eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_PAYMENT_PVT dependencies on OKL_TRX_CSH_RECEIPT_V

Line 532: l_payment_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL;

528: l_check NUMBER := 0;
529: l_commit VARCHAR2(1);
530: l_validation_level NUMBER;
531: l_customer_site_use_id NUMBER;
532: l_payment_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL;
533: l_rct_id OKL_TRX_CSH_RECEIPT_V.ID%TYPE;
534: l_xcr_id NUMBER;
535: l_cash_receipt_id NUMBER;
536: l_cons_bill_id OKL_CNSLD_AR_HDRS_V.ID%TYPE;

Line 533: l_rct_id OKL_TRX_CSH_RECEIPT_V.ID%TYPE;

529: l_commit VARCHAR2(1);
530: l_validation_level NUMBER;
531: l_customer_site_use_id NUMBER;
532: l_payment_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL;
533: l_rct_id OKL_TRX_CSH_RECEIPT_V.ID%TYPE;
534: l_xcr_id NUMBER;
535: l_cash_receipt_id NUMBER;
536: l_cons_bill_id OKL_CNSLD_AR_HDRS_V.ID%TYPE;
537: l_cons_bill_num OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE;

Line 538: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;

534: l_xcr_id NUMBER;
535: l_cash_receipt_id NUMBER;
536: l_cons_bill_id OKL_CNSLD_AR_HDRS_V.ID%TYPE;
537: l_cons_bill_num OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE;
538: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;
539: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE;
540: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE;
541: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE;
542: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE;

Line 539: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE;

535: l_cash_receipt_id NUMBER;
536: l_cons_bill_id OKL_CNSLD_AR_HDRS_V.ID%TYPE;
537: l_cons_bill_num OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE;
538: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;
539: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE;
540: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE;
541: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE;
542: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE;
543: l_payment_ref_number AR_CASH_RECEIPTS_ALL.RECEIPT_NUMBER%TYPE DEFAULT NULL;

Line 540: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE;

536: l_cons_bill_id OKL_CNSLD_AR_HDRS_V.ID%TYPE;
537: l_cons_bill_num OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE;
538: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;
539: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE;
540: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE;
541: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE;
542: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE;
543: l_payment_ref_number AR_CASH_RECEIPTS_ALL.RECEIPT_NUMBER%TYPE DEFAULT NULL;
544: l_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE;

Line 541: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE;

537: l_cons_bill_num OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE;
538: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;
539: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE;
540: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE;
541: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE;
542: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE;
543: l_payment_ref_number AR_CASH_RECEIPTS_ALL.RECEIPT_NUMBER%TYPE DEFAULT NULL;
544: l_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE;
545: l_contract_id OKC_K_HEADERS_B.ID%TYPE;

Line 542: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE;

538: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;
539: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE;
540: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE;
541: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE;
542: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE;
543: l_payment_ref_number AR_CASH_RECEIPTS_ALL.RECEIPT_NUMBER%TYPE DEFAULT NULL;
544: l_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE;
545: l_contract_id OKC_K_HEADERS_B.ID%TYPE;
546: l_contract_num OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

Line 544: l_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE;

540: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE;
541: l_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE;
542: l_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE;
543: l_payment_ref_number AR_CASH_RECEIPTS_ALL.RECEIPT_NUMBER%TYPE DEFAULT NULL;
544: l_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE;
545: l_contract_id OKC_K_HEADERS_B.ID%TYPE;
546: l_contract_num OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
547: l_cust_acct_id NUMBER;
548: l_customer_num HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;

Line 549: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;

545: l_contract_id OKC_K_HEADERS_B.ID%TYPE;
546: l_contract_num OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
547: l_cust_acct_id NUMBER;
548: l_customer_num HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
549: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
550: l_receipt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE;
551: l_rcpt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT TRUNC(p_receipt_rec.PAYMENT_DATE);
552: l_org_id Number DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();
553: l_rcpt_rec rcpt_rec_type;

Line 550: l_receipt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE;

546: l_contract_num OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
547: l_cust_acct_id NUMBER;
548: l_customer_num HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
549: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
550: l_receipt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE;
551: l_rcpt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT TRUNC(p_receipt_rec.PAYMENT_DATE);
552: l_org_id Number DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();
553: l_rcpt_rec rcpt_rec_type;
554: l_appl_tbl appl_tbl_type;

Line 551: l_rcpt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT TRUNC(p_receipt_rec.PAYMENT_DATE);

547: l_cust_acct_id NUMBER;
548: l_customer_num HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
549: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
550: l_receipt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE;
551: l_rcpt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT TRUNC(p_receipt_rec.PAYMENT_DATE);
552: l_org_id Number DEFAULT MO_GLOBAL.GET_CURRENT_ORG_ID();
553: l_rcpt_rec rcpt_rec_type;
554: l_appl_tbl appl_tbl_type;
555: l_customer_trx_id NUMBER;

Line 577: FROM OKL_TRX_CSH_RECEIPT_V

573: ,cp_rcpt_date IN DATE
574: ,cp_irm_id IN NUMBER) IS
575:
576: SELECT ID INTO l_rct_id
577: FROM OKL_TRX_CSH_RECEIPT_V
578: WHERE AMOUNT = cp_amount
579: AND IBA_ID = cp_bank_acct_id
580: AND ILE_ID = cp_cust_id
581: AND DATE_EFFECTIVE = cp_rcpt_date