eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AS_GEN_007 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: | igs_as_unitass_item_pkg; igs_ps_unitass_item_pkg
16: | Added the references of the newly added columns
17: | in the base tables. This is as per 'Assessment
18: | Item description Build'; Bug# 2829291;

Line 47: -- Create a tracking item for a IGS_AS_SU_ATMPT_ITM.

43: ) IS
44: gv_other_detail VARCHAR2 (255);
45: gv_log_created BOOLEAN DEFAULT FALSE;
46: BEGIN -- assp_ins_suaai_tri
47: -- Create a tracking item for a IGS_AS_SU_ATMPT_ITM.
48: DECLARE
49: v_uai_due_dt igs_as_unitass_item.due_dt%TYPE;
50: v_uai_reference igs_as_unitass_item.REFERENCE%TYPE;
51: v_uai_location_cd igs_en_su_attempt.location_cd%TYPE;

Line 82: FROM igs_as_su_atmpt_itm suaai,

78: suaai.creation_dt,
79: suaai.override_due_dt,
80: sua.version_number,
81: sua.uoo_id
82: FROM igs_as_su_atmpt_itm suaai,
83: igs_en_su_attempt sua,
84: igs_as_assessmnt_itm ai,
85: igs_as_unit_class ucl
86: WHERE suaai.person_id = NVL (p_person_id, suaai.person_id)

Line 89: FROM igs_as_su_atmpt_itm suaai2

85: igs_as_unit_class ucl
86: WHERE suaai.person_id = NVL (p_person_id, suaai.person_id)
87: AND suaai.logical_delete_dt IS NULL
88: AND suaai.attempt_number = (SELECT MAX (attempt_number)
89: FROM igs_as_su_atmpt_itm suaai2
90: WHERE suaai2.person_id = suaai.person_id
91: AND suaai2.course_cd = suaai.course_cd
92: AND suaai2.uoo_id = suaai.uoo_id
93: AND suaai2.ass_id = suaai.ass_id)

Line 125: cp_ass_id igs_as_su_atmpt_itm.ass_id%TYPE,

121: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
122: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,
123: cp_cal_type igs_en_su_attempt.cal_type%TYPE,
124: cp_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
125: cp_ass_id igs_as_su_atmpt_itm.ass_id%TYPE,
126: cp_uoo_id igs_as_su_atmpt_itm.uoo_id%TYPE
127: ) IS
128: SELECT uai.due_dt,
129: uai.REFERENCE,

Line 126: cp_uoo_id igs_as_su_atmpt_itm.uoo_id%TYPE

122: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,
123: cp_cal_type igs_en_su_attempt.cal_type%TYPE,
124: cp_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
125: cp_ass_id igs_as_su_atmpt_itm.ass_id%TYPE,
126: cp_uoo_id igs_as_su_atmpt_itm.uoo_id%TYPE
127: ) IS
128: SELECT uai.due_dt,
129: uai.REFERENCE,
130: uai.location_cd,

Line 155: cp_ass_id igs_as_su_atmpt_itm.ass_id%TYPE,

151: cp_course_cd igs_en_su_attempt.course_cd%TYPE,
152: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,
153: cp_cal_type igs_en_su_attempt.cal_type%TYPE,
154: cp_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
155: cp_ass_id igs_as_su_atmpt_itm.ass_id%TYPE,
156: cp_creation_dt DATE,
157: cp_uoo_id igs_as_su_atmpt_itm.uoo_id%TYPE
158: ) IS
159: SELECT ROWID,

Line 157: cp_uoo_id igs_as_su_atmpt_itm.uoo_id%TYPE

153: cp_cal_type igs_en_su_attempt.cal_type%TYPE,
154: cp_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,
155: cp_ass_id igs_as_su_atmpt_itm.ass_id%TYPE,
156: cp_creation_dt DATE,
157: cp_uoo_id igs_as_su_atmpt_itm.uoo_id%TYPE
158: ) IS
159: SELECT ROWID,
160: igs_as_su_atmpt_itm.*
161: FROM igs_as_su_atmpt_itm

Line 160: igs_as_su_atmpt_itm.*

156: cp_creation_dt DATE,
157: cp_uoo_id igs_as_su_atmpt_itm.uoo_id%TYPE
158: ) IS
159: SELECT ROWID,
160: igs_as_su_atmpt_itm.*
161: FROM igs_as_su_atmpt_itm
162: WHERE person_id = cp_person_id
163: AND course_cd = cp_course_cd
164: AND uoo_id = cp_uoo_id

Line 161: FROM igs_as_su_atmpt_itm

157: cp_uoo_id igs_as_su_atmpt_itm.uoo_id%TYPE
158: ) IS
159: SELECT ROWID,
160: igs_as_su_atmpt_itm.*
161: FROM igs_as_su_atmpt_itm
162: WHERE person_id = cp_person_id
163: AND course_cd = cp_course_cd
164: AND uoo_id = cp_uoo_id
165: AND ass_id = cp_ass_id

Line 392: igs_as_su_atmpt_itm_pkg.update_row (

388: END IF;
389: ELSE
390: -- update suaai record that has been selected
391: -- for update nowait with the ID of the tracking item
392: igs_as_su_atmpt_itm_pkg.update_row (
393: x_rowid => c_lock_suaai_rec.ROWID,
394: x_person_id => c_lock_suaai_rec.person_id,
395: x_course_cd => c_lock_suaai_rec.course_cd,
396: x_unit_cd => c_lock_suaai_rec.unit_cd,

Line 1572: UPDATE igs_as_su_atmpt_itm suaai

1568: -- record so that all can be processed again at a later date.
1569: -- Report on the exception.
1570: -- Logically delete the associated suaai record for the Unit Assessment Item.
1571: --
1572: UPDATE igs_as_su_atmpt_itm suaai
1573: SET suaai.logical_delete_dt = SYSDATE,
1574: suaai.last_update_date = SYSDATE,
1575: suaai.last_updated_by = fnd_global.user_id,
1576: suaai.last_update_login = fnd_global.login_id,

Line 1588: FROM igs_as_su_atmpt_itm suaai2

1584: AND suaai.ass_id = v_uai_rec.ass_id
1585: AND suaai.unit_cd = v_uai_rec.unit_cd
1586: AND suaai.logical_delete_dt IS NULL
1587: AND suaai.attempt_number = (SELECT MAX (suaai2.attempt_number)
1588: FROM igs_as_su_atmpt_itm suaai2
1589: WHERE suaai2.person_id = suaai.person_id
1590: AND suaai2.course_cd = suaai.course_cd
1591: AND suaai2.uoo_id = suaai.uoo_id
1592: AND suaai2.ass_id = suaai.ass_id