[Home] [Help]
PACKAGE: APPS.ASO_PARTY_RLTSHIP_PVT
Source
1 PACKAGE ASO_PARTY_RLTSHIP_PVT AUTHID CURRENT_USER as
2 /* $Header: asovpars.pls 120.1 2005/06/29 12:42:48 appldev ship $ */
3 -- Start of Comments
4 -- Package name : ASO_PARTY_RLTSHIP_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:PARTY_RLTSHIP_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- PARTY_RELATIONSHIP_ID
19 -- CREATION_DATE
20 -- CREATED_BY
21 -- LAST_UPDATE_DATE
22 -- LAST_UPDATED_BY
23 -- LAST_UPDATE_LOGIN
24 -- REQUEST_ID
25 -- PROGRAM_APPLICATION_ID
26 -- PROGRAM_ID
27 -- PROGRAM_UPDATE_DATE
28 -- QUOTE_OBJECT_TYPE
29 -- QUOTE_OBJECT_ID
30 -- RELATIONSHIP_TYPE_CODE
31 -- RELATED_OBJECT_TYPE_CODE
32 -- RELATED_OBJECT_ID
33 -- QUOTE_HEADER_ID
34 -- QUOTE_LINE_ID
35 -- OBJECT_TYPE_CODE
36 -- OBJECT_ID
37 --
38 -- Required:
39 -- Defaults:
40 -- Note: This is automatic generated record definition, it includes all columns
41 -- defined in the table, developer must manually add or delete some of the attributes.
42 --
43 -- End of Comments
44 -- *******************************************************
45 -- Start of Comments
46 -- *******************************************************
47 -- API Name: Create_party_rltship
48 -- Type : Private
49 -- Pre-Req :
50 -- Parameters:
51 -- IN
52 -- p_api_version_number IN NUMBER Required
53 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
54 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
55 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
56 -- P_PARTY_RLTSHIP_Rec IN PARTY_RLTSHIP_Rec_Type Required
57 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
58 -- and basic operation, developer must manually add parameters and business logic as necessary.
59 --
60 -- End of Comments
61 --
62 PROCEDURE Create_party_rltship(
63 P_Api_Version_Number IN NUMBER,
64 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
65 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
66 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
67 P_PARTY_RLTSHIP_Rec IN ASO_quote_PUB.PARTY_RLTSHIP_Rec_Type := ASO_quote_PUB.G_MISS_PARTY_RLTSHIP_REC,
68 X_PARTY_RELATIONSHIP_ID OUT NOCOPY /* file.sql.39 change */ NUMBER,
69 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
70 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
71 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
72 );
73
74 -- *******************************************************
75 -- Start of Comments
76 -- *******************************************************
77 -- API Name: Update_party_rltship
78 -- Type : Private
79 -- Pre-Req :
80 -- Parameters:
81 -- IN
82 -- p_api_version_number IN NUMBER Required
83 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
84 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
85 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
86 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
87 -- P_PARTY_RLTSHIP_Rec IN PARTY_RLTSHIP_Rec_Type Required
88 -- Version : Current version 2.0
89 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
90 -- and basic operation, developer must manually add parameters and business logic as necessary.
91 --
92 -- End of Comments
93 --
94 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
95 PROCEDURE Update_party_rltship(
96 P_Api_Version_Number IN NUMBER,
97 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
98 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
99 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
100 P_PARTY_RLTSHIP_Rec IN ASO_quote_PUB.PARTY_RLTSHIP_Rec_Type,
101 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
102 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
103 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
104 );
105
106 -- *******************************************************
107 -- Start of Comments
108 -- *******************************************************
109 -- API Name: Delete_party_rltship
110 -- Type : Private
111 -- Pre-Req :
112 -- Parameters:
113 -- IN
114 -- p_api_version_number IN NUMBER Required
115 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
116 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
117 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
118 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
119 -- P_PARTY_RLTSHIP_Rec IN PARTY_RLTSHIP_Rec_Type Required
120 --
121 -- Version : Current version 2.0
122 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
123 -- and basic operation, developer must manually add parameters and business logic as necessary.
124 --
125 -- End of Comments
126 --
127 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
128 -- The Master delete procedure may not be needed depends on different business requirements.
129 PROCEDURE Delete_party_rltship(
130 P_Api_Version_Number IN NUMBER,
131 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
132 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
133 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
134 P_PARTY_RLTSHIP_Rec IN ASO_quote_PUB.PARTY_RLTSHIP_Rec_Type,
135 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
136 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
137 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
138 );
139
140
141 -- Start of Comments
142 --
143 -- Item level validation procedures
144 --
145 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
146 -- For create: G_CREATE, for update: G_UPDATE
147 -- Note: 1. This is automated generated item level validation procedure.
148 -- The actual validation detail is needed to be added.
149 --
150 -- End of Comments
151
152 PROCEDURE Validate_PARTY_RLTSHIP_ID (
153 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
154 P_Validation_mode IN VARCHAR2,
155 P_PARTY_RELATIONSHIP_ID IN NUMBER,
156 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
157 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
158 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
159 );
160
161 -- Start of Comments
162 --
163 -- Item level validation procedures
164 --
165 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
166 -- For create: G_CREATE, for update: G_UPDATE
167 -- Note: 1. This is automated generated item level validation procedure.
168 -- The actual validation detail is needed to be added.
169 --
170 -- End of Comments
171
172 PROCEDURE Validate_REQUEST_ID (
173 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
174 P_Validation_mode IN VARCHAR2,
175 P_REQUEST_ID IN NUMBER,
176 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
177 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
178 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
179 );
180
181 -- Start of Comments
182 --
183 -- Item level validation procedures
184 --
185 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
186 -- For create: G_CREATE, for update: G_UPDATE
187 -- Note: 1. This is automated generated item level validation procedure.
188 -- The actual validation detail is needed to be added.
189 --
190 -- End of Comments
191
192 PROCEDURE Validate_PROG_APPL_ID (
193 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
194 P_Validation_mode IN VARCHAR2,
195 P_PROGRAM_APPLICATION_ID IN NUMBER,
196 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
197 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
198 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
199 );
200
201 -- Start of Comments
202 --
203 -- Item level validation procedures
204 --
205 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
206 -- For create: G_CREATE, for update: G_UPDATE
207 -- Note: 1. This is automated generated item level validation procedure.
208 -- The actual validation detail is needed to be added.
209 --
210 -- End of Comments
211
212 PROCEDURE Validate_PROGRAM_ID (
213 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
214 P_Validation_mode IN VARCHAR2,
215 P_PROGRAM_ID IN NUMBER,
216 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
217 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
218 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
219 );
220
221 -- Start of Comments
222 --
223 -- Item level validation procedures
224 --
225 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
226 -- For create: G_CREATE, for update: G_UPDATE
227 -- Note: 1. This is automated generated item level validation procedure.
228 -- The actual validation detail is needed to be added.
229 --
230 -- End of Comments
231
232 PROCEDURE Validate_PROGRAM_UPDATE_DATE (
233 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
234 P_Validation_mode IN VARCHAR2,
235 P_PROGRAM_UPDATE_DATE IN DATE,
236 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
237 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
238 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
239 );
240
241 -- Start of Comments
242 --
243 -- Item level validation procedures
244 --
245 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
246 -- For create: G_CREATE, for update: G_UPDATE
247 -- Note: 1. This is automated generated item level validation procedure.
248 -- The actual validation detail is needed to be added.
249 --
250 -- End of Comments
251
252 PROCEDURE Validate_QUOTE_OBJECT_TYPE (
253 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
254 P_Validation_mode IN VARCHAR2,
255 P_QUOTE_OBJECT_TYPE IN VARCHAR2,
256 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
257 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
258 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
259 );
260
261 -- Start of Comments
262 --
263 -- Item level validation procedures
264 --
265 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
266 -- For create: G_CREATE, for update: G_UPDATE
267 -- Note: 1. This is automated generated item level validation procedure.
268 -- The actual validation detail is needed to be added.
269 --
270 -- End of Comments
271
272 PROCEDURE Validate_QUOTE_OBJECT_ID (
273 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
274 P_Validation_mode IN VARCHAR2,
275 P_QUOTE_OBJECT_ID IN NUMBER,
276 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
277 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
278 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
279 );
280
281 -- Start of Comments
282 --
283 -- Item level validation procedures
284 --
285 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
286 -- For create: G_CREATE, for update: G_UPDATE
287 -- Note: 1. This is automated generated item level validation procedure.
288 -- The actual validation detail is needed to be added.
289 --
290 -- End of Comments
291
292 PROCEDURE Validate_RLTSHIP_TYPE_CODE (
293 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
294 P_Validation_mode IN VARCHAR2,
295 P_RELATIONSHIP_TYPE_CODE IN VARCHAR2,
296 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
297 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
298 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
299 );
300
301 -- Start of Comments
302 --
303 -- Item level validation procedures
304 --
305 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
306 -- For create: G_CREATE, for update: G_UPDATE
307 -- Note: 1. This is automated generated item level validation procedure.
308 -- The actual validation detail is needed to be added.
309 --
310 -- End of Comments
311
312 PROCEDURE Validate_RELATED_OBJ_TYPE_CODE (
313 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
314 P_Validation_mode IN VARCHAR2,
315 P_RELATED_OBJECT_TYPE_CODE IN VARCHAR2,
316 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
317 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
318 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
319 );
320
321 -- Start of Comments
322 --
323 -- Item 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 --
330 -- End of Comments
331
332 PROCEDURE Validate_RELATED_OBJECT_ID (
333 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
334 P_Validation_mode IN VARCHAR2,
335 P_RELATED_OBJECT_ID IN NUMBER,
336 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
337 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
338 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
339 );
340
341 -- Start of Comments
342 --
343 -- Item level validation procedures
344 --
345 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
346 -- For create: G_CREATE, for update: G_UPDATE
347 -- Note: 1. This is automated generated item level validation procedure.
348 -- The actual validation detail is needed to be added.
349 --
350 -- End of Comments
351
352 PROCEDURE Validate_QUOTE_HEADER_ID (
353 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
354 P_Validation_mode IN VARCHAR2,
355 P_QUOTE_HEADER_ID IN NUMBER,
356 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
357 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
358 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
359 );
360
361 -- Start of Comments
362 --
363 -- Item level validation procedures
364 --
365 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
366 -- For create: G_CREATE, for update: G_UPDATE
367 -- Note: 1. This is automated generated item level validation procedure.
368 -- The actual validation detail is needed to be added.
369 --
370 -- End of Comments
371
372 PROCEDURE Validate_QUOTE_LINE_ID (
373 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
374 P_Validation_mode IN VARCHAR2,
375 P_QUOTE_LINE_ID IN NUMBER,
376 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
377 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
378 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
382 --
379 );
380
381 -- Start of Comments
383 -- Item level validation procedures
384 --
385 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
386 -- For create: G_CREATE, for update: G_UPDATE
387 -- Note: 1. This is automated generated item level validation procedure.
388 -- The actual validation detail is needed to be added.
389 --
390 -- End of Comments
391
392 PROCEDURE Validate_OBJECT_TYPE_CODE (
393 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
394 P_Validation_mode IN VARCHAR2,
395 P_OBJECT_TYPE_CODE IN VARCHAR2,
396 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
397 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
398 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
399 );
400
401 -- Start of Comments
402 --
403 -- Item level validation procedures
404 --
405 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
406 -- For create: G_CREATE, for update: G_UPDATE
407 -- Note: 1. This is automated generated item level validation procedure.
408 -- The actual validation detail is needed to be added.
409 --
410 -- End of Comments
411
412 PROCEDURE Validate_OBJECT_ID (
413 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
414 P_Validation_mode IN VARCHAR2,
415 P_OBJECT_ID IN NUMBER,
416 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
417 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
418 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
419 );
420
421 -- Start of Comments
422 --
423 -- Record level validation procedures
424 --
425 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
426 -- For create: G_CREATE, for update: G_UPDATE
427 -- Note: 1. This is automated generated item level validation procedure.
428 -- The actual validation detail is needed to be added.
429 -- 2. Developer can manually added inter-field level validation.
430 -- End of Comments
431
432 PROCEDURE Validate_PARTY_RLTSHIP_rec(
433 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
434 P_Validation_mode IN VARCHAR2,
435 P_PARTY_RLTSHIP_Rec IN ASO_quote_PUB.PARTY_RLTSHIP_Rec_Type,
436 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
437 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
438 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
439 );
440
441 -- Start of Comments
442 --
443 -- validation procedures
444 --
445 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
446 -- For create: G_CREATE, for update: G_UPDATE
447 -- Note: 1. This is automated generated item level validation procedure.
448 -- The actual validation detail is needed to be added.
449 -- 2. We can also validate table instead of record. There will be an option for user to choose.
450 -- End of Comments
451
452 PROCEDURE Validate_party_rltship(
453 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
454 P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
455 P_Validation_mode IN VARCHAR2,
456 P_PARTY_RLTSHIP_Rec IN ASO_quote_PUB.PARTY_RLTSHIP_Rec_Type,
457 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
458 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
459 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
460 );
461 End ASO_PARTY_RLTSHIP_PVT;