[Home] [Help]
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 ;