PACKAGE BODY: APPS.PO_POXPOPAA_XMLP_PKG

Source

1 PACKAGE BODY PO_POXPOPAA_XMLP_PKG AS
2 /* $Header: POXPOPAAB.pls 120.1 2007/12/25 11:16:51 krreddy noship $ */
3 
4 function BeforeReport return boolean is
5 begin
6 
7 BEGIN
8   /*SRW.USER_EXIT('FND SRWINIT');*/null;
9 
10 QTY_PRECISION:=po_common_XMLP_PKG.GET_PRECISION(P_QTY_PRECISION);
11   if (get_p_struct_num <> TRUE )
12     then /*SRW.MESSAGE('1','P Struct Num Init failed');*/null;
13 
14   end if;
15 
16  null;
17 
18 
19  null;
20 END;  return (TRUE);
21 end;
22 
23 function AfterReport return boolean is
24 begin
25 
26 /*SRW.USER_EXIT('FND SRWEXIT');*/null;
27   return (TRUE);
28 end;
29 
30 function get_p_struct_num return boolean is
31 
32 l_p_struct_num number;
33 
34 begin
35         select structure_id
36         into l_p_struct_num
37         from mtl_default_sets_view
38         where functional_area_id = 2 ;
39 
40         P_STRUCT_NUM := l_p_struct_num ;
41 
42         return(TRUE) ;
43 
44         RETURN NULL; exception
45         when others then return(FALSE) ;
46 end;
47 
48 function cf_buyer_formulaformula(buyer in varchar2) return char is
49 begin
50   cp_buyer:=buyer;
51   return null;
52 end;
53 
54 function CF_BUYERFormula return Char is
55 buyer varchar(240):=null;
56 begin
57 
58   if p_buyer is not null then
59   buyer:=cp_buyer;
60   else
61   buyer:=null;
62   end if;
63 
64  return buyer;
65 
66 end;
67 
68 function CP_BUYERFormula return Char is
69 begin
70   null;end;
71 
72 --Functions to refer Oracle report placeholders--
73 
74  Function CP_BUYER_p return varchar2 is
75 	Begin
76 	 return CP_BUYER;
77 	 END;
78 END PO_POXPOPAA_XMLP_PKG ;
79