APPS.PO_DRAFTS_PVT dependencies on PO_LINE_LOCATIONS_DRAFT_ALL

Line 406: FROM po_line_locations_draft_all plld

402: AND poel.entity_name = G_LOCK_SHIPMENT_ENTITY
403: )
404: -- : Stamping revision_num for newly added shipment on mod.
405: OR EXISTS ( SELECT 'New Shipment'
406: FROM po_line_locations_draft_all plld
407: WHERE plld.line_location_id = plla.line_location_id
408: AND plld.draft_id = p_draft_id
409: AND plld.change_status = 'NEW'
410: )

Line 3792: UPDATE po_line_locations_draft_all

3788: WHERE draft_id = p_draft_id
3789: AND change_accepted_flag IS NULL;
3790:
3791: d_position := 50;
3792: UPDATE po_line_locations_draft_all
3793: SET change_accepted_flag = l_change_accepted_flag
3794: WHERE draft_id = p_draft_id
3795: AND change_accepted_flag IS NULL;
3796:

Line 4899: FROM po_line_locations_draft_all ppbrd,

4895: NVL(ppbrd.start_date ,G_NULL_DATE),
4896: NVL(ppbrd.end_date ,G_NULL_DATE)
4897: ) p_lock_attrs,
4898: ppbrd.line_location_id
4899: FROM po_line_locations_draft_all ppbrd,
4900: po_session_gt pogt
4901: WHERE ppbrd.draft_id = p_draft_id
4902: AND ppbrd.po_line_id = pogt.char1 -- po_line_id
4903: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID

Line 4994: FROM po_line_locations_draft_all poll_draft

4990: 'S'
4991: FROM po_lines_all pol,
4992: po_drafts dft
4993: WHERE EXISTS ( SELECT line_location_id -- new shipment added
4994: FROM po_line_locations_draft_all poll_draft
4995: WHERE poll_draft.po_line_id = pol.po_line_id
4996: AND poll_draft.draft_id = p_draft_id
4997: MINUS
4998: SELECT line_location_id

Line 5229: FROM po_line_locations_draft_all polld,

5225: NVL(polld.ship_to_organization_id ,G_NULL_NUM),
5226: NVL(polld.unit_meas_lookup_code, G_NULL_CHAR),
5227: NVL(polld.transaction_flow_header_id ,G_NULL_NUM)
5228: ) f_lock_attrs
5229: FROM po_line_locations_draft_all polld,
5230: po_session_gt pogt
5231: WHERE polld.draft_id = p_draft_id
5232: AND polld.line_location_id = pogt.char1 -- line_location_id
5233: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID

Line 7626: FROM po_line_locations_draft_all pllbd,

7622: G_LOCK_SHIPMENT_ENTITY,
7623: pllbd.line_location_id,
7624: p_draft_id,
7625: 'P'
7626: FROM po_line_locations_draft_all pllbd,
7627: po_session_gt pogt
7628: WHERE pllbd.draft_id = p_draft_id
7629: AND pllbd.line_location_id = pogt.char1 -- line_location_id
7630: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID

Line 8419: FROM po_line_locations_draft_all

8415: WHERE pda.line_location_id IN (SELECT * FROM TABLE(po_ship_ids_tbl));
8416:
8417: FORALL itr IN 1..po_ship_ids_tbl.Count
8418: DELETE
8419: FROM po_line_locations_draft_all
8420: WHERE line_location_id = po_ship_ids_tbl(itr)
8421: AND draft_id = p_po_draft_id;
8422:
8423: FORALL itr IN 1..po_ship_ids_tbl.Count

Line 8734: FROM po_line_locations_draft_all

8730: --delete line location data
8731: SELECT line_location_id
8732: BULK COLLECT
8733: INTO l_line_loc_id_tbl
8734: FROM po_line_locations_draft_all
8735: WHERE delete_flag = 'Y'
8736: AND draft_id = p_draft_id
8737: AND NVL(change_accepted_flag, 'Y') = 'Y';
8738:

Line 8740: DELETE FROM po_line_locations_draft_all

8736: AND draft_id = p_draft_id
8737: AND NVL(change_accepted_flag, 'Y') = 'Y';
8738:
8739: FORALL i IN 1..l_line_loc_id_tbl.Count()
8740: DELETE FROM po_line_locations_draft_all
8741: WHERE line_location_id = l_line_loc_id_tbl(i)
8742: AND draft_id = p_draft_id;
8743:
8744: FORALL i IN 1..l_line_loc_id_tbl.Count()