[Home] [Help]
PACKAGE BODY: APPS.PER_PERUSCPE_XMLP_PKG
Source
1 PACKAGE BODY PER_PERUSCPE_XMLP_PKG AS
2 /* $Header: PERUSCPEB.pls 120.0 2007/12/28 06:57:47 srikrish noship $ */
3
4 function BeforeReport return boolean is
5 begin
6
7 declare
8 v_organization_name varchar2(60);
9 begin
10
11 --hr_standard.event('BEFORE REPORT');
12 LP_SESSION_DATE := to_char(P_SESSION_DATE, 'dd-mon-yyyy');
13
14 c_business_group_name :=
15 hr_reports.get_business_group(p_business_group_id);
16 v_organization_name := c_business_group_name;
17
18 c_employee_name := hr_reports.get_person_name(
19 p_session_date => lp_session_date,
20 p_person_id => TO_NUMBER(p_person_id ));
21
22 IF ( p_qual_date IS NOT NULL )
23 THEN
24 c_qualifying_date := TO_CHAR(p_qual_date, 'DD-MON-YYYY');
25 ELSE
26 c_qualifying_date := '';
27 END IF;
28
29 end; return (TRUE);
30 end;
31
32 function AfterReport return boolean is
33 begin
34
35 --hr_standard.event('AFTER REPORT');
36
37 return (TRUE);
38 end;
39
40 --Functions to refer Oracle report placeholders--
41
42 Function C_LETTER_DATE_p return date is
43 Begin
44 return C_LETTER_DATE;
45 END;
46 Function C_BUSINESS_GROUP_NAME_p return varchar2 is
47 Begin
48 return C_BUSINESS_GROUP_NAME;
49 END;
50 Function C_EMPLOYEE_NAME_p return varchar2 is
51 Begin
52 return C_EMPLOYEE_NAME;
53 END;
54 Function C_QUALIFYING_DATE_p return varchar2 is
55 Begin
56 return C_QUALIFYING_DATE;
57 END;
58 END PER_PERUSCPE_XMLP_PKG ;