eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.GHR_API dependencies on PER_PEOPLE_F

Line 448: (p_national_identifier per_people_f.national_identifier%type

444: ,career_program_code per_position_extra_info.poei_information7%type
445: ,acteds_key_position per_position_extra_info.poei_information8%type);
446: --
447: type personal_info_type is record
448: (p_national_identifier per_people_f.national_identifier%type
449: ,p_date_of_birth per_people_f.date_of_birth%type
450: ,p_sex per_people_f.sex%type);
451: --
452: type prior_sf52_data_type is record

Line 449: ,p_date_of_birth per_people_f.date_of_birth%type

445: ,acteds_key_position per_position_extra_info.poei_information8%type);
446: --
447: type personal_info_type is record
448: (p_national_identifier per_people_f.national_identifier%type
449: ,p_date_of_birth per_people_f.date_of_birth%type
450: ,p_sex per_people_f.sex%type);
451: --
452: type prior_sf52_data_type is record
453: (position_title per_position_definitions.segment1%type

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

446: --
447: type personal_info_type is record
448: (p_national_identifier per_people_f.national_identifier%type
449: ,p_date_of_birth per_people_f.date_of_birth%type
450: ,p_sex per_people_f.sex%type);
451: --
452: type prior_sf52_data_type is record
453: (position_title per_position_definitions.segment1%type
454: ,position_number per_position_definitions.segment2%type

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

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

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

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

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

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

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

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

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

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

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

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

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

1482: -- |--------------------------< return_education_Details >----------------|
1483: -- --------------------------------------------------------------------------
1484:
1485: Procedure return_education_Details
1486: (p_person_id in per_people_f.person_id%type,
1487: p_effective_date in date,
1488: p_education_level OUT NOCOPY per_analysis_criteria.segment1%type,
1489: p_academic_discipline OUT NOCOPY per_analysis_criteria.segment2%type,
1490: p_year_degree_attained OUT NOCOPY per_analysis_criteria.segment3%type