APPS.IBY_HASH_REGENERATOR dependencies on IBY_SYS_SECURITY_OPTIONS

Line 169: UPDATE iby_sys_security_options SET system_salt_version = 2;

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;
170:
171:
172: ----------------------------------------------------------------------------------------
173: --TABLE_NAME COLUMN_NAME COLUMN_NAME_REF

Line 599: UPDATE iby_sys_security_options SET system_salt_version=3;

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;
601: ELSE
602: iby_debug_pub.add('There are pending BA records to be processed. Skipping update of system_salt_version.'
603: ,iby_debug_pub.G_LEVEL_INFO,l_module_name);

Line 819: UPDATE iby_sys_security_options SET system_salt_version=3;

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;
821: ELSE
822: iby_debug_pub.add('There are pending BA records to be processed. Skipping update of system_salt_version.'
823: ,iby_debug_pub.G_LEVEL_INFO,l_module_name);