APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PER_REQUISITIONS

Line 104: from per_requisitions pr

100: -- requisitions cursor
101: --
102: cursor requisitions is
103: select rowid
104: from per_requisitions pr
105: where (pr.business_group_id = p_business_group_id OR
106: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
107: and pr.person_id = p_person_id
108: for update of person_id;

Line 369: from per_requisitions pr

365: -- requisitions cursor
366: --
367: cursor requisitions is
368: select rowid
369: from per_requisitions pr
370: where (pr.business_group_id = p_business_group_id OR
371: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
372: and pr.person_id = p_person_id
373: for update of person_id;

Line 724: from per_requisitions pr

720: -- requisitions cursor
721: --
722: cursor requisition is
723: select rowid
724: from per_requisitions pr
725: where (pr.business_group_id = p_business_group_id OR
726: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
727: and pr.person_id = p_person_id;
728: --

Line 1249: from per_requisitions pr

1245: -- requisitions cursor
1246: --
1247: cursor requisitions1 is
1248: select rowid
1249: from per_requisitions pr
1250: where (pr.business_group_id = p_business_group_id OR
1251: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
1252: and pr.person_id = p_person_id;
1253: --

Line 1593: update per_requisitions pr

1589: loop
1590: hr_utility.set_location('cancel_hire_or_apl.do_cancel_hire',150);
1591: fetch requisitions1 into p_rowid;
1592: exit when requisitions1%NOTFOUND;
1593: update per_requisitions pr
1594: set pr.person_id = NULL
1595: where pr.rowid = p_rowid;
1596: if sql%notfound then
1597: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 2906: FROM per_requisitions pr

2902: -- requisitions cursor
2903: --
2904: CURSOR csr_requisition IS
2905: SELECT ROWID
2906: FROM per_requisitions pr
2907: WHERE (pr.business_group_id = p_business_group_id OR
2908: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
2909: AND pr.person_id = p_person_id;
2910: --

Line 3305: FROM per_requisitions pr

3301: -- requisitions cursor
3302: --
3303: CURSOR csr_requisitions IS
3304: SELECT ROWID
3305: FROM per_requisitions pr
3306: WHERE (pr.business_group_id = p_business_group_id OR
3307: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
3308: AND pr.person_id = p_person_id;
3309: --

Line 3629: UPDATE per_requisitions pr

3625: FOR requisition_rec IN csr_requisitions LOOP
3626: --
3627: hr_utility.set_location(l_proc,160);
3628: --
3629: UPDATE per_requisitions pr
3630: SET pr.person_id = NULL
3631: WHERE pr.rowid = requisition_rec.rowid;
3632: --
3633: IF SQL%NOTFOUND THEN