DBA Data[Home] [Help]

APPS.OEXPURGE dependencies on SO_PRICE_ADJUSTMENTS

Line 1433: FROM so_price_adjustments

1429: syntax_required NUMBER := 0;
1430:
1431: CURSOR SO_LOCK_RECORDS IS
1432: SELECT header_id -- Lock rows to be purged
1433: FROM so_price_adjustments
1434: WHERE header_id = p_header_id
1435: FOR UPDATE NOWAIT;
1436: BEGIN
1437: OPEN SO_LOCK_RECORDS;

Line 1440: DELETE FROM so_price_adjustments

1436: BEGIN
1437: OPEN SO_LOCK_RECORDS;
1438: CLOSE SO_LOCK_RECORDS;
1439:
1440: DELETE FROM so_price_adjustments
1441: WHERE header_id = p_header_id;
1442:
1443: RETURN SQLCODE;
1444:

Line 1452: 'OEPUR: SO_PRICE_ADJUSTMENTS',

1448: ROLLBACK;
1449: so_record_errors( return_status,
1450: p_request_id,
1451: p_header_id,
1452: 'OEPUR: SO_PRICE_ADJUSTMENTS',
1453: NULL );
1454: CLOSE SO_LOCK_RECORDS;
1455: RETURN return_status;
1456: