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_ALL_POSITIONS

Line 233: l_rec hr_all_positions%rowtype;

229: ,p_effective_date in date) IS
230: l_bgt_lt_abv_fte boolean := false;
231: l_open_status varchar2(30);
232: l_proposed_date_for_layoff date;
233: l_rec hr_all_positions%rowtype;
234: l_fte_capacity number(15,2);
235: l_sum number(15,2);
236: l_bdgt number(15,2);
237: l_available_fte number:=0;

Line 249: from hr_all_positions

245: l_bgt_realloc number;
246:
247: cursor c_position is
248: select *
249: from hr_all_positions
250: where position_id = p_rec.position_id;
251: --
252: cursor c_single_pos_future_asg(p_position_id number, p_effective_date date) is
253: select min(effective_start_date)

Line 424: l_rec hr_all_positions%rowtype;

420: ,p_datetrack_mode in varchar2 ) IS
421: l_bgt_lt_abv_fte boolean := false;
422: l_open_status varchar2(30);
423: l_proposed_date_for_layoff date;
424: l_rec hr_all_positions%rowtype;
425: l_asg per_all_assignments%rowtype;
426: l_fte_capacity number(15,2);
427: l_sum number(15,2);
428: l_bdgt number(15,2);

Line 440: from hr_all_positions

436: l_default_asg_fte number;
437:
438: cursor c_position is
439: select *
440: from hr_all_positions
441: where position_id = p_rec.position_id;
442:
443: cursor c_assignment is
444: select *

Line 670: from hr_all_positions_f

666: and abv.effective_end_date between p_validation_start_date and p_validation_end_date
667: and asg.effective_end_date between p_validation_start_date and p_validation_end_date
668: union
669: select effective_start_date, business_group_id
670: from hr_all_positions_f
671: where position_id = p_position_id
672: and effective_start_date between p_validation_start_date and p_validation_end_date;
673: --
674: cursor c_position_id(p_assignment_id number, p_effective_date date) is

Line 682: from hr_all_positions_f

678: and p_effective_date between effective_start_date and effective_end_date;
679: --
680: cursor c_position_fte(p_position_id number, p_date date) is
681: select overlap_period, fte, organization_id
682: from hr_all_positions_f
683: where position_id = p_position_id
684: and p_date between effective_start_date and effective_end_date;
685: --
686: begin

Line 777: l_position_id hr_all_positions_f.position_id%type;

773: p_value number,
774: p_unit varchar2,
775: p_effective_date date) is
776: l_proc varchar2(100) := 'per_abv_insert_validate';
777: l_position_id hr_all_positions_f.position_id%type;
778: l_fte hr_all_positions_f.fte%type;
779: l_max_persons hr_all_positions_f.max_persons%type;
780: l_position_type hr_all_positions_f.position_type%type;
781: l_organization_id number;

Line 778: l_fte hr_all_positions_f.fte%type;

774: p_unit varchar2,
775: p_effective_date date) is
776: l_proc varchar2(100) := 'per_abv_insert_validate';
777: l_position_id hr_all_positions_f.position_id%type;
778: l_fte hr_all_positions_f.fte%type;
779: l_max_persons hr_all_positions_f.max_persons%type;
780: l_position_type hr_all_positions_f.position_type%type;
781: l_organization_id number;
782: l_sum_abv number:=0;

Line 779: l_max_persons hr_all_positions_f.max_persons%type;

775: p_effective_date date) is
776: l_proc varchar2(100) := 'per_abv_insert_validate';
777: l_position_id hr_all_positions_f.position_id%type;
778: l_fte hr_all_positions_f.fte%type;
779: l_max_persons hr_all_positions_f.max_persons%type;
780: l_position_type hr_all_positions_f.position_type%type;
781: l_organization_id number;
782: l_sum_abv number:=0;
783: l_pos_budget_fte number:=0;

Line 780: l_position_type hr_all_positions_f.position_type%type;

776: l_proc varchar2(100) := 'per_abv_insert_validate';
777: l_position_id hr_all_positions_f.position_id%type;
778: l_fte hr_all_positions_f.fte%type;
779: l_max_persons hr_all_positions_f.max_persons%type;
780: l_position_type hr_all_positions_f.position_type%type;
781: l_organization_id number;
782: l_sum_abv number:=0;
783: l_pos_budget_fte number:=0;
784: l_person_id number;

Line 802: from hr_all_positions_f psf

