APPS.OE_ELECMSGS_PVT dependencies on OE_ACTIONS_IFACE_ALL

Line 1747: FROM OE_Actions_Iface_All

1743:
1744: -- Start MOAC
1745: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
1746: DELETE
1747: FROM OE_Actions_Iface_All
1748: WHERE order_source_id = p_order_source_id
1749: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
1750: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
1751: AND orig_sys_line_ref IS NULL

Line 1777: FROM OE_Actions_Iface_All

1773:
1774: -- Start MOAC
1775: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
1776: DELETE
1777: FROM OE_Actions_Iface_All
1778: WHERE order_source_id BETWEEN l_min_order_source_id AND l_max_order_source_id
1779: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
1780: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
1781: AND orig_sys_line_ref IS NULL

Line 2434: FROM OE_Actions_Iface_All

2430:
2431: -- Start MOAC
2432: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
2433: DELETE
2434: FROM OE_Actions_Iface_All
2435: WHERE order_source_id = p_order_source_id
2436: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2437: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2438: AND orig_sys_line_ref IS NOT NULL

Line 2464: FROM OE_Actions_Iface_All

2460:
2461: -- Start MOAC
2462: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
2463: DELETE
2464: FROM OE_Actions_Iface_All
2465: WHERE order_source_id BETWEEN l_min_order_source_id and l_max_order_source_id
2466: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2467: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2468: AND orig_sys_line_ref IS NOT NULL