APPS.HR_PERSON_NAME dependencies on HR_API

Line 418: if l_user_format_choice <> nvl(g_user_format_choice_cached,hr_api.g_varchar2) then

414: else
415: l_user_format_choice := p_user_format_choice;
416: end if;
417: --
418: if l_user_format_choice <> nvl(g_user_format_choice_cached,hr_api.g_varchar2) then
419: l_retrieve_flag := 'Y';
420: g_user_format_choice_cached := l_user_format_choice;
421: end if;
422: --

Line 434: if l_person_rec.business_group_id <> nvl(g_business_group_id_cached,hr_api.g_number) then

430: else
431: RETURN l_person_rec.global_name;
432: end if;
433: else
434: if l_person_rec.business_group_id <> nvl(g_business_group_id_cached,hr_api.g_number) then
435: g_business_group_id_cached := l_person_rec.business_group_id;
436: l_legislation_code := hr_api.return_legislation_code(l_person_rec.business_group_id);
437: if l_legislation_code <> nvl(g_legislation_code_cached,hr_api.g_varchar2) then
438: l_retrieve_flag := 'Y';

Line 436: l_legislation_code := hr_api.return_legislation_code(l_person_rec.business_group_id);

432: end if;
433: else
434: if l_person_rec.business_group_id <> nvl(g_business_group_id_cached,hr_api.g_number) then
435: g_business_group_id_cached := l_person_rec.business_group_id;
436: l_legislation_code := hr_api.return_legislation_code(l_person_rec.business_group_id);
437: if l_legislation_code <> nvl(g_legislation_code_cached,hr_api.g_varchar2) then
438: l_retrieve_flag := 'Y';
439: g_legislation_code_cached := l_legislation_code;
440: end if;

Line 437: if l_legislation_code <> nvl(g_legislation_code_cached,hr_api.g_varchar2) then

433: else
434: if l_person_rec.business_group_id <> nvl(g_business_group_id_cached,hr_api.g_number) then
435: g_business_group_id_cached := l_person_rec.business_group_id;
436: l_legislation_code := hr_api.return_legislation_code(l_person_rec.business_group_id);
437: if l_legislation_code <> nvl(g_legislation_code_cached,hr_api.g_varchar2) then
438: l_retrieve_flag := 'Y';
439: g_legislation_code_cached := l_legislation_code;
440: end if;
441: end if;

Line 444: if p_format_name <> nvl(g_format_name_cached,hr_api.g_varchar2) then

440: end if;
441: end if;
442: end if;
443: --
444: if p_format_name <> nvl(g_format_name_cached,hr_api.g_varchar2) then
445: l_retrieve_flag := 'Y';
446: g_format_name_cached := p_format_name;
447: end if;
448: --

Line 1058: l_legislation_code := hr_api.return_legislation_code(p_business_group_id);

1054: l_gen_all_per_cols := 'Y';
1055: else
1056: l_gen_all_per_cols := 'N';
1057: end if;
1058: l_legislation_code := hr_api.return_legislation_code(p_business_group_id);
1059: -- -------------------------------------------------------------------+
1060: -- Derive FULL_NAME
1061: -- -------------------------------------------------------------------+
1062: if l_format_name = g_FULL_NAME or l_gen_all_per_cols = 'Y' then

Line 1253: l_legislation_code VARCHAR2(10) := HR_API.GET_LEGISLATION_CONTEXT;

1249: -- ----------------------------------------------------------------------- +
1250: if fnd_profile.value('HR_CROSS_BUSINESS_GROUP') = 'N' then
1251: declare
1252: -- bug 3988762
1253: l_legislation_code VARCHAR2(10) := HR_API.GET_LEGISLATION_CONTEXT;
1254: begin
1255: --
1256: l_first_char := substr( p_last_name , 1 , 1 ) ;
1257: l_second_char := substr( p_last_name , 2 , 1 ) ;

Line 1922: l_legislation_code := hr_api.return_legislation_code(p_business_group_id);

1918: l_gen_all_per_cols := 'Y';
1919: else
1920: l_gen_all_per_cols := 'N';
1921: end if;
1922: l_legislation_code := hr_api.return_legislation_code(p_business_group_id);
1923: -- -------------------------------------------------------------------+
1924: -- Derive FULL_NAME
1925: -- -------------------------------------------------------------------+
1926: if l_format_name = g_FULL_NAME or l_gen_all_per_cols = 'Y' then