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_POOUS_ALL_PKG dependencies on IGS_EN_STDNT_PS_ATT

Line 499: CURSOR cur_stdnt(cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,

495: END get_fk_igs_ps_ofr_unit_set;
496:
497:
498: PROCEDURE check_spa_exists AS
499: CURSOR cur_stdnt(cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
500: cp_version igs_en_stdnt_ps_att.version_number%TYPE,
501: cp_cal_type igs_en_stdnt_ps_att.cal_type%TYPE,
502: cp_location_cd igs_en_stdnt_ps_att.location_cd%TYPE,
503: cp_attendance_mode igs_en_stdnt_ps_att.attendance_mode%TYPE,

Line 500: cp_version igs_en_stdnt_ps_att.version_number%TYPE,

496:
497:
498: PROCEDURE check_spa_exists AS
499: CURSOR cur_stdnt(cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
500: cp_version igs_en_stdnt_ps_att.version_number%TYPE,
501: cp_cal_type igs_en_stdnt_ps_att.cal_type%TYPE,
502: cp_location_cd igs_en_stdnt_ps_att.location_cd%TYPE,
503: cp_attendance_mode igs_en_stdnt_ps_att.attendance_mode%TYPE,
504: cp_attendance_type igs_en_stdnt_ps_att.attendance_type%TYPE) IS

Line 501: cp_cal_type igs_en_stdnt_ps_att.cal_type%TYPE,

497:
498: PROCEDURE check_spa_exists AS
499: CURSOR cur_stdnt(cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
500: cp_version igs_en_stdnt_ps_att.version_number%TYPE,
501: cp_cal_type igs_en_stdnt_ps_att.cal_type%TYPE,
502: cp_location_cd igs_en_stdnt_ps_att.location_cd%TYPE,
503: cp_attendance_mode igs_en_stdnt_ps_att.attendance_mode%TYPE,
504: cp_attendance_type igs_en_stdnt_ps_att.attendance_type%TYPE) IS
505: SELECT 'X' FROM igs_en_stdnt_ps_att

Line 502: cp_location_cd igs_en_stdnt_ps_att.location_cd%TYPE,

498: PROCEDURE check_spa_exists AS
499: CURSOR cur_stdnt(cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
500: cp_version igs_en_stdnt_ps_att.version_number%TYPE,
501: cp_cal_type igs_en_stdnt_ps_att.cal_type%TYPE,
502: cp_location_cd igs_en_stdnt_ps_att.location_cd%TYPE,
503: cp_attendance_mode igs_en_stdnt_ps_att.attendance_mode%TYPE,
504: cp_attendance_type igs_en_stdnt_ps_att.attendance_type%TYPE) IS
505: SELECT 'X' FROM igs_en_stdnt_ps_att
506: WHERE course_cd = cp_course_cd

Line 503: cp_attendance_mode igs_en_stdnt_ps_att.attendance_mode%TYPE,

499: CURSOR cur_stdnt(cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
500: cp_version igs_en_stdnt_ps_att.version_number%TYPE,
501: cp_cal_type igs_en_stdnt_ps_att.cal_type%TYPE,
502: cp_location_cd igs_en_stdnt_ps_att.location_cd%TYPE,
503: cp_attendance_mode igs_en_stdnt_ps_att.attendance_mode%TYPE,
504: cp_attendance_type igs_en_stdnt_ps_att.attendance_type%TYPE) IS
505: SELECT 'X' FROM igs_en_stdnt_ps_att
506: WHERE course_cd = cp_course_cd
507: AND version_number = cp_version

Line 504: cp_attendance_type igs_en_stdnt_ps_att.attendance_type%TYPE) IS

500: cp_version igs_en_stdnt_ps_att.version_number%TYPE,
501: cp_cal_type igs_en_stdnt_ps_att.cal_type%TYPE,
502: cp_location_cd igs_en_stdnt_ps_att.location_cd%TYPE,
503: cp_attendance_mode igs_en_stdnt_ps_att.attendance_mode%TYPE,
504: cp_attendance_type igs_en_stdnt_ps_att.attendance_type%TYPE) IS
505: SELECT 'X' FROM igs_en_stdnt_ps_att
506: WHERE course_cd = cp_course_cd
507: AND version_number = cp_version
508: AND cal_type = cp_cal_type

Line 505: SELECT 'X' FROM igs_en_stdnt_ps_att

501: cp_cal_type igs_en_stdnt_ps_att.cal_type%TYPE,
502: cp_location_cd igs_en_stdnt_ps_att.location_cd%TYPE,
503: cp_attendance_mode igs_en_stdnt_ps_att.attendance_mode%TYPE,
504: cp_attendance_type igs_en_stdnt_ps_att.attendance_type%TYPE) IS
505: SELECT 'X' FROM igs_en_stdnt_ps_att
506: WHERE course_cd = cp_course_cd
507: AND version_number = cp_version
508: AND cal_type = cp_cal_type
509: AND location_cd = cp_location_cd