APPS.ARI_DB_UTILITIES dependencies on AR_BANK_DIRECTORY

Line 1267: | This procedure submits cuncurrent request to upload AR_BANK_DIRECTORY

1263: /*========================================================================
1264: | PUBLIC procedure upload_ar_bank_branch_concur
1265: |
1266: | DESCRIPTION
1267: | This procedure submits cuncurrent request to upload AR_BANK_DIRECTORY
1268: | table data to HZ_PARTIES.
1269: | --------------------------------------------------------------------
1270: |
1271: | PSEUDO CODE/LOGIC

Line 1305: CURSOR ar_bank_branch_cur IS -- cursor to fetch the records from ar_Bank_directory table

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
1306: SELECT routing_number,
1307: new_routing_number,
1308: nvl(bank_name,routing_number) bank_name,
1309: nvl(bank_name,routing_number) AS branch_name,

Line 1311: FROM ar_bank_directory;

1307: new_routing_number,
1308: nvl(bank_name,routing_number) bank_name,
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

Line 1612: fnd_file.put_line( FND_FILE.LOG, 'Skipping - New Routing Number Exits for this Routing Number :: '||ar_bank_branch_rec.routing_number||' , Bank Name :: '||ar_bank_branch_rec.bank_name || ' in AR_BANK_DIRECTORY');

1608:
1609: END IF; --ce_bank_branch_cur%NOTFOUND
1610:
1611: ELSE -- ar_bank_branch_rec.new_routing_number is not null
1612: fnd_file.put_line( FND_FILE.LOG, 'Skipping - New Routing Number Exits for this Routing Number :: '||ar_bank_branch_rec.routing_number||' , Bank Name :: '||ar_bank_branch_rec.bank_name || ' in AR_BANK_DIRECTORY');
1613: END IF; -- ar_bank_branch_rec.new_routing_number is null
1614:
1615: END IF; -- l_import_new_banks_only = 'Y'
1616: