[Home] [Help]
11: G_EXCEPTION_ERROR EXCEPTION;
12: G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
13: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
14: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CREATE_STREAMS_PVT';
15: G_OKC_APP CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
16: G_NO_DATA_FOUND CONSTANT VARCHAR2(200) := 'OKL_NOT_FOUND';
17: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
18: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
19: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
13: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
14: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CREATE_STREAMS_PVT';
15: G_OKC_APP CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
16: G_NO_DATA_FOUND CONSTANT VARCHAR2(200) := 'OKL_NOT_FOUND';
17: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
18: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
19: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
20: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
21: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
14: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CREATE_STREAMS_PVT';
15: G_OKC_APP CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
16: G_NO_DATA_FOUND CONSTANT VARCHAR2(200) := 'OKL_NOT_FOUND';
17: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
18: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
19: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
20: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
21: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
22: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
15: G_OKC_APP CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
16: G_NO_DATA_FOUND CONSTANT VARCHAR2(200) := 'OKL_NOT_FOUND';
17: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
18: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
19: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
20: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
21: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
22: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
23: G_OKL_CSM_PENDING CONSTANT VARCHAR2(15) := 'OKL_CSM_PENDING';
121: -- In the abscence of "KLE_ID" it is assumed to be in the Header
122: -- else it will be assigned to the corresponding KLE_ID / Line
123: */
124: TYPE csm_one_off_fee_rec_type IS RECORD(
125: description OKL_SIF_FEES_V.description%TYPE := OKC_API.G_MISS_CHAR
126: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
127: ,amount NUMBER := OKC_API.G_MISS_NUM
128: ,date_start OKL_SIF_FEES_V.date_paid%TYPE := OKC_API.G_MISS_DATE --smahapat fee type solution
129: ,date_paid OKL_SIF_FEES_V.date_paid%TYPE := OKC_API.G_MISS_DATE
122: -- else it will be assigned to the corresponding KLE_ID / Line
123: */
124: TYPE csm_one_off_fee_rec_type IS RECORD(
125: description OKL_SIF_FEES_V.description%TYPE := OKC_API.G_MISS_CHAR
126: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
127: ,amount NUMBER := OKC_API.G_MISS_NUM
128: ,date_start OKL_SIF_FEES_V.date_paid%TYPE := OKC_API.G_MISS_DATE --smahapat fee type solution
129: ,date_paid OKL_SIF_FEES_V.date_paid%TYPE := OKC_API.G_MISS_DATE
130: ,idc_accounting_flag OKL_SIF_FEES_V.idc_accounting_flag%TYPE := OKC_API.G_MISS_CHAR
123: */
124: TYPE csm_one_off_fee_rec_type IS RECORD(
125: description OKL_SIF_FEES_V.description%TYPE := OKC_API.G_MISS_CHAR
126: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
127: ,amount NUMBER := OKC_API.G_MISS_NUM
128: ,date_start OKL_SIF_FEES_V.date_paid%TYPE := OKC_API.G_MISS_DATE --smahapat fee type solution
129: ,date_paid OKL_SIF_FEES_V.date_paid%TYPE := OKC_API.G_MISS_DATE
130: ,idc_accounting_flag OKL_SIF_FEES_V.idc_accounting_flag%TYPE := OKC_API.G_MISS_CHAR
131: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
124: TYPE csm_one_off_fee_rec_type IS RECORD(
125: description OKL_SIF_FEES_V.description%TYPE := OKC_API.G_MISS_CHAR
126: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
127: ,amount NUMBER := OKC_API.G_MISS_NUM
128: ,date_start OKL_SIF_FEES_V.date_paid%TYPE := OKC_API.G_MISS_DATE --smahapat fee type solution
129: ,date_paid OKL_SIF_FEES_V.date_paid%TYPE := OKC_API.G_MISS_DATE
130: ,idc_accounting_flag OKL_SIF_FEES_V.idc_accounting_flag%TYPE := OKC_API.G_MISS_CHAR
131: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
132: ,kle_fee_id NUMBER := OKC_API.G_MISS_NUM
125: description OKL_SIF_FEES_V.description%TYPE := OKC_API.G_MISS_CHAR
126: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
127: ,amount NUMBER := OKC_API.G_MISS_NUM
128: ,date_start OKL_SIF_FEES_V.date_paid%TYPE := OKC_API.G_MISS_DATE --smahapat fee type solution
129: ,date_paid OKL_SIF_FEES_V.date_paid%TYPE := OKC_API.G_MISS_DATE
130: ,idc_accounting_flag OKL_SIF_FEES_V.idc_accounting_flag%TYPE := OKC_API.G_MISS_CHAR
131: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
132: ,kle_fee_id NUMBER := OKC_API.G_MISS_NUM
133: ,fee_type OKL_K_LINES_v.fee_type%TYPE := OKC_API.G_MISS_CHAR --SGORANTL ADDED FOR FINANCE FEES
126: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
127: ,amount NUMBER := OKC_API.G_MISS_NUM
128: ,date_start OKL_SIF_FEES_V.date_paid%TYPE := OKC_API.G_MISS_DATE --smahapat fee type solution
129: ,date_paid OKL_SIF_FEES_V.date_paid%TYPE := OKC_API.G_MISS_DATE
130: ,idc_accounting_flag OKL_SIF_FEES_V.idc_accounting_flag%TYPE := OKC_API.G_MISS_CHAR
131: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
132: ,kle_fee_id NUMBER := OKC_API.G_MISS_NUM
133: ,fee_type OKL_K_LINES_v.fee_type%TYPE := OKC_API.G_MISS_CHAR --SGORANTL ADDED FOR FINANCE FEES
134: -- Use ONLY in case this fees is for a Specific Line (Asset Line / Loan Line)
127: ,amount NUMBER := OKC_API.G_MISS_NUM
128: ,date_start OKL_SIF_FEES_V.date_paid%TYPE := OKC_API.G_MISS_DATE --smahapat fee type solution
129: ,date_paid OKL_SIF_FEES_V.date_paid%TYPE := OKC_API.G_MISS_DATE
130: ,idc_accounting_flag OKL_SIF_FEES_V.idc_accounting_flag%TYPE := OKC_API.G_MISS_CHAR
131: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
132: ,kle_fee_id NUMBER := OKC_API.G_MISS_NUM
133: ,fee_type OKL_K_LINES_v.fee_type%TYPE := OKC_API.G_MISS_CHAR --SGORANTL ADDED FOR FINANCE FEES
134: -- Use ONLY in case this fees is for a Specific Line (Asset Line / Loan Line)
135: ,kle_asset_id NUMBER := OKC_API.G_MISS_NUM
128: ,date_start OKL_SIF_FEES_V.date_paid%TYPE := OKC_API.G_MISS_DATE --smahapat fee type solution
129: ,date_paid OKL_SIF_FEES_V.date_paid%TYPE := OKC_API.G_MISS_DATE
130: ,idc_accounting_flag OKL_SIF_FEES_V.idc_accounting_flag%TYPE := OKC_API.G_MISS_CHAR
131: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
132: ,kle_fee_id NUMBER := OKC_API.G_MISS_NUM
133: ,fee_type OKL_K_LINES_v.fee_type%TYPE := OKC_API.G_MISS_CHAR --SGORANTL ADDED FOR FINANCE FEES
134: -- Use ONLY in case this fees is for a Specific Line (Asset Line / Loan Line)
135: ,kle_asset_id NUMBER := OKC_API.G_MISS_NUM
136: ,other_type_id NUMBER := OKC_API.G_MISS_NUM --SGORANTL ADDED FOR subsidy
129: ,date_paid OKL_SIF_FEES_V.date_paid%TYPE := OKC_API.G_MISS_DATE
130: ,idc_accounting_flag OKL_SIF_FEES_V.idc_accounting_flag%TYPE := OKC_API.G_MISS_CHAR
131: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
132: ,kle_fee_id NUMBER := OKC_API.G_MISS_NUM
133: ,fee_type OKL_K_LINES_v.fee_type%TYPE := OKC_API.G_MISS_CHAR --SGORANTL ADDED FOR FINANCE FEES
134: -- Use ONLY in case this fees is for a Specific Line (Asset Line / Loan Line)
135: ,kle_asset_id NUMBER := OKC_API.G_MISS_NUM
136: ,other_type_id NUMBER := OKC_API.G_MISS_NUM --SGORANTL ADDED FOR subsidy
137: ,other_type OKL_K_LINES_v.fee_type%TYPE := OKC_API.G_MISS_CHAR --SGORANTL ADDED FOR subsidy
131: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
132: ,kle_fee_id NUMBER := OKC_API.G_MISS_NUM
133: ,fee_type OKL_K_LINES_v.fee_type%TYPE := OKC_API.G_MISS_CHAR --SGORANTL ADDED FOR FINANCE FEES
134: -- Use ONLY in case this fees is for a Specific Line (Asset Line / Loan Line)
135: ,kle_asset_id NUMBER := OKC_API.G_MISS_NUM
136: ,other_type_id NUMBER := OKC_API.G_MISS_NUM --SGORANTL ADDED FOR subsidy
137: ,other_type OKL_K_LINES_v.fee_type%TYPE := OKC_API.G_MISS_CHAR --SGORANTL ADDED FOR subsidy
138: ,rate NUMBER := OKC_API.G_MISS_NUM
139: -- add reference to the external ID
132: ,kle_fee_id NUMBER := OKC_API.G_MISS_NUM
133: ,fee_type OKL_K_LINES_v.fee_type%TYPE := OKC_API.G_MISS_CHAR --SGORANTL ADDED FOR FINANCE FEES
134: -- Use ONLY in case this fees is for a Specific Line (Asset Line / Loan Line)
135: ,kle_asset_id NUMBER := OKC_API.G_MISS_NUM
136: ,other_type_id NUMBER := OKC_API.G_MISS_NUM --SGORANTL ADDED FOR subsidy
137: ,other_type OKL_K_LINES_v.fee_type%TYPE := OKC_API.G_MISS_CHAR --SGORANTL ADDED FOR subsidy
138: ,rate NUMBER := OKC_API.G_MISS_NUM
139: -- add reference to the external ID
140: ,orig_contract_line_id NUMBER := OKC_API.G_MISS_NUM
133: ,fee_type OKL_K_LINES_v.fee_type%TYPE := OKC_API.G_MISS_CHAR --SGORANTL ADDED FOR FINANCE FEES
134: -- Use ONLY in case this fees is for a Specific Line (Asset Line / Loan Line)
135: ,kle_asset_id NUMBER := OKC_API.G_MISS_NUM
136: ,other_type_id NUMBER := OKC_API.G_MISS_NUM --SGORANTL ADDED FOR subsidy
137: ,other_type OKL_K_LINES_v.fee_type%TYPE := OKC_API.G_MISS_CHAR --SGORANTL ADDED FOR subsidy
138: ,rate NUMBER := OKC_API.G_MISS_NUM
139: -- add reference to the external ID
140: ,orig_contract_line_id NUMBER := OKC_API.G_MISS_NUM
141: );
134: -- Use ONLY in case this fees is for a Specific Line (Asset Line / Loan Line)
135: ,kle_asset_id NUMBER := OKC_API.G_MISS_NUM
136: ,other_type_id NUMBER := OKC_API.G_MISS_NUM --SGORANTL ADDED FOR subsidy
137: ,other_type OKL_K_LINES_v.fee_type%TYPE := OKC_API.G_MISS_CHAR --SGORANTL ADDED FOR subsidy
138: ,rate NUMBER := OKC_API.G_MISS_NUM
139: -- add reference to the external ID
140: ,orig_contract_line_id NUMBER := OKC_API.G_MISS_NUM
141: );
142:
136: ,other_type_id NUMBER := OKC_API.G_MISS_NUM --SGORANTL ADDED FOR subsidy
137: ,other_type OKL_K_LINES_v.fee_type%TYPE := OKC_API.G_MISS_CHAR --SGORANTL ADDED FOR subsidy
138: ,rate NUMBER := OKC_API.G_MISS_NUM
139: -- add reference to the external ID
140: ,orig_contract_line_id NUMBER := OKC_API.G_MISS_NUM
141: );
142:
143: TYPE csm_one_off_fee_tbl_type IS TABLE OF csm_one_off_fee_rec_type
144: INDEX BY BINARY_INTEGER;
149: -- else it will be assigned to the corresponding KLE_ID / Line
150: */
151: TYPE csm_periodic_expenses_rec_type IS RECORD(
152: -- Common Details
153: description OKL_SIF_FEES_V.description%TYPE := OKC_API.G_MISS_CHAR
154: ,date_start OKL_SIF_FEES_V.date_start%TYPE := OKC_API.G_MISS_DATE --smahapat fee type soln interpreted as en accrual for stub payment
155: ,kle_fee_id NUMBER := OKC_API.G_MISS_NUM
156: -- Use ONLY in case this fees is for a Specific Line (Asset Line / Loan Line)
157: ,kle_asset_id NUMBER := OKC_API.G_MISS_NUM
150: */
151: TYPE csm_periodic_expenses_rec_type IS RECORD(
152: -- Common Details
153: description OKL_SIF_FEES_V.description%TYPE := OKC_API.G_MISS_CHAR
154: ,date_start OKL_SIF_FEES_V.date_start%TYPE := OKC_API.G_MISS_DATE --smahapat fee type soln interpreted as en accrual for stub payment
155: ,kle_fee_id NUMBER := OKC_API.G_MISS_NUM
156: -- Use ONLY in case this fees is for a Specific Line (Asset Line / Loan Line)
157: ,kle_asset_id NUMBER := OKC_API.G_MISS_NUM
158: -- Per-Record Details
151: TYPE csm_periodic_expenses_rec_type IS RECORD(
152: -- Common Details
153: description OKL_SIF_FEES_V.description%TYPE := OKC_API.G_MISS_CHAR
154: ,date_start OKL_SIF_FEES_V.date_start%TYPE := OKC_API.G_MISS_DATE --smahapat fee type soln interpreted as en accrual for stub payment
155: ,kle_fee_id NUMBER := OKC_API.G_MISS_NUM
156: -- Use ONLY in case this fees is for a Specific Line (Asset Line / Loan Line)
157: ,kle_asset_id NUMBER := OKC_API.G_MISS_NUM
158: -- Per-Record Details
159: ,level_index_number NUMBER := OKC_API.G_MISS_NUM
153: description OKL_SIF_FEES_V.description%TYPE := OKC_API.G_MISS_CHAR
154: ,date_start OKL_SIF_FEES_V.date_start%TYPE := OKC_API.G_MISS_DATE --smahapat fee type soln interpreted as en accrual for stub payment
155: ,kle_fee_id NUMBER := OKC_API.G_MISS_NUM
156: -- Use ONLY in case this fees is for a Specific Line (Asset Line / Loan Line)
157: ,kle_asset_id NUMBER := OKC_API.G_MISS_NUM
158: -- Per-Record Details
159: ,level_index_number NUMBER := OKC_API.G_MISS_NUM
160: ,level_type OKL_SIF_FEES_V.level_type%TYPE := OKC_API.G_MISS_CHAR
161: ,number_of_periods NUMBER := OKC_API.G_MISS_NUM
155: ,kle_fee_id NUMBER := OKC_API.G_MISS_NUM
156: -- Use ONLY in case this fees is for a Specific Line (Asset Line / Loan Line)
157: ,kle_asset_id NUMBER := OKC_API.G_MISS_NUM
158: -- Per-Record Details
159: ,level_index_number NUMBER := OKC_API.G_MISS_NUM
160: ,level_type OKL_SIF_FEES_V.level_type%TYPE := OKC_API.G_MISS_CHAR
161: ,number_of_periods NUMBER := OKC_API.G_MISS_NUM
162: ,amount NUMBER := OKC_API.G_MISS_NUM
163: ,rate NUMBER := OKC_API.G_MISS_NUM
156: -- Use ONLY in case this fees is for a Specific Line (Asset Line / Loan Line)
157: ,kle_asset_id NUMBER := OKC_API.G_MISS_NUM
158: -- Per-Record Details
159: ,level_index_number NUMBER := OKC_API.G_MISS_NUM
160: ,level_type OKL_SIF_FEES_V.level_type%TYPE := OKC_API.G_MISS_CHAR
161: ,number_of_periods NUMBER := OKC_API.G_MISS_NUM
162: ,amount NUMBER := OKC_API.G_MISS_NUM
163: ,rate NUMBER := OKC_API.G_MISS_NUM
164: ,lock_level_step OKL_SIF_FEES_V.lock_level_step%TYPE := OKC_API.G_MISS_CHAR
157: ,kle_asset_id NUMBER := OKC_API.G_MISS_NUM
158: -- Per-Record Details
159: ,level_index_number NUMBER := OKC_API.G_MISS_NUM
160: ,level_type OKL_SIF_FEES_V.level_type%TYPE := OKC_API.G_MISS_CHAR
161: ,number_of_periods NUMBER := OKC_API.G_MISS_NUM
162: ,amount NUMBER := OKC_API.G_MISS_NUM
163: ,rate NUMBER := OKC_API.G_MISS_NUM
164: ,lock_level_step OKL_SIF_FEES_V.lock_level_step%TYPE := OKC_API.G_MISS_CHAR
165: ,period OKL_SIF_FEES_V.period%TYPE := OKC_API.G_MISS_CHAR
158: -- Per-Record Details
159: ,level_index_number NUMBER := OKC_API.G_MISS_NUM
160: ,level_type OKL_SIF_FEES_V.level_type%TYPE := OKC_API.G_MISS_CHAR
161: ,number_of_periods NUMBER := OKC_API.G_MISS_NUM
162: ,amount NUMBER := OKC_API.G_MISS_NUM
163: ,rate NUMBER := OKC_API.G_MISS_NUM
164: ,lock_level_step OKL_SIF_FEES_V.lock_level_step%TYPE := OKC_API.G_MISS_CHAR
165: ,period OKL_SIF_FEES_V.period%TYPE := OKC_API.G_MISS_CHAR
166: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
159: ,level_index_number NUMBER := OKC_API.G_MISS_NUM
160: ,level_type OKL_SIF_FEES_V.level_type%TYPE := OKC_API.G_MISS_CHAR
161: ,number_of_periods NUMBER := OKC_API.G_MISS_NUM
162: ,amount NUMBER := OKC_API.G_MISS_NUM
163: ,rate NUMBER := OKC_API.G_MISS_NUM
164: ,lock_level_step OKL_SIF_FEES_V.lock_level_step%TYPE := OKC_API.G_MISS_CHAR
165: ,period OKL_SIF_FEES_V.period%TYPE := OKC_API.G_MISS_CHAR
166: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
167: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
160: ,level_type OKL_SIF_FEES_V.level_type%TYPE := OKC_API.G_MISS_CHAR
161: ,number_of_periods NUMBER := OKC_API.G_MISS_NUM
162: ,amount NUMBER := OKC_API.G_MISS_NUM
163: ,rate NUMBER := OKC_API.G_MISS_NUM
164: ,lock_level_step OKL_SIF_FEES_V.lock_level_step%TYPE := OKC_API.G_MISS_CHAR
165: ,period OKL_SIF_FEES_V.period%TYPE := OKC_API.G_MISS_CHAR
166: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
167: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
168: ,fee_type OKL_K_LINES_v.fee_type%TYPE := OKC_API.G_MISS_CHAR --SGORANTL ADDED FOR FINANCE FEES
161: ,number_of_periods NUMBER := OKC_API.G_MISS_NUM
162: ,amount NUMBER := OKC_API.G_MISS_NUM
163: ,rate NUMBER := OKC_API.G_MISS_NUM
164: ,lock_level_step OKL_SIF_FEES_V.lock_level_step%TYPE := OKC_API.G_MISS_CHAR
165: ,period OKL_SIF_FEES_V.period%TYPE := OKC_API.G_MISS_CHAR
166: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
167: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
168: ,fee_type OKL_K_LINES_v.fee_type%TYPE := OKC_API.G_MISS_CHAR --SGORANTL ADDED FOR FINANCE FEES
169: -- 04/29/2002, mvasudev
162: ,amount NUMBER := OKC_API.G_MISS_NUM
163: ,rate NUMBER := OKC_API.G_MISS_NUM
164: ,lock_level_step OKL_SIF_FEES_V.lock_level_step%TYPE := OKC_API.G_MISS_CHAR
165: ,period OKL_SIF_FEES_V.period%TYPE := OKC_API.G_MISS_CHAR
166: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
167: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
168: ,fee_type OKL_K_LINES_v.fee_type%TYPE := OKC_API.G_MISS_CHAR --SGORANTL ADDED FOR FINANCE FEES
169: -- 04/29/2002, mvasudev
170: -- added for "Restructure" requirements
163: ,rate NUMBER := OKC_API.G_MISS_NUM
164: ,lock_level_step OKL_SIF_FEES_V.lock_level_step%TYPE := OKC_API.G_MISS_CHAR
165: ,period OKL_SIF_FEES_V.period%TYPE := OKC_API.G_MISS_CHAR
166: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
167: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
168: ,fee_type OKL_K_LINES_v.fee_type%TYPE := OKC_API.G_MISS_CHAR --SGORANTL ADDED FOR FINANCE FEES
169: -- 04/29/2002, mvasudev
170: -- added for "Restructure" requirements
171: ,query_level_yn OKL_SIF_FEES_V.query_level_yn%TYPE := OKC_API.G_MISS_CHAR
164: ,lock_level_step OKL_SIF_FEES_V.lock_level_step%TYPE := OKC_API.G_MISS_CHAR
165: ,period OKL_SIF_FEES_V.period%TYPE := OKC_API.G_MISS_CHAR
166: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
167: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
168: ,fee_type OKL_K_LINES_v.fee_type%TYPE := OKC_API.G_MISS_CHAR --SGORANTL ADDED FOR FINANCE FEES
169: -- 04/29/2002, mvasudev
170: -- added for "Restructure" requirements
171: ,query_level_yn OKL_SIF_FEES_V.query_level_yn%TYPE := OKC_API.G_MISS_CHAR
172: -- 06/13/2002
167: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
168: ,fee_type OKL_K_LINES_v.fee_type%TYPE := OKC_API.G_MISS_CHAR --SGORANTL ADDED FOR FINANCE FEES
169: -- 04/29/2002, mvasudev
170: -- added for "Restructure" requirements
171: ,query_level_yn OKL_SIF_FEES_V.query_level_yn%TYPE := OKC_API.G_MISS_CHAR
172: -- 06/13/2002
173: ,structure OKL_SIF_FEES_V.structure%TYPE := OKC_API.G_MISS_CHAR
174: ,cash_effect_yn OKL_SIF_FEES_V.cash_effect_yn%TYPE := OKC_API.G_MISS_CHAR
175: ,tax_effect_yn OKL_SIF_FEES_V.tax_effect_yn%TYPE := OKC_API.G_MISS_CHAR
169: -- 04/29/2002, mvasudev
170: -- added for "Restructure" requirements
171: ,query_level_yn OKL_SIF_FEES_V.query_level_yn%TYPE := OKC_API.G_MISS_CHAR
172: -- 06/13/2002
173: ,structure OKL_SIF_FEES_V.structure%TYPE := OKC_API.G_MISS_CHAR
174: ,cash_effect_yn OKL_SIF_FEES_V.cash_effect_yn%TYPE := OKC_API.G_MISS_CHAR
175: ,tax_effect_yn OKL_SIF_FEES_V.tax_effect_yn%TYPE := OKC_API.G_MISS_CHAR
176: ,days_in_month OKL_SIF_FEES_V.days_in_month%TYPE :=OKC_API.G_MISS_CHAR
177: ,days_in_year OKL_SIF_FEES_V.days_in_year%TYPE :=OKC_API.G_MISS_CHAR
170: -- added for "Restructure" requirements
171: ,query_level_yn OKL_SIF_FEES_V.query_level_yn%TYPE := OKC_API.G_MISS_CHAR
172: -- 06/13/2002
173: ,structure OKL_SIF_FEES_V.structure%TYPE := OKC_API.G_MISS_CHAR
174: ,cash_effect_yn OKL_SIF_FEES_V.cash_effect_yn%TYPE := OKC_API.G_MISS_CHAR
175: ,tax_effect_yn OKL_SIF_FEES_V.tax_effect_yn%TYPE := OKC_API.G_MISS_CHAR
176: ,days_in_month OKL_SIF_FEES_V.days_in_month%TYPE :=OKC_API.G_MISS_CHAR
177: ,days_in_year OKL_SIF_FEES_V.days_in_year%TYPE :=OKC_API.G_MISS_CHAR
178: ,down_payment_amount NUMBER := OKC_API.G_MISS_NUM
171: ,query_level_yn OKL_SIF_FEES_V.query_level_yn%TYPE := OKC_API.G_MISS_CHAR
172: -- 06/13/2002
173: ,structure OKL_SIF_FEES_V.structure%TYPE := OKC_API.G_MISS_CHAR
174: ,cash_effect_yn OKL_SIF_FEES_V.cash_effect_yn%TYPE := OKC_API.G_MISS_CHAR
175: ,tax_effect_yn OKL_SIF_FEES_V.tax_effect_yn%TYPE := OKC_API.G_MISS_CHAR
176: ,days_in_month OKL_SIF_FEES_V.days_in_month%TYPE :=OKC_API.G_MISS_CHAR
177: ,days_in_year OKL_SIF_FEES_V.days_in_year%TYPE :=OKC_API.G_MISS_CHAR
178: ,down_payment_amount NUMBER := OKC_API.G_MISS_NUM
179: ,date_paid OKL_SIF_FEES_V.DATE_PAID%TYPE := OKC_API.G_MISS_DATE -- RGOOTY: Bug 7552496
172: -- 06/13/2002
173: ,structure OKL_SIF_FEES_V.structure%TYPE := OKC_API.G_MISS_CHAR
174: ,cash_effect_yn OKL_SIF_FEES_V.cash_effect_yn%TYPE := OKC_API.G_MISS_CHAR
175: ,tax_effect_yn OKL_SIF_FEES_V.tax_effect_yn%TYPE := OKC_API.G_MISS_CHAR
176: ,days_in_month OKL_SIF_FEES_V.days_in_month%TYPE :=OKC_API.G_MISS_CHAR
177: ,days_in_year OKL_SIF_FEES_V.days_in_year%TYPE :=OKC_API.G_MISS_CHAR
178: ,down_payment_amount NUMBER := OKC_API.G_MISS_NUM
179: ,date_paid OKL_SIF_FEES_V.DATE_PAID%TYPE := OKC_API.G_MISS_DATE -- RGOOTY: Bug 7552496
180: -- add reference to the external ID
173: ,structure OKL_SIF_FEES_V.structure%TYPE := OKC_API.G_MISS_CHAR
174: ,cash_effect_yn OKL_SIF_FEES_V.cash_effect_yn%TYPE := OKC_API.G_MISS_CHAR
175: ,tax_effect_yn OKL_SIF_FEES_V.tax_effect_yn%TYPE := OKC_API.G_MISS_CHAR
176: ,days_in_month OKL_SIF_FEES_V.days_in_month%TYPE :=OKC_API.G_MISS_CHAR
177: ,days_in_year OKL_SIF_FEES_V.days_in_year%TYPE :=OKC_API.G_MISS_CHAR
178: ,down_payment_amount NUMBER := OKC_API.G_MISS_NUM
179: ,date_paid OKL_SIF_FEES_V.DATE_PAID%TYPE := OKC_API.G_MISS_DATE -- RGOOTY: Bug 7552496
180: -- add reference to the external ID
181: ,orig_contract_line_id NUMBER := OKC_API.G_MISS_NUM
174: ,cash_effect_yn OKL_SIF_FEES_V.cash_effect_yn%TYPE := OKC_API.G_MISS_CHAR
175: ,tax_effect_yn OKL_SIF_FEES_V.tax_effect_yn%TYPE := OKC_API.G_MISS_CHAR
176: ,days_in_month OKL_SIF_FEES_V.days_in_month%TYPE :=OKC_API.G_MISS_CHAR
177: ,days_in_year OKL_SIF_FEES_V.days_in_year%TYPE :=OKC_API.G_MISS_CHAR
178: ,down_payment_amount NUMBER := OKC_API.G_MISS_NUM
179: ,date_paid OKL_SIF_FEES_V.DATE_PAID%TYPE := OKC_API.G_MISS_DATE -- RGOOTY: Bug 7552496
180: -- add reference to the external ID
181: ,orig_contract_line_id NUMBER := OKC_API.G_MISS_NUM
182: );
175: ,tax_effect_yn OKL_SIF_FEES_V.tax_effect_yn%TYPE := OKC_API.G_MISS_CHAR
176: ,days_in_month OKL_SIF_FEES_V.days_in_month%TYPE :=OKC_API.G_MISS_CHAR
177: ,days_in_year OKL_SIF_FEES_V.days_in_year%TYPE :=OKC_API.G_MISS_CHAR
178: ,down_payment_amount NUMBER := OKC_API.G_MISS_NUM
179: ,date_paid OKL_SIF_FEES_V.DATE_PAID%TYPE := OKC_API.G_MISS_DATE -- RGOOTY: Bug 7552496
180: -- add reference to the external ID
181: ,orig_contract_line_id NUMBER := OKC_API.G_MISS_NUM
182: );
183: TYPE csm_periodic_expenses_tbl_type IS TABLE OF csm_periodic_expenses_rec_type
177: ,days_in_year OKL_SIF_FEES_V.days_in_year%TYPE :=OKC_API.G_MISS_CHAR
178: ,down_payment_amount NUMBER := OKC_API.G_MISS_NUM
179: ,date_paid OKL_SIF_FEES_V.DATE_PAID%TYPE := OKC_API.G_MISS_DATE -- RGOOTY: Bug 7552496
180: -- add reference to the external ID
181: ,orig_contract_line_id NUMBER := OKC_API.G_MISS_NUM
182: );
183: TYPE csm_periodic_expenses_tbl_type IS TABLE OF csm_periodic_expenses_rec_type
184: INDEX BY BINARY_INTEGER;
185: /* Stream Types*/
183: TYPE csm_periodic_expenses_tbl_type IS TABLE OF csm_periodic_expenses_rec_type
184: INDEX BY BINARY_INTEGER;
185: /* Stream Types*/
186: TYPE csm_yields_rec_type IS RECORD(
187: yield_name OKL_SIF_YIELDS_V.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
188: method OKL_SIF_YIELDS_V.METHOD%TYPE := OKC_API.G_MISS_CHAR,
189: array_type OKL_SIF_YIELDS_V.ARRAY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
190: roe_type OKL_SIF_YIELDS_V.ROE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
191: roe_base OKL_SIF_YIELDS_V.ROE_BASE%TYPE := OKC_API.G_MISS_CHAR,
184: INDEX BY BINARY_INTEGER;
185: /* Stream Types*/
186: TYPE csm_yields_rec_type IS RECORD(
187: yield_name OKL_SIF_YIELDS_V.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
188: method OKL_SIF_YIELDS_V.METHOD%TYPE := OKC_API.G_MISS_CHAR,
189: array_type OKL_SIF_YIELDS_V.ARRAY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
190: roe_type OKL_SIF_YIELDS_V.ROE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
191: roe_base OKL_SIF_YIELDS_V.ROE_BASE%TYPE := OKC_API.G_MISS_CHAR,
192: compounded_method OKL_SIF_YIELDS_V.COMPOUNDED_METHOD%TYPE := OKC_API.G_MISS_CHAR,
185: /* Stream Types*/
186: TYPE csm_yields_rec_type IS RECORD(
187: yield_name OKL_SIF_YIELDS_V.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
188: method OKL_SIF_YIELDS_V.METHOD%TYPE := OKC_API.G_MISS_CHAR,
189: array_type OKL_SIF_YIELDS_V.ARRAY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
190: roe_type OKL_SIF_YIELDS_V.ROE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
191: roe_base OKL_SIF_YIELDS_V.ROE_BASE%TYPE := OKC_API.G_MISS_CHAR,
192: compounded_method OKL_SIF_YIELDS_V.COMPOUNDED_METHOD%TYPE := OKC_API.G_MISS_CHAR,
193: target_value NUMBER := OKC_API.G_MISS_NUM,
186: TYPE csm_yields_rec_type IS RECORD(
187: yield_name OKL_SIF_YIELDS_V.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
188: method OKL_SIF_YIELDS_V.METHOD%TYPE := OKC_API.G_MISS_CHAR,
189: array_type OKL_SIF_YIELDS_V.ARRAY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
190: roe_type OKL_SIF_YIELDS_V.ROE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
191: roe_base OKL_SIF_YIELDS_V.ROE_BASE%TYPE := OKC_API.G_MISS_CHAR,
192: compounded_method OKL_SIF_YIELDS_V.COMPOUNDED_METHOD%TYPE := OKC_API.G_MISS_CHAR,
193: target_value NUMBER := OKC_API.G_MISS_NUM,
194: nominal_yn OKL_SIF_YIELDS_V.NOMINAL_YN%TYPE := OKC_API.G_MISS_CHAR,
187: yield_name OKL_SIF_YIELDS_V.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
188: method OKL_SIF_YIELDS_V.METHOD%TYPE := OKC_API.G_MISS_CHAR,
189: array_type OKL_SIF_YIELDS_V.ARRAY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
190: roe_type OKL_SIF_YIELDS_V.ROE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
191: roe_base OKL_SIF_YIELDS_V.ROE_BASE%TYPE := OKC_API.G_MISS_CHAR,
192: compounded_method OKL_SIF_YIELDS_V.COMPOUNDED_METHOD%TYPE := OKC_API.G_MISS_CHAR,
193: target_value NUMBER := OKC_API.G_MISS_NUM,
194: nominal_yn OKL_SIF_YIELDS_V.NOMINAL_YN%TYPE := OKC_API.G_MISS_CHAR,
195: -- 04/29/2002, mvasudev
188: method OKL_SIF_YIELDS_V.METHOD%TYPE := OKC_API.G_MISS_CHAR,
189: array_type OKL_SIF_YIELDS_V.ARRAY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
190: roe_type OKL_SIF_YIELDS_V.ROE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
191: roe_base OKL_SIF_YIELDS_V.ROE_BASE%TYPE := OKC_API.G_MISS_CHAR,
192: compounded_method OKL_SIF_YIELDS_V.COMPOUNDED_METHOD%TYPE := OKC_API.G_MISS_CHAR,
193: target_value NUMBER := OKC_API.G_MISS_NUM,
194: nominal_yn OKL_SIF_YIELDS_V.NOMINAL_YN%TYPE := OKC_API.G_MISS_CHAR,
195: -- 04/29/2002, mvasudev
196: -- added for "Restructure" requirements
189: array_type OKL_SIF_YIELDS_V.ARRAY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
190: roe_type OKL_SIF_YIELDS_V.ROE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
191: roe_base OKL_SIF_YIELDS_V.ROE_BASE%TYPE := OKC_API.G_MISS_CHAR,
192: compounded_method OKL_SIF_YIELDS_V.COMPOUNDED_METHOD%TYPE := OKC_API.G_MISS_CHAR,
193: target_value NUMBER := OKC_API.G_MISS_NUM,
194: nominal_yn OKL_SIF_YIELDS_V.NOMINAL_YN%TYPE := OKC_API.G_MISS_CHAR,
195: -- 04/29/2002, mvasudev
196: -- added for "Restructure" requirements
197: pre_tax_yn OKL_SIF_YIELDS_V.PRE_TAX_YN%TYPE := OKC_API.G_MISS_CHAR,
190: roe_type OKL_SIF_YIELDS_V.ROE_TYPE%TYPE := OKC_API.G_MISS_CHAR,
191: roe_base OKL_SIF_YIELDS_V.ROE_BASE%TYPE := OKC_API.G_MISS_CHAR,
192: compounded_method OKL_SIF_YIELDS_V.COMPOUNDED_METHOD%TYPE := OKC_API.G_MISS_CHAR,
193: target_value NUMBER := OKC_API.G_MISS_NUM,
194: nominal_yn OKL_SIF_YIELDS_V.NOMINAL_YN%TYPE := OKC_API.G_MISS_CHAR,
195: -- 04/29/2002, mvasudev
196: -- added for "Restructure" requirements
197: pre_tax_yn OKL_SIF_YIELDS_V.PRE_TAX_YN%TYPE := OKC_API.G_MISS_CHAR,
198: -- 06/24/2002, mvasudev
193: target_value NUMBER := OKC_API.G_MISS_NUM,
194: nominal_yn OKL_SIF_YIELDS_V.NOMINAL_YN%TYPE := OKC_API.G_MISS_CHAR,
195: -- 04/29/2002, mvasudev
196: -- added for "Restructure" requirements
197: pre_tax_yn OKL_SIF_YIELDS_V.PRE_TAX_YN%TYPE := OKC_API.G_MISS_CHAR,
198: -- 06/24/2002, mvasudev
199: -- added for "sno" requirements
200: siy_type OKL_SIF_YIELDS_V.SIY_TYPE%TYPE := OKC_API.G_MISS_CHAR
201: );
196: -- added for "Restructure" requirements
197: pre_tax_yn OKL_SIF_YIELDS_V.PRE_TAX_YN%TYPE := OKC_API.G_MISS_CHAR,
198: -- 06/24/2002, mvasudev
199: -- added for "sno" requirements
200: siy_type OKL_SIF_YIELDS_V.SIY_TYPE%TYPE := OKC_API.G_MISS_CHAR
201: );
202: TYPE csm_yields_tbl_type IS TABLE OF csm_yields_rec_type
203: INDEX BY BINARY_INTEGER;
204: /* Stream Types*/
202: TYPE csm_yields_tbl_type IS TABLE OF csm_yields_rec_type
203: INDEX BY BINARY_INTEGER;
204: /* Stream Types*/
205: TYPE csm_stream_types_rec_type IS RECORD(
206: stream_type_id NUMBER := OKC_API.G_MISS_NUM
207: ,kle_asset_id NUMBER := OKC_API.G_MISS_NUM
208: ,kle_fee_id NUMBER := OKC_API.G_MISS_NUM
209: ,pricing_name OKL_SIF_STREAM_TYPES_V.PRICING_NAME%type := OKC_API.G_MISS_CHAR
210: );
203: INDEX BY BINARY_INTEGER;
204: /* Stream Types*/
205: TYPE csm_stream_types_rec_type IS RECORD(
206: stream_type_id NUMBER := OKC_API.G_MISS_NUM
207: ,kle_asset_id NUMBER := OKC_API.G_MISS_NUM
208: ,kle_fee_id NUMBER := OKC_API.G_MISS_NUM
209: ,pricing_name OKL_SIF_STREAM_TYPES_V.PRICING_NAME%type := OKC_API.G_MISS_CHAR
210: );
211: TYPE csm_stream_types_tbl_type IS TABLE OF csm_stream_types_rec_type
204: /* Stream Types*/
205: TYPE csm_stream_types_rec_type IS RECORD(
206: stream_type_id NUMBER := OKC_API.G_MISS_NUM
207: ,kle_asset_id NUMBER := OKC_API.G_MISS_NUM
208: ,kle_fee_id NUMBER := OKC_API.G_MISS_NUM
209: ,pricing_name OKL_SIF_STREAM_TYPES_V.PRICING_NAME%type := OKC_API.G_MISS_CHAR
210: );
211: TYPE csm_stream_types_tbl_type IS TABLE OF csm_stream_types_rec_type
212: INDEX BY BINARY_INTEGER;
205: TYPE csm_stream_types_rec_type IS RECORD(
206: stream_type_id NUMBER := OKC_API.G_MISS_NUM
207: ,kle_asset_id NUMBER := OKC_API.G_MISS_NUM
208: ,kle_fee_id NUMBER := OKC_API.G_MISS_NUM
209: ,pricing_name OKL_SIF_STREAM_TYPES_V.PRICING_NAME%type := OKC_API.G_MISS_CHAR
210: );
211: TYPE csm_stream_types_tbl_type IS TABLE OF csm_stream_types_rec_type
212: INDEX BY BINARY_INTEGER;
213: /* -- "Lease" Specific Definitions -- */
212: INDEX BY BINARY_INTEGER;
213: /* -- "Lease" Specific Definitions -- */
214: /* Line Level Details Record */
215: TYPE csm_line_details_rec_type IS RECORD(
216: kle_asset_id NUMBER := OKC_API.G_MISS_NUM
217: ,state_depre_dmnshing_value_rt NUMBER := OKC_API.G_MISS_NUM
218: ,book_depre_dmnshing_value_rt NUMBER := OKC_API.G_MISS_NUM
219: ,residual_guarantee_method OKL_SIF_LINES_V.residual_guarantee_method%TYPE := OKC_API.G_MISS_CHAR
220: ,fed_depre_term NUMBER := OKC_API.G_MISS_NUM
213: /* -- "Lease" Specific Definitions -- */
214: /* Line Level Details Record */
215: TYPE csm_line_details_rec_type IS RECORD(
216: kle_asset_id NUMBER := OKC_API.G_MISS_NUM
217: ,state_depre_dmnshing_value_rt NUMBER := OKC_API.G_MISS_NUM
218: ,book_depre_dmnshing_value_rt NUMBER := OKC_API.G_MISS_NUM
219: ,residual_guarantee_method OKL_SIF_LINES_V.residual_guarantee_method%TYPE := OKC_API.G_MISS_CHAR
220: ,fed_depre_term NUMBER := OKC_API.G_MISS_NUM
221: ,fed_depre_dmnshing_value_rate NUMBER := OKC_API.G_MISS_NUM
214: /* Line Level Details Record */
215: TYPE csm_line_details_rec_type IS RECORD(
216: kle_asset_id NUMBER := OKC_API.G_MISS_NUM
217: ,state_depre_dmnshing_value_rt NUMBER := OKC_API.G_MISS_NUM
218: ,book_depre_dmnshing_value_rt NUMBER := OKC_API.G_MISS_NUM
219: ,residual_guarantee_method OKL_SIF_LINES_V.residual_guarantee_method%TYPE := OKC_API.G_MISS_CHAR
220: ,fed_depre_term NUMBER := OKC_API.G_MISS_NUM
221: ,fed_depre_dmnshing_value_rate NUMBER := OKC_API.G_MISS_NUM
222: ,fed_depre_adr_conve OKL_SIF_LINES_V.fed_depre_adr_conve%TYPE := OKC_API.G_MISS_CHAR
215: TYPE csm_line_details_rec_type IS RECORD(
216: kle_asset_id NUMBER := OKC_API.G_MISS_NUM
217: ,state_depre_dmnshing_value_rt NUMBER := OKC_API.G_MISS_NUM
218: ,book_depre_dmnshing_value_rt NUMBER := OKC_API.G_MISS_NUM
219: ,residual_guarantee_method OKL_SIF_LINES_V.residual_guarantee_method%TYPE := OKC_API.G_MISS_CHAR
220: ,fed_depre_term NUMBER := OKC_API.G_MISS_NUM
221: ,fed_depre_dmnshing_value_rate NUMBER := OKC_API.G_MISS_NUM
222: ,fed_depre_adr_conve OKL_SIF_LINES_V.fed_depre_adr_conve%TYPE := OKC_API.G_MISS_CHAR
223: ,state_depre_basis_percent NUMBER := OKC_API.G_MISS_NUM
216: kle_asset_id NUMBER := OKC_API.G_MISS_NUM
217: ,state_depre_dmnshing_value_rt NUMBER := OKC_API.G_MISS_NUM
218: ,book_depre_dmnshing_value_rt NUMBER := OKC_API.G_MISS_NUM
219: ,residual_guarantee_method OKL_SIF_LINES_V.residual_guarantee_method%TYPE := OKC_API.G_MISS_CHAR
220: ,fed_depre_term NUMBER := OKC_API.G_MISS_NUM
221: ,fed_depre_dmnshing_value_rate NUMBER := OKC_API.G_MISS_NUM
222: ,fed_depre_adr_conve OKL_SIF_LINES_V.fed_depre_adr_conve%TYPE := OKC_API.G_MISS_CHAR
223: ,state_depre_basis_percent NUMBER := OKC_API.G_MISS_NUM
224: ,state_depre_method OKL_SIF_LINES_V.state_depre_method%TYPE := OKC_API.G_MISS_CHAR
217: ,state_depre_dmnshing_value_rt NUMBER := OKC_API.G_MISS_NUM
218: ,book_depre_dmnshing_value_rt NUMBER := OKC_API.G_MISS_NUM
219: ,residual_guarantee_method OKL_SIF_LINES_V.residual_guarantee_method%TYPE := OKC_API.G_MISS_CHAR
220: ,fed_depre_term NUMBER := OKC_API.G_MISS_NUM
221: ,fed_depre_dmnshing_value_rate NUMBER := OKC_API.G_MISS_NUM
222: ,fed_depre_adr_conve OKL_SIF_LINES_V.fed_depre_adr_conve%TYPE := OKC_API.G_MISS_CHAR
223: ,state_depre_basis_percent NUMBER := OKC_API.G_MISS_NUM
224: ,state_depre_method OKL_SIF_LINES_V.state_depre_method%TYPE := OKC_API.G_MISS_CHAR
225: ,purchase_option OKL_SIF_LINES_V.purchase_option%TYPE := OKC_API.G_MISS_CHAR
218: ,book_depre_dmnshing_value_rt NUMBER := OKC_API.G_MISS_NUM
219: ,residual_guarantee_method OKL_SIF_LINES_V.residual_guarantee_method%TYPE := OKC_API.G_MISS_CHAR
220: ,fed_depre_term NUMBER := OKC_API.G_MISS_NUM
221: ,fed_depre_dmnshing_value_rate NUMBER := OKC_API.G_MISS_NUM
222: ,fed_depre_adr_conve OKL_SIF_LINES_V.fed_depre_adr_conve%TYPE := OKC_API.G_MISS_CHAR
223: ,state_depre_basis_percent NUMBER := OKC_API.G_MISS_NUM
224: ,state_depre_method OKL_SIF_LINES_V.state_depre_method%TYPE := OKC_API.G_MISS_CHAR
225: ,purchase_option OKL_SIF_LINES_V.purchase_option%TYPE := OKC_API.G_MISS_CHAR
226: ,purchase_option_amount NUMBER := OKC_API.G_MISS_NUM
219: ,residual_guarantee_method OKL_SIF_LINES_V.residual_guarantee_method%TYPE := OKC_API.G_MISS_CHAR
220: ,fed_depre_term NUMBER := OKC_API.G_MISS_NUM
221: ,fed_depre_dmnshing_value_rate NUMBER := OKC_API.G_MISS_NUM
222: ,fed_depre_adr_conve OKL_SIF_LINES_V.fed_depre_adr_conve%TYPE := OKC_API.G_MISS_CHAR
223: ,state_depre_basis_percent NUMBER := OKC_API.G_MISS_NUM
224: ,state_depre_method OKL_SIF_LINES_V.state_depre_method%TYPE := OKC_API.G_MISS_CHAR
225: ,purchase_option OKL_SIF_LINES_V.purchase_option%TYPE := OKC_API.G_MISS_CHAR
226: ,purchase_option_amount NUMBER := OKC_API.G_MISS_NUM
227: ,asset_cost NUMBER := OKC_API.G_MISS_NUM
220: ,fed_depre_term NUMBER := OKC_API.G_MISS_NUM
221: ,fed_depre_dmnshing_value_rate NUMBER := OKC_API.G_MISS_NUM
222: ,fed_depre_adr_conve OKL_SIF_LINES_V.fed_depre_adr_conve%TYPE := OKC_API.G_MISS_CHAR
223: ,state_depre_basis_percent NUMBER := OKC_API.G_MISS_NUM
224: ,state_depre_method OKL_SIF_LINES_V.state_depre_method%TYPE := OKC_API.G_MISS_CHAR
225: ,purchase_option OKL_SIF_LINES_V.purchase_option%TYPE := OKC_API.G_MISS_CHAR
226: ,purchase_option_amount NUMBER := OKC_API.G_MISS_NUM
227: ,asset_cost NUMBER := OKC_API.G_MISS_NUM
228: ,state_depre_term NUMBER := OKC_API.G_MISS_NUM
221: ,fed_depre_dmnshing_value_rate NUMBER := OKC_API.G_MISS_NUM
222: ,fed_depre_adr_conve OKL_SIF_LINES_V.fed_depre_adr_conve%TYPE := OKC_API.G_MISS_CHAR
223: ,state_depre_basis_percent NUMBER := OKC_API.G_MISS_NUM
224: ,state_depre_method OKL_SIF_LINES_V.state_depre_method%TYPE := OKC_API.G_MISS_CHAR
225: ,purchase_option OKL_SIF_LINES_V.purchase_option%TYPE := OKC_API.G_MISS_CHAR
226: ,purchase_option_amount NUMBER := OKC_API.G_MISS_NUM
227: ,asset_cost NUMBER := OKC_API.G_MISS_NUM
228: ,state_depre_term NUMBER := OKC_API.G_MISS_NUM
229: ,state_depre_adr_convent OKL_SIF_LINES_V.state_depre_adr_convent%TYPE := OKC_API.G_MISS_CHAR
222: ,fed_depre_adr_conve OKL_SIF_LINES_V.fed_depre_adr_conve%TYPE := OKC_API.G_MISS_CHAR
223: ,state_depre_basis_percent NUMBER := OKC_API.G_MISS_NUM
224: ,state_depre_method OKL_SIF_LINES_V.state_depre_method%TYPE := OKC_API.G_MISS_CHAR
225: ,purchase_option OKL_SIF_LINES_V.purchase_option%TYPE := OKC_API.G_MISS_CHAR
226: ,purchase_option_amount NUMBER := OKC_API.G_MISS_NUM
227: ,asset_cost NUMBER := OKC_API.G_MISS_NUM
228: ,state_depre_term NUMBER := OKC_API.G_MISS_NUM
229: ,state_depre_adr_convent OKL_SIF_LINES_V.state_depre_adr_convent%TYPE := OKC_API.G_MISS_CHAR
230: ,fed_depre_method OKL_SIF_LINES_V.fed_depre_method%TYPE := OKC_API.G_MISS_CHAR
223: ,state_depre_basis_percent NUMBER := OKC_API.G_MISS_NUM
224: ,state_depre_method OKL_SIF_LINES_V.state_depre_method%TYPE := OKC_API.G_MISS_CHAR
225: ,purchase_option OKL_SIF_LINES_V.purchase_option%TYPE := OKC_API.G_MISS_CHAR
226: ,purchase_option_amount NUMBER := OKC_API.G_MISS_NUM
227: ,asset_cost NUMBER := OKC_API.G_MISS_NUM
228: ,state_depre_term NUMBER := OKC_API.G_MISS_NUM
229: ,state_depre_adr_convent OKL_SIF_LINES_V.state_depre_adr_convent%TYPE := OKC_API.G_MISS_CHAR
230: ,fed_depre_method OKL_SIF_LINES_V.fed_depre_method%TYPE := OKC_API.G_MISS_CHAR
231: ,residual_amount NUMBER := OKC_API.G_MISS_NUM
224: ,state_depre_method OKL_SIF_LINES_V.state_depre_method%TYPE := OKC_API.G_MISS_CHAR
225: ,purchase_option OKL_SIF_LINES_V.purchase_option%TYPE := OKC_API.G_MISS_CHAR
226: ,purchase_option_amount NUMBER := OKC_API.G_MISS_NUM
227: ,asset_cost NUMBER := OKC_API.G_MISS_NUM
228: ,state_depre_term NUMBER := OKC_API.G_MISS_NUM
229: ,state_depre_adr_convent OKL_SIF_LINES_V.state_depre_adr_convent%TYPE := OKC_API.G_MISS_CHAR
230: ,fed_depre_method OKL_SIF_LINES_V.fed_depre_method%TYPE := OKC_API.G_MISS_CHAR
231: ,residual_amount NUMBER := OKC_API.G_MISS_NUM
232: ,residual_date OKL_SIF_LINES_V.residual_date%TYPE := OKC_API.G_MISS_DATE
225: ,purchase_option OKL_SIF_LINES_V.purchase_option%TYPE := OKC_API.G_MISS_CHAR
226: ,purchase_option_amount NUMBER := OKC_API.G_MISS_NUM
227: ,asset_cost NUMBER := OKC_API.G_MISS_NUM
228: ,state_depre_term NUMBER := OKC_API.G_MISS_NUM
229: ,state_depre_adr_convent OKL_SIF_LINES_V.state_depre_adr_convent%TYPE := OKC_API.G_MISS_CHAR
230: ,fed_depre_method OKL_SIF_LINES_V.fed_depre_method%TYPE := OKC_API.G_MISS_CHAR
231: ,residual_amount NUMBER := OKC_API.G_MISS_NUM
232: ,residual_date OKL_SIF_LINES_V.residual_date%TYPE := OKC_API.G_MISS_DATE
233: ,fed_depre_salvage NUMBER := OKC_API.G_MISS_NUM
226: ,purchase_option_amount NUMBER := OKC_API.G_MISS_NUM
227: ,asset_cost NUMBER := OKC_API.G_MISS_NUM
228: ,state_depre_term NUMBER := OKC_API.G_MISS_NUM
229: ,state_depre_adr_convent OKL_SIF_LINES_V.state_depre_adr_convent%TYPE := OKC_API.G_MISS_CHAR
230: ,fed_depre_method OKL_SIF_LINES_V.fed_depre_method%TYPE := OKC_API.G_MISS_CHAR
231: ,residual_amount NUMBER := OKC_API.G_MISS_NUM
232: ,residual_date OKL_SIF_LINES_V.residual_date%TYPE := OKC_API.G_MISS_DATE
233: ,fed_depre_salvage NUMBER := OKC_API.G_MISS_NUM
234: ,date_fed_depre OKL_SIF_LINES_V.date_fed_depre%TYPE := OKC_API.G_MISS_DATE
227: ,asset_cost NUMBER := OKC_API.G_MISS_NUM
228: ,state_depre_term NUMBER := OKC_API.G_MISS_NUM
229: ,state_depre_adr_convent OKL_SIF_LINES_V.state_depre_adr_convent%TYPE := OKC_API.G_MISS_CHAR
230: ,fed_depre_method OKL_SIF_LINES_V.fed_depre_method%TYPE := OKC_API.G_MISS_CHAR
231: ,residual_amount NUMBER := OKC_API.G_MISS_NUM
232: ,residual_date OKL_SIF_LINES_V.residual_date%TYPE := OKC_API.G_MISS_DATE
233: ,fed_depre_salvage NUMBER := OKC_API.G_MISS_NUM
234: ,date_fed_depre OKL_SIF_LINES_V.date_fed_depre%TYPE := OKC_API.G_MISS_DATE
235: ,book_salvage NUMBER := OKC_API.G_MISS_NUM
228: ,state_depre_term NUMBER := OKC_API.G_MISS_NUM
229: ,state_depre_adr_convent OKL_SIF_LINES_V.state_depre_adr_convent%TYPE := OKC_API.G_MISS_CHAR
230: ,fed_depre_method OKL_SIF_LINES_V.fed_depre_method%TYPE := OKC_API.G_MISS_CHAR
231: ,residual_amount NUMBER := OKC_API.G_MISS_NUM
232: ,residual_date OKL_SIF_LINES_V.residual_date%TYPE := OKC_API.G_MISS_DATE
233: ,fed_depre_salvage NUMBER := OKC_API.G_MISS_NUM
234: ,date_fed_depre OKL_SIF_LINES_V.date_fed_depre%TYPE := OKC_API.G_MISS_DATE
235: ,book_salvage NUMBER := OKC_API.G_MISS_NUM
236: ,book_adr_convention OKL_SIF_LINES_V.book_adr_convention%TYPE := OKC_API.G_MISS_CHAR
229: ,state_depre_adr_convent OKL_SIF_LINES_V.state_depre_adr_convent%TYPE := OKC_API.G_MISS_CHAR
230: ,fed_depre_method OKL_SIF_LINES_V.fed_depre_method%TYPE := OKC_API.G_MISS_CHAR
231: ,residual_amount NUMBER := OKC_API.G_MISS_NUM
232: ,residual_date OKL_SIF_LINES_V.residual_date%TYPE := OKC_API.G_MISS_DATE
233: ,fed_depre_salvage NUMBER := OKC_API.G_MISS_NUM
234: ,date_fed_depre OKL_SIF_LINES_V.date_fed_depre%TYPE := OKC_API.G_MISS_DATE
235: ,book_salvage NUMBER := OKC_API.G_MISS_NUM
236: ,book_adr_convention OKL_SIF_LINES_V.book_adr_convention%TYPE := OKC_API.G_MISS_CHAR
237: ,state_depre_salvage NUMBER := OKC_API.G_MISS_NUM
230: ,fed_depre_method OKL_SIF_LINES_V.fed_depre_method%TYPE := OKC_API.G_MISS_CHAR
231: ,residual_amount NUMBER := OKC_API.G_MISS_NUM
232: ,residual_date OKL_SIF_LINES_V.residual_date%TYPE := OKC_API.G_MISS_DATE
233: ,fed_depre_salvage NUMBER := OKC_API.G_MISS_NUM
234: ,date_fed_depre OKL_SIF_LINES_V.date_fed_depre%TYPE := OKC_API.G_MISS_DATE
235: ,book_salvage NUMBER := OKC_API.G_MISS_NUM
236: ,book_adr_convention OKL_SIF_LINES_V.book_adr_convention%TYPE := OKC_API.G_MISS_CHAR
237: ,state_depre_salvage NUMBER := OKC_API.G_MISS_NUM
238: ,fed_depre_basis_percent NUMBER := OKC_API.G_MISS_NUM
231: ,residual_amount NUMBER := OKC_API.G_MISS_NUM
232: ,residual_date OKL_SIF_LINES_V.residual_date%TYPE := OKC_API.G_MISS_DATE
233: ,fed_depre_salvage NUMBER := OKC_API.G_MISS_NUM
234: ,date_fed_depre OKL_SIF_LINES_V.date_fed_depre%TYPE := OKC_API.G_MISS_DATE
235: ,book_salvage NUMBER := OKC_API.G_MISS_NUM
236: ,book_adr_convention OKL_SIF_LINES_V.book_adr_convention%TYPE := OKC_API.G_MISS_CHAR
237: ,state_depre_salvage NUMBER := OKC_API.G_MISS_NUM
238: ,fed_depre_basis_percent NUMBER := OKC_API.G_MISS_NUM
239: ,book_basis_percent NUMBER := OKC_API.G_MISS_NUM
232: ,residual_date OKL_SIF_LINES_V.residual_date%TYPE := OKC_API.G_MISS_DATE
233: ,fed_depre_salvage NUMBER := OKC_API.G_MISS_NUM
234: ,date_fed_depre OKL_SIF_LINES_V.date_fed_depre%TYPE := OKC_API.G_MISS_DATE
235: ,book_salvage NUMBER := OKC_API.G_MISS_NUM
236: ,book_adr_convention OKL_SIF_LINES_V.book_adr_convention%TYPE := OKC_API.G_MISS_CHAR
237: ,state_depre_salvage NUMBER := OKC_API.G_MISS_NUM
238: ,fed_depre_basis_percent NUMBER := OKC_API.G_MISS_NUM
239: ,book_basis_percent NUMBER := OKC_API.G_MISS_NUM
240: ,date_delivery OKL_SIF_LINES_V.date_delivery%TYPE := OKC_API.G_MISS_DATE
233: ,fed_depre_salvage NUMBER := OKC_API.G_MISS_NUM
234: ,date_fed_depre OKL_SIF_LINES_V.date_fed_depre%TYPE := OKC_API.G_MISS_DATE
235: ,book_salvage NUMBER := OKC_API.G_MISS_NUM
236: ,book_adr_convention OKL_SIF_LINES_V.book_adr_convention%TYPE := OKC_API.G_MISS_CHAR
237: ,state_depre_salvage NUMBER := OKC_API.G_MISS_NUM
238: ,fed_depre_basis_percent NUMBER := OKC_API.G_MISS_NUM
239: ,book_basis_percent NUMBER := OKC_API.G_MISS_NUM
240: ,date_delivery OKL_SIF_LINES_V.date_delivery%TYPE := OKC_API.G_MISS_DATE
241: ,book_term NUMBER := OKC_API.G_MISS_NUM
234: ,date_fed_depre OKL_SIF_LINES_V.date_fed_depre%TYPE := OKC_API.G_MISS_DATE
235: ,book_salvage NUMBER := OKC_API.G_MISS_NUM
236: ,book_adr_convention OKL_SIF_LINES_V.book_adr_convention%TYPE := OKC_API.G_MISS_CHAR
237: ,state_depre_salvage NUMBER := OKC_API.G_MISS_NUM
238: ,fed_depre_basis_percent NUMBER := OKC_API.G_MISS_NUM
239: ,book_basis_percent NUMBER := OKC_API.G_MISS_NUM
240: ,date_delivery OKL_SIF_LINES_V.date_delivery%TYPE := OKC_API.G_MISS_DATE
241: ,book_term NUMBER := OKC_API.G_MISS_NUM
242: ,residual_guarantee_amount NUMBER := OKC_API.G_MISS_NUM
235: ,book_salvage NUMBER := OKC_API.G_MISS_NUM
236: ,book_adr_convention OKL_SIF_LINES_V.book_adr_convention%TYPE := OKC_API.G_MISS_CHAR
237: ,state_depre_salvage NUMBER := OKC_API.G_MISS_NUM
238: ,fed_depre_basis_percent NUMBER := OKC_API.G_MISS_NUM
239: ,book_basis_percent NUMBER := OKC_API.G_MISS_NUM
240: ,date_delivery OKL_SIF_LINES_V.date_delivery%TYPE := OKC_API.G_MISS_DATE
241: ,book_term NUMBER := OKC_API.G_MISS_NUM
242: ,residual_guarantee_amount NUMBER := OKC_API.G_MISS_NUM
243: ,date_funding OKL_SIF_LINES_V.date_funding%TYPE := OKC_API.G_MISS_DATE
236: ,book_adr_convention OKL_SIF_LINES_V.book_adr_convention%TYPE := OKC_API.G_MISS_CHAR
237: ,state_depre_salvage NUMBER := OKC_API.G_MISS_NUM
238: ,fed_depre_basis_percent NUMBER := OKC_API.G_MISS_NUM
239: ,book_basis_percent NUMBER := OKC_API.G_MISS_NUM
240: ,date_delivery OKL_SIF_LINES_V.date_delivery%TYPE := OKC_API.G_MISS_DATE
241: ,book_term NUMBER := OKC_API.G_MISS_NUM
242: ,residual_guarantee_amount NUMBER := OKC_API.G_MISS_NUM
243: ,date_funding OKL_SIF_LINES_V.date_funding%TYPE := OKC_API.G_MISS_DATE
244: ,date_book OKL_SIF_LINES_V.date_book%TYPE := OKC_API.G_MISS_DATE
237: ,state_depre_salvage NUMBER := OKC_API.G_MISS_NUM
238: ,fed_depre_basis_percent NUMBER := OKC_API.G_MISS_NUM
239: ,book_basis_percent NUMBER := OKC_API.G_MISS_NUM
240: ,date_delivery OKL_SIF_LINES_V.date_delivery%TYPE := OKC_API.G_MISS_DATE
241: ,book_term NUMBER := OKC_API.G_MISS_NUM
242: ,residual_guarantee_amount NUMBER := OKC_API.G_MISS_NUM
243: ,date_funding OKL_SIF_LINES_V.date_funding%TYPE := OKC_API.G_MISS_DATE
244: ,date_book OKL_SIF_LINES_V.date_book%TYPE := OKC_API.G_MISS_DATE
245: ,date_state_depre OKL_SIF_LINES_V.date_state_depre%TYPE := OKC_API.G_MISS_DATE
238: ,fed_depre_basis_percent NUMBER := OKC_API.G_MISS_NUM
239: ,book_basis_percent NUMBER := OKC_API.G_MISS_NUM
240: ,date_delivery OKL_SIF_LINES_V.date_delivery%TYPE := OKC_API.G_MISS_DATE
241: ,book_term NUMBER := OKC_API.G_MISS_NUM
242: ,residual_guarantee_amount NUMBER := OKC_API.G_MISS_NUM
243: ,date_funding OKL_SIF_LINES_V.date_funding%TYPE := OKC_API.G_MISS_DATE
244: ,date_book OKL_SIF_LINES_V.date_book%TYPE := OKC_API.G_MISS_DATE
245: ,date_state_depre OKL_SIF_LINES_V.date_state_depre%TYPE := OKC_API.G_MISS_DATE
246: ,book_method OKL_SIF_LINES_V.book_method%TYPE := OKC_API.G_MISS_CHAR
239: ,book_basis_percent NUMBER := OKC_API.G_MISS_NUM
240: ,date_delivery OKL_SIF_LINES_V.date_delivery%TYPE := OKC_API.G_MISS_DATE
241: ,book_term NUMBER := OKC_API.G_MISS_NUM
242: ,residual_guarantee_amount NUMBER := OKC_API.G_MISS_NUM
243: ,date_funding OKL_SIF_LINES_V.date_funding%TYPE := OKC_API.G_MISS_DATE
244: ,date_book OKL_SIF_LINES_V.date_book%TYPE := OKC_API.G_MISS_DATE
245: ,date_state_depre OKL_SIF_LINES_V.date_state_depre%TYPE := OKC_API.G_MISS_DATE
246: ,book_method OKL_SIF_LINES_V.book_method%TYPE := OKC_API.G_MISS_CHAR
247: ,description OKL_SIF_LINES_V.description%TYPE := OKC_API.G_MISS_CHAR
240: ,date_delivery OKL_SIF_LINES_V.date_delivery%TYPE := OKC_API.G_MISS_DATE
241: ,book_term NUMBER := OKC_API.G_MISS_NUM
242: ,residual_guarantee_amount NUMBER := OKC_API.G_MISS_NUM
243: ,date_funding OKL_SIF_LINES_V.date_funding%TYPE := OKC_API.G_MISS_DATE
244: ,date_book OKL_SIF_LINES_V.date_book%TYPE := OKC_API.G_MISS_DATE
245: ,date_state_depre OKL_SIF_LINES_V.date_state_depre%TYPE := OKC_API.G_MISS_DATE
246: ,book_method OKL_SIF_LINES_V.book_method%TYPE := OKC_API.G_MISS_CHAR
247: ,description OKL_SIF_LINES_V.description%TYPE := OKC_API.G_MISS_CHAR
248: -- stream_interface_attribute01 => guarantee_type
241: ,book_term NUMBER := OKC_API.G_MISS_NUM
242: ,residual_guarantee_amount NUMBER := OKC_API.G_MISS_NUM
243: ,date_funding OKL_SIF_LINES_V.date_funding%TYPE := OKC_API.G_MISS_DATE
244: ,date_book OKL_SIF_LINES_V.date_book%TYPE := OKC_API.G_MISS_DATE
245: ,date_state_depre OKL_SIF_LINES_V.date_state_depre%TYPE := OKC_API.G_MISS_DATE
246: ,book_method OKL_SIF_LINES_V.book_method%TYPE := OKC_API.G_MISS_CHAR
247: ,description OKL_SIF_LINES_V.description%TYPE := OKC_API.G_MISS_CHAR
248: -- stream_interface_attribute01 => guarantee_type
249: ,guarantee_type OKL_SIF_LINES_V.residual_guarantee_type%TYPE
242: ,residual_guarantee_amount NUMBER := OKC_API.G_MISS_NUM
243: ,date_funding OKL_SIF_LINES_V.date_funding%TYPE := OKC_API.G_MISS_DATE
244: ,date_book OKL_SIF_LINES_V.date_book%TYPE := OKC_API.G_MISS_DATE
245: ,date_state_depre OKL_SIF_LINES_V.date_state_depre%TYPE := OKC_API.G_MISS_DATE
246: ,book_method OKL_SIF_LINES_V.book_method%TYPE := OKC_API.G_MISS_CHAR
247: ,description OKL_SIF_LINES_V.description%TYPE := OKC_API.G_MISS_CHAR
248: -- stream_interface_attribute01 => guarantee_type
249: ,guarantee_type OKL_SIF_LINES_V.residual_guarantee_type%TYPE
250: ,down_payment_amount NUMBER := OKC_API.G_MISS_NUM
243: ,date_funding OKL_SIF_LINES_V.date_funding%TYPE := OKC_API.G_MISS_DATE
244: ,date_book OKL_SIF_LINES_V.date_book%TYPE := OKC_API.G_MISS_DATE
245: ,date_state_depre OKL_SIF_LINES_V.date_state_depre%TYPE := OKC_API.G_MISS_DATE
246: ,book_method OKL_SIF_LINES_V.book_method%TYPE := OKC_API.G_MISS_CHAR
247: ,description OKL_SIF_LINES_V.description%TYPE := OKC_API.G_MISS_CHAR
248: -- stream_interface_attribute01 => guarantee_type
249: ,guarantee_type OKL_SIF_LINES_V.residual_guarantee_type%TYPE
250: ,down_payment_amount NUMBER := OKC_API.G_MISS_NUM
251: ,capitalize_down_payment_yn OKL_SIF_LINES_V.capitalize_down_payment_yn%TYPE := OKC_API.G_MISS_CHAR
246: ,book_method OKL_SIF_LINES_V.book_method%TYPE := OKC_API.G_MISS_CHAR
247: ,description OKL_SIF_LINES_V.description%TYPE := OKC_API.G_MISS_CHAR
248: -- stream_interface_attribute01 => guarantee_type
249: ,guarantee_type OKL_SIF_LINES_V.residual_guarantee_type%TYPE
250: ,down_payment_amount NUMBER := OKC_API.G_MISS_NUM
251: ,capitalize_down_payment_yn OKL_SIF_LINES_V.capitalize_down_payment_yn%TYPE := OKC_API.G_MISS_CHAR
252: -- add reference to the external ID
253: ,orig_contract_line_id NUMBER := OKC_API.G_MISS_NUM
254: );
247: ,description OKL_SIF_LINES_V.description%TYPE := OKC_API.G_MISS_CHAR
248: -- stream_interface_attribute01 => guarantee_type
249: ,guarantee_type OKL_SIF_LINES_V.residual_guarantee_type%TYPE
250: ,down_payment_amount NUMBER := OKC_API.G_MISS_NUM
251: ,capitalize_down_payment_yn OKL_SIF_LINES_V.capitalize_down_payment_yn%TYPE := OKC_API.G_MISS_CHAR
252: -- add reference to the external ID
253: ,orig_contract_line_id NUMBER := OKC_API.G_MISS_NUM
254: );
255: TYPE csm_line_details_tbl_type IS TABLE OF csm_line_details_rec_type
249: ,guarantee_type OKL_SIF_LINES_V.residual_guarantee_type%TYPE
250: ,down_payment_amount NUMBER := OKC_API.G_MISS_NUM
251: ,capitalize_down_payment_yn OKL_SIF_LINES_V.capitalize_down_payment_yn%TYPE := OKC_API.G_MISS_CHAR
252: -- add reference to the external ID
253: ,orig_contract_line_id NUMBER := OKC_API.G_MISS_NUM
254: );
255: TYPE csm_line_details_tbl_type IS TABLE OF csm_line_details_rec_type
256: INDEX BY BINARY_INTEGER;
257: /* Lease Type - Header */
256: INDEX BY BINARY_INTEGER;
257: /* Lease Type - Header */
258: TYPE csm_lease_rec_type IS RECORD(
259: -- Common Details
260: jtot_object1_code OKL_STREAM_INTERFACES_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR
261: ,object1_id1 OKL_STREAM_INTERFACES_V.object1_id1%TYPE := OKC_API.G_MISS_CHAR
262: ,khr_id NUMBER := OKC_API.G_MISS_NUM
263: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
264: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lessor'
257: /* Lease Type - Header */
258: TYPE csm_lease_rec_type IS RECORD(
259: -- Common Details
260: jtot_object1_code OKL_STREAM_INTERFACES_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR
261: ,object1_id1 OKL_STREAM_INTERFACES_V.object1_id1%TYPE := OKC_API.G_MISS_CHAR
262: ,khr_id NUMBER := OKC_API.G_MISS_NUM
263: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
264: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lessor'
265: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
258: TYPE csm_lease_rec_type IS RECORD(
259: -- Common Details
260: jtot_object1_code OKL_STREAM_INTERFACES_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR
261: ,object1_id1 OKL_STREAM_INTERFACES_V.object1_id1%TYPE := OKC_API.G_MISS_CHAR
262: ,khr_id NUMBER := OKC_API.G_MISS_NUM
263: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
264: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lessor'
265: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
266: ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
259: -- Common Details
260: jtot_object1_code OKL_STREAM_INTERFACES_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR
261: ,object1_id1 OKL_STREAM_INTERFACES_V.object1_id1%TYPE := OKC_API.G_MISS_CHAR
262: ,khr_id NUMBER := OKC_API.G_MISS_NUM
263: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
264: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lessor'
265: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
266: ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
267: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
261: ,object1_id1 OKL_STREAM_INTERFACES_V.object1_id1%TYPE := OKC_API.G_MISS_CHAR
262: ,khr_id NUMBER := OKC_API.G_MISS_NUM
263: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
264: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lessor'
265: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
266: ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
267: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
268: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
269: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
262: ,khr_id NUMBER := OKC_API.G_MISS_NUM
263: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
264: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lessor'
265: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
266: ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
267: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
268: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
269: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
270: ,fasb_acct_treatment_method OKL_STREAM_INTERFACES_V.fasb_acct_treatment_method%TYPE := OKC_API.G_MISS_CHAR
263: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
264: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lessor'
265: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
266: ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
267: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
268: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
269: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
270: ,fasb_acct_treatment_method OKL_STREAM_INTERFACES_V.fasb_acct_treatment_method%TYPE := OKC_API.G_MISS_CHAR
271: ,adjust OKL_STREAM_INTERFACES_V.adjust%TYPE
264: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lessor'
265: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
266: ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
267: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
268: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
269: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
270: ,fasb_acct_treatment_method OKL_STREAM_INTERFACES_V.fasb_acct_treatment_method%TYPE := OKC_API.G_MISS_CHAR
271: ,adjust OKL_STREAM_INTERFACES_V.adjust%TYPE
272: ,adjustment_method OKL_STREAM_INTERFACES_V.adjustment_method%TYPE
265: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
266: ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
267: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
268: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
269: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
270: ,fasb_acct_treatment_method OKL_STREAM_INTERFACES_V.fasb_acct_treatment_method%TYPE := OKC_API.G_MISS_CHAR
271: ,adjust OKL_STREAM_INTERFACES_V.adjust%TYPE
272: ,adjustment_method OKL_STREAM_INTERFACES_V.adjustment_method%TYPE
273: ,term NUMBER := OKC_API.G_MISS_NUM
266: ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
267: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
268: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
269: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
270: ,fasb_acct_treatment_method OKL_STREAM_INTERFACES_V.fasb_acct_treatment_method%TYPE := OKC_API.G_MISS_CHAR
271: ,adjust OKL_STREAM_INTERFACES_V.adjust%TYPE
272: ,adjustment_method OKL_STREAM_INTERFACES_V.adjustment_method%TYPE
273: ,term NUMBER := OKC_API.G_MISS_NUM
274: ,structure OKL_STREAM_INTERFACES_V.structure%TYPE := OKC_API.G_MISS_CHAR
269: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
270: ,fasb_acct_treatment_method OKL_STREAM_INTERFACES_V.fasb_acct_treatment_method%TYPE := OKC_API.G_MISS_CHAR
271: ,adjust OKL_STREAM_INTERFACES_V.adjust%TYPE
272: ,adjustment_method OKL_STREAM_INTERFACES_V.adjustment_method%TYPE
273: ,term NUMBER := OKC_API.G_MISS_NUM
274: ,structure OKL_STREAM_INTERFACES_V.structure%TYPE := OKC_API.G_MISS_CHAR
275: -- Lease Type Details
276: ,irs_tax_treatment_method OKL_STREAM_INTERFACES_V.irs_tax_treatment_method%TYPE := OKC_API.G_MISS_CHAR
277: ,date_delivery OKL_STREAM_INTERFACES_V.date_delivery%TYPE := OKC_API.G_MISS_DATE
270: ,fasb_acct_treatment_method OKL_STREAM_INTERFACES_V.fasb_acct_treatment_method%TYPE := OKC_API.G_MISS_CHAR
271: ,adjust OKL_STREAM_INTERFACES_V.adjust%TYPE
272: ,adjustment_method OKL_STREAM_INTERFACES_V.adjustment_method%TYPE
273: ,term NUMBER := OKC_API.G_MISS_NUM
274: ,structure OKL_STREAM_INTERFACES_V.structure%TYPE := OKC_API.G_MISS_CHAR
275: -- Lease Type Details
276: ,irs_tax_treatment_method OKL_STREAM_INTERFACES_V.irs_tax_treatment_method%TYPE := OKC_API.G_MISS_CHAR
277: ,date_delivery OKL_STREAM_INTERFACES_V.date_delivery%TYPE := OKC_API.G_MISS_DATE
278: ,implicit_interest_rate NUMBER DEFAULT NULL
272: ,adjustment_method OKL_STREAM_INTERFACES_V.adjustment_method%TYPE
273: ,term NUMBER := OKC_API.G_MISS_NUM
274: ,structure OKL_STREAM_INTERFACES_V.structure%TYPE := OKC_API.G_MISS_CHAR
275: -- Lease Type Details
276: ,irs_tax_treatment_method OKL_STREAM_INTERFACES_V.irs_tax_treatment_method%TYPE := OKC_API.G_MISS_CHAR
277: ,date_delivery OKL_STREAM_INTERFACES_V.date_delivery%TYPE := OKC_API.G_MISS_DATE
278: ,implicit_interest_rate NUMBER DEFAULT NULL
279: ,rvi_yn OKL_STREAM_INTERFACES_V.rvi_yn%TYPE := OKC_API.G_MISS_CHAR
280: ,rvi_rate NUMBER := OKC_API.G_MISS_NUM
273: ,term NUMBER := OKC_API.G_MISS_NUM
274: ,structure OKL_STREAM_INTERFACES_V.structure%TYPE := OKC_API.G_MISS_CHAR
275: -- Lease Type Details
276: ,irs_tax_treatment_method OKL_STREAM_INTERFACES_V.irs_tax_treatment_method%TYPE := OKC_API.G_MISS_CHAR
277: ,date_delivery OKL_STREAM_INTERFACES_V.date_delivery%TYPE := OKC_API.G_MISS_DATE
278: ,implicit_interest_rate NUMBER DEFAULT NULL
279: ,rvi_yn OKL_STREAM_INTERFACES_V.rvi_yn%TYPE := OKC_API.G_MISS_CHAR
280: ,rvi_rate NUMBER := OKC_API.G_MISS_NUM
281: -- mvasudev, Bug#2650599
275: -- Lease Type Details
276: ,irs_tax_treatment_method OKL_STREAM_INTERFACES_V.irs_tax_treatment_method%TYPE := OKC_API.G_MISS_CHAR
277: ,date_delivery OKL_STREAM_INTERFACES_V.date_delivery%TYPE := OKC_API.G_MISS_DATE
278: ,implicit_interest_rate NUMBER DEFAULT NULL
279: ,rvi_yn OKL_STREAM_INTERFACES_V.rvi_yn%TYPE := OKC_API.G_MISS_CHAR
280: ,rvi_rate NUMBER := OKC_API.G_MISS_NUM
281: -- mvasudev, Bug#2650599
282: ,sif_id NUMBER := OKC_API.G_MISS_NUM
283: ,purpose_code OKL_STREAM_INTERFACES_V.PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR
276: ,irs_tax_treatment_method OKL_STREAM_INTERFACES_V.irs_tax_treatment_method%TYPE := OKC_API.G_MISS_CHAR
277: ,date_delivery OKL_STREAM_INTERFACES_V.date_delivery%TYPE := OKC_API.G_MISS_DATE
278: ,implicit_interest_rate NUMBER DEFAULT NULL
279: ,rvi_yn OKL_STREAM_INTERFACES_V.rvi_yn%TYPE := OKC_API.G_MISS_CHAR
280: ,rvi_rate NUMBER := OKC_API.G_MISS_NUM
281: -- mvasudev, Bug#2650599
282: ,sif_id NUMBER := OKC_API.G_MISS_NUM
283: ,purpose_code OKL_STREAM_INTERFACES_V.PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR
284: -- end, mvasudev, Bug#2650599
278: ,implicit_interest_rate NUMBER DEFAULT NULL
279: ,rvi_yn OKL_STREAM_INTERFACES_V.rvi_yn%TYPE := OKC_API.G_MISS_CHAR
280: ,rvi_rate NUMBER := OKC_API.G_MISS_NUM
281: -- mvasudev, Bug#2650599
282: ,sif_id NUMBER := OKC_API.G_MISS_NUM
283: ,purpose_code OKL_STREAM_INTERFACES_V.PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR
284: -- end, mvasudev, Bug#2650599
285: );
286: -- 04/21/2002
279: ,rvi_yn OKL_STREAM_INTERFACES_V.rvi_yn%TYPE := OKC_API.G_MISS_CHAR
280: ,rvi_rate NUMBER := OKC_API.G_MISS_NUM
281: -- mvasudev, Bug#2650599
282: ,sif_id NUMBER := OKC_API.G_MISS_NUM
283: ,purpose_code OKL_STREAM_INTERFACES_V.PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR
284: -- end, mvasudev, Bug#2650599
285: );
286: -- 04/21/2002
287: /* Loan Lines */
285: );
286: -- 04/21/2002
287: /* Loan Lines */
288: TYPE csm_loan_line_rec_type IS RECORD(
289: kle_loan_id NUMBER := OKC_API.G_MISS_NUM
290: --Added by kthiruva on 15-Nov-2005 for the Down Payment CR
291: --Bug 4738011 - Start of Changes
292: ,down_payment_amount NUMBER := OKC_API.G_MISS_NUM
293: ,capitalize_down_payment_yn OKL_SIF_LINES_V.capitalize_down_payment_yn%TYPE := OKC_API.G_MISS_CHAR
288: TYPE csm_loan_line_rec_type IS RECORD(
289: kle_loan_id NUMBER := OKC_API.G_MISS_NUM
290: --Added by kthiruva on 15-Nov-2005 for the Down Payment CR
291: --Bug 4738011 - Start of Changes
292: ,down_payment_amount NUMBER := OKC_API.G_MISS_NUM
293: ,capitalize_down_payment_yn OKL_SIF_LINES_V.capitalize_down_payment_yn%TYPE := OKC_API.G_MISS_CHAR
294: ,orig_contract_line_id NUMBER := OKC_API.G_MISS_NUM
295: --Bug 4738011 - End of Changes
296: );
289: kle_loan_id NUMBER := OKC_API.G_MISS_NUM
290: --Added by kthiruva on 15-Nov-2005 for the Down Payment CR
291: --Bug 4738011 - Start of Changes
292: ,down_payment_amount NUMBER := OKC_API.G_MISS_NUM
293: ,capitalize_down_payment_yn OKL_SIF_LINES_V.capitalize_down_payment_yn%TYPE := OKC_API.G_MISS_CHAR
294: ,orig_contract_line_id NUMBER := OKC_API.G_MISS_NUM
295: --Bug 4738011 - End of Changes
296: );
297: TYPE csm_loan_line_tbl_type IS TABLE OF csm_loan_line_rec_type
290: --Added by kthiruva on 15-Nov-2005 for the Down Payment CR
291: --Bug 4738011 - Start of Changes
292: ,down_payment_amount NUMBER := OKC_API.G_MISS_NUM
293: ,capitalize_down_payment_yn OKL_SIF_LINES_V.capitalize_down_payment_yn%TYPE := OKC_API.G_MISS_CHAR
294: ,orig_contract_line_id NUMBER := OKC_API.G_MISS_NUM
295: --Bug 4738011 - End of Changes
296: );
297: TYPE csm_loan_line_tbl_type IS TABLE OF csm_loan_line_rec_type
298: INDEX BY BINARY_INTEGER;
298: INDEX BY BINARY_INTEGER;
299: /* Loan Levels */
300: TYPE csm_loan_level_rec_type IS RECORD(
301: -- Common Details
302: description OKL_SIF_FEES_V.description%TYPE := OKC_API.G_MISS_CHAR
303: ,date_start OKL_SIF_FEES_V.date_start%TYPE := OKC_API.G_MISS_DATE
304: ,kle_loan_id NUMBER := OKC_API.G_MISS_NUM
305: -- Per-Record Details
306: ,level_index_number NUMBER := OKC_API.G_MISS_NUM
299: /* Loan Levels */
300: TYPE csm_loan_level_rec_type IS RECORD(
301: -- Common Details
302: description OKL_SIF_FEES_V.description%TYPE := OKC_API.G_MISS_CHAR
303: ,date_start OKL_SIF_FEES_V.date_start%TYPE := OKC_API.G_MISS_DATE
304: ,kle_loan_id NUMBER := OKC_API.G_MISS_NUM
305: -- Per-Record Details
306: ,level_index_number NUMBER := OKC_API.G_MISS_NUM
307: ,level_type OKL_SIF_FEES_V.level_type%TYPE := OKC_API.G_MISS_CHAR
300: TYPE csm_loan_level_rec_type IS RECORD(
301: -- Common Details
302: description OKL_SIF_FEES_V.description%TYPE := OKC_API.G_MISS_CHAR
303: ,date_start OKL_SIF_FEES_V.date_start%TYPE := OKC_API.G_MISS_DATE
304: ,kle_loan_id NUMBER := OKC_API.G_MISS_NUM
305: -- Per-Record Details
306: ,level_index_number NUMBER := OKC_API.G_MISS_NUM
307: ,level_type OKL_SIF_FEES_V.level_type%TYPE := OKC_API.G_MISS_CHAR
308: ,number_of_periods NUMBER := OKC_API.G_MISS_NUM
302: description OKL_SIF_FEES_V.description%TYPE := OKC_API.G_MISS_CHAR
303: ,date_start OKL_SIF_FEES_V.date_start%TYPE := OKC_API.G_MISS_DATE
304: ,kle_loan_id NUMBER := OKC_API.G_MISS_NUM
305: -- Per-Record Details
306: ,level_index_number NUMBER := OKC_API.G_MISS_NUM
307: ,level_type OKL_SIF_FEES_V.level_type%TYPE := OKC_API.G_MISS_CHAR
308: ,number_of_periods NUMBER := OKC_API.G_MISS_NUM
309: ,amount NUMBER := OKC_API.G_MISS_NUM
310: ,lock_level_step OKL_SIF_FEES_V.lock_level_step%TYPE := OKC_API.G_MISS_CHAR
303: ,date_start OKL_SIF_FEES_V.date_start%TYPE := OKC_API.G_MISS_DATE
304: ,kle_loan_id NUMBER := OKC_API.G_MISS_NUM
305: -- Per-Record Details
306: ,level_index_number NUMBER := OKC_API.G_MISS_NUM
307: ,level_type OKL_SIF_FEES_V.level_type%TYPE := OKC_API.G_MISS_CHAR
308: ,number_of_periods NUMBER := OKC_API.G_MISS_NUM
309: ,amount NUMBER := OKC_API.G_MISS_NUM
310: ,lock_level_step OKL_SIF_FEES_V.lock_level_step%TYPE := OKC_API.G_MISS_CHAR
311: ,rate NUMBER := OKC_API.G_MISS_NUM
304: ,kle_loan_id NUMBER := OKC_API.G_MISS_NUM
305: -- Per-Record Details
306: ,level_index_number NUMBER := OKC_API.G_MISS_NUM
307: ,level_type OKL_SIF_FEES_V.level_type%TYPE := OKC_API.G_MISS_CHAR
308: ,number_of_periods NUMBER := OKC_API.G_MISS_NUM
309: ,amount NUMBER := OKC_API.G_MISS_NUM
310: ,lock_level_step OKL_SIF_FEES_V.lock_level_step%TYPE := OKC_API.G_MISS_CHAR
311: ,rate NUMBER := OKC_API.G_MISS_NUM
312: ,period OKL_SIF_FEES_V.period%TYPE := OKC_API.G_MISS_CHAR
305: -- Per-Record Details
306: ,level_index_number NUMBER := OKC_API.G_MISS_NUM
307: ,level_type OKL_SIF_FEES_V.level_type%TYPE := OKC_API.G_MISS_CHAR
308: ,number_of_periods NUMBER := OKC_API.G_MISS_NUM
309: ,amount NUMBER := OKC_API.G_MISS_NUM
310: ,lock_level_step OKL_SIF_FEES_V.lock_level_step%TYPE := OKC_API.G_MISS_CHAR
311: ,rate NUMBER := OKC_API.G_MISS_NUM
312: ,period OKL_SIF_FEES_V.period%TYPE := OKC_API.G_MISS_CHAR
313: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
306: ,level_index_number NUMBER := OKC_API.G_MISS_NUM
307: ,level_type OKL_SIF_FEES_V.level_type%TYPE := OKC_API.G_MISS_CHAR
308: ,number_of_periods NUMBER := OKC_API.G_MISS_NUM
309: ,amount NUMBER := OKC_API.G_MISS_NUM
310: ,lock_level_step OKL_SIF_FEES_V.lock_level_step%TYPE := OKC_API.G_MISS_CHAR
311: ,rate NUMBER := OKC_API.G_MISS_NUM
312: ,period OKL_SIF_FEES_V.period%TYPE := OKC_API.G_MISS_CHAR
313: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
314: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
307: ,level_type OKL_SIF_FEES_V.level_type%TYPE := OKC_API.G_MISS_CHAR
308: ,number_of_periods NUMBER := OKC_API.G_MISS_NUM
309: ,amount NUMBER := OKC_API.G_MISS_NUM
310: ,lock_level_step OKL_SIF_FEES_V.lock_level_step%TYPE := OKC_API.G_MISS_CHAR
311: ,rate NUMBER := OKC_API.G_MISS_NUM
312: ,period OKL_SIF_FEES_V.period%TYPE := OKC_API.G_MISS_CHAR
313: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
314: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
315: -- 06/13/2002
308: ,number_of_periods NUMBER := OKC_API.G_MISS_NUM
309: ,amount NUMBER := OKC_API.G_MISS_NUM
310: ,lock_level_step OKL_SIF_FEES_V.lock_level_step%TYPE := OKC_API.G_MISS_CHAR
311: ,rate NUMBER := OKC_API.G_MISS_NUM
312: ,period OKL_SIF_FEES_V.period%TYPE := OKC_API.G_MISS_CHAR
313: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
314: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
315: -- 06/13/2002
316: ,structure OKL_SIF_FEES_V.structure%TYPE := OKC_API.G_MISS_CHAR
309: ,amount NUMBER := OKC_API.G_MISS_NUM
310: ,lock_level_step OKL_SIF_FEES_V.lock_level_step%TYPE := OKC_API.G_MISS_CHAR
311: ,rate NUMBER := OKC_API.G_MISS_NUM
312: ,period OKL_SIF_FEES_V.period%TYPE := OKC_API.G_MISS_CHAR
313: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
314: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
315: -- 06/13/2002
316: ,structure OKL_SIF_FEES_V.structure%TYPE := OKC_API.G_MISS_CHAR
317: -- added for "Restructure" requirements akjain 08/20/02
310: ,lock_level_step OKL_SIF_FEES_V.lock_level_step%TYPE := OKC_API.G_MISS_CHAR
311: ,rate NUMBER := OKC_API.G_MISS_NUM
312: ,period OKL_SIF_FEES_V.period%TYPE := OKC_API.G_MISS_CHAR
313: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
314: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
315: -- 06/13/2002
316: ,structure OKL_SIF_FEES_V.structure%TYPE := OKC_API.G_MISS_CHAR
317: -- added for "Restructure" requirements akjain 08/20/02
318: ,query_level_yn OKL_SIF_FEES_V.query_level_yn%TYPE := OKC_API.G_MISS_CHAR
312: ,period OKL_SIF_FEES_V.period%TYPE := OKC_API.G_MISS_CHAR
313: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
314: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
315: -- 06/13/2002
316: ,structure OKL_SIF_FEES_V.structure%TYPE := OKC_API.G_MISS_CHAR
317: -- added for "Restructure" requirements akjain 08/20/02
318: ,query_level_yn OKL_SIF_FEES_V.query_level_yn%TYPE := OKC_API.G_MISS_CHAR
319: ,days_in_month OKL_SIF_FEES_V.days_in_month%TYPE :=OKC_API.G_MISS_CHAR
320: ,days_in_year OKL_SIF_FEES_V.days_in_year%TYPE :=OKC_API.G_MISS_CHAR
314: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
315: -- 06/13/2002
316: ,structure OKL_SIF_FEES_V.structure%TYPE := OKC_API.G_MISS_CHAR
317: -- added for "Restructure" requirements akjain 08/20/02
318: ,query_level_yn OKL_SIF_FEES_V.query_level_yn%TYPE := OKC_API.G_MISS_CHAR
319: ,days_in_month OKL_SIF_FEES_V.days_in_month%TYPE :=OKC_API.G_MISS_CHAR
320: ,days_in_year OKL_SIF_FEES_V.days_in_year%TYPE :=OKC_API.G_MISS_CHAR
321: ,balance_type_code OKL_SIF_FEES_V.balance_type_code%TYPE :=OKC_API.G_MISS_CHAR
322: ,payment_type VARCHAR2(30) :=OKC_API.G_MISS_CHAR
315: -- 06/13/2002
316: ,structure OKL_SIF_FEES_V.structure%TYPE := OKC_API.G_MISS_CHAR
317: -- added for "Restructure" requirements akjain 08/20/02
318: ,query_level_yn OKL_SIF_FEES_V.query_level_yn%TYPE := OKC_API.G_MISS_CHAR
319: ,days_in_month OKL_SIF_FEES_V.days_in_month%TYPE :=OKC_API.G_MISS_CHAR
320: ,days_in_year OKL_SIF_FEES_V.days_in_year%TYPE :=OKC_API.G_MISS_CHAR
321: ,balance_type_code OKL_SIF_FEES_V.balance_type_code%TYPE :=OKC_API.G_MISS_CHAR
322: ,payment_type VARCHAR2(30) :=OKC_API.G_MISS_CHAR
323: -- add reference to external id
316: ,structure OKL_SIF_FEES_V.structure%TYPE := OKC_API.G_MISS_CHAR
317: -- added for "Restructure" requirements akjain 08/20/02
318: ,query_level_yn OKL_SIF_FEES_V.query_level_yn%TYPE := OKC_API.G_MISS_CHAR
319: ,days_in_month OKL_SIF_FEES_V.days_in_month%TYPE :=OKC_API.G_MISS_CHAR
320: ,days_in_year OKL_SIF_FEES_V.days_in_year%TYPE :=OKC_API.G_MISS_CHAR
321: ,balance_type_code OKL_SIF_FEES_V.balance_type_code%TYPE :=OKC_API.G_MISS_CHAR
322: ,payment_type VARCHAR2(30) :=OKC_API.G_MISS_CHAR
323: -- add reference to external id
324: ,orig_contract_line_id NUMBER := OKC_API.G_MISS_NUM
317: -- added for "Restructure" requirements akjain 08/20/02
318: ,query_level_yn OKL_SIF_FEES_V.query_level_yn%TYPE := OKC_API.G_MISS_CHAR
319: ,days_in_month OKL_SIF_FEES_V.days_in_month%TYPE :=OKC_API.G_MISS_CHAR
320: ,days_in_year OKL_SIF_FEES_V.days_in_year%TYPE :=OKC_API.G_MISS_CHAR
321: ,balance_type_code OKL_SIF_FEES_V.balance_type_code%TYPE :=OKC_API.G_MISS_CHAR
322: ,payment_type VARCHAR2(30) :=OKC_API.G_MISS_CHAR
323: -- add reference to external id
324: ,orig_contract_line_id NUMBER := OKC_API.G_MISS_NUM
325: );
318: ,query_level_yn OKL_SIF_FEES_V.query_level_yn%TYPE := OKC_API.G_MISS_CHAR
319: ,days_in_month OKL_SIF_FEES_V.days_in_month%TYPE :=OKC_API.G_MISS_CHAR
320: ,days_in_year OKL_SIF_FEES_V.days_in_year%TYPE :=OKC_API.G_MISS_CHAR
321: ,balance_type_code OKL_SIF_FEES_V.balance_type_code%TYPE :=OKC_API.G_MISS_CHAR
322: ,payment_type VARCHAR2(30) :=OKC_API.G_MISS_CHAR
323: -- add reference to external id
324: ,orig_contract_line_id NUMBER := OKC_API.G_MISS_NUM
325: );
326: TYPE csm_loan_level_tbl_type IS TABLE OF csm_loan_level_rec_type
320: ,days_in_year OKL_SIF_FEES_V.days_in_year%TYPE :=OKC_API.G_MISS_CHAR
321: ,balance_type_code OKL_SIF_FEES_V.balance_type_code%TYPE :=OKC_API.G_MISS_CHAR
322: ,payment_type VARCHAR2(30) :=OKC_API.G_MISS_CHAR
323: -- add reference to external id
324: ,orig_contract_line_id NUMBER := OKC_API.G_MISS_NUM
325: );
326: TYPE csm_loan_level_tbl_type IS TABLE OF csm_loan_level_rec_type
327: INDEX BY BINARY_INTEGER;
328: -- end,04/21/2002
328: -- end,04/21/2002
329: /* Loan Type - Header */
330: TYPE csm_loan_rec_type IS RECORD(
331: -- Common Details
332: jtot_object1_code OKL_STREAM_INTERFACES_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR
333: ,object1_id1 OKL_STREAM_INTERFACES_V.object1_id1%TYPE := OKC_API.G_MISS_CHAR
334: ,khr_id NUMBER := OKC_API.G_MISS_NUM
335: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
336: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lender'
329: /* Loan Type - Header */
330: TYPE csm_loan_rec_type IS RECORD(
331: -- Common Details
332: jtot_object1_code OKL_STREAM_INTERFACES_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR
333: ,object1_id1 OKL_STREAM_INTERFACES_V.object1_id1%TYPE := OKC_API.G_MISS_CHAR
334: ,khr_id NUMBER := OKC_API.G_MISS_NUM
335: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
336: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lender'
337: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
330: TYPE csm_loan_rec_type IS RECORD(
331: -- Common Details
332: jtot_object1_code OKL_STREAM_INTERFACES_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR
333: ,object1_id1 OKL_STREAM_INTERFACES_V.object1_id1%TYPE := OKC_API.G_MISS_CHAR
334: ,khr_id NUMBER := OKC_API.G_MISS_NUM
335: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
336: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lender'
337: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
338: ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
331: -- Common Details
332: jtot_object1_code OKL_STREAM_INTERFACES_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR
333: ,object1_id1 OKL_STREAM_INTERFACES_V.object1_id1%TYPE := OKC_API.G_MISS_CHAR
334: ,khr_id NUMBER := OKC_API.G_MISS_NUM
335: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
336: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lender'
337: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
338: ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
339: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
333: ,object1_id1 OKL_STREAM_INTERFACES_V.object1_id1%TYPE := OKC_API.G_MISS_CHAR
334: ,khr_id NUMBER := OKC_API.G_MISS_NUM
335: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
336: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lender'
337: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
338: ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
339: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
340: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
341: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
334: ,khr_id NUMBER := OKC_API.G_MISS_NUM
335: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
336: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lender'
337: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
338: ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
339: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
340: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
341: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
342: -- Loan Type Details
335: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
336: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lender'
337: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
338: ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
339: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
340: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
341: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
342: -- Loan Type Details
343: ,total_lending NUMBER := OKC_API.G_MISS_NUM
336: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lender'
337: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
338: ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
339: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
340: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
341: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
342: -- Loan Type Details
343: ,total_lending NUMBER := OKC_API.G_MISS_NUM
344: ,date_start OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
337: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
338: ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
339: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
340: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
341: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
342: -- Loan Type Details
343: ,total_lending NUMBER := OKC_API.G_MISS_NUM
344: ,date_start OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
345: ,lending_rate NUMBER DEFAULT NULL
339: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
340: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
341: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
342: -- Loan Type Details
343: ,total_lending NUMBER := OKC_API.G_MISS_NUM
344: ,date_start OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
345: ,lending_rate NUMBER DEFAULT NULL
346: -- mvasudev, Bug#2650599
347: ,sif_id NUMBER := OKC_API.G_MISS_NUM
340: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
341: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
342: -- Loan Type Details
343: ,total_lending NUMBER := OKC_API.G_MISS_NUM
344: ,date_start OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
345: ,lending_rate NUMBER DEFAULT NULL
346: -- mvasudev, Bug#2650599
347: ,sif_id NUMBER := OKC_API.G_MISS_NUM
348: ,purpose_code OKL_STREAM_INTERFACES_V.PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR
343: ,total_lending NUMBER := OKC_API.G_MISS_NUM
344: ,date_start OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
345: ,lending_rate NUMBER DEFAULT NULL
346: -- mvasudev, Bug#2650599
347: ,sif_id NUMBER := OKC_API.G_MISS_NUM
348: ,purpose_code OKL_STREAM_INTERFACES_V.PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR
349: -- end, mvasudev, Bug#2650599
350: -- added for Loan Quote requirements smahapat 10/30/03
351: ,adjust OKL_STREAM_INTERFACES_V.adjust%TYPE
344: ,date_start OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
345: ,lending_rate NUMBER DEFAULT NULL
346: -- mvasudev, Bug#2650599
347: ,sif_id NUMBER := OKC_API.G_MISS_NUM
348: ,purpose_code OKL_STREAM_INTERFACES_V.PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR
349: -- end, mvasudev, Bug#2650599
350: -- added for Loan Quote requirements smahapat 10/30/03
351: ,adjust OKL_STREAM_INTERFACES_V.adjust%TYPE
352: ,adjustment_method OKL_STREAM_INTERFACES_V.adjustment_method%TYPE