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 375: p_rec.effective_start_date, hr_general.end_of_time, l_default_asg_fte);

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

Line 540: p_validation_end_date => hr_general.end_of_time,

536: pqh_psf_bus.chk_future_pos_asg_fte(
537: p_assignment_id => p_rec.assignment_id,
538: p_position_id => p_rec.position_id,
539: p_validation_start_date => p_validation_start_date,
540: p_validation_end_date => hr_general.end_of_time,
541: p_default_asg_fte => l_default_asg_fte);
542: end if;
543: --
544: hr_utility.set_location('after chk_future_pos_asg_fte ', 100);

Line 591: p_validation_start_date, hr_general.end_of_time);

587: --pqh_utility.raise_error;
588: else
589: l_future_res_date := chk_future_reserved_fte(p_rec.assignment_id, p_rec.person_id,
590: p_rec.position_id, l_rec.position_type,
591: p_validation_start_date, hr_general.end_of_time);
592: if l_future_res_date is not null then
593: hr_utility.set_message(8302,'PQH_POS_FUTURE_RESERVED');
594: hr_utility.set_message_token('FUTURE_RESERVED_DATE', l_future_res_date);
595: pqh_utility.set_message_level_cd('W');

Line 1490: hr_general.end_of_time) poei_information4,

1486:
1487: cursor c1 is
1488: select fnd_date.canonical_to_date(poei_information3) poei_information3,
1489: nvl(fnd_date.canonical_to_date(poei_information4),
1490: hr_general.end_of_time) poei_information4,
1491: poei_information5, poei_information6, poei_information7
1492: from per_position_extra_info
1493: where position_id = p_position_id
1494: and information_type = 'PER_RESERVED';

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

2565: cursor c2(p_budget_id number) is
2566: select bdet.budget_detail_id
2567: from pqh_budget_details bdet,pqh_budget_versions bvr
2568: where bvr.budget_id = p_budget_id
2569: and hr_general.effective_date between bvr.date_from and nvl(bvr.date_to,hr_general.effective_date)
2570: and bdet.budget_version_id = bvr.budget_version_id
2571: and nvl(p_organization_id, nvl(bdet.organization_id, -1)) =
2572: nvl(bdet.organization_id, -1)
2573: and nvl(p_job_id, nvl(bdet.job_id, -1)) =

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

2658: select to_number(poei_information6,'99999999.99') fte
2659: from per_position_extra_info
2660: where p_effective_date
2661: between fnd_date.canonical_to_date(poei_information3)
2662: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)
2663: and position_id = p_position_id
2664: and information_type= 'PER_RESERVED'
2665: and poei_information5 = p_person_id;
2666: begin

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

2693: select sum(to_number(poei_information6,'99999999.99')) fte
2694: from per_position_extra_info
2695: where p_effective_date
2696: between fnd_date.canonical_to_date(poei_information3)
2697: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)
2698: and position_id = p_position_id
2699: and information_type= 'PER_RESERVED';
2700: --
2701: begin

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

2739: select poei_information5 person_id
2740: from per_position_extra_info
2741: where p_effective_date
2742: between fnd_date.canonical_to_date(poei_information3)
2743: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)
2744: and position_id = p_position_id
2745: and poei_information5 is not null
2746: and information_type= 'PER_RESERVED';
2747: begin

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

3220: select sum(poei_information6) fte
3221: from per_position_extra_info
3222: where p_effective_date
3223: between fnd_date.canonical_to_date(poei_information3)
3224: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)
3225: and position_id = p_position_id
3226: and information_type= 'PER_RESERVED'
3227: and position_extra_info_id <> l_ex_position_extra_info_id;
3228: begin

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

3283: where information_type= 'PER_RESERVED'
3284: and position_id = p_position_id
3285: and position_extra_info_id <> l_ex_position_extra_info_id
3286: and fnd_date.canonical_to_date(poei_information3) <= p_effective_date
3287: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)
3288: >= p_effective_date
3289: and poei_information5 = asn.person_id);
3290: l_nonreserved_fte number:=0;
3291: begin

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

3367: where abv.assignment_id = asn.assignment_id
3368: and asn.position_id = p_position_id
3369: and abv.effective_start_date between asn.effective_start_date and asn.effective_end_date
3370: and abv.effective_start_date between
3371: p_start_date and nvl(p_end_date, hr_general.end_of_time)
3372: and asn.effective_start_date between
3373: p_start_date and nvl(p_end_date, hr_general.end_of_time)
3374: and asn.assignment_type in ('E', 'C')
3375: and abv.unit(+) = 'FTE'

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

3369: and abv.effective_start_date between asn.effective_start_date and asn.effective_end_date
3370: and abv.effective_start_date between
3371: p_start_date and nvl(p_end_date, hr_general.end_of_time)
3372: and asn.effective_start_date between
3373: p_start_date and nvl(p_end_date, hr_general.end_of_time)
3374: and asn.assignment_type in ('E', 'C')
3375: and abv.unit(+) = 'FTE'
3376: union
3377: select effective_start_date effective_date

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

3377: select effective_start_date effective_date
3378: from per_all_assignments_f asg
3379: where position_id = p_position_id
3380: and asg.effective_start_date between
3381: p_start_date and nvl(p_end_date, hr_general.end_of_time)
3382: union
3383: select effective_start_date effective_date
3384: from hr_all_positions_f psf
3385: where position_id = p_position_id

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

