APPS.IGS_SESSION_VALIDITY dependencies on IGS_EN_SU_ATTEMPT

Line 122: igs_en_su_attempt_all

118: CURSOR all_sessions_cur IS
119: SELECT
120: DISTINCT session_id
121: FROM
122: igs_en_su_attempt_all
123: WHERE
124: cart = 'S';
125:
126: /**

Line 135: igs_en_su_attempt_all

131: CURSOR unit_attempt_del_cur (c_session_id NUMBER) IS
132: SELECT
133: rowid row_id, person_id
134: FROM
135: igs_en_su_attempt_all
136: WHERE
137: session_id = c_session_id AND
138: cart = 'S'
139: ORDER BY sup_unit_cd ASC;

Line 152: igs_en_su_attempt_all

148: CURSOR std_unit_attempt_del_cur (c_session_id NUMBER) IS
149: SELECT
150: rowid row_id, person_id
151: FROM
152: igs_en_su_attempt_all
153: WHERE
154: session_id = c_session_id AND
155: cart = 'S' AND
156: ss_source_ind <> 'A'

Line 167: igs_en_su_attempt_all

163: CURSOR all_stud_sessions_cur IS
164: SELECT
165: DISTINCT session_id
166: FROM
167: igs_en_su_attempt_all
168: WHERE cart = 'S'
169: AND ss_source_ind <> 'A';
170:
171: /**

Line 176: FROM igs_en_su_attempt

172: Cursor to select all the distinct session ids of cart, created from planned sheet and swap page.
173: */
174: CURSOR c_stud_cart_ses IS
175: SELECT DISTINCT session_id
176: FROM igs_en_su_attempt
177: WHERE cart = 'S'
178: AND ss_source_ind IN ('P','S');
179:
180: /**

Line 183: CURSOR c_stud_cart_row (p_session_id igs_en_su_attempt.session_id%TYPE) IS

179:
180: /**
181: Cursor to select details of the cart, created from planned sheet and swap page.
182: */
183: CURSOR c_stud_cart_row (p_session_id igs_en_su_attempt.session_id%TYPE) IS
184: SELECT a.rowid, a.person_id,a.course_cd, a.uoo_id, a.ss_source_ind
185: FROM igs_en_su_attempt a
186: WHERE a.cart = 'S'
187: AND a.ss_source_ind IN ('P','S')

Line 185: FROM igs_en_su_attempt a

181: Cursor to select details of the cart, created from planned sheet and swap page.
182: */
183: CURSOR c_stud_cart_row (p_session_id igs_en_su_attempt.session_id%TYPE) IS
184: SELECT a.rowid, a.person_id,a.course_cd, a.uoo_id, a.ss_source_ind
185: FROM igs_en_su_attempt a
186: WHERE a.cart = 'S'
187: AND a.ss_source_ind IN ('P','S')
188: AND a.session_id = p_session_id
189: ORDER BY a.sup_unit_cd asc;

Line 276: igs_en_su_attempt_pkg.delete_row (c_stud_cart_rec.rowid);

272: BEGIN
273: SAVEPOINT SP_CART_REC;
274:
275: -- Delete the cart record
276: igs_en_su_attempt_pkg.delete_row (c_stud_cart_rec.rowid);
277:
278: IF c_stud_cart_rec.ss_source_ind = 'P' THEN
279: -- If there exists a term record with planning sheet marked as
280: -- submited for this unit attempt, then update that term record to PLAN.

Line 402: igs_en_su_attempt_pkg.delete_row ( unit_attempt_del_rec.row_id);

398:
399: FOR unit_attempt_del_rec IN unit_attempt_del_cur ( all_sessions_rec.session_id) LOOP
400: BEGIN
401: SAVEPOINT SP_SESSION_VAL_SUA_DEL;
402: igs_en_su_attempt_pkg.delete_row ( unit_attempt_del_rec.row_id);
403:
404: EXCEPTION
405: WHEN OTHERS THEN
406: ROLLBACK TO SP_SESSION_VAL_SUA_DEL;

Line 440: igs_en_su_attempt_pkg.delete_row ( std_unit_attempt_del_rec.row_id);

436:
437: FOR std_unit_attempt_del_rec IN std_unit_attempt_del_cur ( all_stud_sessions_rec.session_id) LOOP
438: BEGIN
439: SAVEPOINT SP_SESSION_VAL_SUA_DEL;
440: igs_en_su_attempt_pkg.delete_row ( std_unit_attempt_del_rec.row_id);
441:
442: EXCEPTION
443: WHEN OTHERS THEN
444: ROLLBACK TO SP_SESSION_VAL_SUA_DEL;