1 PACKAGE BODY BEN_BENXSMRY_XMLP_PKG AS
2 /* $Header: BENXSMRYB.pls 120.1 2007/12/10 08:41:35 vjaganat noship $ */
3
4 function valueformula(ext_rcd_id in number, ext_rslt_dtl_id in number, seq_num in number) return varchar2 is
5 begin
6 return(ben_ext_util.get_value(ext_rcd_id, ext_rslt_dtl_id, seq_num));
7 end;
8
9 function business_groupformula(p_business_group_id in number) return varchar2 is
10
11 cursor get_bg_name is
12 SELECT name
13 FROM per_business_groups
14 WHERE business_group_id = p_business_group_id;
15
16 l_name per_business_groups.name%type ;
17 begin
18 open get_bg_name;
19 fetch get_bg_name into l_name;
20 close get_bg_name;
21
22 return (l_name);
23 end;
24
25 function total_peopleformula(people_count_dummy in number, error_count_dummy in number) return number is
26 begin
27 return(nvl(people_count_dummy, 0) + nvl(error_count_dummy, 0));
28 end;
29
30 function BeforeReport return boolean is
31 begin
32 --hr_standard.event('BEFORE REPORT');
33 return (TRUE);
34 end;
35
36 function AfterReport return boolean is
37 begin
38 --hr_standard.event('AFTER REPORT');
39 return (TRUE);
40 end;
41
42 --Functions to refer Oracle report placeholders--
43
44 END BEN_BENXSMRY_XMLP_PKG ;