DBA Data[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