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_APPLICANT_INTERNAL dependencies on PER_ALL_PEOPLE_F

Line 15: from per_all_people_f

11: --
12:
13: CURSOR csr_person_record (cp_person_id number) IS
14: select *
15: from per_all_people_f
16: where person_id = cp_person_id
17: and rownum = 1;
18:
19: -- ------------------------------------------------------------------------ +

Line 35: from per_all_people_f

31: cursor csr_get_apl_number(cp_person_id number
32: ,cp_business_group_id number
33: ,cp_effective_date date ) is
34: select applicant_number
35: from per_all_people_f
36: where person_id = cp_person_id
37: and business_group_id = cp_business_group_id
38: and applicant_number is not null
39: and (cp_effective_date between effective_start_date and effective_end_date

Line 44: l_applicant_number per_all_people_f.applicant_number%TYPE;

40: or effective_start_date > cp_effective_date)
41: order by effective_start_date ASC;
42: --
43: l_dummy varchar2(100);
44: l_applicant_number per_all_people_f.applicant_number%TYPE;
45: l_method_of_generation VARCHAR2(30);
46: --
47: BEGIN
48: --

Line 184: l_ovn per_all_people_f.object_version_number%TYPE;

180: ,p_current_apl_flag varchar2
181: ,p_object_version_number in out nocopy number -- BUG4081676
182: ) IS
183: --
184: l_ovn per_all_people_f.object_version_number%TYPE;
185: --
186: BEGIN
187:
188: l_ovn := p_object_version_number + 1; -- BUG4081676

Line 190: UPDATE per_all_people_f

186: BEGIN
187:
188: l_ovn := p_object_version_number + 1; -- BUG4081676
189:
190: UPDATE per_all_people_f
191: set person_type_id = p_person_type_id
192: ,current_applicant_flag = p_current_apl_flag
193: ,current_emp_or_apl_flag = p_current_emp_apl_flag
194: ,applicant_number = p_applicant_number

Line 219: l_created_by per_all_people_f.created_by%TYPE;

215: ,p_current_employee_flag varchar2
216: ,p_object_version_number in out nocopy number -- BUG4081676
217: ) IS
218: --
219: l_created_by per_all_people_f.created_by%TYPE;
220: l_creation_date per_all_people_f.creation_date%TYPE;
221: l_last_update_date per_all_people_f.last_update_date%TYPE;
222: l_last_updated_by per_all_people_f.last_updated_by%TYPE;
223: l_last_update_login per_all_people_f.last_update_login%TYPE;

Line 220: l_creation_date per_all_people_f.creation_date%TYPE;

216: ,p_object_version_number in out nocopy number -- BUG4081676
217: ) IS
218: --
219: l_created_by per_all_people_f.created_by%TYPE;
220: l_creation_date per_all_people_f.creation_date%TYPE;
221: l_last_update_date per_all_people_f.last_update_date%TYPE;
222: l_last_updated_by per_all_people_f.last_updated_by%TYPE;
223: l_last_update_login per_all_people_f.last_update_login%TYPE;
224: l_ovn per_all_people_f.object_version_number%TYPE;

Line 221: l_last_update_date per_all_people_f.last_update_date%TYPE;

217: ) IS
218: --
219: l_created_by per_all_people_f.created_by%TYPE;
220: l_creation_date per_all_people_f.creation_date%TYPE;
221: l_last_update_date per_all_people_f.last_update_date%TYPE;
222: l_last_updated_by per_all_people_f.last_updated_by%TYPE;
223: l_last_update_login per_all_people_f.last_update_login%TYPE;
224: l_ovn per_all_people_f.object_version_number%TYPE;
225: --

Line 222: l_last_updated_by per_all_people_f.last_updated_by%TYPE;

218: --
219: l_created_by per_all_people_f.created_by%TYPE;
220: l_creation_date per_all_people_f.creation_date%TYPE;
221: l_last_update_date per_all_people_f.last_update_date%TYPE;
222: l_last_updated_by per_all_people_f.last_updated_by%TYPE;
223: l_last_update_login per_all_people_f.last_update_login%TYPE;
224: l_ovn per_all_people_f.object_version_number%TYPE;
225: --
226: BEGIN

