PACKAGE BODY: APPS.BEN_BENXSMRY_XMLP_PKG

Source

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 ;