DBA Data[Home] [Help]

PACKAGE: APPS.GME_ERES_PKG

Source


1 Package GME_ERES_PKG AUTHID CURRENT_USER AS
2 /* $Header: GMEVERSS.pls 120.1 2005/09/23 12:15 srpuri noship $ */
3 
4 
5    PROCEDURE INSERT_EVENT(P_EVENT_NAME VARCHAR2,
6                           P_EVENT_KEY VARCHAR2,
7                           P_USER_KEY_LABEL VARCHAR2,
8                           P_USER_KEY_VALUE VARCHAR2,
9                           P_POST_OP_API VARCHAR2,
10                           P_PARENT_EVENT VARCHAR2,
11                           P_PARENT_EVENT_KEY VARCHAR2,
12                           P_PARENT_ERECORD_ID NUMBER,
13                           X_STATUS  OUT  NOCOPY VARCHAR2);
14 
15 
16   FUNCTION GET_ITEM_NUMBER(P_ORGANIZATION_ID NUMBER,
17                             P_INVENTORY_ITEM_ID NUMBER) RETURN VARCHAR2;
18 
19   FUNCTION GET_OPRN_NO(P_OPRN_ID NUMBER)  RETURN VARCHAR2;
20 
21   FUNCTION GET_EVENT_XML (P_EVENT_NAME VARCHAR2,P_EVENT_KEY VARCHAR2) RETURN CLOB;
22 END;