APPS.OEXPURGE dependencies on SO_ORDER_CANCELLATIONS

Line 844: FROM so_order_cancellations

840: syntax_required NUMBER := 0;
841:
842: CURSOR SO_LOCK_RECORDS IS
843: SELECT line_id -- Lock rows to be purged
844: FROM so_order_cancellations
845: WHERE line_id = p_line_id
846: FOR UPDATE NOWAIT;
847: BEGIN
848: OPEN SO_LOCK_RECORDS;

Line 851: DELETE FROM so_order_cancellations

847: BEGIN
848: OPEN SO_LOCK_RECORDS;
849: CLOSE SO_LOCK_RECORDS;
850:
851: DELETE FROM so_order_cancellations
852: WHERE line_id = p_line_id;
853:
854: RETURN SQLCODE;
855:

Line 863: 'OEPUR: SO_ORDER_CANCELLATIONS',

859: ROLLBACK;
860: so_record_errors( return_status,
861: p_request_id,
862: p_line_id,
863: 'OEPUR: SO_ORDER_CANCELLATIONS',
864: NULL );
865: CLOSE SO_LOCK_RECORDS;
866: RETURN return_status;
867:

Line 985: FROM so_order_cancellations

981: syntax_required NUMBER := 0;
982:
983: CURSOR SO_LOCK_RECORDS IS
984: SELECT header_id -- Lock rows to be purged
985: FROM so_order_cancellations
986: WHERE header_id = p_header_id
987: FOR UPDATE NOWAIT;
988: BEGIN
989: OPEN SO_LOCK_RECORDS;

Line 992: DELETE FROM so_order_cancellations

988: BEGIN
989: OPEN SO_LOCK_RECORDS;
990: CLOSE SO_LOCK_RECORDS;
991:
992: DELETE FROM so_order_cancellations
993: WHERE header_id = p_header_id;
994:
995: RETURN SQLCODE;
996:

Line 1004: 'OEPUR: SO_ORDER_CANCELLATIONS',

1000: ROLLBACK;
1001: so_record_errors( return_status,
1002: p_request_id,
1003: p_header_id,
1004: 'OEPUR: SO_ORDER_CANCELLATIONS',
1005: NULL );
1006: CLOSE SO_LOCK_RECORDS;
1007: RETURN return_status;
1008: