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_HASH_REGENERATOR dependencies on IBY_EXT_BANK_ACCOUNTS

Line 38: l_ba_id iby_ext_bank_accounts.ext_bank_account_id%TYPE;

34: l_count3 NUMBER;
35: l_cc_id iby_creditcard.instrid%TYPE;
36: l_cc_num iby_creditcard.ccnumber%TYPE;
37:
38: l_ba_id iby_ext_bank_accounts.ext_bank_account_id%TYPE;
39: l_ba_num iby_ext_bank_accounts.bank_account_num%TYPE;
40:
41: l_sys_key iby_view_parameters_gt.value%TYPE;
42: l_force_create VARCHAR2(1);

Line 39: l_ba_num iby_ext_bank_accounts.bank_account_num%TYPE;

35: l_cc_id iby_creditcard.instrid%TYPE;
36: l_cc_num iby_creditcard.ccnumber%TYPE;
37:
38: l_ba_id iby_ext_bank_accounts.ext_bank_account_id%TYPE;
39: l_ba_num iby_ext_bank_accounts.bank_account_num%TYPE;
40:
41: l_sys_key iby_view_parameters_gt.value%TYPE;
42: l_force_create VARCHAR2(1);
43:

Line 86: iby_ext_bank_accounts b,

82: b.ba_unmask_length
83: ) iban,
84: b.iban iban2
85: FROM
86: iby_ext_bank_accounts b,
87: iby_security_segments bas,
88: iby_sys_security_subkeys bak,
89: iby_security_segments ibs,
90: iby_sys_security_subkeys ibk

Line 223: --IBY_EXT_BANK_ACCOUNTS BANK_ACCOUNT_NUM_HASH1 BANK_ACCOUNT_NUM

219:
220: ----------------------------------------------------------------------------------------
221: --TABLE_NAME COLUMN_NAME COLUMN_NAME_REF
222: ----------------------------------------------------------------------------------------
223: --IBY_EXT_BANK_ACCOUNTS BANK_ACCOUNT_NUM_HASH1 BANK_ACCOUNT_NUM
224: --IBY_EXT_BANK_ACCOUNTS BANK_ACCOUNT_NUM_HASH2 BANK_ACCOUNT_NUM
225: --IBY_EXT_BANK_ACCOUNTS IBAN_HASH1 IBAN
226: --IBY_EXT_BANK_ACCOUNTS IBAN_HASH2 IBAN
227: ----------------------------------------------------------------------------------------

Line 224: --IBY_EXT_BANK_ACCOUNTS BANK_ACCOUNT_NUM_HASH2 BANK_ACCOUNT_NUM

220: ----------------------------------------------------------------------------------------
221: --TABLE_NAME COLUMN_NAME COLUMN_NAME_REF
222: ----------------------------------------------------------------------------------------
223: --IBY_EXT_BANK_ACCOUNTS BANK_ACCOUNT_NUM_HASH1 BANK_ACCOUNT_NUM
224: --IBY_EXT_BANK_ACCOUNTS BANK_ACCOUNT_NUM_HASH2 BANK_ACCOUNT_NUM
225: --IBY_EXT_BANK_ACCOUNTS IBAN_HASH1 IBAN
226: --IBY_EXT_BANK_ACCOUNTS IBAN_HASH2 IBAN
227: ----------------------------------------------------------------------------------------
228: --SELECT bank_account_num,

Line 225: --IBY_EXT_BANK_ACCOUNTS IBAN_HASH1 IBAN

221: --TABLE_NAME COLUMN_NAME COLUMN_NAME_REF
222: ----------------------------------------------------------------------------------------
223: --IBY_EXT_BANK_ACCOUNTS BANK_ACCOUNT_NUM_HASH1 BANK_ACCOUNT_NUM
224: --IBY_EXT_BANK_ACCOUNTS BANK_ACCOUNT_NUM_HASH2 BANK_ACCOUNT_NUM
225: --IBY_EXT_BANK_ACCOUNTS IBAN_HASH1 IBAN
226: --IBY_EXT_BANK_ACCOUNTS IBAN_HASH2 IBAN
227: ----------------------------------------------------------------------------------------
228: --SELECT bank_account_num,
229: -- bank_account_num_hash1,

