1 PACKAGE CSP_PRODUCT_TASK_PVT AUTHID CURRENT_USER as
2 /* $Header: cspvptas.pls 115.3 2003/05/02 16:26:30 hhaugeru noship $ */
3 -- Start of Comments
4 -- Package name : CSP_PRODUCT_TASK_PVT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9 -- Default number of records fetch per call
10 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
11 -- *******************************************************
12 -- Start of Comments
13 -- -------------------------------------------------------
14 -- Record name:PROD_TASK_Rec_Type
15 -- -------------------------------------------------------
16 -- Parameters:
17 -- PRODUCT_TASK_ID
18 -- PRODUCT_ID
19 -- TASK_TEMPLATE_ID
20 -- AUTO_MANUAL
21 -- ACTUAL_TIMES_USED
22 -- TASK_PERCENTAGE
23 -- ATTRIBUTE_CATEGORY
24 -- ATTRIBUTE1
25 -- ATTRIBUTE2
26 -- ATTRIBUTE3
27 -- ATTRIBUTE4
28 -- ATTRIBUTE5
29 -- ATTRIBUTE6
30 -- ATTRIBUTE7
31 -- ATTRIBUTE8
32 -- ATTRIBUTE9
33 -- ATTRIBUTE10
34 -- ATTRIBUTE11
35 -- ATTRIBUTE12
36 -- ATTRIBUTE13
37 -- ATTRIBUTE14
38 -- ATTRIBUTE15
39 -- CREATED_BY
40 -- CREATION_DATE
41 -- LAST_UPDATED_BY
42 -- LAST_UPDATE_DATE
43 -- LAST_UPDATE_LOGIN
44 --
45 -- Required:
46 -- Defaults:
47 -- Note: This is automatic generated record definition, it includes all columns
48 -- defined in the table, developer must manually add or delete some of the attributes.
49 --
50 -- End of Comments
51 TYPE PROD_TASK_Rec_Type IS RECORD
52 (
53 PRODUCT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
54 PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
55 TASK_TEMPLATE_ID NUMBER := FND_API.G_MISS_NUM,
56 AUTO_MANUAL VARCHAR2(6) := FND_API.G_MISS_CHAR,
57 ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
58 TASK_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
59 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
60 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
61 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
62 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
76 CREATION_DATE DATE := FND_API.G_MISS_DATE,
77 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
78 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
79 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
80 );
81 G_MISS_PROD_TASK_REC PROD_TASK_Rec_Type;
82 TYPE PROD_TASK_Tbl_Type IS TABLE OF PROD_TASK_Rec_Type
83 INDEX BY BINARY_INTEGER;
84 G_MISS_PROD_TASK_TBL PROD_TASK_Tbl_Type;
85 -- *******************************************************
86 -- Start of Comments
87 -- *******************************************************
88 -- API Name: Create_product_task
89 -- Type : Private
90 -- Pre-Req :
91 -- Parameters:
92 -- IN
93 -- p_api_version_number IN NUMBER Required
94 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
95 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
96 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
97 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
98 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
99 -- p_admin_group_id IN NUMBER Required
100 -- P_PROD_TASK_Rec IN PROD_TASK_Rec_Type Required
101 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
102 --
103 -- OUT:
104 -- x_return_status OUT NOCOPY VARCHAR2
105 -- x_msg_count OUT NOCOPY NUMBER
106 -- x_msg_data OUT NOCOPY VARCHAR2
107 -- Version : Current version 2.0
108 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
109 -- and basic operation, developer must manually add parameters and business logic as necessary.
110 --
111 -- End of Comments
112 --
113 PROCEDURE Create_product_task(
114 P_Api_Version_Number IN NUMBER,
115 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
116 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
117 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
118 P_PROD_TASK_Rec IN PROD_TASK_Rec_Type := G_MISS_PROD_TASK_REC,
119 --Hint: Add detail tables as parameter lists if it's master-detail relationship.
120 X_PRODUCT_TASK_ID OUT NOCOPY NUMBER,
121 X_Return_Status OUT NOCOPY VARCHAR2,
122 X_Msg_Count OUT NOCOPY NUMBER,
123 X_Msg_Data OUT NOCOPY VARCHAR2
124 );
125 -- *******************************************************
126 -- Start of Comments
127 -- *******************************************************
128 -- API Name: Update_product_task
129 -- Type : Private
130 -- Pre-Req :
131 -- Parameters:
132 -- IN
133 -- p_api_version_number IN NUMBER Required
134 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
135 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
136 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
137 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
138 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
139 -- p_admin_group_id IN NUMBER Required
140 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
141 -- P_PROD_TASK_Rec IN PROD_TASK_Rec_Type Required
142 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
143 --
144 -- OUT:
145 -- x_return_status OUT NOCOPY VARCHAR2
146 -- x_msg_count OUT NOCOPY NUMBER
147 -- x_msg_data OUT NOCOPY VARCHAR2
148 -- Version : Current version 2.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 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
155 PROCEDURE Update_product_task(
156 P_Api_Version_Number 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 P_PROD_TASK_Rec IN PROD_TASK_Rec_Type,
161 X_Return_Status OUT NOCOPY VARCHAR2,
162 X_Msg_Count OUT NOCOPY NUMBER,
163 X_Msg_Data OUT NOCOPY VARCHAR2
164 );
165 -- *******************************************************
166 -- Start of Comments
167 -- *******************************************************
168 -- API Name: Delete_product_task
169 -- Type : Private
170 -- Pre-Req :
171 -- Parameters:
172 -- IN
173 -- p_api_version_number IN NUMBER Required
174 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
175 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
176 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
177 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
178 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
179 -- p_admin_group_id IN NUMBER Required
180 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
181 -- P_PROD_TASK_Rec IN PROD_TASK_Rec_Type Required
182 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
183 --
184 -- OUT:
185 -- x_return_status OUT NOCOPY VARCHAR2
186 -- x_msg_count OUT NOCOPY NUMBER
187 -- x_msg_data OUT NOCOPY VARCHAR2
188 -- Version : Current version 2.0
189 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
190 -- and basic operation, developer must manually add parameters and business logic as necessary.
191 --
192 -- End of Comments
193 --
194 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
195 -- The Master delete procedure may not be needed depends on different business requirements.
196 PROCEDURE Delete_product_task(
197 P_Api_Version_Number IN NUMBER,
198 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
199 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
200 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
201 P_PROD_TASK_Rec IN PROD_TASK_Rec_Type,
202 X_Return_Status OUT NOCOPY VARCHAR2,
203 X_Msg_Count OUT NOCOPY NUMBER,
204 X_Msg_Data OUT NOCOPY VARCHAR2
205 );
206
207 -- Start of Comments
208 --
209 -- Item level validation procedures
210 --
211 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
212 -- For create: G_CREATE, for update: G_UPDATE
213 -- Note: 1. This is automated generated item level validation procedure.
214 -- The actual validation detail is needed to be added.
215 --
216 -- End of Comments
217 PROCEDURE Validate_PRODUCT_TASK_ID (
218 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
219 P_Validation_mode IN VARCHAR2,
220 P_PRODUCT_TASK_ID IN NUMBER,
221 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
222 X_Return_Status OUT NOCOPY VARCHAR2,
223 X_Msg_Count OUT NOCOPY NUMBER,
224 X_Msg_Data OUT NOCOPY VARCHAR2
225 );
226 -- Start of Comments
227 --
228 -- Item level validation procedures
229 --
230 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
231 -- For create: G_CREATE, for update: G_UPDATE
232 -- Note: 1. This is automated generated item level validation procedure.
233 -- The actual validation detail is needed to be added.
234 --
235 -- End of Comments
236 PROCEDURE Validate_PRODUCT_ID (
237 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
238 P_Validation_mode IN VARCHAR2,
239 P_PRODUCT_ID IN NUMBER,
240 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
241 X_Return_Status OUT NOCOPY VARCHAR2,
242 X_Msg_Count OUT NOCOPY NUMBER,
243 X_Msg_Data OUT NOCOPY VARCHAR2
244 );
245 -- Start of Comments
246 --
247 -- Item level validation procedures
248 --
249 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
250 -- For create: G_CREATE, for update: G_UPDATE
251 -- Note: 1. This is automated generated item level validation procedure.
252 -- The actual validation detail is needed to be added.
253 --
254 -- End of Comments
255 PROCEDURE Validate_TASK_TEMPLATE_ID (
256 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
257 P_Validation_mode IN VARCHAR2,
258 P_TASK_TEMPLATE_ID IN NUMBER,
259 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
260 X_Return_Status OUT NOCOPY VARCHAR2,
261 X_Msg_Count OUT NOCOPY NUMBER,
262 X_Msg_Data OUT NOCOPY VARCHAR2
263 );
264 -- Start of Comments
265 --
266 -- Item level validation procedures
267 --
268 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
269 -- For create: G_CREATE, for update: G_UPDATE
270 -- Note: 1. This is automated generated item level validation procedure.
271 -- The actual validation detail is needed to be added.
272 --
273 -- End of Comments
274 PROCEDURE Validate_AUTO_MANUAL (
275 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
276 P_Validation_mode IN VARCHAR2,
277 P_AUTO_MANUAL IN VARCHAR2,
278 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
279 X_Return_Status OUT NOCOPY VARCHAR2,
280 X_Msg_Count OUT NOCOPY NUMBER,
281 X_Msg_Data OUT NOCOPY VARCHAR2
282 );
283 -- Start of Comments
284 --
285 -- Item level validation procedures
286 --
287 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
288 -- For create: G_CREATE, for update: G_UPDATE
289 -- Note: 1. This is automated generated item level validation procedure.
290 -- The actual validation detail is needed to be added.
291 --
292 -- End of Comments
293 PROCEDURE Validate_ACTUAL_TIMES_USED (
294 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
295 P_Validation_mode IN VARCHAR2,
296 P_ACTUAL_TIMES_USED IN NUMBER,
297 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
298 X_Return_Status OUT NOCOPY VARCHAR2,
299 X_Msg_Count OUT NOCOPY NUMBER,
300 X_Msg_Data OUT NOCOPY VARCHAR2
301 );
302 -- Start of Comments
303 --
304 -- Item level validation procedures
305 --
306 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
307 -- For create: G_CREATE, for update: G_UPDATE
308 -- Note: 1. This is automated generated item level validation procedure.
309 -- The actual validation detail is needed to be added.
310 --
311 -- End of Comments
312 PROCEDURE Validate_TASK_PERCENTAGE (
313 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
314 P_Validation_mode IN VARCHAR2,
315 P_TASK_PERCENTAGE IN NUMBER,
316 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
317 X_Return_Status OUT NOCOPY VARCHAR2,
318 X_Msg_Count OUT NOCOPY NUMBER,
319 X_Msg_Data OUT NOCOPY VARCHAR2
320 );
321 -- Start of Comments
322 --
323 -- Record level validation procedures
324 --
325 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
326 -- For create: G_CREATE, for update: G_UPDATE
327 -- Note: 1. This is automated generated item level validation procedure.
328 -- The actual validation detail is needed to be added.
329 -- 2. Developer can manually added inter-field level validation.
330 -- End of Comments
331 PROCEDURE Validate_PROD_TASK_rec(
332 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
333 P_Validation_mode IN VARCHAR2,
334 P_PROD_TASK_Rec IN PROD_TASK_Rec_Type,
335 X_Return_Status OUT NOCOPY VARCHAR2,
336 X_Msg_Count OUT NOCOPY NUMBER,
337 X_Msg_Data OUT NOCOPY VARCHAR2
338 );
339 -- Start of Comments
340 --
341 -- validation procedures
342 --
343 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
344 -- For create: G_CREATE, for update: G_UPDATE
345 -- Note: 1. This is automated generated item level validation procedure.
346 -- The actual validation detail is needed to be added.
347 -- 2. We can also validate table instead of record. There will be an option for user to choose.
351 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
348 -- End of Comments
349 PROCEDURE Validate_product_task(
350 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
352 P_Validation_mode IN VARCHAR2,
353 P_PROD_TASK_Rec IN PROD_TASK_Rec_Type,
354 X_Return_Status OUT NOCOPY VARCHAR2,
355 X_Msg_Count OUT NOCOPY NUMBER,
356 X_Msg_Data OUT NOCOPY VARCHAR2
357 );
358 End CSP_PRODUCT_TASK_PVT;