[Home] [Help]
PACKAGE BODY: APPS.CCT_MEDIA_TYPES_PUB
Source
1 PACKAGE BODY CCT_MEDIA_TYPES_PUB AS
2 /* $Header: cctpmtb.pls 115.2 2003/02/19 02:45:35 svinamda noship $*/
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'CCT_MEDIA_TYEPS_PUB';
5
6 FUNCTION GET_UWQ_MEDIA_TYPE_ID
7 (
8 p_item_type IN NUMBER
9 )
10 RETURN NUMBER IS
11 BEGIN
12 --dbms_output.put_line('CCT_MEDIA_TYPES_PUB.GET_UWQ_MEDIA_TYPE_ID:'
13 --|| ' p_item_type = ' || p_item_type);
14
15 if (p_item_type = G_BASIC_WEB_CALLBACK)
16 then return G_UWQ_BASIC_WEB_CALLBACK;
17 elsif (p_item_type = G_BASIC_INBOUND_TELE)
18 THEN return G_UWQ_BASIC_INBOUND_TELE;
19 elsif (p_item_type = G_INBOUND_TELE)
20 THEN return G_UWQ_INBOUND_TELE;
21 elsif (p_item_type = G_WEB_CALLBACK)
22 THEN return G_UWQ_WEB_CALLBACK;
23 elsif (p_item_type = G_WEB_COLLAB)
24 THEN return G_UWQ_WEB_COLLAB;
25 elsif (p_item_type = G_INBOUND_EMAIL)
26 THEN return G_UWQ_INBOUND_EMAIL;
27 ELSE return -1;
28 end if;
29
30 END GET_UWQ_MEDIA_TYPE_ID;
31
32 END CCT_MEDIA_TYPES_PUB;