PACKAGE BODY: APPS.PER_PERUSCNL_XMLP_PKG

Source

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