APPS.IEM_KB_RESULTS_PVT dependencies on IEM_KB_RESULTS

Line 1: PACKAGE BODY IEM_KB_RESULTS_PVT as

1: PACKAGE BODY IEM_KB_RESULTS_PVT as
2: /* $Header: iemvkbrb.pls 120.0 2005/06/02 13:47:36 appldev noship $ */
3:
4: G_PKG_NAME CONSTANT varchar2(30) :='IEM_KB_RESULTS_PVT ';
5:

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

1: PACKAGE BODY IEM_KB_RESULTS_PVT as
2: /* $Header: iemvkbrb.pls 120.0 2005/06/02 13:47:36 appldev noship $ */
3:
4: G_PKG_NAME CONSTANT varchar2(30) :='IEM_KB_RESULTS_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 67: SELECT IEM_KB_RESULTS_s1.nextval

63: FND_MSG_PUB.initialize;
64: END IF;
65: -- Initialize API return status to SUCCESS
66: x_return_status := FND_API.G_RET_STS_SUCCESS;
67: SELECT IEM_KB_RESULTS_s1.nextval
68: INTO l_seq_id
69: FROM dual;
70:
71: Select count(*) into l_grp_cnt from iem_mstemail_accounts

Line 79: INSERT INTO IEM_KB_RESULTS

75: FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_EMAIL_ACCT_ID');
76: APP_EXCEPTION.RAISE_EXCEPTION;
77: END IF;
78:
79: INSERT INTO IEM_KB_RESULTS
80: (
81: KB_RESULT_ID,
82: MESSAGE_ID ,
83: CLASSIFICATION_ID,

Line 221: DELETE FROM IEM_KB_RESULTS

217: END IF;
218: -- Initialize API return status to SUCCESS
219: x_return_status := FND_API.G_RET_STS_SUCCESS;
220:
221: DELETE FROM IEM_KB_RESULTS
222: where kb_delete='Y';
223:
224: -- Standard Check Of p_commit.
225: IF FND_API.To_Boolean(p_commit) THEN

Line 319: UPDATE IEM_KB_RESULTS

315: FND_MSG_PUB.initialize;
316: END IF;
317: -- Initialize API return status to SUCCESS
318: x_return_status := FND_API.G_RET_STS_SUCCESS;
319: UPDATE IEM_KB_RESULTS
320: set kb_delete='Y'
321: where kb_result_id=p_kb_result_id ;
322:
323: -- Standard Check Of p_commit.

Line 364: END IEM_KB_RESULTS_PVT ;

360: p_data => x_msg_data
361: );
362:
363: END update_item;
364: END IEM_KB_RESULTS_PVT ;