DBA Data[Home] [Help]

APPS.EGO_PUB_WS_UTIL dependencies on XMLSEQUENCE

Line 1075: TABLE(XMLSequence(

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: );
1079:

Line 1085: TABLE(XMLSequence(

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: );
1089:

Line 1451: TABLE(XMLSequence(

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: );
1455:

Line 1461: TABLE(XMLSequence(

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: );
1465: