DBA Data[Home] [Help]

APPS.IBY_HASH_REGENERATOR dependencies on IBY_UTILITY_PVT

Line 120: iby_utility_pvt.decode64(instrnumber) credit_card_number,

116: AND tx.instrtype = 'CREDITCARD'
117: AND tx.instrnumber IS NOT NULL
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'

Line 129: iby_utility_pvt.decode64(instrnumber) bank_account_number,

125: AND tx.instrnumber IS NOT NULL;
126:
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'

Line 165: --l_sys_key := iby_utility_pvt.get_view_param('SYS_KEY');

161: END IF ;
162:
163: print_debuginfo(l_module_name, 'Initiating hash regeneration processes ');
164:
165: --l_sys_key := iby_utility_pvt.get_view_param('SYS_KEY');
166: l_sys_key := p_sys_key;
167: --print_debuginfo(l_module_name, 'System Key : ' || l_sys_key);
168:
169: UPDATE iby_sys_security_options SET system_salt_version = 2;