DBA Data[Home] [Help]

APPS.GHR_API dependencies on PER_PEOPLE_F

Line 98: (p_person_id in per_people_f.person_id%type default null

94: -- {End of Comments}
95: -- ---------------------------------------------------------------------------
96: --
97: procedure retrieve_business_group_id
98: (p_person_id in per_people_f.person_id%type default null
99: ,p_assignment_id in per_assignments_f.assignment_id%type default null
100: ,p_effective_date in date default sysdate
101: ,p_business_group_id OUT NOCOPY per_business_groups.business_group_id%type
102: ) is

Line 174: (p_person_id in per_people_f.person_id%type default null

170:
171: -- retrieve_business_group_id overloaded to cater to refresh for the correction of SF52.
172: -- vsm
173: procedure retrieve_business_group_id
174: (p_person_id in per_people_f.person_id%type default null
175: ,p_assignment_id in per_assignments_f.assignment_id%type default null
176: ,p_effective_date in date default sysdate
177: ,p_altered_pa_request_id in number
178: ,p_pa_history_id in number

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

1918: -- |--------------------------< get_position_title >-------------------------|
1919: -- ---------------------------------------------------------------------------
1920: --
1921: function get_position_title
1922: (p_person_id in per_people_f.person_id%type default NULL
1923: ,p_assignment_id in per_assignments_f.assignment_id%type default NULL
1924: ,p_effective_date in date default sysdate
1925: ) return varchar2 is
1926: --

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

2053: -- |---------------------< get_position_description_no >---------------------|
2054: -- ---------------------------------------------------------------------------
2055: --
2056: function get_position_description_no
2057: (p_person_id in per_people_f.person_id%type default NULL
2058: ,p_assignment_id in per_assignments_f.assignment_id%type default NULL
2059: ,p_effective_date in date default sysdate
2060: ) return varchar2 is
2061: --

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

2190: -- |----------------------< get_position_sequence_no >-----------------------|
2191: -- ---------------------------------------------------------------------------
2192: --
2193: function get_position_sequence_no
2194: (p_person_id in per_people_f.person_id%type default NULL
2195: ,p_assignment_id in per_assignments_f.assignment_id%type default NULL
2196: ,p_effective_date in date default sysdate
2197: ) return varchar2 is
2198: --

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

2327: -- |----------------------< get_position_agency_code >-----------------------|
2328: -- ---------------------------------------------------------------------------
2329: --
2330: function get_position_agency_code
2331: (p_person_id in per_people_f.person_id%type default NULL
2332: ,p_assignment_id in per_assignments_f.assignment_id%type default NULL
2333: ,p_effective_date in date default sysdate
2334: ) return varchar2 is
2335: --

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

2464: -- |---------------------< get_job_occupational_series >---------------------|
2465: -- ---------------------------------------------------------------------------
2466: --
2467: function get_job_occupational_series
2468: (p_person_id in per_people_f.person_id%type default NULL
2469: ,p_assignment_id in per_assignments_f.assignment_id%type default NULL
2470: ,p_effective_date in date default sysdate
2471: ) return varchar2 is
2472: --

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

2600: -- |-----------------------< sf52_from_data_elements >-----------------------|
2601: -- ---------------------------------------------------------------------------
2602: --
2603: procedure sf52_from_data_elements
2604: (p_person_id in per_people_f.person_id%type default NULL
2605: ,p_assignment_id IN OUT NOCOPY per_assignments_f.assignment_id%type
2606: ,p_effective_date in date default sysdate
2607: -- vsm added following 2 parameters
2608: ,p_altered_pa_request_id in number

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

3758: -- |--------------------------< return_education_Details >----------------|
3759: -- --------------------------------------------------------------------------
3760:
3761: Procedure return_education_Details
3762: (p_person_id in per_people_f.person_id%type,
3763: p_effective_date in date,
3764: p_education_level OUT NOCOPY per_analysis_criteria.segment1%type,
3765: p_academic_discipline OUT NOCOPY per_analysis_criteria.segment2%type,
3766: p_year_degree_attained OUT NOCOPY per_analysis_criteria.segment3%type