Package sb_admissionsapplication

BANINST1@S10B80

This package provides the Common business interface for the Admissions Application API (sb_admissionsapplication).

A person can have many applications for admissions to an institution.
Internal identification number, term code, and application number are the keys for each application.

Starting with Banner 7.0, all curriculum and field of study data are maintained on the tables SORLCUR and SORLFOS (sb_curriculum API and sb_fieldofstudy API).
When an application record is created, a primary curriculum and primary major field of study must also be created. At the conclusion of the curriculum and field of study insert, the primary and secondary curriculum data is backfilled to the curriculum on the application record.

Program units

f_api_version	Returns the API version number.
f_exists	Checks to see if a record exists.
f_isequal	Compares two records for equality.
f_query_all	Selects all records for the entity.
f_query_one	Selects one record using the key.
f_query_by_rowid	Selects one record using the ROWID.
f_query_one_lock	Selects one record and locks it.
f_query_by_preference	Selects a set of records for a person/term and, optionally, application with the results ordered by application preference.
f_GetSaradapSeqno	Returns the application sequence number for the most current or the next (new) application for a person.
p_create	Creates a record.
p_delete	Deletes a record.
p_lock	Locks a record.
p_update	Updates a record.

Types

admissionsapplication_rec	Entity record type
admissionsapplication_ref	Entity cursor variable type
admissionsapplication_tab	Entity table type

Constants

M_ENTITY_NAME

Business Entity name

M_ENTITY_NAME

M_ENTITY_NAME    CONSTANT VARCHAR2(21) := 'ADMISSIONSAPPLICATION';

Business Entity name

admissionsapplication_rec

TYPE admissionsapplication_rec IS RECORD (
   r_pidm                    saradap.saradap_pidm%TYPE,
   r_term_code_entry         saradap.saradap_term_code_entry%TYPE,
   r_appl_no                 saradap.saradap_appl_no%TYPE,
   r_levl_code               saradap.saradap_levl_code%TYPE,
   r_appl_date               saradap.saradap_appl_date%TYPE,
   r_apst_code               saradap.saradap_apst_code%TYPE,
   r_apst_date               saradap.saradap_apst_date%TYPE,
   r_maint_ind               saradap.saradap_maint_ind%TYPE,
   r_admt_code               saradap.saradap_admt_code%TYPE,
   r_styp_code               saradap.saradap_styp_code%TYPE,
   r_camp_code               saradap.saradap_camp_code%TYPE,
   r_site_code               saradap.saradap_site_code%TYPE,
   r_coll_code_1             saradap.saradap_coll_code_1%TYPE,
   r_degc_code_1             saradap.saradap_degc_code_1%TYPE,
   r_majr_code_1             saradap.saradap_majr_code_1%TYPE,
   r_coll_code_2             saradap.saradap_coll_code_2%TYPE,
   r_degc_code_2             saradap.saradap_degc_code_2%TYPE,
   r_majr_code_2             saradap.saradap_majr_code_2%TYPE,
   r_resd_code               saradap.saradap_resd_code%TYPE,
   r_full_part_ind           saradap.saradap_full_part_ind%TYPE,
   r_sess_code               saradap.saradap_sess_code%TYPE,
   r_wrsn_code               saradap.saradap_wrsn_code%TYPE,
   r_intv_code               saradap.saradap_intv_code%TYPE,
   r_fee_ind                 saradap.saradap_fee_ind%TYPE,
   r_fee_date                saradap.saradap_fee_date%TYPE,
   r_rate_code               saradap.saradap_rate_code%TYPE,
   r_egol_code               saradap.saradap_egol_code%TYPE,
   r_edlv_code               saradap.saradap_edlv_code%TYPE,
   r_majr_code_conc_1        saradap.saradap_majr_code_conc_1%TYPE,
   r_dept_code               saradap.saradap_dept_code%TYPE,
   r_sbgi_code               saradap.saradap_sbgi_code%TYPE,
   r_recr_code               saradap.saradap_recr_code%TYPE,
   r_rtyp_code               saradap.saradap_rtyp_code%TYPE,
   r_dept_code_2             saradap.saradap_dept_code_2%TYPE,
   r_majr_code_conc_2        saradap.saradap_majr_code_conc_2%TYPE,
   r_program_1               saradap.saradap_program_1%TYPE,
   r_term_code_ctlg_1        saradap.saradap_term_code_ctlg_1%TYPE,
   r_majr_code_1_2           saradap.saradap_majr_code_1_2%TYPE,
   r_dept_code_1_2           saradap.saradap_dept_code_1_2%TYPE,
   r_majr_code_conc_1_2      saradap.saradap_majr_code_conc_1_2%TYPE,
   r_majr_code_conc_1_3      saradap.saradap_majr_code_conc_1_3%TYPE,
   r_majr_code_conc_121      saradap.saradap_majr_code_conc_121%TYPE,
   r_majr_code_conc_122      saradap.saradap_majr_code_conc_122%TYPE,
   r_majr_code_conc_123      saradap.saradap_majr_code_conc_123%TYPE,
   r_majr_code_minr_1_1      saradap.saradap_majr_code_minr_1_1%TYPE,
   r_majr_code_minr_1_2      saradap.saradap_majr_code_minr_1_2%TYPE,
   r_program_2               saradap.saradap_program_2%TYPE,
   r_term_code_ctlg_2        saradap.saradap_term_code_ctlg_2%TYPE,
   r_levl_code_2             saradap.saradap_levl_code_2%TYPE,
   r_camp_code_2             saradap.saradap_camp_code_2%TYPE,
   r_majr_code_2_2           saradap.saradap_majr_code_2_2%TYPE,
   r_dept_code_2_2           saradap.saradap_dept_code_2_2%TYPE,
   r_majr_code_conc_211      saradap.saradap_majr_code_conc_211%TYPE,
   r_majr_code_conc_212      saradap.saradap_majr_code_conc_212%TYPE,
   r_majr_code_conc_213      saradap.saradap_majr_code_conc_213%TYPE,
   r_majr_code_conc_221      saradap.saradap_majr_code_conc_221%TYPE,
   r_majr_code_conc_222      saradap.saradap_majr_code_conc_222%TYPE,
   r_majr_code_conc_223      saradap.saradap_majr_code_conc_223%TYPE,
   r_majr_code_minr_2_1      saradap.saradap_majr_code_minr_2_1%TYPE,
   r_majr_code_minr_2_2      saradap.saradap_majr_code_minr_2_2%TYPE,
   r_curr_rule_1             saradap.saradap_curr_rule_1%TYPE,
   r_cmjr_rule_1_1           saradap.saradap_cmjr_rule_1_1%TYPE,
   r_ccon_rule_11_1          saradap.saradap_ccon_rule_11_1%TYPE,
   r_ccon_rule_11_2          saradap.saradap_ccon_rule_11_2%TYPE,
   r_ccon_rule_11_3          saradap.saradap_ccon_rule_11_3%TYPE,
   r_cmjr_rule_1_2           saradap.saradap_cmjr_rule_1_2%TYPE,
   r_ccon_rule_12_1          saradap.saradap_ccon_rule_12_1%TYPE,
   r_ccon_rule_12_2          saradap.saradap_ccon_rule_12_2%TYPE,
   r_ccon_rule_12_3          saradap.saradap_ccon_rule_12_3%TYPE,
   r_cmnr_rule_1_1           saradap.saradap_cmnr_rule_1_1%TYPE,
   r_cmnr_rule_1_2           saradap.saradap_cmnr_rule_1_2%TYPE,
   r_curr_rule_2             saradap.saradap_curr_rule_2%TYPE,
   r_cmjr_rule_2_1           saradap.saradap_cmjr_rule_2_1%TYPE,
   r_ccon_rule_21_1          saradap.saradap_ccon_rule_21_1%TYPE,
   r_ccon_rule_21_2          saradap.saradap_ccon_rule_21_2%TYPE,
   r_ccon_rule_21_3          saradap.saradap_ccon_rule_21_3%TYPE,
   r_cmjr_rule_2_2           saradap.saradap_cmjr_rule_2_2%TYPE,
   r_ccon_rule_22_1          saradap.saradap_ccon_rule_22_1%TYPE,
   r_ccon_rule_22_2          saradap.saradap_ccon_rule_22_2%TYPE,
   r_ccon_rule_22_3          saradap.saradap_ccon_rule_22_3%TYPE,
   r_cmnr_rule_2_1           saradap.saradap_cmnr_rule_2_1%TYPE,
   r_cmnr_rule_2_2           saradap.saradap_cmnr_rule_2_2%TYPE,
   r_web_acct_misc_ind       saradap.saradap_web_acct_misc_ind%TYPE,
   r_web_cashier_user        saradap.saradap_web_cashier_user%TYPE,
   r_web_trans_no            saradap.saradap_web_trans_no%TYPE,
   r_web_amount              saradap.saradap_web_amount%TYPE,
   r_web_receipt_number      saradap.saradap_web_receipt_number%TYPE,
   r_waiv_code               saradap.saradap_waiv_code%TYPE,
   r_data_origin             saradap.saradap_data_origin%TYPE,
   r_user_id                 saradap.saradap_user_id%TYPE,
   r_internal_record_id      gb_common.internal_record_id_type,
                                            
   r_appl_preference         saradap.saradap_appl_preference%TYPE);