798: and p_effective_date between paf.effective_start_date and paf.effective_end_date;
799:
800: cursor c_positions is
801: select position_id, fte, max_persons, position_type, organization_id, overlap_period
802: from hr_all_positions_f psf
803: where position_id =
804: (select position_id
805: from per_all_assignments_f paf
806: where paf.assignment_id = p_assignment_id

Line 937: l_position_id hr_all_positions_f.position_id%type;

933: p_validation_start_date date,
934: p_validation_end_date date,
935: p_datetrack_mode varchar2) is
936: l_proc varchar2(100) := 'per_abv_update_validate';
937: l_position_id hr_all_positions_f.position_id%type;
938: l_fte hr_all_positions_f.fte%type;
939: l_max_persons hr_all_positions_f.max_persons%type;
940: l_position_type hr_all_positions_f.position_type%type;
941: l_organization_id number;

Line 938: l_fte hr_all_positions_f.fte%type;

934: p_validation_end_date date,
935: p_datetrack_mode varchar2) is
936: l_proc varchar2(100) := 'per_abv_update_validate';
937: l_position_id hr_all_positions_f.position_id%type;
938: l_fte hr_all_positions_f.fte%type;
939: l_max_persons hr_all_positions_f.max_persons%type;
940: l_position_type hr_all_positions_f.position_type%type;
941: l_organization_id number;
942: l_sum_abv number;

Line 939: l_max_persons hr_all_positions_f.max_persons%type;

935: p_datetrack_mode varchar2) is
936: l_proc varchar2(100) := 'per_abv_update_validate';
937: l_position_id hr_all_positions_f.position_id%type;
938: l_fte hr_all_positions_f.fte%type;
939: l_max_persons hr_all_positions_f.max_persons%type;
940: l_position_type hr_all_positions_f.position_type%type;
941: l_organization_id number;
942: l_sum_abv number;
943: l_pos_budget_fte number;

Line 940: l_position_type hr_all_positions_f.position_type%type;

936: l_proc varchar2(100) := 'per_abv_update_validate';
937: l_position_id hr_all_positions_f.position_id%type;
938: l_fte hr_all_positions_f.fte%type;
939: l_max_persons hr_all_positions_f.max_persons%type;
940: l_position_type hr_all_positions_f.position_type%type;
941: l_organization_id number;
942: l_sum_abv number;
943: l_pos_budget_fte number;
944: l_person_id number;

Line 964: from hr_all_positions_f psf

