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_CANCEL_HIRE_OR_APL_PKG dependencies on PER_PEOPLE_F

Line 120: from per_people_f ppf

116: for update of assignment_id;
117: --
118: cursor per_rows is
119: select ppf.rowid
120: from per_people_f ppf
121: where ppf.person_id = p_person_id
122: for update of ppf.person_id;
123: --
124: --CWK assignments cursor

Line 300: from per_people_f ppf

296: -- Person cursor
297: --
298: cursor per_rows is
299: select ppf.rowid
300: from per_people_f ppf
301: where ppf.person_id = p_person_id
302: for update of ppf.person_id;
303: --
304: -- Period cursor

Line 1384: select p.rowid, effective_end_date from per_people_f p

1380: --
1381: -- person cursor
1382: --
1383: cursor person is
1384: select p.rowid, effective_end_date from per_people_f p
1385: where p.person_id = p_person_id
1386: and p.effective_start_date >= p_date_start;
1387: --
1388: -- 3194314

Line 1435: select p.rowid from per_people_f p

1431: --
1432: -- new_person
1433: --
1434: cursor new_person is
1435: select p.rowid from per_people_f p
1436: where p.person_id = p_person_id
1437: and p.effective_end_date = p_date_start -1;
1438:
1439: -- fix for bug 5005157 starts here.

Line 1860: update per_people_f

1856: and default_flag = 'Y';
1857:
1858: hr_utility.set_location('cancel_hire_or_apl.do_cancel_hire',322);
1859:
1860: update per_people_f
1861: set person_type_id = l_person_type_id,
1862: effective_start_date = p_date_start, -- in case DT updates exist
1863: current_employee_flag = null,
1864: current_emp_or_apl_flag = l_apl_flag, -- 3848352 --null,

Line 1872: delete from per_people_f

1868: else -- #1998140
1869: --
1870: hr_utility.set_location('cancel_hire_or_apl.do_cancel_hire',323);
1871:
1872: delete from per_people_f
1873: where rowid = p_rowid;
1874: --
1875: end if;
1876:

Line 1907: update per_people_f

1903:
1904: --
1905: -- 3847884 Changed from p_start_date to p_date_start
1906: --
1907: update per_people_f
1908: set person_type_id = l_person_type_id,
1909: current_employee_flag = null,
1910: current_emp_or_apl_flag = l_apl_flag, -- 3848352 -- null,
1911: current_applicant_flag = l_apl_flag, -- 3848352 --null,

Line 1923: delete from per_people_f

1919: else -- #1998140
1920: --
1921: hr_utility.set_location('cancel_hire_or_apl.do_cancel_hire',325);
1922:
1923: delete from per_people_f
1924: where rowid = p_rowid;
1925: --
1926: end if;
1927:

Line 1931: delete from per_people_f

1927:
1928: -- <<
1929: else
1930: hr_utility.set_location('cancel_hire_or_apl.do_cancel_hire',330);
1931: delete from per_people_f
1932: where rowid = p_rowid;
1933: end if;
1934: --
1935: hr_utility.set_location('cancel_hire_or_apl.do_cancel_hire',340);

Line 1965: update per_people_f

1961: exit when new_person%notfound;
1962: if NOT l_back2back
1963: then
1964: hr_utility.set_location('cancel_hire_or_apl.do_cancel_hire',380);
1965: update per_people_f
1966: set effective_end_date = p_end_of_time
1967: where rowid = p_rowid;
1968: end if;
1969: --

Line 2207: from per_people_f

2203: -- person cursor
2204: --
2205: cursor people is
2206: select rowid
2207: from per_people_f
2208: where person_id = p_person_id
2209: and effective_start_date >= p_date_received;
2210: --
2211: -- new person cursor

Line 2215: from per_people_f

2211: -- new person cursor
2212: --
2213: cursor new_people is
2214: select rowid
2215: from per_people_f
2216: where person_id = p_person_id
2217: and effective_end_date = p_date_received - 1;
2218: --
2219: --

Line 2282: from hr_comments h, per_people_f ppf

2278: -- person comments when apl cursor
2279: --
2280: cursor person_apl_comments2 is
2281: select distinct h.comment_id --fix for bug 7157204.
2282: from hr_comments h, per_people_f ppf
2283: where ppf.business_group_id = p_business_group_id
2284: and ppf.person_id = p_person_id
2285: and ppf.effective_start_date >= p_date_received
2286: and ppf.comment_id = h.comment_id;

Line 2302: -- Bug 4095559: Cursor to update per_people_f B2B of EX_EMP/EX_CWK.APL

2298: and ptu.effective_start_date = p_date_received
2299: and ptu.person_type_id = ppt.person_type_id
2300: and ppt.system_person_type <> 'APL';
2301:
2302: -- Bug 4095559: Cursor to update per_people_f B2B of EX_EMP/EX_CWK.APL
2303: -- new_people_b2b for person records with ESD as date_received
2304: cursor new_people_b2b is
2305: select rowid,effective_end_date,effective_start_date,current_applicant_flag
2306: from per_people_f

Line 2306: from per_people_f

2302: -- Bug 4095559: Cursor to update per_people_f B2B of EX_EMP/EX_CWK.APL
2303: -- new_people_b2b for person records with ESD as date_received
2304: cursor new_people_b2b is
2305: select rowid,effective_end_date,effective_start_date,current_applicant_flag
2306: from per_people_f
2307: where person_id = p_person_id
2308: and effective_start_date = p_date_received;
2309:
2310: -- Bug 4095559: Cursor to update per_people_f B2B of EX_EMP/EX_CWK.APL

Line 2310: -- Bug 4095559: Cursor to update per_people_f B2B of EX_EMP/EX_CWK.APL

2306: from per_people_f
2307: where person_id = p_person_id
2308: and effective_start_date = p_date_received;
2309:
2310: -- Bug 4095559: Cursor to update per_people_f B2B of EX_EMP/EX_CWK.APL
2311: -- people_b2b for person records with ESD future to date_received
2312: cursor people_b2b is
2313: select rowid,effective_end_date,effective_start_date,current_applicant_flag
2314: from per_people_f

Line 2314: from per_people_f

2310: -- Bug 4095559: Cursor to update per_people_f B2B of EX_EMP/EX_CWK.APL
2311: -- people_b2b for person records with ESD future to date_received
2312: cursor people_b2b is
2313: select rowid,effective_end_date,effective_start_date,current_applicant_flag
2314: from per_people_f
2315: where person_id = p_person_id
2316: and effective_start_date > p_date_received;
2317:
2318: -- Bug 4095559: Cursor to get the latest person_type_id B2B of

Line 2608: delete from per_people_f

2604: <>
2605: loop
2606: fetch people into l_rowid;
2607: exit when people%notfound;
2608: delete from per_people_f
2609: where rowid = l_rowid;
2610: if sql%notfound then
2611: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2612: hr_utility.set_message_token('PROCEDURE','do_cancel_appl');

Line 2631: update per_people_f

2627: <>
2628: loop
2629: fetch new_people into l_rowid;
2630: exit when new_people%notfound;
2631: update per_people_f
2632: set effective_end_date = p_end_of_time
2633: where rowid = l_rowid;
2634: --
2635: if sql%ROWCOUNT <1 then

Line 2664: update per_people_f

2660: open latest_ptid;
2661: fetch latest_ptid into l_person_type_id;
2662: close latest_ptid;
2663: -- Upadte the person table with the person type id
2664: update per_people_f
2665: set PERSON_TYPE_ID=l_person_type_id
2666: where rowid = l_rowid;
2667: if sql%notfound then
2668: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 2690: delete from per_people_f

2686: l_effective_start_date,l_current_applicant_flag;
2687: exit when new_people_b2b%notfound;
2688:
2689: if l_effective_end_date = hr_general.effective_date -1 then
2690: delete from per_people_f
2691: where rowid = l_rowid;
2692: elsif l_current_applicant_flag = 'Y' then
2693: -- Get the latest person Type Id to update the person table.
2694: open latest_ptid;

Line 2699: update per_people_f

2695: fetch latest_ptid into l_person_type_id;
2696: close latest_ptid;
2697: -- Updating the person table, if there is future changes
2698: if l_fut_per_chg then
2699: update per_people_f
2700: set applicant_number = null,
2701: current_applicant_flag=null,
2702: current_emp_or_apl_flag=null,
2703: PERSON_TYPE_ID=l_person_type_id

Line 2707: update per_people_f

2703: PERSON_TYPE_ID=l_person_type_id
2704: where rowid = l_rowid;
2705: -- Updating the person table, if there is NO future changes
2706: else
2707: update per_people_f
2708: set applicant_number = null,
2709: current_applicant_flag=null,
2710: current_emp_or_apl_flag=null,
2711: PERSON_TYPE_ID=l_person_type_id,

Line 2846: FROM per_people_f per

2842: --
2843: CURSOR csr_chk_person_is_cwk IS
2844: SELECT per.person_id,
2845: per.effective_start_date
2846: FROM per_people_f per
2847: WHERE per.person_id = p_person_id
2848: AND per.current_npw_flag = 'Y'
2849: AND per.effective_start_date >= p_date_start;
2850: --

Line 3259: (p_person_id IN per_people_f.person_id%TYPE

3255: | |
3256: *============================================================================*/
3257: --
3258: PROCEDURE do_cancel_placement
3259: (p_person_id IN per_people_f.person_id%TYPE
3260: ,p_business_group_id IN per_people_f.business_group_id%TYPE
3261: ,p_effective_date IN DATE
3262: ,p_date_start IN DATE) AS
3263: --

Line 3260: ,p_business_group_id IN per_people_f.business_group_id%TYPE

3256: *============================================================================*/
3257: --
3258: PROCEDURE do_cancel_placement
3259: (p_person_id IN per_people_f.person_id%TYPE
3260: ,p_business_group_id IN per_people_f.business_group_id%TYPE
3261: ,p_effective_date IN DATE
3262: ,p_date_start IN DATE) AS
3263: --
3264: -- Declare local variables

Line 3430: FROM per_people_f p

3426: --
3427: CURSOR csr_person IS
3428: SELECT p.rowid,
3429: effective_end_date
3430: FROM per_people_f p
3431: WHERE p.person_id = p_person_id
3432: AND p.effective_start_date >= p_date_start;
3433: --
3434: -- new_person

Line 3438: FROM per_people_f p

3434: -- new_person
3435: --
3436: CURSOR csr_new_person IS
3437: SELECT p.rowid
3438: FROM per_people_f p
3439: WHERE p.person_id = p_person_id
3440: AND p.effective_end_date = p_date_start -1;
3441: --
3442: CURSOR csr_assignment_rate_values IS

Line 3902: UPDATE per_people_f -- 3194314

3898: AND p_date_start BETWEEN effective_start_date
3899: AND effective_end_date;
3900: --changes end for bug 7110731
3901:
3902: UPDATE per_people_f -- 3194314
3903: SET current_npw_flag = null
3904: ,effective_start_date = p_date_start -- in case DT udpates exist
3905: WHERE rowid = person_rec.rowid;
3906: --

Line 3911: DELETE FROM per_people_f

3907: ELSE -- #1998140
3908: --
3909: hr_utility.set_location(l_proc,400);
3910: --
3911: DELETE FROM per_people_f
3912: WHERE rowid = person_rec.rowid;
3913: --
3914: END IF;
3915: --

Line 3925: UPDATE per_people_f

3921:
3922: -- it should restore the EX_EMP record instead of removing it
3923: hr_utility.set_location(l_proc,405);
3924: --
3925: UPDATE per_people_f
3926: SET npw_number = null,
3927: effective_start_date = p_date_start, -- in case DT updates exist
3928: current_npw_flag = null,
3929: per_information7 = 'INCL'

Line 3937: DELETE FROM per_people_f

3933: ELSE -- #1998140
3934: --
3935: hr_utility.set_location(l_proc,406);
3936: --
3937: DELETE FROM per_people_f
3938: WHERE rowid = person_rec.rowid;
3939: --
3940: END IF;
3941: --

Line 3948: DELETE FROM per_people_f

3944: ELSE
3945: --
3946: hr_utility.set_location(l_proc,410);
3947: --
3948: DELETE FROM per_people_f
3949: WHERE rowid = person_rec.rowid;
3950: --
3951: END IF;
3952: --

Line 3992: UPDATE per_people_f

3988: IF NOT l_pop_back_to_back THEN
3989: --
3990: hr_utility.set_location(l_proc,460);
3991: --
3992: UPDATE per_people_f
3993: SET effective_end_date = l_end_of_time
3994: WHERE rowid = new_person_rec.rowid;
3995: --
3996: END IF;

Line 4124: , per_people_f per

4120: --
4121: CURSOR csr_leg_code IS
4122: SELECT pbg.legislation_code
4123: FROM per_business_groups pbg
4124: , per_people_f per
4125: WHERE per.person_id = p_person_id
4126: AND pbg.business_group_id = per.business_group_id;
4127: --
4128: -- Declare local variables