APPS.IGS_AS_GEN_001 dependencies on IGS_AS_SU_ATMPT_ITM

Line 14: | Nalin Kumar 24-May-2003 Modified the call to the igs_as_su_atmpt_itm_pkg;

10: | CHANGE HISTORY |
11: +======================================================================+
12: | WHO WHEN WHAT |
13: +======================================================================+
14: | Nalin Kumar 24-May-2003 Modified the call to the igs_as_su_atmpt_itm_pkg;
15: | Added two new parameters x_unit_section_ass_item_id and x_unit_ass_item_id in the call;
16: | This is as per 'Assessment Item description Build'; Bug# 2829291;
17: +======================================================================+*/
18: --

Line 238: FROM igs_as_su_atmpt_itm

234: DECLARE
235: CURSOR c_del_suaai IS
236: SELECT ROWID,
237: tracking_id
238: FROM igs_as_su_atmpt_itm
239: WHERE person_id = p_person_id
240: AND course_cd = p_course_cd
241: AND uoo_id = p_uoo_id
242: FOR UPDATE OF tracking_id NOWAIT;

Line 245: igs_as_su_atmpt_itm_pkg.delete_row (c_del_suaai_rec.ROWID);

241: AND uoo_id = p_uoo_id
242: FOR UPDATE OF tracking_id NOWAIT;
243: c_del_suaai_rec c_del_suaai%ROWTYPE;
244: BEGIN
245: igs_as_su_atmpt_itm_pkg.delete_row (c_del_suaai_rec.ROWID);
246: FOR v_suaai_rec IN c_del_suaai LOOP
247: IF (v_suaai_rec.tracking_id IS NOT NULL) THEN
248: IF igs_tr_gen_002.trkp_del_tri (v_suaai_rec.tracking_id, v_message_name) = FALSE THEN
249: p_message_name := v_message_name;

Line 339: FROM igs_as_su_atmpt_itm suaai,

335: PRAGMA EXCEPTION_INIT (e_resource_busy_exception, -54);
336: CURSOR c_suaai IS
337: SELECT suaai.ROWID row_id,
338: suaai.*
339: FROM igs_as_su_atmpt_itm suaai,
340: igs_en_su_attempt_all sua
341: WHERE suaai.person_id = p_person_id
342: AND suaai.course_cd = p_course_cd
343: AND suaai.uoo_id = p_uoo_id

Line 368: igs_as_su_atmpt_itm_pkg.update_row (

364: -- Perform a logical delete of the system defaulted items. If the p_ass_id is
365: -- set then update only that item regardless of whether it is a default item,
366: -- otherwise update all default items for the student's IGS_PS_UNIT.
367: FOR c_suaai_rec IN c_suaai LOOP
368: igs_as_su_atmpt_itm_pkg.update_row (
369: x_mode => 'R',
370: x_rowid => c_suaai_rec.row_id,
371: x_person_id => c_suaai_rec.person_id,
372: x_course_cd => c_suaai_rec.course_cd,