[Home] [Help]
PACKAGE: APPS.PO_POXPOVPS_XMLP_PKG
Source
1 PACKAGE PO_POXPOVPS_XMLP_PKG AS
2 /* $Header: POXPOVPSS.pls 120.2 2008/01/05 15:57:33 dwkrishn noship $ */
3 P_title varchar2(50);
4 P_CONC_REQUEST_ID number;
5 P_CREATION_DATE_FROM date;
6 P_CREATION_DATE_FROM_LP varchar2(40);
7 P_CREATION_DATE_TO date;
8 P_CREATION_DATE_TO_LP varchar2(40);
9 P_VENDOR_TYPE varchar2(40);
10 P_SMALL_BUSINESS varchar2(1);
11 P_MINORITY_OWNED varchar2(40);
12 P_WOMEN_OWNED varchar2(1);
13 P_ORDERBY varchar2(40);
14 P_SMALL_BUSINESS_FLAG varchar2(40);
15 P_BASE_CURRENCY varchar2(40);
16 P_orderby_displayed varchar2(80);
17 LP_orderby_displayed varchar2(80);
18 P_small_business_disp varchar2(80);
19 P_WOMEN_OWNED_DISP varchar2(80);
20 P_minority_owned_disp varchar2(80);
21 C_amount_func_vendor_round number;
22 C_amount_rep_round number;
23 C_amount_func_site_round number;
24 C_amount_func_po_type_round number;
25 C_amount_po_round number;
26 C_amount_functional_round number;
27 C_AMOUNT_WO_ROUND number;
28 C_AMOUNT_SB_ROUND number;
29 C_AMOUNT_MO_ROUND number;
30 function BeforeReport return boolean ;
31 function orderby_clauseFormula return VARCHAR2 ;
32 function get_percent_wo(PO_CNT_WO in varchar2, Report_PO_Count in number) return number ;
33 function get_percent_mo(PO_CNT_MO in varchar2, Report_PO_Count in number) return number ;
34 function get_percent_sb(PO_CNT_SB in varchar2, Report_PO_Count in number) return number ;
35 function AfterReport return boolean ;
36 Function C_amount_func_vendor_round_p return number;
37 Function C_amount_rep_round_p return number;
38 Function C_amount_func_site_round_p return number;
39 Function C_amount_func_po_type_round_p return number;
40 Function C_amount_po_round_p return number;
41 Function C_amount_functional_round_p return number;
42 Function C_AMOUNT_WO_ROUND_p return number;
43 Function C_AMOUNT_SB_ROUND_p return number;
44 Function C_AMOUNT_MO_ROUND_p return number;
45 END PO_POXPOVPS_XMLP_PKG;
46