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 68: remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE,

64: gl_date ar_cash_receipts.receipt_date%TYPE,
65: customer_id hz_cust_accounts.cust_account_id%TYPE,
66: customer_site_use_id hz_cust_site_uses.site_use_id%TYPE,
67: remittance_bank_account_id fun_net_agreements.bank_account_id%TYPE,
68: remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE,
69: remittance_bank_account_name ce_bank_accounts.bank_account_name%TYPE ,
70: receipt_method_id ar_receipt_methods.receipt_method_id%TYPE,
71: org_id fun_net_batches.org_id%TYPE
72: );

Line 69: remittance_bank_account_name ce_bank_accounts.bank_account_name%TYPE ,

65: customer_id hz_cust_accounts.cust_account_id%TYPE,
66: customer_site_use_id hz_cust_site_uses.site_use_id%TYPE,
67: remittance_bank_account_id fun_net_agreements.bank_account_id%TYPE,
68: remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE,
69: remittance_bank_account_name ce_bank_accounts.bank_account_name%TYPE ,
70: receipt_method_id ar_receipt_methods.receipt_method_id%TYPE,
71: org_id fun_net_batches.org_id%TYPE
72: );
73:

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

1910: if( l_count > 0 ) then
1911: begin
1912: select cba.receipt_multi_currency_flag
1913: into l_flag
1914: from ce_bank_accounts cba, ce_bank_acct_uses_ALL ba,ar_receipt_classes rc,
1915: ar_receipt_methods rm,ar_receipt_method_accounts_ALL rma
1916: where rc.creation_method_code = 'NETTING'
1917: and rc.receipt_class_id = rm.receipt_class_id
1918: and ba.bank_account_id = cba.bank_account_id

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

2316:
2317: PROCEDURE Get_Netting_Bank_Details(
2318: p_bank_acct_use_id OUT NOCOPY NUMBER,
2319: p_bank_acct_name OUT NOCOPY VARCHAR2,
2320: p_bank_acct_num OUT NOCOPY ce_bank_accounts.bank_account_num%TYPE,
2321: p_le_id OUT NOCOPY NUMBER,
2322: p_bank_num OUT NOCOPY VARCHAR2,
2323: p_return_status OUT NOCOPY VARCHAR2)
2324: IS

Line 2338: ce_bank_accounts ac,

2334: p_bank_acct_num,
2335: p_le_id,
2336: p_bank_num
2337: FROM ce_bank_acct_uses ac_use,
2338: ce_bank_accounts ac,
2339: ce_banks_v ba
2340: WHERE ac.bank_account_id = g_bank_account_id
2341: AND ac.bank_account_id = ac_use.bank_account_id
2342: AND ac_use.org_id = g_batch_details.org_id

Line 2570: p_bank_acct_name IN ce_bank_accounts.bank_account_name%TYPE,

2566: invoice payments for each AP Check */
2567:
2568: PROCEDURE settle_ap_invs(
2569: p_bank_acct_use_id IN ce_bank_acct_uses_all.bank_acct_use_id%TYPE,
2570: p_bank_acct_name IN ce_bank_accounts.bank_account_name%TYPE,
2571: p_bank_acct_num IN ce_bank_accounts.bank_account_num%TYPE,
2572: p_le_id IN xle_entity_profiles.legal_entity_id%TYPE,
2573: p_bank_num IN ce_banks_v.bank_number%TYPE,
2574: x_return_status OUT NOCOPY VARCHAR2)

Line 2571: p_bank_acct_num IN ce_bank_accounts.bank_account_num%TYPE,

2567:
2568: PROCEDURE settle_ap_invs(
2569: p_bank_acct_use_id IN ce_bank_acct_uses_all.bank_acct_use_id%TYPE,
2570: p_bank_acct_name IN ce_bank_accounts.bank_account_name%TYPE,
2571: p_bank_acct_num IN ce_bank_accounts.bank_account_num%TYPE,
2572: p_le_id IN xle_entity_profiles.legal_entity_id%TYPE,
2573: p_bank_num IN ce_banks_v.bank_number%TYPE,
2574: x_return_status OUT NOCOPY VARCHAR2)
2575: IS

Line 3696: p_bank_acct_name IN ce_bank_accounts.bank_account_name%TYPE,

3692: *******************************************************************************/
3693:
3694: PROCEDURE settle_ar_txns(
3695: txnTable IN txnTblType,
3696: p_bank_acct_name IN ce_bank_accounts.bank_account_name%TYPE,
3697: p_bank_acct_num IN ce_bank_accounts.bank_account_num%TYPE,
3698: p_bank_acct_use_id IN ce_bank_acct_uses_all.bank_acct_use_id%TYPE,
3699: x_return_status OUT NOCOPY VARCHAR2,
3700: x_msg_data OUT NOCOPY VARCHAR2,

Line 3697: p_bank_acct_num IN ce_bank_accounts.bank_account_num%TYPE,

3693:
3694: PROCEDURE settle_ar_txns(
3695: txnTable IN txnTblType,
3696: p_bank_acct_name IN ce_bank_accounts.bank_account_name%TYPE,
3697: p_bank_acct_num IN ce_bank_accounts.bank_account_num%TYPE,
3698: p_bank_acct_use_id IN ce_bank_acct_uses_all.bank_acct_use_id%TYPE,
3699: x_return_status OUT NOCOPY VARCHAR2,
3700: x_msg_data OUT NOCOPY VARCHAR2,
3701: x_msg_count OUT NOCOPY NUMBER)

Line 3960: l_bank_acct_name ce_bank_accounts.bank_account_name%TYPE;

3956: l_status_flag VARCHAR2(1);
3957: l_return_status VARCHAR2(1);
3958: l_batch_status fun_net_batches_all.settlement_date%TYPE;
3959: l_bank_acct_use_id ce_bank_acct_uses_all.bank_acct_use_id%TYPE;
3960: l_bank_acct_name ce_bank_accounts.bank_account_name%TYPE;
3961: l_bank_acct_num ce_bank_accounts.bank_account_num%TYPE;
3962: l_le_id xle_entity_profiles.legal_entity_id%TYPE;
3963: l_bank_num ce_banks_v.bank_number%TYPE;
3964: batch_status_flag BOOLEAN;

Line 3961: l_bank_acct_num ce_bank_accounts.bank_account_num%TYPE;

3957: l_return_status VARCHAR2(1);
3958: l_batch_status fun_net_batches_all.settlement_date%TYPE;
3959: l_bank_acct_use_id ce_bank_acct_uses_all.bank_acct_use_id%TYPE;
3960: l_bank_acct_name ce_bank_accounts.bank_account_name%TYPE;
3961: l_bank_acct_num ce_bank_accounts.bank_account_num%TYPE;
3962: l_le_id xle_entity_profiles.legal_entity_id%TYPE;
3963: l_bank_num ce_banks_v.bank_number%TYPE;
3964: batch_status_flag BOOLEAN;
3965: l_msg_data VARCHAR2(1000);