APPS.IEM_RT_PREPROC_EMAILS_PVT dependencies on IEM_RT_PREPROC_EMAILS

Line 1: PACKAGE BODY iem_Rt_preproc_emails_pvt as

1: PACKAGE BODY iem_Rt_preproc_emails_pvt as
2: /* $Header: iemprepb.pls 120.0 2005/06/02 14:04:07 appldev noship $ */
3:
4: G_PKG_NAME CONSTANT varchar2(30) :='iem_Rt_preproc_emails_pvt ';
5:

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

1: PACKAGE BODY iem_Rt_preproc_emails_pvt as
2: /* $Header: iemprepb.pls 120.0 2005/06/02 14:04:07 appldev noship $ */
3:
4: G_PKG_NAME CONSTANT varchar2(30) :='iem_Rt_preproc_emails_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 38: INSERT INTO IEM_RT_PREPROC_EMAILS (

34: THEN
35: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
36: END IF;
37: x_return_status := FND_API.G_RET_STS_SUCCESS;
38: INSERT INTO IEM_RT_PREPROC_EMAILS (
39: MESSAGE_ID ,
40: email_account_id ,
41: PRIORITY ,
42: RECEIVED_DATE,

Line 122: delete from IEM_RT_PREPROC_EMAILS

118: THEN
119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
120: END IF;
121: x_return_status := FND_API.G_RET_STS_SUCCESS;
122: delete from IEM_RT_PREPROC_EMAILS
123: where message_id=p_message_id;
124:
125: -- Standard Check Of p_commit.
126: IF p_commit='T' THEN

Line 166: END iem_Rt_preproc_emails_pvt ;

162: p_data => x_msg_data
163: );
164:
165: END delete_item;
166: END iem_Rt_preproc_emails_pvt ;