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_HE_EXTRACT2_PKG dependencies on IGS_PS_OFR_OPT

Line 19: g_ps_ofr_opt igs_ps_ofr_opt%ROWTYPE;

15: g_he_en_susa igs_he_en_susa%ROWTYPE;
16: g_he_st_prog igs_he_st_prog%ROWTYPE;
17: g_ps_ver igs_ps_ver%ROWTYPE;
18: g_ps_type igs_ps_type_all%ROWTYPE;
19: g_ps_ofr_opt igs_ps_ofr_opt%ROWTYPE;
20: g_he_poous igs_he_poous%ROWTYPE;
21: g_pe_person igs_pe_person%ROWTYPE;
22: g_pe_stat_v igs_pe_stat_v%ROWTYPE;
23: g_he_ad_dtl igs_he_ad_dtl%ROWTYPE;

Line 9686: CURSOR c_crse (p_cal_type igs_ps_ofr_opt.cal_type%TYPE,

9682: ORDER BY susa.rqrmnts_complete_dt DESC, susa.end_dt DESC, susa.selection_dt DESC;
9683:
9684: -- smaddali modified this cursor to select funding_source field from igs_he_poous for hefd208 - bug#2717751
9685: -- smaddali added version_number parameter for HECR214 build, we need to get the Term record program version details
9686: CURSOR c_crse (p_cal_type igs_ps_ofr_opt.cal_type%TYPE,
9687: p_attendance_mode igs_ps_ofr_opt.attendance_mode%TYPE,
9688: p_attendance_type igs_ps_ofr_opt.attendance_type%TYPE,
9689: p_location_cd igs_ps_ofr_opt.location_cd%TYPE,
9690: p_unit_set_cd igs_he_poous_all.unit_set_cd%TYPE,

Line 9687: p_attendance_mode igs_ps_ofr_opt.attendance_mode%TYPE,

9683:
9684: -- smaddali modified this cursor to select funding_source field from igs_he_poous for hefd208 - bug#2717751
9685: -- smaddali added version_number parameter for HECR214 build, we need to get the Term record program version details
9686: CURSOR c_crse (p_cal_type igs_ps_ofr_opt.cal_type%TYPE,
9687: p_attendance_mode igs_ps_ofr_opt.attendance_mode%TYPE,
9688: p_attendance_type igs_ps_ofr_opt.attendance_type%TYPE,
9689: p_location_cd igs_ps_ofr_opt.location_cd%TYPE,
9690: p_unit_set_cd igs_he_poous_all.unit_set_cd%TYPE,
9691: p_us_version_number igs_he_poous_all.us_version_number%TYPE,

Line 9688: p_attendance_type igs_ps_ofr_opt.attendance_type%TYPE,

9684: -- smaddali modified this cursor to select funding_source field from igs_he_poous for hefd208 - bug#2717751
9685: -- smaddali added version_number parameter for HECR214 build, we need to get the Term record program version details
9686: CURSOR c_crse (p_cal_type igs_ps_ofr_opt.cal_type%TYPE,
9687: p_attendance_mode igs_ps_ofr_opt.attendance_mode%TYPE,
9688: p_attendance_type igs_ps_ofr_opt.attendance_type%TYPE,
9689: p_location_cd igs_ps_ofr_opt.location_cd%TYPE,
9690: p_unit_set_cd igs_he_poous_all.unit_set_cd%TYPE,
9691: p_us_version_number igs_he_poous_all.us_version_number%TYPE,
9692: cp_crv_version_number igs_ps_ver_all.version_number%TYPE ) IS

Line 9689: p_location_cd igs_ps_ofr_opt.location_cd%TYPE,

9685: -- smaddali added version_number parameter for HECR214 build, we need to get the Term record program version details
9686: CURSOR c_crse (p_cal_type igs_ps_ofr_opt.cal_type%TYPE,
9687: p_attendance_mode igs_ps_ofr_opt.attendance_mode%TYPE,
9688: p_attendance_type igs_ps_ofr_opt.attendance_type%TYPE,
9689: p_location_cd igs_ps_ofr_opt.location_cd%TYPE,
9690: p_unit_set_cd igs_he_poous_all.unit_set_cd%TYPE,
9691: p_us_version_number igs_he_poous_all.us_version_number%TYPE,
9692: cp_crv_version_number igs_ps_ver_all.version_number%TYPE ) IS
9693: SELECT crv.title,

Line 9753: igs_ps_ofr_opt pop

9749: hpud.funding_source
9750: FROM igs_ps_ver crv,
9751: igs_he_st_prog hpr,
9752: igs_he_poous hpud,
9753: igs_ps_ofr_opt pop
9754: WHERE crv.course_cd = hpr.course_cd
9755: AND crv.version_number = hpr.version_number
9756: AND crv.course_cd = p_course_cd
9757: AND crv.version_number = cp_crv_version_number