2: /* $Header: OKLSSIPS.pls 120.1 2005/10/30 03:18:06 appldev noship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_SUBSIDY_POOLS_V Record Spec
7: TYPE sipv_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,sfwt_flag OKL_SUBSIDY_POOLS_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR
6: -- OKL_SUBSIDY_POOLS_V Record Spec
7: TYPE sipv_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,sfwt_flag OKL_SUBSIDY_POOLS_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR
11: ,pool_type_code OKL_SUBSIDY_POOLS_V.POOL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
12: ,subsidy_pool_name OKL_SUBSIDY_POOLS_V.SUBSIDY_POOL_NAME%TYPE := OKL_API.G_MISS_CHAR
13: ,short_description OKL_SUBSIDY_POOLS_V.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
14: ,description OKL_SUBSIDY_POOLS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
7: TYPE sipv_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,sfwt_flag OKL_SUBSIDY_POOLS_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR
11: ,pool_type_code OKL_SUBSIDY_POOLS_V.POOL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
12: ,subsidy_pool_name OKL_SUBSIDY_POOLS_V.SUBSIDY_POOL_NAME%TYPE := OKL_API.G_MISS_CHAR
13: ,short_description OKL_SUBSIDY_POOLS_V.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
14: ,description OKL_SUBSIDY_POOLS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
15: ,effective_from_date OKL_SUBSIDY_POOLS_V.EFFECTIVE_FROM_DATE%TYPE := OKL_API.G_MISS_DATE
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,sfwt_flag OKL_SUBSIDY_POOLS_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR
11: ,pool_type_code OKL_SUBSIDY_POOLS_V.POOL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
12: ,subsidy_pool_name OKL_SUBSIDY_POOLS_V.SUBSIDY_POOL_NAME%TYPE := OKL_API.G_MISS_CHAR
13: ,short_description OKL_SUBSIDY_POOLS_V.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
14: ,description OKL_SUBSIDY_POOLS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
15: ,effective_from_date OKL_SUBSIDY_POOLS_V.EFFECTIVE_FROM_DATE%TYPE := OKL_API.G_MISS_DATE
16: ,effective_to_date OKL_SUBSIDY_POOLS_V.EFFECTIVE_TO_DATE%TYPE := OKL_API.G_MISS_DATE
9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
10: ,sfwt_flag OKL_SUBSIDY_POOLS_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR
11: ,pool_type_code OKL_SUBSIDY_POOLS_V.POOL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
12: ,subsidy_pool_name OKL_SUBSIDY_POOLS_V.SUBSIDY_POOL_NAME%TYPE := OKL_API.G_MISS_CHAR
13: ,short_description OKL_SUBSIDY_POOLS_V.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
14: ,description OKL_SUBSIDY_POOLS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
15: ,effective_from_date OKL_SUBSIDY_POOLS_V.EFFECTIVE_FROM_DATE%TYPE := OKL_API.G_MISS_DATE
16: ,effective_to_date OKL_SUBSIDY_POOLS_V.EFFECTIVE_TO_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,currency_code OKL_SUBSIDY_POOLS_V.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
10: ,sfwt_flag OKL_SUBSIDY_POOLS_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR
11: ,pool_type_code OKL_SUBSIDY_POOLS_V.POOL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
12: ,subsidy_pool_name OKL_SUBSIDY_POOLS_V.SUBSIDY_POOL_NAME%TYPE := OKL_API.G_MISS_CHAR
13: ,short_description OKL_SUBSIDY_POOLS_V.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
14: ,description OKL_SUBSIDY_POOLS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
15: ,effective_from_date OKL_SUBSIDY_POOLS_V.EFFECTIVE_FROM_DATE%TYPE := OKL_API.G_MISS_DATE
16: ,effective_to_date OKL_SUBSIDY_POOLS_V.EFFECTIVE_TO_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,currency_code OKL_SUBSIDY_POOLS_V.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
18: ,currency_conversion_type OKL_SUBSIDY_POOLS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
11: ,pool_type_code OKL_SUBSIDY_POOLS_V.POOL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
12: ,subsidy_pool_name OKL_SUBSIDY_POOLS_V.SUBSIDY_POOL_NAME%TYPE := OKL_API.G_MISS_CHAR
13: ,short_description OKL_SUBSIDY_POOLS_V.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
14: ,description OKL_SUBSIDY_POOLS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
15: ,effective_from_date OKL_SUBSIDY_POOLS_V.EFFECTIVE_FROM_DATE%TYPE := OKL_API.G_MISS_DATE
16: ,effective_to_date OKL_SUBSIDY_POOLS_V.EFFECTIVE_TO_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,currency_code OKL_SUBSIDY_POOLS_V.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
18: ,currency_conversion_type OKL_SUBSIDY_POOLS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
19: ,decision_status_code OKL_SUBSIDY_POOLS_V.DECISION_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
12: ,subsidy_pool_name OKL_SUBSIDY_POOLS_V.SUBSIDY_POOL_NAME%TYPE := OKL_API.G_MISS_CHAR
13: ,short_description OKL_SUBSIDY_POOLS_V.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
14: ,description OKL_SUBSIDY_POOLS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
15: ,effective_from_date OKL_SUBSIDY_POOLS_V.EFFECTIVE_FROM_DATE%TYPE := OKL_API.G_MISS_DATE
16: ,effective_to_date OKL_SUBSIDY_POOLS_V.EFFECTIVE_TO_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,currency_code OKL_SUBSIDY_POOLS_V.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
18: ,currency_conversion_type OKL_SUBSIDY_POOLS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
19: ,decision_status_code OKL_SUBSIDY_POOLS_V.DECISION_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
20: ,subsidy_pool_id NUMBER := OKL_API.G_MISS_NUM
13: ,short_description OKL_SUBSIDY_POOLS_V.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
14: ,description OKL_SUBSIDY_POOLS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
15: ,effective_from_date OKL_SUBSIDY_POOLS_V.EFFECTIVE_FROM_DATE%TYPE := OKL_API.G_MISS_DATE
16: ,effective_to_date OKL_SUBSIDY_POOLS_V.EFFECTIVE_TO_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,currency_code OKL_SUBSIDY_POOLS_V.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
18: ,currency_conversion_type OKL_SUBSIDY_POOLS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
19: ,decision_status_code OKL_SUBSIDY_POOLS_V.DECISION_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
20: ,subsidy_pool_id NUMBER := OKL_API.G_MISS_NUM
21: ,reporting_pool_limit NUMBER := OKL_API.G_MISS_NUM
14: ,description OKL_SUBSIDY_POOLS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
15: ,effective_from_date OKL_SUBSIDY_POOLS_V.EFFECTIVE_FROM_DATE%TYPE := OKL_API.G_MISS_DATE
16: ,effective_to_date OKL_SUBSIDY_POOLS_V.EFFECTIVE_TO_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,currency_code OKL_SUBSIDY_POOLS_V.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
18: ,currency_conversion_type OKL_SUBSIDY_POOLS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
19: ,decision_status_code OKL_SUBSIDY_POOLS_V.DECISION_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
20: ,subsidy_pool_id NUMBER := OKL_API.G_MISS_NUM
21: ,reporting_pool_limit NUMBER := OKL_API.G_MISS_NUM
22: ,total_budgets NUMBER := OKL_API.G_MISS_NUM
15: ,effective_from_date OKL_SUBSIDY_POOLS_V.EFFECTIVE_FROM_DATE%TYPE := OKL_API.G_MISS_DATE
16: ,effective_to_date OKL_SUBSIDY_POOLS_V.EFFECTIVE_TO_DATE%TYPE := OKL_API.G_MISS_DATE
17: ,currency_code OKL_SUBSIDY_POOLS_V.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
18: ,currency_conversion_type OKL_SUBSIDY_POOLS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
19: ,decision_status_code OKL_SUBSIDY_POOLS_V.DECISION_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
20: ,subsidy_pool_id NUMBER := OKL_API.G_MISS_NUM
21: ,reporting_pool_limit NUMBER := OKL_API.G_MISS_NUM
22: ,total_budgets NUMBER := OKL_API.G_MISS_NUM
23: ,total_subsidy_amount NUMBER := OKL_API.G_MISS_NUM
20: ,subsidy_pool_id NUMBER := OKL_API.G_MISS_NUM
21: ,reporting_pool_limit NUMBER := OKL_API.G_MISS_NUM
22: ,total_budgets NUMBER := OKL_API.G_MISS_NUM
23: ,total_subsidy_amount NUMBER := OKL_API.G_MISS_NUM
24: ,decision_date OKL_SUBSIDY_POOLS_V.DECISION_DATE%TYPE := OKL_API.G_MISS_DATE
25: ,attribute_category OKL_SUBSIDY_POOLS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute1 OKL_SUBSIDY_POOLS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute2 OKL_SUBSIDY_POOLS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute3 OKL_SUBSIDY_POOLS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
21: ,reporting_pool_limit NUMBER := OKL_API.G_MISS_NUM
22: ,total_budgets NUMBER := OKL_API.G_MISS_NUM
23: ,total_subsidy_amount NUMBER := OKL_API.G_MISS_NUM
24: ,decision_date OKL_SUBSIDY_POOLS_V.DECISION_DATE%TYPE := OKL_API.G_MISS_DATE
25: ,attribute_category OKL_SUBSIDY_POOLS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute1 OKL_SUBSIDY_POOLS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute2 OKL_SUBSIDY_POOLS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute3 OKL_SUBSIDY_POOLS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute4 OKL_SUBSIDY_POOLS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
22: ,total_budgets NUMBER := OKL_API.G_MISS_NUM
23: ,total_subsidy_amount NUMBER := OKL_API.G_MISS_NUM
24: ,decision_date OKL_SUBSIDY_POOLS_V.DECISION_DATE%TYPE := OKL_API.G_MISS_DATE
25: ,attribute_category OKL_SUBSIDY_POOLS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute1 OKL_SUBSIDY_POOLS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute2 OKL_SUBSIDY_POOLS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute3 OKL_SUBSIDY_POOLS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute4 OKL_SUBSIDY_POOLS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute5 OKL_SUBSIDY_POOLS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
23: ,total_subsidy_amount NUMBER := OKL_API.G_MISS_NUM
24: ,decision_date OKL_SUBSIDY_POOLS_V.DECISION_DATE%TYPE := OKL_API.G_MISS_DATE
25: ,attribute_category OKL_SUBSIDY_POOLS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute1 OKL_SUBSIDY_POOLS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute2 OKL_SUBSIDY_POOLS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute3 OKL_SUBSIDY_POOLS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute4 OKL_SUBSIDY_POOLS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute5 OKL_SUBSIDY_POOLS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute6 OKL_SUBSIDY_POOLS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
24: ,decision_date OKL_SUBSIDY_POOLS_V.DECISION_DATE%TYPE := OKL_API.G_MISS_DATE
25: ,attribute_category OKL_SUBSIDY_POOLS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute1 OKL_SUBSIDY_POOLS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute2 OKL_SUBSIDY_POOLS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute3 OKL_SUBSIDY_POOLS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute4 OKL_SUBSIDY_POOLS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute5 OKL_SUBSIDY_POOLS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute6 OKL_SUBSIDY_POOLS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute7 OKL_SUBSIDY_POOLS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute_category OKL_SUBSIDY_POOLS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute1 OKL_SUBSIDY_POOLS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute2 OKL_SUBSIDY_POOLS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute3 OKL_SUBSIDY_POOLS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute4 OKL_SUBSIDY_POOLS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute5 OKL_SUBSIDY_POOLS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute6 OKL_SUBSIDY_POOLS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute7 OKL_SUBSIDY_POOLS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute8 OKL_SUBSIDY_POOLS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute1 OKL_SUBSIDY_POOLS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute2 OKL_SUBSIDY_POOLS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute3 OKL_SUBSIDY_POOLS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute4 OKL_SUBSIDY_POOLS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute5 OKL_SUBSIDY_POOLS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute6 OKL_SUBSIDY_POOLS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute7 OKL_SUBSIDY_POOLS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute8 OKL_SUBSIDY_POOLS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute9 OKL_SUBSIDY_POOLS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute2 OKL_SUBSIDY_POOLS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute3 OKL_SUBSIDY_POOLS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute4 OKL_SUBSIDY_POOLS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute5 OKL_SUBSIDY_POOLS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute6 OKL_SUBSIDY_POOLS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute7 OKL_SUBSIDY_POOLS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute8 OKL_SUBSIDY_POOLS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute9 OKL_SUBSIDY_POOLS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute10 OKL_SUBSIDY_POOLS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute3 OKL_SUBSIDY_POOLS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute4 OKL_SUBSIDY_POOLS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute5 OKL_SUBSIDY_POOLS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute6 OKL_SUBSIDY_POOLS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute7 OKL_SUBSIDY_POOLS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute8 OKL_SUBSIDY_POOLS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute9 OKL_SUBSIDY_POOLS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute10 OKL_SUBSIDY_POOLS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute11 OKL_SUBSIDY_POOLS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute4 OKL_SUBSIDY_POOLS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute5 OKL_SUBSIDY_POOLS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute6 OKL_SUBSIDY_POOLS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute7 OKL_SUBSIDY_POOLS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute8 OKL_SUBSIDY_POOLS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute9 OKL_SUBSIDY_POOLS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute10 OKL_SUBSIDY_POOLS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute11 OKL_SUBSIDY_POOLS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute12 OKL_SUBSIDY_POOLS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute5 OKL_SUBSIDY_POOLS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute6 OKL_SUBSIDY_POOLS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute7 OKL_SUBSIDY_POOLS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute8 OKL_SUBSIDY_POOLS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute9 OKL_SUBSIDY_POOLS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute10 OKL_SUBSIDY_POOLS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute11 OKL_SUBSIDY_POOLS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute12 OKL_SUBSIDY_POOLS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute13 OKL_SUBSIDY_POOLS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute6 OKL_SUBSIDY_POOLS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute7 OKL_SUBSIDY_POOLS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute8 OKL_SUBSIDY_POOLS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute9 OKL_SUBSIDY_POOLS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute10 OKL_SUBSIDY_POOLS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute11 OKL_SUBSIDY_POOLS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute12 OKL_SUBSIDY_POOLS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute13 OKL_SUBSIDY_POOLS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
39: ,attribute14 OKL_SUBSIDY_POOLS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute7 OKL_SUBSIDY_POOLS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute8 OKL_SUBSIDY_POOLS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute9 OKL_SUBSIDY_POOLS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute10 OKL_SUBSIDY_POOLS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute11 OKL_SUBSIDY_POOLS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute12 OKL_SUBSIDY_POOLS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute13 OKL_SUBSIDY_POOLS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
39: ,attribute14 OKL_SUBSIDY_POOLS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
40: ,attribute15 OKL_SUBSIDY_POOLS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute8 OKL_SUBSIDY_POOLS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute9 OKL_SUBSIDY_POOLS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute10 OKL_SUBSIDY_POOLS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute11 OKL_SUBSIDY_POOLS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute12 OKL_SUBSIDY_POOLS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute13 OKL_SUBSIDY_POOLS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
39: ,attribute14 OKL_SUBSIDY_POOLS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
40: ,attribute15 OKL_SUBSIDY_POOLS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
41: ,created_by NUMBER := OKL_API.G_MISS_NUM
34: ,attribute9 OKL_SUBSIDY_POOLS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute10 OKL_SUBSIDY_POOLS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute11 OKL_SUBSIDY_POOLS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute12 OKL_SUBSIDY_POOLS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute13 OKL_SUBSIDY_POOLS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
39: ,attribute14 OKL_SUBSIDY_POOLS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
40: ,attribute15 OKL_SUBSIDY_POOLS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
41: ,created_by NUMBER := OKL_API.G_MISS_NUM
42: ,creation_date OKL_SUBSIDY_POOLS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
35: ,attribute10 OKL_SUBSIDY_POOLS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute11 OKL_SUBSIDY_POOLS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute12 OKL_SUBSIDY_POOLS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute13 OKL_SUBSIDY_POOLS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
39: ,attribute14 OKL_SUBSIDY_POOLS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
40: ,attribute15 OKL_SUBSIDY_POOLS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
41: ,created_by NUMBER := OKL_API.G_MISS_NUM
42: ,creation_date OKL_SUBSIDY_POOLS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
43: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
36: ,attribute11 OKL_SUBSIDY_POOLS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute12 OKL_SUBSIDY_POOLS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute13 OKL_SUBSIDY_POOLS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
39: ,attribute14 OKL_SUBSIDY_POOLS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
40: ,attribute15 OKL_SUBSIDY_POOLS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
41: ,created_by NUMBER := OKL_API.G_MISS_NUM
42: ,creation_date OKL_SUBSIDY_POOLS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
43: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
44: ,last_update_date OKL_SUBSIDY_POOLS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
38: ,attribute13 OKL_SUBSIDY_POOLS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
39: ,attribute14 OKL_SUBSIDY_POOLS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
40: ,attribute15 OKL_SUBSIDY_POOLS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
41: ,created_by NUMBER := OKL_API.G_MISS_NUM
42: ,creation_date OKL_SUBSIDY_POOLS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
43: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
44: ,last_update_date OKL_SUBSIDY_POOLS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
45: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
46: G_MISS_sipv_rec sipv_rec_type;
40: ,attribute15 OKL_SUBSIDY_POOLS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
41: ,created_by NUMBER := OKL_API.G_MISS_NUM
42: ,creation_date OKL_SUBSIDY_POOLS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
43: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
44: ,last_update_date OKL_SUBSIDY_POOLS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
45: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
46: G_MISS_sipv_rec sipv_rec_type;
47: TYPE sipv_tbl_type IS TABLE OF sipv_rec_type
48: INDEX BY BINARY_INTEGER;