APPS.OE_ELECMSGS_PVT dependencies on OE_LINE_ACKS

Line 1298: IF p_view_name IN ('OE_LINE_ACKS') THEN

1294: IF l_purge_child_tables = 'Y' THEN
1295: l_line_acks := TRUE;
1296: END IF;
1297: END IF;
1298: IF p_view_name IN ('OE_LINE_ACKS') THEN
1299: l_line_acks := TRUE;
1300: END IF;
1301: IF p_view_name IN ('OE_EM_INFORMATION') THEN
1302: l_elecmsgs := TRUE;

Line 2969: oe_debug_pub.add('Deleting Acknowledged Line records from OE_LINE_ACKS');

2965: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Header Acknowledgments: '|| l_count );
2966: END IF;
2967: IF l_line_acks THEN
2968: IF l_debug_level > 0 THEN
2969: oe_debug_pub.add('Deleting Acknowledged Line records from OE_LINE_ACKS');
2970: END IF;
2971: l_count := 0;
2972:
2973: IF p_orig_sys_document_ref_from IS NOT NULL

Line 2976: FROM OE_Line_Acks

2972:
2973: IF p_orig_sys_document_ref_from IS NOT NULL
2974: AND p_orig_sys_document_ref_to IS NOT NULL THEN
2975: DELETE
2976: FROM OE_Line_Acks
2977: WHERE order_source_id = nvl(p_order_source_id, order_source_id)
2978: AND orig_sys_document_ref BETWEEN p_orig_sys_document_ref_from
2979: AND p_orig_sys_document_ref_to
2980: AND sold_to_org_id = nvl(l_sold_to_org_id, sold_to_org_id)

Line 2985: FROM OE_Line_Acks

2981: AND nvl(acknowledgment_flag, 'N') = 'Y'
2982: AND ((p_operating_unit IS NULL AND MO_GLOBAL.Check_Access (org_id) = l_yes) OR org_id = p_operating_unit);
2983: ELSIF p_orig_sys_document_ref_from IS NOT NULL THEN
2984: DELETE
2985: FROM OE_Line_Acks
2986: WHERE order_source_id = nvl(p_order_source_id, order_source_id)
2987: AND orig_sys_document_ref >= p_orig_sys_document_ref_from
2988: AND sold_to_org_id = nvl(l_sold_to_org_id, sold_to_org_id)
2989: AND nvl(acknowledgment_flag, 'N') = 'Y'

Line 2993: FROM OE_Line_Acks

2989: AND nvl(acknowledgment_flag, 'N') = 'Y'
2990: AND ((p_operating_unit IS NULL AND MO_GLOBAL.Check_Access (org_id) = l_yes) OR org_id = p_operating_unit);
2991: ELSIF p_orig_sys_document_ref_to IS NOT NULL THEN
2992: DELETE
2993: FROM OE_Line_Acks
2994: WHERE order_source_id = nvl(p_order_source_id, order_source_id)
2995: AND orig_sys_document_ref <= p_orig_sys_document_ref_to
2996: AND sold_to_org_id = nvl(l_sold_to_org_id, sold_to_org_id)
2997: AND nvl(acknowledgment_flag, 'N') = 'Y'

Line 3001: FROM OE_Line_Acks

2997: AND nvl(acknowledgment_flag, 'N') = 'Y'
2998: AND ((p_operating_unit IS NULL AND MO_GLOBAL.Check_Access (org_id) = l_yes) OR org_id = p_operating_unit);
2999: ELSE
3000: DELETE
3001: FROM OE_Line_Acks
3002: WHERE order_source_id = nvl(p_order_source_id, order_source_id)
3003: AND orig_sys_document_ref >= ' '
3004: AND sold_to_org_id = nvl(l_sold_to_org_id, sold_to_org_id)
3005: AND nvl(acknowledgment_flag, 'N') = 'Y'