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.HR_PSF_BUS dependencies on HR_POSITIONS_F

Line 1765: , hr_positions_f pos

1761: --
1762: cursor csr_leg_code is
1763: select pbg.legislation_code
1764: from per_business_groups pbg
1765: , hr_positions_f pos
1766: where pos.position_id = p_position_id
1767: and pbg.business_group_id = pos.business_group_id
1768: order by pos.effective_start_date;
1769: --

Line 2018: (p_position_id in hr_positions_f.position_id%TYPE default null

2014: -- |-----------------------------< chk_job_id >------------------------------|
2015: -- ---------------------------------------------------------------------------
2016: --
2017: procedure chk_job_id
2018: (p_position_id in hr_positions_f.position_id%TYPE default null
2019: ,p_business_group_id in hr_positions_f.business_group_id%TYPE
2020: ,p_job_id in hr_positions_f.job_id%TYPE
2021: ,p_effective_date in date
2022: ,p_validation_start_date in hr_positions_f.effective_start_date%TYPE

Line 2019: ,p_business_group_id in hr_positions_f.business_group_id%TYPE

2015: -- ---------------------------------------------------------------------------
2016: --
2017: procedure chk_job_id
2018: (p_position_id in hr_positions_f.position_id%TYPE default null
2019: ,p_business_group_id in hr_positions_f.business_group_id%TYPE
2020: ,p_job_id in hr_positions_f.job_id%TYPE
2021: ,p_effective_date in date
2022: ,p_validation_start_date in hr_positions_f.effective_start_date%TYPE
2023: ,p_validation_end_date in hr_positions_f.effective_end_date%TYPE

Line 2020: ,p_job_id in hr_positions_f.job_id%TYPE

2016: --
2017: procedure chk_job_id
2018: (p_position_id in hr_positions_f.position_id%TYPE default null
2019: ,p_business_group_id in hr_positions_f.business_group_id%TYPE
2020: ,p_job_id in hr_positions_f.job_id%TYPE
2021: ,p_effective_date in date
2022: ,p_validation_start_date in hr_positions_f.effective_start_date%TYPE
2023: ,p_validation_end_date in hr_positions_f.effective_end_date%TYPE
2024: ,p_object_version_number in hr_positions_f.object_version_number%TYPE default null

Line 2022: ,p_validation_start_date in hr_positions_f.effective_start_date%TYPE

2018: (p_position_id in hr_positions_f.position_id%TYPE default null
2019: ,p_business_group_id in hr_positions_f.business_group_id%TYPE
2020: ,p_job_id in hr_positions_f.job_id%TYPE
2021: ,p_effective_date in date
2022: ,p_validation_start_date in hr_positions_f.effective_start_date%TYPE
2023: ,p_validation_end_date in hr_positions_f.effective_end_date%TYPE
2024: ,p_object_version_number in hr_positions_f.object_version_number%TYPE default null
2025: )
2026: is

Line 2023: ,p_validation_end_date in hr_positions_f.effective_end_date%TYPE

2019: ,p_business_group_id in hr_positions_f.business_group_id%TYPE
2020: ,p_job_id in hr_positions_f.job_id%TYPE
2021: ,p_effective_date in date
2022: ,p_validation_start_date in hr_positions_f.effective_start_date%TYPE
2023: ,p_validation_end_date in hr_positions_f.effective_end_date%TYPE
2024: ,p_object_version_number in hr_positions_f.object_version_number%TYPE default null
2025: )
2026: is
2027: --

Line 2024: ,p_object_version_number in hr_positions_f.object_version_number%TYPE default null

2020: ,p_job_id in hr_positions_f.job_id%TYPE
2021: ,p_effective_date in date
2022: ,p_validation_start_date in hr_positions_f.effective_start_date%TYPE
2023: ,p_validation_end_date in hr_positions_f.effective_end_date%TYPE
2024: ,p_object_version_number in hr_positions_f.object_version_number%TYPE default null
2025: )
2026: is
2027: --
2028: l_proc varchar2(72) ;

Line 2031: l_business_group_id hr_positions_f.business_group_id%TYPE;

2027: --
2028: l_proc varchar2(72) ;
2029: l_exists varchar2(1);
2030: l_api_updating boolean;
2031: l_business_group_id hr_positions_f.business_group_id%TYPE;
2032: l_vac_job_id hr_positions_f.job_id%TYPE;
2033: --
2034: cursor csr_valid_job_id is
2035: select 'x'

Line 2032: l_vac_job_id hr_positions_f.job_id%TYPE;

2028: l_proc varchar2(72) ;
2029: l_exists varchar2(1);
2030: l_api_updating boolean;
2031: l_business_group_id hr_positions_f.business_group_id%TYPE;
2032: l_vac_job_id hr_positions_f.job_id%TYPE;
2033: --
2034: cursor csr_valid_job_id is
2035: select 'x'
2036: from per_jobs_v job

Line 2147: (p_position_id in hr_positions_f.position_id%TYPE default null

2143: -- |-----------------------< chk_organization_id >---------------------------|
2144: -- ---------------------------------------------------------------------------
2145: --
2146: procedure chk_organization_id
2147: (p_position_id in hr_positions_f.position_id%TYPE default null
2148: ,p_organization_id in hr_positions_f.organization_id%TYPE
2149: ,p_business_group_id in hr_positions_f.business_group_id%TYPE
2150: ,p_validation_start_date in hr_positions_f.effective_start_date%TYPE
2151: ,p_validation_end_date in hr_positions_f.effective_end_date%TYPE

Line 2148: ,p_organization_id in hr_positions_f.organization_id%TYPE

2144: -- ---------------------------------------------------------------------------
2145: --
2146: procedure chk_organization_id
2147: (p_position_id in hr_positions_f.position_id%TYPE default null
2148: ,p_organization_id in hr_positions_f.organization_id%TYPE
2149: ,p_business_group_id in hr_positions_f.business_group_id%TYPE
2150: ,p_validation_start_date in hr_positions_f.effective_start_date%TYPE
2151: ,p_validation_end_date in hr_positions_f.effective_end_date%TYPE
2152: ,p_effective_date in date

Line 2149: ,p_business_group_id in hr_positions_f.business_group_id%TYPE

2145: --
2146: procedure chk_organization_id
2147: (p_position_id in hr_positions_f.position_id%TYPE default null
2148: ,p_organization_id in hr_positions_f.organization_id%TYPE
2149: ,p_business_group_id in hr_positions_f.business_group_id%TYPE
2150: ,p_validation_start_date in hr_positions_f.effective_start_date%TYPE
2151: ,p_validation_end_date in hr_positions_f.effective_end_date%TYPE
2152: ,p_effective_date in date
2153: ,p_object_version_number in hr_positions_f.object_version_number%TYPE default null

Line 2150: ,p_validation_start_date in hr_positions_f.effective_start_date%TYPE

2146: procedure chk_organization_id
2147: (p_position_id in hr_positions_f.position_id%TYPE default null
2148: ,p_organization_id in hr_positions_f.organization_id%TYPE
2149: ,p_business_group_id in hr_positions_f.business_group_id%TYPE
2150: ,p_validation_start_date in hr_positions_f.effective_start_date%TYPE
2151: ,p_validation_end_date in hr_positions_f.effective_end_date%TYPE
2152: ,p_effective_date in date
2153: ,p_object_version_number in hr_positions_f.object_version_number%TYPE default null
2154: )

Line 2151: ,p_validation_end_date in hr_positions_f.effective_end_date%TYPE

2147: (p_position_id in hr_positions_f.position_id%TYPE default null
2148: ,p_organization_id in hr_positions_f.organization_id%TYPE
2149: ,p_business_group_id in hr_positions_f.business_group_id%TYPE
2150: ,p_validation_start_date in hr_positions_f.effective_start_date%TYPE
2151: ,p_validation_end_date in hr_positions_f.effective_end_date%TYPE
2152: ,p_effective_date in date
2153: ,p_object_version_number in hr_positions_f.object_version_number%TYPE default null
2154: )
2155: is

Line 2153: ,p_object_version_number in hr_positions_f.object_version_number%TYPE default null

2149: ,p_business_group_id in hr_positions_f.business_group_id%TYPE
2150: ,p_validation_start_date in hr_positions_f.effective_start_date%TYPE
2151: ,p_validation_end_date in hr_positions_f.effective_end_date%TYPE
2152: ,p_effective_date in date
2153: ,p_object_version_number in hr_positions_f.object_version_number%TYPE default null
2154: )
2155: is
2156: --
2157: l_exists varchar2(1);

Line 2160: l_business_group_id hr_positions_f.business_group_id%TYPE;

2156: --
2157: l_exists varchar2(1);
2158: l_api_updating boolean;
2159: l_proc varchar2(72);
2160: l_business_group_id hr_positions_f.business_group_id%TYPE;
2161: --
2162: cursor csr_valid_organization_id is
2163: select 'x'
2164: from per_organization_units oru