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.IBY_EXT_BANKACCT_PUB dependencies on IBY_EXT_BANK_ACCOUNTS

Line 1317: lx_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;

1313: l_owner_rowid VARCHAR2(100);
1314: l_count NUMBER;
1315: l_joint_acct_owner_id NUMBER;
1316:
1317: lx_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;
1318: lx_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
1319: l_masked_ba_num iby_ext_bank_accounts.masked_bank_account_num%TYPE;
1320: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
1321: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;

Line 1318: lx_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;

1314: l_count NUMBER;
1315: l_joint_acct_owner_id NUMBER;
1316:
1317: lx_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;
1318: lx_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
1319: l_masked_ba_num iby_ext_bank_accounts.masked_bank_account_num%TYPE;
1320: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
1321: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1322: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;

Line 1319: l_masked_ba_num iby_ext_bank_accounts.masked_bank_account_num%TYPE;

1315: l_joint_acct_owner_id NUMBER;
1316:
1317: lx_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;
1318: lx_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
1319: l_masked_ba_num iby_ext_bank_accounts.masked_bank_account_num%TYPE;
1320: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
1321: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1322: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1323: l_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;

Line 1320: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;

1316:
1317: lx_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;
1318: lx_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
1319: l_masked_ba_num iby_ext_bank_accounts.masked_bank_account_num%TYPE;
1320: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
1321: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1322: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1323: l_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;
1324: l_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;

Line 1321: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;

1317: lx_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;
1318: lx_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
1319: l_masked_ba_num iby_ext_bank_accounts.masked_bank_account_num%TYPE;
1320: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
1321: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1322: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1323: l_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;
1324: l_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;
1325: l_dup_acct_id number;

Line 1322: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;

1318: lx_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
1319: l_masked_ba_num iby_ext_bank_accounts.masked_bank_account_num%TYPE;
1320: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
1321: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1322: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1323: l_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;
1324: l_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;
1325: l_dup_acct_id number;
1326: l_dup_start_date date;

Line 1323: l_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;

1319: l_masked_ba_num iby_ext_bank_accounts.masked_bank_account_num%TYPE;
1320: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
1321: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1322: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1323: l_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;
1324: l_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;
1325: l_dup_acct_id number;
1326: l_dup_start_date date;
1327: l_dup_end_date date;

Line 1324: l_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;

1320: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
1321: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1322: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
1323: l_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;
1324: l_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;
1325: l_dup_acct_id number;
1326: l_dup_start_date date;
1327: l_dup_end_date date;
1328: l_bank_account_num_electronic iby_ext_bank_accounts.bank_account_num_electronic%TYPE;

Line 1328: l_bank_account_num_electronic iby_ext_bank_accounts.bank_account_num_electronic%TYPE;

1324: l_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;
1325: l_dup_acct_id number;
1326: l_dup_start_date date;
1327: l_dup_end_date date;
1328: l_bank_account_num_electronic iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
1329: l_party_id ap_suppliers.party_id%TYPE;
1330: l_supplier_name ap_suppliers.vendor_name%TYPE;
1331: l_supplier_number ap_suppliers.segment1%TYPE;
1332:

Line 1662: -- inserting the new account into IBY_EXT_BANK_ACCOUNTS

1658: l_iban_hash1 := iby_security_pkg.Get_Hash(p_ext_bank_acct_rec.iban,'F');
1659: l_iban_hash2 := iby_security_pkg.Get_Hash(p_ext_bank_acct_rec.iban,'T');
1660: END IF;
1661:
1662: -- inserting the new account into IBY_EXT_BANK_ACCOUNTS
1663: INSERT INTO IBY_EXT_BANK_ACCOUNTS
1664: (
1665: EXT_BANK_ACCOUNT_ID,
1666: COUNTRY_CODE,

Line 1663: INSERT INTO IBY_EXT_BANK_ACCOUNTS

1659: l_iban_hash2 := iby_security_pkg.Get_Hash(p_ext_bank_acct_rec.iban,'T');
1660: END IF;
1661:
1662: -- inserting the new account into IBY_EXT_BANK_ACCOUNTS
1663: INSERT INTO IBY_EXT_BANK_ACCOUNTS
1664: (
1665: EXT_BANK_ACCOUNT_ID,
1666: COUNTRY_CODE,
1667: BRANCH_ID,

Line 1736: IBY_EXT_BANK_ACCOUNTS_S.nextval, --EXT_BANK_ACCOUNT_ID,

1732: CONTACT_FAX
1733: )
1734: VALUES
1735: (
1736: IBY_EXT_BANK_ACCOUNTS_S.nextval, --EXT_BANK_ACCOUNT_ID,
1737: p_ext_bank_acct_rec.country_code, --COUNTRY_CODE,
1738: p_ext_bank_acct_rec.branch_id, --BRANCH_ID,
1739: p_ext_bank_acct_rec.bank_id, --BANK_ID,
1740: nvl(l_account_number, p_ext_bank_acct_rec.bank_account_num), --BANK_ACCOUNT_NUM,

Line 1808: print_debuginfo('New Row inserted in IBY_EXT_BANK_ACCOUNTS');

1804: ) RETURNING EXT_BANK_ACCOUNT_ID INTO x_acct_id;
1805:
1806: IF (SQL%FOUND) THEN
1807: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1808: print_debuginfo('New Row inserted in IBY_EXT_BANK_ACCOUNTS');
1809: END IF;
1810: ELSE
1811: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1812: print_debuginfo('Failed to insert in IBY_EXT_BANK_ACCOUNTS');

Line 1812: print_debuginfo('Failed to insert in IBY_EXT_BANK_ACCOUNTS');

1808: print_debuginfo('New Row inserted in IBY_EXT_BANK_ACCOUNTS');
1809: END IF;
1810: ELSE
1811: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1812: print_debuginfo('Failed to insert in IBY_EXT_BANK_ACCOUNTS');
1813: END IF;
1814: RAISE fnd_api.g_exc_unexpected_error;
1815: END IF;
1816:

Line 2255: l_acct_number iby_ext_bank_accounts.bank_account_num%TYPE;

2251: l_bank_id NUMBER(15);
2252: l_branch_id NUMBER(15);
2253: l_bank_name VARCHAR2(360);
2254: l_branch_number VARCHAR2(30);
2255: l_acct_number iby_ext_bank_accounts.bank_account_num%TYPE;
2256: l_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;
2257: l_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
2258: l_masked_ba_num iby_ext_bank_accounts.masked_bank_account_num%TYPE;
2259: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;

Line 2256: l_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;

2252: l_branch_id NUMBER(15);
2253: l_bank_name VARCHAR2(360);
2254: l_branch_number VARCHAR2(30);
2255: l_acct_number iby_ext_bank_accounts.bank_account_num%TYPE;
2256: l_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;
2257: l_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
2258: l_masked_ba_num iby_ext_bank_accounts.masked_bank_account_num%TYPE;
2259: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
2260: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;

Line 2257: l_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;

2253: l_bank_name VARCHAR2(360);
2254: l_branch_number VARCHAR2(30);
2255: l_acct_number iby_ext_bank_accounts.bank_account_num%TYPE;
2256: l_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;
2257: l_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
2258: l_masked_ba_num iby_ext_bank_accounts.masked_bank_account_num%TYPE;
2259: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
2260: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
2261: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;

Line 2258: l_masked_ba_num iby_ext_bank_accounts.masked_bank_account_num%TYPE;

2254: l_branch_number VARCHAR2(30);
2255: l_acct_number iby_ext_bank_accounts.bank_account_num%TYPE;
2256: l_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;
2257: l_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
2258: l_masked_ba_num iby_ext_bank_accounts.masked_bank_account_num%TYPE;
2259: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
2260: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
2261: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
2262: l_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;

Line 2259: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;

2255: l_acct_number iby_ext_bank_accounts.bank_account_num%TYPE;
2256: l_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;
2257: l_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
2258: l_masked_ba_num iby_ext_bank_accounts.masked_bank_account_num%TYPE;
2259: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
2260: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
2261: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
2262: l_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;
2263: l_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;

Line 2260: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;

2256: l_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;
2257: l_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
2258: l_masked_ba_num iby_ext_bank_accounts.masked_bank_account_num%TYPE;
2259: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
2260: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
2261: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
2262: l_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;
2263: l_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;
2264: l_iban iby_ext_bank_accounts.iban%TYPE;

Line 2261: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;

2257: l_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
2258: l_masked_ba_num iby_ext_bank_accounts.masked_bank_account_num%TYPE;
2259: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
2260: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
2261: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
2262: l_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;
2263: l_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;
2264: l_iban iby_ext_bank_accounts.iban%TYPE;
2265: l_encrypted iby_ext_bank_accounts.encrypted%TYPE;

Line 2262: l_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;

2258: l_masked_ba_num iby_ext_bank_accounts.masked_bank_account_num%TYPE;
2259: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
2260: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
2261: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
2262: l_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;
2263: l_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;
2264: l_iban iby_ext_bank_accounts.iban%TYPE;
2265: l_encrypted iby_ext_bank_accounts.encrypted%TYPE;
2266: l_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;

Line 2263: l_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;

2259: l_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
2260: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
2261: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
2262: l_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;
2263: l_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;
2264: l_iban iby_ext_bank_accounts.iban%TYPE;
2265: l_encrypted iby_ext_bank_accounts.encrypted%TYPE;
2266: l_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
2267: l_ba_elec_segment_id iby_ext_bank_accounts.ba_num_elec_sec_segment_id%TYPE;

Line 2264: l_iban iby_ext_bank_accounts.iban%TYPE;

2260: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
2261: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
2262: l_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;
2263: l_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;
2264: l_iban iby_ext_bank_accounts.iban%TYPE;
2265: l_encrypted iby_ext_bank_accounts.encrypted%TYPE;
2266: l_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
2267: l_ba_elec_segment_id iby_ext_bank_accounts.ba_num_elec_sec_segment_id%TYPE;
2268: l_iban_segment_id iby_ext_bank_accounts.iban_sec_segment_id%TYPE;

Line 2265: l_encrypted iby_ext_bank_accounts.encrypted%TYPE;

2261: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
2262: l_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;
2263: l_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;
2264: l_iban iby_ext_bank_accounts.iban%TYPE;
2265: l_encrypted iby_ext_bank_accounts.encrypted%TYPE;
2266: l_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
2267: l_ba_elec_segment_id iby_ext_bank_accounts.ba_num_elec_sec_segment_id%TYPE;
2268: l_iban_segment_id iby_ext_bank_accounts.iban_sec_segment_id%TYPE;
2269: l_bank_account_num_electronic iby_ext_bank_accounts.bank_account_num_electronic%TYPE;

Line 2266: l_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;

2262: l_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;
2263: l_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;
2264: l_iban iby_ext_bank_accounts.iban%TYPE;
2265: l_encrypted iby_ext_bank_accounts.encrypted%TYPE;
2266: l_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
2267: l_ba_elec_segment_id iby_ext_bank_accounts.ba_num_elec_sec_segment_id%TYPE;
2268: l_iban_segment_id iby_ext_bank_accounts.iban_sec_segment_id%TYPE;
2269: l_bank_account_num_electronic iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
2270: l_old_iban iby_ext_bank_accounts.iban%TYPE;

Line 2267: l_ba_elec_segment_id iby_ext_bank_accounts.ba_num_elec_sec_segment_id%TYPE;

2263: l_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;
2264: l_iban iby_ext_bank_accounts.iban%TYPE;
2265: l_encrypted iby_ext_bank_accounts.encrypted%TYPE;
2266: l_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
2267: l_ba_elec_segment_id iby_ext_bank_accounts.ba_num_elec_sec_segment_id%TYPE;
2268: l_iban_segment_id iby_ext_bank_accounts.iban_sec_segment_id%TYPE;
2269: l_bank_account_num_electronic iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
2270: l_old_iban iby_ext_bank_accounts.iban%TYPE;
2271: l_old_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;

Line 2268: l_iban_segment_id iby_ext_bank_accounts.iban_sec_segment_id%TYPE;

2264: l_iban iby_ext_bank_accounts.iban%TYPE;
2265: l_encrypted iby_ext_bank_accounts.encrypted%TYPE;
2266: l_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
2267: l_ba_elec_segment_id iby_ext_bank_accounts.ba_num_elec_sec_segment_id%TYPE;
2268: l_iban_segment_id iby_ext_bank_accounts.iban_sec_segment_id%TYPE;
2269: l_bank_account_num_electronic iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
2270: l_old_iban iby_ext_bank_accounts.iban%TYPE;
2271: l_old_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
2272: l_old_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;

Line 2269: l_bank_account_num_electronic iby_ext_bank_accounts.bank_account_num_electronic%TYPE;

2265: l_encrypted iby_ext_bank_accounts.encrypted%TYPE;
2266: l_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
2267: l_ba_elec_segment_id iby_ext_bank_accounts.ba_num_elec_sec_segment_id%TYPE;
2268: l_iban_segment_id iby_ext_bank_accounts.iban_sec_segment_id%TYPE;
2269: l_bank_account_num_electronic iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
2270: l_old_iban iby_ext_bank_accounts.iban%TYPE;
2271: l_old_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
2272: l_old_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;
2273: l_old_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;

Line 2270: l_old_iban iby_ext_bank_accounts.iban%TYPE;

2266: l_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
2267: l_ba_elec_segment_id iby_ext_bank_accounts.ba_num_elec_sec_segment_id%TYPE;
2268: l_iban_segment_id iby_ext_bank_accounts.iban_sec_segment_id%TYPE;
2269: l_bank_account_num_electronic iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
2270: l_old_iban iby_ext_bank_accounts.iban%TYPE;
2271: l_old_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
2272: l_old_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;
2273: l_old_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;
2274: l_dup_acct_id number;

Line 2271: l_old_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;

2267: l_ba_elec_segment_id iby_ext_bank_accounts.ba_num_elec_sec_segment_id%TYPE;
2268: l_iban_segment_id iby_ext_bank_accounts.iban_sec_segment_id%TYPE;
2269: l_bank_account_num_electronic iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
2270: l_old_iban iby_ext_bank_accounts.iban%TYPE;
2271: l_old_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
2272: l_old_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;
2273: l_old_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;
2274: l_dup_acct_id number;
2275: l_dup_start_date date;

Line 2272: l_old_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;

2268: l_iban_segment_id iby_ext_bank_accounts.iban_sec_segment_id%TYPE;
2269: l_bank_account_num_electronic iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
2270: l_old_iban iby_ext_bank_accounts.iban%TYPE;
2271: l_old_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
2272: l_old_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;
2273: l_old_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;
2274: l_dup_acct_id number;
2275: l_dup_start_date date;
2276: l_dup_end_date date;

Line 2273: l_old_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;

2269: l_bank_account_num_electronic iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
2270: l_old_iban iby_ext_bank_accounts.iban%TYPE;
2271: l_old_masked_iban iby_ext_bank_accounts.masked_iban%TYPE;
2272: l_old_iban_hash1 iby_ext_bank_accounts.iban_hash1%TYPE;
2273: l_old_iban_hash2 iby_ext_bank_accounts.iban_hash2%TYPE;
2274: l_dup_acct_id number;
2275: l_dup_start_date date;
2276: l_dup_end_date date;
2277: l_party_id ap_suppliers.party_id%TYPE;

Line 2300: FROM IBY_EXT_BANK_ACCOUNTS

2296: encrypted,
2297: iban,
2298: masked_iban,
2299: ba_num_elec_sec_segment_id --Changes in Bank Account Num should also consider Electronic BA Num
2300: FROM IBY_EXT_BANK_ACCOUNTS
2301: WHERE EXT_BANK_ACCOUNT_ID = p_acct_id;
2302:
2303: -- checks if account already exists
2304: -- a duplicate bank account is one with the same account_number and

Line 2316: FROM IBY_EXT_BANK_ACCOUNTS_V

2312: p_bank_id NUMBER,
2313: p_branch_id NUMBER,
2314: p_bank_acct_id NUMBER) IS
2315: SELECT count(*)
2316: FROM IBY_EXT_BANK_ACCOUNTS_V
2317: WHERE
2318: (bank_acct_num_hash1 = p_account_num_hash1)
2319: AND (bank_acct_num_hash2 = p_account_num_hash2)
2320: -- AND (p_currency IS NULL OR CURRENCY_CODE = p_currency)

