PACKAGE BODY: APPS.PER_PERRPRMS_XMLP_PKG

Source

1 PACKAGE BODY PER_PERRPRMS_XMLP_PKG AS
2 /* $Header: PERRPRMSB.pls 120.1 2007/12/06 11:32:43 amakrish noship $ */
3 
4 function BeforeReport return boolean is
5 begin
6 
7 c_end_of_time := hr_general.end_of_time;
8 declare l_legislation_code VARCHAR2(2);
9 begin
10 P_SESSION_DATE1:=TO_CHAR(P_SESSION_DATE,'DD-MON-YYYY');
11 --hr_standard.event('BEFORE REPORT');
12 
13  c_business_group_name :=
14    hr_reports.get_business_group(p_business_group_id);
15 
16  select legislation_code
17  into   l_legislation_code
18  from   per_business_groups
19  where  business_group_id = p_business_group_id;
20 
21  p_legislation_code := l_legislation_code ;
22  IF p_position_id is not null then
23         c_job_position_id := p_position_id;
24         p_job_position := 'POSITION_ID';
25         c_job_position_name :=
26             hr_reports.get_position(p_position_id);
27  ELSIF
28     p_job_id is not null then
29         c_job_position_id := p_job_id;
30          p_job_position := 'JOB_ID';
31         c_job_position_name :=
32             hr_reports.get_job(p_job_id);
33  END IF;
34 
35 
36  c_person_type_desc :=
37        hr_reports.get_lookup_meaning('EMP_OR_APL',p_person_type);
38 
39 
40 
41  null;
42 end;  return (TRUE);
43 end;
44 
45 function C_SPECIAL_INFO_SEGSFormula return Number is
46 begin
47 
48 
49 return(0);
50 end;
51 
52 function g_people_matchinggroupfilter(c_special_info_count in number, person_id1 in number, C_COUNT_ESSENTIAL in number, C_COUNT_DESIRABLE in number) return boolean is
53 begin
54 
55 if c_special_info_count = 0 then return(false);
56 else
57 return(
58 hr_reports.person_matching_skills
59 (person_id1
60 ,C_JOB_POSITION_ID
61 ,substr(P_JOB_POSITION,1,1)
62 ,P_MATCHING_LEVEL
63 ,C_COUNT_ESSENTIAL
64 ,C_COUNT_DESIRABLE)
65 );
66 end if;  return (TRUE);
67 end;
68 
69 function c_date_toformula(date_to in date) return varchar2 is
70 begin
71 
72 if date_to = c_end_of_time then
73    return('');
74    else
75    return(to_char(date_to,'DD-MON-YYYY'));
76 end if;
77 
78 RETURN NULL; end;
79 
80 function C_REQUIREMENT_HEADINGFormula return VARCHAR2 is
81 begin
82 
83 return(rpad('-',NVL(length(c_requirement_desc), 0),'-'));
84 end;
85 
86 function c_essential_decodeformula(essential in varchar2) return varchar2 is
87 begin
88 
89 return(hr_reports.get_lookup_meaning
90                   ('YES_NO',essential));
91 end;
92 
93 function AfterReport return boolean is
94 begin
95 
96 --hr_standard.event('AFTER REPORT');
97 
98   return (TRUE);
99 end;
100 
101 --Functions to refer Oracle report placeholders--
102 
103  Function C_REQ_VAL_p return varchar2 is
104 	Begin
105 	 return C_REQ_VAL;
106 	 END;
107  Function C_BUSINESS_GROUP_NAME_p return varchar2 is
108 	Begin
109 	 return C_BUSINESS_GROUP_NAME;
110 	 END;
111  Function C_REPORT_SUBTITLE_p return varchar2 is
112 	Begin
113 	 return C_REPORT_SUBTITLE;
114 	 END;
115  Function C_JOB_POSITION_ID_p return number is
116 	Begin
117 	 return C_JOB_POSITION_ID;
118 	 END;
119  Function C_JOB_POSITION_NAME_p return varchar2 is
120 	Begin
121 	 return C_JOB_POSITION_NAME;
122 	 END;
123  Function C_PERSON_TYPE_DESC_p return varchar2 is
124 	Begin
125 	 return C_PERSON_TYPE_DESC;
126 	 END;
127  Function C_REQUIREMENT_DESC_p return varchar2 is
128 	Begin
129 	 return C_REQUIREMENT_DESC;
130 	 END;
131  Function C_REQUIREMENT_VALUE_p return varchar2 is
132 	Begin
133 	 return C_REQUIREMENT_VALUE;
134 	 END;
135  Function C_END_OF_TIME_p return date is
136 	Begin
137 	 return C_END_OF_TIME;
138 	 END;
139 END PER_PERRPRMS_XMLP_PKG ;