APPS.EGO_PUB_WS_WRAPPER dependencies on EGO_PUB_WS_CONFIG

Line 37: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,

33:
34: BEGIN
35:
36: -- inserting ODI_SESSION_ID as config parameter
37: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,
38: odi_session_id,
39: Parameter_Name,
40: Data_Type,
41: NUMERIC_value,

Line 80: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,

76: values (p_session_id, 'invokation mode:' || l_mode);*/
77:
78:
79: --inserting invocation mode as config parameter
80: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,
81: odi_session_id,
82: Parameter_Name,
83: Data_Type,
84: Char_value,

Line 99: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,

95: l_odi_entscename);
96:
97: IF l_mode = 'BATCH' THEN
98: --inserting batch id as config parameter
99: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,
100: odi_session_id,
101: Parameter_Name,
102: Data_Type,
103: Numeric_value,

Line 177: FROM EGO_PUB_WS_CONFIG

173: -- which will update status for all entities for the provided systems of the batch
174: BEGIN
175: SELECT CHAR_VALUE
176: INTO l_mode
177: FROM EGO_PUB_WS_CONFIG
178: WHERE SESSION_ID = p_session_id
179: AND PARAMETER_NAME = 'MODE';
180: EXCEPTION
181: WHEN NO_DATA_FOUND THEN

Line 190: FROM EGO_PUB_WS_CONFIG

186:
187: BEGIN
188: SELECT NUMERIC_VALUE
189: INTO l_batch_id
190: FROM EGO_PUB_WS_CONFIG
191: WHERE SESSION_ID = p_session_id
192: AND PARAMETER_NAME = 'BATCH_ID';
193: EXCEPTION
194: WHEN NO_DATA_FOUND THEN