[Home] [Help]
PACKAGE: APPS.AMS_ACTRESOURCE_PVT
Source
1 PACKAGE AMS_ActResource_PVT AUTHID CURRENT_USER as
2 /*$Header: amsvrscs.pls 115.11 2002/11/22 23:37:33 dbiswas ship $*/
3
4 /*****************************************************************************************/
5 --
6 -- NAME
7 -- AMS_ActResource_PVT
8 --
9 -- PURPOSE
10 -- This package is a Private API for managing Product information in
11 -- AMS.
12 --
13 -- Procedures:
14 -- Create_Act_Resource (see below for specification)
15 -- Update_Act_Resource (see below for specification)
16 -- Delete_Act_Resource (see below for specification)
17 -- Lock_Act_Resource (see below for specification)
18 -- Validate_Act_Resource (see below for specification)
19 -- Validate_Act_Resource_Items (see below for specification)
20 -- Validate_Act_Rsc_Record (see below for specification
21 --
22 -- NOTES
23 --
24 -- History created rvaka 28-DEC-1999
25 --
26 /*****************************************************************************************/
27
28 -- global constants
29
30 TYPE Act_Resource_rec_type
31 IS RECORD
32 (
33 ACTIVITY_RESOURCE_ID NUMBER,
34 LAST_UPDATE_DATE DATE,
35 LAST_UPDATED_BY NUMBER,
36 CREATION_DATE DATE,
37 CREATED_BY NUMBER,
38 LAST_UPDATE_LOGIN NUMBER,
39 OBJECT_VERSION_NUMBER NUMBER,
40 ACT_RESOURCE_USED_BY_ID NUMBER,
41 ARC_ACT_RESOURCE_USED_BY VARCHAR2(30),
42 RESOURCE_ID NUMBER,
43 ROLE_CD VARCHAR2(30),
44 USER_STATUS_ID NUMBER,
45 SYSTEM_STATUS_CODE VARCHAR2(30),
46 START_DATE_TIME DATE,
47 END_DATE_TIME DATE,
48 PRIMARY_FLAG VARCHAR2(30),
49 DESCRIPTION VARCHAR2(4000),
50 --TOP_LEVEL_PARTEN_ID NUMBER,
51 --TOP_LEVEL_PARENT_TYPE VARCHAR2(30),
52 ATTRIBUTE_CATEGORY VARCHAR2(30),
53 ATTRIBUTE1 VARCHAR2(150),
54 ATTRIBUTE2 VARCHAR2(150),
55 ATTRIBUTE3 VARCHAR2(150),
56 ATTRIBUTE4 VARCHAR2(150),
57 ATTRIBUTE5 VARCHAR2(150),
58 ATTRIBUTE6 VARCHAR2(150),
59 ATTRIBUTE7 VARCHAR2(150),
60 ATTRIBUTE8 VARCHAR2(150),
61 ATTRIBUTE9 VARCHAR2(150),
62 ATTRIBUTE10 VARCHAR2(150),
63 ATTRIBUTE11 VARCHAR2(150),
64 ATTRIBUTE12 VARCHAR2(150),
65 ATTRIBUTE13 VARCHAR2(150),
66 ATTRIBUTE14 VARCHAR2(150),
67 ATTRIBUTE15 VARCHAR2(150)
68 );
69
70 PROCEDURE Create_Act_Resource
71 ( p_api_version IN NUMBER,
72 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
73 p_commit IN VARCHAR2 := FND_API.G_FALSE,
74 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
75 x_return_status OUT NOCOPY VARCHAR2,
76 x_msg_count OUT NOCOPY NUMBER,
77 x_msg_data OUT NOCOPY VARCHAR2,
78
79 p_Act_Resource_rec IN Act_Resource_rec_type,
80 x_Act_Resource_id OUT NOCOPY NUMBER
81 );
82
83 /****************************************************************************/
84 -- Start of Comments
85 --
86 -- API name : Update_Act_Resource
87 -- Type : Private
88 -- Function : Update a row in AMS_ACT_RESOURCES table
89 --
90 -- Paramaeters :
91 -- IN :
92 -- standard IN parameters
93 -- p_api_version IN NUMBER := NULL Required
94 -- p_init_msg_list IN VARCHAR2 Optional
95 -- p_commit IN VARCHAR2 := FND_API.G_FALSE Optional
96 -- p_validation_level IN NUMBER
97 -- := FND_API.G_VALID_LEVEL_FULL,
98 -- API's IN parameters
99 --
100 -- p_Act_Resource_rec IN Act_Resource_rec_type
101 --
102 -- OUT :
103 -- standard OUT parameters
104 -- x_return_status OUT VARCHAR2(1)
105 -- x_msg_count OUT NUMBER
106 -- x_msg_data OUT VARCHAR2(2000)
107 --
108 --
109 -- Note : 1. p_Act_Resource_rec.activity_delivery_method_id is a required parameter
110 -- 2. p_Act_Resource_rec.activity_delivery_method_id is not updatable
111 --
112 /****************************************************************************/
113
114 PROCEDURE Update_Act_Resource
115 ( p_api_version IN NUMBER,
116 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
117 p_commit IN VARCHAR2 := FND_API.G_FALSE,
118 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
119 x_return_status OUT NOCOPY VARCHAR2,
120 x_msg_count OUT NOCOPY NUMBER,
121 x_msg_data OUT NOCOPY VARCHAR2,
122
123 p_Act_Resource_rec IN Act_Resource_rec_type
124 );
125
126 /*****************************************************************************************/
127 -- Start of Comments
128 --
129 -- API name : Delete_Act_Resource
130 -- Type : Private
131 -- Function : Delete a row in AMS_ACT_RESOURCES table
132 --
133 -- Paramaeters :
134 -- IN :
135 -- standard IN parameters
136 -- p_api_version IN NUMBER := NULL Required
137 -- p_init_msg_list IN VARCHAR2 Optional
138 -- Default := FND_API.G_FALSE
139 -- p_commit IN VARCHAR2 := FND_API.G_FALSE Optional
140 -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
141 -- API's IN parameters
142 -- p_Act_Resource_rec IN Act_Resource_rec_type Required
143 --
144 -- standard OUT parameters
145 -- x_return_status OUT VARCHAR2(1)
146 -- x_msg_count OUT NUMBER
147 -- x_msg_data OUT VARCHAR2(2000)
148 --
149 --
150 -- Note : 1. p_Resource_rec.activity_Delivery_method_id is a required parameter
151 --
152 /*****************************************************************************************/
153
154 PROCEDURE Delete_Act_Resource
155 ( p_api_version IN NUMBER,
156 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
157 p_commit IN VARCHAR2 := FND_API.G_FALSE,
158 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159 x_return_status OUT NOCOPY VARCHAR2,
160 x_msg_count OUT NOCOPY NUMBER,
161 x_msg_data OUT NOCOPY VARCHAR2,
162
163 p_Act_Resource_id IN NUMBER,
164 p_object_version IN NUMBER
165 );
166
167
168 /*****************************************************************************************/
169 -- Start of Comments
170 --
171 -- API name : Lock_Act_Resource
172 -- Type : Private
173 -- Function : Lock a row in AMS_ACT_RESOURCES table
174 --
175 -- Paramaeters :
176 -- IN :
177 -- standard IN parameters
178 -- p_api_version IN NUMBER := NULL Required
179 -- p_init_msg_list IN VARCHAR2 Optional
180 -- Default := FND_API.G_FALSE
181 -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
182 -- API's IN parameters
183 -- p_Resource_rec IN Act_Resource_rec_type Required
184 -- OUT :
185 -- standard OUT parameters
186 -- x_return_status OUT VARCHAR2(1)
187 -- x_msg_count OUT NUMBER
188 -- x_msg_data OUT VARCHAR2(2000)
189 --
190 -- Note : p_Resource_rec.activity_product_id is a required parameter
191 --
192 /*****************************************************************************************/
193
194 PROCEDURE Lock_Act_Resource
195 ( p_api_version IN NUMBER,
196 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
197 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198 x_return_status OUT NOCOPY VARCHAR2,
199 x_msg_count OUT NOCOPY NUMBER,
200 x_msg_data OUT NOCOPY VARCHAR2,
201
202 p_Act_Resource_id IN NUMBER,
203 p_object_version IN NUMBER
204 );
205
206 /*****************************************************************************************/
207 -- Start of Comments
208 --
209 -- API name : Validate_Act_Resource
210 -- Type : Private
211 -- Function : Validate a row in AMS_ACT_RESOURCES table
212 --
213 -- Paramaeters :
214 -- IN :
215 -- standard IN parameters
216 -- p_api_version IN NUMBER := NULL Required
217 -- p_init_msg_list IN VARCHAR2 Optional
218 -- Default := FND_API.G_FALSE
219 -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
220 -- API's IN parameters
221 --
222 -- p_Resource_rec IN Act_Resource_rec_type Required
223 --
224 -- standard OUT parameters
225 -- x_return_status OUT VARCHAR2(1)
226 -- x_msg_count OUT NUMBER
227 -- x_msg_data OUT VARCHAR2(2000)
228 --
229 --
230 -- Note : 1. p_Resource_rec.activity_product_id is a required parameter
231 -- 2. x_return_status will be FND_API.G_RET_STS_SUCCESS,
232 -- FND_API.G_RET_STS_ERROR, or
233 -- FND_API.G_RET_STS_UNEXP_ERROR
234 --
235 /*****************************************************************************************/
236
237 PROCEDURE Validate_Act_Resource
238 ( p_api_version IN NUMBER,
239 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
240 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
241 x_return_status OUT NOCOPY VARCHAR2,
242 x_msg_count OUT NOCOPY NUMBER,
243 x_msg_data OUT NOCOPY VARCHAR2,
244
245 p_Act_Resource_rec IN Act_Resource_rec_type
246 );
247
248 PROCEDURE Validate_Act_Resource_Items
249 ( p_Act_Resource_rec IN Act_Resource_rec_type,
250 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
251 x_return_status OUT NOCOPY VARCHAR2
252 );
253
254 PROCEDURE Validate_Act_Rsc_Record
255 (
256 p_Act_Resource_rec IN Act_Resource_rec_type,
257 x_return_status OUT NOCOPY VARCHAR2
258 );
259
260 ---------------------------------------------------------------------
261 -- PROCEDURE
262 -- init_Act_Rsc_Record
263 --
264 -- PURPOSE
265 -- Initialize all attributes to be FND_API.g_miss_char/num/date.
266 ---------------------------------------------------------------------
267 PROCEDURE init_Act_Rsc_Record(
268 x_Act_Resource_rec OUT NOCOPY Act_Resource_rec_type
269 );
270
271
272 PROCEDURE complete_Act_Resource_rec(
273 p_Act_Resource_rec IN Act_Resource_rec_type,
274 x_Act_Resource_rec OUT NOCOPY Act_Resource_rec_type
275 );
276
277 END AMS_ActResource_PVT;