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_CREDITCARD

Line 35: l_cc_id iby_creditcard.instrid%TYPE;

31:
32: l_count1 NUMBER;
33: l_count2 NUMBER;
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;

Line 36: l_cc_num iby_creditcard.ccnumber%TYPE;

32: l_count1 NUMBER;
33: l_count2 NUMBER;
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:

Line 49: iby_creditcard_pkg.uncipher_ccnumber

45:
46: CURSOR get_credit_cards(p_sys_key iby_view_parameters_gt.value%TYPE) IS
47: SELECT
48: b.instrid instrid,
49: iby_creditcard_pkg.uncipher_ccnumber
50: (
51: instrid,
52: p_sys_key
53: ) credit_card_number,

Line 56: iby_creditcard b;

52: p_sys_key
53: ) credit_card_number,
54: b.ccnumber credit_card_number2
55: FROM
56: iby_creditcard b;
57:
58: CURSOR get_bank_accounts(p_sys_key iby_view_parameters_gt.value%TYPE) IS
59: SELECT
60: b.ext_bank_account_id ext_bank_account_id,

Line 110: iby_creditcard_issuers_b i

106: FROM iby_trxn_summaries_all tx,
107: iby_security_segments seg,
108: iby_sys_security_subkeys k,
109: iby_cc_issuer_ranges r,
110: iby_creditcard_issuers_b i
111: WHERE (NOT instrnum_sec_segment_id IS NULL)
112: AND (tx.instrnum_sec_segment_id = seg.sec_segment_id(+))
113: AND (seg.sec_subkey_id = k.sec_subkey_id(+))
114: AND (tx.cc_issuer_range_id = r.cc_issuer_range_id(+))

Line 175: --IBY_CREDITCARD CC_NUMBER_HASH1 CCNUMBER

171:
172: ----------------------------------------------------------------------------------------
173: --TABLE_NAME COLUMN_NAME COLUMN_NAME_REF
174: ----------------------------------------------------------------------------------------
175: --IBY_CREDITCARD CC_NUMBER_HASH1 CCNUMBER
176: --IBY_CREDITCARD CC_NUMBER_HASH2 CCNUMBER
177: ----------------------------------------------------------------------------------------
178: --SELECT ccnumber,
179: -- cc_number_hash1,

Line 176: --IBY_CREDITCARD CC_NUMBER_HASH2 CCNUMBER

172: ----------------------------------------------------------------------------------------
173: --TABLE_NAME COLUMN_NAME COLUMN_NAME_REF
174: ----------------------------------------------------------------------------------------
175: --IBY_CREDITCARD CC_NUMBER_HASH1 CCNUMBER
176: --IBY_CREDITCARD CC_NUMBER_HASH2 CCNUMBER
177: ----------------------------------------------------------------------------------------
178: --SELECT ccnumber,
179: -- cc_number_hash1,
180: -- iby_security_pkg.get_hash(ccnumber, 'F'),

Line 183: --FROM iby_creditcard

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
187:

Line 192: UPDATE iby_creditcard

188: print_debuginfo(l_module_name, 'Regenerating hash for credit cards ...');
189: l_count1 := 0 ;
190: l_count2 := 0 ;
191:
192: UPDATE iby_creditcard
193: SET cc_number_hash1 = NULL,
194: cc_number_hash2 = NULL;
195:
196: FOR credit_card_rec IN get_credit_cards(l_sys_key)

Line 204: UPDATE iby_creditcard

200: IF (credit_card_rec.credit_card_number IS NOT NULL)
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;

Line 466: l_table_name VARCHAR2(30) := 'IBY_CREDITCARD';

462: l_batch_size NUMBER;
463: l_worker_id NUMBER;
464: l_num_workers NUMBER;
465: l_any_rows_to_process BOOLEAN;
466: l_table_name VARCHAR2(30) := 'IBY_CREDITCARD';
467: l_script_name VARCHAR2(30);
468: l_product VARCHAR2(10) := 'IBY';
469: l_status VARCHAR2(30);
470: l_industry VARCHAR2(30);

Line 496: FROM iby_creditcard

492: IS
493: SELECT instrid,
494: cc_number_hash1,
495: cc_number_hash2
496: FROM iby_creditcard
497: WHERE NVL(salt_version,1) = 2
498: AND (rowid BETWEEN ci_start_rowid AND ci_end_rowid);
499: BEGIN
500: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_INFO,l_module_name);

Line 553: UPDATE iby_creditcard

549: iby_debug_pub.add('rows fetched:='||l_instrid_tbl.COUNT,iby_debug_pub.G_LEVEL_INFO,l_module_name);
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);

Line 593: SELECT COUNT(1) INTO l_pending_cc FROM iby_creditcard WHERE NVL(salt_version,1) <> 3;

589:
590: -- If entire data has been upgarded then turn on the system switch to use
591: -- new hashing logic
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

Line 813: SELECT COUNT(1) INTO l_pending_cc FROM iby_creditcard WHERE NVL(salt_version,1) <> 3;

809:
810: -- If entire data has been upgarded then turn on the system switch to use
811: -- new hashing logic
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