DBA Data[Home] [Help]

APPS.GHR_API dependencies on PER_ALL_POSITIONS

Line 441: ,position_id per_all_positions.position_id%type

437: ,position_org_line3 ghr_pa_requests.from_position_org_line3%type
438: ,position_org_line4 ghr_pa_requests.from_position_org_line4%type
439: ,position_org_line5 ghr_pa_requests.from_position_org_line5%type
440: ,position_org_line6 ghr_pa_requests.from_position_org_line6%type
441: ,position_id per_all_positions.position_id%type
442: ,duty_station_location_id hr_locations.location_id%type
443: , work_schedule ghr_pa_requests.work_schedule%type
444: ,pay_rate_determinant per_assignment_extra_info.aei_information6%type);
445: --

Line 963: (p_position_id in per_all_positions.position_id%type

959: --
960: -- {End of Comments}
961: -- ---------------------------------------------------------------------------
962: function get_position_title_pos
963: (p_position_id in per_all_positions.position_id%type
964: ,p_business_group_id in per_all_positions.business_group_id%type
965: ,p_effective_date in date default sysdate
966: ) return varchar2;
967: pragma restrict_references (get_position_title_pos, WNDS, WNPS);

Line 964: ,p_business_group_id in per_all_positions.business_group_id%type

960: -- {End of Comments}
961: -- ---------------------------------------------------------------------------
962: function get_position_title_pos
963: (p_position_id in per_all_positions.position_id%type
964: ,p_business_group_id in per_all_positions.business_group_id%type
965: ,p_effective_date in date default sysdate
966: ) return varchar2;
967: pragma restrict_references (get_position_title_pos, WNDS, WNPS);
968: --

Line 1042: (p_position_id in per_all_positions.position_id%type

1038: --
1039: -- {End of Comments}
1040: -- ---------------------------------------------------------------------------
1041: function get_position_desc_no_pos
1042: (p_position_id in per_all_positions.position_id%type
1043: ,p_business_group_id in per_all_positions.business_group_id%type
1044: ,p_effective_date in date default sysdate
1045: ) return varchar2;
1046: pragma restrict_references (get_position_desc_no_pos, WNDS, WNPS);

Line 1043: ,p_business_group_id in per_all_positions.business_group_id%type

1039: -- {End of Comments}
1040: -- ---------------------------------------------------------------------------
1041: function get_position_desc_no_pos
1042: (p_position_id in per_all_positions.position_id%type
1043: ,p_business_group_id in per_all_positions.business_group_id%type
1044: ,p_effective_date in date default sysdate
1045: ) return varchar2;
1046: pragma restrict_references (get_position_desc_no_pos, WNDS, WNPS);
1047: --

Line 1121: (p_position_id in per_all_positions.position_id%type

1117: --
1118: -- {End of Comments}
1119: -- ---------------------------------------------------------------------------
1120: function get_position_sequence_no_pos
1121: (p_position_id in per_all_positions.position_id%type
1122: ,p_business_group_id in per_all_positions.business_group_id%type
1123: ,p_effective_date in date default sysdate
1124: ) return varchar2;
1125: pragma restrict_references (get_position_sequence_no_pos, WNDS, WNPS);

Line 1122: ,p_business_group_id in per_all_positions.business_group_id%type

1118: -- {End of Comments}
1119: -- ---------------------------------------------------------------------------
1120: function get_position_sequence_no_pos
1121: (p_position_id in per_all_positions.position_id%type
1122: ,p_business_group_id in per_all_positions.business_group_id%type
1123: ,p_effective_date in date default sysdate
1124: ) return varchar2;
1125: pragma restrict_references (get_position_sequence_no_pos, WNDS, WNPS);
1126: --

Line 1202: (p_position_id in per_all_positions.position_id%type

1198: --
1199: -- {End of Comments}
1200: -- ---------------------------------------------------------------------------
1201: function get_position_agency_code_pos
1202: (p_position_id in per_all_positions.position_id%type
1203: ,p_business_group_id in per_all_positions.business_group_id%type
1204: ,p_effective_date in date default sysdate
1205: ) return varchar2;
1206: pragma restrict_references (get_position_agency_code_pos, WNDS, WNPS);

Line 1203: ,p_business_group_id in per_all_positions.business_group_id%type

1199: -- {End of Comments}
1200: -- ---------------------------------------------------------------------------
1201: function get_position_agency_code_pos
1202: (p_position_id in per_all_positions.position_id%type
1203: ,p_business_group_id in per_all_positions.business_group_id%type
1204: ,p_effective_date in date default sysdate
1205: ) return varchar2;
1206: pragma restrict_references (get_position_agency_code_pos, WNDS, WNPS);
1207: --

Line 1282: ,p_business_group_id in per_all_positions.business_group_id%type

1278: -- ---------------------------------------------------------------------------
1279: --
1280: function get_job_occ_series_job
1281: (p_job_id in per_jobs.job_id%type
1282: ,p_business_group_id in per_all_positions.business_group_id%type
1283: ) return varchar2;
1284: pragma restrict_references (get_job_occ_series_job, WNDS, WNPS);
1285: --
1286: -- ---------------------------------------------------------------------------

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

1354: ,p_position_org_line3 OUT NOCOPY varchar2
1355: ,p_position_org_line4 OUT NOCOPY varchar2
1356: ,p_position_org_line5 OUT NOCOPY varchar2
1357: ,p_position_org_line6 OUT NOCOPY varchar2
1358: ,p_position_id OUT NOCOPY per_all_positions.position_id%type
1359: ,p_duty_station_location_id OUT NOCOPY hr_locations.location_id%type -- duty_station_location_id
1360: ,p_pay_rate_determinant OUT NOCOPY varchar2
1361: ,p_work_schedule OUT NOCOPY varchar2
1362: );