248: INDEX BY BINARY_INTEGER;
249: /* Lease Type - Header */
250: TYPE csm_lease_rec_type IS RECORD(
251: -- Common Details
252: jtot_object1_code OKL_STREAM_INTERFACES_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR
253: ,object1_id1 OKL_STREAM_INTERFACES_V.object1_id1%TYPE := OKC_API.G_MISS_CHAR
254: ,khr_id NUMBER := OKC_API.G_MISS_NUM
255: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
256: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lessor'
249: /* Lease Type - Header */
250: TYPE csm_lease_rec_type IS RECORD(
251: -- Common Details
252: jtot_object1_code OKL_STREAM_INTERFACES_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR
253: ,object1_id1 OKL_STREAM_INTERFACES_V.object1_id1%TYPE := OKC_API.G_MISS_CHAR
254: ,khr_id NUMBER := OKC_API.G_MISS_NUM
255: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
256: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lessor'
257: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
252: jtot_object1_code OKL_STREAM_INTERFACES_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR
253: ,object1_id1 OKL_STREAM_INTERFACES_V.object1_id1%TYPE := OKC_API.G_MISS_CHAR
254: ,khr_id NUMBER := OKC_API.G_MISS_NUM
255: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
256: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lessor'
257: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
258: ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
259: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
260: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
253: ,object1_id1 OKL_STREAM_INTERFACES_V.object1_id1%TYPE := OKC_API.G_MISS_CHAR
254: ,khr_id NUMBER := OKC_API.G_MISS_NUM
255: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
256: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lessor'
257: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
258: ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
259: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
260: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
261: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
254: ,khr_id NUMBER := OKC_API.G_MISS_NUM
255: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
256: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lessor'
257: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
258: ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
259: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
260: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
261: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
262: ,fasb_acct_treatment_method OKL_STREAM_INTERFACES_V.fasb_acct_treatment_method%TYPE := OKC_API.G_MISS_CHAR
255: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
256: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lessor'
257: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
258: ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
259: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
260: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
261: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
262: ,fasb_acct_treatment_method OKL_STREAM_INTERFACES_V.fasb_acct_treatment_method%TYPE := OKC_API.G_MISS_CHAR
263: ,adjust OKL_STREAM_INTERFACES_V.adjust%TYPE
257: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
258: ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
259: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
260: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
261: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
262: ,fasb_acct_treatment_method OKL_STREAM_INTERFACES_V.fasb_acct_treatment_method%TYPE := OKC_API.G_MISS_CHAR
263: ,adjust OKL_STREAM_INTERFACES_V.adjust%TYPE
264: ,adjustment_method OKL_STREAM_INTERFACES_V.adjustment_method%TYPE
265: ,term NUMBER := OKC_API.G_MISS_NUM
258: ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
259: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
260: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
261: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
262: ,fasb_acct_treatment_method OKL_STREAM_INTERFACES_V.fasb_acct_treatment_method%TYPE := OKC_API.G_MISS_CHAR
263: ,adjust OKL_STREAM_INTERFACES_V.adjust%TYPE
264: ,adjustment_method OKL_STREAM_INTERFACES_V.adjustment_method%TYPE
265: ,term NUMBER := OKC_API.G_MISS_NUM
266: ,structure OKL_STREAM_INTERFACES_V.structure%TYPE := OKC_API.G_MISS_CHAR
259: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
260: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
261: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
262: ,fasb_acct_treatment_method OKL_STREAM_INTERFACES_V.fasb_acct_treatment_method%TYPE := OKC_API.G_MISS_CHAR
263: ,adjust OKL_STREAM_INTERFACES_V.adjust%TYPE
264: ,adjustment_method OKL_STREAM_INTERFACES_V.adjustment_method%TYPE
265: ,term NUMBER := OKC_API.G_MISS_NUM
266: ,structure OKL_STREAM_INTERFACES_V.structure%TYPE := OKC_API.G_MISS_CHAR
267: -- Lease Type Details
260: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
261: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
262: ,fasb_acct_treatment_method OKL_STREAM_INTERFACES_V.fasb_acct_treatment_method%TYPE := OKC_API.G_MISS_CHAR
263: ,adjust OKL_STREAM_INTERFACES_V.adjust%TYPE
264: ,adjustment_method OKL_STREAM_INTERFACES_V.adjustment_method%TYPE
265: ,term NUMBER := OKC_API.G_MISS_NUM
266: ,structure OKL_STREAM_INTERFACES_V.structure%TYPE := OKC_API.G_MISS_CHAR
267: -- Lease Type Details
268: ,irs_tax_treatment_method OKL_STREAM_INTERFACES_V.irs_tax_treatment_method%TYPE := OKC_API.G_MISS_CHAR
262: ,fasb_acct_treatment_method OKL_STREAM_INTERFACES_V.fasb_acct_treatment_method%TYPE := OKC_API.G_MISS_CHAR
263: ,adjust OKL_STREAM_INTERFACES_V.adjust%TYPE
264: ,adjustment_method OKL_STREAM_INTERFACES_V.adjustment_method%TYPE
265: ,term NUMBER := OKC_API.G_MISS_NUM
266: ,structure OKL_STREAM_INTERFACES_V.structure%TYPE := OKC_API.G_MISS_CHAR
267: -- Lease Type Details
268: ,irs_tax_treatment_method OKL_STREAM_INTERFACES_V.irs_tax_treatment_method%TYPE := OKC_API.G_MISS_CHAR
269: ,date_delivery OKL_STREAM_INTERFACES_V.date_delivery%TYPE := OKC_API.G_MISS_DATE
270: ,implicit_interest_rate NUMBER DEFAULT NULL
264: ,adjustment_method OKL_STREAM_INTERFACES_V.adjustment_method%TYPE
265: ,term NUMBER := OKC_API.G_MISS_NUM
266: ,structure OKL_STREAM_INTERFACES_V.structure%TYPE := OKC_API.G_MISS_CHAR
267: -- Lease Type Details
268: ,irs_tax_treatment_method OKL_STREAM_INTERFACES_V.irs_tax_treatment_method%TYPE := OKC_API.G_MISS_CHAR
269: ,date_delivery OKL_STREAM_INTERFACES_V.date_delivery%TYPE := OKC_API.G_MISS_DATE
270: ,implicit_interest_rate NUMBER DEFAULT NULL
271: ,rvi_yn OKL_STREAM_INTERFACES_V.rvi_yn%TYPE := OKC_API.G_MISS_CHAR
272: ,rvi_rate NUMBER := OKC_API.G_MISS_NUM
265: ,term NUMBER := OKC_API.G_MISS_NUM
266: ,structure OKL_STREAM_INTERFACES_V.structure%TYPE := OKC_API.G_MISS_CHAR
267: -- Lease Type Details
268: ,irs_tax_treatment_method OKL_STREAM_INTERFACES_V.irs_tax_treatment_method%TYPE := OKC_API.G_MISS_CHAR
269: ,date_delivery OKL_STREAM_INTERFACES_V.date_delivery%TYPE := OKC_API.G_MISS_DATE
270: ,implicit_interest_rate NUMBER DEFAULT NULL
271: ,rvi_yn OKL_STREAM_INTERFACES_V.rvi_yn%TYPE := OKC_API.G_MISS_CHAR
272: ,rvi_rate NUMBER := OKC_API.G_MISS_NUM
273: -- mvasudev, Bug#2650599
267: -- Lease Type Details
268: ,irs_tax_treatment_method OKL_STREAM_INTERFACES_V.irs_tax_treatment_method%TYPE := OKC_API.G_MISS_CHAR
269: ,date_delivery OKL_STREAM_INTERFACES_V.date_delivery%TYPE := OKC_API.G_MISS_DATE
270: ,implicit_interest_rate NUMBER DEFAULT NULL
271: ,rvi_yn OKL_STREAM_INTERFACES_V.rvi_yn%TYPE := OKC_API.G_MISS_CHAR
272: ,rvi_rate NUMBER := OKC_API.G_MISS_NUM
273: -- mvasudev, Bug#2650599
274: ,sif_id NUMBER := OKC_API.G_MISS_NUM
275: ,purpose_code OKL_STREAM_INTERFACES_V.PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR
271: ,rvi_yn OKL_STREAM_INTERFACES_V.rvi_yn%TYPE := OKC_API.G_MISS_CHAR
272: ,rvi_rate NUMBER := OKC_API.G_MISS_NUM
273: -- mvasudev, Bug#2650599
274: ,sif_id NUMBER := OKC_API.G_MISS_NUM
275: ,purpose_code OKL_STREAM_INTERFACES_V.PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR
276: -- end, mvasudev, Bug#2650599
277: );
278: -- 04/21/2002
279: /* Loan Lines */
317: -- end,04/21/2002
318: /* Loan Type - Header */
319: TYPE csm_loan_rec_type IS RECORD(
320: -- Common Details
321: jtot_object1_code OKL_STREAM_INTERFACES_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR
322: ,object1_id1 OKL_STREAM_INTERFACES_V.object1_id1%TYPE := OKC_API.G_MISS_CHAR
323: ,khr_id NUMBER := OKC_API.G_MISS_NUM
324: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
325: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lender'
318: /* Loan Type - Header */
319: TYPE csm_loan_rec_type IS RECORD(
320: -- Common Details
321: jtot_object1_code OKL_STREAM_INTERFACES_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR
322: ,object1_id1 OKL_STREAM_INTERFACES_V.object1_id1%TYPE := OKC_API.G_MISS_CHAR
323: ,khr_id NUMBER := OKC_API.G_MISS_NUM
324: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
325: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lender'
326: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
321: jtot_object1_code OKL_STREAM_INTERFACES_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR
322: ,object1_id1 OKL_STREAM_INTERFACES_V.object1_id1%TYPE := OKC_API.G_MISS_CHAR
323: ,khr_id NUMBER := OKC_API.G_MISS_NUM
324: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
325: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lender'
326: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
327: ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
328: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
329: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
322: ,object1_id1 OKL_STREAM_INTERFACES_V.object1_id1%TYPE := OKC_API.G_MISS_CHAR
323: ,khr_id NUMBER := OKC_API.G_MISS_NUM
324: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
325: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lender'
326: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
327: ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
328: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
329: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
330: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
323: ,khr_id NUMBER := OKC_API.G_MISS_NUM
324: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
325: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lender'
326: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
327: ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
328: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
329: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
330: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
331: -- Loan Type Details
324: ,pdt_id NUMBER := OKC_API.G_MISS_NUM
325: ,sif_mode OKL_STREAM_INTERFACES_V.sif_mode%TYPE DEFAULT 'Lender'
326: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
327: ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
328: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
329: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
330: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
331: -- Loan Type Details
332: ,total_lending NUMBER := OKC_API.G_MISS_NUM
326: ,country OKL_STREAM_INTERFACES_V.country%TYPE := OKC_API.G_MISS_CHAR
327: ,orp_code OKL_STREAM_INTERFACES_V.orp_code%TYPE := OKC_API.G_MISS_CHAR
328: ,date_payments_commencement OKL_STREAM_INTERFACES_V.date_payments_commencement%TYPE := OKC_API.G_MISS_DATE
329: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
330: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
331: -- Loan Type Details
332: ,total_lending NUMBER := OKC_API.G_MISS_NUM
333: ,date_start OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
334: ,lending_rate NUMBER DEFAULT NULL
329: ,security_deposit_amount NUMBER := OKC_API.G_MISS_NUM
330: ,date_sec_deposit_collected OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
331: -- Loan Type Details
332: ,total_lending NUMBER := OKC_API.G_MISS_NUM
333: ,date_start OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
334: ,lending_rate NUMBER DEFAULT NULL
335: -- mvasudev, Bug#2650599
336: ,sif_id NUMBER := OKC_API.G_MISS_NUM
337: ,purpose_code OKL_STREAM_INTERFACES_V.PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR
333: ,date_start OKL_STREAM_INTERFACES_V.date_sec_deposit_collected%TYPE := OKC_API.G_MISS_DATE
334: ,lending_rate NUMBER DEFAULT NULL
335: -- mvasudev, Bug#2650599
336: ,sif_id NUMBER := OKC_API.G_MISS_NUM
337: ,purpose_code OKL_STREAM_INTERFACES_V.PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR
338: -- end, mvasudev, Bug#2650599
339: -- added for Loan Quote requirements smahapat 10/30/03
340: ,adjust OKL_STREAM_INTERFACES_V.adjust%TYPE
341: ,adjustment_method OKL_STREAM_INTERFACES_V.adjustment_method%TYPE
336: ,sif_id NUMBER := OKC_API.G_MISS_NUM
337: ,purpose_code OKL_STREAM_INTERFACES_V.PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR
338: -- end, mvasudev, Bug#2650599
339: -- added for Loan Quote requirements smahapat 10/30/03
340: ,adjust OKL_STREAM_INTERFACES_V.adjust%TYPE
341: ,adjustment_method OKL_STREAM_INTERFACES_V.adjustment_method%TYPE
342: );
343: /* For Fees and Asset Index */
344: TYPE index_rec_type IS RECORD
337: ,purpose_code OKL_STREAM_INTERFACES_V.PURPOSE_CODE%TYPE := OKC_API.G_MISS_CHAR
338: -- end, mvasudev, Bug#2650599
339: -- added for Loan Quote requirements smahapat 10/30/03
340: ,adjust OKL_STREAM_INTERFACES_V.adjust%TYPE
341: ,adjustment_method OKL_STREAM_INTERFACES_V.adjustment_method%TYPE
342: );
343: /* For Fees and Asset Index */
344: TYPE index_rec_type IS RECORD
345: (