Entity record type

admissionsapplication_ref

TYPE admissionsapplication_ref IS REF CURSOR RETURN admissionsapplication_rec;

Entity cursor variable type

admissionsapplication_tab

TYPE admissionsapplication_tab IS TABLE OF admissionsapplication_rec INDEX BY BINARY_INTEGER;

Entity table type

f_api_version

Function f_api_version RETURN PLS_INTEGER

Returns the API version number.

Returns

Version of the API signature. Changes only when the signature changes.

f_exists

Function f_exists(p_pidm            saradap.saradap_pidm%TYPE,
                  p_term_code_entry saradap.saradap_term_code_entry%TYPE,
                  p_appl_no         saradap.saradap_appl_no%TYPE,
                  p_rowid           VARCHAR2 DEFAULT NULL) RETURN VARCHAR2

Checks to see if a record exists.

Parameters

	p_pidm	Applicant internal identification number. NUMBER(8) Required Key
	p_term_code_entry	Term associated with the information on the applicant record. VARCHAR2(6) Required Key
	p_appl_no	Application number of the admissions record for a specific term. NUMBER(2) Required Key
	p_rowid	Database ROWID of the record to be selected. VARCHAR2(18)

Returns

Y if found, otherwise N.

f_isequal

Function f_isequal(rec_one admissionsapplication_rec,
                   rec_two admissionsapplication_rec) RETURN VARCHAR2

Compares two records for equality. Nulls match nulls.
Tests each field of rec_one against the corresponding field of rec_two.
Two null values are considered equal.

Parameters

	rec_one	First record to compare. Type admissionsapplication_rec Required
	rec_two	Second record to compare. Type admissionsapplication_rec Required

Returns

Y if all values in the records are equal, otherwise N. Nulls match Nulls.

f_query_all

Function f_query_all(p_pidm            saradap.saradap_pidm%TYPE,
                     p_term_code_entry saradap.saradap_term_code_entry%TYPE DEFAULT NULL,
                     p_appl_no         saradap.saradap_appl_no%TYPE DEFAULT NULL)
  RETURN admissionsapplication_ref

Selects all records for the entity.
Note that parameters other than PIDM default to NULL and are ignored if not populated AND are used when multiple criteria are given.

Parameters

	p_pidm	Applicant internal identification number. NUMBER(8) Required Key
	p_term_code_entry	Term associated with the information on the applicant record. VARCHAR2(6) Default NULL
	p_appl_no	Application number of the admissions record for a specific term. NUMBER(2) Default NULL

Returns

A cursor variable that will fetch the set of records.

f_query_one