Line 2881: * iby_ext_bank_accounts.

2877: END IF;
2878:
2879: /* Bug :8244523
2880: * Negative bank id and branch Id's are getting updated to the table
2881: * iby_ext_bank_accounts.
2882: * Nulling out the bank Id and branch Id if they are negative.
2883: */
2884: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2885: print_debuginfo('BankID::'||p_ext_bank_acct_rec.bank_id);

Line 2924: -- Update Table IBY_EXT_BANK_ACCOUNTS

2920: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2921: print_debuginfo('Before Update: using bank account');
2922:
2923: END IF;
2924: -- Update Table IBY_EXT_BANK_ACCOUNTS
2925: UPDATE IBY_EXT_BANK_ACCOUNTS
2926: SET BANK_ACCOUNT_NUM = nvl(l_acct_number, BANK_ACCOUNT_NUM),
2927: COUNTRY_CODE=p_ext_bank_acct_rec.country_code,
2928: CURRENCY_CODE =p_ext_bank_acct_rec.currency,

Line 2925: UPDATE IBY_EXT_BANK_ACCOUNTS

2921: print_debuginfo('Before Update: using bank account');
2922:
2923: END IF;
2924: -- Update Table IBY_EXT_BANK_ACCOUNTS
2925: UPDATE IBY_EXT_BANK_ACCOUNTS
2926: SET BANK_ACCOUNT_NUM = nvl(l_acct_number, BANK_ACCOUNT_NUM),
2927: COUNTRY_CODE=p_ext_bank_acct_rec.country_code,
2928: CURRENCY_CODE =p_ext_bank_acct_rec.currency,
2929: IBAN = DECODE(l_iban, FND_API.G_MISS_CHAR,NULL,l_iban),

Line 3121: FROM IBY_EXT_BANK_ACCOUNTS b

3117: b.BANK_ACCOUNT_NAME_ALT,
3118: b.SHORT_ACCT_NAME,
3119: b.DESCRIPTION,
3120: b.SECONDARY_ACCOUNT_REFERENCE -- Bug 7408747
3121: FROM IBY_EXT_BANK_ACCOUNTS b
3122: WHERE b.EXT_BANK_ACCOUNT_ID = p_bankacct_id;
3123:
3124: CURSOR c_acct_owner IS
3125: SELECT ACCOUNT_OWNER_PARTY_ID

Line 3445: UPDATE IBY_EXT_BANK_ACCOUNTS

3441: RAISE fnd_api.g_exc_error;
3442: END IF;
3443:
3444: -- update bank account dates
3445: UPDATE IBY_EXT_BANK_ACCOUNTS
3446: SET START_DATE = p_start_date, END_DATE = NVL(p_end_date,END_DATE)
3447: WHERE EXT_BANK_ACCOUNT_ID = p_acct_id;
3448:
3449: IF (SQL%NOTFOUND) THEN

Line 3451: print_debuginfo('Warning: No matching Row found in IBY_EXT_BANK_ACCOUNTS');

3447: WHERE EXT_BANK_ACCOUNT_ID = p_acct_id;
3448:
3449: IF (SQL%NOTFOUND) THEN
3450: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3451: print_debuginfo('Warning: No matching Row found in IBY_EXT_BANK_ACCOUNTS');
3452: END IF;
3453: ELSE
3454: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3455: print_debuginfo('Set Ext Bank Account End Date as ' || p_end_date);

Line 3528: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;

3524: x_msg_data OUT NOCOPY VARCHAR2,
3525: x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
3526: ) IS
3527:
3528: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
3529: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
3530:
3531: l_api_name CONSTANT VARCHAR2(30) := 'check_ext_acct_exist';
3532: l_api_version CONSTANT NUMBER := 1.0;

Line 3529: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;

3525: x_response OUT NOCOPY IBY_FNDCPT_COMMON_PUB.Result_rec_type
3526: ) IS
3527:
3528: l_ba_num_hash1 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
3529: l_ba_num_hash2 iby_ext_bank_accounts.bank_account_num_hash1%TYPE;
3530:
3531: l_api_name CONSTANT VARCHAR2(30) := 'check_ext_acct_exist';
3532: l_api_version CONSTANT NUMBER := 1.0;
3533: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.' || l_api_name;

Line 3555: FROM IBY_EXT_BANK_ACCOUNTS

3551:
3552: SELECT EXT_BANK_ACCOUNT_ID,
3553: START_DATE,
3554: END_DATE
3555: FROM IBY_EXT_BANK_ACCOUNTS
3556: WHERE (BANK_ACCOUNT_NUM_HASH1= p_account_num_hash1)
3557: AND (BANK_ACCOUNT_NUM_HASH2= p_account_num_hash2)
3558: AND ((p_currency IS NULL and CURRENCY_CODE is NULL) OR (CURRENCY_CODE = p_currency))
3559: AND ((p_bank_id IS NULL AND BANK_ID is NULL) OR (BANK_ID = p_bank_id))

Line 3578: FROM IBY_EXT_BANK_ACCOUNTS

3574:
3575: SELECT EXT_BANK_ACCOUNT_ID,
3576: START_DATE,
3577: END_DATE
3578: FROM IBY_EXT_BANK_ACCOUNTS
3579: WHERE (BANK_ACCOUNT_NUM_HASH1= p_account_num_hash1)
3580: AND (BANK_ACCOUNT_NUM_HASH2= p_account_num_hash2)
3581: AND ((p_currency IS NULL and CURRENCY_CODE is NULL) OR (CURRENCY_CODE = p_currency))
3582: AND ((p_bank_id IS NULL AND BANK_ID is NULL) OR (BANK_ID = p_bank_id))

Line 3602: FROM IBY_EXT_BANK_ACCOUNTS

3598:
3599: SELECT EXT_BANK_ACCOUNT_ID,
3600: START_DATE,
3601: END_DATE
3602: FROM IBY_EXT_BANK_ACCOUNTS
3603: WHERE (BANK_ACCOUNT_NUM_HASH1= p_account_num_hash1)
3604: AND (BANK_ACCOUNT_NUM_HASH2= p_account_num_hash2)
3605: AND ((p_currency IS NULL and CURRENCY_CODE is NULL) OR (CURRENCY_CODE = p_currency))
3606: AND ((p_bank_id IS NULL AND BANK_ID is NULL) OR (BANK_ID = p_bank_id))

Line 4927: lx_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;

4923: END Get_BA_Encrypt_Mode;
4924:
4925: FUNCTION Mask_Bank_Number( p_bank_number IN VARCHAR2 ) RETURN VARCHAR2
4926: IS
4927: lx_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;
4928: lx_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
4929: BEGIN
4930: Get_Mask_Settings(lx_mask_option,lx_unmask_len);
4931: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 4928: lx_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;

4924:
4925: FUNCTION Mask_Bank_Number( p_bank_number IN VARCHAR2 ) RETURN VARCHAR2
4926: IS
4927: lx_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;
4928: lx_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
4929: BEGIN
4930: Get_Mask_Settings(lx_mask_option,lx_unmask_len);
4931: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4932: print_debuginfo('The value of lx_mask_option :' ||lx_mask_option);

Line 4940: p_mask_option IN iby_ext_bank_accounts.ba_mask_setting%TYPE,

4936: END Mask_Bank_Number;
4937:
4938: FUNCTION Mask_Bank_Number
4939: (p_bank_number IN VARCHAR2,
4940: p_mask_option IN iby_ext_bank_accounts.ba_mask_setting%TYPE,
4941: p_unmask_len IN iby_ext_bank_accounts.ba_unmask_length%TYPE
4942: )
4943: RETURN VARCHAR2
4944: IS

Line 4941: p_unmask_len IN iby_ext_bank_accounts.ba_unmask_length%TYPE

4937:
4938: FUNCTION Mask_Bank_Number
4939: (p_bank_number IN VARCHAR2,
4940: p_mask_option IN iby_ext_bank_accounts.ba_mask_setting%TYPE,
4941: p_unmask_len IN iby_ext_bank_accounts.ba_unmask_length%TYPE
4942: )
4943: RETURN VARCHAR2
4944: IS
4945: BEGIN

Line 5004: p_mask_option IN iby_ext_bank_accounts.ba_mask_setting%TYPE,

5000: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE,
5001: p_sub_key_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
5002: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,
5003: p_encoding IN iby_security_segments.encoding_scheme%TYPE,
5004: p_mask_option IN iby_ext_bank_accounts.ba_mask_setting%TYPE,
5005: p_unmask_len IN iby_ext_bank_accounts.ba_unmask_length%TYPE
5006: )
5007: RETURN VARCHAR2
5008: IS

Line 5005: p_unmask_len IN iby_ext_bank_accounts.ba_unmask_length%TYPE

5001: p_sub_key_cipher IN iby_sys_security_subkeys.subkey_cipher_text%TYPE,
5002: p_segment_cipher IN iby_security_segments.segment_cipher_text%TYPE,
5003: p_encoding IN iby_security_segments.encoding_scheme%TYPE,
5004: p_mask_option IN iby_ext_bank_accounts.ba_mask_setting%TYPE,
5005: p_unmask_len IN iby_ext_bank_accounts.ba_unmask_length%TYPE
5006: )
5007: RETURN VARCHAR2
5008: IS
5009: l_sub_key iby_sys_security_subkeys.subkey_cipher_text%TYPE;

Line 5050: lx_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;

5046: (p_commit IN VARCHAR2 := FND_API.G_TRUE,
5047: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE
5048: )
5049: IS
5050: lx_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;
5051: lx_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
5052: l_mode iby_sys_security_options.ext_ba_encryption_mode%TYPE;
5053: lx_key_error VARCHAR2(300);
5054:

Line 5051: lx_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;

5047: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE
5048: )
5049: IS
5050: lx_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;
5051: lx_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
5052: l_mode iby_sys_security_options.ext_ba_encryption_mode%TYPE;
5053: lx_key_error VARCHAR2(300);
5054:
5055: l_ba_num iby_ext_bank_accounts.bank_account_num%TYPE;

Line 5055: l_ba_num iby_ext_bank_accounts.bank_account_num%TYPE;

5051: lx_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
5052: l_mode iby_sys_security_options.ext_ba_encryption_mode%TYPE;
5053: lx_key_error VARCHAR2(300);
5054:
5055: l_ba_num iby_ext_bank_accounts.bank_account_num%TYPE;
5056: l_iban iby_ext_bank_accounts.iban%TYPE;
5057: lx_compress_num iby_ext_bank_accounts.bank_account_num%TYPE;
5058:
5059: lx_ba_unmask_digits iby_ext_bank_accounts.bank_account_num%TYPE;

Line 5056: l_iban iby_ext_bank_accounts.iban%TYPE;

5052: l_mode iby_sys_security_options.ext_ba_encryption_mode%TYPE;
5053: lx_key_error VARCHAR2(300);
5054:
5055: l_ba_num iby_ext_bank_accounts.bank_account_num%TYPE;
5056: l_iban iby_ext_bank_accounts.iban%TYPE;
5057: lx_compress_num iby_ext_bank_accounts.bank_account_num%TYPE;
5058:
5059: lx_ba_unmask_digits iby_ext_bank_accounts.bank_account_num%TYPE;
5060: l_ba_segment iby_security_segments.segment_cipher_text%TYPE;

Line 5057: lx_compress_num iby_ext_bank_accounts.bank_account_num%TYPE;

5053: lx_key_error VARCHAR2(300);
5054:
5055: l_ba_num iby_ext_bank_accounts.bank_account_num%TYPE;
5056: l_iban iby_ext_bank_accounts.iban%TYPE;
5057: lx_compress_num iby_ext_bank_accounts.bank_account_num%TYPE;
5058:
5059: lx_ba_unmask_digits iby_ext_bank_accounts.bank_account_num%TYPE;
5060: l_ba_segment iby_security_segments.segment_cipher_text%TYPE;
5061: lx_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;

