[Home] [Help]
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;
152: p_no_assessment_type igs_lookups_view.lookup_code%TYPE;
153: --
154: BEGIN -- assp_ins_admin_grds
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,
271: cp_no_assessment_type igs_en_su_attempt.no_assessment_ind%TYPE
272: ) IS
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,
271: cp_no_assessment_type igs_en_su_attempt.no_assessment_ind%TYPE
272: ) IS
273: SELECT sua.person_id,
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'
291: FROM igs_ca_inst_rel
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 ;
1014: --------------------------------------------------------------------------------------------------------------------------
1015: --Change History:
1126: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1127: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1128: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,
1129: cp_unit_class IGS_EN_SU_ATTEMPT.UNIT_CLASS%TYPE,
1130: cp_unit_mode IGS_AS_UNIT_CLASS.UNIT_MODE%TYPE,
1131: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1132: cp_ass_id IGS_AS_SU_ATMPT_ITM.ass_id%TYPE,
1133: cp_reproduce VARCHAR2
1134: )
1152: FROM
1153: igs_as_su_atmpt_itm suaai,
1154: igs_en_su_attempt sua,
1155: igs_as_assessmnt_itm ai,
1156: igs_as_unit_class uc
1157: WHERE
1158: (cp_person_id IS NULL OR suaai.person_id = cp_person_id)
1159: AND
1160: suaai.logical_delete_dt IS NULL
1341: sua.uoo_id = cp_uoo_id AND
1342: uv.unit_cd = sua.unit_cd AND
1343: uv.version_number = sua.version_number;
1344: CURSOR c_um(
1345: cp_unit_mode IGS_AS_UNIT_CLASS.UNIT_MODE%TYPE) IS
1346: SELECT s_unit_mode
1347: FROM IGS_AS_UNIT_MODE
1348: WHERE UNIT_MODE = cp_unit_mode;
1349:
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,
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
1747: uoo.CAL_TYPE = cp_teach_cal_type AND
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
1765: WHERE uoo.uoo_id = cp_uoo_id AND