PACKAGE BODY: APPS.BEN_BENXAUDT_XMLP_PKG

Source

1 PACKAGE BODY BEN_BENXAUDT_XMLP_PKG AS
2 /* $Header: BENXAUDTB.pls 120.1 2007/12/10 08:39:53 vjaganat noship $ */
3 
4   procedure get_seq_num is
5   begin
6     g_counter := g_counter + 1;
7   end;
8 
9 function valueformula(ext_rcd_id in number, ext_rslt_dtl_id in number, seq_num in number) return varchar2 is
10 begin
11   return(ben_ext_util.get_value(ext_rcd_id, ext_rslt_dtl_id, seq_num));
12 end;
13 
14 --function business_nameformula(business_group_id in number) return varchar2 is
15 function business_nameformula(p_business_group_id in number) return varchar2 is
16   cursor get_bg is
17   SELECT name
18   FROM   hr_all_organization_units_vl
19   --WHERE  organization_id = business_group_id;
20   WHERE  organization_id = p_business_group_id;
21   l_bg_name    hr_all_organization_units.name%type;
22 begin
23 
24   open get_bg;
25   fetch get_bg into l_bg_name;
26   close get_bg;
27   return (l_bg_name);
28 end;
29 
30 function BetweenPage return boolean is
31 begin
32   g_counter := g_counter - 1;
33   return (TRUE);
34 end;
35 
36 function BeforeReport return boolean is
37 begin
38     --hr_standard.event('BEFORE REPORT');
39   return (TRUE);
40 end;
41 
42 function AfterReport return boolean is
43 begin
44     --hr_standard.event('AFTER REPORT');
45   return (TRUE);
46 end;
47 
48 --Functions to refer Oracle report placeholders--
49 
50 END BEN_BENXAUDT_XMLP_PKG ;