DBA Data[Home] [Help]

APPS.OE_PURCHASE_RELEASE_PVT dependencies on PO_TBL_NUMBER

Line 1222: l_req_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();

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();

Line 1223: l_req_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();

Line 1224: l_po_header_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:

Line 1225: l_po_release_id PO_TBL_NUMBER := PO_TBL_NUMBER();

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();

Line 1226: l_po_line_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();

Line 1227: l_po_line_location_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();

Line 1229: l_can_req_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();

Line 1230: l_can_req_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();

Line 1231: l_can_po_header_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:

Line 1232: l_can_po_release_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:
1236: l_quantity PO_TBL_NUMBER := PO_TBL_NUMBER();

Line 1233: l_can_po_line_id 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();

Line 1234: l_can_po_line_location_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();
1238: l_need_by_date PO_TBL_DATE := PO_TBL_DATE();

Line 1236: l_quantity 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();
1239: l_ship_to_location PO_TBL_NUMBER := PO_TBL_NUMBER();
1240: l_sales_order_updated_date PO_TBL_DATE := PO_TBL_DATE();

Line 1237: l_secondary_quantity 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();
1241: l_grade po_tbl_varchar240 := po_tbl_varchar240(); -- INVCONV

Line 1239: l_ship_to_location 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
1242:
1243: l_ds_quantity NUMBER;