[Home] [Help]
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