APPS.IGS_AD_SS_APPL_FEE_PKG dependencies on IGS_AD_PS_APPL_INST

Line 41: FROM igs_ad_ps_appl_inst

37: AND admission_appl_number = cp_admission_appl_number;
38:
39: CURSOR c_appl_inst(cp_person_id NUMBER,cp_admission_appl_number NUMBER,cp_nominated_cd VARCHAR,cp_seq_number NUMBER) IS
40: SELECT *
41: FROM igs_ad_ps_appl_inst
42: WHERE person_id = cp_person_id
43: AND admission_appl_number = cp_admission_appl_number
44: AND nominated_course_cd = cp_nominated_cd
45: AND sequence_number = cp_seq_number;

Line 54: l_offer_resp_outcome_status IGS_AD_PS_APPL_INST_ALL.adm_outcome_status%TYPE;

50: invalidsysstatus EXCEPTION;
51: applnotfound EXCEPTION;
52: applinstnotfound EXCEPTION;
53:
54: l_offer_resp_outcome_status IGS_AD_PS_APPL_INST_ALL.adm_outcome_status%TYPE;
55:
56: l_apcs_pref_limit_ind VARCHAR2(1);
57: l_apcs_app_fee_ind VARCHAR2(1);
58: l_apcs_late_app_ind VARCHAR2(1);

Line 249: FROM igs_ad_ps_appl_inst

245: AND admission_appl_number = cp_admission_appl_number;
246:
247: CURSOR c_appl_inst(cp_person_id NUMBER,cp_admission_appl_number NUMBER,cp_nominated_cd VARCHAR,cp_seq_number NUMBER) IS
248: SELECT *
249: FROM igs_ad_ps_appl_inst
250: WHERE person_id = cp_person_id
251: AND admission_appl_number = cp_admission_appl_number
252: AND nominated_course_cd = cp_nominated_cd
253: AND sequence_number = cp_seq_number;

Line 262: l_offer_adm_outcome_status IGS_AD_PS_APPL_INST_ALL.adm_outcome_status%TYPE;

258: invalidsysstatus EXCEPTION;
259: applnotfound EXCEPTION;
260: applinstnotfound EXCEPTION;
261:
262: l_offer_adm_outcome_status IGS_AD_PS_APPL_INST_ALL.adm_outcome_status%TYPE;
263: l_old_adm_outcome_status IGS_AD_PS_APPL_INST_ALL.adm_outcome_status%TYPE;
264:
265: l_offer_resp_status IGS_AD_PS_APPL_INST_ALL.adm_offer_resp_status%TYPE;
266: l_offer_old_resp_status IGS_AD_PS_APPL_INST_ALL.adm_offer_resp_status%TYPE;

Line 263: l_old_adm_outcome_status IGS_AD_PS_APPL_INST_ALL.adm_outcome_status%TYPE;

259: applnotfound EXCEPTION;
260: applinstnotfound EXCEPTION;
261:
262: l_offer_adm_outcome_status IGS_AD_PS_APPL_INST_ALL.adm_outcome_status%TYPE;
263: l_old_adm_outcome_status IGS_AD_PS_APPL_INST_ALL.adm_outcome_status%TYPE;
264:
265: l_offer_resp_status IGS_AD_PS_APPL_INST_ALL.adm_offer_resp_status%TYPE;
266: l_offer_old_resp_status IGS_AD_PS_APPL_INST_ALL.adm_offer_resp_status%TYPE;
267:

Line 265: l_offer_resp_status IGS_AD_PS_APPL_INST_ALL.adm_offer_resp_status%TYPE;

261:
262: l_offer_adm_outcome_status IGS_AD_PS_APPL_INST_ALL.adm_outcome_status%TYPE;
263: l_old_adm_outcome_status IGS_AD_PS_APPL_INST_ALL.adm_outcome_status%TYPE;
264:
265: l_offer_resp_status IGS_AD_PS_APPL_INST_ALL.adm_offer_resp_status%TYPE;
266: l_offer_old_resp_status IGS_AD_PS_APPL_INST_ALL.adm_offer_resp_status%TYPE;
267:
268: l_apcs_pref_limit_ind VARCHAR2(1);
269: l_apcs_app_fee_ind VARCHAR2(1);

Line 266: l_offer_old_resp_status IGS_AD_PS_APPL_INST_ALL.adm_offer_resp_status%TYPE;

262: l_offer_adm_outcome_status IGS_AD_PS_APPL_INST_ALL.adm_outcome_status%TYPE;
263: l_old_adm_outcome_status IGS_AD_PS_APPL_INST_ALL.adm_outcome_status%TYPE;
264:
265: l_offer_resp_status IGS_AD_PS_APPL_INST_ALL.adm_offer_resp_status%TYPE;
266: l_offer_old_resp_status IGS_AD_PS_APPL_INST_ALL.adm_offer_resp_status%TYPE;
267:
268: l_apcs_pref_limit_ind VARCHAR2(1);
269: l_apcs_app_fee_ind VARCHAR2(1);
270: l_apcs_late_app_ind VARCHAR2(1);