Function f_query_one(p_pidm            saradap.saradap_pidm%TYPE,
                     p_term_code_entry saradap.saradap_term_code_entry%TYPE,
                     p_appl_no         saradap.saradap_appl_no%TYPE)
  RETURN admissionsapplication_ref

Selects one record using the key.

Parameters

	p_pidm	Applicant internal identification number. NUMBER(8) Required Key
	p_term_code_entry	Term associated with the information on the applicant record. VARCHAR2(6) Required Key
	p_appl_no	Application number of the admissions record for a specific term. NUMBER(2) Required Key

Returns

A cursor variable that will fetch exactly one record.

f_query_by_rowid

Function f_query_by_rowid(p_rowid VARCHAR2)
  RETURN admissionsapplication_ref

Selects one record using the ROWID.

Parameters

p_rowid

Database ROWID of the record to be selected. VARCHAR2(18) Required

Returns

A cursor variable that will fetch exactly one record.

f_query_one_lock

Function f_query_one_lock(p_pidm            saradap.saradap_pidm%TYPE,
                          p_term_code_entry saradap.saradap_term_code_entry%TYPE,
                          p_appl_no         saradap.saradap_appl_no%TYPE,
                          p_rowid           VARCHAR2 DEFAULT NULL)
  RETURN admissionsapplication_ref

Selects one record and locks it.

Parameters

	p_pidm	Applicant internal identification number. NUMBER(8) Required Key
	p_term_code_entry	Term associated with the information on the applicant record. VARCHAR2(6) Required Key
	p_appl_no	Application number of the admissions record for a specific term. NUMBER(2) Required Key
	p_rowid	Database ROWID of the record to be selected. VARCHAR2(18)

Returns

A cursor variable for one record, locking the record.

f_query_by_preference

Function f_query_by_preference(p_pidm            sarappd.sarappd_pidm%TYPE,
                               p_term_code_entry sarappd.sarappd_term_code_entry%TYPE,
                               p_appl_no         sarappd.sarappd_appl_no%TYPE DEFAULT NULL)
  RETURN admissionsapplication_ref

Selects a set of records for a person/term and, optionally, application with the results ordered by application preference.

Parameters

	p_pidm	Applicant internal identification number. NUMBER(8) Required Key
	p_term_code_entry	Term associated with the information on the applicant record. VARCHAR2(6) Required Key
	p_appl_no	Application number of the admissions record for a specific term. NUMBER(2)

Returns

A cursor variable that will fetch the set of records.

f_GetSaradapSeqno

Function f_GetSaradapSeqno(p_pidm IN NUMBER, p_curr_or_next IN VARCHAR2)
  RETURN NUMBER

Returns the application sequence number for the most current or the next (new) application for a person.

Parameters

	p_pidm	Applicant internal identification number. NUMBER(8) Required Key
	p_curr_or_next	Passes C to retrieve the number for the most recent application or N for the Next or new application number. VARCHAR2(1) Required

Returns

An application number.

p_create

