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
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: --
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,
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,
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:
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
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,
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
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:
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: --
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,
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,
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.
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,
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,
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:
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,
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,
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
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
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,
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
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
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
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,
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,
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
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
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,
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,
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: --
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
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,
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
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
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: --
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,
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,
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,
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:
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,
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,
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
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: --
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
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,
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,
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
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.
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,
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,
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
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
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,
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,
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
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
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,
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