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_AS_GEN_006 dependencies on IGS_PS_UNIT_OFR_OPT

Line 1730: cp_teach_cal_type IGS_PS_UNIT_OFR_OPT.CAL_TYPE%TYPE,

1726: cst_no) = cst_yes;
1727: -- Cursor to get the relevant unit offering option and assessment item
1728: -- within the nominated teaching period, org unit and mode.
1729: CURSOR c_uoo(
1730: cp_teach_cal_type IGS_PS_UNIT_OFR_OPT.CAL_TYPE%TYPE,
1731: cp_teach_ci_sequence_number IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE,
1732: cp_owner_org_unit_cd IGS_PS_UNIT_VER.owner_org_unit_cd%TYPE,
1733: cp_owner_ou_start_dt IGS_PS_UNIT_VER.owner_ou_start_dt%TYPE,
1734: cp_unit_mode IGS_AS_UNIT_CLASS.UNIT_MODE%TYPE) IS

Line 1731: cp_teach_ci_sequence_number IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE,

1727: -- Cursor to get the relevant unit offering option and assessment item
1728: -- within the nominated teaching period, org unit and mode.
1729: CURSOR c_uoo(
1730: cp_teach_cal_type IGS_PS_UNIT_OFR_OPT.CAL_TYPE%TYPE,
1731: cp_teach_ci_sequence_number IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE,
1732: cp_owner_org_unit_cd IGS_PS_UNIT_VER.owner_org_unit_cd%TYPE,
1733: cp_owner_ou_start_dt IGS_PS_UNIT_VER.owner_ou_start_dt%TYPE,
1734: cp_unit_mode IGS_AS_UNIT_CLASS.UNIT_MODE%TYPE) IS
1735: SELECT uv.owner_org_unit_cd,

Line 1741: FROM IGS_PS_UNIT_OFR_OPT uoo,

1737: uc.UNIT_MODE,
1738: uv.unit_cd,
1739: uv.version_number,
1740: uoo.uoo_id
1741: FROM IGS_PS_UNIT_OFR_OPT uoo,
1742: IGS_PS_UNIT_VER uv,
1743: IGS_AS_UNIT_CLASS uc
1744: WHERE uoo.unit_cd = uv.unit_cd AND
1745: uoo.version_number = uv.version_number AND

Line 1756: cp_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS

1752: -- Cursor to get the relevant assessment item
1753: -- within the nominated unit offering option,
1754: -- teaching period, org unit and mode.
1755: CURSOR c_uai(
1756: cp_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS
1757: SELECT uai.ass_id,
1758: uai.due_dt,
1759: IGS_GE_GEN_001.genp_clc_week_end_dt(uai.due_dt) uai_week_ending_dt
1760: FROM IGS_PS_UNIT_OFR_OPT uoo,

Line 1760: FROM IGS_PS_UNIT_OFR_OPT uoo,

1756: cp_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS
1757: SELECT uai.ass_id,
1758: uai.due_dt,
1759: IGS_GE_GEN_001.genp_clc_week_end_dt(uai.due_dt) uai_week_ending_dt
1760: FROM IGS_PS_UNIT_OFR_OPT uoo,
1761: -- IGS_AS_UNIT_CLASS uc,
1762: IGS_AS_UNITASS_ITEM uai,
1763: IGS_AS_ASSESSMNT_ITM ai,
1764: IGS_AS_ASSESSMNT_TYP atyp

Line 1784: cp_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE,

1780: uai.logical_delete_dt IS NULL AND
1781: atyp.ASSESSMENT_TYPE = ai.ASSESSMENT_TYPE AND
1782: NVL(atyp.s_assessment_type, cst_none) = cst_assignment;
1783: CURSOR c_suaai(
1784: cp_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE,
1785: cp_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE) IS
1786: SELECT suaai.override_due_dt,
1787: trst.completion_dt
1788: FROM IGS_AS_SU_ATMPT_ITM suaai,