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.

[Home] [Help]

APPS.IGS_AD_GEN_014 dependencies on IGS_PS_COO_AD_UNIT_S

Line 1548: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,

1544: cp_us_version_number IGS_PS_OF_OPT_UNT_ST.us_version_number%TYPE,
1545: cp_course_cd IGS_PS_OF_OPT_UNT_ST.course_cd%TYPE,
1546: cp_crv_version_number IGS_PS_OF_OPT_UNT_ST.crv_version_number%TYPE,
1547: cp_acad_cal_type IGS_PS_OF_OPT_UNT_ST.cal_type%TYPE,
1548: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,
1549: cp_location_cd IGS_PS_COO_AD_UNIT_S.location_cd%TYPE,
1550: cp_attendance_mode IGS_PS_COO_AD_UNIT_S.attendance_mode%TYPE,
1551: cp_attendance_type IGS_PS_COO_AD_UNIT_S.attendance_type%TYPE) IS
1552: SELECT 1

Line 1549: cp_location_cd IGS_PS_COO_AD_UNIT_S.location_cd%TYPE,

1545: cp_course_cd IGS_PS_OF_OPT_UNT_ST.course_cd%TYPE,
1546: cp_crv_version_number IGS_PS_OF_OPT_UNT_ST.crv_version_number%TYPE,
1547: cp_acad_cal_type IGS_PS_OF_OPT_UNT_ST.cal_type%TYPE,
1548: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,
1549: cp_location_cd IGS_PS_COO_AD_UNIT_S.location_cd%TYPE,
1550: cp_attendance_mode IGS_PS_COO_AD_UNIT_S.attendance_mode%TYPE,
1551: cp_attendance_type IGS_PS_COO_AD_UNIT_S.attendance_type%TYPE) IS
1552: SELECT 1
1553: FROM IGS_PS_OFR_OPT_UNIT_SET_V psusv

Line 1550: cp_attendance_mode IGS_PS_COO_AD_UNIT_S.attendance_mode%TYPE,

1546: cp_crv_version_number IGS_PS_OF_OPT_UNT_ST.crv_version_number%TYPE,
1547: cp_acad_cal_type IGS_PS_OF_OPT_UNT_ST.cal_type%TYPE,
1548: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,
1549: cp_location_cd IGS_PS_COO_AD_UNIT_S.location_cd%TYPE,
1550: cp_attendance_mode IGS_PS_COO_AD_UNIT_S.attendance_mode%TYPE,
1551: cp_attendance_type IGS_PS_COO_AD_UNIT_S.attendance_type%TYPE) IS
1552: SELECT 1
1553: FROM IGS_PS_OFR_OPT_UNIT_SET_V psusv
1554: WHERE psusv.course_cd = cp_course_cd

Line 1551: cp_attendance_type IGS_PS_COO_AD_UNIT_S.attendance_type%TYPE) IS

1547: cp_acad_cal_type IGS_PS_OF_OPT_UNT_ST.cal_type%TYPE,
1548: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,
1549: cp_location_cd IGS_PS_COO_AD_UNIT_S.location_cd%TYPE,
1550: cp_attendance_mode IGS_PS_COO_AD_UNIT_S.attendance_mode%TYPE,
1551: cp_attendance_type IGS_PS_COO_AD_UNIT_S.attendance_type%TYPE) IS
1552: SELECT 1
1553: FROM IGS_PS_OFR_OPT_UNIT_SET_V psusv
1554: WHERE psusv.course_cd = cp_course_cd
1555: AND psusv.crv_version_number = cp_crv_version_number

Line 1564: FROM igs_ps_coo_ad_unit_s psus

1560: AND psusv.attendance_mode = NVL(cp_attendance_mode, psusv.attendance_mode)
1561: AND psusv.attendance_type = NVL(cp_attendance_type, psusv.attendance_type)
1562: AND NOT EXISTS
1563: (SELECT 1
1564: FROM igs_ps_coo_ad_unit_s psus
1565: WHERE psus.course_cd = psusv.course_cd
1566: AND psus.crv_version_number = psusv.crv_version_number
1567: AND psus.cal_type = psusv.cal_type
1568: AND psus.location_cd = psusv.location_cd

Line 1588: FROM igs_ps_coo_ad_unit_s psus,

1584: )
1585: AND psusv.expiry_dt IS NULL
1586: UNION
1587: SELECT 1
1588: FROM igs_ps_coo_ad_unit_s psus,
1589: igs_en_unit_set us
1590: WHERE us.unit_set_cd = psus.unit_set_cd
1591: AND us.version_number = psus.us_version_number
1592: AND psus.unit_set_cd = cp_unit_set_cd

Line 1616: cp_course_cd IGS_PS_COO_AD_UNIT_S.course_cd%TYPE,

