APPS.IEM_EMAIL_SERVER_TYPES_PVT dependencies on IEM_EMAIL_SERVER_TYPES

Line 1: PACKAGE BODY IEM_EMAIL_SERVER_TYPES_PVT as

1: PACKAGE BODY IEM_EMAIL_SERVER_TYPES_PVT as
2: /* $Header: iemvsvtb.pls 115.5 2002/12/04 01:02:50 sboorela shipped $ */
3:
4: G_PKG_NAME CONSTANT varchar2(30) :='IEM_EMAIL_SERVER_TYPES_PVT ';
5:

Line 4: G_PKG_NAME CONSTANT varchar2(30) :='IEM_EMAIL_SERVER_TYPES_PVT ';

1: PACKAGE BODY IEM_EMAIL_SERVER_TYPES_PVT as
2: /* $Header: iemvsvtb.pls 115.5 2002/12/04 01:02:50 sboorela shipped $ */
3:
4: G_PKG_NAME CONSTANT varchar2(30) :='IEM_EMAIL_SERVER_TYPES_PVT ';
5:
6: PROCEDURE create_item (p_api_version_number IN NUMBER,
7: p_init_msg_list IN VARCHAR2 ,
8: p_commit IN VARCHAR2 ,

Line 58: SELECT iem_email_server_types_s1.nextval

54: FND_MSG_PUB.initialize;
55: END IF;
56: -- Initialize API return status to SUCCESS
57: x_return_status := FND_API.G_RET_STS_SUCCESS;
58: SELECT iem_email_server_types_s1.nextval
59: INTO l_seq_id
60: FROM dual;
61: INSERT INTO iem_email_server_types
62: (

Line 61: INSERT INTO iem_email_server_types

57: x_return_status := FND_API.G_RET_STS_SUCCESS;
58: SELECT iem_email_server_types_s1.nextval
59: INTO l_seq_id
60: FROM dual;
61: INSERT INTO iem_email_server_types
62: (
63: EMAIL_SERVER_TYPE_ID,
64: EMAIL_SERVER_TYPE ,
65: IS_SECURE ,

Line 190: IEM_EMAIL_SERVER_TYPES

186: if p_server_type_id is null then
187: DELETE FROM IEM_EMAIL_SERVERS
188: WHERE SERVER_TYPE_ID IN
189: (SELECT EMAIL_SERVER_TYPE_ID FROM
190: IEM_EMAIL_SERVER_TYPES
191: WHERE EMAIL_SERVER_TYPE=p_server_type);
192: DELETE FROM IEM_EMAIL_SERVER_TYPES
193: WHERE EMAIL_SERVER_TYPE=p_server_type;
194: else

Line 192: DELETE FROM IEM_EMAIL_SERVER_TYPES

188: WHERE SERVER_TYPE_ID IN
189: (SELECT EMAIL_SERVER_TYPE_ID FROM
190: IEM_EMAIL_SERVER_TYPES
191: WHERE EMAIL_SERVER_TYPE=p_server_type);
192: DELETE FROM IEM_EMAIL_SERVER_TYPES
193: WHERE EMAIL_SERVER_TYPE=p_server_type;
194: else
195: DELETE FROM IEM_EMAIL_SERVERS
196: WHERE SERVER_TYPE_ID=p_server_type_id;

Line 197: DELETE FROM IEM_EMAIL_SERVER_TYPES

193: WHERE EMAIL_SERVER_TYPE=p_server_type;
194: else
195: DELETE FROM IEM_EMAIL_SERVERS
196: WHERE SERVER_TYPE_ID=p_server_type_id;
197: DELETE FROM IEM_EMAIL_SERVER_TYPES
198: WHERE EMAIL_SERVER_TYPE_ID=p_server_type_id;
199: end if;
200:
201: -- Standard Check Of p_commit.

Line 295: update iem_email_server_types

291: END IF;
292: -- Initialize API return status to SUCCESS
293: x_return_status := FND_API.G_RET_STS_SUCCESS;
294: if p_server_type_id is null then
295: update iem_email_server_types
296: set type_description= decode(p_type_desc,FND_API.G_MISS_CHAR,null,null,type_Description,p_type_desc),
297: is_secure=decode(p_is_secure,FND_API.G_MISS_CHAR,null,null,is_secure,p_is_secure),
298: LAST_UPDATE_DATE = sysdate,
299: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, null,last_updated_by,p_LAST_UPDATED_BY),

Line 318: update iem_email_server_types

314: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE14, p_ATTRIBUTE14),
315: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE15, p_ATTRIBUTE15)
316: WHERE EMAIL_SERVER_TYPE=p_server_type;
317: ELSE
318: update iem_email_server_types
319: set
320: email_server_type= decode(p_server_type,FND_API.G_MISS_CHAR,null,null,email_server_type,p_server_type),
321: type_description= decode(p_type_desc,FND_API.G_MISS_CHAR,null,null,type_description,p_type_desc),
322: is_secure=decode(p_is_secure,FND_API.G_MISS_CHAR,null,null,is_secure,p_is_secure),

Line 386: END IEM_EMAIL_SERVER_TYPES_PVT ;

382: p_data => x_msg_data
383: );
384:
385: END update_item;
386: END IEM_EMAIL_SERVER_TYPES_PVT ;