PACKAGE BODY: APPS.PO_POXSURQC_XMLP_PKG

Source

1 PACKAGE BODY PO_POXSURQC_XMLP_PKG AS
2 /* $Header: POXSURQCB.pls 120.1 2007/12/25 12:32:48 krreddy noship $ */
3 
4 function orderby_clauseFormula return VARCHAR2 is
5 begin
6 
7 if    P_orderby = 'CODE' then
8       return('pqc.code');
9 elsif P_orderby = 'RANKING' then
10       return('pqc.ranking');
11 end if;
12 RETURN 'pqc.code'; end;
13 
14 function BeforeReport return boolean is
15 begin
16 
17 declare
18 l_active_inactive    po_lookup_codes.displayed_field%type ;
19 l_sort     po_lookup_codes.displayed_field%type ;
20 begin
21 
22 /*SRW.USER_EXIT('FND SRWINIT');*/null;
23 
24 
25 if P_active_inactive is not null then
26 
27     select displayed_field
28     into l_active_inactive
29     from po_lookup_codes
30     where lookup_code = P_active_inactive
31     and lookup_type = 'ACTIVE_INACTIVE';
32 
33     P_active_inactive_disp := l_active_inactive ;
34 
35 else
36 
37     P_active_inactive_disp := '' ;
38 
39 end if;
40 
41 if P_orderby is not null then
42 
43     select displayed_field
44     into l_sort
45     from po_lookup_codes
46     where lookup_code = P_orderby
47     and lookup_type = 'SRS ORDER BY';
48 
49     P_orderby_displayed := l_sort ;
50 
51 else
52 
53     P_orderby_displayed := '' ;
54 
55 end if;
56 
57 end;
58   return (TRUE);
59 end;
60 
61 function AfterReport return boolean is
62 begin
63   /*SRW.USER_EXIT('FND SRWEXIT');*/null;
64 
65   return (TRUE);
66 end;
67 
68 --Functions to refer Oracle report placeholders--
69 
70 END PO_POXSURQC_XMLP_PKG ;
71