PACKAGE: APPS.PO_POXRQSDD_XMLP_PKG

Source

1 PACKAGE PO_POXRQSDD_XMLP_PKG AS
2 /* $Header: POXRQSDDS.pls 120.2 2007/12/25 11:58:08 krreddy noship $ */
3 	P_title	varchar2(50);
4 	P_CONC_REQUEST_ID	number;
5 	P_FLEX_ITEM	varchar2(800);
6 	P_REQ_NUMBER_FROM	varchar2(40);
7 	P_REQ_NUMBER_TO	varchar2(40);
8 	P_CREATION_DATE_FROM	varchar2(40);
9 	P_CREATION_DATE_TO	varchar2(40);
10 	P_REQUESTOR	varchar2(40);
11 	P_qty_precision	varchar2(40);
12     QTY_PRECISION varchar2(100);
13      FORMAT_MASK VARCHAR2(100);
14 	P_ORDERBY	varchar2(40);
15 	P_OE_STATUS	varchar2(1);
16 	P_ORDERBY_DISPLAYED	varchar2(80);
17 	P_SINGLE_PO_PRINT	number;
18 	P_REQ_NUM_TYPE	varchar2(32767);
19 	P_WHERE_QUERY	varchar2(2000);
20 	C_quantity_shipped	number;
21 	C_Quantity_Variance	number;
22 	C_Cost_variance	number;
23 	function BeforeReport return boolean  ;
24 	procedure get_precision  ;
25 	function orderby_clauseFormula return VARCHAR2  ;
26 	function C_shipped_qtyFormula return VARCHAR2  ;
27 	function C_selling_priceFormula return VARCHAR2  ;
28 	function C_fromFormula return VARCHAR2  ;
29 	function C_whereFormula return VARCHAR2  ;
30 	function c_get_shipped_quantity (Quantity_delivered in number, unit_price in number, Line in number, Req_number in varchar2, p_Order_Source_id in number) return number  ;
31 	function get_shipped_quantity(orig_line_num in varchar2,orig_header_num varchar2,psp_order_source_id number) return number   ;
32 	function AfterPForm return boolean  ;
33 	function AfterReport return boolean  ;
34 	Function C_quantity_shipped_p return number;
35 	Function C_Quantity_Variance_p return number;
36 	Function C_Cost_variance_p return number;
37 END PO_POXRQSDD_XMLP_PKG;
38