APPS.OE_ELECMSGS_PVT dependencies on OE_LOTSERIALS_INTERFACE

Line 2559: oe_debug_pub.add('Deleting Line records from OE_LOTSERIALS_INTERFACE');

2555: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Credits Interface (Line): '|| l_count);
2556: END IF;
2557: IF l_line_lotserial THEN
2558: IF l_debug_level > 0 THEN
2559: oe_debug_pub.add('Deleting Line records from OE_LOTSERIALS_INTERFACE');
2560: END IF;
2561: l_count := 0;
2562:
2563: IF p_order_source_id IS NOT NULL THEN

Line 2565: FROM OE_LotSerials_Interface

2561: l_count := 0;
2562:
2563: IF p_order_source_id IS NOT NULL THEN
2564: DELETE
2565: FROM OE_LotSerials_Interface
2566: WHERE order_source_id = p_order_source_id
2567: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2568: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2569: AND orig_sys_line_ref IS NOT NULL

Line 2595: FROM OE_LotSerials_Interface

2591: END IF;
2592: -- End MOAC
2593: ELSE
2594: DELETE
2595: FROM OE_LotSerials_Interface
2596: WHERE order_source_id BETWEEN l_min_order_source_id and l_max_order_source_id
2597: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2598: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2599: AND orig_sys_line_ref IS NOT NULL