4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_TRX_SUBSIDY_POOLS_V Record Spec
7: TYPE sixv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,trx_type_code OKL_TRX_SUBSIDY_POOLS_V.TRX_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
11: ,source_type_code OKL_TRX_SUBSIDY_POOLS_V.SOURCE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
12: ,source_object_id NUMBER := OKC_API.G_MISS_NUM
5: ---------------------------------------------------------------------------
6: -- OKL_TRX_SUBSIDY_POOLS_V Record Spec
7: TYPE sixv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,trx_type_code OKL_TRX_SUBSIDY_POOLS_V.TRX_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
11: ,source_type_code OKL_TRX_SUBSIDY_POOLS_V.SOURCE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
12: ,source_object_id NUMBER := OKC_API.G_MISS_NUM
13: ,subsidy_pool_id NUMBER := OKC_API.G_MISS_NUM
6: -- OKL_TRX_SUBSIDY_POOLS_V Record Spec
7: TYPE sixv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,trx_type_code OKL_TRX_SUBSIDY_POOLS_V.TRX_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
11: ,source_type_code OKL_TRX_SUBSIDY_POOLS_V.SOURCE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
12: ,source_object_id NUMBER := OKC_API.G_MISS_NUM
13: ,subsidy_pool_id NUMBER := OKC_API.G_MISS_NUM
14: ,dnz_asset_number OKL_TRX_SUBSIDY_POOLS_V.DNZ_ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
7: TYPE sixv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,trx_type_code OKL_TRX_SUBSIDY_POOLS_V.TRX_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
11: ,source_type_code OKL_TRX_SUBSIDY_POOLS_V.SOURCE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
12: ,source_object_id NUMBER := OKC_API.G_MISS_NUM
13: ,subsidy_pool_id NUMBER := OKC_API.G_MISS_NUM
14: ,dnz_asset_number OKL_TRX_SUBSIDY_POOLS_V.DNZ_ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
15: ,vendor_id NUMBER := OKC_API.G_MISS_NUM
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,trx_type_code OKL_TRX_SUBSIDY_POOLS_V.TRX_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
11: ,source_type_code OKL_TRX_SUBSIDY_POOLS_V.SOURCE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
12: ,source_object_id NUMBER := OKC_API.G_MISS_NUM
13: ,subsidy_pool_id NUMBER := OKC_API.G_MISS_NUM
14: ,dnz_asset_number OKL_TRX_SUBSIDY_POOLS_V.DNZ_ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
15: ,vendor_id NUMBER := OKC_API.G_MISS_NUM
16: ,source_trx_date OKL_TRX_SUBSIDY_POOLS_V.SOURCE_TRX_DATE%TYPE := OKC_API.G_MISS_DATE
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,trx_type_code OKL_TRX_SUBSIDY_POOLS_V.TRX_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
11: ,source_type_code OKL_TRX_SUBSIDY_POOLS_V.SOURCE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
12: ,source_object_id NUMBER := OKC_API.G_MISS_NUM
13: ,subsidy_pool_id NUMBER := OKC_API.G_MISS_NUM
14: ,dnz_asset_number OKL_TRX_SUBSIDY_POOLS_V.DNZ_ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
15: ,vendor_id NUMBER := OKC_API.G_MISS_NUM
16: ,source_trx_date OKL_TRX_SUBSIDY_POOLS_V.SOURCE_TRX_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,trx_date OKL_TRX_SUBSIDY_POOLS_V.TRX_DATE%TYPE := OKC_API.G_MISS_DATE
10: ,trx_type_code OKL_TRX_SUBSIDY_POOLS_V.TRX_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
11: ,source_type_code OKL_TRX_SUBSIDY_POOLS_V.SOURCE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
12: ,source_object_id NUMBER := OKC_API.G_MISS_NUM
13: ,subsidy_pool_id NUMBER := OKC_API.G_MISS_NUM
14: ,dnz_asset_number OKL_TRX_SUBSIDY_POOLS_V.DNZ_ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
15: ,vendor_id NUMBER := OKC_API.G_MISS_NUM
16: ,source_trx_date OKL_TRX_SUBSIDY_POOLS_V.SOURCE_TRX_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,trx_date OKL_TRX_SUBSIDY_POOLS_V.TRX_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,subsidy_id NUMBER := OKC_API.G_MISS_NUM
11: ,source_type_code OKL_TRX_SUBSIDY_POOLS_V.SOURCE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
12: ,source_object_id NUMBER := OKC_API.G_MISS_NUM
13: ,subsidy_pool_id NUMBER := OKC_API.G_MISS_NUM
14: ,dnz_asset_number OKL_TRX_SUBSIDY_POOLS_V.DNZ_ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
15: ,vendor_id NUMBER := OKC_API.G_MISS_NUM
16: ,source_trx_date OKL_TRX_SUBSIDY_POOLS_V.SOURCE_TRX_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,trx_date OKL_TRX_SUBSIDY_POOLS_V.TRX_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,subsidy_id NUMBER := OKC_API.G_MISS_NUM
19: ,trx_reason_code OKL_TRX_SUBSIDY_POOLS_V.TRX_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
12: ,source_object_id NUMBER := OKC_API.G_MISS_NUM
13: ,subsidy_pool_id NUMBER := OKC_API.G_MISS_NUM
14: ,dnz_asset_number OKL_TRX_SUBSIDY_POOLS_V.DNZ_ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
15: ,vendor_id NUMBER := OKC_API.G_MISS_NUM
16: ,source_trx_date OKL_TRX_SUBSIDY_POOLS_V.SOURCE_TRX_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,trx_date OKL_TRX_SUBSIDY_POOLS_V.TRX_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,subsidy_id NUMBER := OKC_API.G_MISS_NUM
19: ,trx_reason_code OKL_TRX_SUBSIDY_POOLS_V.TRX_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
20: ,trx_currency_code OKL_TRX_SUBSIDY_POOLS_V.TRX_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
13: ,subsidy_pool_id NUMBER := OKC_API.G_MISS_NUM
14: ,dnz_asset_number OKL_TRX_SUBSIDY_POOLS_V.DNZ_ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
15: ,vendor_id NUMBER := OKC_API.G_MISS_NUM
16: ,source_trx_date OKL_TRX_SUBSIDY_POOLS_V.SOURCE_TRX_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,trx_date OKL_TRX_SUBSIDY_POOLS_V.TRX_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,subsidy_id NUMBER := OKC_API.G_MISS_NUM
19: ,trx_reason_code OKL_TRX_SUBSIDY_POOLS_V.TRX_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
20: ,trx_currency_code OKL_TRX_SUBSIDY_POOLS_V.TRX_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
21: ,trx_amount NUMBER := OKC_API.G_MISS_NUM
14: ,dnz_asset_number OKL_TRX_SUBSIDY_POOLS_V.DNZ_ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
15: ,vendor_id NUMBER := OKC_API.G_MISS_NUM
16: ,source_trx_date OKL_TRX_SUBSIDY_POOLS_V.SOURCE_TRX_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,trx_date OKL_TRX_SUBSIDY_POOLS_V.TRX_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,subsidy_id NUMBER := OKC_API.G_MISS_NUM
19: ,trx_reason_code OKL_TRX_SUBSIDY_POOLS_V.TRX_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
20: ,trx_currency_code OKL_TRX_SUBSIDY_POOLS_V.TRX_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
21: ,trx_amount NUMBER := OKC_API.G_MISS_NUM
22: ,subsidy_pool_currency_code OKL_TRX_SUBSIDY_POOLS_V.SUBSIDY_POOL_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
15: ,vendor_id NUMBER := OKC_API.G_MISS_NUM
16: ,source_trx_date OKL_TRX_SUBSIDY_POOLS_V.SOURCE_TRX_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,trx_date OKL_TRX_SUBSIDY_POOLS_V.TRX_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,subsidy_id NUMBER := OKC_API.G_MISS_NUM
19: ,trx_reason_code OKL_TRX_SUBSIDY_POOLS_V.TRX_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
20: ,trx_currency_code OKL_TRX_SUBSIDY_POOLS_V.TRX_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
21: ,trx_amount NUMBER := OKC_API.G_MISS_NUM
22: ,subsidy_pool_currency_code OKL_TRX_SUBSIDY_POOLS_V.SUBSIDY_POOL_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
23: ,subsidy_pool_amount NUMBER := OKC_API.G_MISS_NUM
16: ,source_trx_date OKL_TRX_SUBSIDY_POOLS_V.SOURCE_TRX_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,trx_date OKL_TRX_SUBSIDY_POOLS_V.TRX_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,subsidy_id NUMBER := OKC_API.G_MISS_NUM
19: ,trx_reason_code OKL_TRX_SUBSIDY_POOLS_V.TRX_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
20: ,trx_currency_code OKL_TRX_SUBSIDY_POOLS_V.TRX_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
21: ,trx_amount NUMBER := OKC_API.G_MISS_NUM
22: ,subsidy_pool_currency_code OKL_TRX_SUBSIDY_POOLS_V.SUBSIDY_POOL_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
23: ,subsidy_pool_amount NUMBER := OKC_API.G_MISS_NUM
24: ,conversion_rate NUMBER := OKC_API.G_MISS_NUM
17: ,trx_date OKL_TRX_SUBSIDY_POOLS_V.TRX_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,subsidy_id NUMBER := OKC_API.G_MISS_NUM
19: ,trx_reason_code OKL_TRX_SUBSIDY_POOLS_V.TRX_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
20: ,trx_currency_code OKL_TRX_SUBSIDY_POOLS_V.TRX_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
21: ,trx_amount NUMBER := OKC_API.G_MISS_NUM
22: ,subsidy_pool_currency_code OKL_TRX_SUBSIDY_POOLS_V.SUBSIDY_POOL_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
23: ,subsidy_pool_amount NUMBER := OKC_API.G_MISS_NUM
24: ,conversion_rate NUMBER := OKC_API.G_MISS_NUM
25: ,attribute_category OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
18: ,subsidy_id NUMBER := OKC_API.G_MISS_NUM
19: ,trx_reason_code OKL_TRX_SUBSIDY_POOLS_V.TRX_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
20: ,trx_currency_code OKL_TRX_SUBSIDY_POOLS_V.TRX_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
21: ,trx_amount NUMBER := OKC_API.G_MISS_NUM
22: ,subsidy_pool_currency_code OKL_TRX_SUBSIDY_POOLS_V.SUBSIDY_POOL_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
23: ,subsidy_pool_amount NUMBER := OKC_API.G_MISS_NUM
24: ,conversion_rate NUMBER := OKC_API.G_MISS_NUM
25: ,attribute_category OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute1 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
19: ,trx_reason_code OKL_TRX_SUBSIDY_POOLS_V.TRX_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
20: ,trx_currency_code OKL_TRX_SUBSIDY_POOLS_V.TRX_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
21: ,trx_amount NUMBER := OKC_API.G_MISS_NUM
22: ,subsidy_pool_currency_code OKL_TRX_SUBSIDY_POOLS_V.SUBSIDY_POOL_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
23: ,subsidy_pool_amount NUMBER := OKC_API.G_MISS_NUM
24: ,conversion_rate NUMBER := OKC_API.G_MISS_NUM
25: ,attribute_category OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute1 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute2 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
20: ,trx_currency_code OKL_TRX_SUBSIDY_POOLS_V.TRX_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
21: ,trx_amount NUMBER := OKC_API.G_MISS_NUM
22: ,subsidy_pool_currency_code OKL_TRX_SUBSIDY_POOLS_V.SUBSIDY_POOL_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
23: ,subsidy_pool_amount NUMBER := OKC_API.G_MISS_NUM
24: ,conversion_rate NUMBER := OKC_API.G_MISS_NUM
25: ,attribute_category OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute1 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute2 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute3 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
21: ,trx_amount NUMBER := OKC_API.G_MISS_NUM
22: ,subsidy_pool_currency_code OKL_TRX_SUBSIDY_POOLS_V.SUBSIDY_POOL_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
23: ,subsidy_pool_amount NUMBER := OKC_API.G_MISS_NUM
24: ,conversion_rate NUMBER := OKC_API.G_MISS_NUM
25: ,attribute_category OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute1 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute2 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute3 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute4 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
22: ,subsidy_pool_currency_code OKL_TRX_SUBSIDY_POOLS_V.SUBSIDY_POOL_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
23: ,subsidy_pool_amount NUMBER := OKC_API.G_MISS_NUM
24: ,conversion_rate NUMBER := OKC_API.G_MISS_NUM
25: ,attribute_category OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute1 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute2 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute3 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute4 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute5 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
23: ,subsidy_pool_amount NUMBER := OKC_API.G_MISS_NUM
24: ,conversion_rate NUMBER := OKC_API.G_MISS_NUM
25: ,attribute_category OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute1 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute2 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute3 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute4 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute5 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute6 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
24: ,conversion_rate NUMBER := OKC_API.G_MISS_NUM
25: ,attribute_category OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute1 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute2 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute3 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute4 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute5 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute6 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute7 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute_category OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute1 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute2 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute3 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute4 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute5 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute6 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute7 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute8 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute1 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute2 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute3 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute4 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute5 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute6 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute7 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute8 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute9 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute2 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute3 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute4 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute5 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute6 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute7 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute8 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute9 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute10 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute3 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute4 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute5 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute6 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute7 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute8 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute9 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute10 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute11 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute4 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute5 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute6 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute7 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute8 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute9 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute10 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute11 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute12 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute5 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute6 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute7 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute8 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute9 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute10 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute11 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute12 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute13 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute6 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute7 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute8 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute9 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute10 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute11 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute12 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute13 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute14 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute7 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute8 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute9 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute10 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute11 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute12 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute13 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute14 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute15 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute8 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute9 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute10 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute11 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute12 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute13 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute14 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute15 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
41: ,created_by NUMBER := OKC_API.G_MISS_NUM
34: ,attribute9 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute10 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute11 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute12 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute13 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute14 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute15 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
41: ,created_by NUMBER := OKC_API.G_MISS_NUM
42: ,creation_date OKL_TRX_SUBSIDY_POOLS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
35: ,attribute10 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute11 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute12 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute13 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute14 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute15 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
41: ,created_by NUMBER := OKC_API.G_MISS_NUM
42: ,creation_date OKL_TRX_SUBSIDY_POOLS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
43: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
36: ,attribute11 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute12 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute13 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute14 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute15 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
41: ,created_by NUMBER := OKC_API.G_MISS_NUM
42: ,creation_date OKL_TRX_SUBSIDY_POOLS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
43: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
44: ,last_update_date OKL_TRX_SUBSIDY_POOLS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,attribute12 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute13 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute14 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute15 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
41: ,created_by NUMBER := OKC_API.G_MISS_NUM
42: ,creation_date OKL_TRX_SUBSIDY_POOLS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
43: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
44: ,last_update_date OKL_TRX_SUBSIDY_POOLS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
45: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
38: ,attribute13 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute14 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute15 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
41: ,created_by NUMBER := OKC_API.G_MISS_NUM
42: ,creation_date OKL_TRX_SUBSIDY_POOLS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
43: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
44: ,last_update_date OKL_TRX_SUBSIDY_POOLS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
45: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
46: G_MISS_sixv_rec sixv_rec_type;
39: ,attribute14 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute15 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
41: ,created_by NUMBER := OKC_API.G_MISS_NUM
42: ,creation_date OKL_TRX_SUBSIDY_POOLS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
43: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
44: ,last_update_date OKL_TRX_SUBSIDY_POOLS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
45: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
46: G_MISS_sixv_rec sixv_rec_type;
47: TYPE sixv_tbl_type IS TABLE OF sixv_rec_type
40: ,attribute15 OKL_TRX_SUBSIDY_POOLS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
41: ,created_by NUMBER := OKC_API.G_MISS_NUM
42: ,creation_date OKL_TRX_SUBSIDY_POOLS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
43: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
44: ,last_update_date OKL_TRX_SUBSIDY_POOLS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
45: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
46: G_MISS_sixv_rec sixv_rec_type;
47: TYPE sixv_tbl_type IS TABLE OF sixv_rec_type
48: INDEX BY BINARY_INTEGER;
41: ,created_by NUMBER := OKC_API.G_MISS_NUM
42: ,creation_date OKL_TRX_SUBSIDY_POOLS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
43: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
44: ,last_update_date OKL_TRX_SUBSIDY_POOLS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
45: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
46: G_MISS_sixv_rec sixv_rec_type;
47: TYPE sixv_tbl_type IS TABLE OF sixv_rec_type
48: INDEX BY BINARY_INTEGER;
49: -- OKL_TRX_SUBSIDY_POOLS Record Spec
47: TYPE sixv_tbl_type IS TABLE OF sixv_rec_type
48: INDEX BY BINARY_INTEGER;
49: -- OKL_TRX_SUBSIDY_POOLS Record Spec
50: TYPE okl_trx_subsidy_pools_rec_type IS RECORD (
51: id NUMBER := OKC_API.G_MISS_NUM
52: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
53: ,trx_type_code OKL_TRX_SUBSIDY_POOLS.TRX_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
54: ,source_type_code OKL_TRX_SUBSIDY_POOLS.SOURCE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
55: ,source_object_id NUMBER := OKC_API.G_MISS_NUM
48: INDEX BY BINARY_INTEGER;
49: -- OKL_TRX_SUBSIDY_POOLS Record Spec
50: TYPE okl_trx_subsidy_pools_rec_type IS RECORD (
51: id NUMBER := OKC_API.G_MISS_NUM
52: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
53: ,trx_type_code OKL_TRX_SUBSIDY_POOLS.TRX_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
54: ,source_type_code OKL_TRX_SUBSIDY_POOLS.SOURCE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
55: ,source_object_id NUMBER := OKC_API.G_MISS_NUM
56: ,subsidy_pool_id NUMBER := OKC_API.G_MISS_NUM
49: -- OKL_TRX_SUBSIDY_POOLS Record Spec
50: TYPE okl_trx_subsidy_pools_rec_type IS RECORD (
51: id NUMBER := OKC_API.G_MISS_NUM
52: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
53: ,trx_type_code OKL_TRX_SUBSIDY_POOLS.TRX_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
54: ,source_type_code OKL_TRX_SUBSIDY_POOLS.SOURCE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
55: ,source_object_id NUMBER := OKC_API.G_MISS_NUM
56: ,subsidy_pool_id NUMBER := OKC_API.G_MISS_NUM
57: ,dnz_asset_number OKL_TRX_SUBSIDY_POOLS.DNZ_ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
50: TYPE okl_trx_subsidy_pools_rec_type IS RECORD (
51: id NUMBER := OKC_API.G_MISS_NUM
52: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
53: ,trx_type_code OKL_TRX_SUBSIDY_POOLS.TRX_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
54: ,source_type_code OKL_TRX_SUBSIDY_POOLS.SOURCE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
55: ,source_object_id NUMBER := OKC_API.G_MISS_NUM
56: ,subsidy_pool_id NUMBER := OKC_API.G_MISS_NUM
57: ,dnz_asset_number OKL_TRX_SUBSIDY_POOLS.DNZ_ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
58: ,vendor_id NUMBER := OKC_API.G_MISS_NUM
51: id NUMBER := OKC_API.G_MISS_NUM
52: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
53: ,trx_type_code OKL_TRX_SUBSIDY_POOLS.TRX_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
54: ,source_type_code OKL_TRX_SUBSIDY_POOLS.SOURCE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
55: ,source_object_id NUMBER := OKC_API.G_MISS_NUM
56: ,subsidy_pool_id NUMBER := OKC_API.G_MISS_NUM
57: ,dnz_asset_number OKL_TRX_SUBSIDY_POOLS.DNZ_ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
58: ,vendor_id NUMBER := OKC_API.G_MISS_NUM
59: ,source_trx_date OKL_TRX_SUBSIDY_POOLS.SOURCE_TRX_DATE%TYPE := OKC_API.G_MISS_DATE
52: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
53: ,trx_type_code OKL_TRX_SUBSIDY_POOLS.TRX_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
54: ,source_type_code OKL_TRX_SUBSIDY_POOLS.SOURCE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
55: ,source_object_id NUMBER := OKC_API.G_MISS_NUM
56: ,subsidy_pool_id NUMBER := OKC_API.G_MISS_NUM
57: ,dnz_asset_number OKL_TRX_SUBSIDY_POOLS.DNZ_ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
58: ,vendor_id NUMBER := OKC_API.G_MISS_NUM
59: ,source_trx_date OKL_TRX_SUBSIDY_POOLS.SOURCE_TRX_DATE%TYPE := OKC_API.G_MISS_DATE
60: ,trx_date OKL_TRX_SUBSIDY_POOLS.TRX_DATE%TYPE := OKC_API.G_MISS_DATE
53: ,trx_type_code OKL_TRX_SUBSIDY_POOLS.TRX_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
54: ,source_type_code OKL_TRX_SUBSIDY_POOLS.SOURCE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
55: ,source_object_id NUMBER := OKC_API.G_MISS_NUM
56: ,subsidy_pool_id NUMBER := OKC_API.G_MISS_NUM
57: ,dnz_asset_number OKL_TRX_SUBSIDY_POOLS.DNZ_ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
58: ,vendor_id NUMBER := OKC_API.G_MISS_NUM
59: ,source_trx_date OKL_TRX_SUBSIDY_POOLS.SOURCE_TRX_DATE%TYPE := OKC_API.G_MISS_DATE
60: ,trx_date OKL_TRX_SUBSIDY_POOLS.TRX_DATE%TYPE := OKC_API.G_MISS_DATE
61: ,subsidy_id NUMBER := OKC_API.G_MISS_NUM
54: ,source_type_code OKL_TRX_SUBSIDY_POOLS.SOURCE_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
55: ,source_object_id NUMBER := OKC_API.G_MISS_NUM
56: ,subsidy_pool_id NUMBER := OKC_API.G_MISS_NUM
57: ,dnz_asset_number OKL_TRX_SUBSIDY_POOLS.DNZ_ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
58: ,vendor_id NUMBER := OKC_API.G_MISS_NUM
59: ,source_trx_date OKL_TRX_SUBSIDY_POOLS.SOURCE_TRX_DATE%TYPE := OKC_API.G_MISS_DATE
60: ,trx_date OKL_TRX_SUBSIDY_POOLS.TRX_DATE%TYPE := OKC_API.G_MISS_DATE
61: ,subsidy_id NUMBER := OKC_API.G_MISS_NUM
62: ,trx_reason_code OKL_TRX_SUBSIDY_POOLS.TRX_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
55: ,source_object_id NUMBER := OKC_API.G_MISS_NUM
56: ,subsidy_pool_id NUMBER := OKC_API.G_MISS_NUM
57: ,dnz_asset_number OKL_TRX_SUBSIDY_POOLS.DNZ_ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
58: ,vendor_id NUMBER := OKC_API.G_MISS_NUM
59: ,source_trx_date OKL_TRX_SUBSIDY_POOLS.SOURCE_TRX_DATE%TYPE := OKC_API.G_MISS_DATE
60: ,trx_date OKL_TRX_SUBSIDY_POOLS.TRX_DATE%TYPE := OKC_API.G_MISS_DATE
61: ,subsidy_id NUMBER := OKC_API.G_MISS_NUM
62: ,trx_reason_code OKL_TRX_SUBSIDY_POOLS.TRX_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
63: ,trx_currency_code OKL_TRX_SUBSIDY_POOLS.TRX_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
56: ,subsidy_pool_id NUMBER := OKC_API.G_MISS_NUM
57: ,dnz_asset_number OKL_TRX_SUBSIDY_POOLS.DNZ_ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
58: ,vendor_id NUMBER := OKC_API.G_MISS_NUM
59: ,source_trx_date OKL_TRX_SUBSIDY_POOLS.SOURCE_TRX_DATE%TYPE := OKC_API.G_MISS_DATE
60: ,trx_date OKL_TRX_SUBSIDY_POOLS.TRX_DATE%TYPE := OKC_API.G_MISS_DATE
61: ,subsidy_id NUMBER := OKC_API.G_MISS_NUM
62: ,trx_reason_code OKL_TRX_SUBSIDY_POOLS.TRX_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
63: ,trx_currency_code OKL_TRX_SUBSIDY_POOLS.TRX_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
64: ,trx_amount NUMBER := OKC_API.G_MISS_NUM
57: ,dnz_asset_number OKL_TRX_SUBSIDY_POOLS.DNZ_ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
58: ,vendor_id NUMBER := OKC_API.G_MISS_NUM
59: ,source_trx_date OKL_TRX_SUBSIDY_POOLS.SOURCE_TRX_DATE%TYPE := OKC_API.G_MISS_DATE
60: ,trx_date OKL_TRX_SUBSIDY_POOLS.TRX_DATE%TYPE := OKC_API.G_MISS_DATE
61: ,subsidy_id NUMBER := OKC_API.G_MISS_NUM
62: ,trx_reason_code OKL_TRX_SUBSIDY_POOLS.TRX_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
63: ,trx_currency_code OKL_TRX_SUBSIDY_POOLS.TRX_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
64: ,trx_amount NUMBER := OKC_API.G_MISS_NUM
65: ,subsidy_pool_currency_code OKL_TRX_SUBSIDY_POOLS.SUBSIDY_POOL_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
58: ,vendor_id NUMBER := OKC_API.G_MISS_NUM
59: ,source_trx_date OKL_TRX_SUBSIDY_POOLS.SOURCE_TRX_DATE%TYPE := OKC_API.G_MISS_DATE
60: ,trx_date OKL_TRX_SUBSIDY_POOLS.TRX_DATE%TYPE := OKC_API.G_MISS_DATE
61: ,subsidy_id NUMBER := OKC_API.G_MISS_NUM
62: ,trx_reason_code OKL_TRX_SUBSIDY_POOLS.TRX_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
63: ,trx_currency_code OKL_TRX_SUBSIDY_POOLS.TRX_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
64: ,trx_amount NUMBER := OKC_API.G_MISS_NUM
65: ,subsidy_pool_currency_code OKL_TRX_SUBSIDY_POOLS.SUBSIDY_POOL_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
66: ,subsidy_pool_amount NUMBER := OKC_API.G_MISS_NUM
59: ,source_trx_date OKL_TRX_SUBSIDY_POOLS.SOURCE_TRX_DATE%TYPE := OKC_API.G_MISS_DATE
60: ,trx_date OKL_TRX_SUBSIDY_POOLS.TRX_DATE%TYPE := OKC_API.G_MISS_DATE
61: ,subsidy_id NUMBER := OKC_API.G_MISS_NUM
62: ,trx_reason_code OKL_TRX_SUBSIDY_POOLS.TRX_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
63: ,trx_currency_code OKL_TRX_SUBSIDY_POOLS.TRX_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
64: ,trx_amount NUMBER := OKC_API.G_MISS_NUM
65: ,subsidy_pool_currency_code OKL_TRX_SUBSIDY_POOLS.SUBSIDY_POOL_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
66: ,subsidy_pool_amount NUMBER := OKC_API.G_MISS_NUM
67: ,conversion_rate NUMBER := OKC_API.G_MISS_NUM
60: ,trx_date OKL_TRX_SUBSIDY_POOLS.TRX_DATE%TYPE := OKC_API.G_MISS_DATE
61: ,subsidy_id NUMBER := OKC_API.G_MISS_NUM
62: ,trx_reason_code OKL_TRX_SUBSIDY_POOLS.TRX_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
63: ,trx_currency_code OKL_TRX_SUBSIDY_POOLS.TRX_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
64: ,trx_amount NUMBER := OKC_API.G_MISS_NUM
65: ,subsidy_pool_currency_code OKL_TRX_SUBSIDY_POOLS.SUBSIDY_POOL_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
66: ,subsidy_pool_amount NUMBER := OKC_API.G_MISS_NUM
67: ,conversion_rate NUMBER := OKC_API.G_MISS_NUM
68: ,attribute_category OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
61: ,subsidy_id NUMBER := OKC_API.G_MISS_NUM
62: ,trx_reason_code OKL_TRX_SUBSIDY_POOLS.TRX_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
63: ,trx_currency_code OKL_TRX_SUBSIDY_POOLS.TRX_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
64: ,trx_amount NUMBER := OKC_API.G_MISS_NUM
65: ,subsidy_pool_currency_code OKL_TRX_SUBSIDY_POOLS.SUBSIDY_POOL_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
66: ,subsidy_pool_amount NUMBER := OKC_API.G_MISS_NUM
67: ,conversion_rate NUMBER := OKC_API.G_MISS_NUM
68: ,attribute_category OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute1 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
62: ,trx_reason_code OKL_TRX_SUBSIDY_POOLS.TRX_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
63: ,trx_currency_code OKL_TRX_SUBSIDY_POOLS.TRX_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
64: ,trx_amount NUMBER := OKC_API.G_MISS_NUM
65: ,subsidy_pool_currency_code OKL_TRX_SUBSIDY_POOLS.SUBSIDY_POOL_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
66: ,subsidy_pool_amount NUMBER := OKC_API.G_MISS_NUM
67: ,conversion_rate NUMBER := OKC_API.G_MISS_NUM
68: ,attribute_category OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute1 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute2 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
63: ,trx_currency_code OKL_TRX_SUBSIDY_POOLS.TRX_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
64: ,trx_amount NUMBER := OKC_API.G_MISS_NUM
65: ,subsidy_pool_currency_code OKL_TRX_SUBSIDY_POOLS.SUBSIDY_POOL_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
66: ,subsidy_pool_amount NUMBER := OKC_API.G_MISS_NUM
67: ,conversion_rate NUMBER := OKC_API.G_MISS_NUM
68: ,attribute_category OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute1 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute2 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute3 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
64: ,trx_amount NUMBER := OKC_API.G_MISS_NUM
65: ,subsidy_pool_currency_code OKL_TRX_SUBSIDY_POOLS.SUBSIDY_POOL_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
66: ,subsidy_pool_amount NUMBER := OKC_API.G_MISS_NUM
67: ,conversion_rate NUMBER := OKC_API.G_MISS_NUM
68: ,attribute_category OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute1 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute2 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute3 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute4 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
65: ,subsidy_pool_currency_code OKL_TRX_SUBSIDY_POOLS.SUBSIDY_POOL_CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
66: ,subsidy_pool_amount NUMBER := OKC_API.G_MISS_NUM
67: ,conversion_rate NUMBER := OKC_API.G_MISS_NUM
68: ,attribute_category OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute1 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute2 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute3 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute4 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute5 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
66: ,subsidy_pool_amount NUMBER := OKC_API.G_MISS_NUM
67: ,conversion_rate NUMBER := OKC_API.G_MISS_NUM
68: ,attribute_category OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute1 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute2 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute3 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute4 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute5 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute6 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
67: ,conversion_rate NUMBER := OKC_API.G_MISS_NUM
68: ,attribute_category OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute1 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute2 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute3 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute4 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute5 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute6 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute7 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute_category OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute1 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute2 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute3 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute4 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute5 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute6 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute7 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute8 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute1 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute2 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute3 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute4 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute5 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute6 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute7 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute8 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
77: ,attribute9 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute2 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute3 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute4 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute5 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute6 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute7 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute8 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
77: ,attribute9 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
78: ,attribute10 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute3 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute4 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute5 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute6 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute7 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute8 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
77: ,attribute9 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
78: ,attribute10 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
79: ,attribute11 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
72: ,attribute4 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute5 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute6 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute7 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute8 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
77: ,attribute9 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
78: ,attribute10 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
79: ,attribute11 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
80: ,attribute12 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
73: ,attribute5 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute6 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute7 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute8 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
77: ,attribute9 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
78: ,attribute10 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
79: ,attribute11 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
80: ,attribute12 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
81: ,attribute13 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
74: ,attribute6 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute7 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute8 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
77: ,attribute9 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
78: ,attribute10 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
79: ,attribute11 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
80: ,attribute12 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
81: ,attribute13 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
82: ,attribute14 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
75: ,attribute7 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute8 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
77: ,attribute9 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
78: ,attribute10 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
79: ,attribute11 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
80: ,attribute12 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
81: ,attribute13 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
82: ,attribute14 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
83: ,attribute15 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
76: ,attribute8 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
77: ,attribute9 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
78: ,attribute10 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
79: ,attribute11 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
80: ,attribute12 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
81: ,attribute13 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
82: ,attribute14 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
83: ,attribute15 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
84: ,created_by NUMBER := OKC_API.G_MISS_NUM
77: ,attribute9 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
78: ,attribute10 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
79: ,attribute11 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
80: ,attribute12 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
81: ,attribute13 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
82: ,attribute14 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
83: ,attribute15 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
84: ,created_by NUMBER := OKC_API.G_MISS_NUM
85: ,creation_date OKL_TRX_SUBSIDY_POOLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
78: ,attribute10 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
79: ,attribute11 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
80: ,attribute12 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
81: ,attribute13 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
82: ,attribute14 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
83: ,attribute15 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
84: ,created_by NUMBER := OKC_API.G_MISS_NUM
85: ,creation_date OKL_TRX_SUBSIDY_POOLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
86: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
79: ,attribute11 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
80: ,attribute12 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
81: ,attribute13 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
82: ,attribute14 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
83: ,attribute15 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
84: ,created_by NUMBER := OKC_API.G_MISS_NUM
85: ,creation_date OKL_TRX_SUBSIDY_POOLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
86: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
87: ,last_update_date OKL_TRX_SUBSIDY_POOLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
80: ,attribute12 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
81: ,attribute13 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
82: ,attribute14 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
83: ,attribute15 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
84: ,created_by NUMBER := OKC_API.G_MISS_NUM
85: ,creation_date OKL_TRX_SUBSIDY_POOLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
86: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
87: ,last_update_date OKL_TRX_SUBSIDY_POOLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
88: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
81: ,attribute13 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
82: ,attribute14 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
83: ,attribute15 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
84: ,created_by NUMBER := OKC_API.G_MISS_NUM
85: ,creation_date OKL_TRX_SUBSIDY_POOLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
86: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
87: ,last_update_date OKL_TRX_SUBSIDY_POOLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
88: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
89: GMissOklTrxSubsidyPoolsRec okl_trx_subsidy_pools_rec_type;
82: ,attribute14 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
83: ,attribute15 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
84: ,created_by NUMBER := OKC_API.G_MISS_NUM
85: ,creation_date OKL_TRX_SUBSIDY_POOLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
86: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
87: ,last_update_date OKL_TRX_SUBSIDY_POOLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
88: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
89: GMissOklTrxSubsidyPoolsRec okl_trx_subsidy_pools_rec_type;
90: TYPE okl_trx_subsidy_pools_tbl_type IS TABLE OF okl_trx_subsidy_pools_rec_type
83: ,attribute15 OKL_TRX_SUBSIDY_POOLS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
84: ,created_by NUMBER := OKC_API.G_MISS_NUM
85: ,creation_date OKL_TRX_SUBSIDY_POOLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
86: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
87: ,last_update_date OKL_TRX_SUBSIDY_POOLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
88: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
89: GMissOklTrxSubsidyPoolsRec okl_trx_subsidy_pools_rec_type;
90: TYPE okl_trx_subsidy_pools_tbl_type IS TABLE OF okl_trx_subsidy_pools_rec_type
91: INDEX BY BINARY_INTEGER;
84: ,created_by NUMBER := OKC_API.G_MISS_NUM
85: ,creation_date OKL_TRX_SUBSIDY_POOLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
86: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
87: ,last_update_date OKL_TRX_SUBSIDY_POOLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
88: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
89: GMissOklTrxSubsidyPoolsRec okl_trx_subsidy_pools_rec_type;
90: TYPE okl_trx_subsidy_pools_tbl_type IS TABLE OF okl_trx_subsidy_pools_rec_type
91: INDEX BY BINARY_INTEGER;
92: ---------------------------------------------------------------------------
91: INDEX BY BINARY_INTEGER;
92: ---------------------------------------------------------------------------
93: -- GLOBAL MESSAGE CONSTANTS
94: ---------------------------------------------------------------------------
95: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
96: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
97: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
98: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
99: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
92: ---------------------------------------------------------------------------
93: -- GLOBAL MESSAGE CONSTANTS
94: ---------------------------------------------------------------------------
95: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
96: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
97: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
98: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
99: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
100: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
93: -- GLOBAL MESSAGE CONSTANTS
94: ---------------------------------------------------------------------------
95: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
96: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
97: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
98: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
99: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
100: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
101: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
94: ---------------------------------------------------------------------------
95: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
96: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
97: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
98: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
99: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
100: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
101: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
102: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
95: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
96: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
97: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
98: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
99: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
100: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
101: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
102: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
103: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
96: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
97: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
98: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
99: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
100: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
101: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
102: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
103: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
104: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
97: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
98: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
99: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
100: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
101: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
102: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
103: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
104: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
105: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
98: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
99: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
100: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
101: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
102: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
103: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
104: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
105: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
106: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
99: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
100: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
101: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
102: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
103: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
104: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
105: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
106: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
107: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
100: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
101: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
102: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
103: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
104: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
105: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
106: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
107: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
108:
114: ---------------------------------------------------------------------------
115: -- GLOBAL VARIABLES
116: ---------------------------------------------------------------------------
117: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SIX_PVT';
118: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
119: ---------------------------------------------------------------------------
120: -- Procedures and Functions
121: ---------------------------------------------------------------------------
122:
124: PROCEDURE change_version;
125: PROCEDURE api_copy;
126: PROCEDURE insert_row(
127: p_api_version IN NUMBER,
128: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
129: x_return_status OUT NOCOPY VARCHAR2,
130: x_msg_count OUT NOCOPY NUMBER,
131: x_msg_data OUT NOCOPY VARCHAR2,
132: p_sixv_rec IN sixv_rec_type,
132: p_sixv_rec IN sixv_rec_type,
133: x_sixv_rec OUT NOCOPY sixv_rec_type);
134: PROCEDURE insert_row(
135: p_api_version IN NUMBER,
136: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
137: x_return_status OUT NOCOPY VARCHAR2,
138: x_msg_count OUT NOCOPY NUMBER,
139: x_msg_data OUT NOCOPY VARCHAR2,
140: p_sixv_tbl IN sixv_tbl_type,
138: x_msg_count OUT NOCOPY NUMBER,
139: x_msg_data OUT NOCOPY VARCHAR2,
140: p_sixv_tbl IN sixv_tbl_type,
141: x_sixv_tbl OUT NOCOPY sixv_tbl_type,
142: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
143: PROCEDURE insert_row(
144: p_api_version IN NUMBER,
145: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
146: x_return_status OUT NOCOPY VARCHAR2,
141: x_sixv_tbl OUT NOCOPY sixv_tbl_type,
142: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
143: PROCEDURE insert_row(
144: p_api_version IN NUMBER,
145: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
146: x_return_status OUT NOCOPY VARCHAR2,
147: x_msg_count OUT NOCOPY NUMBER,
148: x_msg_data OUT NOCOPY VARCHAR2,
149: p_sixv_tbl IN sixv_tbl_type,
149: p_sixv_tbl IN sixv_tbl_type,
150: x_sixv_tbl OUT NOCOPY sixv_tbl_type);
151: PROCEDURE lock_row(
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2,
157: p_sixv_rec IN sixv_rec_type);
156: x_msg_data OUT NOCOPY VARCHAR2,
157: p_sixv_rec IN sixv_rec_type);
158: PROCEDURE lock_row(
159: p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
161: x_return_status OUT NOCOPY VARCHAR2,
162: x_msg_count OUT NOCOPY NUMBER,
163: x_msg_data OUT NOCOPY VARCHAR2,
164: p_sixv_tbl IN sixv_tbl_type,
161: x_return_status OUT NOCOPY VARCHAR2,
162: x_msg_count OUT NOCOPY NUMBER,
163: x_msg_data OUT NOCOPY VARCHAR2,
164: p_sixv_tbl IN sixv_tbl_type,
165: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
166: PROCEDURE lock_row(
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
169: x_return_status OUT NOCOPY VARCHAR2,
164: p_sixv_tbl IN sixv_tbl_type,
165: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
166: PROCEDURE lock_row(
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
169: x_return_status OUT NOCOPY VARCHAR2,
170: x_msg_count OUT NOCOPY NUMBER,
171: x_msg_data OUT NOCOPY VARCHAR2,
172: p_sixv_tbl IN sixv_tbl_type);
171: x_msg_data OUT NOCOPY VARCHAR2,
172: p_sixv_tbl IN sixv_tbl_type);
173: PROCEDURE update_row(
174: p_api_version IN NUMBER,
175: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
176: x_return_status OUT NOCOPY VARCHAR2,
177: x_msg_count OUT NOCOPY NUMBER,
178: x_msg_data OUT NOCOPY VARCHAR2,
179: p_sixv_rec IN sixv_rec_type,
179: p_sixv_rec IN sixv_rec_type,
180: x_sixv_rec OUT NOCOPY sixv_rec_type);
181: PROCEDURE update_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_sixv_tbl IN sixv_tbl_type,
185: x_msg_count OUT NOCOPY NUMBER,
186: x_msg_data OUT NOCOPY VARCHAR2,
187: p_sixv_tbl IN sixv_tbl_type,
188: x_sixv_tbl OUT NOCOPY sixv_tbl_type,
189: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
190: PROCEDURE update_row(
191: p_api_version IN NUMBER,
192: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
193: x_return_status OUT NOCOPY VARCHAR2,
188: x_sixv_tbl OUT NOCOPY sixv_tbl_type,
189: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
190: PROCEDURE update_row(
191: p_api_version IN NUMBER,
192: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
193: x_return_status OUT NOCOPY VARCHAR2,
194: x_msg_count OUT NOCOPY NUMBER,
195: x_msg_data OUT NOCOPY VARCHAR2,
196: p_sixv_tbl IN sixv_tbl_type,
196: p_sixv_tbl IN sixv_tbl_type,
197: x_sixv_tbl OUT NOCOPY sixv_tbl_type);
198: PROCEDURE delete_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_sixv_rec IN sixv_rec_type);
203: x_msg_data OUT NOCOPY VARCHAR2,
204: p_sixv_rec IN sixv_rec_type);
205: PROCEDURE delete_row(
206: p_api_version IN NUMBER,
207: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
208: x_return_status OUT NOCOPY VARCHAR2,
209: x_msg_count OUT NOCOPY NUMBER,
210: x_msg_data OUT NOCOPY VARCHAR2,
211: p_sixv_tbl IN sixv_tbl_type,
208: x_return_status OUT NOCOPY VARCHAR2,
209: x_msg_count OUT NOCOPY NUMBER,
210: x_msg_data OUT NOCOPY VARCHAR2,
211: p_sixv_tbl IN sixv_tbl_type,
212: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
213: PROCEDURE delete_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,
211: p_sixv_tbl IN sixv_tbl_type,
212: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
213: PROCEDURE delete_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_sixv_tbl IN sixv_tbl_type);
218: x_msg_data OUT NOCOPY VARCHAR2,
219: p_sixv_tbl IN sixv_tbl_type);
220: PROCEDURE validate_row(
221: p_api_version IN NUMBER,
222: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
223: x_return_status OUT NOCOPY VARCHAR2,
224: x_msg_count OUT NOCOPY NUMBER,
225: x_msg_data OUT NOCOPY VARCHAR2,
226: p_sixv_rec IN sixv_rec_type);
225: x_msg_data OUT NOCOPY VARCHAR2,
226: p_sixv_rec IN sixv_rec_type);
227: PROCEDURE validate_row(
228: p_api_version IN NUMBER,
229: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
230: x_return_status OUT NOCOPY VARCHAR2,
231: x_msg_count OUT NOCOPY NUMBER,
232: x_msg_data OUT NOCOPY VARCHAR2,
233: p_sixv_tbl IN sixv_tbl_type,
230: x_return_status OUT NOCOPY VARCHAR2,
231: x_msg_count OUT NOCOPY NUMBER,
232: x_msg_data OUT NOCOPY VARCHAR2,
233: p_sixv_tbl IN sixv_tbl_type,
234: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
235: PROCEDURE validate_row(
236: p_api_version IN NUMBER,
237: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
238: x_return_status OUT NOCOPY VARCHAR2,
233: p_sixv_tbl IN sixv_tbl_type,
234: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
235: PROCEDURE validate_row(
236: p_api_version IN NUMBER,
237: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
238: x_return_status OUT NOCOPY VARCHAR2,
239: x_msg_count OUT NOCOPY NUMBER,
240: x_msg_data OUT NOCOPY VARCHAR2,
241: p_sixv_tbl IN sixv_tbl_type);