125: -- Parameters
126: --
127: -- IN
128: -- p_api_version_number IN NUMBER Required
129: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
130: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
131: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
132: -- p_adj_new_line_rec IN adj_new_line_rec_type Required
133: --
126: --
127: -- IN
128: -- p_api_version_number IN NUMBER Required
129: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
130: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
131: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
132: -- p_adj_new_line_rec IN adj_new_line_rec_type Required
133: --
134: -- OUT
127: -- IN
128: -- p_api_version_number IN NUMBER Required
129: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
130: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
131: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
132: -- p_adj_new_line_rec IN adj_new_line_rec_type Required
133: --
134: -- OUT
135: -- x_return_status OUT VARCHAR2
144: --
145:
146: PROCEDURE Create_Adj_New_Line(
147: p_api_version_number IN NUMBER,
148: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
149: p_commit IN VARCHAR2 := FND_API.G_FALSE,
150: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
151:
152: x_return_status OUT NOCOPY VARCHAR2,
145:
146: PROCEDURE Create_Adj_New_Line(
147: p_api_version_number IN NUMBER,
148: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
149: p_commit IN VARCHAR2 := FND_API.G_FALSE,
150: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
151:
152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_count OUT NOCOPY NUMBER,
146: PROCEDURE Create_Adj_New_Line(
147: p_api_version_number IN NUMBER,
148: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
149: p_commit IN VARCHAR2 := FND_API.G_FALSE,
150: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
151:
152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_count OUT NOCOPY NUMBER,
154: x_msg_data OUT NOCOPY VARCHAR2,
169: -- Parameters
170: --
171: -- IN
172: -- p_api_version_number IN NUMBER Required
173: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
174: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
175: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
176: -- p_adj_new_line_rec IN adj_new_line_rec_type Required
177: --
170: --
171: -- IN
172: -- p_api_version_number IN NUMBER Required
173: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
174: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
175: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
176: -- p_adj_new_line_rec IN adj_new_line_rec_type Required
177: --
178: -- OUT
171: -- IN
172: -- p_api_version_number IN NUMBER Required
173: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
174: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
175: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
176: -- p_adj_new_line_rec IN adj_new_line_rec_type Required
177: --
178: -- OUT
179: -- x_return_status OUT NOCOPY VARCHAR2
188: --
189:
190: PROCEDURE Update_Adj_New_Line(
191: p_api_version_number IN NUMBER,
192: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
193: p_commit IN VARCHAR2 := FND_API.G_FALSE,
194: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
195:
196: x_return_status OUT NOCOPY VARCHAR2,
189:
190: PROCEDURE Update_Adj_New_Line(
191: p_api_version_number IN NUMBER,
192: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
193: p_commit IN VARCHAR2 := FND_API.G_FALSE,
194: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
195:
196: x_return_status OUT NOCOPY VARCHAR2,
197: x_msg_count OUT NOCOPY NUMBER,
190: PROCEDURE Update_Adj_New_Line(
191: p_api_version_number IN NUMBER,
192: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
193: p_commit IN VARCHAR2 := FND_API.G_FALSE,
194: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
195:
196: x_return_status OUT NOCOPY VARCHAR2,
197: x_msg_count OUT NOCOPY NUMBER,
198: x_msg_data OUT NOCOPY VARCHAR2,
213: -- Parameters
214: --
215: -- IN
216: -- p_api_version_number IN NUMBER Required
217: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
218: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
219: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
220: -- p_OFFER_ADJ_NEW_LINE_ID IN NUMBER
221: -- p_object_version_number IN NUMBER Optional Default = NULL
214: --
215: -- IN
216: -- p_api_version_number IN NUMBER Required
217: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
218: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
219: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
220: -- p_OFFER_ADJ_NEW_LINE_ID IN NUMBER
221: -- p_object_version_number IN NUMBER Optional Default = NULL
222: --
215: -- IN
216: -- p_api_version_number IN NUMBER Required
217: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
218: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
219: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
220: -- p_OFFER_ADJ_NEW_LINE_ID IN NUMBER
221: -- p_object_version_number IN NUMBER Optional Default = NULL
222: --
223: -- OUT
233: --
234:
235: PROCEDURE Delete_Adj_New_Line(
236: p_api_version_number IN NUMBER,
237: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
238: p_commit IN VARCHAR2 := FND_API.G_FALSE,
239: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
240: x_return_status OUT NOCOPY VARCHAR2,
241: x_msg_count OUT NOCOPY NUMBER,
234:
235: PROCEDURE Delete_Adj_New_Line(
236: p_api_version_number IN NUMBER,
237: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
238: p_commit IN VARCHAR2 := FND_API.G_FALSE,
239: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
240: x_return_status OUT NOCOPY VARCHAR2,
241: x_msg_count OUT NOCOPY NUMBER,
242: x_msg_data OUT NOCOPY VARCHAR2,
235: PROCEDURE Delete_Adj_New_Line(
236: p_api_version_number IN NUMBER,
237: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
238: p_commit IN VARCHAR2 := FND_API.G_FALSE,
239: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
240: x_return_status OUT NOCOPY VARCHAR2,
241: x_msg_count OUT NOCOPY NUMBER,
242: x_msg_data OUT NOCOPY VARCHAR2,
243: p_offer_adj_new_line_id IN NUMBER,
256: -- Parameters
257: --
258: -- IN
259: -- p_api_version_number IN NUMBER Required
260: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
261: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
262: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
263: -- p_adj_new_line_rec IN adj_new_line_rec_type Required
264: --
257: --
258: -- IN
259: -- p_api_version_number IN NUMBER Required
260: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
261: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
262: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
263: -- p_adj_new_line_rec IN adj_new_line_rec_type Required
264: --
265: -- OUT
258: -- IN
259: -- p_api_version_number IN NUMBER Required
260: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
261: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
262: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
263: -- p_adj_new_line_rec IN adj_new_line_rec_type Required
264: --
265: -- OUT
266: -- x_return_status OUT NOCOPY VARCHAR2
275: --
276:
277: PROCEDURE Lock_Adj_New_Line(
278: p_api_version_number IN NUMBER,
279: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
280:
281: x_return_status OUT NOCOPY VARCHAR2,
282: x_msg_count OUT NOCOPY NUMBER,
283: x_msg_data OUT NOCOPY VARCHAR2,
300:
301:
302: PROCEDURE Validate_adj_new_line(
303: p_api_version_number IN NUMBER,
304: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
305: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
306: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_update,
307: p_adj_new_line_rec IN adj_new_line_rec_type,
308: x_return_status OUT NOCOPY VARCHAR2,
301:
302: PROCEDURE Validate_adj_new_line(
303: p_api_version_number IN NUMBER,
304: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
305: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
306: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_update,
307: p_adj_new_line_rec IN adj_new_line_rec_type,
308: x_return_status OUT NOCOPY VARCHAR2,
309: x_msg_count OUT NOCOPY NUMBER,
339: -- End of Comments
340:
341: PROCEDURE Validate_adj_new_line_rec(
342: p_api_version_number IN NUMBER,
343: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
344: x_return_status OUT NOCOPY VARCHAR2,
345: x_msg_count OUT NOCOPY NUMBER,
346: x_msg_data OUT NOCOPY VARCHAR2,
347: p_adj_new_line_rec IN adj_new_line_rec_type
348: );
349:
350: PROCEDURE Create_Adj_New_Disc(
351: p_api_version_number IN NUMBER,
352: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
353: p_commit IN VARCHAR2 := FND_API.G_FALSE,
354: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
355:
356: x_return_status OUT NOCOPY VARCHAR2,
349:
350: PROCEDURE Create_Adj_New_Disc(
351: p_api_version_number IN NUMBER,
352: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
353: p_commit IN VARCHAR2 := FND_API.G_FALSE,
354: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
355:
356: x_return_status OUT NOCOPY VARCHAR2,
357: x_msg_count OUT NOCOPY NUMBER,
350: PROCEDURE Create_Adj_New_Disc(
351: p_api_version_number IN NUMBER,
352: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
353: p_commit IN VARCHAR2 := FND_API.G_FALSE,
354: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
355:
356: x_return_status OUT NOCOPY VARCHAR2,
357: x_msg_count OUT NOCOPY NUMBER,
358: x_msg_data OUT NOCOPY VARCHAR2,
362: );
363:
364: PROCEDURE Update_Adj_New_Disc(
365: p_api_version_number IN NUMBER,
366: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
367: p_commit IN VARCHAR2 := FND_API.G_FALSE,
368: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
369:
370: x_return_status OUT NOCOPY VARCHAR2,
363:
364: PROCEDURE Update_Adj_New_Disc(
365: p_api_version_number IN NUMBER,
366: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
367: p_commit IN VARCHAR2 := FND_API.G_FALSE,
368: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
369:
370: x_return_status OUT NOCOPY VARCHAR2,
371: x_msg_count OUT NOCOPY NUMBER,
364: PROCEDURE Update_Adj_New_Disc(
365: p_api_version_number IN NUMBER,
366: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
367: p_commit IN VARCHAR2 := FND_API.G_FALSE,
368: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
369:
370: x_return_status OUT NOCOPY VARCHAR2,
371: x_msg_count OUT NOCOPY NUMBER,
372: x_msg_data OUT NOCOPY VARCHAR2,