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_SECURITY_PKG

Line 158: IF(l_force_create <> 'Y' AND IBY_SECURITY_PKG.get_salt_version > 1)THEN

154: l_force_create := NVL(p_force_create, 'N');
155: print_debuginfo(l_module_name, 'l_force_create = '|| l_force_create);
156:
157: print_debuginfo(l_module_name, 'Verfying version of existing hash..');
158: IF(l_force_create <> 'Y' AND IBY_SECURITY_PKG.get_salt_version > 1)THEN
159: print_debuginfo(l_module_name, 'Raw hash already generated. Exiting!');
160: RETURN;
161: END IF ;
162:

Line 180: -- iby_security_pkg.get_hash(ccnumber, 'F'),

176: --IBY_CREDITCARD CC_NUMBER_HASH2 CCNUMBER
177: ----------------------------------------------------------------------------------------
178: --SELECT ccnumber,
179: -- cc_number_hash1,
180: -- iby_security_pkg.get_hash(ccnumber, 'F'),
181: -- cc_number_hash2,
182: -- iby_security_pkg.get_hash(ccnumber, 'T')
183: --FROM iby_creditcard
184: --WHERE ccnumber IS NOT NULL;

Line 182: -- iby_security_pkg.get_hash(ccnumber, 'T')

178: --SELECT ccnumber,
179: -- cc_number_hash1,
180: -- iby_security_pkg.get_hash(ccnumber, 'F'),
181: -- cc_number_hash2,
182: -- iby_security_pkg.get_hash(ccnumber, 'T')
183: --FROM iby_creditcard
184: --WHERE ccnumber IS NOT NULL;
185:
186: IF (p_creditcards_flag = 'Y') THEN

Line 205: SET cc_number_hash1 = iby_security_pkg.get_hash(credit_card_rec.credit_card_number, 'F'),

201: THEN
202:
203: l_count2 := l_count2 + 1 ;
204: UPDATE iby_creditcard
205: SET cc_number_hash1 = iby_security_pkg.get_hash(credit_card_rec.credit_card_number, 'F'),
206: cc_number_hash2 = iby_security_pkg.get_hash(credit_card_rec.credit_card_number, 'T'),
207: salt_version = 2
208: WHERE instrid = credit_card_rec.instrid;
209:

Line 206: cc_number_hash2 = iby_security_pkg.get_hash(credit_card_rec.credit_card_number, 'T'),

202:
203: l_count2 := l_count2 + 1 ;
204: UPDATE iby_creditcard
205: SET cc_number_hash1 = iby_security_pkg.get_hash(credit_card_rec.credit_card_number, 'F'),
206: cc_number_hash2 = iby_security_pkg.get_hash(credit_card_rec.credit_card_number, 'T'),
207: salt_version = 2
208: WHERE instrid = credit_card_rec.instrid;
209:
210: END IF;

Line 230: -- iby_security_pkg.get_hash(bank_account_num, 'F'),

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'),
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;

Line 232: -- iby_security_pkg.get_hash(bank_account_num, 'T')

228: --SELECT bank_account_num,
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,

Line 238: -- iby_security_pkg.get_hash(iban, 'F'),

234: --WHERE bank_account_num IS NOT NULL;
235:
236: --SELECT iban,
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;

Line 240: -- iby_security_pkg.get_hash(iban, 'T')

236: --SELECT iban,
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

Line 266: SET bank_account_num_hash1 = iby_security_pkg.get_hash(bank_acct_rec.bank_account_number, 'F'),

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;
270:

Line 267: bank_account_num_hash2 = iby_security_pkg.get_hash(bank_acct_rec.bank_account_number, 'T'),

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;
270:
271: END IF;

Line 278: SET iban_hash1 = iby_security_pkg.get_hash(bank_acct_rec.iban, 'F'),

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:
282: END IF;

Line 279: iban_hash2 = iby_security_pkg.get_hash(bank_acct_rec.iban, 'T')

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:
282: END IF;
283:

Line 298: -- iby_security_pkg.get_hash(instrnumber, 'F')

294: --IBY_TRXN_SUMMARIES_ALL INSTRNUM_HASH INSTRNUMBER
295: ----------------------------------------------------------------------------------------
296: --SELECT instrnumber,
297: -- instrnum_hash,
298: -- iby_security_pkg.get_hash(instrnumber, 'F')
299: --FROM iby_trxn_summaries_all
300: --WHERE instrnumber IS NOT NULL;
301:
302: IF (p_transactions_flag = 'Y') THEN

Line 323: SET instrnum_hash = iby_security_pkg.get_hash(bank_acct_rec.bank_account_number, 'F'),

319: IF (bank_acct_rec.bank_account_number IS NOT NULL AND bank_acct_rec.bank_account_number2 IS NOT NULL)
320: THEN
321: l_count2 := l_count2 + 1 ;
322: UPDATE iby_trxn_summaries_all
323: SET instrnum_hash = iby_security_pkg.get_hash(bank_acct_rec.bank_account_number, 'F'),
324: salt_version = 2
325: WHERE trxnmid = bank_acct_rec.trxnmid;
326:
327: END IF;

Line 343: SET instrnum_hash = iby_security_pkg.get_hash(credit_card_rec.credit_card_number, 'F'),

339: THEN
340:
341: l_count3 := l_count3 + 1 ;
342: UPDATE iby_trxn_summaries_all
343: SET instrnum_hash = iby_security_pkg.get_hash(credit_card_rec.credit_card_number, 'F'),
344: salt_version = 2
345: WHERE trxnmid = credit_card_rec.trxnmid;
346:
347: END IF;

Line 405: l_system_salt_version := IBY_SECURITY_PKG.Get_Salt_Version;

401: l_system_salt_version NUMBER;
402: BEGIN
403: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_INFO,l_module_name);
404:
405: l_system_salt_version := IBY_SECURITY_PKG.Get_Salt_Version;
406: iby_debug_pub.add('Version of existing hash: '||l_system_salt_version,iby_debug_pub.G_LEVEL_INFO,l_module_name);
407:
408: IF (l_system_salt_version =3) THEN
409: iby_debug_pub.add('Latest version of hash data already present. Exiting..'

Line 523: l_site_salt := IBY_SECURITY_PKG.Get_Site_Salt;

519:
520: x_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
521:
522: -- cache site salt value
523: l_site_salt := IBY_SECURITY_PKG.Get_Site_Salt;
524:
525: BEGIN
526: ad_parallel_updates_pkg.initialize_rowid_range(
527: ad_parallel_updates_pkg.ROWID_RANGE,

Line 554: SET cc_number_hash1 = IBY_SECURITY_PKG.Compute_New_Hash(l_ccnum_hash1_tbl(i),l_site_salt),

550: t1 := systimestamp;
551: IF (l_instrid_tbl.count>0) THEN
552: FORALL i IN l_instrid_tbl.first..l_instrid_tbl.last
553: UPDATE iby_creditcard
554: SET cc_number_hash1 = IBY_SECURITY_PKG.Compute_New_Hash(l_ccnum_hash1_tbl(i),l_site_salt),
555: cc_number_hash2 = IBY_SECURITY_PKG.Compute_New_Hash(l_ccnum_hash2_tbl(i),l_site_salt),
556: salt_version = 3
557: WHERE instrid=l_instrid_tbl(i);
558: END IF;

Line 555: cc_number_hash2 = IBY_SECURITY_PKG.Compute_New_Hash(l_ccnum_hash2_tbl(i),l_site_salt),

551: IF (l_instrid_tbl.count>0) THEN
552: FORALL i IN l_instrid_tbl.first..l_instrid_tbl.last
553: UPDATE iby_creditcard
554: SET cc_number_hash1 = IBY_SECURITY_PKG.Compute_New_Hash(l_ccnum_hash1_tbl(i),l_site_salt),
555: cc_number_hash2 = IBY_SECURITY_PKG.Compute_New_Hash(l_ccnum_hash2_tbl(i),l_site_salt),
556: salt_version = 3
557: WHERE instrid=l_instrid_tbl(i);
558: END IF;
559:

Line 625: l_system_salt_version := IBY_SECURITY_PKG.Get_Salt_Version;

621: l_system_salt_version NUMBER;
622: BEGIN
623: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_INFO,l_module_name);
624:
625: l_system_salt_version := IBY_SECURITY_PKG.Get_Salt_Version;
626: iby_debug_pub.add('Version of existing hash: '||l_system_salt_version,iby_debug_pub.G_LEVEL_INFO,l_module_name);
627:
628: IF (l_system_salt_version =3) THEN
629: iby_debug_pub.add('Latest version of hash data already present. Exiting..'

Line 740: l_site_salt := IBY_SECURITY_PKG.Get_Site_Salt;

736:
737: x_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
738:
739: -- cache site salt value
740: l_site_salt := IBY_SECURITY_PKG.Get_Site_Salt;
741:
742: BEGIN
743: ad_parallel_updates_pkg.initialize_rowid_range(
744: ad_parallel_updates_pkg.ROWID_RANGE,

Line 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)),

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)),
776: salt_version = 3

Line 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)),

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)),
776: salt_version = 3
777: WHERE ext_bank_account_id=l_instrid_tbl(i);

Line 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)),

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)),
776: salt_version = 3
777: WHERE ext_bank_account_id=l_instrid_tbl(i);
778: END IF;

Line 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)),

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)),
776: salt_version = 3
777: WHERE ext_bank_account_id=l_instrid_tbl(i);
778: END IF;
779: