[Home] [Help]
PACKAGE: APPS.AMS_ACTRESOURCE_PUB
Source
1 PACKAGE AMS_ActResource_PUB AUTHID CURRENT_USER as
2 /*$Header: amsprscs.pls 115.3 2002/12/11 03:43:17 ptendulk ship $*/
3
4 /*****************************************************************************************/
5 --
6 -- NAME
7 -- AMS_ActResource_PUB
8 --
9 -- Procedures:
10 -- Create_Act_Resource (see below for specification)
11 -- Update_Act_Resource (see below for specification)
12 -- Delete_Act_Resource (see below for specification)
13 -- Lock_Act_Resource (see below for specification)
14 -- Validate_Act_Resource (see below for specification)
15 --
16 -- NOTES
17 --
18 -- History created gmadana 28-Mar-2002
19 --
20 /*****************************************************************************************/
21
22 -- Default number of records fetch per call
23 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
24
25 --===================================================================
26 -- Start of Comments
27 -- -------------------------------------------------------
28 -- Record name
29 -- Act_Resource_rec_type
30 -- -------------------------------------------------------
31 -- Parameters:
32 -- row_id
33 -- activity_resource_id
34 -- last_update_date
35 -- last_updated_by
36 -- creation_date
37 -- created_by
38 -- last_update_login
39 -- object_version_number
40 -- act_resource_used_by_id
41 -- arc_act_resource_used_by
42 -- resource_id
43 -- role_cd
44 -- user_status_id
45 -- system_status_code
46 -- start_date_time
47 -- end_date_time
48 -- primary_flag
49 -- description
50 -- attribute_category
51 -- attribute1
52 -- attribute2
53 -- attribute3
54 -- attribute4
55 -- attribute5
56 -- attribute6
57 -- attribute7
58 -- attribute8
59 -- attribute9
60 -- attribute10
61 -- attribute11
62 -- attribute12
63 -- attribute13
64 -- attribute14
65 -- attribute15
66 --
67 -- Required
68 --
69 -- Defaults
70 --
71 -- Note: This is automatic generated record definition, it includes all columns
72 -- defined in the table, developer must manually add or delete some of
73 -- the attributes.
74 --
75 -- End of Comments
76
77 --===================================================================
78
79 TYPE Act_Resource_rec_type
80 IS RECORD
81 (
82 ACTIVITY_RESOURCE_ID NUMBER,
83 LAST_UPDATE_DATE DATE,
84 LAST_UPDATED_BY NUMBER,
85 CREATION_DATE DATE,
86 CREATED_BY NUMBER,
87 LAST_UPDATE_LOGIN NUMBER,
88 OBJECT_VERSION_NUMBER NUMBER,
89 ACT_RESOURCE_USED_BY_ID NUMBER,
90 ARC_ACT_RESOURCE_USED_BY VARCHAR2(30),
91 RESOURCE_ID NUMBER,
92 ROLE_CD VARCHAR2(30),
93 USER_STATUS_ID NUMBER,
94 SYSTEM_STATUS_CODE VARCHAR2(30),
95 START_DATE_TIME DATE,
96 END_DATE_TIME DATE,
97 PRIMARY_FLAG VARCHAR2(30),
98 DESCRIPTION VARCHAR2(4000),
99 ATTRIBUTE_CATEGORY VARCHAR2(30),
100 ATTRIBUTE1 VARCHAR2(150),
101 ATTRIBUTE2 VARCHAR2(150),
102 ATTRIBUTE3 VARCHAR2(150),
103 ATTRIBUTE4 VARCHAR2(150),
104 ATTRIBUTE5 VARCHAR2(150),
105 ATTRIBUTE6 VARCHAR2(150),
106 ATTRIBUTE7 VARCHAR2(150),
107 ATTRIBUTE8 VARCHAR2(150),
108 ATTRIBUTE9 VARCHAR2(150),
109 ATTRIBUTE10 VARCHAR2(150),
110 ATTRIBUTE11 VARCHAR2(150),
111 ATTRIBUTE12 VARCHAR2(150),
112 ATTRIBUTE13 VARCHAR2(150),
113 ATTRIBUTE14 VARCHAR2(150),
114 ATTRIBUTE15 VARCHAR2(150)
115 );
116
117 g_miss_Act_Resource_rec_type Act_Resource_rec_type;
118 TYPE Act_Resource_rec_tbl IS TABLE OF Act_Resource_rec_type INDEX BY BINARY_INTEGER;
119 g_miss_resource_tbl Act_Resource_rec_tbl;
120
121 TYPE resource_sort_rec_type IS RECORD
122 (
123 -- Please define your own sort by record here.
124 activity_resource_id NUMBER := NULL
125 );
126
127 -- ==============================================================================
128 -- Start of Comments
129 -- ==============================================================================
130 -- API Name
131 -- Create_Act_Resource
132 -- Type
133 -- Public
134 -- Pre-Req
135 --
136 -- Parameters
137 --
138 -- IN
139 -- p_api_version_number IN NUMBER Required
140 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
141 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
142 -- p_Act_Resource_rec IN Act_Resource_rec_type Required
143 --
144 -- OUT
145 -- x_return_status OUT VARCHAR2
146 -- x_msg_count OUT NUMBER
147 -- x_msg_data OUT VARCHAR2
148 -- Version : Current version 1.0
149 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
150 -- and basic operation, developer must manually add parameters and business logic as necessary.
151 --
152 -- End of Comments
153 -- ==============================================================================
154
155 PROCEDURE Create_Act_Resource
156 ( p_api_version IN NUMBER,
157 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
158 p_commit IN VARCHAR2 := FND_API.G_FALSE,
159 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
160
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2,
164
165 p_Act_Resource_rec IN Act_Resource_rec_type,
166 x_Act_Resource_id OUT NOCOPY NUMBER
167 );
168
169 -- ==============================================================================
170 -- Start of Comments
171 -- ==============================================================================
172 -- API Name
173 -- Update_Act_Resource
174 -- Type
175 -- Public
176 -- Pre-Req
177 --
178 -- Parameters
179 --
180 -- IN
181 -- p_api_version_number IN NUMBER Required
182 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
183 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
184 -- p_Act_Resource_rec IN Act_Resource_rec_type Required
185 --
186 -- OUT
187 -- x_return_status OUT VARCHAR2
188 -- x_msg_count OUT NUMBER
189 -- x_msg_data OUT VARCHAR2
190 -- Version : Current version 1.0
191 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
192 -- and basic operation, developer must manually add parameters and business logic as necessary.
193 --
194 -- End of Comments
195 -- ==============================================================================
196
197 PROCEDURE Update_Act_Resource
198 ( p_api_version IN NUMBER,
199 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
200 p_commit IN VARCHAR2 := FND_API.G_FALSE,
201 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
202 x_return_status OUT NOCOPY VARCHAR2,
203 x_msg_count OUT NOCOPY NUMBER,
204 x_msg_data OUT NOCOPY VARCHAR2,
205 p_Act_Resource_rec IN Act_Resource_rec_type
206 );
207
208 -- ==============================================================================
209 -- Start of Comments
210 -- ==============================================================================
211 -- API Name
212 -- Delete_Act_Resource
213 -- Type
214 -- Public
215 -- Pre-Req
216 --
217 -- Parameters
218 --
219 -- IN
220 -- p_api_version_number IN NUMBER Required
221 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
222 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
223 -- p_Act_Resource_id IN NUMBER
224 -- p_object_version_number IN NUMBER Optional Default = NULL
225 --
226 -- OUT
227 -- x_return_status OUT VARCHAR2
228 -- x_msg_count OUT NUMBER
229 -- x_msg_data OUT VARCHAR2
230 -- Version : Current version 1.0
231 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
232 -- and basic operation, developer must manually add parameters and business logic as necessary.
233 --
234 -- End of Comments
235 -- ==============================================================================
236
237 PROCEDURE Delete_Act_Resource
238 ( p_api_version IN NUMBER,
239 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
240 p_commit IN VARCHAR2 := FND_API.G_FALSE,
241 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
242 x_return_status OUT NOCOPY VARCHAR2,
243 x_msg_count OUT NOCOPY NUMBER,
244 x_msg_data OUT NOCOPY VARCHAR2,
245
246 p_Act_Resource_id IN NUMBER,
247 p_object_version IN NUMBER
248 );
249
250
251 -- ==============================================================================
252 -- Start of Comments
253 -- ==============================================================================
254 -- API Name
255 -- Lock_Act_Resource
256 -- Type
257 -- Public
258 -- Pre-Req
259 --
260 -- Parameters
261 --
262 -- IN
263 -- p_api_version_number IN NUMBER Required
264 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
265 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
266 -- p_Act_Resource_id IN NUMBER Required
267 --
268 -- OUT
269 -- x_return_status OUT VARCHAR2
270 -- x_msg_count OUT NUMBER
271 -- x_msg_data OUT VARCHAR2
272 -- Version : Current version 1.0
273 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
274 -- and basic operation, developer must manually add parameters and business logic as necessary.
275 --
276 -- End of Comments
277 -- ==============================================================================
278
279 PROCEDURE Lock_Act_Resource
280 ( p_api_version IN NUMBER,
281 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
282 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
283 x_return_status OUT NOCOPY VARCHAR2,
284 x_msg_count OUT NOCOPY NUMBER,
285 x_msg_data OUT NOCOPY VARCHAR2,
286
287 p_Act_Resource_id IN NUMBER,
288 p_object_version IN NUMBER
289 );
293 --
290
291 /*****************************************************************************************/
292 -- Start of Comments
294 -- API name : Validate_Act_Resource
295 -- Type : Public
296 -- Function : Validate a row in AMS_ACT_RESOURCES table
297 --
298 -- Paramaeters :
299 --
300 -- IN :
301 -- p_api_version IN NUMBER Required
302 -- p_init_msg_list IN VARCHAR2 Optional Default := FND_API.G_FALSE
303 -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
304 -- p_Resource_rec IN Act_Resource_rec_type Required
305 --
306 -- OUT
307 -- x_return_status OUT VARCHAR2(1)
308 -- x_msg_count OUT NUMBER
309 -- x_msg_data OUT VARCHAR2(2000)
310 --
311 /*****************************************************************************************/
312
313 PROCEDURE Validate_Act_Resource
314 ( p_api_version IN NUMBER,
315 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
316 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
317 x_return_status OUT NOCOPY VARCHAR2,
318 x_msg_count OUT NOCOPY NUMBER,
319 x_msg_data OUT NOCOPY VARCHAR2,
320 p_Act_Resource_rec IN Act_Resource_rec_type
321 );
322
323
324 END AMS_ActResource_PUB;