APPS.IGS_EN_GEN_010 dependencies on IGS_AS_SU_ATMPT_ITM

Line 9852: FROM IGS_AS_SU_ATMPT_ITM asit

9848: cp_course_cd VARCHAR2,
9849: cp_uoo_id NUMBER,
9850: c_sua_ass_item_group_id NUMBER) IS
9851: SELECT asit.rowid, asit.*
9852: FROM IGS_AS_SU_ATMPT_ITM asit
9853: WHERE asit.person_id = cp_person_id
9854: and asit.course_cd = cp_course_cd
9855: and asit.uoo_id = cp_uoo_id
9856: and asit.SUA_ASS_ITEM_GROUP_ID = c_sua_ass_item_group_id

Line 9901: l_usec_ass_item_id igs_as_su_atmpt_itm.unit_section_ass_item_id%TYPE;

9897:
9898: l_group_name IGS_AS_SUA_AI_GROUP.group_name%TYPE;
9899: l_rowid VARCHAR2(25);
9900: l_sua_ass_itemgrp_id IGS_AS_SUA_AI_GROUP.sua_ass_item_group_id%TYPE;
9901: l_usec_ass_item_id igs_as_su_atmpt_itm.unit_section_ass_item_id%TYPE;
9902: l_unit_ass_item_id igs_as_su_atmpt_itm.unit_ass_item_id%TYPE;
9903: l_rowid2 VARCHAR2(25);
9904: l_dummy NUMBER;
9905:

Line 9902: l_unit_ass_item_id igs_as_su_atmpt_itm.unit_ass_item_id%TYPE;

9898: l_group_name IGS_AS_SUA_AI_GROUP.group_name%TYPE;
9899: l_rowid VARCHAR2(25);
9900: l_sua_ass_itemgrp_id IGS_AS_SUA_AI_GROUP.sua_ass_item_group_id%TYPE;
9901: l_usec_ass_item_id igs_as_su_atmpt_itm.unit_section_ass_item_id%TYPE;
9902: l_unit_ass_item_id igs_as_su_atmpt_itm.unit_ass_item_id%TYPE;
9903: l_rowid2 VARCHAR2(25);
9904: l_dummy NUMBER;
9905:
9906: l_suai_valid BOOLEAN;

Line 9997: igs_as_su_atmpt_itm_pkg.insert_row (

9993:
9994: vc_source_su_itm.unit_section_ass_item_id := l_usec_ass_item_id;
9995: vc_source_su_itm.unit_ass_item_id := l_unit_ass_item_id;
9996:
9997: igs_as_su_atmpt_itm_pkg.insert_row (
9998: x_rowid => l_rowid2,
9999: x_person_id => p_person_id,
10000: x_course_cd => p_dest_course_cd,
10001: x_unit_cd => vc_source_su_itm.unit_cd,

Line 10054: IGS_AS_SU_ATMPT_ITM_PKG.delete_row (x_rowid => vc_source_su_itm.rowid);

10050: x_penalty_applied_flag => vc_source_su_itm.penalty_applied_flag );
10051:
10052: --delete the assessment item for the source unit attempt
10053: IF (p_delete_source = TRUE) THEN
10054: IGS_AS_SU_ATMPT_ITM_PKG.delete_row (x_rowid => vc_source_su_itm.rowid);
10055: END IF;
10056:
10057:
10058: END IF;