DBA Data[Home] [Help]

APPS.GHR_API dependencies on PER_ALL_POSITIONS

Line 472: ,position_id per_all_positions.position_id%type

468: ,position_org_line3 ghr_pa_requests.from_position_org_line3%type
469: ,position_org_line4 ghr_pa_requests.from_position_org_line4%type
470: ,position_org_line5 ghr_pa_requests.from_position_org_line5%type
471: ,position_org_line6 ghr_pa_requests.from_position_org_line6%type
472: ,position_id per_all_positions.position_id%type
473: ,duty_station_location_id hr_locations.location_id%type
474: , work_schedule ghr_pa_requests.work_schedule%type
475: ,pay_rate_determinant per_assignment_extra_info.aei_information6%type);
476: --

Line 1001: (p_position_id in per_all_positions.position_id%type

997: --
998: -- {End of Comments}
999: -- ---------------------------------------------------------------------------
1000: function get_position_title_pos
1001: (p_position_id in per_all_positions.position_id%type
1002: ,p_business_group_id in per_all_positions.business_group_id%type
1003: ,p_effective_date in date default sysdate
1004: ) return varchar2;
1005: pragma restrict_references (get_position_title_pos, WNDS, WNPS);

Line 1002: ,p_business_group_id in per_all_positions.business_group_id%type

998: -- {End of Comments}
999: -- ---------------------------------------------------------------------------
1000: function get_position_title_pos
1001: (p_position_id in per_all_positions.position_id%type
1002: ,p_business_group_id in per_all_positions.business_group_id%type
1003: ,p_effective_date in date default sysdate
1004: ) return varchar2;
1005: pragma restrict_references (get_position_title_pos, WNDS, WNPS);
1006: --

Line 1080: (p_position_id in per_all_positions.position_id%type

1076: --
1077: -- {End of Comments}
1078: -- ---------------------------------------------------------------------------
1079: function get_position_desc_no_pos
1080: (p_position_id in per_all_positions.position_id%type
1081: ,p_business_group_id in per_all_positions.business_group_id%type
1082: ,p_effective_date in date default sysdate
1083: ) return varchar2;
1084: pragma restrict_references (get_position_desc_no_pos, WNDS, WNPS);

Line 1081: ,p_business_group_id in per_all_positions.business_group_id%type

1077: -- {End of Comments}
1078: -- ---------------------------------------------------------------------------
1079: function get_position_desc_no_pos
1080: (p_position_id in per_all_positions.position_id%type
1081: ,p_business_group_id in per_all_positions.business_group_id%type
1082: ,p_effective_date in date default sysdate
1083: ) return varchar2;
1084: pragma restrict_references (get_position_desc_no_pos, WNDS, WNPS);
1085: --

Line 1159: (p_position_id in per_all_positions.position_id%type

1155: --
1156: -- {End of Comments}
1157: -- ---------------------------------------------------------------------------
1158: function get_position_sequence_no_pos
1159: (p_position_id in per_all_positions.position_id%type
1160: ,p_business_group_id in per_all_positions.business_group_id%type
1161: ,p_effective_date in date default sysdate
1162: ) return varchar2;
1163: pragma restrict_references (get_position_sequence_no_pos, WNDS, WNPS);

Line 1160: ,p_business_group_id in per_all_positions.business_group_id%type

1156: -- {End of Comments}
1157: -- ---------------------------------------------------------------------------
1158: function get_position_sequence_no_pos
1159: (p_position_id in per_all_positions.position_id%type
1160: ,p_business_group_id in per_all_positions.business_group_id%type
1161: ,p_effective_date in date default sysdate
1162: ) return varchar2;
1163: pragma restrict_references (get_position_sequence_no_pos, WNDS, WNPS);
1164: --

Line 1240: (p_position_id in per_all_positions.position_id%type

1236: --
1237: -- {End of Comments}
1238: -- ---------------------------------------------------------------------------
1239: function get_position_agency_code_pos
1240: (p_position_id in per_all_positions.position_id%type
1241: ,p_business_group_id in per_all_positions.business_group_id%type
1242: ,p_effective_date in date default sysdate
1243: ) return varchar2;
1244: pragma restrict_references (get_position_agency_code_pos, WNDS, WNPS);

Line 1241: ,p_business_group_id in per_all_positions.business_group_id%type

1237: -- {End of Comments}
1238: -- ---------------------------------------------------------------------------
1239: function get_position_agency_code_pos
1240: (p_position_id in per_all_positions.position_id%type
1241: ,p_business_group_id in per_all_positions.business_group_id%type
1242: ,p_effective_date in date default sysdate
1243: ) return varchar2;
1244: pragma restrict_references (get_position_agency_code_pos, WNDS, WNPS);
1245: --

Line 1320: ,p_business_group_id in per_all_positions.business_group_id%type

1316: -- ---------------------------------------------------------------------------
1317: --
1318: function get_job_occ_series_job
1319: (p_job_id in per_jobs.job_id%type
1320: ,p_business_group_id in per_all_positions.business_group_id%type
1321: ) return varchar2;
1322: pragma restrict_references (get_job_occ_series_job, WNDS, WNPS);
1323: --
1324: -- ---------------------------------------------------------------------------

Line 1396: ,p_position_id OUT NOCOPY per_all_positions.position_id%type

1392: ,p_position_org_line3 OUT NOCOPY varchar2
1393: ,p_position_org_line4 OUT NOCOPY varchar2
1394: ,p_position_org_line5 OUT NOCOPY varchar2
1395: ,p_position_org_line6 OUT NOCOPY varchar2
1396: ,p_position_id OUT NOCOPY per_all_positions.position_id%type
1397: ,p_duty_station_location_id OUT NOCOPY hr_locations.location_id%type -- duty_station_location_id
1398: ,p_pay_rate_determinant OUT NOCOPY varchar2
1399: ,p_work_schedule OUT NOCOPY varchar2
1400: );