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 398: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type

394: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type
395: ,p_organization OUT NOCOPY hr_organization_units.name%type
396: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type
397: ,p_job OUT NOCOPY per_jobs.name%type
398: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type
399: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
400: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
401: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
402: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type

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

395: ,p_organization OUT NOCOPY hr_organization_units.name%type
396: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type
397: ,p_job OUT NOCOPY per_jobs.name%type
398: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type
399: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
400: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
401: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
402: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
403: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type

Line 471: from per_vacancies

467: and p_effective_date between effective_start_date and effective_end_date;
468: --
469: cursor get_vac is
470: select position_id
471: from per_vacancies
472: where vacancy_id=p_vacancy_id
473: and p_effective_date between date_from and nvl(date_to,p_effective_date);
474: --
475: begin

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

636: procedure get_org_defaults
637: (p_organization_id IN per_all_assignments_f.organization_id%type
638: ,p_defaulting IN varchar2
639: ,p_effective_date IN date
640: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type
641: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
642: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
643: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
644: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type

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

637: (p_organization_id IN per_all_assignments_f.organization_id%type
638: ,p_defaulting IN varchar2
639: ,p_effective_date IN date
640: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type
641: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
642: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
643: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
644: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
645: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type

Line 705: from per_vacancies

701: --
702: --
703: cursor get_vac is
704: select organization_id
705: from per_vacancies
706: where vacancy_id=p_vacancy_id
707: and p_effective_date between date_from and nvl(date_to,p_effective_date);
708: --
709: cursor chk_pos_org(ln_position_id number

Line 905: l_vacancy_id per_vacancies.vacancy_id%type;

901: l_location_id per_all_assignments_f.location_id%type;
902: l_organization_id per_all_assignments_f.organization_id%type;
903: l_people_group_id per_all_assignments_f.people_group_id%type;
904: l_pgp_rec pay_people_groups%rowtype;
905: l_vacancy_id per_vacancies.vacancy_id%type;
906: l_vacancy per_vacancies.name%type;
907: l_dummy number;
908: --
909: cursor get_vac_details is

Line 906: l_vacancy per_vacancies.name%type;

902: l_organization_id per_all_assignments_f.organization_id%type;
903: l_people_group_id per_all_assignments_f.people_group_id%type;
904: l_pgp_rec pay_people_groups%rowtype;
905: l_vacancy_id per_vacancies.vacancy_id%type;
906: l_vacancy per_vacancies.name%type;
907: l_dummy number;
908: --
909: cursor get_vac_details is
910: select recruiter_id

Line 917: from per_vacancies

913: , job_id
914: , location_id
915: , organization_id
916: , people_group_id
917: from per_vacancies
918: where vacancy_id=p_vacancy_id;
919: --
920: cursor get_pgp(pgp_id number) is
921: select *