APPS.IRC_PARTY_API dependencies on PER_BUSINESS_GROUPS

Line 114: l_legislation_code per_business_groups_perf.legislation_code%type;

110: l_comment_id per_all_people_f.comment_id%type;
111: l_name_combination_warning boolean;
112: l_orig_hire_warning boolean;
113: l_assign_payroll_warning boolean;
114: l_legislation_code per_business_groups_perf.legislation_code%type;
115: l_ptu_person_type_id number(15);
116: l_employee_number per_all_people_f.employee_number%type := hr_api.g_varchar2;
117: --
118: -- for disabling the descriptive flex field

Line 122: -- cursor to select the legislation from per_business_groups_perf

118: -- for disabling the descriptive flex field
119: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=
120: hr_dflex_utility.l_ignore_dfcode_varray();
121: --
122: -- cursor to select the legislation from per_business_groups_perf
123: -- corresponding to the business group
124: --
125: cursor csr_legislation_code(p_business_group_id number) is
126: select legislation_code

Line 127: from per_business_groups_perf

123: -- corresponding to the business group
124: --
125: cursor csr_legislation_code(p_business_group_id number) is
126: select legislation_code
127: from per_business_groups_perf
128: where business_group_id = p_business_group_id;
129: --
130: -- cursor to select the person_type_id from hr_organization_inforamtion
131: -- corresponding to the recruiting flexfield on the business group

Line 846: l_legislation_code per_business_groups_perf.legislation_code%type;

842: l_full_name per_all_people_f.full_name%type;
843: l_comment_id per_all_people_f.comment_id%type;
844: l_name_combination_warning boolean;
845: l_orig_hire_warning boolean;
846: l_legislation_code per_business_groups_perf.legislation_code%type;
847: l_ptu_person_type_id number(15);
848: --
849: -- for disabling the descriptive flex field
850: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=

Line 853: -- cursor to select the legislation from per_business_groups_perf

849: -- for disabling the descriptive flex field
850: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=
851: hr_dflex_utility.l_ignore_dfcode_varray();
852: --
853: -- cursor to select the legislation from per_business_groups_perf
854: -- corresponding to the business group
855: --
856: cursor csr_legislation_code(p_business_group_id number) is
857: select legislation_code

Line 858: from per_business_groups_perf

854: -- corresponding to the business group
855: --
856: cursor csr_legislation_code(p_business_group_id number) is
857: select legislation_code
858: from per_business_groups_perf
859: where business_group_id = p_business_group_id;
860: --
861: -- cursor to select the person_type_id from hr_organization_inforamtion
862: -- corresponding to the recruiting flexfield on the business group

Line 1347: l_legislation_code per_business_groups.legislation_code%type;

1343: l_proc varchar2(72) := g_package||'update_registered_user';
1344: l_object_version_number per_all_people_f.object_version_number%TYPE;
1345: l_employee_number per_all_people_f.employee_number%TYPE;
1346: l_effective_date date;
1347: l_legislation_code per_business_groups.legislation_code%type;
1348: -- sex is defaulted to null - it is set to the value of sex
1349: -- on per_all_people_f if p_gender exists in hr_lookups
1350: l_sex per_all_people_f.sex%TYPE := hr_api.g_varchar2;
1351: l_last_name_phonetic hz_person_profiles.person_last_name_phonetic%type

Line 2042: l_legislation_code per_business_groups.legislation_code%type;

2038: l_grade_id per_all_vacancies.grade_id%type;
2039: l_location_id per_all_vacancies.location_id%type;
2040: l_recruiter_id per_all_vacancies.recruiter_id%type;
2041: l_people_group_id per_all_vacancies.people_group_id%type;
2042: l_legislation_code per_business_groups.legislation_code%type;
2043: --
2044: -- variables for hr_person_api.update_person
2045: --
2046: l_object_version_number per_all_people_f.object_version_number%TYPE;