DBA Data[Home] [Help]

APPS.OEXPURGE dependencies on SO_ORDER_APPROVALS

Line 802: FROM so_order_approvals

798: syntax_required NUMBER := 0;
799:
800: CURSOR SO_LOCK_RECORDS IS
801: SELECT header_id -- Lock rows to be purged
802: FROM so_order_approvals
803: WHERE header_id = p_header_id
804: FOR UPDATE NOWAIT;
805: BEGIN
806: OPEN SO_LOCK_RECORDS;

Line 809: DELETE FROM so_order_approvals

805: BEGIN
806: OPEN SO_LOCK_RECORDS;
807: CLOSE SO_LOCK_RECORDS;
808:
809: DELETE FROM so_order_approvals
810: WHERE header_id = p_header_id;
811:
812: RETURN SQLCODE;
813:

Line 821: 'OEPUR: SO_ORDER_APPROVALS',

817: ROLLBACK;
818: so_record_errors( return_status,
819: p_request_id,
820: p_header_id,
821: 'OEPUR: SO_ORDER_APPROVALS',
822: NULL );
823: CLOSE SO_LOCK_RECORDS;
824: RETURN return_status;
825: