DBA Data[Home] [Help]

PACKAGE BODY: APPS.PA_PAXRWPCR_XMLP_PKG

Source


1 PACKAGE BODY PA_PAXRWPCR_XMLP_PKG AS
2 /* $Header: PAXRWPCRB.pls 120.0 2008/01/02 12:07:19 krreddy noship $ */
3 
4 FUNCTION  get_company_name    RETURN BOOLEAN IS
5   l_name                  gl_sets_of_books.name%TYPE;
6 BEGIN
7   SELECT  gl.name
8   INTO    l_name
9   FROM    gl_sets_of_books gl,pa_implementations pi
10   WHERE   gl.set_of_books_id = pi.set_of_books_id;
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 begin
30 /*srw.user_exit('FND SRWINIT');*/null;
31 
32 
33 end;  return (TRUE);
34 end;
35 
36 function AfterReport return boolean is
37 begin
38   /*srw.user_exit('FND SRWEXIT') ;*/null;
39 
40   return (TRUE);
41 end;
42 
43 --Functions to refer Oracle report placeholders--
44 
45  Function C_company_name_header_p return varchar2 is
46 	Begin
47 	 return C_company_name_header;
48 	 END;
49 END PA_PAXRWPCR_XMLP_PKG ;
50