1 PACKAGE GMO_MBR_UTIL AS
2 /* $Header: GMOMBRUS.pls 120.4 2006/03/21 02:32 rvsingh noship $ */
3
4 /* Global Variable */
5 G_ORGANIZATION_ID NUMBER(15) :=NULL;
6
7 /**********************************************************************************
8 ** This Function is to retrieve Template Code Based on ERES setup for the event
9 ** and event key combination
10 ** IN Parameter
11 **
12 ** P_EVENT_NAME -- This is ERES Business Event Name
13 ** P_EVENT_KEY -- Transaction Event Key
14 ** OUT Template Code
15 ***********************************************************************************/
16
17 FUNCTION GET_TEMPLATE_CODE(P_EVENT_NAME VARCHAR2,P_EVENT_KEY VARCHAR2) RETURN VARCHAR2;
18
19 /**********************************************************************************
20 ** This Function is to retrieve XML Based on ERES setup for the event
21 ** and event key combination
22 ** OUT Parameter
23 ** XML CLOB
24 ** IN Parameters
25 ** P_EVENT_NAME -- This is ERES Business Event Name
26 ** P_EVENT_KEY -- Transaction Event Key
27 **
28 ***********************************************************************************/
29
30 FUNCTION GET_MBR_XML(P_EVENT_NAME VARCHAR2,P_EVENT_KEY VARCHAR2) RETURN CLOB;
31
32 /**********************************************************************************
33 ** This proceduce is wrapper on top of above functions to reduce JDBC calls from
34 ** View MBR Page
35 ** IN Parameter
36 **
37 ** P_EVENT_NAME -- This is ERES Business Event Name
38 ** P_EVENT_KEY -- Transaction Event Key
39 ** OUT Parameters
40 ** X_TEMPLATE_CODE -- Tamplate Code
41 ** X_QUERY_ID -- Query ID to navigate Evidence Store Query Page
42 ** X_MBR_XML -- XML to generate Master Batch Record
43 **
44 ***********************************************************************************/
45
46 PROCEDURE GET_TEMPLATE_CODE_AND_XML(P_EVENT_NAME VARCHAR2,
47 P_EVENT_KEY VARCHAR2,
48 X_TEMPLATE_CODE OUT NOCOPY VARCHAR2,
49 X_QUERY_ID OUT NOCOPY NUMBER,
50 X_MBR_XML OUT NOCOPY CLOB);
51 /**********************************************************************************
52 ** This proceduce is wrapper on top of above functions to reduce JDBC calls from
53 ** View CBR Page
54 ** IN Parameter
55 **
56 ** P_EVENT_NAME -- This is ERES Business Event Name
57 ** P_EVENT_KEY -- Transaction Event Key
58 ** OUT Parameters
59 ** X_TEMPLATE_CODE -- Tamplate Code
60 ** X_QUERY_ID -- Query ID to navigate Evidence Store Query Page
61 **
62 ***********************************************************************************/
63 PROCEDURE GET_TEMPLATE_CODE_AND_QUERYID(P_EVENT_NAME VARCHAR2,
64 P_EVENT_KEY VARCHAR2,
65 X_TEMPLATE_CODE OUT NOCOPY VARCHAR2,
66 X_QUERY_ID OUT NOCOPY NUMBER);
67
68 /**********************************************************************************
69 ** This proceduce is wrapper on top of GET_USER_DISPLAY_NAME functions
70 ** of GMO_UTILITY to use in XML Map.
71 ** IN Parameter
72 **
73 ** P_USER_ID -- USER ID
74 ** OUT Parameters
75 ** P_USER_DISPLAY_NAME -- User Display Name
76 **
77 ***********************************************************************************/
78 PROCEDURE GET_USER_DISPLAY_NAME (P_USER_ID IN NUMBER, P_USER_DISPLAY_NAME OUT nocopy VARCHAR2);
79
80 /**********************************************************************************
81 ** This proceduce is return the ORG Code and ORG Name based on Event key passed to MBR Map
82 ** IN Parameter
83 **
84 ** P_MBR_EVT_KEY -- Event Key passed to Map
85 ** OUT Parameters
86 ** X_ORG_CODE -- Organization Code
87 ** X_ORG_NAME -- Organization name
88 ***********************************************************************************/
89
90 procedure get_organization (P_MBR_EVT_KEY IN VARCHAR2, X_ORG_CODE OUT NOCOPY VARCHAR2,X_ORG_NAME OUT NOCOPY VARCHAR2);
91
92 /**********************************************************************************
93 ** This function is wrapper on top of GMO_DISPENSE_SETUP_PVT.IS_DISPENSE_ITEM
94 ** IN Parameter
95 **
96 ** P_INVENTORY_ITEM_ID -- Inventory Item ID
97 ** P_ORGANIZATION_ID -- Organization ID
98 ** P_RECIPE_ID -- Recipe ID
99 ** Return Parameters
100 ** Dispense Config ID
101 **
102 ***********************************************************************************/
103 FUNCTION GET_DISPENSE_CONFIG(P_INVENTORY_ITEM_ID IN NUMBER,P_ORGANIZATION_ID IN NUMBER,P_RECIPE_ID IN NUMBER) RETURN NUMBER;
104
105 /**********************************************************************************
106 ** This function set's the Globale Variable G_ORGANIZATION_ID
107 ** IN Parameter
108 **
109 ** P_MBR_EVT_KEY -- Event Key passed to Map
110 ** Return Parameters
111 ** Number
112 **
113 ***********************************************************************************/
114
115
116 FUNCTION SET_GLOBAL_ORGID(P_MBR_EVT_KEY IN VARCHAR2) RETURN NUMBER;
117
118 END GMO_MBR_UTIL;