APPS.GMO_MBR_UTIL dependencies on GMO_MBR_UTIL

Line 1: PACKAGE BODY GMO_MBR_UTIL AS

1: PACKAGE BODY GMO_MBR_UTIL AS
2: /* $Header: GMOMBRUB.pls 120.12 2006/10/06 11:20:19 rvsingh noship $ */
3:
4: FUNCTION GET_TEMPLATE_CODE(P_EVENT_NAME VARCHAR2,P_EVENT_KEY VARCHAR2) RETURN VARCHAR2 IS
5: L_ame_rule_ids FND_TABLE_OF_VARCHAR2_255;

Line 107: X_TEMPLATE_CODE := GMO_MBR_UTIL.get_template_code(p_event_name => P_EVENT_NAME,

103: X_TEMPLATE_CODE OUT NOCOPY VARCHAR2,
104: X_QUERY_ID OUT NOCOPY NUMBER,
105: X_MBR_XML OUT NOCOPY CLOB) IS
106: BEGIN
107: X_TEMPLATE_CODE := GMO_MBR_UTIL.get_template_code(p_event_name => P_EVENT_NAME,
108: p_event_key => P_EVENT_KEY);
109:
110: -- generate XML only when template code is present
111: IF X_TEMPLATE_CODE IS NOT NULL

Line 113: X_MBR_XML := GMO_MBR_UTIL.get_mbr_xml(p_event_name => P_EVENT_NAME,

109:
110: -- generate XML only when template code is present
111: IF X_TEMPLATE_CODE IS NOT NULL
112: THEN
113: X_MBR_XML := GMO_MBR_UTIL.get_mbr_xml(p_event_name => P_EVENT_NAME,
114: p_event_key => P_EVENT_KEY);
115: X_QUERY_ID := GMO_MBR_UTIL.GET_QUERY_ID(p_event_name => P_EVENT_NAME,
116: p_event_key => P_EVENT_KEY);
117: END IF;

Line 115: X_QUERY_ID := GMO_MBR_UTIL.GET_QUERY_ID(p_event_name => P_EVENT_NAME,

111: IF X_TEMPLATE_CODE IS NOT NULL
112: THEN
113: X_MBR_XML := GMO_MBR_UTIL.get_mbr_xml(p_event_name => P_EVENT_NAME,
114: p_event_key => P_EVENT_KEY);
115: X_QUERY_ID := GMO_MBR_UTIL.GET_QUERY_ID(p_event_name => P_EVENT_NAME,
116: p_event_key => P_EVENT_KEY);
117: END IF;
118: END;
119:

Line 126: X_TEMPLATE_CODE := GMO_MBR_UTIL.get_template_code(p_event_name => P_EVENT_NAME,

122: P_EVENT_KEY VARCHAR2,
123: X_TEMPLATE_CODE OUT NOCOPY VARCHAR2,
124: X_QUERY_ID OUT NOCOPY NUMBER) IS
125: BEGIN
126: X_TEMPLATE_CODE := GMO_MBR_UTIL.get_template_code(p_event_name => P_EVENT_NAME,
127: p_event_key => P_EVENT_KEY);
128: X_QUERY_ID := GMO_MBR_UTIL.GET_QUERY_ID(p_event_name => P_EVENT_NAME,
129: p_event_key => P_EVENT_KEY);
130: END;

Line 128: X_QUERY_ID := GMO_MBR_UTIL.GET_QUERY_ID(p_event_name => P_EVENT_NAME,

124: X_QUERY_ID OUT NOCOPY NUMBER) IS
125: BEGIN
126: X_TEMPLATE_CODE := GMO_MBR_UTIL.get_template_code(p_event_name => P_EVENT_NAME,
127: p_event_key => P_EVENT_KEY);
128: X_QUERY_ID := GMO_MBR_UTIL.GET_QUERY_ID(p_event_name => P_EVENT_NAME,
129: p_event_key => P_EVENT_KEY);
130: END;
131:
132: PROCEDURE GET_USER_DISPLAY_NAME (P_USER_ID IN NUMBER, P_USER_DISPLAY_NAME OUT nocopy VARCHAR2)as

Line 179: END GMO_MBR_UTIL;

175: into G_ORGANIZATION_ID from dual;
176: RETURN l_flag;
177: END SET_GLOBAL_ORGID;
178:
179: END GMO_MBR_UTIL;