DBA Data[Home] [Help]

APPS.FND_FLEX_SERVER dependencies on FND_FLEX_HASH

Line 561: SELECT hash_value INTO hash_num FROM fnd_flex_hash

557: end loop;
558:
559: hash_number := hash_segs(nsegs, segids);
560: if(hash_number >= 0) then
561: SELECT hash_value INTO hash_num FROM fnd_flex_hash
562: WHERE hash_value = hash_number FOR UPDATE;
563: end if;
564: return(hash_number);
565:

Line 1380: SELECT hash_value INTO hash_num FROM fnd_flex_hash

1376:
1377: IF (fnd_flex_server1.g_debug_level > 0) THEN
1378: FND_FLEX_SERVER1.add_debug('Hash value = '||to_char(hash_number)||'.');
1379: END IF;
1380: SELECT hash_value INTO hash_num FROM fnd_flex_hash
1381: WHERE hash_value = hash_number FOR UPDATE;
1382:
1383: -- Double-check to see if it has been created.
1384: -- No where clause this time.

Line 2773: SELECT hash_value INTO hash_num FROM fnd_flex_hash

2769:
2770: IF (fnd_flex_server1.g_debug_level > 0) THEN
2771: FND_FLEX_SERVER1.add_debug('Hash value = '||to_char(hash_number)||'.');
2772: END IF;
2773: SELECT hash_value INTO hash_num FROM fnd_flex_hash
2774: WHERE hash_value = hash_number FOR UPDATE;
2775:
2776: -- Double-check to see if it has been created. No where clause this time.
2777: --

Line 4239: FROM fnd_flex_hash

4235: --
4236: BEGIN
4237: SELECT hash_value
4238: INTO l_num
4239: FROM fnd_flex_hash
4240: WHERE hash_value = l_hash_value
4241: FOR UPDATE;
4242: EXCEPTION
4243: WHEN OTHERS THEN

Line 4246: ' is unable to lock FND_FLEX_HASH. ' ||

4242: EXCEPTION
4243: WHEN OTHERS THEN
4244: fnd_message.set_name('FND', 'FLEX-USER DEFINED ERROR');
4245: fnd_message.set_token('MSG', l_func_name ||
4246: ' is unable to lock FND_FLEX_HASH. ' ||
4247: 'Hash Value: ' || l_hash_value || l_newline ||
4248: 'SQLERRM: ' || Sqlerrm);
4249: GOTO return_failure;
4250: END;