DBA Data[Home] [Help]

APPS.OEXPURGE dependencies on SO_LINE_APPROVALS

Line 586: FROM so_line_approvals

582: syntax_required NUMBER := 0;
583:
584: CURSOR SO_LOCK_RECORDS IS
585: SELECT header_id -- Lock rows to be purged
586: FROM so_line_approvals
587: WHERE header_id = p_header_id
588: FOR UPDATE NOWAIT;
589: BEGIN
590: OPEN SO_LOCK_RECORDS; -- Lock all rows to be purged

Line 593: DELETE FROM so_line_approvals

589: BEGIN
590: OPEN SO_LOCK_RECORDS; -- Lock all rows to be purged
591: CLOSE SO_LOCK_RECORDS;
592:
593: DELETE FROM so_line_approvals
594: WHERE header_id = p_header_id;
595:
596: RETURN SQLCODE;
597:

Line 605: 'OEPUR: SO_LINE_APPROVALS',

601: ROLLBACK;
602: so_record_errors( return_status,
603: p_request_id,
604: p_header_id,
605: 'OEPUR: SO_LINE_APPROVALS',
606: NULL );
607: CLOSE SO_LOCK_RECORDS;
608: RETURN return_status;
609: