APPS.PO_LINE_LOCATIONS_DRAFT_PKG dependencies on PO_LINE_LOCATIONS_DRAFT_ALL

Line 81: DELETE FROM po_line_locations_draft_all

77: p_line_location_id||'-'||p_draft_id,
78: '', '', '', '', '');
79: END IF;
80:
81: DELETE FROM po_line_locations_draft_all
82: WHERE draft_id = p_draft_id
83: AND line_location_id = NVL(p_line_location_id, line_location_id);
84:
85: d_position := 10;

Line 183: INSERT INTO po_line_locations_draft_all

179: PO_LOG.stmt(d_module, d_position, 'transfer records from txn to dft');
180: END IF;
181:
182: FORALL i IN 1..p_line_location_id_tbl.COUNT
183: INSERT INTO po_line_locations_draft_all
184: ( draft_id,
185: delete_flag,
186: change_accepted_flag,
187: line_location_id,

Line 559: UPDATE po_line_locations_draft_all

555: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
556: END IF;
557:
558: FORALL i IN 1..p_line_location_id_tbl.COUNT
559: UPDATE po_line_locations_draft_all
560: SET delete_flag = p_delete_flag_tbl(i)
561: WHERE line_location_id = p_line_location_id_tbl(i)
562: AND draft_id = p_draft_id_tbl(i)
563: AND NVL(delete_flag, 'N') <> 'Y' -- bug5570989

Line 711: FROM po_line_locations_draft_all PLLD

707:
708: /*DELETE FROM po_line_locations_all PLL
709: WHERE PLL.line_location_id IN
710: ( SELECT PLLD.line_location_id
711: FROM po_line_locations_draft_all PLLD
712: WHERE PLLD.draft_id = p_draft_id
713: AND PLLD.delete_flag = 'Y'
714: AND NVL(PLLD.change_accepted_flag, 'Y') = 'Y');
715: */

Line 720: FROM po_line_locations_draft_all PLLD

716:
717: SELECT line_location_id
718: BULK COLLECT
719: INTO l_line_loc_id_tbl
720: FROM po_line_locations_draft_all PLLD
721: WHERE PLLD.draft_id = p_draft_id
722: AND PLLD.delete_flag = 'Y'
723: AND NVL(PLLD.change_accepted_flag, 'Y') = 'Y';
724:

Line 974: FROM po_line_locations_draft_all PLLD

970: PLLD.clm_pop_duration,
971: PLLD.clm_delivery_period_uom,
972: PLLD.clm_promise_period_uom,
973: PLLD.clm_pop_duration_uom
974: FROM po_line_locations_draft_all PLLD
975: WHERE PLLD.draft_id = p_draft_id
976: AND NVL(PLLD.change_accepted_flag, 'Y') = 'Y'
977: ) PLLDV
978: ON (PLL.line_location_id = PLLDV.line_location_id)

Line 1516: FROM po_line_locations_draft_all

1512: END IF;
1513:
1514: SELECT 1
1515: INTO l_dummy
1516: FROM po_line_locations_draft_all
1517: WHERE line_location_id = p_line_location_id
1518: AND draft_id = p_draft_id
1519: FOR UPDATE NOWAIT;
1520: