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