APPS.IGS_EN_GEN_001 dependencies on IGS_PS_STDNT_UNT_TRN

Line 365: -- and deletes associated IGS_PS_STDNT_UNT_TRN detail.

361: e_resource_busy_exception EXCEPTION;
362: PRAGMA EXCEPTION_INIT(e_resource_busy_exception, -54);
363: BEGIN -- enrp_del_sua_sut
364: -- This module validates if a duplicate IGS_EN_SU_ATTEMPT can be deleted,
365: -- and deletes associated IGS_PS_STDNT_UNT_TRN detail.
366: DECLARE
367: cst_duplicate VARCHAR2(10) := 'DUPLICATE';
368: v_person_id IGS_PS_STDNT_UNT_TRN.person_id%TYPE;
369: -- cursor to locate duplicate in another IGS_PS_COURSE.

Line 368: v_person_id IGS_PS_STDNT_UNT_TRN.person_id%TYPE;

364: -- This module validates if a duplicate IGS_EN_SU_ATTEMPT can be deleted,
365: -- and deletes associated IGS_PS_STDNT_UNT_TRN detail.
366: DECLARE
367: cst_duplicate VARCHAR2(10) := 'DUPLICATE';
368: v_person_id IGS_PS_STDNT_UNT_TRN.person_id%TYPE;
369: -- cursor to locate duplicate in another IGS_PS_COURSE.
370: CURSOR c_sut_duplicate IS
371: SELECT person_id
372: FROM IGS_PS_STDNT_UNT_TRN sut

Line 372: FROM IGS_PS_STDNT_UNT_TRN sut

368: v_person_id IGS_PS_STDNT_UNT_TRN.person_id%TYPE;
369: -- cursor to locate duplicate in another IGS_PS_COURSE.
370: CURSOR c_sut_duplicate IS
371: SELECT person_id
372: FROM IGS_PS_STDNT_UNT_TRN sut
373: WHERE sut.person_id = p_person_id AND
374: sut.transfer_course_cd = p_course_cd AND
375: sut.uoo_id = p_uoo_id;
376: --cursor to acquire lock for delete

Line 379: FROM IGS_PS_STDNT_UNT_TRN sut

375: sut.uoo_id = p_uoo_id;
376: --cursor to acquire lock for delete
377: CURSOR c_sut_delete IS
378: SELECT rowid,person_id
379: FROM IGS_PS_STDNT_UNT_TRN sut
380: WHERE sut.person_id = p_person_id AND
381: sut.course_cd = p_course_cd AND
382: sut.uoo_id = p_uoo_id
383: FOR UPDATE OF sut.person_id NOWAIT;

Line 396: IGS_PS_STDNT_UNT_TRN_PKG.DELETE_ROW(v_sut_delete_rec.rowid);

392: RETURN FALSE;
393: END IF;
394: CLOSE c_sut_duplicate;
395: FOR v_sut_delete_rec IN c_sut_delete LOOP
396: IGS_PS_STDNT_UNT_TRN_PKG.DELETE_ROW(v_sut_delete_rec.rowid);
397: END LOOP;
398: END IF;
399: p_message_name := Null;
400: RETURN TRUE;