APPS.PO_PDOI_MOVE_TO_DRAFT_TABS_PVT dependencies on PO_LINE_LOCATIONS

Line 1216: FROM po_line_locations

1212: SELECT l_key,
1213: line_location_id,
1214: x_lines.draft_id_tbl(i),
1215: 'Y'
1216: FROM po_line_locations
1217: WHERE po_line_id = x_lines.po_line_id_tbl(i);
1218:
1219: d_position := 300;
1220:

Line 1234: PO_LINE_LOCATIONS_DRAFT_PKG.sync_draft_from_txn

1230: FOR i IN 1..l_change_loc_id_tbl.COUNT
1231: LOOP
1232: l_delete_flag_tbl(i) := 'N';
1233: END LOOP;
1234: PO_LINE_LOCATIONS_DRAFT_PKG.sync_draft_from_txn
1235: (
1236: p_line_location_id_tbl => l_change_loc_id_tbl,
1237: p_draft_id_tbl => l_draft_id_tbl,
1238: p_delete_flag_tbl => l_delete_flag_tbl,

Line 1243: PO_LINE_LOCATIONS_DRAFT_PKG.sync_draft_from_txn

1239: x_record_already_exist_tbl => l_record_already_exist_tbl
1240: );
1241: ELSE -- document_type = 'QUOTATION'
1242: -- delete price breaks for the line
1243: PO_LINE_LOCATIONS_DRAFT_PKG.sync_draft_from_txn
1244: (
1245: p_line_location_id_tbl => l_change_loc_id_tbl,
1246: p_draft_id_tbl => l_draft_id_tbl,
1247: p_delete_flag_tbl => l_delete_flag_tbl,

Line 1261: FROM po_line_locations

1257: SELECT l_key,
1258: l_uom_warning_queue(i)
1259: FROM DUAL
1260: WHERE EXISTS (SELECT 1
1261: FROM po_line_locations
1262: WHERE po_line_id = x_lines.po_line_id_tbl(i)
1263: AND shipment_type = 'PRICE BREAK')
1264: OR EXISTS (SELECT 1
1265: FROM po_line_locations_draft_all

Line 1265: FROM po_line_locations_draft_all

1261: FROM po_line_locations
1262: WHERE po_line_id = x_lines.po_line_id_tbl(i)
1263: AND shipment_type = 'PRICE BREAK')
1264: OR EXISTS (SELECT 1
1265: FROM po_line_locations_draft_all
1266: WHERE po_line_id =
1267: x_lines.po_line_id_tbl(i)
1268: AND draft_id = x_lines.draft_id_tbl(i)
1269: AND shipment_type = 'PRICE BREAK')

Line 1533: FROM po_line_locations

1529: SELECT DISTINCT l_key,
1530: line_location_id,
1531: p_line_locs.draft_id_tbl(i),
1532: 'Y'
1533: FROM po_line_locations
1534: WHERE po_line_id = p_line_locs.ln_po_line_id_tbl(i)
1535: AND p_line_locs.error_flag_tbl(i) = FND_API.g_FALSE;
1536:
1537: d_position := 20;

Line 1547: PO_LINE_LOCATIONS_DRAFT_PKG.sync_draft_from_txn

1543:
1544: d_position := 30;
1545:
1546: -- sync from txn to draft table with delete_flag set to 'Y'
1547: PO_LINE_LOCATIONS_DRAFT_PKG.sync_draft_from_txn
1548: (
1549: p_line_location_id_tbl => l_change_loc_id_tbl,
1550: p_draft_id_tbl => l_draft_id_tbl,
1551: p_delete_flag_tbl => l_delete_flag_tbl,

Line 1558: -- insert line location rows into po_line_locations_draft_all

1554: END IF;
1555: */
1556: d_position := 40;
1557:
1558: -- insert line location rows into po_line_locations_draft_all
1559: insert_po_line_locs_draft_all
1560: (
1561: p_line_locs => p_line_locs
1562: );

Line 3108: -- po_line_locations_draft_all

3104: --Start of Comments
3105: --Name: insert_po_line_locs_draft_all
3106: --Function:
3107: -- insert new line location attribute values into
3108: -- po_line_locations_draft_all
3109: --Parameters:
3110: --IN:
3111: --p_line_locs
3112: -- record which contains processed line attributes in a batch;

Line 3158: INSERT INTO po_line_locations_draft_all

3154: --Bug 8565385. If unit_meas_lookup_code is null for line_locations,
3155: --get the value from lines_draft. When code executed to this point, the
3156: --lines_draft has been inserted with derived and defaulted values
3157: FORALL i IN 1..p_line_locs.rec_count
3158: INSERT INTO po_line_locations_draft_all
3159: (
3160: draft_id,
3161: org_id,
3162: delete_flag,

Line 3379: FROM po_line_locations_interface

3375: p_line_locs.value_basis_tbl(i),
3376: p_line_locs.matching_basis_tbl(i),
3377: p_line_locs.payment_type_tbl(i), -- PDOI for Complex PO Project
3378: p_line_locs.ln_item_desc_tbl(i) -- PDOI for Complex PO Project
3379: FROM po_line_locations_interface
3380: WHERE interface_line_location_id = p_line_locs.intf_line_loc_id_tbl(i)
3381: AND p_line_locs.error_flag_tbl(i) = FND_API.g_FALSE;
3382:
3383: IF (PO_LOG.d_proc) THEN