1 PACKAGE GME_GMEBCHYV_XMLP_PKG 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