APPS.EGO_PUB_WS_VS dependencies on EGO_PUB_WS_PARAMS

Line 428: FROM EGO_PUB_WS_PARAMS

424: debug(1,l_proc_name||'start');
425:
426: SELECT WEB_SERVICE_NAME
427: INTO l_web_service_name
428: FROM EGO_PUB_WS_PARAMS
429: WHERE SESSION_ID = p_session_id;
430: debug(1,l_proc_name||'derived web service name=>'||l_web_service_name);
431:
432:

Line 604: FROM EGO_PUB_WS_PARAMS

600:
601: --get invocation mode for the web service
602: SELECT WEB_SERVICE_NAME
603: INTO l_web_service_name
604: FROM EGO_PUB_WS_PARAMS
605: WHERE SESSION_ID = p_session_id;
606: debug(2, l_proc_name||'Finish fetch WS name=>'||l_web_service_name);
607:
608: IF l_mode = 'BATCH' THEN

Line 1055: FROM EGO_PUB_WS_PARAMS i,

1051: 1, Nvl(extractValue(vs_id, 'ValuesetIdentifier/ValueSetId'), -1),
1052: 0, -1)
1053: BULK COLLECT INTO l_vs_id_tab
1054: FROM( SELECT Value(vsid) vs_id
1055: FROM EGO_PUB_WS_PARAMS i,
1056: TABLE(XMLSequence(
1057: extract(i.xmlcontent, 'ValuesetQueryParam/ValuesetIdentifiersList/ValuesetIdentifier') )) vsid
1058: WHERE session_id=p_session_id
1059: );

Line 1068: FROM EGO_PUB_WS_PARAMS i,

1064:
1065: SELECT Decode(existsNode(vs_name, 'ValuesetIdentifier/ValueSetName'), 1, extractValue(vs_name, 'ValuesetIdentifier/ValueSetName'), 0, NULL)
1066: BULK COLLECT INTO l_vs_name_tab
1067: FROM( SELECT Value(vsname) vs_name
1068: FROM EGO_PUB_WS_PARAMS i,
1069: TABLE(XMLSequence(
1070: extract(i.xmlcontent, 'ValuesetQueryParam/ValuesetIdentifiersList/ValuesetIdentifier') )) vsname
1071: WHERE session_id=p_session_id
1072: );

Line 1082: FROM EGO_PUB_WS_PARAMS i,

1078: 1, extractValue(vs_vers, 'ValuesetIdentifier/VersionSeqId'),
1079: 0, NULL)
1080: BULK COLLECT INTO l_vs_vers_tab
1081: FROM( SELECT Value(vsvers) vs_vers
1082: FROM EGO_PUB_WS_PARAMS i,
1083: TABLE(XMLSequence(
1084: extract(i.xmlcontent, 'ValuesetQueryParam/ValuesetIdentifiersList/ValuesetIdentifier') )) vsvers
1085: WHERE session_id=p_session_id
1086: );