1218: l_return_status VARCHAR2(3);
1219: l_count NUMBER := 1;
1220: l_can_count NUMBER := 1;
1221:
1222: l_req_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1223: l_req_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1224: l_po_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1225: l_po_release_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1226: l_po_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1219: l_count NUMBER := 1;
1220: l_can_count NUMBER := 1;
1221:
1222: l_req_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1223: l_req_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1224: l_po_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1225: l_po_release_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1226: l_po_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1227: l_po_line_location_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1220: l_can_count NUMBER := 1;
1221:
1222: l_req_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1223: l_req_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1224: l_po_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1225: l_po_release_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1226: l_po_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1227: l_po_line_location_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1228:
1221:
1222: l_req_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1223: l_req_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1224: l_po_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1225: l_po_release_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1226: l_po_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1227: l_po_line_location_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1228:
1229: l_can_req_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1222: l_req_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1223: l_req_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1224: l_po_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1225: l_po_release_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1226: l_po_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1227: l_po_line_location_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1228:
1229: l_can_req_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1230: l_can_req_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1223: l_req_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1224: l_po_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1225: l_po_release_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1226: l_po_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1227: l_po_line_location_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1228:
1229: l_can_req_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1230: l_can_req_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1231: l_can_po_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1225: l_po_release_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1226: l_po_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1227: l_po_line_location_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1228:
1229: l_can_req_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1230: l_can_req_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1231: l_can_po_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1232: l_can_po_release_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1233: l_can_po_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1226: l_po_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1227: l_po_line_location_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1228:
1229: l_can_req_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1230: l_can_req_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1231: l_can_po_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1232: l_can_po_release_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1233: l_can_po_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1234: l_can_po_line_location_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1227: l_po_line_location_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1228:
1229: l_can_req_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1230: l_can_req_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1231: l_can_po_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1232: l_can_po_release_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1233: l_can_po_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1234: l_can_po_line_location_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1235:
1228:
1229: l_can_req_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1230: l_can_req_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1231: l_can_po_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1232: l_can_po_release_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1233: l_can_po_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1234: l_can_po_line_location_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1235:
1236: l_quantity PO_TBL_NUMBER := PO_TBL_NUMBER();
1229: l_can_req_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1230: l_can_req_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1231: l_can_po_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1232: l_can_po_release_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1233: l_can_po_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1234: l_can_po_line_location_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1235:
1236: l_quantity PO_TBL_NUMBER := PO_TBL_NUMBER();
1237: l_secondary_quantity PO_TBL_NUMBER := PO_TBL_NUMBER();
1230: l_can_req_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1231: l_can_po_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1232: l_can_po_release_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1233: l_can_po_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1234: l_can_po_line_location_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1235:
1236: l_quantity PO_TBL_NUMBER := PO_TBL_NUMBER();
1237: l_secondary_quantity PO_TBL_NUMBER := PO_TBL_NUMBER();
1238: l_need_by_date PO_TBL_DATE := PO_TBL_DATE();
1232: l_can_po_release_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1233: l_can_po_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1234: l_can_po_line_location_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1235:
1236: l_quantity PO_TBL_NUMBER := PO_TBL_NUMBER();
1237: l_secondary_quantity PO_TBL_NUMBER := PO_TBL_NUMBER();
1238: l_need_by_date PO_TBL_DATE := PO_TBL_DATE();
1239: l_ship_to_location PO_TBL_NUMBER := PO_TBL_NUMBER();
1240: l_sales_order_updated_date PO_TBL_DATE := PO_TBL_DATE();
1233: l_can_po_line_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1234: l_can_po_line_location_id PO_TBL_NUMBER := PO_TBL_NUMBER();
1235:
1236: l_quantity PO_TBL_NUMBER := PO_TBL_NUMBER();
1237: l_secondary_quantity PO_TBL_NUMBER := PO_TBL_NUMBER();
1238: l_need_by_date PO_TBL_DATE := PO_TBL_DATE();
1239: l_ship_to_location PO_TBL_NUMBER := PO_TBL_NUMBER();
1240: l_sales_order_updated_date PO_TBL_DATE := PO_TBL_DATE();
1241: l_grade po_tbl_varchar240 := po_tbl_varchar240(); -- INVCONV
1235:
1236: l_quantity PO_TBL_NUMBER := PO_TBL_NUMBER();
1237: l_secondary_quantity PO_TBL_NUMBER := PO_TBL_NUMBER();
1238: l_need_by_date PO_TBL_DATE := PO_TBL_DATE();
1239: l_ship_to_location PO_TBL_NUMBER := PO_TBL_NUMBER();
1240: l_sales_order_updated_date PO_TBL_DATE := PO_TBL_DATE();
1241: l_grade po_tbl_varchar240 := po_tbl_varchar240(); -- INVCONV
1242:
1243: l_ds_quantity NUMBER;