Line 226: --IBY_EXT_BANK_ACCOUNTS IBAN_HASH2 IBAN

222: ----------------------------------------------------------------------------------------
223: --IBY_EXT_BANK_ACCOUNTS BANK_ACCOUNT_NUM_HASH1 BANK_ACCOUNT_NUM
224: --IBY_EXT_BANK_ACCOUNTS BANK_ACCOUNT_NUM_HASH2 BANK_ACCOUNT_NUM
225: --IBY_EXT_BANK_ACCOUNTS IBAN_HASH1 IBAN
226: --IBY_EXT_BANK_ACCOUNTS IBAN_HASH2 IBAN
227: ----------------------------------------------------------------------------------------
228: --SELECT bank_account_num,
229: -- bank_account_num_hash1,
230: -- iby_security_pkg.get_hash(bank_account_num, 'F'),

Line 233: --FROM iby_ext_bank_accounts

229: -- bank_account_num_hash1,
230: -- iby_security_pkg.get_hash(bank_account_num, 'F'),
231: -- bank_account_num_hash2,
232: -- iby_security_pkg.get_hash(bank_account_num, 'T')
233: --FROM iby_ext_bank_accounts
234: --WHERE bank_account_num IS NOT NULL;
235:
236: --SELECT iban,
237: -- iban_hash1,

Line 241: --FROM iby_ext_bank_accounts

237: -- iban_hash1,
238: -- iby_security_pkg.get_hash(iban, 'F'),
239: -- iban_hash2,
240: -- iby_security_pkg.get_hash(iban, 'T')
241: --FROM iby_ext_bank_accounts
242: --WHERE iban IS NOT NULL;
243:
244: IF (p_bankaccounts_flag = 'Y') THEN
245:

Line 251: UPDATE iby_ext_bank_accounts

247: l_count1 := 0 ;
248: l_count2 := 0 ;
249: l_count3 := 0 ;
250:
251: UPDATE iby_ext_bank_accounts
252: SET bank_account_num_hash1 = NULL,
253: bank_account_num_hash2 = NULL;
254:
255: UPDATE iby_ext_bank_accounts

Line 255: UPDATE iby_ext_bank_accounts

251: UPDATE iby_ext_bank_accounts
252: SET bank_account_num_hash1 = NULL,
253: bank_account_num_hash2 = NULL;
254:
255: UPDATE iby_ext_bank_accounts
256: SET iban_hash1 = NULL,
257: iban_hash2 = NULL;
258:
259: FOR bank_acct_rec IN get_bank_accounts(l_sys_key)

Line 265: UPDATE iby_ext_bank_accounts

261: l_count1 := l_count1 + 1 ;
262: IF (bank_acct_rec.bank_account_number IS NOT NULL)
263: THEN
264: l_count2 := l_count2 + 1 ;
265: UPDATE iby_ext_bank_accounts
266: SET bank_account_num_hash1 = iby_security_pkg.get_hash(bank_acct_rec.bank_account_number, 'F'),
267: bank_account_num_hash2 = iby_security_pkg.get_hash(bank_acct_rec.bank_account_number, 'T'),
268: salt_version = 2
269: WHERE ext_bank_account_id = bank_acct_rec.ext_bank_account_id;

Line 277: UPDATE iby_ext_bank_accounts

273: IF (bank_acct_rec.iban IS NOT NULL)
274: THEN
275:
276: l_count3 := l_count3 + 1 ;
277: UPDATE iby_ext_bank_accounts
278: SET iban_hash1 = iby_security_pkg.get_hash(bank_acct_rec.iban, 'F'),
279: iban_hash2 = iby_security_pkg.get_hash(bank_acct_rec.iban, 'T')
280: WHERE ext_bank_account_id = bank_acct_rec.ext_bank_account_id;
281:

Line 596: SELECT COUNT(1) INTO l_pending_ba FROM iby_ext_bank_accounts WHERE NVL(salt_version,1) <> 3;

