APPS.OEXPURGE dependencies on SO_HEADERS

Line 29: so_headers so

25: SELECT so.header_id
26: , so.order_number
27: , sot.name
28: FROM so_order_types sot,
29: so_headers so
30: WHERE so.order_number BETWEEN NVL(p_low_order_number,so.order_number)
31: AND NVL( p_high_order_number, so.order_number )
32: -- The time component in Order Date and Creation Date has been stripped off
33: -- before making comparision. Bug# 916858 - propagated from Rel. 11

Line 239: so_headers sh,

235: CURSOR SO_PROBLEM_CHECK IS
236: SELECT 'Open return for this sales order'
237: FROM so_lines sl1,
238: so_lines sl2,
239: so_headers sh,
240: so_order_types ot
241: WHERE sh.order_number = p_order_number
242: AND sh.order_type_id = ot.order_type_id
243: AND ot.name = p_order_type_name

Line 478: FROM so_headers

474: syntax_required NUMBER := 0;
475:
476: CURSOR SO_LOCK_RECORDS IS
477: SELECT header_id -- Lock all rows to be purged
478: FROM so_headers
479: WHERE header_id = p_header_id
480: FOR UPDATE NOWAIT;
481: BEGIN
482: OPEN SO_LOCK_RECORDS; -- Lock all rows to be purged

Line 485: DELETE FROM so_headers

481: BEGIN
482: OPEN SO_LOCK_RECORDS; -- Lock all rows to be purged
483: CLOSE SO_LOCK_RECORDS;
484:
485: DELETE FROM so_headers
486: WHERE header_id = p_header_id;
487:
488: RETURN SQLCODE;
489:

Line 497: 'OEPUR: SO_HEADERS',

493: ROLLBACK;
494: so_record_errors( return_status,
495: p_request_id,
496: p_header_id,
497: 'OEPUR: SO_HEADERS',
498: NULL );
499: CLOSE SO_LOCK_RECORDS;
500: RETURN return_status;
501: