eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_PARTY_API dependencies on PER_BUSINESS_GROUPS

Line 119: l_legislation_code per_business_groups_perf.legislation_code%type;

115: l_comment_id per_all_people_f.comment_id%type;
116: l_name_combination_warning boolean;
117: l_orig_hire_warning boolean;
118: l_assign_payroll_warning boolean;
119: l_legislation_code per_business_groups_perf.legislation_code%type;
120: l_ptu_person_type_id number(15);
121: l_employee_number per_all_people_f.employee_number%type := hr_api.g_varchar2;
122: --
123: -- for disabling the descriptive flex field

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

123: -- for disabling the descriptive flex field
124: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=
125: hr_dflex_utility.l_ignore_dfcode_varray();
126: --
127: -- cursor to select the legislation from per_business_groups_perf
128: -- corresponding to the business group
129: --
130: cursor csr_legislation_code(p_business_group_id number) is
131: select legislation_code

Line 132: from per_business_groups_perf

128: -- corresponding to the business group
129: --
130: cursor csr_legislation_code(p_business_group_id number) is
131: select legislation_code
132: from per_business_groups_perf
133: where business_group_id = p_business_group_id;
134: --
135: -- cursor to select the person_type_id from hr_organization_inforamtion
136: -- corresponding to the recruiting flexfield on the business group

Line 873: l_legislation_code per_business_groups_perf.legislation_code%type;

869: l_full_name per_all_people_f.full_name%type;
870: l_comment_id per_all_people_f.comment_id%type;
871: l_name_combination_warning boolean;
872: l_orig_hire_warning boolean;
873: l_legislation_code per_business_groups_perf.legislation_code%type;
874: l_ptu_person_type_id number(15);
875: --
876: -- for disabling the descriptive flex field
877: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=

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

876: -- for disabling the descriptive flex field
877: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=
878: hr_dflex_utility.l_ignore_dfcode_varray();
879: --
880: -- cursor to select the legislation from per_business_groups_perf
881: -- corresponding to the business group
882: --
883: cursor csr_legislation_code(p_business_group_id number) is
884: select legislation_code

Line 885: from per_business_groups_perf

881: -- corresponding to the business group
882: --
883: cursor csr_legislation_code(p_business_group_id number) is
884: select legislation_code
885: from per_business_groups_perf
886: where business_group_id = p_business_group_id;
887: --
888: -- cursor to select the person_type_id from hr_organization_inforamtion
889: -- corresponding to the recruiting flexfield on the business group

Line 1374: l_legislation_code per_business_groups.legislation_code%type;

1370: l_proc varchar2(72) := g_package||'update_registered_user';
1371: l_object_version_number per_all_people_f.object_version_number%TYPE;
1372: l_employee_number per_all_people_f.employee_number%TYPE;
1373: l_effective_date date;
1374: l_legislation_code per_business_groups.legislation_code%type;
1375: -- sex is defaulted to null - it is set to the value of sex
1376: -- on per_all_people_f if p_gender exists in hr_lookups
1377: l_sex per_all_people_f.sex%TYPE := hr_api.g_varchar2;
1378: l_last_name_phonetic hz_person_profiles.person_last_name_phonetic%type

Line 2068: l_legislation_code per_business_groups.legislation_code%type;

2064: l_grade_id per_all_vacancies.grade_id%type;
2065: l_location_id per_all_vacancies.location_id%type;
2066: l_recruiter_id per_all_vacancies.recruiter_id%type;
2067: l_people_group_id per_all_vacancies.people_group_id%type;
2068: l_legislation_code per_business_groups.legislation_code%type;
2069: --
2070: -- variables for hr_person_api.update_person
2071: --
2072: l_object_version_number per_all_people_f.object_version_number%TYPE;

Line 2108: l_time_normal_finish per_business_groups.default_end_time%TYPE;

2104: -- for disabling the key flex field
2105: l_add_struct_k hr_kflex_utility.l_ignore_kfcode_varray :=
2106: hr_kflex_utility.l_ignore_kfcode_varray();
2107: --
2108: l_time_normal_finish per_business_groups.default_end_time%TYPE;
2109: l_time_normal_start per_business_groups.default_start_time%TYPE;
2110: l_normal_hours number;
2111: l_frequency per_business_groups.frequency%TYPE;
2112: --

Line 2109: l_time_normal_start per_business_groups.default_start_time%TYPE;

2105: l_add_struct_k hr_kflex_utility.l_ignore_kfcode_varray :=
2106: hr_kflex_utility.l_ignore_kfcode_varray();
2107: --
2108: l_time_normal_finish per_business_groups.default_end_time%TYPE;
2109: l_time_normal_start per_business_groups.default_start_time%TYPE;
2110: l_normal_hours number;
2111: l_frequency per_business_groups.frequency%TYPE;
2112: --
2113: -- cursor to select entries IN per_all_people_f

Line 2111: l_frequency per_business_groups.frequency%TYPE;

2107: --
2108: l_time_normal_finish per_business_groups.default_end_time%TYPE;
2109: l_time_normal_start per_business_groups.default_start_time%TYPE;
2110: l_normal_hours number;
2111: l_frequency per_business_groups.frequency%TYPE;
2112: --
2113: -- cursor to select entries IN per_all_people_f
2114: -- relating to registered user
2115: --

Line 2208: FROM per_business_groups bus

2204: SELECT bus.default_start_time
2205: , bus.default_end_time
2206: , fnd_number.canonical_to_number(bus.working_hours)
2207: , bus.frequency
2208: FROM per_business_groups bus
2209: WHERE bus.business_group_id = p_business_group_id;
2210: --
2211: --
2212: begin

Line 6200: l_legislation_code per_business_groups.legislation_code%type;

6196: l_grade_id per_all_vacancies.grade_id%type;
6197: l_location_id per_all_vacancies.location_id%type;
6198: l_recruiter_id per_all_vacancies.recruiter_id%type;
6199: l_people_group_id per_all_vacancies.people_group_id%type;
6200: l_legislation_code per_business_groups.legislation_code%type;
6201: l_effective_date date;
6202: --
6203: -- variables for hr_person_api.update_person
6204: --

Line 6235: l_time_normal_finish per_business_groups.default_end_time%TYPE;

6231: -- for disabling the key flex field
6232: l_add_struct_k hr_kflex_utility.l_ignore_kfcode_varray :=
6233: hr_kflex_utility.l_ignore_kfcode_varray();
6234: --
6235: l_time_normal_finish per_business_groups.default_end_time%TYPE;
6236: l_time_normal_start per_business_groups.default_start_time%TYPE;
6237: l_normal_hours number;
6238: l_frequency per_business_groups.frequency%TYPE;
6239: l_per_information4 per_all_people_f.per_information4%type;

Line 6236: l_time_normal_start per_business_groups.default_start_time%TYPE;

6232: l_add_struct_k hr_kflex_utility.l_ignore_kfcode_varray :=
6233: hr_kflex_utility.l_ignore_kfcode_varray();
6234: --
6235: l_time_normal_finish per_business_groups.default_end_time%TYPE;
6236: l_time_normal_start per_business_groups.default_start_time%TYPE;
6237: l_normal_hours number;
6238: l_frequency per_business_groups.frequency%TYPE;
6239: l_per_information4 per_all_people_f.per_information4%type;
6240:

Line 6238: l_frequency per_business_groups.frequency%TYPE;

6234: --
6235: l_time_normal_finish per_business_groups.default_end_time%TYPE;
6236: l_time_normal_start per_business_groups.default_start_time%TYPE;
6237: l_normal_hours number;
6238: l_frequency per_business_groups.frequency%TYPE;
6239: l_per_information4 per_all_people_f.per_information4%type;
6240:
6241: --
6242: -- cursor to select entries IN per_all_people_f

Line 6316: FROM per_business_groups bus

6312: SELECT bus.default_start_time
6313: , bus.default_end_time
6314: , fnd_number.canonical_to_number(bus.working_hours)
6315: , bus.frequency
6316: FROM per_business_groups bus
6317: WHERE bus.business_group_id = p_business_group_id;
6318: --
6319: begin
6320: --

Line 6586: from per_business_groups pbg

6582: );
6583: end if;
6584: else
6585: select pbg.legislation_code into l_legislation_code
6586: from per_business_groups pbg
6587: where pbg.business_group_id = p_business_group_id;
6588: --
6589: l_applicant_number:=null;
6590: if (l_legislation_code = 'JP') then