APPS.OE_ELECMSGS_PVT dependencies on OE_HEADER_ACKS

Line 1292: IF p_view_name IN ('OE_HEADER_ACKS') THEN

1288: l_line_actions := TRUE;
1289: l_line_payments := TRUE;
1290: END IF;
1291: END IF;
1292: IF p_view_name IN ('OE_HEADER_ACKS') THEN
1293: l_header_acks := TRUE;
1294: IF l_purge_child_tables = 'Y' THEN
1295: l_line_acks := TRUE;
1296: END IF;

Line 2921: oe_debug_pub.add('Deleting Acknowledged Header records from OE_HEADER_ACKS');

2917: END IF;
2918:
2919: IF l_header_acks THEN
2920: IF l_debug_level > 0 THEN
2921: oe_debug_pub.add('Deleting Acknowledged Header records from OE_HEADER_ACKS');
2922: END IF;
2923: l_count := 0;
2924:
2925: IF p_orig_sys_document_ref_from IS NOT NULL

Line 2928: FROM OE_Header_Acks

2924:
2925: IF p_orig_sys_document_ref_from IS NOT NULL
2926: AND p_orig_sys_document_ref_to IS NOT NULL THEN
2927: DELETE
2928: FROM OE_Header_Acks
2929: WHERE order_source_id = nvl(p_order_source_id, order_source_id)
2930: AND orig_sys_document_ref BETWEEN p_orig_sys_document_ref_from
2931: AND p_orig_sys_document_ref_to
2932: AND sold_to_org_id = nvl(l_sold_to_org_id, sold_to_org_id)

Line 2937: FROM OE_Header_Acks

2933: AND nvl(acknowledgment_flag, 'N') = 'Y'
2934: AND ((p_operating_unit IS NULL AND MO_GLOBAL.Check_Access (org_id) = l_yes) OR org_id = p_operating_unit);
2935: ELSIF p_orig_sys_document_ref_from IS NOT NULL THEN
2936: DELETE
2937: FROM OE_Header_Acks
2938: WHERE order_source_id = nvl(p_order_source_id, order_source_id)
2939: AND orig_sys_document_ref >= p_orig_sys_document_ref_from
2940: AND sold_to_org_id = nvl(l_sold_to_org_id, sold_to_org_id)
2941: AND nvl(acknowledgment_flag, 'N') = 'Y'

Line 2945: FROM OE_Header_Acks

2941: AND nvl(acknowledgment_flag, 'N') = 'Y'
2942: AND ((p_operating_unit IS NULL AND MO_GLOBAL.Check_Access (org_id) = l_yes) OR org_id = p_operating_unit);
2943: ELSIF p_orig_sys_document_ref_to IS NOT NULL THEN
2944: DELETE
2945: FROM OE_Header_Acks
2946: WHERE order_source_id = nvl(p_order_source_id, order_source_id)
2947: AND orig_sys_document_ref <= p_orig_sys_document_ref_to
2948: AND sold_to_org_id = nvl(l_sold_to_org_id, sold_to_org_id)
2949: AND nvl(acknowledgment_flag, 'N') = 'Y'

Line 2953: FROM OE_Header_Acks

2949: AND nvl(acknowledgment_flag, 'N') = 'Y'
2950: AND ((p_operating_unit IS NULL AND MO_GLOBAL.Check_Access (org_id) = l_yes) OR org_id = p_operating_unit);
2951: ELSE
2952: DELETE
2953: FROM OE_Header_Acks
2954: WHERE order_source_id = nvl(p_order_source_id, order_source_id)
2955: AND orig_sys_document_ref >= ' '
2956: AND sold_to_org_id = nvl(l_sold_to_org_id, sold_to_org_id)
2957: AND nvl(acknowledgment_flag, 'N') = 'Y'