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 2748: SELECT hash_value INTO hash_num FROM fnd_flex_hash

2744:
2745: IF (fnd_flex_server1.g_debug_level > 0) THEN
2746: FND_FLEX_SERVER1.add_debug('Hash value = '||to_char(hash_number)||'.');
2747: END IF;
2748: SELECT hash_value INTO hash_num FROM fnd_flex_hash
2749: WHERE hash_value = hash_number FOR UPDATE;
2750:
2751: -- Double-check to see if it has been created. No where clause this time.
2752: --

Line 4210: FROM fnd_flex_hash

4206: --
4207: BEGIN
4208: SELECT hash_value
4209: INTO l_num
4210: FROM fnd_flex_hash
4211: WHERE hash_value = l_hash_value
4212: FOR UPDATE;
4213: EXCEPTION
4214: WHEN OTHERS THEN

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

4213: EXCEPTION
4214: WHEN OTHERS THEN
4215: fnd_message.set_name('FND', 'FLEX-USER DEFINED ERROR');
4216: fnd_message.set_token('MSG', l_func_name ||
4217: ' is unable to lock FND_FLEX_HASH. ' ||
4218: 'Hash Value: ' || l_hash_value || l_newline ||
4219: 'SQLERRM: ' || Sqlerrm);
4220: GOTO return_failure;
4221: END;