APPS.OE_ELECMSGS_PVT dependencies on OE_RESERVTNS_INTERFACE

Line 2775: oe_debug_pub.add('Deleting Line records from OE_RESERVTNS_INTERFACE');

2771: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Pricing Attributes Interface (Line): '|| l_count );
2772: END IF;
2773: IF l_line_reservtns THEN
2774: IF l_debug_level > 0 THEN
2775: oe_debug_pub.add('Deleting Line records from OE_RESERVTNS_INTERFACE');
2776: END IF;
2777: l_count := 0;
2778:
2779: IF p_order_source_id IS NOT NULL THEN

Line 2781: FROM OE_Reservtns_Interface

2777: l_count := 0;
2778:
2779: IF p_order_source_id IS NOT NULL THEN
2780: DELETE
2781: FROM OE_Reservtns_Interface
2782: WHERE order_source_id = p_order_source_id
2783: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2784: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2785: AND orig_sys_line_ref IS NOT NULL

Line 2811: FROM OE_Reservtns_Interface

2807: END IF;
2808: -- End MOAC
2809: ELSE
2810: DELETE
2811: FROM OE_Reservtns_Interface
2812: WHERE order_source_id BETWEEN l_min_order_source_id and l_max_order_source_id
2813: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2814: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2815: AND orig_sys_line_ref IS NOT NULL