APPS.IGS_EN_GEN_010 dependencies on IGS_AS_SUA_AI_GROUP

Line 9819: FROM IGS_AS_SUA_AI_GROUP sag

9815: Cursor c_source_ai_group(cp_person_id NUMBER,
9816: cp_source_course_cd VARCHAR2,
9817: cp_source_uoo_id NUMBER) IS
9818: SELECT sag.rowid, sag.*
9819: FROM IGS_AS_SUA_AI_GROUP sag
9820: WHERE sag.person_id = cp_person_id
9821: AND sag.course_cd = cp_source_course_cd
9822: AND sag.uoo_id = cp_source_uoo_id
9823: AND logical_delete_date IS NULL;

Line 9831: FROM IGS_AS_SUA_AI_GROUP

9827: cp_dest_course_cd VARCHAR2,
9828: cp_dest_uoo_id NUMBER,
9829: cp_group_name VARCHAR2) IS
9830: SELECT GROUP_NAME
9831: FROM IGS_AS_SUA_AI_GROUP
9832: WHERE person_id = cp_person_id
9833: and course_cd = cp_dest_course_cd
9834: and uoo_id = cp_dest_uoo_id
9835: and group_name = cp_group_name;

Line 9898: l_group_name IGS_AS_SUA_AI_GROUP.group_name%TYPE;

9894: and suv_source.person_id = cp_person_id
9895: and suv_source.course_cd = cp_source_course_cd;
9896:
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;

Line 9900: l_sua_ass_itemgrp_id IGS_AS_SUA_AI_GROUP.sua_ass_item_group_id%TYPE;

9896:
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;

Line 9924: igs_as_sua_ai_group_pkg.insert_row (

9920: CLOSE c_dest_ai_group;
9921:
9922: --Copy the student unit attempt assessment item groups from the source to the destination
9923: l_rowid := NULL;
9924: igs_as_sua_ai_group_pkg.insert_row (
9925: x_rowid => l_rowid,
9926: x_sua_ass_item_group_id => l_sua_ass_itemgrp_id,
9927: x_person_id => vc_source_ai_group.person_id,
9928: x_course_cd => p_dest_course_cd,

Line 10063: IGS_AS_SUA_AI_GROUP_PKG.DELETE_ROW(x_rowid => vc_source_ai_group.rowid);

10059:
10060: END LOOP;
10061: --delete the assessment item group for the source unit attempt
10062: IF (p_delete_source = TRUE) THEN
10063: IGS_AS_SUA_AI_GROUP_PKG.DELETE_ROW(x_rowid => vc_source_ai_group.rowid);
10064: END IF;
10065:
10066: ELSE
10067: --the assessment item group exists for the destination unit attempt