DBA Data[Home] [Help]

APPS.OEXPURGE dependencies on SO_PICKING_RULES

Line 1397: FROM so_picking_rules

1393: syntax_required NUMBER := 0;
1394:
1395: CURSOR SO_LOCK_RECORDS IS
1396: SELECT header_id -- Lock rows to be purged
1397: FROM so_picking_rules
1398: WHERE header_id = p_header_id
1399: FOR UPDATE NOWAIT;
1400: BEGIN
1401: OPEN SO_LOCK_RECORDS;

Line 1404: DELETE FROM so_picking_rules

1400: BEGIN
1401: OPEN SO_LOCK_RECORDS;
1402: CLOSE SO_LOCK_RECORDS;
1403:
1404: DELETE FROM so_picking_rules
1405: WHERE header_id = p_header_id;
1406:
1407: RETURN SQLCODE;
1408:

Line 1416: 'OEPUR: SO_PICKING_RULES',

1412: ROLLBACK;
1413: so_record_errors( return_status,
1414: p_request_id,
1415: p_header_id,
1416: 'OEPUR: SO_PICKING_RULES',
1417: NULL );
1418: CLOSE SO_LOCK_RECORDS;
1419: RETURN return_status;
1420: