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_INT_EXT_CSH_APP_PVT dependencies on OKL_TRX_CSH_BATCH_V

Line 161: FROM okl_trx_csh_batch_v btc,

157: rct.attribute12,
158: rct.attribute13,
159: rct.attribute14,
160: rct.attribute15
161: FROM okl_trx_csh_batch_v btc,
162: okl_trx_csh_receipt_v rct,
163: okl_txl_rcpt_apps_v rca
164: WHERE btc.ID = rct.btc_id
165: AND rct.ID = rca.rct_id_details

Line 214: l_btc_id okl_trx_csh_batch_v.ID%TYPE DEFAULT NULL;

210: l_attribute14 okl_trx_csh_receipt_v.attribute14%TYPE
211: DEFAULT NULL;
212: l_attribute15 okl_trx_csh_receipt_v.attribute15%TYPE
213: DEFAULT NULL;
214: l_btc_id okl_trx_csh_batch_v.ID%TYPE DEFAULT NULL;
215: l_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;
216: l_check_number okl_trx_csh_receipt_v.check_number%TYPE
217: DEFAULT NULL;
218: l_cnr_id okl_txl_rcpt_apps_v.cnr_id%TYPE DEFAULT NULL;

Line 259: l_trx_status_code okl_trx_csh_batch_v.trx_status_code%TYPE := 'PROCESSED';

255: l_receipt_currency okl_trx_csh_receipt_v.currency_code%TYPE
256: DEFAULT NULL;
257: l_remit_bank_id NUMBER;
258: l_return_status VARCHAR2 (1);
259: l_trx_status_code okl_trx_csh_batch_v.trx_status_code%TYPE := 'PROCESSED';
260: l_validation_text VARCHAR2 (2000);
261:
262: BEGIN
263: -- Standard Start of API savepoint

Line 679: l_trx_status_code okl_trx_csh_batch_v.trx_status_code%TYPE;

675: l_init_msg_list VARCHAR2 (1);
676: l_return_status VARCHAR2 (1);
677: l_msg_count NUMBER;
678: l_msg_data VARCHAR2 (2000);
679: l_trx_status_code okl_trx_csh_batch_v.trx_status_code%TYPE;
680: l_rcpt_status_code okl_trx_csh_receipt_v.rcpt_status_code%TYPE;
681: l_btc_id okl_trx_csh_batch_v.ID%TYPE DEFAULT NULL;
682: l_btc_name okl_trx_csh_batch_v.NAME%TYPE DEFAULT NULL;
683: l_rct_id okl_trx_csh_receipt_v.ID%TYPE DEFAULT NULL;

Line 681: l_btc_id okl_trx_csh_batch_v.ID%TYPE DEFAULT NULL;

677: l_msg_count NUMBER;
678: l_msg_data VARCHAR2 (2000);
679: l_trx_status_code okl_trx_csh_batch_v.trx_status_code%TYPE;
680: l_rcpt_status_code okl_trx_csh_receipt_v.rcpt_status_code%TYPE;
681: l_btc_id okl_trx_csh_batch_v.ID%TYPE DEFAULT NULL;
682: l_btc_name okl_trx_csh_batch_v.NAME%TYPE DEFAULT NULL;
683: l_rct_id okl_trx_csh_receipt_v.ID%TYPE DEFAULT NULL;
684: l_rca_id okl_txl_rcpt_apps_v.ID%TYPE DEFAULT NULL;
685: l_ile_id okl_trx_csh_receipt_v.ile_id%TYPE

Line 682: l_btc_name okl_trx_csh_batch_v.NAME%TYPE DEFAULT NULL;

