DBA Data[Home] [Help]

APPS.OKL_CREATE_STREAMS_PVT dependencies on OKL_SIF_LINES_V

Line 213: ,residual_guarantee_method OKL_SIF_LINES_V.residual_guarantee_method%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

Line 216: ,fed_depre_adr_conve OKL_SIF_LINES_V.fed_depre_adr_conve%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

Line 218: ,state_depre_method OKL_SIF_LINES_V.state_depre_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
222: ,state_depre_term NUMBER := OKC_API.G_MISS_NUM

Line 219: ,purchase_option OKL_SIF_LINES_V.purchase_option%TYPE := OKC_API.G_MISS_CHAR

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

Line 223: ,state_depre_adr_convent OKL_SIF_LINES_V.state_depre_adr_convent%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
227: ,fed_depre_salvage NUMBER := OKC_API.G_MISS_NUM

Line 224: ,fed_depre_method OKL_SIF_LINES_V.fed_depre_method%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
228: ,date_fed_depre OKL_SIF_LINES_V.date_fed_depre%TYPE := OKC_API.G_MISS_DATE

Line 226: ,residual_date OKL_SIF_LINES_V.residual_date%TYPE := OKC_API.G_MISS_DATE

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

Line 228: ,date_fed_depre OKL_SIF_LINES_V.date_fed_depre%TYPE := OKC_API.G_MISS_DATE

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

Line 230: ,book_adr_convention OKL_SIF_LINES_V.book_adr_convention%TYPE := OKC_API.G_MISS_CHAR

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

Line 234: ,date_delivery OKL_SIF_LINES_V.date_delivery%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

Line 237: ,date_funding OKL_SIF_LINES_V.date_funding%TYPE := OKC_API.G_MISS_DATE

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

Line 238: ,date_book OKL_SIF_LINES_V.date_book%TYPE := OKC_API.G_MISS_DATE

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

Line 239: ,date_state_depre OKL_SIF_LINES_V.date_state_depre%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
243: ,guarantee_type OKL_SIF_LINES_V.residual_guarantee_type%TYPE

Line 240: ,book_method OKL_SIF_LINES_V.book_method%TYPE := OKC_API.G_MISS_CHAR

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

Line 241: ,description OKL_SIF_LINES_V.description%TYPE := OKC_API.G_MISS_CHAR

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

Line 243: ,guarantee_type OKL_SIF_LINES_V.residual_guarantee_type%TYPE

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
246: );
247: TYPE csm_line_details_tbl_type IS TABLE OF csm_line_details_rec_type

Line 245: ,capitalize_down_payment_yn OKL_SIF_LINES_V.capitalize_down_payment_yn%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;
249: /* Lease Type - Header */

Line 285: ,capitalize_down_payment_yn OKL_SIF_LINES_V.capitalize_down_payment_yn%TYPE := OKC_API.G_MISS_CHAR

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;