21: --
22: -- Standard IN Parameters:
23: -- p_api_version IN NUMBER Required
24: -- p_init_msg_list IN VARCHAR2 Optional
25: -- Default = FND_API.G_FALSE
26: -- p_commit IN VARCHAR2 Optional
27: -- Default = FND_API.G_FALSE
28: --
29: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
23: -- p_api_version IN NUMBER Required
24: -- p_init_msg_list IN VARCHAR2 Optional
25: -- Default = FND_API.G_FALSE
26: -- p_commit IN VARCHAR2 Optional
27: -- Default = FND_API.G_FALSE
28: --
29: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
30: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
31: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
102:
103: PROCEDURE UPDATE_NOTICE
104: (
105: p_api_version IN NUMBER,
106: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
107: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
108: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
109: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
110: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
103: PROCEDURE UPDATE_NOTICE
104: (
105: p_api_version IN NUMBER,
106: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
107: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
108: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
109: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
110: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
111: p_header_rec IN OE_Order_PUB.Header_Rec_Type :=
177: --
178: -- Standard IN Parameters:
179: -- p_api_version IN NUMBER Required
180: -- p_init_msg_list IN VARCHAR2 Optional
181: -- Default = FND_API.G_FALSE
182: -- p_commit IN VARCHAR2 Optional
183: -- Default = FND_API.G_FALSE
184: --
185: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
179: -- p_api_version IN NUMBER Required
180: -- p_init_msg_list IN VARCHAR2 Optional
181: -- Default = FND_API.G_FALSE
182: -- p_commit IN VARCHAR2 Optional
183: -- Default = FND_API.G_FALSE
184: --
185: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
186: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
187: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
232:
233: PROCEDURE GET_NOTICE
234: (
235: p_api_version IN NUMBER,
236: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
237: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
238: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
239: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
240: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
233: PROCEDURE GET_NOTICE
234: (
235: p_api_version IN NUMBER,
236: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
237: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
238: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
239: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
240: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
241: p_app_short_name IN VARCHAR2,
288: --
289: -- Standard IN Parameters:
290: -- p_api_version IN NUMBER Required
291: -- p_init_msg_list IN VARCHAR2 Optional
292: -- Default = FND_API.G_FALSE
293: -- p_commit IN VARCHAR2 Optional
294: -- Default = FND_API.G_FALSE
295: --
296: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
290: -- p_api_version IN NUMBER Required
291: -- p_init_msg_list IN VARCHAR2 Optional
292: -- Default = FND_API.G_FALSE
293: -- p_commit IN VARCHAR2 Optional
294: -- Default = FND_API.G_FALSE
295: --
296: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
297: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
298: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
371:
372: PROCEDURE HANDLE_EXCEPTION
373: (
374: p_api_version IN NUMBER,
375: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
376: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
377: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
378: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
379: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
372: PROCEDURE HANDLE_EXCEPTION
373: (
374: p_api_version IN NUMBER,
375: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
376: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
377: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
378: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
379: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
380: p_app_short_name IN VARCHAR2,
448: --
449: -- Standard IN Parameters:
450: -- p_api_version IN NUMBER Required
451: -- p_init_msg_list IN VARCHAR2 Optional
452: -- Default = FND_API.G_FALSE
453: -- p_commit IN VARCHAR2 Optional
454: -- Default = FND_API.G_FALSE
455: --
456: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
450: -- p_api_version IN NUMBER Required
451: -- p_init_msg_list IN VARCHAR2 Optional
452: -- Default = FND_API.G_FALSE
453: -- p_commit IN VARCHAR2 Optional
454: -- Default = FND_API.G_FALSE
455: --
456: -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
457: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
458: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
507:
508: PROCEDURE GET_EXCEPTION
509: (
510: p_api_version IN NUMBER,
511: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
512: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
513: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
514: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
515: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
508: PROCEDURE GET_EXCEPTION
509: (
510: p_api_version IN NUMBER,
511: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
512: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
513: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
514: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
515: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
516: p_app_short_name IN VARCHAR2,