APPS.IBY_HASH_REGENERATOR dependencies on IBY_TRXN_SUMMARIES_ALL

Line 106: FROM iby_trxn_summaries_all tx,

102: tx.instrnum_sec_segment_id, seg.segment_cipher_text,
103: r.card_number_prefix, NVL(r.card_number_length,tx.instrnum_length),
104: i.digit_check_flag) credit_card_number,
105: tx.instrnumber credit_card_number2
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

Line 122: FROM iby_trxn_summaries_all tx

118: UNION
119: SELECT tx.trxnmid,
120: iby_utility_pvt.decode64(instrnumber) credit_card_number,
121: instrnumber credit_card_number2
122: FROM iby_trxn_summaries_all tx
123: WHERE instrnum_sec_segment_id IS NULL
124: AND tx.instrtype = 'CREDITCARD'
125: AND tx.instrnumber IS NOT NULL;
126:

Line 131: FROM iby_trxn_summaries_all tx

127: CURSOR get_txn_bank_accounts(p_sys_key iby_view_parameters_gt.value%TYPE) IS
128: SELECT tx.trxnmid,
129: iby_utility_pvt.decode64(instrnumber) bank_account_number,
130: instrnumber bank_account_number2
131: FROM iby_trxn_summaries_all tx
132: WHERE instrnum_sec_segment_id IS NULL
133: AND tx.instrtype = 'BANKACCOUNT'
134: AND tx.instrnumber IS NOT NULL
135: UNION

Line 141: FROM iby_trxn_summaries_all tx,

137: iby_ext_bankacct_pub.uncipher_bank_number (
138: tx.instrnumber, tx.instrnum_sec_segment_id, p_sys_key, bak.subkey_cipher_text,
139: bas.segment_cipher_text, bas.encoding_scheme, NULL, NULL ) bank_account_number,
140: tx.instrnumber bank_account_number2
141: FROM iby_trxn_summaries_all tx,
142: iby_security_segments bas,
143: iby_sys_security_subkeys bak
144: WHERE (NOT instrnum_sec_segment_id IS NULL)
145: AND tx.instrnum_sec_segment_id = bas.sec_segment_id(+)

Line 294: --IBY_TRXN_SUMMARIES_ALL INSTRNUM_HASH INSTRNUMBER

290:
291: ----------------------------------------------------------------------------------------
292: --TABLE_NAME COLUMN_NAME COLUMN_NAME_REF
293: ----------------------------------------------------------------------------------------
294: --IBY_TRXN_SUMMARIES_ALL INSTRNUM_HASH INSTRNUMBER
295: ----------------------------------------------------------------------------------------
296: --SELECT instrnumber,
297: -- instrnum_hash,
298: -- iby_security_pkg.get_hash(instrnumber, 'F')

Line 299: --FROM iby_trxn_summaries_all

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
303: print_debuginfo(l_module_name, 'Clearing hash from Transaction table..');

Line 304: UPDATE iby_trxn_summaries_all

300: --WHERE instrnumber IS NOT NULL;
301:
302: IF (p_transactions_flag = 'Y') THEN
303: print_debuginfo(l_module_name, 'Clearing hash from Transaction table..');
304: UPDATE iby_trxn_summaries_all
305: SET instrnum_hash = NULL;
306:
307:
308: /* print_debuginfo(l_module_name, 'Regenerating hash for transactions ...');

Line 313: UPDATE iby_trxn_summaries_all

309: l_count1 := 0 ;
310: l_count2 := 0 ;
311: l_count3 := 0 ;
312:
313: UPDATE iby_trxn_summaries_all
314: SET instrnum_hash = NULL;
315:
316: FOR bank_acct_rec IN get_txn_bank_accounts(l_sys_key)
317: LOOP

Line 322: UPDATE iby_trxn_summaries_all

318: l_count1 := l_count1 + 1 ;
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:

Line 342: UPDATE iby_trxn_summaries_all

338: IF (credit_card_rec.credit_card_number IS NOT NULL AND credit_card_rec.credit_card_number2 IS NOT NULL)
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:

Line 433: iby_debug_pub.add('Removing redundant hash data from iby_trxn_summaries_all..',iby_debug_pub.G_LEVEL_INFO,l_module_name);

429: X_Num_Workers => x_num_workers
430: );
431:
432: iby_debug_pub.add('Submitted Workers..',iby_debug_pub.G_LEVEL_INFO,l_module_name);
433: iby_debug_pub.add('Removing redundant hash data from iby_trxn_summaries_all..',iby_debug_pub.G_LEVEL_INFO,l_module_name);
434: UPDATE iby_trxn_summaries_all SET instrnum_hash = NULL WHERE instrnum_hash IS NOT NULL;
435: iby_debug_pub.add('Records updated='||SQL%ROWCOUNT,iby_debug_pub.G_LEVEL_INFO,l_module_name);
436: COMMIT ;
437:

Line 434: UPDATE iby_trxn_summaries_all SET instrnum_hash = NULL WHERE instrnum_hash IS NOT NULL;

430: );
431:
432: iby_debug_pub.add('Submitted Workers..',iby_debug_pub.G_LEVEL_INFO,l_module_name);
433: iby_debug_pub.add('Removing redundant hash data from iby_trxn_summaries_all..',iby_debug_pub.G_LEVEL_INFO,l_module_name);
434: UPDATE iby_trxn_summaries_all SET instrnum_hash = NULL WHERE instrnum_hash IS NOT NULL;
435: iby_debug_pub.add('Records updated='||SQL%ROWCOUNT,iby_debug_pub.G_LEVEL_INFO,l_module_name);
436: COMMIT ;
437:
438: EXCEPTION