PACKAGE: APPS.PO_POXPRIPR_XMLP_PKG

Source

1 PACKAGE PO_POXPRIPR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: POXPRIPRS.pls 120.3 2008/01/22 07:44:46 dwkrishn noship $ */
3 	P_title	varchar2(50);
4 	P_FLEX_ITEM	varchar2(800);
5 	P_CONC_REQUEST_ID	number;
6 	P_FLEX_CAT	varchar2(31000);
7 	P_PERIOD_FROM	varchar2(40);
8 	P_PERIOD_TO	varchar2(40);
9 	P_CREATION_DATE_FROM	varchar2(40);
10 	P_CREATION_DATE_TO	varchar2(40);
11 	P_qty_precision	varchar2(40);
12   QTY_PRECISION varchar2(100);
13 	P_VENDOR_FROM	varchar2(240);
14 	P_VENDOR_TO	varchar2(240);
15 	P_CATEGORY_FROM	varchar2(900);
16 	P_CATEGORY_TO	varchar2(900);
17 	P_ITEM_FROM	varchar2(900);
18 	P_ITEM_TO	varchar2(900);
19 	P_WHERE_CAT	varchar2(2000) := '1=1' ;
20 	P_WHERE_ITEM	varchar2(2000) := '1=1' ;
21 	P_STRUCT_NUM	varchar2(15);
22 	P_STRUCT_NUM1	varchar2(15);
23 	P_ORDERBY_ITEM	varchar2(298);
24 	P_ORDERBY_CAT	varchar2(298);
25 	P_ORDERBY	varchar2(40);
26 	P_BASE_CURRENCY	varchar2(32767);
27 	P_ITEM_STRUCT_NUM	varchar2(32767);
28 	P_orderby_displayed	varchar2(80);
29 	LP_orderby_displayed	varchar2(80);
30 	P_ORDERBY_CLAUSE	varchar2(32767) := 'MCA.SEGMENT1';
31 	LP_orderby_clause	varchar2(32767) := 'MCA.SEGMENT1';
32 	P_PERIOD_START_DATE	date;
33 	P_PERIOD_END_DATE	date;
34 	PERIOD_WHERE	varchar2(1000) := '1=1';
35 	function BeforeReport return boolean  ;
36 	function AfterReport return boolean  ;
37 	function ipvformula(Average_Purchase in number, Average_Invoice in number) return number  ;
38 	procedure get_precision  ;
39 	function orderby_clauseFormula return VARCHAR2  ;
40 	function get_p_struct_num return boolean  ;
41 	function item_average_purchase_roundfor(item_average_purchase in number, c_fnd_precision in number) return number  ;
42 	function item_average_invoice_roundform(item_average_invoice in number, c_fnd_precision in number) return number  ;
43 	function AfterPForm return boolean  ;
44 	function average_purchase_roundformula(AVERAGE_PURCHASE in number, c_fnd_precision in number) return number  ;
45 	function c_amount_roundformula(C_AMOUNT in number, c_fnd_precision in number) return number  ;
46 	function average_invoice_roundformula(AVERAGE_INVOICE in number, c_fnd_precision in number) return number  ;
47 	function c_amount_tot_roundformula(C_AMOUNT_TOT in number, c_fnd_precision in number) return number  ;
48 	function rateformula(Unit_Of_measure in varchar2, Unit in varchar2, Item_id in number) return number  ;
49 	function po_primary_qtyformula(PO_Quantity in number, conv_Rate in number) return number  ;
50 	function ap_primary_qtyformula(AP_Quantity in number, conv_Rate in number) return number  ;
51 	function average_invoiceformula(Q_Invoiced in number, Total_amount_Invoiced in number) return number  ;
52 	function average_purchaseformula(C_amount in number, Q_Purchased in number) return number  ;
53 END PO_POXPRIPR_XMLP_PKG;
54