DBA Data[Home] [Help]

APPS.GHR_API dependencies on PER_PEOPLE_F

Line 417: (p_national_identifier per_people_f.national_identifier%type

413: ,career_program_code per_position_extra_info.poei_information7%type
414: ,acteds_key_position per_position_extra_info.poei_information8%type);
415: --
416: type personal_info_type is record
417: (p_national_identifier per_people_f.national_identifier%type
418: ,p_date_of_birth per_people_f.date_of_birth%type
419: ,p_sex per_people_f.sex%type);
420: --
421: type prior_sf52_data_type is record

Line 418: ,p_date_of_birth per_people_f.date_of_birth%type

414: ,acteds_key_position per_position_extra_info.poei_information8%type);
415: --
416: type personal_info_type is record
417: (p_national_identifier per_people_f.national_identifier%type
418: ,p_date_of_birth per_people_f.date_of_birth%type
419: ,p_sex per_people_f.sex%type);
420: --
421: type prior_sf52_data_type is record
422: (position_title per_position_definitions.segment1%type

Line 419: ,p_sex per_people_f.sex%type);

415: --
416: type personal_info_type is record
417: (p_national_identifier per_people_f.national_identifier%type
418: ,p_date_of_birth per_people_f.date_of_birth%type
419: ,p_sex per_people_f.sex%type);
420: --
421: type prior_sf52_data_type is record
422: (position_title per_position_definitions.segment1%type
423: ,position_number per_position_definitions.segment2%type

Line 926: (p_person_id in per_people_f.person_id%type default NULL

922: --
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: --

Line 1004: (p_person_id in per_people_f.person_id%type default NULL

1000: --
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);

Line 1083: (p_person_id in per_people_f.person_id%type default NULL

1079: --
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);

Line 1164: (p_person_id in per_people_f.person_id%type default NULL

1160: --
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);

Line 1243: (p_person_id in per_people_f.person_id%type default NULL

1239: -- {End of Comments}
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);

Line 1317: (p_person_id in per_people_f.person_id%type default NULL

1313: -- {End of Comments}
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

Line 1448: (p_person_id in per_people_f.person_id%type,

1444: -- |--------------------------< return_education_Details >----------------|
1445: -- --------------------------------------------------------------------------
1446:
1447: Procedure return_education_Details
1448: (p_person_id in per_people_f.person_id%type,
1449: p_effective_date in date,
1450: p_education_level OUT NOCOPY per_analysis_criteria.segment1%type,
1451: p_academic_discipline OUT NOCOPY per_analysis_criteria.segment2%type,
1452: p_year_degree_attained OUT NOCOPY per_analysis_criteria.segment3%type