APPS.IEM_KB_CATEGORIES_PVT dependencies on IEM_KB_CATEGORIES

Line 1: PACKAGE BODY IEM_KB_CATEGORIES_PVT as

1: PACKAGE BODY IEM_KB_CATEGORIES_PVT as
2: /* $Header: iemvkbcb.pls 115.3 2002/12/02 23:52:40 sboorela shipped $ */
3:
4: G_PKG_NAME CONSTANT varchar2(30) :='IEM_KB_CATEGORIES_PVT ';
5:

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

1: PACKAGE BODY IEM_KB_CATEGORIES_PVT as
2: /* $Header: iemvkbcb.pls 115.3 2002/12/02 23:52:40 sboorela shipped $ */
3:
4: G_PKG_NAME CONSTANT varchar2(30) :='IEM_KB_CATEGORIES_PVT ';
5:
6: PROCEDURE create_item (p_api_version_number IN NUMBER,
7: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8: p_commit IN VARCHAR2 := FND_API.G_FALSE,

Line 67: SELECT IEM_KB_CATEGORIES_s1.nextval

63: END IF;
64: -- Initialize API return status to SUCCESS
65: x_return_status := FND_API.G_RET_STS_SUCCESS;
66:
67: SELECT IEM_KB_CATEGORIES_s1.nextval
68: INTO l_seq_id
69: FROM dual;
70:
71: INSERT INTO IEM_KB_CATEGORIES

Line 71: INSERT INTO IEM_KB_CATEGORIES

67: SELECT IEM_KB_CATEGORIES_s1.nextval
68: INTO l_seq_id
69: FROM dual;
70:
71: INSERT INTO IEM_KB_CATEGORIES
72: (
73: KB_CATEGORY_ID,
74: KB_PARENT_CATEGORY_ID,
75: DISPLAY_NAME ,

Line 202: DELETE FROM IEM_KB_CATEGORIES

198: -- Initialize API return status to SUCCESS
199: x_return_status := FND_API.G_RET_STS_SUCCESS;
200:
201: IF p_kb_category_id =FND_API.G_MISS_NUM THEN
202: DELETE FROM IEM_KB_CATEGORIES
203: WHERE display_name=p_display_name AND
204: kb_parent_category_id=p_kb_parent_category_id;
205: else
206: DELETE FROM IEM_KB_CATEGORIES

Line 206: DELETE FROM IEM_KB_CATEGORIES

202: DELETE FROM IEM_KB_CATEGORIES
203: WHERE display_name=p_display_name AND
204: kb_parent_category_id=p_kb_parent_category_id;
205: else
206: DELETE FROM IEM_KB_CATEGORIES
207: where kb_category_id=p_kb_category_id;
208: end if;
209:
210: -- Standard Check Of p_commit.

Line 310: update IEM_KB_CATEGORIES

306: END IF;
307: -- Initialize API return status to SUCCESS
308: x_return_status := FND_API.G_RET_STS_SUCCESS;
309:
310: update IEM_KB_CATEGORIES
311: set kb_parent_category_id=decode(p_kb_parent_category_id,FND_API.G_MISS_NUM,kb_parent_category_id,p_kb_parent_category_id),
312: display_name=decode(p_display_name,FND_API.G_MISS_CHAR,display_name,p_display_name),
313: category_code=decode(p_category_code,FND_API.G_MISS_CHAR,category_code,p_category_code),
314: is_repository=decode(p_is_repos,FND_API.G_MISS_CHAR,is_repository,p_is_repos),

Line 378: END IEM_KB_CATEGORIES_PVT ;

374: p_data => x_msg_data
375: );
376:
377: END update_item;
378: END IEM_KB_CATEGORIES_PVT ;