DBA Data[Home] [Help]

APPS.GHR_API dependencies on PER_ASSIGNMENTS_F

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

923: -- {End of Comments}
924: -- ---------------------------------------------------------------------------
925: function get_position_title
926: (p_person_id in per_people_f.person_id%type default NULL
927: ,p_assignment_id in per_assignments_f.assignment_id%type default NULL
928: ,p_effective_date in date default sysdate ) return varchar2;
929: pragma restrict_references (get_position_title, WNDS, WNPS);
930: --
931: -- ---------------------------------------------------------------------------

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

1001: -- {End of Comments}
1002: -- ---------------------------------------------------------------------------
1003: function get_position_description_no
1004: (p_person_id in per_people_f.person_id%type default NULL
1005: ,p_assignment_id in per_assignments_f.assignment_id%type default NULL
1006: ,p_effective_date in date default sysdate
1007: ) return varchar2;
1008: pragma restrict_references (get_position_description_no, WNDS, WNPS);
1009: --

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

1080: -- {End of Comments}
1081: -- ---------------------------------------------------------------------------
1082: function get_position_sequence_no
1083: (p_person_id in per_people_f.person_id%type default NULL
1084: ,p_assignment_id in per_assignments_f.assignment_id%type default NULL
1085: ,p_effective_date in date default sysdate
1086: ) return varchar2;
1087: pragma restrict_references (get_position_sequence_no, WNDS, WNPS);
1088: --

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

1161: -- {End of Comments}
1162: -- ---------------------------------------------------------------------------
1163: function get_position_agency_code
1164: (p_person_id in per_people_f.person_id%type default NULL
1165: ,p_assignment_id in per_assignments_f.assignment_id%type default NULL
1166: ,p_effective_date in date default sysdate
1167: ) return varchar2;
1168: pragma restrict_references (get_position_agency_code, WNDS, WNPS);
1169: --

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

1240: -- ---------------------------------------------------------------------------
1241: --
1242: function get_job_occupational_series
1243: (p_person_id in per_people_f.person_id%type default NULL
1244: ,p_assignment_id in per_assignments_f.assignment_id%type default NULL
1245: ,p_effective_date in date default sysdate
1246: ) return varchar2;
1247: pragma restrict_references (get_job_occupational_series, WNDS, WNPS);
1248: --

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

1314: -- ---------------------------------------------------------------------------
1315: --
1316: procedure sf52_from_data_elements
1317: (p_person_id in per_people_f.person_id%type default NULL
1318: ,p_assignment_id IN OUT NOCOPY per_assignments_f.assignment_id%type
1319: ,p_effective_date in date default sysdate
1320: ,p_altered_pa_request_id in number
1321: ,p_noa_id_corrected in number
1322: ,p_pa_history_id in number