124: -- Parameters
125: --
126: -- IN
127: -- p_api_version_number IN NUMBER Required
128: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
129: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
130: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
131: -- p_process_rec IN process_rec_type Required
132: --
125: --
126: -- IN
127: -- p_api_version_number IN NUMBER Required
128: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
129: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
130: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
131: -- p_process_rec IN process_rec_type Required
132: --
133: -- OUT NOCOPY
126: -- IN
127: -- p_api_version_number IN NUMBER Required
128: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
129: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
130: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
131: -- p_process_rec IN process_rec_type Required
132: --
133: -- OUT NOCOPY
134: -- x_return_status OUT NOCOPY VARCHAR2
143: --
144:
145: PROCEDURE Create_Process_rec(
146: p_api_version_number IN NUMBER,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148: p_commit IN VARCHAR2 := FND_API.G_FALSE,
149: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
150:
151: x_return_status OUT NOCOPY VARCHAR2,
144:
145: PROCEDURE Create_Process_rec(
146: p_api_version_number IN NUMBER,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148: p_commit IN VARCHAR2 := FND_API.G_FALSE,
149: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
150:
151: x_return_status OUT NOCOPY VARCHAR2,
152: x_msg_count OUT NOCOPY NUMBER,
145: PROCEDURE Create_Process_rec(
146: p_api_version_number IN NUMBER,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148: p_commit IN VARCHAR2 := FND_API.G_FALSE,
149: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
150:
151: x_return_status OUT NOCOPY VARCHAR2,
152: x_msg_count OUT NOCOPY NUMBER,
153: x_msg_data OUT NOCOPY VARCHAR2,
168: -- Parameters
169: --
170: -- IN
171: -- p_api_version_number IN NUMBER Required
172: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
173: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
174: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
175: -- p_process_tbl IN process_tbl_type Required
176: --
169: --
170: -- IN
171: -- p_api_version_number IN NUMBER Required
172: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
173: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
174: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
175: -- p_process_tbl IN process_tbl_type Required
176: --
177: -- OUT NOCOPY
170: -- IN
171: -- p_api_version_number IN NUMBER Required
172: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
173: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
174: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
175: -- p_process_tbl IN process_tbl_type Required
176: --
177: -- OUT NOCOPY
178: -- x_return_status OUT NOCOPY VARCHAR2
187: --
188:
189: PROCEDURE Create_Process(
190: p_api_version_number IN NUMBER,
191: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
192: p_commit IN VARCHAR2 := FND_API.G_FALSE,
193: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
194:
195: x_return_status OUT NOCOPY VARCHAR2,
188:
189: PROCEDURE Create_Process(
190: p_api_version_number IN NUMBER,
191: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
192: p_commit IN VARCHAR2 := FND_API.G_FALSE,
193: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
194:
195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,
189: PROCEDURE Create_Process(
190: p_api_version_number IN NUMBER,
191: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
192: p_commit IN VARCHAR2 := FND_API.G_FALSE,
193: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
194:
195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2,
211: -- Parameters
212: --
213: -- IN
214: -- p_api_version_number IN NUMBER Required
215: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
216: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
217: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
218: -- p_process_rec IN process_rec_type Required
219: --
212: --
213: -- IN
214: -- p_api_version_number IN NUMBER Required
215: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
216: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
217: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
218: -- p_process_rec IN process_rec_type Required
219: --
220: -- OUT NOCOPY
213: -- IN
214: -- p_api_version_number IN NUMBER Required
215: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
216: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
217: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
218: -- p_process_rec IN process_rec_type Required
219: --
220: -- OUT NOCOPY
221: -- x_return_status OUT NOCOPY VARCHAR2
230: --
231:
232: PROCEDURE Update_Process_rec(
233: p_api_version_number IN NUMBER,
234: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
235: p_commit IN VARCHAR2 := FND_API.G_FALSE,
236: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
237:
238: x_return_status OUT NOCOPY VARCHAR2,
231:
232: PROCEDURE Update_Process_rec(
233: p_api_version_number IN NUMBER,
234: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
235: p_commit IN VARCHAR2 := FND_API.G_FALSE,
236: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
237:
238: x_return_status OUT NOCOPY VARCHAR2,
239: x_msg_count OUT NOCOPY NUMBER,
232: PROCEDURE Update_Process_rec(
233: p_api_version_number IN NUMBER,
234: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
235: p_commit IN VARCHAR2 := FND_API.G_FALSE,
236: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
237:
238: x_return_status OUT NOCOPY VARCHAR2,
239: x_msg_count OUT NOCOPY NUMBER,
240: x_msg_data OUT NOCOPY VARCHAR2,
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_process_rec IN process_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_process_rec IN process_rec_type Required
264: --
265: -- OUT NOCOPY
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_process_rec IN process_rec_type Required
264: --
265: -- OUT NOCOPY
266: -- x_return_status OUT NOCOPY VARCHAR2
274: -- ==============================================================================
275: --
276: PROCEDURE Update_Process(
277: p_api_version_number IN NUMBER,
278: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
279: p_commit IN VARCHAR2 := FND_API.G_FALSE,
280: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
281:
282: x_return_status OUT NOCOPY VARCHAR2,
275: --
276: PROCEDURE Update_Process(
277: p_api_version_number IN NUMBER,
278: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
279: p_commit IN VARCHAR2 := FND_API.G_FALSE,
280: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
281:
282: x_return_status OUT NOCOPY VARCHAR2,
283: x_msg_count OUT NOCOPY NUMBER,
276: PROCEDURE Update_Process(
277: p_api_version_number IN NUMBER,
278: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
279: p_commit IN VARCHAR2 := FND_API.G_FALSE,
280: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
281:
282: x_return_status OUT NOCOPY VARCHAR2,
283: x_msg_count OUT NOCOPY NUMBER,
284: x_msg_data OUT NOCOPY VARCHAR2,
298: -- Parameters
299: --
300: -- IN
301: -- p_api_version_number IN NUMBER Required
302: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
303: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
304: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
305: -- p_PROCESS_ID IN NUMBER
306: -- p_object_version_number IN NUMBER Optional Default = NULL
299: --
300: -- IN
301: -- p_api_version_number IN NUMBER Required
302: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
303: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
304: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
305: -- p_PROCESS_ID IN NUMBER
306: -- p_object_version_number IN NUMBER Optional Default = NULL
307: --
300: -- IN
301: -- p_api_version_number IN NUMBER Required
302: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
303: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
304: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
305: -- p_PROCESS_ID IN NUMBER
306: -- p_object_version_number IN NUMBER Optional Default = NULL
307: --
308: -- OUT NOCOPY
318: --
319:
320: PROCEDURE Delete_Process(
321: p_api_version_number IN NUMBER,
322: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
323: p_commit IN VARCHAR2 := FND_API.G_FALSE,
324: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
325: x_return_status OUT NOCOPY VARCHAR2,
326: x_msg_count OUT NOCOPY NUMBER,
319:
320: PROCEDURE Delete_Process(
321: p_api_version_number IN NUMBER,
322: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
323: p_commit IN VARCHAR2 := FND_API.G_FALSE,
324: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
325: x_return_status OUT NOCOPY VARCHAR2,
326: x_msg_count OUT NOCOPY NUMBER,
327: x_msg_data OUT NOCOPY VARCHAR2,
320: PROCEDURE Delete_Process(
321: p_api_version_number IN NUMBER,
322: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
323: p_commit IN VARCHAR2 := FND_API.G_FALSE,
324: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
325: x_return_status OUT NOCOPY VARCHAR2,
326: x_msg_count OUT NOCOPY NUMBER,
327: x_msg_data OUT NOCOPY VARCHAR2,
328: p_process_rev_id IN NUMBER,
341: -- Parameters
342: --
343: -- IN
344: -- p_api_version_number IN NUMBER Required
345: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
346: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
347: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
348: -- p_process_rec IN process_rec_type Required
349: --
342: --
343: -- IN
344: -- p_api_version_number IN NUMBER Required
345: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
346: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
347: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
348: -- p_process_rec IN process_rec_type Required
349: --
350: -- OUT NOCOPY
343: -- IN
344: -- p_api_version_number IN NUMBER Required
345: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
346: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
347: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
348: -- p_process_rec IN process_rec_type Required
349: --
350: -- OUT NOCOPY
351: -- x_return_status OUT NOCOPY VARCHAR2
360: --
361:
362: PROCEDURE Lock_Process(
363: p_api_version_number IN NUMBER,
364: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
365:
366: x_return_status OUT NOCOPY VARCHAR2,
367: x_msg_count OUT NOCOPY NUMBER,
368: x_msg_data OUT NOCOPY VARCHAR2,
384: -- End of Comments
385:
386: PROCEDURE Validate_process(
387: p_api_version_number IN NUMBER,
388: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
389: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
390: p_process_rec IN process_rec_type,
391: x_return_status OUT NOCOPY VARCHAR2,
392: x_msg_count OUT NOCOPY NUMBER,
385:
386: PROCEDURE Validate_process(
387: p_api_version_number IN NUMBER,
388: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
389: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
390: p_process_rec IN process_rec_type,
391: x_return_status OUT NOCOPY VARCHAR2,
392: x_msg_count OUT NOCOPY NUMBER,
393: x_msg_data OUT NOCOPY VARCHAR2
422: -- End of Comments
423:
424: PROCEDURE Validate_process_rec(
425: p_api_version_number IN NUMBER,
426: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
427: x_return_status OUT NOCOPY VARCHAR2,
428: x_msg_count OUT NOCOPY NUMBER,
429: x_msg_data OUT NOCOPY VARCHAR2,
430: p_process_rec IN process_rec_type