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 HR_COMMENTS

Line 193: from hr_comments h

189: -- Comments cursor
190: --
191: cursor comments is
192: select h.rowid
193: from hr_comments h
194: , per_assignments_f paf
195: where h.comment_id = paf.comment_id
196: and paf.business_group_id + 0 = p_business_group_id
197: and paf.person_id = p_person_id

Line 603: from hr_comments h

599: -- Comments cursor
600: --
601: cursor comments is
602: select h.rowid
603: from hr_comments h
604: , per_assignments_f paf
605: where h.comment_id = paf.comment_id
606: and paf.business_group_id + 0 = p_business_group_id
607: and paf.person_id = p_person_id

Line 2216: from hr_comments h

2212: -- comments cursor
2213: --
2214: cursor comments1 is
2215: select rowid
2216: from hr_comments h
2217: where exists (select 'comments exist'
2218: from per_all_assignments_f paf
2219: where h.comment_id = paf.comment_id
2220: and paf.business_group_id +0= p_business_group_id

Line 2585: delete from hr_comments h

2581: loop
2582: hr_utility.set_location('cancel_hire_or_apl.do_cancel_hire',220);
2583: fetch comments1 into p_rowid;
2584: exit when comments1%NOTFOUND;
2585: delete from hr_comments h
2586: where h.rowid = p_rowid;
2587: if sql%notfound then
2588: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2589: hr_utility.set_message_token('PROCEDURE','do_cancel_hire');

Line 3182: from hr_comments h

3178: -- Comments cursor
3179: --
3180: cursor comments2(p_assignment_id NUMBER) is
3181: select h.comment_id
3182: from hr_comments h
3183: , per_assignments_f paf
3184: where h.comment_id = paf.comment_id
3185: and paf.assignment_id = p_assignment_id;
3186: --

Line 3282: from hr_comments h, per_people_f ppf

3278: -- person comments when apl cursor
3279: --
3280: cursor person_apl_comments2 is
3281: select distinct h.comment_id --fix for bug 7157204.
3282: from hr_comments h, per_people_f ppf
3283: where ppf.business_group_id = p_business_group_id
3284: and ppf.person_id = p_person_id
3285: and ppf.effective_start_date >= p_date_received
3286: and ppf.comment_id = h.comment_id;

Line 3464: delete from hr_comments h

3460: <>
3461: loop
3462: fetch comments2 into l_pk_id;
3463: exit when comments2%NOTFOUND;
3464: delete from hr_comments h
3465: where h.comment_id = l_pk_id;
3466: if sql%notfound then
3467: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
3468: hr_utility.set_message_token('PROCEDURE','do_cancel_appl');

Line 3606: delete from hr_comments h

3602: <>
3603: loop
3604: fetch person_apl_comments2 into l_pk_id;
3605: exit when person_apl_comments2%NOTFOUND;
3606: delete from hr_comments h
3607: where h.comment_id = l_pk_id;
3608: if sql%notfound then
3609: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
3610: hr_utility.set_message_token('PROCEDURE','do_cancel_appl');

Line 4607: FROM hr_comments h

4603: -- comments cursor
4604: --
4605: CURSOR csr_comments IS
4606: SELECT ROWID
4607: FROM hr_comments h
4608: WHERE EXISTS (SELECT 'comments exist'
4609: FROM per_all_assignments_f paf
4610: WHERE h.comment_id = paf.comment_id
4611: AND paf.business_group_id +0 = p_business_group_id

Line 4883: DELETE FROM hr_comments h

4879: FOR comments_rec IN csr_comments LOOP
4880: --
4881: hr_utility.set_location(l_proc,140);
4882: --
4883: DELETE FROM hr_comments h
4884: WHERE h.rowid = comments_rec.rowid;
4885: --
4886: IF SQL%NOTFOUND THEN
4887: --