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_IREC_PAYMENTS dependencies on CE_BANK_BRANCHES_V

Line 2952: FROM ce_bank_branches_V

2948:
2949: -- added for bug 8664350
2950: CURSOR bank_branch_cur(l_routing_number VARCHAR2) IS
2951: SELECT decode(country,null, bank_home_country,country) country_code,bank_party_id,branch_party_id
2952: FROM ce_bank_branches_V
2953: WHERE branch_number = l_routing_number;
2954:
2955: CURSOR bank_branch_name_cur (l_routing_number VARCHAR2) IS
2956: SELECT decode(bank_name,null,routing_number,bank_name) bank_name,

Line 2961: CURSOR ce_chk_bank_exists_cur(l_bank_name VARCHAR2) IS -- cursor to check whether the bank exists in ce_bank_Branches_v or not

2957: decode(bank_name,null,routing_number,bank_name) branch_name
2958: FROM ar_bank_directory
2959: WHERE routing_number = l_routing_number;
2960:
2961: CURSOR ce_chk_bank_exists_cur(l_bank_name VARCHAR2) IS -- cursor to check whether the bank exists in ce_bank_Branches_v or not
2962: SELECT bank_party_id,branch_party_id, branch_number
2963: FROM ce_bank_branches_V
2964: WHERE upper(bank_name) = upper(l_bank_name);
2965:

Line 2963: FROM ce_bank_branches_V

2959: WHERE routing_number = l_routing_number;
2960:
2961: CURSOR ce_chk_bank_exists_cur(l_bank_name VARCHAR2) IS -- cursor to check whether the bank exists in ce_bank_Branches_v or not
2962: SELECT bank_party_id,branch_party_id, branch_number
2963: FROM ce_bank_branches_V
2964: WHERE upper(bank_name) = upper(l_bank_name);
2965:
2966: CURSOR chk_instr_assigned_cur(l_bank_account_id NUMBER, p_customer_id NUMBER, p_customer_site_id NUMBER) IS
2967: select INSTRUMENT_PAYMENT_USE_ID,ORDER_OF_PREFERENCE,START_DATE from IBY_PMT_INSTR_USES_ALL

Line 2984: l_bank_party_id ce_bank_branches_v.bank_party_id%TYPE;

2980: l_bank_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
2981: l_branch_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
2982: l_ext_bank_rec IBY_EXT_BANKACCT_PUB.extbank_rec_type;
2983: l_ext_branch_rec IBY_EXT_BANKACCT_PUB.ExtBankBranch_rec_type;
2984: l_bank_party_id ce_bank_branches_v.bank_party_id%TYPE;
2985: l_branch_party_id ce_bank_branches_v.branch_party_id%TYPE;
2986: l_address_country ce_bank_branches_v.country% TYPE default 'US';
2987: l_bank_name ar_bank_directory.bank_name%type;
2988: l_branch_name ar_bank_directory.bank_name%type;

Line 2985: l_branch_party_id ce_bank_branches_v.branch_party_id%TYPE;

2981: l_branch_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
2982: l_ext_bank_rec IBY_EXT_BANKACCT_PUB.extbank_rec_type;
2983: l_ext_branch_rec IBY_EXT_BANKACCT_PUB.ExtBankBranch_rec_type;
2984: l_bank_party_id ce_bank_branches_v.bank_party_id%TYPE;
2985: l_branch_party_id ce_bank_branches_v.branch_party_id%TYPE;
2986: l_address_country ce_bank_branches_v.country% TYPE default 'US';
2987: l_bank_name ar_bank_directory.bank_name%type;
2988: l_branch_name ar_bank_directory.bank_name%type;
2989: l_st_date IBY_PMT_INSTR_USES_ALL.start_date%TYPE;

Line 2986: l_address_country ce_bank_branches_v.country% TYPE default 'US';

2982: l_ext_bank_rec IBY_EXT_BANKACCT_PUB.extbank_rec_type;
2983: l_ext_branch_rec IBY_EXT_BANKACCT_PUB.ExtBankBranch_rec_type;
2984: l_bank_party_id ce_bank_branches_v.bank_party_id%TYPE;
2985: l_branch_party_id ce_bank_branches_v.branch_party_id%TYPE;
2986: l_address_country ce_bank_branches_v.country% TYPE default 'US';
2987: l_bank_name ar_bank_directory.bank_name%type;
2988: l_branch_name ar_bank_directory.bank_name%type;
2989: l_st_date IBY_PMT_INSTR_USES_ALL.start_date%TYPE;
2990: l_priority IBY_PMT_INSTR_USES_ALL.order_of_preference%TYPE;

Line 2991: l_bank_id ce_bank_branches_v.bank_party_id%TYPE;

2987: l_bank_name ar_bank_directory.bank_name%type;
2988: l_branch_name ar_bank_directory.bank_name%type;
2989: l_st_date IBY_PMT_INSTR_USES_ALL.start_date%TYPE;
2990: l_priority IBY_PMT_INSTR_USES_ALL.order_of_preference%TYPE;
2991: l_bank_id ce_bank_branches_v.bank_party_id%TYPE;
2992: l_branch_id ce_bank_branches_v.branch_party_id%TYPE;
2993:
2994: bank_branch_rec bank_branch_cur%ROWTYPE;
2995: bank_branch_name_rec bank_branch_name_cur%ROWTYPE;

Line 2992: l_branch_id ce_bank_branches_v.branch_party_id%TYPE;

2988: l_branch_name ar_bank_directory.bank_name%type;
2989: l_st_date IBY_PMT_INSTR_USES_ALL.start_date%TYPE;
2990: l_priority IBY_PMT_INSTR_USES_ALL.order_of_preference%TYPE;
2991: l_bank_id ce_bank_branches_v.bank_party_id%TYPE;
2992: l_branch_id ce_bank_branches_v.branch_party_id%TYPE;
2993:
2994: bank_branch_rec bank_branch_cur%ROWTYPE;
2995: bank_branch_name_rec bank_branch_name_cur%ROWTYPE;
2996: ce_chk_bank_exists_rec ce_chk_bank_exists_cur%ROWTYPE;

Line 3067: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, 'This Bank ' || l_bank_name || ' for the routing number '|| p_routing_number ||'already exists in CE_BANK_BRANCHES_V');

3063: CLOSE ce_chk_bank_exists_cur;
3064: l_bank_party_id := ce_chk_bank_exists_rec.bank_party_id;
3065:
3066: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3067: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, 'This Bank ' || l_bank_name || ' for the routing number '|| p_routing_number ||'already exists in CE_BANK_BRANCHES_V');
3068: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Bank Id :: ' ||l_bank_party_id);
3069: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Branch Id :: ' ||l_branch_party_id);
3070: end if;
3071: