1253: l_return_status VARCHAR2(3);
1254: l_count NUMBER := 1;
1255: l_can_count NUMBER := 1;
1256:
1257: l_req_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1258: l_req_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1259: l_po_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1260: l_po_release_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1261: l_po_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1254: l_count NUMBER := 1;
1255: l_can_count NUMBER := 1;
1256:
1257: l_req_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1258: l_req_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1259: l_po_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1260: l_po_release_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1261: l_po_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1262: l_po_line_location_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1255: l_can_count NUMBER := 1;
1256:
1257: l_req_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1258: l_req_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1259: l_po_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1260: l_po_release_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1261: l_po_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1262: l_po_line_location_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1263:
1256:
1257: l_req_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1258: l_req_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1259: l_po_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1260: l_po_release_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1261: l_po_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1262: l_po_line_location_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1263:
1264: l_can_req_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1257: l_req_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1258: l_req_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1259: l_po_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1260: l_po_release_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1261: l_po_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1262: l_po_line_location_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1263:
1264: l_can_req_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1265: l_can_req_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1258: l_req_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1259: l_po_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1260: l_po_release_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1261: l_po_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1262: l_po_line_location_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1263:
1264: l_can_req_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1265: l_can_req_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1266: l_can_po_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1260: l_po_release_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1261: l_po_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1262: l_po_line_location_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1263:
1264: l_can_req_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1265: l_can_req_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1266: l_can_po_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1267: l_can_po_release_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1268: l_can_po_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1261: l_po_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1262: l_po_line_location_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1263:
1264: l_can_req_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1265: l_can_req_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1266: l_can_po_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1267: l_can_po_release_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1268: l_can_po_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1269: l_can_po_line_location_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1262: l_po_line_location_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1263:
1264: l_can_req_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1265: l_can_req_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1266: l_can_po_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1267: l_can_po_release_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1268: l_can_po_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1269: l_can_po_line_location_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1270:
1263:
1264: l_can_req_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1265: l_can_req_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1266: l_can_po_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1267: l_can_po_release_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1268: l_can_po_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1269: l_can_po_line_location_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1270:
1271: l_quantity PO_TBL_NUMBER := PO_TBL_NUMBER();
1264: l_can_req_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1265: l_can_req_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1266: l_can_po_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1267: l_can_po_release_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1268: l_can_po_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1269: l_can_po_line_location_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1270:
1271: l_quantity PO_TBL_NUMBER := PO_TBL_NUMBER();
1272: l_secondary_quantity PO_TBL_NUMBER := PO_TBL_NUMBER();
1265: l_can_req_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1266: l_can_po_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1267: l_can_po_release_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1268: l_can_po_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1269: l_can_po_line_location_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1270:
1271: l_quantity PO_TBL_NUMBER := PO_TBL_NUMBER();
1272: l_secondary_quantity PO_TBL_NUMBER := PO_TBL_NUMBER();
1273: l_need_by_date PO_TBL_DATE := PO_TBL_DATE();
1267: l_can_po_release_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1268: l_can_po_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1269: l_can_po_line_location_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1270:
1271: l_quantity PO_TBL_NUMBER := PO_TBL_NUMBER();
1272: l_secondary_quantity PO_TBL_NUMBER := PO_TBL_NUMBER();
1273: l_need_by_date PO_TBL_DATE := PO_TBL_DATE();
1274: l_ship_to_location PO_TBL_NUMBER := PO_TBL_NUMBER();
1275: l_sales_order_updated_date PO_TBL_DATE := PO_TBL_DATE();
1268: l_can_po_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1269: l_can_po_line_location_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1270:
1271: l_quantity PO_TBL_NUMBER := PO_TBL_NUMBER();
1272: l_secondary_quantity PO_TBL_NUMBER := PO_TBL_NUMBER();
1273: l_need_by_date PO_TBL_DATE := PO_TBL_DATE();
1274: l_ship_to_location PO_TBL_NUMBER := PO_TBL_NUMBER();
1275: l_sales_order_updated_date PO_TBL_DATE := PO_TBL_DATE();
1276: l_grade po_tbl_varchar240 := po_tbl_varchar240(); -- INVCONV
1270:
1271: l_quantity PO_TBL_NUMBER := PO_TBL_NUMBER();
1272: l_secondary_quantity PO_TBL_NUMBER := PO_TBL_NUMBER();
1273: l_need_by_date PO_TBL_DATE := PO_TBL_DATE();
1274: l_ship_to_location PO_TBL_NUMBER := PO_TBL_NUMBER();
1275: l_sales_order_updated_date PO_TBL_DATE := PO_TBL_DATE();
1276: l_grade po_tbl_varchar240 := po_tbl_varchar240(); -- INVCONV
1277:
1278: l_ds_quantity NUMBER;