256: INDEX BY BINARY_INTEGER;
257: /* Lease Type - Header */
258: TYPE csm_lease_rec_type IS RECORD(
259: -- Common Details
260: jtot_object1_code OKL_STREAM_INTERFACES_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR
261: ,object1_id1 OKL_STREAM_INTERFACES_V.object1_id1%TYPE := OKC_API.G_MISS_CHAR
262: ,khr_id NUMBER := OKC_API.G_MISS_NUM
263: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
264: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lessor'
257: /* Lease Type - Header */
258: TYPE csm_lease_rec_type IS RECORD(
259: -- Common Details
260: jtot_object1_code OKL_STREAM_INTERFACES_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR
261: ,object1_id1 OKL_STREAM_INTERFACES_V.object1_id1%TYPE := OKC_API.G_MISS_CHAR
262: ,khr_id NUMBER := OKC_API.G_MISS_NUM
263: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
264: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lessor'
265: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
260: jtot_object1_code OKL_STREAM_INTERFACES_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR
261: ,object1_id1 OKL_STREAM_INTERFACES_V.object1_id1%TYPE := OKC_API.G_MISS_CHAR
262: ,khr_id NUMBER := OKC_API.G_MISS_NUM
263: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
264: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lessor'
265: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
266: ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
267: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
268: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
261: ,object1_id1 OKL_STREAM_INTERFACES_V.object1_id1%TYPE := OKC_API.G_MISS_CHAR
262: ,khr_id NUMBER := OKC_API.G_MISS_NUM
263: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
264: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lessor'
265: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
266: ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
267: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
268: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
269: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
262: ,khr_id NUMBER := OKC_API.G_MISS_NUM
263: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
264: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lessor'
265: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
266: ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
267: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
268: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
269: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
270: ,fasb_acct_treatment_method OKL_STREAM_INTERFACES_V.fasb_acct_treatment_method%TYPE := OKC_API.G_MISS_CHAR
263: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
264: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lessor'
265: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
266: ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
267: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
268: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
269: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
270: ,fasb_acct_treatment_method OKL_STREAM_INTERFACES_V.fasb_acct_treatment_method%TYPE := OKC_API.G_MISS_CHAR
271: ,adjust OKL_STREAM_INTERFACES_V.adjust%TYPE
265: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
266: ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
267: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
268: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
269: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
270: ,fasb_acct_treatment_method OKL_STREAM_INTERFACES_V.fasb_acct_treatment_method%TYPE := OKC_API.G_MISS_CHAR
271: ,adjust OKL_STREAM_INTERFACES_V.adjust%TYPE
272: ,adjustment_method OKL_STREAM_INTERFACES_V.adjustment_method%TYPE
273: ,term NUMBER := OKC_API.G_MISS_NUM
266: ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
267: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
268: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
269: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
270: ,fasb_acct_treatment_method OKL_STREAM_INTERFACES_V.fasb_acct_treatment_method%TYPE := OKC_API.G_MISS_CHAR
271: ,adjust OKL_STREAM_INTERFACES_V.adjust%TYPE
272: ,adjustment_method OKL_STREAM_INTERFACES_V.adjustment_method%TYPE
273: ,term NUMBER := OKC_API.G_MISS_NUM
274: ,structure OKL_STREAM_INTERFACES_V.structure%TYPE := OKC_API.G_MISS_CHAR
267: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
268: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
269: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
270: ,fasb_acct_treatment_method OKL_STREAM_INTERFACES_V.fasb_acct_treatment_method%TYPE := OKC_API.G_MISS_CHAR
271: ,adjust OKL_STREAM_INTERFACES_V.adjust%TYPE
272: ,adjustment_method OKL_STREAM_INTERFACES_V.adjustment_method%TYPE
273: ,term NUMBER := OKC_API.G_MISS_NUM
274: ,structure OKL_STREAM_INTERFACES_V.structure%TYPE := OKC_API.G_MISS_CHAR
275: -- Lease Type Details
268: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
269: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
270: ,fasb_acct_treatment_method OKL_STREAM_INTERFACES_V.fasb_acct_treatment_method%TYPE := OKC_API.G_MISS_CHAR
271: ,adjust OKL_STREAM_INTERFACES_V.adjust%TYPE
272: ,adjustment_method OKL_STREAM_INTERFACES_V.adjustment_method%TYPE
273: ,term NUMBER := OKC_API.G_MISS_NUM
274: ,structure OKL_STREAM_INTERFACES_V.structure%TYPE := OKC_API.G_MISS_CHAR
275: -- Lease Type Details
276: ,irs_tax_treatment_method OKL_STREAM_INTERFACES_V.irs_tax_treatment_method%TYPE := OKC_API.G_MISS_CHAR
270: ,fasb_acct_treatment_method OKL_STREAM_INTERFACES_V.fasb_acct_treatment_method%TYPE := OKC_API.G_MISS_CHAR
271: ,adjust OKL_STREAM_INTERFACES_V.adjust%TYPE
272: ,adjustment_method OKL_STREAM_INTERFACES_V.adjustment_method%TYPE
273: ,term NUMBER := OKC_API.G_MISS_NUM
274: ,structure OKL_STREAM_INTERFACES_V.structure%TYPE := OKC_API.G_MISS_CHAR
275: -- Lease Type Details
276: ,irs_tax_treatment_method OKL_STREAM_INTERFACES_V.irs_tax_treatment_method%TYPE := OKC_API.G_MISS_CHAR
277: ,date_delivery OKL_STREAM_INTERFACES_V.date_delivery%TYPE := OKC_API.G_MISS_DATE
278: ,implicit_interest_rate NUMBER DEFAULT NULL
272: ,adjustment_method OKL_STREAM_INTERFACES_V.adjustment_method%TYPE
273: ,term NUMBER := OKC_API.G_MISS_NUM
274: ,structure OKL_STREAM_INTERFACES_V.structure%TYPE := OKC_API.G_MISS_CHAR
275: -- Lease Type Details
276: ,irs_tax_treatment_method OKL_STREAM_INTERFACES_V.irs_tax_treatment_method%TYPE := OKC_API.G_MISS_CHAR
277: ,date_delivery OKL_STREAM_INTERFACES_V.date_delivery%TYPE := OKC_API.G_MISS_DATE
278: ,implicit_interest_rate NUMBER DEFAULT NULL
279: ,rvi_yn OKL_STREAM_INTERFACES_V.rvi_yn%TYPE := OKC_API.G_MISS_CHAR
280: ,rvi_rate NUMBER := OKC_API.G_MISS_NUM
273: ,term NUMBER := OKC_API.G_MISS_NUM
274: ,structure OKL_STREAM_INTERFACES_V.structure%TYPE := OKC_API.G_MISS_CHAR
275: -- Lease Type Details
276: ,irs_tax_treatment_method OKL_STREAM_INTERFACES_V.irs_tax_treatment_method%TYPE := OKC_API.G_MISS_CHAR
277: ,date_delivery OKL_STREAM_INTERFACES_V.date_delivery%TYPE := OKC_API.G_MISS_DATE
278: ,implicit_interest_rate NUMBER DEFAULT NULL
279: ,rvi_yn OKL_STREAM_INTERFACES_V.rvi_yn%TYPE := OKC_API.G_MISS_CHAR
280: ,rvi_rate NUMBER := OKC_API.G_MISS_NUM
281: -- mvasudev, Bug#2650599
275: -- Lease Type Details
276: ,irs_tax_treatment_method OKL_STREAM_INTERFACES_V.irs_tax_treatment_method%TYPE := OKC_API.G_MISS_CHAR
277: ,date_delivery OKL_STREAM_INTERFACES_V.date_delivery%TYPE := OKC_API.G_MISS_DATE
278: ,implicit_interest_rate NUMBER DEFAULT NULL
279: ,rvi_yn OKL_STREAM_INTERFACES_V.rvi_yn%TYPE := OKC_API.G_MISS_CHAR
280: ,rvi_rate NUMBER := OKC_API.G_MISS_NUM
281: -- mvasudev, Bug#2650599
282: ,sif_id NUMBER := OKC_API.G_MISS_NUM
283: ,purpose_code OKL_STREAM_INTERFACES_V.PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR
279: ,rvi_yn OKL_STREAM_INTERFACES_V.rvi_yn%TYPE := OKC_API.G_MISS_CHAR
280: ,rvi_rate NUMBER := OKC_API.G_MISS_NUM
281: -- mvasudev, Bug#2650599
282: ,sif_id NUMBER := OKC_API.G_MISS_NUM
283: ,purpose_code OKL_STREAM_INTERFACES_V.PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR
284: -- end, mvasudev, Bug#2650599
285: );
286: -- 04/21/2002
287: /* Loan Lines */
328: -- end,04/21/2002
329: /* Loan Type - Header */
330: TYPE csm_loan_rec_type IS RECORD(
331: -- Common Details
332: jtot_object1_code OKL_STREAM_INTERFACES_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR
333: ,object1_id1 OKL_STREAM_INTERFACES_V.object1_id1%TYPE := OKC_API.G_MISS_CHAR
334: ,khr_id NUMBER := OKC_API.G_MISS_NUM
335: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
336: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lender'
329: /* Loan Type - Header */
330: TYPE csm_loan_rec_type IS RECORD(
331: -- Common Details
332: jtot_object1_code OKL_STREAM_INTERFACES_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR
333: ,object1_id1 OKL_STREAM_INTERFACES_V.object1_id1%TYPE := OKC_API.G_MISS_CHAR
334: ,khr_id NUMBER := OKC_API.G_MISS_NUM
335: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
336: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lender'
337: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
332: jtot_object1_code OKL_STREAM_INTERFACES_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR
333: ,object1_id1 OKL_STREAM_INTERFACES_V.object1_id1%TYPE := OKC_API.G_MISS_CHAR
334: ,khr_id NUMBER := OKC_API.G_MISS_NUM
335: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
336: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lender'
337: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
338: ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
339: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
340: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
333: ,object1_id1 OKL_STREAM_INTERFACES_V.object1_id1%TYPE := OKC_API.G_MISS_CHAR
334: ,khr_id NUMBER := OKC_API.G_MISS_NUM
335: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
336: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lender'
337: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
338: ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
339: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
340: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
341: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
334: ,khr_id NUMBER := OKC_API.G_MISS_NUM
335: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
336: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lender'
337: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
338: ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
339: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
340: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
341: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
342: -- Loan Type Details
335: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
336: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lender'
337: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
338: ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
339: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
340: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
341: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
342: -- Loan Type Details
343: ,total_lending NUMBER := OKC_API.G_MISS_NUM
337: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
338: ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
339: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
340: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
341: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
342: -- Loan Type Details
343: ,total_lending NUMBER := OKC_API.G_MISS_NUM
344: ,date_start OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
345: ,lending_rate NUMBER DEFAULT NULL
340: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
341: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
342: -- Loan Type Details
343: ,total_lending NUMBER := OKC_API.G_MISS_NUM
344: ,date_start OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
345: ,lending_rate NUMBER DEFAULT NULL
346: -- mvasudev, Bug#2650599
347: ,sif_id NUMBER := OKC_API.G_MISS_NUM
348: ,purpose_code OKL_STREAM_INTERFACES_V.PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR
344: ,date_start OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
345: ,lending_rate NUMBER DEFAULT NULL
346: -- mvasudev, Bug#2650599
347: ,sif_id NUMBER := OKC_API.G_MISS_NUM
348: ,purpose_code OKL_STREAM_INTERFACES_V.PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR
349: -- end, mvasudev, Bug#2650599
350: -- added for Loan Quote requirements smahapat 10/30/03
351: ,adjust OKL_STREAM_INTERFACES_V.adjust%TYPE
352: ,adjustment_method OKL_STREAM_INTERFACES_V.adjustment_method%TYPE
347: ,sif_id NUMBER := OKC_API.G_MISS_NUM
348: ,purpose_code OKL_STREAM_INTERFACES_V.PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR
349: -- end, mvasudev, Bug#2650599
350: -- added for Loan Quote requirements smahapat 10/30/03
351: ,adjust OKL_STREAM_INTERFACES_V.adjust%TYPE
352: ,adjustment_method OKL_STREAM_INTERFACES_V.adjustment_method%TYPE
353: );
354: /* For Fees and Asset Index */
355: TYPE index_rec_type IS RECORD
348: ,purpose_code OKL_STREAM_INTERFACES_V.PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR
349: -- end, mvasudev, Bug#2650599
350: -- added for Loan Quote requirements smahapat 10/30/03
351: ,adjust OKL_STREAM_INTERFACES_V.adjust%TYPE
352: ,adjustment_method OKL_STREAM_INTERFACES_V.adjustment_method%TYPE
353: );
354: /* For Fees and Asset Index */
355: TYPE index_rec_type IS RECORD
356: (