PACKAGE BODY: APPS.PO_POXSURUC_XMLP_PKG

Source

1 PACKAGE BODY PO_POXSURUC_XMLP_PKG AS
2 /* $Header: POXSURUCB.pls 120.1 2007/12/25 12:34:17 krreddy noship $ */
3 
4 function BeforeReport return boolean is
5 begin
6 
7 declare
8 l_active_inactive    po_lookup_codes.displayed_field%type ;
9 begin
10 /*SRW.USER_EXIT('FND SRWINIT');*/null;
11 
12 if P_active_inactive is not null then
13 
14     select displayed_field
15     into l_active_inactive
16     from po_lookup_codes
17     where lookup_code = P_active_inactive
18     and lookup_type = 'ACTIVE_INACTIVE';
19 
20     P_active_inactive_disp := l_active_inactive ;
21 
22 else
23 
24     P_active_inactive_disp := '' ;
25 
26 end if;
27 
28 end;
29   return (TRUE);
30 end;
31 
32 function AfterReport return boolean is
33 begin
34   /*SRW.USER_EXIT('FND SRWEXIT');*/null;
35 
36   return (TRUE);
37 end;
38 
39 --Functions to refer Oracle report placeholders--
40 
41 END PO_POXSURUC_XMLP_PKG ;
42