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