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_GEN_004 dependencies on IGS_PS_OFR_OPT_ALL

Line 695: cp_course_cd igs_ps_ofr_opt_all.course_cd%TYPE,

691: ORDER BY alias_val; -- Order is changed to Ascending. Bug :2647482
692:
693: --Cursor to get the Program Length and Program Length Measurement for the Program Offering Option record. Bug:2647482
694: CURSOR c_get_prg_mesr_dtls(
695: cp_course_cd igs_ps_ofr_opt_all.course_cd%TYPE,
696: cp_version_number igs_ps_ofr_opt_all.version_number%TYPE,
697: cp_cal_type igs_ps_ofr_opt_all.cal_type%TYPE,
698: cp_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE,
699: cp_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE,

Line 696: cp_version_number igs_ps_ofr_opt_all.version_number%TYPE,

692:
693: --Cursor to get the Program Length and Program Length Measurement for the Program Offering Option record. Bug:2647482
694: CURSOR c_get_prg_mesr_dtls(
695: cp_course_cd igs_ps_ofr_opt_all.course_cd%TYPE,
696: cp_version_number igs_ps_ofr_opt_all.version_number%TYPE,
697: cp_cal_type igs_ps_ofr_opt_all.cal_type%TYPE,
698: cp_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE,
699: cp_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE,
700: cp_location_cd igs_ps_ofr_opt_all.location_cd%TYPE

Line 697: cp_cal_type igs_ps_ofr_opt_all.cal_type%TYPE,

693: --Cursor to get the Program Length and Program Length Measurement for the Program Offering Option record. Bug:2647482
694: CURSOR c_get_prg_mesr_dtls(
695: cp_course_cd igs_ps_ofr_opt_all.course_cd%TYPE,
696: cp_version_number igs_ps_ofr_opt_all.version_number%TYPE,
697: cp_cal_type igs_ps_ofr_opt_all.cal_type%TYPE,
698: cp_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE,
699: cp_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE,
700: cp_location_cd igs_ps_ofr_opt_all.location_cd%TYPE
701: ) IS

Line 698: cp_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE,

694: CURSOR c_get_prg_mesr_dtls(
695: cp_course_cd igs_ps_ofr_opt_all.course_cd%TYPE,
696: cp_version_number igs_ps_ofr_opt_all.version_number%TYPE,
697: cp_cal_type igs_ps_ofr_opt_all.cal_type%TYPE,
698: cp_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE,
699: cp_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE,
700: cp_location_cd igs_ps_ofr_opt_all.location_cd%TYPE
701: ) IS
702: SELECT program_length,

Line 699: cp_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE,

695: cp_course_cd igs_ps_ofr_opt_all.course_cd%TYPE,
696: cp_version_number igs_ps_ofr_opt_all.version_number%TYPE,
697: cp_cal_type igs_ps_ofr_opt_all.cal_type%TYPE,
698: cp_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE,
699: cp_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE,
700: cp_location_cd igs_ps_ofr_opt_all.location_cd%TYPE
701: ) IS
702: SELECT program_length,
703: program_length_measurement

Line 700: cp_location_cd igs_ps_ofr_opt_all.location_cd%TYPE

696: cp_version_number igs_ps_ofr_opt_all.version_number%TYPE,
697: cp_cal_type igs_ps_ofr_opt_all.cal_type%TYPE,
698: cp_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE,
699: cp_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE,
700: cp_location_cd igs_ps_ofr_opt_all.location_cd%TYPE
701: ) IS
702: SELECT program_length,
703: program_length_measurement
704: FROM igs_ps_ofr_opt_all

Line 704: FROM igs_ps_ofr_opt_all

700: cp_location_cd igs_ps_ofr_opt_all.location_cd%TYPE
701: ) IS
702: SELECT program_length,
703: program_length_measurement
704: FROM igs_ps_ofr_opt_all
705: WHERE course_cd = p_course_cd AND
706: version_number = p_crv_version_number AND
707: cal_type = p_cal_type AND
708: location_cd = p_location_cd AND