46: l_over_pay VARCHAR2(1) DEFAULT NULL;
47: l_conc_proc VARCHAR2(2) DEFAULT p_conc_proc;
48: l_counter NUMBER;
49:
50: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT NULL;
51: l_ile_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;
52: l_iba_id OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE DEFAULT NULL;
53: l_orig_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
54: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
47: l_conc_proc VARCHAR2(2) DEFAULT p_conc_proc;
48: l_counter NUMBER;
49:
50: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT NULL;
51: l_ile_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;
52: l_iba_id OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE DEFAULT NULL;
53: l_orig_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
54: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
55: l_functional_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
48: l_counter NUMBER;
49:
50: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT NULL;
51: l_ile_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;
52: l_iba_id OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE DEFAULT NULL;
53: l_orig_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
54: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
55: l_functional_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
56:
49:
50: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT NULL;
51: l_ile_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;
52: l_iba_id OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE DEFAULT NULL;
53: l_orig_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
54: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
55: l_functional_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
56:
57: ar_invoice_num RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE DEFAULT NULL;
50: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT NULL;
51: l_ile_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;
52: l_iba_id OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE DEFAULT NULL;
53: l_orig_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
54: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
55: l_functional_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
56:
57: ar_invoice_num RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE DEFAULT NULL;
58: ar_invoice_date OKL_BPD_LEASING_PAYMENT_TRX_V.INVOICE_DATE%TYPE DEFAULT NULL;
51: l_ile_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;
52: l_iba_id OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE DEFAULT NULL;
53: l_orig_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
54: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
55: l_functional_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
56:
57: ar_invoice_num RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE DEFAULT NULL;
58: ar_invoice_date OKL_BPD_LEASING_PAYMENT_TRX_V.INVOICE_DATE%TYPE DEFAULT NULL;
59:
56:
57: ar_invoice_num RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE DEFAULT NULL;
58: ar_invoice_date OKL_BPD_LEASING_PAYMENT_TRX_V.INVOICE_DATE%TYPE DEFAULT NULL;
59:
60: l_inv_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
61: l_rec_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
62: l_apply_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
63:
64: l_customer_trx_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL;
57: ar_invoice_num RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE DEFAULT NULL;
58: ar_invoice_date OKL_BPD_LEASING_PAYMENT_TRX_V.INVOICE_DATE%TYPE DEFAULT NULL;
59:
60: l_inv_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
61: l_rec_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
62: l_apply_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
63:
64: l_customer_trx_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL;
65: l_customer_site_use_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_SITE_USE_ID%TYPE DEFAULT NULL;
58: ar_invoice_date OKL_BPD_LEASING_PAYMENT_TRX_V.INVOICE_DATE%TYPE DEFAULT NULL;
59:
60: l_inv_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
61: l_rec_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
62: l_apply_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
63:
64: l_customer_trx_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL;
65: l_customer_site_use_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_SITE_USE_ID%TYPE DEFAULT NULL;
66:
592: l_over_pay VARCHAR2(1) DEFAULT NULL;
593: l_conc_proc VARCHAR2(2) DEFAULT p_conc_proc;
594: l_counter NUMBER;
595:
596: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT NULL;
597: l_ile_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;
598: l_iba_id OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE DEFAULT NULL;
599: l_orig_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
600: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
593: l_conc_proc VARCHAR2(2) DEFAULT p_conc_proc;
594: l_counter NUMBER;
595:
596: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT NULL;
597: l_ile_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;
598: l_iba_id OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE DEFAULT NULL;
599: l_orig_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
600: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
601: l_functional_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
594: l_counter NUMBER;
595:
596: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT NULL;
597: l_ile_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;
598: l_iba_id OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE DEFAULT NULL;
599: l_orig_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
600: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
601: l_functional_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
602:
595:
596: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT NULL;
597: l_ile_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;
598: l_iba_id OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE DEFAULT NULL;
599: l_orig_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
600: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
601: l_functional_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
602:
603: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
596: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT NULL;
597: l_ile_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;
598: l_iba_id OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE DEFAULT NULL;
599: l_orig_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
600: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
601: l_functional_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
602:
603: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
604: l_apply_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
597: l_ile_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%TYPE DEFAULT NULL;
598: l_iba_id OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE DEFAULT NULL;
599: l_orig_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
600: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
601: l_functional_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
602:
603: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
604: l_apply_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
605:
599: l_orig_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
600: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
601: l_functional_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
602:
603: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
604: l_apply_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
605:
606: l_customer_trx_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL;
607: l_customer_site_use_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_SITE_USE_ID%TYPE DEFAULT NULL;
600: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
601: l_functional_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
602:
603: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
604: l_apply_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
605:
606: l_customer_trx_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL;
607: l_customer_site_use_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_SITE_USE_ID%TYPE DEFAULT NULL;
608: