9: -- Pre-reqs : None.
10: -- Parameters :
11: -- IN
12: -- p_api_version_number IN NUMBER Required
13: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
14: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
15: -- p_email_account_id IN NUMBER,
16: -- p_email_cat_id IN NUMBER,
17: -- p_is_repos IN VARCHAR2,
10: -- Parameters :
11: -- IN
12: -- p_api_version_number IN NUMBER Required
13: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
14: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
15: -- p_email_account_id IN NUMBER,
16: -- p_email_cat_id IN NUMBER,
17: -- p_is_repos IN VARCHAR2,
18: --
27: -- End of comments
28: -- **********************************************************
29:
30: PROCEDURE create_item (p_api_version_number IN NUMBER,
31: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
32: p_commit IN VARCHAR2 := FND_API.G_FALSE,
33: p_email_account_id IN NUMBER,
34: p_kb_category_id IN NUMBER,
35: p_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
28: -- **********************************************************
29:
30: PROCEDURE create_item (p_api_version_number IN NUMBER,
31: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
32: p_commit IN VARCHAR2 := FND_API.G_FALSE,
33: p_email_account_id IN NUMBER,
34: p_kb_category_id IN NUMBER,
35: p_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
36: p_CREATION_DATE DATE:=SYSDATE,
64: -- Pre-reqs : None.
65: -- Parameters :
66: -- IN
67: -- p_api_version_number IN NUMBER Required
68: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
69: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
70: -- p_email_account_id IN NUMBER,
71: -- p_email_cat_id IN NUMBER,
72: -- p_is_repos IN VARCHAR2,
65: -- Parameters :
66: -- IN
67: -- p_api_version_number IN NUMBER Required
68: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
69: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
70: -- p_email_account_id IN NUMBER,
71: -- p_email_cat_id IN NUMBER,
72: -- p_is_repos IN VARCHAR2,
73: --
82: -- End of comments
83: -- **********************************************************
84:
85: PROCEDURE delete_item (p_api_version_number IN NUMBER,
86: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
87: p_commit IN VARCHAR2 := FND_API.G_FALSE,
88: p_email_account_id IN NUMBER,
89: p_kb_category_id IN NUMBER,
90: x_return_status OUT NOCOPY VARCHAR2,
83: -- **********************************************************
84:
85: PROCEDURE delete_item (p_api_version_number IN NUMBER,
86: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
87: p_commit IN VARCHAR2 := FND_API.G_FALSE,
88: p_email_account_id IN NUMBER,
89: p_kb_category_id IN NUMBER,
90: x_return_status OUT NOCOPY VARCHAR2,
91: x_msg_count OUT NOCOPY NUMBER,