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_ICC dependencies on EGO_PUB_WS_PARAMS

Line 498: FROM EGO_PUB_WS_PARAMS

494:
495: --get web service name
496: SELECT WEB_SERVICE_NAME
497: INTO l_web_service_name
498: FROM EGO_PUB_WS_PARAMS
499: WHERE SESSION_ID = p_session_id;
500:
501: --debug(L_PROC_NAME||' WEB_SERVICE_NAME: '||l_web_service_name);
502:

Line 1203: FROM ego_pub_ws_params i,

1199: If the ICCId node does not exist or has a null value, insert -1 as value*/
1200: SELECT Decode(existsNode(ICC_Identifier, '/ICCIdentifier/ICCId'), 1, Nvl(extractValue(ICC_Identifier, '/ICCIdentifier/ICCId'), -1), 0, -1)
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,

Line 1218: FROM ego_pub_ws_params i,

1214: /*Extract value into array if ICCName node exist in Input table*/
1215: SELECT EXTRACTVALUE (icc_name, '/ICCName')
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,

Line 1234: FROM ego_pub_ws_params i,

1230: If the VersionId node does not exist or has a null value, insert -1 as value*/
1231: SELECT Decode(existsNode(ICC_Identifier, '/ICCIdentifier/VersionSequence'), 1, Nvl(extractValue(ICC_Identifier, '/ICCIdentifier/VersionSequence'), -1), 0, -1)
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,