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 1455: from per_person_type_usages_f ptu

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

Line 1474: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;

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

Line 1475: l_effective_date per_person_type_usages_f.effective_start_date%TYPE;

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

Line 1476: l_object_version_number per_person_type_usages_f.object_version_number%TYPE;

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

Line 1477: l_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;

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

Line 1478: l_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;

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

Line 2542: -- Add delete from per_person_type_usages_f

2538: --
2539: -- 03/18/98 Change Ends
2540: --
2541: -- 28/5/98
2542: -- Add delete from per_person_type_usages_f
2543: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON',47);
2544:
2545: for ptu_rec in c_ptu loop
2546:

Line 2549: from per_person_type_usages_f ptu1

2545: for ptu_rec in c_ptu loop
2546:
2547: select min(ptu1.effective_start_date)
2548: into l_effective_date
2549: from per_person_type_usages_f ptu1
2550: where ptu1.person_type_usage_id = ptu_rec.person_type_usage_id;
2551:
2552: select ptu2.object_version_number
2553: into l_object_version_number

Line 2554: from per_person_type_usages_f ptu2

2550: where ptu1.person_type_usage_id = ptu_rec.person_type_usage_id;
2551:
2552: select ptu2.object_version_number
2553: into l_object_version_number
2554: from per_person_type_usages_f ptu2
2555: where ptu2.person_type_usage_id = ptu_rec.person_type_usage_id
2556: and ptu2.effective_start_date = l_effective_date;
2557:
2558: hr_utility.set_location('l_person_type_usage_id = '||to_char(ptu_rec.person_type_usage_id),44);

Line 3063: delete from per_person_type_usages_f

3059: -- Added this delete for PTU
3060: --
3061: hr_utility.set_location('HR_PERSON_DELETE.APPLICANT_DEFAULT_DELETES', 16);
3062: begin
3063: delete from per_person_type_usages_f
3064: where person_id = P_PERSON_ID;
3065: exception
3066: when NO_DATA_FOUND then null;
3067: end;