Line 223: l_last_update_login per_all_people_f.last_update_login%TYPE;

219: l_created_by per_all_people_f.created_by%TYPE;
220: l_creation_date per_all_people_f.creation_date%TYPE;
221: l_last_update_date per_all_people_f.last_update_date%TYPE;
222: l_last_updated_by per_all_people_f.last_updated_by%TYPE;
223: l_last_update_login per_all_people_f.last_update_login%TYPE;
224: l_ovn per_all_people_f.object_version_number%TYPE;
225: --
226: BEGIN
227: -- Set the AOL updated WHO values

Line 224: l_ovn per_all_people_f.object_version_number%TYPE;

220: l_creation_date per_all_people_f.creation_date%TYPE;
221: l_last_update_date per_all_people_f.last_update_date%TYPE;
222: l_last_updated_by per_all_people_f.last_updated_by%TYPE;
223: l_last_update_login per_all_people_f.last_update_login%TYPE;
224: l_ovn per_all_people_f.object_version_number%TYPE;
225: --
226: BEGIN
227: -- Set the AOL updated WHO values
228: --

Line 234: INSERT INTO per_all_people_f

230: l_last_updated_by := fnd_global.user_id;
231: l_last_update_login := fnd_global.login_id;
232: l_ovn := p_object_version_number + 1; -- BUG4081676
233:
234: INSERT INTO per_all_people_f
235: (person_id,
236: effective_start_date,
237: effective_end_date,
238: business_group_id,

Line 563: from per_all_people_f peo

559: --
560: cursor csr_get_person_details(cp_person_id number, cp_effective_date date)
561: IS
562: select *
563: from per_all_people_f peo
564: where person_id = cp_person_id
565: and (effective_start_date >= cp_effective_date
566: OR
567: cp_effective_date between effective_start_date

Line 593: l_business_group_id per_all_people_f.business_group_id%TYPE;

589:
590: l_proc constant varchar2(100) := g_package||'Update_PER_PTU_to_EX_APL';
591: l_effective_date date;
592:
593: l_business_group_id per_all_people_f.business_group_id%TYPE;
594: l_effective_start_date per_all_people_f.effective_start_date%TYPE;
595: l_effective_end_date per_all_people_f.effective_end_date%TYPE;
596: l_system_person_type per_person_types.system_person_type%TYPE;
597: l_ovn per_all_people_f.object_version_number%TYPE;

Line 594: l_effective_start_date per_all_people_f.effective_start_date%TYPE;

590: l_proc constant varchar2(100) := g_package||'Update_PER_PTU_to_EX_APL';
591: l_effective_date date;
592:
593: l_business_group_id per_all_people_f.business_group_id%TYPE;
594: l_effective_start_date per_all_people_f.effective_start_date%TYPE;
595: l_effective_end_date per_all_people_f.effective_end_date%TYPE;
596: l_system_person_type per_person_types.system_person_type%TYPE;
597: l_ovn per_all_people_f.object_version_number%TYPE;
598:

Line 595: l_effective_end_date per_all_people_f.effective_end_date%TYPE;

591: l_effective_date date;
592:
593: l_business_group_id per_all_people_f.business_group_id%TYPE;
594: l_effective_start_date per_all_people_f.effective_start_date%TYPE;
595: l_effective_end_date per_all_people_f.effective_end_date%TYPE;
596: l_system_person_type per_person_types.system_person_type%TYPE;
597: l_ovn per_all_people_f.object_version_number%TYPE;
598:
599: l_new_person_type_id per_person_types.person_type_id%TYPE;

Line 597: l_ovn per_all_people_f.object_version_number%TYPE;

593: l_business_group_id per_all_people_f.business_group_id%TYPE;
594: l_effective_start_date per_all_people_f.effective_start_date%TYPE;
595: l_effective_end_date per_all_people_f.effective_end_date%TYPE;
596: l_system_person_type per_person_types.system_person_type%TYPE;
597: l_ovn per_all_people_f.object_version_number%TYPE;
598:
599: l_new_person_type_id per_person_types.person_type_id%TYPE;
600: l_ptu_person_type_id per_person_types.person_type_id%TYPE;
601: l_new_sys_person_type per_person_types.system_person_type%TYPE;

Line 652: select 'Y' from per_all_people_f

648: and ptu.person_type_id = ppt.person_type_id
649: and system_person_type in ('APL','EX_APL','EX_EMP');
650:
651: cursor per_row_exists(cp_effective_start_date date) is
652: select 'Y' from per_all_people_f
653: where person_id = p_person_id
654: and effective_start_date = cp_effective_start_date;
655:
656: cursor chk_ptu_exists(cp_effective_start_date date) is

Line 753: UPDATE per_all_people_f

749: l_new_effective_date := l_effective_date;
750: l_per_effective_end_date := l_person_rec.effective_end_date;
751: --
752: -- End date current record
753: UPDATE per_all_people_f
754: set effective_end_date = l_effective_date -1
755: where person_id = l_person_rec.person_id
756: and effective_start_date = l_person_rec.effective_start_date
757: and effective_end_date = l_person_rec.effective_end_date;

Line 909: -- updating per_all_people_f for the future PTU records

905:
906: end loop;
907:
908: for ptu_rec in fpt_ptu_details loop
909: -- updating per_all_people_f for the future PTU records
910: open csr_get_person_details(p_person_id, ptu_rec.effective_start_date);
911: fetch csr_get_person_details into l_person_rec;
912: close csr_get_person_details;
913:

Line 915: update per_all_people_f

911: fetch csr_get_person_details into l_person_rec;
912: close csr_get_person_details;
913:
914: -- end dating the current PER record
915: update per_all_people_f
916: set effective_end_date = ptu_rec.effective_start_date - 1
917: where person_id = p_person_id
918: and effective_start_date < ptu_rec.effective_start_date
919: and effective_end_date > ptu_rec.effective_start_date;

Line 1041: from per_all_people_f peo

1037: --
1038: cursor csr_get_person_details(cp_person_id number, cp_effective_date date)
1039: IS
1040: select *
1041: from per_all_people_f peo
1042: where person_id = cp_person_id
1043: and (effective_start_date >= cp_effective_date
1044: OR
1045: cp_effective_date between effective_start_date

Line 1073: l_business_group_id per_all_people_f.business_group_id%TYPE;

1069:
1070: l_proc constant varchar2(100) := g_package||'Update_PER_PTU_Records';
1071: l_effective_date date;
1072:
1073: l_business_group_id per_all_people_f.business_group_id%TYPE;
1074: l_effective_start_date per_all_people_f.effective_start_date%TYPE;
1075: l_effective_end_date per_all_people_f.effective_end_date%TYPE;
1076: l_system_person_type per_person_types.system_person_type%TYPE;
1077: l_ovn per_all_people_f.object_version_number%TYPE;

Line 1074: l_effective_start_date per_all_people_f.effective_start_date%TYPE;

1070: l_proc constant varchar2(100) := g_package||'Update_PER_PTU_Records';
1071: l_effective_date date;
1072:
1073: l_business_group_id per_all_people_f.business_group_id%TYPE;
1074: l_effective_start_date per_all_people_f.effective_start_date%TYPE;
1075: l_effective_end_date per_all_people_f.effective_end_date%TYPE;
1076: l_system_person_type per_person_types.system_person_type%TYPE;
1077: l_ovn per_all_people_f.object_version_number%TYPE;
1078:

Line 1075: l_effective_end_date per_all_people_f.effective_end_date%TYPE;

1071: l_effective_date date;
1072:
1073: l_business_group_id per_all_people_f.business_group_id%TYPE;
1074: l_effective_start_date per_all_people_f.effective_start_date%TYPE;
1075: l_effective_end_date per_all_people_f.effective_end_date%TYPE;
1076: l_system_person_type per_person_types.system_person_type%TYPE;
1077: l_ovn per_all_people_f.object_version_number%TYPE;
1078:
1079: l_ptu_person_type_id per_person_types.person_type_id%TYPE;

Line 1077: l_ovn per_all_people_f.object_version_number%TYPE;

1073: l_business_group_id per_all_people_f.business_group_id%TYPE;
1074: l_effective_start_date per_all_people_f.effective_start_date%TYPE;
1075: l_effective_end_date per_all_people_f.effective_end_date%TYPE;
1076: l_system_person_type per_person_types.system_person_type%TYPE;
1077: l_ovn per_all_people_f.object_version_number%TYPE;
1078:
1079: l_ptu_person_type_id per_person_types.person_type_id%TYPE;
1080: l_new_person_type_id per_person_types.person_type_id%TYPE;
1081: l_new_sys_person_type per_person_types.system_person_type%TYPE;

Line 1115: from per_all_people_f

1111: l_ptu_eff_end_date per_person_type_usages_f.effective_end_date%TYPE;
1112: -- BUG4081676
1113: cursor csr_get_per_ovn is
1114: select object_version_number
1115: from per_all_people_f
1116: where person_id = p_person_id
1117: and effective_start_date = l_new_effective_date
1118: and effective_end_date = l_per_effective_end_date;
1119: --

Line 1242: UPDATE per_all_people_f

1238: l_new_effective_date := l_effective_date;
1239: l_per_effective_end_date := l_person_rec.effective_end_date;
1240: --
1241: -- End date current record
1242: UPDATE per_all_people_f
1243: set effective_end_date = l_effective_date -1
1244: where person_id = l_person_rec.person_id
1245: and effective_start_date = l_person_rec.effective_start_date
1246: and effective_end_date = l_person_rec.effective_end_date;

Line 1514: from per_all_people_f peo

1510: IS
1511: --
1512: cursor csr_get_person_details(cp_person_id number, cp_ex_apl_date date, cp_apl_date date) is
1513: select *
1514: from per_all_people_f peo
1515: where person_id = cp_person_id
1516: and (cp_ex_apl_date between effective_start_date
1517: and effective_end_date -- becomes ex-apl on this date
1518: or cp_apl_date between effective_start_date

Line 1543: l_business_group_id per_all_people_f.business_group_id%TYPE;

1539: --
1540: l_proc constant varchar2(100) := g_package||'Upd_person_EX_APL_and_APL';
1541: l_effective_date date;
1542:
1543: l_business_group_id per_all_people_f.business_group_id%TYPE;
1544: l_effective_start_date per_all_people_f.effective_start_date%TYPE;
1545: l_effective_end_date per_all_people_f.effective_end_date%TYPE;
1546: l_system_person_type per_person_types.system_person_type%TYPE;
1547: l_ovn per_all_people_f.object_version_number%TYPE;

Line 1544: l_effective_start_date per_all_people_f.effective_start_date%TYPE;

1540: l_proc constant varchar2(100) := g_package||'Upd_person_EX_APL_and_APL';
1541: l_effective_date date;
1542:
1543: l_business_group_id per_all_people_f.business_group_id%TYPE;
1544: l_effective_start_date per_all_people_f.effective_start_date%TYPE;
1545: l_effective_end_date per_all_people_f.effective_end_date%TYPE;
1546: l_system_person_type per_person_types.system_person_type%TYPE;
1547: l_ovn per_all_people_f.object_version_number%TYPE;
1548:

Line 1545: l_effective_end_date per_all_people_f.effective_end_date%TYPE;

1541: l_effective_date date;
1542:
1543: l_business_group_id per_all_people_f.business_group_id%TYPE;
1544: l_effective_start_date per_all_people_f.effective_start_date%TYPE;
1545: l_effective_end_date per_all_people_f.effective_end_date%TYPE;
1546: l_system_person_type per_person_types.system_person_type%TYPE;
1547: l_ovn per_all_people_f.object_version_number%TYPE;
1548:
1549: l_new_person_type_id per_person_types.person_type_id%TYPE;

Line 1547: l_ovn per_all_people_f.object_version_number%TYPE;

1543: l_business_group_id per_all_people_f.business_group_id%TYPE;
1544: l_effective_start_date per_all_people_f.effective_start_date%TYPE;
1545: l_effective_end_date per_all_people_f.effective_end_date%TYPE;
1546: l_system_person_type per_person_types.system_person_type%TYPE;
1547: l_ovn per_all_people_f.object_version_number%TYPE;
1548:
1549: l_new_person_type_id per_person_types.person_type_id%TYPE;
1550: l_ptu_person_type_id per_person_types.person_type_id%TYPE;
1551: l_new_sys_person_type per_person_types.system_person_type%TYPE;

Line 1596: UPDATE per_all_people_f

1592: ,p_object_version_number in out nocopy number
1593: ) IS
1594: BEGIN
1595: if p_mode = 'CORRECTION' then
1596: UPDATE per_all_people_f
1597: SET person_type_id = p_person_type
1598: WHERE person_id = p_ex_apl_rec.person_id
1599: AND effective_start_date = p_ex_apl_rec.effective_start_date
1600: AND effective_end_date = p_ex_apl_rec.effective_end_date;

Line 1608: UPDATE per_all_people_f

1604: -- b. create the ex_applicant record effective on p_ex_apl_date
1605: -- c. insert/update APL record depending on scenario
1606: --
1607: -- a. End APL record
1608: UPDATE per_all_people_f
1609: SET effective_end_date = p_ex_apl_date - 1
1610: WHERE person_id = p_ex_apl_rec.person_id
1611: AND effective_start_date = p_ex_apl_rec.effective_start_date
1612: AND effective_end_date = p_ex_apl_rec.effective_end_date;

Line 1646: UPDATE per_all_people_f

1642: ,p_object_version_number => p_object_version_number -- BUG4081676
1643: );
1644: elsif p_mode = 'UPDATE_OVERRIDE' then
1645: -- insert APL record as of p_apl_date
1646: UPDATE per_all_people_f
1647: SET effective_start_date = p_apl_date
1648: WHERE person_id = p_apl_rec.person_id
1649: AND effective_start_date = p_apl_rec.effective_start_date
1650: AND effective_end_date = p_apl_rec.effective_end_date;

Line 2326: l_per_party_id per_all_people_f.party_id%TYPE;

2322: l_asg_object_version_number number;
2323: l_per_effective_start_date date;
2324: l_per_effective_end_date date;
2325: l_appl_override_warning BOOLEAN;
2326: l_per_party_id per_all_people_f.party_id%TYPE;
2327: l_per_dob per_all_people_f.date_of_birth%TYPE;
2328: l_per_start_date per_all_people_f.effective_start_date%TYPE;
2329: --
2330: --

Line 2327: l_per_dob per_all_people_f.date_of_birth%TYPE;

2323: l_per_effective_start_date date;
2324: l_per_effective_end_date date;
2325: l_appl_override_warning BOOLEAN;
2326: l_per_party_id per_all_people_f.party_id%TYPE;
2327: l_per_dob per_all_people_f.date_of_birth%TYPE;
2328: l_per_start_date per_all_people_f.effective_start_date%TYPE;
2329: --
2330: --
2331: -- select and validate the person

Line 2328: l_per_start_date per_all_people_f.effective_start_date%TYPE;

2324: l_per_effective_end_date date;
2325: l_appl_override_warning BOOLEAN;
2326: l_per_party_id per_all_people_f.party_id%TYPE;
2327: l_per_dob per_all_people_f.date_of_birth%TYPE;
2328: l_per_start_date per_all_people_f.effective_start_date%TYPE;
2329: --
2330: --
2331: -- select and validate the person
2332: --

Line 2381: FROM per_all_people_f

2377: where vacancy_id = p_vacancy_id;
2378: --
2379: CURSOR csr_lock_person(cp_person_id number, cp_termination_date date) IS
2380: SELECT null
2381: FROM per_all_people_f
2382: WHERE person_id = cp_person_id
2383: AND (effective_start_date > cp_termination_date
2384: OR
2385: cp_termination_date between effective_start_date