1 PACKAGE GMO_DISP_CON_PKG AUTHID CURRENT_USER AS
2 /*$Header: GMOVDCPS.pls 120.1 2006/02/16 13:23 srpuri noship $*/
3
4 --This PL/SQL procedure is called through a concurrent program to generate the Dispense History XML.
5 PROCEDURE GENERATE_DISPHIST_XML(ERRBUF OUT NOCOPY VARCHAR2,
6 RETCODE OUT NOCOPY VARCHAR2,
7 Plant IN NUMBER,
8 SubInventory IN VARCHAR2,
9 Batch IN NUMBER,
10 FromDate IN VARCHAR2,
11 ToDate IN VARCHAR2,
12 OperatorID IN VARCHAR2);
13
14
15 --This PL/SQL procedure is called through a concurrent program to generate the Dispense Dispatch XML.
16 PROCEDURE GENERATE_DISPDPCH_XML(ERRBUF OUT NOCOPY VARCHAR2,
17 RETCODE OUT NOCOPY VARCHAR2,
18 Plant IN NUMBER,
19 SubInventory IN VARCHAR2,
20 Batch IN NUMBER,
21 FromDate IN VARCHAR2,
22 ToDate IN VARCHAR2);
23 FUNCTION GET_HAZARD_CLASS_NAME(P_INVENTORY_ITEM_ID NUMBER,
24 P_ORGANIZATION_ID NUMBER)
25 RETURN VARCHAR2;
26
27 END GMO_DISP_CON_PKG;