APPS.IGS_AS_GEN_005 dependencies on IGS_AS_UNITASS_ITEM

Line 326: cp_version_number igs_as_unitass_item.version_number%TYPE,

322: AND suv.uai_dflt_item_ind = cst_yes
323: AND suv.uai_logical_delete_dt IS NULL;
324: CURSOR c_uai (
325: cp_unit_cd igs_as_su_atmpt_itm.unit_cd%TYPE,
326: cp_version_number igs_as_unitass_item.version_number%TYPE,
327: cp_cal_type igs_as_su_atmpt_itm.cal_type%TYPE,
328: cp_ci_sequence_number igs_as_su_atmpt_itm.ci_sequence_number%TYPE
329: ) IS
330: SELECT DISTINCT ass_id,

Line 339: FROM igs_as_unitass_item

335: final_mandatory_type_code ,
336: final_weight_qty ,
337: grading_schema_cd ,
338: gs_version_number
339: FROM igs_as_unitass_item
340: WHERE unit_cd = cp_unit_cd
341: AND version_number = cp_version_number
342: AND cal_type = cp_cal_type
343: AND ci_sequence_number = cp_ci_sequence_number

Line 483: p_ass_id IN igs_as_unitass_item_all.ass_id%TYPE,

479: NULL;
480: END assp_upd_suaap_dflt;
481:
482: FUNCTION assp_upd_uai_action (
483: p_ass_id IN igs_as_unitass_item_all.ass_id%TYPE,
484: p_message_name OUT NOCOPY VARCHAR2
485: ) RETURN BOOLEAN IS
486: e_resource_busy EXCEPTION;
487: PRAGMA EXCEPTION_INIT (e_resource_busy, -54);

Line 488: CURSOR c_uai (cp_ass_id igs_as_unitass_item.ass_id%TYPE) IS

484: p_message_name OUT NOCOPY VARCHAR2
485: ) RETURN BOOLEAN IS
486: e_resource_busy EXCEPTION;
487: PRAGMA EXCEPTION_INIT (e_resource_busy, -54);
488: CURSOR c_uai (cp_ass_id igs_as_unitass_item.ass_id%TYPE) IS
489: SELECT uai.ass_id
490: FROM igs_ca_stat cs,
491: igs_ca_inst ci,
492: igs_ps_unit_stat ust,

Line 494: igs_as_unitass_item uai

490: FROM igs_ca_stat cs,
491: igs_ca_inst ci,
492: igs_ps_unit_stat ust,
493: igs_ps_unit_ver uv,
494: igs_as_unitass_item uai
495: WHERE cs.s_cal_status <> 'INACTIVE'
496: AND ci.cal_status = cs.cal_status
497: AND uai.ci_sequence_number = ci.sequence_number
498: AND uai.cal_type = ci.cal_type

Line 521: UPDATE igs_as_unitass_item uai

517: v_sysdate := SYSDATE;
518: v_record_found := FALSE;
519: FOR v_uai_rec IN c_uai (p_ass_id) LOOP
520: v_record_found := TRUE;
521: UPDATE igs_as_unitass_item uai
522: SET uai.action_dt = v_sysdate
523: WHERE CURRENT OF c_uai;
524: END LOOP;
525: RETURN TRUE;

Line 757: -- still valid for the student. The IGS_AS_UNITASS_ITEM may have been

753: -- This routine is called from the process that determines if changes have
754: -- been made to unit_assessment_items and applies them to the
755: -- stdnt_unit_atmpt_ass_items.
756: -- This routine will determine if the IGS_AS_SU_ATMPT_ITM is
757: -- still valid for the student. The IGS_AS_UNITASS_ITEM may have been
758: -- updated and for example the location code may have been altered from
759: -- GEELONG to BURWOOD, making the assessment item for the GEELONG student
760: -- no longer valid. In such a case it will logically delete the assessment
761: -- item.