DBA Data[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;