DBA Data[Home] [Help]

APPS.OE_PURCHASE_RELEASE_PVT dependencies on PO_TBL_NUMBER

Line 1257: l_req_header_id PO_TBL_NUMBER := PO_TBL_NUMBER();

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

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

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

Line 1260: l_po_release_id PO_TBL_NUMBER := PO_TBL_NUMBER();

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

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

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

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

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

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

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

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

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

Line 1271: l_quantity 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();
1274: l_ship_to_location PO_TBL_NUMBER := PO_TBL_NUMBER();
1275: l_sales_order_updated_date PO_TBL_DATE := PO_TBL_DATE();

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

Line 1274: l_ship_to_location 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
1277:
1278: l_ds_quantity NUMBER;