[Home] [Help]
3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE oiav_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM
8: ,khr_id NUMBER := OKC_API.G_MISS_NUM
9: ,instance_number OKL_OPEN_INT_ASST.INSTANCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
10: ,asset_id NUMBER := OKC_API.G_MISS_NUM
11: ,asset_number OKL_OPEN_INT_ASST.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE oiav_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM
8: ,khr_id NUMBER := OKC_API.G_MISS_NUM
9: ,instance_number OKL_OPEN_INT_ASST.INSTANCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
10: ,asset_id NUMBER := OKC_API.G_MISS_NUM
11: ,asset_number OKL_OPEN_INT_ASST.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
12: ,description OKL_OPEN_INT_ASST.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
5: ---------------------------------------------------------------------------
6: TYPE oiav_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM
8: ,khr_id NUMBER := OKC_API.G_MISS_NUM
9: ,instance_number OKL_OPEN_INT_ASST.INSTANCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
10: ,asset_id NUMBER := OKC_API.G_MISS_NUM
11: ,asset_number OKL_OPEN_INT_ASST.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
12: ,description OKL_OPEN_INT_ASST.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,asset_type OKL_OPEN_INT_ASST.ASSET_TYPE%TYPE := OKC_API.G_MISS_CHAR
6: TYPE oiav_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM
8: ,khr_id NUMBER := OKC_API.G_MISS_NUM
9: ,instance_number OKL_OPEN_INT_ASST.INSTANCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
10: ,asset_id NUMBER := OKC_API.G_MISS_NUM
11: ,asset_number OKL_OPEN_INT_ASST.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
12: ,description OKL_OPEN_INT_ASST.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,asset_type OKL_OPEN_INT_ASST.ASSET_TYPE%TYPE := OKC_API.G_MISS_CHAR
14: ,manufacturer_name OKL_OPEN_INT_ASST.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR
7: id NUMBER := OKC_API.G_MISS_NUM
8: ,khr_id NUMBER := OKC_API.G_MISS_NUM
9: ,instance_number OKL_OPEN_INT_ASST.INSTANCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
10: ,asset_id NUMBER := OKC_API.G_MISS_NUM
11: ,asset_number OKL_OPEN_INT_ASST.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
12: ,description OKL_OPEN_INT_ASST.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,asset_type OKL_OPEN_INT_ASST.ASSET_TYPE%TYPE := OKC_API.G_MISS_CHAR
14: ,manufacturer_name OKL_OPEN_INT_ASST.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR
15: ,model_number OKL_OPEN_INT_ASST.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
8: ,khr_id NUMBER := OKC_API.G_MISS_NUM
9: ,instance_number OKL_OPEN_INT_ASST.INSTANCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
10: ,asset_id NUMBER := OKC_API.G_MISS_NUM
11: ,asset_number OKL_OPEN_INT_ASST.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
12: ,description OKL_OPEN_INT_ASST.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,asset_type OKL_OPEN_INT_ASST.ASSET_TYPE%TYPE := OKC_API.G_MISS_CHAR
14: ,manufacturer_name OKL_OPEN_INT_ASST.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR
15: ,model_number OKL_OPEN_INT_ASST.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
16: ,serial_number OKL_OPEN_INT_ASST.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
9: ,instance_number OKL_OPEN_INT_ASST.INSTANCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
10: ,asset_id NUMBER := OKC_API.G_MISS_NUM
11: ,asset_number OKL_OPEN_INT_ASST.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
12: ,description OKL_OPEN_INT_ASST.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,asset_type OKL_OPEN_INT_ASST.ASSET_TYPE%TYPE := OKC_API.G_MISS_CHAR
14: ,manufacturer_name OKL_OPEN_INT_ASST.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR
15: ,model_number OKL_OPEN_INT_ASST.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
16: ,serial_number OKL_OPEN_INT_ASST.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
17: ,tag_number OKL_OPEN_INT_ASST.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR
10: ,asset_id NUMBER := OKC_API.G_MISS_NUM
11: ,asset_number OKL_OPEN_INT_ASST.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
12: ,description OKL_OPEN_INT_ASST.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,asset_type OKL_OPEN_INT_ASST.ASSET_TYPE%TYPE := OKC_API.G_MISS_CHAR
14: ,manufacturer_name OKL_OPEN_INT_ASST.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR
15: ,model_number OKL_OPEN_INT_ASST.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
16: ,serial_number OKL_OPEN_INT_ASST.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
17: ,tag_number OKL_OPEN_INT_ASST.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR
18: ,original_cost NUMBER := OKC_API.G_MISS_NUM
11: ,asset_number OKL_OPEN_INT_ASST.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
12: ,description OKL_OPEN_INT_ASST.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,asset_type OKL_OPEN_INT_ASST.ASSET_TYPE%TYPE := OKC_API.G_MISS_CHAR
14: ,manufacturer_name OKL_OPEN_INT_ASST.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR
15: ,model_number OKL_OPEN_INT_ASST.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
16: ,serial_number OKL_OPEN_INT_ASST.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
17: ,tag_number OKL_OPEN_INT_ASST.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR
18: ,original_cost NUMBER := OKC_API.G_MISS_NUM
19: ,quantity OKL_OPEN_INT_ASST.QUANTITY%TYPE := OKC_API.G_MISS_CHAR
12: ,description OKL_OPEN_INT_ASST.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,asset_type OKL_OPEN_INT_ASST.ASSET_TYPE%TYPE := OKC_API.G_MISS_CHAR
14: ,manufacturer_name OKL_OPEN_INT_ASST.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR
15: ,model_number OKL_OPEN_INT_ASST.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
16: ,serial_number OKL_OPEN_INT_ASST.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
17: ,tag_number OKL_OPEN_INT_ASST.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR
18: ,original_cost NUMBER := OKC_API.G_MISS_NUM
19: ,quantity OKL_OPEN_INT_ASST.QUANTITY%TYPE := OKC_API.G_MISS_CHAR
20: ,country OKL_OPEN_INT_ASST.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
13: ,asset_type OKL_OPEN_INT_ASST.ASSET_TYPE%TYPE := OKC_API.G_MISS_CHAR
14: ,manufacturer_name OKL_OPEN_INT_ASST.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR
15: ,model_number OKL_OPEN_INT_ASST.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
16: ,serial_number OKL_OPEN_INT_ASST.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
17: ,tag_number OKL_OPEN_INT_ASST.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR
18: ,original_cost NUMBER := OKC_API.G_MISS_NUM
19: ,quantity OKL_OPEN_INT_ASST.QUANTITY%TYPE := OKC_API.G_MISS_CHAR
20: ,country OKL_OPEN_INT_ASST.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
21: ,address1 OKL_OPEN_INT_ASST.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
14: ,manufacturer_name OKL_OPEN_INT_ASST.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR
15: ,model_number OKL_OPEN_INT_ASST.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
16: ,serial_number OKL_OPEN_INT_ASST.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
17: ,tag_number OKL_OPEN_INT_ASST.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR
18: ,original_cost NUMBER := OKC_API.G_MISS_NUM
19: ,quantity OKL_OPEN_INT_ASST.QUANTITY%TYPE := OKC_API.G_MISS_CHAR
20: ,country OKL_OPEN_INT_ASST.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
21: ,address1 OKL_OPEN_INT_ASST.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
22: ,address2 OKL_OPEN_INT_ASST.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
15: ,model_number OKL_OPEN_INT_ASST.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
16: ,serial_number OKL_OPEN_INT_ASST.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
17: ,tag_number OKL_OPEN_INT_ASST.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR
18: ,original_cost NUMBER := OKC_API.G_MISS_NUM
19: ,quantity OKL_OPEN_INT_ASST.QUANTITY%TYPE := OKC_API.G_MISS_CHAR
20: ,country OKL_OPEN_INT_ASST.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
21: ,address1 OKL_OPEN_INT_ASST.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
22: ,address2 OKL_OPEN_INT_ASST.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
23: ,address3 OKL_OPEN_INT_ASST.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
16: ,serial_number OKL_OPEN_INT_ASST.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
17: ,tag_number OKL_OPEN_INT_ASST.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR
18: ,original_cost NUMBER := OKC_API.G_MISS_NUM
19: ,quantity OKL_OPEN_INT_ASST.QUANTITY%TYPE := OKC_API.G_MISS_CHAR
20: ,country OKL_OPEN_INT_ASST.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
21: ,address1 OKL_OPEN_INT_ASST.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
22: ,address2 OKL_OPEN_INT_ASST.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
23: ,address3 OKL_OPEN_INT_ASST.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
24: ,address4 OKL_OPEN_INT_ASST.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
17: ,tag_number OKL_OPEN_INT_ASST.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR
18: ,original_cost NUMBER := OKC_API.G_MISS_NUM
19: ,quantity OKL_OPEN_INT_ASST.QUANTITY%TYPE := OKC_API.G_MISS_CHAR
20: ,country OKL_OPEN_INT_ASST.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
21: ,address1 OKL_OPEN_INT_ASST.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
22: ,address2 OKL_OPEN_INT_ASST.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
23: ,address3 OKL_OPEN_INT_ASST.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
24: ,address4 OKL_OPEN_INT_ASST.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
25: ,city OKL_OPEN_INT_ASST.CITY%TYPE := OKC_API.G_MISS_CHAR
18: ,original_cost NUMBER := OKC_API.G_MISS_NUM
19: ,quantity OKL_OPEN_INT_ASST.QUANTITY%TYPE := OKC_API.G_MISS_CHAR
20: ,country OKL_OPEN_INT_ASST.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
21: ,address1 OKL_OPEN_INT_ASST.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
22: ,address2 OKL_OPEN_INT_ASST.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
23: ,address3 OKL_OPEN_INT_ASST.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
24: ,address4 OKL_OPEN_INT_ASST.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
25: ,city OKL_OPEN_INT_ASST.CITY%TYPE := OKC_API.G_MISS_CHAR
26: ,postal_code OKL_OPEN_INT_ASST.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
19: ,quantity OKL_OPEN_INT_ASST.QUANTITY%TYPE := OKC_API.G_MISS_CHAR
20: ,country OKL_OPEN_INT_ASST.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
21: ,address1 OKL_OPEN_INT_ASST.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
22: ,address2 OKL_OPEN_INT_ASST.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
23: ,address3 OKL_OPEN_INT_ASST.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
24: ,address4 OKL_OPEN_INT_ASST.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
25: ,city OKL_OPEN_INT_ASST.CITY%TYPE := OKC_API.G_MISS_CHAR
26: ,postal_code OKL_OPEN_INT_ASST.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
27: ,state OKL_OPEN_INT_ASST.STATE%TYPE := OKC_API.G_MISS_CHAR
20: ,country OKL_OPEN_INT_ASST.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
21: ,address1 OKL_OPEN_INT_ASST.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
22: ,address2 OKL_OPEN_INT_ASST.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
23: ,address3 OKL_OPEN_INT_ASST.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
24: ,address4 OKL_OPEN_INT_ASST.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
25: ,city OKL_OPEN_INT_ASST.CITY%TYPE := OKC_API.G_MISS_CHAR
26: ,postal_code OKL_OPEN_INT_ASST.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
27: ,state OKL_OPEN_INT_ASST.STATE%TYPE := OKC_API.G_MISS_CHAR
28: ,province OKL_OPEN_INT_ASST.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
21: ,address1 OKL_OPEN_INT_ASST.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
22: ,address2 OKL_OPEN_INT_ASST.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
23: ,address3 OKL_OPEN_INT_ASST.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
24: ,address4 OKL_OPEN_INT_ASST.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
25: ,city OKL_OPEN_INT_ASST.CITY%TYPE := OKC_API.G_MISS_CHAR
26: ,postal_code OKL_OPEN_INT_ASST.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
27: ,state OKL_OPEN_INT_ASST.STATE%TYPE := OKC_API.G_MISS_CHAR
28: ,province OKL_OPEN_INT_ASST.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
29: ,county OKL_OPEN_INT_ASST.COUNTY%TYPE := OKC_API.G_MISS_CHAR
22: ,address2 OKL_OPEN_INT_ASST.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
23: ,address3 OKL_OPEN_INT_ASST.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
24: ,address4 OKL_OPEN_INT_ASST.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
25: ,city OKL_OPEN_INT_ASST.CITY%TYPE := OKC_API.G_MISS_CHAR
26: ,postal_code OKL_OPEN_INT_ASST.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
27: ,state OKL_OPEN_INT_ASST.STATE%TYPE := OKC_API.G_MISS_CHAR
28: ,province OKL_OPEN_INT_ASST.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
29: ,county OKL_OPEN_INT_ASST.COUNTY%TYPE := OKC_API.G_MISS_CHAR
30: ,po_box_number OKL_OPEN_INT_ASST.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
23: ,address3 OKL_OPEN_INT_ASST.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
24: ,address4 OKL_OPEN_INT_ASST.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
25: ,city OKL_OPEN_INT_ASST.CITY%TYPE := OKC_API.G_MISS_CHAR
26: ,postal_code OKL_OPEN_INT_ASST.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
27: ,state OKL_OPEN_INT_ASST.STATE%TYPE := OKC_API.G_MISS_CHAR
28: ,province OKL_OPEN_INT_ASST.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
29: ,county OKL_OPEN_INT_ASST.COUNTY%TYPE := OKC_API.G_MISS_CHAR
30: ,po_box_number OKL_OPEN_INT_ASST.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
31: ,house_number OKL_OPEN_INT_ASST.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
24: ,address4 OKL_OPEN_INT_ASST.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
25: ,city OKL_OPEN_INT_ASST.CITY%TYPE := OKC_API.G_MISS_CHAR
26: ,postal_code OKL_OPEN_INT_ASST.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
27: ,state OKL_OPEN_INT_ASST.STATE%TYPE := OKC_API.G_MISS_CHAR
28: ,province OKL_OPEN_INT_ASST.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
29: ,county OKL_OPEN_INT_ASST.COUNTY%TYPE := OKC_API.G_MISS_CHAR
30: ,po_box_number OKL_OPEN_INT_ASST.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
31: ,house_number OKL_OPEN_INT_ASST.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
32: ,street_suffix OKL_OPEN_INT_ASST.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
25: ,city OKL_OPEN_INT_ASST.CITY%TYPE := OKC_API.G_MISS_CHAR
26: ,postal_code OKL_OPEN_INT_ASST.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
27: ,state OKL_OPEN_INT_ASST.STATE%TYPE := OKC_API.G_MISS_CHAR
28: ,province OKL_OPEN_INT_ASST.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
29: ,county OKL_OPEN_INT_ASST.COUNTY%TYPE := OKC_API.G_MISS_CHAR
30: ,po_box_number OKL_OPEN_INT_ASST.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
31: ,house_number OKL_OPEN_INT_ASST.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
32: ,street_suffix OKL_OPEN_INT_ASST.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
33: ,apartment_number OKL_OPEN_INT_ASST.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
26: ,postal_code OKL_OPEN_INT_ASST.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
27: ,state OKL_OPEN_INT_ASST.STATE%TYPE := OKC_API.G_MISS_CHAR
28: ,province OKL_OPEN_INT_ASST.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
29: ,county OKL_OPEN_INT_ASST.COUNTY%TYPE := OKC_API.G_MISS_CHAR
30: ,po_box_number OKL_OPEN_INT_ASST.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
31: ,house_number OKL_OPEN_INT_ASST.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
32: ,street_suffix OKL_OPEN_INT_ASST.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
33: ,apartment_number OKL_OPEN_INT_ASST.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
34: ,street OKL_OPEN_INT_ASST.STREET%TYPE := OKC_API.G_MISS_CHAR
27: ,state OKL_OPEN_INT_ASST.STATE%TYPE := OKC_API.G_MISS_CHAR
28: ,province OKL_OPEN_INT_ASST.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
29: ,county OKL_OPEN_INT_ASST.COUNTY%TYPE := OKC_API.G_MISS_CHAR
30: ,po_box_number OKL_OPEN_INT_ASST.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
31: ,house_number OKL_OPEN_INT_ASST.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
32: ,street_suffix OKL_OPEN_INT_ASST.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
33: ,apartment_number OKL_OPEN_INT_ASST.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
34: ,street OKL_OPEN_INT_ASST.STREET%TYPE := OKC_API.G_MISS_CHAR
35: ,rural_route_number OKL_OPEN_INT_ASST.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
28: ,province OKL_OPEN_INT_ASST.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
29: ,county OKL_OPEN_INT_ASST.COUNTY%TYPE := OKC_API.G_MISS_CHAR
30: ,po_box_number OKL_OPEN_INT_ASST.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
31: ,house_number OKL_OPEN_INT_ASST.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
32: ,street_suffix OKL_OPEN_INT_ASST.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
33: ,apartment_number OKL_OPEN_INT_ASST.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
34: ,street OKL_OPEN_INT_ASST.STREET%TYPE := OKC_API.G_MISS_CHAR
35: ,rural_route_number OKL_OPEN_INT_ASST.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
36: ,street_number OKL_OPEN_INT_ASST.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
29: ,county OKL_OPEN_INT_ASST.COUNTY%TYPE := OKC_API.G_MISS_CHAR
30: ,po_box_number OKL_OPEN_INT_ASST.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
31: ,house_number OKL_OPEN_INT_ASST.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
32: ,street_suffix OKL_OPEN_INT_ASST.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
33: ,apartment_number OKL_OPEN_INT_ASST.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
34: ,street OKL_OPEN_INT_ASST.STREET%TYPE := OKC_API.G_MISS_CHAR
35: ,rural_route_number OKL_OPEN_INT_ASST.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
36: ,street_number OKL_OPEN_INT_ASST.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
37: ,building OKL_OPEN_INT_ASST.BUILDING%TYPE := OKC_API.G_MISS_CHAR
30: ,po_box_number OKL_OPEN_INT_ASST.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
31: ,house_number OKL_OPEN_INT_ASST.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
32: ,street_suffix OKL_OPEN_INT_ASST.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
33: ,apartment_number OKL_OPEN_INT_ASST.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
34: ,street OKL_OPEN_INT_ASST.STREET%TYPE := OKC_API.G_MISS_CHAR
35: ,rural_route_number OKL_OPEN_INT_ASST.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
36: ,street_number OKL_OPEN_INT_ASST.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
37: ,building OKL_OPEN_INT_ASST.BUILDING%TYPE := OKC_API.G_MISS_CHAR
38: ,floor OKL_OPEN_INT_ASST.FLOOR%TYPE := OKC_API.G_MISS_CHAR
31: ,house_number OKL_OPEN_INT_ASST.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
32: ,street_suffix OKL_OPEN_INT_ASST.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
33: ,apartment_number OKL_OPEN_INT_ASST.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
34: ,street OKL_OPEN_INT_ASST.STREET%TYPE := OKC_API.G_MISS_CHAR
35: ,rural_route_number OKL_OPEN_INT_ASST.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
36: ,street_number OKL_OPEN_INT_ASST.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
37: ,building OKL_OPEN_INT_ASST.BUILDING%TYPE := OKC_API.G_MISS_CHAR
38: ,floor OKL_OPEN_INT_ASST.FLOOR%TYPE := OKC_API.G_MISS_CHAR
39: ,suite OKL_OPEN_INT_ASST.SUITE%TYPE := OKC_API.G_MISS_CHAR
32: ,street_suffix OKL_OPEN_INT_ASST.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
33: ,apartment_number OKL_OPEN_INT_ASST.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
34: ,street OKL_OPEN_INT_ASST.STREET%TYPE := OKC_API.G_MISS_CHAR
35: ,rural_route_number OKL_OPEN_INT_ASST.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
36: ,street_number OKL_OPEN_INT_ASST.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
37: ,building OKL_OPEN_INT_ASST.BUILDING%TYPE := OKC_API.G_MISS_CHAR
38: ,floor OKL_OPEN_INT_ASST.FLOOR%TYPE := OKC_API.G_MISS_CHAR
39: ,suite OKL_OPEN_INT_ASST.SUITE%TYPE := OKC_API.G_MISS_CHAR
40: ,room OKL_OPEN_INT_ASST.ROOM%TYPE := OKC_API.G_MISS_CHAR
33: ,apartment_number OKL_OPEN_INT_ASST.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
34: ,street OKL_OPEN_INT_ASST.STREET%TYPE := OKC_API.G_MISS_CHAR
35: ,rural_route_number OKL_OPEN_INT_ASST.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
36: ,street_number OKL_OPEN_INT_ASST.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
37: ,building OKL_OPEN_INT_ASST.BUILDING%TYPE := OKC_API.G_MISS_CHAR
38: ,floor OKL_OPEN_INT_ASST.FLOOR%TYPE := OKC_API.G_MISS_CHAR
39: ,suite OKL_OPEN_INT_ASST.SUITE%TYPE := OKC_API.G_MISS_CHAR
40: ,room OKL_OPEN_INT_ASST.ROOM%TYPE := OKC_API.G_MISS_CHAR
41: ,postal_plus4_code OKL_OPEN_INT_ASST.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
34: ,street OKL_OPEN_INT_ASST.STREET%TYPE := OKC_API.G_MISS_CHAR
35: ,rural_route_number OKL_OPEN_INT_ASST.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
36: ,street_number OKL_OPEN_INT_ASST.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
37: ,building OKL_OPEN_INT_ASST.BUILDING%TYPE := OKC_API.G_MISS_CHAR
38: ,floor OKL_OPEN_INT_ASST.FLOOR%TYPE := OKC_API.G_MISS_CHAR
39: ,suite OKL_OPEN_INT_ASST.SUITE%TYPE := OKC_API.G_MISS_CHAR
40: ,room OKL_OPEN_INT_ASST.ROOM%TYPE := OKC_API.G_MISS_CHAR
41: ,postal_plus4_code OKL_OPEN_INT_ASST.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
42: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
35: ,rural_route_number OKL_OPEN_INT_ASST.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
36: ,street_number OKL_OPEN_INT_ASST.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
37: ,building OKL_OPEN_INT_ASST.BUILDING%TYPE := OKC_API.G_MISS_CHAR
38: ,floor OKL_OPEN_INT_ASST.FLOOR%TYPE := OKC_API.G_MISS_CHAR
39: ,suite OKL_OPEN_INT_ASST.SUITE%TYPE := OKC_API.G_MISS_CHAR
40: ,room OKL_OPEN_INT_ASST.ROOM%TYPE := OKC_API.G_MISS_CHAR
41: ,postal_plus4_code OKL_OPEN_INT_ASST.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
42: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
43: ,org_id NUMBER := OKC_API.G_MISS_NUM
36: ,street_number OKL_OPEN_INT_ASST.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
37: ,building OKL_OPEN_INT_ASST.BUILDING%TYPE := OKC_API.G_MISS_CHAR
38: ,floor OKL_OPEN_INT_ASST.FLOOR%TYPE := OKC_API.G_MISS_CHAR
39: ,suite OKL_OPEN_INT_ASST.SUITE%TYPE := OKC_API.G_MISS_CHAR
40: ,room OKL_OPEN_INT_ASST.ROOM%TYPE := OKC_API.G_MISS_CHAR
41: ,postal_plus4_code OKL_OPEN_INT_ASST.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
42: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
43: ,org_id NUMBER := OKC_API.G_MISS_NUM
44: ,request_id NUMBER := OKC_API.G_MISS_NUM
37: ,building OKL_OPEN_INT_ASST.BUILDING%TYPE := OKC_API.G_MISS_CHAR
38: ,floor OKL_OPEN_INT_ASST.FLOOR%TYPE := OKC_API.G_MISS_CHAR
39: ,suite OKL_OPEN_INT_ASST.SUITE%TYPE := OKC_API.G_MISS_CHAR
40: ,room OKL_OPEN_INT_ASST.ROOM%TYPE := OKC_API.G_MISS_CHAR
41: ,postal_plus4_code OKL_OPEN_INT_ASST.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
42: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
43: ,org_id NUMBER := OKC_API.G_MISS_NUM
44: ,request_id NUMBER := OKC_API.G_MISS_NUM
45: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
38: ,floor OKL_OPEN_INT_ASST.FLOOR%TYPE := OKC_API.G_MISS_CHAR
39: ,suite OKL_OPEN_INT_ASST.SUITE%TYPE := OKC_API.G_MISS_CHAR
40: ,room OKL_OPEN_INT_ASST.ROOM%TYPE := OKC_API.G_MISS_CHAR
41: ,postal_plus4_code OKL_OPEN_INT_ASST.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
42: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
43: ,org_id NUMBER := OKC_API.G_MISS_NUM
44: ,request_id NUMBER := OKC_API.G_MISS_NUM
45: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
46: ,program_id NUMBER := OKC_API.G_MISS_NUM
39: ,suite OKL_OPEN_INT_ASST.SUITE%TYPE := OKC_API.G_MISS_CHAR
40: ,room OKL_OPEN_INT_ASST.ROOM%TYPE := OKC_API.G_MISS_CHAR
41: ,postal_plus4_code OKL_OPEN_INT_ASST.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
42: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
43: ,org_id NUMBER := OKC_API.G_MISS_NUM
44: ,request_id NUMBER := OKC_API.G_MISS_NUM
45: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
46: ,program_id NUMBER := OKC_API.G_MISS_NUM
47: ,program_update_date OKL_OPEN_INT_ASST.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
40: ,room OKL_OPEN_INT_ASST.ROOM%TYPE := OKC_API.G_MISS_CHAR
41: ,postal_plus4_code OKL_OPEN_INT_ASST.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
42: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
43: ,org_id NUMBER := OKC_API.G_MISS_NUM
44: ,request_id NUMBER := OKC_API.G_MISS_NUM
45: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
46: ,program_id NUMBER := OKC_API.G_MISS_NUM
47: ,program_update_date OKL_OPEN_INT_ASST.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
48: ,attribute_category OKL_OPEN_INT_ASST.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
41: ,postal_plus4_code OKL_OPEN_INT_ASST.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
42: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
43: ,org_id NUMBER := OKC_API.G_MISS_NUM
44: ,request_id NUMBER := OKC_API.G_MISS_NUM
45: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
46: ,program_id NUMBER := OKC_API.G_MISS_NUM
47: ,program_update_date OKL_OPEN_INT_ASST.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
48: ,attribute_category OKL_OPEN_INT_ASST.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute1 OKL_OPEN_INT_ASST.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
42: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
43: ,org_id NUMBER := OKC_API.G_MISS_NUM
44: ,request_id NUMBER := OKC_API.G_MISS_NUM
45: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
46: ,program_id NUMBER := OKC_API.G_MISS_NUM
47: ,program_update_date OKL_OPEN_INT_ASST.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
48: ,attribute_category OKL_OPEN_INT_ASST.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute1 OKL_OPEN_INT_ASST.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute2 OKL_OPEN_INT_ASST.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
43: ,org_id NUMBER := OKC_API.G_MISS_NUM
44: ,request_id NUMBER := OKC_API.G_MISS_NUM
45: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
46: ,program_id NUMBER := OKC_API.G_MISS_NUM
47: ,program_update_date OKL_OPEN_INT_ASST.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
48: ,attribute_category OKL_OPEN_INT_ASST.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute1 OKL_OPEN_INT_ASST.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute2 OKL_OPEN_INT_ASST.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute3 OKL_OPEN_INT_ASST.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
44: ,request_id NUMBER := OKC_API.G_MISS_NUM
45: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
46: ,program_id NUMBER := OKC_API.G_MISS_NUM
47: ,program_update_date OKL_OPEN_INT_ASST.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
48: ,attribute_category OKL_OPEN_INT_ASST.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute1 OKL_OPEN_INT_ASST.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute2 OKL_OPEN_INT_ASST.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute3 OKL_OPEN_INT_ASST.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute4 OKL_OPEN_INT_ASST.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
45: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
46: ,program_id NUMBER := OKC_API.G_MISS_NUM
47: ,program_update_date OKL_OPEN_INT_ASST.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
48: ,attribute_category OKL_OPEN_INT_ASST.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute1 OKL_OPEN_INT_ASST.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute2 OKL_OPEN_INT_ASST.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute3 OKL_OPEN_INT_ASST.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute4 OKL_OPEN_INT_ASST.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
53: ,attribute5 OKL_OPEN_INT_ASST.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
46: ,program_id NUMBER := OKC_API.G_MISS_NUM
47: ,program_update_date OKL_OPEN_INT_ASST.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
48: ,attribute_category OKL_OPEN_INT_ASST.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute1 OKL_OPEN_INT_ASST.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute2 OKL_OPEN_INT_ASST.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute3 OKL_OPEN_INT_ASST.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute4 OKL_OPEN_INT_ASST.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
53: ,attribute5 OKL_OPEN_INT_ASST.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
54: ,attribute6 OKL_OPEN_INT_ASST.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
47: ,program_update_date OKL_OPEN_INT_ASST.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
48: ,attribute_category OKL_OPEN_INT_ASST.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute1 OKL_OPEN_INT_ASST.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute2 OKL_OPEN_INT_ASST.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute3 OKL_OPEN_INT_ASST.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute4 OKL_OPEN_INT_ASST.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
53: ,attribute5 OKL_OPEN_INT_ASST.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
54: ,attribute6 OKL_OPEN_INT_ASST.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
55: ,attribute7 OKL_OPEN_INT_ASST.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
48: ,attribute_category OKL_OPEN_INT_ASST.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute1 OKL_OPEN_INT_ASST.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute2 OKL_OPEN_INT_ASST.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute3 OKL_OPEN_INT_ASST.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute4 OKL_OPEN_INT_ASST.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
53: ,attribute5 OKL_OPEN_INT_ASST.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
54: ,attribute6 OKL_OPEN_INT_ASST.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
55: ,attribute7 OKL_OPEN_INT_ASST.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
56: ,attribute8 OKL_OPEN_INT_ASST.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute1 OKL_OPEN_INT_ASST.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute2 OKL_OPEN_INT_ASST.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute3 OKL_OPEN_INT_ASST.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute4 OKL_OPEN_INT_ASST.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
53: ,attribute5 OKL_OPEN_INT_ASST.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
54: ,attribute6 OKL_OPEN_INT_ASST.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
55: ,attribute7 OKL_OPEN_INT_ASST.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
56: ,attribute8 OKL_OPEN_INT_ASST.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute9 OKL_OPEN_INT_ASST.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute2 OKL_OPEN_INT_ASST.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute3 OKL_OPEN_INT_ASST.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute4 OKL_OPEN_INT_ASST.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
53: ,attribute5 OKL_OPEN_INT_ASST.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
54: ,attribute6 OKL_OPEN_INT_ASST.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
55: ,attribute7 OKL_OPEN_INT_ASST.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
56: ,attribute8 OKL_OPEN_INT_ASST.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute9 OKL_OPEN_INT_ASST.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute10 OKL_OPEN_INT_ASST.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute3 OKL_OPEN_INT_ASST.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute4 OKL_OPEN_INT_ASST.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
53: ,attribute5 OKL_OPEN_INT_ASST.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
54: ,attribute6 OKL_OPEN_INT_ASST.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
55: ,attribute7 OKL_OPEN_INT_ASST.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
56: ,attribute8 OKL_OPEN_INT_ASST.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute9 OKL_OPEN_INT_ASST.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute10 OKL_OPEN_INT_ASST.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute11 OKL_OPEN_INT_ASST.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute4 OKL_OPEN_INT_ASST.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
53: ,attribute5 OKL_OPEN_INT_ASST.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
54: ,attribute6 OKL_OPEN_INT_ASST.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
55: ,attribute7 OKL_OPEN_INT_ASST.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
56: ,attribute8 OKL_OPEN_INT_ASST.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute9 OKL_OPEN_INT_ASST.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute10 OKL_OPEN_INT_ASST.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute11 OKL_OPEN_INT_ASST.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute12 OKL_OPEN_INT_ASST.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
53: ,attribute5 OKL_OPEN_INT_ASST.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
54: ,attribute6 OKL_OPEN_INT_ASST.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
55: ,attribute7 OKL_OPEN_INT_ASST.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
56: ,attribute8 OKL_OPEN_INT_ASST.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute9 OKL_OPEN_INT_ASST.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute10 OKL_OPEN_INT_ASST.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute11 OKL_OPEN_INT_ASST.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute12 OKL_OPEN_INT_ASST.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute13 OKL_OPEN_INT_ASST.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
54: ,attribute6 OKL_OPEN_INT_ASST.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
55: ,attribute7 OKL_OPEN_INT_ASST.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
56: ,attribute8 OKL_OPEN_INT_ASST.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute9 OKL_OPEN_INT_ASST.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute10 OKL_OPEN_INT_ASST.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute11 OKL_OPEN_INT_ASST.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute12 OKL_OPEN_INT_ASST.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute13 OKL_OPEN_INT_ASST.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute14 OKL_OPEN_INT_ASST.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
55: ,attribute7 OKL_OPEN_INT_ASST.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
56: ,attribute8 OKL_OPEN_INT_ASST.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute9 OKL_OPEN_INT_ASST.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute10 OKL_OPEN_INT_ASST.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute11 OKL_OPEN_INT_ASST.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute12 OKL_OPEN_INT_ASST.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute13 OKL_OPEN_INT_ASST.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute14 OKL_OPEN_INT_ASST.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute15 OKL_OPEN_INT_ASST.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
56: ,attribute8 OKL_OPEN_INT_ASST.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute9 OKL_OPEN_INT_ASST.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute10 OKL_OPEN_INT_ASST.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute11 OKL_OPEN_INT_ASST.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute12 OKL_OPEN_INT_ASST.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute13 OKL_OPEN_INT_ASST.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute14 OKL_OPEN_INT_ASST.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute15 OKL_OPEN_INT_ASST.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
64: ,created_by NUMBER := OKC_API.G_MISS_NUM
57: ,attribute9 OKL_OPEN_INT_ASST.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute10 OKL_OPEN_INT_ASST.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute11 OKL_OPEN_INT_ASST.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute12 OKL_OPEN_INT_ASST.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute13 OKL_OPEN_INT_ASST.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute14 OKL_OPEN_INT_ASST.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute15 OKL_OPEN_INT_ASST.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
64: ,created_by NUMBER := OKC_API.G_MISS_NUM
65: ,creation_date OKL_OPEN_INT_ASST.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
58: ,attribute10 OKL_OPEN_INT_ASST.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute11 OKL_OPEN_INT_ASST.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute12 OKL_OPEN_INT_ASST.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute13 OKL_OPEN_INT_ASST.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute14 OKL_OPEN_INT_ASST.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute15 OKL_OPEN_INT_ASST.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
64: ,created_by NUMBER := OKC_API.G_MISS_NUM
65: ,creation_date OKL_OPEN_INT_ASST.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
66: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
59: ,attribute11 OKL_OPEN_INT_ASST.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute12 OKL_OPEN_INT_ASST.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute13 OKL_OPEN_INT_ASST.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute14 OKL_OPEN_INT_ASST.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute15 OKL_OPEN_INT_ASST.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
64: ,created_by NUMBER := OKC_API.G_MISS_NUM
65: ,creation_date OKL_OPEN_INT_ASST.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
66: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
67: ,last_update_date OKL_OPEN_INT_ASST.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
60: ,attribute12 OKL_OPEN_INT_ASST.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute13 OKL_OPEN_INT_ASST.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute14 OKL_OPEN_INT_ASST.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute15 OKL_OPEN_INT_ASST.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
64: ,created_by NUMBER := OKC_API.G_MISS_NUM
65: ,creation_date OKL_OPEN_INT_ASST.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
66: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
67: ,last_update_date OKL_OPEN_INT_ASST.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
68: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
61: ,attribute13 OKL_OPEN_INT_ASST.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute14 OKL_OPEN_INT_ASST.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute15 OKL_OPEN_INT_ASST.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
64: ,created_by NUMBER := OKC_API.G_MISS_NUM
65: ,creation_date OKL_OPEN_INT_ASST.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
66: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
67: ,last_update_date OKL_OPEN_INT_ASST.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
68: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
69: G_MISS_oiav_rec oiav_rec_type;
62: ,attribute14 OKL_OPEN_INT_ASST.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute15 OKL_OPEN_INT_ASST.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
64: ,created_by NUMBER := OKC_API.G_MISS_NUM
65: ,creation_date OKL_OPEN_INT_ASST.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
66: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
67: ,last_update_date OKL_OPEN_INT_ASST.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
68: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
69: G_MISS_oiav_rec oiav_rec_type;
70: TYPE oiav_tbl_type IS TABLE OF oiav_rec_type
63: ,attribute15 OKL_OPEN_INT_ASST.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
64: ,created_by NUMBER := OKC_API.G_MISS_NUM
65: ,creation_date OKL_OPEN_INT_ASST.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
66: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
67: ,last_update_date OKL_OPEN_INT_ASST.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
68: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
69: G_MISS_oiav_rec oiav_rec_type;
70: TYPE oiav_tbl_type IS TABLE OF oiav_rec_type
71: INDEX BY BINARY_INTEGER;
64: ,created_by NUMBER := OKC_API.G_MISS_NUM
65: ,creation_date OKL_OPEN_INT_ASST.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
66: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
67: ,last_update_date OKL_OPEN_INT_ASST.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
68: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
69: G_MISS_oiav_rec oiav_rec_type;
70: TYPE oiav_tbl_type IS TABLE OF oiav_rec_type
71: INDEX BY BINARY_INTEGER;
72: TYPE oia_rec_type IS RECORD (
69: G_MISS_oiav_rec oiav_rec_type;
70: TYPE oiav_tbl_type IS TABLE OF oiav_rec_type
71: INDEX BY BINARY_INTEGER;
72: TYPE oia_rec_type IS RECORD (
73: id NUMBER := OKC_API.G_MISS_NUM
74: ,khr_id NUMBER := OKC_API.G_MISS_NUM
75: ,instance_number OKL_OPEN_INT_ASST.INSTANCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
76: ,asset_id NUMBER := OKC_API.G_MISS_NUM
77: ,asset_number OKL_OPEN_INT_ASST.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
70: TYPE oiav_tbl_type IS TABLE OF oiav_rec_type
71: INDEX BY BINARY_INTEGER;
72: TYPE oia_rec_type IS RECORD (
73: id NUMBER := OKC_API.G_MISS_NUM
74: ,khr_id NUMBER := OKC_API.G_MISS_NUM
75: ,instance_number OKL_OPEN_INT_ASST.INSTANCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
76: ,asset_id NUMBER := OKC_API.G_MISS_NUM
77: ,asset_number OKL_OPEN_INT_ASST.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
78: ,description OKL_OPEN_INT_ASST.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
71: INDEX BY BINARY_INTEGER;
72: TYPE oia_rec_type IS RECORD (
73: id NUMBER := OKC_API.G_MISS_NUM
74: ,khr_id NUMBER := OKC_API.G_MISS_NUM
75: ,instance_number OKL_OPEN_INT_ASST.INSTANCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
76: ,asset_id NUMBER := OKC_API.G_MISS_NUM
77: ,asset_number OKL_OPEN_INT_ASST.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
78: ,description OKL_OPEN_INT_ASST.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
79: ,asset_type OKL_OPEN_INT_ASST.ASSET_TYPE%TYPE := OKC_API.G_MISS_CHAR
72: TYPE oia_rec_type IS RECORD (
73: id NUMBER := OKC_API.G_MISS_NUM
74: ,khr_id NUMBER := OKC_API.G_MISS_NUM
75: ,instance_number OKL_OPEN_INT_ASST.INSTANCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
76: ,asset_id NUMBER := OKC_API.G_MISS_NUM
77: ,asset_number OKL_OPEN_INT_ASST.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
78: ,description OKL_OPEN_INT_ASST.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
79: ,asset_type OKL_OPEN_INT_ASST.ASSET_TYPE%TYPE := OKC_API.G_MISS_CHAR
80: ,manufacturer_name OKL_OPEN_INT_ASST.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR
73: id NUMBER := OKC_API.G_MISS_NUM
74: ,khr_id NUMBER := OKC_API.G_MISS_NUM
75: ,instance_number OKL_OPEN_INT_ASST.INSTANCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
76: ,asset_id NUMBER := OKC_API.G_MISS_NUM
77: ,asset_number OKL_OPEN_INT_ASST.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
78: ,description OKL_OPEN_INT_ASST.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
79: ,asset_type OKL_OPEN_INT_ASST.ASSET_TYPE%TYPE := OKC_API.G_MISS_CHAR
80: ,manufacturer_name OKL_OPEN_INT_ASST.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR
81: ,model_number OKL_OPEN_INT_ASST.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
74: ,khr_id NUMBER := OKC_API.G_MISS_NUM
75: ,instance_number OKL_OPEN_INT_ASST.INSTANCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
76: ,asset_id NUMBER := OKC_API.G_MISS_NUM
77: ,asset_number OKL_OPEN_INT_ASST.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
78: ,description OKL_OPEN_INT_ASST.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
79: ,asset_type OKL_OPEN_INT_ASST.ASSET_TYPE%TYPE := OKC_API.G_MISS_CHAR
80: ,manufacturer_name OKL_OPEN_INT_ASST.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR
81: ,model_number OKL_OPEN_INT_ASST.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
82: ,serial_number OKL_OPEN_INT_ASST.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
75: ,instance_number OKL_OPEN_INT_ASST.INSTANCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
76: ,asset_id NUMBER := OKC_API.G_MISS_NUM
77: ,asset_number OKL_OPEN_INT_ASST.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
78: ,description OKL_OPEN_INT_ASST.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
79: ,asset_type OKL_OPEN_INT_ASST.ASSET_TYPE%TYPE := OKC_API.G_MISS_CHAR
80: ,manufacturer_name OKL_OPEN_INT_ASST.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR
81: ,model_number OKL_OPEN_INT_ASST.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
82: ,serial_number OKL_OPEN_INT_ASST.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
83: ,tag_number OKL_OPEN_INT_ASST.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR
76: ,asset_id NUMBER := OKC_API.G_MISS_NUM
77: ,asset_number OKL_OPEN_INT_ASST.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
78: ,description OKL_OPEN_INT_ASST.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
79: ,asset_type OKL_OPEN_INT_ASST.ASSET_TYPE%TYPE := OKC_API.G_MISS_CHAR
80: ,manufacturer_name OKL_OPEN_INT_ASST.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR
81: ,model_number OKL_OPEN_INT_ASST.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
82: ,serial_number OKL_OPEN_INT_ASST.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
83: ,tag_number OKL_OPEN_INT_ASST.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR
84: ,original_cost NUMBER := OKC_API.G_MISS_NUM
77: ,asset_number OKL_OPEN_INT_ASST.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
78: ,description OKL_OPEN_INT_ASST.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
79: ,asset_type OKL_OPEN_INT_ASST.ASSET_TYPE%TYPE := OKC_API.G_MISS_CHAR
80: ,manufacturer_name OKL_OPEN_INT_ASST.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR
81: ,model_number OKL_OPEN_INT_ASST.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
82: ,serial_number OKL_OPEN_INT_ASST.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
83: ,tag_number OKL_OPEN_INT_ASST.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR
84: ,original_cost NUMBER := OKC_API.G_MISS_NUM
85: ,quantity OKL_OPEN_INT_ASST.QUANTITY%TYPE := OKC_API.G_MISS_CHAR
78: ,description OKL_OPEN_INT_ASST.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
79: ,asset_type OKL_OPEN_INT_ASST.ASSET_TYPE%TYPE := OKC_API.G_MISS_CHAR
80: ,manufacturer_name OKL_OPEN_INT_ASST.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR
81: ,model_number OKL_OPEN_INT_ASST.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
82: ,serial_number OKL_OPEN_INT_ASST.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
83: ,tag_number OKL_OPEN_INT_ASST.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR
84: ,original_cost NUMBER := OKC_API.G_MISS_NUM
85: ,quantity OKL_OPEN_INT_ASST.QUANTITY%TYPE := OKC_API.G_MISS_CHAR
86: ,country OKL_OPEN_INT_ASST.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
79: ,asset_type OKL_OPEN_INT_ASST.ASSET_TYPE%TYPE := OKC_API.G_MISS_CHAR
80: ,manufacturer_name OKL_OPEN_INT_ASST.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR
81: ,model_number OKL_OPEN_INT_ASST.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
82: ,serial_number OKL_OPEN_INT_ASST.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
83: ,tag_number OKL_OPEN_INT_ASST.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR
84: ,original_cost NUMBER := OKC_API.G_MISS_NUM
85: ,quantity OKL_OPEN_INT_ASST.QUANTITY%TYPE := OKC_API.G_MISS_CHAR
86: ,country OKL_OPEN_INT_ASST.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
87: ,address1 OKL_OPEN_INT_ASST.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
80: ,manufacturer_name OKL_OPEN_INT_ASST.MANUFACTURER_NAME%TYPE := OKC_API.G_MISS_CHAR
81: ,model_number OKL_OPEN_INT_ASST.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
82: ,serial_number OKL_OPEN_INT_ASST.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
83: ,tag_number OKL_OPEN_INT_ASST.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR
84: ,original_cost NUMBER := OKC_API.G_MISS_NUM
85: ,quantity OKL_OPEN_INT_ASST.QUANTITY%TYPE := OKC_API.G_MISS_CHAR
86: ,country OKL_OPEN_INT_ASST.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
87: ,address1 OKL_OPEN_INT_ASST.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
88: ,address2 OKL_OPEN_INT_ASST.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
81: ,model_number OKL_OPEN_INT_ASST.MODEL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
82: ,serial_number OKL_OPEN_INT_ASST.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
83: ,tag_number OKL_OPEN_INT_ASST.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR
84: ,original_cost NUMBER := OKC_API.G_MISS_NUM
85: ,quantity OKL_OPEN_INT_ASST.QUANTITY%TYPE := OKC_API.G_MISS_CHAR
86: ,country OKL_OPEN_INT_ASST.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
87: ,address1 OKL_OPEN_INT_ASST.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
88: ,address2 OKL_OPEN_INT_ASST.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
89: ,address3 OKL_OPEN_INT_ASST.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
82: ,serial_number OKL_OPEN_INT_ASST.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR
83: ,tag_number OKL_OPEN_INT_ASST.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR
84: ,original_cost NUMBER := OKC_API.G_MISS_NUM
85: ,quantity OKL_OPEN_INT_ASST.QUANTITY%TYPE := OKC_API.G_MISS_CHAR
86: ,country OKL_OPEN_INT_ASST.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
87: ,address1 OKL_OPEN_INT_ASST.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
88: ,address2 OKL_OPEN_INT_ASST.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
89: ,address3 OKL_OPEN_INT_ASST.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
90: ,address4 OKL_OPEN_INT_ASST.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
83: ,tag_number OKL_OPEN_INT_ASST.TAG_NUMBER%TYPE := OKC_API.G_MISS_CHAR
84: ,original_cost NUMBER := OKC_API.G_MISS_NUM
85: ,quantity OKL_OPEN_INT_ASST.QUANTITY%TYPE := OKC_API.G_MISS_CHAR
86: ,country OKL_OPEN_INT_ASST.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
87: ,address1 OKL_OPEN_INT_ASST.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
88: ,address2 OKL_OPEN_INT_ASST.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
89: ,address3 OKL_OPEN_INT_ASST.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
90: ,address4 OKL_OPEN_INT_ASST.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
91: ,city OKL_OPEN_INT_ASST.CITY%TYPE := OKC_API.G_MISS_CHAR
84: ,original_cost NUMBER := OKC_API.G_MISS_NUM
85: ,quantity OKL_OPEN_INT_ASST.QUANTITY%TYPE := OKC_API.G_MISS_CHAR
86: ,country OKL_OPEN_INT_ASST.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
87: ,address1 OKL_OPEN_INT_ASST.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
88: ,address2 OKL_OPEN_INT_ASST.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
89: ,address3 OKL_OPEN_INT_ASST.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
90: ,address4 OKL_OPEN_INT_ASST.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
91: ,city OKL_OPEN_INT_ASST.CITY%TYPE := OKC_API.G_MISS_CHAR
92: ,postal_code OKL_OPEN_INT_ASST.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
85: ,quantity OKL_OPEN_INT_ASST.QUANTITY%TYPE := OKC_API.G_MISS_CHAR
86: ,country OKL_OPEN_INT_ASST.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
87: ,address1 OKL_OPEN_INT_ASST.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
88: ,address2 OKL_OPEN_INT_ASST.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
89: ,address3 OKL_OPEN_INT_ASST.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
90: ,address4 OKL_OPEN_INT_ASST.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
91: ,city OKL_OPEN_INT_ASST.CITY%TYPE := OKC_API.G_MISS_CHAR
92: ,postal_code OKL_OPEN_INT_ASST.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
93: ,state OKL_OPEN_INT_ASST.STATE%TYPE := OKC_API.G_MISS_CHAR
86: ,country OKL_OPEN_INT_ASST.COUNTRY%TYPE := OKC_API.G_MISS_CHAR
87: ,address1 OKL_OPEN_INT_ASST.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
88: ,address2 OKL_OPEN_INT_ASST.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
89: ,address3 OKL_OPEN_INT_ASST.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
90: ,address4 OKL_OPEN_INT_ASST.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
91: ,city OKL_OPEN_INT_ASST.CITY%TYPE := OKC_API.G_MISS_CHAR
92: ,postal_code OKL_OPEN_INT_ASST.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
93: ,state OKL_OPEN_INT_ASST.STATE%TYPE := OKC_API.G_MISS_CHAR
94: ,province OKL_OPEN_INT_ASST.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
87: ,address1 OKL_OPEN_INT_ASST.ADDRESS1%TYPE := OKC_API.G_MISS_CHAR
88: ,address2 OKL_OPEN_INT_ASST.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
89: ,address3 OKL_OPEN_INT_ASST.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
90: ,address4 OKL_OPEN_INT_ASST.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
91: ,city OKL_OPEN_INT_ASST.CITY%TYPE := OKC_API.G_MISS_CHAR
92: ,postal_code OKL_OPEN_INT_ASST.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
93: ,state OKL_OPEN_INT_ASST.STATE%TYPE := OKC_API.G_MISS_CHAR
94: ,province OKL_OPEN_INT_ASST.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
95: ,county OKL_OPEN_INT_ASST.COUNTY%TYPE := OKC_API.G_MISS_CHAR
88: ,address2 OKL_OPEN_INT_ASST.ADDRESS2%TYPE := OKC_API.G_MISS_CHAR
89: ,address3 OKL_OPEN_INT_ASST.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
90: ,address4 OKL_OPEN_INT_ASST.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
91: ,city OKL_OPEN_INT_ASST.CITY%TYPE := OKC_API.G_MISS_CHAR
92: ,postal_code OKL_OPEN_INT_ASST.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
93: ,state OKL_OPEN_INT_ASST.STATE%TYPE := OKC_API.G_MISS_CHAR
94: ,province OKL_OPEN_INT_ASST.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
95: ,county OKL_OPEN_INT_ASST.COUNTY%TYPE := OKC_API.G_MISS_CHAR
96: ,po_box_number OKL_OPEN_INT_ASST.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
89: ,address3 OKL_OPEN_INT_ASST.ADDRESS3%TYPE := OKC_API.G_MISS_CHAR
90: ,address4 OKL_OPEN_INT_ASST.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
91: ,city OKL_OPEN_INT_ASST.CITY%TYPE := OKC_API.G_MISS_CHAR
92: ,postal_code OKL_OPEN_INT_ASST.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
93: ,state OKL_OPEN_INT_ASST.STATE%TYPE := OKC_API.G_MISS_CHAR
94: ,province OKL_OPEN_INT_ASST.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
95: ,county OKL_OPEN_INT_ASST.COUNTY%TYPE := OKC_API.G_MISS_CHAR
96: ,po_box_number OKL_OPEN_INT_ASST.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
97: ,house_number OKL_OPEN_INT_ASST.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
90: ,address4 OKL_OPEN_INT_ASST.ADDRESS4%TYPE := OKC_API.G_MISS_CHAR
91: ,city OKL_OPEN_INT_ASST.CITY%TYPE := OKC_API.G_MISS_CHAR
92: ,postal_code OKL_OPEN_INT_ASST.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
93: ,state OKL_OPEN_INT_ASST.STATE%TYPE := OKC_API.G_MISS_CHAR
94: ,province OKL_OPEN_INT_ASST.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
95: ,county OKL_OPEN_INT_ASST.COUNTY%TYPE := OKC_API.G_MISS_CHAR
96: ,po_box_number OKL_OPEN_INT_ASST.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
97: ,house_number OKL_OPEN_INT_ASST.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
98: ,street_suffix OKL_OPEN_INT_ASST.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
91: ,city OKL_OPEN_INT_ASST.CITY%TYPE := OKC_API.G_MISS_CHAR
92: ,postal_code OKL_OPEN_INT_ASST.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
93: ,state OKL_OPEN_INT_ASST.STATE%TYPE := OKC_API.G_MISS_CHAR
94: ,province OKL_OPEN_INT_ASST.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
95: ,county OKL_OPEN_INT_ASST.COUNTY%TYPE := OKC_API.G_MISS_CHAR
96: ,po_box_number OKL_OPEN_INT_ASST.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
97: ,house_number OKL_OPEN_INT_ASST.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
98: ,street_suffix OKL_OPEN_INT_ASST.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
99: ,apartment_number OKL_OPEN_INT_ASST.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
92: ,postal_code OKL_OPEN_INT_ASST.POSTAL_CODE%TYPE := OKC_API.G_MISS_CHAR
93: ,state OKL_OPEN_INT_ASST.STATE%TYPE := OKC_API.G_MISS_CHAR
94: ,province OKL_OPEN_INT_ASST.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
95: ,county OKL_OPEN_INT_ASST.COUNTY%TYPE := OKC_API.G_MISS_CHAR
96: ,po_box_number OKL_OPEN_INT_ASST.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
97: ,house_number OKL_OPEN_INT_ASST.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
98: ,street_suffix OKL_OPEN_INT_ASST.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
99: ,apartment_number OKL_OPEN_INT_ASST.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
100: ,street OKL_OPEN_INT_ASST.STREET%TYPE := OKC_API.G_MISS_CHAR
93: ,state OKL_OPEN_INT_ASST.STATE%TYPE := OKC_API.G_MISS_CHAR
94: ,province OKL_OPEN_INT_ASST.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
95: ,county OKL_OPEN_INT_ASST.COUNTY%TYPE := OKC_API.G_MISS_CHAR
96: ,po_box_number OKL_OPEN_INT_ASST.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
97: ,house_number OKL_OPEN_INT_ASST.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
98: ,street_suffix OKL_OPEN_INT_ASST.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
99: ,apartment_number OKL_OPEN_INT_ASST.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
100: ,street OKL_OPEN_INT_ASST.STREET%TYPE := OKC_API.G_MISS_CHAR
101: ,rural_route_number OKL_OPEN_INT_ASST.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
94: ,province OKL_OPEN_INT_ASST.PROVINCE%TYPE := OKC_API.G_MISS_CHAR
95: ,county OKL_OPEN_INT_ASST.COUNTY%TYPE := OKC_API.G_MISS_CHAR
96: ,po_box_number OKL_OPEN_INT_ASST.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
97: ,house_number OKL_OPEN_INT_ASST.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
98: ,street_suffix OKL_OPEN_INT_ASST.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
99: ,apartment_number OKL_OPEN_INT_ASST.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
100: ,street OKL_OPEN_INT_ASST.STREET%TYPE := OKC_API.G_MISS_CHAR
101: ,rural_route_number OKL_OPEN_INT_ASST.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
102: ,street_number OKL_OPEN_INT_ASST.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
95: ,county OKL_OPEN_INT_ASST.COUNTY%TYPE := OKC_API.G_MISS_CHAR
96: ,po_box_number OKL_OPEN_INT_ASST.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
97: ,house_number OKL_OPEN_INT_ASST.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
98: ,street_suffix OKL_OPEN_INT_ASST.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
99: ,apartment_number OKL_OPEN_INT_ASST.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
100: ,street OKL_OPEN_INT_ASST.STREET%TYPE := OKC_API.G_MISS_CHAR
101: ,rural_route_number OKL_OPEN_INT_ASST.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
102: ,street_number OKL_OPEN_INT_ASST.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
103: ,building OKL_OPEN_INT_ASST.BUILDING%TYPE := OKC_API.G_MISS_CHAR
96: ,po_box_number OKL_OPEN_INT_ASST.PO_BOX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
97: ,house_number OKL_OPEN_INT_ASST.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
98: ,street_suffix OKL_OPEN_INT_ASST.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
99: ,apartment_number OKL_OPEN_INT_ASST.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
100: ,street OKL_OPEN_INT_ASST.STREET%TYPE := OKC_API.G_MISS_CHAR
101: ,rural_route_number OKL_OPEN_INT_ASST.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
102: ,street_number OKL_OPEN_INT_ASST.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
103: ,building OKL_OPEN_INT_ASST.BUILDING%TYPE := OKC_API.G_MISS_CHAR
104: ,floor OKL_OPEN_INT_ASST.FLOOR%TYPE := OKC_API.G_MISS_CHAR
97: ,house_number OKL_OPEN_INT_ASST.HOUSE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
98: ,street_suffix OKL_OPEN_INT_ASST.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
99: ,apartment_number OKL_OPEN_INT_ASST.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
100: ,street OKL_OPEN_INT_ASST.STREET%TYPE := OKC_API.G_MISS_CHAR
101: ,rural_route_number OKL_OPEN_INT_ASST.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
102: ,street_number OKL_OPEN_INT_ASST.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
103: ,building OKL_OPEN_INT_ASST.BUILDING%TYPE := OKC_API.G_MISS_CHAR
104: ,floor OKL_OPEN_INT_ASST.FLOOR%TYPE := OKC_API.G_MISS_CHAR
105: ,suite OKL_OPEN_INT_ASST.SUITE%TYPE := OKC_API.G_MISS_CHAR
98: ,street_suffix OKL_OPEN_INT_ASST.STREET_SUFFIX%TYPE := OKC_API.G_MISS_CHAR
99: ,apartment_number OKL_OPEN_INT_ASST.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
100: ,street OKL_OPEN_INT_ASST.STREET%TYPE := OKC_API.G_MISS_CHAR
101: ,rural_route_number OKL_OPEN_INT_ASST.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
102: ,street_number OKL_OPEN_INT_ASST.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
103: ,building OKL_OPEN_INT_ASST.BUILDING%TYPE := OKC_API.G_MISS_CHAR
104: ,floor OKL_OPEN_INT_ASST.FLOOR%TYPE := OKC_API.G_MISS_CHAR
105: ,suite OKL_OPEN_INT_ASST.SUITE%TYPE := OKC_API.G_MISS_CHAR
106: ,room OKL_OPEN_INT_ASST.ROOM%TYPE := OKC_API.G_MISS_CHAR
99: ,apartment_number OKL_OPEN_INT_ASST.APARTMENT_NUMBER%TYPE := OKC_API.G_MISS_CHAR
100: ,street OKL_OPEN_INT_ASST.STREET%TYPE := OKC_API.G_MISS_CHAR
101: ,rural_route_number OKL_OPEN_INT_ASST.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
102: ,street_number OKL_OPEN_INT_ASST.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
103: ,building OKL_OPEN_INT_ASST.BUILDING%TYPE := OKC_API.G_MISS_CHAR
104: ,floor OKL_OPEN_INT_ASST.FLOOR%TYPE := OKC_API.G_MISS_CHAR
105: ,suite OKL_OPEN_INT_ASST.SUITE%TYPE := OKC_API.G_MISS_CHAR
106: ,room OKL_OPEN_INT_ASST.ROOM%TYPE := OKC_API.G_MISS_CHAR
107: ,postal_plus4_code OKL_OPEN_INT_ASST.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
100: ,street OKL_OPEN_INT_ASST.STREET%TYPE := OKC_API.G_MISS_CHAR
101: ,rural_route_number OKL_OPEN_INT_ASST.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
102: ,street_number OKL_OPEN_INT_ASST.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
103: ,building OKL_OPEN_INT_ASST.BUILDING%TYPE := OKC_API.G_MISS_CHAR
104: ,floor OKL_OPEN_INT_ASST.FLOOR%TYPE := OKC_API.G_MISS_CHAR
105: ,suite OKL_OPEN_INT_ASST.SUITE%TYPE := OKC_API.G_MISS_CHAR
106: ,room OKL_OPEN_INT_ASST.ROOM%TYPE := OKC_API.G_MISS_CHAR
107: ,postal_plus4_code OKL_OPEN_INT_ASST.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
108: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
101: ,rural_route_number OKL_OPEN_INT_ASST.RURAL_ROUTE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
102: ,street_number OKL_OPEN_INT_ASST.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
103: ,building OKL_OPEN_INT_ASST.BUILDING%TYPE := OKC_API.G_MISS_CHAR
104: ,floor OKL_OPEN_INT_ASST.FLOOR%TYPE := OKC_API.G_MISS_CHAR
105: ,suite OKL_OPEN_INT_ASST.SUITE%TYPE := OKC_API.G_MISS_CHAR
106: ,room OKL_OPEN_INT_ASST.ROOM%TYPE := OKC_API.G_MISS_CHAR
107: ,postal_plus4_code OKL_OPEN_INT_ASST.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
108: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
109: ,org_id NUMBER := OKC_API.G_MISS_NUM
102: ,street_number OKL_OPEN_INT_ASST.STREET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
103: ,building OKL_OPEN_INT_ASST.BUILDING%TYPE := OKC_API.G_MISS_CHAR
104: ,floor OKL_OPEN_INT_ASST.FLOOR%TYPE := OKC_API.G_MISS_CHAR
105: ,suite OKL_OPEN_INT_ASST.SUITE%TYPE := OKC_API.G_MISS_CHAR
106: ,room OKL_OPEN_INT_ASST.ROOM%TYPE := OKC_API.G_MISS_CHAR
107: ,postal_plus4_code OKL_OPEN_INT_ASST.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
108: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
109: ,org_id NUMBER := OKC_API.G_MISS_NUM
110: ,request_id NUMBER := OKC_API.G_MISS_NUM
103: ,building OKL_OPEN_INT_ASST.BUILDING%TYPE := OKC_API.G_MISS_CHAR
104: ,floor OKL_OPEN_INT_ASST.FLOOR%TYPE := OKC_API.G_MISS_CHAR
105: ,suite OKL_OPEN_INT_ASST.SUITE%TYPE := OKC_API.G_MISS_CHAR
106: ,room OKL_OPEN_INT_ASST.ROOM%TYPE := OKC_API.G_MISS_CHAR
107: ,postal_plus4_code OKL_OPEN_INT_ASST.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
108: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
109: ,org_id NUMBER := OKC_API.G_MISS_NUM
110: ,request_id NUMBER := OKC_API.G_MISS_NUM
111: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
104: ,floor OKL_OPEN_INT_ASST.FLOOR%TYPE := OKC_API.G_MISS_CHAR
105: ,suite OKL_OPEN_INT_ASST.SUITE%TYPE := OKC_API.G_MISS_CHAR
106: ,room OKL_OPEN_INT_ASST.ROOM%TYPE := OKC_API.G_MISS_CHAR
107: ,postal_plus4_code OKL_OPEN_INT_ASST.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
108: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
109: ,org_id NUMBER := OKC_API.G_MISS_NUM
110: ,request_id NUMBER := OKC_API.G_MISS_NUM
111: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
112: ,program_id NUMBER := OKC_API.G_MISS_NUM
105: ,suite OKL_OPEN_INT_ASST.SUITE%TYPE := OKC_API.G_MISS_CHAR
106: ,room OKL_OPEN_INT_ASST.ROOM%TYPE := OKC_API.G_MISS_CHAR
107: ,postal_plus4_code OKL_OPEN_INT_ASST.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
108: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
109: ,org_id NUMBER := OKC_API.G_MISS_NUM
110: ,request_id NUMBER := OKC_API.G_MISS_NUM
111: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
112: ,program_id NUMBER := OKC_API.G_MISS_NUM
113: ,program_update_date OKL_OPEN_INT_ASST.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
106: ,room OKL_OPEN_INT_ASST.ROOM%TYPE := OKC_API.G_MISS_CHAR
107: ,postal_plus4_code OKL_OPEN_INT_ASST.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
108: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
109: ,org_id NUMBER := OKC_API.G_MISS_NUM
110: ,request_id NUMBER := OKC_API.G_MISS_NUM
111: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
112: ,program_id NUMBER := OKC_API.G_MISS_NUM
113: ,program_update_date OKL_OPEN_INT_ASST.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
114: ,attribute_category OKL_OPEN_INT_ASST.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
107: ,postal_plus4_code OKL_OPEN_INT_ASST.POSTAL_PLUS4_CODE%TYPE := OKC_API.G_MISS_CHAR
108: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
109: ,org_id NUMBER := OKC_API.G_MISS_NUM
110: ,request_id NUMBER := OKC_API.G_MISS_NUM
111: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
112: ,program_id NUMBER := OKC_API.G_MISS_NUM
113: ,program_update_date OKL_OPEN_INT_ASST.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
114: ,attribute_category OKL_OPEN_INT_ASST.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
115: ,attribute1 OKL_OPEN_INT_ASST.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
108: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
109: ,org_id NUMBER := OKC_API.G_MISS_NUM
110: ,request_id NUMBER := OKC_API.G_MISS_NUM
111: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
112: ,program_id NUMBER := OKC_API.G_MISS_NUM
113: ,program_update_date OKL_OPEN_INT_ASST.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
114: ,attribute_category OKL_OPEN_INT_ASST.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
115: ,attribute1 OKL_OPEN_INT_ASST.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
116: ,attribute2 OKL_OPEN_INT_ASST.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
109: ,org_id NUMBER := OKC_API.G_MISS_NUM
110: ,request_id NUMBER := OKC_API.G_MISS_NUM
111: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
112: ,program_id NUMBER := OKC_API.G_MISS_NUM
113: ,program_update_date OKL_OPEN_INT_ASST.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
114: ,attribute_category OKL_OPEN_INT_ASST.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
115: ,attribute1 OKL_OPEN_INT_ASST.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
116: ,attribute2 OKL_OPEN_INT_ASST.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
117: ,attribute3 OKL_OPEN_INT_ASST.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
110: ,request_id NUMBER := OKC_API.G_MISS_NUM
111: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
112: ,program_id NUMBER := OKC_API.G_MISS_NUM
113: ,program_update_date OKL_OPEN_INT_ASST.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
114: ,attribute_category OKL_OPEN_INT_ASST.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
115: ,attribute1 OKL_OPEN_INT_ASST.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
116: ,attribute2 OKL_OPEN_INT_ASST.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
117: ,attribute3 OKL_OPEN_INT_ASST.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
118: ,attribute4 OKL_OPEN_INT_ASST.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
111: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
112: ,program_id NUMBER := OKC_API.G_MISS_NUM
113: ,program_update_date OKL_OPEN_INT_ASST.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
114: ,attribute_category OKL_OPEN_INT_ASST.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
115: ,attribute1 OKL_OPEN_INT_ASST.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
116: ,attribute2 OKL_OPEN_INT_ASST.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
117: ,attribute3 OKL_OPEN_INT_ASST.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
118: ,attribute4 OKL_OPEN_INT_ASST.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
119: ,attribute5 OKL_OPEN_INT_ASST.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
112: ,program_id NUMBER := OKC_API.G_MISS_NUM
113: ,program_update_date OKL_OPEN_INT_ASST.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
114: ,attribute_category OKL_OPEN_INT_ASST.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
115: ,attribute1 OKL_OPEN_INT_ASST.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
116: ,attribute2 OKL_OPEN_INT_ASST.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
117: ,attribute3 OKL_OPEN_INT_ASST.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
118: ,attribute4 OKL_OPEN_INT_ASST.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
119: ,attribute5 OKL_OPEN_INT_ASST.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
120: ,attribute6 OKL_OPEN_INT_ASST.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
113: ,program_update_date OKL_OPEN_INT_ASST.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
114: ,attribute_category OKL_OPEN_INT_ASST.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
115: ,attribute1 OKL_OPEN_INT_ASST.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
116: ,attribute2 OKL_OPEN_INT_ASST.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
117: ,attribute3 OKL_OPEN_INT_ASST.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
118: ,attribute4 OKL_OPEN_INT_ASST.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
119: ,attribute5 OKL_OPEN_INT_ASST.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
120: ,attribute6 OKL_OPEN_INT_ASST.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
121: ,attribute7 OKL_OPEN_INT_ASST.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
114: ,attribute_category OKL_OPEN_INT_ASST.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
115: ,attribute1 OKL_OPEN_INT_ASST.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
116: ,attribute2 OKL_OPEN_INT_ASST.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
117: ,attribute3 OKL_OPEN_INT_ASST.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
118: ,attribute4 OKL_OPEN_INT_ASST.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
119: ,attribute5 OKL_OPEN_INT_ASST.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
120: ,attribute6 OKL_OPEN_INT_ASST.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
121: ,attribute7 OKL_OPEN_INT_ASST.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
122: ,attribute8 OKL_OPEN_INT_ASST.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
115: ,attribute1 OKL_OPEN_INT_ASST.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
116: ,attribute2 OKL_OPEN_INT_ASST.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
117: ,attribute3 OKL_OPEN_INT_ASST.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
118: ,attribute4 OKL_OPEN_INT_ASST.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
119: ,attribute5 OKL_OPEN_INT_ASST.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
120: ,attribute6 OKL_OPEN_INT_ASST.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
121: ,attribute7 OKL_OPEN_INT_ASST.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
122: ,attribute8 OKL_OPEN_INT_ASST.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
123: ,attribute9 OKL_OPEN_INT_ASST.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
116: ,attribute2 OKL_OPEN_INT_ASST.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
117: ,attribute3 OKL_OPEN_INT_ASST.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
118: ,attribute4 OKL_OPEN_INT_ASST.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
119: ,attribute5 OKL_OPEN_INT_ASST.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
120: ,attribute6 OKL_OPEN_INT_ASST.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
121: ,attribute7 OKL_OPEN_INT_ASST.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
122: ,attribute8 OKL_OPEN_INT_ASST.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
123: ,attribute9 OKL_OPEN_INT_ASST.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
124: ,attribute10 OKL_OPEN_INT_ASST.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
117: ,attribute3 OKL_OPEN_INT_ASST.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
118: ,attribute4 OKL_OPEN_INT_ASST.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
119: ,attribute5 OKL_OPEN_INT_ASST.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
120: ,attribute6 OKL_OPEN_INT_ASST.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
121: ,attribute7 OKL_OPEN_INT_ASST.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
122: ,attribute8 OKL_OPEN_INT_ASST.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
123: ,attribute9 OKL_OPEN_INT_ASST.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
124: ,attribute10 OKL_OPEN_INT_ASST.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
125: ,attribute11 OKL_OPEN_INT_ASST.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
118: ,attribute4 OKL_OPEN_INT_ASST.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
119: ,attribute5 OKL_OPEN_INT_ASST.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
120: ,attribute6 OKL_OPEN_INT_ASST.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
121: ,attribute7 OKL_OPEN_INT_ASST.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
122: ,attribute8 OKL_OPEN_INT_ASST.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
123: ,attribute9 OKL_OPEN_INT_ASST.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
124: ,attribute10 OKL_OPEN_INT_ASST.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
125: ,attribute11 OKL_OPEN_INT_ASST.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
126: ,attribute12 OKL_OPEN_INT_ASST.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
119: ,attribute5 OKL_OPEN_INT_ASST.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
120: ,attribute6 OKL_OPEN_INT_ASST.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
121: ,attribute7 OKL_OPEN_INT_ASST.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
122: ,attribute8 OKL_OPEN_INT_ASST.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
123: ,attribute9 OKL_OPEN_INT_ASST.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
124: ,attribute10 OKL_OPEN_INT_ASST.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
125: ,attribute11 OKL_OPEN_INT_ASST.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
126: ,attribute12 OKL_OPEN_INT_ASST.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
127: ,attribute13 OKL_OPEN_INT_ASST.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
120: ,attribute6 OKL_OPEN_INT_ASST.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
121: ,attribute7 OKL_OPEN_INT_ASST.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
122: ,attribute8 OKL_OPEN_INT_ASST.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
123: ,attribute9 OKL_OPEN_INT_ASST.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
124: ,attribute10 OKL_OPEN_INT_ASST.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
125: ,attribute11 OKL_OPEN_INT_ASST.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
126: ,attribute12 OKL_OPEN_INT_ASST.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
127: ,attribute13 OKL_OPEN_INT_ASST.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
128: ,attribute14 OKL_OPEN_INT_ASST.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
121: ,attribute7 OKL_OPEN_INT_ASST.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
122: ,attribute8 OKL_OPEN_INT_ASST.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
123: ,attribute9 OKL_OPEN_INT_ASST.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
124: ,attribute10 OKL_OPEN_INT_ASST.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
125: ,attribute11 OKL_OPEN_INT_ASST.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
126: ,attribute12 OKL_OPEN_INT_ASST.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
127: ,attribute13 OKL_OPEN_INT_ASST.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
128: ,attribute14 OKL_OPEN_INT_ASST.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
129: ,attribute15 OKL_OPEN_INT_ASST.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
122: ,attribute8 OKL_OPEN_INT_ASST.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
123: ,attribute9 OKL_OPEN_INT_ASST.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
124: ,attribute10 OKL_OPEN_INT_ASST.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
125: ,attribute11 OKL_OPEN_INT_ASST.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
126: ,attribute12 OKL_OPEN_INT_ASST.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
127: ,attribute13 OKL_OPEN_INT_ASST.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
128: ,attribute14 OKL_OPEN_INT_ASST.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
129: ,attribute15 OKL_OPEN_INT_ASST.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
130: ,created_by NUMBER := OKC_API.G_MISS_NUM
123: ,attribute9 OKL_OPEN_INT_ASST.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
124: ,attribute10 OKL_OPEN_INT_ASST.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
125: ,attribute11 OKL_OPEN_INT_ASST.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
126: ,attribute12 OKL_OPEN_INT_ASST.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
127: ,attribute13 OKL_OPEN_INT_ASST.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
128: ,attribute14 OKL_OPEN_INT_ASST.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
129: ,attribute15 OKL_OPEN_INT_ASST.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
130: ,created_by NUMBER := OKC_API.G_MISS_NUM
131: ,creation_date OKL_OPEN_INT_ASST.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
124: ,attribute10 OKL_OPEN_INT_ASST.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
125: ,attribute11 OKL_OPEN_INT_ASST.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
126: ,attribute12 OKL_OPEN_INT_ASST.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
127: ,attribute13 OKL_OPEN_INT_ASST.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
128: ,attribute14 OKL_OPEN_INT_ASST.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
129: ,attribute15 OKL_OPEN_INT_ASST.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
130: ,created_by NUMBER := OKC_API.G_MISS_NUM
131: ,creation_date OKL_OPEN_INT_ASST.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
132: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
125: ,attribute11 OKL_OPEN_INT_ASST.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
126: ,attribute12 OKL_OPEN_INT_ASST.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
127: ,attribute13 OKL_OPEN_INT_ASST.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
128: ,attribute14 OKL_OPEN_INT_ASST.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
129: ,attribute15 OKL_OPEN_INT_ASST.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
130: ,created_by NUMBER := OKC_API.G_MISS_NUM
131: ,creation_date OKL_OPEN_INT_ASST.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
132: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
133: ,last_update_date OKL_OPEN_INT_ASST.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
126: ,attribute12 OKL_OPEN_INT_ASST.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
127: ,attribute13 OKL_OPEN_INT_ASST.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
128: ,attribute14 OKL_OPEN_INT_ASST.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
129: ,attribute15 OKL_OPEN_INT_ASST.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
130: ,created_by NUMBER := OKC_API.G_MISS_NUM
131: ,creation_date OKL_OPEN_INT_ASST.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
132: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
133: ,last_update_date OKL_OPEN_INT_ASST.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
134: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
127: ,attribute13 OKL_OPEN_INT_ASST.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
128: ,attribute14 OKL_OPEN_INT_ASST.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
129: ,attribute15 OKL_OPEN_INT_ASST.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
130: ,created_by NUMBER := OKC_API.G_MISS_NUM
131: ,creation_date OKL_OPEN_INT_ASST.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
132: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
133: ,last_update_date OKL_OPEN_INT_ASST.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
134: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
135: G_MISS_oia_rec oia_rec_type;
128: ,attribute14 OKL_OPEN_INT_ASST.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
129: ,attribute15 OKL_OPEN_INT_ASST.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
130: ,created_by NUMBER := OKC_API.G_MISS_NUM
131: ,creation_date OKL_OPEN_INT_ASST.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
132: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
133: ,last_update_date OKL_OPEN_INT_ASST.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
134: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
135: G_MISS_oia_rec oia_rec_type;
136: TYPE oia_tbl_type IS TABLE OF oia_rec_type
129: ,attribute15 OKL_OPEN_INT_ASST.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
130: ,created_by NUMBER := OKC_API.G_MISS_NUM
131: ,creation_date OKL_OPEN_INT_ASST.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
132: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
133: ,last_update_date OKL_OPEN_INT_ASST.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
134: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
135: G_MISS_oia_rec oia_rec_type;
136: TYPE oia_tbl_type IS TABLE OF oia_rec_type
137: INDEX BY BINARY_INTEGER;
130: ,created_by NUMBER := OKC_API.G_MISS_NUM
131: ,creation_date OKL_OPEN_INT_ASST.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
132: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
133: ,last_update_date OKL_OPEN_INT_ASST.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
134: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
135: G_MISS_oia_rec oia_rec_type;
136: TYPE oia_tbl_type IS TABLE OF oia_rec_type
137: INDEX BY BINARY_INTEGER;
138: ---------------------------------------------------------------------------
137: INDEX BY BINARY_INTEGER;
138: ---------------------------------------------------------------------------
139: -- GLOBAL MESSAGE CONSTANTS
140: ---------------------------------------------------------------------------
141: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
142: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
143: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
144: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
145: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
138: ---------------------------------------------------------------------------
139: -- GLOBAL MESSAGE CONSTANTS
140: ---------------------------------------------------------------------------
141: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
142: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
143: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
144: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
145: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
146: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
139: -- GLOBAL MESSAGE CONSTANTS
140: ---------------------------------------------------------------------------
141: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
142: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
143: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
144: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
145: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
146: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
147: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
140: ---------------------------------------------------------------------------
141: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
142: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
143: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
144: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
145: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
146: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
147: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
148: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
141: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
142: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
143: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
144: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
145: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
146: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
147: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
148: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
149: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
142: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
143: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
144: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
145: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
146: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
147: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
148: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
149: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
150: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
143: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
144: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
145: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
146: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
147: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
148: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
149: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
150: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
151: --G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
144: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
145: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
146: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
147: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
148: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
149: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
150: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
151: --G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
152: --G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
145: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
146: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
147: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
148: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
149: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
150: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
151: --G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
152: --G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
153: --G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
146: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
147: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
148: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
149: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
150: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
151: --G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
152: --G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
153: --G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
154:
160: ---------------------------------------------------------------------------
161: -- GLOBAL VARIABLES
162: ---------------------------------------------------------------------------
163: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_OIA_PVT';
164: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
165: -------------------------------------------------------------------------------
166: --Post change to TAPI code
167: -------------------------------------------------------------------------------
168: --G_EXCEPTION_HALT_VALIDATION EXCEPTION;
179: PROCEDURE change_version;
180: PROCEDURE api_copy;
181: PROCEDURE insert_row(
182: p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
184: x_return_status OUT NOCOPY VARCHAR2,
185: x_msg_count OUT NOCOPY NUMBER,
186: x_msg_data OUT NOCOPY VARCHAR2,
187: p_oiav_rec IN oiav_rec_type,
187: p_oiav_rec IN oiav_rec_type,
188: x_oiav_rec OUT NOCOPY oiav_rec_type);
189: PROCEDURE insert_row(
190: p_api_version IN NUMBER,
191: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
192: x_return_status OUT NOCOPY VARCHAR2,
193: x_msg_count OUT NOCOPY NUMBER,
194: x_msg_data OUT NOCOPY VARCHAR2,
195: p_oiav_tbl IN oiav_tbl_type,
196: x_oiav_tbl OUT NOCOPY oiav_tbl_type,
197: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
198: PROCEDURE insert_row(
199: p_api_version IN NUMBER,
200: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
201: x_return_status OUT NOCOPY VARCHAR2,
202: x_msg_count OUT NOCOPY NUMBER,
203: x_msg_data OUT NOCOPY VARCHAR2,
204: p_oiav_tbl IN oiav_tbl_type,
204: p_oiav_tbl IN oiav_tbl_type,
205: x_oiav_tbl OUT NOCOPY oiav_tbl_type);
206: PROCEDURE lock_row(
207: p_api_version IN NUMBER,
208: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
209: x_return_status OUT NOCOPY VARCHAR2,
210: x_msg_count OUT NOCOPY NUMBER,
211: x_msg_data OUT NOCOPY VARCHAR2,
212: p_oiav_rec IN oiav_rec_type);
211: x_msg_data OUT NOCOPY VARCHAR2,
212: p_oiav_rec IN oiav_rec_type);
213: PROCEDURE lock_row(
214: p_api_version IN NUMBER,
215: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
216: x_return_status OUT NOCOPY VARCHAR2,
217: x_msg_count OUT NOCOPY NUMBER,
218: x_msg_data OUT NOCOPY VARCHAR2,
219: p_oiav_tbl IN oiav_tbl_type,
219: p_oiav_tbl IN oiav_tbl_type,
220: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
221: PROCEDURE lock_row(
222: p_api_version IN NUMBER,
223: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
224: x_return_status OUT NOCOPY VARCHAR2,
225: x_msg_count OUT NOCOPY NUMBER,
226: x_msg_data OUT NOCOPY VARCHAR2,
227: p_oiav_tbl IN oiav_tbl_type);
226: x_msg_data OUT NOCOPY VARCHAR2,
227: p_oiav_tbl IN oiav_tbl_type);
228: PROCEDURE update_row(
229: p_api_version IN NUMBER,
230: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
231: x_return_status OUT NOCOPY VARCHAR2,
232: x_msg_count OUT NOCOPY NUMBER,
233: x_msg_data OUT NOCOPY VARCHAR2,
234: p_oiav_rec IN oiav_rec_type,
234: p_oiav_rec IN oiav_rec_type,
235: x_oiav_rec OUT NOCOPY oiav_rec_type);
236: PROCEDURE update_row(
237: p_api_version IN NUMBER,
238: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
239: x_return_status OUT NOCOPY VARCHAR2,
240: x_msg_count OUT NOCOPY NUMBER,
241: x_msg_data OUT NOCOPY VARCHAR2,
242: p_oiav_tbl IN oiav_tbl_type,
243: x_oiav_tbl OUT NOCOPY oiav_tbl_type,
244: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
245: PROCEDURE update_row(
246: p_api_version IN NUMBER,
247: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
248: x_return_status OUT NOCOPY VARCHAR2,
249: x_msg_count OUT NOCOPY NUMBER,
250: x_msg_data OUT NOCOPY VARCHAR2,
251: p_oiav_tbl IN oiav_tbl_type,
251: p_oiav_tbl IN oiav_tbl_type,
252: x_oiav_tbl OUT NOCOPY oiav_tbl_type);
253: PROCEDURE delete_row(
254: p_api_version IN NUMBER,
255: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
256: x_return_status OUT NOCOPY VARCHAR2,
257: x_msg_count OUT NOCOPY NUMBER,
258: x_msg_data OUT NOCOPY VARCHAR2,
259: p_oiav_rec IN oiav_rec_type);
258: x_msg_data OUT NOCOPY VARCHAR2,
259: p_oiav_rec IN oiav_rec_type);
260: PROCEDURE delete_row(
261: p_api_version IN NUMBER,
262: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
263: x_return_status OUT NOCOPY VARCHAR2,
264: x_msg_count OUT NOCOPY NUMBER,
265: x_msg_data OUT NOCOPY VARCHAR2,
266: p_oiav_tbl IN oiav_tbl_type,
266: p_oiav_tbl IN oiav_tbl_type,
267: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
268: PROCEDURE delete_row(
269: p_api_version IN NUMBER,
270: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
271: x_return_status OUT NOCOPY VARCHAR2,
272: x_msg_count OUT NOCOPY NUMBER,
273: x_msg_data OUT NOCOPY VARCHAR2,
274: p_oiav_tbl IN oiav_tbl_type);
273: x_msg_data OUT NOCOPY VARCHAR2,
274: p_oiav_tbl IN oiav_tbl_type);
275: PROCEDURE validate_row(
276: p_api_version IN NUMBER,
277: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
278: x_return_status OUT NOCOPY VARCHAR2,
279: x_msg_count OUT NOCOPY NUMBER,
280: x_msg_data OUT NOCOPY VARCHAR2,
281: p_oiav_rec IN oiav_rec_type);
280: x_msg_data OUT NOCOPY VARCHAR2,
281: p_oiav_rec IN oiav_rec_type);
282: PROCEDURE validate_row(
283: p_api_version IN NUMBER,
284: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
285: x_return_status OUT NOCOPY VARCHAR2,
286: x_msg_count OUT NOCOPY NUMBER,
287: x_msg_data OUT NOCOPY VARCHAR2,
288: p_oiav_tbl IN oiav_tbl_type,
288: p_oiav_tbl IN oiav_tbl_type,
289: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
290: PROCEDURE validate_row(
291: p_api_version IN NUMBER,
292: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
293: x_return_status OUT NOCOPY VARCHAR2,
294: x_msg_count OUT NOCOPY NUMBER,
295: x_msg_data OUT NOCOPY VARCHAR2,
296: p_oiav_tbl IN oiav_tbl_type);