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 PQH_PSF_BUS

Line 1: package body PQH_PSF_BUS as

1: package body PQH_PSF_BUS as
2: /* $Header: pqpsfbus.pkb 120.10.12010000.1 2008/07/28 13:04:27 appldev ship $ */
3: --
4: function POSITION_CONTROL_ENABLED(P_ORGANIZATION_ID NUMBER default null,
5: p_effective_date in date default sysdate,

Line 24: l_proc varchar2(100):= 'PQH_PSF_BUS.POS_ASSIGNMENTS_EXIST';

20: function pos_assignments_exist(p_position_id number,
21: p_validation_start_date date, p_validation_end_date date)
22: return boolean is
23: l_dummy varchar2(10);
24: l_proc varchar2(100):= 'PQH_PSF_BUS.POS_ASSIGNMENTS_EXIST';
25:
26: cursor c1 is
27: select 'x'
28: from dual

Line 121: select max(pqh_psf_bus.sum_assignment_fte(p_position_id,ed))

117: --
118: cursor c_asg_max_count(p_position_id number
119: , p_validation_start_date date
120: , p_validation_end_date date) is
121: select max(pqh_psf_bus.sum_assignment_fte(p_position_id,ed))
122: from
123: (select a.effective_start_date ed
124: from per_all_assignments_f a
125: where a.position_id = p_position_id

Line 165: if (pqh_psf_bus.pos_assignments_exist(p_rec.position_id,

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
167: hr_utility.set_location('ASSIGNMENTS EXIST FOR ELIMINATED POSITION', 623);
168: pqh_utility.set_message(800,'PER_POS_ELIMINATED',p_rec.organization_id);
169: pqh_utility.raise_error;

Line 203: l_chk_earliest_hire_date := pqh_psf_bus.chk_earliest_hire_date(

199: --
200: -- Check Earliest hire date validation rule
201: --
202: --
203: l_chk_earliest_hire_date := pqh_psf_bus.chk_earliest_hire_date(
204: p_position_id => p_rec.position_id, p_earliest_hire_date => p_rec.earliest_hire_date );
205: if (not l_chk_earliest_hire_date ) then
206: pqh_utility.set_message(8302,'PQH_ASG_HIRED_BEFORE_EARLIEST',p_rec.organization_id);
207: pqh_utility.raise_error;

Line 214: l_chk_prop_date_for_layoff := pqh_psf_bus.chk_prop_date_for_layoff(

210: --
211: -- Check proposed date for layoff validation rule
212: --
213: --
214: l_chk_prop_date_for_layoff := pqh_psf_bus.chk_prop_date_for_layoff(
215: p_position_id => p_rec.position_id, p_proposed_date_for_layoff => p_rec.proposed_date_for_layoff );
216: if (not l_chk_prop_date_for_layoff ) then
217: --pqh_utility.set_message(8302,'PQH_LAYOFF_DT_GT_ASG_DT',p_rec.organization_id);
218: pqh_utility.set_message(8302,'PQH_ASG_DT_GT_LAYOFF_DT',p_rec.organization_id);

Line 272: if not pqh_psf_bus.chk_seasonal_dates(

268: -- Check for Assignment attached to a Seasonal Position is with in seasonal dates
269: --
270: hr_utility.set_location('Insert Validate: Before Seasonal Validation', 130);
271: if l_rec.seasonal_flag = 'Y' then
272: if not pqh_psf_bus.chk_seasonal_dates(
273: p_position_id => p_rec.position_id,
274: p_seasonal_flag => l_rec.seasonal_flag,
275: p_assignment_start_date => p_effective_date) then
276: pqh_utility.set_message(8302,'PQH_NON_SEASONAL_ASG_DATE',l_rec.organization_id);

Line 310: l_default_asg_fte := pqh_psf_bus.default_assignment_fte(p_rec.business_group_id);

306: --
307: hr_utility.set_location('Insert Validate: SHARED position has FTE greater than', 130);
308: if (l_rec.position_type = 'SHARED') then
309: --
310: l_default_asg_fte := pqh_psf_bus.default_assignment_fte(p_rec.business_group_id);
311: --
312: pqh_psf_bus.CHK_ABV_FTE_GT_POS_BGT_FTE(
313: p_assignment_id => p_rec.assignment_id,
314: p_position_id => p_rec.position_id,

Line 312: pqh_psf_bus.CHK_ABV_FTE_GT_POS_BGT_FTE(

308: if (l_rec.position_type = 'SHARED') then
309: --
310: l_default_asg_fte := pqh_psf_bus.default_assignment_fte(p_rec.business_group_id);
311: --
312: pqh_psf_bus.CHK_ABV_FTE_GT_POS_BGT_FTE(
313: p_assignment_id => p_rec.assignment_id,
314: p_position_id => p_rec.position_id,
315: p_effective_date => p_rec.effective_start_date,
316: p_default_asg_fte => l_default_asg_fte,

Line 327: pqh_psf_bus.chk_future_pos_asg_fte(

323: end if;
324: --
325: if not l_bgt_lt_abv_fte then
326: hr_utility.set_location('l_default_asg_fte :'||l_default_asg_fte, 135);
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,

Line 340: if pqh_psf_bus.open_status(p_rec.position_id, p_rec.effective_start_date) = 'OPEN' then

336: --
337: hr_utility.set_location('Insert Validate:Check Insert allowed', 130);
338: if l_rec.position_type = 'POOLED' then
339: hr_utility.set_location('Insert Validate:POOLED', 130);
340: if pqh_psf_bus.open_status(p_rec.position_id, p_rec.effective_start_date) = 'OPEN' then
341: null;
342: else
343: pqh_utility.set_message(8302,'PQH_POOLED_POS_NOT_OPEN',l_rec.organization_id);
344: pqh_utility.raise_error;

Line 349: if pqh_psf_bus.open_status(p_rec.position_id, p_rec.effective_start_date) = 'OPEN' then

345: end if;
346: hr_utility.set_location('Insert Validate:END POOLED', 130);
347: elsif l_rec.position_type = 'SINGLE' or l_rec.position_type = 'SHARED' then
348: hr_utility.set_location('Insert Validate:SINGLE-SHARED', 130);
349: if pqh_psf_bus.open_status(p_rec.position_id, p_rec.effective_start_date) = 'OPEN' then
350: hr_utility.set_location('Insert Validate:OPEN', 130);
351: if not l_bgt_lt_abv_fte then
352: hr_utility.set_location('p_rec.business_group_id : '||p_rec.business_group_id, 131);
353: if l_rec.position_type = 'SINGLE' then

Line 356: l_default_asg_fte := pqh_psf_bus.default_assignment_fte(p_rec.business_group_id);

352: hr_utility.set_location('p_rec.business_group_id : '||p_rec.business_group_id, 131);
353: if l_rec.position_type = 'SINGLE' then
354: l_default_asg_fte := 1;
355: else
356: l_default_asg_fte := pqh_psf_bus.default_assignment_fte(p_rec.business_group_id);
357: end if;
358: hr_utility.set_location('l_default_asg_fte : '||l_default_asg_fte, 13);
359: --
360: if chk_reserved_fte(p_rec.assignment_id, p_rec.person_id,

Line 363: pqh_psf_bus.reserved_error(p_rec.assignment_id,

359: --
360: if chk_reserved_fte(p_rec.assignment_id, p_rec.person_id,
361: p_rec.position_id, l_rec.position_type,
362: p_rec.effective_start_date, l_default_asg_fte) then
363: pqh_psf_bus.reserved_error(p_rec.assignment_id,
364: p_rec.person_id,
365: p_rec.position_id,
366: p_rec.effective_start_date,
367: l_rec.organization_id,

Line 453: hr_utility.set_location('Entering Procedure PQH_PSF_BUS ', 100);

449: where position_id = p_position_id
450: and effective_start_date > p_effective_date;
451: --
452: BEGIN
453: hr_utility.set_location('Entering Procedure PQH_PSF_BUS ', 100);
454: hr_utility.set_location('p_validation_start_date '||p_validation_start_date, 101);
455: hr_utility.set_location('p_validation_end_date '||p_validation_end_date, 101);
456: hr_utility.set_location('p_effective_date '||p_effective_date, 101);
457: hr_utility.set_location('p_datetrack_mode '||p_datetrack_mode, 101);

Line 472: if not pqh_psf_bus.chk_seasonal_dates(

468: -- Check for Assignment attached to a Seasonal Position is with in seasonal dates
469: --
470: if p_rec.position_id <> nvl(l_asg.position_id, -999) then
471: if l_rec.seasonal_flag = 'Y' then
472: if not pqh_psf_bus.chk_seasonal_dates(
473: p_position_id => p_rec.position_id,
474: p_seasonal_flag => l_rec.seasonal_flag,
475: p_assignment_start_date => p_validation_start_date) then
476:

Line 519: --pqh_psf_bus.default_assignment_fte(p_rec.business_group_id);

515: if (l_rec.position_type = 'SHARED') then
516: --
517: hr_utility.set_location('before l_overlap_dates_present ', 100);
518: l_default_asg_fte := null;
519: --pqh_psf_bus.default_assignment_fte(p_rec.business_group_id);
520: --
521: pqh_psf_bus.CHK_ABV_FTE_GT_POS_BGT_FTE(
522: p_assignment_id => p_rec.assignment_id,
523: p_position_id => p_rec.position_id,

Line 521: pqh_psf_bus.CHK_ABV_FTE_GT_POS_BGT_FTE(

517: hr_utility.set_location('before l_overlap_dates_present ', 100);
518: l_default_asg_fte := null;
519: --pqh_psf_bus.default_assignment_fte(p_rec.business_group_id);
520: --
521: pqh_psf_bus.CHK_ABV_FTE_GT_POS_BGT_FTE(
522: p_assignment_id => p_rec.assignment_id,
523: p_position_id => p_rec.position_id,
524: p_effective_date => p_validation_start_date,
525: p_default_asg_fte => l_default_asg_fte,

Line 536: pqh_psf_bus.chk_future_pos_asg_fte(

532: end if;
533: --
534: if not l_bgt_lt_abv_fte then
535: hr_utility.set_location('l_default_asg_fte :'||l_default_asg_fte, 135);
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,

Line 550: l_assignment_fte := pqh_psf_bus.assignment_fte(p_rec.assignment_id, p_validation_start_date);

546: if (l_rec.position_type = 'SHARED') then
547: --
548: hr_utility.set_location('before PQH_FTE_NE_SHARED_POS_FTE_CAP ', 100);
549: --
550: l_assignment_fte := pqh_psf_bus.assignment_fte(p_rec.assignment_id, p_validation_start_date);
551: if (l_rec.fte/l_rec.max_persons <> l_assignment_fte) then
552: pqh_utility.set_message(8302,'PQH_FTE_NE_SHARED_POS_FTE_CAP',l_rec.organization_id);
553: pqh_utility.raise_error;
554: end if;

Line 564: if pqh_psf_bus.open_status(l_rec.position_id, l_rec.effective_start_date) = 'OPEN' then

560: --
561: --Check Insert allowed..
562: --
563: if l_rec.position_type = 'POOLED' then
564: if pqh_psf_bus.open_status(l_rec.position_id, l_rec.effective_start_date) = 'OPEN' then
565: null;
566: else
567: pqh_utility.set_message(8302,'PQH_POOLED_POS_NOT_OPEN',l_rec.organization_id);
568: pqh_utility.raise_error;

Line 572: if pqh_psf_bus.open_status(l_rec.position_id, l_rec.effective_start_date) = 'OPEN' then

568: pqh_utility.raise_error;
569: end if;
570: elsif l_rec.position_type = 'SINGLE' or l_rec.position_type = 'SHARED' then
571: hr_utility.set_location('SINGLE OR SHARED', 111);
572: if pqh_psf_bus.open_status(l_rec.position_id, l_rec.effective_start_date) = 'OPEN' then
573: hr_utility.set_location('OPEN', 112);
574: if not l_bgt_lt_abv_fte then
575: hr_utility.set_location('NOT l_bgt_lt_abv_fte ', 113);
576: if chk_reserved_fte(p_rec.assignment_id, p_rec.person_id,

Line 579: pqh_psf_bus.reserved_error(p_rec.assignment_id,

575: hr_utility.set_location('NOT l_bgt_lt_abv_fte ', 113);
576: if chk_reserved_fte(p_rec.assignment_id, p_rec.person_id,
577: p_rec.position_id, l_rec.position_type,
578: p_validation_start_date) then
579: pqh_psf_bus.reserved_error(p_rec.assignment_id,
580: p_rec.person_id,
581: p_rec.position_id,
582: p_validation_start_date,
583: l_rec.organization_id);

Line 608: hr_utility.set_location('Exiting PQH_PSF_BUS', 130);

604: end if;
605: else
606: close c_position;
607: end if;
608: hr_utility.set_location('Exiting PQH_PSF_BUS', 130);
609: --
610: END;
611: --
612: -- ---------------------------------------------------------------------------

Line 703: l_overlap_dates_present := pqh_psf_bus.chk_overlap_dates(

699: fetch c_position_fte into l_overlap_period,l_fte, l_organization_id;
700: close c_position_fte;
701: hr_utility.set_location('l_overlap_period : ' || l_overlap_period,51);
702: --
703: l_overlap_dates_present := pqh_psf_bus.chk_overlap_dates(
704: p_position_id => l_position_id,
705: p_overlap_period => l_overlap_period,
706: p_assignment_start_date => r1.effective_start_date);
707: --

Line 722: l_sum1 := pqh_psf_bus.sum_assignment_fte(l_position_id, r1.effective_start_date, p_rec.assignment_id);

718: ,p_business_group_id => r1.business_group_id
719: );
720: --
721: --
722: l_sum1 := pqh_psf_bus.sum_assignment_fte(l_position_id, r1.effective_start_date, p_rec.assignment_id);
723: l_sum2 := pqh_psf_bus.assignment_fte(p_rec.assignment_id, r1.effective_start_date);
724: l_sum := l_sum1 + l_sum2;
725: --
726: hr_utility.set_location('l_bdgt '||l_bdgt, 101);

Line 723: l_sum2 := pqh_psf_bus.assignment_fte(p_rec.assignment_id, r1.effective_start_date);

719: );
720: --
721: --
722: l_sum1 := pqh_psf_bus.sum_assignment_fte(l_position_id, r1.effective_start_date, p_rec.assignment_id);
723: l_sum2 := pqh_psf_bus.assignment_fte(p_rec.assignment_id, r1.effective_start_date);
724: l_sum := l_sum1 + l_sum2;
725: --
726: hr_utility.set_location('l_bdgt '||l_bdgt, 101);
727: hr_utility.set_location('l_fte '||l_fte, 101);

Line 830: l_overlap_dates_present := pqh_psf_bus.chk_overlap_dates(

826: l_fte||' - '||l_max_persons ||' - '||l_position_type, 120);
827: --
828: --
829: if l_position_type in ('SINGLE', 'SHARED') then
830: l_overlap_dates_present := pqh_psf_bus.chk_overlap_dates(
831: p_position_id => l_position_id,
832: p_overlap_period => l_overlap_period,
833: p_assignment_start_date => p_effective_date);
834: if not l_overlap_dates_present then

Line 838: l_sum_abv := pqh_psf_bus.sum_assignment_fte(l_position_id, p_effective_date);

834: if not l_overlap_dates_present then
835: --
836: --Validate Position Budget values with sum of Assignment Budget Values
837: --
838: l_sum_abv := pqh_psf_bus.sum_assignment_fte(l_position_id, p_effective_date);
839: --
840: l_pos_budget_fte := budgeted_fte(l_position_id, p_effective_date);
841: --
842: l_realloc := pqh_reallocation_pkg.get_reallocation(

Line 881: if pqh_psf_bus.open_status(l_position_id, p_effective_date) = 'OPEN' then

877: --
878: -- Check Reserved
879: --
880: hr_utility.set_location('Insert Validate:SINGLE-SHARED', 130);
881: if pqh_psf_bus.open_status(l_position_id, p_effective_date) = 'OPEN' then
882: hr_utility.set_location('Insert Validate:OPEN', 130);
883: l_available_fte := pqh_psf_bus.available_fte(l_person_id, l_position_id, p_effective_date);
884: hr_utility.set_location('l_available_fte : '||l_available_fte, 131);
885: if (nvl(p_value,0) > l_available_fte) then

Line 883: l_available_fte := pqh_psf_bus.available_fte(l_person_id, l_position_id, p_effective_date);

879: --
880: hr_utility.set_location('Insert Validate:SINGLE-SHARED', 130);
881: if pqh_psf_bus.open_status(l_position_id, p_effective_date) = 'OPEN' then
882: hr_utility.set_location('Insert Validate:OPEN', 130);
883: l_available_fte := pqh_psf_bus.available_fte(l_person_id, l_position_id, p_effective_date);
884: hr_utility.set_location('l_available_fte : '||l_available_fte, 131);
885: if (nvl(p_value,0) > l_available_fte) then
886: pqh_psf_bus.reserved_error(p_assignment_id, l_person_id,
887: l_position_id,

Line 886: pqh_psf_bus.reserved_error(p_assignment_id, l_person_id,

882: hr_utility.set_location('Insert Validate:OPEN', 130);
883: l_available_fte := pqh_psf_bus.available_fte(l_person_id, l_position_id, p_effective_date);
884: hr_utility.set_location('l_available_fte : '||l_available_fte, 131);
885: if (nvl(p_value,0) > l_available_fte) then
886: pqh_psf_bus.reserved_error(p_assignment_id, l_person_id,
887: l_position_id,
888: p_effective_date,
889: l_organization_id);
890: end if;

Line 988: l_overlap_dates_present := pqh_psf_bus.chk_overlap_dates(

984: hr_utility.set_location('c_positions found', 121);
985: --
986: if l_position_type in ('SINGLE', 'SHARED') then
987: hr_utility.set_location('pos type SINGLE OR SHARED', 122);
988: l_overlap_dates_present := pqh_psf_bus.chk_overlap_dates(
989: p_position_id => l_position_id,
990: p_overlap_period => l_overlap_period,
991: p_assignment_start_date => p_effective_date);
992: hr_utility.set_location('After chk_Overlap_dates', 123);

Line 1048: --if pqh_psf_bus.open_status(l_position_id, p_effective_date) = 'OPEN' then

1044: -- Check Reserved
1045: --
1046: if (not l_abv_gt_fte) and (l_position_type = 'SHARED') then
1047: hr_utility.set_location('Insert Validate:SINGLE-SHARED', 130);
1048: --if pqh_psf_bus.open_status(l_position_id, p_effective_date) = 'OPEN' then
1049: hr_utility.set_location('Insert Validate:OPEN', 130);
1050: l_available_fte := pqh_psf_bus.available_fte(l_person_id, l_position_id, p_effective_date);
1051: l_assignment_fte := nvl(pqh_psf_bus.assignment_fte(p_assignment_id, p_effective_date),0);
1052: hr_utility.set_location('l_available_fte : '||l_available_fte, 131);

Line 1050: l_available_fte := pqh_psf_bus.available_fte(l_person_id, l_position_id, p_effective_date);

1046: if (not l_abv_gt_fte) and (l_position_type = 'SHARED') then
1047: hr_utility.set_location('Insert Validate:SINGLE-SHARED', 130);
1048: --if pqh_psf_bus.open_status(l_position_id, p_effective_date) = 'OPEN' then
1049: hr_utility.set_location('Insert Validate:OPEN', 130);
1050: l_available_fte := pqh_psf_bus.available_fte(l_person_id, l_position_id, p_effective_date);
1051: l_assignment_fte := nvl(pqh_psf_bus.assignment_fte(p_assignment_id, p_effective_date),0);
1052: hr_utility.set_location('l_available_fte : '||l_available_fte, 131);
1053: hr_utility.set_location('l_assignment_fte : '||l_assignment_fte, 133);
1054: l_temp := l_available_fte + l_assignment_fte ;

Line 1051: l_assignment_fte := nvl(pqh_psf_bus.assignment_fte(p_assignment_id, p_effective_date),0);

1047: hr_utility.set_location('Insert Validate:SINGLE-SHARED', 130);
1048: --if pqh_psf_bus.open_status(l_position_id, p_effective_date) = 'OPEN' then
1049: hr_utility.set_location('Insert Validate:OPEN', 130);
1050: l_available_fte := pqh_psf_bus.available_fte(l_person_id, l_position_id, p_effective_date);
1051: l_assignment_fte := nvl(pqh_psf_bus.assignment_fte(p_assignment_id, p_effective_date),0);
1052: hr_utility.set_location('l_available_fte : '||l_available_fte, 131);
1053: hr_utility.set_location('l_assignment_fte : '||l_assignment_fte, 133);
1054: l_temp := l_available_fte + l_assignment_fte ;
1055: if (nvl(p_value,0) > l_temp ) then

Line 1056: pqh_psf_bus.reserved_error(p_assignment_id, l_person_id,

1052: hr_utility.set_location('l_available_fte : '||l_available_fte, 131);
1053: hr_utility.set_location('l_assignment_fte : '||l_assignment_fte, 133);
1054: l_temp := l_available_fte + l_assignment_fte ;
1055: if (nvl(p_value,0) > l_temp ) then
1056: pqh_psf_bus.reserved_error(p_assignment_id, l_person_id,
1057: l_position_id,
1058: p_effective_date,
1059: l_organization_id);
1060:

Line 1600: l_fte := pqh_psf_bus.get_position_fte(p_position_id, p_effective_date);

1596: return(l_vacancy_status);
1597: else
1598: close C_ASSIGNMENTS;
1599: l_vacancy_status := 'FILLED';
1600: l_fte := pqh_psf_bus.get_position_fte(p_position_id, p_effective_date);
1601: l_sum_asg_fte := sum_assignment_fte(p_position_id, p_effective_date);
1602: hr_utility.set_location('l_fte' || l_fte,102);
1603: hr_utility.set_location('sum_asg_fte :' || l_sum_asg_fte,102);
1604: if l_fte is not null then

Line 2704: l_pos_fte := pqh_psf_bus.get_position_fte(p_position_id, p_effective_date);

2700: --
2701: begin
2702: if p_position_id is not null and p_effective_date is not null then
2703: --
2704: l_pos_fte := pqh_psf_bus.get_position_fte(p_position_id, p_effective_date);
2705: --
2706: open c1(p_position_id, p_effective_date);
2707: fetch c1 into l_fte;
2708: close c1;

Line 2724: l_person_fte := pqh_psf_bus.person_fte(p_person_id, p_position_id, p_effective_date, -1);

2720: l_uu_fte number := 0;
2721: l_person_fte number;
2722: l_reserved_fte number;
2723: begin
2724: l_person_fte := pqh_psf_bus.person_fte(p_person_id, p_position_id, p_effective_date, -1);
2725: l_reserved_fte := pqh_psf_bus.reserved_fte(p_person_id, p_position_id, p_effective_date);
2726: hr_utility.set_location('uu: l_person_fte : '||l_person_fte, 131);
2727: hr_utility.set_location('uu: l_reserved_fte : '||l_reserved_fte, 131);
2728: if l_reserved_fte>0 and l_person_fte - l_reserved_fte > 0then

Line 2725: l_reserved_fte := pqh_psf_bus.reserved_fte(p_person_id, p_position_id, p_effective_date);

2721: l_person_fte number;
2722: l_reserved_fte number;
2723: begin
2724: l_person_fte := pqh_psf_bus.person_fte(p_person_id, p_position_id, p_effective_date, -1);
2725: l_reserved_fte := pqh_psf_bus.reserved_fte(p_person_id, p_position_id, p_effective_date);
2726: hr_utility.set_location('uu: l_person_fte : '||l_person_fte, 131);
2727: hr_utility.set_location('uu: l_reserved_fte : '||l_reserved_fte, 131);
2728: if l_reserved_fte>0 and l_person_fte - l_reserved_fte > 0then
2729: l_uu_fte := l_person_fte - l_reserved_fte;

Line 3413: l_person_asg_fte := pqh_psf_bus.person_asg_fte(p_person_id, p_position_id, r1.effective_date);

3409: --
3410: l_reserved_fte := pos_reserved_fte(p_position_id, r1.effective_date, p_position_extra_info_id);
3411: l_nonreserved_asg_fte := nonreserved_asg_fte(p_position_id, r1.effective_date,
3412: p_position_extra_info_id, p_person_id);
3413: l_person_asg_fte := pqh_psf_bus.person_asg_fte(p_person_id, p_position_id, r1.effective_date);
3414: l_poei_fte := greatest(l_person_asg_fte, p_poei_fte);
3415: l_position_fte := pqh_psf_bus.position_fte(p_position_id, r1.effective_date);
3416: --
3417: l_total_fte := nvl(l_reserved_fte,0) + nvl(l_nonreserved_asg_fte,0) + l_poei_fte;

Line 3415: l_position_fte := pqh_psf_bus.position_fte(p_position_id, r1.effective_date);

3411: l_nonreserved_asg_fte := nonreserved_asg_fte(p_position_id, r1.effective_date,
3412: p_position_extra_info_id, p_person_id);
3413: l_person_asg_fte := pqh_psf_bus.person_asg_fte(p_person_id, p_position_id, r1.effective_date);
3414: l_poei_fte := greatest(l_person_asg_fte, p_poei_fte);
3415: l_position_fte := pqh_psf_bus.position_fte(p_position_id, r1.effective_date);
3416: --
3417: l_total_fte := nvl(l_reserved_fte,0) + nvl(l_nonreserved_asg_fte,0) + l_poei_fte;
3418: l_budgeted_fte := pqh_psf_bus.budgeted_fte(p_position_id, r1.effective_date);
3419: --

Line 3418: l_budgeted_fte := pqh_psf_bus.budgeted_fte(p_position_id, r1.effective_date);

3414: l_poei_fte := greatest(l_person_asg_fte, p_poei_fte);
3415: l_position_fte := pqh_psf_bus.position_fte(p_position_id, r1.effective_date);
3416: --
3417: l_total_fte := nvl(l_reserved_fte,0) + nvl(l_nonreserved_asg_fte,0) + l_poei_fte;
3418: l_budgeted_fte := pqh_psf_bus.budgeted_fte(p_position_id, r1.effective_date);
3419: --
3420: l_realloc_fte := pqh_reallocation_pkg.get_reallocation(
3421: p_position_id => p_position_id
3422: ,p_start_date => r1.effective_date

Line 3502: l_overlap_dates_present := pqh_psf_bus.chk_overlap_dates(

3498: hr_utility.set_location('chk_pos_fte_sum_asg_fte l_position_type'||l_position_type , 20);
3499: --
3500: --
3501: if l_position_type in ('SHARED', 'SINGLE') then
3502: l_overlap_dates_present := pqh_psf_bus.chk_overlap_dates(
3503: p_position_id => p_position_id,
3504: p_overlap_period => l_overlap_period,
3505: p_assignment_start_date => p_effective_date);
3506: if not l_overlap_dates_present then

Line 3519: l_available_fte := pqh_psf_bus.available_fte(p_person_id, p_position_id, p_effective_date);

3515: return false;
3516: else
3517: close c_pos_reserved;
3518: end if;
3519: l_available_fte := pqh_psf_bus.available_fte(p_person_id, p_position_id, p_effective_date);
3520: if l_position_type = 'SINGLE' then
3521: hr_utility.set_location('p_position_type is SINGLE ', 110);
3522: l_assignment_fte := 1;
3523: elsif p_assignment_id is not null then

Line 3525: l_assignment_fte := nvl(pqh_psf_bus.assignment_fte(p_assignment_id, p_effective_date),0

3521: hr_utility.set_location('p_position_type is SINGLE ', 110);
3522: l_assignment_fte := 1;
3523: elsif p_assignment_id is not null then
3524: hr_utility.set_location('p_assignment_id is not null ', 111);
3525: l_assignment_fte := nvl(pqh_psf_bus.assignment_fte(p_assignment_id, p_effective_date),0
3526: );
3527: else
3528: hr_utility.set_location('p_assignment_id is null and pos type SHARED', 112);
3529: l_assignment_fte := p_default_asg_fte;

Line 3727: l_overlap_dates_present := pqh_psf_bus.chk_overlap_dates(

3723: hr_utility.set_location('chk_pos_fte_sum_asg_fte p_position_type'||p_position_type , 20);
3724: --
3725: if p_position_type = 'SHARED' then
3726: --
3727: l_overlap_dates_present := pqh_psf_bus.chk_overlap_dates(
3728: p_position_id => p_position_id,
3729: p_overlap_period => l_overlap_period,
3730: p_assignment_start_date => p_effective_date);
3731: if not l_overlap_dates_present then

Line 3748: p_total_asg_fte := pqh_psf_bus.sum_assignment_fte(p_position_id, p_effective_date) + p_default_asg_fte;

3744: --
3745: hr_utility.set_location('chk_pos_fte_sum_asg_fte before asg_null' , 20);
3746: if p_assignment_id is null then
3747: hr_utility.set_location('chk_pos_fte_sum_asg_fte before asg_is null' , 20);
3748: p_total_asg_fte := pqh_psf_bus.sum_assignment_fte(p_position_id, p_effective_date) + p_default_asg_fte;
3749: else
3750: hr_utility.set_location('chk_pos_fte_sum_asg_fte before asg_is not null' , 20);
3751: l_sum := pqh_psf_bus.sum_assignment_fte(p_position_id, p_effective_date);
3752: l_asg := pqh_psf_bus.assignment_fte(p_assignment_id, p_effective_date);

Line 3751: l_sum := pqh_psf_bus.sum_assignment_fte(p_position_id, p_effective_date);

3747: hr_utility.set_location('chk_pos_fte_sum_asg_fte before asg_is null' , 20);
3748: p_total_asg_fte := pqh_psf_bus.sum_assignment_fte(p_position_id, p_effective_date) + p_default_asg_fte;
3749: else
3750: hr_utility.set_location('chk_pos_fte_sum_asg_fte before asg_is not null' , 20);
3751: l_sum := pqh_psf_bus.sum_assignment_fte(p_position_id, p_effective_date);
3752: l_asg := pqh_psf_bus.assignment_fte(p_assignment_id, p_effective_date);
3753: p_total_asg_fte := l_sum + l_asg;
3754: --
3755: hr_utility.set_location('chk_pos_fte_sum_asg_fte l_sum : '||l_sum, 20);

Line 3752: l_asg := pqh_psf_bus.assignment_fte(p_assignment_id, p_effective_date);

3748: p_total_asg_fte := pqh_psf_bus.sum_assignment_fte(p_position_id, p_effective_date) + p_default_asg_fte;
3749: else
3750: hr_utility.set_location('chk_pos_fte_sum_asg_fte before asg_is not null' , 20);
3751: l_sum := pqh_psf_bus.sum_assignment_fte(p_position_id, p_effective_date);
3752: l_asg := pqh_psf_bus.assignment_fte(p_assignment_id, p_effective_date);
3753: p_total_asg_fte := l_sum + l_asg;
3754: --
3755: hr_utility.set_location('chk_pos_fte_sum_asg_fte l_sum : '||l_sum, 20);
3756: hr_utility.set_location('chk_pos_fte_sum_asg_fte l_asg : '||l_asg, 20);

Line 3764: l_overlap_dates_present := pqh_psf_bus.chk_overlap_dates(

3760: hr_utility.set_location('chk_pos_fte_sum_asg_fte end SHARED' , 20);
3761: end if;
3762: elsif p_position_type = 'SINGLE' then
3763: --
3764: l_overlap_dates_present := pqh_psf_bus.chk_overlap_dates(
3765: p_position_id => p_position_id,
3766: p_overlap_period => l_overlap_period,
3767: p_assignment_start_date => p_effective_date);
3768: if not l_overlap_dates_present then

Line 3774: p_total_asg_fte := pqh_psf_bus.no_assignments(p_position_id, p_effective_date) + 1;

3770: --
3771: hr_utility.set_location('chk_pos_fte_sum_asg_fte before asg_null' , 20);
3772: if p_assignment_id is null then
3773: hr_utility.set_location('chk_pos_fte_sum_asg_fte before asg_is null' , 20);
3774: p_total_asg_fte := pqh_psf_bus.no_assignments(p_position_id, p_effective_date) + 1;
3775: else
3776: hr_utility.set_location('chk_pos_fte_sum_asg_fte before asg_is not null' , 20);
3777: l_sum := pqh_psf_bus.no_assignments(p_position_id, p_effective_date);
3778: l_asg := 1;

Line 3777: l_sum := pqh_psf_bus.no_assignments(p_position_id, p_effective_date);

3773: hr_utility.set_location('chk_pos_fte_sum_asg_fte before asg_is null' , 20);
3774: p_total_asg_fte := pqh_psf_bus.no_assignments(p_position_id, p_effective_date) + 1;
3775: else
3776: hr_utility.set_location('chk_pos_fte_sum_asg_fte before asg_is not null' , 20);
3777: l_sum := pqh_psf_bus.no_assignments(p_position_id, p_effective_date);
3778: l_asg := 1;
3779: p_total_asg_fte := l_sum + l_asg;
3780: --
3781: hr_utility.set_location('chk_pos_fte_sum_asg_fte l_sum : '||l_sum, 20);

Line 4017: pqh_psf_bus.chk_pos_fte_sum_asg_fte(

4013: l_sum number;
4014: l_bgt_realloc number;
4015: begin
4016: --
4017: pqh_psf_bus.chk_pos_fte_sum_asg_fte(
4018: p_assignment_id => p_assignment_id,
4019: p_position_id => p_position_id,
4020: p_effective_date => p_effective_date,
4021: p_default_asg_fte => p_default_asg_fte,

Line 4076: l_budgeted_fte := pqh_psf_bus.budgeted_fte(p_position_id, p_effective_date);

4072: open c2(p_position_id, p_effective_date);
4073: fetch c2 into l_pos_fte, l_business_group_id;
4074: close c2;
4075: --
4076: l_budgeted_fte := pqh_psf_bus.budgeted_fte(p_position_id, p_effective_date);
4077: --
4078: --
4079: l_realloc_fte := pqh_reallocation_pkg.get_reallocation(
4080: p_position_id => p_position_id

Line 4466: l_proc varchar2(72) := 'pqh_psf_bus.chk_position_budget';

4462: l_salary_element_type_id number;
4463: l_salary_input_value_id number;
4464: --
4465: l_message_level varchar2(10);
4466: l_proc varchar2(72) := 'pqh_psf_bus.chk_position_budget';
4467: begin
4468: --
4469: hr_utility.set_location(l_proc||'Entering',1);
4470: get_assignment_info(p_assignment_id, p_effective_date, l_asg_position_id, l_asg_organization_id);

Line 4653: end PQH_PSF_BUS;

4649: hr_utility.set_location(substr(sqlerrm,1,120),13);
4650: raise;
4651: end;
4652:
4653: end PQH_PSF_BUS;