APPS.OE_ELECMSGS_PVT dependencies on OE_CREDITS_INTERFACE

Line 1801: oe_debug_pub.add('Deleting Header records from OE_CREDITS_INTERFACE');

1797: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Actions Interface (Header): '|| l_count);
1798: END IF;
1799: IF l_header_credits THEN
1800: IF l_debug_level > 0 THEN
1801: oe_debug_pub.add('Deleting Header records from OE_CREDITS_INTERFACE');
1802: END IF;
1803: l_count := 0;
1804:
1805: IF p_order_source_id IS NOT NULL THEN

Line 1807: FROM OE_Credits_Interface

1803: l_count := 0;
1804:
1805: IF p_order_source_id IS NOT NULL THEN
1806: DELETE
1807: FROM OE_Credits_Interface
1808: WHERE order_source_id = p_order_source_id
1809: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
1810: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
1811: AND orig_sys_line_ref IS NULL

Line 1837: FROM OE_Credits_Interface

1833: END IF;
1834: -- End MOAC
1835: ELSE
1836: DELETE
1837: FROM OE_Credits_Interface
1838: WHERE order_source_id BETWEEN l_min_order_source_id AND l_max_order_source_id
1839: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
1840: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
1841: AND orig_sys_line_ref IS NULL

Line 2487: oe_debug_pub.add('Deleting Line records from OE_CREDITS_INTERFACE');

2483: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Actions Interface (Line): '|| l_count);
2484: END IF;
2485: IF l_line_credits THEN
2486: IF l_debug_level > 0 THEN
2487: oe_debug_pub.add('Deleting Line records from OE_CREDITS_INTERFACE');
2488: END IF;
2489: l_count := 0;
2490:
2491: IF p_order_source_id IS NOT NULL THEN

Line 2493: FROM OE_Credits_Interface

2489: l_count := 0;
2490:
2491: IF p_order_source_id IS NOT NULL THEN
2492: DELETE
2493: FROM OE_Credits_Interface
2494: WHERE order_source_id = p_order_source_id
2495: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2496: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2497: AND orig_sys_line_ref IS NOT NULL

Line 2523: FROM OE_Credits_Interface

2519: END IF;
2520: -- End MOAC
2521: ELSE
2522: DELETE
2523: FROM OE_Credits_Interface
2524: WHERE order_source_id BETWEEN l_min_order_source_id and l_max_order_source_id
2525: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2526: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2527: AND orig_sys_line_ref IS NOT NULL