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.AR_BR_REMIT_IMPORT_API_PUB dependencies on CE_BANK_ACCOUNTS

Line 154: p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,

150: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
151: p_payment_method IN ar_receipt_methods.name%TYPE,
152: p_remittance_date IN ar_batches.batch_date%TYPE,
153: p_Currency_code IN ar_batches.currency_code%TYPE,
154: p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,
155: l_batch_applied_status OUT NOCOPY ar_batches.batch_applied_status%TYPE,
156: l_batch_id OUT NOCOPY ar_batches.batch_id%TYPE
157: ) IS
158:

Line 171: l_bank_account_num ce_bank_accounts.bank_account_num%TYPE;

167: l_reserved_value ar_payment_schedules.reserved_value%TYPE;
168: l_count NUMBER;
169: l_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;
170: l_payment_method ar_receipt_methods.name%TYPE;
171: l_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
172:
173: BEGIN
174:
175: arp_standard.debug ('impremapi.Compare_old_versus_new_values ()+');

Line 206: FROM ce_bank_accounts cba,

202: and type = 'BR_REMITTANCE';
203:
204:
205: SELECT cba.bank_account_num INTO l_bank_account_num
206: FROM ce_bank_accounts cba,
207: ce_bank_acct_uses cbau
208: WHERE cbau.bank_acct_use_id =l_remit_bank_acct_use_id
209: AND cbau.bank_account_id = cba.bank_account_id;
210:

Line 320: p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,

316: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,
317: p_payment_method IN ar_receipt_methods.name%TYPE,
318: p_remittance_date IN ar_batches.batch_date%TYPE,
319: p_currency_code IN ar_batches.currency_code%TYPE,
320: p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,
321: x_return_status IN OUT NOCOPY VARCHAR2
322: ) IS
323:
324: l_media_reference AR_BATCHES.media_reference%TYPE;

Line 403: p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,

399: p_currency_code IN ar_batches.currency_code%TYPE,
400: p_remittance_method IN ar_batches.remit_method_code%TYPE,
401: p_remittance_bnk_branch_number IN ce_bank_branches_v.branch_number%TYPE,
402: p_remittance_bank_number IN ce_bank_branches_v.bank_number%TYPE,
403: p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,
404: p_payment_method IN ar_receipt_methods.name%TYPE,
405: x_batch_name OUT NOCOPY ar_batches.name%TYPE,
406: x_return_status IN OUT NOCOPY VARCHAR2
407: ) IS

Line 434: FROM ce_bank_accounts cba, ce_bank_acct_uses cbau

430: CURSOR account (p_branch_id NUMBER,
431: p_bank_account_number NUMBER,
432: p_currency_code VARCHAR2) IS
433: SELECT cbau.bank_acct_use_id
434: FROM ce_bank_accounts cba, ce_bank_acct_uses cbau
435: WHERE cba.bank_account_id = cbau.bank_account_id
436: AND cba.bank_branch_id = p_branch_id
437: AND cba.bank_account_num = p_bank_account_number
438: AND cba.currency_code = p_currency_code

Line 665: p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,

661: x_msg_count OUT NOCOPY NUMBER,
662: x_msg_data OUT NOCOPY VARCHAR2,
663: p_remittance_bank_number IN ce_bank_branches_v.bank_number%TYPE,
664: p_remittance_bnk_branch_number IN ce_bank_branches_v.branch_number%TYPE,
665: p_remittance_bnk_acct_number IN ce_bank_accounts.bank_account_num%TYPE,
666: p_media_reference IN ar_batches.media_reference%TYPE,
667: p_remittance_method IN ar_batches.remit_method_code%TYPE,
668: -- 'STANDARD' , 'FACTORING' etc.
669: p_with_recourse_flag IN ar_batches.with_recourse_flag%TYPE,