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

Line 670: p_course_cd IN igs_ps_ofr_opt.course_cd%TYPE,

666: END get_last_dt_of_att ;
667:
668:
669: FUNCTION get_coo_id(
670: p_course_cd IN igs_ps_ofr_opt.course_cd%TYPE,
671: p_version_number IN igs_ps_ofr_opt.version_number%TYPE,
672: p_cal_type IN igs_ps_ofr_opt.cal_type%TYPE,
673: p_location_cd IN igs_ps_ofr_opt.location_cd%TYPE,
674: p_attendance_mode IN igs_ps_ofr_opt.attendance_mode%TYPE,

Line 671: p_version_number IN igs_ps_ofr_opt.version_number%TYPE,

667:
668:
669: FUNCTION get_coo_id(
670: p_course_cd IN igs_ps_ofr_opt.course_cd%TYPE,
671: p_version_number IN igs_ps_ofr_opt.version_number%TYPE,
672: p_cal_type IN igs_ps_ofr_opt.cal_type%TYPE,
673: p_location_cd IN igs_ps_ofr_opt.location_cd%TYPE,
674: p_attendance_mode IN igs_ps_ofr_opt.attendance_mode%TYPE,
675: p_attendance_type IN igs_ps_ofr_opt.attendance_type%TYPE)

Line 672: p_cal_type IN igs_ps_ofr_opt.cal_type%TYPE,

668:
669: FUNCTION get_coo_id(
670: p_course_cd IN igs_ps_ofr_opt.course_cd%TYPE,
671: p_version_number IN igs_ps_ofr_opt.version_number%TYPE,
672: p_cal_type IN igs_ps_ofr_opt.cal_type%TYPE,
673: p_location_cd IN igs_ps_ofr_opt.location_cd%TYPE,
674: p_attendance_mode IN igs_ps_ofr_opt.attendance_mode%TYPE,
675: p_attendance_type IN igs_ps_ofr_opt.attendance_type%TYPE)
676: RETURN igs_ps_ofr_opt.coo_id%TYPE AS

Line 673: p_location_cd IN igs_ps_ofr_opt.location_cd%TYPE,

669: FUNCTION get_coo_id(
670: p_course_cd IN igs_ps_ofr_opt.course_cd%TYPE,
671: p_version_number IN igs_ps_ofr_opt.version_number%TYPE,
672: p_cal_type IN igs_ps_ofr_opt.cal_type%TYPE,
673: p_location_cd IN igs_ps_ofr_opt.location_cd%TYPE,
674: p_attendance_mode IN igs_ps_ofr_opt.attendance_mode%TYPE,
675: p_attendance_type IN igs_ps_ofr_opt.attendance_type%TYPE)
676: RETURN igs_ps_ofr_opt.coo_id%TYPE AS
677: /*----------------------------------------------------------------------------

Line 674: p_attendance_mode IN igs_ps_ofr_opt.attendance_mode%TYPE,

670: p_course_cd IN igs_ps_ofr_opt.course_cd%TYPE,
671: p_version_number IN igs_ps_ofr_opt.version_number%TYPE,
672: p_cal_type IN igs_ps_ofr_opt.cal_type%TYPE,
673: p_location_cd IN igs_ps_ofr_opt.location_cd%TYPE,
674: p_attendance_mode IN igs_ps_ofr_opt.attendance_mode%TYPE,
675: p_attendance_type IN igs_ps_ofr_opt.attendance_type%TYPE)
676: RETURN igs_ps_ofr_opt.coo_id%TYPE AS
677: /*----------------------------------------------------------------------------
678: || Created By : kkillams

Line 675: p_attendance_type IN igs_ps_ofr_opt.attendance_type%TYPE)

671: p_version_number IN igs_ps_ofr_opt.version_number%TYPE,
672: p_cal_type IN igs_ps_ofr_opt.cal_type%TYPE,
673: p_location_cd IN igs_ps_ofr_opt.location_cd%TYPE,
674: p_attendance_mode IN igs_ps_ofr_opt.attendance_mode%TYPE,
675: p_attendance_type IN igs_ps_ofr_opt.attendance_type%TYPE)
676: RETURN igs_ps_ofr_opt.coo_id%TYPE AS
677: /*----------------------------------------------------------------------------
678: || Created By : kkillams
679: || Created On : 08-11-2002

Line 676: RETURN igs_ps_ofr_opt.coo_id%TYPE AS

672: p_cal_type IN igs_ps_ofr_opt.cal_type%TYPE,
673: p_location_cd IN igs_ps_ofr_opt.location_cd%TYPE,
674: p_attendance_mode IN igs_ps_ofr_opt.attendance_mode%TYPE,
675: p_attendance_type IN igs_ps_ofr_opt.attendance_type%TYPE)
676: RETURN igs_ps_ofr_opt.coo_id%TYPE AS
677: /*----------------------------------------------------------------------------
678: || Created By : kkillams
679: || Created On : 08-11-2002
680: || Purpose : Returns the coo_id for a program offering.

Line 685: CURSOR cur_coo_id IS SELECT coo_id FROM igs_ps_ofr_opt

681: || Known limitations, enhancements or remarks :
682: || Change History :
683: || Who When What
684: ------------------------------------------------------------------------------*/
685: CURSOR cur_coo_id IS SELECT coo_id FROM igs_ps_ofr_opt
686: WHERE course_cd = p_course_cd
687: AND version_number = p_version_number
688: AND cal_type = p_cal_type
689: AND location_cd = p_location_cd

Line 692: l_coo_id igs_ps_ofr_opt.coo_id%TYPE;

688: AND cal_type = p_cal_type
689: AND location_cd = p_location_cd
690: AND attendance_mode = p_attendance_mode
691: AND attendance_type = p_attendance_type;
692: l_coo_id igs_ps_ofr_opt.coo_id%TYPE;
693: BEGIN
694: --Return null if any of input parameters is null.
695: IF p_course_cd IS NULL OR
696: p_version_number IS NULL OR