1 PACKAGE CSP_ORDERLINES_PVT AUTHID CURRENT_USER AS
2 /* $Header: cspvtmls.pls 115.9 2003/05/02 16:37:32 hhaugeru ship $ */
3 -- Start of Comments
4 -- Package name : CSP_ORDERLINES_PVT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 -- Default number of records fetch per call
11 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
12 -- *******************************************************
13 -- Start of Comments
14 -- -------------------------------------------------------
15 -- Record name:mol_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- LINE_ID
19 -- CREATED_BY
20 -- CREATION_DATE
21 -- LAST_UPDATED_BY
22 -- LAST_UPDATE_DATE
23 -- LAST_UPDATED_LOGIN
24 -- HEADER_ID
25 -- CUSTOMER_PO
26 -- INCIDENT_ID
27 -- TASK_ID
28 -- TASK_ASSIGNMENT_ID
29 -- COMMENTS
30 -- ATTRIBUTE_CATEGORY
31 -- ATTRIBUTE1
32 -- ATTRIBUTE2
33 -- ATTRIBUTE3
34 -- ATTRIBUTE4
35 -- ATTRIBUTE5
36 -- ATTRIBUTE6
37 -- ATTRIBUTE7
38 -- ATTRIBUTE8
39 -- ATTRIBUTE9
40 -- ATTRIBUTE10
41 -- ATTRIBUTE11
42 -- ATTRIBUTE12
43 -- ATTRIBUTE13
44 -- ATTRIBUTE14
45 -- ATTRIBUTE15
46 --
47 -- Required:
48 -- Defaults:
49 -- Note: This is automatic generated record definition, it includes all columns
50 -- defined in the table, developer must manually add or delete some of the attributes.
51 --
52 -- End of Comments
53
54 TYPE mol_Rec_Type IS RECORD
55 (
56 LINE_ID NUMBER := FND_API.G_MISS_NUM,
57 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
58 CREATION_DATE DATE := FND_API.G_MISS_DATE,
59 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
60 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
61 LAST_UPDATED_LOGIN NUMBER := FND_API.G_MISS_NUM,
62 HEADER_ID NUMBER := FND_API.G_MISS_NUM,
63 CUSTOMER_PO VARCHAR2(30) := FND_API.G_MISS_CHAR,
64 INCIDENT_ID NUMBER := FND_API.G_MISS_NUM,
65 TASK_ID NUMBER := FND_API.G_MISS_NUM,
66 TASK_ASSIGNMENT_ID NUMBER := FND_API.G_MISS_NUM,
67 COMMENTS VARCHAR2(240) := FND_API.G_MISS_CHAR,
68 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
69 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
84 );
85
86 G_MISS_mol_REC mol_Rec_Type;
87 TYPE mol_Tbl_Type IS TABLE OF mol_Rec_Type
88 INDEX BY BINARY_INTEGER;
89 G_MISS_mol_TBL mol_Tbl_Type;
90
91 -- *******************************************************
92 -- Start of Comments
93 -- *******************************************************
94 -- API Name: Create_orderlines
95 -- Type : Private
96 -- Pre-Req :
97 -- Parameters:
98 -- IN
99 -- p_api_version_number IN NUMBER Required
100 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
101 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
102 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
103 -- P_mol_Rec IN mol_Rec_Type Required
104 --
105 -- OUT:
106 -- x_return_status OUT NOCOPY VARCHAR2
107 -- x_msg_count OUT NOCOPY NUMBER
108 -- x_msg_data OUT NOCOPY VARCHAR2
109 -- Version : Current version 2.0
110 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
111 -- and basic operation, developer must manually add parameters and business logic as necessary.
112 --
113 -- End of Comments
114 --
115 PROCEDURE Create_orderlines(
116 P_Api_Version_Number IN NUMBER,
117 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
118 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
119 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
120 P_mol_Rec IN mol_Rec_Type := G_MISS_mol_REC,
121 --Hint: Add detail tables as parameter lists if it's master-detail relationship.
122 X_LINE_ID OUT NOCOPY NUMBER,
123 X_Return_Status OUT NOCOPY VARCHAR2,
124 X_Msg_Count OUT NOCOPY NUMBER,
125 X_Msg_Data OUT NOCOPY VARCHAR2
126 );
127
128 -- *******************************************************
129 -- Start of Comments
130 -- *******************************************************
131 -- API Name: Update_orderlines
132 -- Type : Private
133 -- Pre-Req :
134 -- Parameters:
135 -- IN
136 -- p_api_version_number IN NUMBER Required
137 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
138 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
139 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
140 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
141 -- P_mol_Rec IN mol_Rec_Type Required
142 --
143 -- OUT:
144 -- x_return_status OUT NOCOPY VARCHAR2
145 -- x_msg_count OUT NOCOPY NUMBER
146 -- x_msg_data OUT NOCOPY VARCHAR2
147 -- Version : Current version 2.0
148 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
149 -- and basic operation, developer must manually add parameters and business logic as necessary.
150 --
151 -- End of Comments
152 --
153 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
154 PROCEDURE Update_orderlines(
155 P_Api_Version_Number 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 P_Identity_Salesforce_Id IN NUMBER := NULL,
160 P_mol_Rec IN mol_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 -- *******************************************************
167 -- Start of Comments
168 -- *******************************************************
169 -- API Name: Delete_orderlines
170 -- Type : Private
171 -- Pre-Req :
172 -- Parameters:
173 -- IN
174 -- p_api_version_number IN NUMBER Required
175 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
176 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
177 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
178 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
179 -- P_mol_Rec IN mol_Rec_Type Required
180 --
181 -- OUT:
182 -- x_return_status OUT NOCOPY VARCHAR2
183 -- x_msg_count OUT NOCOPY NUMBER
184 -- x_msg_data OUT NOCOPY VARCHAR2
185 -- Version : Current version 2.0
186 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
187 -- and basic operation, developer must manually add parameters and business logic as necessary.
188 --
189 -- End of Comments
190 --
191 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
192 -- The Master delete procedure may not be needed depends on different business requirements.
193 PROCEDURE Delete_orderlines(
194 P_Api_Version_Number IN NUMBER,
195 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
196 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
197 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198 P_identity_salesforce_id IN NUMBER := NULL,
199 P_mol_Rec IN mol_Rec_Type,
200 X_Return_Status OUT NOCOPY VARCHAR2,
201 X_Msg_Count OUT NOCOPY NUMBER,
202 X_Msg_Data OUT NOCOPY VARCHAR2
203 );
204
205 -- Start of Comments
206 --
207 -- Item level validation procedures
208 --
209 -- p_validation_mode is a constant defined in package
210 -- For create: G_CREATE, for update: G_UPDATE
211 -- Note: 1. This is automated generated item level validation procedure.
212 -- The actual validation detail is needed to be added.
213 --
214 -- End of Comments
215
216 PROCEDURE Validate_LINE_ID (
217 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
218 P_Validation_mode IN VARCHAR2,
219 P_LINE_ID IN NUMBER,
220 P_HEADER_ID IN NUMBER, -- added for valiation of line_id 06-DEC-99, VL.
221 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.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
227 -- Start of Comments
228 --
229 -- Item level validation procedures
230 --
231 -- p_validation_mode is a constant defined in package
232 -- For create: G_CREATE, for update: G_UPDATE
233 -- Note: 1. This is automated generated item level validation procedure.
234 -- The actual validation detail is needed to be added.
235 --
236 -- End of Comments
237
238 PROCEDURE Validate_LAST_UPDATED_LOGIN (
239 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
240 P_Validation_mode IN VARCHAR2,
241 P_LAST_UPDATED_LOGIN IN NUMBER,
242 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
243 X_Return_Status OUT NOCOPY VARCHAR2,
244 X_Msg_Count OUT NOCOPY NUMBER,
245 X_Msg_Data OUT NOCOPY VARCHAR2
246 );
247
248 -- Start of Comments
249 --
250 -- Item level validation procedures
251 --
252 -- p_validation_mode is a constant defined in package
253 -- For create: G_CREATE, for update: G_UPDATE
254 -- Note: 1. This is automated generated item level validation procedure.
255 -- The actual validation detail is needed to be added.
256 --
257 -- End of Comments
258
259 PROCEDURE Validate_HEADER_ID (
260 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
261 P_Validation_mode IN VARCHAR2,
262 P_HEADER_ID IN NUMBER,
263 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
264 X_Return_Status OUT NOCOPY VARCHAR2,
265 X_Msg_Count OUT NOCOPY NUMBER,
266 X_Msg_Data OUT NOCOPY VARCHAR2
267 );
268
269 -- Start of Comments
270 --
271 -- Item level validation procedures
272 --
273 -- p_validation_mode is a constant defined in package
274 -- For create: G_CREATE, for update: G_UPDATE
275 -- Note: 1. This is automated generated item level validation procedure.
276 -- The actual validation detail is needed to be added.
277 --
278 -- End of Comments
279
280 PROCEDURE Validate_CUSTOMER_PO (
281 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
282 P_Validation_mode IN VARCHAR2,
283 P_CUSTOMER_PO IN VARCHAR2,
284 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
285 X_Return_Status OUT NOCOPY VARCHAR2,
286 X_Msg_Count OUT NOCOPY NUMBER,
287 X_Msg_Data OUT NOCOPY VARCHAR2
288 );
289
290 -- Start of Comments
291 --
292 -- Item level validation procedures
293 --
294 -- p_validation_mode is a constant defined in package
295 -- For create: G_CREATE, for update: G_UPDATE
296 -- Note: 1. This is automated generated item level validation procedure.
297 -- The actual validation detail is needed to be added.
298 --
299 -- End of Comments
300
301 PROCEDURE Validate_INCIDENT_ID (
305 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
302 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
303 P_Validation_mode IN VARCHAR2,
304 P_INCIDENT_ID IN NUMBER,
306 X_Return_Status OUT NOCOPY VARCHAR2,
307 X_Msg_Count OUT NOCOPY NUMBER,
308 X_Msg_Data OUT NOCOPY VARCHAR2
309 );
310
311 -- Start of Comments
312 --
313 -- Item level validation procedures
314 --
315 -- p_validation_mode is a constant defined in package
316 -- For create: G_CREATE, for update: G_UPDATE
317 -- Note: 1. This is automated generated item level validation procedure.
318 -- The actual validation detail is needed to be added.
319 --
320 -- End of Comments
321
322 PROCEDURE Validate_TASK_ID (
323 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
324 P_Validation_mode IN VARCHAR2,
325 P_TASK_ID IN NUMBER,
326 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
327 X_Return_Status OUT NOCOPY VARCHAR2,
328 X_Msg_Count OUT NOCOPY NUMBER,
329 X_Msg_Data OUT NOCOPY VARCHAR2
330 );
331
332 -- Start of Comments
333 --
334 -- Item level validation procedures
335 --
336 -- p_validation_mode is a constant defined in package
337 -- For create: G_CREATE, for update: G_UPDATE
338 -- Note: 1. This is automated generated item level validation procedure.
339 -- The actual validation detail is needed to be added.
340 --
341 -- End of Comments
342
343 PROCEDURE Validate_TASK_ASSIGNMENT_ID (
344 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
345 P_Validation_mode IN VARCHAR2,
346 P_TASK_ASSIGNMENT_ID IN NUMBER,
347 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
348 X_Return_Status OUT NOCOPY VARCHAR2,
349 X_Msg_Count OUT NOCOPY NUMBER,
350 X_Msg_Data OUT NOCOPY VARCHAR2
351 );
352
353 -- Start of Comments
354 --
355 -- Item level validation procedures
356 --
357 -- p_validation_mode is a constant defined in package
358 -- For create: G_CREATE, for update: G_UPDATE
359 -- Note: 1. This is automated generated item level validation procedure.
360 -- The actual validation detail is needed to be added.
361 --
362 -- End of Comments
363
364 PROCEDURE Validate_COMMENTS (
365 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
366 P_Validation_mode IN VARCHAR2,
367 P_COMMENTS IN VARCHAR2,
368 -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
369 X_Return_Status OUT NOCOPY VARCHAR2,
370 X_Msg_Count OUT NOCOPY NUMBER,
371 X_Msg_Data OUT NOCOPY VARCHAR2
372 );
373
374 -- Start of Comments
375 --
376 -- Record level validation procedures
377 --
378 -- p_validation_mode is a constant defined in package
379 -- For create: G_CREATE, for update: G_UPDATE
380 -- Note: 1. This is automated generated item level validation procedure.
381 -- The actual validation detail is needed to be added.
382 -- 2. Developer can manually added inter-field level validation.
383 -- End of Comments
384
385 PROCEDURE Validate_mol_rec(
386 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
387 P_Validation_mode IN VARCHAR2,
388 P_mol_Rec IN mol_Rec_Type,
389 X_Return_Status OUT NOCOPY VARCHAR2,
390 X_Msg_Count OUT NOCOPY NUMBER,
391 X_Msg_Data OUT NOCOPY VARCHAR2
392 );
393
394 -- Start of Comments
395 --
396 -- validation procedures
397 --
398 -- p_validation_mode is a constant defined in package
399 -- For create: G_CREATE, for update: G_UPDATE
400 -- Note: 1. This is automated generated item level validation procedure.
401 -- The actual validation detail is needed to be added.
402 -- 2. We can also validate table instead of record. There will be an option for user to choose.
403 -- End of Comments
404
405 PROCEDURE Validate_orderlines(
406 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
407 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
408 P_Validation_mode IN VARCHAR2,
409 P_mol_Rec IN mol_Rec_Type,
410 X_Return_Status OUT NOCOPY VARCHAR2,
411 X_Msg_Count OUT NOCOPY NUMBER,
412 X_Msg_Data OUT NOCOPY VARCHAR2
413 );
414 End CSP_ORDERLINES_PVT;