DBA Data[Home] [Help]

APPS.IGS_SESSION_VALIDITY dependencies on IGS_EN_SU_ATTEMPT_PKG

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;