eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SIP_PVT dependencies on OKL_API

Line 8: id NUMBER := OKL_API.G_MISS_NUM

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
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

Line 9: ,object_version_number NUMBER := OKL_API.G_MISS_NUM

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
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

Line 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

Line 11: ,pool_type_code OKL_SUBSIDY_POOLS_V.POOL_TYPE_CODE%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

Line 12: ,subsidy_pool_name OKL_SUBSIDY_POOLS_V.SUBSIDY_POOL_NAME%TYPE := OKL_API.G_MISS_CHAR

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

Line 13: ,short_description OKL_SUBSIDY_POOLS_V.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR

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

Line 14: ,description OKL_SUBSIDY_POOLS_V.DESCRIPTION%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

Line 15: ,effective_from_date OKL_SUBSIDY_POOLS_V.EFFECTIVE_FROM_DATE%TYPE := OKL_API.G_MISS_DATE

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

Line 16: ,effective_to_date OKL_SUBSIDY_POOLS_V.EFFECTIVE_TO_DATE%TYPE := OKL_API.G_MISS_DATE

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

Line 17: ,currency_code OKL_SUBSIDY_POOLS_V.CURRENCY_CODE%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
21: ,reporting_pool_limit NUMBER := OKL_API.G_MISS_NUM

Line 18: ,currency_conversion_type OKL_SUBSIDY_POOLS_V.CURRENCY_CONVERSION_TYPE%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
22: ,total_budgets NUMBER := OKL_API.G_MISS_NUM

Line 19: ,decision_status_code OKL_SUBSIDY_POOLS_V.DECISION_STATUS_CODE%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
23: ,total_subsidy_amount NUMBER := OKL_API.G_MISS_NUM

Line 20: ,subsidy_pool_id NUMBER := OKL_API.G_MISS_NUM

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
24: ,decision_date OKL_SUBSIDY_POOLS_V.DECISION_DATE%TYPE := OKL_API.G_MISS_DATE

Line 21: ,reporting_pool_limit NUMBER := OKL_API.G_MISS_NUM

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
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

Line 22: ,total_budgets NUMBER := OKL_API.G_MISS_NUM

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
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

Line 23: ,total_subsidy_amount NUMBER := OKL_API.G_MISS_NUM

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
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

Line 24: ,decision_date OKL_SUBSIDY_POOLS_V.DECISION_DATE%TYPE := OKL_API.G_MISS_DATE

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

Line 25: ,attribute_category OKL_SUBSIDY_POOLS_V.ATTRIBUTE_CATEGORY%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

Line 26: ,attribute1 OKL_SUBSIDY_POOLS_V.ATTRIBUTE1%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

Line 27: ,attribute2 OKL_SUBSIDY_POOLS_V.ATTRIBUTE2%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

Line 28: ,attribute3 OKL_SUBSIDY_POOLS_V.ATTRIBUTE3%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

Line 29: ,attribute4 OKL_SUBSIDY_POOLS_V.ATTRIBUTE4%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

Line 30: ,attribute5 OKL_SUBSIDY_POOLS_V.ATTRIBUTE5%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

Line 31: ,attribute6 OKL_SUBSIDY_POOLS_V.ATTRIBUTE6%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

Line 32: ,attribute7 OKL_SUBSIDY_POOLS_V.ATTRIBUTE7%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

Line 33: ,attribute8 OKL_SUBSIDY_POOLS_V.ATTRIBUTE8%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

Line 34: ,attribute9 OKL_SUBSIDY_POOLS_V.ATTRIBUTE9%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

Line 35: ,attribute10 OKL_SUBSIDY_POOLS_V.ATTRIBUTE10%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

Line 36: ,attribute11 OKL_SUBSIDY_POOLS_V.ATTRIBUTE11%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

Line 37: ,attribute12 OKL_SUBSIDY_POOLS_V.ATTRIBUTE12%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

Line 38: ,attribute13 OKL_SUBSIDY_POOLS_V.ATTRIBUTE13%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
42: ,creation_date OKL_SUBSIDY_POOLS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

Line 39: ,attribute14 OKL_SUBSIDY_POOLS_V.ATTRIBUTE14%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
43: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

Line 40: ,attribute15 OKL_SUBSIDY_POOLS_V.ATTRIBUTE15%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
44: ,last_update_date OKL_SUBSIDY_POOLS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

Line 41: ,created_by NUMBER := OKL_API.G_MISS_NUM

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
45: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);

Line 42: ,creation_date OKL_SUBSIDY_POOLS_V.CREATION_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;

Line 43: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

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;
47: TYPE sipv_tbl_type IS TABLE OF sipv_rec_type

Line 44: ,last_update_date OKL_SUBSIDY_POOLS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

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;

Line 45: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);

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;
49: -- OKL_SUBSIDY_POOLS_TL Record Spec

Line 51: id NUMBER := OKL_API.G_MISS_NUM

47: TYPE sipv_tbl_type IS TABLE OF sipv_rec_type
48: INDEX BY BINARY_INTEGER;
49: -- OKL_SUBSIDY_POOLS_TL Record Spec
50: TYPE okl_subsidy_pools_tl_rec_type IS RECORD (
51: id NUMBER := OKL_API.G_MISS_NUM
52: ,short_description OKL_SUBSIDY_POOLS_TL.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
53: ,description OKL_SUBSIDY_POOLS_TL.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
54: ,language OKL_SUBSIDY_POOLS_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR
55: ,source_lang OKL_SUBSIDY_POOLS_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR

Line 52: ,short_description OKL_SUBSIDY_POOLS_TL.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR

48: INDEX BY BINARY_INTEGER;
49: -- OKL_SUBSIDY_POOLS_TL Record Spec
50: TYPE okl_subsidy_pools_tl_rec_type IS RECORD (
51: id NUMBER := OKL_API.G_MISS_NUM
52: ,short_description OKL_SUBSIDY_POOLS_TL.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
53: ,description OKL_SUBSIDY_POOLS_TL.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
54: ,language OKL_SUBSIDY_POOLS_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR
55: ,source_lang OKL_SUBSIDY_POOLS_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR
56: ,sfwt_flag OKL_SUBSIDY_POOLS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR

Line 53: ,description OKL_SUBSIDY_POOLS_TL.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR

49: -- OKL_SUBSIDY_POOLS_TL Record Spec
50: TYPE okl_subsidy_pools_tl_rec_type IS RECORD (
51: id NUMBER := OKL_API.G_MISS_NUM
52: ,short_description OKL_SUBSIDY_POOLS_TL.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
53: ,description OKL_SUBSIDY_POOLS_TL.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
54: ,language OKL_SUBSIDY_POOLS_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR
55: ,source_lang OKL_SUBSIDY_POOLS_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR
56: ,sfwt_flag OKL_SUBSIDY_POOLS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR
57: ,created_by NUMBER := OKL_API.G_MISS_NUM

Line 54: ,language OKL_SUBSIDY_POOLS_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR

50: TYPE okl_subsidy_pools_tl_rec_type IS RECORD (
51: id NUMBER := OKL_API.G_MISS_NUM
52: ,short_description OKL_SUBSIDY_POOLS_TL.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
53: ,description OKL_SUBSIDY_POOLS_TL.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
54: ,language OKL_SUBSIDY_POOLS_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR
55: ,source_lang OKL_SUBSIDY_POOLS_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR
56: ,sfwt_flag OKL_SUBSIDY_POOLS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR
57: ,created_by NUMBER := OKL_API.G_MISS_NUM
58: ,creation_date OKL_SUBSIDY_POOLS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

Line 55: ,source_lang OKL_SUBSIDY_POOLS_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR

51: id NUMBER := OKL_API.G_MISS_NUM
52: ,short_description OKL_SUBSIDY_POOLS_TL.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
53: ,description OKL_SUBSIDY_POOLS_TL.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
54: ,language OKL_SUBSIDY_POOLS_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR
55: ,source_lang OKL_SUBSIDY_POOLS_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR
56: ,sfwt_flag OKL_SUBSIDY_POOLS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR
57: ,created_by NUMBER := OKL_API.G_MISS_NUM
58: ,creation_date OKL_SUBSIDY_POOLS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
59: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

Line 56: ,sfwt_flag OKL_SUBSIDY_POOLS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR

52: ,short_description OKL_SUBSIDY_POOLS_TL.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
53: ,description OKL_SUBSIDY_POOLS_TL.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
54: ,language OKL_SUBSIDY_POOLS_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR
55: ,source_lang OKL_SUBSIDY_POOLS_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR
56: ,sfwt_flag OKL_SUBSIDY_POOLS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR
57: ,created_by NUMBER := OKL_API.G_MISS_NUM
58: ,creation_date OKL_SUBSIDY_POOLS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
59: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
60: ,last_update_date OKL_SUBSIDY_POOLS_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

Line 57: ,created_by NUMBER := OKL_API.G_MISS_NUM

53: ,description OKL_SUBSIDY_POOLS_TL.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR
54: ,language OKL_SUBSIDY_POOLS_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR
55: ,source_lang OKL_SUBSIDY_POOLS_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR
56: ,sfwt_flag OKL_SUBSIDY_POOLS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR
57: ,created_by NUMBER := OKL_API.G_MISS_NUM
58: ,creation_date OKL_SUBSIDY_POOLS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
59: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
60: ,last_update_date OKL_SUBSIDY_POOLS_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
61: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);

Line 58: ,creation_date OKL_SUBSIDY_POOLS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

54: ,language OKL_SUBSIDY_POOLS_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR
55: ,source_lang OKL_SUBSIDY_POOLS_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR
56: ,sfwt_flag OKL_SUBSIDY_POOLS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR
57: ,created_by NUMBER := OKL_API.G_MISS_NUM
58: ,creation_date OKL_SUBSIDY_POOLS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
59: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
60: ,last_update_date OKL_SUBSIDY_POOLS_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
61: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
62: GMissOklSubsidyPoolsTlRec okl_subsidy_pools_tl_rec_type;

Line 59: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

55: ,source_lang OKL_SUBSIDY_POOLS_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR
56: ,sfwt_flag OKL_SUBSIDY_POOLS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR
57: ,created_by NUMBER := OKL_API.G_MISS_NUM
58: ,creation_date OKL_SUBSIDY_POOLS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
59: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
60: ,last_update_date OKL_SUBSIDY_POOLS_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
61: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
62: GMissOklSubsidyPoolsTlRec okl_subsidy_pools_tl_rec_type;
63: TYPE okl_subsidy_pools_tl_tbl_type IS TABLE OF okl_subsidy_pools_tl_rec_type

Line 60: ,last_update_date OKL_SUBSIDY_POOLS_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

56: ,sfwt_flag OKL_SUBSIDY_POOLS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR
57: ,created_by NUMBER := OKL_API.G_MISS_NUM
58: ,creation_date OKL_SUBSIDY_POOLS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
59: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
60: ,last_update_date OKL_SUBSIDY_POOLS_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
61: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
62: GMissOklSubsidyPoolsTlRec okl_subsidy_pools_tl_rec_type;
63: TYPE okl_subsidy_pools_tl_tbl_type IS TABLE OF okl_subsidy_pools_tl_rec_type
64: INDEX BY BINARY_INTEGER;

Line 61: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);

57: ,created_by NUMBER := OKL_API.G_MISS_NUM
58: ,creation_date OKL_SUBSIDY_POOLS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
59: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
60: ,last_update_date OKL_SUBSIDY_POOLS_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
61: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
62: GMissOklSubsidyPoolsTlRec okl_subsidy_pools_tl_rec_type;
63: TYPE okl_subsidy_pools_tl_tbl_type IS TABLE OF okl_subsidy_pools_tl_rec_type
64: INDEX BY BINARY_INTEGER;
65: -- OKL_SUBSIDY_POOLS_B Record Spec

Line 67: id NUMBER := OKL_API.G_MISS_NUM

63: TYPE okl_subsidy_pools_tl_tbl_type IS TABLE OF okl_subsidy_pools_tl_rec_type
64: INDEX BY BINARY_INTEGER;
65: -- OKL_SUBSIDY_POOLS_B Record Spec
66: TYPE sip_rec_type IS RECORD (
67: id NUMBER := OKL_API.G_MISS_NUM
68: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
69: ,pool_type_code OKL_SUBSIDY_POOLS_B.POOL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
70: ,subsidy_pool_name OKL_SUBSIDY_POOLS_B.SUBSIDY_POOL_NAME%TYPE := OKL_API.G_MISS_CHAR
71: ,effective_from_date OKL_SUBSIDY_POOLS_B.EFFECTIVE_FROM_DATE%TYPE := OKL_API.G_MISS_DATE

Line 68: ,object_version_number NUMBER := OKL_API.G_MISS_NUM

64: INDEX BY BINARY_INTEGER;
65: -- OKL_SUBSIDY_POOLS_B Record Spec
66: TYPE sip_rec_type IS RECORD (
67: id NUMBER := OKL_API.G_MISS_NUM
68: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
69: ,pool_type_code OKL_SUBSIDY_POOLS_B.POOL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
70: ,subsidy_pool_name OKL_SUBSIDY_POOLS_B.SUBSIDY_POOL_NAME%TYPE := OKL_API.G_MISS_CHAR
71: ,effective_from_date OKL_SUBSIDY_POOLS_B.EFFECTIVE_FROM_DATE%TYPE := OKL_API.G_MISS_DATE
72: ,effective_to_date OKL_SUBSIDY_POOLS_B.EFFECTIVE_TO_DATE%TYPE := OKL_API.G_MISS_DATE

Line 69: ,pool_type_code OKL_SUBSIDY_POOLS_B.POOL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR

65: -- OKL_SUBSIDY_POOLS_B Record Spec
66: TYPE sip_rec_type IS RECORD (
67: id NUMBER := OKL_API.G_MISS_NUM
68: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
69: ,pool_type_code OKL_SUBSIDY_POOLS_B.POOL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
70: ,subsidy_pool_name OKL_SUBSIDY_POOLS_B.SUBSIDY_POOL_NAME%TYPE := OKL_API.G_MISS_CHAR
71: ,effective_from_date OKL_SUBSIDY_POOLS_B.EFFECTIVE_FROM_DATE%TYPE := OKL_API.G_MISS_DATE
72: ,effective_to_date OKL_SUBSIDY_POOLS_B.EFFECTIVE_TO_DATE%TYPE := OKL_API.G_MISS_DATE
73: ,currency_code OKL_SUBSIDY_POOLS_B.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR

Line 70: ,subsidy_pool_name OKL_SUBSIDY_POOLS_B.SUBSIDY_POOL_NAME%TYPE := OKL_API.G_MISS_CHAR

66: TYPE sip_rec_type IS RECORD (
67: id NUMBER := OKL_API.G_MISS_NUM
68: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
69: ,pool_type_code OKL_SUBSIDY_POOLS_B.POOL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
70: ,subsidy_pool_name OKL_SUBSIDY_POOLS_B.SUBSIDY_POOL_NAME%TYPE := OKL_API.G_MISS_CHAR
71: ,effective_from_date OKL_SUBSIDY_POOLS_B.EFFECTIVE_FROM_DATE%TYPE := OKL_API.G_MISS_DATE
72: ,effective_to_date OKL_SUBSIDY_POOLS_B.EFFECTIVE_TO_DATE%TYPE := OKL_API.G_MISS_DATE
73: ,currency_code OKL_SUBSIDY_POOLS_B.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
74: ,currency_conversion_type OKL_SUBSIDY_POOLS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR

Line 71: ,effective_from_date OKL_SUBSIDY_POOLS_B.EFFECTIVE_FROM_DATE%TYPE := OKL_API.G_MISS_DATE

67: id NUMBER := OKL_API.G_MISS_NUM
68: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
69: ,pool_type_code OKL_SUBSIDY_POOLS_B.POOL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
70: ,subsidy_pool_name OKL_SUBSIDY_POOLS_B.SUBSIDY_POOL_NAME%TYPE := OKL_API.G_MISS_CHAR
71: ,effective_from_date OKL_SUBSIDY_POOLS_B.EFFECTIVE_FROM_DATE%TYPE := OKL_API.G_MISS_DATE
72: ,effective_to_date OKL_SUBSIDY_POOLS_B.EFFECTIVE_TO_DATE%TYPE := OKL_API.G_MISS_DATE
73: ,currency_code OKL_SUBSIDY_POOLS_B.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
74: ,currency_conversion_type OKL_SUBSIDY_POOLS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
75: ,decision_status_code OKL_SUBSIDY_POOLS_B.DECISION_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR

Line 72: ,effective_to_date OKL_SUBSIDY_POOLS_B.EFFECTIVE_TO_DATE%TYPE := OKL_API.G_MISS_DATE

68: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
69: ,pool_type_code OKL_SUBSIDY_POOLS_B.POOL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
70: ,subsidy_pool_name OKL_SUBSIDY_POOLS_B.SUBSIDY_POOL_NAME%TYPE := OKL_API.G_MISS_CHAR
71: ,effective_from_date OKL_SUBSIDY_POOLS_B.EFFECTIVE_FROM_DATE%TYPE := OKL_API.G_MISS_DATE
72: ,effective_to_date OKL_SUBSIDY_POOLS_B.EFFECTIVE_TO_DATE%TYPE := OKL_API.G_MISS_DATE
73: ,currency_code OKL_SUBSIDY_POOLS_B.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
74: ,currency_conversion_type OKL_SUBSIDY_POOLS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
75: ,decision_status_code OKL_SUBSIDY_POOLS_B.DECISION_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
76: ,subsidy_pool_id NUMBER := OKL_API.G_MISS_NUM

Line 73: ,currency_code OKL_SUBSIDY_POOLS_B.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR

69: ,pool_type_code OKL_SUBSIDY_POOLS_B.POOL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
70: ,subsidy_pool_name OKL_SUBSIDY_POOLS_B.SUBSIDY_POOL_NAME%TYPE := OKL_API.G_MISS_CHAR
71: ,effective_from_date OKL_SUBSIDY_POOLS_B.EFFECTIVE_FROM_DATE%TYPE := OKL_API.G_MISS_DATE
72: ,effective_to_date OKL_SUBSIDY_POOLS_B.EFFECTIVE_TO_DATE%TYPE := OKL_API.G_MISS_DATE
73: ,currency_code OKL_SUBSIDY_POOLS_B.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
74: ,currency_conversion_type OKL_SUBSIDY_POOLS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
75: ,decision_status_code OKL_SUBSIDY_POOLS_B.DECISION_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
76: ,subsidy_pool_id NUMBER := OKL_API.G_MISS_NUM
77: ,reporting_pool_limit NUMBER := OKL_API.G_MISS_NUM

Line 74: ,currency_conversion_type OKL_SUBSIDY_POOLS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR

70: ,subsidy_pool_name OKL_SUBSIDY_POOLS_B.SUBSIDY_POOL_NAME%TYPE := OKL_API.G_MISS_CHAR
71: ,effective_from_date OKL_SUBSIDY_POOLS_B.EFFECTIVE_FROM_DATE%TYPE := OKL_API.G_MISS_DATE
72: ,effective_to_date OKL_SUBSIDY_POOLS_B.EFFECTIVE_TO_DATE%TYPE := OKL_API.G_MISS_DATE
73: ,currency_code OKL_SUBSIDY_POOLS_B.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
74: ,currency_conversion_type OKL_SUBSIDY_POOLS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
75: ,decision_status_code OKL_SUBSIDY_POOLS_B.DECISION_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
76: ,subsidy_pool_id NUMBER := OKL_API.G_MISS_NUM
77: ,reporting_pool_limit NUMBER := OKL_API.G_MISS_NUM
78: ,total_budgets NUMBER := OKL_API.G_MISS_NUM

Line 75: ,decision_status_code OKL_SUBSIDY_POOLS_B.DECISION_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR

71: ,effective_from_date OKL_SUBSIDY_POOLS_B.EFFECTIVE_FROM_DATE%TYPE := OKL_API.G_MISS_DATE
72: ,effective_to_date OKL_SUBSIDY_POOLS_B.EFFECTIVE_TO_DATE%TYPE := OKL_API.G_MISS_DATE
73: ,currency_code OKL_SUBSIDY_POOLS_B.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
74: ,currency_conversion_type OKL_SUBSIDY_POOLS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
75: ,decision_status_code OKL_SUBSIDY_POOLS_B.DECISION_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
76: ,subsidy_pool_id NUMBER := OKL_API.G_MISS_NUM
77: ,reporting_pool_limit NUMBER := OKL_API.G_MISS_NUM
78: ,total_budgets NUMBER := OKL_API.G_MISS_NUM
79: ,total_subsidy_amount NUMBER := OKL_API.G_MISS_NUM

Line 76: ,subsidy_pool_id NUMBER := OKL_API.G_MISS_NUM

72: ,effective_to_date OKL_SUBSIDY_POOLS_B.EFFECTIVE_TO_DATE%TYPE := OKL_API.G_MISS_DATE
73: ,currency_code OKL_SUBSIDY_POOLS_B.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
74: ,currency_conversion_type OKL_SUBSIDY_POOLS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
75: ,decision_status_code OKL_SUBSIDY_POOLS_B.DECISION_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
76: ,subsidy_pool_id NUMBER := OKL_API.G_MISS_NUM
77: ,reporting_pool_limit NUMBER := OKL_API.G_MISS_NUM
78: ,total_budgets NUMBER := OKL_API.G_MISS_NUM
79: ,total_subsidy_amount NUMBER := OKL_API.G_MISS_NUM
80: ,decision_date OKL_SUBSIDY_POOLS_B.DECISION_DATE%TYPE := OKL_API.G_MISS_DATE

Line 77: ,reporting_pool_limit NUMBER := OKL_API.G_MISS_NUM

73: ,currency_code OKL_SUBSIDY_POOLS_B.CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
74: ,currency_conversion_type OKL_SUBSIDY_POOLS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
75: ,decision_status_code OKL_SUBSIDY_POOLS_B.DECISION_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
76: ,subsidy_pool_id NUMBER := OKL_API.G_MISS_NUM
77: ,reporting_pool_limit NUMBER := OKL_API.G_MISS_NUM
78: ,total_budgets NUMBER := OKL_API.G_MISS_NUM
79: ,total_subsidy_amount NUMBER := OKL_API.G_MISS_NUM
80: ,decision_date OKL_SUBSIDY_POOLS_B.DECISION_DATE%TYPE := OKL_API.G_MISS_DATE
81: ,attribute_category OKL_SUBSIDY_POOLS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR

Line 78: ,total_budgets NUMBER := OKL_API.G_MISS_NUM

74: ,currency_conversion_type OKL_SUBSIDY_POOLS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
75: ,decision_status_code OKL_SUBSIDY_POOLS_B.DECISION_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
76: ,subsidy_pool_id NUMBER := OKL_API.G_MISS_NUM
77: ,reporting_pool_limit NUMBER := OKL_API.G_MISS_NUM
78: ,total_budgets NUMBER := OKL_API.G_MISS_NUM
79: ,total_subsidy_amount NUMBER := OKL_API.G_MISS_NUM
80: ,decision_date OKL_SUBSIDY_POOLS_B.DECISION_DATE%TYPE := OKL_API.G_MISS_DATE
81: ,attribute_category OKL_SUBSIDY_POOLS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute1 OKL_SUBSIDY_POOLS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR

Line 79: ,total_subsidy_amount NUMBER := OKL_API.G_MISS_NUM

75: ,decision_status_code OKL_SUBSIDY_POOLS_B.DECISION_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
76: ,subsidy_pool_id NUMBER := OKL_API.G_MISS_NUM
77: ,reporting_pool_limit NUMBER := OKL_API.G_MISS_NUM
78: ,total_budgets NUMBER := OKL_API.G_MISS_NUM
79: ,total_subsidy_amount NUMBER := OKL_API.G_MISS_NUM
80: ,decision_date OKL_SUBSIDY_POOLS_B.DECISION_DATE%TYPE := OKL_API.G_MISS_DATE
81: ,attribute_category OKL_SUBSIDY_POOLS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute1 OKL_SUBSIDY_POOLS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute2 OKL_SUBSIDY_POOLS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR

Line 80: ,decision_date OKL_SUBSIDY_POOLS_B.DECISION_DATE%TYPE := OKL_API.G_MISS_DATE

76: ,subsidy_pool_id NUMBER := OKL_API.G_MISS_NUM
77: ,reporting_pool_limit NUMBER := OKL_API.G_MISS_NUM
78: ,total_budgets NUMBER := OKL_API.G_MISS_NUM
79: ,total_subsidy_amount NUMBER := OKL_API.G_MISS_NUM
80: ,decision_date OKL_SUBSIDY_POOLS_B.DECISION_DATE%TYPE := OKL_API.G_MISS_DATE
81: ,attribute_category OKL_SUBSIDY_POOLS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute1 OKL_SUBSIDY_POOLS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute2 OKL_SUBSIDY_POOLS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
84: ,attribute3 OKL_SUBSIDY_POOLS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR

Line 81: ,attribute_category OKL_SUBSIDY_POOLS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR

77: ,reporting_pool_limit NUMBER := OKL_API.G_MISS_NUM
78: ,total_budgets NUMBER := OKL_API.G_MISS_NUM
79: ,total_subsidy_amount NUMBER := OKL_API.G_MISS_NUM
80: ,decision_date OKL_SUBSIDY_POOLS_B.DECISION_DATE%TYPE := OKL_API.G_MISS_DATE
81: ,attribute_category OKL_SUBSIDY_POOLS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute1 OKL_SUBSIDY_POOLS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute2 OKL_SUBSIDY_POOLS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
84: ,attribute3 OKL_SUBSIDY_POOLS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
85: ,attribute4 OKL_SUBSIDY_POOLS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR

Line 82: ,attribute1 OKL_SUBSIDY_POOLS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR

78: ,total_budgets NUMBER := OKL_API.G_MISS_NUM
79: ,total_subsidy_amount NUMBER := OKL_API.G_MISS_NUM
80: ,decision_date OKL_SUBSIDY_POOLS_B.DECISION_DATE%TYPE := OKL_API.G_MISS_DATE
81: ,attribute_category OKL_SUBSIDY_POOLS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute1 OKL_SUBSIDY_POOLS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute2 OKL_SUBSIDY_POOLS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
84: ,attribute3 OKL_SUBSIDY_POOLS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
85: ,attribute4 OKL_SUBSIDY_POOLS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
86: ,attribute5 OKL_SUBSIDY_POOLS_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR

Line 83: ,attribute2 OKL_SUBSIDY_POOLS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR

79: ,total_subsidy_amount NUMBER := OKL_API.G_MISS_NUM
80: ,decision_date OKL_SUBSIDY_POOLS_B.DECISION_DATE%TYPE := OKL_API.G_MISS_DATE
81: ,attribute_category OKL_SUBSIDY_POOLS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute1 OKL_SUBSIDY_POOLS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute2 OKL_SUBSIDY_POOLS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
84: ,attribute3 OKL_SUBSIDY_POOLS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
85: ,attribute4 OKL_SUBSIDY_POOLS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
86: ,attribute5 OKL_SUBSIDY_POOLS_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
87: ,attribute6 OKL_SUBSIDY_POOLS_B.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR

Line 84: ,attribute3 OKL_SUBSIDY_POOLS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR

80: ,decision_date OKL_SUBSIDY_POOLS_B.DECISION_DATE%TYPE := OKL_API.G_MISS_DATE
81: ,attribute_category OKL_SUBSIDY_POOLS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute1 OKL_SUBSIDY_POOLS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute2 OKL_SUBSIDY_POOLS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
84: ,attribute3 OKL_SUBSIDY_POOLS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
85: ,attribute4 OKL_SUBSIDY_POOLS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
86: ,attribute5 OKL_SUBSIDY_POOLS_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
87: ,attribute6 OKL_SUBSIDY_POOLS_B.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
88: ,attribute7 OKL_SUBSIDY_POOLS_B.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR

Line 85: ,attribute4 OKL_SUBSIDY_POOLS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR

81: ,attribute_category OKL_SUBSIDY_POOLS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
82: ,attribute1 OKL_SUBSIDY_POOLS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute2 OKL_SUBSIDY_POOLS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
84: ,attribute3 OKL_SUBSIDY_POOLS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
85: ,attribute4 OKL_SUBSIDY_POOLS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
86: ,attribute5 OKL_SUBSIDY_POOLS_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
87: ,attribute6 OKL_SUBSIDY_POOLS_B.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
88: ,attribute7 OKL_SUBSIDY_POOLS_B.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
89: ,attribute8 OKL_SUBSIDY_POOLS_B.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR

Line 86: ,attribute5 OKL_SUBSIDY_POOLS_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR

82: ,attribute1 OKL_SUBSIDY_POOLS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
83: ,attribute2 OKL_SUBSIDY_POOLS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
84: ,attribute3 OKL_SUBSIDY_POOLS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
85: ,attribute4 OKL_SUBSIDY_POOLS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
86: ,attribute5 OKL_SUBSIDY_POOLS_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
87: ,attribute6 OKL_SUBSIDY_POOLS_B.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
88: ,attribute7 OKL_SUBSIDY_POOLS_B.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
89: ,attribute8 OKL_SUBSIDY_POOLS_B.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
90: ,attribute9 OKL_SUBSIDY_POOLS_B.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR

Line 87: ,attribute6 OKL_SUBSIDY_POOLS_B.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR

83: ,attribute2 OKL_SUBSIDY_POOLS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
84: ,attribute3 OKL_SUBSIDY_POOLS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
85: ,attribute4 OKL_SUBSIDY_POOLS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
86: ,attribute5 OKL_SUBSIDY_POOLS_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
87: ,attribute6 OKL_SUBSIDY_POOLS_B.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
88: ,attribute7 OKL_SUBSIDY_POOLS_B.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
89: ,attribute8 OKL_SUBSIDY_POOLS_B.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
90: ,attribute9 OKL_SUBSIDY_POOLS_B.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
91: ,attribute10 OKL_SUBSIDY_POOLS_B.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR

Line 88: ,attribute7 OKL_SUBSIDY_POOLS_B.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR

84: ,attribute3 OKL_SUBSIDY_POOLS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
85: ,attribute4 OKL_SUBSIDY_POOLS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
86: ,attribute5 OKL_SUBSIDY_POOLS_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
87: ,attribute6 OKL_SUBSIDY_POOLS_B.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
88: ,attribute7 OKL_SUBSIDY_POOLS_B.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
89: ,attribute8 OKL_SUBSIDY_POOLS_B.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
90: ,attribute9 OKL_SUBSIDY_POOLS_B.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
91: ,attribute10 OKL_SUBSIDY_POOLS_B.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
92: ,attribute11 OKL_SUBSIDY_POOLS_B.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR

Line 89: ,attribute8 OKL_SUBSIDY_POOLS_B.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR

85: ,attribute4 OKL_SUBSIDY_POOLS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
86: ,attribute5 OKL_SUBSIDY_POOLS_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
87: ,attribute6 OKL_SUBSIDY_POOLS_B.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
88: ,attribute7 OKL_SUBSIDY_POOLS_B.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
89: ,attribute8 OKL_SUBSIDY_POOLS_B.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
90: ,attribute9 OKL_SUBSIDY_POOLS_B.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
91: ,attribute10 OKL_SUBSIDY_POOLS_B.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
92: ,attribute11 OKL_SUBSIDY_POOLS_B.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
93: ,attribute12 OKL_SUBSIDY_POOLS_B.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR

Line 90: ,attribute9 OKL_SUBSIDY_POOLS_B.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR

86: ,attribute5 OKL_SUBSIDY_POOLS_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
87: ,attribute6 OKL_SUBSIDY_POOLS_B.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
88: ,attribute7 OKL_SUBSIDY_POOLS_B.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
89: ,attribute8 OKL_SUBSIDY_POOLS_B.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
90: ,attribute9 OKL_SUBSIDY_POOLS_B.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
91: ,attribute10 OKL_SUBSIDY_POOLS_B.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
92: ,attribute11 OKL_SUBSIDY_POOLS_B.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
93: ,attribute12 OKL_SUBSIDY_POOLS_B.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
94: ,attribute13 OKL_SUBSIDY_POOLS_B.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR

Line 91: ,attribute10 OKL_SUBSIDY_POOLS_B.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR

87: ,attribute6 OKL_SUBSIDY_POOLS_B.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
88: ,attribute7 OKL_SUBSIDY_POOLS_B.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
89: ,attribute8 OKL_SUBSIDY_POOLS_B.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
90: ,attribute9 OKL_SUBSIDY_POOLS_B.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
91: ,attribute10 OKL_SUBSIDY_POOLS_B.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
92: ,attribute11 OKL_SUBSIDY_POOLS_B.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
93: ,attribute12 OKL_SUBSIDY_POOLS_B.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
94: ,attribute13 OKL_SUBSIDY_POOLS_B.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
95: ,attribute14 OKL_SUBSIDY_POOLS_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR

Line 92: ,attribute11 OKL_SUBSIDY_POOLS_B.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR

88: ,attribute7 OKL_SUBSIDY_POOLS_B.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
89: ,attribute8 OKL_SUBSIDY_POOLS_B.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
90: ,attribute9 OKL_SUBSIDY_POOLS_B.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
91: ,attribute10 OKL_SUBSIDY_POOLS_B.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
92: ,attribute11 OKL_SUBSIDY_POOLS_B.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
93: ,attribute12 OKL_SUBSIDY_POOLS_B.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
94: ,attribute13 OKL_SUBSIDY_POOLS_B.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
95: ,attribute14 OKL_SUBSIDY_POOLS_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
96: ,attribute15 OKL_SUBSIDY_POOLS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR

Line 93: ,attribute12 OKL_SUBSIDY_POOLS_B.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR

89: ,attribute8 OKL_SUBSIDY_POOLS_B.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
90: ,attribute9 OKL_SUBSIDY_POOLS_B.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
91: ,attribute10 OKL_SUBSIDY_POOLS_B.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
92: ,attribute11 OKL_SUBSIDY_POOLS_B.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
93: ,attribute12 OKL_SUBSIDY_POOLS_B.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
94: ,attribute13 OKL_SUBSIDY_POOLS_B.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
95: ,attribute14 OKL_SUBSIDY_POOLS_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
96: ,attribute15 OKL_SUBSIDY_POOLS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
97: ,created_by NUMBER := OKL_API.G_MISS_NUM

Line 94: ,attribute13 OKL_SUBSIDY_POOLS_B.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR

90: ,attribute9 OKL_SUBSIDY_POOLS_B.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
91: ,attribute10 OKL_SUBSIDY_POOLS_B.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
92: ,attribute11 OKL_SUBSIDY_POOLS_B.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
93: ,attribute12 OKL_SUBSIDY_POOLS_B.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
94: ,attribute13 OKL_SUBSIDY_POOLS_B.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
95: ,attribute14 OKL_SUBSIDY_POOLS_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
96: ,attribute15 OKL_SUBSIDY_POOLS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
97: ,created_by NUMBER := OKL_API.G_MISS_NUM
98: ,creation_date OKL_SUBSIDY_POOLS_B.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

Line 95: ,attribute14 OKL_SUBSIDY_POOLS_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR

91: ,attribute10 OKL_SUBSIDY_POOLS_B.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
92: ,attribute11 OKL_SUBSIDY_POOLS_B.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
93: ,attribute12 OKL_SUBSIDY_POOLS_B.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
94: ,attribute13 OKL_SUBSIDY_POOLS_B.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
95: ,attribute14 OKL_SUBSIDY_POOLS_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
96: ,attribute15 OKL_SUBSIDY_POOLS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
97: ,created_by NUMBER := OKL_API.G_MISS_NUM
98: ,creation_date OKL_SUBSIDY_POOLS_B.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
99: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

Line 96: ,attribute15 OKL_SUBSIDY_POOLS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR

92: ,attribute11 OKL_SUBSIDY_POOLS_B.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
93: ,attribute12 OKL_SUBSIDY_POOLS_B.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
94: ,attribute13 OKL_SUBSIDY_POOLS_B.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
95: ,attribute14 OKL_SUBSIDY_POOLS_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
96: ,attribute15 OKL_SUBSIDY_POOLS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
97: ,created_by NUMBER := OKL_API.G_MISS_NUM
98: ,creation_date OKL_SUBSIDY_POOLS_B.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
99: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
100: ,last_update_date OKL_SUBSIDY_POOLS_B.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

Line 97: ,created_by NUMBER := OKL_API.G_MISS_NUM

93: ,attribute12 OKL_SUBSIDY_POOLS_B.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
94: ,attribute13 OKL_SUBSIDY_POOLS_B.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
95: ,attribute14 OKL_SUBSIDY_POOLS_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
96: ,attribute15 OKL_SUBSIDY_POOLS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
97: ,created_by NUMBER := OKL_API.G_MISS_NUM
98: ,creation_date OKL_SUBSIDY_POOLS_B.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
99: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
100: ,last_update_date OKL_SUBSIDY_POOLS_B.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
101: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);

Line 98: ,creation_date OKL_SUBSIDY_POOLS_B.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE

94: ,attribute13 OKL_SUBSIDY_POOLS_B.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
95: ,attribute14 OKL_SUBSIDY_POOLS_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
96: ,attribute15 OKL_SUBSIDY_POOLS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
97: ,created_by NUMBER := OKL_API.G_MISS_NUM
98: ,creation_date OKL_SUBSIDY_POOLS_B.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
99: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
100: ,last_update_date OKL_SUBSIDY_POOLS_B.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
101: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
102: G_MISS_sip_rec sip_rec_type;

Line 99: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM

95: ,attribute14 OKL_SUBSIDY_POOLS_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
96: ,attribute15 OKL_SUBSIDY_POOLS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
97: ,created_by NUMBER := OKL_API.G_MISS_NUM
98: ,creation_date OKL_SUBSIDY_POOLS_B.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
99: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
100: ,last_update_date OKL_SUBSIDY_POOLS_B.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
101: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
102: G_MISS_sip_rec sip_rec_type;
103: TYPE sip_tbl_type IS TABLE OF sip_rec_type

Line 100: ,last_update_date OKL_SUBSIDY_POOLS_B.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE

96: ,attribute15 OKL_SUBSIDY_POOLS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
97: ,created_by NUMBER := OKL_API.G_MISS_NUM
98: ,creation_date OKL_SUBSIDY_POOLS_B.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
99: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
100: ,last_update_date OKL_SUBSIDY_POOLS_B.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
101: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
102: G_MISS_sip_rec sip_rec_type;
103: TYPE sip_tbl_type IS TABLE OF sip_rec_type
104: INDEX BY BINARY_INTEGER;

Line 101: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);

97: ,created_by NUMBER := OKL_API.G_MISS_NUM
98: ,creation_date OKL_SUBSIDY_POOLS_B.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
99: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
100: ,last_update_date OKL_SUBSIDY_POOLS_B.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
101: ,last_update_login NUMBER := OKL_API.G_MISS_NUM);
102: G_MISS_sip_rec sip_rec_type;
103: TYPE sip_tbl_type IS TABLE OF sip_rec_type
104: INDEX BY BINARY_INTEGER;
105: ---------------------------------------------------------------------------

Line 108: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;

104: INDEX BY BINARY_INTEGER;
105: ---------------------------------------------------------------------------
106: -- GLOBAL MESSAGE CONSTANTS
107: ---------------------------------------------------------------------------
108: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
109: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
110: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
111: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
112: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;

Line 109: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;

105: ---------------------------------------------------------------------------
106: -- GLOBAL MESSAGE CONSTANTS
107: ---------------------------------------------------------------------------
108: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
109: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
110: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
111: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
112: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
113: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

Line 110: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;

106: -- GLOBAL MESSAGE CONSTANTS
107: ---------------------------------------------------------------------------
108: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
109: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
110: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
111: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
112: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
113: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
114: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

Line 111: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;

107: ---------------------------------------------------------------------------
108: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
109: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
110: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
111: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
112: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
113: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
114: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
115: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

Line 112: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;

108: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
109: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
110: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
111: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
112: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
113: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
114: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
115: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
116: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;

Line 113: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

109: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
110: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
111: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
112: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
113: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
114: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
115: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
116: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
117: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

Line 114: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

110: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
111: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
112: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
113: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
114: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
115: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
116: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
117: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
118: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';

Line 115: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

111: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
112: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
113: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
114: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
115: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
116: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
117: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
118: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
119: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

Line 116: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;

112: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
113: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
114: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
115: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
116: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
117: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
118: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
119: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
120: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

Line 117: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

113: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
114: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
115: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
116: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
117: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
118: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
119: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
120: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
121: G_TABLE_TOKEN CONSTANT VARCHAR2(100) := 'OKL_TABLE_NAME';

Line 133: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

129: ---------------------------------------------------------------------------
130: -- GLOBAL VARIABLES
131: ---------------------------------------------------------------------------
132: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SIP_PVT';
133: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
134: ---------------------------------------------------------------------------
135: -- Procedures and Functions
136: ---------------------------------------------------------------------------
137:

Line 144: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

140: PROCEDURE api_copy;
141: PROCEDURE add_language;
142: PROCEDURE insert_row(
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2,
148: p_sipv_rec IN sipv_rec_type,

Line 152: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

148: p_sipv_rec IN sipv_rec_type,
149: x_sipv_rec OUT NOCOPY sipv_rec_type);
150: PROCEDURE insert_row(
151: p_api_version IN NUMBER,
152: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
153: x_return_status OUT NOCOPY VARCHAR2,
154: x_msg_count OUT NOCOPY NUMBER,
155: x_msg_data OUT NOCOPY VARCHAR2,
156: p_sipv_tbl IN sipv_tbl_type,

Line 158: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

154: x_msg_count OUT NOCOPY NUMBER,
155: x_msg_data OUT NOCOPY VARCHAR2,
156: p_sipv_tbl IN sipv_tbl_type,
157: x_sipv_tbl OUT NOCOPY sipv_tbl_type,
158: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
159: PROCEDURE insert_row(
160: p_api_version IN NUMBER,
161: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
162: x_return_status OUT NOCOPY VARCHAR2,

Line 161: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

157: x_sipv_tbl OUT NOCOPY sipv_tbl_type,
158: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
159: PROCEDURE insert_row(
160: p_api_version IN NUMBER,
161: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
162: x_return_status OUT NOCOPY VARCHAR2,
163: x_msg_count OUT NOCOPY NUMBER,
164: x_msg_data OUT NOCOPY VARCHAR2,
165: p_sipv_tbl IN sipv_tbl_type,

Line 169: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

165: p_sipv_tbl IN sipv_tbl_type,
166: x_sipv_tbl OUT NOCOPY sipv_tbl_type);
167: PROCEDURE lock_row(
168: p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
170: x_return_status OUT NOCOPY VARCHAR2,
171: x_msg_count OUT NOCOPY NUMBER,
172: x_msg_data OUT NOCOPY VARCHAR2,
173: p_sipv_rec IN sipv_rec_type);

Line 176: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

172: x_msg_data OUT NOCOPY VARCHAR2,
173: p_sipv_rec IN sipv_rec_type);
174: PROCEDURE lock_row(
175: p_api_version IN NUMBER,
176: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
177: x_return_status OUT NOCOPY VARCHAR2,
178: x_msg_count OUT NOCOPY NUMBER,
179: x_msg_data OUT NOCOPY VARCHAR2,
180: p_sipv_tbl IN sipv_tbl_type,

Line 181: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

177: x_return_status OUT NOCOPY VARCHAR2,
178: x_msg_count OUT NOCOPY NUMBER,
179: x_msg_data OUT NOCOPY VARCHAR2,
180: p_sipv_tbl IN sipv_tbl_type,
181: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
182: PROCEDURE lock_row(
183: p_api_version IN NUMBER,
184: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
185: x_return_status OUT NOCOPY VARCHAR2,

Line 184: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

180: p_sipv_tbl IN sipv_tbl_type,
181: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
182: PROCEDURE lock_row(
183: p_api_version IN NUMBER,
184: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
185: x_return_status OUT NOCOPY VARCHAR2,
186: x_msg_count OUT NOCOPY NUMBER,
187: x_msg_data OUT NOCOPY VARCHAR2,
188: p_sipv_tbl IN sipv_tbl_type);

Line 191: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

187: x_msg_data OUT NOCOPY VARCHAR2,
188: p_sipv_tbl IN sipv_tbl_type);
189: PROCEDURE update_row(
190: p_api_version IN NUMBER,
191: p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_sipv_rec IN sipv_rec_type,

Line 199: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

195: p_sipv_rec IN sipv_rec_type,
196: x_sipv_rec OUT NOCOPY sipv_rec_type);
197: PROCEDURE update_row(
198: p_api_version IN NUMBER,
199: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
200: x_return_status OUT NOCOPY VARCHAR2,
201: x_msg_count OUT NOCOPY NUMBER,
202: x_msg_data OUT NOCOPY VARCHAR2,
203: p_sipv_tbl IN sipv_tbl_type,

Line 205: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

201: x_msg_count OUT NOCOPY NUMBER,
202: x_msg_data OUT NOCOPY VARCHAR2,
203: p_sipv_tbl IN sipv_tbl_type,
204: x_sipv_tbl OUT NOCOPY sipv_tbl_type,
205: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
206: PROCEDURE update_row(
207: p_api_version IN NUMBER,
208: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
209: x_return_status OUT NOCOPY VARCHAR2,

Line 208: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

204: x_sipv_tbl OUT NOCOPY sipv_tbl_type,
205: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
206: PROCEDURE update_row(
207: p_api_version IN NUMBER,
208: p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_sipv_tbl IN sipv_tbl_type,

Line 216: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

212: p_sipv_tbl IN sipv_tbl_type,
213: x_sipv_tbl OUT NOCOPY sipv_tbl_type);
214: PROCEDURE delete_row(
215: p_api_version IN NUMBER,
216: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
217: x_return_status OUT NOCOPY VARCHAR2,
218: x_msg_count OUT NOCOPY NUMBER,
219: x_msg_data OUT NOCOPY VARCHAR2,
220: p_sipv_rec IN sipv_rec_type);

Line 223: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

219: x_msg_data OUT NOCOPY VARCHAR2,
220: p_sipv_rec IN sipv_rec_type);
221: PROCEDURE delete_row(
222: p_api_version IN NUMBER,
223: p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_sipv_tbl IN sipv_tbl_type,

Line 228: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

224: x_return_status OUT NOCOPY VARCHAR2,
225: x_msg_count OUT NOCOPY NUMBER,
226: x_msg_data OUT NOCOPY VARCHAR2,
227: p_sipv_tbl IN sipv_tbl_type,
228: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
229: PROCEDURE delete_row(
230: p_api_version IN NUMBER,
231: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
232: x_return_status OUT NOCOPY VARCHAR2,

Line 231: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

227: p_sipv_tbl IN sipv_tbl_type,
228: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
229: PROCEDURE delete_row(
230: p_api_version IN NUMBER,
231: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
232: x_return_status OUT NOCOPY VARCHAR2,
233: x_msg_count OUT NOCOPY NUMBER,
234: x_msg_data OUT NOCOPY VARCHAR2,
235: p_sipv_tbl IN sipv_tbl_type);

Line 238: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

234: x_msg_data OUT NOCOPY VARCHAR2,
235: p_sipv_tbl IN sipv_tbl_type);
236: PROCEDURE validate_row(
237: p_api_version IN NUMBER,
238: p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_sipv_rec IN sipv_rec_type);

Line 245: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

241: x_msg_data OUT NOCOPY VARCHAR2,
242: p_sipv_rec IN sipv_rec_type);
243: PROCEDURE validate_row(
244: p_api_version IN NUMBER,
245: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
246: x_return_status OUT NOCOPY VARCHAR2,
247: x_msg_count OUT NOCOPY NUMBER,
248: x_msg_data OUT NOCOPY VARCHAR2,
249: p_sipv_tbl IN sipv_tbl_type,

Line 250: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

246: x_return_status OUT NOCOPY VARCHAR2,
247: x_msg_count OUT NOCOPY NUMBER,
248: x_msg_data OUT NOCOPY VARCHAR2,
249: p_sipv_tbl IN sipv_tbl_type,
250: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
251: PROCEDURE validate_row(
252: p_api_version IN NUMBER,
253: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
254: x_return_status OUT NOCOPY VARCHAR2,

Line 253: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

249: p_sipv_tbl IN sipv_tbl_type,
250: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
251: PROCEDURE validate_row(
252: p_api_version IN NUMBER,
253: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
254: x_return_status OUT NOCOPY VARCHAR2,
255: x_msg_count OUT NOCOPY NUMBER,
256: x_msg_data OUT NOCOPY VARCHAR2,
257: p_sipv_tbl IN sipv_tbl_type);