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,
108: -- Parameters :
109: --
110: -- Standard IN Parameters :
111: -- p_api_version IN NUMBER Required
112: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
113: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
114: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
115: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
116: -- p_module_type IN VARCHAR2 Default NULL.
109: --
110: -- Standard IN Parameters :
111: -- p_api_version IN NUMBER Required
112: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
113: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
114: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
115: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
116: -- p_module_type IN VARCHAR2 Default NULL.
117: --
110: -- Standard IN Parameters :
111: -- p_api_version IN NUMBER Required
112: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
113: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
114: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
115: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
116: -- p_module_type IN VARCHAR2 Default NULL.
117: --
118: -- Standard OUT Parameters :
111: -- p_api_version IN NUMBER Required
112: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
113: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
114: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
115: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
116: -- p_module_type IN VARCHAR2 Default NULL.
117: --
118: -- Standard OUT Parameters :
119: -- x_return_status OUT VARCHAR2 Required
128: -- Initial Version 1.0
129: -------------------------------------------------------------------
130: PROCEDURE Add_Task_to_Project(
131: p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
133: p_commit IN VARCHAR2 := Fnd_Api.g_false,
134: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
135: p_module_type IN VARCHAR2 := Null,
136: p_visit_task_id IN NUMBER,
129: -------------------------------------------------------------------
130: PROCEDURE Add_Task_to_Project(
131: p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
133: p_commit IN VARCHAR2 := Fnd_Api.g_false,
134: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
135: p_module_type IN VARCHAR2 := Null,
136: p_visit_task_id IN NUMBER,
137: x_return_status OUT NOCOPY VARCHAR2,
130: PROCEDURE Add_Task_to_Project(
131: p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
133: p_commit IN VARCHAR2 := Fnd_Api.g_false,
134: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
135: p_module_type IN VARCHAR2 := Null,
136: p_visit_task_id IN NUMBER,
137: x_return_status OUT NOCOPY VARCHAR2,
138: x_msg_count OUT NOCOPY NUMBER,
146: -- Parameters :
147: --
148: -- Standard IN Parameters :
149: -- p_api_version IN NUMBER Required
150: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
151: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
152: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
153: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
154: -- p_module_type IN VARCHAR2 Default NULL.
147: --
148: -- Standard IN Parameters :
149: -- p_api_version IN NUMBER Required
150: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
151: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
152: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
153: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
154: -- p_module_type IN VARCHAR2 Default NULL.
155: --
148: -- Standard IN Parameters :
149: -- p_api_version IN NUMBER Required
150: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
151: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
152: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
153: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
154: -- p_module_type IN VARCHAR2 Default NULL.
155: --
156: -- Standard OUT Parameters :
149: -- p_api_version IN NUMBER Required
150: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
151: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
152: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
153: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
154: -- p_module_type IN VARCHAR2 Default NULL.
155: --
156: -- Standard OUT Parameters :
157: -- x_return_status OUT VARCHAR2 Required
178: -- Parameters :
179: --
180: -- Standard IN Parameters :
181: -- p_api_version IN NUMBER Required
182: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
183: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
184: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
185: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
186: -- p_module_type IN VARCHAR2 Default NULL.
179: --
180: -- Standard IN Parameters :
181: -- p_api_version IN NUMBER Required
182: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
183: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
184: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
185: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
186: -- p_module_type IN VARCHAR2 Default NULL.
187: --
180: -- Standard IN Parameters :
181: -- p_api_version IN NUMBER Required
182: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
183: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
184: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
185: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
186: -- p_module_type IN VARCHAR2 Default NULL.
187: --
188: -- Standard OUT Parameters :
181: -- p_api_version IN NUMBER Required
182: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
183: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
184: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
185: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
186: -- p_module_type IN VARCHAR2 Default NULL.
187: --
188: -- Standard OUT Parameters :
189: -- x_return_status OUT VARCHAR2 Required
199: -------------------------------------------------------------------
200:
201: PROCEDURE Update_Project(
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
204: p_commit IN VARCHAR2 := Fnd_Api.g_false,
205: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
206: p_module_type IN VARCHAR2 := Null,
207: p_visit_id IN NUMBER,
200:
201: PROCEDURE Update_Project(
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
204: p_commit IN VARCHAR2 := Fnd_Api.g_false,
205: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
206: p_module_type IN VARCHAR2 := Null,
207: p_visit_id IN NUMBER,
208:
201: PROCEDURE Update_Project(
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
204: p_commit IN VARCHAR2 := Fnd_Api.g_false,
205: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
206: p_module_type IN VARCHAR2 := Null,
207: p_visit_id IN NUMBER,
208:
209: x_return_status OUT NOCOPY VARCHAR2,
218: -- Parameters :
219: --
220: -- Standard IN Parameters :
221: -- p_api_version IN NUMBER Required
222: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
223: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
224: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
225: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
226: -- p_module_type IN VARCHAR2 Default NULL.
219: --
220: -- Standard IN Parameters :
221: -- p_api_version IN NUMBER Required
222: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
223: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
224: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
225: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
226: -- p_module_type IN VARCHAR2 Default NULL.
227: --
220: -- Standard IN Parameters :
221: -- p_api_version IN NUMBER Required
222: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
223: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
224: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
225: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
226: -- p_module_type IN VARCHAR2 Default NULL.
227: --
228: -- Standard OUT Parameters :
221: -- p_api_version IN NUMBER Required
222: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
223: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
224: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
225: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
226: -- p_module_type IN VARCHAR2 Default NULL.
227: --
228: -- Standard OUT Parameters :
229: -- x_return_status OUT VARCHAR2 Required
238: -- Initial Version 1.0
239: -------------------------------------------------------------------
240: PROCEDURE Delete_Project(
241: p_api_version IN NUMBER,
242: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
243: p_commit IN VARCHAR2 := Fnd_Api.g_false,
244: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
245: p_module_type IN VARCHAR2 := Null,
246: p_visit_id IN NUMBER,
239: -------------------------------------------------------------------
240: PROCEDURE Delete_Project(
241: p_api_version IN NUMBER,
242: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
243: p_commit IN VARCHAR2 := Fnd_Api.g_false,
244: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
245: p_module_type IN VARCHAR2 := Null,
246: p_visit_id IN NUMBER,
247: x_return_status OUT NOCOPY VARCHAR2,
240: PROCEDURE Delete_Project(
241: p_api_version IN NUMBER,
242: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
243: p_commit IN VARCHAR2 := Fnd_Api.g_false,
244: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
245: p_module_type IN VARCHAR2 := Null,
246: p_visit_id IN NUMBER,
247: x_return_status OUT NOCOPY VARCHAR2,
248: x_msg_count OUT NOCOPY NUMBER,
256: -- Parameters :
257: --
258: -- Standard IN Parameters :
259: -- p_api_version IN NUMBER Required
260: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
261: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
262: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
263: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
264: -- p_module_type IN VARCHAR2 Default NULL.
257: --
258: -- Standard IN Parameters :
259: -- p_api_version IN NUMBER Required
260: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
261: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
262: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
263: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
264: -- p_module_type IN VARCHAR2 Default NULL.
265: --
258: -- Standard IN Parameters :
259: -- p_api_version IN NUMBER Required
260: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
261: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
262: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
263: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
264: -- p_module_type IN VARCHAR2 Default NULL.
265: --
266: -- Standard OUT Parameters :
259: -- p_api_version IN NUMBER Required
260: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
261: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
262: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
263: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
264: -- p_module_type IN VARCHAR2 Default NULL.
265: --
266: -- Standard OUT Parameters :
267: -- x_return_status OUT VARCHAR2 Required
276: -- Initial Version 1.0
277: -------------------------------------------------------------------
278: PROCEDURE Validate_Before_Production
279: (p_api_version IN NUMBER,
280: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
281: p_commit IN VARCHAR2 := Fnd_Api.g_false,
282: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
283: p_module_type IN VARCHAR2 := 'JSP',
284: p_visit_id IN NUMBER,
277: -------------------------------------------------------------------
278: PROCEDURE Validate_Before_Production
279: (p_api_version IN NUMBER,
280: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
281: p_commit IN VARCHAR2 := Fnd_Api.g_false,
282: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
283: p_module_type IN VARCHAR2 := 'JSP',
284: p_visit_id IN NUMBER,
285: x_error_tbl OUT NOCOPY error_tbl_type,
278: PROCEDURE Validate_Before_Production
279: (p_api_version IN NUMBER,
280: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
281: p_commit IN VARCHAR2 := Fnd_Api.g_false,
282: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
283: p_module_type IN VARCHAR2 := 'JSP',
284: p_visit_id IN NUMBER,
285: x_error_tbl OUT NOCOPY error_tbl_type,
286: x_return_status OUT NOCOPY VARCHAR2,
296: -- Parameters :
297: --
298: -- Standard IN Parameters :
299: -- p_api_version IN NUMBER Required
300: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
301: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
302: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
303: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
304: -- p_module_type IN VARCHAR2 Default NULL.
297: --
298: -- Standard IN Parameters :
299: -- p_api_version IN NUMBER Required
300: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
301: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
302: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
303: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
304: -- p_module_type IN VARCHAR2 Default NULL.
305: --
298: -- Standard IN Parameters :
299: -- p_api_version IN NUMBER Required
300: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
301: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
302: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
303: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
304: -- p_module_type IN VARCHAR2 Default NULL.
305: --
306: -- Standard OUT Parameters :
299: -- p_api_version IN NUMBER Required
300: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
301: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
302: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
303: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
304: -- p_module_type IN VARCHAR2 Default NULL.
305: --
306: -- Standard OUT Parameters :
307: -- x_return_status OUT VARCHAR2 Required
316: -- Initial Version 1.0
317: -------------------------------------------------------------------
318: PROCEDURE Create_Job_Tasks(
319: p_api_version IN NUMBER :=1.0,
320: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
321: p_commit IN VARCHAR2 := Fnd_Api.g_false,
322: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
323: p_module_type IN VARCHAR2 := Null,
324: p_x_task_Tbl IN OUT NOCOPY Task_Tbl_Type,
317: -------------------------------------------------------------------
318: PROCEDURE Create_Job_Tasks(
319: p_api_version IN NUMBER :=1.0,
320: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
321: p_commit IN VARCHAR2 := Fnd_Api.g_false,
322: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
323: p_module_type IN VARCHAR2 := Null,
324: p_x_task_Tbl IN OUT NOCOPY Task_Tbl_Type,
325: x_return_status OUT NOCOPY VARCHAR2,
318: PROCEDURE Create_Job_Tasks(
319: p_api_version IN NUMBER :=1.0,
320: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
321: p_commit IN VARCHAR2 := Fnd_Api.g_false,
322: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
323: p_module_type IN VARCHAR2 := Null,
324: p_x_task_Tbl IN OUT NOCOPY Task_Tbl_Type,
325: x_return_status OUT NOCOPY VARCHAR2,
326: x_msg_count OUT NOCOPY NUMBER,
335: -- Parameters :
336: --
337: -- Standard IN Parameters :
338: -- p_api_version IN NUMBER Required
339: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
340: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
341: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
342: --
343: -- Standard OUT Parameters :
336: --
337: -- Standard IN Parameters :
338: -- p_api_version IN NUMBER Required
339: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
340: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
341: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
342: --
343: -- Standard OUT Parameters :
344: -- x_return_status OUT VARCHAR2 Required
337: -- Standard IN Parameters :
338: -- p_api_version IN NUMBER Required
339: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
340: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
341: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
342: --
343: -- Standard OUT Parameters :
344: -- x_return_status OUT VARCHAR2 Required
345: -- x_msg_count OUT NUMBER Required
355: -- End of Comments.
356: --
357: PROCEDURE Release_Visit (
358: p_api_version IN NUMBER,
359: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
360: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
361: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
362: p_module_type IN VARCHAR2 := NULL,
363: p_visit_id IN NUMBER,
356: --
357: PROCEDURE Release_Visit (
358: p_api_version IN NUMBER,
359: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
360: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
361: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
362: p_module_type IN VARCHAR2 := NULL,
363: p_visit_id IN NUMBER,
364: p_release_flag IN VARCHAR2 := 'N',
357: PROCEDURE Release_Visit (
358: p_api_version IN NUMBER,
359: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
360: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
361: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
362: p_module_type IN VARCHAR2 := NULL,
363: p_visit_id IN NUMBER,
364: p_release_flag IN VARCHAR2 := 'N',
365: p_orig_visit_id IN NUMBER := NULL, -- By yazhou 08/06/04 for TC changes
375: -- Function : To launch background p2p
376: -- Parameters :
377:
378: -- Standard IN Parameters :
379: -- p_commit IN VARCHAR2 Fnd_Api.G_FALSE
380: --
381: -- Standard OUT Parameters :
382: -- x_return_status OUT VARCHAR2 Required
383: -- x_msg_count OUT NUMBER Required
395: -- 02 Dec, 2009 P2P CP ER 9151144 TCHIMIRA Initial Version - 1.0
396: -------------------------------------------------------------------
397: PROCEDURE BG_Release_visit(
398: p_api_version IN NUMBER,
399: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
400: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
401: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
402: p_module_type IN VARCHAR2 := NULL,
403: p_visit_id IN NUMBER,
396: -------------------------------------------------------------------
397: PROCEDURE BG_Release_visit(
398: p_api_version IN NUMBER,
399: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
400: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
401: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
402: p_module_type IN VARCHAR2 := NULL,
403: p_visit_id IN NUMBER,
404: p_release_flag IN VARCHAR2 := 'U',
397: PROCEDURE BG_Release_visit(
398: p_api_version IN NUMBER,
399: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
400: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
401: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
402: p_module_type IN VARCHAR2 := NULL,
403: p_visit_id IN NUMBER,
404: p_release_flag IN VARCHAR2 := 'U',
405: x_request_id OUT NOCOPY NUMBER,
443: -- Parameters :
444: --
445: -- Standard IN Parameters :
446: -- p_api_version IN NUMBER Required
447: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
448: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
449: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
450: --
451: -- Standard OUT Parameters :
444: --
445: -- Standard IN Parameters :
446: -- p_api_version IN NUMBER Required
447: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
448: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
449: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
450: --
451: -- Standard OUT Parameters :
452: -- x_return_status OUT VARCHAR2 Required
445: -- Standard IN Parameters :
446: -- p_api_version IN NUMBER Required
447: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
448: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
449: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
450: --
451: -- Standard OUT Parameters :
452: -- x_return_status OUT VARCHAR2 Required
453: -- x_msg_count OUT NUMBER Required
466: -- End of Comments.
467: --
468: PROCEDURE Release_MR (
469: p_api_version IN NUMBER,
470: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
471: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
472: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
473: p_module_type IN VARCHAR2 := NULL,
474: p_visit_id IN NUMBER,
467: --
468: PROCEDURE Release_MR (
469: p_api_version IN NUMBER,
470: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
471: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
472: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
473: p_module_type IN VARCHAR2 := NULL,
474: p_visit_id IN NUMBER,
475: p_unit_effectivity_id IN NUMBER,
468: PROCEDURE Release_MR (
469: p_api_version IN NUMBER,
470: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
471: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
472: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
473: p_module_type IN VARCHAR2 := NULL,
474: p_visit_id IN NUMBER,
475: p_unit_effectivity_id IN NUMBER,
476: p_release_flag IN VARCHAR2 := 'N',
493: -- Parameters :
494: --
495: -- Standard IN Parameters :
496: -- p_api_version IN NUMBER Required
497: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
498: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
499: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
500: -- p_module_type IN VARCHAR2 Default Null
501: --
494: --
495: -- Standard IN Parameters :
496: -- p_api_version IN NUMBER Required
497: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
498: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
499: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
500: -- p_module_type IN VARCHAR2 Default Null
501: --
502: -- Standard OUT Parameters :
495: -- Standard IN Parameters :
496: -- p_api_version IN NUMBER Required
497: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
498: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
499: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
500: -- p_module_type IN VARCHAR2 Default Null
501: --
502: -- Standard OUT Parameters :
503: -- x_return_status OUT VARCHAR2 Required
514: -- End of Comments.
515: --
516: PROCEDURE Release_Tasks(
517: p_api_version IN NUMBER,
518: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
519: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
520: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
521: p_module_type IN VARCHAR2 := Null,
522: p_visit_id IN NUMBER,
515: --
516: PROCEDURE Release_Tasks(
517: p_api_version IN NUMBER,
518: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
519: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
520: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
521: p_module_type IN VARCHAR2 := Null,
522: p_visit_id IN NUMBER,
523: p_tasks_tbl IN Task_Tbl_Type,
516: PROCEDURE Release_Tasks(
517: p_api_version IN NUMBER,
518: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
519: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
520: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
521: p_module_type IN VARCHAR2 := Null,
522: p_visit_id IN NUMBER,
523: p_tasks_tbl IN Task_Tbl_Type,
524: p_release_flag IN VARCHAR2 := 'N',
558: -- Function : Update the project task start/end dates
559: -- with the workorder schedule start/end dates
560: -- Parameters :
561: -- Standard IN Parameters :
562: -- p_commit IN VARCHAR2 Fnd_Api.G_FALSE
563: --
564: -- Update_Project_Task_Times Parameters :
565: -- p_prd_workorder_tbl IN AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL Required
566: --
573: -------------------------------------------------------------------
574:
575: PROCEDURE Update_Project_Task_Times
576: ( p_prd_workorder_tbl IN AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL,
577: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
578: x_return_status OUT NOCOPY VARCHAR2,
579: x_msg_count OUT NOCOPY NUMBER,
580: x_msg_data OUT NOCOPY VARCHAR2
581: ) ;
602: -- Parameters :
603: --
604: -- Standard IN Parameters :
605: -- p_api_version IN NUMBER Required
606: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
607: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
608: -- p_module_type IN VARCHAR2 Default Null
609: --
610: -- Standard OUT Parameters :
603: --
604: -- Standard IN Parameters :
605: -- p_api_version IN NUMBER Required
606: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
607: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
608: -- p_module_type IN VARCHAR2 Default Null
609: --
610: -- Standard OUT Parameters :
611: -- x_return_status OUT VARCHAR2 Required
620: -------------------------------------------------------------------
621:
622: PROCEDURE Push_stages_to_production(
623: p_api_version IN NUMBER,
624: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
625: p_commit IN VARCHAR2 := FND_API.G_FALSE,
626: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
627: p_module_type IN VARCHAR2 := Null,
628: p_visit_id IN NUMBER,
621:
622: PROCEDURE Push_stages_to_production(
623: p_api_version IN NUMBER,
624: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
625: p_commit IN VARCHAR2 := FND_API.G_FALSE,
626: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
627: p_module_type IN VARCHAR2 := Null,
628: p_visit_id IN NUMBER,
629: p_stages_tbl IN AHL_VWP_VISITS_STAGES_PVT.Visit_Stages_Tbl_Type,
622: PROCEDURE Push_stages_to_production(
623: p_api_version IN NUMBER,
624: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
625: p_commit IN VARCHAR2 := FND_API.G_FALSE,
626: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
627: p_module_type IN VARCHAR2 := Null,
628: p_visit_id IN NUMBER,
629: p_stages_tbl IN AHL_VWP_VISITS_STAGES_PVT.Visit_Stages_Tbl_Type,
630: p_release_flag IN VARCHAR2 ,
640: -- Parameters :
641: --
642: -- Standard IN Parameters :
643: -- p_api_version IN NUMBER Required
644: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
645: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
646: -- p_caller IN VARCHAR2 Default Null
647: --
648: -- Standard OUT Parameters :
641: --
642: -- Standard IN Parameters :
643: -- p_api_version IN NUMBER Required
644: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
645: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
646: -- p_caller IN VARCHAR2 Default Null
647: --
648: -- Standard OUT Parameters :
649: -- x_return_status OUT VARCHAR2 Required
656: -------------------------------------------------------------------
657:
658: PROCEDURE plan_visit(
659: p_api_version IN NUMBER := 1.0,
660: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
661: p_commit IN VARCHAR2 := FND_API.G_FALSE,
662: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
663: p_caller IN VARCHAR2 := NULL,
664: p_visit_id IN NUMBER,
657:
658: PROCEDURE plan_visit(
659: p_api_version IN NUMBER := 1.0,
660: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
661: p_commit IN VARCHAR2 := FND_API.G_FALSE,
662: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
663: p_caller IN VARCHAR2 := NULL,
664: p_visit_id IN NUMBER,
665: x_return_status OUT NOCOPY VARCHAR2,
658: PROCEDURE plan_visit(
659: p_api_version IN NUMBER := 1.0,
660: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
661: p_commit IN VARCHAR2 := FND_API.G_FALSE,
662: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
663: p_caller IN VARCHAR2 := NULL,
664: p_visit_id IN NUMBER,
665: x_return_status OUT NOCOPY VARCHAR2,
666: x_msg_count OUT NOCOPY NUMBER,