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.IEU_PVT dependencies on IEU_CONSTS_PUB

Line 174: ( (ptable.MEDIA_TYPE_ID = IEU_CONSTS_PUB.G_MTID_INBOUND_TELEPHONY)

170: l_class
171: FROM
172: IEU_UWQ_CLI_MED_PLUGINS ptable
173: WHERE
174: ( (ptable.MEDIA_TYPE_ID = IEU_CONSTS_PUB.G_MTID_INBOUND_TELEPHONY)
175: OR
176: (ptable.MEDIA_TYPE_ID = IEU_CONSTS_PUB.G_MTID_OUTBOUND_TELEPHONY)
177: OR
178: (ptable.MEDIA_TYPE_ID = IEU_CONSTS_PUB.G_MTID_ADV_OUTB_TELEPHONY))

Line 176: (ptable.MEDIA_TYPE_ID = IEU_CONSTS_PUB.G_MTID_OUTBOUND_TELEPHONY)

172: IEU_UWQ_CLI_MED_PLUGINS ptable
173: WHERE
174: ( (ptable.MEDIA_TYPE_ID = IEU_CONSTS_PUB.G_MTID_INBOUND_TELEPHONY)
175: OR
176: (ptable.MEDIA_TYPE_ID = IEU_CONSTS_PUB.G_MTID_OUTBOUND_TELEPHONY)
177: OR
178: (ptable.MEDIA_TYPE_ID = IEU_CONSTS_PUB.G_MTID_ADV_OUTB_TELEPHONY))
179: AND
180: (ROWNUM <= 1)

Line 178: (ptable.MEDIA_TYPE_ID = IEU_CONSTS_PUB.G_MTID_ADV_OUTB_TELEPHONY))

174: ( (ptable.MEDIA_TYPE_ID = IEU_CONSTS_PUB.G_MTID_INBOUND_TELEPHONY)
175: OR
176: (ptable.MEDIA_TYPE_ID = IEU_CONSTS_PUB.G_MTID_OUTBOUND_TELEPHONY)
177: OR
178: (ptable.MEDIA_TYPE_ID = IEU_CONSTS_PUB.G_MTID_ADV_OUTB_TELEPHONY))
179: AND
180: (ROWNUM <= 1)
181: ORDER BY
182: ptable.CLI_PLUGIN_ID;

Line 215: ( (ptable.MEDIA_TYPE_ID = IEU_CONSTS_PUB.G_MTID_INBOUND_EMAIL) OR

211: l_class
212: FROM
213: IEU_UWQ_CLI_MED_PLUGINS ptable
214: WHERE
215: ( (ptable.MEDIA_TYPE_ID = IEU_CONSTS_PUB.G_MTID_INBOUND_EMAIL) OR
216: (ptable.MEDIA_TYPE_ID = IEU_CONSTS_PUB.G_MTID_DIRECT_EMAIL) ) AND
217: (ROWNUM <= 1)
218: ORDER BY
219: ptable.CLI_PLUGIN_ID;

Line 216: (ptable.MEDIA_TYPE_ID = IEU_CONSTS_PUB.G_MTID_DIRECT_EMAIL) ) AND

212: FROM
213: IEU_UWQ_CLI_MED_PLUGINS ptable
214: WHERE
215: ( (ptable.MEDIA_TYPE_ID = IEU_CONSTS_PUB.G_MTID_INBOUND_EMAIL) OR
216: (ptable.MEDIA_TYPE_ID = IEU_CONSTS_PUB.G_MTID_DIRECT_EMAIL) ) AND
217: (ROWNUM <= 1)
218: ORDER BY
219: ptable.CLI_PLUGIN_ID;
220: EXCEPTION

Line 871: X_NODE_ID => IEU_CONSTS_PUB.G_SNID_MEDIA,

