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_PTC_PVT dependencies on OKC_API

Line 7: id NUMBER := OKC_API.G_MISS_NUM

3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE ptcv_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM
8: ,sequence_number NUMBER := OKC_API.G_MISS_NUM
9: ,asset_id NUMBER := OKC_API.G_MISS_NUM
10: ,asset_number OKL_PROPERTY_TAX_V.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
11: ,contract_number OKL_PROPERTY_TAX_V.contract_number%TYPE := OKC_API.G_MISS_CHAR

Line 8: ,sequence_number NUMBER := OKC_API.G_MISS_NUM

4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE ptcv_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM
8: ,sequence_number NUMBER := OKC_API.G_MISS_NUM
9: ,asset_id NUMBER := OKC_API.G_MISS_NUM
10: ,asset_number OKL_PROPERTY_TAX_V.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
11: ,contract_number OKL_PROPERTY_TAX_V.contract_number%TYPE := OKC_API.G_MISS_CHAR
12: ,sty_name OKL_PROPERTY_TAX_V.STY_NAME%TYPE := OKC_API.G_MISS_CHAR

Line 9: ,asset_id NUMBER := OKC_API.G_MISS_NUM

5: ---------------------------------------------------------------------------
6: TYPE ptcv_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM
8: ,sequence_number NUMBER := OKC_API.G_MISS_NUM
9: ,asset_id NUMBER := OKC_API.G_MISS_NUM
10: ,asset_number OKL_PROPERTY_TAX_V.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
11: ,contract_number OKL_PROPERTY_TAX_V.contract_number%TYPE := OKC_API.G_MISS_CHAR
12: ,sty_name OKL_PROPERTY_TAX_V.STY_NAME%TYPE := OKC_API.G_MISS_CHAR
13: ,sty_id NUMBER := OKC_API.G_MISS_NUM

Line 10: ,asset_number OKL_PROPERTY_TAX_V.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR

6: TYPE ptcv_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM
8: ,sequence_number NUMBER := OKC_API.G_MISS_NUM
9: ,asset_id NUMBER := OKC_API.G_MISS_NUM
10: ,asset_number OKL_PROPERTY_TAX_V.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
11: ,contract_number OKL_PROPERTY_TAX_V.contract_number%TYPE := OKC_API.G_MISS_CHAR
12: ,sty_name OKL_PROPERTY_TAX_V.STY_NAME%TYPE := OKC_API.G_MISS_CHAR
13: ,sty_id NUMBER := OKC_API.G_MISS_NUM
14: ,invoice_date OKL_PROPERTY_TAX_V.INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 11: ,contract_number OKL_PROPERTY_TAX_V.contract_number%TYPE := OKC_API.G_MISS_CHAR

7: id NUMBER := OKC_API.G_MISS_NUM
8: ,sequence_number NUMBER := OKC_API.G_MISS_NUM
9: ,asset_id NUMBER := OKC_API.G_MISS_NUM
10: ,asset_number OKL_PROPERTY_TAX_V.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
11: ,contract_number OKL_PROPERTY_TAX_V.contract_number%TYPE := OKC_API.G_MISS_CHAR
12: ,sty_name OKL_PROPERTY_TAX_V.STY_NAME%TYPE := OKC_API.G_MISS_CHAR
13: ,sty_id NUMBER := OKC_API.G_MISS_NUM
14: ,invoice_date OKL_PROPERTY_TAX_V.INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,amount NUMBER := OKC_API.G_MISS_NUM

Line 12: ,sty_name OKL_PROPERTY_TAX_V.STY_NAME%TYPE := OKC_API.G_MISS_CHAR

8: ,sequence_number NUMBER := OKC_API.G_MISS_NUM
9: ,asset_id NUMBER := OKC_API.G_MISS_NUM
10: ,asset_number OKL_PROPERTY_TAX_V.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
11: ,contract_number OKL_PROPERTY_TAX_V.contract_number%TYPE := OKC_API.G_MISS_CHAR
12: ,sty_name OKL_PROPERTY_TAX_V.STY_NAME%TYPE := OKC_API.G_MISS_CHAR
13: ,sty_id NUMBER := OKC_API.G_MISS_NUM
14: ,invoice_date OKL_PROPERTY_TAX_V.INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,amount NUMBER := OKC_API.G_MISS_NUM
16: ,org_id NUMBER := OKC_API.G_MISS_NUM

Line 13: ,sty_id NUMBER := OKC_API.G_MISS_NUM

9: ,asset_id NUMBER := OKC_API.G_MISS_NUM
10: ,asset_number OKL_PROPERTY_TAX_V.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
11: ,contract_number OKL_PROPERTY_TAX_V.contract_number%TYPE := OKC_API.G_MISS_CHAR
12: ,sty_name OKL_PROPERTY_TAX_V.STY_NAME%TYPE := OKC_API.G_MISS_CHAR
13: ,sty_id NUMBER := OKC_API.G_MISS_NUM
14: ,invoice_date OKL_PROPERTY_TAX_V.INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,amount NUMBER := OKC_API.G_MISS_NUM
16: ,org_id NUMBER := OKC_API.G_MISS_NUM
17: ,asset_description OKL_PROPERTY_TAX_V.ASSET_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR

Line 14: ,invoice_date OKL_PROPERTY_TAX_V.INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE

10: ,asset_number OKL_PROPERTY_TAX_V.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
11: ,contract_number OKL_PROPERTY_TAX_V.contract_number%TYPE := OKC_API.G_MISS_CHAR
12: ,sty_name OKL_PROPERTY_TAX_V.STY_NAME%TYPE := OKC_API.G_MISS_CHAR
13: ,sty_id NUMBER := OKC_API.G_MISS_NUM
14: ,invoice_date OKL_PROPERTY_TAX_V.INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,amount NUMBER := OKC_API.G_MISS_NUM
16: ,org_id NUMBER := OKC_API.G_MISS_NUM
17: ,asset_description OKL_PROPERTY_TAX_V.ASSET_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
18: ,khr_id NUMBER := OKC_API.G_MISS_NUM

Line 15: ,amount NUMBER := OKC_API.G_MISS_NUM

11: ,contract_number OKL_PROPERTY_TAX_V.contract_number%TYPE := OKC_API.G_MISS_CHAR
12: ,sty_name OKL_PROPERTY_TAX_V.STY_NAME%TYPE := OKC_API.G_MISS_CHAR
13: ,sty_id NUMBER := OKC_API.G_MISS_NUM
14: ,invoice_date OKL_PROPERTY_TAX_V.INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,amount NUMBER := OKC_API.G_MISS_NUM
16: ,org_id NUMBER := OKC_API.G_MISS_NUM
17: ,asset_description OKL_PROPERTY_TAX_V.ASSET_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
18: ,khr_id NUMBER := OKC_API.G_MISS_NUM
19: ,kle_id NUMBER := OKC_API.G_MISS_NUM

Line 16: ,org_id NUMBER := OKC_API.G_MISS_NUM

12: ,sty_name OKL_PROPERTY_TAX_V.STY_NAME%TYPE := OKC_API.G_MISS_CHAR
13: ,sty_id NUMBER := OKC_API.G_MISS_NUM
14: ,invoice_date OKL_PROPERTY_TAX_V.INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,amount NUMBER := OKC_API.G_MISS_NUM
16: ,org_id NUMBER := OKC_API.G_MISS_NUM
17: ,asset_description OKL_PROPERTY_TAX_V.ASSET_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
18: ,khr_id NUMBER := OKC_API.G_MISS_NUM
19: ,kle_id NUMBER := OKC_API.G_MISS_NUM
20: ,asset_units NUMBER := OKC_API.G_MISS_NUM

Line 17: ,asset_description OKL_PROPERTY_TAX_V.ASSET_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR

13: ,sty_id NUMBER := OKC_API.G_MISS_NUM
14: ,invoice_date OKL_PROPERTY_TAX_V.INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,amount NUMBER := OKC_API.G_MISS_NUM
16: ,org_id NUMBER := OKC_API.G_MISS_NUM
17: ,asset_description OKL_PROPERTY_TAX_V.ASSET_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
18: ,khr_id NUMBER := OKC_API.G_MISS_NUM
19: ,kle_id NUMBER := OKC_API.G_MISS_NUM
20: ,asset_units NUMBER := OKC_API.G_MISS_NUM
21: ,language OKL_PROPERTY_TAX_V.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR

Line 18: ,khr_id NUMBER := OKC_API.G_MISS_NUM

14: ,invoice_date OKL_PROPERTY_TAX_V.INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,amount NUMBER := OKC_API.G_MISS_NUM
16: ,org_id NUMBER := OKC_API.G_MISS_NUM
17: ,asset_description OKL_PROPERTY_TAX_V.ASSET_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
18: ,khr_id NUMBER := OKC_API.G_MISS_NUM
19: ,kle_id NUMBER := OKC_API.G_MISS_NUM
20: ,asset_units NUMBER := OKC_API.G_MISS_NUM
21: ,language OKL_PROPERTY_TAX_V.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
22: ,source_lang OKL_PROPERTY_TAX_V.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR

Line 19: ,kle_id NUMBER := OKC_API.G_MISS_NUM

15: ,amount NUMBER := OKC_API.G_MISS_NUM
16: ,org_id NUMBER := OKC_API.G_MISS_NUM
17: ,asset_description OKL_PROPERTY_TAX_V.ASSET_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
18: ,khr_id NUMBER := OKC_API.G_MISS_NUM
19: ,kle_id NUMBER := OKC_API.G_MISS_NUM
20: ,asset_units NUMBER := OKC_API.G_MISS_NUM
21: ,language OKL_PROPERTY_TAX_V.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
22: ,source_lang OKL_PROPERTY_TAX_V.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
23: ,sfwt_flag OKL_PROPERTY_TAX_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR

Line 20: ,asset_units NUMBER := OKC_API.G_MISS_NUM

16: ,org_id NUMBER := OKC_API.G_MISS_NUM
17: ,asset_description OKL_PROPERTY_TAX_V.ASSET_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
18: ,khr_id NUMBER := OKC_API.G_MISS_NUM
19: ,kle_id NUMBER := OKC_API.G_MISS_NUM
20: ,asset_units NUMBER := OKC_API.G_MISS_NUM
21: ,language OKL_PROPERTY_TAX_V.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
22: ,source_lang OKL_PROPERTY_TAX_V.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
23: ,sfwt_flag OKL_PROPERTY_TAX_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
24: ,asset_address_1 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_1%TYPE := OKC_API.G_MISS_CHAR

Line 21: ,language OKL_PROPERTY_TAX_V.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR

17: ,asset_description OKL_PROPERTY_TAX_V.ASSET_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
18: ,khr_id NUMBER := OKC_API.G_MISS_NUM
19: ,kle_id NUMBER := OKC_API.G_MISS_NUM
20: ,asset_units NUMBER := OKC_API.G_MISS_NUM
21: ,language OKL_PROPERTY_TAX_V.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
22: ,source_lang OKL_PROPERTY_TAX_V.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
23: ,sfwt_flag OKL_PROPERTY_TAX_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
24: ,asset_address_1 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_1%TYPE := OKC_API.G_MISS_CHAR
25: ,asset_address_2 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_2%TYPE := OKC_API.G_MISS_CHAR

Line 22: ,source_lang OKL_PROPERTY_TAX_V.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR

18: ,khr_id NUMBER := OKC_API.G_MISS_NUM
19: ,kle_id NUMBER := OKC_API.G_MISS_NUM
20: ,asset_units NUMBER := OKC_API.G_MISS_NUM
21: ,language OKL_PROPERTY_TAX_V.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
22: ,source_lang OKL_PROPERTY_TAX_V.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
23: ,sfwt_flag OKL_PROPERTY_TAX_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
24: ,asset_address_1 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_1%TYPE := OKC_API.G_MISS_CHAR
25: ,asset_address_2 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_2%TYPE := OKC_API.G_MISS_CHAR
26: ,asset_address_3 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_3%TYPE := OKC_API.G_MISS_CHAR

Line 23: ,sfwt_flag OKL_PROPERTY_TAX_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR

19: ,kle_id NUMBER := OKC_API.G_MISS_NUM
20: ,asset_units NUMBER := OKC_API.G_MISS_NUM
21: ,language OKL_PROPERTY_TAX_V.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
22: ,source_lang OKL_PROPERTY_TAX_V.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
23: ,sfwt_flag OKL_PROPERTY_TAX_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
24: ,asset_address_1 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_1%TYPE := OKC_API.G_MISS_CHAR
25: ,asset_address_2 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_2%TYPE := OKC_API.G_MISS_CHAR
26: ,asset_address_3 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_3%TYPE := OKC_API.G_MISS_CHAR
27: ,asset_address_4 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_4%TYPE := OKC_API.G_MISS_CHAR

Line 24: ,asset_address_1 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_1%TYPE := OKC_API.G_MISS_CHAR

20: ,asset_units NUMBER := OKC_API.G_MISS_NUM
21: ,language OKL_PROPERTY_TAX_V.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
22: ,source_lang OKL_PROPERTY_TAX_V.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
23: ,sfwt_flag OKL_PROPERTY_TAX_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
24: ,asset_address_1 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_1%TYPE := OKC_API.G_MISS_CHAR
25: ,asset_address_2 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_2%TYPE := OKC_API.G_MISS_CHAR
26: ,asset_address_3 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_3%TYPE := OKC_API.G_MISS_CHAR
27: ,asset_address_4 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_4%TYPE := OKC_API.G_MISS_CHAR
28: ,asset_city OKL_PROPERTY_TAX_V.ASSET_CITY%TYPE := OKC_API.G_MISS_CHAR

Line 25: ,asset_address_2 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_2%TYPE := OKC_API.G_MISS_CHAR

21: ,language OKL_PROPERTY_TAX_V.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
22: ,source_lang OKL_PROPERTY_TAX_V.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
23: ,sfwt_flag OKL_PROPERTY_TAX_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
24: ,asset_address_1 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_1%TYPE := OKC_API.G_MISS_CHAR
25: ,asset_address_2 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_2%TYPE := OKC_API.G_MISS_CHAR
26: ,asset_address_3 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_3%TYPE := OKC_API.G_MISS_CHAR
27: ,asset_address_4 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_4%TYPE := OKC_API.G_MISS_CHAR
28: ,asset_city OKL_PROPERTY_TAX_V.ASSET_CITY%TYPE := OKC_API.G_MISS_CHAR
29: ,asset_state OKL_PROPERTY_TAX_V.ASSET_STATE%TYPE := OKC_API.G_MISS_CHAR

Line 26: ,asset_address_3 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_3%TYPE := OKC_API.G_MISS_CHAR

22: ,source_lang OKL_PROPERTY_TAX_V.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
23: ,sfwt_flag OKL_PROPERTY_TAX_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
24: ,asset_address_1 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_1%TYPE := OKC_API.G_MISS_CHAR
25: ,asset_address_2 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_2%TYPE := OKC_API.G_MISS_CHAR
26: ,asset_address_3 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_3%TYPE := OKC_API.G_MISS_CHAR
27: ,asset_address_4 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_4%TYPE := OKC_API.G_MISS_CHAR
28: ,asset_city OKL_PROPERTY_TAX_V.ASSET_CITY%TYPE := OKC_API.G_MISS_CHAR
29: ,asset_state OKL_PROPERTY_TAX_V.ASSET_STATE%TYPE := OKC_API.G_MISS_CHAR
30: ,asset_country OKL_PROPERTY_TAX_V.ASSET_COUNTRY%TYPE := OKC_API.G_MISS_CHAR

Line 27: ,asset_address_4 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_4%TYPE := OKC_API.G_MISS_CHAR

23: ,sfwt_flag OKL_PROPERTY_TAX_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
24: ,asset_address_1 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_1%TYPE := OKC_API.G_MISS_CHAR
25: ,asset_address_2 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_2%TYPE := OKC_API.G_MISS_CHAR
26: ,asset_address_3 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_3%TYPE := OKC_API.G_MISS_CHAR
27: ,asset_address_4 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_4%TYPE := OKC_API.G_MISS_CHAR
28: ,asset_city OKL_PROPERTY_TAX_V.ASSET_CITY%TYPE := OKC_API.G_MISS_CHAR
29: ,asset_state OKL_PROPERTY_TAX_V.ASSET_STATE%TYPE := OKC_API.G_MISS_CHAR
30: ,asset_country OKL_PROPERTY_TAX_V.ASSET_COUNTRY%TYPE := OKC_API.G_MISS_CHAR
31: ,tax_assessment_amount NUMBER := OKC_API.G_MISS_NUM

Line 28: ,asset_city OKL_PROPERTY_TAX_V.ASSET_CITY%TYPE := OKC_API.G_MISS_CHAR

24: ,asset_address_1 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_1%TYPE := OKC_API.G_MISS_CHAR
25: ,asset_address_2 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_2%TYPE := OKC_API.G_MISS_CHAR
26: ,asset_address_3 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_3%TYPE := OKC_API.G_MISS_CHAR
27: ,asset_address_4 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_4%TYPE := OKC_API.G_MISS_CHAR
28: ,asset_city OKL_PROPERTY_TAX_V.ASSET_CITY%TYPE := OKC_API.G_MISS_CHAR
29: ,asset_state OKL_PROPERTY_TAX_V.ASSET_STATE%TYPE := OKC_API.G_MISS_CHAR
30: ,asset_country OKL_PROPERTY_TAX_V.ASSET_COUNTRY%TYPE := OKC_API.G_MISS_CHAR
31: ,tax_assessment_amount NUMBER := OKC_API.G_MISS_NUM
32: ,tax_jurisdiction_city OKL_PROPERTY_TAX_V.TAX_JURISDICTION_CITY%TYPE := OKC_API.G_MISS_CHAR

Line 29: ,asset_state OKL_PROPERTY_TAX_V.ASSET_STATE%TYPE := OKC_API.G_MISS_CHAR

25: ,asset_address_2 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_2%TYPE := OKC_API.G_MISS_CHAR
26: ,asset_address_3 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_3%TYPE := OKC_API.G_MISS_CHAR
27: ,asset_address_4 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_4%TYPE := OKC_API.G_MISS_CHAR
28: ,asset_city OKL_PROPERTY_TAX_V.ASSET_CITY%TYPE := OKC_API.G_MISS_CHAR
29: ,asset_state OKL_PROPERTY_TAX_V.ASSET_STATE%TYPE := OKC_API.G_MISS_CHAR
30: ,asset_country OKL_PROPERTY_TAX_V.ASSET_COUNTRY%TYPE := OKC_API.G_MISS_CHAR
31: ,tax_assessment_amount NUMBER := OKC_API.G_MISS_NUM
32: ,tax_jurisdiction_city OKL_PROPERTY_TAX_V.TAX_JURISDICTION_CITY%TYPE := OKC_API.G_MISS_CHAR
33: -- End Addition for Est Property Tax

Line 30: ,asset_country OKL_PROPERTY_TAX_V.ASSET_COUNTRY%TYPE := OKC_API.G_MISS_CHAR

26: ,asset_address_3 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_3%TYPE := OKC_API.G_MISS_CHAR
27: ,asset_address_4 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_4%TYPE := OKC_API.G_MISS_CHAR
28: ,asset_city OKL_PROPERTY_TAX_V.ASSET_CITY%TYPE := OKC_API.G_MISS_CHAR
29: ,asset_state OKL_PROPERTY_TAX_V.ASSET_STATE%TYPE := OKC_API.G_MISS_CHAR
30: ,asset_country OKL_PROPERTY_TAX_V.ASSET_COUNTRY%TYPE := OKC_API.G_MISS_CHAR
31: ,tax_assessment_amount NUMBER := OKC_API.G_MISS_NUM
32: ,tax_jurisdiction_city OKL_PROPERTY_TAX_V.TAX_JURISDICTION_CITY%TYPE := OKC_API.G_MISS_CHAR
33: -- End Addition for Est Property Tax
34: ,JURSDCTN_TYPE OKL_PROPERTY_TAX_V.JURSDCTN_TYPE%TYPE := OKC_API.G_MISS_CHAR

Line 31: ,tax_assessment_amount NUMBER := OKC_API.G_MISS_NUM

27: ,asset_address_4 OKL_PROPERTY_TAX_V.ASSET_ADDRESS_4%TYPE := OKC_API.G_MISS_CHAR
28: ,asset_city OKL_PROPERTY_TAX_V.ASSET_CITY%TYPE := OKC_API.G_MISS_CHAR
29: ,asset_state OKL_PROPERTY_TAX_V.ASSET_STATE%TYPE := OKC_API.G_MISS_CHAR
30: ,asset_country OKL_PROPERTY_TAX_V.ASSET_COUNTRY%TYPE := OKC_API.G_MISS_CHAR
31: ,tax_assessment_amount NUMBER := OKC_API.G_MISS_NUM
32: ,tax_jurisdiction_city OKL_PROPERTY_TAX_V.TAX_JURISDICTION_CITY%TYPE := OKC_API.G_MISS_CHAR
33: -- End Addition for Est Property Tax
34: ,JURSDCTN_TYPE OKL_PROPERTY_TAX_V.JURSDCTN_TYPE%TYPE := OKC_API.G_MISS_CHAR
35: ,JURSDCTN_NAME OKL_PROPERTY_TAX_V.JURSDCTN_NAME%TYPE := OKC_API.G_MISS_CHAR

Line 32: ,tax_jurisdiction_city OKL_PROPERTY_TAX_V.TAX_JURISDICTION_CITY%TYPE := OKC_API.G_MISS_CHAR

28: ,asset_city OKL_PROPERTY_TAX_V.ASSET_CITY%TYPE := OKC_API.G_MISS_CHAR
29: ,asset_state OKL_PROPERTY_TAX_V.ASSET_STATE%TYPE := OKC_API.G_MISS_CHAR
30: ,asset_country OKL_PROPERTY_TAX_V.ASSET_COUNTRY%TYPE := OKC_API.G_MISS_CHAR
31: ,tax_assessment_amount NUMBER := OKC_API.G_MISS_NUM
32: ,tax_jurisdiction_city OKL_PROPERTY_TAX_V.TAX_JURISDICTION_CITY%TYPE := OKC_API.G_MISS_CHAR
33: -- End Addition for Est Property Tax
34: ,JURSDCTN_TYPE OKL_PROPERTY_TAX_V.JURSDCTN_TYPE%TYPE := OKC_API.G_MISS_CHAR
35: ,JURSDCTN_NAME OKL_PROPERTY_TAX_V.JURSDCTN_NAME%TYPE := OKC_API.G_MISS_CHAR
36: ,MLRT_TAX NUMBER := OKC_API.G_MISS_NUM

Line 34: ,JURSDCTN_TYPE OKL_PROPERTY_TAX_V.JURSDCTN_TYPE%TYPE := OKC_API.G_MISS_CHAR

30: ,asset_country OKL_PROPERTY_TAX_V.ASSET_COUNTRY%TYPE := OKC_API.G_MISS_CHAR
31: ,tax_assessment_amount NUMBER := OKC_API.G_MISS_NUM
32: ,tax_jurisdiction_city OKL_PROPERTY_TAX_V.TAX_JURISDICTION_CITY%TYPE := OKC_API.G_MISS_CHAR
33: -- End Addition for Est Property Tax
34: ,JURSDCTN_TYPE OKL_PROPERTY_TAX_V.JURSDCTN_TYPE%TYPE := OKC_API.G_MISS_CHAR
35: ,JURSDCTN_NAME OKL_PROPERTY_TAX_V.JURSDCTN_NAME%TYPE := OKC_API.G_MISS_CHAR
36: ,MLRT_TAX NUMBER := OKC_API.G_MISS_NUM
37: ,TAX_VENDOR_ID NUMBER := OKC_API.G_MISS_NUM
38: ,TAX_VENDOR_NAME OKL_PROPERTY_TAX_V.TAX_VENDOR_NAME%TYPE := OKC_API.G_MISS_CHAR

Line 35: ,JURSDCTN_NAME OKL_PROPERTY_TAX_V.JURSDCTN_NAME%TYPE := OKC_API.G_MISS_CHAR

31: ,tax_assessment_amount NUMBER := OKC_API.G_MISS_NUM
32: ,tax_jurisdiction_city OKL_PROPERTY_TAX_V.TAX_JURISDICTION_CITY%TYPE := OKC_API.G_MISS_CHAR
33: -- End Addition for Est Property Tax
34: ,JURSDCTN_TYPE OKL_PROPERTY_TAX_V.JURSDCTN_TYPE%TYPE := OKC_API.G_MISS_CHAR
35: ,JURSDCTN_NAME OKL_PROPERTY_TAX_V.JURSDCTN_NAME%TYPE := OKC_API.G_MISS_CHAR
36: ,MLRT_TAX NUMBER := OKC_API.G_MISS_NUM
37: ,TAX_VENDOR_ID NUMBER := OKC_API.G_MISS_NUM
38: ,TAX_VENDOR_NAME OKL_PROPERTY_TAX_V.TAX_VENDOR_NAME%TYPE := OKC_API.G_MISS_CHAR
39: ,TAX_VENDOR_SITE_ID NUMBER := OKC_API.G_MISS_NUM

Line 36: ,MLRT_TAX NUMBER := OKC_API.G_MISS_NUM

32: ,tax_jurisdiction_city OKL_PROPERTY_TAX_V.TAX_JURISDICTION_CITY%TYPE := OKC_API.G_MISS_CHAR
33: -- End Addition for Est Property Tax
34: ,JURSDCTN_TYPE OKL_PROPERTY_TAX_V.JURSDCTN_TYPE%TYPE := OKC_API.G_MISS_CHAR
35: ,JURSDCTN_NAME OKL_PROPERTY_TAX_V.JURSDCTN_NAME%TYPE := OKC_API.G_MISS_CHAR
36: ,MLRT_TAX NUMBER := OKC_API.G_MISS_NUM
37: ,TAX_VENDOR_ID NUMBER := OKC_API.G_MISS_NUM
38: ,TAX_VENDOR_NAME OKL_PROPERTY_TAX_V.TAX_VENDOR_NAME%TYPE := OKC_API.G_MISS_CHAR
39: ,TAX_VENDOR_SITE_ID NUMBER := OKC_API.G_MISS_NUM
40: ,TAX_VENDOR_SITE_NAME OKL_PROPERTY_TAX_V.TAX_VENDOR_SITE_NAME%TYPE := OKC_API.G_MISS_CHAR

Line 37: ,TAX_VENDOR_ID NUMBER := OKC_API.G_MISS_NUM

33: -- End Addition for Est Property Tax
34: ,JURSDCTN_TYPE OKL_PROPERTY_TAX_V.JURSDCTN_TYPE%TYPE := OKC_API.G_MISS_CHAR
35: ,JURSDCTN_NAME OKL_PROPERTY_TAX_V.JURSDCTN_NAME%TYPE := OKC_API.G_MISS_CHAR
36: ,MLRT_TAX NUMBER := OKC_API.G_MISS_NUM
37: ,TAX_VENDOR_ID NUMBER := OKC_API.G_MISS_NUM
38: ,TAX_VENDOR_NAME OKL_PROPERTY_TAX_V.TAX_VENDOR_NAME%TYPE := OKC_API.G_MISS_CHAR
39: ,TAX_VENDOR_SITE_ID NUMBER := OKC_API.G_MISS_NUM
40: ,TAX_VENDOR_SITE_NAME OKL_PROPERTY_TAX_V.TAX_VENDOR_SITE_NAME%TYPE := OKC_API.G_MISS_CHAR
41: -- End Addition for Est Property Tax

