DBA Data[Home] [Help]

APPS.OKL_CREATE_STREAMS_PVT dependencies on OKL_SIF_FEES_V

Line 124: description OKL_SIF_FEES_V.description%TYPE := OKC_API.G_MISS_CHAR

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

Line 125: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR

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

Line 127: ,date_start OKL_SIF_FEES_V.date_paid%TYPE := OKC_API.G_MISS_DATE --smahapat fee type solution

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

Line 128: ,date_paid OKL_SIF_FEES_V.date_paid%TYPE := OKC_API.G_MISS_DATE

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

Line 129: ,idc_accounting_flag OKL_SIF_FEES_V.idc_accounting_flag%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
133: -- Use ONLY in case this fees is for a Specific Line (Asset Line / Loan Line)

Line 130: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%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)
134: ,kle_asset_id NUMBER := OKC_API.G_MISS_NUM

Line 150: description OKL_SIF_FEES_V.description%TYPE := OKC_API.G_MISS_CHAR

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

Line 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

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

Line 157: ,level_type OKL_SIF_FEES_V.level_type%TYPE := OKC_API.G_MISS_CHAR

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

Line 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

Line 162: ,period OKL_SIF_FEES_V.period%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
166: -- 04/29/2002, mvasudev

Line 163: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKC_API.G_MISS_CHAR

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

Line 164: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR

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

Line 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

Line 170: ,structure OKL_SIF_FEES_V.structure%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

Line 171: ,cash_effect_yn OKL_SIF_FEES_V.cash_effect_yn%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

Line 172: ,tax_effect_yn OKL_SIF_FEES_V.tax_effect_yn%TYPE := OKC_API.G_MISS_CHAR

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

Line 173: ,days_in_month OKL_SIF_FEES_V.days_in_month%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: );
177: TYPE csm_periodic_expenses_tbl_type IS TABLE OF csm_periodic_expenses_rec_type

Line 174: ,days_in_year OKL_SIF_FEES_V.days_in_year%TYPE :=OKC_API.G_MISS_CHAR

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;

Line 293: description OKL_SIF_FEES_V.description%TYPE := OKC_API.G_MISS_CHAR

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

Line 294: ,date_start OKL_SIF_FEES_V.date_start%TYPE := OKC_API.G_MISS_DATE

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

Line 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

Line 301: ,lock_level_step OKL_SIF_FEES_V.lock_level_step%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

Line 303: ,period OKL_SIF_FEES_V.period%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

Line 304: ,advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%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

Line 305: ,income_or_expense OKL_SIF_FEES_V.income_or_expense%TYPE := OKC_API.G_MISS_CHAR

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

Line 307: ,structure OKL_SIF_FEES_V.structure%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

Line 309: ,query_level_yn OKL_SIF_FEES_V.query_level_yn%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

Line 310: ,days_in_month OKL_SIF_FEES_V.days_in_month%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
314: );

Line 311: ,days_in_year OKL_SIF_FEES_V.days_in_year%TYPE :=OKC_API.G_MISS_CHAR

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

Line 312: ,balance_type_code OKL_SIF_FEES_V.balance_type_code%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
316: INDEX BY BINARY_INTEGER;