121: -- In the abscence of "KLE_ID" it is assumed to be in the Header
122: -- else it will be assigned to the corresponding KLE_ID / Line
123: */
124: TYPE csm_one_off_fee_rec_type IS RECORD(
125: description OKL_SIF_FEES_V.description%TYPE := OKC_API.G_MISS_CHAR
126: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
127: ,amount NUMBER := OKC_API.G_MISS_NUM
128: ,date_start OKL_SIF_FEES_V.date_paid%TYPE := OKC_API.G_MISS_DATE --smahapat fee type solution
129: ,date_paid OKL_SIF_FEES_V.date_paid%TYPE := OKC_API.G_MISS_DATE
122: -- else it will be assigned to the corresponding KLE_ID / Line
123: */
124: TYPE csm_one_off_fee_rec_type IS RECORD(
125: description OKL_SIF_FEES_V.description%TYPE := OKC_API.G_MISS_CHAR
126: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
127: ,amount NUMBER := OKC_API.G_MISS_NUM
128: ,date_start OKL_SIF_FEES_V.date_paid%TYPE := OKC_API.G_MISS_DATE --smahapat fee type solution
129: ,date_paid OKL_SIF_FEES_V.date_paid%TYPE := OKC_API.G_MISS_DATE
130: ,idc_accounting_flag OKL_SIF_FEES_V.idc_accounting_flag%TYPE := OKC_API.G_MISS_CHAR
124: TYPE csm_one_off_fee_rec_type IS RECORD(
125: description OKL_SIF_FEES_V.description%TYPE := OKC_API.G_MISS_CHAR
126: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
127: ,amount NUMBER := OKC_API.G_MISS_NUM
128: ,date_start OKL_SIF_FEES_V.date_paid%TYPE := OKC_API.G_MISS_DATE --smahapat fee type solution
129: ,date_paid OKL_SIF_FEES_V.date_paid%TYPE := OKC_API.G_MISS_DATE
130: ,idc_accounting_flag OKL_SIF_FEES_V.idc_accounting_flag%TYPE := OKC_API.G_MISS_CHAR
131: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
132: ,kle_fee_id NUMBER := OKC_API.G_MISS_NUM
125: description OKL_SIF_FEES_V.description%TYPE := OKC_API.G_MISS_CHAR
126: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
127: ,amount NUMBER := OKC_API.G_MISS_NUM
128: ,date_start OKL_SIF_FEES_V.date_paid%TYPE := OKC_API.G_MISS_DATE --smahapat fee type solution
129: ,date_paid OKL_SIF_FEES_V.date_paid%TYPE := OKC_API.G_MISS_DATE
130: ,idc_accounting_flag OKL_SIF_FEES_V.idc_accounting_flag%TYPE := OKC_API.G_MISS_CHAR
131: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
132: ,kle_fee_id NUMBER := OKC_API.G_MISS_NUM
133: ,fee_type OKL_K_LINES_v.fee_type%TYPE := OKC_API.G_MISS_CHAR --SGORANTL ADDED FOR FINANCE FEES
126: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
127: ,amount NUMBER := OKC_API.G_MISS_NUM
128: ,date_start OKL_SIF_FEES_V.date_paid%TYPE := OKC_API.G_MISS_DATE --smahapat fee type solution
129: ,date_paid OKL_SIF_FEES_V.date_paid%TYPE := OKC_API.G_MISS_DATE
130: ,idc_accounting_flag OKL_SIF_FEES_V.idc_accounting_flag%TYPE := OKC_API.G_MISS_CHAR
131: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
132: ,kle_fee_id NUMBER := OKC_API.G_MISS_NUM
133: ,fee_type OKL_K_LINES_v.fee_type%TYPE := OKC_API.G_MISS_CHAR --SGORANTL ADDED FOR FINANCE FEES
134: -- Use ONLY in case this fees is for a Specific Line (Asset Line / Loan Line)
127: ,amount NUMBER := OKC_API.G_MISS_NUM
128: ,date_start OKL_SIF_FEES_V.date_paid%TYPE := OKC_API.G_MISS_DATE --smahapat fee type solution
129: ,date_paid OKL_SIF_FEES_V.date_paid%TYPE := OKC_API.G_MISS_DATE
130: ,idc_accounting_flag OKL_SIF_FEES_V.idc_accounting_flag%TYPE := OKC_API.G_MISS_CHAR
131: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
132: ,kle_fee_id NUMBER := OKC_API.G_MISS_NUM
133: ,fee_type OKL_K_LINES_v.fee_type%TYPE := OKC_API.G_MISS_CHAR --SGORANTL ADDED FOR FINANCE FEES
134: -- Use ONLY in case this fees is for a Specific Line (Asset Line / Loan Line)
135: ,kle_asset_id NUMBER := OKC_API.G_MISS_NUM
149: -- else it will be assigned to the corresponding KLE_ID / Line
150: */
151: TYPE csm_periodic_expenses_rec_type IS RECORD(
152: -- Common Details
153: description OKL_SIF_FEES_V.description%TYPE := OKC_API.G_MISS_CHAR
154: ,date_start OKL_SIF_FEES_V.date_start%TYPE := OKC_API.G_MISS_DATE --smahapat fee type soln interpreted as en accrual for stub payment
155: ,kle_fee_id NUMBER := OKC_API.G_MISS_NUM
156: -- Use ONLY in case this fees is for a Specific Line (Asset Line / Loan Line)
157: ,kle_asset_id NUMBER := OKC_API.G_MISS_NUM
150: */
151: TYPE csm_periodic_expenses_rec_type IS RECORD(
152: -- Common Details
153: description OKL_SIF_FEES_V.description%TYPE := OKC_API.G_MISS_CHAR
154: ,date_start OKL_SIF_FEES_V.date_start%TYPE := OKC_API.G_MISS_DATE --smahapat fee type soln interpreted as en accrual for stub payment
155: ,kle_fee_id NUMBER := OKC_API.G_MISS_NUM
156: -- Use ONLY in case this fees is for a Specific Line (Asset Line / Loan Line)
157: ,kle_asset_id NUMBER := OKC_API.G_MISS_NUM
158: -- Per-Record Details
156: -- Use ONLY in case this fees is for a Specific Line (Asset Line / Loan Line)
157: ,kle_asset_id NUMBER := OKC_API.G_MISS_NUM
158: -- Per-Record Details
159: ,level_index_number NUMBER := OKC_API.G_MISS_NUM
160: ,level_type OKL_SIF_FEES_V.level_type%TYPE := OKC_API.G_MISS_CHAR
161: ,number_of_periods NUMBER := OKC_API.G_MISS_NUM
162: ,amount NUMBER := OKC_API.G_MISS_NUM
163: ,rate NUMBER := OKC_API.G_MISS_NUM
164: ,lock_level_step OKL_SIF_FEES_V.lock_level_step%TYPE := OKC_API.G_MISS_CHAR
160: ,level_type OKL_SIF_FEES_V.level_type%TYPE := OKC_API.G_MISS_CHAR
161: ,number_of_periods NUMBER := OKC_API.G_MISS_NUM
162: ,amount NUMBER := OKC_API.G_MISS_NUM
163: ,rate NUMBER := OKC_API.G_MISS_NUM
164: ,lock_level_step OKL_SIF_FEES_V.lock_level_step%TYPE := OKC_API.G_MISS_CHAR
165: ,period OKL_SIF_FEES_V.period%TYPE := OKC_API.G_MISS_CHAR
166: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
167: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
168: ,fee_type OKL_K_LINES_v.fee_type%TYPE := OKC_API.G_MISS_CHAR --SGORANTL ADDED FOR FINANCE FEES
161: ,number_of_periods NUMBER := OKC_API.G_MISS_NUM
162: ,amount NUMBER := OKC_API.G_MISS_NUM
163: ,rate NUMBER := OKC_API.G_MISS_NUM
164: ,lock_level_step OKL_SIF_FEES_V.lock_level_step%TYPE := OKC_API.G_MISS_CHAR
165: ,period OKL_SIF_FEES_V.period%TYPE := OKC_API.G_MISS_CHAR
166: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
167: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
168: ,fee_type OKL_K_LINES_v.fee_type%TYPE := OKC_API.G_MISS_CHAR --SGORANTL ADDED FOR FINANCE FEES
169: -- 04/29/2002, mvasudev
162: ,amount NUMBER := OKC_API.G_MISS_NUM
163: ,rate NUMBER := OKC_API.G_MISS_NUM
164: ,lock_level_step OKL_SIF_FEES_V.lock_level_step%TYPE := OKC_API.G_MISS_CHAR
165: ,period OKL_SIF_FEES_V.period%TYPE := OKC_API.G_MISS_CHAR
166: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
167: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
168: ,fee_type OKL_K_LINES_v.fee_type%TYPE := OKC_API.G_MISS_CHAR --SGORANTL ADDED FOR FINANCE FEES
169: -- 04/29/2002, mvasudev
170: -- added for "Restructure" requirements
163: ,rate NUMBER := OKC_API.G_MISS_NUM
164: ,lock_level_step OKL_SIF_FEES_V.lock_level_step%TYPE := OKC_API.G_MISS_CHAR
165: ,period OKL_SIF_FEES_V.period%TYPE := OKC_API.G_MISS_CHAR
166: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
167: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
168: ,fee_type OKL_K_LINES_v.fee_type%TYPE := OKC_API.G_MISS_CHAR --SGORANTL ADDED FOR FINANCE FEES
169: -- 04/29/2002, mvasudev
170: -- added for "Restructure" requirements
171: ,query_level_yn OKL_SIF_FEES_V.query_level_yn%TYPE := OKC_API.G_MISS_CHAR
167: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
168: ,fee_type OKL_K_LINES_v.fee_type%TYPE := OKC_API.G_MISS_CHAR --SGORANTL ADDED FOR FINANCE FEES
169: -- 04/29/2002, mvasudev
170: -- added for "Restructure" requirements
171: ,query_level_yn OKL_SIF_FEES_V.query_level_yn%TYPE := OKC_API.G_MISS_CHAR
172: -- 06/13/2002
173: ,structure OKL_SIF_FEES_V.structure%TYPE := OKC_API.G_MISS_CHAR
174: ,cash_effect_yn OKL_SIF_FEES_V.cash_effect_yn%TYPE := OKC_API.G_MISS_CHAR
175: ,tax_effect_yn OKL_SIF_FEES_V.tax_effect_yn%TYPE := OKC_API.G_MISS_CHAR
169: -- 04/29/2002, mvasudev
170: -- added for "Restructure" requirements
171: ,query_level_yn OKL_SIF_FEES_V.query_level_yn%TYPE := OKC_API.G_MISS_CHAR
172: -- 06/13/2002
173: ,structure OKL_SIF_FEES_V.structure%TYPE := OKC_API.G_MISS_CHAR
174: ,cash_effect_yn OKL_SIF_FEES_V.cash_effect_yn%TYPE := OKC_API.G_MISS_CHAR
175: ,tax_effect_yn OKL_SIF_FEES_V.tax_effect_yn%TYPE := OKC_API.G_MISS_CHAR
176: ,days_in_month OKL_SIF_FEES_V.days_in_month%TYPE :=OKC_API.G_MISS_CHAR
177: ,days_in_year OKL_SIF_FEES_V.days_in_year%TYPE :=OKC_API.G_MISS_CHAR
170: -- added for "Restructure" requirements
171: ,query_level_yn OKL_SIF_FEES_V.query_level_yn%TYPE := OKC_API.G_MISS_CHAR
172: -- 06/13/2002
173: ,structure OKL_SIF_FEES_V.structure%TYPE := OKC_API.G_MISS_CHAR
174: ,cash_effect_yn OKL_SIF_FEES_V.cash_effect_yn%TYPE := OKC_API.G_MISS_CHAR
175: ,tax_effect_yn OKL_SIF_FEES_V.tax_effect_yn%TYPE := OKC_API.G_MISS_CHAR
176: ,days_in_month OKL_SIF_FEES_V.days_in_month%TYPE :=OKC_API.G_MISS_CHAR
177: ,days_in_year OKL_SIF_FEES_V.days_in_year%TYPE :=OKC_API.G_MISS_CHAR
178: ,down_payment_amount NUMBER := OKC_API.G_MISS_NUM
171: ,query_level_yn OKL_SIF_FEES_V.query_level_yn%TYPE := OKC_API.G_MISS_CHAR
172: -- 06/13/2002
173: ,structure OKL_SIF_FEES_V.structure%TYPE := OKC_API.G_MISS_CHAR
174: ,cash_effect_yn OKL_SIF_FEES_V.cash_effect_yn%TYPE := OKC_API.G_MISS_CHAR
175: ,tax_effect_yn OKL_SIF_FEES_V.tax_effect_yn%TYPE := OKC_API.G_MISS_CHAR
176: ,days_in_month OKL_SIF_FEES_V.days_in_month%TYPE :=OKC_API.G_MISS_CHAR
177: ,days_in_year OKL_SIF_FEES_V.days_in_year%TYPE :=OKC_API.G_MISS_CHAR
178: ,down_payment_amount NUMBER := OKC_API.G_MISS_NUM
179: ,date_paid OKL_SIF_FEES_V.DATE_PAID%TYPE := OKC_API.G_MISS_DATE -- RGOOTY: Bug 7552496
172: -- 06/13/2002
173: ,structure OKL_SIF_FEES_V.structure%TYPE := OKC_API.G_MISS_CHAR
174: ,cash_effect_yn OKL_SIF_FEES_V.cash_effect_yn%TYPE := OKC_API.G_MISS_CHAR
175: ,tax_effect_yn OKL_SIF_FEES_V.tax_effect_yn%TYPE := OKC_API.G_MISS_CHAR
176: ,days_in_month OKL_SIF_FEES_V.days_in_month%TYPE :=OKC_API.G_MISS_CHAR
177: ,days_in_year OKL_SIF_FEES_V.days_in_year%TYPE :=OKC_API.G_MISS_CHAR
178: ,down_payment_amount NUMBER := OKC_API.G_MISS_NUM
179: ,date_paid OKL_SIF_FEES_V.DATE_PAID%TYPE := OKC_API.G_MISS_DATE -- RGOOTY: Bug 7552496
180: -- add reference to the external ID
173: ,structure OKL_SIF_FEES_V.structure%TYPE := OKC_API.G_MISS_CHAR
174: ,cash_effect_yn OKL_SIF_FEES_V.cash_effect_yn%TYPE := OKC_API.G_MISS_CHAR
175: ,tax_effect_yn OKL_SIF_FEES_V.tax_effect_yn%TYPE := OKC_API.G_MISS_CHAR
176: ,days_in_month OKL_SIF_FEES_V.days_in_month%TYPE :=OKC_API.G_MISS_CHAR
177: ,days_in_year OKL_SIF_FEES_V.days_in_year%TYPE :=OKC_API.G_MISS_CHAR
178: ,down_payment_amount NUMBER := OKC_API.G_MISS_NUM
179: ,date_paid OKL_SIF_FEES_V.DATE_PAID%TYPE := OKC_API.G_MISS_DATE -- RGOOTY: Bug 7552496
180: -- add reference to the external ID
181: ,orig_contract_line_id NUMBER := OKC_API.G_MISS_NUM
175: ,tax_effect_yn OKL_SIF_FEES_V.tax_effect_yn%TYPE := OKC_API.G_MISS_CHAR
176: ,days_in_month OKL_SIF_FEES_V.days_in_month%TYPE :=OKC_API.G_MISS_CHAR
177: ,days_in_year OKL_SIF_FEES_V.days_in_year%TYPE :=OKC_API.G_MISS_CHAR
178: ,down_payment_amount NUMBER := OKC_API.G_MISS_NUM
179: ,date_paid OKL_SIF_FEES_V.DATE_PAID%TYPE := OKC_API.G_MISS_DATE -- RGOOTY: Bug 7552496
180: -- add reference to the external ID
181: ,orig_contract_line_id NUMBER := OKC_API.G_MISS_NUM
182: );
183: TYPE csm_periodic_expenses_tbl_type IS TABLE OF csm_periodic_expenses_rec_type
298: INDEX BY BINARY_INTEGER;
299: /* Loan Levels */
300: TYPE csm_loan_level_rec_type IS RECORD(
301: -- Common Details
302: description OKL_SIF_FEES_V.description%TYPE := OKC_API.G_MISS_CHAR
303: ,date_start OKL_SIF_FEES_V.date_start%TYPE := OKC_API.G_MISS_DATE
304: ,kle_loan_id NUMBER := OKC_API.G_MISS_NUM
305: -- Per-Record Details
306: ,level_index_number NUMBER := OKC_API.G_MISS_NUM
299: /* Loan Levels */
300: TYPE csm_loan_level_rec_type IS RECORD(
301: -- Common Details
302: description OKL_SIF_FEES_V.description%TYPE := OKC_API.G_MISS_CHAR
303: ,date_start OKL_SIF_FEES_V.date_start%TYPE := OKC_API.G_MISS_DATE
304: ,kle_loan_id NUMBER := OKC_API.G_MISS_NUM
305: -- Per-Record Details
306: ,level_index_number NUMBER := OKC_API.G_MISS_NUM
307: ,level_type OKL_SIF_FEES_V.level_type%TYPE := OKC_API.G_MISS_CHAR
303: ,date_start OKL_SIF_FEES_V.date_start%TYPE := OKC_API.G_MISS_DATE
304: ,kle_loan_id NUMBER := OKC_API.G_MISS_NUM
305: -- Per-Record Details
306: ,level_index_number NUMBER := OKC_API.G_MISS_NUM
307: ,level_type OKL_SIF_FEES_V.level_type%TYPE := OKC_API.G_MISS_CHAR
308: ,number_of_periods NUMBER := OKC_API.G_MISS_NUM
309: ,amount NUMBER := OKC_API.G_MISS_NUM
310: ,lock_level_step OKL_SIF_FEES_V.lock_level_step%TYPE := OKC_API.G_MISS_CHAR
311: ,rate NUMBER := OKC_API.G_MISS_NUM
306: ,level_index_number NUMBER := OKC_API.G_MISS_NUM
307: ,level_type OKL_SIF_FEES_V.level_type%TYPE := OKC_API.G_MISS_CHAR
308: ,number_of_periods NUMBER := OKC_API.G_MISS_NUM
309: ,amount NUMBER := OKC_API.G_MISS_NUM
310: ,lock_level_step OKL_SIF_FEES_V.lock_level_step%TYPE := OKC_API.G_MISS_CHAR
311: ,rate NUMBER := OKC_API.G_MISS_NUM
312: ,period OKL_SIF_FEES_V.period%TYPE := OKC_API.G_MISS_CHAR
313: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
314: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
308: ,number_of_periods NUMBER := OKC_API.G_MISS_NUM
309: ,amount NUMBER := OKC_API.G_MISS_NUM
310: ,lock_level_step OKL_SIF_FEES_V.lock_level_step%TYPE := OKC_API.G_MISS_CHAR
311: ,rate NUMBER := OKC_API.G_MISS_NUM
312: ,period OKL_SIF_FEES_V.period%TYPE := OKC_API.G_MISS_CHAR
313: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
314: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
315: -- 06/13/2002
316: ,structure OKL_SIF_FEES_V.structure%TYPE := OKC_API.G_MISS_CHAR
309: ,amount NUMBER := OKC_API.G_MISS_NUM
310: ,lock_level_step OKL_SIF_FEES_V.lock_level_step%TYPE := OKC_API.G_MISS_CHAR
311: ,rate NUMBER := OKC_API.G_MISS_NUM
312: ,period OKL_SIF_FEES_V.period%TYPE := OKC_API.G_MISS_CHAR
313: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
314: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
315: -- 06/13/2002
316: ,structure OKL_SIF_FEES_V.structure%TYPE := OKC_API.G_MISS_CHAR
317: -- added for "Restructure" requirements akjain 08/20/02
310: ,lock_level_step OKL_SIF_FEES_V.lock_level_step%TYPE := OKC_API.G_MISS_CHAR
311: ,rate NUMBER := OKC_API.G_MISS_NUM
312: ,period OKL_SIF_FEES_V.period%TYPE := OKC_API.G_MISS_CHAR
313: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
314: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
315: -- 06/13/2002
316: ,structure OKL_SIF_FEES_V.structure%TYPE := OKC_API.G_MISS_CHAR
317: -- added for "Restructure" requirements akjain 08/20/02
318: ,query_level_yn OKL_SIF_FEES_V.query_level_yn%TYPE := OKC_API.G_MISS_CHAR
312: ,period OKL_SIF_FEES_V.period%TYPE := OKC_API.G_MISS_CHAR
313: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR
314: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
315: -- 06/13/2002
316: ,structure OKL_SIF_FEES_V.structure%TYPE := OKC_API.G_MISS_CHAR
317: -- added for "Restructure" requirements akjain 08/20/02
318: ,query_level_yn OKL_SIF_FEES_V.query_level_yn%TYPE := OKC_API.G_MISS_CHAR
319: ,days_in_month OKL_SIF_FEES_V.days_in_month%TYPE :=OKC_API.G_MISS_CHAR
320: ,days_in_year OKL_SIF_FEES_V.days_in_year%TYPE :=OKC_API.G_MISS_CHAR
314: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR
315: -- 06/13/2002
316: ,structure OKL_SIF_FEES_V.structure%TYPE := OKC_API.G_MISS_CHAR
317: -- added for "Restructure" requirements akjain 08/20/02
318: ,query_level_yn OKL_SIF_FEES_V.query_level_yn%TYPE := OKC_API.G_MISS_CHAR
319: ,days_in_month OKL_SIF_FEES_V.days_in_month%TYPE :=OKC_API.G_MISS_CHAR
320: ,days_in_year OKL_SIF_FEES_V.days_in_year%TYPE :=OKC_API.G_MISS_CHAR
321: ,balance_type_code OKL_SIF_FEES_V.balance_type_code%TYPE :=OKC_API.G_MISS_CHAR
322: ,payment_type VARCHAR2(30) :=OKC_API.G_MISS_CHAR
315: -- 06/13/2002
316: ,structure OKL_SIF_FEES_V.structure%TYPE := OKC_API.G_MISS_CHAR
317: -- added for "Restructure" requirements akjain 08/20/02
318: ,query_level_yn OKL_SIF_FEES_V.query_level_yn%TYPE := OKC_API.G_MISS_CHAR
319: ,days_in_month OKL_SIF_FEES_V.days_in_month%TYPE :=OKC_API.G_MISS_CHAR
320: ,days_in_year OKL_SIF_FEES_V.days_in_year%TYPE :=OKC_API.G_MISS_CHAR
321: ,balance_type_code OKL_SIF_FEES_V.balance_type_code%TYPE :=OKC_API.G_MISS_CHAR
322: ,payment_type VARCHAR2(30) :=OKC_API.G_MISS_CHAR
323: -- add reference to external id
316: ,structure OKL_SIF_FEES_V.structure%TYPE := OKC_API.G_MISS_CHAR
317: -- added for "Restructure" requirements akjain 08/20/02
318: ,query_level_yn OKL_SIF_FEES_V.query_level_yn%TYPE := OKC_API.G_MISS_CHAR
319: ,days_in_month OKL_SIF_FEES_V.days_in_month%TYPE :=OKC_API.G_MISS_CHAR
320: ,days_in_year OKL_SIF_FEES_V.days_in_year%TYPE :=OKC_API.G_MISS_CHAR
321: ,balance_type_code OKL_SIF_FEES_V.balance_type_code%TYPE :=OKC_API.G_MISS_CHAR
322: ,payment_type VARCHAR2(30) :=OKC_API.G_MISS_CHAR
323: -- add reference to external id
324: ,orig_contract_line_id NUMBER := OKC_API.G_MISS_NUM
317: -- added for "Restructure" requirements akjain 08/20/02
318: ,query_level_yn OKL_SIF_FEES_V.query_level_yn%TYPE := OKC_API.G_MISS_CHAR
319: ,days_in_month OKL_SIF_FEES_V.days_in_month%TYPE :=OKC_API.G_MISS_CHAR
320: ,days_in_year OKL_SIF_FEES_V.days_in_year%TYPE :=OKC_API.G_MISS_CHAR
321: ,balance_type_code OKL_SIF_FEES_V.balance_type_code%TYPE :=OKC_API.G_MISS_CHAR
322: ,payment_type VARCHAR2(30) :=OKC_API.G_MISS_CHAR
323: -- add reference to external id
324: ,orig_contract_line_id NUMBER := OKC_API.G_MISS_NUM
325: );