DBA Data[Home] [Help]

APPS.EGO_PUB_WS_AG dependencies on XMLSEQUENCE

Line 537: TABLE(XMLSequence(

533: SELECT Decode(existsNode(ag_id, '/AGId'), 1, Nvl(extractValue(ag_id, '/AGId'), -1), 0 , -1)
534: BULK COLLECT INTO l_ag_id_tab
535: FROM( SELECT Value(agid) ag_id
536: FROM EGO_PUB_WS_PARAMS i,
537: TABLE(XMLSequence(
538: extract(i.xmlcontent, 'AGQueryParam/AGIdentifiersList/AGIdentifier/AGId') )) agid
539: WHERE session_id=p_session_id
540: );
541:

Line 547: TABLE(XMLSequence(

543: SELECT extractValue(ag_name, '/AGName')
544: BULK COLLECT INTO l_ag_name_tab
545: FROM( SELECT Value(agname) ag_name
546: FROM EGO_PUB_WS_PARAMS i,
547: TABLE(XMLSequence(
548: extract(i.xmlcontent, 'AGQueryParam/AGIdentifiersList/AGIdentifier/AGName') )) agname
549: WHERE session_id=p_session_id
550: );
551: