DBA Data[Home] [Help]

APPS.OEXPURGE dependencies on SO_LINE_SERVICE_DETAILS

Line 658: FROM so_line_service_details

654: syntax_required NUMBER := 0;
655:
656: CURSOR SO_LOCK_RECORDS IS
657: SELECT line_id
658: FROM so_line_service_details
659: WHERE line_id = p_line_id
660: FOR UPDATE NOWAIT;
661: BEGIN
662: OPEN SO_LOCK_RECORDS; -- Lock all rows to be purged

Line 665: DELETE FROM so_line_service_details

661: BEGIN
662: OPEN SO_LOCK_RECORDS; -- Lock all rows to be purged
663: CLOSE SO_LOCK_RECORDS;
664:
665: DELETE FROM so_line_service_details
666: WHERE line_id = p_line_id;
667:
668: RETURN SQLCODE;
669:

Line 677: 'OEPUR: SO_LINE_SERVICE_DETAILS',

673: ROLLBACK;
674: so_record_errors( return_status,
675: p_request_id,
676: p_line_id,
677: 'OEPUR: SO_LINE_SERVICE_DETAILS',
678: NULL );
679: CLOSE SO_LOCK_RECORDS;
680: RETURN return_status;
681: