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_QH_POPULATE dependencies on PER_VACANCIES

Line 391: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type

387: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type
388: ,p_organization OUT NOCOPY hr_organization_units.name%type
389: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type
390: ,p_job OUT NOCOPY per_jobs.name%type
391: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type
392: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
393: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
394: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
395: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type

Line 392: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type

388: ,p_organization OUT NOCOPY hr_organization_units.name%type
389: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type
390: ,p_job OUT NOCOPY per_jobs.name%type
391: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type
392: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
393: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
394: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
395: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
396: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type

Line 464: from per_vacancies

460: and p_effective_date between effective_start_date and effective_end_date;
461: --
462: cursor get_vac is
463: select position_id
464: from per_vacancies
465: where vacancy_id=p_vacancy_id
466: and p_effective_date between date_from and nvl(date_to,p_effective_date);
467: --
468: begin

Line 633: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type

629: procedure get_org_defaults
630: (p_organization_id IN per_all_assignments_f.organization_id%type
631: ,p_defaulting IN varchar2
632: ,p_effective_date IN date
633: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type
634: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
635: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
636: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
637: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type

Line 634: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type

630: (p_organization_id IN per_all_assignments_f.organization_id%type
631: ,p_defaulting IN varchar2
632: ,p_effective_date IN date
633: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type
634: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
635: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
636: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
637: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
638: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type

Line 698: from per_vacancies

694: --
695: --
696: cursor get_vac is
697: select organization_id
698: from per_vacancies
699: where vacancy_id=p_vacancy_id
700: and p_effective_date between date_from and nvl(date_to,p_effective_date);
701: --
702: cursor chk_pos_org(ln_position_id number

Line 898: l_vacancy_id per_vacancies.vacancy_id%type;

894: l_location_id per_all_assignments_f.location_id%type;
895: l_organization_id per_all_assignments_f.organization_id%type;
896: l_people_group_id per_all_assignments_f.people_group_id%type;
897: l_pgp_rec pay_people_groups%rowtype;
898: l_vacancy_id per_vacancies.vacancy_id%type;
899: l_vacancy per_vacancies.name%type;
900: l_dummy number;
901: --
902: cursor get_vac_details is

Line 899: l_vacancy per_vacancies.name%type;

895: l_organization_id per_all_assignments_f.organization_id%type;
896: l_people_group_id per_all_assignments_f.people_group_id%type;
897: l_pgp_rec pay_people_groups%rowtype;
898: l_vacancy_id per_vacancies.vacancy_id%type;
899: l_vacancy per_vacancies.name%type;
900: l_dummy number;
901: --
902: cursor get_vac_details is
903: select recruiter_id

Line 910: from per_vacancies

906: , job_id
907: , location_id
908: , organization_id
909: , people_group_id
910: from per_vacancies
911: where vacancy_id=p_vacancy_id;
912: --
913: cursor get_pgp(pgp_id number) is
914: select *