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

Line 56: remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE,

52: gl_date ar_cash_receipts.receipt_date%TYPE,
53: customer_id hz_cust_accounts.cust_account_id%TYPE,
54: customer_site_use_id hz_cust_site_uses.site_use_id%TYPE,
55: remittance_bank_account_id fun_net_agreements.bank_account_id%TYPE,
56: remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE,
57: remittance_bank_account_name ce_bank_accounts.bank_account_name%TYPE ,
58: receipt_method_id ar_receipt_methods.receipt_method_id%TYPE,
59: org_id fun_net_batches.org_id%TYPE
60: );

Line 57: remittance_bank_account_name ce_bank_accounts.bank_account_name%TYPE ,

53: customer_id hz_cust_accounts.cust_account_id%TYPE,
54: customer_site_use_id hz_cust_site_uses.site_use_id%TYPE,
55: remittance_bank_account_id fun_net_agreements.bank_account_id%TYPE,
56: remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE,
57: remittance_bank_account_name ce_bank_accounts.bank_account_name%TYPE ,
58: receipt_method_id ar_receipt_methods.receipt_method_id%TYPE,
59: org_id fun_net_batches.org_id%TYPE
60: );
61: g_batch_id fun_net_batches_all.batch_id%TYPE;

Line 2607: from ce_bank_accounts cba, ce_bank_acct_uses_ALL ba,ar_receipt_classes rc,

2603: if( l_count > 0 ) then
2604: begin
2605: select cba.receipt_multi_currency_flag
2606: into l_flag
2607: from ce_bank_accounts cba, ce_bank_acct_uses_ALL ba,ar_receipt_classes rc,
2608: ar_receipt_methods rm,ar_receipt_method_accounts_ALL rma
2609: where rc.creation_method_code = 'NETTING'
2610: and rc.receipt_class_id = rm.receipt_class_id
2611: and ba.bank_account_id = cba.bank_account_id

Line 3005: p_bank_acct_num OUT NOCOPY ce_bank_accounts.bank_account_num%TYPE,

3001: from the Bank Account Id. Netting Bank is stored in the agreement details */
3002: PROCEDURE Get_Netting_Bank_Details(
3003: p_bank_acct_use_id OUT NOCOPY NUMBER,
3004: p_bank_acct_name OUT NOCOPY VARCHAR2,
3005: p_bank_acct_num OUT NOCOPY ce_bank_accounts.bank_account_num%TYPE,
3006: p_le_id OUT NOCOPY NUMBER,
3007: p_bank_num OUT NOCOPY VARCHAR2,
3008: p_return_status OUT NOCOPY VARCHAR2)
3009: IS

Line 3023: ce_bank_accounts ac,

3019: p_bank_acct_num,
3020: p_le_id,
3021: p_bank_num
3022: FROM ce_bank_acct_uses ac_use,
3023: ce_bank_accounts ac,
3024: ce_banks_v ba
3025: WHERE ac.bank_account_id = g_bank_account_id
3026: AND ac.bank_account_id = ac_use.bank_account_id
3027: AND ac_use.org_id = g_batch_details.org_id

Line 3252: p_bank_acct_name IN ce_bank_accounts.bank_account_name%TYPE,

3248: /* Creates AP Check per vendor / vendor site / currency . Also creates
3249: invoice payments for each AP Check */
3250: PROCEDURE settle_ap_invs(
3251: p_bank_acct_use_id IN ce_bank_acct_uses_all.bank_acct_use_id%TYPE,
3252: p_bank_acct_name IN ce_bank_accounts.bank_account_name%TYPE,
3253: p_bank_acct_num IN ce_bank_accounts.bank_account_num%TYPE,
3254: p_le_id IN xle_entity_profiles.legal_entity_id%TYPE,
3255: p_bank_num IN ce_banks_v.bank_number%TYPE,
3256: x_return_status OUT NOCOPY VARCHAR2)

Line 3253: p_bank_acct_num IN ce_bank_accounts.bank_account_num%TYPE,

3249: invoice payments for each AP Check */
3250: PROCEDURE settle_ap_invs(
3251: p_bank_acct_use_id IN ce_bank_acct_uses_all.bank_acct_use_id%TYPE,
3252: p_bank_acct_name IN ce_bank_accounts.bank_account_name%TYPE,
3253: p_bank_acct_num IN ce_bank_accounts.bank_account_num%TYPE,
3254: p_le_id IN xle_entity_profiles.legal_entity_id%TYPE,
3255: p_bank_num IN ce_banks_v.bank_number%TYPE,
3256: x_return_status OUT NOCOPY VARCHAR2)
3257: IS

Line 4304: p_bank_acct_name IN ce_bank_accounts.bank_account_name%TYPE,

4300: | : apply_cash_receipt |
4301: *******************************************************************************/
4302: PROCEDURE settle_ar_txns(
4303: txnTable IN txnTblType,
4304: p_bank_acct_name IN ce_bank_accounts.bank_account_name%TYPE,
4305: p_bank_acct_num IN ce_bank_accounts.bank_account_num%TYPE,
4306: p_bank_acct_use_id IN ce_bank_acct_uses_all.bank_acct_use_id%TYPE,
4307: x_return_status OUT NOCOPY VARCHAR2,
4308: x_msg_data OUT NOCOPY VARCHAR2,

Line 4305: p_bank_acct_num IN ce_bank_accounts.bank_account_num%TYPE,

4301: *******************************************************************************/
4302: PROCEDURE settle_ar_txns(
4303: txnTable IN txnTblType,
4304: p_bank_acct_name IN ce_bank_accounts.bank_account_name%TYPE,
4305: p_bank_acct_num IN ce_bank_accounts.bank_account_num%TYPE,
4306: p_bank_acct_use_id IN ce_bank_acct_uses_all.bank_acct_use_id%TYPE,
4307: x_return_status OUT NOCOPY VARCHAR2,
4308: x_msg_data OUT NOCOPY VARCHAR2,
4309: x_msg_count OUT NOCOPY NUMBER)

Line 4616: l_bank_acct_name ce_bank_accounts.bank_account_name%TYPE;

4612: l_status_flag VARCHAR2(1);
4613: l_return_status VARCHAR2(1);
4614: l_batch_status fun_net_batches_all.settlement_date%TYPE;
4615: l_bank_acct_use_id ce_bank_acct_uses_all.bank_acct_use_id%TYPE;
4616: l_bank_acct_name ce_bank_accounts.bank_account_name%TYPE;
4617: l_bank_acct_num ce_bank_accounts.bank_account_num%TYPE;
4618: l_le_id xle_entity_profiles.legal_entity_id%TYPE;
4619: l_bank_num ce_banks_v.bank_number%TYPE;
4620: batch_status_flag BOOLEAN;

Line 4617: l_bank_acct_num ce_bank_accounts.bank_account_num%TYPE;

4613: l_return_status VARCHAR2(1);
4614: l_batch_status fun_net_batches_all.settlement_date%TYPE;
4615: l_bank_acct_use_id ce_bank_acct_uses_all.bank_acct_use_id%TYPE;
4616: l_bank_acct_name ce_bank_accounts.bank_account_name%TYPE;
4617: l_bank_acct_num ce_bank_accounts.bank_account_num%TYPE;
4618: l_le_id xle_entity_profiles.legal_entity_id%TYPE;
4619: l_bank_num ce_banks_v.bank_number%TYPE;
4620: batch_status_flag BOOLEAN;
4621: l_msg_data VARCHAR2(1000);