APPS.IGS_AD_DEF_APPL_PKG dependencies on IGS_AD_APPL_ALL

Line 371: CURSOR c_get_acad_cal_info(cp_person_id igs_ad_appl_all.person_id%TYPE,

367: l_s_adm_offer_dfrmnt_status igs_ad_ofrdfrmt_stat_v.s_adm_offer_dfrmnt_status%TYPE;
368:
369: v_start_dt DATE;
370:
371: CURSOR c_get_acad_cal_info(cp_person_id igs_ad_appl_all.person_id%TYPE,
372: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS
373: SELECT acad_cal_type,acad_ci_sequence_number
374: FROM igs_ad_appl_all
375: WHERE person_id = cp_person_id

Line 372: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS

368:
369: v_start_dt DATE;
370:
371: CURSOR c_get_acad_cal_info(cp_person_id igs_ad_appl_all.person_id%TYPE,
372: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS
373: SELECT acad_cal_type,acad_ci_sequence_number
374: FROM igs_ad_appl_all
375: WHERE person_id = cp_person_id
376: AND admission_appl_number = cp_admission_appl_number;

Line 374: FROM igs_ad_appl_all

370:
371: CURSOR c_get_acad_cal_info(cp_person_id igs_ad_appl_all.person_id%TYPE,
372: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS
373: SELECT acad_cal_type,acad_ci_sequence_number
374: FROM igs_ad_appl_all
375: WHERE person_id = cp_person_id
376: AND admission_appl_number = cp_admission_appl_number;
377:
378: l_get_acad_cal_info c_get_acad_cal_info%ROWTYPE;

Line 560: CURSOR c_sys_def_appl_type(cp_adm_cat igs_ad_appl_all.admission_cat%TYPE,

556: AND aca.admission_appl_number = acai.admission_appl_number
557: AND aca.nominated_course_cd = acai.nominated_course_cd;
558:
559:
560: CURSOR c_sys_def_appl_type(cp_adm_cat igs_ad_appl_all.admission_cat%TYPE,
561: cp_s_adm_prc_typ igs_ad_appl_all.s_admission_process_type%TYPE
562: )
563: IS
564: SELECT admission_application_type

Line 561: cp_s_adm_prc_typ igs_ad_appl_all.s_admission_process_type%TYPE

557: AND aca.nominated_course_cd = acai.nominated_course_cd;
558:
559:
560: CURSOR c_sys_def_appl_type(cp_adm_cat igs_ad_appl_all.admission_cat%TYPE,
561: cp_s_adm_prc_typ igs_ad_appl_all.s_admission_process_type%TYPE
562: )
563: IS
564: SELECT admission_application_type
565: FROM igs_ad_ss_appl_typ

Line 581: l_application_type igs_ad_appl_all.application_type%TYPE;

577: l_return_type VARCHAR2(100);
578: l_error_code VARCHAR2(100);
579: l_adm_appl_status igs_ad_appl.adm_appl_status%TYPE;
580: l_admission_appl_number igs_ad_appl.admission_appl_number%TYPE;
581: l_application_type igs_ad_appl_all.application_type%TYPE;
582: ------------------- End Variable Declarations------------------------------------------------------
583: BEGIN
584: FOR c_appl_inst_rec IN c_appl_inst LOOP
585: