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_GENERAL

Line 331: p_validation_end_date => hr_general.end_of_time,

327: pqh_psf_bus.chk_future_pos_asg_fte(
328: p_assignment_id => p_rec.assignment_id,
329: p_position_id => p_rec.position_id,
330: p_validation_start_date => p_rec.effective_start_date,
331: p_validation_end_date => hr_general.end_of_time,
332: p_default_asg_fte => l_default_asg_fte);
333: end if;
334: --
335: --Check Insert allowed..

Line 377: p_rec.effective_start_date, hr_general.end_of_time, l_default_asg_fte);

373: --pqh_utility.raise_error;
374: else
375: l_future_res_date := chk_future_reserved_fte(p_rec.assignment_id, p_rec.person_id,
376: p_rec.position_id, l_rec.position_type,
377: p_rec.effective_start_date, hr_general.end_of_time, l_default_asg_fte);
378: if l_future_res_date is not null then
379: hr_utility.set_message(8302,'PQH_POS_FUTURE_RESERVED');
380: hr_utility.set_message_token('FUTURE_RESERVED_DATE', l_future_res_date);
381: pqh_utility.set_message_level_cd('W');

Line 544: --p_validation_end_date => hr_general.end_of_time,

540: p_assignment_id => p_rec.assignment_id,
541: p_position_id => p_rec.position_id,
542: p_validation_start_date => p_validation_start_date,
543: -- Start changes for bug 10220040
544: --p_validation_end_date => hr_general.end_of_time,
545: p_validation_end_date => p_validation_end_date,
546: -- End changes for bug 10220040
547: p_default_asg_fte => l_default_asg_fte);
548: end if;

Line 600: p_validation_start_date, hr_general.end_of_time);

596: --pqh_utility.raise_error;
597: else
598: l_future_res_date := chk_future_reserved_fte(p_rec.assignment_id, p_rec.person_id,
599: p_rec.position_id, l_rec.position_type,
600: p_validation_start_date, hr_general.end_of_time);
601: if l_future_res_date is not null then
602: hr_utility.set_message(8302,'PQH_POS_FUTURE_RESERVED');
603: hr_utility.set_message_token('FUTURE_RESERVED_DATE', l_future_res_date);
604: pqh_utility.set_message_level_cd('W');

Line 1515: hr_general.end_of_time) poei_information4,

1511:
1512: cursor c1 is
1513: select fnd_date.canonical_to_date(poei_information3) poei_information3,
1514: nvl(fnd_date.canonical_to_date(poei_information4),
1515: hr_general.end_of_time) poei_information4,
1516: poei_information5, poei_information6, poei_information7
1517: from per_position_extra_info
1518: where position_id = p_position_id
1519: and information_type = 'PER_RESERVED';

Line 2762: and hr_general.effective_date between bvr.date_from and nvl(bvr.date_to,hr_general.effective_date)

2758: cursor c2(p_budget_id number) is
2759: select bdet.budget_detail_id
2760: from pqh_budget_details bdet,pqh_budget_versions bvr
2761: where bvr.budget_id = p_budget_id
2762: and hr_general.effective_date between bvr.date_from and nvl(bvr.date_to,hr_general.effective_date)
2763: and bdet.budget_version_id = bvr.budget_version_id
2764: and nvl(p_organization_id, nvl(bdet.organization_id, -1)) =
2765: nvl(bdet.organization_id, -1)
2766: and nvl(p_job_id, nvl(bdet.job_id, -1)) =

Line 2858: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)

2854: select to_number(poei_information6,'99999999.99') fte
2855: from per_position_extra_info
2856: where p_effective_date
2857: between fnd_date.canonical_to_date(poei_information3)
2858: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)
2859: and position_id = p_position_id
2860: and information_type= 'PER_RESERVED'
2861: and poei_information5 = p_person_id;
2862: *******/

Line 2872: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time);

2868: WHERE position_id = p_position_id
2869: and information_type= 'PER_RESERVED'
2870: and poei_information5 = p_person_id) pos
2871: where p_effective_date between fnd_date.canonical_to_date(poei_information3)
2872: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time);
2873:
2874: begin
2875: hr_utility.set_location('inside reserved_fte',10);
2876: if p_person_id is not null and p_position_id is not null and p_effective_date is not null then

Line 2911: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)

2907: select sum(to_number(poei_information6,'99999999.99')) fte
2908: from per_position_extra_info
2909: where p_effective_date
2910: between fnd_date.canonical_to_date(poei_information3)
2911: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)
2912: and position_id = p_position_id
2913: and information_type= 'PER_RESERVED';
2914: *********/
2915: cursor c1(p_position_id number, p_effective_date date) is

Line 2921: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time);

2917: from ( SELECT poei_information6,poei_information3,poei_information4, ROWNUM rn from per_position_extra_info
2918: WHERE position_id = p_position_id
2919: and information_type= 'PER_RESERVED') pos
2920: where p_effective_date between fnd_date.canonical_to_date(poei_information3)
2921: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time);
2922:
2923: --
2924: begin
2925: hr_utility.set_location('inside unreserved_fte',10);

Line 2974: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)

2970: select poei_information5 person_id
2971: from per_position_extra_info
2972: where p_effective_date
2973: between fnd_date.canonical_to_date(poei_information3)
2974: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)
2975: and position_id = p_position_id
2976: and poei_information5 is not null
2977: and information_type= 'PER_RESERVED';
2978: *********/

Line 2987: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time);

2983: WHERE position_id = p_position_id
2984: and poei_information5 is not null
2985: and information_type= 'PER_RESERVED') pos
2986: where p_effective_date between fnd_date.canonical_to_date(poei_information3)
2987: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time);
2988:
2989: begin
2990: hr_utility.set_location('inside reserved_overused ',10);
2991: if p_position_id is not null and p_effective_date is not null then

Line 3475: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)

3471: select sum(poei_information6) fte
3472: from per_position_extra_info
3473: where p_effective_date
3474: between fnd_date.canonical_to_date(poei_information3)
3475: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)
3476: and position_id = p_position_id
3477: and information_type= 'PER_RESERVED'
3478: and position_extra_info_id <> l_ex_position_extra_info_id;
3479: *********/

Line 3488: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time);

3484: WHERE position_id = p_position_id
3485: and information_type= 'PER_RESERVED'
3486: and position_extra_info_id <> l_ex_position_extra_info_id) pei
3487: where p_effective_date between fnd_date.canonical_to_date(poei_information3)
3488: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time);
3489:
3490: begin
3491: hr_utility.set_location('inside pos_reserved_fte',10);
3492: if p_position_id is not null and p_effective_date is not null then

Line 3554: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time) >= p_effective_date

3550: where information_type= 'PER_RESERVED'
3551: and position_id = p_position_id ) pei
3552: where position_extra_info_id <> l_ex_position_extra_info_id
3553: and fnd_date.canonical_to_date(poei_information3) <= p_effective_date
3554: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time) >= p_effective_date
3555: and poei_information5 = asn.person_id);
3556: l_nonreserved_fte number:=0;
3557: begin
3558: hr_utility.set_location('inside nonreserved_asg_fte',10);

Line 3639: p_start_date and nvl(p_end_date, hr_general.end_of_time)

3635: where abv.assignment_id = asn.assignment_id
3636: and asn.position_id = p_position_id
3637: and abv.effective_start_date between asn.effective_start_date and asn.effective_end_date
3638: and abv.effective_start_date between
3639: p_start_date and nvl(p_end_date, hr_general.end_of_time)
3640: and asn.effective_start_date between
3641: p_start_date and nvl(p_end_date, hr_general.end_of_time)
3642: and asn.assignment_type in ('E', 'C')
3643: and abv.unit(+) = 'FTE'

Line 3641: p_start_date and nvl(p_end_date, hr_general.end_of_time)

3637: and abv.effective_start_date between asn.effective_start_date and asn.effective_end_date
3638: and abv.effective_start_date between
3639: p_start_date and nvl(p_end_date, hr_general.end_of_time)
3640: and asn.effective_start_date between
3641: p_start_date and nvl(p_end_date, hr_general.end_of_time)
3642: and asn.assignment_type in ('E', 'C')
3643: and abv.unit(+) = 'FTE'
3644: union
3645: select effective_start_date effective_date

Line 3649: p_start_date and nvl(p_end_date, hr_general.end_of_time)

3645: select effective_start_date effective_date
3646: from per_all_assignments_f asg
3647: where position_id = p_position_id
3648: and asg.effective_start_date between
3649: p_start_date and nvl(p_end_date, hr_general.end_of_time)
3650: union
3651: select effective_start_date effective_date
3652: from hr_all_positions_f psf
3653: where position_id = p_position_id

Line 3655: p_start_date and nvl(p_end_date, hr_general.end_of_time)

3651: select effective_start_date effective_date
3652: from hr_all_positions_f psf
3653: where position_id = p_position_id
3654: and psf.effective_start_date between
3655: p_start_date and nvl(p_end_date, hr_general.end_of_time)
3656: union
3657: select p_start_date effective_date
3658: from dual
3659: union

Line 3660: select nvl(p_end_date, hr_general.end_of_time) effective_date

3656: union
3657: select p_start_date effective_date
3658: from dual
3659: union
3660: select nvl(p_end_date, hr_general.end_of_time) effective_date
3661: from dual;
3662: --
3663: cursor c2(p_position_id number) is
3664: select business_group_id

Line 3713: --hr_utility.set_message_token('PERSON', hr_general.decode_person_name(p_person_id));

3709: l_bgt_realloc := nvl(l_budgeted_fte,0) + nvl(l_realloc_fte,0);
3710: --
3711: if l_total_fte > l_bgt_realloc then
3712: hr_utility.set_message(8302,'PQH_RES_FTE_GT_AVL_POS_BGT_FTE');
3713: --hr_utility.set_message_token('PERSON', hr_general.decode_person_name(p_person_id));
3714: hr_utility.set_message_token('EFFECTIVE_DATE', r1.effective_date);
3715: hr_utility.raise_error;
3716: end if;
3717: else

Line 3720: --hr_utility.set_message_token('PERSON', hr_general.decode_person_name(p_person_id));

3716: end if;
3717: else
3718: if l_total_fte > l_position_fte then
3719: hr_utility.set_message(8302,'PQH_RES_FTE_GT_AVL_POS_FTE');
3720: --hr_utility.set_message_token('PERSON', hr_general.decode_person_name(p_person_id));
3721: hr_utility.set_message_token('EFFECTIVE_DATE', r1.effective_date);
3722: hr_utility.raise_error;
3723: end if;
3724: end if;

Line 3789: nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time);

3785: where p_effective_date
3786: between
3787: fnd_date.canonical_to_date(poei_information3)
3788: and
3789: nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time);
3790: -- End changes for bug 10262123
3791:
3792: --
3793: begin

Line 3867: hr_general.end_of_time) poei_information4

3863: select 'x'
3864: from (select /*+ INDEX(PER_POSITION_EXTRA_INFO PER_POSITION_EXTRA_INFO_N3)*/
3865: fnd_date.canonical_to_date(poei_information3) poei_information3,
3866: nvl(fnd_date.canonical_to_date(poei_information4),
3867: hr_general.end_of_time) poei_information4
3868: from per_position_extra_info
3869: where information_type = 'PER_RESERVED'
3870: and position_id = p_position_id)
3871: where p_effective_date <= poei_information4;

Line 4491: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)

4487: where information_type = 'PER_RESERVED'
4488: and position_id = p_position_id ) poei
4489: Where p_effective_start_date
4490: between fnd_date.canonical_to_date(poei_information3)
4491: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)
4492: and poei_information5 is null;
4493: --
4494: --
4495: CURSOR c_sum_asg_fte(p_position_id number) is

Line 4515: and nvl(fnd_date.canonical_to_date(poei.poei_information4),hr_general.end_of_time)

4511: where information_type = 'PER_RESERVED'
4512: and position_id = p_position_id) poei
4513: where p_effective_start_date
4514: between fnd_date.canonical_to_date(poei.poei_information3)
4515: and nvl(fnd_date.canonical_to_date(poei.poei_information4),hr_general.end_of_time)
4516: and to_number(poei.poei_information5) = asn.person_id);
4517: --
4518: l_blank_res_pos_fte number := 0;
4519: l_unreserved_fte number := 0;

Line 4610: l_business_group_id := NVL(hr_general.get_business_group_id,fnd_profile.value('PER_BUSINESS_GROUP_ID'));

4606: AND NVL(pos.position_control_structure_flg,'N') = 'Y'
4607: AND pos.business_group_id = p_business_group_id;
4608: begin
4609: if p_business_group_id is null then
4610: l_business_group_id := NVL(hr_general.get_business_group_id,fnd_profile.value('PER_BUSINESS_GROUP_ID'));
4611: else
4612: l_business_group_id := p_business_group_id;
4613: end if;
4614: if p_effective_date is null then

Line 4615: l_effective_date := hr_general.effective_date;

4611: else
4612: l_business_group_id := p_business_group_id;
4613: end if;
4614: if p_effective_date is null then
4615: l_effective_date := hr_general.effective_date;
4616: else
4617: l_effective_date := p_effective_date;
4618: end if;
4619: open csr_pc_version(l_effective_date,l_business_group_id);

Line 5017: hr_general.decode_position(l_asg_position_id));

5013:
5014: pqh_utility.set_message(8302,'PQH_SUM_ASG_AMT_GT_BGT_AMT',l_asg_organization_id);
5015: -- pqh_utility.set_message_level_cd(l_message_level);
5016: pqh_utility.set_message_token('POSITION',
5017: hr_general.decode_position(l_asg_position_id));
5018: pqh_utility.set_message_token('UNDER_BUDGETED_AMT',
5019: to_char( -l_pos_under_budgeted_amt,
5020: fnd_currency.GET_FORMAT_MASK(nvl(l_currency_code,'USD'),length(trunc(l_pos_under_budgeted_amt))+15)
5021: ));