eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.EGO_PUB_WS_UTIL dependencies on EGO_PUB_WS_PARAMS

Line 219: --EGO_PUB_WS_PARAMS using the session_id.

215: END Get_Language_Search_Str;
216:
217:
218: --Function that returns the specified ODI input parameter from table
219: --EGO_PUB_WS_PARAMS using the session_id.
220: --INPUT:
221: --p_session_id: unique identifier of input XML stored in table EGO_PUB_WS_PARAMS
222: --p_search_str: x_path expression pointing to parameter to be recovered
223: -- (e.g. '/ValuesetQueryParam/BatchId')

Line 221: --p_session_id: unique identifier of input XML stored in table EGO_PUB_WS_PARAMS

217:
218: --Function that returns the specified ODI input parameter from table
219: --EGO_PUB_WS_PARAMS using the session_id.
220: --INPUT:
221: --p_session_id: unique identifier of input XML stored in table EGO_PUB_WS_PARAMS
222: --p_search_str: x_path expression pointing to parameter to be recovered
223: -- (e.g. '/ValuesetQueryParam/BatchId')
224: --OUTPUT:
225: --parameter value in VARCHAR or NULL if parameter specified does not exist

Line 237: from EGO_PUB_WS_PARAMS

233: BEGIN
234:
235: select extractValue(xmlcontent, p_search_str)
236: into x_value
237: from EGO_PUB_WS_PARAMS
238: where session_id = p_session_id;
239:
240: --check for parameter value not available condition generated by
241: --some web services when parameter value is not specified.

Line 280: FROM EGO_PUB_WS_PARAMS

276:
277: --if BatchId node exist and It has some value then we are in 'BATCH' mode
278: SELECT existsNode(xmlcontent, p_search_str)
279: INTO l_exists
280: FROM EGO_PUB_WS_PARAMS
281: WHERE session_id = p_session_id;
282:
283:
284: IF l_exists=1 THEN

Line 291: FROM EGO_PUB_WS_PARAMS

287: -- trudave commenting following SELECT statement and replacing it with GET_ODI_Input_Parameter Function use.
288: -- trudave remove the commented following SELECT query later on
289: /*SELECT Nvl(extractValue(xmlcontent,p_search_str),-1)
290: INTO l_batch_id
291: FROM EGO_PUB_WS_PARAMS
292: WHERE session_id = p_session_id;*/
293:
294: -- trudave - added following code by replacing above SELECT Statement.
295: l_batch_id := Nvl(Get_ODI_Input_Parameter(p_session_id, p_search_str),-1);

Line 449: --EGO_PUB_WS_PARAMS and can be recovered with the session_id

445: --SECURITY_GROUP_NAME depending on input mode
446:
447: --if mode is LIST or H-MDM, get authentication information from
448: --user calling the web service. This info is stored in table
449: --EGO_PUB_WS_PARAMS and can be recovered with the session_id
450: IF Nvl(l_mode,'LIST') <> 'BATCH' THEN
451:
452: --retrieving and storing FND_USER_NAME
453: SELECT fnd_user_name

Line 455: FROM EGO_PUB_WS_PARAMS

451:
452: --retrieving and storing FND_USER_NAME
453: SELECT fnd_user_name
454: INTO l_fnd_user_name
455: FROM EGO_PUB_WS_PARAMS
456: WHERE session_id = p_session_id;
457:
458: /*INSERT INTO tr_temp (Session_id, message)
459: values (p_session_id, 'FND_USER_NAME:' || l_fnd_user_name);*/

Line 480: FROM EGO_PUB_WS_PARAMS

476:
477: --retrieving and storing RESPONSIBILITY_NAME
478: SELECT responsibility_name
479: INTO l_responsibility_name
480: FROM EGO_PUB_WS_PARAMS
481: WHERE session_id = p_session_id;
482:
483: /*INSERT INTO tr_temp (Session_id, message)
484: values (p_session_id, 'RESPONSIBILITY_NAME:' || l_responsibility_name);*/

Line 507: FROM EGO_PUB_WS_PARAMS

503:
504: --retrieving and storing RESPONSIBILITY_APPL_NAME
505: SELECT responsibility_appl_name
506: INTO l_responsibility_appl_name
507: FROM EGO_PUB_WS_PARAMS
508: WHERE session_id = p_session_id;
509:
510: /*INSERT INTO tr_temp (Session_id, message)
511: values (p_session_id, 'RESPONSIBILITY_APPL_NAME:' || l_responsibility_appl_name);*/

Line 534: FROM EGO_PUB_WS_PARAMS

530:
531: --retrieving and storing SECURITY_GROUP_NAME
532: SELECT security_group_name
533: INTO l_security_group_name
534: FROM EGO_PUB_WS_PARAMS
535: WHERE session_id = p_session_id;
536:
537: /*INSERT INTO tr_temp (Session_id, message)
538: values (p_session_id, 'SECURITY_GROUP_NAME:' || l_security_group_name);*/

Line 1074: FROM EGO_PUB_WS_PARAMS i,

1070: --extracting system Codes
1071: SELECT extractValue(system_code, '/SystemCode')
1072: BULK COLLECT INTO l_system_code_tab
1073: FROM (SELECT Value(systemcode) system_code
1074: FROM EGO_PUB_WS_PARAMS i,
1075: TABLE(XMLSequence(
1076: extract(i.xmlcontent, l_systemcode_xpath) )) systemcode
1077: WHERE session_id=p_session_id
1078: );

Line 1084: FROM EGO_PUB_WS_PARAMS i,

1080: --extracting system names
1081: SELECT extractValue(system_name, '/SystemName')
1082: BULK COLLECT INTO l_system_name_tab
1083: FROM (SELECT Value(systemname) system_name
1084: FROM EGO_PUB_WS_PARAMS i,
1085: TABLE(XMLSequence(
1086: extract(i.xmlcontent, l_systemname_xpath) )) systemname
1087: WHERE session_id=p_session_id
1088: );

Line 1450: FROM EGO_PUB_WS_PARAMS i,

1446: --extracting language Codes
1447: SELECT extractValue(lang_code, '/LanguageCode')
1448: BULK COLLECT INTO l_lang_code_tab
1449: FROM (SELECT Value(langcode) lang_code
1450: FROM EGO_PUB_WS_PARAMS i,
1451: TABLE(XMLSequence(
1452: extract(i.xmlcontent, l_langcode_xpath) )) langcode
1453: WHERE session_id=p_session_id
1454: );

Line 1460: FROM EGO_PUB_WS_PARAMS i,

1456: --extracting language names
1457: SELECT extractValue(lang_name, '/LanguageName')
1458: BULK COLLECT INTO l_lang_name_tab
1459: FROM (SELECT Value(langname) lang_name
1460: FROM EGO_PUB_WS_PARAMS i,
1461: TABLE(XMLSequence(
1462: extract(i.xmlcontent, l_langname_xpath) )) langname
1463: WHERE session_id=p_session_id
1464: );