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_VAL_ACAI dependencies on IGS_PS_COO_AD_UNIT_S

Line 1694: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,

1690: cp_us_version_number IGS_PS_OF_OPT_UNT_ST.us_version_number%TYPE,
1691: cp_course_cd IGS_PS_OF_OPT_UNT_ST.course_cd%TYPE,
1692: cp_crv_version_number IGS_PS_OF_OPT_UNT_ST.crv_version_number%TYPE,
1693: cp_acad_cal_type IGS_PS_OF_OPT_UNT_ST.cal_type%TYPE,
1694: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,
1695: cp_location_cd IGS_PS_COO_AD_UNIT_S.location_cd%TYPE,
1696: cp_attendance_mode IGS_PS_COO_AD_UNIT_S.attendance_mode%TYPE,
1697: cp_attendance_type IGS_PS_COO_AD_UNIT_S.attendance_type%TYPE) IS
1698: SELECT 1

Line 1695: cp_location_cd IGS_PS_COO_AD_UNIT_S.location_cd%TYPE,

1691: cp_course_cd IGS_PS_OF_OPT_UNT_ST.course_cd%TYPE,
1692: cp_crv_version_number IGS_PS_OF_OPT_UNT_ST.crv_version_number%TYPE,
1693: cp_acad_cal_type IGS_PS_OF_OPT_UNT_ST.cal_type%TYPE,
1694: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,
1695: cp_location_cd IGS_PS_COO_AD_UNIT_S.location_cd%TYPE,
1696: cp_attendance_mode IGS_PS_COO_AD_UNIT_S.attendance_mode%TYPE,
1697: cp_attendance_type IGS_PS_COO_AD_UNIT_S.attendance_type%TYPE) IS
1698: SELECT 1
1699: FROM IGS_PS_OFR_OPT_UNIT_SET_V psusv

Line 1696: cp_attendance_mode IGS_PS_COO_AD_UNIT_S.attendance_mode%TYPE,

1692: cp_crv_version_number IGS_PS_OF_OPT_UNT_ST.crv_version_number%TYPE,
1693: cp_acad_cal_type IGS_PS_OF_OPT_UNT_ST.cal_type%TYPE,
1694: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,
1695: cp_location_cd IGS_PS_COO_AD_UNIT_S.location_cd%TYPE,
1696: cp_attendance_mode IGS_PS_COO_AD_UNIT_S.attendance_mode%TYPE,
1697: cp_attendance_type IGS_PS_COO_AD_UNIT_S.attendance_type%TYPE) IS
1698: SELECT 1
1699: FROM IGS_PS_OFR_OPT_UNIT_SET_V psusv
1700: WHERE psusv.course_cd = cp_course_cd

Line 1697: cp_attendance_type IGS_PS_COO_AD_UNIT_S.attendance_type%TYPE) IS

1693: cp_acad_cal_type IGS_PS_OF_OPT_UNT_ST.cal_type%TYPE,
1694: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,
1695: cp_location_cd IGS_PS_COO_AD_UNIT_S.location_cd%TYPE,
1696: cp_attendance_mode IGS_PS_COO_AD_UNIT_S.attendance_mode%TYPE,
1697: cp_attendance_type IGS_PS_COO_AD_UNIT_S.attendance_type%TYPE) IS
1698: SELECT 1
1699: FROM IGS_PS_OFR_OPT_UNIT_SET_V psusv
1700: WHERE psusv.course_cd = cp_course_cd
1701: AND psusv.crv_version_number = cp_crv_version_number

Line 1710: FROM igs_ps_coo_ad_unit_s psus

1706: AND psusv.attendance_mode = NVL(cp_attendance_mode, psusv.attendance_mode)
1707: AND psusv.attendance_type = NVL(cp_attendance_type, psusv.attendance_type)
1708: AND NOT EXISTS
1709: (SELECT 1
1710: FROM igs_ps_coo_ad_unit_s psus
1711: WHERE psus.course_cd = psusv.course_cd
1712: AND psus.crv_version_number = psusv.crv_version_number
1713: AND psus.cal_type = psusv.cal_type
1714: AND psus.location_cd = psusv.location_cd

Line 1734: FROM igs_ps_coo_ad_unit_s psus,

1730: )
1731: AND psusv.expiry_dt IS NULL
1732: UNION
1733: SELECT 1
1734: FROM igs_ps_coo_ad_unit_s psus,
1735: igs_en_unit_set us
1736: WHERE us.unit_set_cd = psus.unit_set_cd
1737: AND us.version_number = psus.us_version_number
1738: AND psus.unit_set_cd = cp_unit_set_cd

Line 1763: cp_course_cd IGS_PS_COO_AD_UNIT_S.course_cd%TYPE,

1759: AND us.expiry_dt IS NULL;
1760:
1761:
1762: CURSOR c_coacus (
1763: cp_course_cd IGS_PS_COO_AD_UNIT_S.course_cd%TYPE,
1764: cp_crv_version_number IGS_PS_COO_AD_UNIT_S.crv_version_number%TYPE,
1765: cp_acad_cal_type IGS_PS_COO_AD_UNIT_S.cal_type%TYPE,
1766: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,
1767: cp_location_cd IGS_PS_COO_AD_UNIT_S.location_cd%TYPE,

Line 1764: cp_crv_version_number IGS_PS_COO_AD_UNIT_S.crv_version_number%TYPE,

1760:
1761:
1762: CURSOR c_coacus (
1763: cp_course_cd IGS_PS_COO_AD_UNIT_S.course_cd%TYPE,
1764: cp_crv_version_number IGS_PS_COO_AD_UNIT_S.crv_version_number%TYPE,
1765: cp_acad_cal_type IGS_PS_COO_AD_UNIT_S.cal_type%TYPE,
1766: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,
1767: cp_location_cd IGS_PS_COO_AD_UNIT_S.location_cd%TYPE,
1768: cp_attendance_mode IGS_PS_COO_AD_UNIT_S.attendance_mode%TYPE,

Line 1765: cp_acad_cal_type IGS_PS_COO_AD_UNIT_S.cal_type%TYPE,

1761:
1762: CURSOR c_coacus (
1763: cp_course_cd IGS_PS_COO_AD_UNIT_S.course_cd%TYPE,
1764: cp_crv_version_number IGS_PS_COO_AD_UNIT_S.crv_version_number%TYPE,
1765: cp_acad_cal_type IGS_PS_COO_AD_UNIT_S.cal_type%TYPE,
1766: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,
1767: cp_location_cd IGS_PS_COO_AD_UNIT_S.location_cd%TYPE,
1768: cp_attendance_mode IGS_PS_COO_AD_UNIT_S.attendance_mode%TYPE,
1769: cp_attendance_type IGS_PS_COO_AD_UNIT_S.attendance_type%TYPE) IS

Line 1766: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,

1762: CURSOR c_coacus (
1763: cp_course_cd IGS_PS_COO_AD_UNIT_S.course_cd%TYPE,
1764: cp_crv_version_number IGS_PS_COO_AD_UNIT_S.crv_version_number%TYPE,
1765: cp_acad_cal_type IGS_PS_COO_AD_UNIT_S.cal_type%TYPE,
1766: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,
1767: cp_location_cd IGS_PS_COO_AD_UNIT_S.location_cd%TYPE,
1768: cp_attendance_mode IGS_PS_COO_AD_UNIT_S.attendance_mode%TYPE,
1769: cp_attendance_type IGS_PS_COO_AD_UNIT_S.attendance_type%TYPE) IS
1770: SELECT coacus.unit_set_cd,

Line 1767: cp_location_cd IGS_PS_COO_AD_UNIT_S.location_cd%TYPE,

1763: cp_course_cd IGS_PS_COO_AD_UNIT_S.course_cd%TYPE,
1764: cp_crv_version_number IGS_PS_COO_AD_UNIT_S.crv_version_number%TYPE,
1765: cp_acad_cal_type IGS_PS_COO_AD_UNIT_S.cal_type%TYPE,
1766: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,
1767: cp_location_cd IGS_PS_COO_AD_UNIT_S.location_cd%TYPE,
1768: cp_attendance_mode IGS_PS_COO_AD_UNIT_S.attendance_mode%TYPE,
1769: cp_attendance_type IGS_PS_COO_AD_UNIT_S.attendance_type%TYPE) IS
1770: SELECT coacus.unit_set_cd,
1771: coacus.us_version_number,

Line 1768: cp_attendance_mode IGS_PS_COO_AD_UNIT_S.attendance_mode%TYPE,

1764: cp_crv_version_number IGS_PS_COO_AD_UNIT_S.crv_version_number%TYPE,
1765: cp_acad_cal_type IGS_PS_COO_AD_UNIT_S.cal_type%TYPE,
1766: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,
1767: cp_location_cd IGS_PS_COO_AD_UNIT_S.location_cd%TYPE,
1768: cp_attendance_mode IGS_PS_COO_AD_UNIT_S.attendance_mode%TYPE,
1769: cp_attendance_type IGS_PS_COO_AD_UNIT_S.attendance_type%TYPE) IS
1770: SELECT coacus.unit_set_cd,
1771: coacus.us_version_number,
1772: coacus.location_cd,

Line 1769: cp_attendance_type IGS_PS_COO_AD_UNIT_S.attendance_type%TYPE) IS

1765: cp_acad_cal_type IGS_PS_COO_AD_UNIT_S.cal_type%TYPE,
1766: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,
1767: cp_location_cd IGS_PS_COO_AD_UNIT_S.location_cd%TYPE,
1768: cp_attendance_mode IGS_PS_COO_AD_UNIT_S.attendance_mode%TYPE,
1769: cp_attendance_type IGS_PS_COO_AD_UNIT_S.attendance_type%TYPE) IS
1770: SELECT coacus.unit_set_cd,
1771: coacus.us_version_number,
1772: coacus.location_cd,
1773: coacus.attendance_mode,

Line 1775: FROM IGS_PS_COO_AD_UNIT_S coacus

1771: coacus.us_version_number,
1772: coacus.location_cd,
1773: coacus.attendance_mode,
1774: coacus.attendance_type
1775: FROM IGS_PS_COO_AD_UNIT_S coacus
1776: WHERE coacus.course_cd = cp_course_cd AND
1777: coacus.crv_version_number = cp_crv_version_number AND
1778: coacus.cal_type = cp_acad_cal_type AND
1779: coacus.admission_cat = cp_admission_cat AND