PACKAGE BODY: APPS.PA_PAXRWRVC_XMLP_PKG

Source

1 PACKAGE BODY PA_PAXRWRVC_XMLP_PKG AS
2 /* $Header: PAXRWRVCB.pls 120.0 2008/01/02 12:14:54 krreddy noship $ */
3 
4 FUNCTION  get_company_name    RETURN BOOLEAN IS
5   l_name                  gl_sets_of_books.name%TYPE;
6 BEGIN
7 
8 
9 
10 
11 
12   c_company_name_header     := l_name;
13 
14   RETURN (TRUE);
15 
16 EXCEPTION
17 
18   WHEN   OTHERS  THEN
19     RETURN (FALSE);
20 
21 END;
22 
23 function BeforeReport return boolean is
24 begin
25 
26 
27 declare
28 init_error exception;
29 rev_category_name pa_lookups.meaning%TYPE;
30 begin
31 /*srw.user_exit('FND SRWINIT');*/null;
32 
33 
34 if p_revenue_category is not NULL then
35     select meaning into rev_category_name from
36             pa_lookups
37     where
38        lookup_code = p_revenue_category;
39 end if;
40 C_Revenue_Category:= rev_category_name;
41 
42 
43 
44 
45 
46 end;  return (TRUE);
47 end;
48 
49 function AfterReport return boolean is
50 begin
51   /*srw.user_exit('FND SRWEXIT') ;*/null;
52 
53   return (TRUE);
54 end;
55 
56 --Functions to refer Oracle report placeholders--
57 
58  Function C_Company_Name_Header_p return varchar2 is
59 	Begin
60 	 return C_Company_Name_Header;
61 	 END;
62  Function C_Revenue_Category_p return varchar2 is
63 	Begin
64 	 return C_Revenue_Category;
65 	 END;
66 END PA_PAXRWRVC_XMLP_PKG ;
67