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.

[Home] [Help]

APPS.IGS_AS_GEN_005 dependencies on IGS_AS_SU_ATMPT_ITM

Line 280: cp_person_id igs_as_su_atmpt_itm.person_id%TYPE,

276: AND location_cd = p_location_cd
277: AND unit_class = p_unit_class;
278: rec_uoo_id cur_uoo_id%ROWTYPE;
279: CURSOR c_suaai (
280: cp_person_id igs_as_su_atmpt_itm.person_id%TYPE,
281: cp_course_cd igs_as_su_atmpt_itm.course_cd%TYPE,
282: cp_unit_cd igs_as_su_atmpt_itm.unit_cd%TYPE,
283: cp_cal_type igs_as_su_atmpt_itm.cal_type%TYPE,
284: cp_ci_sequence_number igs_as_su_atmpt_itm.ci_sequence_number%TYPE,

Line 281: cp_course_cd igs_as_su_atmpt_itm.course_cd%TYPE,

277: AND unit_class = p_unit_class;
278: rec_uoo_id cur_uoo_id%ROWTYPE;
279: CURSOR c_suaai (
280: cp_person_id igs_as_su_atmpt_itm.person_id%TYPE,
281: cp_course_cd igs_as_su_atmpt_itm.course_cd%TYPE,
282: cp_unit_cd igs_as_su_atmpt_itm.unit_cd%TYPE,
283: cp_cal_type igs_as_su_atmpt_itm.cal_type%TYPE,
284: cp_ci_sequence_number igs_as_su_atmpt_itm.ci_sequence_number%TYPE,
285: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE

Line 282: cp_unit_cd igs_as_su_atmpt_itm.unit_cd%TYPE,

278: rec_uoo_id cur_uoo_id%ROWTYPE;
279: CURSOR c_suaai (
280: cp_person_id igs_as_su_atmpt_itm.person_id%TYPE,
281: cp_course_cd igs_as_su_atmpt_itm.course_cd%TYPE,
282: cp_unit_cd igs_as_su_atmpt_itm.unit_cd%TYPE,
283: cp_cal_type igs_as_su_atmpt_itm.cal_type%TYPE,
284: cp_ci_sequence_number igs_as_su_atmpt_itm.ci_sequence_number%TYPE,
285: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE
286: ) IS

Line 283: cp_cal_type igs_as_su_atmpt_itm.cal_type%TYPE,

279: CURSOR c_suaai (
280: cp_person_id igs_as_su_atmpt_itm.person_id%TYPE,
281: cp_course_cd igs_as_su_atmpt_itm.course_cd%TYPE,
282: cp_unit_cd igs_as_su_atmpt_itm.unit_cd%TYPE,
283: cp_cal_type igs_as_su_atmpt_itm.cal_type%TYPE,
284: cp_ci_sequence_number igs_as_su_atmpt_itm.ci_sequence_number%TYPE,
285: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE
286: ) IS
287: SELECT suaai.ass_id,

Line 284: cp_ci_sequence_number igs_as_su_atmpt_itm.ci_sequence_number%TYPE,

280: cp_person_id igs_as_su_atmpt_itm.person_id%TYPE,
281: cp_course_cd igs_as_su_atmpt_itm.course_cd%TYPE,
282: cp_unit_cd igs_as_su_atmpt_itm.unit_cd%TYPE,
283: cp_cal_type igs_as_su_atmpt_itm.cal_type%TYPE,
284: cp_ci_sequence_number igs_as_su_atmpt_itm.ci_sequence_number%TYPE,
285: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE
286: ) IS
287: SELECT suaai.ass_id,
288: suaai.unit_section_ass_item_id,

Line 290: FROM igs_as_su_atmpt_itm suaai,

286: ) IS
287: SELECT suaai.ass_id,
288: suaai.unit_section_ass_item_id,
289: suaai.unit_ass_item_id
290: FROM igs_as_su_atmpt_itm suaai,
291: igs_en_su_attempt_all sua
292: WHERE suaai.person_id = cp_person_id
293: AND suaai.course_cd = cp_course_cd
294: AND suaai.uoo_id = cp_uoo_id