Procedure p_create(p_pidm               saradap.saradap_pidm%TYPE,
                   p_term_code_entry    saradap.saradap_term_code_entry%TYPE,
                   p_appl_no_inout      IN OUT saradap.saradap_appl_no%TYPE,
                   p_appl_date          saradap.saradap_appl_date%TYPE,
                   p_apst_code          saradap.saradap_apst_code%TYPE,
                   p_apst_date          saradap.saradap_apst_date%TYPE,
                   p_maint_ind          saradap.saradap_maint_ind%TYPE,
                   p_admt_code          saradap.saradap_admt_code%TYPE DEFAULT NULL,
                   p_styp_code          saradap.saradap_styp_code%TYPE,
                   p_site_code          saradap.saradap_site_code%TYPE DEFAULT NULL,
                   p_resd_code          saradap.saradap_resd_code%TYPE,
                   p_full_part_ind      saradap.saradap_full_part_ind%TYPE DEFAULT NULL,
                   p_sess_code          saradap.saradap_sess_code%TYPE DEFAULT NULL,
                   p_wrsn_code          saradap.saradap_wrsn_code%TYPE DEFAULT NULL,
                   p_intv_code          saradap.saradap_intv_code%TYPE DEFAULT NULL,
                   p_fee_ind            saradap.saradap_fee_ind%TYPE DEFAULT NULL,
                   p_fee_date           saradap.saradap_fee_date%TYPE DEFAULT NULL,
                   p_rate_code          saradap.saradap_rate_code%TYPE DEFAULT NULL,
                   p_egol_code          saradap.saradap_egol_code%TYPE DEFAULT NULL,
                   p_edlv_code          saradap.saradap_edlv_code%TYPE DEFAULT NULL,
                   p_sbgi_code          saradap.saradap_sbgi_code%TYPE DEFAULT NULL,
                   p_recr_code          saradap.saradap_recr_code%TYPE DEFAULT NULL,
                   p_rtyp_code          saradap.saradap_rtyp_code%TYPE DEFAULT NULL,
                   p_web_acct_misc_ind  saradap.saradap_web_acct_misc_ind%TYPE DEFAULT NULL,
                   p_web_cashier_user   saradap.saradap_web_cashier_user%TYPE DEFAULT NULL,
                   p_web_trans_no       saradap.saradap_web_trans_no%TYPE DEFAULT NULL,
                   p_web_amount         saradap.saradap_web_amount%TYPE DEFAULT NULL,
                   p_web_receipt_number saradap.saradap_web_receipt_number%TYPE DEFAULT NULL,
                   p_waiv_code          saradap.saradap_waiv_code%TYPE DEFAULT NULL,
                   p_data_origin        saradap.saradap_data_origin%TYPE DEFAULT NULL,
                   p_user_id            saradap.saradap_user_id%TYPE DEFAULT gb_common.f_sct_user,
                   p_rowid_out          OUT VARCHAR2,
                   /* CC 7.3: Add application preference */
                   p_appl_preference saradap.saradap_appl_preference%TYPE DEFAULT NULL)

Creates a record.

Parameters

	p_pidm	Applicant internal identification number. NUMBER(8) Required Key
	p_term_code_entry	Term associated with the information on the applicant record. VARCHAR2(6) Required Key
	p_appl_no_inout	Application number of the admissions record for a specific term. NUMBER(2) Required Key
	p_appl_date	Date of the application record. DATE Required
	p_apst_code	Status of the application. VARCHAR2(1) Required
	p_apst_date	Date associated with the most current status of the application. DATE Required
	p_maint_ind	Indicates whether the status of the application is being maintained by the system or the user. VARCHAR2(1) Required
	p_admt_code	Admission type of the applicant. VARCHAR2(2)
	p_styp_code	Type of student the applicant will become if admitted. VARCHAR2(1) Required
	p_site_code	Site to which the applicant is applying. VARCHAR2(3)
	p_resd_code	Residency classification of the applicant. VARCHAR2(1) Required
	p_full_part_ind	Indicates whether the applicant's intention is for full- or part-time enrollment. VARCHAR2(1)
	p_sess_code	Session for which the applicant is applying. VARCHAR2(1)
	p_wrsn_code	Reason why an application has been withdrawn. VARCHAR2(2)
	p_intv_code	Status of the interview associated with the applicant. VARCHAR2(1)
	p_fee_ind	Indicates whether an application fee has been assessed. VARCHAR2(1)
	p_fee_date	Date application fee was assessed. DATE
	p_rate_code	Specific assessment rate assigned to the student. VARCHAR2(5)
	p_egol_code	Educational Goal Code. VARCHAR2(2)
	p_edlv_code	Education Level Code. VARCHAR2(3)
	p_sbgi_code	Institution Attending code of the institution the student decided to attend instead of the home institution. VARCHAR2(6)
	p_recr_code	Recruiter Code. VARCHAR2(3)
	p_rtyp_code	Recruit Type code. VARCHAR2(2)
	p_web_acct_misc_ind	Indicator to identify where the record for the application fee is stored if the fee was paid by credit card via the Web. VARCHAR2(1)
	p_web_cashier_user	Oracle ID of the cashier associated with the application fee if the fee was paid by credit card via the Web. VARCHAR2(30)
	p_web_trans_no	Transaction number associated with the application fee if the fee was paid by credit card via the Web. NUMBER(8)
	p_web_amount	Amount of the transaction for an application fee if the fee was paid by credit card via the Web. NUMBER(12,2)
	p_web_receipt_number	Receipt number associated with the application fee if the fee was paid by credit card via the Web. NUMBER(8)
	p_waiv_code	Application fee waiver reason. VARCHAR2(4)
	p_data_origin	Source system that generated the data. VARCHAR2(30)
	p_user_id	Oracle ID of the most recent user to create or update a record. VARCHAR2(30)
	p_rowid_out	Database ROWID of the record to be created. VARCHAR2(18) Required
	p_appl_preference	Application preference number. NUMBER(2)

p_delete

Procedure p_delete(p_pidm            saradap.saradap_pidm%TYPE,
                   p_term_code_entry saradap.saradap_term_code_entry%TYPE,
                   p_appl_no         saradap.saradap_appl_no%TYPE,
                   p_rowid           VARCHAR2 DEFAULT NULL)

Deletes a record.
Either the ROWID or all primary key fields are required.

Before deleting the admissions application, the process deletes any child rows and other table rows dependent upon the application.
It will delete rows from decision (SARAPPD), checklist (SARCHKL), cohort (SARCHRT), application question (SARQUAN), attribute (SARAATT), comment (SARACMT), source (SARRSRC), supplemental data (SABSUPL), GPA types (SORGPAT), course summaries (SORCRSS), selective admissions student application rating (SARRRAT), decision collector table used by SAADCBT(SARDSCL), and mail (GURMAIL) tables.
It will also delete curriculum (SORLCUR) and field of study (SORLFOS) rows associated with the application row.

The process acquires a lock first, registers the values for messaging if needed, then calls the DML layer to perform the task.

Parameters

	p_pidm	Applicant internal identification number. NUMBER(8) Required Key
	p_term_code_entry	Term associated with the information on the applicant record. VARCHAR2(6) Required Key
	p_appl_no	Application number of the admissions record for a specific term. NUMBER(2) Required Key
	p_rowid	Database ROWID of the record to be deleted. VARCHAR2(18)

p_lock

Procedure p_lock(p_pidm            saradap.saradap_pidm%TYPE,
                 p_term_code_entry saradap.saradap_term_code_entry%TYPE,
                 p_appl_no         saradap.saradap_appl_no%TYPE,
                 p_rowid_inout     IN OUT VARCHAR2)

Locks a record.
If the ROWID is not passed in, the record is located using the key values and the ROWID of the locked row is passed in p_rowid_inout.

Parameters

	p_pidm	Applicant internal identification number. NUMBER(8) Required Key
	p_term_code_entry	Term associated with the information on the applicant record. VARCHAR2(6) Required Key
	p_appl_no	Application number of the admissions record for a specific term. NUMBER(2) Required Key
	p_rowid_inout	Database ROWID of the record to be locked. VARCHAR2(18) Required

p_update

Procedure p_update(p_pidm               saradap.saradap_pidm%TYPE,
                   p_term_code_entry    saradap.saradap_term_code_entry%TYPE,
                   p_appl_no            saradap.saradap_appl_no%TYPE,
                   p_appl_date          saradap.saradap_appl_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_apst_code          saradap.saradap_apst_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_apst_date          saradap.saradap_apst_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_maint_ind          saradap.saradap_maint_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_admt_code          saradap.saradap_admt_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_styp_code          saradap.saradap_styp_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_site_code          saradap.saradap_site_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_resd_code          saradap.saradap_resd_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_full_part_ind      saradap.saradap_full_part_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_sess_code          saradap.saradap_sess_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_wrsn_code          saradap.saradap_wrsn_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_intv_code          saradap.saradap_intv_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_fee_ind            saradap.saradap_fee_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_fee_date           saradap.saradap_fee_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_rate_code          saradap.saradap_rate_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_egol_code          saradap.saradap_egol_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_edlv_code          saradap.saradap_edlv_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_sbgi_code          saradap.saradap_sbgi_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_recr_code          saradap.saradap_recr_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_rtyp_code          saradap.saradap_rtyp_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_web_acct_misc_ind  saradap.saradap_web_acct_misc_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_web_cashier_user   saradap.saradap_web_cashier_user%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_web_trans_no       saradap.saradap_web_trans_no%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_web_amount         saradap.saradap_web_amount%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_web_receipt_number saradap.saradap_web_receipt_number%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_waiv_code          saradap.saradap_waiv_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_data_origin        saradap.saradap_data_origin%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_user_id            saradap.saradap_user_id%TYPE DEFAULT gb_common.f_sct_user,
                   p_rowid              VARCHAR2 DEFAULT NULL,
                   /* CC 7.3 Add application preference. */
                   p_appl_preference saradap.saradap_appl_preference%TYPE DEFAULT dml_common.f_unspecified_number)

Updates a record.
The process acquires a lock on the row, performs validation, and calls the DML procedure to perform the dynamic update.

Parameters

	p_pidm	Applicant internal identification number. NUMBER(8) Required Key
	p_term_code_entry	Term associated with the information on the applicant record. VARCHAR2(6) Required Key
	p_appl_no	Application number of the admissions record for a specific term. NUMBER(2) Required Key
	p_appl_date	Date of the application record. DATE Required
	p_apst_code	Status of the application. VARCHAR2(1) Required
	p_apst_date	Date associated with the most current status of the application. DATE Required
	p_maint_ind	Indicates whether the status of the application is being maintained by the system or the user. VARCHAR2(1) Required
	p_admt_code	Admission type of the applicant. VARCHAR2(2)
	p_styp_code	Type of student the applicant will become if admitted. VARCHAR2(1) Required
	p_resd_code	Residency classification of the applicant. VARCHAR2(1) Required
	p_full_part_ind	Indicates whether the applicant's intention is for full- or part-time enrollment. VARCHAR2(1)
	p_sess_code	Session for which the applicant is applying. VARCHAR2(1)
	p_wrsn_code	Reason why an application has been withdrawn. VARCHAR2(2)
	p_intv_code	Status of the interview associated with the applicant. VARCHAR2(1)
	p_fee_ind	Indicates whether an application fee has been assessed. VARCHAR2(1)
	p_fee_date	Date application fee was assessed. DATE
	p_rate_code	Specific assessment rate assigned to the student. VARCHAR2(5)
	p_egol_code	Educational Goal Code. VARCHAR2(2)
	p_edlv_code	Education Level Code. VARCHAR2(3)
	p_sbgi_code	Institution Attending code of the institution the student decided to attend instead of the home institution. VARCHAR2(6)
	p_recr_code	Recruiter Code. VARCHAR2(3)
	p_rtyp_code	Recruit Type code. VARCHAR2(2)
	p_web_acct_misc_ind	Indicator to identify where the record for the application fee is stored if the fee was paid by credit card via the Web. Values are M for Misc, T for TBRACCD. VARCHAR2(1)
	p_web_cashier_user	Oracle ID of the cashier associated with the application fee if the fee was paid by credit card via the Web. VARCHAR2(30)
	p_web_trans_no	Transaction number associated with the application fee if the fee was paid by credit card via the Web. NUMBER(8)
	p_web_amount	Amount of the transaction for an application if the fee was paid by credit card via the Web. NUMBER(12,2)
	p_web_receipt_number	Receipt number associated with the application fee if the fee was paid by credit card via the Web. NUMBER(8)
	p_waiv_code	Application fee waiver reason. VARCHAR2(4)
	p_data_origin	Source system that generated the data. VARCHAR2(30)
	p_user_id	Oracle ID of the most recent user to create or update a record. VARCHAR2(30)
	p_rowid	Database ROWID of the record to be updated. VARCHAR2(18)
	p_appl_preference	Application preference number. NUMBER(2)