3383: select effective_start_date effective_date
3384: from hr_all_positions_f psf
3385: where position_id = p_position_id
3386: and psf.effective_start_date between
3387: p_start_date and nvl(p_end_date, hr_general.end_of_time)
3388: union
3389: select p_start_date effective_date
3390: from dual
3391: union

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

3388: union
3389: select p_start_date effective_date
3390: from dual
3391: union
3392: select nvl(p_end_date, hr_general.end_of_time) effective_date
3393: from dual;
3394: --
3395: cursor c2(p_position_id number) is
3396: select business_group_id

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

3441: l_bgt_realloc := nvl(l_budgeted_fte,0) + nvl(l_realloc_fte,0);
3442: --
3443: if l_total_fte > l_bgt_realloc then
3444: hr_utility.set_message(8302,'PQH_RES_FTE_GT_AVL_POS_BGT_FTE');
3445: --hr_utility.set_message_token('PERSON', hr_general.decode_person_name(p_person_id));
3446: hr_utility.set_message_token('EFFECTIVE_DATE', r1.effective_date);
3447: hr_utility.raise_error;
3448: end if;
3449: else

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

3448: end if;
3449: else
3450: if l_total_fte > l_position_fte then
3451: hr_utility.set_message(8302,'PQH_RES_FTE_GT_AVL_POS_FTE');
3452: --hr_utility.set_message_token('PERSON', hr_general.decode_person_name(p_person_id));
3453: hr_utility.set_message_token('EFFECTIVE_DATE', r1.effective_date);
3454: hr_utility.raise_error;
3455: end if;
3456: end if;

Line 3486: hr_general.end_of_time) poei_information4

3482: select 'x'
3483: from (select /*+ INDEX(PER_POSITION_EXTRA_INFO PER_POSITION_EXTRA_INFO_N3)*/
3484: fnd_date.canonical_to_date(poei_information3) poei_information3,
3485: nvl(fnd_date.canonical_to_date(poei_information4),
3486: hr_general.end_of_time) poei_information4
3487: from per_position_extra_info
3488: where information_type = 'PER_RESERVED'
3489: and position_id = p_position_id)
3490: where p_effective_date between poei_information3 and poei_information4;

Line 3560: hr_general.end_of_time) poei_information4

3556: select 'x'
3557: from (select /*+ INDEX(PER_POSITION_EXTRA_INFO PER_POSITION_EXTRA_INFO_N3)*/
3558: fnd_date.canonical_to_date(poei_information3) poei_information3,
3559: nvl(fnd_date.canonical_to_date(poei_information4),
3560: hr_general.end_of_time) poei_information4
3561: from per_position_extra_info
3562: where information_type = 'PER_RESERVED'
3563: and position_id = p_position_id)
3564: where p_effective_date <= poei_information4;

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

4108: where information_type = 'PER_RESERVED'
4109: and position_id = p_position_id
4110: and p_effective_start_date
4111: between fnd_date.canonical_to_date(poei_information3)
4112: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)
4113: and poei_information5 is null;
4114: --
4115: --
4116: CURSOR c_sum_asg_fte(p_position_id number) is

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

4131: where poei.information_type = 'PER_RESERVED'
4132: and poei.position_id = p_position_id
4133: and p_effective_start_date
4134: between fnd_date.canonical_to_date(poei.poei_information3)
4135: and nvl(fnd_date.canonical_to_date(poei.poei_information4),hr_general.end_of_time)
4136: and to_number(poei.poei_information5) = asn.person_id);
4137: --
4138: l_blank_res_pos_fte number := 0;
4139: l_unreserved_fte number := 0;

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

4218: AND NVL(pos.position_control_structure_flg,'N') = 'Y'
4219: AND pos.business_group_id = p_business_group_id;
4220: begin
4221: if p_business_group_id is null then
4222: l_business_group_id := NVL(hr_general.get_business_group_id,fnd_profile.value('PER_BUSINESS_GROUP_ID'));
4223: else
4224: l_business_group_id := p_business_group_id;
4225: end if;
4226: if p_effective_date is null then

Line 4227: l_effective_date := hr_general.effective_date;

4223: else
4224: l_business_group_id := p_business_group_id;
4225: end if;
4226: if p_effective_date is null then
4227: l_effective_date := hr_general.effective_date;
4228: else
4229: l_effective_date := p_effective_date;
4230: end if;
4231: open csr_pc_version(l_effective_date,l_business_group_id);

Line 4629: hr_general.decode_position(l_asg_position_id));

4625:
4626: pqh_utility.set_message(8302,'PQH_SUM_ASG_AMT_GT_BGT_AMT',l_asg_organization_id);
4627: -- pqh_utility.set_message_level_cd(l_message_level);
4628: pqh_utility.set_message_token('POSITION',
4629: hr_general.decode_position(l_asg_position_id));
4630: pqh_utility.set_message_token('UNDER_BUDGETED_AMT',
4631: to_char( -l_pos_under_budgeted_amt,
4632: fnd_currency.GET_FORMAT_MASK(nvl(l_currency_code,'USD'),length(trunc(l_pos_under_budgeted_amt))+15)
4633: ));