Line 300: FROM igs_as_su_atmpt_itm suaai2

296: AND sua.course_cd = suaai.course_cd
297: AND sua.uoo_id = suaai.uoo_id
298: AND sua.unit_attempt_status IN ('ENROLLED', 'UNCONFIRM', 'WAITLISTED')
299: AND suaai.attempt_number = (SELECT MAX (attempt_number)
300: FROM igs_as_su_atmpt_itm suaai2
301: WHERE suaai2.person_id = cp_person_id
302: AND suaai2.course_cd = cp_course_cd
303: AND suaai2.uoo_id = cp_uoo_id
304: AND suaai2.ass_id = suaai.ass_id)

Line 308: cp_person_id igs_as_su_atmpt_itm.person_id%TYPE,

304: AND suaai2.ass_id = suaai.ass_id)
305: AND suaai.s_default_ind = cst_yes
306: AND suaai.logical_delete_dt IS NULL;
307: CURSOR c_suv (
308: cp_person_id igs_as_su_atmpt_itm.person_id%TYPE,
309: cp_course_cd igs_as_su_atmpt_itm.course_cd%TYPE,
310: cp_unit_cd igs_as_su_atmpt_itm.unit_cd%TYPE,
311: cp_cal_type igs_as_su_atmpt_itm.cal_type%TYPE,
312: cp_ci_sequence_number igs_as_su_atmpt_itm.ci_sequence_number%TYPE,

Line 309: cp_course_cd igs_as_su_atmpt_itm.course_cd%TYPE,

305: AND suaai.s_default_ind = cst_yes
306: AND suaai.logical_delete_dt IS NULL;
307: CURSOR c_suv (
308: cp_person_id igs_as_su_atmpt_itm.person_id%TYPE,
309: cp_course_cd igs_as_su_atmpt_itm.course_cd%TYPE,
310: cp_unit_cd igs_as_su_atmpt_itm.unit_cd%TYPE,
311: cp_cal_type igs_as_su_atmpt_itm.cal_type%TYPE,
312: cp_ci_sequence_number igs_as_su_atmpt_itm.ci_sequence_number%TYPE,
313: cp_ass_id igs_as_su_atmpt_itm.ass_id%TYPE,

Line 310: cp_unit_cd igs_as_su_atmpt_itm.unit_cd%TYPE,

306: AND suaai.logical_delete_dt IS NULL;
307: CURSOR c_suv (
308: cp_person_id igs_as_su_atmpt_itm.person_id%TYPE,
309: cp_course_cd igs_as_su_atmpt_itm.course_cd%TYPE,
310: cp_unit_cd igs_as_su_atmpt_itm.unit_cd%TYPE,
311: cp_cal_type igs_as_su_atmpt_itm.cal_type%TYPE,
312: cp_ci_sequence_number igs_as_su_atmpt_itm.ci_sequence_number%TYPE,
313: cp_ass_id igs_as_su_atmpt_itm.ass_id%TYPE,
314: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE

Line 311: cp_cal_type igs_as_su_atmpt_itm.cal_type%TYPE,

307: CURSOR c_suv (
308: cp_person_id igs_as_su_atmpt_itm.person_id%TYPE,
309: cp_course_cd igs_as_su_atmpt_itm.course_cd%TYPE,
310: cp_unit_cd igs_as_su_atmpt_itm.unit_cd%TYPE,
311: cp_cal_type igs_as_su_atmpt_itm.cal_type%TYPE,
312: cp_ci_sequence_number igs_as_su_atmpt_itm.ci_sequence_number%TYPE,
313: cp_ass_id igs_as_su_atmpt_itm.ass_id%TYPE,
314: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE
315: ) IS

Line 312: cp_ci_sequence_number igs_as_su_atmpt_itm.ci_sequence_number%TYPE,

308: cp_person_id igs_as_su_atmpt_itm.person_id%TYPE,
309: cp_course_cd igs_as_su_atmpt_itm.course_cd%TYPE,
310: cp_unit_cd igs_as_su_atmpt_itm.unit_cd%TYPE,
311: cp_cal_type igs_as_su_atmpt_itm.cal_type%TYPE,
312: cp_ci_sequence_number igs_as_su_atmpt_itm.ci_sequence_number%TYPE,
313: cp_ass_id igs_as_su_atmpt_itm.ass_id%TYPE,
314: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE
315: ) IS
316: SELECT suv.ass_id

Line 313: cp_ass_id igs_as_su_atmpt_itm.ass_id%TYPE,

309: cp_course_cd igs_as_su_atmpt_itm.course_cd%TYPE,
310: cp_unit_cd igs_as_su_atmpt_itm.unit_cd%TYPE,
311: cp_cal_type igs_as_su_atmpt_itm.cal_type%TYPE,
312: cp_ci_sequence_number igs_as_su_atmpt_itm.ci_sequence_number%TYPE,
313: cp_ass_id igs_as_su_atmpt_itm.ass_id%TYPE,
314: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE
315: ) IS
316: SELECT suv.ass_id
317: FROM igs_as_uai_sua_v suv

Line 325: cp_unit_cd igs_as_su_atmpt_itm.unit_cd%TYPE,

321: AND suv.ass_id = cp_ass_id
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

Line 327: cp_cal_type igs_as_su_atmpt_itm.cal_type%TYPE,

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,
331: unit_ass_item_id,

Line 328: cp_ci_sequence_number igs_as_su_atmpt_itm.ci_sequence_number%TYPE

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,
331: unit_ass_item_id,
332: unit_ass_item_group_id,

Line 349: l_ass_id igs_as_su_atmpt_itm.unit_ass_item_id%TYPE;

345: AND logical_delete_dt IS NULL;
346: v_suaai_rec c_suaai%ROWTYPE;
347: v_uai_rec c_uai%ROWTYPE;
348: v_suv_rec c_suv%ROWTYPE;
349: l_ass_id igs_as_su_atmpt_itm.unit_ass_item_id%TYPE;
350: BEGIN
351: -- Set the default message number
352: p_message_name := NULL;
353: OPEN cur_uoo_id;

Line 756: -- This routine will determine if the IGS_AS_SU_ATMPT_ITM is

752: BEGIN -- assp_mnt_suaai_uai
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

Line 808: FROM igs_as_su_atmpt_itm

804: cp_course_cd VARCHAR2,
805: cp_uoo_id NUMBER
806: ) IS
807: SELECT 'X'
808: FROM igs_as_su_atmpt_itm
809: WHERE person_id = cp_person_id
810: AND course_cd = cp_course_cd
811: AND uoo_id = cp_uoo_id
812: AND unit_section_ass_item_id IS NOT NULL

Line 846: UPDATE igs_as_su_atmpt_itm suaai

842: FETCH cur_as_prg_type INTO rec_as_prg_type;
843: IF (cur_as_prg_type%FOUND) THEN
844: CLOSE cur_as_prg_type;
845: --
846: UPDATE igs_as_su_atmpt_itm suaai
847: SET suaai.logical_delete_dt = SYSDATE,
848: suaai.last_update_date = SYSDATE,
849: suaai.last_updated_by = fnd_global.user_id,
850: suaai.last_update_login = fnd_global.login_id,

Line 864: FROM igs_as_su_atmpt_itm suaai2

860: AND (suaai.unit_section_ass_item_id = p_ass_item_id
861: OR suaai.unit_ass_item_id = p_ass_item_id)
862: AND suaai.attempt_number = (
863: SELECT MAX (suaai2.attempt_number)
864: FROM igs_as_su_atmpt_itm suaai2
865: WHERE suaai2.person_id = suaai.person_id
866: AND suaai2.course_cd = suaai.course_cd
867: AND suaai2.uoo_id = suaai.uoo_id
868: AND suaai2.ass_id = suaai.ass_id