PACKAGE: APPS.GME_GMEBCHPL_XMLP_PKG

Source

1 PACKAGE GME_GMEBCHPL_XMLP_PKG AS
2 /* $Header: GMEBCHPLS.pls 120.1 2007/12/24 12:43:09 nchinnam noship $ */
3   P_CODE VARCHAR2(6);
4 
5   FROMBATCH VARCHAR2(40);
6 
7   TOBATCH VARCHAR2(40);
8 
9   FROMWHSE VARCHAR2(32767);
10 
11   TOWHSE VARCHAR2(32767);
12 
13   FROMDATE DATE;
14 
15   TODATE DATE;
16 
17   C_FROMDATE VARCHAR2(20);
18 
19   C_TODATE VARCHAR2(20);
20 
21   SORTBY VARCHAR2(80);
22 
23   SY_MIN_DATE VARCHAR2(40);
24 
25   NONBLOCKSQL VARCHAR2(5);
26 
27   P_CONC_REQUEST_ID NUMBER := 0;
28 
29   P_ORG_ID NUMBER;
30 
31   CP_BATCHRANGE VARCHAR2(255);
32 
33   CP_WHSERANGE VARCHAR2(255);
34 
35   CP_DATERANGE VARCHAR2(255);
36 
37   CP_SORTBY VARCHAR2(255):='  ';
38 
39   FUNCTION CF_TRANS_QTYFORMULA(TRANS_QTY IN NUMBER) RETURN NUMBER;
40 
41   FUNCTION CF_SUM_TRANS_QTYFORMULA(SUM_TRANS_QTY IN NUMBER) RETURN NUMBER;
42 
43   FUNCTION CF_SUM_TRANS_QTY2FORMULA(SUM_TRANS_QTY2 IN NUMBER) RETURN NUMBER;
44 
45   FUNCTION CF_BATCHRANGEFORMULA RETURN VARCHAR2;
46 
47   FUNCTION CF_WHSERANGEFORMULA RETURN VARCHAR2;
48 
49   FUNCTION CF_DATERANGEFORMULA RETURN VARCHAR2;
50 
51   FUNCTION CF_SORTBYFORMULA RETURN VARCHAR2;
52 
53   FUNCTION CF_TRANS_QTY2FORMULA(TRANS_QTY2 IN NUMBER) RETURN NUMBER;
54 
55   FUNCTION AFTERPFORM RETURN BOOLEAN;
56 
57   FUNCTION SORTRETCFFORMULA RETURN VARCHAR2;
58 
59   FUNCTION CF_ACTUAL_START_DATEFORMULA(ACTUAL_START_DATE IN DATE) RETURN DATE;
60 
61   FUNCTION BEFOREREPORT RETURN BOOLEAN;
62 
63   PROCEDURE HEADER;
64 
65   FUNCTION CF_PLAN_QTY2FORMULA(ITEM_UM IN VARCHAR2
66                               ,ITEM_UM2 IN VARCHAR2
67                               ,ITEM_ID IN NUMBER
68                               ,PLAN_QTY2 IN NUMBER) RETURN NUMBER;
69 
70   FUNCTION AFTERREPORT RETURN BOOLEAN;
71 
72   FUNCTION CF_CONTEXTORGFORMULA RETURN CHAR;
73 
74   FUNCTION CF_INV_PLAN_QTYFORMULA(ITEM_UM IN VARCHAR2
75                                  ,ITEM_UM4 IN VARCHAR2
76                                  ,ITEM_ID IN NUMBER
77                                  ,PLAN_QTY2 IN NUMBER) RETURN NUMBER;
78 
79   FUNCTION CP_BATCHRANGE_P RETURN VARCHAR2;
80 
81   FUNCTION CP_WHSERANGE_P RETURN VARCHAR2;
82 
83   FUNCTION CP_DATERANGE_P RETURN VARCHAR2;
84 
85   FUNCTION CP_SORTBY_P RETURN VARCHAR2;
86 
87 END GME_GMEBCHPL_XMLP_PKG;
88