867:
868: IEU_UWQ_SEL_RT_NODES_PKG.LOAD_ROW (
869: X_RESOURCE_ID => p_resource_id,
870: X_SEL_ENUM_ID => 0,
871: X_NODE_ID => IEU_CONSTS_PUB.G_SNID_MEDIA,
872: X_NODE_TYPE => 0,
873: X_NODE_PID => 0,
874: X_NODE_WEIGHT => nvl(IEU_UWQ_UTIL_PUB.to_number_noerr(fnd_profile.value('IEU_QOR_MEDIA')) , IEU_CONSTS_PUB.G_SNID_MEDIA),
875: X_NODE_DEPTH => 1,

Line 874: X_NODE_WEIGHT => nvl(IEU_UWQ_UTIL_PUB.to_number_noerr(fnd_profile.value('IEU_QOR_MEDIA')) , IEU_CONSTS_PUB.G_SNID_MEDIA),

870: X_SEL_ENUM_ID => 0,
871: X_NODE_ID => IEU_CONSTS_PUB.G_SNID_MEDIA,
872: X_NODE_TYPE => 0,
873: X_NODE_PID => 0,
874: X_NODE_WEIGHT => nvl(IEU_UWQ_UTIL_PUB.to_number_noerr(fnd_profile.value('IEU_QOR_MEDIA')) , IEU_CONSTS_PUB.G_SNID_MEDIA),
875: X_NODE_DEPTH => 1,
876: X_SEL_ENUM_PID => 0,
877: X_MEDIA_TYPE_ID => NULL,
878: X_COUNT => 0,

Line 956: /* (rt_nodes.node_id <> IEU_CONSTS_PUB.G_SNID_MEDIA) and */

952: ieu_uwq_sel_rt_nodes rt_nodes
953: WHERE
954: (rt_nodes.resource_id = p_resource_id) AND
955: (rt_nodes.node_id > 0) AND
956: /* (rt_nodes.node_id <> IEU_CONSTS_PUB.G_SNID_MEDIA) and */
957: (rt_nodes.not_valid = 'N');
958:
959: /*
960: CURSOR c_media_nodes IS

Line 975: (rt_nodes.node_id = IEU_CONSTS_PUB.G_SNID_MEDIA) and

971: FROM
972: ieu_uwq_sel_rt_nodes rt_nodes
973: WHERE
974: (rt_nodes.resource_id = p_resource_id) AND
975: (rt_nodes.node_id = IEU_CONSTS_PUB.G_SNID_MEDIA) and
976: (rt_nodes.not_valid = 'N');
977: */
978:
979: CURSOR c_bindVal IS

Line 1018: if (node.node_id = IEU_CONSTS_PUB.G_SNID_MEDIA)

1014: LOOP
1015:
1016: l_count := 0;
1017:
1018: if (node.node_id = IEU_CONSTS_PUB.G_SNID_MEDIA)
1019: then
1020:
1021: l_sel_rt_node_id := node.sel_rt_node_id;
1022: l_node_id := node.node_id;

Line 1080: if (l_node_id is not null) and (l_node_id = IEU_CONSTS_PUB.G_SNID_MEDIA)

1076: END;
1077:
1078: end;
1079:
1080: if (l_node_id is not null) and (l_node_id = IEU_CONSTS_PUB.G_SNID_MEDIA)
1081: then
1082: l_count := 0;
1083: l_bulk_count := '';
1084:

Line 1194: if ( (p_node_id = IEU_CONSTS_PUB.G_SNID_MEDIA) or

1190: -- (Ray Cardillo / 05-08-00)
1191: --
1192:
1193:
1194: if ( (p_node_id = IEU_CONSTS_PUB.G_SNID_MEDIA) or
1195: (p_node_id = IEU_CONSTS_PUB.G_SNID_BLENDED) )
1196: then
1197: begin
1198: select

Line 1195: (p_node_id = IEU_CONSTS_PUB.G_SNID_BLENDED) )

1191: --
1192:
1193:
1194: if ( (p_node_id = IEU_CONSTS_PUB.G_SNID_MEDIA) or
1195: (p_node_id = IEU_CONSTS_PUB.G_SNID_BLENDED) )
1196: then
1197: begin
1198: select
1199: where_clause

Line 1596: (srvrs.TYPE_ID = IEU_CONSTS_PUB.G_STID_UWQ) AND

1592: WHERE
1593: (binds.RESOURCE_ID = P_RESOURCE_ID) AND
1594: (binds.SERVER_ID = srvrs.SERVER_ID) AND
1595: (nvl(binds.NOT_VALID,'N') = 'N') AND
1596: (srvrs.TYPE_ID = IEU_CONSTS_PUB.G_STID_UWQ) AND
1597: (srvrs.SERVER_ID = rti.SERVER_ID) AND
1598: (nvl(rti.STATUS,0) > 0) AND
1599: (ROWNUM <= 1);
1600:

Line 2366: l_prnt_node_id := IEU_CONSTS_PUB.G_SNID_MEDIA;

2362: -- for the top node. (Ray Cardillo / 05-22-01)
2363: --
2364: if ( (P_ENUMERATOR_DATAREC_LIST(0).MEDIA_TYPE_ID IS NOT NULL) )
2365: then
2366: l_prnt_node_id := IEU_CONSTS_PUB.G_SNID_MEDIA;
2367: else
2368: l_prnt_node_id := 0;
2369: end if;
2370: