APPS.IEM_EMAIL_CATEGORY_MAPS_PVT dependencies on IEM_EMAIL_CATEGORY_MAPS

Line 1: PACKAGE BODY IEM_EMAIL_CATEGORY_MAPS_PVT as

1: PACKAGE BODY IEM_EMAIL_CATEGORY_MAPS_PVT as
2: /* $Header: iemvcatb.pls 115.8 2002/12/03 02:17:55 sboorela shipped $ */
3: G_PKG_NAME CONSTANT varchar2(30) :='IEM_EMAIL_CATEGORY_MAPS_PVT ';
4:
5: PROCEDURE create_item (p_api_version_number IN NUMBER,

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

1: PACKAGE BODY IEM_EMAIL_CATEGORY_MAPS_PVT as
2: /* $Header: iemvcatb.pls 115.8 2002/12/03 02:17:55 sboorela shipped $ */
3: G_PKG_NAME CONSTANT varchar2(30) :='IEM_EMAIL_CATEGORY_MAPS_PVT ';
4:
5: PROCEDURE create_item (p_api_version_number IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_commit IN VARCHAR2 := FND_API.G_FALSE,

Line 78: INSERT INTO iem_email_category_maps

74: IF l_cnt = 0 then
75: FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_KB_CAT_ID');
76: APP_EXCEPTION.RAISE_EXCEPTION;
77: END IF;
78: INSERT INTO iem_email_category_maps
79: (
80: EMAIL_ACCOUNT_ID,
81: KB_CATEGORY_ID,
82: CREATED_BY,

Line 201: DELETE FROM IEM_EMAIL_CATEGORY_MAPS

197: END IF;
198: -- Initialize API return status to SUCCESS
199: x_return_status := FND_API.G_RET_STS_SUCCESS;
200:
201: DELETE FROM IEM_EMAIL_CATEGORY_MAPS
202: where email_account_id=p_email_account_id
203: and kb_category_id=p_kb_category_id;
204:
205: -- Standard Check Of p_commit.

Line 246: END IEM_EMAIL_CATEGORY_MAPS_PVT ;

242: p_data => x_msg_data
243: );
244:
245: END delete_item;
246: END IEM_EMAIL_CATEGORY_MAPS_PVT ;