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.ARI_DB_UTILITIES dependencies on CE_BANK_BRANCHES_V

Line 1300: l_bank_party_id ce_bank_branches_v.bank_party_id%TYPE;

1296: l_bank_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1297: l_branch_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1298: l_ext_bank_rec IBY_EXT_BANKACCT_PUB.extbank_rec_type;
1299: l_ext_branch_rec IBY_EXT_BANKACCT_PUB.ExtBankBranch_rec_type;
1300: l_bank_party_id ce_bank_branches_v.bank_party_id%TYPE;
1301: l_branch_party_id ce_bank_branches_v.branch_party_id%TYPE;
1302: l_import_new_banks_only varchar2(1);
1303:
1304:

Line 1301: l_branch_party_id ce_bank_branches_v.branch_party_id%TYPE;

1297: l_branch_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1298: l_ext_bank_rec IBY_EXT_BANKACCT_PUB.extbank_rec_type;
1299: l_ext_branch_rec IBY_EXT_BANKACCT_PUB.ExtBankBranch_rec_type;
1300: l_bank_party_id ce_bank_branches_v.bank_party_id%TYPE;
1301: l_branch_party_id ce_bank_branches_v.branch_party_id%TYPE;
1302: l_import_new_banks_only varchar2(1);
1303:
1304:
1305: CURSOR ar_bank_branch_cur IS -- cursor to fetch the records from ar_Bank_directory table

Line 1313: CURSOR ce_bank_branch_cur(l_routing_number VARCHAR2) IS -- cursor to check whether the routing number exists in ce_bank_Branches_v or not

1309: nvl(bank_name,routing_number) AS branch_name,
1310: nvl(country,'US') AS country
1311: FROM ar_bank_directory;
1312:
1313: CURSOR ce_bank_branch_cur(l_routing_number VARCHAR2) IS -- cursor to check whether the routing number exists in ce_bank_Branches_v or not
1314: SELECT bank_party_id,branch_party_id
1315: FROM ce_bank_branches_V
1316: WHERE branch_number = l_routing_number;
1317:

Line 1315: FROM ce_bank_branches_V

1311: FROM ar_bank_directory;
1312:
1313: CURSOR ce_bank_branch_cur(l_routing_number VARCHAR2) IS -- cursor to check whether the routing number exists in ce_bank_Branches_v or not
1314: SELECT bank_party_id,branch_party_id
1315: FROM ce_bank_branches_V
1316: WHERE branch_number = l_routing_number;
1317:
1318: CURSOR ce_chk_bank_exists(l_bank_name VARCHAR2) IS -- cursor to check whether the bank exists in ce_bank_Branches_v or not
1319: SELECT bank_party_id,branch_party_id, branch_number

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

1314: SELECT bank_party_id,branch_party_id
1315: FROM ce_bank_branches_V
1316: WHERE branch_number = l_routing_number;
1317:
1318: CURSOR ce_chk_bank_exists(l_bank_name VARCHAR2) IS -- cursor to check whether the bank exists in ce_bank_Branches_v or not
1319: SELECT bank_party_id,branch_party_id, branch_number
1320: FROM ce_bank_branches_V
1321: WHERE upper(bank_name) = upper(l_bank_name);
1322:

Line 1320: FROM ce_bank_branches_V

1316: WHERE branch_number = l_routing_number;
1317:
1318: CURSOR ce_chk_bank_exists(l_bank_name VARCHAR2) IS -- cursor to check whether the bank exists in ce_bank_Branches_v or not
1319: SELECT bank_party_id,branch_party_id, branch_number
1320: FROM ce_bank_branches_V
1321: WHERE upper(bank_name) = upper(l_bank_name);
1322:
1323: CURSOR ce_chk_branch_exists(l_bank_name VARCHAR2) IS -- cursor to check whether the branch exists in ce_bank_Branches_v or not
1324: SELECT bank_party_id,branch_party_id, branch_number

Line 1323: CURSOR ce_chk_branch_exists(l_bank_name VARCHAR2) IS -- cursor to check whether the branch exists in ce_bank_Branches_v or not

1319: SELECT bank_party_id,branch_party_id, branch_number
1320: FROM ce_bank_branches_V
1321: WHERE upper(bank_name) = upper(l_bank_name);
1322:
1323: CURSOR ce_chk_branch_exists(l_bank_name VARCHAR2) IS -- cursor to check whether the branch exists in ce_bank_Branches_v or not
1324: SELECT bank_party_id,branch_party_id, branch_number
1325: FROM ce_bank_branches_V
1326: WHERE upper(bank_branch_name) = upper(l_bank_name);
1327:

Line 1325: FROM ce_bank_branches_V

1321: WHERE upper(bank_name) = upper(l_bank_name);
1322:
1323: CURSOR ce_chk_branch_exists(l_bank_name VARCHAR2) IS -- cursor to check whether the branch exists in ce_bank_Branches_v or not
1324: SELECT bank_party_id,branch_party_id, branch_number
1325: FROM ce_bank_branches_V
1326: WHERE upper(bank_branch_name) = upper(l_bank_name);
1327:
1328: CURSOR hz_obj_ver_num_cur(l_party_id VARCHAR2) IS -- cursor to get the object version number
1329: SELECT object_version_number from hz_parties where party_id = l_party_id;

Line 1457: fnd_file.put_line( FND_FILE.LOG, 'Skipping - This Routing Number :: '||ar_bank_branch_rec.routing_number||' , with Branch Name :: '||ar_bank_branch_rec.bank_name || ' already exists in ce_bank_branches_v');

1453: END IF;
1454:
1455: ELSE -- If branch associated with this routing number exists -- NO ACTIVITY REQUIRED
1456:
1457: fnd_file.put_line( FND_FILE.LOG, 'Skipping - This Routing Number :: '||ar_bank_branch_rec.routing_number||' , with Branch Name :: '||ar_bank_branch_rec.bank_name || ' already exists in ce_bank_branches_v');
1458: CLOSE ce_chk_branch_exists;
1459:
1460: END IF; --ce_chk_branch_exists%NOTFOUND
1461:

Line 1606: fnd_file.put_line( FND_FILE.LOG, 'Skipping - This Routing Number :: '||ar_bank_branch_rec.routing_number||' , associated with Bank Name :: '||ar_bank_branch_rec.bank_name || ' already exists in ce_bank_branches_v');

1602: END IF; -- ce_chk_bank_exists%NOTFOUND
1603:
1604: ELSE -- If routing number exixts in CE -- NO ACTIVITY REQUIRED
1605:
1606: fnd_file.put_line( FND_FILE.LOG, 'Skipping - This Routing Number :: '||ar_bank_branch_rec.routing_number||' , associated with Bank Name :: '||ar_bank_branch_rec.bank_name || ' already exists in ce_bank_branches_v');
1607: CLOSE ce_bank_branch_cur;
1608:
1609: END IF; --ce_bank_branch_cur%NOTFOUND
1610: