[Home] [Help]
PACKAGE: APPS.ASO_RLTSHIP_PUB
Source
1 PACKAGE ASO_RLTSHIP_PUB AUTHID CURRENT_USER as
2 /* $Header: asoprlts.pls 120.1 2005/06/29 12:37:49 appldev ship $ */
3 -- Start of Comments
4 -- Package name : ASO_RLTSHIP_PUB
5 -- Purpose :
6 -- This package contains specification for pl/sql records and tables and the
7 -- Public API of Order Capture.
8 --
9
10
11
12 -- *******************************************************
13 -- Start of Comments
14 -- *******************************************************
15 -- API Name: Create_Line_Relationship
16 -- Type : Public
17 -- Pre-Req :
18 -- Parameters:
19 -- IN
20 -- p_api_version_number IN NUMBER Required
21 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
22 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
23 -- P_Line_Rltship_Tbl IN Line_Rltship_Tbl_Type
24
25 -- End of Comments
26 --
27 PROCEDURE Create_Line_Relationship(
28 P_Api_Version_Number IN NUMBER,
29 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
30 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
31 P_Line_Rltship_Rec IN ASO_QUOTE_PUB.Line_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_line_rltship_REC,
32 X_line_relationship_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
33 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
34 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
35 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
36 );
37
38
39
40 -- *******************************************************
41 -- Start of Comments
42 -- *******************************************************
43 -- API Name: Update_Line_Relationship
44 -- Type : Public
45 -- Pre-Req :
46 -- Parameters:
47 -- IN
48 -- p_api_version_number IN NUMBER Required
49 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
50 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
51 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
52 -- P_Line_Rltship_Rec IN Line_Rltship_Rec_Type
53
54 -- End of Comments
55 --
56 PROCEDURE Update_Line_Relationship(
57 P_Api_Version_Number IN NUMBER,
58 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
59 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
60 P_Line_Rltship_Rec IN ASO_QUOTE_PUB.Line_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_line_rltship_REC,
61 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
62 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
63 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
64 );
65
66
67
68 -- *******************************************************
69 -- Start of Comments
70 -- *******************************************************
71 -- API Name: Delete_Line_Relationship
72 -- Type : Public
73 -- Pre-Req :
74 -- Parameters:
75 -- IN
76 -- p_api_version_number IN NUMBER Required
77 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
78 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
79 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
80 -- P_Line_Rltship_Rec IN Line_Rltship_Rec_Type
81
82 --
83 PROCEDURE Delete_Line_Relationship(
84 P_Api_Version_Number IN NUMBER,
85 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
86 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
87 p_control_rec IN ASO_QUOTE_PUB.control_rec_type := ASO_QUOTE_PUB.G_MISS_Control_Rec,
88 P_Line_Rltship_Rec IN ASO_QUOTE_PUB.Line_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_line_rltship_rec,
89 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
90 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
91 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
92 );
93
94 -- *******************************************************
95 -- Start of Comments
96 -- *******************************************************
97 -- API Name: Create_Header_Relationship
98 -- Type : Public
99 -- Pre-Req :
100 -- Parameters:
101 -- IN
102 -- p_api_version_number IN NUMBER Required
103 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
104 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
105 -- P_Header_Relationship_Rec IN Header_Relationship_Rec_Type
106
107 -- and basic operation, developer must manually add parameters and business logic as necessary.
108 --
109 -- End of Comments
110 --
111 PROCEDURE Create_Header_Relationship(
112 P_Api_Version_Number IN NUMBER,
113 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
114 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
115 P_Header_Rltship_Rec IN ASO_QUOTE_PUB.Header_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_header_rltship_REC,
116 X_Header_rltship_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
117 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
118 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
119 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
120 );
121
122
123
124 -- *******************************************************
125 -- Start of Comments
126 -- *******************************************************
127 -- API Name: Update_Header_Relationship
128 -- Type : Public
129 -- Pre-Req :
130 -- Parameters:
131 -- IN
132 -- p_api_version_number IN NUMBER Required
133 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
134 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
135 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
136 -- P_Header_Relationship_Rec IN Header_Relationship_Rec_Type
137
138 --
139 -- End of Comments
140 --
141 PROCEDURE Update_Header_Relationship(
142 P_Api_Version_Number IN NUMBER,
143 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
144 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
145 P_Header_Rltship_Rec IN ASO_QUOTE_PUB.Header_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_header_rltship_REC,
146 X_header_relationship_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
147 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
148 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
149 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
150 );
151
152
153 -- *******************************************************
154 -- Start of Comments
155 -- *******************************************************
156 -- API Name: Delete_Header_Relationship
157 -- Type : Public
158 -- Pre-Req :
159 -- Parameters:
160 -- IN
161 -- p_api_version_number IN NUMBER Required
162 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
163 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
164 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
165 -- P_Header_Relationship_Rec IN Header_Relationship_Rec_Type
166 -- Version : Current version 2.0
167 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
168 -- and basic operation, developer must manually add parameters and business logic as necessary.
169 --
170 -- End of Comments
171 --
172 PROCEDURE Delete_Header_Relationship(
173 P_Api_Version_Number IN NUMBER,
174 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
175 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
176 P_Header_Rltship_Rec IN ASO_QUOTE_PUB.Header_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_header_rltship_REC,
177 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
178 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
179 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
180 );
181
182
183
184 -- *******************************************************
185 -- Start of Comments
186 -- *******************************************************
187 -- API Name: Create_Party_Relationship
188 -- Type : Public
189 -- Pre-Req :
190 -- Parameters:
191 -- IN
192 -- p_api_version_number IN NUMBER Required
193 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
194 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
195 -- P_Party_Relationship_Rec IN Party_Relationship_Rec_Type
196 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
197 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
198 -- Version : Current version 2.0
199 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
200 -- and basic operation, developer must manually add parameters and business logic as necessary.
201 --
202 -- End of Comments
203 --
204 PROCEDURE Create_Party_Relationship(
205 P_Api_Version_Number IN NUMBER,
206 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
207 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
208 P_Party_Rltship_Rec IN ASO_QUOTE_PUB.Party_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_party_rltship_REC,
209 X_party_relationship_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
210 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
211 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
212 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
213 );
214
215
216
217 -- *******************************************************
218 -- Start of Comments
219 -- *******************************************************
220 -- API Name: Update_Party_Relationship
221 -- Type : Public
222 -- Pre-Req :
223 -- Parameters:
224 -- IN
225 -- p_api_version_number IN NUMBER Required
226 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
227 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
228 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
229 -- P_Party_Relationship_Rec IN Party_Relationship_Rec_Type
230 -- Version : Current version 2.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 PROCEDURE Update_Party_Relationship(
237 P_Api_Version_Number IN NUMBER,
238 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
239 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
240 P_Party_Rltship_Rec IN ASO_QUOTE_PUB.Party_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_party_rltship_REC,
241 X_party_relationship_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
242 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
243 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
244 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
245 );
246
247
248
249
250 -- *******************************************************
251 -- Start of Comments
252 -- *******************************************************
253 -- API Name: Delete_Party_Relationship
254 -- Type : Public
255 -- Pre-Req :
256 -- Parameters:
257 -- IN
258 -- p_api_version_number IN NUMBER Required
259 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
260 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
261 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
262 -- P_Party_Relationship_Rec IN Party_Relationship_Rec_Type
263 --
264 -- End of Comments
265 --
266 PROCEDURE Delete_Party_Relationship(
267 P_Api_Version_Number IN NUMBER,
268 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
269 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
270 P_Party_Rltship_Rec IN ASO_QUOTE_PUB.Party_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_party_rltship_REC,
271 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
272 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
273 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
274 );
275
276
277
278 -- *******************************************************
279 -- Start of Comments
280 -- *******************************************************
281 -- API Name: Create_Object_Relationship
282 -- Type : Public
283 -- Pre-Req :
284 -- Parameters:
285 -- IN
286 -- p_api_version_number IN NUMBER Required
287 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
288 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
289 -- P_Object_Relationship_Rec IN RELATED_OBJ_Rec_Type
290 --
291 -- End of Comments
292 --
293 PROCEDURE Create_Object_Relationship(
294 P_Api_Version_Number IN NUMBER,
295 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
296 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
297 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
298 P_RELATED_OBJ_Rec IN ASO_quote_PUB.RELATED_OBJ_Rec_Type := ASO_quote_PUB.G_MISS_RELATED_OBJ_REC,
299 X_related_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
300 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
301 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
302 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
303 );
304
305
306 -- *******************************************************
307 -- Start of Comments
308 -- *******************************************************
309 -- API Name: Update_Object_Relationship
310 -- Type : Public
311 -- Pre-Req :
312 -- Parameters:
313 -- IN
314 -- p_api_version_number IN NUMBER Required
315 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
316 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
317 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
318 -- P_Object_Relationship_Rec IN RELATED_OBJ_Rec_Type
319
320 --
321 -- End of Comments
322 --
323 PROCEDURE Update_Object_Relationship(
324 P_Api_Version_Number IN NUMBER,
325 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
326 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
327 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
328 P_RELATED_OBJ_Rec IN ASO_QUOTE_PUB.RELATED_OBJ_Rec_Type,
329 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
330 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
331 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
332 );
333
334
335
336
337 -- *******************************************************
338 -- Start of Comments
339 -- *******************************************************
340 -- API Name: Delete_Object_Relationship
341 -- Type : Public
342 -- Pre-Req :
343 -- Parameters:
344 -- IN
345 -- p_api_version_number IN NUMBER Required
346 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
347 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
348 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
349 -- P_Object_Relationship_Rec IN Object_Relationship_Rec_Type
350 --
351 -- End of Comments
352 --
353 PROCEDURE Delete_Object_Relationship(
354 P_Api_Version_Number IN NUMBER,
355 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
356 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
357 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
358 P_RELATED_OBJ_Rec IN ASO_QUOTE_PUB.RELATED_OBJ_Rec_Type,
359 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
360 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
361 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
362 );
363
364
365 -- *******************************************************
366 -- Start of Comments
367 -- *******************************************************
368 -- API Name: Create_Price_Adj_Relationship
369 -- Type : Public
370 -- Pre-Req :
371 -- Parameters:
372 -- IN
373 -- p_api_version_number IN NUMBER Required
374 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
375 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
376 -- P_Price_Adj_Rltship_Rec IN Price_Adj_Rltship_Rec_Type
377 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
378 -- and basic operation, developer must manually add parameters and business logic as necessary.
379 --
380 -- End of Comments
381 --
382 PROCEDURE Create_Price_Adj_Rltship(
383 P_Api_Version_Number IN NUMBER,
384 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
385 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
386 P_Price_Adj_Rltship_Rec IN ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_REC,
387 X_adj_relationship_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
388 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
389 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
390 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
391 );
392
393
394
395 -- *******************************************************
396 -- Start of Comments
397 -- *******************************************************
398 -- API Name: Update_Price_Adj_Relationship
399 -- Type : Public
400 -- Pre-Req :
401 -- Parameters:
402 -- IN
403 -- p_api_version_number IN NUMBER Required
404 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
405 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
406 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
407 -- P_Price_Adj_Rltship_Rec IN Price_Adj_Rltship_Rec_Type
408 -- Version : Current version 2.0
409 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
410 -- and basic operation, developer must manually add parameters and business logic as necessary.
411 --
412 -- End of Comments
413 --
414 PROCEDURE Update_Price_Adj_Rltship(
415 P_Api_Version_Number IN NUMBER,
416 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
417 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
418 P_Price_Adj_Rltship_Rec IN ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_REC,
419 X_adj_relationship_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
420 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
421 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
422 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
423 );
424
425
426
427 -- *******************************************************
428 -- Start of Comments
429 -- *******************************************************
430 -- API Name: Delete_Price_Adj__Relationship
431 -- Type : Public
432 -- Pre-Req :
433 -- Parameters:
434 -- IN
435 -- p_api_version_number IN NUMBER Required
436 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
437 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
438 -- p_identity_salesforce_id IN NUMBER Optional Default = NUL
439 -- P_Price_Adj_Rltship_Rec IN Price_Adj_Rltship_Rec_Type
440 -- Version : Current version 2.0
441 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
442 -- and basic operation, developer must manually add parameters and business logic as necessary.
443 --
444 -- End of Comments
445 --
446 PROCEDURE Delete_Price_Adj_Rltship(
447 P_Api_Version_Number IN NUMBER,
448 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
449 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
450 P_Price_Adj_Rltship_Rec IN ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_REC,
451 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
452 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
453 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
454 );
455
456
457 END ASO_RLTSHIP_PUB;