DBA Data[Home] [Help]

APPS.GHR_API dependencies on PER_ASSIGNMENTS_F

Line 965: ,p_assignment_id in per_assignments_f.assignment_id%type default NULL

961: -- {End of Comments}
962: -- ---------------------------------------------------------------------------
963: function get_position_title
964: (p_person_id in per_people_f.person_id%type default NULL
965: ,p_assignment_id in per_assignments_f.assignment_id%type default NULL
966: ,p_effective_date in date default sysdate ) return varchar2;
967: pragma restrict_references (get_position_title, WNDS, WNPS);
968: --
969: -- ---------------------------------------------------------------------------

Line 1043: ,p_assignment_id in per_assignments_f.assignment_id%type default NULL

1039: -- {End of Comments}
1040: -- ---------------------------------------------------------------------------
1041: function get_position_description_no
1042: (p_person_id in per_people_f.person_id%type default NULL
1043: ,p_assignment_id in per_assignments_f.assignment_id%type default NULL
1044: ,p_effective_date in date default sysdate
1045: ) return varchar2;
1046: pragma restrict_references (get_position_description_no, WNDS, WNPS);
1047: --

Line 1122: ,p_assignment_id in per_assignments_f.assignment_id%type default NULL

1118: -- {End of Comments}
1119: -- ---------------------------------------------------------------------------
1120: function get_position_sequence_no
1121: (p_person_id in per_people_f.person_id%type default NULL
1122: ,p_assignment_id in per_assignments_f.assignment_id%type default NULL
1123: ,p_effective_date in date default sysdate
1124: ) return varchar2;
1125: pragma restrict_references (get_position_sequence_no, WNDS, WNPS);
1126: --

Line 1203: ,p_assignment_id in per_assignments_f.assignment_id%type default NULL

1199: -- {End of Comments}
1200: -- ---------------------------------------------------------------------------
1201: function get_position_agency_code
1202: (p_person_id in per_people_f.person_id%type default NULL
1203: ,p_assignment_id in per_assignments_f.assignment_id%type default NULL
1204: ,p_effective_date in date default sysdate
1205: ) return varchar2;
1206: pragma restrict_references (get_position_agency_code, WNDS, WNPS);
1207: --

Line 1282: ,p_assignment_id in per_assignments_f.assignment_id%type default NULL

1278: -- ---------------------------------------------------------------------------
1279: --
1280: function get_job_occupational_series
1281: (p_person_id in per_people_f.person_id%type default NULL
1282: ,p_assignment_id in per_assignments_f.assignment_id%type default NULL
1283: ,p_effective_date in date default sysdate
1284: ) return varchar2;
1285: pragma restrict_references (get_job_occupational_series, WNDS, WNPS);
1286: --

Line 1356: ,p_assignment_id IN OUT NOCOPY per_assignments_f.assignment_id%type

1352: -- ---------------------------------------------------------------------------
1353: --
1354: procedure sf52_from_data_elements
1355: (p_person_id in per_people_f.person_id%type default NULL
1356: ,p_assignment_id IN OUT NOCOPY per_assignments_f.assignment_id%type
1357: ,p_effective_date in date default sysdate
1358: ,p_altered_pa_request_id in number
1359: ,p_noa_id_corrected in number
1360: ,p_pa_history_id in number