[Home] [Help]
9: tmp_leg_code ff_user_entities.legislation_code%TYPE;
10: --
11: -- Temporary storage for global database item information.
12: --
13: g_glb_id ff_globals_f.global_id%TYPE;
14: g_glb_ueid ff_user_entities.user_entity_id%TYPE;
15: g_glb_dbi ff_database_items.user_name%TYPE;
16: --
17: g_debug boolean := hr_utility.debug_enabled;
1005: --
1006: begin
1007: select null into dummy from dual where exists
1008: (select null
1009: from ff_globals_f a
1010: where a.global_name = p_item_name
1011: and
1012: ( startup_mode = 'MASTER'
1013: or
1038: exception
1039: when no_data_found then
1040: select null into dummy from dual where exists
1041: (select null
1042: from ff_globals_f a
1043: , ff_globals_f_tl b
1044: where b.global_name = p_item_name
1045: and a.global_id = b.global_id
1046: and
1039: when no_data_found then
1040: select null into dummy from dual where exists
1041: (select null
1042: from ff_globals_f a
1043: , ff_globals_f_tl b
1044: where b.global_name = p_item_name
1045: and a.global_id = b.global_id
1046: and
1047: ( startup_mode = 'MASTER'
1112: --
1113: begin
1114: select null into dummy from dual where exists
1115: (select null
1116: from ff_globals_f a
1117: where a.global_name = p_item_name
1118: and a.global_id <> p_global_id
1119: and
1120: ( startup_mode = 'MASTER'
1146: exception
1147: when no_data_found then
1148: select null into dummy from dual where exists
1149: (select null
1150: from ff_globals_f a
1151: , ff_globals_f_tl b
1152: where b.global_name = p_item_name
1153: and a.global_id = b.global_id
1154: and a.global_id <> p_global_id
1147: when no_data_found then
1148: select null into dummy from dual where exists
1149: (select null
1150: from ff_globals_f a
1151: , ff_globals_f_tl b
1152: where b.global_name = p_item_name
1153: and a.global_id = b.global_id
1154: and a.global_id <> p_global_id
1155: and