DBA Data[Home] [Help]

APPS.EGO_PUB_WS_ICC dependencies on XMLSEQUENCE

Line 1205: (XMLSEQUENCE

1201: BULK COLLECT INTO l_dup_icc_id_tab
1202: FROM (SELECT VALUE (ICCIdentifier) ICC_Identifier
1203: FROM ego_pub_ws_params i,
1204: TABLE
1205: (XMLSEQUENCE
1206: (EXTRACT
1207: (i.xmlcontent,
1208: '/ICCQueryParam/ICCIdentifiersList/ICCIdentifier'
1209: )

Line 1220: (XMLSEQUENCE

1216: BULK COLLECT INTO l_dup_icc_name_tab
1217: FROM (SELECT VALUE (iccname) icc_name
1218: FROM ego_pub_ws_params i,
1219: TABLE
1220: (XMLSEQUENCE
1221: (EXTRACT
1222: (i.xmlcontent,
1223: '/ICCQueryParam/ICCIdentifiersList/ICCIdentifier/ICCName'
1224: )

Line 1236: (XMLSEQUENCE

1232: BULK COLLECT INTO l_dup_icc_ver_id_tab
1233: FROM (SELECT VALUE (ICCIdentifier) ICC_Identifier
1234: FROM ego_pub_ws_params i,
1235: TABLE
1236: (XMLSEQUENCE
1237: (EXTRACT
1238: (i.xmlcontent,
1239: '/ICCQueryParam/ICCIdentifiersList/ICCIdentifier'
1240: )