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_EN_SU_ATTEMPT

Line 51: v_uai_location_cd igs_en_su_attempt.location_cd%TYPE;

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;
52: v_uai_unit_class igs_as_unitass_item.unit_class%TYPE;
53: v_uai_unit_mode igs_as_unitass_item.unit_mode%TYPE;
54: v_create_item BOOLEAN;
55: v_record VARCHAR2 (1024);

Line 83: igs_en_su_attempt sua,

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)
87: AND suaai.logical_delete_dt IS NULL

Line 120: cp_person_id igs_en_su_attempt.person_id%TYPE,

116: AND suaai.ass_id = ai.ass_id
117: AND igs_as_gen_002.assp_get_ai_s_type (ai.ass_id) = 'ASSIGNMENT';
118: --
119: CURSOR c_sua_uai_v (
120: cp_person_id igs_en_su_attempt.person_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,

Line 121: cp_course_cd igs_en_su_attempt.course_cd%TYPE,

117: AND igs_as_gen_002.assp_get_ai_s_type (ai.ass_id) = 'ASSIGNMENT';
118: --
119: CURSOR c_sua_uai_v (
120: cp_person_id igs_en_su_attempt.person_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,

Line 122: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,

118: --
119: CURSOR c_sua_uai_v (
120: cp_person_id igs_en_su_attempt.person_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

Line 123: cp_cal_type igs_en_su_attempt.cal_type%TYPE,

119: CURSOR c_sua_uai_v (
120: cp_person_id igs_en_su_attempt.person_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

Line 124: cp_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,

120: cp_person_id igs_en_su_attempt.person_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,

Line 133: FROM igs_en_su_attempt sua,

129: uai.REFERENCE,
130: uai.location_cd,
131: uai.unit_class,
132: uai.unit_mode
133: FROM igs_en_su_attempt sua,
134: igs_as_unitass_item uai,
135: igs_as_unit_class uc
136: WHERE sua.person_id = cp_person_id
137: AND sua.course_cd = cp_course_cd

Line 150: cp_person_id igs_en_su_attempt.person_id%TYPE,

146: AND uc.closed_ind = 'N'
147: AND igs_as_val_uai.assp_val_sua_ai_acot (uai.ass_id, sua.person_id, sua.course_cd) = 'TRUE';
148: --
149: CURSOR c_lock_suaai (
150: cp_person_id igs_en_su_attempt.person_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,

Line 151: cp_course_cd igs_en_su_attempt.course_cd%TYPE,

147: AND igs_as_val_uai.assp_val_sua_ai_acot (uai.ass_id, sua.person_id, sua.course_cd) = 'TRUE';
148: --
149: CURSOR c_lock_suaai (
150: cp_person_id igs_en_su_attempt.person_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,

Line 152: cp_unit_cd igs_en_su_attempt.unit_cd%TYPE,

148: --
149: CURSOR c_lock_suaai (
150: cp_person_id igs_en_su_attempt.person_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,

Line 153: cp_cal_type igs_en_su_attempt.cal_type%TYPE,

149: CURSOR c_lock_suaai (
150: cp_person_id igs_en_su_attempt.person_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

Line 154: cp_ci_sequence_number igs_en_su_attempt.ci_sequence_number%TYPE,

150: cp_person_id igs_en_su_attempt.person_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

Line 571: FROM igs_en_su_attempt sua,

567: -- Log the exception indicating a lock on the suaai record.
568: v_uai_reference := NULL;
569: SELECT uai.REFERENCE
570: INTO v_uai_reference
571: FROM igs_en_su_attempt sua,
572: igs_as_unitass_item uai,
573: igs_as_unit_class uc
574: WHERE sua.person_id = v_suaai_rec.person_id
575: AND sua.course_cd = v_suaai_rec.course_cd

Line 830: v_previous_unit igs_en_su_attempt.unit_cd%TYPE;

826: v_delete_todo BOOLEAN;
827: v_sle_key igs_ge_s_log_entry.KEY%TYPE;
828: v_new_student BOOLEAN;
829: v_previous_student igs_pe_person.person_id%TYPE;
830: v_previous_unit igs_en_su_attempt.unit_cd%TYPE;
831: v_key igs_ge_s_log.KEY%TYPE;
832: v_message_name VARCHAR2 (30);
833: v_log_dt DATE DEFAULT NULL;
834: v_record VARCHAR2 (255);

Line 854: igs_en_su_attempt_all sua,

850: st.todo_dt,
851: sua.uoo_id
852: FROM igs_pe_std_todo st,
853: igs_pe_std_todo_ref str,
854: igs_en_su_attempt_all sua,
855: igs_as_unit_class uc,
856: igs_ca_inst_rel cir
857: WHERE ((NVL (p_person_id, 9999999999) = 9999999999)
858: OR (st.person_id = p_person_id)

Line 893: CURSOR c_usc_ass (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS

889: --
890: -- Get the Active Assessment Items attached to a Unit Section
891: -- Added by ddey for the bug # 2162831
892: --
893: CURSOR c_usc_ass (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
894: SELECT uai.ass_id
895: FROM igs_ps_unitass_item uai
896: WHERE uai.uoo_id = cp_uoo_id
897: AND uai.logical_delete_dt IS NULL;

Line 1599: FROM igs_en_su_attempt_all sua

1595: AND (suaai.unit_section_ass_item_id = v_uai_rec.ass_item_id
1596: OR suaai.unit_ass_item_id = v_uai_rec.ass_item_id)
1597: AND EXISTS (
1598: SELECT 'X'
1599: FROM igs_en_su_attempt_all sua
1600: WHERE sua.person_id = suaai.person_id
1601: AND sua.course_cd = suaai.course_cd
1602: AND sua.uoo_id = suaai.uoo_id
1603: AND sua.unit_attempt_status IN ('ENROLLED', 'UNCONFIRM', 'WAITLISTED')

Line 1870: cst_enrolled CONSTANT igs_en_su_attempt.unit_attempt_status%TYPE := 'ENROLLED';

1866: -- This routine will create a IGS_PE_STD_TODO entry for students who:
1867: -- 1. have just enrolled
1868: -- 2. had their location and class details changed
1869: DECLARE
1870: cst_enrolled CONSTANT igs_en_su_attempt.unit_attempt_status%TYPE := 'ENROLLED';
1871: cst_completed CONSTANT igs_en_su_attempt.unit_attempt_status%TYPE := 'COMPLETED';
1872: cst_ass_insert CONSTANT VARCHAR2 (15) := 'ASS_INSERT';
1873: cst_ass_change CONSTANT VARCHAR2 (15) := 'ASS_CHANGE';
1874: cst_yes CONSTANT CHAR := 'Y';

Line 1871: cst_completed CONSTANT igs_en_su_attempt.unit_attempt_status%TYPE := 'COMPLETED';

1867: -- 1. have just enrolled
1868: -- 2. had their location and class details changed
1869: DECLARE
1870: cst_enrolled CONSTANT igs_en_su_attempt.unit_attempt_status%TYPE := 'ENROLLED';
1871: cst_completed CONSTANT igs_en_su_attempt.unit_attempt_status%TYPE := 'COMPLETED';
1872: cst_ass_insert CONSTANT VARCHAR2 (15) := 'ASS_INSERT';
1873: cst_ass_change CONSTANT VARCHAR2 (15) := 'ASS_CHANGE';
1874: cst_yes CONSTANT CHAR := 'Y';
1875: v_return_val NUMBER;