DBA Data[Home] [Help]

APPS.OKL_CASH_RECEIPT dependencies on OKL_TRX_CSH_RECEIPT_V

Line 50: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT NULL;

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;

Line 51: l_ile_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%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;

Line 52: l_iba_id OKL_TRX_CSH_RECEIPT_V.IBA_ID%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:

Line 53: l_orig_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;

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;

Line 54: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%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;

Line 55: l_functional_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%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:

Line 60: l_inv_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;

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;

Line 61: l_rec_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;

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;

Line 62: l_apply_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;

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:

Line 596: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT NULL;

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;

Line 597: l_ile_id OKL_TRX_CSH_RECEIPT_V.ILE_ID%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;

Line 598: l_iba_id OKL_TRX_CSH_RECEIPT_V.IBA_ID%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:

Line 599: l_orig_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;

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;

Line 600: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;

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;

Line 601: l_functional_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%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;
605:

Line 603: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;

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;

Line 604: l_apply_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;

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: