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.

[Home] [Help]

APPS.PER_VACANCY_API dependencies on PER_VAC_SHD

Line 582: if (nvl(p_organization_id,0) <> nvl(per_vac_shd.g_old_rec.organization_id,0))

578: --
579: l_ASSIGNMENT_CHANGED := FALSE;
580: --
581: -- start changes for bug 8518955
582: if (nvl(p_organization_id,0) <> nvl(per_vac_shd.g_old_rec.organization_id,0))
583: and (nvl(p_organization_id,0) <> hr_api.g_number)
584: then
585: l_ASSIGNMENT_CHANGED := TRUE;
586: --l_organization_id := p_organization_id;

Line 590: if (nvl(p_job_id,0) <> nvl(per_vac_shd.g_old_rec.job_id,0))

586: --l_organization_id := p_organization_id;
587: --l_position_id := p_position_id;
588: end if;
589: --
590: if (nvl(p_job_id,0) <> nvl(per_vac_shd.g_old_rec.job_id,0))
591: and (nvl(p_job_id,0) <> hr_api.g_number)
592: then
593: l_ASSIGNMENT_CHANGED := TRUE;
594: --l_job_id := p_job_id;

Line 598: if (nvl(p_grade_id,0)<> nvl(per_vac_shd.g_old_rec.grade_id,0))

594: --l_job_id := p_job_id;
595: --l_position_id := p_position_id;
596: end if;
597: --
598: if (nvl(p_grade_id,0)<> nvl(per_vac_shd.g_old_rec.grade_id,0))
599: and (nvl(p_grade_id,0) <> hr_api.g_number)
600: then
601: l_ASSIGNMENT_CHANGED := TRUE;
602: --l_grade_id := p_grade_id;

Line 605: if (nvl(p_people_group_id,0) <> nvl(per_vac_shd.g_old_rec.people_group_id,0))

601: l_ASSIGNMENT_CHANGED := TRUE;
602: --l_grade_id := p_grade_id;
603: end if;
604: --
605: if (nvl(p_people_group_id,0) <> nvl(per_vac_shd.g_old_rec.people_group_id,0))
606: and (nvl(p_people_group_id,0) <> hr_api.g_number)
607: then
608: l_ASSIGNMENT_CHANGED := TRUE;
609: --l_people_group_id := p_people_group_id;

Line 612: if (nvl(p_position_id,0) <> nvl(per_vac_shd.g_old_rec.position_id,0))

608: l_ASSIGNMENT_CHANGED := TRUE;
609: --l_people_group_id := p_people_group_id;
610: end if;
611: --
612: if (nvl(p_position_id,0) <> nvl(per_vac_shd.g_old_rec.position_id,0))
613: and (nvl(p_position_id,0) <> hr_api.g_number)
614: then
615: l_ASSIGNMENT_CHANGED := TRUE;
616: --l_position_id := p_position_id;

Line 619: if (nvl(p_location_id,0) <> nvl(per_vac_shd.g_old_rec.location_id,0))

615: l_ASSIGNMENT_CHANGED := TRUE;
616: --l_position_id := p_position_id;
617: end if;
618: --
619: if (nvl(p_location_id,0) <> nvl(per_vac_shd.g_old_rec.location_id,0))
620: and (nvl(p_location_id,0) <> hr_api.g_number)
621: then
622: l_ASSIGNMENT_CHANGED := TRUE;
623: --l_location_id := p_location_id;

Line 626: if (nvl(p_recruiter_id,0) <> nvl(per_vac_shd.g_old_rec.recruiter_id,0))

622: l_ASSIGNMENT_CHANGED := TRUE;
623: --l_location_id := p_location_id;
624: end if;
625: --
626: if (nvl(p_recruiter_id,0) <> nvl(per_vac_shd.g_old_rec.recruiter_id,0))
627: and (nvl(p_recruiter_id,0) <> hr_api.g_number)
628: then
629: l_ASSIGNMENT_CHANGED := TRUE;
630: --l_recruiter_id := p_recruiter_id;

Line 633: if (nvl(p_manager_id,0) <> nvl(per_vac_shd.g_old_rec.manager_id,0))

629: l_ASSIGNMENT_CHANGED := TRUE;
630: --l_recruiter_id := p_recruiter_id;
631: end if;
632: --
633: if (nvl(p_manager_id,0) <> nvl(per_vac_shd.g_old_rec.manager_id,0))
634: and (nvl(p_manager_id,0) <> hr_api.g_number)
635: then
636: l_ASSIGNMENT_CHANGED := TRUE;
637: --l_manager_id := p_manager_id;

Line 647: when nvl(p_job_id,0) = hr_api.g_number then per_vac_shd.g_old_rec.job_id

643: --l_position_id := p_position_id;
644: hr_utility.set_location(l_proc, 40);
645:
646: l_job_id := case
647: when nvl(p_job_id,0) = hr_api.g_number then per_vac_shd.g_old_rec.job_id
648: else p_job_id
649: end;
650:
651: l_grade_id := case

Line 652: when nvl(p_grade_id,0) = hr_api.g_number then per_vac_shd.g_old_rec.grade_id

648: else p_job_id
649: end;
650:
651: l_grade_id := case
652: when nvl(p_grade_id,0) = hr_api.g_number then per_vac_shd.g_old_rec.grade_id
653: else p_grade_id
654: end;
655:
656: l_people_group_id := case

Line 657: when nvl(p_people_group_id,0) = hr_api.g_number then per_vac_shd.g_old_rec.people_group_id

653: else p_grade_id
654: end;
655:
656: l_people_group_id := case
657: when nvl(p_people_group_id,0) = hr_api.g_number then per_vac_shd.g_old_rec.people_group_id
658: else P_people_group_id
659: end;
660:
661: l_organization_id := case

Line 662: when nvl(p_organization_id,0) = hr_api.g_number then per_vac_shd.g_old_rec.organization_id

658: else P_people_group_id
659: end;
660:
661: l_organization_id := case
662: when nvl(p_organization_id,0) = hr_api.g_number then per_vac_shd.g_old_rec.organization_id
663: else nvl(p_organization_id,per_vac_shd.g_old_rec.organization_id)
664: end;
665:
666: l_position_id := case

Line 663: else nvl(p_organization_id,per_vac_shd.g_old_rec.organization_id)

659: end;
660:
661: l_organization_id := case
662: when nvl(p_organization_id,0) = hr_api.g_number then per_vac_shd.g_old_rec.organization_id
663: else nvl(p_organization_id,per_vac_shd.g_old_rec.organization_id)
664: end;
665:
666: l_position_id := case
667: when nvl(p_position_id,0) = hr_api.g_number then per_vac_shd.g_old_rec.position_id

Line 667: when nvl(p_position_id,0) = hr_api.g_number then per_vac_shd.g_old_rec.position_id

663: else nvl(p_organization_id,per_vac_shd.g_old_rec.organization_id)
664: end;
665:
666: l_position_id := case
667: when nvl(p_position_id,0) = hr_api.g_number then per_vac_shd.g_old_rec.position_id
668: else p_position_id
669: end;
670:
671: l_location_id := case

Line 672: when nvl(p_location_id,0) = hr_api.g_number then per_vac_shd.g_old_rec.location_id

668: else p_position_id
669: end;
670:
671: l_location_id := case
672: when nvl(p_location_id,0) = hr_api.g_number then per_vac_shd.g_old_rec.location_id
673: else p_location_id
674: end;
675:
676: l_manager_id := case

Line 677: when nvl(p_manager_id,0) = hr_api.g_number then per_vac_shd.g_old_rec.manager_id

673: else p_location_id
674: end;
675:
676: l_manager_id := case
677: when nvl(p_manager_id,0) = hr_api.g_number then per_vac_shd.g_old_rec.manager_id
678: else p_manager_id
679: end;
680:
681: l_recruiter_id := case

Line 682: when nvl(p_recruiter_id,0) = hr_api.g_number then per_vac_shd.g_old_rec.recruiter_id

678: else p_manager_id
679: end;
680:
681: l_recruiter_id := case
682: when nvl(p_recruiter_id,0) = hr_api.g_number then per_vac_shd.g_old_rec.recruiter_id
683: else p_recruiter_id
684: end;
685: --
686: /*update per_all_assignments_f asg

Line 696: per_vac_shd.g_old_rec.organization_id||'.'||per_vac_shd.g_old_rec.job_id,

692: ,asg.recruiter_id = nvl(l_recruiter_id, asg.recruiter_id)
693: ,asg.supervisor_id = nvl(l_manager_id, asg.supervisor_id)
694: ,asg.position_id = decode
695: (l_organization_id||'.'||l_job_id,
696: per_vac_shd.g_old_rec.organization_id||'.'||per_vac_shd.g_old_rec.job_id,
697: nvl(l_position_id, asg.position_id),
698: l_position_id) */
699:
700: update per_all_assignments_f asg