APPS.OE_ELECMSGS_PVT dependencies on OE_PRICE_ADJS_INTERFACE

Line 1874: oe_debug_pub.add('Deleting Header records from OE_PRICE_ADJS_INTERFACE');

1870: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Credits Interface (Header): '|| l_count);
1871: END IF;
1872: IF l_header_price_adj THEN
1873: IF l_debug_level > 0 THEN
1874: oe_debug_pub.add('Deleting Header records from OE_PRICE_ADJS_INTERFACE');
1875: END IF;
1876: l_count := 0;
1877:
1878: IF p_order_source_id IS NOT NULL THEN

Line 1880: FROM OE_Price_Adjs_Interface

1876: l_count := 0;
1877:
1878: IF p_order_source_id IS NOT NULL THEN
1879: DELETE
1880: FROM OE_Price_Adjs_Interface
1881: WHERE order_source_id = p_order_source_id
1882: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
1883: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
1884: AND orig_sys_line_ref IS NULL

Line 1910: FROM OE_Price_Adjs_Interface

1906: END IF;
1907: -- End MOAC
1908: ELSE
1909: DELETE
1910: FROM OE_Price_Adjs_Interface
1911: WHERE order_source_id BETWEEN l_min_order_source_id AND l_max_order_source_id
1912: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
1913: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
1914: AND orig_sys_line_ref IS NULL

Line 2631: oe_debug_pub.add('Deleting Line records from OE_PRICE_ADJS_INTERFACE');

2627: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Lotserials Interface (Line): '|| l_count );
2628: END IF;
2629: IF l_line_price_adj THEN
2630: IF l_debug_level > 0 THEN
2631: oe_debug_pub.add('Deleting Line records from OE_PRICE_ADJS_INTERFACE');
2632: END IF;
2633: l_count := 0;
2634:
2635: IF p_order_source_id IS NOT NULL THEN

Line 2637: FROM OE_Price_Adjs_Interface

2633: l_count := 0;
2634:
2635: IF p_order_source_id IS NOT NULL THEN
2636: DELETE
2637: FROM OE_Price_Adjs_Interface
2638: WHERE order_source_id = p_order_source_id
2639: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2640: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2641: AND orig_sys_line_ref IS NOT NULL

Line 2667: FROM OE_Price_Adjs_Interface

2663: END IF;
2664: -- End MOAC
2665: ELSE
2666: DELETE
2667: FROM OE_Price_Adjs_Interface
2668: WHERE order_source_id BETWEEN l_min_order_source_id and l_max_order_source_id
2669: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2670: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2671: AND orig_sys_line_ref IS NOT NULL