APPS.OE_ELECMSGS_PVT dependencies on OE_PRICE_ATTS_INTERFACE

Line 1947: oe_debug_pub.add('Deleting Header records from OE_PRICE_ATTS_INTERFACE');

1943: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Price Adjustments Interface (Header): '|| l_count);
1944: END IF;
1945: IF l_header_price_att THEN
1946: IF l_debug_level > 0 THEN
1947: oe_debug_pub.add('Deleting Header records from OE_PRICE_ATTS_INTERFACE');
1948: END IF;
1949: l_count := 0;
1950:
1951: IF p_order_source_id IS NOT NULL THEN

Line 1953: FROM OE_Price_Atts_Interface

1949: l_count := 0;
1950:
1951: IF p_order_source_id IS NOT NULL THEN
1952: DELETE
1953: FROM OE_Price_Atts_Interface
1954: WHERE order_source_id = p_order_source_id
1955: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
1956: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
1957: AND orig_sys_line_ref IS NULL

Line 1983: FROM OE_Price_Atts_Interface

1979: END IF;
1980: -- End MOAC
1981: ELSE
1982: DELETE
1983: FROM OE_Price_Atts_Interface
1984: WHERE order_source_id BETWEEN l_min_order_source_id and l_max_order_source_id
1985: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
1986: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
1987: AND orig_sys_line_ref IS NULL

Line 2703: oe_debug_pub.add('Deleting Line records from OE_PRICE_ATTS_INTERFACE');

2699: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Price Adjustments Interface (Line): '|| l_count );
2700: END IF;
2701: IF l_line_price_att THEN
2702: IF l_debug_level > 0 THEN
2703: oe_debug_pub.add('Deleting Line records from OE_PRICE_ATTS_INTERFACE');
2704: END IF;
2705: l_count := 0;
2706:
2707: IF p_order_source_id IS NOT NULL THEN

Line 2709: FROM OE_Price_Atts_Interface

2705: l_count := 0;
2706:
2707: IF p_order_source_id IS NOT NULL THEN
2708: DELETE
2709: FROM OE_Price_Atts_Interface
2710: WHERE order_source_id = p_order_source_id
2711: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2712: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2713: AND orig_sys_line_ref IS NOT NULL

Line 2739: FROM OE_Price_Atts_Interface

2735: END IF;
2736: -- End MOAC
2737: ELSE
2738: DELETE
2739: FROM OE_Price_Atts_Interface
2740: WHERE order_source_id BETWEEN l_min_order_source_id and l_max_order_source_id
2741: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2742: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2743: AND orig_sys_line_ref IS NOT NULL