APPS.IEM_EMAIL_ICNTR_MAPS_PVT dependencies on IEM_EMAIL_ICNTR_MAPS

Line 1: PACKAGE BODY IEM_EMAIL_ICNTR_MAPS_PVT as

1: PACKAGE BODY IEM_EMAIL_ICNTR_MAPS_PVT as
2: /* $Header: iemvmapb.pls 115.5 2002/12/03 23:21:26 sboorela shipped $ */
3: G_PKG_NAME CONSTANT varchar2(30) :='IEM_EMAIL_ICNTR_MAPS_PVT ';
4:
5: PROCEDURE create_item (p_api_version_number IN NUMBER,

Line 3: G_PKG_NAME CONSTANT varchar2(30) :='IEM_EMAIL_ICNTR_MAPS_PVT ';

1: PACKAGE BODY IEM_EMAIL_ICNTR_MAPS_PVT as
2: /* $Header: iemvmapb.pls 115.5 2002/12/03 23:21:26 sboorela shipped $ */
3: G_PKG_NAME CONSTANT varchar2(30) :='IEM_EMAIL_ICNTR_MAPS_PVT ';
4:
5: PROCEDURE create_item (p_api_version_number IN NUMBER,
6: p_init_msg_list IN VARCHAR2 ,
7: p_commit IN VARCHAR2 ,

Line 67: SELECT iem_email_icntr_maps_s1.nextval

63: FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_EMAIL_ACCT_ID');
64: APP_EXCEPTION.RAISE_EXCEPTION;
65: END IF;
66: end if;
67: SELECT iem_email_icntr_maps_s1.nextval
68: INTO l_seq_id
69: FROM dual;
70: INSERT INTO iem_email_icntr_maps
71: (

Line 70: INSERT INTO iem_email_icntr_maps

66: end if;
67: SELECT iem_email_icntr_maps_s1.nextval
68: INTO l_seq_id
69: FROM dual;
70: INSERT INTO iem_email_icntr_maps
71: (
72: EMAIL_ICNTR_MAP_ID,
73: EMAIL_ACCOUNT_ID,
74: SERVER_GROUP_ID,

Line 199: DELETE FROM IEM_EMAIL_ICNTR_MAPS WHERE

195: -- Initialize API return status to SUCCESS
196: x_return_status := FND_API.G_RET_STS_SUCCESS;
197:
198: if p_email_icntr_map_id is not null then
199: DELETE FROM IEM_EMAIL_ICNTR_MAPS WHERE
200: EMAIL_ICNTR_MAP_ID = p_email_icntr_map_id ;
201: else
202: DELETE FROM IEM_EMAIL_ICNTR_MAPS WHERE
203: EMAIL_ACCOUNT_ID = p_email_account_id ;

Line 202: DELETE FROM IEM_EMAIL_ICNTR_MAPS WHERE

198: if p_email_icntr_map_id is not null then
199: DELETE FROM IEM_EMAIL_ICNTR_MAPS WHERE
200: EMAIL_ICNTR_MAP_ID = p_email_icntr_map_id ;
201: else
202: DELETE FROM IEM_EMAIL_ICNTR_MAPS WHERE
203: EMAIL_ACCOUNT_ID = p_email_account_id ;
204: end if;
205:
206: -- Standard Check Of p_commit.

Line 312: update iem_email_icntr_maps

308: APP_EXCEPTION.RAISE_EXCEPTION;
309: END IF;
310: end if;
311: if p_email_icntr_map_id is null then
312: update iem_email_icntr_maps
313: set server_group_id=decode(p_server_group_id,FND_API.G_MISS_NUM,null,null,server_group_id,p_server_group_id),
314: LAST_UPDATE_DATE = sysdate,
315: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY, null,last_updated_by,l_LAST_UPDATED_BY),
316: LAST_UPDATE_LOGIN = decode( l_LAST_UPDATE_LOGIN,null,last_update_login,l_LAST_UPDATE_LOGIN),

Line 334: update iem_email_icntr_maps

330: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE14, p_ATTRIBUTE14),
331: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE15, p_ATTRIBUTE15)
332: where EMAIL_ACCOUNT_ID=p_email_account_id;
333: else
334: update iem_email_icntr_maps
335: set EMAIL_ACCOUNT_ID=decode(p_email_account_id,FND_API.G_MISS_NUM,EMAIL_ACCOUNT_ID,p_email_account_id),
336: server_group_id=decode(p_server_group_id,FND_API.G_MISS_NUM,server_group_id,p_server_group_id),
337: LAST_UPDATE_DATE = sysdate,
338: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY, null,last_updated_by,l_LAST_UPDATED_BY),

Line 399: END IEM_EMAIL_ICNTR_MAPS_PVT ;

395: p_data => x_msg_data
396: );
397:
398: END update_item;
399: END IEM_EMAIL_ICNTR_MAPS_PVT ;