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.PQH_PSF_BUS dependencies on HR_PSF_SHD

Line 62: procedure hr_psf_bus_insert_validate(p_rec in hr_psf_shd.g_rec_type

58: -- ---------------------------------------------------------------------------
59: -- |-----------------< hr_psf_bus_insert_validate >---------------------|
60: -- ---------------------------------------------------------------------------
61: --
62: procedure hr_psf_bus_insert_validate(p_rec in hr_psf_shd.g_rec_type
63: ,p_effective_date in date
64: ) is
65: l_chk_position_job_grade boolean;
66: l_transaction_status varchar2(100);

Line 95: procedure hr_psf_bus_update_validate(p_rec in hr_psf_shd.g_rec_type

91: -- ---------------------------------------------------------------------------
92: -- |-----------------< hr_psf_bus_update_validate >---------------------|
93: -- ---------------------------------------------------------------------------
94: --
95: procedure hr_psf_bus_update_validate(p_rec in hr_psf_shd.g_rec_type
96: ,p_effective_date in date
97: ,p_validation_start_date in date
98: ,p_validation_end_date in date
99: ,p_datetrack_mode in varchar2

Line 162: ('ELIMINATED'=hr_psf_shd.get_availability_status(

158: hr_utility.set_location('AVAILABILITY_STATUS_ID :'||p_rec.availability_status_id, 620);
159:
160: if ((p_datetrack_mode IN ('CORRECTION', 'UPDATE','UPDATE_CHANGE_INSERT',
161: 'UPDATE_OVERRIDE')) AND
162: ('ELIMINATED'=hr_psf_shd.get_availability_status(
163: p_rec.availability_status_id,p_rec.business_group_id))) then
164: hr_utility.set_location('AVAILABILITY STATUS : ELIMINATED', 621);
165: if (pqh_psf_bus.pos_assignments_exist(p_rec.position_id,
166: p_validation_start_date, p_validation_end_date)) then

Line 1379: hr_psf_shd.get_availability_status(l_availability_status_id,l_business_group_id);

1375: fetch c_positions into
1376: l_availability_status_id,l_business_group_id, l_position_type, l_pos_effective_date;
1377: close c_positions;
1378: l_availability_status :=
1379: hr_psf_shd.get_availability_status(l_availability_status_id,l_business_group_id);
1380: hr_utility.set_location('Open Status- l_availability_status:'||l_availability_status,
1381: 310);
1382: hr_utility.set_location('Open Status- l_position_type:'||l_position_type,
1383: 320);

Line 2148: hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = 'FTE'

2144: and budgeted_entity_cd = 'POSITION'
2145: and business_group_id = l_business_group_id
2146: and p_effective_date between budget_start_date and budget_end_date
2147: and (
2148: hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = 'FTE'
2149: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = 'FTE'
2150: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = 'FTE'
2151: );
2152: --

Line 2149: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = 'FTE'

2145: and business_group_id = l_business_group_id
2146: and p_effective_date between budget_start_date and budget_end_date
2147: and (
2148: hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = 'FTE'
2149: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = 'FTE'
2150: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = 'FTE'
2151: );
2152: --
2153: hr_utility.set_location('l_budget_id:' || l_budget_id, 600);

Line 2150: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = 'FTE'

2146: and p_effective_date between budget_start_date and budget_end_date
2147: and (
2148: hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = 'FTE'
2149: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = 'FTE'
2150: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = 'FTE'
2151: );
2152: --
2153: hr_utility.set_location('l_budget_id:' || l_budget_id, 600);
2154: hr_utility.set_location('l_calendar:' || l_calendar, 600);

Line 2601: hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = p_unit_of_measure

2597: and budgeted_entity_cd = p_budget_entity
2598: and business_group_id = p_business_group_id
2599: and p_effective_date between budget_start_date and budget_end_date
2600: and (
2601: hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = p_unit_of_measure
2602: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = p_unit_of_measure
2603: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = p_unit_of_measure
2604: );
2605: --

Line 2602: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = p_unit_of_measure

2598: and business_group_id = p_business_group_id
2599: and p_effective_date between budget_start_date and budget_end_date
2600: and (
2601: hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = p_unit_of_measure
2602: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = p_unit_of_measure
2603: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = p_unit_of_measure
2604: );
2605: --
2606: hr_utility.set_location('p_effective_date' || p_effective_date, 600);

Line 2603: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = p_unit_of_measure

2599: and p_effective_date between budget_start_date and budget_end_date
2600: and (
2601: hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = p_unit_of_measure
2602: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = p_unit_of_measure
2603: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = p_unit_of_measure
2604: );
2605: --
2606: hr_utility.set_location('p_effective_date' || p_effective_date, 600);
2607: hr_utility.set_location('l_budget_id:' || l_budget_id, 600);

Line 2871: hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = 'MONEY'

2867: and budgeted_entity_cd = 'POSITION'
2868: and business_group_id = l_business_group_id
2869: and p_effective_date between budget_start_date and budget_end_date
2870: and (
2871: hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = 'MONEY'
2872: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = 'MONEY'
2873: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = 'MONEY'
2874: );
2875: hr_utility.set_location('budget is:'||l_budget_id,30);

Line 2872: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = 'MONEY'

2868: and business_group_id = l_business_group_id
2869: and p_effective_date between budget_start_date and budget_end_date
2870: and (
2871: hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = 'MONEY'
2872: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = 'MONEY'
2873: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = 'MONEY'
2874: );
2875: hr_utility.set_location('budget is:'||l_budget_id,30);
2876: open c1(l_budget_unit1_id);

Line 2873: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = 'MONEY'

2869: and p_effective_date between budget_start_date and budget_end_date
2870: and (
2871: hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = 'MONEY'
2872: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = 'MONEY'
2873: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = 'MONEY'
2874: );
2875: hr_utility.set_location('budget is:'||l_budget_id,30);
2876: open c1(l_budget_unit1_id);
2877: fetch c1 into l_unit1_name;

Line 2962: hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = 'MONEY'

2958: and budgeted_entity_cd = 'POSITION'
2959: and business_group_id = l_business_group_id
2960: and p_effective_date between budget_start_date and budget_end_date
2961: and (
2962: hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = 'MONEY'
2963: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = 'MONEY'
2964: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = 'MONEY'
2965: );
2966: hr_utility.set_location('budget exists' || l_budget_id, 50);

Line 2963: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = 'MONEY'

2959: and business_group_id = l_business_group_id
2960: and p_effective_date between budget_start_date and budget_end_date
2961: and (
2962: hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = 'MONEY'
2963: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = 'MONEY'
2964: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = 'MONEY'
2965: );
2966: hr_utility.set_location('budget exists' || l_budget_id, 50);
2967: hr_utility.set_location('start_date is '||to_char(l_start_date,'dd-MM-RRRR'),55);

Line 2964: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = 'MONEY'

2960: and p_effective_date between budget_start_date and budget_end_date
2961: and (
2962: hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = 'MONEY'
2963: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = 'MONEY'
2964: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = 'MONEY'
2965: );
2966: hr_utility.set_location('budget exists' || l_budget_id, 50);
2967: hr_utility.set_location('start_date is '||to_char(l_start_date,'dd-MM-RRRR'),55);
2968: hr_utility.set_location('end_date is '||to_char(l_end_date,'dd-MM-RRRR'),60);

Line 3087: hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = 'MONEY'

3083: and budgeted_entity_cd = 'POSITION'
3084: and business_group_id = l_business_group_id
3085: and p_effective_date between budget_start_date and budget_end_date
3086: and (
3087: hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = 'MONEY'
3088: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = 'MONEY'
3089: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = 'MONEY'
3090: );
3091: --

Line 3088: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = 'MONEY'

3084: and business_group_id = l_business_group_id
3085: and p_effective_date between budget_start_date and budget_end_date
3086: and (
3087: hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = 'MONEY'
3088: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = 'MONEY'
3089: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = 'MONEY'
3090: );
3091: --
3092: select budget_version_id into l_budget_version_id

Line 3089: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = 'MONEY'

3085: and p_effective_date between budget_start_date and budget_end_date
3086: and (
3087: hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit1_id) = 'MONEY'
3088: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit2_id) = 'MONEY'
3089: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(budget_unit3_id) = 'MONEY'
3090: );
3091: --
3092: select budget_version_id into l_budget_version_id
3093: from pqh_budget_versions bvr

Line 4305: and (hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(bgt.budget_unit1_id) = p_budget_unit_cd

4301: and p_effective_date between bgt.budget_start_date and bgt.budget_end_date
4302: and p_effective_date between bver.date_from and bver.date_to
4303: and bgt.budgeted_entity_cd = 'POSITION'
4304: and bgt.position_control_flag = 'Y'
4305: and (hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(bgt.budget_unit1_id) = p_budget_unit_cd
4306: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(bgt.budget_unit2_id) = p_budget_unit_cd
4307: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(bgt.budget_unit3_id) = p_budget_unit_cd);
4308: --
4309: begin

Line 4306: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(bgt.budget_unit2_id) = p_budget_unit_cd

4302: and p_effective_date between bver.date_from and bver.date_to
4303: and bgt.budgeted_entity_cd = 'POSITION'
4304: and bgt.position_control_flag = 'Y'
4305: and (hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(bgt.budget_unit1_id) = p_budget_unit_cd
4306: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(bgt.budget_unit2_id) = p_budget_unit_cd
4307: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(bgt.budget_unit3_id) = p_budget_unit_cd);
4308: --
4309: begin
4310: open c_pc_budget_info(p_position_id, p_budget_unit_cd, p_effective_date);

Line 4307: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(bgt.budget_unit3_id) = p_budget_unit_cd);

4303: and bgt.budgeted_entity_cd = 'POSITION'
4304: and bgt.position_control_flag = 'Y'
4305: and (hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(bgt.budget_unit1_id) = p_budget_unit_cd
4306: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(bgt.budget_unit2_id) = p_budget_unit_cd
4307: or hr_psf_shd.SYSTEM_AVAILABILITY_STATUS(bgt.budget_unit3_id) = p_budget_unit_cd);
4308: --
4309: begin
4310: open c_pc_budget_info(p_position_id, p_budget_unit_cd, p_effective_date);
4311: fetch c_pc_budget_info into