Line 38: ,TAX_VENDOR_NAME OKL_PROPERTY_TAX_V.TAX_VENDOR_NAME%TYPE := OKC_API.G_MISS_CHAR

34: ,JURSDCTN_TYPE OKL_PROPERTY_TAX_V.JURSDCTN_TYPE%TYPE := OKC_API.G_MISS_CHAR
35: ,JURSDCTN_NAME OKL_PROPERTY_TAX_V.JURSDCTN_NAME%TYPE := OKC_API.G_MISS_CHAR
36: ,MLRT_TAX NUMBER := OKC_API.G_MISS_NUM
37: ,TAX_VENDOR_ID NUMBER := OKC_API.G_MISS_NUM
38: ,TAX_VENDOR_NAME OKL_PROPERTY_TAX_V.TAX_VENDOR_NAME%TYPE := OKC_API.G_MISS_CHAR
39: ,TAX_VENDOR_SITE_ID NUMBER := OKC_API.G_MISS_NUM
40: ,TAX_VENDOR_SITE_NAME OKL_PROPERTY_TAX_V.TAX_VENDOR_SITE_NAME%TYPE := OKC_API.G_MISS_CHAR
41: -- End Addition for Est Property Tax
42: ,tax_jurisdiction_city_rate NUMBER := OKC_API.G_MISS_NUM

Line 39: ,TAX_VENDOR_SITE_ID NUMBER := OKC_API.G_MISS_NUM

35: ,JURSDCTN_NAME OKL_PROPERTY_TAX_V.JURSDCTN_NAME%TYPE := OKC_API.G_MISS_CHAR
36: ,MLRT_TAX NUMBER := OKC_API.G_MISS_NUM
37: ,TAX_VENDOR_ID NUMBER := OKC_API.G_MISS_NUM
38: ,TAX_VENDOR_NAME OKL_PROPERTY_TAX_V.TAX_VENDOR_NAME%TYPE := OKC_API.G_MISS_CHAR
39: ,TAX_VENDOR_SITE_ID NUMBER := OKC_API.G_MISS_NUM
40: ,TAX_VENDOR_SITE_NAME OKL_PROPERTY_TAX_V.TAX_VENDOR_SITE_NAME%TYPE := OKC_API.G_MISS_CHAR
41: -- End Addition for Est Property Tax
42: ,tax_jurisdiction_city_rate NUMBER := OKC_API.G_MISS_NUM
43: ,tax_jurisdiction_county OKL_PROPERTY_TAX_V.TAX_JURISDICTION_COUNTY%TYPE := OKC_API.G_MISS_CHAR

Line 40: ,TAX_VENDOR_SITE_NAME OKL_PROPERTY_TAX_V.TAX_VENDOR_SITE_NAME%TYPE := OKC_API.G_MISS_CHAR

36: ,MLRT_TAX NUMBER := OKC_API.G_MISS_NUM
37: ,TAX_VENDOR_ID NUMBER := OKC_API.G_MISS_NUM
38: ,TAX_VENDOR_NAME OKL_PROPERTY_TAX_V.TAX_VENDOR_NAME%TYPE := OKC_API.G_MISS_CHAR
39: ,TAX_VENDOR_SITE_ID NUMBER := OKC_API.G_MISS_NUM
40: ,TAX_VENDOR_SITE_NAME OKL_PROPERTY_TAX_V.TAX_VENDOR_SITE_NAME%TYPE := OKC_API.G_MISS_CHAR
41: -- End Addition for Est Property Tax
42: ,tax_jurisdiction_city_rate NUMBER := OKC_API.G_MISS_NUM
43: ,tax_jurisdiction_county OKL_PROPERTY_TAX_V.TAX_JURISDICTION_COUNTY%TYPE := OKC_API.G_MISS_CHAR
44: ,tax_jurisdiction_county_rate NUMBER := OKC_API.G_MISS_NUM

Line 42: ,tax_jurisdiction_city_rate NUMBER := OKC_API.G_MISS_NUM

38: ,TAX_VENDOR_NAME OKL_PROPERTY_TAX_V.TAX_VENDOR_NAME%TYPE := OKC_API.G_MISS_CHAR
39: ,TAX_VENDOR_SITE_ID NUMBER := OKC_API.G_MISS_NUM
40: ,TAX_VENDOR_SITE_NAME OKL_PROPERTY_TAX_V.TAX_VENDOR_SITE_NAME%TYPE := OKC_API.G_MISS_CHAR
41: -- End Addition for Est Property Tax
42: ,tax_jurisdiction_city_rate NUMBER := OKC_API.G_MISS_NUM
43: ,tax_jurisdiction_county OKL_PROPERTY_TAX_V.TAX_JURISDICTION_COUNTY%TYPE := OKC_API.G_MISS_CHAR
44: ,tax_jurisdiction_county_rate NUMBER := OKC_API.G_MISS_NUM
45: ,tax_jurisdiction_state OKL_PROPERTY_TAX_V.TAX_JURISDICTION_STATE%TYPE := OKC_API.G_MISS_CHAR
46: ,tax_jurisdiction_state_rate NUMBER := OKC_API.G_MISS_NUM

Line 43: ,tax_jurisdiction_county OKL_PROPERTY_TAX_V.TAX_JURISDICTION_COUNTY%TYPE := OKC_API.G_MISS_CHAR

39: ,TAX_VENDOR_SITE_ID NUMBER := OKC_API.G_MISS_NUM
40: ,TAX_VENDOR_SITE_NAME OKL_PROPERTY_TAX_V.TAX_VENDOR_SITE_NAME%TYPE := OKC_API.G_MISS_CHAR
41: -- End Addition for Est Property Tax
42: ,tax_jurisdiction_city_rate NUMBER := OKC_API.G_MISS_NUM
43: ,tax_jurisdiction_county OKL_PROPERTY_TAX_V.TAX_JURISDICTION_COUNTY%TYPE := OKC_API.G_MISS_CHAR
44: ,tax_jurisdiction_county_rate NUMBER := OKC_API.G_MISS_NUM
45: ,tax_jurisdiction_state OKL_PROPERTY_TAX_V.TAX_JURISDICTION_STATE%TYPE := OKC_API.G_MISS_CHAR
46: ,tax_jurisdiction_state_rate NUMBER := OKC_API.G_MISS_NUM
47: ,tax_jurisdiction_school OKL_PROPERTY_TAX_V.TAX_JURISDICTION_SCHOOL%TYPE := OKC_API.G_MISS_CHAR

Line 44: ,tax_jurisdiction_county_rate NUMBER := OKC_API.G_MISS_NUM

40: ,TAX_VENDOR_SITE_NAME OKL_PROPERTY_TAX_V.TAX_VENDOR_SITE_NAME%TYPE := OKC_API.G_MISS_CHAR
41: -- End Addition for Est Property Tax
42: ,tax_jurisdiction_city_rate NUMBER := OKC_API.G_MISS_NUM
43: ,tax_jurisdiction_county OKL_PROPERTY_TAX_V.TAX_JURISDICTION_COUNTY%TYPE := OKC_API.G_MISS_CHAR
44: ,tax_jurisdiction_county_rate NUMBER := OKC_API.G_MISS_NUM
45: ,tax_jurisdiction_state OKL_PROPERTY_TAX_V.TAX_JURISDICTION_STATE%TYPE := OKC_API.G_MISS_CHAR
46: ,tax_jurisdiction_state_rate NUMBER := OKC_API.G_MISS_NUM
47: ,tax_jurisdiction_school OKL_PROPERTY_TAX_V.TAX_JURISDICTION_SCHOOL%TYPE := OKC_API.G_MISS_CHAR
48: ,tax_jurisdiction_school_rate NUMBER := OKC_API.G_MISS_NUM

Line 45: ,tax_jurisdiction_state OKL_PROPERTY_TAX_V.TAX_JURISDICTION_STATE%TYPE := OKC_API.G_MISS_CHAR

41: -- End Addition for Est Property Tax
42: ,tax_jurisdiction_city_rate NUMBER := OKC_API.G_MISS_NUM
43: ,tax_jurisdiction_county OKL_PROPERTY_TAX_V.TAX_JURISDICTION_COUNTY%TYPE := OKC_API.G_MISS_CHAR
44: ,tax_jurisdiction_county_rate NUMBER := OKC_API.G_MISS_NUM
45: ,tax_jurisdiction_state OKL_PROPERTY_TAX_V.TAX_JURISDICTION_STATE%TYPE := OKC_API.G_MISS_CHAR
46: ,tax_jurisdiction_state_rate NUMBER := OKC_API.G_MISS_NUM
47: ,tax_jurisdiction_school OKL_PROPERTY_TAX_V.TAX_JURISDICTION_SCHOOL%TYPE := OKC_API.G_MISS_CHAR
48: ,tax_jurisdiction_school_rate NUMBER := OKC_API.G_MISS_NUM
49: ,tax_jurisdiction_country OKL_PROPERTY_TAX_V.TAX_JURISDICTION_COUNTRY%TYPE := OKC_API.G_MISS_CHAR

Line 46: ,tax_jurisdiction_state_rate NUMBER := OKC_API.G_MISS_NUM

42: ,tax_jurisdiction_city_rate NUMBER := OKC_API.G_MISS_NUM
43: ,tax_jurisdiction_county OKL_PROPERTY_TAX_V.TAX_JURISDICTION_COUNTY%TYPE := OKC_API.G_MISS_CHAR
44: ,tax_jurisdiction_county_rate NUMBER := OKC_API.G_MISS_NUM
45: ,tax_jurisdiction_state OKL_PROPERTY_TAX_V.TAX_JURISDICTION_STATE%TYPE := OKC_API.G_MISS_CHAR
46: ,tax_jurisdiction_state_rate NUMBER := OKC_API.G_MISS_NUM
47: ,tax_jurisdiction_school OKL_PROPERTY_TAX_V.TAX_JURISDICTION_SCHOOL%TYPE := OKC_API.G_MISS_CHAR
48: ,tax_jurisdiction_school_rate NUMBER := OKC_API.G_MISS_NUM
49: ,tax_jurisdiction_country OKL_PROPERTY_TAX_V.TAX_JURISDICTION_COUNTRY%TYPE := OKC_API.G_MISS_CHAR
50: ,tax_jurisdiction_country_rate NUMBER := OKC_API.G_MISS_NUM

Line 47: ,tax_jurisdiction_school OKL_PROPERTY_TAX_V.TAX_JURISDICTION_SCHOOL%TYPE := OKC_API.G_MISS_CHAR

43: ,tax_jurisdiction_county OKL_PROPERTY_TAX_V.TAX_JURISDICTION_COUNTY%TYPE := OKC_API.G_MISS_CHAR
44: ,tax_jurisdiction_county_rate NUMBER := OKC_API.G_MISS_NUM
45: ,tax_jurisdiction_state OKL_PROPERTY_TAX_V.TAX_JURISDICTION_STATE%TYPE := OKC_API.G_MISS_CHAR
46: ,tax_jurisdiction_state_rate NUMBER := OKC_API.G_MISS_NUM
47: ,tax_jurisdiction_school OKL_PROPERTY_TAX_V.TAX_JURISDICTION_SCHOOL%TYPE := OKC_API.G_MISS_CHAR
48: ,tax_jurisdiction_school_rate NUMBER := OKC_API.G_MISS_NUM
49: ,tax_jurisdiction_country OKL_PROPERTY_TAX_V.TAX_JURISDICTION_COUNTRY%TYPE := OKC_API.G_MISS_CHAR
50: ,tax_jurisdiction_country_rate NUMBER := OKC_API.G_MISS_NUM
51: ,tax_assessment_date OKL_PROPERTY_TAX_V.TAX_ASSESSMENT_DATE%TYPE := OKC_API.G_MISS_DATE

Line 48: ,tax_jurisdiction_school_rate NUMBER := OKC_API.G_MISS_NUM

44: ,tax_jurisdiction_county_rate NUMBER := OKC_API.G_MISS_NUM
45: ,tax_jurisdiction_state OKL_PROPERTY_TAX_V.TAX_JURISDICTION_STATE%TYPE := OKC_API.G_MISS_CHAR
46: ,tax_jurisdiction_state_rate NUMBER := OKC_API.G_MISS_NUM
47: ,tax_jurisdiction_school OKL_PROPERTY_TAX_V.TAX_JURISDICTION_SCHOOL%TYPE := OKC_API.G_MISS_CHAR
48: ,tax_jurisdiction_school_rate NUMBER := OKC_API.G_MISS_NUM
49: ,tax_jurisdiction_country OKL_PROPERTY_TAX_V.TAX_JURISDICTION_COUNTRY%TYPE := OKC_API.G_MISS_CHAR
50: ,tax_jurisdiction_country_rate NUMBER := OKC_API.G_MISS_NUM
51: ,tax_assessment_date OKL_PROPERTY_TAX_V.TAX_ASSESSMENT_DATE%TYPE := OKC_API.G_MISS_DATE
52: ,milrate NUMBER := OKC_API.G_MISS_NUM

Line 49: ,tax_jurisdiction_country OKL_PROPERTY_TAX_V.TAX_JURISDICTION_COUNTRY%TYPE := OKC_API.G_MISS_CHAR

45: ,tax_jurisdiction_state OKL_PROPERTY_TAX_V.TAX_JURISDICTION_STATE%TYPE := OKC_API.G_MISS_CHAR
46: ,tax_jurisdiction_state_rate NUMBER := OKC_API.G_MISS_NUM
47: ,tax_jurisdiction_school OKL_PROPERTY_TAX_V.TAX_JURISDICTION_SCHOOL%TYPE := OKC_API.G_MISS_CHAR
48: ,tax_jurisdiction_school_rate NUMBER := OKC_API.G_MISS_NUM
49: ,tax_jurisdiction_country OKL_PROPERTY_TAX_V.TAX_JURISDICTION_COUNTRY%TYPE := OKC_API.G_MISS_CHAR
50: ,tax_jurisdiction_country_rate NUMBER := OKC_API.G_MISS_NUM
51: ,tax_assessment_date OKL_PROPERTY_TAX_V.TAX_ASSESSMENT_DATE%TYPE := OKC_API.G_MISS_DATE
52: ,milrate NUMBER := OKC_API.G_MISS_NUM
53: ,property_tax_amount NUMBER := OKC_API.G_MISS_NUM