592: iby_debug_pub.add('Verifying if any data is pending before setting system switch',iby_debug_pub.G_LEVEL_INFO,l_module_name);
593: SELECT COUNT(1) INTO l_pending_cc FROM iby_creditcard WHERE NVL(salt_version,1) <> 3;
594: IF(l_pending_cc = 0) THEN
595: iby_debug_pub.add('All CC hashes generated. Verifying BA..',iby_debug_pub.G_LEVEL_INFO,l_module_name);
596: SELECT COUNT(1) INTO l_pending_ba FROM iby_ext_bank_accounts WHERE NVL(salt_version,1) <> 3;
597: IF(l_pending_ba = 0) THEN
598: iby_debug_pub.add('All BA records re-hashed. Updating system_salt_version..',iby_debug_pub.G_LEVEL_INFO,l_module_name);
599: UPDATE iby_sys_security_options SET system_salt_version=3;
600: COMMIT;

Line 681: l_table_name VARCHAR2(30) := 'IBY_EXT_BANK_ACCOUNTS';

677: l_batch_size NUMBER;
678: l_worker_id NUMBER;
679: l_num_workers NUMBER;
680: l_any_rows_to_process BOOLEAN;
681: l_table_name VARCHAR2(30) := 'IBY_EXT_BANK_ACCOUNTS';
682: l_script_name VARCHAR2(30);
683: l_product VARCHAR2(10) := 'IBY';
684: l_status VARCHAR2(30);
685: l_industry VARCHAR2(30);

Line 714: FROM iby_ext_bank_accounts

710: bank_account_num_hash1,
711: bank_account_num_hash2,
712: iban_hash1,
713: iban_hash2
714: FROM iby_ext_bank_accounts
715: WHERE NVL(salt_version,1) = 2
716: AND (rowid BETWEEN ci_start_rowid AND ci_end_rowid);
717: BEGIN
718: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_INFO,l_module_name);

Line 771: UPDATE iby_ext_bank_accounts

767: iby_debug_pub.add('rows fetched:='||l_instrid_tbl.COUNT,iby_debug_pub.G_LEVEL_INFO,l_module_name);
768: t1 := systimestamp;
769: IF (l_instrid_tbl.COUNT>0) THEN
770: FORALL i IN l_instrid_tbl.first..l_instrid_tbl.last
771: UPDATE iby_ext_bank_accounts
772: SET bank_account_num_hash1 = DECODE(l_banum_hash1_tbl(i),NULL,NULL,IBY_SECURITY_PKG.Compute_New_Hash(l_banum_hash1_tbl(i),l_site_salt)),
773: bank_account_num_hash2 = DECODE(l_banum_hash2_tbl(i),NULL,NULL,IBY_SECURITY_PKG.Compute_New_Hash(l_banum_hash2_tbl(i),l_site_salt)),
774: iban_hash1 = DECODE(l_iban_hash1_tbl(i),NULL,NULL,IBY_SECURITY_PKG.Compute_New_Hash(l_iban_hash1_tbl(i),l_site_salt)),
775: iban_hash2 = DECODE(l_iban_hash2_tbl(i),NULL,NULL,IBY_SECURITY_PKG.Compute_New_Hash(l_iban_hash2_tbl(i),l_site_salt)),

Line 816: SELECT COUNT(1) INTO l_pending_ba FROM iby_ext_bank_accounts WHERE NVL(salt_version,1) <> 3;

812: iby_debug_pub.add('Verifying if any data is pending before setting system switch',iby_debug_pub.G_LEVEL_INFO,l_module_name);
813: SELECT COUNT(1) INTO l_pending_cc FROM iby_creditcard WHERE NVL(salt_version,1) <> 3;
814: IF(l_pending_cc = 0) THEN
815: iby_debug_pub.add('All CC hashes generated. Verifying BA..',iby_debug_pub.G_LEVEL_INFO,l_module_name);
816: SELECT COUNT(1) INTO l_pending_ba FROM iby_ext_bank_accounts WHERE NVL(salt_version,1) <> 3;
817: IF(l_pending_ba = 0) THEN
818: iby_debug_pub.add('All BA records re-hashed. Updating system_salt_version..',iby_debug_pub.G_LEVEL_INFO,l_module_name);
819: UPDATE iby_sys_security_options SET system_salt_version=3;
820: COMMIT;