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_PS_GEN_001 dependencies on IGS_PS_OF_OPT_AD_CAT

Line 590: FROM IGS_PS_OF_OPT_AD_CAT cooac

586: cooac.attendance_mode,
587: cooac.attendance_type,
588: cooac.admission_cat,
589: cooac.system_default_ind
590: FROM IGS_PS_OF_OPT_AD_CAT cooac
591: WHERE cooac.course_cd = p_old_course_cd AND
592: cooac.version_number = p_old_version_number AND
593: cooac.cal_type = gv_coo_rec.cal_type AND
594: cooac.location_cd = gv_coo_rec.location_cd AND

Line 598: cp_cooac_cal_type IGS_PS_OF_OPT_AD_CAT.cal_type%TYPE,

594: cooac.location_cd = gv_coo_rec.location_cd AND
595: cooac.attendance_mode = gv_coo_rec.attendance_mode AND
596: cooac.attendance_type = gv_coo_rec.attendance_type;
597: CURSOR c_cacus (
598: cp_cooac_cal_type IGS_PS_OF_OPT_AD_CAT.cal_type%TYPE,
599: cp_cooac_location_cd IGS_PS_OF_OPT_AD_CAT.location_cd%TYPE,
600: cp_cooac_attendance_mode IGS_PS_OF_OPT_AD_CAT.attendance_mode%TYPE,
601: cp_cooac_attendance_type IGS_PS_OF_OPT_AD_CAT.attendance_type%TYPE,
602: cp_cooac_admission_cat IGS_PS_OF_OPT_AD_CAT.admission_cat%TYPE) IS

Line 599: cp_cooac_location_cd IGS_PS_OF_OPT_AD_CAT.location_cd%TYPE,

595: cooac.attendance_mode = gv_coo_rec.attendance_mode AND
596: cooac.attendance_type = gv_coo_rec.attendance_type;
597: CURSOR c_cacus (
598: cp_cooac_cal_type IGS_PS_OF_OPT_AD_CAT.cal_type%TYPE,
599: cp_cooac_location_cd IGS_PS_OF_OPT_AD_CAT.location_cd%TYPE,
600: cp_cooac_attendance_mode IGS_PS_OF_OPT_AD_CAT.attendance_mode%TYPE,
601: cp_cooac_attendance_type IGS_PS_OF_OPT_AD_CAT.attendance_type%TYPE,
602: cp_cooac_admission_cat IGS_PS_OF_OPT_AD_CAT.admission_cat%TYPE) IS
603: SELECT cacus.cal_type,

Line 600: cp_cooac_attendance_mode IGS_PS_OF_OPT_AD_CAT.attendance_mode%TYPE,

596: cooac.attendance_type = gv_coo_rec.attendance_type;
597: CURSOR c_cacus (
598: cp_cooac_cal_type IGS_PS_OF_OPT_AD_CAT.cal_type%TYPE,
599: cp_cooac_location_cd IGS_PS_OF_OPT_AD_CAT.location_cd%TYPE,
600: cp_cooac_attendance_mode IGS_PS_OF_OPT_AD_CAT.attendance_mode%TYPE,
601: cp_cooac_attendance_type IGS_PS_OF_OPT_AD_CAT.attendance_type%TYPE,
602: cp_cooac_admission_cat IGS_PS_OF_OPT_AD_CAT.admission_cat%TYPE) IS
603: SELECT cacus.cal_type,
604: cacus.location_cd,

Line 601: cp_cooac_attendance_type IGS_PS_OF_OPT_AD_CAT.attendance_type%TYPE,

597: CURSOR c_cacus (
598: cp_cooac_cal_type IGS_PS_OF_OPT_AD_CAT.cal_type%TYPE,
599: cp_cooac_location_cd IGS_PS_OF_OPT_AD_CAT.location_cd%TYPE,
600: cp_cooac_attendance_mode IGS_PS_OF_OPT_AD_CAT.attendance_mode%TYPE,
601: cp_cooac_attendance_type IGS_PS_OF_OPT_AD_CAT.attendance_type%TYPE,
602: cp_cooac_admission_cat IGS_PS_OF_OPT_AD_CAT.admission_cat%TYPE) IS
603: SELECT cacus.cal_type,
604: cacus.location_cd,
605: cacus.attendance_mode,

Line 602: cp_cooac_admission_cat IGS_PS_OF_OPT_AD_CAT.admission_cat%TYPE) IS

598: cp_cooac_cal_type IGS_PS_OF_OPT_AD_CAT.cal_type%TYPE,
599: cp_cooac_location_cd IGS_PS_OF_OPT_AD_CAT.location_cd%TYPE,
600: cp_cooac_attendance_mode IGS_PS_OF_OPT_AD_CAT.attendance_mode%TYPE,
601: cp_cooac_attendance_type IGS_PS_OF_OPT_AD_CAT.attendance_type%TYPE,
602: cp_cooac_admission_cat IGS_PS_OF_OPT_AD_CAT.admission_cat%TYPE) IS
603: SELECT cacus.cal_type,
604: cacus.location_cd,
605: cacus.attendance_mode,
606: cacus.attendance_type,

Line 622: IGS_PS_OF_OPT_AD_CAT_PKG.INSERT_ROW(

618: BEGIN
619: FOR v_cooac_rec IN c_cooac LOOP
620: BEGIN
621: x_rowid := NULL;
622: IGS_PS_OF_OPT_AD_CAT_PKG.INSERT_ROW(
623: X_ROWID => x_rowid,
624: X_COURSE_CD => p_new_course_cd,
625: X_VERSION_NUMBER => p_new_version_number,
626: X_CAL_TYPE => v_cooac_rec.cal_type,

Line 805: -- calling procedure to insert IGS_PS_OF_OPT_AD_CAT records

801: X_COO_ID => gv_coo_seq_num,
802: X_MODE => 'R'
803: );
804: END LOOP; -- coous
805: -- calling procedure to insert IGS_PS_OF_OPT_AD_CAT records
806: -- and its child table IGS_PS_COO_AD_UNIT_S
807: crspl_ins_cooac_rec;
808: EXCEPTION
809: WHEN OTHERS THEN