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_SS_APP_PGM_STG

Line 12: TYPE DFFAttributeSet IS TABLE OF IGS_SS_APP_PGM_STG.attribute1%TYPE;

8: -- Who When What
9: --
10: ---------------------------------------------------------------------------------------------------------------------------------------
11:
12: TYPE DFFAttributeSet IS TABLE OF IGS_SS_APP_PGM_STG.attribute1%TYPE;
13: g_dff_attribute DFFAttributeSet;
14: g_dff_attribute_category IGS_SS_APP_PGM_STG.attribute_category%TYPE;
15:
16:

Line 14: g_dff_attribute_category IGS_SS_APP_PGM_STG.attribute_category%TYPE;

10: ---------------------------------------------------------------------------------------------------------------------------------------
11:
12: TYPE DFFAttributeSet IS TABLE OF IGS_SS_APP_PGM_STG.attribute1%TYPE;
13: g_dff_attribute DFFAttributeSet;
14: g_dff_attribute_category IGS_SS_APP_PGM_STG.attribute_category%TYPE;
15:
16:
17:
18: PROCEDURE set_return_message(

Line 89: l_location_code IGS_SS_APP_PGM_STG.location_cd%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;
93: l_attendance_mode IGS_SS_APP_PGM_STG.attendance_mode%TYPE;

Line 91: l_sch_apl_to_id IGS_SS_APP_PGM_STG.sch_apl_to_id%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;
93: l_attendance_mode IGS_SS_APP_PGM_STG.attendance_mode%TYPE;
94: l_entry_status IGS_SS_ADM_APPL_STG.entry_status%TYPE;
95: l_entry_level IGS_SS_ADM_APPL_STG.entry_level%TYPE;

Line 92: l_attendance_type IGS_SS_APP_PGM_STG.attendance_type%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;
93: l_attendance_mode IGS_SS_APP_PGM_STG.attendance_mode%TYPE;
94: l_entry_status IGS_SS_ADM_APPL_STG.entry_status%TYPE;
95: l_entry_level IGS_SS_ADM_APPL_STG.entry_level%TYPE;
96: l_spcl_gr1 IGS_SS_ADM_APPL_STG.spcl_grp_1%TYPE;

Line 93: l_attendance_mode IGS_SS_APP_PGM_STG.attendance_mode%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;
93: l_attendance_mode IGS_SS_APP_PGM_STG.attendance_mode%TYPE;
94: l_entry_status IGS_SS_ADM_APPL_STG.entry_status%TYPE;
95: l_entry_level IGS_SS_ADM_APPL_STG.entry_level%TYPE;
96: l_spcl_gr1 IGS_SS_ADM_APPL_STG.spcl_grp_1%TYPE;
97: l_spcl_gr2 IGS_SS_ADM_APPL_STG.spcl_grp_2%TYPE;

Line 314: l_location_code IGS_SS_APP_PGM_STG.location_cd%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;
318: l_attendance_mode IGS_SS_APP_PGM_STG.attendance_mode%TYPE;

Line 316: l_sch_apl_to_id IGS_SS_APP_PGM_STG.sch_apl_to_id%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;
318: l_attendance_mode IGS_SS_APP_PGM_STG.attendance_mode%TYPE;
319: l_oo_attribute_1 VARCHAR2(1);
320: l_oo_attribute_2 VARCHAR2(1);

Line 317: l_attendance_type IGS_SS_APP_PGM_STG.attendance_type%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;
318: l_attendance_mode IGS_SS_APP_PGM_STG.attendance_mode%TYPE;
319: l_oo_attribute_1 VARCHAR2(1);
320: l_oo_attribute_2 VARCHAR2(1);
321: l_oo_attribute_3 VARCHAR2(1);

Line 318: l_attendance_mode IGS_SS_APP_PGM_STG.attendance_mode%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;
318: l_attendance_mode IGS_SS_APP_PGM_STG.attendance_mode%TYPE;
319: l_oo_attribute_1 VARCHAR2(1);
320: l_oo_attribute_2 VARCHAR2(1);
321: l_oo_attribute_3 VARCHAR2(1);
322: l_oo_attribute_4 VARCHAR2(1);

Line 884: l_location_code IGS_SS_APP_PGM_STG.location_cd%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;
887:
888: l_admission_cat IGS_AD_SS_APPL_TYP.admission_cat%TYPE;

Line 885: l_attendance_type IGS_SS_APP_PGM_STG.attendance_type%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;
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;

Line 886: l_attendance_mode IGS_SS_APP_PGM_STG.attendance_mode%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;
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;