APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PER_APPLICATIONS

Line 316: from per_applications pap

312: -- applicant cursor
313: --
314: cursor applicant_rows is
315: select pap.rowid
316: from per_applications pap
317: where pap.person_id = p_person_id
318: for update of pap.person_id;
319: --
320: -- supervisor cursor.

Line 1361: from per_applications pap

1357: -- applications cursor
1358: --
1359: cursor applications is
1360: select rowid
1361: from per_applications pap
1362: where exists (select 'row exists'
1363: from per_all_assignments_f paf
1364: where paf.person_id = p_person_id
1365: and paf.business_group_id +0 = p_business_group_id

Line 1760: update per_applications pap

1756: loop
1757: hr_utility.set_location('cancel_hire_or_apl.do_cancel_hire',260);
1758: fetch applications into p_rowid;
1759: exit when applications%NOTFOUND;
1760: update per_applications pap
1761: set pap.date_end = NULL
1762: where pap.rowid = p_rowid;
1763: if sql%notfound then
1764: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 2199: from per_applications pap

2195: -- applications cursor
2196: --
2197: cursor applications is
2198: select rowid
2199: from per_applications pap
2200: where pap.date_received = p_date_received
2201: and pap.person_id = p_person_id;
2202: --
2203: -- person cursor

Line 2578: delete from per_applications pap

2574: <>
2575: loop
2576: fetch applications into l_rowid;
2577: exit when applications%NOTFOUND;
2578: delete from per_applications pap
2579: where pap.rowid = l_rowid;
2580: if sql%notfound then
2581: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2582: hr_utility.set_message_token('PROCEDURE','do_cancel_appl');

Line 3417: FROM per_applications pap

3413: -- applications cursor
3414: --
3415: CURSOR csr_applications IS
3416: SELECT ROWID
3417: FROM per_applications pap
3418: WHERE EXISTS (SELECT 'row exists'
3419: FROM per_all_assignments_f paf
3420: WHERE paf.person_id = p_person_id
3421: AND paf.business_group_id +0 = p_business_group_id

Line 3740: UPDATE per_applications pap

3736: FOR applicantions_rec IN csr_applications LOOP
3737: --
3738: hr_utility.set_location(l_proc,280);
3739: --
3740: UPDATE per_applications pap
3741: SET pap.date_end = NULL
3742: WHERE pap.rowid = applicantions_rec.rowid;
3743: --
3744: IF SQL%NOTFOUND THEN