PACKAGE: APPS.GMI_ICR04_XMLP_PKG

Source

1 PACKAGE GMI_ICR04_XMLP_PKG AS
2 /* $Header: ICR04S.pls 120.0 2007/12/24 13:17:30 nchinnam noship $ */
3   FISCAL_YEAR VARCHAR2(4);
4 
5   COST_METHOD VARCHAR2(4);
6 
7   FROM_ITEM VARCHAR2(32);
8 
9   TO_ITEM VARCHAR2(32);
10 
11   FROM_WHSE VARCHAR2(4);
12 
13   TO_WHSE VARCHAR2(4);
14 
15   FROM_DATE DATE;
16 
17   TO_DATE DATE;
18 
19   P_ORGN VARCHAR2(4);
20 
21   NONBLOCKSQL VARCHAR2(3);
22 
23   P_CONC_REQUEST_ID NUMBER;
24 
25   DOC_TYPE_INCP VARCHAR2(4) := 'NONE';
26 
27   REASON_CODE_INCP VARCHAR2(4) := 'NONE';
28 
29   QUANTITY_INCP NUMBER := 0.00;
30 
31   DOC_TYPE_OUTCP VARCHAR2(4) := 'NONE';
32 
33   REASON_CODE_OUTCP VARCHAR2(4) := 'NONE';
34 
35   QUANTITY_OUTCP NUMBER := 0.00;
36 
37   FUNCTION YTD_USAGECFFORMULA(DOC_TYPE_1 IN VARCHAR2
38                              ,REASON_CODE_1 IN VARCHAR2
39                              ,ITEM_ID_1 IN NUMBER
40                              ,WHSE_CODE_1 IN VARCHAR2) RETURN NUMBER;
41 function R_Daily_Item_Usage(doc_type_1 varchar2,reason_code_1 varchar2) return varchar2;
42 function F_Doc_Type_InCP(doc_type_1 varchar2,reason_code_1 varchar2,line_id_1 number,doc_id_1 number,quantity_1 number)return varchar2;
43 function F_Doc_Type_OutCP(doc_type_1 varchar2,reason_code_1 varchar2,line_id_1 number,doc_id_1 number,quantity_1 number) return varchar2;
44   FUNCTION ACT_USAGEFORMULA(DOC_TYPE_1 IN VARCHAR2
45                            ,REASON_CODE_1 IN VARCHAR2
46                            ,ITEM_ID_1 IN NUMBER
47                            ,WHSE_CODE_1 IN VARCHAR2) RETURN NUMBER;
48 
49   FUNCTION YTD_VALUECFFORMULA RETURN NUMBER;
50 
51   FUNCTION BEFOREREPORT RETURN BOOLEAN;
52 
53   PROCEDURE HEADER;
54 
55   FUNCTION AFTERREPORT RETURN BOOLEAN;
56 
57   FUNCTION DOC_TYPE_INCP_P RETURN VARCHAR2;
58 
59   FUNCTION REASON_CODE_INCP_P RETURN VARCHAR2;
60 
61   FUNCTION QUANTITY_INCP_P RETURN NUMBER;
62 
63   FUNCTION DOC_TYPE_OUTCP_P RETURN VARCHAR2;
64 
65   FUNCTION REASON_CODE_OUTCP_P RETURN VARCHAR2;
66 
67   FUNCTION QUANTITY_OUTCP_P RETURN NUMBER;
68 
69 END GMI_ICR04_XMLP_PKG;
70