960: and p_effective_date between paf.effective_start_date and paf.effective_end_date;
961: --
962: cursor c_positions(p_effective_date date) is
963: select position_id, fte, max_persons, position_type, organization_id, overlap_period
964: from hr_all_positions_f psf
965: where position_id =
966: (select position_id
967: from per_all_assignments_f paf
968: where paf.assignment_id = p_assignment_id

Line 1394: from hr_all_positions_f

1390: l_funded_status varchar2(30);
1391:
1392: cursor c_positions is
1393: select availability_status_id, business_group_id, position_type, date_effective
1394: from hr_all_positions_f
1395: where position_id = p_position_id
1396: and p_effective_date between effective_start_date and effective_end_date;
1397: begin
1398: l_open_status := 'OPEN';

Line 1471: from hr_all_positions

1467: l_overlap_unit_cd varchar2(30);
1468:
1469: cursor c1 is
1470: select overlap_period, overlap_unit_cd
1471: from hr_all_positions
1472: where position_id = p_position_id;
1473:
1474: cursor c2 is
1475: select fnd_date.canonical_to_date(poei_information3), fnd_date.canonical_to_date(poei_information4)

Line 1588: select position_type, FTE from hr_all_positions_f

1584: l_assignment_id number(15);
1585: l_sum_asg_fte number;
1586: --
1587: CURSOR C1 IS
1588: select position_type, FTE from hr_all_positions_f
1589: where position_id = p_position_id
1590: and p_effective_date
1591: between effective_start_date and effective_end_date;
1592:

Line 1765: from hr_all_positions_f

1761: order by 1,2 desc;
1762:
1763: cursor c_position_type is
1764: select position_type
1765: from hr_all_positions_f
1766: where position_id = p_position_id;
1767:
1768: cursor c3(lp_effective_end_date date) is
1769: select

Line 1800: l_position_type hr_all_positions_f.position_type%type;

1796: l_ol_effective_start_date date;
1797: l_ol_effective_end_date date;
1798:
1799: l_asg_number per_all_assignments_f.assignment_number%type;
1800: l_position_type hr_all_positions_f.position_type%type;
1801: l_asg_effective_start_date date;
1802: l_asg_effective_end_date date;
1803: -- End changes for bug 10220040
1804:

Line 1952: from hr_all_positions

1948: function chk_seasonal(p_position_id number) return boolean is
1949: l_dummy varchar2(1);
1950: cursor c_seasonal is
1951: select 'X'
1952: from hr_all_positions
1953: where position_id = p_position_id
1954: and seasonal_flag = 'Y';
1955: begin
1956: open c_seasonal;

Line 2025: from hr_all_positions

2021: function chk_overlap(p_position_id number) return boolean is
2022: l_dummy varchar2(1);
2023: cursor c1 is
2024: select 'X'
2025: from hr_all_positions
2026: where position_id = p_position_id
2027: and overlap_period is not null;
2028: begin
2029: open c1;

Line 2098: from hr_all_positions

2094: function max_persons(p_position_id number) return number is
2095: l_max_persons number(15,2);
2096: cursor c1 is
2097: select max_persons
2098: from hr_all_positions
2099: where position_id = p_position_id;
2100: begin
2101: open c1;
2102: fetch c1 into l_max_persons;

Line 2111: from hr_all_positions_f

2107: function proposed_date_for_layoff(p_position_id number) return date is
2108: l_proposed_date_for_layoff date;
2109: cursor c1 is
2110: select proposed_date_for_layoff
2111: from hr_all_positions_f
2112: where position_id = p_position_id;
2113: begin
2114: open c1;
2115: fetch c1 into l_proposed_date_for_layoff;

Line 2124: from hr_all_positions

2120: function fte_capacity(p_position_id number) return number is
2121: l_fte_capacity number(15,2);
2122: cursor c1 is
2123: select fte/max_persons
2124: from hr_all_positions
2125: where position_id = p_position_id;
2126: begin
2127: open c1;
2128: fetch c1 into l_fte_capacity;

Line 2137: from hr_all_positions

2133: function position_type(p_position_id number) return varchar2 is
2134: l_position_type varchar2(32);
2135: cursor c1 is
2136: select position_type
2137: from hr_all_positions
2138: where position_id = p_position_id;
2139: begin
2140: open c1;
2141: fetch c1 into l_position_type;

Line 2150: from hr_all_positions

2146: function grade(p_position_id number) return number is
2147: l_grade_id number(15);
2148: cursor c1 is
2149: select entry_grade_id
2150: from hr_all_positions
2151: where position_id = p_position_id;
2152: begin
2153: open c1;
2154: fetch c1 into l_grade_id;

Line 2163: from hr_all_positions

2159: function work_period_type_cd(p_position_id number) return varchar2 is
2160: l_work_period_type_cd varchar2(50);
2161: cursor c1 is
2162: select work_period_type_cd
2163: from hr_all_positions
2164: where position_id = p_position_id;
2165: begin
2166: open c1;
2167: fetch c1 into l_work_period_type_cd;

Line 2172: function chk_work_pay_term_dates(p_work_period_type_cd hr_all_positions_f.work_period_type_cd%type

2168: close c1;
2169: return(l_work_period_type_cd);
2170: end ;
2171: --
2172: function chk_work_pay_term_dates(p_work_period_type_cd hr_all_positions_f.work_period_type_cd%type
2173: ,p_work_term_end_day_cd hr_all_positions_f.work_term_end_day_cd%type
2174: ,p_work_term_end_month_cd hr_all_positions_f.work_term_end_month_cd%type
2175: ,p_pay_term_end_day_cd hr_all_positions_f.pay_term_end_day_cd%type
2176: ,p_pay_term_end_month_cd hr_all_positions_f.pay_term_end_month_cd%type

Line 2173: ,p_work_term_end_day_cd hr_all_positions_f.work_term_end_day_cd%type

2169: return(l_work_period_type_cd);
2170: end ;
2171: --
2172: function chk_work_pay_term_dates(p_work_period_type_cd hr_all_positions_f.work_period_type_cd%type
2173: ,p_work_term_end_day_cd hr_all_positions_f.work_term_end_day_cd%type
2174: ,p_work_term_end_month_cd hr_all_positions_f.work_term_end_month_cd%type
2175: ,p_pay_term_end_day_cd hr_all_positions_f.pay_term_end_day_cd%type
2176: ,p_pay_term_end_month_cd hr_all_positions_f.pay_term_end_month_cd%type
2177: ,p_term_start_day_cd hr_all_positions_f.term_start_day_cd%type

Line 2174: ,p_work_term_end_month_cd hr_all_positions_f.work_term_end_month_cd%type

2170: end ;
2171: --
2172: function chk_work_pay_term_dates(p_work_period_type_cd hr_all_positions_f.work_period_type_cd%type
2173: ,p_work_term_end_day_cd hr_all_positions_f.work_term_end_day_cd%type
2174: ,p_work_term_end_month_cd hr_all_positions_f.work_term_end_month_cd%type
2175: ,p_pay_term_end_day_cd hr_all_positions_f.pay_term_end_day_cd%type
2176: ,p_pay_term_end_month_cd hr_all_positions_f.pay_term_end_month_cd%type
2177: ,p_term_start_day_cd hr_all_positions_f.term_start_day_cd%type
2178: ,p_term_start_month_cd hr_all_positions_f.term_start_month_cd%type

Line 2175: ,p_pay_term_end_day_cd hr_all_positions_f.pay_term_end_day_cd%type

2171: --
2172: function chk_work_pay_term_dates(p_work_period_type_cd hr_all_positions_f.work_period_type_cd%type
2173: ,p_work_term_end_day_cd hr_all_positions_f.work_term_end_day_cd%type
2174: ,p_work_term_end_month_cd hr_all_positions_f.work_term_end_month_cd%type
2175: ,p_pay_term_end_day_cd hr_all_positions_f.pay_term_end_day_cd%type
2176: ,p_pay_term_end_month_cd hr_all_positions_f.pay_term_end_month_cd%type
2177: ,p_term_start_day_cd hr_all_positions_f.term_start_day_cd%type
2178: ,p_term_start_month_cd hr_all_positions_f.term_start_month_cd%type
2179: ) return boolean is

Line 2176: ,p_pay_term_end_month_cd hr_all_positions_f.pay_term_end_month_cd%type

2172: function chk_work_pay_term_dates(p_work_period_type_cd hr_all_positions_f.work_period_type_cd%type
2173: ,p_work_term_end_day_cd hr_all_positions_f.work_term_end_day_cd%type
2174: ,p_work_term_end_month_cd hr_all_positions_f.work_term_end_month_cd%type
2175: ,p_pay_term_end_day_cd hr_all_positions_f.pay_term_end_day_cd%type
2176: ,p_pay_term_end_month_cd hr_all_positions_f.pay_term_end_month_cd%type
2177: ,p_term_start_day_cd hr_all_positions_f.term_start_day_cd%type
2178: ,p_term_start_month_cd hr_all_positions_f.term_start_month_cd%type
2179: ) return boolean is
2180: begin

Line 2177: ,p_term_start_day_cd hr_all_positions_f.term_start_day_cd%type

2173: ,p_work_term_end_day_cd hr_all_positions_f.work_term_end_day_cd%type
2174: ,p_work_term_end_month_cd hr_all_positions_f.work_term_end_month_cd%type
2175: ,p_pay_term_end_day_cd hr_all_positions_f.pay_term_end_day_cd%type
2176: ,p_pay_term_end_month_cd hr_all_positions_f.pay_term_end_month_cd%type
2177: ,p_term_start_day_cd hr_all_positions_f.term_start_day_cd%type
2178: ,p_term_start_month_cd hr_all_positions_f.term_start_month_cd%type
2179: ) return boolean is
2180: begin
2181: if (p_work_period_type_cd = 'Y') then

Line 2178: ,p_term_start_month_cd hr_all_positions_f.term_start_month_cd%type

2174: ,p_work_term_end_month_cd hr_all_positions_f.work_term_end_month_cd%type
2175: ,p_pay_term_end_day_cd hr_all_positions_f.pay_term_end_day_cd%type
2176: ,p_pay_term_end_month_cd hr_all_positions_f.pay_term_end_month_cd%type
2177: ,p_term_start_day_cd hr_all_positions_f.term_start_day_cd%type
2178: ,p_term_start_month_cd hr_all_positions_f.term_start_month_cd%type
2179: ) return boolean is
2180: begin
2181: if (p_work_period_type_cd = 'Y') then
2182: return(true);

Line 2303: from hr_all_positions_f

2299: l_business_group_id number;
2300: --
2301: cursor c_bus_grp_id(p_position_id number) is
2302: select business_group_id
2303: from hr_all_positions_f
2304: where position_id = p_position_id;
2305: --
2306: cursor c1(p_unit_id number) is select system_type_cd from
2307: per_shared_types where shared_type_id = p_unit_id;

Line 3090: from hr_all_positions_f

3086: l_business_group_id number;
3087: --
3088: cursor c_bus_grp_id(p_position_id number) is
3089: select business_group_id
3090: from hr_all_positions_f
3091: where position_id = p_position_id;
3092: --
3093: cursor c1(p_unit_id number) is select system_type_cd from
3094: per_shared_types where shared_type_id = p_unit_id;

Line 3183: from hr_all_positions_f

3179: l_business_group_id number;
3180: --
3181: cursor c_bus_grp_id(p_position_id number) is
3182: select business_group_id
3183: from hr_all_positions_f
3184: where position_id = p_position_id;
3185: --
3186: cursor c1(p_unit_id number) is select system_type_cd from
3187: per_shared_types where shared_type_id = p_unit_id;

Line 3571: from hr_all_positions_f

3567: function position_fte(p_position_id number, p_effective_date date) return number is
3568: l_fte number;
3569: cursor c1(p_position_id number, p_effective_date date) is
3570: select fte
3571: from hr_all_positions_f
3572: where position_id = p_position_id
3573: and p_effective_date between effective_start_date and effective_end_date;
3574: begin
3575: open c1(p_position_id, p_effective_date);

Line 3652: from hr_all_positions_f psf

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
3654: and psf.effective_start_date between
3655: p_start_date and nvl(p_end_date, hr_general.end_of_time)
3656: union

Line 3665: from hr_all_positions_f

3661: from dual;
3662: --
3663: cursor c2(p_position_id number) is
3664: select business_group_id
3665: from hr_all_positions_f
3666: where position_id = p_position_id;
3667: --
3668: begin
3669: --

Line 3769: from hr_all_positions_f

3765: l_business_group_id number;
3766: --
3767: cursor c_pos_fte(p_position_id number, p_effective_date date) is
3768: select position_type, overlap_period, business_group_id
3769: from hr_all_positions_f
3770: where position_id = p_position_id
3771: and p_effective_date between effective_start_date and effective_end_date;
3772: ----
3773: /*** index hint added in the select statement of the inner

Line 3934: from hr_all_positions_f

3930: and abv.effective_start_date between asg.effective_start_date and asg.effective_end_date
3931: and asg.effective_start_date between p_validation_start_date and p_validation_end_date
3932: union
3933: select effective_start_date
3934: from hr_all_positions_f
3935: where position_id = p_position_id
3936: and effective_start_date between p_validation_start_date and p_validation_end_date;
3937: --
3938: cursor c2(p_position_id number, p_validation_start_date date, p_validation_end_date date) is

Line 3961: from hr_all_positions_f

3957: and information_type = 'PER_RESERVED')
3958: where effective_start_date >= p_validation_start_date
3959: union
3960: select effective_start_date
3961: from hr_all_positions_f
3962: where position_id = p_position_id
3963: and effective_start_date between p_validation_start_date and p_validation_end_date;
3964: --
3965: begin

Line 4061: from hr_all_positions_f

4057: l_business_group_id number;
4058: --
4059: cursor c_pos_fte(p_position_id number, p_effective_date date) is
4060: select position_type, fte, organization_id, overlap_period, business_group_id
4061: from hr_all_positions_f
4062: where position_id = p_position_id
4063: and p_effective_date between effective_start_date and effective_end_date;
4064: --
4065: begin

Line 4207: from hr_all_positions_f

4203: and abv.effective_start_date between asg.effective_start_date and asg.effective_end_date
4204: and asg.effective_start_date between p_validation_start_date and p_validation_end_date
4205: union
4206: select effective_start_date
4207: from hr_all_positions_f
4208: where position_id = p_position_id
4209: and effective_start_date between p_validation_start_date and p_validation_end_date;
4210: --
4211: cursor c2(p_position_id number, p_validation_start_date date, p_validation_end_date date) is

Line 4228: from hr_all_positions_f

4224: and asg.effective_start_date between p_validation_start_date and p_validation_end_date
4225: and asg.business_group_id = abv.business_group_id
4226: union
4227: select effective_start_date
4228: from hr_all_positions_f
4229: where position_id = p_position_id
4230: and effective_start_date between p_validation_start_date and p_validation_end_date;
4231: --
4232: begin

Line 4443: from hr_all_positions_f

4439: l_business_group_id number;
4440: --
4441: cursor c2(p_position_id number, p_effective_date date) is
4442: select fte, business_group_id
4443: from hr_all_positions_f
4444: where position_id = p_position_id
4445: and p_effective_date
4446: between effective_start_date and effective_end_date;
4447: begin