APPS.OEXPURGE dependencies on SO_PURGE_ORDERS

Line 49: DELETE FROM SO_PURGE_ORDERS

45: AND so.open_flag is null;
46:
47: BEGIN
48:
49: DELETE FROM SO_PURGE_ORDERS
50: WHERE REQUEST_ID IS NULL;
51:
52: /* commit; */
53:

Line 87: INSERT INTO SO_PURGE_ORDERS

83: END IF;
84:
85: IF return_status = 0 THEN
86:
87: INSERT INTO SO_PURGE_ORDERS
88: (HEADER_ID,
89: CREATION_DATE,
90: CREATED_BY,
91: LAST_UPDATE_DATE,

Line 310: CURSOR purging IS SELECT header_id FROM so_purge_orders;

306: commit_ctr NUMBER := 0;
307: return_status NUMBER := 0;
308: p_request_id NUMBER := 0;
309:
310: CURSOR purging IS SELECT header_id FROM so_purge_orders;
311:
312: BEGIN
313:
314: p_request_id := FND_GLOBAL.CONC_REQUEST_ID;

Line 397: DELETE FROM so_purge_orders -- Delete the purge record

393:
394: -- dbms_output.put_line('before delete');
395:
396: IF return_status > -1 THEN -- Success !
397: DELETE FROM so_purge_orders -- Delete the purge record
398: WHERE header_id = v_header_id;
399:
400: -- dbms_output.put_line('after delete');
401:

Line 427: 'OEPUR: SO_PURGE_ORDERS', NULL );

423: return_status := SQLCODE;
424: ROLLBACK;
425: -- dbms_output.put_line('rollback 2');
426: so_record_errors( return_status, p_request_id, v_header_id,
427: 'OEPUR: SO_PURGE_ORDERS', NULL );
428: CLOSE purging;
429: END so_order_purge;
430:
431: