PACKAGE BODY: APPS.PO_POXREQAC_XMLP_PKG

Source

1 PACKAGE BODY PO_POXREQAC_XMLP_PKG AS
2 /* $Header: POXREQACB.pls 120.1 2007/12/25 11:39:47 krreddy noship $ */
3 
4 USER_EXIT_FAILURE EXCEPTION;
5 
6 function BeforeReport return boolean is
7 begin
8 
9 DECLARE
10    l_req_type     po_lookup_codes.displayed_field%type;
11 BEGIN
12   /*SRW.USER_EXIT('FND SRWINIT');*/null;
13 
14 
15   IF P_TYPE is NOT NULL THEN
16 
17     SELECT displayed_field
18     INTO l_req_type
19     FROM po_lookup_codes
20     WHERE lookup_code = P_TYPE
21     AND lookup_type = 'REQUISITION TYPE';
22 
23     P_TYPE_DISPLAYED := l_req_type;
24 
25   ELSE
26 
27     P_TYPE_DISPLAYED := '';
28 
29   END IF;
30   LP_CREATION_DATE_FROM:=to_char(P_CREATION_DATE_FROM,'DD-MON-YY');
31   LP_CREATION_DATE_TO:=to_char(P_CREATION_DATE_TO,'DD-MON-YY');
32   RETURN TRUE;
33 
34 END;
35 
36 return (TRUE);
37 end;
38 
39 function AfterReport return boolean is
40 begin
41 
42 /*SRW.USER_EXIT('FND SRWEXIT');*/null;
43    return (TRUE);
44 end;
45 
46 function round_amount_req(c_amount_req in number, c_currency_precision in number) return number is
47 begin
48 
49   /*srw.reference(c_amount_req);*/null;
50 
51   /*srw.reference(c_currency_precision);*/null;
52 
53 
54   return(round(c_amount_req, c_currency_precision));
55 end;
56 
57 function round_amount_sum_req(c_amount_sum_req in number, c_currency_precision in number) return number is
58 begin
59 
60   /*srw.reference(c_amount_sum_req);*/null;
61 
62   /*srw.reference(c_currency_precision);*/null;
63 
64 
65   return(round(c_amount_sum_req, c_currency_precision));
66 end;
67 
68 function round_amount_report(c_amount_report in number, c_curr_precision in number) return number is
69 begin
70 
71   /*srw.reference(c_amount_report);*/null;
72 
73   /*srw.reference(c_curr_precision);*/null;
74 
75 
76   return(round(c_amount_report, c_curr_precision));
77 end;
78 
79 --Functions to refer Oracle report placeholders--
80 
81 END PO_POXREQAC_XMLP_PKG ;
82