[Home] [Help]
566: (p_sub_doc_type => l_doc_row.document_subtype);
567:
568: SELECT MAX (pli.bid_number)
569: INTO x_bid_number
570: FROM po_lines_interface pli
571: WHERE pli.interface_header_id =
572: po_autocreate_params.x_interface_header_id;
573:
574: IF g_debug_stmt
739: (p_sub_doc_type => l_doc_row.document_subtype);
740:
741: SELECT MAX (pli.bid_number)
742: INTO x_bid_number
743: FROM po_lines_interface pli
744: WHERE pli.interface_header_id =
745: po_autocreate_params.x_interface_header_id;
746:
747: IF g_debug_stmt
1212: AND pla.draft_id = l_draft_id
1213: AND plt.line_type_id(+) = pla.line_type_id
1214: AND EXISTS (
1215: SELECT 'Y'
1216: FROM po_lines_interface pli
1217: WHERE pli.line_num = pla.line_num
1218: AND pli.interface_header_id =
1219: po_autocreate_params.x_interface_header_id);
1220:
1224: pli.last_update_login, pli.last_updated_by,
1225: pli.last_update_date, pli.clm_info_flag,
1226: pli.auction_header_id, pli.auction_line_number,
1227: pli.bid_number, pli.bid_line_number, pli.interface_line_id
1228: FROM po_lines_interface pli
1229: WHERE pli.interface_header_id =
1230: po_autocreate_params.x_interface_header_id
1231: AND Nvl(pli.shipment_type, 'NONE') <> 'PRICE BREAK';
1232:
1237: pli.last_update_date, pli.clm_info_flag,
1238: pli.auction_header_id, pli.auction_line_number,
1239: pli.bid_number, pli.bid_line_number, pli.interface_line_id,
1240: pli.shipment_type
1241: FROM po_lines_interface pli
1242: WHERE pli.interface_header_id =
1243: po_autocreate_params.x_interface_header_id
1244: AND pli.line_num = p_line_num;
1245:
1246: CURSOR c_copy_lineloc_attachment (p_po_line_id NUMBER)
1247: IS
1248: SELECT pll.line_location_id
1249: FROM po_line_locations_merge_v pll,
1250: po_lines_interface pli,
1251: po_lines_all pla
1252: WHERE pll.po_line_id = p_po_line_id
1253: AND pll.draft_id = l_draft_id
1254: AND pli.interface_header_id =
1276: --sourcing entities need to be suppressed due to the grouping of lines.
1277: x_attch_suppress_flag VARCHAR2 (1) := 'N';
1278: l_one_time_att_doc_id NUMBER;
1279: x_line_location_id NUMBER;
1280: x_auction_header_id po_lines_interface.auction_header_id%TYPE;
1281: BEGIN
1282: IF g_debug_stmt
1283: THEN
1284: po_debug.debug_begin (p_log_head => g_log_head || l_api_name);
1285: END IF;
1286:
1287: SELECT MAX (pli.auction_header_id)
1288: INTO x_auction_header_id
1289: FROM po_lines_interface pli
1290: WHERE pli.interface_header_id =
1291: po_autocreate_params.x_interface_header_id;
1292:
1293: IF p_is_mod = 'Y' THEN
1779:
1780: CURSOR c_old_parent
1781: IS
1782: SELECT pla.group_line_id, pla.po_line_id
1783: FROM po_lines_draft_all pla, po_lines_interface pli
1784: WHERE pli.group_line_id IS NOT NULL
1785: AND pli.interface_header_id =
1786: po_autocreate_params.x_interface_header_id
1787: AND pli.line_num = pla.line_num
1790:
1791: CURSOR c_old_base
1792: IS
1793: SELECT pla.clm_base_line_num, pla.po_line_id
1794: FROM po_lines_draft_all pla, po_lines_interface pli
1795: WHERE pli.clm_base_line_num IS NOT NULL
1796: AND pli.interface_header_id =
1797: po_autocreate_params.x_interface_header_id
1798: AND pli.line_num = pla.line_num
1805: pla.clm_base_line_num,
1806: pla.po_line_id,
1807: rownum --bug 13584453
1808: FROM po_lines_draft_all pla,
1809: po_lines_interface pli
1810: WHERE pli.clm_base_line_num IS NOT NULL
1811: AND pli.interface_header_id = po_autocreate_params.x_interface_header_id
1812: AND pli.line_num = pla.line_num
1813: AND pla.po_header_id = po_autocreate_params.g_po_header_id
1827: LOOP
1828: UPDATE po_lines_draft_all
1829: SET group_line_id =
1830: (SELECT pla.po_line_id
1831: FROM po_lines_interface pli, po_lines_draft_all pla
1832: WHERE 1 = 1
1833: AND pla.po_header_id =
1834: po_autocreate_params.g_po_header_id
1835: AND pla.group_line_id IS NULL
1855: LOOP
1856: UPDATE po_lines_draft_all
1857: SET clm_base_line_num =
1858: (SELECT pla.po_line_id
1859: FROM po_lines_interface pli, po_lines_draft_all pla
1860: WHERE 1 = 1
1861: AND pla.po_header_id =
1862: po_autocreate_params.g_po_header_id
1863: AND pla.clm_base_line_num IS NULL
1968: l_progress := 30;
1969:
1970: UPDATE po_distributions_draft_all pda
1971: SET group_line_id = ( SELECT pld.po_line_id
1972: FROM po_lines_draft_all pld , po_lines_interface PLI
1973: WHERE pld.draft_id = po_autocreate_params.g_draft_id
1974: AND pld.po_header_id = po_autocreate_params.g_po_header_id
1975: AND pld.line_num = pli.line_num
1976: AND PLI.interface_line_id = pda.group_line_id
2137: UPDATE po_lines_all pla
2138: SET pla.line_num_display =
2139: (SELECT prl.line_num_display
2140: FROM po_requisition_lines_all prl,
2141: po_lines_interface pli
2142: WHERE prl.requisition_line_id =
2143: pli.requisition_line_id
2144: AND pli.interface_header_id =
2145: po_autocreate_params.x_interface_header_id
2368: CURSOR c_lines
2369: IS
2370:
2371: SELECT pld.po_line_id
2372: FROM po_lines_draft_all pld, po_lines_interface PLI
2373: WHERE pld.uda_template_id IS NULL
2374: AND PLI.interface_header_id = po_autocreate_params.g_interface_header_id
2375: AND PLD.po_header_id = po_autocreate_params.g_po_header_id
2376: AND pld. line_num =PLI.line_num
2380: CURSOR c_shipments
2381: IS
2382:
2383: SELECT pll.line_location_id
2384: FROM po_lines_draft_all pld, po_lines_interface PLI, po_line_locations_draft_all pll
2385: WHERE pll.uda_template_id IS NULL
2386: AND PLI.interface_header_id = po_autocreate_params.g_interface_header_id
2387: AND PLD.po_header_id = po_autocreate_params.g_po_header_id
2388: AND pld. line_num =PLI.line_num