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