eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_WF_P2A dependencies on IGS_AD_SS_APPL_TYP

Line 73: CURSOR c_app_type_det ( cp_app_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE) IS

69: --Who When What
70: -------------------------------------------------------------------
71: IS
72:
73: CURSOR c_app_type_det ( cp_app_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE) IS
74: SELECT admission_cat,s_admission_process_type
75: FROM igs_ad_ss_appl_typ
76: WHERE admission_application_type = cp_app_type;
77:

Line 75: FROM igs_ad_ss_appl_typ

71: IS
72:
73: CURSOR c_app_type_det ( cp_app_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE) IS
74: SELECT admission_cat,s_admission_process_type
75: FROM igs_ad_ss_appl_typ
76: WHERE admission_application_type = cp_app_type;
77:
78: CURSOR c_seq_num IS
79: SELECT IGS_SS_ADM_APPL_S.NEXTVAL

Line 88: l_application_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE;

84: l_acad_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
85: l_acad_cal_seq_number IGS_CA_INST_ALL.sequence_number%TYPE;
86: l_adm_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
87: l_adm_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE;
88: l_application_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE;
89: l_location_code IGS_SS_APP_PGM_STG.location_cd%TYPE;
90: l_program_type IGS_PS_TYPE_ALL.course_type%TYPE;
91: l_sch_apl_to_id IGS_SS_APP_PGM_STG.sch_apl_to_id%TYPE;
92: l_attendance_type IGS_SS_APP_PGM_STG.attendance_type%TYPE;

Line 103: l_admission_cat IGS_AD_SS_APPL_TYP.admission_cat%TYPE;

99: l_finaid_apply_date IGS_SS_ADM_APPL_STG.finaid_apply_date%TYPE;
100: l_application_fee_amount IGS_SS_ADM_APPL_STG.appl_fee_amt%TYPE;
101:
102:
103: l_admission_cat IGS_AD_SS_APPL_TYP.admission_cat%TYPE;
104: l_s_process_type IGS_AD_SS_APPL_TYP.s_admission_process_type%TYPE;
105: l_seq_val NUMBER;
106: l_appl_source_id IGS_AD_CODE_CLASSES.code_id%TYPE;
107:

Line 104: l_s_process_type IGS_AD_SS_APPL_TYP.s_admission_process_type%TYPE;

100: l_application_fee_amount IGS_SS_ADM_APPL_STG.appl_fee_amt%TYPE;
101:
102:
103: l_admission_cat IGS_AD_SS_APPL_TYP.admission_cat%TYPE;
104: l_s_process_type IGS_AD_SS_APPL_TYP.s_admission_process_type%TYPE;
105: l_seq_val NUMBER;
106: l_appl_source_id IGS_AD_CODE_CLASSES.code_id%TYPE;
107:
108: l_return_status VARCHAR2(3);

Line 294: CURSOR c_appl_fee_amount ( cp_app_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE) IS

290: funcmode in VARCHAR2 ,
291: resultout OUT NOCOPY VARCHAR2 ) IS
292:
293:
294: CURSOR c_appl_fee_amount ( cp_app_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE) IS
295: SELECT application_fee_amount,admission_application_type
296: FROM igs_ad_ss_appl_typ
297: WHERE admission_application_type = cp_app_type;
298:

Line 296: FROM igs_ad_ss_appl_typ

292:
293:
294: CURSOR c_appl_fee_amount ( cp_app_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE) IS
295: SELECT application_fee_amount,admission_application_type
296: FROM igs_ad_ss_appl_typ
297: WHERE admission_application_type = cp_app_type;
298:
299: CURSOR c_appl_type_uhk_prl IS
300: SELECT FND_PROFILE.VALUE('IGS_AD_APPL_TYPE_UHK') value

Line 313: l_application_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE;

309: l_acad_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
310: l_acad_cal_seq_number IGS_CA_INST_ALL.sequence_number%TYPE;
311: l_adm_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
312: l_adm_ci_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE;
313: l_application_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE;
314: l_location_code IGS_SS_APP_PGM_STG.location_cd%TYPE;
315: l_program_type IGS_PS_TYPE_ALL.course_type%TYPE;
316: l_sch_apl_to_id IGS_SS_APP_PGM_STG.sch_apl_to_id%TYPE;
317: l_attendance_type IGS_SS_APP_PGM_STG.attendance_type%TYPE;

Line 381: cl_appl_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE;

377: l_application_fee_amount IGS_SS_ADM_APPL_STG.appl_fee_amt%TYPE;
378:
379: l_application_fee_amount_test IGS_SS_ADM_APPL_STG.appl_fee_amt%TYPE;
380:
381: cl_appl_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE;
382: l_result VARCHAR2(30);
383: l_appl_type_uhk_prl c_appl_type_uhk_prl%ROWTYPE;
384: l_appl_fee_uhk_prl c_appl_fee_uhk_prl%ROWTYPE;
385: l_appl_date DATE;

Line 859: CURSOR c_app_type_det ( cp_app_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE) IS

855: resultout OUT NOCOPY VARCHAR2 ) IS
856: l_result VARCHAR2(30);
857:
858:
859: CURSOR c_app_type_det ( cp_app_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE) IS
860: SELECT admission_cat,s_admission_process_type
861: FROM igs_ad_ss_appl_typ
862: WHERE admission_application_type = cp_app_type;
863:

Line 861: FROM igs_ad_ss_appl_typ

857:
858:
859: CURSOR c_app_type_det ( cp_app_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE) IS
860: SELECT admission_cat,s_admission_process_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

Line 881: l_application_type IGS_AD_SS_APPL_TYP.admission_application_type%TYPE;

877: l_acad_cal_type IGS_CA_INST_ALL.cal_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;

Line 888: l_admission_cat IGS_AD_SS_APPL_TYP.admission_cat%TYPE;

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;
887:
888: l_admission_cat IGS_AD_SS_APPL_TYP.admission_cat%TYPE;
889: l_s_process_type IGS_AD_SS_APPL_TYP.s_admission_process_type%TYPE;
890: l_submission_deadline DATE;
891:
892: l_loc_des IGS_AD_LOCATION.description%TYPE;

Line 889: l_s_process_type IGS_AD_SS_APPL_TYP.s_admission_process_type%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;
887:
888: l_admission_cat IGS_AD_SS_APPL_TYP.admission_cat%TYPE;
889: l_s_process_type IGS_AD_SS_APPL_TYP.s_admission_process_type%TYPE;
890: l_submission_deadline DATE;
891:
892: l_loc_des IGS_AD_LOCATION.description%TYPE;
893: l_attd_type_des IGS_EN_ATD_TYPE.description%TYPE;