APPS.PO_DRAFT_APPR_STATUS_PVT dependencies on PO_LINE_LOCATIONS_DRAFT_ALL

Line 315: UPDATE po_line_locations_draft_all

311: 'Update shipment approved flag for shipment changes');
312: END IF;
313:
314: FORALL i IN 1..l_line_loc_list1.COUNT
315: UPDATE po_line_locations_draft_all
316: SET approved_flag = 'R'
317: WHERE line_location_id = l_line_loc_list1(i)
318: AND draft_id = p_draft_info.draft_id
319: AND approved_flag = 'Y';

Line 339: UPDATE po_line_locations_draft_all

335: 'Update shipment approved flag for distribution changes');
336: END IF;
337:
338: FORALL i IN 1..l_line_loc_list2.COUNT
339: UPDATE po_line_locations_draft_all
340: SET approved_flag = 'R'
341: WHERE line_location_id = l_line_loc_list2(i)
342: AND draft_id = p_draft_info.draft_id
343: AND approved_flag = 'Y';

Line 671: FROM po_line_locations_draft_all PLLD

667: INTO l_has_new_records
668: FROM dual
669: WHERE EXISTS
670: ( SELECT NULL
671: FROM po_line_locations_draft_all PLLD
672: WHERE PLLD.draft_id = p_draft_info.draft_id
673: AND NVL(PLLD.delete_flag, 'N') = 'N'
674: AND NVL(PLLD.change_accepted_flag, 'Y') = 'Y'
675: AND NOT EXISTS

Line 691: FROM po_line_locations_draft_all PLLD,

687:
688: SELECT PLLD.line_location_id
689: BULK COLLECT
690: INTO x_changed_line_loc_list
691: FROM po_line_locations_draft_all PLLD,
692: po_line_locations_all PLL
693: WHERE PLLD.draft_id = p_draft_info.draft_id
694: AND NVL(PLLD.delete_flag, 'N') = 'N'
695: AND NVL(PLLD.change_accepted_flag, 'Y') = 'Y'