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

Line 147: p_unit_cd igs_ps_unit.unit_cd%TYPE;

143: p_assess_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
144: p_teach_cal_type igs_ca_inst.cal_type%TYPE;
145: p_teach_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
146: p_org_unit_cd igs_or_unit.org_unit_cd%TYPE;
147: p_unit_cd igs_ps_unit.unit_cd%TYPE;
148: p_location_cd igs_ad_location.location_cd%TYPE;
149: p_unit_mode igs_as_unit_mode.unit_mode%TYPE;
150: p_unit_class igs_as_unit_class.unit_class%TYPE;
151: p_assessable_type igs_lookups_view.lookup_code%TYPE;

Line 266: cp_unit_cd igs_ps_unit.unit_cd%TYPE,

262: cp_assess_sequence_number igs_ca_inst.sequence_number%TYPE,
263: cp_teach_cal_type igs_ca_inst.cal_type%TYPE,
264: cp_teach_sequence_number igs_ca_inst.sequence_number%TYPE,
265: cp_org_unit_cd igs_or_unit.org_unit_cd%TYPE,
266: cp_unit_cd igs_ps_unit.unit_cd%TYPE,
267: cp_location_cd igs_ad_location.location_cd%TYPE,
268: cp_unit_mode igs_as_unit_class.unit_mode%TYPE,
269: cp_unit_class igs_as_unit_class.unit_class%TYPE,
270: cp_assessable_type igs_as_assessmnt_typ.assessment_type%TYPE,

Line 286: igs_ps_unit_ver_all uv,

