10: MEDIA_TYPE_ID
11: INTO
12: G_MTID_INBOUND_TELEPHONY
13: FROM
14: IEU_UWQ_MEDIA_TYPES_B
15: WHERE
16: MEDIA_TYPE_UUID = G_MTUUID_INBOUND_TELEPHONY; -- Niraj, Bug 4998176, Replaced value by Variable
17: exception
18: when others then
25: MEDIA_TYPE_ID
26: INTO
27: G_MTID_INBOUND_EMAIL
28: FROM
29: IEU_UWQ_MEDIA_TYPES_B
30: WHERE
31: MEDIA_TYPE_UUID = G_MTUUID_INBOUND_EMAIL; -- Niraj, Bug 4998176, Replaced value by Variable
32: exception
33: when others then
40: MEDIA_TYPE_ID
41: INTO
42: G_MTID_OUTBOUND_TELEPHONY
43: FROM
44: IEU_UWQ_MEDIA_TYPES_B
45: WHERE
46: MEDIA_TYPE_UUID = G_MTUUID_OUTBOUND_TELEPHONY; -- Niraj, Bug 4998176, Replaced value by Variable
47: exception
48: when others then
55: MEDIA_TYPE_ID
56: INTO
57: G_MTID_ADV_OUTB_TELEPHONY
58: FROM
59: IEU_UWQ_MEDIA_TYPES_B
60: WHERE
61: MEDIA_TYPE_UUID = G_MTUUID_ADV_OUTB_TELEPHONY; -- Niraj, Bug 4998176, Replaced value by Variable
62: exception
63: when others then
70: MEDIA_TYPE_ID
71: INTO
72: G_MTID_OUTBOUND_EMAIL
73: FROM
74: IEU_UWQ_MEDIA_TYPES_B
75: WHERE
76: MEDIA_TYPE_UUID = G_MTUUID_OUTBOUND_EMAIL; -- Niraj, Bug 4998176, Replaced value by Variable
77: exception
78: when others then
85: MEDIA_TYPE_ID
86: INTO
87: G_MTID_WEB_CALLBACK
88: FROM
89: IEU_UWQ_MEDIA_TYPES_B
90: WHERE
91: MEDIA_TYPE_UUID = G_MTUUID_WEB_CALLBACK; -- Niraj, Bug 4998176, Replaced value by Variable
92: exception
93: when others then
100: MEDIA_TYPE_ID
101: INTO
102: G_MTID_WEB_COLLABORATION
103: FROM
104: IEU_UWQ_MEDIA_TYPES_B
105: WHERE
106: MEDIA_TYPE_UUID = G_MTUUID_WEB_COLLABORATION; -- Niraj, Bug 4998176, Replaced value by Variable
107: exception
108: when others then
115: MEDIA_TYPE_ID
116: INTO
117: G_MTID_DIRECT_EMAIL
118: FROM
119: IEU_UWQ_MEDIA_TYPES_B
120: WHERE
121: MEDIA_TYPE_UUID = G_MTUUID_DIRECT_EMAIL; -- Niraj, Bug 4998176, Replaced value by Variable
122: exception
123: when others then
130: MEDIA_TYPE_ID
131: INTO
132: G_MTID_BLENDED
133: FROM
134: IEU_UWQ_MEDIA_TYPES_B
135: WHERE
136: MEDIA_TYPE_UUID = G_MTUUID_BLENDED; -- Niraj, Bug 4998176, Replaced value by Variable
137: exception
138: when others then
160: MEDIA_TYPE_ID
161: INTO
162: G_MTID_ACQUIRED_EMAIL
163: FROM
164: IEU_UWQ_MEDIA_TYPES_B
165: WHERE
166: MEDIA_TYPE_UUID = G_MTUUID_ACQUIRED_EMAIL; -- Niraj, Bug 4998176, Replaced value by Variable
167: exception
168: when others then