PACKAGE: APPS.INV_INVPRFDH_XMLP_PKG

Source

1 PACKAGE INV_INVPRFDH_XMLP_PKG AS
2 /* $Header: INVPRFDHS.pls 120.1 2007/12/25 10:47:21 dwkrishn noship $ */
3   P_ORG VARCHAR2(40);
4 
5   P_SORT_ID NUMBER;
6 
7   P_ITEM_WHERE VARCHAR2(960);
8 
9   P_CAT_SET VARCHAR2(40);
10 
11   P_ITEM_LO VARCHAR2(240);
12 
13   P_ITEM_HI VARCHAR2(240);
14 
15   P_CAT_LO VARCHAR2(240);
16 
17   P_CAT_HI VARCHAR2(240);
18 
19   P_CAT_WHERE VARCHAR2(960);
20 
21   P_ITEM_FLEXNUM VARCHAR2(15);
22 
23   P_ITEM_FLEXDAT VARCHAR2(800);
24 
25   P_CAT_FLEXDAT VARCHAR2(800);
26 
27   P_PERIOD_TYPE VARCHAR2(40);
28 
29   P_START_DATE DATE;
30 
31   LP_START_DATE varchar2(15);
32 
33   P_CONC_REQUEST_ID NUMBER := 0;
34 
35   P_CAT_FLEXNUM VARCHAR2(32767);
36 
37   P_ITEM_FLEXORD VARCHAR2(1444);
38 
39   P_TRACE_FLAG NUMBER;
40 
41   P_CBO_FLAG NUMBER;
42 
43   P_QTY_PRECISION NUMBER;
44 
45   FUNCTION WHERE_CAT(P_CAT_WHERE varchar2) RETURN VARCHAR2;
46 
47   FUNCTION BEFOREREPORT RETURN BOOLEAN;
48 
49   FUNCTION AFTERREPORT RETURN BOOLEAN;
50 
51   FUNCTION C_ITEM_LO_NICEFORMULA RETURN VARCHAR2;
52 
53   FUNCTION C_ITEM_HI_NICEFORMULA RETURN VARCHAR2;
54 
55   FUNCTION C_CAT_LO_NICEFORMULA RETURN VARCHAR2;
56 
57   FUNCTION C_CAT_HI_NICEFORMULA RETURN VARCHAR2;
58 
59   FUNCTION BEFOREPFORM RETURN BOOLEAN;
60 
61   FUNCTION F_TOTALFORMULA(SALES_ORDERS IN NUMBER
62                          ,INTERORG_ISSUES IN NUMBER
63                          ,WIP_ISSUES IN NUMBER
64                          ,MISCELLANEOUS_ISSUES IN NUMBER) RETURN NUMBER;
65 
66 END INV_INVPRFDH_XMLP_PKG;
67