APPS.IGS_AD_WF_P2A dependencies on IGS_AD_PRD_AD_PRC_CA

Line 865: CURSOR c_apptype_admcal(p_adm_cal_type IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE,p_adm_cal_seq IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE

861: FROM igs_ad_ss_appl_typ
862: WHERE admission_application_type = cp_app_type;
863:
864: -- Cursor to validate whether the Application Type is available in the current Admission Calendar
865: CURSOR c_apptype_admcal(p_adm_cal_type IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE,p_adm_cal_seq IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE
866: , p_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE, p_s_admission_process_type IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%TYPE) IS
867: SELECT s_admission_process_type
868: FROM IGS_AD_PRD_AD_PRC_CA
869: WHERE adm_cal_type = p_adm_cal_type AND

Line 866: , p_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE, p_s_admission_process_type IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%TYPE) IS

862: WHERE admission_application_type = cp_app_type;
863:
864: -- Cursor to validate whether the Application Type is available in the current Admission Calendar
865: CURSOR c_apptype_admcal(p_adm_cal_type IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE,p_adm_cal_seq IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE
866: , p_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE, p_s_admission_process_type IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%TYPE) IS
867: SELECT s_admission_process_type
868: FROM IGS_AD_PRD_AD_PRC_CA
869: WHERE adm_cal_type = p_adm_cal_type AND
870: adm_ci_sequence_number = p_adm_cal_seq AND

Line 868: FROM IGS_AD_PRD_AD_PRC_CA

864: -- Cursor to validate whether the Application Type is available in the current Admission Calendar
865: CURSOR c_apptype_admcal(p_adm_cal_type IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE,p_adm_cal_seq IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE
866: , p_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE, p_s_admission_process_type IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%TYPE) IS
867: SELECT s_admission_process_type
868: FROM IGS_AD_PRD_AD_PRC_CA
869: WHERE adm_cal_type = p_adm_cal_type AND
870: adm_ci_sequence_number = p_adm_cal_seq AND
871: admission_cat = p_admission_cat AND
872: s_admission_process_type = p_s_admission_process_type;

Line 882: l_application_type_test IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%TYPE;

878: l_acad_cal_seq_number IGS_CA_INST_ALL.sequence_number%TYPE;
879: l_adm_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
880: l_adm_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE;
881: l_application_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE;
882: l_application_type_test IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%TYPE;
883:
884: l_location_code IGS_SS_APP_PGM_STG.location_cd%TYPE;
885: l_attendance_type IGS_SS_APP_PGM_STG.attendance_type%TYPE;
886: l_attendance_mode IGS_SS_APP_PGM_STG.attendance_mode%TYPE;