The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT party_number
FROM hz_parties hp
WHERE hp.party_id = p_person_id;
SELECT distinct psapl.*
FROM igs_ad_ps_appl_inst apai,
igs_ad_ps_appl psapl,
igs_ad_ou_stat aos,
igs_ad_appl aa,
igs_ad_appl_stat aps
WHERE (( Aa.acad_cal_type = cp_acad_cal_type AND cp_acad_cal_type IS NOT NULL) OR ( cp_acad_cal_type IS NULL))AND
(( Aa.acad_ci_sequence_number = cp_acad_sequence_number AND cp_acad_sequence_number IS NOT NULL)OR (cp_acad_sequence_number IS NULL) ) AND
(( Aa.adm_cal_type = cp_adm_cal_type AND cp_adm_cal_type IS NOT NULL) OR (cp_adm_cal_type IS NULL) ) AND
(( Aa.adm_ci_sequence_number = cp_adm_sequence_number AND cp_adm_sequence_number IS NOT NULL) OR (cp_adm_sequence_number IS NULL) ) AND
(( Aa.admission_cat = cp_admission_cat AND cp_admission_cat IS NOT NULL) OR (cp_admission_cat IS NULL)) AND
(( Aa.s_admission_process_type = cp_s_adm_process_typ AND cp_s_adm_process_typ IS NOT NULL) OR (cp_s_adm_process_typ IS NULL) ) AND
Apai.adm_outcome_status = aos.adm_outcome_status AND
Aos.s_adm_outcome_status = 'PENDING' AND
NVL(apai.appl_inst_status,'RECEIVED') NOT IN (SELECT adm_appl_status FROM igs_ad_appl_stat WHERE S_ADM_APPL_STATUS = 'WITHDRAWN') AND
Psapl.req_for_reconsideration_ind = 'Y' AND
Apai.person_id = psapl.person_id AND
Apai.admission_appl_number = psapl.admission_appl_number AND
Apai.nominated_course_cd = psapl.nominated_course_cd AND
Aa.person_id=apai.person_id AND
Aa.admission_appl_number = apai.admission_appl_number AND
Aa.adm_appl_status = aps.adm_appl_status AND
(((p_recon_no_future = 'Y') AND (apai.future_acad_cal_type IS NULL AND apai.future_acad_ci_sequence_number IS NULL
AND apai.future_adm_cal_type IS NULL AND apai.future_adm_ci_sequence_number IS NULL))
OR ((p_recon_future = 'Y') AND (apai.future_acad_cal_type IS NOT NULL AND apai.future_acad_ci_sequence_number IS NOT NULL
AND apai.future_adm_cal_type IS NOT NULL AND apai.future_adm_ci_sequence_number IS NOT NULL)));
SELECT apai.rowid, apai.*
FROM Igs_ad_ps_appl_inst apai,
Igs_ad_ps_appl psapl,
Igs_ad_ou_stat aos,
Igs_ad_appl_all Aa
WHERE (( Aa.acad_cal_type = cp_acad_cal_type AND cp_acad_cal_type IS NOT NULL) OR ( cp_acad_cal_type IS NULL))AND
(( Aa.acad_ci_sequence_number = cp_acad_sequence_number AND cp_acad_sequence_number IS NOT NULL)OR (cp_acad_sequence_number IS NULL) ) AND
(( Aa.adm_cal_type = cp_adm_cal_type AND cp_adm_cal_type IS NOT NULL) OR (cp_adm_cal_type IS NULL) ) AND
(( Aa.adm_ci_sequence_number = cp_adm_sequence_number AND cp_adm_sequence_number IS NOT NULL) OR (cp_adm_sequence_number IS NULL) ) AND
(( Aa.admission_cat = cp_admission_cat AND cp_admission_cat IS NOT NULL) OR (cp_admission_cat IS NULL)) AND
(( Aa.s_admission_process_type = cp_s_adm_process_typ AND cp_s_adm_process_typ IS NOT NULL) OR (cp_s_adm_process_typ IS NULL) ) AND
Apai.adm_outcome_status = aos.adm_outcome_status AND
Aos.s_adm_outcome_status = 'PENDING' AND
NVL(apai.appl_inst_status,'RECEIVED') NOT IN (SELECT adm_appl_status FROM igs_ad_appl_stat WHERE S_ADM_APPL_STATUS = 'WITHDRAWN') AND
Psapl.req_for_reconsideration_ind <> 'Y' AND
Apai.person_id = psapl.person_id AND
Apai.admission_appl_number = psapl.admission_appl_number AND
Apai.nominated_course_cd = psapl.nominated_course_cd AND
apai.person_id = aa.person_id AND
apai.admission_appl_number = aa.admission_appl_number AND
Apai.future_acad_cal_type IS NOT NULL AND
Apai.future_acad_ci_sequence_number IS NOT NULL AND
Apai.future_adm_cal_type IS NOT NULL AND
Apai.future_adm_ci_sequence_number IS NOT NULL;
SELECT alternate_code
FROM igs_ca_inst_all
WHERE cal_type = cp_cal_type
AND sequence_number = cp_sequence_number;
SELECT meaning
FROM igs_lookup_values
WHERE lookup_type = 'ADMISSION_PROCESS_TYPE'
AND lookup_code = cp_s_admission_process_type;
SELECT application_id
FROM igs_ad_appl_all
WHERE person_id = cp_person_id
AND admission_appl_number = cp_admission_appl_number;
SELECT apai.rowid,apai.*
FROM igs_ad_ps_appl_inst_all apai
WHERE apai.person_id = cp_person_id
AND apai.admission_appl_number = cp_admission_appl_number
AND apai.nominated_course_cd = cp_nominated_course_cd
AND NVL(apai.appl_inst_status,'RECEIVED') NOT IN (SELECT adm_appl_status FROM igs_ad_appl_stat WHERE S_ADM_APPL_STATUS = 'WITHDRAWN');
SELECT hist.*
FROM igs_ad_ps_aplinsthst_all hist
WHERE person_id = cp_person_id
AND admission_appl_number = cp_admission_appl_number
AND nominated_course_cd = cp_nominated_course_cd
AND sequence_number = cp_sequence_number;
SELECT MAX(hist_start_dt) latest_record
FROM igs_ad_ps_aplinsthst_all
WHERE person_id = cp_person_id
AND admission_appl_number = cp_admission_appl_number
AND nominated_course_cd = cp_nominated_course_cd
AND sequence_number = cp_sequence_number
AND NVL(reconsider_flag,'N') = 'N';
SELECT hist.*
FROM igs_ad_ps_aplinsthst_all hist
WHERE person_id = cp_person_id
AND admission_appl_number = cp_admission_appl_number
AND nominated_course_cd = cp_nominated_course_cd
AND sequence_number = cp_sequence_number
AND hist_start_dt > cp_hist_start_dt
AND NVL(adm_outcome_status,'PENDING') <> 'PENDING';
SELECT admission_cat, s_admission_process_type
FROM igs_ad_ss_appl_typ
WHERE admission_application_type = cp_admission_type;
SELECT 'Y'
FROM IGS_AD_PRCS_CAT_STEP
WHERE admission_cat = cp_admission_cat
AND s_admission_process_type = cp_s_admission_process_type
AND s_admission_step_type = 'PRE-ENROL'
AND step_group_type <> 'TRACK';
SELECT admission_cat,s_admission_process_type
FROM igs_ad_appl_all
WHERE person_id = cp_person_id
AND admission_appl_number = cp_admission_appl_number;
l_sql_stmt1 VARCHAR2(32676) := 'SELECT distinct psapl.row_id,psapl.person_id, psapl.admission_appl_number,psapl.nominated_course_cd,
psapl.transfer_course_cd,psapl.basis_for_admission_type,psapl.admission_cd,
psapl.course_rank_set,psapl.course_rank_schedule, psapl.req_for_adv_standing_ind
FROM
Igs_ad_ps_appl_inst apai,
igs_ad_ps_appl psapl,
Igs_ad_ou_stat aos,
Igs_ad_appl aa,
Igs_ad_appl_stat aps
WHERE
Apai.person_id IN ';
NVL(apai.appl_inst_status,''RECEIVED'') NOT IN (SELECT adm_appl_status FROM igs_ad_appl_stat WHERE S_ADM_APPL_STATUS = ''WITHDRAWN'') AND
Psapl.req_for_reconsideration_ind = ''Y'' AND
Apai.person_id = psapl.person_id AND
Apai.admission_appl_number = psapl.admission_appl_number AND
Apai.nominated_course_cd = psapl.nominated_course_cd AND
Aa.person_id=apai.person_id AND
Aa.admission_appl_number = apai.admission_appl_number AND
Aa.adm_appl_status = aps.adm_appl_status AND
(((:7 = ''Y'') AND
(apai.future_acad_cal_type IS NULL AND apai.future_acad_ci_sequence_number IS NULL AND
apai.future_adm_cal_type IS NULL AND apai.future_adm_ci_sequence_number IS NULL))
OR ((:8 = ''Y'') AND
(apai.future_acad_cal_type IS NOT NULL AND apai.future_acad_ci_sequence_number IS NOT NULL AND
apai.future_adm_cal_type IS NOT NULL AND apai.future_adm_ci_sequence_number IS NOT NULL)))';
'SELECT
apai.row_id,
apai.person_id,
apai.admission_appl_number,
apai.nominated_course_cd,
apai.sequence_number,
apai.predicted_gpa,
apai.academic_index,
apai.adm_cal_type,
apai.app_file_location,
apai.adm_ci_sequence_number,
apai.course_cd,
apai.app_source_id,
apai.crv_version_number,
apai.waitlist_rank,
apai.location_cd,
apai.attent_other_inst_cd,
apai.attendance_mode,
apai.edu_goal_prior_enroll_id,
apai.attendance_type,
apai.decision_make_id,
apai.unit_set_cd,
apai.decision_date,
apai.attribute_category,
apai.attribute1,
apai.attribute2,
apai.attribute3,
apai.attribute4,
apai.attribute5,
apai.attribute6,
apai.attribute7,
apai.attribute8,
apai.attribute9,
apai.attribute10,
apai.attribute11,
apai.attribute12,
apai.attribute13,
apai.attribute14,
apai.attribute15,
apai.attribute16,
apai.attribute17,
apai.attribute18,
apai.attribute19,
apai.attribute20,
apai.decision_reason_id,
apai.us_version_number,
apai.decision_notes,
apai.pending_reason_id,
apai.preference_number,
apai.adm_doc_status,
apai.adm_entry_qual_status,
apai.deficiency_in_prep,
apai.late_adm_fee_status,
apai.spl_consider_comments,
apai.apply_for_finaid,
apai.finaid_apply_date,
apai.adm_outcome_status,
apai.adm_otcm_status_auth_person_id,
apai.adm_outcome_status_auth_dt,
apai.adm_outcome_status_reason,
apai.offer_dt,
apai.offer_response_dt,
apai.prpsd_commencement_dt,
apai.adm_cndtnl_offer_status,
apai.cndtnl_offer_satisfied_dt,
apai.cndtnl_offer_must_be_stsfd_ind,
apai.adm_offer_resp_status,
apai.actual_response_dt,
apai.adm_offer_dfrmnt_status,
apai.deferred_adm_cal_type,
apai.deferred_adm_ci_sequence_num,
apai.deferred_tracking_id,
apai.ass_rank,
apai.secondary_ass_rank,
apai.intrntnl_acceptance_advice_num,
apai.ass_tracking_id,
apai.fee_cat,
apai.hecs_payment_option,
apai.expected_completion_yr,
apai.expected_completion_perd,
apai.correspondence_cat,
apai.enrolment_cat,
apai.funding_source,
apai.applicant_acptnce_cndtn,
apai.cndtnl_offer_cndtn,
apai.ss_application_id,
apai.ss_pwd,
apai.authorized_dt,
apai.authorizing_pers_id,
apai.entry_status,
apai.entry_level,
apai.sch_apl_to_id,
apai.idx_calc_date,
apai.waitlist_status,
apai.attribute21,
apai.attribute22,
apai.attribute23,
apai.attribute24,
apai.attribute25,
apai.attribute26,
apai.attribute27,
apai.attribute28,
apai.attribute29,
apai.attribute30,
apai.attribute31,
apai.attribute32,
apai.attribute33,
apai.attribute34,
apai.attribute35,
apai.attribute36,
apai.attribute37,
apai.attribute38,
apai.attribute39,
apai.attribute40,
apai.future_acad_cal_type,
apai.future_acad_ci_sequence_number,
apai.future_adm_cal_type,
apai.future_adm_ci_sequence_number,
apai.previous_term_adm_appl_number,
apai.previous_term_sequence_number,
apai.future_term_adm_appl_number,
apai.future_term_sequence_number,
apai.def_acad_cal_type,
apai.def_acad_ci_sequence_num,
apai.def_prev_term_adm_appl_num,
apai.def_prev_appl_sequence_num,
apai.def_term_adm_appl_num,
apai.def_appl_sequence_num,
apai.appl_inst_status,
apai.ais_reason,
apai.decline_ofr_reason
FROM Igs_ad_ps_appl_inst apai,
Igs_ad_ps_appl psapl,
Igs_ad_ou_stat aos,
Igs_ad_appl_all Aa
WHERE Apai.person_id IN ';
igs_ad_ps_appl_pkg.update_row (
x_rowid => l_get_ad_ps_appl_rec.row_id,
x_person_id => l_get_ad_ps_appl_rec.person_id,
x_admission_appl_number => l_get_ad_ps_appl_rec.admission_appl_number,
x_nominated_course_cd => l_get_ad_ps_appl_rec.nominated_course_cd,
x_transfer_course_cd => l_get_ad_ps_appl_rec.transfer_course_cd,
x_basis_for_admission_type => l_get_ad_ps_appl_rec.basis_for_admission_type,
x_admission_cd => l_get_ad_ps_appl_rec.admission_cd,
x_course_rank_set => l_get_ad_ps_appl_rec.course_rank_set,
x_course_rank_schedule => l_get_ad_ps_appl_rec.course_rank_schedule,
x_req_for_reconsideration_ind => 'N',
x_req_for_adv_standing_ind => l_get_ad_ps_appl_rec.req_for_adv_standing_ind ,
x_mode => 'R' ) ;
igs_ad_ps_appl_inst_pkg.update_row (
X_ROWID => l_get_inst_dtls_rec.ROWID,
x_PERSON_ID => l_get_inst_dtls_rec.PERSON_ID,
x_ADMISSION_APPL_NUMBER => l_get_inst_dtls_rec.ADMISSION_APPL_NUMBER,
x_NOMINATED_COURSE_CD => l_get_inst_dtls_rec.NOMINATED_COURSE_CD,
x_SEQUENCE_NUMBER => l_get_inst_dtls_rec.SEQUENCE_NUMBER,
x_PREDICTED_GPA => l_get_inst_dtls_rec.PREDICTED_GPA,
x_ACADEMIC_INDEX => l_get_inst_dtls_rec.ACADEMIC_INDEX,
x_ADM_CAL_TYPE => l_get_inst_dtls_rec.ADM_CAL_TYPE,
x_APP_FILE_LOCATION => l_get_inst_dtls_rec.APP_FILE_LOCATION,
x_ADM_CI_SEQUENCE_NUMBER => l_get_inst_dtls_rec.ADM_CI_SEQUENCE_NUMBER,
x_COURSE_CD => l_get_inst_dtls_rec.COURSE_CD,
x_APP_SOURCE_ID => l_get_inst_dtls_rec.APP_SOURCE_ID,
x_CRV_VERSION_NUMBER => l_get_inst_dtls_rec.CRV_VERSION_NUMBER,
x_WAITLIST_RANK => l_get_pending_hist_rec.WAITLIST_RANK,
x_LOCATION_CD => l_get_inst_dtls_rec.LOCATION_CD,
x_ATTENT_OTHER_INST_CD => l_get_inst_dtls_rec.ATTENT_OTHER_INST_CD,
x_ATTENDANCE_MODE => l_get_inst_dtls_rec.ATTENDANCE_MODE,
x_EDU_GOAL_PRIOR_ENROLL_ID => l_get_inst_dtls_rec.EDU_GOAL_PRIOR_ENROLL_ID,
x_ATTENDANCE_TYPE => l_get_inst_dtls_rec.ATTENDANCE_TYPE,
x_DECISION_MAKE_ID => l_get_pending_hist_rec.DECISION_MAKE_ID,
x_UNIT_SET_CD => l_get_inst_dtls_rec.UNIT_SET_CD,
x_DECISION_DATE => l_get_pending_hist_rec.DECISION_DATE,
x_ATTRIBUTE_CATEGORY => l_get_inst_dtls_rec.ATTRIBUTE_CATEGORY,
x_ATTRIBUTE1 => l_get_inst_dtls_rec.ATTRIBUTE1,
x_ATTRIBUTE2 => l_get_inst_dtls_rec.ATTRIBUTE2,
x_ATTRIBUTE3 => l_get_inst_dtls_rec.ATTRIBUTE3,
x_ATTRIBUTE4 => l_get_inst_dtls_rec.ATTRIBUTE4,
x_ATTRIBUTE5 => l_get_inst_dtls_rec.ATTRIBUTE5,
x_ATTRIBUTE6 => l_get_inst_dtls_rec.ATTRIBUTE6,
x_ATTRIBUTE7 => l_get_inst_dtls_rec.ATTRIBUTE7,
x_ATTRIBUTE8 => l_get_inst_dtls_rec.ATTRIBUTE8,
x_ATTRIBUTE9 => l_get_inst_dtls_rec.ATTRIBUTE9,
x_ATTRIBUTE10 => l_get_inst_dtls_rec.ATTRIBUTE10,
x_ATTRIBUTE11 => l_get_inst_dtls_rec.ATTRIBUTE11,
x_ATTRIBUTE12 => l_get_inst_dtls_rec.ATTRIBUTE12,
x_ATTRIBUTE13 => l_get_inst_dtls_rec.ATTRIBUTE13,
x_ATTRIBUTE14 => l_get_inst_dtls_rec.ATTRIBUTE14,
x_ATTRIBUTE15 => l_get_inst_dtls_rec.ATTRIBUTE15,
x_ATTRIBUTE16 => l_get_inst_dtls_rec.ATTRIBUTE16,
x_ATTRIBUTE17 => l_get_inst_dtls_rec.ATTRIBUTE17,
x_ATTRIBUTE18 => l_get_inst_dtls_rec.ATTRIBUTE18,
x_ATTRIBUTE19 => l_get_inst_dtls_rec.ATTRIBUTE19,
x_ATTRIBUTE20 => l_get_inst_dtls_rec.ATTRIBUTE20,
x_DECISION_REASON_ID => l_get_pending_hist_rec.DECISION_REASON_ID,
x_US_VERSION_NUMBER => l_get_inst_dtls_rec.US_VERSION_NUMBER,
x_DECISION_NOTES => l_get_inst_dtls_rec.DECISION_NOTES,
x_PENDING_REASON_ID => l_get_pending_hist_rec.PENDING_REASON_ID,
x_PREFERENCE_NUMBER => l_get_inst_dtls_rec.PREFERENCE_NUMBER,
x_ADM_DOC_STATUS => l_get_inst_dtls_rec.ADM_DOC_STATUS,
x_ADM_ENTRY_QUAL_STATUS => l_get_inst_dtls_rec.ADM_ENTRY_QUAL_STATUS,
x_DEFICIENCY_IN_PREP => l_get_inst_dtls_rec.DEFICIENCY_IN_PREP,
x_LATE_ADM_FEE_STATUS => l_get_inst_dtls_rec.LATE_ADM_FEE_STATUS,
x_SPL_CONSIDER_COMMENTS => l_get_inst_dtls_rec.SPL_CONSIDER_COMMENTS,
x_APPLY_FOR_FINAID => l_get_inst_dtls_rec.APPLY_FOR_FINAID,
x_FINAID_APPLY_DATE => l_get_inst_dtls_rec.FINAID_APPLY_DATE,
x_ADM_OUTCOME_STATUS => l_get_pending_hist_rec.ADM_OUTCOME_STATUS,
x_adm_otcm_stat_auth_per_id => l_get_inst_dtls_rec.ADM_OTCM_STATUS_AUTH_PERSON_ID,
x_ADM_OUTCOME_STATUS_AUTH_DT => l_get_inst_dtls_rec.ADM_OUTCOME_STATUS_AUTH_DT,
x_ADM_OUTCOME_STATUS_REASON => l_get_inst_dtls_rec.ADM_OUTCOME_STATUS_REASON,
x_OFFER_DT => l_get_pending_hist_rec.OFFER_DT,
x_OFFER_RESPONSE_DT => l_get_pending_hist_rec.OFFER_RESPONSE_DT,
x_PRPSD_COMMENCEMENT_DT => l_get_pending_hist_rec.PRPSD_COMMENCEMENT_DT,
x_ADM_CNDTNL_OFFER_STATUS => NVL(l_get_pending_hist_rec.ADM_CNDTNL_OFFER_STATUS,IGS_AD_GEN_009.ADMP_GET_SYS_ACOS('NOT-APPLIC')),
x_CNDTNL_OFFER_SATISFIED_DT => l_get_pending_hist_rec.CNDTNL_OFFER_SATISFIED_DT,
x_cndnl_ofr_must_be_stsfd_ind => l_get_pending_hist_rec.CNDTNL_OFFER_MUST_BE_STSFD_IND,
x_ADM_OFFER_RESP_STATUS => NVL(l_get_pending_hist_rec.ADM_OFFER_RESP_STATUS,IGS_AD_GEN_009.ADMP_GET_SYS_AORS('NOT-APPLIC')),
x_ACTUAL_RESPONSE_DT => l_get_pending_hist_rec.ACTUAL_RESPONSE_DT,
x_ADM_OFFER_DFRMNT_STATUS => NVL(l_get_pending_hist_rec.ADM_OFFER_DFRMNT_STATUS,IGS_AD_GEN_009.ADMP_GET_SYS_AODS('NOT-APPLIC')),
x_DEFERRED_ADM_CAL_TYPE => l_get_pending_hist_rec.DEFERRED_ADM_CAL_TYPE,
x_DEFERRED_ADM_CI_SEQUENCE_NUM => l_get_pending_hist_rec.DEFERRED_ADM_CI_SEQUENCE_NUM,
x_DEFERRED_TRACKING_ID => l_get_inst_dtls_rec.DEFERRED_TRACKING_ID,
x_ASS_RANK => l_get_inst_dtls_rec.ASS_RANK,
x_SECONDARY_ASS_RANK => l_get_inst_dtls_rec.SECONDARY_ASS_RANK,
x_intr_accept_advice_num => l_get_inst_dtls_rec.intrntnl_acceptance_advice_num,
x_ASS_TRACKING_ID => l_get_inst_dtls_rec.ASS_TRACKING_ID,
x_FEE_CAT => l_get_inst_dtls_rec.FEE_CAT,
x_HECS_PAYMENT_OPTION => l_get_inst_dtls_rec.HECS_PAYMENT_OPTION,
x_EXPECTED_COMPLETION_YR => l_get_inst_dtls_rec.EXPECTED_COMPLETION_YR,
x_EXPECTED_COMPLETION_PERD => l_get_inst_dtls_rec.EXPECTED_COMPLETION_PERD,
x_CORRESPONDENCE_CAT => l_get_inst_dtls_rec.CORRESPONDENCE_CAT,
x_ENROLMENT_CAT => l_get_inst_dtls_rec.ENROLMENT_CAT,
x_FUNDING_SOURCE => l_get_inst_dtls_rec.FUNDING_SOURCE,
x_APPLICANT_ACPTNCE_CNDTN => l_get_pending_hist_rec.APPLICANT_ACPTNCE_CNDTN,
x_CNDTNL_OFFER_CNDTN => l_get_pending_hist_rec.CNDTNL_OFFER_CNDTN,
X_MODE => 'S',
X_SS_APPLICATION_ID => l_get_inst_dtls_rec.SS_APPLICATION_ID,
X_SS_PWD => l_get_inst_dtls_rec.SS_PWD,
X_AUTHORIZED_DT => l_get_inst_dtls_rec.AUTHORIZED_DT,
X_AUTHORIZING_PERS_ID => l_get_inst_dtls_rec.AUTHORIZING_PERS_ID,
x_entry_status => l_get_inst_dtls_rec.entry_status,
x_entry_level => l_get_inst_dtls_rec.entry_level,
x_sch_apl_to_id => l_get_inst_dtls_rec.sch_apl_to_id,
x_idx_calc_date => l_get_inst_dtls_rec.idx_calc_date,
x_waitlist_status => l_get_pending_hist_rec.waitlist_status,
x_ATTRIBUTE21 => l_get_inst_dtls_rec.ATTRIBUTE21,
x_ATTRIBUTE22 => l_get_inst_dtls_rec.ATTRIBUTE22,
x_ATTRIBUTE23 => l_get_inst_dtls_rec.ATTRIBUTE23,
x_ATTRIBUTE24 => l_get_inst_dtls_rec.ATTRIBUTE24,
x_ATTRIBUTE25 => l_get_inst_dtls_rec.ATTRIBUTE25,
x_ATTRIBUTE26 => l_get_inst_dtls_rec.ATTRIBUTE26,
x_ATTRIBUTE27 => l_get_inst_dtls_rec.ATTRIBUTE27,
x_ATTRIBUTE28 => l_get_inst_dtls_rec.ATTRIBUTE28,
x_ATTRIBUTE29 => l_get_inst_dtls_rec.ATTRIBUTE29,
x_ATTRIBUTE30 => l_get_inst_dtls_rec.ATTRIBUTE30,
x_ATTRIBUTE31 => l_get_inst_dtls_rec.ATTRIBUTE31,
x_ATTRIBUTE32 => l_get_inst_dtls_rec.ATTRIBUTE32,
x_ATTRIBUTE33 => l_get_inst_dtls_rec.ATTRIBUTE33,
x_ATTRIBUTE34 => l_get_inst_dtls_rec.ATTRIBUTE34,
x_ATTRIBUTE35 => l_get_inst_dtls_rec.ATTRIBUTE35,
x_ATTRIBUTE36 => l_get_inst_dtls_rec.ATTRIBUTE36,
x_ATTRIBUTE37 => l_get_inst_dtls_rec.ATTRIBUTE37,
x_ATTRIBUTE38 => l_get_inst_dtls_rec.ATTRIBUTE38,
x_ATTRIBUTE39 => l_get_inst_dtls_rec.ATTRIBUTE39,
x_ATTRIBUTE40 => l_get_inst_dtls_rec.ATTRIBUTE40,
x_fut_acad_cal_type => l_get_pending_hist_rec.future_acad_cal_type,
x_fut_acad_ci_sequence_number => l_get_pending_hist_rec.future_acad_ci_sequence_num,
x_fut_adm_cal_type => l_get_pending_hist_rec.future_adm_cal_type,
x_fut_adm_ci_sequence_number => l_get_pending_hist_rec.future_adm_ci_sequence_num,
x_prev_term_adm_appl_number => l_get_inst_dtls_rec.PREVIOUS_TERM_ADM_APPL_NUMBER,
x_prev_term_sequence_number => l_get_inst_dtls_rec.PREVIOUS_TERM_SEQUENCE_NUMBER,
x_fut_term_adm_appl_number => l_get_inst_dtls_rec.future_term_adm_appl_number,
x_fut_term_sequence_number => l_get_inst_dtls_rec.future_term_sequence_number,
x_def_acad_cal_type => l_get_pending_hist_rec.def_acad_cal_type,
x_def_acad_ci_sequence_num => l_get_pending_hist_rec.def_acad_ci_sequence_num,
x_def_prev_term_adm_appl_num => l_get_inst_dtls_rec.def_prev_term_adm_appl_num,
x_def_prev_appl_sequence_num => l_get_inst_dtls_rec.def_prev_appl_sequence_num,
x_def_term_adm_appl_num => l_get_inst_dtls_rec.def_term_adm_appl_num,
x_def_appl_sequence_num => l_get_inst_dtls_rec.def_appl_sequence_num,
x_appl_inst_status => l_get_inst_dtls_rec.appl_inst_status,
x_ais_reason => l_get_inst_dtls_rec.ais_reason,
x_decline_ofr_reason => l_get_pending_hist_rec.decline_ofr_reason);
SAVEPOINT c_update_inst;
igs_ad_ps_appl_inst_pkg.update_row (
X_ROWID => l_get_fut_appl_inst.ROWID,
x_PERSON_ID => l_get_fut_appl_inst.PERSON_ID,
x_ADMISSION_APPL_NUMBER => l_get_fut_appl_inst.ADMISSION_APPL_NUMBER,
x_NOMINATED_COURSE_CD => l_get_fut_appl_inst.NOMINATED_COURSE_CD,
x_SEQUENCE_NUMBER => l_get_fut_appl_inst.SEQUENCE_NUMBER,
x_PREDICTED_GPA => l_get_fut_appl_inst.PREDICTED_GPA,
x_ACADEMIC_INDEX => l_get_fut_appl_inst.ACADEMIC_INDEX,
x_ADM_CAL_TYPE => l_get_fut_appl_inst.ADM_CAL_TYPE,
x_APP_FILE_LOCATION => l_get_fut_appl_inst.APP_FILE_LOCATION,
x_ADM_CI_SEQUENCE_NUMBER => l_get_fut_appl_inst.ADM_CI_SEQUENCE_NUMBER,
x_COURSE_CD => l_get_fut_appl_inst.COURSE_CD,
x_APP_SOURCE_ID => l_get_fut_appl_inst.APP_SOURCE_ID,
x_CRV_VERSION_NUMBER => l_get_fut_appl_inst.CRV_VERSION_NUMBER,
x_WAITLIST_RANK => l_get_fut_appl_inst.WAITLIST_RANK,
x_LOCATION_CD => l_get_fut_appl_inst.LOCATION_CD,
x_ATTENT_OTHER_INST_CD => l_get_fut_appl_inst.ATTENT_OTHER_INST_CD,
x_ATTENDANCE_MODE => l_get_fut_appl_inst.ATTENDANCE_MODE,
x_EDU_GOAL_PRIOR_ENROLL_ID => l_get_fut_appl_inst.EDU_GOAL_PRIOR_ENROLL_ID,
x_ATTENDANCE_TYPE => l_get_fut_appl_inst.ATTENDANCE_TYPE,
x_DECISION_MAKE_ID => l_get_fut_appl_inst.DECISION_MAKE_ID,
x_UNIT_SET_CD => l_get_fut_appl_inst.UNIT_SET_CD,
x_DECISION_DATE => l_get_fut_appl_inst.DECISION_DATE,
x_ATTRIBUTE_CATEGORY => l_get_fut_appl_inst.ATTRIBUTE_CATEGORY,
x_ATTRIBUTE1 => l_get_fut_appl_inst.ATTRIBUTE1,
x_ATTRIBUTE2 => l_get_fut_appl_inst.ATTRIBUTE2,
x_ATTRIBUTE3 => l_get_fut_appl_inst.ATTRIBUTE3,
x_ATTRIBUTE4 => l_get_fut_appl_inst.ATTRIBUTE4,
x_ATTRIBUTE5 => l_get_fut_appl_inst.ATTRIBUTE5,
x_ATTRIBUTE6 => l_get_fut_appl_inst.ATTRIBUTE6,
x_ATTRIBUTE7 => l_get_fut_appl_inst.ATTRIBUTE7,
x_ATTRIBUTE8 => l_get_fut_appl_inst.ATTRIBUTE8,
x_ATTRIBUTE9 => l_get_fut_appl_inst.ATTRIBUTE9,
x_ATTRIBUTE10 => l_get_fut_appl_inst.ATTRIBUTE10,
x_ATTRIBUTE11 => l_get_fut_appl_inst.ATTRIBUTE11,
x_ATTRIBUTE12 => l_get_fut_appl_inst.ATTRIBUTE12,
x_ATTRIBUTE13 => l_get_fut_appl_inst.ATTRIBUTE13,
x_ATTRIBUTE14 => l_get_fut_appl_inst.ATTRIBUTE14,
x_ATTRIBUTE15 => l_get_fut_appl_inst.ATTRIBUTE15,
x_ATTRIBUTE16 => l_get_fut_appl_inst.ATTRIBUTE16,
x_ATTRIBUTE17 => l_get_fut_appl_inst.ATTRIBUTE17,
x_ATTRIBUTE18 => l_get_fut_appl_inst.ATTRIBUTE18,
x_ATTRIBUTE19 => l_get_fut_appl_inst.ATTRIBUTE19,
x_ATTRIBUTE20 => l_get_fut_appl_inst.ATTRIBUTE20,
x_DECISION_REASON_ID => l_get_fut_appl_inst.DECISION_REASON_ID,
x_US_VERSION_NUMBER => l_get_fut_appl_inst.US_VERSION_NUMBER,
x_DECISION_NOTES => l_get_fut_appl_inst.DECISION_NOTES,
x_PENDING_REASON_ID => l_get_fut_appl_inst.PENDING_REASON_ID,
x_PREFERENCE_NUMBER => l_get_fut_appl_inst.PREFERENCE_NUMBER,
x_ADM_DOC_STATUS => l_get_fut_appl_inst.ADM_DOC_STATUS,
x_ADM_ENTRY_QUAL_STATUS => l_get_fut_appl_inst.ADM_ENTRY_QUAL_STATUS,
x_DEFICIENCY_IN_PREP => l_get_fut_appl_inst.DEFICIENCY_IN_PREP,
x_LATE_ADM_FEE_STATUS => l_get_fut_appl_inst.LATE_ADM_FEE_STATUS,
x_SPL_CONSIDER_COMMENTS => l_get_fut_appl_inst.SPL_CONSIDER_COMMENTS,
x_APPLY_FOR_FINAID => l_get_fut_appl_inst.APPLY_FOR_FINAID,
x_FINAID_APPLY_DATE => l_get_fut_appl_inst.FINAID_APPLY_DATE,
x_ADM_OUTCOME_STATUS => l_get_fut_appl_inst.ADM_OUTCOME_STATUS,
x_adm_otcm_stat_auth_per_id => l_get_fut_appl_inst.ADM_OTCM_STATUS_AUTH_PERSON_ID,
x_ADM_OUTCOME_STATUS_AUTH_DT => l_get_fut_appl_inst.ADM_OUTCOME_STATUS_AUTH_DT,
x_ADM_OUTCOME_STATUS_REASON => l_get_fut_appl_inst.ADM_OUTCOME_STATUS_REASON,
x_OFFER_DT => l_get_fut_appl_inst.OFFER_DT,
x_OFFER_RESPONSE_DT => l_get_fut_appl_inst.OFFER_RESPONSE_DT,
x_PRPSD_COMMENCEMENT_DT => l_get_fut_appl_inst.PRPSD_COMMENCEMENT_DT,
x_ADM_CNDTNL_OFFER_STATUS => l_get_fut_appl_inst.ADM_CNDTNL_OFFER_STATUS,
x_CNDTNL_OFFER_SATISFIED_DT => l_get_fut_appl_inst.CNDTNL_OFFER_SATISFIED_DT,
x_cndnl_ofr_must_be_stsfd_ind => l_get_fut_appl_inst.CNDTNL_OFFER_MUST_BE_STSFD_IND,
x_ADM_OFFER_RESP_STATUS => l_get_fut_appl_inst.ADM_OFFER_RESP_STATUS,
x_ACTUAL_RESPONSE_DT => l_get_fut_appl_inst.ACTUAL_RESPONSE_DT,
x_ADM_OFFER_DFRMNT_STATUS => l_get_fut_appl_inst.ADM_OFFER_DFRMNT_STATUS,
x_DEFERRED_ADM_CAL_TYPE => l_get_fut_appl_inst.DEFERRED_ADM_CAL_TYPE,
x_DEFERRED_ADM_CI_SEQUENCE_NUM => l_get_fut_appl_inst.DEFERRED_ADM_CI_SEQUENCE_NUM,
x_DEFERRED_TRACKING_ID => l_get_fut_appl_inst.DEFERRED_TRACKING_ID,
x_ASS_RANK => l_get_fut_appl_inst.ASS_RANK,
x_SECONDARY_ASS_RANK => l_get_fut_appl_inst.SECONDARY_ASS_RANK,
x_intr_accept_advice_num => l_get_fut_appl_inst.INTRNTNL_ACCEPTANCE_ADVICE_NUM,
x_ASS_TRACKING_ID => l_get_fut_appl_inst.ASS_TRACKING_ID,
x_FEE_CAT => l_get_fut_appl_inst.FEE_CAT,
x_HECS_PAYMENT_OPTION => l_get_fut_appl_inst.HECS_PAYMENT_OPTION,
x_EXPECTED_COMPLETION_YR => l_get_fut_appl_inst.EXPECTED_COMPLETION_YR,
x_EXPECTED_COMPLETION_PERD => l_get_fut_appl_inst.EXPECTED_COMPLETION_PERD,
x_CORRESPONDENCE_CAT => l_get_fut_appl_inst.CORRESPONDENCE_CAT,
x_ENROLMENT_CAT => l_get_fut_appl_inst.ENROLMENT_CAT,
x_FUNDING_SOURCE => l_get_fut_appl_inst.FUNDING_SOURCE,
x_APPLICANT_ACPTNCE_CNDTN => l_get_fut_appl_inst.APPLICANT_ACPTNCE_CNDTN,
x_CNDTNL_OFFER_CNDTN => l_get_fut_appl_inst.CNDTNL_OFFER_CNDTN,
X_MODE => 'S',
X_SS_APPLICATION_ID => l_get_fut_appl_inst.SS_APPLICATION_ID,
X_SS_PWD => l_get_fut_appl_inst.SS_PWD,
X_AUTHORIZED_DT => l_get_fut_appl_inst.AUTHORIZED_DT,
X_AUTHORIZING_PERS_ID => l_get_fut_appl_inst.AUTHORIZING_PERS_ID,
x_entry_status => l_get_fut_appl_inst.entry_status,
x_entry_level => l_get_fut_appl_inst.entry_level,
x_sch_apl_to_id => l_get_fut_appl_inst.sch_apl_to_id,
x_idx_calc_date => l_get_fut_appl_inst.idx_calc_date,
x_waitlist_status => l_get_fut_appl_inst.waitlist_status,
x_ATTRIBUTE21 => l_get_fut_appl_inst.ATTRIBUTE21,
x_ATTRIBUTE22 => l_get_fut_appl_inst.ATTRIBUTE22,
x_ATTRIBUTE23 => l_get_fut_appl_inst.ATTRIBUTE23,
x_ATTRIBUTE24 => l_get_fut_appl_inst.ATTRIBUTE24,
x_ATTRIBUTE25 => l_get_fut_appl_inst.ATTRIBUTE25,
x_ATTRIBUTE26 => l_get_fut_appl_inst.ATTRIBUTE26,
x_ATTRIBUTE27 => l_get_fut_appl_inst.ATTRIBUTE27,
x_ATTRIBUTE28 => l_get_fut_appl_inst.ATTRIBUTE28,
x_ATTRIBUTE29 => l_get_fut_appl_inst.ATTRIBUTE29,
x_ATTRIBUTE30 => l_get_fut_appl_inst.ATTRIBUTE30,
x_ATTRIBUTE31 => l_get_fut_appl_inst.ATTRIBUTE31,
x_ATTRIBUTE32 => l_get_fut_appl_inst.ATTRIBUTE32,
x_ATTRIBUTE33 => l_get_fut_appl_inst.ATTRIBUTE33,
x_ATTRIBUTE34 => l_get_fut_appl_inst.ATTRIBUTE34,
x_ATTRIBUTE35 => l_get_fut_appl_inst.ATTRIBUTE35,
x_ATTRIBUTE36 => l_get_fut_appl_inst.ATTRIBUTE36,
x_ATTRIBUTE37 => l_get_fut_appl_inst.ATTRIBUTE37,
x_ATTRIBUTE38 => l_get_fut_appl_inst.ATTRIBUTE38,
x_ATTRIBUTE39 => l_get_fut_appl_inst.ATTRIBUTE39,
x_ATTRIBUTE40 => l_get_fut_appl_inst.ATTRIBUTE40,
x_fut_acad_cal_type => NULL,
x_fut_acad_ci_sequence_number => NULL,
x_fut_adm_cal_type => NULL,
x_fut_adm_ci_sequence_number => NULL,
x_prev_term_adm_appl_number => l_get_fut_appl_inst.PREVIOUS_TERM_ADM_APPL_NUMBER,
x_prev_term_sequence_number => l_get_fut_appl_inst.PREVIOUS_TERM_SEQUENCE_NUMBER,
x_fut_term_adm_appl_number => l_get_fut_appl_inst.FUTURE_TERM_ADM_APPL_NUMBER,
x_fut_term_sequence_number => l_get_fut_appl_inst.FUTURE_TERM_SEQUENCE_NUMBER,
x_def_acad_cal_type => l_get_fut_appl_inst.def_acad_cal_type,
x_def_acad_ci_sequence_num => l_get_fut_appl_inst.def_acad_ci_sequence_num,
x_def_prev_term_adm_appl_num => l_get_fut_appl_inst.def_prev_term_adm_appl_num,
x_def_prev_appl_sequence_num => l_get_fut_appl_inst.def_prev_appl_sequence_num,
x_def_term_adm_appl_num => l_get_fut_appl_inst.def_term_adm_appl_num,
x_def_appl_sequence_num => l_get_fut_appl_inst.def_appl_sequence_num,
x_appl_inst_status => l_get_fut_appl_inst.appl_inst_status,
x_ais_reason => l_get_fut_appl_inst.ais_reason,
x_decline_ofr_reason => l_get_fut_appl_inst.decline_ofr_reason);
ROLLBACK TO c_update_inst;
igs_ad_ps_appl_pkg.update_row (
x_rowid => c_dyn_pig_check_rec.row_id,
x_person_id => c_dyn_pig_check_rec.person_id,
x_admission_appl_number => c_dyn_pig_check_rec.admission_appl_number,
x_nominated_course_cd => c_dyn_pig_check_rec.nominated_course_cd,
x_transfer_course_cd => c_dyn_pig_check_rec.transfer_course_cd,
x_basis_for_admission_type => c_dyn_pig_check_rec.basis_for_admission_type,
x_admission_cd => c_dyn_pig_check_rec.admission_cd,
x_course_rank_set => c_dyn_pig_check_rec.course_rank_set,
x_course_rank_schedule => c_dyn_pig_check_rec.course_rank_schedule,
x_req_for_reconsideration_ind => 'N',
x_req_for_adv_standing_ind => c_dyn_pig_check_rec.req_for_adv_standing_ind ,
x_mode => 'R' ) ;
igs_ad_ps_appl_inst_pkg.update_row (
X_ROWID => l_get_inst_dtls_rec.ROWID,
x_PERSON_ID => l_get_inst_dtls_rec.PERSON_ID,
x_ADMISSION_APPL_NUMBER => l_get_inst_dtls_rec.ADMISSION_APPL_NUMBER,
x_NOMINATED_COURSE_CD => l_get_inst_dtls_rec.NOMINATED_COURSE_CD,
x_SEQUENCE_NUMBER => l_get_inst_dtls_rec.SEQUENCE_NUMBER,
x_PREDICTED_GPA => l_get_inst_dtls_rec.PREDICTED_GPA,
x_ACADEMIC_INDEX => l_get_inst_dtls_rec.ACADEMIC_INDEX,
x_ADM_CAL_TYPE => l_get_inst_dtls_rec.ADM_CAL_TYPE,
x_APP_FILE_LOCATION => l_get_inst_dtls_rec.APP_FILE_LOCATION,
x_ADM_CI_SEQUENCE_NUMBER => l_get_inst_dtls_rec.ADM_CI_SEQUENCE_NUMBER,
x_COURSE_CD => l_get_inst_dtls_rec.COURSE_CD,
x_APP_SOURCE_ID => l_get_inst_dtls_rec.APP_SOURCE_ID,
x_CRV_VERSION_NUMBER => l_get_inst_dtls_rec.CRV_VERSION_NUMBER,
x_WAITLIST_RANK => l_get_pending_hist_rec.WAITLIST_RANK,
x_LOCATION_CD => l_get_inst_dtls_rec.LOCATION_CD,
x_ATTENT_OTHER_INST_CD => l_get_inst_dtls_rec.ATTENT_OTHER_INST_CD,
x_ATTENDANCE_MODE => l_get_inst_dtls_rec.ATTENDANCE_MODE,
x_EDU_GOAL_PRIOR_ENROLL_ID => l_get_inst_dtls_rec.EDU_GOAL_PRIOR_ENROLL_ID,
x_ATTENDANCE_TYPE => l_get_inst_dtls_rec.ATTENDANCE_TYPE,
x_DECISION_MAKE_ID => l_get_pending_hist_rec.DECISION_MAKE_ID,
x_UNIT_SET_CD => l_get_inst_dtls_rec.UNIT_SET_CD,
x_DECISION_DATE => l_get_pending_hist_rec.DECISION_DATE,
x_ATTRIBUTE_CATEGORY => l_get_inst_dtls_rec.ATTRIBUTE_CATEGORY,
x_ATTRIBUTE1 => l_get_inst_dtls_rec.ATTRIBUTE1,
x_ATTRIBUTE2 => l_get_inst_dtls_rec.ATTRIBUTE2,
x_ATTRIBUTE3 => l_get_inst_dtls_rec.ATTRIBUTE3,
x_ATTRIBUTE4 => l_get_inst_dtls_rec.ATTRIBUTE4,
x_ATTRIBUTE5 => l_get_inst_dtls_rec.ATTRIBUTE5,
x_ATTRIBUTE6 => l_get_inst_dtls_rec.ATTRIBUTE6,
x_ATTRIBUTE7 => l_get_inst_dtls_rec.ATTRIBUTE7,
x_ATTRIBUTE8 => l_get_inst_dtls_rec.ATTRIBUTE8,
x_ATTRIBUTE9 => l_get_inst_dtls_rec.ATTRIBUTE9,
x_ATTRIBUTE10 => l_get_inst_dtls_rec.ATTRIBUTE10,
x_ATTRIBUTE11 => l_get_inst_dtls_rec.ATTRIBUTE11,
x_ATTRIBUTE12 => l_get_inst_dtls_rec.ATTRIBUTE12,
x_ATTRIBUTE13 => l_get_inst_dtls_rec.ATTRIBUTE13,
x_ATTRIBUTE14 => l_get_inst_dtls_rec.ATTRIBUTE14,
x_ATTRIBUTE15 => l_get_inst_dtls_rec.ATTRIBUTE15,
x_ATTRIBUTE16 => l_get_inst_dtls_rec.ATTRIBUTE16,
x_ATTRIBUTE17 => l_get_inst_dtls_rec.ATTRIBUTE17,
x_ATTRIBUTE18 => l_get_inst_dtls_rec.ATTRIBUTE18,
x_ATTRIBUTE19 => l_get_inst_dtls_rec.ATTRIBUTE19,
x_ATTRIBUTE20 => l_get_inst_dtls_rec.ATTRIBUTE20,
x_DECISION_REASON_ID => l_get_pending_hist_rec.DECISION_REASON_ID,
x_US_VERSION_NUMBER => l_get_inst_dtls_rec.US_VERSION_NUMBER,
x_DECISION_NOTES => l_get_inst_dtls_rec.DECISION_NOTES,
x_PENDING_REASON_ID => l_get_pending_hist_rec.PENDING_REASON_ID,
x_PREFERENCE_NUMBER => l_get_inst_dtls_rec.PREFERENCE_NUMBER,
x_ADM_DOC_STATUS => l_get_inst_dtls_rec.ADM_DOC_STATUS,
x_ADM_ENTRY_QUAL_STATUS => l_get_inst_dtls_rec.ADM_ENTRY_QUAL_STATUS,
x_DEFICIENCY_IN_PREP => l_get_inst_dtls_rec.DEFICIENCY_IN_PREP,
x_LATE_ADM_FEE_STATUS => l_get_inst_dtls_rec.LATE_ADM_FEE_STATUS,
x_SPL_CONSIDER_COMMENTS => l_get_inst_dtls_rec.SPL_CONSIDER_COMMENTS,
x_APPLY_FOR_FINAID => l_get_inst_dtls_rec.APPLY_FOR_FINAID,
x_FINAID_APPLY_DATE => l_get_inst_dtls_rec.FINAID_APPLY_DATE,
x_ADM_OUTCOME_STATUS => l_get_pending_hist_rec.ADM_OUTCOME_STATUS,
x_adm_otcm_stat_auth_per_id => l_get_inst_dtls_rec.ADM_OTCM_STATUS_AUTH_PERSON_ID,
x_ADM_OUTCOME_STATUS_AUTH_DT => l_get_inst_dtls_rec.ADM_OUTCOME_STATUS_AUTH_DT,
x_ADM_OUTCOME_STATUS_REASON => l_get_inst_dtls_rec.ADM_OUTCOME_STATUS_REASON,
x_OFFER_DT => l_get_pending_hist_rec.OFFER_DT,
x_OFFER_RESPONSE_DT => l_get_pending_hist_rec.OFFER_RESPONSE_DT,
x_PRPSD_COMMENCEMENT_DT => l_get_pending_hist_rec.PRPSD_COMMENCEMENT_DT,
x_ADM_CNDTNL_OFFER_STATUS => NVL(l_get_pending_hist_rec.ADM_CNDTNL_OFFER_STATUS,IGS_AD_GEN_009.ADMP_GET_SYS_ACOS('NOT-APPLIC')),
x_CNDTNL_OFFER_SATISFIED_DT => l_get_pending_hist_rec.CNDTNL_OFFER_SATISFIED_DT,
x_cndnl_ofr_must_be_stsfd_ind => l_get_pending_hist_rec.CNDTNL_OFFER_MUST_BE_STSFD_IND,
x_ADM_OFFER_RESP_STATUS => NVL(l_get_pending_hist_rec.ADM_OFFER_RESP_STATUS,IGS_AD_GEN_009.ADMP_GET_SYS_AORS('NOT-APPLIC')),
x_ACTUAL_RESPONSE_DT => l_get_pending_hist_rec.ACTUAL_RESPONSE_DT,
x_ADM_OFFER_DFRMNT_STATUS => NVL(l_get_pending_hist_rec.ADM_OFFER_DFRMNT_STATUS,IGS_AD_GEN_009.ADMP_GET_SYS_AODS('NOT-APPLIC')),
x_DEFERRED_ADM_CAL_TYPE => l_get_pending_hist_rec.DEFERRED_ADM_CAL_TYPE,
x_DEFERRED_ADM_CI_SEQUENCE_NUM => l_get_pending_hist_rec.DEFERRED_ADM_CI_SEQUENCE_NUM,
x_DEFERRED_TRACKING_ID => l_get_inst_dtls_rec.DEFERRED_TRACKING_ID,
x_ASS_RANK => l_get_inst_dtls_rec.ASS_RANK,
x_SECONDARY_ASS_RANK => l_get_inst_dtls_rec.SECONDARY_ASS_RANK,
x_intr_accept_advice_num => l_get_inst_dtls_rec.intrntnl_acceptance_advice_num,
x_ASS_TRACKING_ID => l_get_inst_dtls_rec.ASS_TRACKING_ID,
x_FEE_CAT => l_get_inst_dtls_rec.FEE_CAT,
x_HECS_PAYMENT_OPTION => l_get_inst_dtls_rec.HECS_PAYMENT_OPTION,
x_EXPECTED_COMPLETION_YR => l_get_inst_dtls_rec.EXPECTED_COMPLETION_YR,
x_EXPECTED_COMPLETION_PERD => l_get_inst_dtls_rec.EXPECTED_COMPLETION_PERD,
x_CORRESPONDENCE_CAT => l_get_inst_dtls_rec.CORRESPONDENCE_CAT,
x_ENROLMENT_CAT => l_get_inst_dtls_rec.ENROLMENT_CAT,
x_FUNDING_SOURCE => l_get_inst_dtls_rec.FUNDING_SOURCE,
x_APPLICANT_ACPTNCE_CNDTN => l_get_pending_hist_rec.APPLICANT_ACPTNCE_CNDTN,
x_CNDTNL_OFFER_CNDTN => l_get_pending_hist_rec.CNDTNL_OFFER_CNDTN,
X_MODE => 'S',
X_SS_APPLICATION_ID => l_get_inst_dtls_rec.SS_APPLICATION_ID,
X_SS_PWD => l_get_inst_dtls_rec.SS_PWD,
X_AUTHORIZED_DT => l_get_inst_dtls_rec.AUTHORIZED_DT,
X_AUTHORIZING_PERS_ID => l_get_inst_dtls_rec.AUTHORIZING_PERS_ID,
x_entry_status => l_get_inst_dtls_rec.entry_status,
x_entry_level => l_get_inst_dtls_rec.entry_level,
x_sch_apl_to_id => l_get_inst_dtls_rec.sch_apl_to_id,
x_idx_calc_date => l_get_inst_dtls_rec.idx_calc_date,
x_waitlist_status => l_get_pending_hist_rec.waitlist_status,
x_ATTRIBUTE21 => l_get_inst_dtls_rec.ATTRIBUTE21,
x_ATTRIBUTE22 => l_get_inst_dtls_rec.ATTRIBUTE22,
x_ATTRIBUTE23 => l_get_inst_dtls_rec.ATTRIBUTE23,
x_ATTRIBUTE24 => l_get_inst_dtls_rec.ATTRIBUTE24,
x_ATTRIBUTE25 => l_get_inst_dtls_rec.ATTRIBUTE25,
x_ATTRIBUTE26 => l_get_inst_dtls_rec.ATTRIBUTE26,
x_ATTRIBUTE27 => l_get_inst_dtls_rec.ATTRIBUTE27,
x_ATTRIBUTE28 => l_get_inst_dtls_rec.ATTRIBUTE28,
x_ATTRIBUTE29 => l_get_inst_dtls_rec.ATTRIBUTE29,
x_ATTRIBUTE30 => l_get_inst_dtls_rec.ATTRIBUTE30,
x_ATTRIBUTE31 => l_get_inst_dtls_rec.ATTRIBUTE31,
x_ATTRIBUTE32 => l_get_inst_dtls_rec.ATTRIBUTE32,
x_ATTRIBUTE33 => l_get_inst_dtls_rec.ATTRIBUTE33,
x_ATTRIBUTE34 => l_get_inst_dtls_rec.ATTRIBUTE34,
x_ATTRIBUTE35 => l_get_inst_dtls_rec.ATTRIBUTE35,
x_ATTRIBUTE36 => l_get_inst_dtls_rec.ATTRIBUTE36,
x_ATTRIBUTE37 => l_get_inst_dtls_rec.ATTRIBUTE37,
x_ATTRIBUTE38 => l_get_inst_dtls_rec.ATTRIBUTE38,
x_ATTRIBUTE39 => l_get_inst_dtls_rec.ATTRIBUTE39,
x_ATTRIBUTE40 => l_get_inst_dtls_rec.ATTRIBUTE40,
x_fut_acad_cal_type => l_get_pending_hist_rec.future_acad_cal_type,
x_fut_acad_ci_sequence_number => l_get_pending_hist_rec.future_acad_ci_sequence_num,
x_fut_adm_cal_type => l_get_pending_hist_rec.future_adm_cal_type,
x_fut_adm_ci_sequence_number => l_get_pending_hist_rec.future_adm_ci_sequence_num,
x_prev_term_adm_appl_number => l_get_inst_dtls_rec.PREVIOUS_TERM_ADM_APPL_NUMBER,
x_prev_term_sequence_number => l_get_inst_dtls_rec.PREVIOUS_TERM_SEQUENCE_NUMBER,
x_fut_term_adm_appl_number => l_get_inst_dtls_rec.future_term_adm_appl_number,
x_fut_term_sequence_number => l_get_inst_dtls_rec.future_term_sequence_number,
x_def_acad_cal_type => l_get_pending_hist_rec.def_acad_cal_type,
x_def_acad_ci_sequence_num => l_get_pending_hist_rec.def_acad_ci_sequence_num,
x_def_prev_term_adm_appl_num => l_get_inst_dtls_rec.def_prev_term_adm_appl_num,
x_def_prev_appl_sequence_num => l_get_inst_dtls_rec.def_prev_appl_sequence_num,
x_def_term_adm_appl_num => l_get_inst_dtls_rec.def_term_adm_appl_num,
x_def_appl_sequence_num => l_get_inst_dtls_rec.def_appl_sequence_num,
x_appl_inst_status => l_get_inst_dtls_rec.appl_inst_status,
x_ais_reason => l_get_inst_dtls_rec.ais_reason,
x_decline_ofr_reason => l_get_pending_hist_rec.decline_ofr_reason);
NVL(apai.appl_inst_status,''RECEIVED'') NOT IN (SELECT adm_appl_status FROM igs_ad_appl_stat WHERE S_ADM_APPL_STATUS = ''WITHDRAWN'') AND
Psapl.req_for_reconsideration_ind <> ''Y'' AND
Apai.person_id = psapl.person_id AND
Apai.admission_appl_number = psapl.admission_appl_number AND
Apai.nominated_course_cd = psapl.nominated_course_cd AND
apai.person_id = aa.person_id AND
apai.admission_appl_number = aa.admission_appl_number AND
Apai.future_acad_cal_type IS NOT NULL AND
Apai.future_acad_ci_sequence_number IS NOT NULL AND
Apai.future_adm_cal_type IS NOT NULL AND
Apai.future_adm_ci_sequence_number IS NOT NULL';
SAVEPOINT c_update_inst;
igs_ad_ps_appl_inst_pkg.update_row (
X_ROWID => c_pend_fut_rec.ROWID,
x_PERSON_ID => c_pend_fut_rec.PERSON_ID,
x_ADMISSION_APPL_NUMBER => c_pend_fut_rec.ADMISSION_APPL_NUMBER,
x_NOMINATED_COURSE_CD => c_pend_fut_rec.NOMINATED_COURSE_CD,
x_SEQUENCE_NUMBER => c_pend_fut_rec.SEQUENCE_NUMBER,
x_PREDICTED_GPA => c_pend_fut_rec.PREDICTED_GPA,
x_ACADEMIC_INDEX => c_pend_fut_rec.ACADEMIC_INDEX,
x_ADM_CAL_TYPE => c_pend_fut_rec.ADM_CAL_TYPE,
x_APP_FILE_LOCATION => c_pend_fut_rec.APP_FILE_LOCATION,
x_ADM_CI_SEQUENCE_NUMBER => c_pend_fut_rec.ADM_CI_SEQUENCE_NUMBER,
x_COURSE_CD => c_pend_fut_rec.COURSE_CD,
x_APP_SOURCE_ID => c_pend_fut_rec.APP_SOURCE_ID,
x_CRV_VERSION_NUMBER => c_pend_fut_rec.CRV_VERSION_NUMBER,
x_WAITLIST_RANK => c_pend_fut_rec.WAITLIST_RANK,
x_LOCATION_CD => c_pend_fut_rec.LOCATION_CD,
x_ATTENT_OTHER_INST_CD => c_pend_fut_rec.ATTENT_OTHER_INST_CD,
x_ATTENDANCE_MODE => c_pend_fut_rec.ATTENDANCE_MODE,
x_EDU_GOAL_PRIOR_ENROLL_ID => c_pend_fut_rec.EDU_GOAL_PRIOR_ENROLL_ID,
x_ATTENDANCE_TYPE => c_pend_fut_rec.ATTENDANCE_TYPE,
x_DECISION_MAKE_ID => c_pend_fut_rec.DECISION_MAKE_ID,
x_UNIT_SET_CD => c_pend_fut_rec.UNIT_SET_CD,
x_DECISION_DATE => c_pend_fut_rec.DECISION_DATE,
x_ATTRIBUTE_CATEGORY => c_pend_fut_rec.ATTRIBUTE_CATEGORY,
x_ATTRIBUTE1 => c_pend_fut_rec.ATTRIBUTE1,
x_ATTRIBUTE2 => c_pend_fut_rec.ATTRIBUTE2,
x_ATTRIBUTE3 => c_pend_fut_rec.ATTRIBUTE3,
x_ATTRIBUTE4 => c_pend_fut_rec.ATTRIBUTE4,
x_ATTRIBUTE5 => c_pend_fut_rec.ATTRIBUTE5,
x_ATTRIBUTE6 => c_pend_fut_rec.ATTRIBUTE6,
x_ATTRIBUTE7 => c_pend_fut_rec.ATTRIBUTE7,
x_ATTRIBUTE8 => c_pend_fut_rec.ATTRIBUTE8,
x_ATTRIBUTE9 => c_pend_fut_rec.ATTRIBUTE9,
x_ATTRIBUTE10 => c_pend_fut_rec.ATTRIBUTE10,
x_ATTRIBUTE11 => c_pend_fut_rec.ATTRIBUTE11,
x_ATTRIBUTE12 => c_pend_fut_rec.ATTRIBUTE12,
x_ATTRIBUTE13 => c_pend_fut_rec.ATTRIBUTE13,
x_ATTRIBUTE14 => c_pend_fut_rec.ATTRIBUTE14,
x_ATTRIBUTE15 => c_pend_fut_rec.ATTRIBUTE15,
x_ATTRIBUTE16 => c_pend_fut_rec.ATTRIBUTE16,
x_ATTRIBUTE17 => c_pend_fut_rec.ATTRIBUTE17,
x_ATTRIBUTE18 => c_pend_fut_rec.ATTRIBUTE18,
x_ATTRIBUTE19 => c_pend_fut_rec.ATTRIBUTE19,
x_ATTRIBUTE20 => c_pend_fut_rec.ATTRIBUTE20,
x_DECISION_REASON_ID => c_pend_fut_rec.DECISION_REASON_ID,
x_US_VERSION_NUMBER => c_pend_fut_rec.US_VERSION_NUMBER,
x_DECISION_NOTES => c_pend_fut_rec.DECISION_NOTES,
x_PENDING_REASON_ID => c_pend_fut_rec.PENDING_REASON_ID,
x_PREFERENCE_NUMBER => c_pend_fut_rec.PREFERENCE_NUMBER,
x_ADM_DOC_STATUS => c_pend_fut_rec.ADM_DOC_STATUS,
x_ADM_ENTRY_QUAL_STATUS => c_pend_fut_rec.ADM_ENTRY_QUAL_STATUS,
x_DEFICIENCY_IN_PREP => c_pend_fut_rec.DEFICIENCY_IN_PREP,
x_LATE_ADM_FEE_STATUS => c_pend_fut_rec.LATE_ADM_FEE_STATUS,
x_SPL_CONSIDER_COMMENTS => c_pend_fut_rec.SPL_CONSIDER_COMMENTS,
x_APPLY_FOR_FINAID => c_pend_fut_rec.APPLY_FOR_FINAID,
x_FINAID_APPLY_DATE => c_pend_fut_rec.FINAID_APPLY_DATE,
x_ADM_OUTCOME_STATUS => c_pend_fut_rec.ADM_OUTCOME_STATUS,
x_adm_otcm_stat_auth_per_id => c_pend_fut_rec.ADM_OTCM_STATUS_AUTH_PERSON_ID,
x_ADM_OUTCOME_STATUS_AUTH_DT => c_pend_fut_rec.ADM_OUTCOME_STATUS_AUTH_DT,
x_ADM_OUTCOME_STATUS_REASON => c_pend_fut_rec.ADM_OUTCOME_STATUS_REASON,
x_OFFER_DT => c_pend_fut_rec.OFFER_DT,
x_OFFER_RESPONSE_DT => c_pend_fut_rec.OFFER_RESPONSE_DT,
x_PRPSD_COMMENCEMENT_DT => c_pend_fut_rec.PRPSD_COMMENCEMENT_DT,
x_ADM_CNDTNL_OFFER_STATUS => c_pend_fut_rec.ADM_CNDTNL_OFFER_STATUS,
x_CNDTNL_OFFER_SATISFIED_DT => c_pend_fut_rec.CNDTNL_OFFER_SATISFIED_DT,
x_cndnl_ofr_must_be_stsfd_ind => c_pend_fut_rec.CNDTNL_OFFER_MUST_BE_STSFD_IND,
x_ADM_OFFER_RESP_STATUS => c_pend_fut_rec.ADM_OFFER_RESP_STATUS,
x_ACTUAL_RESPONSE_DT => c_pend_fut_rec.ACTUAL_RESPONSE_DT,
x_ADM_OFFER_DFRMNT_STATUS => c_pend_fut_rec.ADM_OFFER_DFRMNT_STATUS,
x_DEFERRED_ADM_CAL_TYPE => c_pend_fut_rec.DEFERRED_ADM_CAL_TYPE,
x_DEFERRED_ADM_CI_SEQUENCE_NUM => c_pend_fut_rec.DEFERRED_ADM_CI_SEQUENCE_NUM,
x_DEFERRED_TRACKING_ID => c_pend_fut_rec.DEFERRED_TRACKING_ID,
x_ASS_RANK => c_pend_fut_rec.ASS_RANK,
x_SECONDARY_ASS_RANK => c_pend_fut_rec.SECONDARY_ASS_RANK,
x_intr_accept_advice_num => c_pend_fut_rec.INTRNTNL_ACCEPTANCE_ADVICE_NUM,
x_ASS_TRACKING_ID => c_pend_fut_rec.ASS_TRACKING_ID,
x_FEE_CAT => c_pend_fut_rec.FEE_CAT,
x_HECS_PAYMENT_OPTION => c_pend_fut_rec.HECS_PAYMENT_OPTION,
x_EXPECTED_COMPLETION_YR => c_pend_fut_rec.EXPECTED_COMPLETION_YR,
x_EXPECTED_COMPLETION_PERD => c_pend_fut_rec.EXPECTED_COMPLETION_PERD,
x_CORRESPONDENCE_CAT => c_pend_fut_rec.CORRESPONDENCE_CAT,
x_ENROLMENT_CAT => c_pend_fut_rec.ENROLMENT_CAT,
x_FUNDING_SOURCE => c_pend_fut_rec.FUNDING_SOURCE,
x_APPLICANT_ACPTNCE_CNDTN => c_pend_fut_rec.APPLICANT_ACPTNCE_CNDTN,
x_CNDTNL_OFFER_CNDTN => c_pend_fut_rec.CNDTNL_OFFER_CNDTN,
X_MODE => 'S',
X_SS_APPLICATION_ID => c_pend_fut_rec.SS_APPLICATION_ID,
X_SS_PWD => c_pend_fut_rec.SS_PWD,
X_AUTHORIZED_DT => c_pend_fut_rec.AUTHORIZED_DT,
X_AUTHORIZING_PERS_ID => c_pend_fut_rec.AUTHORIZING_PERS_ID,
x_entry_status => c_pend_fut_rec.entry_status,
x_entry_level => c_pend_fut_rec.entry_level,
x_sch_apl_to_id => c_pend_fut_rec.sch_apl_to_id,
x_idx_calc_date => c_pend_fut_rec.idx_calc_date,
x_waitlist_status => c_pend_fut_rec.waitlist_status,
x_ATTRIBUTE21 => c_pend_fut_rec.ATTRIBUTE21,
x_ATTRIBUTE22 => c_pend_fut_rec.ATTRIBUTE22,
x_ATTRIBUTE23 => c_pend_fut_rec.ATTRIBUTE23,
x_ATTRIBUTE24 => c_pend_fut_rec.ATTRIBUTE24,
x_ATTRIBUTE25 => c_pend_fut_rec.ATTRIBUTE25,
x_ATTRIBUTE26 => c_pend_fut_rec.ATTRIBUTE26,
x_ATTRIBUTE27 => c_pend_fut_rec.ATTRIBUTE27,
x_ATTRIBUTE28 => c_pend_fut_rec.ATTRIBUTE28,
x_ATTRIBUTE29 => c_pend_fut_rec.ATTRIBUTE29,
x_ATTRIBUTE30 => c_pend_fut_rec.ATTRIBUTE30,
x_ATTRIBUTE31 => c_pend_fut_rec.ATTRIBUTE31,
x_ATTRIBUTE32 => c_pend_fut_rec.ATTRIBUTE32,
x_ATTRIBUTE33 => c_pend_fut_rec.ATTRIBUTE33,
x_ATTRIBUTE34 => c_pend_fut_rec.ATTRIBUTE34,
x_ATTRIBUTE35 => c_pend_fut_rec.ATTRIBUTE35,
x_ATTRIBUTE36 => c_pend_fut_rec.ATTRIBUTE36,
x_ATTRIBUTE37 => c_pend_fut_rec.ATTRIBUTE37,
x_ATTRIBUTE38 => c_pend_fut_rec.ATTRIBUTE38,
x_ATTRIBUTE39 => c_pend_fut_rec.ATTRIBUTE39,
x_ATTRIBUTE40 => c_pend_fut_rec.ATTRIBUTE40,
x_fut_acad_cal_type => NULL,
x_fut_acad_ci_sequence_number => NULL,
x_fut_adm_cal_type => NULL,
x_fut_adm_ci_sequence_number => NULL,
x_prev_term_adm_appl_number => c_pend_fut_rec.PREVIOUS_TERM_ADM_APPL_NUMBER,
x_prev_term_sequence_number => c_pend_fut_rec.PREVIOUS_TERM_SEQUENCE_NUMBER,
x_fut_term_adm_appl_number => c_pend_fut_rec.FUTURE_TERM_ADM_APPL_NUMBER,
x_fut_term_sequence_number => c_pend_fut_rec.FUTURE_TERM_SEQUENCE_NUMBER,
x_def_acad_cal_type => c_pend_fut_rec.def_acad_cal_type,
x_def_acad_ci_sequence_num => c_pend_fut_rec.def_acad_ci_sequence_num,
x_def_prev_term_adm_appl_num => c_pend_fut_rec.def_prev_term_adm_appl_num,
x_def_prev_appl_sequence_num => c_pend_fut_rec.def_prev_appl_sequence_num,
x_def_term_adm_appl_num => c_pend_fut_rec.def_term_adm_appl_num,
x_def_appl_sequence_num => c_pend_fut_rec.def_appl_sequence_num,
x_appl_inst_status => c_pend_fut_rec.appl_inst_status,
x_ais_reason => c_pend_fut_rec.ais_reason,
x_decline_ofr_reason => c_pend_fut_rec.decline_ofr_reason);
ROLLBACK TO c_update_inst;