[Home] [Help]
PACKAGE: APPS.PO_POXPRIPR_XMLP_PKG
Source
1 PACKAGE PO_POXPRIPR_XMLP_PKG 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