DBA Data[Home] [Help]

APPS.OEXPURGE dependencies on SO_LINE_DETAILS

Line 622: FROM so_line_details

618: syntax_required NUMBER := 0;
619:
620: CURSOR SO_LOCK_RECORDS IS
621: SELECT line_id
622: FROM so_line_details
623: WHERE line_id = p_line_id
624: FOR UPDATE NOWAIT;
625: BEGIN
626: OPEN SO_LOCK_RECORDS; -- Lock all rows to be purged

Line 629: DELETE FROM so_line_details

625: BEGIN
626: OPEN SO_LOCK_RECORDS; -- Lock all rows to be purged
627: CLOSE SO_LOCK_RECORDS;
628:
629: DELETE FROM so_line_details
630: WHERE line_id = p_line_id;
631:
632: RETURN SQLCODE;
633:

Line 641: 'OEPUR: SO_LINE_DETAILS',

637: ROLLBACK;
638: so_record_errors( return_status,
639: p_request_id,
640: p_line_id,
641: 'OEPUR: SO_LINE_DETAILS',
642: NULL );
643: CLOSE SO_LOCK_RECORDS;
644: RETURN return_status;
645: