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.PER_PEOPLE12_PKG dependencies on PER_ALL_PEOPLE_F

Line 228: l_npw_number per_all_people_f.npw_number%type;

224: l_num_appls NUMBER; -- Number of applicants.
225: l_num_accepted_appls NUMBER; -- Number of accepted spplicant assignments
226: l_set_of_books_id NUMBER; -- Required for GL.
227: v_dummy NUMBER; -- For cursor fetch.
228: l_npw_number per_all_people_f.npw_number%type;
229: --
230: l_warn_ee VARCHAR2(1) := 'N';
231: --
232: l_max_ele number;--added for bug 6600075

Line 251: from per_all_people_f

247: --
248: /* BEGIN OF WWBUG 1975359 */
249: cursor c1 is
250: select party_id
251: from per_all_people_f
252: where person_id = p_person_id
253: and p_effective_start_date
254: between effective_start_date
255: and effective_end_date; /* Fix for Bug 7442246 */

Line 261: from per_all_people_f

257: l_party_id number;
258: --
259: cursor c_person is
260: select *
261: from per_all_people_f
262: where person_id = p_person_id
263: and p_effective_start_date
264: between effective_start_date
265: and effective_end_date;

Line 267: l_person per_all_people_f%rowtype;

263: and p_effective_start_date
264: between effective_start_date
265: and effective_end_date;
266: --
267: l_person per_all_people_f%rowtype;
268: --
269: /* END OF WWBUG 1975359 */
270: --
271: -- **** Start new code for bug 2264569 ******************************

Line 281: from per_all_people_f

277: --
278: --bug no 5546586 starts here
279: cursor email_address is
280: select email_address
281: from per_all_people_f
282: where rowid = p_rowid;
283: --bug no 5546586 ends here
284:
285: -- call to ethnicity

Line 288: from per_all_people_f

284:
285: -- call to ethnicity
286: cursor c_person_enthn is
287: select business_group_id,per_information1
288: from per_all_people_f
289: where person_id = p_person_id
290: and p_effective_start_date
291: between effective_start_date
292: and effective_end_date;

Line 332: select * from per_all_people_f

328: l_exists varchar2(1);
329: l_first_apl_date date := hr_api.g_eot;
330:
331: cursor person_record(p_effective_date date) is
332: select * from per_all_people_f
333: where person_id = p_person_id
334: and p_effective_date between effective_start_date and effective_end_date;
335:
336: per_rec person_record%rowtype;

Line 340: select 'Y' from per_all_people_f

336: per_rec person_record%rowtype;
337:
338:
339: cursor per_future_rows(p_eff_start_date date) is
340: select 'Y' from per_all_people_f
341: where person_id = p_person_id
342: and effective_start_date > p_eff_start_date;
343:
344: cursor csr_get_apln_details(p_hire_date date) is

Line 1233: update per_all_people_f ppf

1229: p_business_group_id,p_system_person_type),272);
1230:
1231: -- Bug 6196362 Starts.
1232: -- update per_people_f ppf
1233: update per_all_people_f ppf
1234: -- Bug 6196362 Ends.
1235: set ppf.person_id = p_person_id
1236: ,ppf.effective_start_date = p_effective_start_date
1237: ,ppf.effective_end_date = p_effective_end_date

Line 1403: FROM per_all_people_f per, per_person_types ppt

1399: IF p_effective_end_date <> hr_api.g_eot and l_create_apl <> 'Y' THEN
1400:
1401: SELECT ppt.system_person_type
1402: INTO l_next_person_type
1403: FROM per_all_people_f per, per_person_types ppt
1404: WHERE per.person_id = p_person_id
1405: AND per.person_type_id = ppt.person_type_id
1406: AND per.effective_start_date = p_effective_end_date + 1;
1407:

Line 1411: UPDATE per_all_people_f

1407:
1408:
1409: IF l_next_person_type in ('EMP','EX_APL','EX_EMP') then
1410:
1411: UPDATE per_all_people_f
1412: SET effective_end_date = (
1413: SELECT effective_end_date
1414: FROM per_all_people_f
1415: WHERE effective_start_date = p_effective_end_date + 1

Line 1414: FROM per_all_people_f

1410:
1411: UPDATE per_all_people_f
1412: SET effective_end_date = (
1413: SELECT effective_end_date
1414: FROM per_all_people_f
1415: WHERE effective_start_date = p_effective_end_date + 1
1416: AND person_id = p_person_id
1417: )
1418: WHERE rowid = p_rowid;

Line 1421: FROM per_all_people_f

1417: )
1418: WHERE rowid = p_rowid;
1419:
1420: DELETE
1421: FROM per_all_people_f
1422: WHERE person_id = p_person_id
1423: AND effective_start_date = p_effective_end_date + 1;
1424:
1425: END IF;

Line 1428: UPDATE per_all_people_f

1424:
1425: END IF;
1426:
1427: -- All the future APL & EX_EMP_APL records will be converted to EMP_APL
1428: UPDATE per_all_people_f
1429: SET person_type_id = hr_person_type_usage_info.get_default_person_type_id (p_business_group_id,'EMP_APL')
1430: ,current_employee_flag = 'Y'
1431: ,employee_number = p_employee_number
1432: ,original_date_of_hire = p_original_date_of_hire

Line 1439: UPDATE per_all_people_f

1435: AND (person_type_id = hr_person_type_usage_info.get_default_person_type_id (p_business_group_id,'APL')
1436: OR person_type_id = hr_person_type_usage_info.get_default_person_type_id (p_business_group_id,'EX_EMP_APL'));
1437:
1438: -- All the future EX_APL & EX_EMP records will be converted to EMP
1439: UPDATE per_all_people_f
1440: SET person_type_id = hr_person_type_usage_info.get_default_person_type_id (p_business_group_id,'EMP')
1441: ,current_employee_flag = 'Y'
1442: ,current_emp_or_apl_flag = 'Y'
1443: ,employee_number = p_employee_number

Line 1458: update per_all_people_f

1454: if nvl(l_fpt_hire_flag,'N') = 'Y' then
1455:
1456: if l_first_apl_date <> hr_api.g_eot then
1457:
1458: update per_all_people_f
1459: set person_type_id = hr_person_type_usage_info.get_default_person_type_id(p_business_group_id,'EMP')
1460: ,current_applicant_flag = null
1461: where person_id = p_person_id
1462: and effective_start_date between p_effective_end_date and l_first_apl_date;

Line 1485: from per_all_people_f

1481: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id
1482: (p_business_group_id,'EMP_APL');
1483:
1484: select object_version_number,effective_start_date into l_per_latest_ovn,l_effective_start_date
1485: from per_all_people_f
1486: where person_id = p_person_id
1487: and apl.date_received between effective_start_date and effective_end_date;
1488:
1489: -- creating EMP_APL records in PER table

Line 1672: from per_all_people_f

1668: ,p_person_type_id => l_person_type_id1
1669: );
1670:
1671: select object_version_number,effective_start_date into l_per_latest_ovn,l_effective_start_date
1672: from per_all_people_f
1673: where person_id= p_person_id
1674: and apl.date_end + 1 between effective_start_date and effective_end_date;
1675:
1676: if l_effective_start_date = apl.date_end + 1 then

Line 1850: UPDATE per_all_people_f

1846:
1847: end loop;
1848: elsif p_status = 'HIRE' and p_effective_end_date <> hr_api.g_eot then
1849:
1850: UPDATE per_all_people_f
1851: SET person_type_id = hr_person_type_usage_info.get_default_person_type_id (p_business_group_id,'EMP')
1852: ,current_applicant_flag = NULL
1853: WHERE person_id = p_person_id
1854: AND effective_start_date > p_effective_end_date;

Line 2568: l_npw_number per_all_people_f.npw_number%type;

2564: l_num_appls NUMBER; -- Number of applicants.
2565: l_num_accepted_appls NUMBER; -- Number of accepted spplicant assignments
2566: l_set_of_books_id NUMBER; -- Required for GL.
2567: v_dummy NUMBER; -- For cursor fetch.
2568: l_npw_number per_all_people_f.npw_number%type;
2569: --
2570: l_warn_ee VARCHAR2(1) := 'N';
2571: --
2572: l_max_ele number;--added for bug 6600075

Line 2591: from per_all_people_f

2587: --
2588: /* BEGIN OF WWBUG 1975359 */
2589: cursor c1 is
2590: select party_id
2591: from per_all_people_f
2592: where person_id = p_person_id
2593: and p_effective_start_date
2594: between effective_start_date
2595: and effective_end_date; /* Fix for Bug 7442246 */

Line 2601: from per_all_people_f

2597: l_party_id number;
2598: --
2599: cursor c_person is
2600: select *
2601: from per_all_people_f
2602: where person_id = p_person_id
2603: and p_effective_start_date
2604: between effective_start_date
2605: and effective_end_date;

Line 2607: l_person per_all_people_f%rowtype;

2603: and p_effective_start_date
2604: between effective_start_date
2605: and effective_end_date;
2606: --
2607: l_person per_all_people_f%rowtype;
2608: --
2609: /* END OF WWBUG 1975359 */
2610: --
2611: -- **** Start new code for bug 2264569 ******************************

Line 2621: from per_all_people_f

2617: --
2618: --bug no 5546586 starts here
2619: cursor email_address is
2620: select email_address
2621: from per_all_people_f
2622: where rowid = p_rowid;
2623: --bug no 5546586 ends here
2624:
2625: -- call to ethnicity

Line 2628: from per_all_people_f

2624:
2625: -- call to ethnicity
2626: cursor c_person_enthn is
2627: select business_group_id,per_information1
2628: from per_all_people_f
2629: where person_id = p_person_id
2630: and p_effective_start_date
2631: between effective_start_date
2632: and effective_end_date;

Line 3700: update per_all_people_f ppf

3696: p_business_group_id,p_system_person_type),272);
3697:
3698: -- Bug 6196362 Starts.
3699: -- update per_people_f ppf
3700: update per_all_people_f ppf
3701: -- Bug 6196362 Ends.
3702: set ppf.person_id = p_person_id
3703: ,ppf.effective_start_date = p_effective_start_date
3704: ,ppf.effective_end_date = p_effective_end_date

Line 4388: from per_all_people_f

4384: ,p_cov_date_start in date) is
4385: --
4386: cursor csr_per_details(c_person_id number) is
4387: select *
4388: from per_all_people_f
4389: where person_id = c_person_id
4390: order by effective_start_date asc;
4391: --
4392: cursor csr_per_exists(c_person_id number, c_effective_date date) is

Line 4397: from per_all_people_f per

4393: select 'Y'
4394: from dual
4395: where exists(
4396: select 1
4397: from per_all_people_f per
4398: where per.person_id = c_person_id
4399: and c_effective_date between per.effective_start_date and per.effective_end_date
4400: );
4401: --

Line 4405: per_all_people_f ppf

4401: --
4402: cursor csr_per_type(c_person_id number, c_effective_date date) is
4403: select ppt.system_person_type
4404: from per_person_types ppt,
4405: per_all_people_f ppf
4406: where ppf.person_id = c_person_id
4407: and ppf.person_type_id = ppt.person_type_id;
4408: --
4409: cursor csr_address(c_person_id number, c_date_from date) is

Line 4424: l_per_rec per_all_people_f%rowtype;

4420: and ppt.active_flag = 'Y'
4421: and ppt.system_person_type = 'OTHER';
4422: --
4423: l_proc varchar2(100) := 'per_people12_pkg.ins_or_upd_precursor_row';
4424: l_per_rec per_all_people_f%rowtype;
4425: l_system_person_type varchar2(60);
4426: l_dummy varchar2(10);
4427: l_cov_date_start date;
4428: l_ptu_nextval number;

Line 4461: update per_all_people_f

4457: end loop;
4458: --
4459: if l_system_person_type = 'OTHER' then --first DT record is "OTHER" so simply extend back
4460: hr_utility.set_location(l_proc,15);
4461: update per_all_people_f
4462: set effective_start_date = p_cov_date_start,
4463: start_date = p_cov_date_start
4464: where person_id = p_person_id
4465: and effective_start_date = l_per_rec.effective_start_date;

Line 4469: update per_all_people_f

4465: and effective_start_date = l_per_rec.effective_start_date;
4466: --
4467: -- Fox for bug 3390731 starts here.
4468: --
4469: update per_all_people_f
4470: set start_date = p_cov_date_start
4471: where person_id = p_person_id;
4472: --
4473: -- Fix for bug 3390731 ends here.

Line 4497: insert into per_all_people_f(

4493: open csr_get_other(l_per_rec.business_group_id);
4494: fetch csr_get_other into l_per_rec.person_type_id;
4495: close csr_get_other;
4496: --
4497: insert into per_all_people_f(
4498: person_id,
4499: effective_start_date,
4500: effective_end_date,
4501: business_group_id,

Line 4672: update per_all_people_f

4668: -- Fox for bug 3390731 starts here.
4669: -- Update the start_date to the minimum of effective_start_date,
4670: -- in this case it is l_per_rec.start_date.
4671: --
4672: update per_all_people_f
4673: set start_date = l_per_rec.start_date
4674: where person_id = l_per_rec.person_id;
4675: --
4676: -- Fix for bug 3390731 ends here.