282: sua.ci_end_dt,
283: sua.uoo_id,
284: sua.no_assessment_ind
285: FROM igs_en_su_attempt_all sua,
286: igs_ps_unit_ver_all uv,
287: igs_as_unit_class_all uc
288: WHERE ((cp_assess_cal_type IS NOT NULL
289: AND EXISTS (
290: SELECT 'x'

Line 913: p_unit_cd IN IGS_PS_UNIT_VER_ALL.unit_cd%TYPE ,

909: App_Exception.Raise_Exception;
910: END assp_ins_aia;
911: PROCEDURE assp_ins_aia_default(
912: p_ass_id IN IGS_AS_ITEM_ASSESSOR.ass_id%TYPE ,
913: p_unit_cd IN IGS_PS_UNIT_VER_ALL.unit_cd%TYPE ,
914: p_version_number IN IGS_PS_UNIT_VER_ALL.version_number%TYPE )
915: IS
916: BEGIN -- assp_ins_aia_default
917: -- Insert a default record into the IGS_AS_ITEM_ASSESSOR table

Line 914: p_version_number IN IGS_PS_UNIT_VER_ALL.version_number%TYPE )

910: END assp_ins_aia;
911: PROCEDURE assp_ins_aia_default(
912: p_ass_id IN IGS_AS_ITEM_ASSESSOR.ass_id%TYPE ,
913: p_unit_cd IN IGS_PS_UNIT_VER_ALL.unit_cd%TYPE ,
914: p_version_number IN IGS_PS_UNIT_VER_ALL.version_number%TYPE )
915: IS
916: BEGIN -- assp_ins_aia_default
917: -- Insert a default record into the IGS_AS_ITEM_ASSESSOR table
918: DECLARE

Line 928: cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,

924: SELECT COUNT(*)
925: FROM IGS_AS_ITEM_ASSESSOR
926: WHERE ass_id = cp_ass_id;
927: CURSOR c_uv(
928: cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,
929: cp_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS
930: SELECT coord_person_id
931: FROM IGS_PS_UNIT_VER
932: WHERE unit_cd = cp_unit_cd AND

Line 929: cp_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS

925: FROM IGS_AS_ITEM_ASSESSOR
926: WHERE ass_id = cp_ass_id;
927: CURSOR c_uv(
928: cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,
929: cp_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS
930: SELECT coord_person_id
931: FROM IGS_PS_UNIT_VER
932: WHERE unit_cd = cp_unit_cd AND
933: version_number = cp_version_number;

Line 931: FROM IGS_PS_UNIT_VER

927: CURSOR c_uv(
928: cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,
929: cp_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS
930: SELECT coord_person_id
931: FROM IGS_PS_UNIT_VER
932: WHERE unit_cd = cp_unit_cd AND
933: version_number = cp_version_number;
934: CURSOR c_asst IS
935: SELECT ASS_ASSESSOR_TYPE

Line 943: v_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE;

939: v_aia_count NUMBER;
940: v_uv_rec c_uv%ROWTYPE;
941: v_asst_rec c_asst%ROWTYPE;
942: v_ass_id IGS_AS_ITEM_ASSESSOR.ass_id%TYPE;
943: v_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE;
944: v_version_number IGS_PS_UNIT_VER.version_number%TYPE;
945: BEGIN
946: -- Initialise all the variables
947: v_ass_id := p_ass_id;

Line 944: v_version_number IGS_PS_UNIT_VER.version_number%TYPE;

940: v_uv_rec c_uv%ROWTYPE;
941: v_asst_rec c_asst%ROWTYPE;
942: v_ass_id IGS_AS_ITEM_ASSESSOR.ass_id%TYPE;
943: v_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE;
944: v_version_number IGS_PS_UNIT_VER.version_number%TYPE;
945: BEGIN
946: -- Initialise all the variables
947: v_ass_id := p_ass_id;
948: v_unit_cd := p_unit_cd;

Line 1009: p_unit_cd IGS_PS_UNIT.UNIT_CD%TYPE;

1005: p_acad_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
1006: p_teach_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1007: p_teach_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
1008: p_course_cd IGS_PS_COURSE.COURSE_CD%TYPE;
1009: p_unit_cd IGS_PS_UNIT.UNIT_CD%TYPE;
1010: p_location_cd IGS_AD_LOCATION.LOCATION_CD%TYPE;
1011: p_unit_class IGS_AS_UNIT_CLASS.UNIT_CLASS%TYPE;
1012: p_unit_mode IGS_AS_UNIT_MODE.UNIT_MODE%TYPE;
1013: p_reproduce IGS_LOOKUPS_VIEW.LOOKUP_CODE%TYPE ;

Line 1337: IGS_PS_UNIT_VER uv

1333: uv.version_number,
1334: uv.short_title
1335: FROM
1336: IGS_EN_SU_ATTEMPT sua,
1337: IGS_PS_UNIT_VER uv
1338: WHERE
1339: sua.person_id = cp_person_id AND
1340: sua.course_cd = cp_course_cd AND
1341: sua.uoo_id = cp_uoo_id AND

Line 1494: -- Reset the last IGS_PS_COURSE and IGS_PS_UNIT codes so that if it is a new IGS_PE_PERSON,

1490: v_ignore_rec := TRUE;
1491: ELSE
1492: CLOSE c_pa;
1493: v_last_person_id := v_enrolled_rec.person_id;
1494: -- Reset the last IGS_PS_COURSE and IGS_PS_UNIT codes so that if it is a new IGS_PE_PERSON,
1495: -- then the appropriate IGS_PS_COURSE and unit version is retrieved.
1496: v_last_course_cd := NULL;
1497: v_last_unit_cd := NULL;
1498:

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 1732: cp_owner_org_unit_cd IGS_PS_UNIT_VER.owner_org_unit_cd%TYPE,

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,
1736: uv.owner_ou_start_dt,

Line 1733: cp_owner_ou_start_dt IGS_PS_UNIT_VER.owner_ou_start_dt%TYPE,

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,
1736: uv.owner_ou_start_dt,
1737: uc.UNIT_MODE,

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 1742: IGS_PS_UNIT_VER uv,

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
1746: uoo.UNIT_CLASS = uc.UNIT_CLASS 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,