67: -- Parameters :
68: --
69: -- Standard IN Parameters :
70: -- p_api_version IN NUMBER Required
71: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
72: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
73: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
74: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
75: -- p_module_type IN VARCHAR2 Default NULL.
68: --
69: -- Standard IN Parameters :
70: -- p_api_version IN NUMBER Required
71: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
72: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
73: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
74: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
75: -- p_module_type IN VARCHAR2 Default NULL.
76: --
69: -- Standard IN Parameters :
70: -- p_api_version IN NUMBER Required
71: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
72: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
73: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
74: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
75: -- p_module_type IN VARCHAR2 Default NULL.
76: --
77: -- Standard OUT Parameters :
70: -- p_api_version IN NUMBER Required
71: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
72: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
73: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
74: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
75: -- p_module_type IN VARCHAR2 Default NULL.
76: --
77: -- Standard OUT Parameters :
78: -- x_return_status OUT VARCHAR2 Required
87: -- Initial Version 1.0
88: -------------------------------------------------------------------
89: PROCEDURE Integrate_to_Projects(
90: p_api_version IN NUMBER,
91: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
92: p_commit IN VARCHAR2 := Fnd_Api.g_false,
93: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
94: p_module_type IN VARCHAR2 := Null,
95: p_visit_id IN NUMBER,
88: -------------------------------------------------------------------
89: PROCEDURE Integrate_to_Projects(
90: p_api_version IN NUMBER,
91: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
92: p_commit IN VARCHAR2 := Fnd_Api.g_false,
93: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
94: p_module_type IN VARCHAR2 := Null,
95: p_visit_id IN NUMBER,
96: x_return_status OUT NOCOPY VARCHAR2,
89: PROCEDURE Integrate_to_Projects(
90: p_api_version IN NUMBER,
91: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
92: p_commit IN VARCHAR2 := Fnd_Api.g_false,
93: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
94: p_module_type IN VARCHAR2 := Null,
95: p_visit_id IN NUMBER,
96: x_return_status OUT NOCOPY VARCHAR2,
97: x_msg_count OUT NOCOPY NUMBER,
105: -- Parameters :
106: --
107: -- Standard IN Parameters :
108: -- p_api_version IN NUMBER Required
109: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
110: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
111: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
112: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
113: -- p_module_type IN VARCHAR2 Default NULL.
106: --
107: -- Standard IN Parameters :
108: -- p_api_version IN NUMBER Required
109: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
110: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
111: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
112: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
113: -- p_module_type IN VARCHAR2 Default NULL.
114: --
107: -- Standard IN Parameters :
108: -- p_api_version IN NUMBER Required
109: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
110: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
111: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
112: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
113: -- p_module_type IN VARCHAR2 Default NULL.
114: --
115: -- Standard OUT Parameters :
108: -- p_api_version IN NUMBER Required
109: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
110: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
111: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
112: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
113: -- p_module_type IN VARCHAR2 Default NULL.
114: --
115: -- Standard OUT Parameters :
116: -- x_return_status OUT VARCHAR2 Required
125: -- Initial Version 1.0
126: -------------------------------------------------------------------
127: PROCEDURE Add_Task_to_Project(
128: p_api_version IN NUMBER,
129: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
130: p_commit IN VARCHAR2 := Fnd_Api.g_false,
131: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
132: p_module_type IN VARCHAR2 := Null,
133: p_visit_task_id IN NUMBER,
126: -------------------------------------------------------------------
127: PROCEDURE Add_Task_to_Project(
128: p_api_version IN NUMBER,
129: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
130: p_commit IN VARCHAR2 := Fnd_Api.g_false,
131: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
132: p_module_type IN VARCHAR2 := Null,
133: p_visit_task_id IN NUMBER,
134: x_return_status OUT NOCOPY VARCHAR2,
127: PROCEDURE Add_Task_to_Project(
128: p_api_version IN NUMBER,
129: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
130: p_commit IN VARCHAR2 := Fnd_Api.g_false,
131: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
132: p_module_type IN VARCHAR2 := Null,
133: p_visit_task_id IN NUMBER,
134: x_return_status OUT NOCOPY VARCHAR2,
135: x_msg_count OUT NOCOPY NUMBER,
143: -- Parameters :
144: --
145: -- Standard IN Parameters :
146: -- p_api_version IN NUMBER Required
147: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
148: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
149: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
150: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
151: -- p_module_type IN VARCHAR2 Default NULL.
144: --
145: -- Standard IN Parameters :
146: -- p_api_version IN NUMBER Required
147: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
148: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
149: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
150: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
151: -- p_module_type IN VARCHAR2 Default NULL.
152: --
145: -- Standard IN Parameters :
146: -- p_api_version IN NUMBER Required
147: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
148: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
149: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
150: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
151: -- p_module_type IN VARCHAR2 Default NULL.
152: --
153: -- Standard OUT Parameters :
146: -- p_api_version IN NUMBER Required
147: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
148: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
149: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
150: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
151: -- p_module_type IN VARCHAR2 Default NULL.
152: --
153: -- Standard OUT Parameters :
154: -- x_return_status OUT VARCHAR2 Required
175: -- Parameters :
176: --
177: -- Standard IN Parameters :
178: -- p_api_version IN NUMBER Required
179: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
180: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
181: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
182: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
183: -- p_module_type IN VARCHAR2 Default NULL.
176: --
177: -- Standard IN Parameters :
178: -- p_api_version IN NUMBER Required
179: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
180: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
181: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
182: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
183: -- p_module_type IN VARCHAR2 Default NULL.
184: --
177: -- Standard IN Parameters :
178: -- p_api_version IN NUMBER Required
179: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
180: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
181: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
182: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
183: -- p_module_type IN VARCHAR2 Default NULL.
184: --
185: -- Standard OUT Parameters :
178: -- p_api_version IN NUMBER Required
179: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
180: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
181: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
182: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
183: -- p_module_type IN VARCHAR2 Default NULL.
184: --
185: -- Standard OUT Parameters :
186: -- x_return_status OUT VARCHAR2 Required
196: -------------------------------------------------------------------
197:
198: PROCEDURE Update_Project(
199: p_api_version IN NUMBER,
200: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
201: p_commit IN VARCHAR2 := Fnd_Api.g_false,
202: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
203: p_module_type IN VARCHAR2 := Null,
204: p_visit_id IN NUMBER,
197:
198: PROCEDURE Update_Project(
199: p_api_version IN NUMBER,
200: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
201: p_commit IN VARCHAR2 := Fnd_Api.g_false,
202: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
203: p_module_type IN VARCHAR2 := Null,
204: p_visit_id IN NUMBER,
205:
198: PROCEDURE Update_Project(
199: p_api_version IN NUMBER,
200: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
201: p_commit IN VARCHAR2 := Fnd_Api.g_false,
202: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
203: p_module_type IN VARCHAR2 := Null,
204: p_visit_id IN NUMBER,
205:
206: x_return_status OUT NOCOPY VARCHAR2,
215: -- Parameters :
216: --
217: -- Standard IN Parameters :
218: -- p_api_version IN NUMBER Required
219: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
220: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
221: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
222: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
223: -- p_module_type IN VARCHAR2 Default NULL.
216: --
217: -- Standard IN Parameters :
218: -- p_api_version IN NUMBER Required
219: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
220: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
221: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
222: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
223: -- p_module_type IN VARCHAR2 Default NULL.
224: --
217: -- Standard IN Parameters :
218: -- p_api_version IN NUMBER Required
219: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
220: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
221: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
222: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
223: -- p_module_type IN VARCHAR2 Default NULL.
224: --
225: -- Standard OUT Parameters :
218: -- p_api_version IN NUMBER Required
219: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
220: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
221: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
222: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
223: -- p_module_type IN VARCHAR2 Default NULL.
224: --
225: -- Standard OUT Parameters :
226: -- x_return_status OUT VARCHAR2 Required
235: -- Initial Version 1.0
236: -------------------------------------------------------------------
237: PROCEDURE Delete_Project(
238: p_api_version IN NUMBER,
239: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
240: p_commit IN VARCHAR2 := Fnd_Api.g_false,
241: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
242: p_module_type IN VARCHAR2 := Null,
243: p_visit_id IN NUMBER,
236: -------------------------------------------------------------------
237: PROCEDURE Delete_Project(
238: p_api_version IN NUMBER,
239: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
240: p_commit IN VARCHAR2 := Fnd_Api.g_false,
241: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
242: p_module_type IN VARCHAR2 := Null,
243: p_visit_id IN NUMBER,
244: x_return_status OUT NOCOPY VARCHAR2,
237: PROCEDURE Delete_Project(
238: p_api_version IN NUMBER,
239: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
240: p_commit IN VARCHAR2 := Fnd_Api.g_false,
241: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
242: p_module_type IN VARCHAR2 := Null,
243: p_visit_id IN NUMBER,
244: x_return_status OUT NOCOPY VARCHAR2,
245: x_msg_count OUT NOCOPY NUMBER,
253: -- Parameters :
254: --
255: -- Standard IN Parameters :
256: -- p_api_version IN NUMBER Required
257: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
258: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
259: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
260: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
261: -- p_module_type IN VARCHAR2 Default NULL.
254: --
255: -- Standard IN Parameters :
256: -- p_api_version IN NUMBER Required
257: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
258: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
259: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
260: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
261: -- p_module_type IN VARCHAR2 Default NULL.
262: --
255: -- Standard IN Parameters :
256: -- p_api_version IN NUMBER Required
257: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
258: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
259: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
260: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
261: -- p_module_type IN VARCHAR2 Default NULL.
262: --
263: -- Standard OUT Parameters :
256: -- p_api_version IN NUMBER Required
257: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
258: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
259: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
260: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
261: -- p_module_type IN VARCHAR2 Default NULL.
262: --
263: -- Standard OUT Parameters :
264: -- x_return_status OUT VARCHAR2 Required
273: -- Initial Version 1.0
274: -------------------------------------------------------------------
275: PROCEDURE Validate_Before_Production
276: (p_api_version IN NUMBER,
277: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
278: p_commit IN VARCHAR2 := Fnd_Api.g_false,
279: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
280: p_module_type IN VARCHAR2 := 'JSP',
281: p_visit_id IN NUMBER,
274: -------------------------------------------------------------------
275: PROCEDURE Validate_Before_Production
276: (p_api_version IN NUMBER,
277: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
278: p_commit IN VARCHAR2 := Fnd_Api.g_false,
279: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
280: p_module_type IN VARCHAR2 := 'JSP',
281: p_visit_id IN NUMBER,
282: x_error_tbl OUT NOCOPY error_tbl_type,
275: PROCEDURE Validate_Before_Production
276: (p_api_version IN NUMBER,
277: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
278: p_commit IN VARCHAR2 := Fnd_Api.g_false,
279: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
280: p_module_type IN VARCHAR2 := 'JSP',
281: p_visit_id IN NUMBER,
282: x_error_tbl OUT NOCOPY error_tbl_type,
283: x_return_status OUT NOCOPY VARCHAR2,
293: -- Parameters :
294: --
295: -- Standard IN Parameters :
296: -- p_api_version IN NUMBER Required
297: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
298: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
299: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
300: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
301: -- p_module_type IN VARCHAR2 Default NULL.
294: --
295: -- Standard IN Parameters :
296: -- p_api_version IN NUMBER Required
297: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
298: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
299: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
300: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
301: -- p_module_type IN VARCHAR2 Default NULL.
302: --
295: -- Standard IN Parameters :
296: -- p_api_version IN NUMBER Required
297: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
298: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
299: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
300: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
301: -- p_module_type IN VARCHAR2 Default NULL.
302: --
303: -- Standard OUT Parameters :
296: -- p_api_version IN NUMBER Required
297: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
298: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
299: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
300: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
301: -- p_module_type IN VARCHAR2 Default NULL.
302: --
303: -- Standard OUT Parameters :
304: -- x_return_status OUT VARCHAR2 Required
313: -- Initial Version 1.0
314: -------------------------------------------------------------------
315: PROCEDURE Create_Job_Tasks(
316: p_api_version IN NUMBER :=1.0,
317: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
318: p_commit IN VARCHAR2 := Fnd_Api.g_false,
319: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
320: p_module_type IN VARCHAR2 := Null,
321: p_x_task_Tbl IN OUT NOCOPY Task_Tbl_Type,
314: -------------------------------------------------------------------
315: PROCEDURE Create_Job_Tasks(
316: p_api_version IN NUMBER :=1.0,
317: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
318: p_commit IN VARCHAR2 := Fnd_Api.g_false,
319: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
320: p_module_type IN VARCHAR2 := Null,
321: p_x_task_Tbl IN OUT NOCOPY Task_Tbl_Type,
322: x_return_status OUT NOCOPY VARCHAR2,
315: PROCEDURE Create_Job_Tasks(
316: p_api_version IN NUMBER :=1.0,
317: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
318: p_commit IN VARCHAR2 := Fnd_Api.g_false,
319: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
320: p_module_type IN VARCHAR2 := Null,
321: p_x_task_Tbl IN OUT NOCOPY Task_Tbl_Type,
322: x_return_status OUT NOCOPY VARCHAR2,
323: x_msg_count OUT NOCOPY NUMBER,
332: -- Parameters :
333: --
334: -- Standard IN Parameters :
335: -- p_api_version IN NUMBER Required
336: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
337: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
338: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
339: --
340: -- Standard OUT Parameters :
333: --
334: -- Standard IN Parameters :
335: -- p_api_version IN NUMBER Required
336: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
337: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
338: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
339: --
340: -- Standard OUT Parameters :
341: -- x_return_status OUT VARCHAR2 Required
334: -- Standard IN Parameters :
335: -- p_api_version IN NUMBER Required
336: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
337: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
338: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
339: --
340: -- Standard OUT Parameters :
341: -- x_return_status OUT VARCHAR2 Required
342: -- x_msg_count OUT NUMBER Required
352: -- End of Comments.
353: --
354: PROCEDURE Release_Visit (
355: p_api_version IN NUMBER,
356: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
357: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
358: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
359: p_module_type IN VARCHAR2 := NULL,
360: p_visit_id IN NUMBER,
353: --
354: PROCEDURE Release_Visit (
355: p_api_version IN NUMBER,
356: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
357: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
358: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
359: p_module_type IN VARCHAR2 := NULL,
360: p_visit_id IN NUMBER,
361: p_release_flag IN VARCHAR2 := 'N',
354: PROCEDURE Release_Visit (
355: p_api_version IN NUMBER,
356: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
357: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
358: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
359: p_module_type IN VARCHAR2 := NULL,
360: p_visit_id IN NUMBER,
361: p_release_flag IN VARCHAR2 := 'N',
362: p_orig_visit_id IN NUMBER := NULL, -- By yazhou 08/06/04 for TC changes
374: -- Parameters :
375: --
376: -- Standard IN Parameters :
377: -- p_api_version IN NUMBER Required
378: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
379: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
380: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
381: --
382: -- Standard OUT Parameters :
375: --
376: -- Standard IN Parameters :
377: -- p_api_version IN NUMBER Required
378: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
379: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
380: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
381: --
382: -- Standard OUT Parameters :
383: -- x_return_status OUT VARCHAR2 Required
376: -- Standard IN Parameters :
377: -- p_api_version IN NUMBER Required
378: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
379: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
380: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
381: --
382: -- Standard OUT Parameters :
383: -- x_return_status OUT VARCHAR2 Required
384: -- x_msg_count OUT NUMBER Required
396: -- End of Comments.
397: --
398: PROCEDURE Release_MR (
399: p_api_version IN NUMBER,
400: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
401: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
402: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
403: p_module_type IN VARCHAR2 := NULL,
404: p_visit_id IN NUMBER,
397: --
398: PROCEDURE Release_MR (
399: p_api_version IN NUMBER,
400: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
401: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
402: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
403: p_module_type IN VARCHAR2 := NULL,
404: p_visit_id IN NUMBER,
405: p_unit_effectivity_id IN NUMBER,
398: PROCEDURE Release_MR (
399: p_api_version IN NUMBER,
400: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
401: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
402: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
403: p_module_type IN VARCHAR2 := NULL,
404: p_visit_id IN NUMBER,
405: p_unit_effectivity_id IN NUMBER,
406: p_release_flag IN VARCHAR2 := 'N',
418: -- Parameters :
419: --
420: -- Standard IN Parameters :
421: -- p_api_version IN NUMBER Required
422: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
423: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
424: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
425: -- p_module_type IN VARCHAR2 Default Null
426: --
419: --
420: -- Standard IN Parameters :
421: -- p_api_version IN NUMBER Required
422: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
423: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
424: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
425: -- p_module_type IN VARCHAR2 Default Null
426: --
427: -- Standard OUT Parameters :
420: -- Standard IN Parameters :
421: -- p_api_version IN NUMBER Required
422: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
423: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
424: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
425: -- p_module_type IN VARCHAR2 Default Null
426: --
427: -- Standard OUT Parameters :
428: -- x_return_status OUT VARCHAR2 Required
439: -- End of Comments.
440: --
441: PROCEDURE Release_Tasks(
442: p_api_version IN NUMBER,
443: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
444: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
445: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
446: p_module_type IN VARCHAR2 := Null,
447: p_visit_id IN NUMBER,
440: --
441: PROCEDURE Release_Tasks(
442: p_api_version IN NUMBER,
443: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
444: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
445: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
446: p_module_type IN VARCHAR2 := Null,
447: p_visit_id IN NUMBER,
448: p_tasks_tbl IN Task_Tbl_Type,
441: PROCEDURE Release_Tasks(
442: p_api_version IN NUMBER,
443: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
444: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
445: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
446: p_module_type IN VARCHAR2 := Null,
447: p_visit_id IN NUMBER,
448: p_tasks_tbl IN Task_Tbl_Type,
449: p_release_flag IN VARCHAR2 := 'N',