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.IGF_AP_OSS_INTR_DTLS dependencies on IGS_AD_PS_APPL_INST_ALL

Line 42: prog_att_course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE,

38: admission_cat igs_ad_appl_all.admission_cat%TYPE,
39: s_admission_process_type igs_ad_prcs_cat_all.s_admission_process_type%TYPE,
40: prog_attempt VARCHAR2(100),
41: -- igs_ad_ps_appl_inst.course_cd ||||igs_ad_ps_appl_inst.crv_version_number%TYPE,
42: prog_att_course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE,
43: prog_att_ver_num igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
44: prog_att_attend_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,
45: prog_att_attend_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,
46: adm_outcome_status igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,

Line 43: prog_att_ver_num igs_ad_ps_appl_inst_all.crv_version_number%TYPE,

39: s_admission_process_type igs_ad_prcs_cat_all.s_admission_process_type%TYPE,
40: prog_attempt VARCHAR2(100),
41: -- igs_ad_ps_appl_inst.course_cd ||||igs_ad_ps_appl_inst.crv_version_number%TYPE,
42: prog_att_course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE,
43: prog_att_ver_num igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
44: prog_att_attend_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,
45: prog_att_attend_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,
46: adm_outcome_status igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
47: s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE,

Line 44: prog_att_attend_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,

40: prog_attempt VARCHAR2(100),
41: -- igs_ad_ps_appl_inst.course_cd ||||igs_ad_ps_appl_inst.crv_version_number%TYPE,
42: prog_att_course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE,
43: prog_att_ver_num igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
44: prog_att_attend_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,
45: prog_att_attend_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,
46: adm_outcome_status igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
47: s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE,
48: decision_date igs_ad_ps_appl_inst_all.decision_date%TYPE,

Line 45: prog_att_attend_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,

41: -- igs_ad_ps_appl_inst.course_cd ||||igs_ad_ps_appl_inst.crv_version_number%TYPE,
42: prog_att_course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE,
43: prog_att_ver_num igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
44: prog_att_attend_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,
45: prog_att_attend_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,
46: adm_outcome_status igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
47: s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE,
48: decision_date igs_ad_ps_appl_inst_all.decision_date%TYPE,
49: adm_offer_resp_status igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,

Line 46: adm_outcome_status igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,

42: prog_att_course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE,
43: prog_att_ver_num igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
44: prog_att_attend_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,
45: prog_att_attend_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,
46: adm_outcome_status igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
47: s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE,
48: decision_date igs_ad_ps_appl_inst_all.decision_date%TYPE,
49: adm_offer_resp_status igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
50: s_adm_offer_resp_status igs_ad_ofr_resp_stat.s_adm_offer_resp_status%TYPE,

Line 48: decision_date igs_ad_ps_appl_inst_all.decision_date%TYPE,

44: prog_att_attend_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,
45: prog_att_attend_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,
46: adm_outcome_status igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
47: s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE,
48: decision_date igs_ad_ps_appl_inst_all.decision_date%TYPE,
49: adm_offer_resp_status igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
50: s_adm_offer_resp_status igs_ad_ofr_resp_stat.s_adm_offer_resp_status%TYPE,
51: actual_response_date igs_ad_ps_appl_inst_all.actual_response_dt%TYPE,
52: adm_fee_status igs_ad_appl_all.adm_fee_status%TYPE,

Line 49: adm_offer_resp_status igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,

45: prog_att_attend_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,
46: adm_outcome_status igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
47: s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE,
48: decision_date igs_ad_ps_appl_inst_all.decision_date%TYPE,
49: adm_offer_resp_status igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
50: s_adm_offer_resp_status igs_ad_ofr_resp_stat.s_adm_offer_resp_status%TYPE,
51: actual_response_date igs_ad_ps_appl_inst_all.actual_response_dt%TYPE,
52: adm_fee_status igs_ad_appl_all.adm_fee_status%TYPE,
53: s_adm_fee_status igs_ad_fee_stat.s_adm_fee_status%TYPE,

Line 51: actual_response_date igs_ad_ps_appl_inst_all.actual_response_dt%TYPE,

47: s_adm_outcome_status igs_ad_ou_stat.s_adm_outcome_status%TYPE,
48: decision_date igs_ad_ps_appl_inst_all.decision_date%TYPE,
49: adm_offer_resp_status igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
50: s_adm_offer_resp_status igs_ad_ofr_resp_stat.s_adm_offer_resp_status%TYPE,
51: actual_response_date igs_ad_ps_appl_inst_all.actual_response_dt%TYPE,
52: adm_fee_status igs_ad_appl_all.adm_fee_status%TYPE,
53: s_adm_fee_status igs_ad_fee_stat.s_adm_fee_status%TYPE,
54: sp_program_1 igs_ad_appl. spcl_grp_1%TYPE,
55: -- sp_program_1 will be NULL till Admission DLD Build

Line 61: academic_index igs_ad_ps_appl_inst_all.academic_index%TYPE,

57: -- sp_program_2 will be NULL till Admission DLD Build
58: entry_level igs_ad_ps_appl_inst. entry_level%TYPE,
59: -- entry_level will be NULL till Admission DLD Build
60: anticip_compl_date DATE,
61: academic_index igs_ad_ps_appl_inst_all.academic_index%TYPE,
62: adm_org_unit_cd igs_ps_ver_all.responsible_org_unit_cd%TYPE,
63: final_unit_set VARCHAR2(100),
64: -- igs_ad_ps_appl_inst.unit_set_cd||||igs_ad_ps_appl_inst.us_version_number%TYPE,
65: final_unit_set_course_cd igs_ad_ps_appl_inst_all.unit_set_cd%TYPE,

Line 65: final_unit_set_course_cd igs_ad_ps_appl_inst_all.unit_set_cd%TYPE,

61: academic_index igs_ad_ps_appl_inst_all.academic_index%TYPE,
62: adm_org_unit_cd igs_ps_ver_all.responsible_org_unit_cd%TYPE,
63: final_unit_set VARCHAR2(100),
64: -- igs_ad_ps_appl_inst.unit_set_cd||||igs_ad_ps_appl_inst.us_version_number%TYPE,
65: final_unit_set_course_cd igs_ad_ps_appl_inst_all.unit_set_cd%TYPE,
66: final_unit_set_ver_num igs_ad_ps_appl_inst_all.us_version_number%TYPE,
67: prog_att_start_dt igs_en_stdnt_ps_att_all.commencement_dt%TYPE,
68: transfered VARCHAR2(30),
69: -- transfered will be NULL as No Mapping exists for this

Line 66: final_unit_set_ver_num igs_ad_ps_appl_inst_all.us_version_number%TYPE,

62: adm_org_unit_cd igs_ps_ver_all.responsible_org_unit_cd%TYPE,
63: final_unit_set VARCHAR2(100),
64: -- igs_ad_ps_appl_inst.unit_set_cd||||igs_ad_ps_appl_inst.us_version_number%TYPE,
65: final_unit_set_course_cd igs_ad_ps_appl_inst_all.unit_set_cd%TYPE,
66: final_unit_set_ver_num igs_ad_ps_appl_inst_all.us_version_number%TYPE,
67: prog_att_start_dt igs_en_stdnt_ps_att_all.commencement_dt%TYPE,
68: transfered VARCHAR2(30),
69: -- transfered will be NULL as No Mapping exists for this
70: multiple_ad_appl VARCHAR2(10),