APPS.PO_LINE_LOCATIONS_DRAFT_PKG dependencies on PO_LINE_LOCATIONS_DRAFT_ALL

Line 47: DELETE FROM po_line_locations_draft_all

43: IF (PO_LOG.d_proc) THEN
44: PO_LOG.proc_begin(d_module);
45: END IF;
46:
47: DELETE FROM po_line_locations_draft_all
48: WHERE draft_id = p_draft_id
49: AND line_location_id = NVL(p_line_location_id, line_location_id);
50:
51: d_position := 10;

Line 149: INSERT INTO po_line_locations_draft_all

145: PO_LOG.stmt(d_module, d_position, 'transfer records from txn to dft');
146: END IF;
147:
148: FORALL i IN 1..p_line_location_id_tbl.COUNT
149: INSERT INTO po_line_locations_draft_all
150: ( draft_id,
151: delete_flag,
152: change_accepted_flag,
153: line_location_id,

Line 499: UPDATE po_line_locations_draft_all

495: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);
496: END IF;
497:
498: FORALL i IN 1..p_line_location_id_tbl.COUNT
499: UPDATE po_line_locations_draft_all
500: SET delete_flag = p_delete_flag_tbl(i)
501: WHERE line_location_id = p_line_location_id_tbl(i)
502: AND draft_id = p_draft_id_tbl(i)
503: AND NVL(delete_flag, 'N') <> 'Y' -- bug5570989

Line 650: FROM po_line_locations_draft_all PLLD

646:
647: DELETE FROM po_line_locations_all PLL
648: WHERE PLL.line_location_id IN
649: ( SELECT PLLD.line_location_id
650: FROM po_line_locations_draft_all PLLD
651: WHERE PLLD.draft_id = p_draft_id
652: AND PLLD.delete_flag = 'Y'
653: AND NVL(PLLD.change_accepted_flag, 'Y') = 'Y');
654:

Line 874: FROM po_line_locations_draft_all PLLD

870: PLLD.retainage_released_amount,
871: --
872: PLLD.outsourced_assembly,
873: PLLD.tax_attribute_update_code --
874: FROM po_line_locations_draft_all PLLD
875: WHERE PLLD.draft_id = p_draft_id
876: AND NVL(PLLD.change_accepted_flag, 'Y') = 'Y'
877: ) PLLDV
878: ON (PLL.line_location_id = PLLDV.line_location_id)

Line 1387: FROM po_line_locations_draft_all

1383: END IF;
1384:
1385: SELECT 1
1386: INTO l_dummy
1387: FROM po_line_locations_draft_all
1388: WHERE line_location_id = p_line_location_id
1389: AND draft_id = p_draft_id
1390: FOR UPDATE NOWAIT;
1391: