50: select legislation_code
51: from per_business_groups_perf
52: where business_group_id = p_business_group_id;
53: begin
54: hr_api.mandatory_arg_error('get_balance_value', 'business_group_id', p_business_group_id);
55: --
56: open csr_legislation_code;
57: fetch csr_legislation_code into l_legislation_code;
58: if csr_legislation_code%NOTFOUND then
588: and fai.value is not null;
589: --
590: begin
591: --
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);
589: --
590: begin
591: --
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);
685: --
686: l_cache := 'N';
687: l_archive := 'N';
688: --
689: hr_api.mandatory_arg_error('get_balance_value', 'assignment_action_id', p_assignment_action_id);
690: hr_api.mandatory_arg_error('get_balance_value', 'defined_balance_id', p_defined_balance_id);
691: --
692: if g_business_group_id is null then
693: l_cache := 'Y';
686: l_cache := 'N';
687: l_archive := 'N';
688: --
689: hr_api.mandatory_arg_error('get_balance_value', 'assignment_action_id', p_assignment_action_id);
690: hr_api.mandatory_arg_error('get_balance_value', 'defined_balance_id', p_defined_balance_id);
691: --
692: if g_business_group_id is null then
693: l_cache := 'Y';
694: else
763: begin
764: --
765: l_cache := 'N';
766: --
767: hr_api.mandatory_arg_error('get_balance_value', 'assignment_action_id', p_assignment_action_id);
768: hr_api.mandatory_arg_error('get_balance_value', 'balance_name', p_balance_name);
769: hr_api.mandatory_arg_error('get_balance_value', 'dimension_name', p_dimension_name);
770: --
771: if g_business_group_id is null then
764: --
765: l_cache := 'N';
766: --
767: hr_api.mandatory_arg_error('get_balance_value', 'assignment_action_id', p_assignment_action_id);
768: hr_api.mandatory_arg_error('get_balance_value', 'balance_name', p_balance_name);
769: hr_api.mandatory_arg_error('get_balance_value', 'dimension_name', p_dimension_name);
770: --
771: if g_business_group_id is null then
772: l_cache := 'Y';
765: l_cache := 'N';
766: --
767: hr_api.mandatory_arg_error('get_balance_value', 'assignment_action_id', p_assignment_action_id);
768: hr_api.mandatory_arg_error('get_balance_value', 'balance_name', p_balance_name);
769: hr_api.mandatory_arg_error('get_balance_value', 'dimension_name', p_dimension_name);
770: --
771: if g_business_group_id is null then
772: l_cache := 'Y';
773: else
868: --
869: l_archive := 'N';
870: l_cache := 'N';
871: --
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);
869: l_archive := 'N';
870: l_cache := 'N';
871: --
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);
964: begin
965: --
966: l_cache := 'N';
967: --
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);
965: --
966: l_cache := 'N';
967: --
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);