PACKAGE: APPS.GME_GMEBCHYV_XMLP_PKG

Source

1 PACKAGE GME_GMEBCHYV_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: GMEBCHYVS.pls 120.0 2007/12/24 12:44:54 nchinnam noship $ */
3   P_CODE VARCHAR2(4);
4 
5   FROMBATCH VARCHAR2(32);
6 
7   TOBATCH VARCHAR2(32);
8 
9   FROMDATE DATE;
10 
11   TODATE DATE;
12 
13   FROMITEM VARCHAR2(32);
14 
15   TOITEM VARCHAR2(32);
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   BATCHUM VARCHAR2(4);
26 
27   CP_ITEM_COST NUMBER;
28 
29   CP_BATCHRANGE VARCHAR2(250);
30 
31   CP_DATERANGE VARCHAR2(255);
32 
33   CP_ITEMRANGE VARCHAR2(255);
34 
35   FUNCTION CF_ACCTG_COST2FORMULA(CF_UOM IN VARCHAR2
36                                 ,ITEMUM IN VARCHAR2
37                                 ,DITEMID IN NUMBER
38                                 ,CF_ACTUAL_QTY_UM IN NUMBER) RETURN NUMBER;
39 
40   FUNCTION CF_QUANTITY_VARIANCE(CF_ACTUAL_QTY_UM IN NUMBER
41                                ,CF_PLAN_QTY_ITEMUM IN NUMBER) RETURN NUMBER;
42 
43   FUNCTION CF_VALUE_VARIANCE(CF_ACCTG_COST2 IN NUMBER
44                             ,CF_ACCTNG_COST1 IN NUMBER) RETURN NUMBER;
45 
46   FUNCTION CF_VARIANCE_PCT(CF_PLAN_QTY_ITEMUM IN NUMBER
47                           ,CF_QUANTITY_VARIANCE IN NUMBER) RETURN NUMBER;
48 
49   FUNCTION CF_FORMULA_QTY(RECIPE_VALIDITY_RULE_ID IN NUMBER
50                          ,BATCH_ID IN NUMBER) RETURN NUMBER;
51 
52   FUNCTION CF_BATCHRANGEFORMULA RETURN VARCHAR2;
53 
54   FUNCTION CF_DATERANGEFORMULA RETURN VARCHAR2;
55 
56   FUNCTION CF_ITEM_RANGE RETURN VARCHAR2;
57 
58   FUNCTION CF_PLAN_QTY_ITEMUMFORMULA(FORMULALINE_ID IN NUMBER
59                                     ,RECIPE_VALIDITY_RULE_ID IN NUMBER
60                                     ,FORMULA_ID IN NUMBER
61                                     ,BATCH_ID IN NUMBER) RETURN NUMBER;
62 
63   FUNCTION CF_ACTUAL_QTY_UMFORMULA(MD_BATCHUM IN VARCHAR2
64                                   ,MD_FORMUM IN VARCHAR2
65                                   ,AQTY IN NUMBER
66                                   ,ITEM_ID IN NUMBER) RETURN NUMBER;
67 
68   FUNCTION BEFOREREPORT RETURN BOOLEAN;
69 
70   FUNCTION CF_ACCTNG_COST1FORMULA(DITEMID IN NUMBER
71                                  ,ACTUAL_CMPLT_DATE IN DATE
72                                  ,CF_UOM IN VARCHAR2
73                                  ,ITEMUM IN VARCHAR2
74                                  ,CF_PLAN_QTY_ITEMUM IN NUMBER) RETURN NUMBER;
75 
76   FUNCTION CF_DELETE_TRANSFORMULA RETURN NUMBER;
77 
78   FUNCTION AFTERREPORT RETURN BOOLEAN;
79 
80   PROCEDURE HEADER;
81 
82   FUNCTION CF_UOMFORMULA(MD_FORMUM IN VARCHAR2
83                         ,MD_BATCHUM IN VARCHAR2) RETURN CHAR;
84 
85   FUNCTION CF_CONTEXT_ORGFORMULA RETURN VARCHAR2;
86 
87   FUNCTION BATCHUM_P RETURN VARCHAR2;
88 
89   FUNCTION CP_ITEM_COST_P RETURN NUMBER;
90 
91   FUNCTION CP_BATCHRANGE_P RETURN VARCHAR2;
92 
93   FUNCTION CP_DATERANGE_P RETURN VARCHAR2;
94 
95   FUNCTION CP_ITEMRANGE_P RETURN VARCHAR2;
96 
97 END GME_GMEBCHYV_XMLP_PKG;
98 
99