APPS.OE_ELECMSGS_PVT dependencies on OE_LINES_INTERFACE

Line 1279: IF p_view_name IN ('OE_LINES_INTERFACE') THEN

1275: l_line_actions := TRUE;
1276: l_line_payments := TRUE;
1277: END IF;
1278: END IF;
1279: IF p_view_name IN ('OE_LINES_INTERFACE') THEN
1280: l_line_iface := TRUE;
1281: IF l_purge_child_tables = 'Y' THEN
1282: l_line_cust_info := TRUE;
1283: l_line_price_adj := 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 2108: FROM OE_Lines_Interface h

2104:
2105: DELETE
2106: FROM OE_Customer_Info_Iface_All c
2107: WHERE c.customer_info_ref IN (SELECT h.bill_to_contact_ref
2108: FROM OE_Lines_Interface h
2109: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
2110: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2111: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2112: AND (l_sold_to_org_id IS NULL

Line 2147: FROM OE_Lines_Interface h

2143:
2144: DELETE
2145: FROM OE_Customer_Info_Iface_All c
2146: WHERE c.customer_info_ref IN (SELECT h.ship_to_contact_ref
2147: FROM OE_Lines_Interface h
2148: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
2149: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2150: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2151: AND (l_sold_to_org_id IS NULL

Line 2186: FROM OE_Lines_Interface h

2182:
2183: DELETE
2184: FROM OE_Customer_Info_Iface_All c
2185: WHERE c.customer_info_ref IN (SELECT h.deliver_to_contact_ref
2186: FROM OE_Lines_Interface h
2187: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
2188: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2189: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2190: AND (l_sold_to_org_id IS NULL

Line 2225: FROM OE_Lines_Interface h

2221:
2222: DELETE
2223: FROM OE_Customer_Info_Iface_All c
2224: WHERE c.customer_info_ref IN (SELECT h.orig_ship_address_ref
2225: FROM OE_Lines_Interface h
2226: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
2227: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2228: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2229: AND (l_sold_to_org_id IS NULL

Line 2264: FROM OE_Lines_Interface h

2260:
2261: DELETE
2262: FROM OE_Customer_Info_Iface_All c
2263: WHERE c.customer_info_ref IN (SELECT h.orig_bill_address_ref
2264: FROM OE_Lines_Interface h
2265: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
2266: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2267: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2268: AND (l_sold_to_org_id IS NULL

Line 2303: FROM OE_Lines_Interface h

2299:
2300: DELETE
2301: FROM OE_Customer_Info_Iface_All c
2302: WHERE c.customer_info_ref IN (SELECT h.orig_deliver_address_ref
2303: FROM OE_Lines_Interface h
2304: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
2305: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2306: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2307: AND (l_sold_to_org_id IS NULL

Line 2346: oe_debug_pub.add('Deleting from OE_LINES_INTERFACE');

2342: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Customer Info Interface (Line): '|| l_cust_rows);
2343: END IF;
2344: IF l_line_iface THEN
2345: IF l_debug_level > 0 THEN
2346: oe_debug_pub.add('Deleting from OE_LINES_INTERFACE');
2347: END IF;
2348: l_count := 0;
2349: IF p_order_source_id IS NOT NULL THEN
2350: DELETE

Line 2351: FROM OE_Lines_Interface

2347: END IF;
2348: l_count := 0;
2349: IF p_order_source_id IS NOT NULL THEN
2350: DELETE
2351: FROM OE_Lines_Interface
2352: WHERE order_source_id = p_order_source_id
2353: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2354: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2355: AND (l_sold_to_org_id IS NULL

Line 2379: FROM OE_Lines_Interface

2375: END IF;
2376: -- End MOAC
2377: ELSE
2378: DELETE
2379: FROM OE_Lines_Interface
2380: WHERE order_source_id BETWEEN l_min_order_source_id and l_max_order_source_id
2381: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2382: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2383: AND (l_sold_to_org_id IS NULL