DBA Data[Home] [Help]

PACKAGE: APPS.INV_INVIRSIQ_XMLP_PKG

Source


1 PACKAGE INV_INVIRSIQ_XMLP_PKG AS
2 /* $Header: INVIRSIQS.pls 120.1 2007/12/25 10:32:34 dwkrishn noship $ */
3   P_CONC_REQUEST_ID NUMBER := 0;
4   qty_precision VARCHAR2(15000);
5   P_STRUCT_NUM VARCHAR2(1500);
6 
7   P_ITEM_FLEXDATA VARCHAR2(300);
8 
9   P_ITEM_WHERE VARCHAR2(600);
10 
11   P_ITEM_ORDER_BY VARCHAR2(800);
12 
13   P_ITEM_LO VARCHAR2(820);
14 
15   P_ITEM_HI VARCHAR2(820);
16 
17   P_QTY_PRECISION NUMBER;
18 
19   P_TRACE_FLAG NUMBER;
20 
21   P_OPTIMIZER_CODE NUMBER;
22 
23   P_ORGANIZATION_ID VARCHAR2(40);
24 
25   P_SUBINV_LO VARCHAR2(10);
26 
27   P_SUBINV_HI VARCHAR2(10);
28 
29   P_LOC_FLEXDATA VARCHAR2(2600);
30 
31   FUNCTION P_STRUCT_NUMVALIDTRIGGER RETURN BOOLEAN;
32 
33   FUNCTION BEFOREREPORT RETURN BOOLEAN;
34 
35   FUNCTION AFTERREPORT RETURN BOOLEAN;
36 
37   FUNCTION AFTERPFORM RETURN BOOLEAN;
38 
39   FUNCTION WHERE_SUBINV RETURN VARCHAR2;
40 
41   FUNCTION CF_ROUNDEDQTYFORMULA(C_SUM_ITEM_QTY IN NUMBER) RETURN NUMBER;
42 
43 END INV_INVIRSIQ_XMLP_PKG;
44