PACKAGE: APPS.PO_POXRQSIN_XMLP_PKG

Source

1 PACKAGE PO_POXRQSIN_XMLP_PKG AS
2 /* $Header: POXRQSINS.pls 120.2 2007/12/25 11:59:40 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	date;
9 	P_CREATION_DATE_TO	date;
10 	P_CREATION_DATE_FROM1	varchar2(10);
11 	P_CREATION_DATE_TO1	varchar2(10);
12 	P_REQUESTOR	varchar2(40);
13 	P_SUBINVENTORY_TO	varchar2(40);
14 	P_SUBINVENTORY_FROM	varchar2(40);
15 	P_WHERE_ITEM	varchar2(2000);
16 	P_STRUCT_NUM	varchar2(15);
17 	P_item_from	varchar2(900);
18 	P_item_to	varchar2(900);
19 	P_QTY_PRECISION	number;
20 	P_STATUS	varchar2(40);
21 	P_orderby	varchar2(13);
22 	P_status_displayed	varchar2(80);
23 	P_orderby_displayed	varchar2(80);
24 	P_OE_STATUS	varchar2(1);
25 	P_SINGLE_PO_PRINT	number;
26 	P_REQ_NUM_TYPE	varchar2(32767);
27 	P_WHERE_QUERY	varchar2(2000);
28         FORMAT_MASK     varchar2(50);
29 	function BeforeReport return boolean  ;
30 	function AfterReport return boolean  ;
31 	procedure get_precision  ;
32 	function orderby_clauseFormula return VARCHAR2  ;
33 	function get_p_struct_num return boolean  ;
34 	function C_backorderedFormula return VARCHAR2  ;
35 	function C_fromFormula return VARCHAR2  ;
36 	function C_whereFormula return VARCHAR2  ;
37 	function C_interface_whereFormula return VARCHAR2  ;
38 	function C_requiredFormula return VARCHAR2  ;
39 	function c_ship_amountformula(required in number, unit_price in number) return number  ;
40 	function C_ship_qtyFormula return VARCHAR2  ;
41 	function P_WHERE_ITEMValidTrigger return boolean  ;
42 	function AfterPForm return boolean  ;
43 END PO_POXRQSIN_XMLP_PKG;
44