[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;
1004: --
1005: begin
1006: select null into dummy from dual where exists
1007: (select null
1008: from ff_globals_f a
1009: where a.global_name = p_item_name
1010: and
1011: ( startup_mode = 'MASTER'
1012: or
1037: exception
1038: when no_data_found then
1039: select null into dummy from dual where exists
1040: (select null
1041: from ff_globals_f a
1042: , ff_globals_f_tl b
1043: where b.global_name = p_item_name
1044: and a.global_id = b.global_id
1045: and
1038: when no_data_found then
1039: select null into dummy from dual where exists
1040: (select null
1041: from ff_globals_f a
1042: , ff_globals_f_tl b
1043: where b.global_name = p_item_name
1044: and a.global_id = b.global_id
1045: and
1046: ( startup_mode = 'MASTER'
1111: --
1112: begin
1113: select null into dummy from dual where exists
1114: (select null
1115: from ff_globals_f a
1116: where a.global_name = p_item_name
1117: and a.global_id <> p_global_id
1118: and
1119: ( startup_mode = 'MASTER'
1145: exception
1146: when no_data_found then
1147: select null into dummy from dual where exists
1148: (select null
1149: from ff_globals_f a
1150: , ff_globals_f_tl b
1151: where b.global_name = p_item_name
1152: and a.global_id = b.global_id
1153: and a.global_id <> p_global_id
1146: when no_data_found then
1147: select null into dummy from dual where exists
1148: (select null
1149: from ff_globals_f a
1150: , ff_globals_f_tl b
1151: where b.global_name = p_item_name
1152: and a.global_id = b.global_id
1153: and a.global_id <> p_global_id
1154: and