APPS.OE_ELECMSGS_PVT dependencies on OE_PAYMENTS_INTERFACE

Line 2021: oe_debug_pub.add('Deleting Header records from OE_PAYMENTS_INTERFACE');

2017: END IF;
2018:
2019: IF l_header_payments THEN
2020: IF l_debug_level > 0 THEN
2021: oe_debug_pub.add('Deleting Header records from OE_PAYMENTS_INTERFACE');
2022: END IF;
2023: l_count := 0;
2024:
2025: IF p_order_source_id IS NOT NULL THEN

Line 2027: FROM OE_Payments_Interface

2023: l_count := 0;
2024:
2025: IF p_order_source_id IS NOT NULL THEN
2026: DELETE
2027: FROM OE_Payments_Interface
2028: WHERE order_source_id = p_order_source_id
2029: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2030: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2031: AND orig_sys_line_ref IS NULL

Line 2057: FROM OE_Payments_Interface

2053: END IF;
2054: -- End MOAC
2055: ELSE
2056: DELETE
2057: FROM OE_Payments_Interface
2058: WHERE order_source_id BETWEEN l_min_order_source_id AND l_max_order_source_id
2059: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2060: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2061: AND orig_sys_line_ref IS NULL

Line 2848: oe_debug_pub.add('Deleting Line records from OE_PAYMENTS_INTERFACE');

2844: END IF;
2845:
2846: IF l_line_payments THEN
2847: IF l_debug_level > 0 THEN
2848: oe_debug_pub.add('Deleting Line records from OE_PAYMENTS_INTERFACE');
2849: END IF;
2850: l_count := 0;
2851:
2852: IF p_order_source_id IS NOT NULL THEN

Line 2854: FROM OE_Payments_Interface

2850: l_count := 0;
2851:
2852: IF p_order_source_id IS NOT NULL THEN
2853: DELETE
2854: FROM OE_Payments_Interface
2855: WHERE order_source_id = p_order_source_id
2856: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2857: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2858: AND orig_sys_line_ref IS NOT NULL

Line 2884: FROM OE_Payments_Interface

2880: END IF;
2881: -- End MOAC
2882: ELSE
2883: DELETE
2884: FROM OE_Payments_Interface
2885: WHERE order_source_id BETWEEN l_min_order_source_id and l_max_order_source_id
2886: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2887: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2888: AND orig_sys_line_ref IS NOT NULL