APPS.IEU_PVT dependencies on IEU_UWQ_CLI_MED_PLUGINS

Line 112: l_class IEU_UWQ_CLI_MED_PLUGINS.CLI_PLUGIN_CLASS%TYPE;

108: )
109: AS
110:
111: l_media_types EligibleMediaList;
112: l_class IEU_UWQ_CLI_MED_PLUGINS.CLI_PLUGIN_CLASS%TYPE;
113:
114: j NUMBER := 0;
115:
116: BEGIN

Line 139: IEU_UWQ_CLI_MED_PLUGINS ptable

135: ptable.CLI_PLUGIN_CLASS
136: INTO
137: l_class
138: FROM
139: IEU_UWQ_CLI_MED_PLUGINS ptable
140: WHERE
141: (ptable.MEDIA_TYPE_ID = l_media_types(i).media_type_id);
142:
143: EXCEPTION

Line 172: IEU_UWQ_CLI_MED_PLUGINS ptable

168: ptable.CLI_PLUGIN_CLASS
169: INTO
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)

Line 213: IEU_UWQ_CLI_MED_PLUGINS ptable

209: ptable.CLI_PLUGIN_CLASS
210: INTO
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)