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 ;