APPS.IGS_ADMAPPLICATION_PUB dependencies on IGS_AD_APPL_ALL

Line 1310: CURSOR c_adm_appl_dtl (cp_person_id igs_ad_appl_all.person_id%TYPE ,

1306: ---------------------------------------------------------------------------------------------------------------------------------------
1307:
1308:
1309: -- to get the one application row
1310: CURSOR c_adm_appl_dtl (cp_person_id igs_ad_appl_all.person_id%TYPE ,
1311: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS
1312: SELECT appl.*
1313: FROM igs_ad_appl_all appl
1314: WHERE person_id = cp_person_id AND

Line 1311: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS

1307:
1308:
1309: -- to get the one application row
1310: CURSOR c_adm_appl_dtl (cp_person_id igs_ad_appl_all.person_id%TYPE ,
1311: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS
1312: SELECT appl.*
1313: FROM igs_ad_appl_all appl
1314: WHERE person_id = cp_person_id AND
1315: admission_appl_number = cp_admission_appl_number;

Line 1313: FROM igs_ad_appl_all appl

1309: -- to get the one application row
1310: CURSOR c_adm_appl_dtl (cp_person_id igs_ad_appl_all.person_id%TYPE ,
1311: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS
1312: SELECT appl.*
1313: FROM igs_ad_appl_all appl
1314: WHERE person_id = cp_person_id AND
1315: admission_appl_number = cp_admission_appl_number;
1316:
1317: -- to get teh application instance

Line 1374: l_application_id igs_ad_appl_all.application_id%TYPE;

1370: v_appl_dt igs_ad_appl.appl_dt%TYPE;
1371: v_adm_appl_status igs_ad_appl.adm_appl_status%TYPE;
1372: v_adm_fee_status igs_ad_appl.adm_fee_status%TYPE;
1373: l_single_response_flag igs_ad_prd_ad_prc_ca.single_response_flag%TYPE;
1374: l_application_id igs_ad_appl_all.application_id%TYPE;
1375: l_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE;
1376: l_acad_alt_code igs_ca_inst.alternate_code%TYPE;
1377: l_adm_alt_code igs_ca_inst.alternate_code%TYPE;
1378: l_acaiv_rec cur_ad_ps_appl_inst%ROWTYPE;

Line 2450: FROM igs_ad_appl_all appl

2446: CURSOR c_appl (cp_person_id igs_ad_ps_appl_inst.person_id%TYPE,
2447: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE)
2448: IS
2449: SELECT appl.s_admission_process_type
2450: FROM igs_ad_appl_all appl
2451: WHERE appl.person_id = cp_person_id
2452: AND appl.admission_appl_number = cp_admission_appl_number;
2453:
2454: l_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE;

Line 2454: l_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE;

2450: FROM igs_ad_appl_all appl
2451: WHERE appl.person_id = cp_person_id
2452: AND appl.admission_appl_number = cp_admission_appl_number;
2453:
2454: l_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE;
2455:
2456: BEGIN
2457: l_msg_index := 0;
2458: SAVEPOINT UPDATE_ENTRY_QUAL_STATUS_SAVE;