APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PER_REQUISITIONS

Line 272: from per_requisitions pr

268: -- requisitions cursor
269: --
270: cursor requisitions is
271: select rowid
272: from per_requisitions pr
273: where (pr.business_group_id = p_business_group_id OR
274: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
275: and pr.person_id = p_person_id
276: for update of person_id;

Line 537: from per_requisitions pr

533: -- requisitions cursor
534: --
535: cursor requisitions is
536: select rowid
537: from per_requisitions pr
538: where (pr.business_group_id = p_business_group_id OR
539: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
540: and pr.person_id = p_person_id
541: for update of person_id;

Line 907: from per_requisitions pr

903: -- requisitions cursor
904: --
905: cursor requisition is
906: select rowid
907: from per_requisitions pr
908: where (pr.business_group_id = p_business_group_id OR
909: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
910: and pr.person_id = p_person_id
911: and pr.date_from >= p_primary_date; -- added for bug 9304366

Line 2159: from per_requisitions pr

2155: -- requisitions cursor
2156: --
2157: cursor requisitions1 is
2158: select rowid
2159: from per_requisitions pr
2160: where (pr.business_group_id = p_business_group_id OR
2161: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
2162: and pr.person_id = p_person_id
2163: and pr.date_from >= p_date_start; -- added for bug 9304366

Line 2513: update per_requisitions pr

2509: loop
2510: hr_utility.set_location('cancel_hire_or_apl.do_cancel_hire',150);
2511: fetch requisitions1 into p_rowid;
2512: exit when requisitions1%NOTFOUND;
2513: update per_requisitions pr
2514: set pr.person_id = NULL
2515: where pr.rowid = p_rowid;
2516: if sql%notfound then
2517: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 4084: FROM per_requisitions pr

4080: -- requisitions cursor
4081: --
4082: CURSOR csr_requisition IS
4083: SELECT ROWID
4084: FROM per_requisitions pr
4085: WHERE (pr.business_group_id = p_business_group_id OR
4086: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
4087: AND pr.person_id = p_person_id;
4088: --

Line 4520: FROM per_requisitions pr

4516: -- requisitions cursor
4517: --
4518: CURSOR csr_requisitions IS
4519: SELECT ROWID
4520: FROM per_requisitions pr
4521: WHERE (pr.business_group_id = p_business_group_id OR
4522: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
4523: AND pr.person_id = p_person_id;
4524: --

Line 4903: UPDATE per_requisitions pr

4899: FOR requisition_rec IN csr_requisitions LOOP
4900: --
4901: hr_utility.set_location(l_proc,160);
4902: --
4903: UPDATE per_requisitions pr
4904: SET pr.person_id = NULL
4905: WHERE pr.rowid = requisition_rec.rowid;
4906: --
4907: IF SQL%NOTFOUND THEN