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