APPS.PO_PDOI_MOVE_TO_DRAFT_TABS_PVT dependencies on PO_LINE_LOCATIONS

Line 1121: FROM po_line_locations

1117: SELECT l_key,
1118: line_location_id,
1119: x_lines.draft_id_tbl(i),
1120: 'Y'
1121: FROM po_line_locations
1122: WHERE po_line_id = x_lines.po_line_id_tbl(i);
1123:
1124: d_position := 300;
1125:

Line 1139: PO_LINE_LOCATIONS_DRAFT_PKG.sync_draft_from_txn

1135: FOR i IN 1..l_change_loc_id_tbl.COUNT
1136: LOOP
1137: l_delete_flag_tbl(i) := 'N';
1138: END LOOP;
1139: PO_LINE_LOCATIONS_DRAFT_PKG.sync_draft_from_txn
1140: (
1141: p_line_location_id_tbl => l_change_loc_id_tbl,
1142: p_draft_id_tbl => l_draft_id_tbl,
1143: p_delete_flag_tbl => l_delete_flag_tbl,

Line 1148: PO_LINE_LOCATIONS_DRAFT_PKG.sync_draft_from_txn

1144: x_record_already_exist_tbl => l_record_already_exist_tbl
1145: );
1146: ELSE -- document_type = 'QUOTATION'
1147: -- delete price breaks for the line
1148: PO_LINE_LOCATIONS_DRAFT_PKG.sync_draft_from_txn
1149: (
1150: p_line_location_id_tbl => l_change_loc_id_tbl,
1151: p_draft_id_tbl => l_draft_id_tbl,
1152: p_delete_flag_tbl => l_delete_flag_tbl,

Line 1166: FROM po_line_locations

1162: SELECT l_key,
1163: l_uom_warning_queue(i)
1164: FROM DUAL
1165: WHERE EXISTS (SELECT 1
1166: FROM po_line_locations
1167: WHERE po_line_id = x_lines.po_line_id_tbl(i)
1168: AND shipment_type = 'PRICE BREAK')
1169: OR EXISTS (SELECT 1
1170: FROM po_line_locations_draft_all

Line 1170: FROM po_line_locations_draft_all

1166: FROM po_line_locations
1167: WHERE po_line_id = x_lines.po_line_id_tbl(i)
1168: AND shipment_type = 'PRICE BREAK')
1169: OR EXISTS (SELECT 1
1170: FROM po_line_locations_draft_all
1171: WHERE po_line_id =
1172: x_lines.po_line_id_tbl(i)
1173: AND draft_id = x_lines.draft_id_tbl(i)
1174: AND shipment_type = 'PRICE BREAK')

Line 1339: FROM po_line_locations

1335: SELECT DISTINCT l_key,
1336: line_location_id,
1337: p_line_locs.draft_id_tbl(i),
1338: 'Y'
1339: FROM po_line_locations
1340: WHERE po_line_id = p_line_locs.ln_po_line_id_tbl(i)
1341: AND p_line_locs.error_flag_tbl(i) = FND_API.g_FALSE;
1342:
1343: d_position := 20;

Line 1353: PO_LINE_LOCATIONS_DRAFT_PKG.sync_draft_from_txn

1349:
1350: d_position := 30;
1351:
1352: -- sync from txn to draft table with delete_flag set to 'Y'
1353: PO_LINE_LOCATIONS_DRAFT_PKG.sync_draft_from_txn
1354: (
1355: p_line_location_id_tbl => l_change_loc_id_tbl,
1356: p_draft_id_tbl => l_draft_id_tbl,
1357: p_delete_flag_tbl => l_delete_flag_tbl,

Line 1364: -- insert line location rows into po_line_locations_draft_all

1360: END IF;
1361: */
1362: d_position := 40;
1363:
1364: -- insert line location rows into po_line_locations_draft_all
1365: insert_po_line_locs_draft_all
1366: (
1367: p_line_locs => p_line_locs
1368: );

Line 2781: -- po_line_locations_draft_all

2777: --Start of Comments
2778: --Name: insert_po_line_locs_draft_all
2779: --Function:
2780: -- insert new line location attribute values into
2781: -- po_line_locations_draft_all
2782: --Parameters:
2783: --IN:
2784: --p_line_locs
2785: -- record which contains processed line attributes in a batch;

Line 2828: INSERT INTO po_line_locations_draft_all

2824: l_valid_intf_loc_id_tbl);
2825: END IF;
2826:
2827: FORALL i IN 1..p_line_locs.rec_count
2828: INSERT INTO po_line_locations_draft_all
2829: (
2830: draft_id,
2831: org_id,
2832: delete_flag,

Line 3039: FROM po_line_locations_interface

3035: p_line_locs.secondary_unit_of_meas_tbl(i),
3036: p_line_locs.preferred_grade_tbl(i),
3037: p_line_locs.value_basis_tbl(i),
3038: p_line_locs.matching_basis_tbl(i)
3039: FROM po_line_locations_interface
3040: WHERE interface_line_location_id = p_line_locs.intf_line_loc_id_tbl(i)
3041: AND p_line_locs.error_flag_tbl(i) = FND_API.g_FALSE;
3042:
3043: IF (PO_LOG.d_proc) THEN