1612: )
1613: AND us.expiry_dt IS NULL;
1614:
1615: CURSOR c_coacus (
1616: cp_course_cd IGS_PS_COO_AD_UNIT_S.course_cd%TYPE,
1617: cp_crv_version_number IGS_PS_COO_AD_UNIT_S.crv_version_number%TYPE,
1618: cp_acad_cal_type IGS_PS_COO_AD_UNIT_S.cal_type%TYPE,
1619: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,
1620: cp_location_cd IGS_PS_COO_AD_UNIT_S.location_cd%TYPE,

Line 1617: cp_crv_version_number IGS_PS_COO_AD_UNIT_S.crv_version_number%TYPE,

1613: AND us.expiry_dt IS NULL;
1614:
1615: CURSOR c_coacus (
1616: cp_course_cd IGS_PS_COO_AD_UNIT_S.course_cd%TYPE,
1617: cp_crv_version_number IGS_PS_COO_AD_UNIT_S.crv_version_number%TYPE,
1618: cp_acad_cal_type IGS_PS_COO_AD_UNIT_S.cal_type%TYPE,
1619: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,
1620: cp_location_cd IGS_PS_COO_AD_UNIT_S.location_cd%TYPE,
1621: cp_attendance_mode IGS_PS_COO_AD_UNIT_S.attendance_mode%TYPE,

Line 1618: cp_acad_cal_type IGS_PS_COO_AD_UNIT_S.cal_type%TYPE,

1614:
1615: CURSOR c_coacus (
1616: cp_course_cd IGS_PS_COO_AD_UNIT_S.course_cd%TYPE,
1617: cp_crv_version_number IGS_PS_COO_AD_UNIT_S.crv_version_number%TYPE,
1618: cp_acad_cal_type IGS_PS_COO_AD_UNIT_S.cal_type%TYPE,
1619: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,
1620: cp_location_cd IGS_PS_COO_AD_UNIT_S.location_cd%TYPE,
1621: cp_attendance_mode IGS_PS_COO_AD_UNIT_S.attendance_mode%TYPE,
1622: cp_attendance_type IGS_PS_COO_AD_UNIT_S.attendance_type%TYPE) IS

Line 1619: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,

1615: CURSOR c_coacus (
1616: cp_course_cd IGS_PS_COO_AD_UNIT_S.course_cd%TYPE,
1617: cp_crv_version_number IGS_PS_COO_AD_UNIT_S.crv_version_number%TYPE,
1618: cp_acad_cal_type IGS_PS_COO_AD_UNIT_S.cal_type%TYPE,
1619: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,
1620: cp_location_cd IGS_PS_COO_AD_UNIT_S.location_cd%TYPE,
1621: cp_attendance_mode IGS_PS_COO_AD_UNIT_S.attendance_mode%TYPE,
1622: cp_attendance_type IGS_PS_COO_AD_UNIT_S.attendance_type%TYPE) IS
1623: SELECT coacus.unit_set_cd,

Line 1620: cp_location_cd IGS_PS_COO_AD_UNIT_S.location_cd%TYPE,

1616: cp_course_cd IGS_PS_COO_AD_UNIT_S.course_cd%TYPE,
1617: cp_crv_version_number IGS_PS_COO_AD_UNIT_S.crv_version_number%TYPE,
1618: cp_acad_cal_type IGS_PS_COO_AD_UNIT_S.cal_type%TYPE,
1619: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,
1620: cp_location_cd IGS_PS_COO_AD_UNIT_S.location_cd%TYPE,
1621: cp_attendance_mode IGS_PS_COO_AD_UNIT_S.attendance_mode%TYPE,
1622: cp_attendance_type IGS_PS_COO_AD_UNIT_S.attendance_type%TYPE) IS
1623: SELECT coacus.unit_set_cd,
1624: coacus.us_version_number,

Line 1621: cp_attendance_mode IGS_PS_COO_AD_UNIT_S.attendance_mode%TYPE,

1617: cp_crv_version_number IGS_PS_COO_AD_UNIT_S.crv_version_number%TYPE,
1618: cp_acad_cal_type IGS_PS_COO_AD_UNIT_S.cal_type%TYPE,
1619: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,
1620: cp_location_cd IGS_PS_COO_AD_UNIT_S.location_cd%TYPE,
1621: cp_attendance_mode IGS_PS_COO_AD_UNIT_S.attendance_mode%TYPE,
1622: cp_attendance_type IGS_PS_COO_AD_UNIT_S.attendance_type%TYPE) IS
1623: SELECT coacus.unit_set_cd,
1624: coacus.us_version_number,
1625: coacus.location_cd,

Line 1622: cp_attendance_type IGS_PS_COO_AD_UNIT_S.attendance_type%TYPE) IS

1618: cp_acad_cal_type IGS_PS_COO_AD_UNIT_S.cal_type%TYPE,
1619: cp_admission_cat IGS_PS_COO_AD_UNIT_S.admission_cat%TYPE,
1620: cp_location_cd IGS_PS_COO_AD_UNIT_S.location_cd%TYPE,
1621: cp_attendance_mode IGS_PS_COO_AD_UNIT_S.attendance_mode%TYPE,
1622: cp_attendance_type IGS_PS_COO_AD_UNIT_S.attendance_type%TYPE) IS
1623: SELECT coacus.unit_set_cd,
1624: coacus.us_version_number,
1625: coacus.location_cd,
1626: coacus.attendance_mode,

Line 1628: FROM IGS_PS_COO_AD_UNIT_S coacus

1624: coacus.us_version_number,
1625: coacus.location_cd,
1626: coacus.attendance_mode,
1627: coacus.attendance_type
1628: FROM IGS_PS_COO_AD_UNIT_S coacus
1629: WHERE coacus.course_cd = cp_course_cd AND
1630: coacus.crv_version_number = cp_crv_version_number AND
1631: coacus.cal_type = cp_acad_cal_type AND
1632: coacus.admission_cat = cp_admission_cat AND