APPS.OE_ELECMSGS_PVT dependencies on OE_HEADERS_INTERFACE

Line 1259: IF p_view_name IN ('OE_HEADERS_INTERFACE') THEN

1255: -----------------------------------------------------------
1256: /* Depending on Table/View name (parameter p_view_name), execute the
1257: SQL statements given below */
1258:
1259: IF p_view_name IN ('OE_HEADERS_INTERFACE') THEN
1260: l_header_iface := TRUE;
1261: IF l_purge_child_tables = 'Y' THEN
1262: l_header_price_adj := TRUE;
1263: l_header_cust_info := TRUE;

Line 1308: IF p_view_name IN ('OE_HEADERS_INTERFACE', 'OE_LINES_INTERFACE','OE_EM_INFORMATION') THEN

1304:
1305: /* to use the index on tracking and interface tables we gather the max and min order source id
1306: in appropriate cases */
1307: IF p_order_source_id IS NULL THEN
1308: IF p_view_name IN ('OE_HEADERS_INTERFACE', 'OE_LINES_INTERFACE','OE_EM_INFORMATION') THEN
1309:
1310: SELECT max(order_source_id), min(order_source_id)
1311: INTO l_max_order_source_id, l_min_order_source_id
1312: FROM OE_Order_Sources;

Line 1332: FROM OE_Headers_Interface h

1328: END IF;
1329: DELETE
1330: FROM OE_Customer_Info_Iface_All c
1331: WHERE c.customer_info_ref IN (SELECT h.orig_sys_customer_ref
1332: FROM OE_Headers_Interface h
1333: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
1334: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
1335: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
1336: AND (l_sold_to_org_id IS NULL

Line 1372: FROM OE_Headers_Interface h

1368:
1369: DELETE
1370: FROM OE_Customer_Info_Iface_All c
1371: WHERE c.customer_info_ref IN (SELECT h.sold_to_contact_ref
1372: FROM OE_Headers_Interface h
1373: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
1374: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
1375: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
1376: AND (l_sold_to_org_id IS NULL

Line 1411: FROM OE_Headers_Interface h

1407:
1408: DELETE
1409: FROM OE_Customer_Info_Iface_All c
1410: WHERE c.customer_info_ref IN (SELECT h.bill_to_contact_ref
1411: FROM OE_Headers_Interface h
1412: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
1413: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
1414: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
1415: AND (l_sold_to_org_id IS NULL

Line 1451: FROM OE_Headers_Interface h

1447:
1448: DELETE
1449: FROM OE_Customer_Info_Iface_All c
1450: WHERE c.customer_info_ref IN (SELECT h.ship_to_contact_ref
1451: FROM OE_Headers_Interface h
1452: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
1453: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
1454: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
1455: AND (l_sold_to_org_id IS NULL

Line 1490: FROM OE_Headers_Interface h

1486:
1487: DELETE
1488: FROM OE_Customer_Info_Iface_All c
1489: WHERE c.customer_info_ref IN (SELECT h.deliver_to_contact_ref
1490: FROM OE_Headers_Interface h
1491: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
1492: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
1493: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
1494: AND (l_sold_to_org_id IS NULL

Line 1529: FROM OE_Headers_Interface h

1525:
1526: DELETE
1527: FROM OE_Customer_Info_Iface_All c
1528: WHERE c.customer_info_ref IN (SELECT h.orig_ship_address_ref
1529: FROM OE_Headers_Interface h
1530: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
1531: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
1532: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
1533: AND (l_sold_to_org_id IS NULL

Line 1569: FROM OE_Headers_Interface h

1565:
1566: DELETE
1567: FROM OE_Customer_Info_Iface_All c
1568: WHERE c.customer_info_ref IN (SELECT h.orig_bill_address_ref
1569: FROM OE_Headers_Interface h
1570: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
1571: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
1572: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
1573: AND (l_sold_to_org_id IS NULL

Line 1608: FROM OE_Headers_Interface h

1604:
1605: DELETE
1606: FROM OE_Customer_Info_Iface_All c
1607: WHERE c.customer_info_ref IN (SELECT h.orig_deliver_address_ref
1608: FROM OE_Headers_Interface h
1609: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
1610: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
1611: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
1612: AND (l_sold_to_org_id IS NULL

Line 1652: oe_debug_pub.add('Deleting from OE_HEADERS_INTERFACE');

1648: END IF;
1649:
1650: IF l_header_iface THEN
1651: IF l_debug_level > 0 THEN
1652: oe_debug_pub.add('Deleting from OE_HEADERS_INTERFACE');
1653: END IF;
1654: l_count := 0;
1655:
1656: -- For the interface tables, we delete if either the sold to org or sold to org id

Line 1662: FROM OE_Headers_Interface

1658: -- For the other tables, the data is always populated internally
1659: -- and hence we can always be sure that sold_to_org_id is populated, if at all
1660: IF p_order_source_id IS NOT NULL THEN
1661: DELETE
1662: FROM OE_Headers_Interface
1663: WHERE order_source_id = p_order_source_id
1664: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
1665: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
1666: AND (l_sold_to_org_id IS NULL

Line 1690: FROM OE_Headers_Interface

1686: END IF;
1687: -- End MOAC
1688: ELSE
1689: DELETE
1690: FROM OE_Headers_Interface
1691: WHERE order_source_id BETWEEN l_min_order_source_id and l_max_order_source_id
1692: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
1693: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
1694: AND (l_sold_to_org_id IS NULL