[Home] [Help]
PACKAGE: APPS.AMS_ACTCATEGORY_PVT
Source
1 PACKAGE AMS_ActCategory_PVT AS
2 /*$Header: amsvacts.pls 120.1 2005/06/15 01:31:17 appldev $*/
3 -- Start of Comments
4 --
5 -- NAME
6 -- AMS_ActCategory_PVT
7 --
8 -- PURPOSE
9 -- This package is a Private API for managing Activity Category information in
10 -- AMS.
11 --
12 -- Procedures:
13 -- Create_Act_Category (see below for specification)
14 -- Update_Act_Category (see below for specification)
15 -- Delete_Act_Category (see below for specification)
16 -- Lock_Act_Category (see below for specification)
17 -- Validate_Act_Category (see below for specification)
18 -- Validate_Act_Cty_Items (see below for specification)
19 -- Validate_Act_Cty_Record (see below for specification
20 --
21 -- NOTES
22 --
23 -- History created sugupta 11/8/99
24 --
25 -- End of Comments
26
27 -- global constants
28
29 TYPE act_category_rec_type
30 IS RECORD
31 (
32 ACTIVITY_CATEGORY_ID NUMBER, -- PK
33 LAST_UPDATE_DATE DATE,
34 LAST_UPDATED_BY NUMBER ,
35 CREATION_DATE DATE ,
36 CREATED_BY NUMBER ,
37 LAST_UPDATE_LOGIN NUMBER ,
38 OBJECT_VERSION_NUMBER NUMBER,
39 ACT_CATEGORY_USED_BY_ID NUMBER,
40 ARC_ACT_CATEGORY_USED_BY VARCHAR2(30),
41 CATEGORY_ID NUMBER,
42 ATTRIBUTE_CATEGORY VARCHAR2(30),
43 ATTRIBUTE1 VARCHAR2(150),
44 ATTRIBUTE2 VARCHAR2(150),
45 ATTRIBUTE3 VARCHAR2(150),
46 ATTRIBUTE4 VARCHAR2(150),
47 ATTRIBUTE5 VARCHAR2(150),
48 ATTRIBUTE6 VARCHAR2(150),
49 ATTRIBUTE7 VARCHAR2(150),
50 ATTRIBUTE8 VARCHAR2(150),
51 ATTRIBUTE9 VARCHAR2(150),
52 ATTRIBUTE10 VARCHAR2(150),
53 ATTRIBUTE11 VARCHAR2(150),
54 ATTRIBUTE12 VARCHAR2(150),
55 ATTRIBUTE13 VARCHAR2(150),
56 ATTRIBUTE14 VARCHAR2(150),
57 ATTRIBUTE15 VARCHAR2(150)
58 );
59
60 PROCEDURE Create_Act_Category
61 ( p_api_version IN NUMBER,
62 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
63 p_commit IN VARCHAR2 := FND_API.G_FALSE,
64 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2,
68
69 p_act_category_rec IN act_category_rec_type,
70 x_act_category_id OUT NOCOPY NUMBER
71 );
72
73 /****************************************************************************/
74 -- Start of Comments
75 --
76 -- API name : Update_Act_Categories
77 -- Type : Private
78 -- Function : Update a row in AMS_ACT_CATEGORIES table
79 --
80 -- Pre-reqs : None
81 -- Paramaeters :
82 -- IN :
83 -- standard IN parameters
84 -- p_api_version IN NUMBER := NULL Required
85 -- p_init_msg_list IN VARCHAR2 Optional
86 -- p_commit IN VARCHAR2 := FND_API.G_FALSE Optional
87 -- p_validation_level IN NUMBER
88 -- := FND_API.G_VALID_LEVEL_FULL,
89 -- API's IN parameters
90 --
91 -- p_act_category_rec IN Act_category_rec_type
92 --
93 -- OUT :
94 -- standard OUT parameters
95 -- x_return_status OUT VARCHAR2(1)
96 -- x_msg_count OUT NUMBER
97 -- x_msg_data OUT VARCHAR2(2000)
98 --
99 -- Version : Current version 1.0
100 -- Initial version 1.0
101 --
102 -- Note : 1. p_act_Category_rec.act_category_id is a required parameter
103 -- 2. p_act_Category_rec.act_category_id is not updatable
104 --
105 -- End Of Comments
106
107 PROCEDURE Update_Act_Category
108 ( p_api_version IN NUMBER,
109 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
110 p_commit IN VARCHAR2 := FND_API.G_FALSE,
111 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
112 x_return_status OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER,
114 x_msg_data OUT NOCOPY VARCHAR2,
115
116 p_act_category_rec IN Act_category_rec_type
117 );
118
119 /*****************************************************************************************/
120 -- Start of Comments
121 --
122 -- API name : Delete_Act_Category
123 -- Type : Private
124 -- Function : Delete a row in AMS_ACT_CATEGORIES table
125 --
126 -- Pre-reqs : None
127 -- Paramaeters :
128 -- IN :
129 -- standard IN parameters
130 -- p_api_version IN NUMBER := NULL Required
131 -- p_init_msg_list IN VARCHAR2 Optional
132 -- Default := FND_API.G_FALSE
133 -- p_commit IN VARCHAR2 := FND_API.G_FALSE Optional
134 -- p_validation_level IN NUMBER
135 -- := FND_API.G_VALID_LEVEL_FULL,
136 -- API's IN parameters
137 -- p_act_Category_rec IN Act_category_rec_type Required
138 --
139 -- standard OUT parameters
140 -- x_return_status OUT VARCHAR2(1)
141 -- x_msg_count OUT NUMBER
142 -- x_msg_data OUT VARCHAR2(2000)
143 --
144 -- Version : Current version 1.0
145 -- Initial version 1.0
146 --
147 -- Note : 1. p_Category_rec.act_category_id is a required parameter
148 --
149 -- End Of Comments
150
151 PROCEDURE Delete_Act_Category
152 ( p_api_version IN NUMBER,
153 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
154 p_commit IN VARCHAR2 := FND_API.G_FALSE,
155 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
156 x_return_status OUT NOCOPY VARCHAR2,
157 x_msg_count OUT NOCOPY NUMBER,
158 x_msg_data OUT NOCOPY VARCHAR2,
159
160 p_act_category_id IN NUMBER,
161 p_object_version IN NUMBER
162 );
163
164
165 /*****************************************************************************************/
166 -- Start of Comments
167 --
168 -- API name : Lock_Act_Categories
169 -- Type : Private
170 -- Function : Lock a row in AMS_ACT_CATEGORIES table
171 --
172 -- Pre-reqs : None
173 -- Paramaeters :
174 -- IN :
175 -- standard IN parameters
176 -- p_api_version IN NUMBER := NULL Required
177 -- p_init_msg_list IN VARCHAR2 Optional
178 -- Default := FND_API.G_FALSE
179 -- p_validation_level IN NUMBER
180 -- := FND_API.G_VALID_LEVEL_FULL,
181 -- API's IN parameters
182 -- p_Category_rec IN Act_category_rec_type Required
183 -- OUT :
184 -- standard OUT parameters
185 -- x_return_status OUT VARCHAR2(1)
186 -- x_msg_count OUT NUMBER
187 -- x_msg_data OUT VARCHAR2(2000)
188 --
189 --
190 -- Version : Current version 1.0
191 -- Initial version 1.0
192 --
193 -- Note : p_Category_rec.act_category_id is a required parameter
194 --
195 -- End Of Comments
196
197 PROCEDURE Lock_Act_Category
198 ( p_api_version IN NUMBER,
199 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
200 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
201 x_return_status OUT NOCOPY VARCHAR2,
202 x_msg_count OUT NOCOPY NUMBER,
203 x_msg_data OUT NOCOPY VARCHAR2,
204
205 p_act_category_id IN NUMBER,
206 p_object_version IN NUMBER
207 );
208
209 /*****************************************************************************************/
210 -- Start of Comments
211 --
212 -- API name : Validate_Act_Categories
213 -- Type : Private
214 -- Function : Validate a row in AMS_ACT_CATEGORIES table
215 --
216 -- Pre-reqs : None
217 -- Paramaeters :
218 -- IN :
219 -- standard IN parameters
220 -- p_api_version IN NUMBER := NULL Required
221 -- p_init_msg_list IN VARCHAR2 Optional
222 -- Default := FND_API.G_FALSE
223 -- p_validation_level IN NUMBER
224 -- := FND_API.G_VALID_LEVEL_FULL,
225 -- API's IN parameters
226 --
227 -- p_Category_rec IN Act_category_rec_type Required
228 --
229 -- standard OUT parameters
230 -- x_return_status OUT VARCHAR2(1)
231 -- x_msg_count OUT NUMBER
232 -- x_msg_data OUT VARCHAR2(2000)
233 --
234 -- Version : Current version 1.0
235 -- Initial version 1.0
236 --
237 -- Note : 1. p_Category_rec.act_category_id is a required parameter
238 -- 2. x_return_status will be FND_API.G_RET_STS_SUCCESS, FND_API.G_RET_STS_ERROR, or
239 -- FND_API.G_RET_STS_UNEXP_ERROR
240 --
241 -- End Of Comments
242
243 PROCEDURE Validate_Act_Category
244 ( p_api_version IN NUMBER,
245 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
246 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
247 x_return_status OUT NOCOPY VARCHAR2,
248 x_msg_count OUT NOCOPY NUMBER,
249 x_msg_data OUT NOCOPY VARCHAR2,
250
251 p_act_category_rec IN act_category_rec_type
252 );
253
254 PROCEDURE Validate_Act_Cty_Items
255 ( p_act_category_rec IN act_category_rec_type,
256 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
257 x_return_status OUT NOCOPY VARCHAR2
258 );
259
260 PROCEDURE Validate_Act_Cty_Record
261 (
262 p_act_category_rec IN act_category_rec_type,
263 x_return_status OUT NOCOPY VARCHAR2
264 );
265
266 PROCEDURE complete_act_category_rec(
267 p_act_category_rec IN act_category_rec_type,
268 x_act_category_rec OUT NOCOPY act_category_rec_type
269 );
270
271 END AMS_ActCategory_PVT;