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.

APPS.EGO_PUB_WS_VS dependencies on XMLSEQUENCE

Line 1056: TABLE(XMLSequence(

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: );
1060: debug(1,l_proc_name||' got VS ids,names and vers into collection');

Line 1069: TABLE(XMLSequence(

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

Line 1083: TABLE(XMLSequence(

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