[Home] [Help]
PACKAGE: APPS.IEM_KB_CATEGORIES_PVT
Source
1 PACKAGE IEM_KB_CATEGORIES_PVT AUTHID CURRENT_USER as
2 /* $Header: iemvkbcs.pls 115.3 2002/12/02 23:52:32 sboorela shipped $ */
3
4 -- Start of Comments
5 -- API name : create_item
6 -- Type : Private
7 -- Function : This procedure create a record in the table IEM_KB_CATEGORIES
8 -- Pre-reqs : None.
9 -- Parameters :
10 -- IN
11 -- p_api_version_number IN NUMBER Required
12 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
13 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
14 -- p_kb_category_id NUMBER:=FND_API.G_MISS_NUM,
15 -- p_kb_parent_category_id IN VARCHAR2,
16 -- p_display_name IN VARCHAR2,
17 -- p_category_code IN VARCHAR2,
18 -- p_is_repos IN VARCHAR2,
19 -- p_category_order IN NUMBER,
20 -- p_category_desc IN varchar2:=FND_API.G_MISS_CHAR,
21 --
22 -- OUT
23 -- x_return_status OUT VARCHAR2
24 -- x_msg_count OUT NUMBER
25 -- x_msg_data OUT VARCHAR2
26 --
27 -- Version : 1.0
28 -- Notes :
29 --
30 -- End of comments
31 -- **********************************************************
32
33 PROCEDURE create_item (p_api_version_number IN NUMBER,
34 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
35 p_commit IN VARCHAR2 := FND_API.G_FALSE,
36 p_kb_category_id NUMBER,
37 p_kb_parent_category_id IN NUMBER,
38 p_display_name IN VARCHAR2,
39 p_category_code IN VARCHAR2,
40 p_is_repos IN VARCHAR2,
41 p_category_order IN NUMBER,
42 p_category_desc IN varchar2,
43 p_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
44 p_CREATION_DATE DATE:=SYSDATE,
45 p_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ,
46 p_LAST_UPDATE_DATE DATE:=SYSDATE,
47 p_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ,
48 p_ATTRIBUTE1 VARCHAR2,
49 p_ATTRIBUTE2 VARCHAR2,
50 p_ATTRIBUTE3 VARCHAR2,
51 p_ATTRIBUTE4 VARCHAR2,
52 p_ATTRIBUTE5 VARCHAR2,
53 p_ATTRIBUTE6 VARCHAR2,
54 p_ATTRIBUTE7 VARCHAR2,
55 p_ATTRIBUTE8 VARCHAR2,
56 p_ATTRIBUTE9 VARCHAR2,
57 p_ATTRIBUTE10 VARCHAR2,
58 p_ATTRIBUTE11 VARCHAR2,
59 p_ATTRIBUTE12 VARCHAR2,
60 p_ATTRIBUTE13 VARCHAR2,
61 p_ATTRIBUTE14 VARCHAR2,
62 p_ATTRIBUTE15 VARCHAR2,
63 x_return_status OUT NOCOPY VARCHAR2,
64 x_msg_count OUT NOCOPY NUMBER,
65 x_msg_data OUT NOCOPY VARCHAR2
66 );
67
68 -- Start of Comments
69 -- API name : delete_item
70 -- Type : Private
71 -- Function : This procedure delete a record in the table IEM_KB_CATEGORIES
72 -- Pre-reqs : None.
73 -- Parameters :
74 -- IN
75 -- p_api_version_number IN NUMBER Required
76 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
77 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
78 -- p_kb_category_id in NUMBER:=FND_API.G_MISS_NUM,
79 -- p_kb_parent_category_id IN NUMBER:=FND_API.G_MISS_NUM,
80 -- p_display_name IN VARCHAR2 :=FND_API.G_MISS_CHAR,
81 --
82 -- OUT
83 -- x_return_status OUT VARCHAR2
84 -- x_msg_count OUT NUMBER
85 -- x_msg_data OUT VARCHAR2
86 --
87 -- Version : 1.0
88 -- Notes :
89 --
90 -- End of comments
91 -- **********************************************************
92
93 PROCEDURE delete_item (p_api_version_number IN NUMBER,
94 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
95 p_commit IN VARCHAR2 := FND_API.G_FALSE,
96 p_kb_category_id in NUMBER,
97 p_kb_parent_category_id IN NUMBER,
98 p_display_name IN VARCHAR2 ,
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_msg_data OUT NOCOPY VARCHAR2
102 );
103 -- Start of Comments
104 -- API name : update_item
105 -- Type : Private
106 -- Function : This procedure update a record in the table IEM_KB_CATEGORIES
107 -- Pre-reqs : None.
108 -- Parameters :
109 -- IN
110 -- p_api_version_number IN NUMBER Required
111 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
112 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
113 -- p_kb_category_id IN NUMBER:=FND_API.G_MISS_NUM,
114 -- p_kb_parent_category_id IN number:=FND_API.G_MISS_NUM,
115 -- p_display_name IN varchar2:=FND_API.G_MISS_CHAR,
116 -- p_category_code IN varchar2:=FND_API.G_MISS_CHAR,
117 -- p_is_repos IN VARCHAR2:=FND_API.G_MISS_CHAR,
118 -- p_category_order IN number:=FND_API.G_MISS_CHAR,
119 -- p_category_desc varchar2:=FND_API.G_MISS_CHAR,
120 --
121 -- OUT
122 -- x_return_status OUT VARCHAR2
123 -- x_msg_count OUT NUMBER
124 -- x_msg_data OUT VARCHAR2
125 --
126 -- Version : 1.0
127 -- Notes :
128 --
129 -- End of comments
130 -- **********************************************************
131
132 PROCEDURE update_item (p_api_version_number IN NUMBER,
133 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
134 p_commit IN VARCHAR2 := FND_API.G_FALSE,
135 p_kb_category_id IN NUMBER,
136 p_kb_parent_category_id IN number,
137 p_display_name IN varchar2,
138 p_category_code IN varchar2,
139 p_is_repos IN VARCHAR2,
140 p_category_order IN number,
141 p_category_desc varchar2,
142 p_CREATED_BY NUMBER,
143 p_CREATION_DATE DATE,
144 p_LAST_UPDATED_BY NUMBER,
145 p_LAST_UPDATE_DATE DATE,
146 p_LAST_UPDATE_LOGIN NUMBER,
147 p_ATTRIBUTE1 VARCHAR2,
148 p_ATTRIBUTE2 VARCHAR2,
149 p_ATTRIBUTE3 VARCHAR2,
150 p_ATTRIBUTE4 VARCHAR2,
151 p_ATTRIBUTE5 VARCHAR2,
152 p_ATTRIBUTE6 VARCHAR2,
153 p_ATTRIBUTE7 VARCHAR2,
154 p_ATTRIBUTE8 VARCHAR2,
155 p_ATTRIBUTE9 VARCHAR2,
156 p_ATTRIBUTE10 VARCHAR2,
157 p_ATTRIBUTE11 VARCHAR2,
158 p_ATTRIBUTE12 VARCHAR2,
159 p_ATTRIBUTE13 VARCHAR2,
160 p_ATTRIBUTE14 VARCHAR2,
161 p_ATTRIBUTE15 VARCHAR2,
162 x_return_status OUT NOCOPY VARCHAR2,
163 x_msg_count OUT NOCOPY NUMBER,
164 x_msg_data OUT NOCOPY VARCHAR2
165 );
166 END IEM_KB_CATEGORIES_PVT;