PACKAGE BODY: APPS.IEU_CONSTS_PUB

Source

1 PACKAGE BODY IEU_CONSTS_PUB AS
2 /* $Header: IEUCNSTB.pls 120.1 2006/02/02 03:36:13 nsardana noship $ */
3 
4 
5 begin
6 
7   begin
8     SELECT
9       DISTINCT
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
19       null;
20   end;
21 
22   begin
23     SELECT
24       DISTINCT
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
34       null;
35   end;
36 
37   begin
38     SELECT
39       DISTINCT
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
49       null;
50   end;
51 
52   begin
53     SELECT
54       DISTINCT
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
64       null;
65   end;
66 
67   begin
68     SELECT
69       DISTINCT
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
79       null;
80   end;
81 
82   begin
83     SELECT
84       DISTINCT
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
94       null;
95   end;
96 
97   begin
98     SELECT
99       DISTINCT
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
109       null;
110   end;
111 
112   begin
113     SELECT
114       DISTINCT
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
124       null;
125   end;
126 
127   begin
128     SELECT
129       DISTINCT
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
139       null;
140   end;
141 
142   begin
143     SELECT
144       DISTINCT
145         TYPE_ID
146       INTO
147         G_STID_UWQ
148       FROM
149         IEO_SVR_TYPES_B
150       WHERE
151         TYPE_UUID = G_STUUID_UWQ;
152   exception
153     when others then
154       null;
155   end;
156 
157   begin
158     SELECT
159       DISTINCT
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
169       null;
170   end;
171 
172 end IEU_CONSTS_PUB;