Line 5059: lx_ba_unmask_digits iby_ext_bank_accounts.bank_account_num%TYPE;

5055: l_ba_num iby_ext_bank_accounts.bank_account_num%TYPE;
5056: l_iban iby_ext_bank_accounts.iban%TYPE;
5057: lx_compress_num iby_ext_bank_accounts.bank_account_num%TYPE;
5058:
5059: lx_ba_unmask_digits iby_ext_bank_accounts.bank_account_num%TYPE;
5060: l_ba_segment iby_security_segments.segment_cipher_text%TYPE;
5061: lx_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
5062:
5063: lx_iban_unmask_digits iby_ext_bank_accounts.iban%TYPE;

Line 5061: lx_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;

5057: lx_compress_num iby_ext_bank_accounts.bank_account_num%TYPE;
5058:
5059: lx_ba_unmask_digits iby_ext_bank_accounts.bank_account_num%TYPE;
5060: l_ba_segment iby_security_segments.segment_cipher_text%TYPE;
5061: lx_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
5062:
5063: lx_iban_unmask_digits iby_ext_bank_accounts.iban%TYPE;
5064: l_iban_segment iby_security_segments.segment_cipher_text%TYPE;
5065: lx_iban_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;

Line 5063: lx_iban_unmask_digits iby_ext_bank_accounts.iban%TYPE;

5059: lx_ba_unmask_digits iby_ext_bank_accounts.bank_account_num%TYPE;
5060: l_ba_segment iby_security_segments.segment_cipher_text%TYPE;
5061: lx_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
5062:
5063: lx_iban_unmask_digits iby_ext_bank_accounts.iban%TYPE;
5064: l_iban_segment iby_security_segments.segment_cipher_text%TYPE;
5065: lx_iban_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
5066:
5067: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Remask_Accounts';

Line 5065: lx_iban_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;

5061: lx_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
5062:
5063: lx_iban_unmask_digits iby_ext_bank_accounts.iban%TYPE;
5064: l_iban_segment iby_security_segments.segment_cipher_text%TYPE;
5065: lx_iban_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
5066:
5067: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Remask_Accounts';
5068:
5069: CURSOR c_ext_ba

Line 5070: (ci_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE,

5066:
5067: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Remask_Accounts';
5068:
5069: CURSOR c_ext_ba
5070: (ci_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE,
5071: ci_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE
5072: )
5073: IS
5074: SELECT b.ext_bank_account_id, b.bank_account_num, b.iban,

Line 5071: ci_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE

5067: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Remask_Accounts';
5068:
5069: CURSOR c_ext_ba
5070: (ci_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE,
5071: ci_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE
5072: )
5073: IS
5074: SELECT b.ext_bank_account_id, b.bank_account_num, b.iban,
5075: b.ba_num_sec_segment_id, bak.subkey_cipher_text ba_subkey_cipher,

Line 5082: FROM iby_ext_bank_accounts b, iby_sys_security_subkeys bak,

5078: b.iban_sec_segment_id, ibk.subkey_cipher_text iban_subkey_cipher,
5079: ibs.segment_cipher_text iban_segment_cipher,
5080: ibs.encoding_scheme iban_encoding,
5081: b.ba_mask_setting, b.ba_unmask_length
5082: FROM iby_ext_bank_accounts b, iby_sys_security_subkeys bak,
5083: iby_sys_security_subkeys ibk, iby_security_segments bas,
5084: iby_security_segments ibs
5085: WHERE
5086: ( (NVL(ba_unmask_length,-1) <> ci_unmask_len) OR

Line 5222: UPDATE iby_ext_bank_accounts

5218: DELETE FROM iby_security_segments
5219: WHERE sec_segment_id = ext_ba_rec.iban_sec_segment_id;
5220: END IF;
5221:
5222: UPDATE iby_ext_bank_accounts
5223: SET
5224: bank_account_num = lx_ba_unmask_digits,
5225: ba_num_sec_segment_id = lx_ba_segment_id,
5226: iban = lx_iban_unmask_digits,

Line 5259: lx_compress_num iby_ext_bank_accounts.bank_account_num%TYPE;

5255: IS
5256: l_mode iby_sys_security_options.ext_ba_encryption_mode%TYPE;
5257: lx_key_error VARCHAR2(300);
5258:
5259: lx_compress_num iby_ext_bank_accounts.bank_account_num%TYPE;
5260:
5261: lx_ba_unmask_digits iby_ext_bank_accounts.bank_account_num%TYPE;
5262: l_ba_segment iby_security_segments.segment_cipher_text%TYPE;
5263: lx_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;

Line 5261: lx_ba_unmask_digits iby_ext_bank_accounts.bank_account_num%TYPE;

5257: lx_key_error VARCHAR2(300);
5258:
5259: lx_compress_num iby_ext_bank_accounts.bank_account_num%TYPE;
5260:
5261: lx_ba_unmask_digits iby_ext_bank_accounts.bank_account_num%TYPE;
5262: l_ba_segment iby_security_segments.segment_cipher_text%TYPE;
5263: lx_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
5264:
5265: lx_iban_unmask_digits iby_ext_bank_accounts.iban%TYPE;

Line 5263: lx_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;

5259: lx_compress_num iby_ext_bank_accounts.bank_account_num%TYPE;
5260:
5261: lx_ba_unmask_digits iby_ext_bank_accounts.bank_account_num%TYPE;
5262: l_ba_segment iby_security_segments.segment_cipher_text%TYPE;
5263: lx_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
5264:
5265: lx_iban_unmask_digits iby_ext_bank_accounts.iban%TYPE;
5266: l_iban_segment iby_security_segments.segment_cipher_text%TYPE;
5267: lx_iban_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;

Line 5265: lx_iban_unmask_digits iby_ext_bank_accounts.iban%TYPE;

5261: lx_ba_unmask_digits iby_ext_bank_accounts.bank_account_num%TYPE;
5262: l_ba_segment iby_security_segments.segment_cipher_text%TYPE;
5263: lx_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
5264:
5265: lx_iban_unmask_digits iby_ext_bank_accounts.iban%TYPE;
5266: l_iban_segment iby_security_segments.segment_cipher_text%TYPE;
5267: lx_iban_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
5268:
5269: lx_e_ba_unmask_digits iby_ext_bank_accounts.bank_account_num_electronic%TYPE;

Line 5267: lx_iban_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;

5263: lx_ba_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
5264:
5265: lx_iban_unmask_digits iby_ext_bank_accounts.iban%TYPE;
5266: l_iban_segment iby_security_segments.segment_cipher_text%TYPE;
5267: lx_iban_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
5268:
5269: lx_e_ba_unmask_digits iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
5270: l_e_ba_segment iby_security_segments.segment_cipher_text%TYPE;
5271: lx_e_ba_segment_id iby_ext_bank_accounts.ba_num_elec_sec_segment_id%TYPE;

Line 5269: lx_e_ba_unmask_digits iby_ext_bank_accounts.bank_account_num_electronic%TYPE;

5265: lx_iban_unmask_digits iby_ext_bank_accounts.iban%TYPE;
5266: l_iban_segment iby_security_segments.segment_cipher_text%TYPE;
5267: lx_iban_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
5268:
5269: lx_e_ba_unmask_digits iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
5270: l_e_ba_segment iby_security_segments.segment_cipher_text%TYPE;
5271: lx_e_ba_segment_id iby_ext_bank_accounts.ba_num_elec_sec_segment_id%TYPE;
5272:
5273: CURSOR c_ext_ba

Line 5271: lx_e_ba_segment_id iby_ext_bank_accounts.ba_num_elec_sec_segment_id%TYPE;

5267: lx_iban_segment_id iby_ext_bank_accounts.ba_num_sec_segment_id%TYPE;
5268:
5269: lx_e_ba_unmask_digits iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
5270: l_e_ba_segment iby_security_segments.segment_cipher_text%TYPE;
5271: lx_e_ba_segment_id iby_ext_bank_accounts.ba_num_elec_sec_segment_id%TYPE;
5272:
5273: CURSOR c_ext_ba
5274: IS
5275: SELECT b.ext_bank_account_id, b.bank_account_num, b.iban,

Line 5279: FROM iby_ext_bank_accounts b

5275: SELECT b.ext_bank_account_id, b.bank_account_num, b.iban,
5276: b.ba_num_sec_segment_id, b.iban_sec_segment_id,
5277: b.bank_account_num_electronic, b.ba_num_elec_sec_segment_id,
5278: b.ba_mask_setting, b.ba_unmask_length
5279: FROM iby_ext_bank_accounts b
5280: WHERE (NVL(b.encrypted,'N') = 'N');
5281:
5282: BEGIN
5283:

Line 5367: UPDATE iby_ext_bank_accounts

5363: ELSE
5364: lx_e_ba_unmask_digits := ext_ba_rec.bank_account_num_electronic;
5365: END IF;
5366:
5367: UPDATE iby_ext_bank_accounts
5368: SET
5369: bank_account_num = lx_ba_unmask_digits,
5370: iban = lx_iban_unmask_digits,
5371: ba_num_sec_segment_id = NVL(lx_ba_segment_id,ba_num_sec_segment_id),

Line 5392: l_ba_num iby_ext_bank_accounts.bank_account_num%TYPE;

5388: )
5389: IS
5390: l_mode iby_sys_security_options.ext_ba_encryption_mode%TYPE;
5391: l_subkey iby_sys_security_subkeys.subkey_cipher_text%TYPE;
5392: l_ba_num iby_ext_bank_accounts.bank_account_num%TYPE;
5393: l_iban iby_ext_bank_accounts.iban%TYPE;
5394: l_e_ba iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
5395:
5396: lx_key_error VARCHAR2(300);

Line 5393: l_iban iby_ext_bank_accounts.iban%TYPE;

5389: IS
5390: l_mode iby_sys_security_options.ext_ba_encryption_mode%TYPE;
5391: l_subkey iby_sys_security_subkeys.subkey_cipher_text%TYPE;
5392: l_ba_num iby_ext_bank_accounts.bank_account_num%TYPE;
5393: l_iban iby_ext_bank_accounts.iban%TYPE;
5394: l_e_ba iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
5395:
5396: lx_key_error VARCHAR2(300);
5397:

Line 5394: l_e_ba iby_ext_bank_accounts.bank_account_num_electronic%TYPE;

5390: l_mode iby_sys_security_options.ext_ba_encryption_mode%TYPE;
5391: l_subkey iby_sys_security_subkeys.subkey_cipher_text%TYPE;
5392: l_ba_num iby_ext_bank_accounts.bank_account_num%TYPE;
5393: l_iban iby_ext_bank_accounts.iban%TYPE;
5394: l_e_ba iby_ext_bank_accounts.bank_account_num_electronic%TYPE;
5395:
5396: lx_key_error VARCHAR2(300);
5397:
5398: CURSOR c_ext_ba

Line 5413: FROM iby_ext_bank_accounts b, iby_sys_security_subkeys bak,

5409: ebk.subkey_cipher_text e_ba_subkey_cipher,
5410: ebs.segment_cipher_text e_ba_segment_cipher,
5411: ebs.encoding_scheme e_ba_encoding,
5412: b.ba_mask_setting, b.ba_unmask_length
5413: FROM iby_ext_bank_accounts b, iby_sys_security_subkeys bak,
5414: iby_sys_security_subkeys ebk, iby_sys_security_subkeys ibk,
5415: iby_security_segments bas, iby_security_segments ibs,
5416: iby_security_segments ebs
5417: WHERE

Line 5480: UPDATE iby_ext_bank_accounts

5476: ext_ba_rec.ba_mask_setting,
5477: ext_ba_rec.ba_unmask_length);
5478: END IF;
5479:
5480: UPDATE iby_ext_bank_accounts
5481: SET
5482: bank_account_num = NVL(l_ba_num,bank_account_num),
5483: iban = NVL(l_iban,iban),
5484: bank_account_num_electronic = NVL(l_e_ba,bank_account_num_electronic),

Line 5560: ( p_ext_bank_acct_id IN iby_ext_bank_accounts.ext_bank_account_id%TYPE

5556: --End of FSIO
5557:
5558:
5559: FUNCTION find_assignment_OU
5560: ( p_ext_bank_acct_id IN iby_ext_bank_accounts.ext_bank_account_id%TYPE
5561: )
5562: RETURN NUMBER IS
5563: l_org_id NUMBER :=-1;
5564: l_api_name CONSTANT VARCHAR2(30) := 'find_assignment_OU';

Line 5621: p_ext_bank_acct_id IN iby_ext_bank_accounts.ext_bank_account_id%type,

5617:
5618: /* Bug 14456128 Introduced procedure Uncipher_Bank_Acct_Number for
5619: decrypting Bank account number */
5620: FUNCTION Uncipher_Bank_Acct_Number(
5621: p_ext_bank_acct_id IN iby_ext_bank_accounts.ext_bank_account_id%type,
5622: p_sys_key IN iby_security_pkg.DES3_KEY_TYPE )
5623: RETURN VARCHAR2
5624: IS
5625: l_api_name CONSTANT VARCHAR2(30) := 'Uncipher_Bank_Acct_Number';

Line 5630: l_bank_acct_num iby_ext_bank_accounts.bank_account_num%TYPE;

5626: l_api_version CONSTANT NUMBER := 1.0;
5627: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.' || l_api_name;
5628: l_sub_key iby_sys_security_subkeys.subkey_cipher_text%TYPE;
5629: l_bank_segment iby_security_segments.segment_cipher_text%TYPE;
5630: l_bank_acct_num iby_ext_bank_accounts.bank_account_num%TYPE;
5631: l_segment_id iby_ext_bank_accounts.BA_NUM_SEC_SEGMENT_ID%type;
5632: l_sub_key_cipher iby_sys_security_subkeys.subkey_cipher_text%TYPE;
5633: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;
5634: l_encoding iby_security_segments.encoding_scheme%TYPE;

Line 5631: l_segment_id iby_ext_bank_accounts.BA_NUM_SEC_SEGMENT_ID%type;

5627: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.' || l_api_name;
5628: l_sub_key iby_sys_security_subkeys.subkey_cipher_text%TYPE;
5629: l_bank_segment iby_security_segments.segment_cipher_text%TYPE;
5630: l_bank_acct_num iby_ext_bank_accounts.bank_account_num%TYPE;
5631: l_segment_id iby_ext_bank_accounts.BA_NUM_SEC_SEGMENT_ID%type;
5632: l_sub_key_cipher iby_sys_security_subkeys.subkey_cipher_text%TYPE;
5633: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;
5634: l_encoding iby_security_segments.encoding_scheme%TYPE;
5635: l_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;

Line 5635: l_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;

5631: l_segment_id iby_ext_bank_accounts.BA_NUM_SEC_SEGMENT_ID%type;
5632: l_sub_key_cipher iby_sys_security_subkeys.subkey_cipher_text%TYPE;
5633: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;
5634: l_encoding iby_security_segments.encoding_scheme%TYPE;
5635: l_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;
5636: l_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
5637: l_bank_num iby_ext_bank_accounts.bank_account_num%TYPE;
5638: l_err_code varchar2(100):=null;
5639: CURSOR c_cipher_data(p_ext_bank_account_id NUMBER)

Line 5636: l_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;

5632: l_sub_key_cipher iby_sys_security_subkeys.subkey_cipher_text%TYPE;
5633: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;
5634: l_encoding iby_security_segments.encoding_scheme%TYPE;
5635: l_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;
5636: l_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
5637: l_bank_num iby_ext_bank_accounts.bank_account_num%TYPE;
5638: l_err_code varchar2(100):=null;
5639: CURSOR c_cipher_data(p_ext_bank_account_id NUMBER)
5640: IS

Line 5637: l_bank_num iby_ext_bank_accounts.bank_account_num%TYPE;

5633: l_segment_cipher iby_security_segments.segment_cipher_text%TYPE;
5634: l_encoding iby_security_segments.encoding_scheme%TYPE;
5635: l_mask_option iby_ext_bank_accounts.ba_mask_setting%TYPE;
5636: l_unmask_len iby_ext_bank_accounts.ba_unmask_length%TYPE;
5637: l_bank_num iby_ext_bank_accounts.bank_account_num%TYPE;
5638: l_err_code varchar2(100):=null;
5639: CURSOR c_cipher_data(p_ext_bank_account_id NUMBER)
5640: IS
5641: SELECT ba.bank_account_num,

Line 5648: FROM iby_ext_bank_accounts ba,

5644: segments.segment_cipher_text,
5645: segments.encoding_scheme,
5646: ba.ba_mask_setting,
5647: ba.ba_unmask_length
5648: FROM iby_ext_bank_accounts ba,
5649: iby_sys_security_subkeys subkeys,
5650: iby_security_segments segments
5651: WHERE ba.ext_bank_account_id = p_ext_bank_account_id
5652: AND ba.ba_num_sec_segment_id = segments.sec_segment_id (+)