APPS.OE_ELECMSGS_PVT dependencies on OE_ACTIONS_INTERFACE

Line 1727: oe_debug_pub.add('Deleting Header records from OE_ACTIONS_INTERFACE');

1723: END IF;
1724:
1725: IF l_header_actions THEN
1726: IF l_debug_level > 0 THEN
1727: oe_debug_pub.add('Deleting Header records from OE_ACTIONS_INTERFACE');
1728: END IF;
1729: l_count := 0;
1730:
1731: IF p_order_source_id IS NOT NULL THEN

Line 1733: FROM OE_Actions_Interface

1729: l_count := 0;
1730:
1731: IF p_order_source_id IS NOT NULL THEN
1732: DELETE
1733: FROM OE_Actions_Interface
1734: WHERE order_source_id = p_order_source_id
1735: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
1736: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
1737: AND orig_sys_line_ref IS NULL

Line 1764: FROM OE_Actions_Interface

1760: END IF;
1761: -- End MOAC
1762: ELSE
1763: DELETE
1764: FROM OE_Actions_Interface
1765: WHERE order_source_id BETWEEN l_min_order_source_id AND l_max_order_source_id
1766: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
1767: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
1768: AND orig_sys_line_ref IS NULL

Line 2415: oe_debug_pub.add('Deleting Line records from OE_ACTIONS_INTERFACE');

2411: END IF;
2412:
2413: IF l_line_actions THEN
2414: IF l_debug_level > 0 THEN
2415: oe_debug_pub.add('Deleting Line records from OE_ACTIONS_INTERFACE');
2416: END IF;
2417: l_count := 0;
2418:
2419: IF p_order_source_id IS NOT NULL THEN

Line 2421: FROM OE_Actions_Interface

2417: l_count := 0;
2418:
2419: IF p_order_source_id IS NOT NULL THEN
2420: DELETE
2421: FROM OE_Actions_Interface
2422: WHERE order_source_id = p_order_source_id
2423: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2424: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2425: AND orig_sys_line_ref IS NOT NULL

Line 2451: FROM OE_Actions_Interface

2447: END IF;
2448: -- End MOAC
2449: ELSE
2450: DELETE
2451: FROM OE_Actions_Interface
2452: WHERE order_source_id BETWEEN l_min_order_source_id and l_max_order_source_id
2453: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2454: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2455: AND orig_sys_line_ref IS NOT NULL