The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT WIDTH , precision , column_type ,scale
FROM FND_COLUMNS
WHERE table_id IN
(SELECT TABLE_ID
FROM FND_TABLES
WHERE table_name = p_table_name AND APPLICATION_ID = 8405)
AND column_name = p_param_name
AND APPLICATION_ID = 8405;
SELECT
a.*
FROM
igs_ad_ps_appl_inst a,
igs_ad_ou_stat c
WHERE a.person_id = p_person_id
AND a.admission_appl_number = p_admission_appl_number
AND a.nominated_course_cd = p_nominated_course_cd
AND a.sequence_number = p_sequence_number
AND a.adm_outcome_status = c.adm_outcome_status
AND c.s_adm_outcome_status = 'PENDING';
SELECT 'x'
FROM igs_ad_doc_stat
WHERE s_adm_doc_status = 'SATISFIED'
AND adm_doc_status = p_doc_status;
igs_ad_ps_appl_inst_pkg.update_row(
x_rowid => l_appl_inst_rec.row_id,
x_person_id => l_appl_inst_rec.person_id,
x_admission_appl_number => l_appl_inst_rec.admission_appl_number,
x_nominated_course_cd => l_appl_inst_rec.nominated_course_cd,
x_sequence_number => l_appl_inst_rec.sequence_number,
x_predicted_gpa => l_predicted_gpa,
x_academic_index => l_academic_index,
x_adm_cal_type => l_appl_inst_rec.adm_cal_type,
x_app_file_location => l_appl_inst_rec.app_file_location,
x_adm_ci_sequence_number => l_appl_inst_rec.adm_ci_sequence_number,
x_course_cd => l_appl_inst_rec.course_cd,
x_app_source_id => l_appl_inst_rec.app_source_id,
x_crv_version_number => l_appl_inst_rec.crv_version_number,
x_waitlist_rank => l_appl_inst_rec.waitlist_rank,
x_waitlist_status => l_appl_inst_rec.waitlist_status,
x_location_cd => l_appl_inst_rec.location_cd,
x_attent_other_inst_cd => l_appl_inst_rec.attent_other_inst_cd,
x_attendance_mode => l_appl_inst_rec.attendance_mode,
x_edu_goal_prior_enroll_id => l_appl_inst_rec.edu_goal_prior_enroll_id,
x_attendance_type => l_appl_inst_rec.attendance_type,
x_decision_make_id => l_appl_inst_rec.decision_make_id,
x_unit_set_cd => l_appl_inst_rec.unit_set_cd,
x_decision_date => l_appl_inst_rec.decision_date,
x_attribute_category => l_appl_inst_rec.attribute_category,
x_attribute1 => l_appl_inst_rec.attribute1,
x_attribute2 => l_appl_inst_rec.attribute2,
x_attribute3 => l_appl_inst_rec.attribute3,
x_attribute4 => l_appl_inst_rec.attribute4,
x_attribute5 => l_appl_inst_rec.attribute5,
x_attribute6 => l_appl_inst_rec.attribute6,
x_attribute7 => l_appl_inst_rec.attribute7,
x_attribute8 => l_appl_inst_rec.attribute8,
x_attribute9 => l_appl_inst_rec.attribute9,
x_attribute10 => l_appl_inst_rec.attribute10,
x_attribute11 => l_appl_inst_rec.attribute11,
x_attribute12 => l_appl_inst_rec.attribute12,
x_attribute13 => l_appl_inst_rec.attribute13,
x_attribute14 => l_appl_inst_rec.attribute14,
x_attribute15 => l_appl_inst_rec.attribute15,
x_attribute16 => l_appl_inst_rec.attribute16,
x_attribute17 => l_appl_inst_rec.attribute17,
x_attribute18 => l_appl_inst_rec.attribute18,
x_attribute19 => l_appl_inst_rec.attribute19,
x_attribute20 => l_appl_inst_rec.attribute20,
x_decision_reason_id => l_appl_inst_rec.decision_reason_id,
x_us_version_number => l_appl_inst_rec.us_version_number,
x_decision_notes => l_appl_inst_rec.decision_notes,
x_pending_reason_id => l_appl_inst_rec.pending_reason_id,
x_preference_number => l_appl_inst_rec.preference_number,
x_adm_doc_status => l_appl_inst_rec.adm_doc_status,
x_adm_entry_qual_status => l_appl_inst_rec.adm_entry_qual_status,
x_deficiency_in_prep => l_appl_inst_rec.deficiency_in_prep,
x_late_adm_fee_status => l_appl_inst_rec.late_adm_fee_status,
x_spl_consider_comments => l_appl_inst_rec.spl_consider_comments,
x_apply_for_finaid => l_appl_inst_rec.apply_for_finaid,
x_finaid_apply_date => l_appl_inst_rec.finaid_apply_date,
x_adm_outcome_status => l_appl_inst_rec.adm_outcome_status,
x_adm_otcm_stat_auth_per_id => l_appl_inst_rec.adm_otcm_status_auth_person_id,
x_adm_outcome_status_auth_dt => l_appl_inst_rec.adm_outcome_status_auth_dt,
x_adm_outcome_status_reason => l_appl_inst_rec.adm_outcome_status_reason,
x_offer_dt => l_appl_inst_rec.offer_dt,
x_offer_response_dt => l_appl_inst_rec.offer_response_dt,
x_prpsd_commencement_dt => l_appl_inst_rec.prpsd_commencement_dt,
x_adm_cndtnl_offer_status => l_appl_inst_rec.adm_cndtnl_offer_status,
x_cndtnl_offer_satisfied_dt => l_appl_inst_rec.cndtnl_offer_satisfied_dt,
x_cndnl_ofr_must_be_stsfd_ind => l_appl_inst_rec.cndtnl_offer_must_be_stsfd_ind,
x_adm_offer_resp_status => l_appl_inst_rec.adm_offer_resp_status,
x_actual_response_dt => l_appl_inst_rec.actual_response_dt,
x_adm_offer_dfrmnt_status => l_appl_inst_rec.adm_offer_dfrmnt_status,
x_deferred_adm_cal_type => l_appl_inst_rec.deferred_adm_cal_type,
x_deferred_adm_ci_sequence_num => l_appl_inst_rec.deferred_adm_ci_sequence_num,
x_deferred_tracking_id => l_appl_inst_rec.deferred_tracking_id,
x_ass_rank => l_appl_inst_rec.ass_rank,
x_secondary_ass_rank => l_appl_inst_rec.secondary_ass_rank,
x_intr_accept_advice_num => l_appl_inst_rec.intrntnl_acceptance_advice_num,
x_ass_tracking_id => l_appl_inst_rec.ass_tracking_id,
x_fee_cat => l_appl_inst_rec.fee_cat,
x_hecs_payment_option => l_appl_inst_rec.hecs_payment_option,
x_expected_completion_yr => l_appl_inst_rec.expected_completion_yr,
x_expected_completion_perd => l_appl_inst_rec.expected_completion_perd,
x_correspondence_cat => l_appl_inst_rec.correspondence_cat,
x_enrolment_cat => l_appl_inst_rec.enrolment_cat,
x_funding_source => l_appl_inst_rec.funding_source,
x_applicant_acptnce_cndtn => l_appl_inst_rec.applicant_acptnce_cndtn,
x_cndtnl_offer_cndtn => l_appl_inst_rec.cndtnl_offer_cndtn,
x_ss_application_id => l_appl_inst_rec.ss_application_id,
x_ss_pwd => l_appl_inst_rec.ss_pwd,
x_authorized_dt => l_appl_inst_rec.authorized_dt,
x_authorizing_pers_id => l_appl_inst_rec.authorizing_pers_id,
x_entry_status => l_appl_inst_rec.entry_status,
x_entry_level => l_appl_inst_rec.entry_level,
x_sch_apl_to_id => l_appl_inst_rec.sch_apl_to_id,
x_idx_calc_date => l_calculation_date,
X_FUT_ACAD_CAL_TYPE => l_appl_inst_rec.FUTURE_ACAD_CAL_TYPE, -- Bug # 2217104
X_FUT_ACAD_CI_SEQUENCE_NUMBER => l_appl_inst_rec.FUTURE_ACAD_CI_SEQUENCE_NUMBER,-- Bug # 2217104
X_FUT_ADM_CAL_TYPE => l_appl_inst_rec.FUTURE_ADM_CAL_TYPE, -- Bug # 2217104
X_FUT_ADM_CI_SEQUENCE_NUMBER => l_appl_inst_rec.FUTURE_ADM_CI_SEQUENCE_NUMBER, -- Bug # 2217104
X_PREV_TERM_ADM_APPL_NUMBER => l_appl_inst_rec.PREVIOUS_TERM_ADM_APPL_NUMBER, -- Bug # 2217104
X_PREV_TERM_SEQUENCE_NUMBER => l_appl_inst_rec.PREVIOUS_TERM_SEQUENCE_NUMBER, -- Bug # 2217104
X_FUT_TERM_ADM_APPL_NUMBER => l_appl_inst_rec.FUTURE_TERM_ADM_APPL_NUMBER, -- Bug # 2217104
X_FUT_TERM_SEQUENCE_NUMBER => l_appl_inst_rec.FUTURE_TERM_SEQUENCE_NUMBER, -- Bug # 2217104
X_DEF_ACAD_CAL_TYPE => l_appl_inst_rec.DEF_ACAD_CAL_TYPE, --Bug 2395510
X_DEF_ACAD_CI_SEQUENCE_NUM => l_appl_inst_rec.DEF_ACAD_CI_SEQUENCE_NUM, --Bug 2395510
X_DEF_PREV_TERM_ADM_APPL_NUM => l_appl_inst_rec.DEF_PREV_TERM_ADM_APPL_NUM,--Bug 2395510
X_DEF_PREV_APPL_SEQUENCE_NUM => l_appl_inst_rec.DEF_PREV_APPL_SEQUENCE_NUM,--Bug 2395510
X_DEF_TERM_ADM_APPL_NUM => l_appl_inst_rec.DEF_TERM_ADM_APPL_NUM,--Bug 2395510
X_DEF_APPL_SEQUENCE_NUM => l_appl_inst_rec.DEF_APPL_SEQUENCE_NUM,--Bug 2395510
x_mode => 'R',
x_attribute21 => l_appl_inst_rec.attribute21,
x_attribute22 => l_appl_inst_rec.attribute22,
x_attribute23 => l_appl_inst_rec.attribute23,
x_attribute24 => l_appl_inst_rec.attribute24,
x_attribute25 => l_appl_inst_rec.attribute25,
x_attribute26 => l_appl_inst_rec.attribute26,
x_attribute27 => l_appl_inst_rec.attribute27,
x_attribute28 => l_appl_inst_rec.attribute28,
x_attribute29 => l_appl_inst_rec.attribute29,
x_attribute30 => l_appl_inst_rec.attribute30,
x_attribute31 => l_appl_inst_rec.attribute31,
x_attribute32 => l_appl_inst_rec.attribute32,
x_attribute33 => l_appl_inst_rec.attribute33,
x_attribute34 => l_appl_inst_rec.attribute34,
x_attribute35 => l_appl_inst_rec.attribute35,
x_attribute36 => l_appl_inst_rec.attribute36,
x_attribute37 => l_appl_inst_rec.attribute37,
x_attribute38 => l_appl_inst_rec.attribute38,
x_attribute39 => l_appl_inst_rec.attribute39,
x_attribute40 => l_appl_inst_rec.attribute40,
X_APPL_INST_STATUS => l_appl_inst_rec.appl_inst_status,
x_ais_reason => l_appl_inst_rec.ais_reason,
x_decline_ofr_reason => l_appl_inst_rec.decline_ofr_reason
);
SELECT a.ROWID, a.*
FROM IGS_AD_APPL a
WHERE person_id = p_person_id
AND admission_appl_number = p_admission_appl_number;
SELECT a.ROWID, a.*, b.req_for_reconsideration_ind
FROM igs_ad_ps_appl_inst a, IGS_AD_PS_APPL b
WHERE a.person_id = p_person_id
AND a.admission_appl_number = p_admission_appl_number
AND a.nominated_course_cd = p_nominated_program_cd
AND a.sequence_number = p_sequence_number
AND a.person_id = b.person_id
AND a.admission_appl_number = b.admission_appl_number
AND a.nominated_course_cd = b.nominated_course_cd;
SELECT a.*
FROM igs_ad_ps_appl a
WHERE person_id = p_person_id
AND admission_appl_number = p_admission_appl_number
AND nominated_course_cd = p_nominated_program_cd;
SELECT 'X'
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 = 'RECONSIDER';
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 a.adm_offer_resp_status
FROM igs_ad_ps_appl_inst a
WHERE person_id = p_person_id
AND admission_appl_number = p_admission_appl_number
AND nominated_course_cd = p_nominated_program_cd
AND sequence_number = p_sequence_number;
SELECT party_id FROM hz_parties WHERE party_number = cp_party_number;
IF IGS_AD_VAL_AA.admp_val_aa_update (
l_c_appl_cur.adm_appl_status,
v_message_name) = FALSE AND l_reconsider_flag = 'N' THEN
FND_MESSAGE.SET_NAME('IGS',v_message_name);
igs_ad_ps_appl_pkg.update_row(x_rowid => l_c_ps_appl_cur.row_id,
x_person_id => l_c_ps_appl_cur.person_id,
x_admission_appl_number => l_c_ps_appl_cur.admission_appl_number,
x_nominated_course_cd => l_c_ps_appl_cur.nominated_course_cd,
x_transfer_course_cd => l_c_ps_appl_cur.transfer_course_cd,
x_basis_for_admission_type => l_c_ps_appl_cur.basis_for_admission_type,
x_admission_cd => l_c_ps_appl_cur.admission_cd,
x_course_rank_set => l_c_ps_appl_cur.course_rank_set,
x_course_rank_schedule => l_c_ps_appl_cur.course_rank_schedule,
x_req_for_reconsideration_ind => 'Y',
x_req_for_adv_standing_ind => l_c_ps_appl_cur.req_for_adv_standing_ind,
x_mode => 'R');
igs_ad_ps_appl_pkg.update_row(x_rowid => l_c_ps_appl_cur.row_id,
x_person_id => l_c_ps_appl_cur.person_id,
x_admission_appl_number => l_c_ps_appl_cur.admission_appl_number,
x_nominated_course_cd => l_c_ps_appl_cur.nominated_course_cd,
x_transfer_course_cd => l_c_ps_appl_cur.transfer_course_cd,
x_basis_for_admission_type => l_c_ps_appl_cur.basis_for_admission_type,
x_admission_cd => l_c_ps_appl_cur.admission_cd,
x_course_rank_set => l_c_ps_appl_cur.course_rank_set,
x_course_rank_schedule => l_c_ps_appl_cur.course_rank_schedule,
x_req_for_reconsideration_ind => 'N',
x_req_for_adv_standing_ind => l_c_ps_appl_cur.req_for_adv_standing_ind,
x_mode => 'R');
igs_ad_ps_appl_inst_pkg.update_row(x_rowid => l_c_aplinst_cur.ROWID,
x_person_id => l_c_aplinst_cur.person_id,
x_admission_appl_number => l_c_aplinst_cur.admission_appl_number,
x_nominated_course_cd => l_c_aplinst_cur.nominated_course_cd,
x_sequence_number => l_c_aplinst_cur.sequence_number,
x_predicted_gpa => l_c_aplinst_cur.predicted_gpa,
x_academic_index => l_c_aplinst_cur.academic_index,
x_adm_cal_type => l_c_aplinst_cur.adm_cal_type,
x_app_file_location => l_c_aplinst_cur.app_file_location,
x_adm_ci_sequence_number => l_c_aplinst_cur.adm_ci_sequence_number,
x_course_cd => l_c_aplinst_cur.course_cd,
x_app_source_id => l_c_aplinst_cur.app_source_id,
x_crv_version_number => l_c_aplinst_cur.crv_version_number,
x_waitlist_rank => l_c_aplinst_cur.waitlist_rank,
x_waitlist_status => l_c_aplinst_cur.waitlist_status,
x_location_cd => l_c_aplinst_cur.location_cd,
x_attent_other_inst_cd => l_c_aplinst_cur.attent_other_inst_cd,
x_attendance_mode => l_c_aplinst_cur.attendance_mode,
x_edu_goal_prior_enroll_id => l_c_aplinst_cur.edu_goal_prior_enroll_id,
x_attendance_type => l_c_aplinst_cur.attendance_type,
x_decision_make_id => l_decision_make_id,
x_unit_set_cd => l_c_aplinst_cur.unit_set_cd,
x_decision_date => l_decision_date,
x_attribute_category => l_c_aplinst_cur.attribute_category,
x_attribute1 => l_c_aplinst_cur.attribute1,
x_attribute2 => l_c_aplinst_cur.attribute2,
x_attribute3 => l_c_aplinst_cur.attribute3,
x_attribute4 => l_c_aplinst_cur.attribute4,
x_attribute5 => l_c_aplinst_cur.attribute5,
x_attribute6 => l_c_aplinst_cur.attribute6,
x_attribute7 => l_c_aplinst_cur.attribute7,
x_attribute8 => l_c_aplinst_cur.attribute8,
x_attribute9 => l_c_aplinst_cur.attribute9,
x_attribute10 => l_c_aplinst_cur.attribute10,
x_attribute11 => l_c_aplinst_cur.attribute11,
x_attribute12 => l_c_aplinst_cur.attribute12,
x_attribute13 => l_c_aplinst_cur.attribute13,
x_attribute14 => l_c_aplinst_cur.attribute14,
x_attribute15 => l_c_aplinst_cur.attribute15,
x_attribute16 => l_c_aplinst_cur.attribute16,
x_attribute17 => l_c_aplinst_cur.attribute17,
x_attribute18 => l_c_aplinst_cur.attribute18,
x_attribute19 => l_c_aplinst_cur.attribute19,
x_attribute20 => l_c_aplinst_cur.attribute20,
x_decision_reason_id => l_decision_reason_id,
x_us_version_number => l_c_aplinst_cur.us_version_number,
x_decision_notes => l_c_aplinst_cur.decision_notes,
x_pending_reason_id => l_pending_reason_id,
x_preference_number => l_c_aplinst_cur.preference_number,
x_adm_doc_status => l_c_aplinst_cur.adm_doc_status,
x_adm_entry_qual_status => l_c_aplinst_cur.adm_entry_qual_status,
x_deficiency_in_prep => l_c_aplinst_cur.deficiency_in_prep,
x_late_adm_fee_status => l_c_aplinst_cur.late_adm_fee_status,
x_spl_consider_comments => l_c_aplinst_cur.spl_consider_comments,
x_apply_for_finaid => l_c_aplinst_cur.apply_for_finaid,
x_finaid_apply_date => l_c_aplinst_cur.finaid_apply_date,
x_adm_outcome_status => l_adm_outcome_status,
x_adm_otcm_stat_auth_per_id => l_adm_otcm_status_auth_per_id,
x_adm_outcome_status_auth_dt => l_adm_outcome_status_auth_dt,
x_adm_outcome_status_reason => l_adm_outcome_status_reason,
x_offer_dt => l_offer_dt,
x_offer_response_dt => l_offer_response_dt,
x_prpsd_commencement_dt => l_prpsd_commencement_date,
x_adm_cndtnl_offer_status => l_adm_cndtl_offer_status,
x_cndtnl_offer_satisfied_dt => l_cndtnl_offer_satisfied_dt,
x_cndnl_ofr_must_be_stsfd_ind => l_cndtl_offer_must_stsfd_ind,
x_adm_offer_resp_status => l_adm_offer_resp_status,
x_actual_response_dt => l_actual_response_dt,
x_adm_offer_dfrmnt_status => l_c_aplinst_cur.adm_offer_dfrmnt_status,
x_deferred_adm_cal_type => l_c_aplinst_cur.deferred_adm_cal_type,
x_deferred_adm_ci_sequence_num => l_c_aplinst_cur.deferred_adm_ci_sequence_num,
x_deferred_tracking_id => l_c_aplinst_cur.deferred_tracking_id,
x_ass_rank => l_c_aplinst_cur.ass_rank,
x_secondary_ass_rank => l_c_aplinst_cur.secondary_ass_rank,
x_intr_accept_advice_num => l_c_aplinst_cur.intrntnl_acceptance_advice_num,
x_ass_tracking_id => l_c_aplinst_cur.ass_tracking_id,
x_fee_cat => l_c_aplinst_cur.fee_cat,
x_hecs_payment_option => l_c_aplinst_cur.hecs_payment_option,
x_expected_completion_yr => l_c_aplinst_cur.expected_completion_yr,
x_expected_completion_perd => l_c_aplinst_cur.expected_completion_perd,
x_correspondence_cat => l_c_aplinst_cur.correspondence_cat,
x_enrolment_cat => l_c_aplinst_cur.enrolment_cat,
x_funding_source => l_c_aplinst_cur.funding_source,
x_applicant_acptnce_cndtn => l_c_aplinst_cur.applicant_acptnce_cndtn,
x_cndtnl_offer_cndtn => l_cndtnl_offer_cndtn,
x_ss_application_id => l_c_aplinst_cur.ss_application_id,
x_ss_pwd => l_c_aplinst_cur.ss_pwd,
x_authorized_dt => l_c_aplinst_cur.authorized_dt,
x_authorizing_pers_id => l_c_aplinst_cur.authorizing_pers_id,
x_entry_status => l_c_aplinst_cur.entry_status,
x_entry_level => l_c_aplinst_cur.entry_level,
x_sch_apl_to_id => l_c_aplinst_cur.sch_apl_to_id,
x_idx_calc_date => l_c_aplinst_cur.idx_calc_date,
x_fut_acad_cal_type => l_c_aplinst_cur.future_acad_cal_type, -- bug # 2217104
x_fut_acad_ci_sequence_number => l_c_aplinst_cur.future_acad_ci_sequence_number, -- bug # 2217104
x_fut_adm_cal_type => l_c_aplinst_cur.future_adm_cal_type, -- bug # 2217104
x_fut_adm_ci_sequence_number => l_c_aplinst_cur.future_adm_ci_sequence_number, -- bug # 2217104
x_prev_term_adm_appl_number => l_c_aplinst_cur.previous_term_adm_appl_number, -- bug # 2217104
x_prev_term_sequence_number => l_c_aplinst_cur.previous_term_sequence_number, -- bug # 2217104
x_fut_term_adm_appl_number => l_c_aplinst_cur.future_term_adm_appl_number, -- bug # 2217104
x_fut_term_sequence_number => l_c_aplinst_cur.future_term_sequence_number, -- bug # 2217104
X_DEF_ACAD_CAL_TYPE => l_c_aplinst_cur.DEF_ACAD_CAL_TYPE, --Bug 2395510
X_DEF_ACAD_CI_SEQUENCE_NUM => l_c_aplinst_cur.DEF_ACAD_CI_SEQUENCE_NUM, --Bug 2395510
X_DEF_PREV_TERM_ADM_APPL_NUM => l_c_aplinst_cur.DEF_PREV_TERM_ADM_APPL_NUM, --Bug 2395510
X_DEF_PREV_APPL_SEQUENCE_NUM => l_c_aplinst_cur.DEF_PREV_APPL_SEQUENCE_NUM, --Bug 2395510
X_DEF_TERM_ADM_APPL_NUM => l_c_aplinst_cur.DEF_TERM_ADM_APPL_NUM, --Bug 2395510
X_DEF_APPL_SEQUENCE_NUM => l_c_aplinst_cur.DEF_APPL_SEQUENCE_NUM, --Bug 2395510
x_mode => 'R',
x_attribute21 => l_c_aplinst_cur.attribute21,
x_attribute22 => l_c_aplinst_cur.attribute22,
x_attribute23 => l_c_aplinst_cur.attribute23,
x_attribute24 => l_c_aplinst_cur.attribute24,
x_attribute25 => l_c_aplinst_cur.attribute25,
x_attribute26 => l_c_aplinst_cur.attribute26,
x_attribute27 => l_c_aplinst_cur.attribute27,
x_attribute28 => l_c_aplinst_cur.attribute28,
x_attribute29 => l_c_aplinst_cur.attribute29,
x_attribute30 => l_c_aplinst_cur.attribute30,
x_attribute31 => l_c_aplinst_cur.attribute31,
x_attribute32 => l_c_aplinst_cur.attribute32,
x_attribute33 => l_c_aplinst_cur.attribute33,
x_attribute34 => l_c_aplinst_cur.attribute34,
x_attribute35 => l_c_aplinst_cur.attribute35,
x_attribute36 => l_c_aplinst_cur.attribute36,
x_attribute37 => l_c_aplinst_cur.attribute37,
x_attribute38 => l_c_aplinst_cur.attribute38,
x_attribute39 => l_c_aplinst_cur.attribute39,
x_attribute40 => l_c_aplinst_cur.attribute40,
X_APPL_INST_STATUS => l_c_aplinst_cur.appl_inst_status,
x_ais_reason => l_c_aplinst_cur.ais_reason,
x_decline_ofr_reason => l_c_aplinst_cur.decline_ofr_reason
);
SELECT appl.*
FROM igs_ad_appl_all appl
WHERE person_id = cp_person_id AND
admission_appl_number = cp_admission_appl_number;
SELECT aplinst.rowid, aplinst.*
FROM igs_ad_ps_appl_inst_all aplinst
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 s_admission_step_type,
step_type_restriction_num
FROM igs_ad_prcs_cat_step
WHERE admission_cat = cp_admission_cat AND
s_admission_process_type = cp_s_admission_process_type AND
step_group_type <> 'TRACK' ;
/* This validation is not needed now as offer reponse is always updateable as per Re-Open ADFD001
--Validations to check if Application Processing Status is OPEN or not
IF igs_ad_gen_007.admp_get_saas(l_appl_rec.adm_appl_status) IN (cst_completed, cst_withdrawn) THEN
p_validation_success := 'N';
IF igs_ad_val_acai_status.admp_val_aods_update(p_person_id,
p_admission_appl_number,
p_nominated_course_cd,
p_sequence_number,
p_adm_offer_defr_status,
v_message_name) = FALSE THEN
p_validation_success := 'N';
SELECT rowid , igs_ad_ps_appl_inst.* from igs_ad_ps_appl_inst
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_no;
IGS_AD_PS_APPL_INST_PKG.UPDATE_ROW (
X_Mode => 'R',
X_RowId => cur_ad_ps_appl_inst_rec.row_id,
X_Person_Id => cur_ad_ps_appl_inst_rec.Person_Id,
X_Admission_Appl_Number => cur_ad_ps_appl_inst_rec.Admission_Appl_Number,
X_Nominated_Course_Cd => cur_ad_ps_appl_inst_rec.Nominated_Course_Cd,
X_Sequence_Number => cur_ad_ps_appl_inst_rec.Sequence_Number,
X_Predicted_Gpa => cur_ad_ps_appl_inst_rec.Predicted_Gpa,
X_Academic_Index => cur_ad_ps_appl_inst_rec.Academic_Index,
X_Adm_Cal_Type => cur_ad_ps_appl_inst_rec.Adm_Cal_Type,
X_App_File_Location => cur_ad_ps_appl_inst_rec.App_File_Location,
X_Adm_Ci_Sequence_Number => cur_ad_ps_appl_inst_rec.Adm_Ci_Sequence_Number,
X_Course_Cd => cur_ad_ps_appl_inst_rec.Course_Cd,
X_App_Source_Id => cur_ad_ps_appl_inst_rec.App_Source_Id,
X_Crv_Version_Number => cur_ad_ps_appl_inst_rec.Crv_Version_Number,
X_Waitlist_Rank => cur_ad_ps_appl_inst_rec.Waitlist_Rank,
X_Location_Cd => cur_ad_ps_appl_inst_rec.Location_Cd,
X_Attent_Other_Inst_Cd => l_attent_other_inst_cd, --
X_Attendance_Mode => cur_ad_ps_appl_inst_rec.Attendance_Mode,
X_Edu_Goal_Prior_Enroll_Id => cur_ad_ps_appl_inst_rec.Edu_Goal_Prior_Enroll_Id,
X_Attendance_Type => cur_ad_ps_appl_inst_rec.Attendance_Type,
X_Decision_Make_Id => cur_ad_ps_appl_inst_rec.Decision_Make_Id,
X_Unit_Set_Cd => cur_ad_ps_appl_inst_rec.Unit_Set_Cd,
X_Decision_Date => cur_ad_ps_appl_inst_rec.Decision_Date,
X_Attribute_Category => cur_ad_ps_appl_inst_rec.Attribute_Category,
X_Attribute1 => cur_ad_ps_appl_inst_rec.Attribute1,
X_Attribute2 => cur_ad_ps_appl_inst_rec.Attribute2,
X_Attribute3 => cur_ad_ps_appl_inst_rec.Attribute3,
X_Attribute4 => cur_ad_ps_appl_inst_rec.Attribute4,
X_Attribute5 => cur_ad_ps_appl_inst_rec.Attribute5,
X_Attribute6 => cur_ad_ps_appl_inst_rec.Attribute6,
X_Attribute7 => cur_ad_ps_appl_inst_rec.Attribute7,
X_Attribute8 => cur_ad_ps_appl_inst_rec.Attribute8,
X_Attribute9 => cur_ad_ps_appl_inst_rec.Attribute9,
X_Attribute10 => cur_ad_ps_appl_inst_rec.Attribute10,
X_Attribute11 => cur_ad_ps_appl_inst_rec.Attribute11,
X_Attribute12 => cur_ad_ps_appl_inst_rec.Attribute12,
X_Attribute13 => cur_ad_ps_appl_inst_rec.Attribute13,
X_Attribute14 => cur_ad_ps_appl_inst_rec.Attribute14,
X_Attribute15 => cur_ad_ps_appl_inst_rec.Attribute15,
X_Attribute16 => cur_ad_ps_appl_inst_rec.Attribute16,
X_Attribute17 => cur_ad_ps_appl_inst_rec.Attribute17,
X_Attribute18 => cur_ad_ps_appl_inst_rec.Attribute18,
X_Attribute19 => cur_ad_ps_appl_inst_rec.Attribute19,
X_Attribute20 => cur_ad_ps_appl_inst_rec.Attribute20,
X_Decision_Reason_Id => cur_ad_ps_appl_inst_rec.decision_reason_id,
X_Us_Version_Number => cur_ad_ps_appl_inst_rec.Us_Version_Number,
X_Decision_Notes => cur_ad_ps_appl_inst_rec.Decision_Notes,
X_Pending_Reason_Id => cur_ad_ps_appl_inst_rec.Pending_Reason_Id,
X_Preference_Number => cur_ad_ps_appl_inst_rec.Preference_Number,
X_Adm_Doc_Status => cur_ad_ps_appl_inst_rec.Adm_Doc_Status,
X_Adm_Entry_Qual_Status => cur_ad_ps_appl_inst_rec.Adm_Entry_Qual_Status,
X_Deficiency_In_Prep => cur_ad_ps_appl_inst_rec.Deficiency_In_Prep,
X_Late_Adm_Fee_Status => cur_ad_ps_appl_inst_rec.Late_Adm_Fee_Status,
X_Spl_Consider_Comments => cur_ad_ps_appl_inst_rec.Spl_Consider_Comments,
X_Apply_For_Finaid => cur_ad_ps_appl_inst_rec.Apply_For_Finaid,
X_Finaid_Apply_Date => cur_ad_ps_appl_inst_rec.Finaid_Apply_Date,
X_Adm_Outcome_Status => cur_ad_ps_appl_inst_rec.Adm_Outcome_Status,
X_Adm_Otcm_Stat_Auth_Per_Id => cur_ad_ps_appl_inst_rec.Adm_Otcm_Status_Auth_Person_Id,
X_Adm_Outcome_Status_Auth_Dt => cur_ad_ps_appl_inst_rec.Adm_Outcome_Status_Auth_Dt,
X_Adm_Outcome_Status_Reason => cur_ad_ps_appl_inst_rec.Adm_Outcome_Status_Reason,
X_Offer_Dt => cur_ad_ps_appl_inst_rec.Offer_Dt,
X_Offer_Response_Dt => cur_ad_ps_appl_inst_rec.Offer_Response_Dt,
X_Prpsd_Commencement_Dt => cur_ad_ps_appl_inst_rec.Prpsd_Commencement_Dt,
X_Adm_Cndtnl_Offer_Status => cur_ad_ps_appl_inst_rec.Adm_Cndtnl_Offer_Status,
X_Cndtnl_Offer_Satisfied_Dt => cur_ad_ps_appl_inst_rec.Cndtnl_Offer_Satisfied_Dt,
X_Cndnl_Ofr_Must_Be_Stsfd_Ind => cur_ad_ps_appl_inst_rec.Cndtnl_Offer_Must_Be_Stsfd_Ind,
X_Adm_Offer_Resp_Status => p_adm_offer_resp_status, -- Updated field
X_Actual_Response_Dt => l_calc_actual_response_dt, --Updated field
X_Adm_Offer_Dfrmnt_Status => l_adm_offer_dfrmnt_status, --Updated Field
X_Deferred_Adm_Cal_Type => l_def_adm_cal_type, --Updated Field
X_Deferred_Adm_Ci_Sequence_Num => l_def_adm_ci_sequence_num, --Updated field
X_Deferred_Tracking_Id => NULL,
X_Ass_Rank => cur_ad_ps_appl_inst_rec.Ass_Rank,
X_Secondary_Ass_Rank => cur_ad_ps_appl_inst_rec.Secondary_Ass_Rank,
X_Intr_Accept_Advice_Num => cur_ad_ps_appl_inst_rec.Intrntnl_Acceptance_Advice_Num,
X_Ass_Tracking_Id => cur_ad_ps_appl_inst_rec.Ass_Tracking_Id,
X_Fee_Cat => cur_ad_ps_appl_inst_rec.Fee_Cat,
X_Hecs_Payment_Option => cur_ad_ps_appl_inst_rec.Hecs_Payment_Option,
X_Expected_Completion_Yr => cur_ad_ps_appl_inst_rec.Expected_Completion_Yr,
X_Expected_Completion_Perd => cur_ad_ps_appl_inst_rec.Expected_Completion_Perd,
X_Correspondence_Cat => cur_ad_ps_appl_inst_rec.Correspondence_Cat,
X_Enrolment_Cat => cur_ad_ps_appl_inst_rec.Enrolment_Cat,
X_Funding_Source => cur_ad_ps_appl_inst_rec.Funding_Source,
X_Applicant_Acptnce_Cndtn => l_response_comments, --Updated Field
X_Cndtnl_Offer_Cndtn => cur_ad_ps_appl_inst_rec.Cndtnl_Offer_Cndtn,
X_SS_APPLICATION_ID => NULL,
X_SS_PWD => NULL ,
X_AUTHORIZED_DT => cur_ad_ps_appl_inst_rec.authorized_dt,--
X_AUTHORIZING_PERS_ID => cur_ad_ps_appl_inst_rec.authorizing_pers_id,--
X_ENTRY_STATUS => cur_ad_ps_appl_inst_rec.entry_status,
X_ENTRY_LEVEL => cur_ad_ps_appl_inst_rec.entry_level,
X_SCH_APL_TO_ID => cur_ad_ps_appl_inst_rec.sch_apl_to_id,
X_IDX_CALC_DATE => cur_ad_ps_appl_inst_rec.IDX_CALC_DATE,
X_WAITLIST_STATUS => cur_ad_ps_appl_inst_rec.Waitlist_Status,
X_Attribute21 => cur_ad_ps_appl_inst_rec.Attribute21,
X_Attribute22 => cur_ad_ps_appl_inst_rec.Attribute22,
X_Attribute23 => cur_ad_ps_appl_inst_rec.Attribute23,
X_Attribute24 => cur_ad_ps_appl_inst_rec.Attribute24,
X_Attribute25 => cur_ad_ps_appl_inst_rec.Attribute25,
X_Attribute26 => cur_ad_ps_appl_inst_rec.Attribute26,
X_Attribute27 => cur_ad_ps_appl_inst_rec.Attribute27,
X_Attribute28 => cur_ad_ps_appl_inst_rec.Attribute28,
X_Attribute29 => cur_ad_ps_appl_inst_rec.Attribute29,
X_Attribute30 => cur_ad_ps_appl_inst_rec.Attribute30,
X_Attribute31 => cur_ad_ps_appl_inst_rec.Attribute31,
X_Attribute32 => cur_ad_ps_appl_inst_rec.Attribute32,
X_Attribute33 => cur_ad_ps_appl_inst_rec.Attribute33,
X_Attribute34 => cur_ad_ps_appl_inst_rec.Attribute34,
X_Attribute35 => cur_ad_ps_appl_inst_rec.Attribute35,
X_Attribute36 => cur_ad_ps_appl_inst_rec.Attribute36,
X_Attribute37 => cur_ad_ps_appl_inst_rec.Attribute37,
X_Attribute38 => cur_ad_ps_appl_inst_rec.Attribute38,
X_Attribute39 => cur_ad_ps_appl_inst_rec.Attribute39,
X_Attribute40 => cur_ad_ps_appl_inst_rec.Attribute40,
x_fut_acad_cal_type => cur_ad_ps_appl_inst_rec.future_acad_cal_type,
x_fut_acad_ci_sequence_number => cur_ad_ps_appl_inst_rec.future_acad_ci_sequence_number,
x_fut_adm_cal_type => cur_ad_ps_appl_inst_rec.future_adm_cal_type,
x_fut_adm_ci_sequence_number => cur_ad_ps_appl_inst_rec.future_adm_ci_sequence_number,
x_prev_term_adm_appl_number => cur_ad_ps_appl_inst_rec.previous_term_adm_appl_number,
x_prev_term_sequence_number => cur_ad_ps_appl_inst_rec.previous_term_sequence_number,
x_fut_term_adm_appl_number => cur_ad_ps_appl_inst_rec.future_term_adm_appl_number,
x_fut_term_sequence_number => cur_ad_ps_appl_inst_rec.future_term_sequence_number,
x_def_acad_cal_type => l_def_acad_cal_type,--Updated field
x_def_acad_ci_sequence_num => l_def_acad_ci_sequence_num,--Updated field
x_def_prev_term_adm_appl_num => cur_ad_ps_appl_inst_rec.def_prev_term_adm_appl_num,
x_def_prev_appl_sequence_num => cur_ad_ps_appl_inst_rec.def_prev_appl_sequence_num,
x_def_term_adm_appl_num => cur_ad_ps_appl_inst_rec.def_term_adm_appl_num,
x_def_appl_sequence_num => cur_ad_ps_appl_inst_rec.def_appl_sequence_num,
x_decline_ofr_reason => l_decline_ofr_reason,
X_APPL_INST_STATUS => cur_ad_ps_appl_inst_rec.appl_inst_status,
x_ais_reason => cur_ad_ps_appl_inst_rec.ais_reason
);
SELECT
a.*
FROM
igs_ad_ps_appl_inst a,
igs_ad_ou_stat c
WHERE a.person_id = p_person_id
AND a.admission_appl_number = p_admission_appl_number
AND a.nominated_course_cd = p_nominated_course_cd
AND a.sequence_number = p_sequence_number
AND a.adm_outcome_status = c.adm_outcome_status
AND c.s_adm_outcome_status = 'PENDING';
SELECT ac.rowid,ac.* FROM IGS_AD_APPQUAL_CODE ac WHERE
PERSON_ID = p_person_id
AND ADMISSION_APPL_NUMBER = p_admission_appl_number
AND NOMINATED_COURSE_CD = p_nominated_course_cd
AND SEQUENCE_NUMBER = p_sequence_number
AND qualifying_type_code = p_qualfying_type;
SELECT code_id FROM IGS_AD_CODE_CLASSES ac WHERE
UPPER(ac.NAME)=UPPER(cp_qual_code) AND ac.CLASS_TYPE_CODE='IGS_AD_QUAL_TYPE'
AND UPPER(ac.CLASS) = UPPER(cp_qual_type_code);
igs_ad_appqual_code_pkg.UPDATE_ROW(
x_rowid => l_qualtype.rowid,
x_person_id => p_person_id,
x_admission_appl_number => p_admission_appl_number,
x_nominated_course_cd => p_nominated_course_cd,
x_sequence_number => p_sequence_number,
x_qualifying_type_code => l_qualifying_type_code,
x_qualifying_code_id => l_code_id,
x_qualifying_value => l_qualifying_value,
x_mode => 'R'
);
PROCEDURE UPDATE_ENTRY_QUAL_STATUS(
--Standard Parameters Start
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
--Standard parameter ends
p_person_id IN NUMBER,
p_admission_appl_number IN NUMBER,
p_nominated_program_cd IN VARCHAR2,
p_sequence_number IN NUMBER,
p_entry_qual_status IN VARCHAR2
)
AS
-- Declaration of the location variables
l_api_version CONSTANT NUMBER := '1.0';
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ENTRY_QUAL_STATUS';
SELECT aplinst.*, aplinst.rowid
FROM igs_ad_ps_appl_inst aplinst
WHERE aplinst.person_id = cp_person_id
AND aplinst.admission_appl_number = cp_admission_appl_number
AND aplinst.nominated_course_cd = cp_nominated_course_cd
AND aplinst.sequence_number = cp_sequence_number;
SELECT appl.s_admission_process_type
FROM igs_ad_appl_all appl
WHERE appl.person_id = cp_person_id
AND appl.admission_appl_number = cp_admission_appl_number;
SAVEPOINT UPDATE_ENTRY_QUAL_STATUS_SAVE;
igs_ad_ps_appl_inst_pkg.UPDATE_ROW (
X_Mode => 'S',
X_RowId => l_appl_inst_rec.rowId,
X_Person_Id => p_person_id,
X_Admission_Appl_Number => p_admission_appl_number,
X_Nominated_Course_Cd => p_nominated_program_cd,
X_Sequence_Number => p_sequence_number,
X_Predicted_Gpa => l_appl_inst_rec.Predicted_Gpa,
X_Academic_Index => l_appl_inst_rec.Academic_Index,
X_Adm_Cal_Type => l_appl_inst_rec.Adm_Cal_Type,
X_App_File_Location => l_appl_inst_rec.App_File_Location,
X_Adm_Ci_Sequence_Number => l_appl_inst_rec.Adm_Ci_Sequence_Number,
X_Course_Cd => l_appl_inst_rec.Course_Cd,
X_App_Source_Id => l_appl_inst_rec.App_Source_Id,
X_Crv_Version_Number => l_appl_inst_rec.Crv_Version_Number,
X_Waitlist_Rank => l_appl_inst_rec.Waitlist_Rank,
X_Location_Cd => l_appl_inst_rec.Location_Cd,
X_Attent_Other_Inst_Cd => l_appl_inst_rec.Attent_Other_Inst_Cd,
X_Attendance_Mode => l_appl_inst_rec.Attendance_Mode,
X_Edu_Goal_Prior_Enroll_Id => l_appl_inst_rec.Edu_Goal_Prior_Enroll_Id,
X_Attendance_Type => l_appl_inst_rec.Attendance_Type,
X_Decision_Make_Id => l_appl_inst_rec.Decision_Make_Id,
X_Unit_Set_Cd => l_appl_inst_rec.Unit_Set_Cd,
X_Decision_Date => l_appl_inst_rec.Decision_Date,
X_Attribute_Category => l_appl_inst_rec.Attribute_Category,
X_Attribute1 => l_appl_inst_rec.Attribute1,
X_Attribute2 => l_appl_inst_rec.Attribute2,
X_Attribute3 => l_appl_inst_rec.Attribute3,
X_Attribute4 => l_appl_inst_rec.Attribute4,
X_Attribute5 => l_appl_inst_rec.Attribute5,
X_Attribute6 => l_appl_inst_rec.Attribute6,
X_Attribute7 => l_appl_inst_rec.Attribute7,
X_Attribute8 => l_appl_inst_rec.Attribute8,
X_Attribute9 => l_appl_inst_rec.Attribute9,
X_Attribute10 => l_appl_inst_rec.Attribute10,
X_Attribute11 => l_appl_inst_rec.Attribute11,
X_Attribute12 => l_appl_inst_rec.Attribute12,
X_Attribute13 => l_appl_inst_rec.Attribute13,
X_Attribute14 => l_appl_inst_rec.Attribute14,
X_Attribute15 => l_appl_inst_rec.Attribute15,
X_Attribute16 => l_appl_inst_rec.Attribute16,
X_Attribute17 => l_appl_inst_rec.Attribute17,
X_Attribute18 => l_appl_inst_rec.Attribute18,
X_Attribute19 => l_appl_inst_rec.Attribute19,
X_Attribute20 => l_appl_inst_rec.Attribute20,
X_Attribute21 => l_appl_inst_rec.Attribute21,
X_Attribute22 => l_appl_inst_rec.Attribute22,
X_Attribute23 => l_appl_inst_rec.Attribute23,
X_Attribute24 => l_appl_inst_rec.Attribute24,
X_Attribute25 => l_appl_inst_rec.Attribute25,
X_Attribute26 => l_appl_inst_rec.Attribute26,
X_Attribute27 => l_appl_inst_rec.Attribute27,
X_Attribute28 => l_appl_inst_rec.Attribute28,
X_Attribute29 => l_appl_inst_rec.Attribute29,
X_Attribute30 => l_appl_inst_rec.Attribute30,
X_Attribute31 => l_appl_inst_rec.Attribute31,
X_Attribute32 => l_appl_inst_rec.Attribute32,
X_Attribute33 => l_appl_inst_rec.Attribute33,
X_Attribute34 => l_appl_inst_rec.Attribute34,
X_Attribute35 => l_appl_inst_rec.Attribute35,
X_Attribute36 => l_appl_inst_rec.Attribute36,
X_Attribute37 => l_appl_inst_rec.Attribute37,
X_Attribute38 => l_appl_inst_rec.Attribute38,
X_Attribute39 => l_appl_inst_rec.Attribute39,
X_Attribute40 => l_appl_inst_rec.Attribute40,
X_Decision_Reason_Id => l_appl_inst_rec.Decision_Reason_Id,
X_Us_Version_Number => l_appl_inst_rec.Us_Version_Number,
X_Decision_Notes => l_appl_inst_rec.Decision_Notes,
X_Pending_Reason_Id => l_appl_inst_rec.Pending_Reason_Id,
X_Preference_Number => l_appl_inst_rec.Preference_Number,
X_Adm_Doc_Status => l_appl_inst_rec.Adm_Doc_Status,
X_Adm_Entry_Qual_Status => l_entry_qual_status,
X_Deficiency_In_Prep => l_appl_inst_rec.Deficiency_In_Prep,
X_Late_Adm_Fee_Status => l_appl_inst_rec.Late_Adm_Fee_Status,
X_Spl_Consider_Comments => l_appl_inst_rec.Spl_Consider_Comments,
X_Apply_For_Finaid => l_appl_inst_rec.Apply_For_Finaid,
X_Finaid_Apply_Date => l_appl_inst_rec.Finaid_Apply_Date,
X_Adm_Outcome_Status => l_appl_inst_rec.Adm_Outcome_Status,
X_Adm_Otcm_Stat_Auth_Per_Id => l_appl_inst_rec.adm_otcm_status_auth_person_id,
X_Adm_Outcome_Status_Auth_Dt => l_appl_inst_rec.Adm_Outcome_Status_Auth_Dt,
X_Adm_Outcome_Status_Reason => l_appl_inst_rec.Adm_Outcome_Status_Reason,
X_Offer_Dt => l_appl_inst_rec.Offer_Dt,
X_Offer_Response_Dt => l_appl_inst_rec.Offer_Response_Dt,
X_Prpsd_Commencement_Dt => l_appl_inst_rec.Prpsd_Commencement_Dt,
X_Adm_Cndtnl_Offer_Status => l_appl_inst_rec.Adm_Cndtnl_Offer_Status,
X_Cndtnl_Offer_Satisfied_Dt => l_appl_inst_rec.Cndtnl_Offer_Satisfied_Dt,
X_Cndnl_Ofr_Must_Be_Stsfd_Ind => l_appl_inst_rec.cndtnl_offer_must_be_stsfd_ind,
X_Adm_Offer_Resp_Status => l_appl_inst_rec.Adm_Offer_Resp_Status,
X_Actual_Response_Dt => l_appl_inst_rec.Actual_Response_Dt,
X_Adm_Offer_Dfrmnt_Status => l_appl_inst_rec.Adm_Offer_Dfrmnt_Status,
X_Deferred_Adm_Cal_Type => l_appl_inst_rec.Deferred_Adm_Cal_Type,
X_Deferred_Adm_Ci_Sequence_Num => l_appl_inst_rec.Deferred_Adm_Ci_Sequence_Num,
X_Deferred_Tracking_Id => l_appl_inst_rec.Deferred_Tracking_Id,
X_Ass_Rank => l_appl_inst_rec.Ass_Rank,
X_Secondary_Ass_Rank => l_appl_inst_rec.Secondary_Ass_Rank,
X_Intr_Accept_Advice_Num => l_appl_inst_rec.intrntnl_acceptance_advice_num,
X_Ass_Tracking_Id => l_appl_inst_rec.Ass_Tracking_Id,
X_Fee_Cat => l_appl_inst_rec.Fee_Cat,
X_Hecs_Payment_Option => l_appl_inst_rec.Hecs_Payment_Option,
X_Expected_Completion_Yr => l_appl_inst_rec.Expected_Completion_Yr,
X_Expected_Completion_Perd => l_appl_inst_rec.Expected_Completion_Perd,
X_Correspondence_Cat => l_appl_inst_rec.Correspondence_Cat,
X_Enrolment_Cat => l_appl_inst_rec.Enrolment_Cat,
X_Funding_Source => l_appl_inst_rec.Funding_Source,
X_Applicant_Acptnce_Cndtn => l_appl_inst_rec.Applicant_Acptnce_Cndtn,
X_Cndtnl_Offer_Cndtn => l_appl_inst_rec.Cndtnl_Offer_Cndtn,
X_SS_APPLICATION_ID => l_appl_inst_rec.SS_APPLICATION_ID,
X_SS_PWD => l_appl_inst_rec.SS_PWD,
X_AUTHORIZED_DT => l_appl_inst_rec.AUTHORIZED_DT,
X_AUTHORIZING_PERS_ID => l_appl_inst_rec.AUTHORIZING_PERS_ID,
X_ENTRY_STATUS => l_appl_inst_rec.ENTRY_STATUS,
X_ENTRY_LEVEL => l_appl_inst_rec.ENTRY_LEVEL,
X_SCH_APL_TO_ID => l_appl_inst_rec.SCH_APL_TO_ID,
X_IDX_CALC_DATE => l_appl_inst_rec.IDX_CALC_DATE,
X_WAITLIST_STATUS => l_appl_inst_rec.WAITLIST_STATUS,
x_fut_acad_cal_type => l_appl_inst_rec.future_acad_cal_type,
x_fut_acad_ci_sequence_number => l_appl_inst_rec.future_acad_ci_sequence_number,
x_fut_adm_cal_type => l_appl_inst_rec.future_adm_cal_type,
x_fut_adm_ci_sequence_number => l_appl_inst_rec.future_adm_ci_sequence_number,
x_prev_term_adm_appl_number => l_appl_inst_rec.previous_term_adm_appl_number,
x_prev_term_sequence_number => l_appl_inst_rec.previous_term_sequence_number,
x_fut_term_adm_appl_number => l_appl_inst_rec.future_term_adm_appl_number,
x_fut_term_sequence_number => l_appl_inst_rec.future_term_sequence_number,
x_def_acad_cal_type => l_appl_inst_rec.def_acad_cal_type,
x_def_acad_ci_sequence_num => l_appl_inst_rec.def_acad_ci_sequence_num,
x_def_prev_term_adm_appl_num => l_appl_inst_rec.def_prev_term_adm_appl_num,
x_def_prev_appl_sequence_num => l_appl_inst_rec.def_prev_appl_sequence_num,
x_def_term_adm_appl_num => l_appl_inst_rec.def_term_adm_appl_num,
x_def_appl_sequence_num => l_appl_inst_rec.def_appl_sequence_num,
x_appl_inst_status => l_appl_inst_rec.appl_inst_status,
x_ais_reason => l_appl_inst_rec.ais_reason,
x_decline_ofr_reason => l_appl_inst_rec.decline_ofr_reason);
ROLLBACK TO UPDATE_ENTRY_QUAL_STATUS_SAVE;
ROLLBACK TO UPDATE_ENTRY_QUAL_STATUS_SAVE;
ROLLBACK TO UPDATE_ENTRY_QUAL_STATUS_SAVE;
END UPDATE_ENTRY_QUAL_STATUS;