DBA Data[Home] [Help]

APPS.OKL_CREATE_STREAMS_PVT dependencies on OKL_SIF_LINES_V

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

215: TYPE csm_line_details_rec_type IS RECORD(
216: kle_asset_id NUMBER := OKC_API.G_MISS_NUM
217: ,state_depre_dmnshing_value_rt NUMBER := OKC_API.G_MISS_NUM
218: ,book_depre_dmnshing_value_rt NUMBER := OKC_API.G_MISS_NUM
219: ,residual_guarantee_method OKL_SIF_LINES_V.residual_guarantee_method%TYPE := OKC_API.G_MISS_CHAR
220: ,fed_depre_term NUMBER := OKC_API.G_MISS_NUM
221: ,fed_depre_dmnshing_value_rate NUMBER := OKC_API.G_MISS_NUM
222: ,fed_depre_adr_conve OKL_SIF_LINES_V.fed_depre_adr_conve%TYPE := OKC_API.G_MISS_CHAR
223: ,state_depre_basis_percent NUMBER := OKC_API.G_MISS_NUM

Line 222: ,fed_depre_adr_conve OKL_SIF_LINES_V.fed_depre_adr_conve%TYPE := OKC_API.G_MISS_CHAR

218: ,book_depre_dmnshing_value_rt NUMBER := OKC_API.G_MISS_NUM
219: ,residual_guarantee_method OKL_SIF_LINES_V.residual_guarantee_method%TYPE := OKC_API.G_MISS_CHAR
220: ,fed_depre_term NUMBER := OKC_API.G_MISS_NUM
221: ,fed_depre_dmnshing_value_rate NUMBER := OKC_API.G_MISS_NUM
222: ,fed_depre_adr_conve OKL_SIF_LINES_V.fed_depre_adr_conve%TYPE := OKC_API.G_MISS_CHAR
223: ,state_depre_basis_percent NUMBER := OKC_API.G_MISS_NUM
224: ,state_depre_method OKL_SIF_LINES_V.state_depre_method%TYPE := OKC_API.G_MISS_CHAR
225: ,purchase_option OKL_SIF_LINES_V.purchase_option%TYPE := OKC_API.G_MISS_CHAR
226: ,purchase_option_amount NUMBER := OKC_API.G_MISS_NUM

Line 224: ,state_depre_method OKL_SIF_LINES_V.state_depre_method%TYPE := OKC_API.G_MISS_CHAR

220: ,fed_depre_term NUMBER := OKC_API.G_MISS_NUM
221: ,fed_depre_dmnshing_value_rate NUMBER := OKC_API.G_MISS_NUM
222: ,fed_depre_adr_conve OKL_SIF_LINES_V.fed_depre_adr_conve%TYPE := OKC_API.G_MISS_CHAR
223: ,state_depre_basis_percent NUMBER := OKC_API.G_MISS_NUM
224: ,state_depre_method OKL_SIF_LINES_V.state_depre_method%TYPE := OKC_API.G_MISS_CHAR
225: ,purchase_option OKL_SIF_LINES_V.purchase_option%TYPE := OKC_API.G_MISS_CHAR
226: ,purchase_option_amount NUMBER := OKC_API.G_MISS_NUM
227: ,asset_cost NUMBER := OKC_API.G_MISS_NUM
228: ,state_depre_term NUMBER := OKC_API.G_MISS_NUM

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

221: ,fed_depre_dmnshing_value_rate NUMBER := OKC_API.G_MISS_NUM
222: ,fed_depre_adr_conve OKL_SIF_LINES_V.fed_depre_adr_conve%TYPE := OKC_API.G_MISS_CHAR
223: ,state_depre_basis_percent NUMBER := OKC_API.G_MISS_NUM
224: ,state_depre_method OKL_SIF_LINES_V.state_depre_method%TYPE := OKC_API.G_MISS_CHAR
225: ,purchase_option OKL_SIF_LINES_V.purchase_option%TYPE := OKC_API.G_MISS_CHAR
226: ,purchase_option_amount NUMBER := OKC_API.G_MISS_NUM
227: ,asset_cost NUMBER := OKC_API.G_MISS_NUM
228: ,state_depre_term NUMBER := OKC_API.G_MISS_NUM
229: ,state_depre_adr_convent OKL_SIF_LINES_V.state_depre_adr_convent%TYPE := OKC_API.G_MISS_CHAR

Line 229: ,state_depre_adr_convent OKL_SIF_LINES_V.state_depre_adr_convent%TYPE := OKC_API.G_MISS_CHAR

225: ,purchase_option OKL_SIF_LINES_V.purchase_option%TYPE := OKC_API.G_MISS_CHAR
226: ,purchase_option_amount NUMBER := OKC_API.G_MISS_NUM
227: ,asset_cost NUMBER := OKC_API.G_MISS_NUM
228: ,state_depre_term NUMBER := OKC_API.G_MISS_NUM
229: ,state_depre_adr_convent OKL_SIF_LINES_V.state_depre_adr_convent%TYPE := OKC_API.G_MISS_CHAR
230: ,fed_depre_method OKL_SIF_LINES_V.fed_depre_method%TYPE := OKC_API.G_MISS_CHAR
231: ,residual_amount NUMBER := OKC_API.G_MISS_NUM
232: ,residual_date OKL_SIF_LINES_V.residual_date%TYPE := OKC_API.G_MISS_DATE
233: ,fed_depre_salvage NUMBER := OKC_API.G_MISS_NUM

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

226: ,purchase_option_amount NUMBER := OKC_API.G_MISS_NUM
227: ,asset_cost NUMBER := OKC_API.G_MISS_NUM
228: ,state_depre_term NUMBER := OKC_API.G_MISS_NUM
229: ,state_depre_adr_convent OKL_SIF_LINES_V.state_depre_adr_convent%TYPE := OKC_API.G_MISS_CHAR
230: ,fed_depre_method OKL_SIF_LINES_V.fed_depre_method%TYPE := OKC_API.G_MISS_CHAR
231: ,residual_amount NUMBER := OKC_API.G_MISS_NUM
232: ,residual_date OKL_SIF_LINES_V.residual_date%TYPE := OKC_API.G_MISS_DATE
233: ,fed_depre_salvage NUMBER := OKC_API.G_MISS_NUM
234: ,date_fed_depre OKL_SIF_LINES_V.date_fed_depre%TYPE := OKC_API.G_MISS_DATE

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

228: ,state_depre_term NUMBER := OKC_API.G_MISS_NUM
229: ,state_depre_adr_convent OKL_SIF_LINES_V.state_depre_adr_convent%TYPE := OKC_API.G_MISS_CHAR
230: ,fed_depre_method OKL_SIF_LINES_V.fed_depre_method%TYPE := OKC_API.G_MISS_CHAR
231: ,residual_amount NUMBER := OKC_API.G_MISS_NUM
232: ,residual_date OKL_SIF_LINES_V.residual_date%TYPE := OKC_API.G_MISS_DATE
233: ,fed_depre_salvage NUMBER := OKC_API.G_MISS_NUM
234: ,date_fed_depre OKL_SIF_LINES_V.date_fed_depre%TYPE := OKC_API.G_MISS_DATE
235: ,book_salvage NUMBER := OKC_API.G_MISS_NUM
236: ,book_adr_convention OKL_SIF_LINES_V.book_adr_convention%TYPE := OKC_API.G_MISS_CHAR

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

230: ,fed_depre_method OKL_SIF_LINES_V.fed_depre_method%TYPE := OKC_API.G_MISS_CHAR
231: ,residual_amount NUMBER := OKC_API.G_MISS_NUM
232: ,residual_date OKL_SIF_LINES_V.residual_date%TYPE := OKC_API.G_MISS_DATE
233: ,fed_depre_salvage NUMBER := OKC_API.G_MISS_NUM
234: ,date_fed_depre OKL_SIF_LINES_V.date_fed_depre%TYPE := OKC_API.G_MISS_DATE
235: ,book_salvage NUMBER := OKC_API.G_MISS_NUM
236: ,book_adr_convention OKL_SIF_LINES_V.book_adr_convention%TYPE := OKC_API.G_MISS_CHAR
237: ,state_depre_salvage NUMBER := OKC_API.G_MISS_NUM
238: ,fed_depre_basis_percent NUMBER := OKC_API.G_MISS_NUM

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

232: ,residual_date OKL_SIF_LINES_V.residual_date%TYPE := OKC_API.G_MISS_DATE
233: ,fed_depre_salvage NUMBER := OKC_API.G_MISS_NUM
234: ,date_fed_depre OKL_SIF_LINES_V.date_fed_depre%TYPE := OKC_API.G_MISS_DATE
235: ,book_salvage NUMBER := OKC_API.G_MISS_NUM
236: ,book_adr_convention OKL_SIF_LINES_V.book_adr_convention%TYPE := OKC_API.G_MISS_CHAR
237: ,state_depre_salvage NUMBER := OKC_API.G_MISS_NUM
238: ,fed_depre_basis_percent NUMBER := OKC_API.G_MISS_NUM
239: ,book_basis_percent NUMBER := OKC_API.G_MISS_NUM
240: ,date_delivery OKL_SIF_LINES_V.date_delivery%TYPE := OKC_API.G_MISS_DATE

Line 240: ,date_delivery OKL_SIF_LINES_V.date_delivery%TYPE := OKC_API.G_MISS_DATE

236: ,book_adr_convention OKL_SIF_LINES_V.book_adr_convention%TYPE := OKC_API.G_MISS_CHAR
237: ,state_depre_salvage NUMBER := OKC_API.G_MISS_NUM
238: ,fed_depre_basis_percent NUMBER := OKC_API.G_MISS_NUM
239: ,book_basis_percent NUMBER := OKC_API.G_MISS_NUM
240: ,date_delivery OKL_SIF_LINES_V.date_delivery%TYPE := OKC_API.G_MISS_DATE
241: ,book_term NUMBER := OKC_API.G_MISS_NUM
242: ,residual_guarantee_amount NUMBER := OKC_API.G_MISS_NUM
243: ,date_funding OKL_SIF_LINES_V.date_funding%TYPE := OKC_API.G_MISS_DATE
244: ,date_book OKL_SIF_LINES_V.date_book%TYPE := OKC_API.G_MISS_DATE

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

239: ,book_basis_percent NUMBER := OKC_API.G_MISS_NUM
240: ,date_delivery OKL_SIF_LINES_V.date_delivery%TYPE := OKC_API.G_MISS_DATE
241: ,book_term NUMBER := OKC_API.G_MISS_NUM
242: ,residual_guarantee_amount NUMBER := OKC_API.G_MISS_NUM
243: ,date_funding OKL_SIF_LINES_V.date_funding%TYPE := OKC_API.G_MISS_DATE
244: ,date_book OKL_SIF_LINES_V.date_book%TYPE := OKC_API.G_MISS_DATE
245: ,date_state_depre OKL_SIF_LINES_V.date_state_depre%TYPE := OKC_API.G_MISS_DATE
246: ,book_method OKL_SIF_LINES_V.book_method%TYPE := OKC_API.G_MISS_CHAR
247: ,description OKL_SIF_LINES_V.description%TYPE := OKC_API.G_MISS_CHAR

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

240: ,date_delivery OKL_SIF_LINES_V.date_delivery%TYPE := OKC_API.G_MISS_DATE
241: ,book_term NUMBER := OKC_API.G_MISS_NUM
242: ,residual_guarantee_amount NUMBER := OKC_API.G_MISS_NUM
243: ,date_funding OKL_SIF_LINES_V.date_funding%TYPE := OKC_API.G_MISS_DATE
244: ,date_book OKL_SIF_LINES_V.date_book%TYPE := OKC_API.G_MISS_DATE
245: ,date_state_depre OKL_SIF_LINES_V.date_state_depre%TYPE := OKC_API.G_MISS_DATE
246: ,book_method OKL_SIF_LINES_V.book_method%TYPE := OKC_API.G_MISS_CHAR
247: ,description OKL_SIF_LINES_V.description%TYPE := OKC_API.G_MISS_CHAR
248: -- stream_interface_attribute01 => guarantee_type

Line 245: ,date_state_depre OKL_SIF_LINES_V.date_state_depre%TYPE := OKC_API.G_MISS_DATE

241: ,book_term NUMBER := OKC_API.G_MISS_NUM
242: ,residual_guarantee_amount NUMBER := OKC_API.G_MISS_NUM
243: ,date_funding OKL_SIF_LINES_V.date_funding%TYPE := OKC_API.G_MISS_DATE
244: ,date_book OKL_SIF_LINES_V.date_book%TYPE := OKC_API.G_MISS_DATE
245: ,date_state_depre OKL_SIF_LINES_V.date_state_depre%TYPE := OKC_API.G_MISS_DATE
246: ,book_method OKL_SIF_LINES_V.book_method%TYPE := OKC_API.G_MISS_CHAR
247: ,description OKL_SIF_LINES_V.description%TYPE := OKC_API.G_MISS_CHAR
248: -- stream_interface_attribute01 => guarantee_type
249: ,guarantee_type OKL_SIF_LINES_V.residual_guarantee_type%TYPE

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

242: ,residual_guarantee_amount NUMBER := OKC_API.G_MISS_NUM
243: ,date_funding OKL_SIF_LINES_V.date_funding%TYPE := OKC_API.G_MISS_DATE
244: ,date_book OKL_SIF_LINES_V.date_book%TYPE := OKC_API.G_MISS_DATE
245: ,date_state_depre OKL_SIF_LINES_V.date_state_depre%TYPE := OKC_API.G_MISS_DATE
246: ,book_method OKL_SIF_LINES_V.book_method%TYPE := OKC_API.G_MISS_CHAR
247: ,description OKL_SIF_LINES_V.description%TYPE := OKC_API.G_MISS_CHAR
248: -- stream_interface_attribute01 => guarantee_type
249: ,guarantee_type OKL_SIF_LINES_V.residual_guarantee_type%TYPE
250: ,down_payment_amount NUMBER := OKC_API.G_MISS_NUM

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

243: ,date_funding OKL_SIF_LINES_V.date_funding%TYPE := OKC_API.G_MISS_DATE
244: ,date_book OKL_SIF_LINES_V.date_book%TYPE := OKC_API.G_MISS_DATE
245: ,date_state_depre OKL_SIF_LINES_V.date_state_depre%TYPE := OKC_API.G_MISS_DATE
246: ,book_method OKL_SIF_LINES_V.book_method%TYPE := OKC_API.G_MISS_CHAR
247: ,description OKL_SIF_LINES_V.description%TYPE := OKC_API.G_MISS_CHAR
248: -- stream_interface_attribute01 => guarantee_type
249: ,guarantee_type OKL_SIF_LINES_V.residual_guarantee_type%TYPE
250: ,down_payment_amount NUMBER := OKC_API.G_MISS_NUM
251: ,capitalize_down_payment_yn OKL_SIF_LINES_V.capitalize_down_payment_yn%TYPE := OKC_API.G_MISS_CHAR

Line 249: ,guarantee_type OKL_SIF_LINES_V.residual_guarantee_type%TYPE

245: ,date_state_depre OKL_SIF_LINES_V.date_state_depre%TYPE := OKC_API.G_MISS_DATE
246: ,book_method OKL_SIF_LINES_V.book_method%TYPE := OKC_API.G_MISS_CHAR
247: ,description OKL_SIF_LINES_V.description%TYPE := OKC_API.G_MISS_CHAR
248: -- stream_interface_attribute01 => guarantee_type
249: ,guarantee_type OKL_SIF_LINES_V.residual_guarantee_type%TYPE
250: ,down_payment_amount NUMBER := OKC_API.G_MISS_NUM
251: ,capitalize_down_payment_yn OKL_SIF_LINES_V.capitalize_down_payment_yn%TYPE := OKC_API.G_MISS_CHAR
252: -- add reference to the external ID
253: ,orig_contract_line_id NUMBER := OKC_API.G_MISS_NUM

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

247: ,description OKL_SIF_LINES_V.description%TYPE := OKC_API.G_MISS_CHAR
248: -- stream_interface_attribute01 => guarantee_type
249: ,guarantee_type OKL_SIF_LINES_V.residual_guarantee_type%TYPE
250: ,down_payment_amount NUMBER := OKC_API.G_MISS_NUM
251: ,capitalize_down_payment_yn OKL_SIF_LINES_V.capitalize_down_payment_yn%TYPE := OKC_API.G_MISS_CHAR
252: -- add reference to the external ID
253: ,orig_contract_line_id NUMBER := OKC_API.G_MISS_NUM
254: );
255: TYPE csm_line_details_tbl_type IS TABLE OF csm_line_details_rec_type

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

289: kle_loan_id NUMBER := OKC_API.G_MISS_NUM
290: --Added by kthiruva on 15-Nov-2005 for the Down Payment CR
291: --Bug 4738011 - Start of Changes
292: ,down_payment_amount NUMBER := OKC_API.G_MISS_NUM
293: ,capitalize_down_payment_yn OKL_SIF_LINES_V.capitalize_down_payment_yn%TYPE := OKC_API.G_MISS_CHAR
294: ,orig_contract_line_id NUMBER := OKC_API.G_MISS_NUM
295: --Bug 4738011 - End of Changes
296: );
297: TYPE csm_loan_line_tbl_type IS TABLE OF csm_loan_line_rec_type