PACKAGE: APPS.GME_GMEMUSBV_XMLP_PKG

Source

1 PACKAGE GME_GMEMUSBV_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: GMEMUSBVS.pls 120.0 2007/12/24 12:47:06 nchinnam noship $ */
3   P_CODE VARCHAR2(40);
4 
5   FROMBATCH VARCHAR2(50);
6 
7   TOBATCH VARCHAR2(50);
8 
9   FROMDATE DATE;
10 
11   TODATE DATE;
12 
13   FROMITEM VARCHAR2(50);
14 
15   TOITEM VARCHAR2(50);
16 
17   CURR_CODE VARCHAR2(4);
18 
19   NONBLOCKSQL VARCHAR2(5);
20 
21   P_CONC_REQUEST_ID NUMBER := 0;
22 
23   P_ORG_ID NUMBER;
24 
25   CP_ITEM_COST NUMBER;
26 
27   CP_BATCHRANGE VARCHAR2(250) := ' ';
28 
29   CP_DATERANGE VARCHAR2(255);
30 
31   CP_ITEMRANGE VARCHAR2(255) := ' ';
32 
33   FUNCTION CF_ACCTG_COST(DITEMID IN NUMBER
34                         ,ACTUAL_CMPLT_DATE IN DATE) RETURN NUMBER;
35 
36   FUNCTION CF_ACCTG_COST2FORMULA(TRANS_QTY IN NUMBER) RETURN NUMBER;
37 
38   FUNCTION CF_QUANTITY_VARIANCE(CF_ACTL_QTY_ITEMUM IN NUMBER
39                                ,TRANS_QTY IN NUMBER) RETURN NUMBER;
40 
41   FUNCTION CF_VALUE_VARIANCE(BATCHUM IN VARCHAR2
42                             ,ITEM_UM IN VARCHAR2
43                             ,DITEMID IN NUMBER
44                             ,CF_QUANTITY_VARIANCE IN NUMBER
45                             ,CF_ACCTG_COST IN NUMBER) RETURN NUMBER;
46 
47   FUNCTION CF_VARIANCE_PCT(TRANS_QTY IN NUMBER
48                           ,CF_QUANTITY_VARIANCE IN NUMBER) RETURN NUMBER;
49 
50   FUNCTION CF_BATCHRANGEFORMULA RETURN VARCHAR2;
51 
52   FUNCTION CF_DATERANGEFORMULA RETURN VARCHAR2;
53 
54   FUNCTION CF_ITEM_RANGE RETURN VARCHAR2;
55 
56   FUNCTION CF_WIPCODE RETURN VARCHAR2;
57 
58   FUNCTION G_MAINGROUPFILTER RETURN BOOLEAN;
59 
60   FUNCTION CF_ACTL_QTY_ITEMUMFORMULA(BATCHUM IN VARCHAR2
61                                     ,FORMUM IN VARCHAR2
62                                     ,AQTY IN NUMBER
63                                     ,DITEMID IN NUMBER) RETURN NUMBER;
64 
65   FUNCTION CF_BATCH_SIZEFORMULA(RECIPE_VALIDITY_RULE_ID IN NUMBER
66                                ,BATCH_ID IN NUMBER) RETURN NUMBER;
67 
68   FUNCTION CF_ITEMUMFORMULA(RECIPE_VALIDITY_RULE_ID IN NUMBER
69                            ,BATCH_ID IN NUMBER) RETURN VARCHAR2;
70 
71   FUNCTION TRANS_QTYFORMULA_005(FORMULALINE_ID IN NUMBER
72                                ,RECIPE_VALIDITY_RULE_ID IN NUMBER
73                                ,FORMULA_ID IN NUMBER
74                                ,BATCH_ID IN NUMBER) RETURN NUMBER;
75 
76   FUNCTION BEFOREREPORT RETURN BOOLEAN;
77 
78   FUNCTION CF_U_VALUE_VARIANCEFORMULA(CF_ACTL_QTY_ITEMUM IN NUMBER
79                                      ,TRANS_QTY IN NUMBER
80                                      ,CF_VALUE_VARIANCE IN NUMBER) RETURN NUMBER;
81 
82   FUNCTION CF_S_VALUE_VARIANCEFORMULA(CF_ACTL_QTY_ITEMUM IN NUMBER
83                                      ,TRANS_QTY IN NUMBER
84                                      ,CF_VALUE_VARIANCE IN NUMBER) RETURN NUMBER;
85 
86   FUNCTION CF_TOTAL_VARIANCEFORMULA(CS_TOT_U_VALUE_VARIANCE IN NUMBER
87                                    ,CS_TOT_S_VALUE_VARIANCE IN NUMBER) RETURN NUMBER;
88 
89   FUNCTION AFTERREPORT RETURN BOOLEAN;
90 
91   FUNCTION CF_DELETE_TRANSFORMULA RETURN NUMBER;
92 
93   PROCEDURE HEADER;
94 
95   FUNCTION CF_UOMFORMULA(FORMUM IN VARCHAR2
96                         ,BATCHUM IN VARCHAR2) RETURN CHAR;
97 
98   FUNCTION CF_CONTEXT_ORGFORMULA RETURN CHAR;
99 
100   FUNCTION CP_ITEM_COST_P RETURN NUMBER;
101 
102   FUNCTION CP_BATCHRANGE_P RETURN VARCHAR2;
103 
104   FUNCTION CP_DATERANGE_P RETURN VARCHAR2;
105 
106   FUNCTION CP_ITEMRANGE_P RETURN VARCHAR2;
107 
108 END GME_GMEMUSBV_XMLP_PKG;
109 
110