APPS.IGS_AD_GEN_011 dependencies on IGS_AD_PS_APPL_INST

Line 149: -- Routine to create a history for the IGS_AD_PS_APPL_INST table.

145: lv_old_update_on DATE := p_old_update_on;
146:
147:
148: BEGIN -- admp_ins_acai_hist
149: -- Routine to create a history for the IGS_AD_PS_APPL_INST table.
150: DECLARE
151: v_changed_flag BOOLEAN DEFAULT FALSE;
152: v_acaih_rec IGS_AD_PS_APLINSTHST%ROWTYPE;
153: lv_rowid VARCHAR2(25);

Line 188: -- Check if any of the old IGS_AD_PS_APPL_INST values are different from

184:
185: l_latest_hist_dt c_latest_hist_dt%ROWTYPE;
186:
187: BEGIN
188: -- Check if any of the old IGS_AD_PS_APPL_INST values are different from
189: -- the associated new IGS_AD_PS_APPL_INST values.
190: IF NVL(p_new_adm_cal_type,'NULL') <> NVL(p_old_adm_cal_type,'NULL') THEN
191: v_acaih_rec.adm_cal_type := p_old_adm_cal_type;
192: v_changed_flag := TRUE;

Line 189: -- the associated new IGS_AD_PS_APPL_INST values.

185: l_latest_hist_dt c_latest_hist_dt%ROWTYPE;
186:
187: BEGIN
188: -- Check if any of the old IGS_AD_PS_APPL_INST values are different from
189: -- the associated new IGS_AD_PS_APPL_INST values.
190: IF NVL(p_new_adm_cal_type,'NULL') <> NVL(p_old_adm_cal_type,'NULL') THEN
191: v_acaih_rec.adm_cal_type := p_old_adm_cal_type;
192: v_changed_flag := TRUE;
193: END IF;

Line 1116: cp_pgm_of_study igs_ad_ps_appl_inst.nominated_course_cd%TYPE,

1112: cp_admission_cat igs_ad_appl.admission_cat%TYPE,
1113: cp_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE,
1114: cp_correspondence_type igs_ad_appl_ltr.correspondence_type%TYPE,
1115: cp_adm_outcome_status igs_ad_ou_stat.adm_outcome_status%TYPE,
1116: cp_pgm_of_study igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
1117: cp_response_status igs_ad_ofr_resp_stat.adm_offer_resp_status%TYPE,
1118: cp_residency_class igs_pe_res_dtls_v.residency_class%TYPE,
1119: cp_residency_stat igs_pe_res_dtls_v.residency_status%TYPE,
1120: cp_org_unit_code igs_ps_ver.responsible_org_unit_cd%TYPE

Line 1135: igs_ad_ps_appl_inst acaiv, --Bug 3150054 Replaced igs_ad_ps_appl_inst_aplinst_v with igs_ad_ps_appl_inst

1131: padv.country country,
1132: padv.postal_code postal_code
1133: FROM igs_ad_appl aa,
1134: igs_ad_appl_ltr aal,
1135: igs_ad_ps_appl_inst acaiv, --Bug 3150054 Replaced igs_ad_ps_appl_inst_aplinst_v with igs_ad_ps_appl_inst
1136: igs_ps_ver pv,
1137: igs_pe_addr_v padv,
1138: igs_pe_res_dtls_v prdv
1139: WHERE aa.acad_cal_type LIKE cp_acad_cal_type

Line 1324: igs_ad_ps_appl_inst acaiv, --Bug 3150054 Replaced igs_ad_ps_appl_inst_aplinst_v with igs_ad_ps_appl_inst

1320: padv.country country,
1321: padv.postal_code postal_code
1322: FROM igs_ad_appl aa,
1323: igs_ad_appl_ltr aal,
1324: igs_ad_ps_appl_inst acaiv, --Bug 3150054 Replaced igs_ad_ps_appl_inst_aplinst_v with igs_ad_ps_appl_inst
1325: igs_ps_ver pv,
1326: igs_pe_addr_v padv,
1327: igs_pe_res_dtls_v prdv
1328: WHERE aa.acad_cal_type LIKE :1

Line 1437: p_program_of_study igs_ad_ps_appl_inst.nominated_course_cd%TYPE;

1433: p_adm_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1434: /*
1435: ** Start of code for enhancement# 1818444.
1436: */
1437: p_program_of_study igs_ad_ps_appl_inst.nominated_course_cd%TYPE;
1438: p_response_status igs_ad_ofr_resp_stat.adm_offer_resp_status%TYPE;
1439: p_residency_class igs_pe_res_dtls_v.residency_class%TYPE;
1440: p_residency_status igs_pe_res_dtls_v.residency_status%TYPE;
1441: p_person_id_group igs_pe_persid_group_all.group_id%TYPE;