APPS.OEXPURGE dependencies on SO_HOLD_RELEASES

Line 514: FROM so_hold_releases

510: syntax_required NUMBER := 0;
511:
512: CURSOR SO_LOCK_RECORDS IS
513: SELECT hold_release_id -- Lock rows to be purged
514: FROM so_hold_releases
515: WHERE hold_release_id = p_release_id
516: FOR UPDATE NOWAIT;
517: BEGIN
518: OPEN SO_LOCK_RECORDS; -- Lock all rows to be purged

Line 521: DELETE FROM so_hold_releases

517: BEGIN
518: OPEN SO_LOCK_RECORDS; -- Lock all rows to be purged
519: CLOSE SO_LOCK_RECORDS;
520:
521: DELETE FROM so_hold_releases
522: WHERE hold_release_id = p_release_id;
523:
524: RETURN SQLCODE;
525:

Line 533: 'OEPUR: SO_HOLD_RELEASES',

529: ROLLBACK;
530: so_record_errors( return_status,
531: p_request_id,
532: p_release_id,
533: 'OEPUR: SO_HOLD_RELEASES',
534: NULL );
535: CLOSE SO_LOCK_RECORDS;
536: RETURN return_status;
537: