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_DELETE dependencies on PER_PERSON_TYPE_USAGES_F

Line 1456: from per_person_type_usages_f ptu

1452: cursor c_ptu is
1453: select distinct person_type_usage_id
1454: -- ,ptu.effective_start_date
1455: -- ,ptu.object_version_number
1456: from per_person_type_usages_f ptu
1457: where ptu.person_id = p_person_id
1458: order by person_type_usage_id;
1459:
1460: --

Line 1475: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;

1471: v_effective_end_date per_disabilities_f.effective_end_date%TYPE;
1472: v_ovn_roles per_roles.object_version_number%TYPE;
1473: v_role_id per_roles.role_id%TYPE;
1474: --
1475: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
1476: l_effective_date per_person_type_usages_f.effective_start_date%TYPE;
1477: l_object_version_number per_person_type_usages_f.object_version_number%TYPE;
1478: l_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;
1479: l_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;

Line 1476: l_effective_date per_person_type_usages_f.effective_start_date%TYPE;

1472: v_ovn_roles per_roles.object_version_number%TYPE;
1473: v_role_id per_roles.role_id%TYPE;
1474: --
1475: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
1476: l_effective_date per_person_type_usages_f.effective_start_date%TYPE;
1477: l_object_version_number per_person_type_usages_f.object_version_number%TYPE;
1478: l_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;
1479: l_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;
1480:

Line 1477: l_object_version_number per_person_type_usages_f.object_version_number%TYPE;

1473: v_role_id per_roles.role_id%TYPE;
1474: --
1475: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
1476: l_effective_date per_person_type_usages_f.effective_start_date%TYPE;
1477: l_object_version_number per_person_type_usages_f.object_version_number%TYPE;
1478: l_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;
1479: l_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;
1480:
1481: -- bug fix 3732129 starts here.

Line 1478: l_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;

1474: --
1475: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
1476: l_effective_date per_person_type_usages_f.effective_start_date%TYPE;
1477: l_object_version_number per_person_type_usages_f.object_version_number%TYPE;
1478: l_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;
1479: l_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;
1480:
1481: -- bug fix 3732129 starts here.
1482: -- to improve performance assignment id fetched into a pl/sql table.

Line 1479: l_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;

1475: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
1476: l_effective_date per_person_type_usages_f.effective_start_date%TYPE;
1477: l_object_version_number per_person_type_usages_f.object_version_number%TYPE;
1478: l_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;
1479: l_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;
1480:
1481: -- bug fix 3732129 starts here.
1482: -- to improve performance assignment id fetched into a pl/sql table.
1483:

Line 2613: -- Add delete from per_person_type_usages_f

2609: --
2610: -- 03/18/98 Change Ends
2611: --
2612: -- 28/5/98
2613: -- Add delete from per_person_type_usages_f
2614: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON',47);
2615:
2616: for ptu_rec in c_ptu loop
2617:

Line 2620: from per_person_type_usages_f ptu1

2616: for ptu_rec in c_ptu loop
2617:
2618: select min(ptu1.effective_start_date)
2619: into l_effective_date
2620: from per_person_type_usages_f ptu1
2621: where ptu1.person_type_usage_id = ptu_rec.person_type_usage_id;
2622:
2623: select ptu2.object_version_number
2624: into l_object_version_number

Line 2625: from per_person_type_usages_f ptu2

2621: where ptu1.person_type_usage_id = ptu_rec.person_type_usage_id;
2622:
2623: select ptu2.object_version_number
2624: into l_object_version_number
2625: from per_person_type_usages_f ptu2
2626: where ptu2.person_type_usage_id = ptu_rec.person_type_usage_id
2627: and ptu2.effective_start_date = l_effective_date;
2628:
2629: hr_utility.set_location('l_person_type_usage_id = '||to_char(ptu_rec.person_type_usage_id),44);

Line 3135: delete from per_person_type_usages_f

3131: -- Added this delete for PTU
3132: --
3133: hr_utility.set_location('HR_PERSON_DELETE.APPLICANT_DEFAULT_DELETES', 16);
3134: begin
3135: delete from per_person_type_usages_f
3136: where person_id = P_PERSON_ID;
3137: exception
3138: when NO_DATA_FOUND then null;
3139: end;