[Home] [Help]
145: -- Get_Date_Param_Value functions
146:
147: /*SELECT CHAR_VALUE
148: INTO l_mode
149: FROM EGO_PUB_WS_CONFIG
150: WHERE PARAMETER_NAME = 'MODE'
151: AND session_id = p_session_id;
152: */
153: --insert into EGO.tr_temp VALUES('create param P_session_id :', p_session_id);
171: -- Get_Date_Param_Value functions
172:
173: /*SELECT numeric_value
174: INTO l_batch_id
175: FROM EGO_PUB_WS_CONFIG
176: WHERE PARAMETER_NAME = 'BATCH_ID'
177: AND session_id = p_session_id;
178: */
179:
194: --insert into EGO.tr_temp VALUES('create param l_config_option :', l_config_option);
195: --if parameter is not provided, assume a default value of 'Y' (Yes)
196: --commit;
197: IF l_param_names(position) NOT IN ('SYNC', 'TRIGGER_IMPORT') THEN
198: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,
199: odi_session_id,
200: Parameter_Name,
201: Data_Type,
202: Char_value,
214:
215: END IF;
216: END LOOP;
217:
218: -- write 'SYNC' param value from EGO_PUB_BAT_PARAMS_B into EGO_PUB_WS_CONFIG table
219:
220: SELECT CHAR_VALUE
221: INTO l_param_value
222: FROM EGO_PUB_BAT_PARAMS_B
228: ELSIF l_param_value = 'SYNC' THEN
229: l_param_value := 'Y';
230: END IF;
231:
232: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,
233: odi_session_id,
234: Parameter_Name,
235: Data_Type,
236: Char_value,
245: sysdate,
246: 0,
247: l_web_service_name);
248:
249: -- write 'TRIGGER_IMPORT' param value from EGO_PUB_BAT_PARAMS_B into EGO_PUB_WS_CONFIG table
250:
251: SELECT CHAR_VALUE
252: INTO l_param_value
253: FROM EGO_PUB_BAT_PARAMS_B
253: FROM EGO_PUB_BAT_PARAMS_B
254: WHERE PARAMETER_NAME = EGO_PUB_WS_UTIL.G_TRIGGER_IMPORT_PARAM
255: AND TYPE_ID = l_batch_id;
256:
257: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,
258: odi_session_id,
259: Parameter_Name,
260: Data_Type,
261: Char_value,
275: l_batch_id := NULL;
276:
277: --
278: --STEP ONE: RETRIEVE ALL SINGLE-VALUE CONFIGURATION PARAMETERS
279: -- AND STORE THEM IN TABLE EGO_PUB_WS_CONFIG
280: --
281:
282: --initialize arrays of parameter names
283: l_param_names := EGO_PUB_WS_UTIL.parameter_name_array_type();
286: l_xpath_expr := EGO_PUB_WS_UTIL.xpath_expr_array_type();
287: EGO_PUB_WS_UTIL.Get_Xpath_Expr(l_web_service_name, l_xpath_expr);
288:
289: --retrieve all single-value parameters of interest from XML
290: --and store them in table EGO_PUB_WS_CONFIG
291:
292: l_param_names_count := l_param_names.COUNT;
293: --insert into EGO.tr_temp VALUES('create param l_param_names COUNT :', l_param_names_count);
294:
302: --if parameter is not provided, assume a default value of 'Y' (Yes)
303: --commit;
304: IF l_config_option IS NOT NULL AND l_config_option <> '?' THEN
305:
306: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,
307: odi_session_id,
308: Parameter_Name,
309: Data_Type,
310: Char_value,
329: l_web_service_name
330: );
331: --
332: --STEP TWO: RETRIEVE ALL MULTI-VALUE CONFIGURATION PARAMETERS
333: -- AND STORE THEM IN TABLE EGO_PUB_WS_CONFIG
334: --
335:
336:
337: --RETRIEVING LIST OF LANGUAGES
343: l_web_service_name);
344:
345: EXCEPTION
346: --- bug 12755038 , if parallel session is trying to insert the same
347: --- record into EGO_PUB_WS_CONFIG, consume the exception , unique
348: --- index added to prevent duplicates from getting inerted which would subsequently fail
349: --- when the rows were queried later.
350: WHEN DUP_VAL_ON_INDEX then
351: NULL;
396: -- Get_Date_Param_Value functions
397:
398: /*SELECT char_value
399: INTO l_mode
400: FROM EGO_PUB_WS_CONFIG
401: WHERE session_id = p_session_id
402: AND parameter_name = 'MODE';
403: */
404:
412: --populate odi input table depending on mode from different data sources
413: --if mode is batch, get information from publication framework using batch_id
414: CASE WHEN l_mode = 'BATCH' THEN
415:
416: --retrieving batchId from ego_pub_ws_config table
417: -- replacing following SELECT query with newly added function
418: -- in EGO_PUB_WS_UTIL - Get_Numeric_Param_Value, Get_Char_Param_Value,
419: -- Get_Date_Param_Value functions
420: /*SELECT NUMERIC_VALUE
418: -- in EGO_PUB_WS_UTIL - Get_Numeric_Param_Value, Get_Char_Param_Value,
419: -- Get_Date_Param_Value functions
420: /*SELECT NUMERIC_VALUE
421: INTO l_batch_id
422: FROM EGO_PUB_WS_CONFIG
423: WHERE SESSION_ID = p_session_id
424: AND PARAMETER_NAME = 'BATCH_ID';
425: */
426:
1118: BEGIN
1119:
1120: -- Get the number of records for configuration parameters
1121: -- for the session
1122: -- If no records exist in EGO_PUB_WS_CONFIG for the session then only
1123: -- create configuration parameters for the session.
1124:
1125: SELECT COUNT(1)
1126: INTO l_param_rec_count
1123: -- create configuration parameters for the session.
1124:
1125: SELECT COUNT(1)
1126: INTO l_param_rec_count
1127: FROM EGO_PUB_WS_CONFIG
1128: WHERE SESSION_ID = p_session_id
1129: AND PARAMETER_NAME NOT IN('ODI_SESSION_ID', 'SYSTEM_CODE', 'MODE', 'BATCH_ID');
1130:
1131: