1 PACKAGE BODY SSP_SSPRPOAR_XMLP_PKG AS
2 /* $Header: SSPRPOARB.pls 120.1 2007/12/24 14:06:24 amakrish noship $ */
3
4 function BeforeReport return boolean is
5 begin
6
7 begin
8 /*srw.user_exit('FND SRWINIT');*/null;
9
10 c_business_group_name := hr_reports.get_business_group(p_bus_grp);
11
12 if P_payroll is not null then
13 Select distinct payroll_name into c_payroll_name
14 from Pay_payrolls_f
15 where payroll_id = P_payroll ;
16 end if;
17 fnd_date.initialize('YYYY/MM/DD', null);
18 Exception
19 When Others then
20 null;
21 end;
22 return (TRUE);
23 end;
24
25 function end_report(c_report_tot in number) return varchar2 is
26 a varchar2(25);
27 begin
28 If c_report_tot = 0 then
29 -- a := '*** No Data Found ***';
30 a := 'No Data Found';
31 else
32 -- a := '*** End of Report ***';
33 a := 'End of Report';
34 end if;
35 return(a);
36 end;
37
38 function AfterReport return boolean is
39 begin
40 /*srw.user_exit('FND SRWEXIT');*/null;
41
42 return (TRUE);
43 end;
44
45 --Functions to refer Oracle report placeholders--
46
47 Function C_BUSINESS_GROUP_NAME_p return varchar2 is
48 Begin
49 return C_BUSINESS_GROUP_NAME;
50 END;
51 Function C_PAYROLL_NAME_p return varchar2 is
52 Begin
53 return C_PAYROLL_NAME;
54 END;
55 END SSP_SSPRPOAR_XMLP_PKG ;