Line 50: ,tax_jurisdiction_country_rate NUMBER := OKC_API.G_MISS_NUM

46: ,tax_jurisdiction_state_rate NUMBER := OKC_API.G_MISS_NUM
47: ,tax_jurisdiction_school OKL_PROPERTY_TAX_V.TAX_JURISDICTION_SCHOOL%TYPE := OKC_API.G_MISS_CHAR
48: ,tax_jurisdiction_school_rate NUMBER := OKC_API.G_MISS_NUM
49: ,tax_jurisdiction_country OKL_PROPERTY_TAX_V.TAX_JURISDICTION_COUNTRY%TYPE := OKC_API.G_MISS_CHAR
50: ,tax_jurisdiction_country_rate NUMBER := OKC_API.G_MISS_NUM
51: ,tax_assessment_date OKL_PROPERTY_TAX_V.TAX_ASSESSMENT_DATE%TYPE := OKC_API.G_MISS_DATE
52: ,milrate NUMBER := OKC_API.G_MISS_NUM
53: ,property_tax_amount NUMBER := OKC_API.G_MISS_NUM
54: ,oec NUMBER := OKC_API.G_MISS_NUM

Line 51: ,tax_assessment_date OKL_PROPERTY_TAX_V.TAX_ASSESSMENT_DATE%TYPE := OKC_API.G_MISS_DATE

47: ,tax_jurisdiction_school OKL_PROPERTY_TAX_V.TAX_JURISDICTION_SCHOOL%TYPE := OKC_API.G_MISS_CHAR
48: ,tax_jurisdiction_school_rate NUMBER := OKC_API.G_MISS_NUM
49: ,tax_jurisdiction_country OKL_PROPERTY_TAX_V.TAX_JURISDICTION_COUNTRY%TYPE := OKC_API.G_MISS_CHAR
50: ,tax_jurisdiction_country_rate NUMBER := OKC_API.G_MISS_NUM
51: ,tax_assessment_date OKL_PROPERTY_TAX_V.TAX_ASSESSMENT_DATE%TYPE := OKC_API.G_MISS_DATE
52: ,milrate NUMBER := OKC_API.G_MISS_NUM
53: ,property_tax_amount NUMBER := OKC_API.G_MISS_NUM
54: ,oec NUMBER := OKC_API.G_MISS_NUM
55: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 52: ,milrate NUMBER := OKC_API.G_MISS_NUM

48: ,tax_jurisdiction_school_rate NUMBER := OKC_API.G_MISS_NUM
49: ,tax_jurisdiction_country OKL_PROPERTY_TAX_V.TAX_JURISDICTION_COUNTRY%TYPE := OKC_API.G_MISS_CHAR
50: ,tax_jurisdiction_country_rate NUMBER := OKC_API.G_MISS_NUM
51: ,tax_assessment_date OKL_PROPERTY_TAX_V.TAX_ASSESSMENT_DATE%TYPE := OKC_API.G_MISS_DATE
52: ,milrate NUMBER := OKC_API.G_MISS_NUM
53: ,property_tax_amount NUMBER := OKC_API.G_MISS_NUM
54: ,oec NUMBER := OKC_API.G_MISS_NUM
55: ,created_by NUMBER := OKC_API.G_MISS_NUM
56: ,creation_date OKL_PROPERTY_TAX_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 53: ,property_tax_amount NUMBER := OKC_API.G_MISS_NUM

49: ,tax_jurisdiction_country OKL_PROPERTY_TAX_V.TAX_JURISDICTION_COUNTRY%TYPE := OKC_API.G_MISS_CHAR
50: ,tax_jurisdiction_country_rate NUMBER := OKC_API.G_MISS_NUM
51: ,tax_assessment_date OKL_PROPERTY_TAX_V.TAX_ASSESSMENT_DATE%TYPE := OKC_API.G_MISS_DATE
52: ,milrate NUMBER := OKC_API.G_MISS_NUM
53: ,property_tax_amount NUMBER := OKC_API.G_MISS_NUM
54: ,oec NUMBER := OKC_API.G_MISS_NUM
55: ,created_by NUMBER := OKC_API.G_MISS_NUM
56: ,creation_date OKL_PROPERTY_TAX_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 54: ,oec NUMBER := OKC_API.G_MISS_NUM

50: ,tax_jurisdiction_country_rate NUMBER := OKC_API.G_MISS_NUM
51: ,tax_assessment_date OKL_PROPERTY_TAX_V.TAX_ASSESSMENT_DATE%TYPE := OKC_API.G_MISS_DATE
52: ,milrate NUMBER := OKC_API.G_MISS_NUM
53: ,property_tax_amount NUMBER := OKC_API.G_MISS_NUM
54: ,oec NUMBER := OKC_API.G_MISS_NUM
55: ,created_by NUMBER := OKC_API.G_MISS_NUM
56: ,creation_date OKL_PROPERTY_TAX_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
58: ,last_update_date OKL_PROPERTY_TAX_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 55: ,created_by NUMBER := OKC_API.G_MISS_NUM

51: ,tax_assessment_date OKL_PROPERTY_TAX_V.TAX_ASSESSMENT_DATE%TYPE := OKC_API.G_MISS_DATE
52: ,milrate NUMBER := OKC_API.G_MISS_NUM
53: ,property_tax_amount NUMBER := OKC_API.G_MISS_NUM
54: ,oec NUMBER := OKC_API.G_MISS_NUM
55: ,created_by NUMBER := OKC_API.G_MISS_NUM
56: ,creation_date OKL_PROPERTY_TAX_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
58: ,last_update_date OKL_PROPERTY_TAX_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
59: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);

Line 56: ,creation_date OKL_PROPERTY_TAX_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

52: ,milrate NUMBER := OKC_API.G_MISS_NUM
53: ,property_tax_amount NUMBER := OKC_API.G_MISS_NUM
54: ,oec NUMBER := OKC_API.G_MISS_NUM
55: ,created_by NUMBER := OKC_API.G_MISS_NUM
56: ,creation_date OKL_PROPERTY_TAX_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
58: ,last_update_date OKL_PROPERTY_TAX_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
59: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
60: G_MISS_ptcv_rec ptcv_rec_type;

Line 57: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

53: ,property_tax_amount NUMBER := OKC_API.G_MISS_NUM
54: ,oec NUMBER := OKC_API.G_MISS_NUM
55: ,created_by NUMBER := OKC_API.G_MISS_NUM
56: ,creation_date OKL_PROPERTY_TAX_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
58: ,last_update_date OKL_PROPERTY_TAX_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
59: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
60: G_MISS_ptcv_rec ptcv_rec_type;
61: TYPE ptcv_tbl_type IS TABLE OF ptcv_rec_type

Line 58: ,last_update_date OKL_PROPERTY_TAX_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

54: ,oec NUMBER := OKC_API.G_MISS_NUM
55: ,created_by NUMBER := OKC_API.G_MISS_NUM
56: ,creation_date OKL_PROPERTY_TAX_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
58: ,last_update_date OKL_PROPERTY_TAX_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
59: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
60: G_MISS_ptcv_rec ptcv_rec_type;
61: TYPE ptcv_tbl_type IS TABLE OF ptcv_rec_type
62: INDEX BY BINARY_INTEGER;

Line 59: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);

55: ,created_by NUMBER := OKC_API.G_MISS_NUM
56: ,creation_date OKL_PROPERTY_TAX_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
58: ,last_update_date OKL_PROPERTY_TAX_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
59: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
60: G_MISS_ptcv_rec ptcv_rec_type;
61: TYPE ptcv_tbl_type IS TABLE OF ptcv_rec_type
62: INDEX BY BINARY_INTEGER;
63: TYPE ptc_rec_type IS RECORD (

Line 64: id NUMBER := OKC_API.G_MISS_NUM

60: G_MISS_ptcv_rec ptcv_rec_type;
61: TYPE ptcv_tbl_type IS TABLE OF ptcv_rec_type
62: INDEX BY BINARY_INTEGER;
63: TYPE ptc_rec_type IS RECORD (
64: id NUMBER := OKC_API.G_MISS_NUM
65: ,sequence_number NUMBER := OKC_API.G_MISS_NUM
66: ,asset_id NUMBER := OKC_API.G_MISS_NUM
67: ,asset_number OKL_PROPERTY_TAX_B.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
68: ,khr_id NUMBER := OKC_API.G_MISS_NUM

Line 65: ,sequence_number NUMBER := OKC_API.G_MISS_NUM

61: TYPE ptcv_tbl_type IS TABLE OF ptcv_rec_type
62: INDEX BY BINARY_INTEGER;
63: TYPE ptc_rec_type IS RECORD (
64: id NUMBER := OKC_API.G_MISS_NUM
65: ,sequence_number NUMBER := OKC_API.G_MISS_NUM
66: ,asset_id NUMBER := OKC_API.G_MISS_NUM
67: ,asset_number OKL_PROPERTY_TAX_B.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
68: ,khr_id NUMBER := OKC_API.G_MISS_NUM
69: ,kle_id NUMBER := OKC_API.G_MISS_NUM

Line 66: ,asset_id NUMBER := OKC_API.G_MISS_NUM

62: INDEX BY BINARY_INTEGER;
63: TYPE ptc_rec_type IS RECORD (
64: id NUMBER := OKC_API.G_MISS_NUM
65: ,sequence_number NUMBER := OKC_API.G_MISS_NUM
66: ,asset_id NUMBER := OKC_API.G_MISS_NUM
67: ,asset_number OKL_PROPERTY_TAX_B.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
68: ,khr_id NUMBER := OKC_API.G_MISS_NUM
69: ,kle_id NUMBER := OKC_API.G_MISS_NUM
70: ,asset_units NUMBER := OKC_API.G_MISS_NUM

Line 67: ,asset_number OKL_PROPERTY_TAX_B.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR

63: TYPE ptc_rec_type IS RECORD (
64: id NUMBER := OKC_API.G_MISS_NUM
65: ,sequence_number NUMBER := OKC_API.G_MISS_NUM
66: ,asset_id NUMBER := OKC_API.G_MISS_NUM
67: ,asset_number OKL_PROPERTY_TAX_B.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
68: ,khr_id NUMBER := OKC_API.G_MISS_NUM
69: ,kle_id NUMBER := OKC_API.G_MISS_NUM
70: ,asset_units NUMBER := OKC_API.G_MISS_NUM
71: ,asset_address_1 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_1%TYPE := OKC_API.G_MISS_CHAR

Line 68: ,khr_id NUMBER := OKC_API.G_MISS_NUM

64: id NUMBER := OKC_API.G_MISS_NUM
65: ,sequence_number NUMBER := OKC_API.G_MISS_NUM
66: ,asset_id NUMBER := OKC_API.G_MISS_NUM
67: ,asset_number OKL_PROPERTY_TAX_B.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
68: ,khr_id NUMBER := OKC_API.G_MISS_NUM
69: ,kle_id NUMBER := OKC_API.G_MISS_NUM
70: ,asset_units NUMBER := OKC_API.G_MISS_NUM
71: ,asset_address_1 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_1%TYPE := OKC_API.G_MISS_CHAR
72: ,asset_address_2 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_2%TYPE := OKC_API.G_MISS_CHAR

Line 69: ,kle_id NUMBER := OKC_API.G_MISS_NUM

65: ,sequence_number NUMBER := OKC_API.G_MISS_NUM
66: ,asset_id NUMBER := OKC_API.G_MISS_NUM
67: ,asset_number OKL_PROPERTY_TAX_B.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
68: ,khr_id NUMBER := OKC_API.G_MISS_NUM
69: ,kle_id NUMBER := OKC_API.G_MISS_NUM
70: ,asset_units NUMBER := OKC_API.G_MISS_NUM
71: ,asset_address_1 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_1%TYPE := OKC_API.G_MISS_CHAR
72: ,asset_address_2 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_2%TYPE := OKC_API.G_MISS_CHAR
73: ,asset_address_3 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_3%TYPE := OKC_API.G_MISS_CHAR

Line 70: ,asset_units NUMBER := OKC_API.G_MISS_NUM

66: ,asset_id NUMBER := OKC_API.G_MISS_NUM
67: ,asset_number OKL_PROPERTY_TAX_B.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
68: ,khr_id NUMBER := OKC_API.G_MISS_NUM
69: ,kle_id NUMBER := OKC_API.G_MISS_NUM
70: ,asset_units NUMBER := OKC_API.G_MISS_NUM
71: ,asset_address_1 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_1%TYPE := OKC_API.G_MISS_CHAR
72: ,asset_address_2 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_2%TYPE := OKC_API.G_MISS_CHAR
73: ,asset_address_3 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_3%TYPE := OKC_API.G_MISS_CHAR
74: ,asset_address_4 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_4%TYPE := OKC_API.G_MISS_CHAR

Line 71: ,asset_address_1 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_1%TYPE := OKC_API.G_MISS_CHAR

67: ,asset_number OKL_PROPERTY_TAX_B.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
68: ,khr_id NUMBER := OKC_API.G_MISS_NUM
69: ,kle_id NUMBER := OKC_API.G_MISS_NUM
70: ,asset_units NUMBER := OKC_API.G_MISS_NUM
71: ,asset_address_1 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_1%TYPE := OKC_API.G_MISS_CHAR
72: ,asset_address_2 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_2%TYPE := OKC_API.G_MISS_CHAR
73: ,asset_address_3 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_3%TYPE := OKC_API.G_MISS_CHAR
74: ,asset_address_4 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_4%TYPE := OKC_API.G_MISS_CHAR
75: ,asset_city OKL_PROPERTY_TAX_B.ASSET_CITY%TYPE := OKC_API.G_MISS_CHAR

Line 72: ,asset_address_2 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_2%TYPE := OKC_API.G_MISS_CHAR

68: ,khr_id NUMBER := OKC_API.G_MISS_NUM
69: ,kle_id NUMBER := OKC_API.G_MISS_NUM
70: ,asset_units NUMBER := OKC_API.G_MISS_NUM
71: ,asset_address_1 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_1%TYPE := OKC_API.G_MISS_CHAR
72: ,asset_address_2 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_2%TYPE := OKC_API.G_MISS_CHAR
73: ,asset_address_3 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_3%TYPE := OKC_API.G_MISS_CHAR
74: ,asset_address_4 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_4%TYPE := OKC_API.G_MISS_CHAR
75: ,asset_city OKL_PROPERTY_TAX_B.ASSET_CITY%TYPE := OKC_API.G_MISS_CHAR
76: ,asset_state OKL_PROPERTY_TAX_B.ASSET_STATE%TYPE := OKC_API.G_MISS_CHAR

Line 73: ,asset_address_3 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_3%TYPE := OKC_API.G_MISS_CHAR

69: ,kle_id NUMBER := OKC_API.G_MISS_NUM
70: ,asset_units NUMBER := OKC_API.G_MISS_NUM
71: ,asset_address_1 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_1%TYPE := OKC_API.G_MISS_CHAR
72: ,asset_address_2 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_2%TYPE := OKC_API.G_MISS_CHAR
73: ,asset_address_3 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_3%TYPE := OKC_API.G_MISS_CHAR
74: ,asset_address_4 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_4%TYPE := OKC_API.G_MISS_CHAR
75: ,asset_city OKL_PROPERTY_TAX_B.ASSET_CITY%TYPE := OKC_API.G_MISS_CHAR
76: ,asset_state OKL_PROPERTY_TAX_B.ASSET_STATE%TYPE := OKC_API.G_MISS_CHAR
77: ,asset_country OKL_PROPERTY_TAX_B.ASSET_COUNTRY%TYPE := OKC_API.G_MISS_CHAR

Line 74: ,asset_address_4 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_4%TYPE := OKC_API.G_MISS_CHAR

70: ,asset_units NUMBER := OKC_API.G_MISS_NUM
71: ,asset_address_1 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_1%TYPE := OKC_API.G_MISS_CHAR
72: ,asset_address_2 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_2%TYPE := OKC_API.G_MISS_CHAR
73: ,asset_address_3 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_3%TYPE := OKC_API.G_MISS_CHAR
74: ,asset_address_4 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_4%TYPE := OKC_API.G_MISS_CHAR
75: ,asset_city OKL_PROPERTY_TAX_B.ASSET_CITY%TYPE := OKC_API.G_MISS_CHAR
76: ,asset_state OKL_PROPERTY_TAX_B.ASSET_STATE%TYPE := OKC_API.G_MISS_CHAR
77: ,asset_country OKL_PROPERTY_TAX_B.ASSET_COUNTRY%TYPE := OKC_API.G_MISS_CHAR
78: ,tax_assessment_amount NUMBER := OKC_API.G_MISS_NUM

Line 75: ,asset_city OKL_PROPERTY_TAX_B.ASSET_CITY%TYPE := OKC_API.G_MISS_CHAR

71: ,asset_address_1 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_1%TYPE := OKC_API.G_MISS_CHAR
72: ,asset_address_2 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_2%TYPE := OKC_API.G_MISS_CHAR
73: ,asset_address_3 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_3%TYPE := OKC_API.G_MISS_CHAR
74: ,asset_address_4 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_4%TYPE := OKC_API.G_MISS_CHAR
75: ,asset_city OKL_PROPERTY_TAX_B.ASSET_CITY%TYPE := OKC_API.G_MISS_CHAR
76: ,asset_state OKL_PROPERTY_TAX_B.ASSET_STATE%TYPE := OKC_API.G_MISS_CHAR
77: ,asset_country OKL_PROPERTY_TAX_B.ASSET_COUNTRY%TYPE := OKC_API.G_MISS_CHAR
78: ,tax_assessment_amount NUMBER := OKC_API.G_MISS_NUM
79: ,tax_jurisdiction_city OKL_PROPERTY_TAX_B.TAX_JURISDICTION_CITY%TYPE := OKC_API.G_MISS_CHAR

Line 76: ,asset_state OKL_PROPERTY_TAX_B.ASSET_STATE%TYPE := OKC_API.G_MISS_CHAR

72: ,asset_address_2 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_2%TYPE := OKC_API.G_MISS_CHAR
73: ,asset_address_3 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_3%TYPE := OKC_API.G_MISS_CHAR
74: ,asset_address_4 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_4%TYPE := OKC_API.G_MISS_CHAR
75: ,asset_city OKL_PROPERTY_TAX_B.ASSET_CITY%TYPE := OKC_API.G_MISS_CHAR
76: ,asset_state OKL_PROPERTY_TAX_B.ASSET_STATE%TYPE := OKC_API.G_MISS_CHAR
77: ,asset_country OKL_PROPERTY_TAX_B.ASSET_COUNTRY%TYPE := OKC_API.G_MISS_CHAR
78: ,tax_assessment_amount NUMBER := OKC_API.G_MISS_NUM
79: ,tax_jurisdiction_city OKL_PROPERTY_TAX_B.TAX_JURISDICTION_CITY%TYPE := OKC_API.G_MISS_CHAR
80: -- Addition for Est Property Tax

Line 77: ,asset_country OKL_PROPERTY_TAX_B.ASSET_COUNTRY%TYPE := OKC_API.G_MISS_CHAR

73: ,asset_address_3 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_3%TYPE := OKC_API.G_MISS_CHAR
74: ,asset_address_4 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_4%TYPE := OKC_API.G_MISS_CHAR
75: ,asset_city OKL_PROPERTY_TAX_B.ASSET_CITY%TYPE := OKC_API.G_MISS_CHAR
76: ,asset_state OKL_PROPERTY_TAX_B.ASSET_STATE%TYPE := OKC_API.G_MISS_CHAR
77: ,asset_country OKL_PROPERTY_TAX_B.ASSET_COUNTRY%TYPE := OKC_API.G_MISS_CHAR
78: ,tax_assessment_amount NUMBER := OKC_API.G_MISS_NUM
79: ,tax_jurisdiction_city OKL_PROPERTY_TAX_B.TAX_JURISDICTION_CITY%TYPE := OKC_API.G_MISS_CHAR
80: -- Addition for Est Property Tax
81: ,JURSDCTN_TYPE OKL_PROPERTY_TAX_B.JURSDCTN_TYPE%TYPE := OKC_API.G_MISS_CHAR

Line 78: ,tax_assessment_amount NUMBER := OKC_API.G_MISS_NUM

74: ,asset_address_4 OKL_PROPERTY_TAX_B.ASSET_ADDRESS_4%TYPE := OKC_API.G_MISS_CHAR
75: ,asset_city OKL_PROPERTY_TAX_B.ASSET_CITY%TYPE := OKC_API.G_MISS_CHAR
76: ,asset_state OKL_PROPERTY_TAX_B.ASSET_STATE%TYPE := OKC_API.G_MISS_CHAR
77: ,asset_country OKL_PROPERTY_TAX_B.ASSET_COUNTRY%TYPE := OKC_API.G_MISS_CHAR
78: ,tax_assessment_amount NUMBER := OKC_API.G_MISS_NUM
79: ,tax_jurisdiction_city OKL_PROPERTY_TAX_B.TAX_JURISDICTION_CITY%TYPE := OKC_API.G_MISS_CHAR
80: -- Addition for Est Property Tax
81: ,JURSDCTN_TYPE OKL_PROPERTY_TAX_B.JURSDCTN_TYPE%TYPE := OKC_API.G_MISS_CHAR
82: ,JURSDCTN_NAME OKL_PROPERTY_TAX_B.JURSDCTN_NAME%TYPE := OKC_API.G_MISS_CHAR

Line 79: ,tax_jurisdiction_city OKL_PROPERTY_TAX_B.TAX_JURISDICTION_CITY%TYPE := OKC_API.G_MISS_CHAR

75: ,asset_city OKL_PROPERTY_TAX_B.ASSET_CITY%TYPE := OKC_API.G_MISS_CHAR
76: ,asset_state OKL_PROPERTY_TAX_B.ASSET_STATE%TYPE := OKC_API.G_MISS_CHAR
77: ,asset_country OKL_PROPERTY_TAX_B.ASSET_COUNTRY%TYPE := OKC_API.G_MISS_CHAR
78: ,tax_assessment_amount NUMBER := OKC_API.G_MISS_NUM
79: ,tax_jurisdiction_city OKL_PROPERTY_TAX_B.TAX_JURISDICTION_CITY%TYPE := OKC_API.G_MISS_CHAR
80: -- Addition for Est Property Tax
81: ,JURSDCTN_TYPE OKL_PROPERTY_TAX_B.JURSDCTN_TYPE%TYPE := OKC_API.G_MISS_CHAR
82: ,JURSDCTN_NAME OKL_PROPERTY_TAX_B.JURSDCTN_NAME%TYPE := OKC_API.G_MISS_CHAR
83: ,MLRT_TAX NUMBER := OKC_API.G_MISS_NUM

Line 81: ,JURSDCTN_TYPE OKL_PROPERTY_TAX_B.JURSDCTN_TYPE%TYPE := OKC_API.G_MISS_CHAR

77: ,asset_country OKL_PROPERTY_TAX_B.ASSET_COUNTRY%TYPE := OKC_API.G_MISS_CHAR
78: ,tax_assessment_amount NUMBER := OKC_API.G_MISS_NUM
79: ,tax_jurisdiction_city OKL_PROPERTY_TAX_B.TAX_JURISDICTION_CITY%TYPE := OKC_API.G_MISS_CHAR
80: -- Addition for Est Property Tax
81: ,JURSDCTN_TYPE OKL_PROPERTY_TAX_B.JURSDCTN_TYPE%TYPE := OKC_API.G_MISS_CHAR
82: ,JURSDCTN_NAME OKL_PROPERTY_TAX_B.JURSDCTN_NAME%TYPE := OKC_API.G_MISS_CHAR
83: ,MLRT_TAX NUMBER := OKC_API.G_MISS_NUM
84: ,TAX_VENDOR_ID NUMBER := OKC_API.G_MISS_NUM
85: ,TAX_VENDOR_NAME OKL_PROPERTY_TAX_B.TAX_VENDOR_NAME%TYPE := OKC_API.G_MISS_CHAR

Line 82: ,JURSDCTN_NAME OKL_PROPERTY_TAX_B.JURSDCTN_NAME%TYPE := OKC_API.G_MISS_CHAR

78: ,tax_assessment_amount NUMBER := OKC_API.G_MISS_NUM
79: ,tax_jurisdiction_city OKL_PROPERTY_TAX_B.TAX_JURISDICTION_CITY%TYPE := OKC_API.G_MISS_CHAR
80: -- Addition for Est Property Tax
81: ,JURSDCTN_TYPE OKL_PROPERTY_TAX_B.JURSDCTN_TYPE%TYPE := OKC_API.G_MISS_CHAR
82: ,JURSDCTN_NAME OKL_PROPERTY_TAX_B.JURSDCTN_NAME%TYPE := OKC_API.G_MISS_CHAR
83: ,MLRT_TAX NUMBER := OKC_API.G_MISS_NUM
84: ,TAX_VENDOR_ID NUMBER := OKC_API.G_MISS_NUM
85: ,TAX_VENDOR_NAME OKL_PROPERTY_TAX_B.TAX_VENDOR_NAME%TYPE := OKC_API.G_MISS_CHAR
86: ,TAX_VENDOR_SITE_ID NUMBER := OKC_API.G_MISS_NUM

Line 83: ,MLRT_TAX NUMBER := OKC_API.G_MISS_NUM

79: ,tax_jurisdiction_city OKL_PROPERTY_TAX_B.TAX_JURISDICTION_CITY%TYPE := OKC_API.G_MISS_CHAR
80: -- Addition for Est Property Tax
81: ,JURSDCTN_TYPE OKL_PROPERTY_TAX_B.JURSDCTN_TYPE%TYPE := OKC_API.G_MISS_CHAR
82: ,JURSDCTN_NAME OKL_PROPERTY_TAX_B.JURSDCTN_NAME%TYPE := OKC_API.G_MISS_CHAR
83: ,MLRT_TAX NUMBER := OKC_API.G_MISS_NUM
84: ,TAX_VENDOR_ID NUMBER := OKC_API.G_MISS_NUM
85: ,TAX_VENDOR_NAME OKL_PROPERTY_TAX_B.TAX_VENDOR_NAME%TYPE := OKC_API.G_MISS_CHAR
86: ,TAX_VENDOR_SITE_ID NUMBER := OKC_API.G_MISS_NUM
87: ,TAX_VENDOR_SITE_NAME OKL_PROPERTY_TAX_B.TAX_VENDOR_SITE_NAME%TYPE := OKC_API.G_MISS_CHAR

Line 84: ,TAX_VENDOR_ID NUMBER := OKC_API.G_MISS_NUM

80: -- Addition for Est Property Tax
81: ,JURSDCTN_TYPE OKL_PROPERTY_TAX_B.JURSDCTN_TYPE%TYPE := OKC_API.G_MISS_CHAR
82: ,JURSDCTN_NAME OKL_PROPERTY_TAX_B.JURSDCTN_NAME%TYPE := OKC_API.G_MISS_CHAR
83: ,MLRT_TAX NUMBER := OKC_API.G_MISS_NUM
84: ,TAX_VENDOR_ID NUMBER := OKC_API.G_MISS_NUM
85: ,TAX_VENDOR_NAME OKL_PROPERTY_TAX_B.TAX_VENDOR_NAME%TYPE := OKC_API.G_MISS_CHAR
86: ,TAX_VENDOR_SITE_ID NUMBER := OKC_API.G_MISS_NUM
87: ,TAX_VENDOR_SITE_NAME OKL_PROPERTY_TAX_B.TAX_VENDOR_SITE_NAME%TYPE := OKC_API.G_MISS_CHAR
88: -- End Addition for Est Property Tax

Line 85: ,TAX_VENDOR_NAME OKL_PROPERTY_TAX_B.TAX_VENDOR_NAME%TYPE := OKC_API.G_MISS_CHAR

81: ,JURSDCTN_TYPE OKL_PROPERTY_TAX_B.JURSDCTN_TYPE%TYPE := OKC_API.G_MISS_CHAR
82: ,JURSDCTN_NAME OKL_PROPERTY_TAX_B.JURSDCTN_NAME%TYPE := OKC_API.G_MISS_CHAR
83: ,MLRT_TAX NUMBER := OKC_API.G_MISS_NUM
84: ,TAX_VENDOR_ID NUMBER := OKC_API.G_MISS_NUM
85: ,TAX_VENDOR_NAME OKL_PROPERTY_TAX_B.TAX_VENDOR_NAME%TYPE := OKC_API.G_MISS_CHAR
86: ,TAX_VENDOR_SITE_ID NUMBER := OKC_API.G_MISS_NUM
87: ,TAX_VENDOR_SITE_NAME OKL_PROPERTY_TAX_B.TAX_VENDOR_SITE_NAME%TYPE := OKC_API.G_MISS_CHAR
88: -- End Addition for Est Property Tax
89: ,tax_jurisdiction_city_rate NUMBER := OKC_API.G_MISS_NUM

Line 86: ,TAX_VENDOR_SITE_ID NUMBER := OKC_API.G_MISS_NUM

82: ,JURSDCTN_NAME OKL_PROPERTY_TAX_B.JURSDCTN_NAME%TYPE := OKC_API.G_MISS_CHAR
83: ,MLRT_TAX NUMBER := OKC_API.G_MISS_NUM
84: ,TAX_VENDOR_ID NUMBER := OKC_API.G_MISS_NUM
85: ,TAX_VENDOR_NAME OKL_PROPERTY_TAX_B.TAX_VENDOR_NAME%TYPE := OKC_API.G_MISS_CHAR
86: ,TAX_VENDOR_SITE_ID NUMBER := OKC_API.G_MISS_NUM
87: ,TAX_VENDOR_SITE_NAME OKL_PROPERTY_TAX_B.TAX_VENDOR_SITE_NAME%TYPE := OKC_API.G_MISS_CHAR
88: -- End Addition for Est Property Tax
89: ,tax_jurisdiction_city_rate NUMBER := OKC_API.G_MISS_NUM
90: ,tax_jurisdiction_county OKL_PROPERTY_TAX_B.TAX_JURISDICTION_COUNTY%TYPE := OKC_API.G_MISS_CHAR

Line 87: ,TAX_VENDOR_SITE_NAME OKL_PROPERTY_TAX_B.TAX_VENDOR_SITE_NAME%TYPE := OKC_API.G_MISS_CHAR

83: ,MLRT_TAX NUMBER := OKC_API.G_MISS_NUM
84: ,TAX_VENDOR_ID NUMBER := OKC_API.G_MISS_NUM
85: ,TAX_VENDOR_NAME OKL_PROPERTY_TAX_B.TAX_VENDOR_NAME%TYPE := OKC_API.G_MISS_CHAR
86: ,TAX_VENDOR_SITE_ID NUMBER := OKC_API.G_MISS_NUM
87: ,TAX_VENDOR_SITE_NAME OKL_PROPERTY_TAX_B.TAX_VENDOR_SITE_NAME%TYPE := OKC_API.G_MISS_CHAR
88: -- End Addition for Est Property Tax
89: ,tax_jurisdiction_city_rate NUMBER := OKC_API.G_MISS_NUM
90: ,tax_jurisdiction_county OKL_PROPERTY_TAX_B.TAX_JURISDICTION_COUNTY%TYPE := OKC_API.G_MISS_CHAR
91: ,tax_jurisdiction_county_rate NUMBER := OKC_API.G_MISS_NUM

Line 89: ,tax_jurisdiction_city_rate NUMBER := OKC_API.G_MISS_NUM

85: ,TAX_VENDOR_NAME OKL_PROPERTY_TAX_B.TAX_VENDOR_NAME%TYPE := OKC_API.G_MISS_CHAR
86: ,TAX_VENDOR_SITE_ID NUMBER := OKC_API.G_MISS_NUM
87: ,TAX_VENDOR_SITE_NAME OKL_PROPERTY_TAX_B.TAX_VENDOR_SITE_NAME%TYPE := OKC_API.G_MISS_CHAR
88: -- End Addition for Est Property Tax
89: ,tax_jurisdiction_city_rate NUMBER := OKC_API.G_MISS_NUM
90: ,tax_jurisdiction_county OKL_PROPERTY_TAX_B.TAX_JURISDICTION_COUNTY%TYPE := OKC_API.G_MISS_CHAR
91: ,tax_jurisdiction_county_rate NUMBER := OKC_API.G_MISS_NUM
92: ,tax_jurisdiction_state OKL_PROPERTY_TAX_B.TAX_JURISDICTION_STATE%TYPE := OKC_API.G_MISS_CHAR
93: ,tax_jurisdiction_state_rate NUMBER := OKC_API.G_MISS_NUM

Line 90: ,tax_jurisdiction_county OKL_PROPERTY_TAX_B.TAX_JURISDICTION_COUNTY%TYPE := OKC_API.G_MISS_CHAR

86: ,TAX_VENDOR_SITE_ID NUMBER := OKC_API.G_MISS_NUM
87: ,TAX_VENDOR_SITE_NAME OKL_PROPERTY_TAX_B.TAX_VENDOR_SITE_NAME%TYPE := OKC_API.G_MISS_CHAR
88: -- End Addition for Est Property Tax
89: ,tax_jurisdiction_city_rate NUMBER := OKC_API.G_MISS_NUM
90: ,tax_jurisdiction_county OKL_PROPERTY_TAX_B.TAX_JURISDICTION_COUNTY%TYPE := OKC_API.G_MISS_CHAR
91: ,tax_jurisdiction_county_rate NUMBER := OKC_API.G_MISS_NUM
92: ,tax_jurisdiction_state OKL_PROPERTY_TAX_B.TAX_JURISDICTION_STATE%TYPE := OKC_API.G_MISS_CHAR
93: ,tax_jurisdiction_state_rate NUMBER := OKC_API.G_MISS_NUM
94: ,tax_jurisdiction_school OKL_PROPERTY_TAX_B.TAX_JURISDICTION_SCHOOL%TYPE := OKC_API.G_MISS_CHAR

Line 91: ,tax_jurisdiction_county_rate NUMBER := OKC_API.G_MISS_NUM

87: ,TAX_VENDOR_SITE_NAME OKL_PROPERTY_TAX_B.TAX_VENDOR_SITE_NAME%TYPE := OKC_API.G_MISS_CHAR
88: -- End Addition for Est Property Tax
89: ,tax_jurisdiction_city_rate NUMBER := OKC_API.G_MISS_NUM
90: ,tax_jurisdiction_county OKL_PROPERTY_TAX_B.TAX_JURISDICTION_COUNTY%TYPE := OKC_API.G_MISS_CHAR
91: ,tax_jurisdiction_county_rate NUMBER := OKC_API.G_MISS_NUM
92: ,tax_jurisdiction_state OKL_PROPERTY_TAX_B.TAX_JURISDICTION_STATE%TYPE := OKC_API.G_MISS_CHAR
93: ,tax_jurisdiction_state_rate NUMBER := OKC_API.G_MISS_NUM
94: ,tax_jurisdiction_school OKL_PROPERTY_TAX_B.TAX_JURISDICTION_SCHOOL%TYPE := OKC_API.G_MISS_CHAR
95: ,tax_jurisdiction_school_rate NUMBER := OKC_API.G_MISS_NUM

Line 92: ,tax_jurisdiction_state OKL_PROPERTY_TAX_B.TAX_JURISDICTION_STATE%TYPE := OKC_API.G_MISS_CHAR

88: -- End Addition for Est Property Tax
89: ,tax_jurisdiction_city_rate NUMBER := OKC_API.G_MISS_NUM
90: ,tax_jurisdiction_county OKL_PROPERTY_TAX_B.TAX_JURISDICTION_COUNTY%TYPE := OKC_API.G_MISS_CHAR
91: ,tax_jurisdiction_county_rate NUMBER := OKC_API.G_MISS_NUM
92: ,tax_jurisdiction_state OKL_PROPERTY_TAX_B.TAX_JURISDICTION_STATE%TYPE := OKC_API.G_MISS_CHAR
93: ,tax_jurisdiction_state_rate NUMBER := OKC_API.G_MISS_NUM
94: ,tax_jurisdiction_school OKL_PROPERTY_TAX_B.TAX_JURISDICTION_SCHOOL%TYPE := OKC_API.G_MISS_CHAR
95: ,tax_jurisdiction_school_rate NUMBER := OKC_API.G_MISS_NUM
96: ,tax_jurisdiction_country OKL_PROPERTY_TAX_B.TAX_JURISDICTION_COUNTRY%TYPE := OKC_API.G_MISS_CHAR

Line 93: ,tax_jurisdiction_state_rate NUMBER := OKC_API.G_MISS_NUM

89: ,tax_jurisdiction_city_rate NUMBER := OKC_API.G_MISS_NUM
90: ,tax_jurisdiction_county OKL_PROPERTY_TAX_B.TAX_JURISDICTION_COUNTY%TYPE := OKC_API.G_MISS_CHAR
91: ,tax_jurisdiction_county_rate NUMBER := OKC_API.G_MISS_NUM
92: ,tax_jurisdiction_state OKL_PROPERTY_TAX_B.TAX_JURISDICTION_STATE%TYPE := OKC_API.G_MISS_CHAR
93: ,tax_jurisdiction_state_rate NUMBER := OKC_API.G_MISS_NUM
94: ,tax_jurisdiction_school OKL_PROPERTY_TAX_B.TAX_JURISDICTION_SCHOOL%TYPE := OKC_API.G_MISS_CHAR
95: ,tax_jurisdiction_school_rate NUMBER := OKC_API.G_MISS_NUM
96: ,tax_jurisdiction_country OKL_PROPERTY_TAX_B.TAX_JURISDICTION_COUNTRY%TYPE := OKC_API.G_MISS_CHAR
97: ,tax_jurisdiction_country_rate NUMBER := OKC_API.G_MISS_NUM

Line 94: ,tax_jurisdiction_school OKL_PROPERTY_TAX_B.TAX_JURISDICTION_SCHOOL%TYPE := OKC_API.G_MISS_CHAR

90: ,tax_jurisdiction_county OKL_PROPERTY_TAX_B.TAX_JURISDICTION_COUNTY%TYPE := OKC_API.G_MISS_CHAR
91: ,tax_jurisdiction_county_rate NUMBER := OKC_API.G_MISS_NUM
92: ,tax_jurisdiction_state OKL_PROPERTY_TAX_B.TAX_JURISDICTION_STATE%TYPE := OKC_API.G_MISS_CHAR
93: ,tax_jurisdiction_state_rate NUMBER := OKC_API.G_MISS_NUM
94: ,tax_jurisdiction_school OKL_PROPERTY_TAX_B.TAX_JURISDICTION_SCHOOL%TYPE := OKC_API.G_MISS_CHAR
95: ,tax_jurisdiction_school_rate NUMBER := OKC_API.G_MISS_NUM
96: ,tax_jurisdiction_country OKL_PROPERTY_TAX_B.TAX_JURISDICTION_COUNTRY%TYPE := OKC_API.G_MISS_CHAR
97: ,tax_jurisdiction_country_rate NUMBER := OKC_API.G_MISS_NUM
98: ,tax_assessment_date OKL_PROPERTY_TAX_B.TAX_ASSESSMENT_DATE%TYPE := OKC_API.G_MISS_DATE

Line 95: ,tax_jurisdiction_school_rate NUMBER := OKC_API.G_MISS_NUM

91: ,tax_jurisdiction_county_rate NUMBER := OKC_API.G_MISS_NUM
92: ,tax_jurisdiction_state OKL_PROPERTY_TAX_B.TAX_JURISDICTION_STATE%TYPE := OKC_API.G_MISS_CHAR
93: ,tax_jurisdiction_state_rate NUMBER := OKC_API.G_MISS_NUM
94: ,tax_jurisdiction_school OKL_PROPERTY_TAX_B.TAX_JURISDICTION_SCHOOL%TYPE := OKC_API.G_MISS_CHAR
95: ,tax_jurisdiction_school_rate NUMBER := OKC_API.G_MISS_NUM
96: ,tax_jurisdiction_country OKL_PROPERTY_TAX_B.TAX_JURISDICTION_COUNTRY%TYPE := OKC_API.G_MISS_CHAR
97: ,tax_jurisdiction_country_rate NUMBER := OKC_API.G_MISS_NUM
98: ,tax_assessment_date OKL_PROPERTY_TAX_B.TAX_ASSESSMENT_DATE%TYPE := OKC_API.G_MISS_DATE
99: ,milrate NUMBER := OKC_API.G_MISS_NUM

Line 96: ,tax_jurisdiction_country OKL_PROPERTY_TAX_B.TAX_JURISDICTION_COUNTRY%TYPE := OKC_API.G_MISS_CHAR

92: ,tax_jurisdiction_state OKL_PROPERTY_TAX_B.TAX_JURISDICTION_STATE%TYPE := OKC_API.G_MISS_CHAR
93: ,tax_jurisdiction_state_rate NUMBER := OKC_API.G_MISS_NUM
94: ,tax_jurisdiction_school OKL_PROPERTY_TAX_B.TAX_JURISDICTION_SCHOOL%TYPE := OKC_API.G_MISS_CHAR
95: ,tax_jurisdiction_school_rate NUMBER := OKC_API.G_MISS_NUM
96: ,tax_jurisdiction_country OKL_PROPERTY_TAX_B.TAX_JURISDICTION_COUNTRY%TYPE := OKC_API.G_MISS_CHAR
97: ,tax_jurisdiction_country_rate NUMBER := OKC_API.G_MISS_NUM
98: ,tax_assessment_date OKL_PROPERTY_TAX_B.TAX_ASSESSMENT_DATE%TYPE := OKC_API.G_MISS_DATE
99: ,milrate NUMBER := OKC_API.G_MISS_NUM
100: ,property_tax_amount NUMBER := OKC_API.G_MISS_NUM

Line 97: ,tax_jurisdiction_country_rate NUMBER := OKC_API.G_MISS_NUM

93: ,tax_jurisdiction_state_rate NUMBER := OKC_API.G_MISS_NUM
94: ,tax_jurisdiction_school OKL_PROPERTY_TAX_B.TAX_JURISDICTION_SCHOOL%TYPE := OKC_API.G_MISS_CHAR
95: ,tax_jurisdiction_school_rate NUMBER := OKC_API.G_MISS_NUM
96: ,tax_jurisdiction_country OKL_PROPERTY_TAX_B.TAX_JURISDICTION_COUNTRY%TYPE := OKC_API.G_MISS_CHAR
97: ,tax_jurisdiction_country_rate NUMBER := OKC_API.G_MISS_NUM
98: ,tax_assessment_date OKL_PROPERTY_TAX_B.TAX_ASSESSMENT_DATE%TYPE := OKC_API.G_MISS_DATE
99: ,milrate NUMBER := OKC_API.G_MISS_NUM
100: ,property_tax_amount NUMBER := OKC_API.G_MISS_NUM
101: ,oec NUMBER := OKC_API.G_MISS_NUM

Line 98: ,tax_assessment_date OKL_PROPERTY_TAX_B.TAX_ASSESSMENT_DATE%TYPE := OKC_API.G_MISS_DATE

94: ,tax_jurisdiction_school OKL_PROPERTY_TAX_B.TAX_JURISDICTION_SCHOOL%TYPE := OKC_API.G_MISS_CHAR
95: ,tax_jurisdiction_school_rate NUMBER := OKC_API.G_MISS_NUM
96: ,tax_jurisdiction_country OKL_PROPERTY_TAX_B.TAX_JURISDICTION_COUNTRY%TYPE := OKC_API.G_MISS_CHAR
97: ,tax_jurisdiction_country_rate NUMBER := OKC_API.G_MISS_NUM
98: ,tax_assessment_date OKL_PROPERTY_TAX_B.TAX_ASSESSMENT_DATE%TYPE := OKC_API.G_MISS_DATE
99: ,milrate NUMBER := OKC_API.G_MISS_NUM
100: ,property_tax_amount NUMBER := OKC_API.G_MISS_NUM
101: ,oec NUMBER := OKC_API.G_MISS_NUM
102: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 99: ,milrate NUMBER := OKC_API.G_MISS_NUM

95: ,tax_jurisdiction_school_rate NUMBER := OKC_API.G_MISS_NUM
96: ,tax_jurisdiction_country OKL_PROPERTY_TAX_B.TAX_JURISDICTION_COUNTRY%TYPE := OKC_API.G_MISS_CHAR
97: ,tax_jurisdiction_country_rate NUMBER := OKC_API.G_MISS_NUM
98: ,tax_assessment_date OKL_PROPERTY_TAX_B.TAX_ASSESSMENT_DATE%TYPE := OKC_API.G_MISS_DATE
99: ,milrate NUMBER := OKC_API.G_MISS_NUM
100: ,property_tax_amount NUMBER := OKC_API.G_MISS_NUM
101: ,oec NUMBER := OKC_API.G_MISS_NUM
102: ,created_by NUMBER := OKC_API.G_MISS_NUM
103: ,creation_date OKL_PROPERTY_TAX_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 100: ,property_tax_amount NUMBER := OKC_API.G_MISS_NUM

96: ,tax_jurisdiction_country OKL_PROPERTY_TAX_B.TAX_JURISDICTION_COUNTRY%TYPE := OKC_API.G_MISS_CHAR
97: ,tax_jurisdiction_country_rate NUMBER := OKC_API.G_MISS_NUM
98: ,tax_assessment_date OKL_PROPERTY_TAX_B.TAX_ASSESSMENT_DATE%TYPE := OKC_API.G_MISS_DATE
99: ,milrate NUMBER := OKC_API.G_MISS_NUM
100: ,property_tax_amount NUMBER := OKC_API.G_MISS_NUM
101: ,oec NUMBER := OKC_API.G_MISS_NUM
102: ,created_by NUMBER := OKC_API.G_MISS_NUM
103: ,creation_date OKL_PROPERTY_TAX_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
104: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 101: ,oec NUMBER := OKC_API.G_MISS_NUM

97: ,tax_jurisdiction_country_rate NUMBER := OKC_API.G_MISS_NUM
98: ,tax_assessment_date OKL_PROPERTY_TAX_B.TAX_ASSESSMENT_DATE%TYPE := OKC_API.G_MISS_DATE
99: ,milrate NUMBER := OKC_API.G_MISS_NUM
100: ,property_tax_amount NUMBER := OKC_API.G_MISS_NUM
101: ,oec NUMBER := OKC_API.G_MISS_NUM
102: ,created_by NUMBER := OKC_API.G_MISS_NUM
103: ,creation_date OKL_PROPERTY_TAX_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
104: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
105: ,last_update_date OKL_PROPERTY_TAX_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 102: ,created_by NUMBER := OKC_API.G_MISS_NUM

98: ,tax_assessment_date OKL_PROPERTY_TAX_B.TAX_ASSESSMENT_DATE%TYPE := OKC_API.G_MISS_DATE
99: ,milrate NUMBER := OKC_API.G_MISS_NUM
100: ,property_tax_amount NUMBER := OKC_API.G_MISS_NUM
101: ,oec NUMBER := OKC_API.G_MISS_NUM
102: ,created_by NUMBER := OKC_API.G_MISS_NUM
103: ,creation_date OKL_PROPERTY_TAX_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
104: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
105: ,last_update_date OKL_PROPERTY_TAX_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
106: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

Line 103: ,creation_date OKL_PROPERTY_TAX_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

99: ,milrate NUMBER := OKC_API.G_MISS_NUM
100: ,property_tax_amount NUMBER := OKC_API.G_MISS_NUM
101: ,oec NUMBER := OKC_API.G_MISS_NUM
102: ,created_by NUMBER := OKC_API.G_MISS_NUM
103: ,creation_date OKL_PROPERTY_TAX_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
104: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
105: ,last_update_date OKL_PROPERTY_TAX_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
106: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
107: ,contract_number OKL_PROPERTY_TAX_B.contract_number%TYPE := OKC_API.G_MISS_CHAR

Line 104: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

100: ,property_tax_amount NUMBER := OKC_API.G_MISS_NUM
101: ,oec NUMBER := OKC_API.G_MISS_NUM
102: ,created_by NUMBER := OKC_API.G_MISS_NUM
103: ,creation_date OKL_PROPERTY_TAX_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
104: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
105: ,last_update_date OKL_PROPERTY_TAX_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
106: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
107: ,contract_number OKL_PROPERTY_TAX_B.contract_number%TYPE := OKC_API.G_MISS_CHAR
108: ,sty_name OKL_PROPERTY_TAX_B.STY_NAME%TYPE := OKC_API.G_MISS_CHAR

Line 105: ,last_update_date OKL_PROPERTY_TAX_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

101: ,oec NUMBER := OKC_API.G_MISS_NUM
102: ,created_by NUMBER := OKC_API.G_MISS_NUM
103: ,creation_date OKL_PROPERTY_TAX_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
104: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
105: ,last_update_date OKL_PROPERTY_TAX_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
106: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
107: ,contract_number OKL_PROPERTY_TAX_B.contract_number%TYPE := OKC_API.G_MISS_CHAR
108: ,sty_name OKL_PROPERTY_TAX_B.STY_NAME%TYPE := OKC_API.G_MISS_CHAR
109: ,sty_id NUMBER := OKC_API.G_MISS_NUM

Line 106: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

102: ,created_by NUMBER := OKC_API.G_MISS_NUM
103: ,creation_date OKL_PROPERTY_TAX_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
104: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
105: ,last_update_date OKL_PROPERTY_TAX_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
106: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
107: ,contract_number OKL_PROPERTY_TAX_B.contract_number%TYPE := OKC_API.G_MISS_CHAR
108: ,sty_name OKL_PROPERTY_TAX_B.STY_NAME%TYPE := OKC_API.G_MISS_CHAR
109: ,sty_id NUMBER := OKC_API.G_MISS_NUM
110: ,invoice_date OKL_PROPERTY_TAX_B.INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 107: ,contract_number OKL_PROPERTY_TAX_B.contract_number%TYPE := OKC_API.G_MISS_CHAR

103: ,creation_date OKL_PROPERTY_TAX_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
104: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
105: ,last_update_date OKL_PROPERTY_TAX_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
106: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
107: ,contract_number OKL_PROPERTY_TAX_B.contract_number%TYPE := OKC_API.G_MISS_CHAR
108: ,sty_name OKL_PROPERTY_TAX_B.STY_NAME%TYPE := OKC_API.G_MISS_CHAR
109: ,sty_id NUMBER := OKC_API.G_MISS_NUM
110: ,invoice_date OKL_PROPERTY_TAX_B.INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE
111: ,amount NUMBER := OKC_API.G_MISS_NUM

Line 108: ,sty_name OKL_PROPERTY_TAX_B.STY_NAME%TYPE := OKC_API.G_MISS_CHAR

104: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
105: ,last_update_date OKL_PROPERTY_TAX_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
106: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
107: ,contract_number OKL_PROPERTY_TAX_B.contract_number%TYPE := OKC_API.G_MISS_CHAR
108: ,sty_name OKL_PROPERTY_TAX_B.STY_NAME%TYPE := OKC_API.G_MISS_CHAR
109: ,sty_id NUMBER := OKC_API.G_MISS_NUM
110: ,invoice_date OKL_PROPERTY_TAX_B.INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE
111: ,amount NUMBER := OKC_API.G_MISS_NUM
112: ,org_id NUMBER := OKC_API.G_MISS_NUM);

Line 109: ,sty_id NUMBER := OKC_API.G_MISS_NUM

105: ,last_update_date OKL_PROPERTY_TAX_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
106: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
107: ,contract_number OKL_PROPERTY_TAX_B.contract_number%TYPE := OKC_API.G_MISS_CHAR
108: ,sty_name OKL_PROPERTY_TAX_B.STY_NAME%TYPE := OKC_API.G_MISS_CHAR
109: ,sty_id NUMBER := OKC_API.G_MISS_NUM
110: ,invoice_date OKL_PROPERTY_TAX_B.INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE
111: ,amount NUMBER := OKC_API.G_MISS_NUM
112: ,org_id NUMBER := OKC_API.G_MISS_NUM);
113: G_MISS_ptc_rec ptc_rec_type;

Line 110: ,invoice_date OKL_PROPERTY_TAX_B.INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE

106: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
107: ,contract_number OKL_PROPERTY_TAX_B.contract_number%TYPE := OKC_API.G_MISS_CHAR
108: ,sty_name OKL_PROPERTY_TAX_B.STY_NAME%TYPE := OKC_API.G_MISS_CHAR
109: ,sty_id NUMBER := OKC_API.G_MISS_NUM
110: ,invoice_date OKL_PROPERTY_TAX_B.INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE
111: ,amount NUMBER := OKC_API.G_MISS_NUM
112: ,org_id NUMBER := OKC_API.G_MISS_NUM);
113: G_MISS_ptc_rec ptc_rec_type;
114: TYPE ptc_tbl_type IS TABLE OF ptc_rec_type

Line 111: ,amount NUMBER := OKC_API.G_MISS_NUM

107: ,contract_number OKL_PROPERTY_TAX_B.contract_number%TYPE := OKC_API.G_MISS_CHAR
108: ,sty_name OKL_PROPERTY_TAX_B.STY_NAME%TYPE := OKC_API.G_MISS_CHAR
109: ,sty_id NUMBER := OKC_API.G_MISS_NUM
110: ,invoice_date OKL_PROPERTY_TAX_B.INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE
111: ,amount NUMBER := OKC_API.G_MISS_NUM
112: ,org_id NUMBER := OKC_API.G_MISS_NUM);
113: G_MISS_ptc_rec ptc_rec_type;
114: TYPE ptc_tbl_type IS TABLE OF ptc_rec_type
115: INDEX BY BINARY_INTEGER;

Line 112: ,org_id NUMBER := OKC_API.G_MISS_NUM);

108: ,sty_name OKL_PROPERTY_TAX_B.STY_NAME%TYPE := OKC_API.G_MISS_CHAR
109: ,sty_id NUMBER := OKC_API.G_MISS_NUM
110: ,invoice_date OKL_PROPERTY_TAX_B.INVOICE_DATE%TYPE := OKC_API.G_MISS_DATE
111: ,amount NUMBER := OKC_API.G_MISS_NUM
112: ,org_id NUMBER := OKC_API.G_MISS_NUM);
113: G_MISS_ptc_rec ptc_rec_type;
114: TYPE ptc_tbl_type IS TABLE OF ptc_rec_type
115: INDEX BY BINARY_INTEGER;
116: TYPE ptct_rec_type IS RECORD (

Line 117: id NUMBER := OKC_API.G_MISS_NUM

113: G_MISS_ptc_rec ptc_rec_type;
114: TYPE ptc_tbl_type IS TABLE OF ptc_rec_type
115: INDEX BY BINARY_INTEGER;
116: TYPE ptct_rec_type IS RECORD (
117: id NUMBER := OKC_API.G_MISS_NUM
118: ,language OKL_PROPERTY_TAX_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
119: ,source_lang OKL_PROPERTY_TAX_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
120: ,sfwt_flag OKL_PROPERTY_TAX_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
121: ,asset_description OKL_PROPERTY_TAX_TL.ASSET_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR

Line 118: ,language OKL_PROPERTY_TAX_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR

114: TYPE ptc_tbl_type IS TABLE OF ptc_rec_type
115: INDEX BY BINARY_INTEGER;
116: TYPE ptct_rec_type IS RECORD (
117: id NUMBER := OKC_API.G_MISS_NUM
118: ,language OKL_PROPERTY_TAX_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
119: ,source_lang OKL_PROPERTY_TAX_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
120: ,sfwt_flag OKL_PROPERTY_TAX_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
121: ,asset_description OKL_PROPERTY_TAX_TL.ASSET_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
122: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 119: ,source_lang OKL_PROPERTY_TAX_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR

115: INDEX BY BINARY_INTEGER;
116: TYPE ptct_rec_type IS RECORD (
117: id NUMBER := OKC_API.G_MISS_NUM
118: ,language OKL_PROPERTY_TAX_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
119: ,source_lang OKL_PROPERTY_TAX_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
120: ,sfwt_flag OKL_PROPERTY_TAX_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
121: ,asset_description OKL_PROPERTY_TAX_TL.ASSET_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
122: ,created_by NUMBER := OKC_API.G_MISS_NUM
123: ,creation_date OKL_PROPERTY_TAX_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 120: ,sfwt_flag OKL_PROPERTY_TAX_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR

116: TYPE ptct_rec_type IS RECORD (
117: id NUMBER := OKC_API.G_MISS_NUM
118: ,language OKL_PROPERTY_TAX_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
119: ,source_lang OKL_PROPERTY_TAX_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
120: ,sfwt_flag OKL_PROPERTY_TAX_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
121: ,asset_description OKL_PROPERTY_TAX_TL.ASSET_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
122: ,created_by NUMBER := OKC_API.G_MISS_NUM
123: ,creation_date OKL_PROPERTY_TAX_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
124: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 121: ,asset_description OKL_PROPERTY_TAX_TL.ASSET_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR

117: id NUMBER := OKC_API.G_MISS_NUM
118: ,language OKL_PROPERTY_TAX_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
119: ,source_lang OKL_PROPERTY_TAX_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
120: ,sfwt_flag OKL_PROPERTY_TAX_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
121: ,asset_description OKL_PROPERTY_TAX_TL.ASSET_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
122: ,created_by NUMBER := OKC_API.G_MISS_NUM
123: ,creation_date OKL_PROPERTY_TAX_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
124: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
125: ,last_update_date OKL_PROPERTY_TAX_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 122: ,created_by NUMBER := OKC_API.G_MISS_NUM

118: ,language OKL_PROPERTY_TAX_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
119: ,source_lang OKL_PROPERTY_TAX_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
120: ,sfwt_flag OKL_PROPERTY_TAX_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
121: ,asset_description OKL_PROPERTY_TAX_TL.ASSET_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
122: ,created_by NUMBER := OKC_API.G_MISS_NUM
123: ,creation_date OKL_PROPERTY_TAX_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
124: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
125: ,last_update_date OKL_PROPERTY_TAX_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
126: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);

Line 123: ,creation_date OKL_PROPERTY_TAX_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

119: ,source_lang OKL_PROPERTY_TAX_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
120: ,sfwt_flag OKL_PROPERTY_TAX_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
121: ,asset_description OKL_PROPERTY_TAX_TL.ASSET_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
122: ,created_by NUMBER := OKC_API.G_MISS_NUM
123: ,creation_date OKL_PROPERTY_TAX_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
124: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
125: ,last_update_date OKL_PROPERTY_TAX_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
126: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
127: G_MISS_ptct_rec ptct_rec_type;

Line 124: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

120: ,sfwt_flag OKL_PROPERTY_TAX_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR
121: ,asset_description OKL_PROPERTY_TAX_TL.ASSET_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
122: ,created_by NUMBER := OKC_API.G_MISS_NUM
123: ,creation_date OKL_PROPERTY_TAX_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
124: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
125: ,last_update_date OKL_PROPERTY_TAX_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
126: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
127: G_MISS_ptct_rec ptct_rec_type;
128: TYPE ptct_tbl_type IS TABLE OF ptct_rec_type

Line 125: ,last_update_date OKL_PROPERTY_TAX_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

121: ,asset_description OKL_PROPERTY_TAX_TL.ASSET_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
122: ,created_by NUMBER := OKC_API.G_MISS_NUM
123: ,creation_date OKL_PROPERTY_TAX_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
124: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
125: ,last_update_date OKL_PROPERTY_TAX_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
126: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
127: G_MISS_ptct_rec ptct_rec_type;
128: TYPE ptct_tbl_type IS TABLE OF ptct_rec_type
129: INDEX BY BINARY_INTEGER;

Line 126: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);

122: ,created_by NUMBER := OKC_API.G_MISS_NUM
123: ,creation_date OKL_PROPERTY_TAX_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
124: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
125: ,last_update_date OKL_PROPERTY_TAX_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
126: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
127: G_MISS_ptct_rec ptct_rec_type;
128: TYPE ptct_tbl_type IS TABLE OF ptct_rec_type
129: INDEX BY BINARY_INTEGER;
130: ---------------------------------------------------------------------------

Line 133: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

129: INDEX BY BINARY_INTEGER;
130: ---------------------------------------------------------------------------
131: -- GLOBAL MESSAGE CONSTANTS
132: ---------------------------------------------------------------------------
133: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
134: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
135: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
136: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
137: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

Line 134: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;

130: ---------------------------------------------------------------------------
131: -- GLOBAL MESSAGE CONSTANTS
132: ---------------------------------------------------------------------------
133: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
134: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
135: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
136: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
137: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
138: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

Line 135: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;

131: -- GLOBAL MESSAGE CONSTANTS
132: ---------------------------------------------------------------------------
133: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
134: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
135: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
136: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
137: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
138: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
139: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

Line 136: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;

132: ---------------------------------------------------------------------------
133: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
134: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
135: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
136: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
137: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
138: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
139: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
140: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

Line 137: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

133: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
134: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
135: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
136: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
137: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
138: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
139: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
140: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
141: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

Line 138: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

134: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
135: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
136: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
137: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
138: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
139: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
140: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
141: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
142: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

Line 139: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

135: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
136: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
137: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
138: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
139: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
140: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
141: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
142: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
143: --G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';

Line 140: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

136: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
137: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
138: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
139: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
140: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
141: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
142: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
143: --G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
144: --G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

Line 141: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

137: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
138: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
139: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
140: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
141: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
142: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
143: --G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
144: --G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
145: --G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

Line 142: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

138: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
139: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
140: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
141: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
142: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
143: --G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
144: --G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
145: --G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
146:

Line 156: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

152: ---------------------------------------------------------------------------
153: -- GLOBAL VARIABLES
154: ---------------------------------------------------------------------------
155: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_PTC_PVT';
156: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
157:
158: -------------------------------------------------------------------------------
159: --Post change to TAPI code
160: -------------------------------------------------------------------------------

Line 178: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

174: PROCEDURE api_copy;
175: PROCEDURE add_language;
176: PROCEDURE insert_row(
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
179: x_return_status OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,
181: x_msg_data OUT NOCOPY VARCHAR2,
182: p_ptcv_rec IN ptcv_rec_type,

Line 186: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

182: p_ptcv_rec IN ptcv_rec_type,
183: x_ptcv_rec OUT NOCOPY ptcv_rec_type);
184: PROCEDURE insert_row(
185: p_api_version IN NUMBER,
186: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
187: x_return_status OUT NOCOPY VARCHAR2,
188: x_msg_count OUT NOCOPY NUMBER,
189: x_msg_data OUT NOCOPY VARCHAR2,
190: p_ptcv_tbl IN ptcv_tbl_type,

Line 195: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

191: x_ptcv_tbl OUT NOCOPY ptcv_tbl_type,
192: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
193: PROCEDURE insert_row(
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
196: x_return_status OUT NOCOPY VARCHAR2,
197: x_msg_count OUT NOCOPY NUMBER,
198: x_msg_data OUT NOCOPY VARCHAR2,
199: p_ptcv_tbl IN ptcv_tbl_type,

Line 203: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

199: p_ptcv_tbl IN ptcv_tbl_type,
200: x_ptcv_tbl OUT NOCOPY ptcv_tbl_type);
201: PROCEDURE lock_row(
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
204: x_return_status OUT NOCOPY VARCHAR2,
205: x_msg_count OUT NOCOPY NUMBER,
206: x_msg_data OUT NOCOPY VARCHAR2,
207: p_ptcv_rec IN ptcv_rec_type);

Line 210: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

206: x_msg_data OUT NOCOPY VARCHAR2,
207: p_ptcv_rec IN ptcv_rec_type);
208: PROCEDURE lock_row(
209: p_api_version IN NUMBER,
210: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
211: x_return_status OUT NOCOPY VARCHAR2,
212: x_msg_count OUT NOCOPY NUMBER,
213: x_msg_data OUT NOCOPY VARCHAR2,
214: p_ptcv_tbl IN ptcv_tbl_type,

Line 218: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

214: p_ptcv_tbl IN ptcv_tbl_type,
215: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
216: PROCEDURE lock_row(
217: p_api_version IN NUMBER,
218: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
219: x_return_status OUT NOCOPY VARCHAR2,
220: x_msg_count OUT NOCOPY NUMBER,
221: x_msg_data OUT NOCOPY VARCHAR2,
222: p_ptcv_tbl IN ptcv_tbl_type);

Line 225: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

221: x_msg_data OUT NOCOPY VARCHAR2,
222: p_ptcv_tbl IN ptcv_tbl_type);
223: PROCEDURE update_row(
224: p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,
228: x_msg_data OUT NOCOPY VARCHAR2,
229: p_ptcv_rec IN ptcv_rec_type,

Line 233: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

229: p_ptcv_rec IN ptcv_rec_type,
230: x_ptcv_rec OUT NOCOPY ptcv_rec_type);
231: PROCEDURE update_row(
232: p_api_version IN NUMBER,
233: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
234: x_return_status OUT NOCOPY VARCHAR2,
235: x_msg_count OUT NOCOPY NUMBER,
236: x_msg_data OUT NOCOPY VARCHAR2,
237: p_ptcv_tbl IN ptcv_tbl_type,

Line 242: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

238: x_ptcv_tbl OUT NOCOPY ptcv_tbl_type,
239: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
240: PROCEDURE update_row(
241: p_api_version IN NUMBER,
242: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
243: x_return_status OUT NOCOPY VARCHAR2,
244: x_msg_count OUT NOCOPY NUMBER,
245: x_msg_data OUT NOCOPY VARCHAR2,
246: p_ptcv_tbl IN ptcv_tbl_type,

Line 250: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

246: p_ptcv_tbl IN ptcv_tbl_type,
247: x_ptcv_tbl OUT NOCOPY ptcv_tbl_type);
248: PROCEDURE delete_row(
249: p_api_version IN NUMBER,
250: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
251: x_return_status OUT NOCOPY VARCHAR2,
252: x_msg_count OUT NOCOPY NUMBER,
253: x_msg_data OUT NOCOPY VARCHAR2,
254: p_ptcv_rec IN ptcv_rec_type);

Line 257: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

253: x_msg_data OUT NOCOPY VARCHAR2,
254: p_ptcv_rec IN ptcv_rec_type);
255: PROCEDURE delete_row(
256: p_api_version IN NUMBER,
257: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
258: x_return_status OUT NOCOPY VARCHAR2,
259: x_msg_count OUT NOCOPY NUMBER,
260: x_msg_data OUT NOCOPY VARCHAR2,
261: p_ptcv_tbl IN ptcv_tbl_type,

Line 265: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

261: p_ptcv_tbl IN ptcv_tbl_type,
262: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
263: PROCEDURE delete_row(
264: p_api_version IN NUMBER,
265: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
266: x_return_status OUT NOCOPY VARCHAR2,
267: x_msg_count OUT NOCOPY NUMBER,
268: x_msg_data OUT NOCOPY VARCHAR2,
269: p_ptcv_tbl IN ptcv_tbl_type);

Line 272: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

268: x_msg_data OUT NOCOPY VARCHAR2,
269: p_ptcv_tbl IN ptcv_tbl_type);
270: PROCEDURE validate_row(
271: p_api_version IN NUMBER,
272: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
273: x_return_status OUT NOCOPY VARCHAR2,
274: x_msg_count OUT NOCOPY NUMBER,
275: x_msg_data OUT NOCOPY VARCHAR2,
276: p_ptcv_rec IN ptcv_rec_type);

Line 279: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

275: x_msg_data OUT NOCOPY VARCHAR2,
276: p_ptcv_rec IN ptcv_rec_type);
277: PROCEDURE validate_row(
278: p_api_version IN NUMBER,
279: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
280: x_return_status OUT NOCOPY VARCHAR2,
281: x_msg_count OUT NOCOPY NUMBER,
282: x_msg_data OUT NOCOPY VARCHAR2,
283: p_ptcv_tbl IN ptcv_tbl_type,

Line 287: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

283: p_ptcv_tbl IN ptcv_tbl_type,
284: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
285: PROCEDURE validate_row(
286: p_api_version IN NUMBER,
287: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
288: x_return_status OUT NOCOPY VARCHAR2,
289: x_msg_count OUT NOCOPY NUMBER,
290: x_msg_data OUT NOCOPY VARCHAR2,
291: p_ptcv_tbl IN ptcv_tbl_type);