APPS.GHR_BREAKDOWN_RPT dependencies on GHR_API

Line 203: ,p_special_info OUT NOCOPY ghr_api.special_information_type

199: Procedure return_special_information
200: (p_person_id in number
201: ,p_structure_name in varchar2
202: ,p_effective_date in date
203: ,p_special_info OUT NOCOPY ghr_api.special_information_type
204: )
205: is
206: l_proc varchar2(72) := 'return_special_information ';
207: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;

Line 303: l_special_info ghr_api.special_information_type;

299: l_result VARCHAR2(300);
300: l_rescpy VARCHAR2(300);
301: l_int INTEGER;
302: -- record structure for special Info 'US Fed Perf Appraisal'
303: l_special_info ghr_api.special_information_type;
304: l_posei_data per_position_extra_info%ROWTYPE;
305: BEGIN
306: IF p_clause = 'GRADE/LEVEL' -- Grade or Level
307: THEN

Line 449: l_result := ghr_api.get_position_agency_code_pos(p_ASG.position_id,

445: INTO l_result
446: FROM per_people_f
447: WHERE rowid = p_PER_rowid;
448: ELSIF p_clause = 'AGENCY_CODE' THEN
449: l_result := ghr_api.get_position_agency_code_pos(p_ASG.position_id,
450: p_ASG.business_group_id);
451: ELSIF p_clause = 'ORGANIZATION_ID' THEN
452: SELECT POS.organization_id
453: INTO l_result

Line 482: AND ghr_api.get_position_agency_code_pos(ASG.position_id, ASG.business_group_id)

478: AND PER.person_id = ASG.person_id
479: AND l_effective_date BETWEEN ASG.effective_start_date
480: AND ASG.effective_end_date
481: AND get_hierarchy_level(ASG.position_id, l_effective_date) >= l_for_clause
482: AND ghr_api.get_position_agency_code_pos(ASG.position_id, ASG.business_group_id)
483: LIKE l_agcy_and_selm
484: AND ASG.primary_flag = 'Y'
485: AND ASG.assignment_type <> 'B';
486: r_GRP1 per_people_extra_info%rowtype;