678: l_msg_data VARCHAR2 (2000);
679: l_trx_status_code okl_trx_csh_batch_v.trx_status_code%TYPE;
680: l_rcpt_status_code okl_trx_csh_receipt_v.rcpt_status_code%TYPE;
681: l_btc_id okl_trx_csh_batch_v.ID%TYPE DEFAULT NULL;
682: l_btc_name okl_trx_csh_batch_v.NAME%TYPE DEFAULT NULL;
683: l_rct_id okl_trx_csh_receipt_v.ID%TYPE DEFAULT NULL;
684: l_rca_id okl_txl_rcpt_apps_v.ID%TYPE DEFAULT NULL;
685: l_ile_id okl_trx_csh_receipt_v.ile_id%TYPE
686: DEFAULT NULL;

Line 714: l_curr_con_type okl_trx_csh_batch_v.currency_conversion_type%TYPE

710: l_org_id okl_txl_rcpt_apps_v.org_id%TYPE DEFAULT NULL;
711: l_cust_num ar_cash_receipts_all.pay_from_customer%TYPE
712: DEFAULT NULL;
713: l_remit_bank_id NUMBER;
714: l_curr_con_type okl_trx_csh_batch_v.currency_conversion_type%TYPE
715: DEFAULT NULL;
716: l_curr_con_rate okl_trx_csh_batch_v.currency_conversion_rate%TYPE
717: DEFAULT NULL;
718: l_curr_con_date okl_trx_csh_batch_v.currency_conversion_date%TYPE

Line 716: l_curr_con_rate okl_trx_csh_batch_v.currency_conversion_rate%TYPE

712: DEFAULT NULL;
713: l_remit_bank_id NUMBER;
714: l_curr_con_type okl_trx_csh_batch_v.currency_conversion_type%TYPE
715: DEFAULT NULL;
716: l_curr_con_rate okl_trx_csh_batch_v.currency_conversion_rate%TYPE
717: DEFAULT NULL;
718: l_curr_con_date okl_trx_csh_batch_v.currency_conversion_date%TYPE
719: DEFAULT NULL;
720: l_customer_num ar_cash_receipts_all.pay_from_customer%TYPE

Line 718: l_curr_con_date okl_trx_csh_batch_v.currency_conversion_date%TYPE

714: l_curr_con_type okl_trx_csh_batch_v.currency_conversion_type%TYPE
715: DEFAULT NULL;
716: l_curr_con_rate okl_trx_csh_batch_v.currency_conversion_rate%TYPE
717: DEFAULT NULL;
718: l_curr_con_date okl_trx_csh_batch_v.currency_conversion_date%TYPE
719: DEFAULT NULL;
720: l_customer_num ar_cash_receipts_all.pay_from_customer%TYPE
721: DEFAULT NULL;
722: l_cons_bill_num okl_cnsld_ar_hdrs_v.consolidated_invoice_number%TYPE

Line 850: FROM okl_trx_csh_batch_v btc

846: SELECT btc.ID,
847: btc.currency_conversion_type,
848: btc.currency_conversion_rate,
849: btc.currency_conversion_date
850: FROM okl_trx_csh_batch_v btc
851: WHERE btc.trx_status_code IN ('SUBMITTED', 'RESUBMITTED');
852:
853: --akrangan added resubmitted sts chk
854:

Line 860: FROM okl_trx_csh_batch_v btc

856:
857: -- get redundant batches, i.e. batches with no receipt headers
858: CURSOR c_get_redund_batch IS
859: SELECT btc.ID, btc.NAME
860: FROM okl_trx_csh_batch_v btc
861: WHERE creation_date < (SYSDATE - 7)
862: AND btc.trx_status_code IN
863: ('WORKING', 'RESUBMITTED') --akrangan added
864: AND btc.ID NOT IN (SELECT btc_id

Line 912: okl_trx_csh_batch_v btc

908: vb.result_code,
909: vl.validation_text
910: FROM okl_validation_results_b vb,
911: okl_validation_results_tl vl,
912: okl_trx_csh_batch_v btc
913: WHERE vb.ID = vl.ID
914: AND vl.LANGUAGE = USERENV ('LANG')
915: AND vb.parent_object_code = 'RECEIPT_BATCH'
916: AND vb.parent_object_id = btc.ID