9: g_assignment_action_id number;
10: g_xassignment_action_id number;
11: g_pre_get_balance_value_index number;
12: g_pre_get_dbitem_value_index number;
13: g_debug constant boolean := hr_utility.debug_enabled;
14: --
15: type value_tbl is table of ff_archive_items.value%type index by binary_integer;
16: type balance_name_tbl is table of pay_balance_types.balance_name%type index by binary_integer;
17: type dimension_name_tbl is table of pay_balance_dimensions.dimension_name%type index by binary_integer;
592: hr_api.mandatory_arg_error('get_archive_items', 'assignment_action_id', p_assignment_action_id);
593: hr_api.mandatory_arg_error('get_archive_items', 'user_entity_id', p_user_entity_id);
594:
595: if g_debug then
596: hr_utility.trace('get_archive_items assignment_action_id : ' || p_assignment_action_id);
597: hr_utility.trace('get_archive_items user_entity_id : ' || p_user_entity_id);
598: end if;
599: --
600: -- Cache new information into global variables if cache information is old.
593: hr_api.mandatory_arg_error('get_archive_items', 'user_entity_id', p_user_entity_id);
594:
595: if g_debug then
596: hr_utility.trace('get_archive_items assignment_action_id : ' || p_assignment_action_id);
597: hr_utility.trace('get_archive_items user_entity_id : ' || p_user_entity_id);
598: end if;
599: --
600: -- Cache new information into global variables if cache information is old.
601: --
712: g_legislation_code := legislation_code(p_business_group_id => g_business_group_id);
713: end if;
714: --
715: if g_debug then
716: hr_utility.trace('get_balance_value g_pre_get_balance_value_perf : ' || g_pre_get_balance_value_perf);
717: end if;
718: --
719: if g_pre_get_balance_value_perf = 'Y' then
720: l_business_group_id := g_business_group_id;
785: g_legislation_code := legislation_code(p_business_group_id => g_business_group_id);
786: end if;
787: --
788: if g_debug then
789: hr_utility.trace('get_balance_value g_pre_get_balance_value_perf : ' || g_pre_get_balance_value_perf);
790: end if;
791: --
792: if g_pre_get_balance_value_perf = 'Y' then
793: l_business_group_id := g_business_group_id;
872: hr_api.mandatory_arg_error('get_dbitem_value', 'assignment_action_id', p_assignment_action_id);
873: hr_api.mandatory_arg_error('get_dbitem_value', 'user_entity_id', p_user_entity_id);
874:
875: if g_debug then
876: hr_utility.trace('get_dbitem_value assignment_action_id : ' || p_assignment_action_id);
877: hr_utility.trace('get_dbitem_value user_entity_id : ' || p_user_entity_id);
878: end if;
879: --
880: -- Cache new information into global variables if cache information is old.
873: hr_api.mandatory_arg_error('get_dbitem_value', 'user_entity_id', p_user_entity_id);
874:
875: if g_debug then
876: hr_utility.trace('get_dbitem_value assignment_action_id : ' || p_assignment_action_id);
877: hr_utility.trace('get_dbitem_value user_entity_id : ' || p_user_entity_id);
878: end if;
879: --
880: -- Cache new information into global variables if cache information is old.
881: --
968: hr_api.mandatory_arg_error('get_dbitem_value', 'assignment_action_id', p_assignment_action_id);
969: hr_api.mandatory_arg_error('get_dbitem_value', 'user_name', p_user_name);
970:
971: if g_debug then
972: hr_utility.trace('get_dbitem_value assignment_action_id : ' || p_assignment_action_id);
973: hr_utility.trace('get_dbitem_value user_name : ' || p_user_name);
974: end if;
975: --
976: if g_business_group_id is null then
969: hr_api.mandatory_arg_error('get_dbitem_value', 'user_name', p_user_name);
970:
971: if g_debug then
972: hr_utility.trace('get_dbitem_value assignment_action_id : ' || p_assignment_action_id);
973: hr_utility.trace('get_dbitem_value user_name : ' || p_user_name);
974: end if;
975: --
976: if g_business_group_id is null then
977: l_cache := 'Y';