APPS.IGS_GE_GEN_001 dependencies on IGS_GE_NOTE

Line 252: SELECT IGS_GE_NOTE.* , ROWID

248: DECLARE
249: e_resource_busy EXCEPTION;
250: PRAGMA EXCEPTION_INIT(e_resource_busy, -54);
251: CURSOR c_del_note IS
252: SELECT IGS_GE_NOTE.* , ROWID
253: FROM IGS_GE_NOTE
254: WHERE reference_number = p_reference_number
255: FOR UPDATE OF reference_number NOWAIT;
256: BEGIN

Line 253: FROM IGS_GE_NOTE

249: e_resource_busy EXCEPTION;
250: PRAGMA EXCEPTION_INIT(e_resource_busy, -54);
251: CURSOR c_del_note IS
252: SELECT IGS_GE_NOTE.* , ROWID
253: FROM IGS_GE_NOTE
254: WHERE reference_number = p_reference_number
255: FOR UPDATE OF reference_number NOWAIT;
256: BEGIN
257: SAVEPOINT sp_before_delete;

Line 261: IGS_GE_NOTE_PKG.DELETE_ROW(X_ROWID => V_NOTE_REC.ROWID );

257: SAVEPOINT sp_before_delete;
258: p_message_name:= null ;
259: BEGIN
260: FOR v_note_rec IN c_del_note LOOP
261: IGS_GE_NOTE_PKG.DELETE_ROW(X_ROWID => V_NOTE_REC.ROWID );
262: END LOOP;
263: EXCEPTION
264: WHEN e_resource_busy THEN
265: ROLLBACK TO sp_before_delete;

Line 266: p_message_name := 'IGS_GE_NOTE_RECORD_LOCKED';

262: END LOOP;
263: EXCEPTION
264: WHEN e_resource_busy THEN
265: ROLLBACK TO sp_before_delete;
266: p_message_name := 'IGS_GE_NOTE_RECORD_LOCKED';
267: RETURN FALSE;
268: END;
269: RETURN TRUE;
270: END;