DBA Data[Home] [Help]

APPS.ASO_RLTSHIP_PUB dependencies on FND_API

Line 21: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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

Line 22: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 29: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 30: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 49: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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:

Line 50: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 58: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 59: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

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

Line 77: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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:

Line 78: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 85: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 86: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 103: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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.

Line 104: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 113: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 114: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 133: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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:

Line 134: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 143: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 144: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 162: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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

Line 163: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 174: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 175: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

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

Line 193: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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

Line 194: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 206: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 207: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 226: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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

Line 227: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 238: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 239: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 259: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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

Line 260: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 268: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 269: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

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

Line 287: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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

Line 288: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 295: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 296: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 297: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 315: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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:

Line 316: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 325: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 326: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 327: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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

Line 346: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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

Line 347: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 355: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 356: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 357: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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

Line 374: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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.

Line 375: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 384: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 385: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 404: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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

Line 405: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 416: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 417: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 436: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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

Line 437: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 448: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 449: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

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