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.HR_PERSON_API dependencies on PER_PEOPLE_F

Line 166: l_business_group_id per_people_f.business_group_id%type;

162: l_person_type_id per_person_types.person_type_id%type :=
163: p_person_type_id;
164: l_person_type_id1 per_person_types.person_type_id%type :=
165: p_person_type_id;
166: l_business_group_id per_people_f.business_group_id%type;
167: l_old_person_type_id per_all_people_f.person_type_id%type;
168: l_current_system_person_type per_person_types.system_person_type%type;
169: l_validate boolean := false;
170: l_discard_varchar2 varchar2(40);

Line 171: l_applicant_number per_people_f.applicant_number%TYPE;

167: l_old_person_type_id per_all_people_f.person_type_id%type;
168: l_current_system_person_type per_person_types.system_person_type%type;
169: l_validate boolean := false;
170: l_discard_varchar2 varchar2(40);
171: l_applicant_number per_people_f.applicant_number%TYPE;
172: l_object_version_number per_people_f.object_version_number%TYPE;
173: l_employee_number per_people_f.employee_number%TYPE;
174: l_npw_number per_people_f.npw_number%TYPE := p_npw_number;
175: l_date_employee_data_verified per_people_f.date_employee_data_verified%TYPE;

Line 172: l_object_version_number per_people_f.object_version_number%TYPE;

168: l_current_system_person_type per_person_types.system_person_type%type;
169: l_validate boolean := false;
170: l_discard_varchar2 varchar2(40);
171: l_applicant_number per_people_f.applicant_number%TYPE;
172: l_object_version_number per_people_f.object_version_number%TYPE;
173: l_employee_number per_people_f.employee_number%TYPE;
174: l_npw_number per_people_f.npw_number%TYPE := p_npw_number;
175: l_date_employee_data_verified per_people_f.date_employee_data_verified%TYPE;
176: l_date_of_birth per_people_f.date_of_birth%TYPE;

Line 173: l_employee_number per_people_f.employee_number%TYPE;

169: l_validate boolean := false;
170: l_discard_varchar2 varchar2(40);
171: l_applicant_number per_people_f.applicant_number%TYPE;
172: l_object_version_number per_people_f.object_version_number%TYPE;
173: l_employee_number per_people_f.employee_number%TYPE;
174: l_npw_number per_people_f.npw_number%TYPE := p_npw_number;
175: l_date_employee_data_verified per_people_f.date_employee_data_verified%TYPE;
176: l_date_of_birth per_people_f.date_of_birth%TYPE;
177: l_date_of_death date;

Line 174: l_npw_number per_people_f.npw_number%TYPE := p_npw_number;

170: l_discard_varchar2 varchar2(40);
171: l_applicant_number per_people_f.applicant_number%TYPE;
172: l_object_version_number per_people_f.object_version_number%TYPE;
173: l_employee_number per_people_f.employee_number%TYPE;
174: l_npw_number per_people_f.npw_number%TYPE := p_npw_number;
175: l_date_employee_data_verified per_people_f.date_employee_data_verified%TYPE;
176: l_date_of_birth per_people_f.date_of_birth%TYPE;
177: l_date_of_death date;
178: l_receipt_of_death_cert_date date;

Line 175: l_date_employee_data_verified per_people_f.date_employee_data_verified%TYPE;

171: l_applicant_number per_people_f.applicant_number%TYPE;
172: l_object_version_number per_people_f.object_version_number%TYPE;
173: l_employee_number per_people_f.employee_number%TYPE;
174: l_npw_number per_people_f.npw_number%TYPE := p_npw_number;
175: l_date_employee_data_verified per_people_f.date_employee_data_verified%TYPE;
176: l_date_of_birth per_people_f.date_of_birth%TYPE;
177: l_date_of_death date;
178: l_receipt_of_death_cert_date date;
179: l_dpdnt_adoption_date date;

Line 176: l_date_of_birth per_people_f.date_of_birth%TYPE;

172: l_object_version_number per_people_f.object_version_number%TYPE;
173: l_employee_number per_people_f.employee_number%TYPE;
174: l_npw_number per_people_f.npw_number%TYPE := p_npw_number;
175: l_date_employee_data_verified per_people_f.date_employee_data_verified%TYPE;
176: l_date_of_birth per_people_f.date_of_birth%TYPE;
177: l_date_of_death date;
178: l_receipt_of_death_cert_date date;
179: l_dpdnt_adoption_date date;
180: l_original_date_of_hire date;

Line 184: l_full_name per_people_f.full_name%type;

180: l_original_date_of_hire date;
181: --
182: l_effective_start_date date;
183: l_effective_end_date date;
184: l_full_name per_people_f.full_name%type;
185: l_comment_id per_people_f.comment_id%type;
186: l_name_combination_warning boolean;
187: l_assign_payroll_warning boolean;
188: l_orig_hire_warning boolean;

Line 185: l_comment_id per_people_f.comment_id%type;

181: --
182: l_effective_start_date date;
183: l_effective_end_date date;
184: l_full_name per_people_f.full_name%type;
185: l_comment_id per_people_f.comment_id%type;
186: l_name_combination_warning boolean;
187: l_assign_payroll_warning boolean;
188: l_orig_hire_warning boolean;
189: --

Line 202: from per_people_f per

198: l_period_of_service_id per_periods_of_service.period_of_service_id%type;
199: --
200: cursor csr_bg is
201: select per.business_group_id
202: from per_people_f per
203: where per.person_id = p_person_id
204: and l_effective_date between per.effective_start_date
205: and per.effective_end_date;
206: --

Line 1242: (c_person_id per_people_f.person_id%TYPE,

1238: l_legislation_code per_business_groups.legislation_code%type;
1239: l_discard_varchar2 varchar2(30);
1240: --
1241: /*cursor check_legislation
1242: (c_person_id per_people_f.person_id%TYPE,
1243: c_effective_date date
1244: )
1245: is
1246: select bgp.legislation_code

Line 1247: from per_people_f per,

1243: c_effective_date date
1244: )
1245: is
1246: select bgp.legislation_code
1247: from per_people_f per,
1248: per_business_groups bgp
1249: where per.business_group_id = bgp.business_group_id
1250: and per.person_id = c_person_id
1251: and c_effective_date

Line 1257: (c_person_id per_people_f.person_id%TYPE,

1253:
1254: Modified the cursor for the bug 6131445 and 6064284 */
1255:
1256: cursor check_legislation
1257: (c_person_id per_people_f.person_id%TYPE,
1258: c_effective_date date
1259: )
1260: is
1261: select bgp.legislation_code

Line 1262: from per_people_f per,

1258: c_effective_date date
1259: )
1260: is
1261: select bgp.legislation_code
1262: from per_people_f per,
1263: per_business_groups_perf bgp
1264: where per.business_group_id+0 = bgp.business_group_id
1265: and per.person_id = c_person_id
1266: and c_effective_date

Line 1581: (c_person_id per_people_f.person_id%TYPE,

1577: */
1578: --
1579: /*
1580: cursor check_legislation
1581: (c_person_id per_people_f.person_id%TYPE,
1582: c_effective_date date
1583: )
1584: is
1585: select bgp.legislation_code

Line 1586: from per_people_f per,

1582: c_effective_date date
1583: )
1584: is
1585: select bgp.legislation_code
1586: from per_people_f per,
1587: -- per_business_groups bgp -- 6131445
1588: -- where per.business_group_id = bgp.business_group_id
1589: per_business_groups_perf bgp
1590: where per.business_group_id+0 = bgp.business_group_id

Line 1905: (c_person_id per_people_f.person_id%TYPE,

1901: l_legislation_code per_business_groups.legislation_code%type;
1902: l_discard_varchar2 varchar2(30);
1903: --
1904: cursor check_legislation
1905: (c_person_id per_people_f.person_id%TYPE,
1906: c_effective_date date
1907: )
1908: is
1909: select bgp.legislation_code

Line 1910: from per_people_f per,

1906: c_effective_date date
1907: )
1908: is
1909: select bgp.legislation_code
1910: from per_people_f per,
1911: -- per_business_groups bgp -- 6131445
1912: -- where per.business_group_id = bgp.business_group_id
1913: per_business_groups_perf bgp
1914: where per.business_group_id+0 = bgp.business_group_id