20: -- Parameters :
21: --
22: -- Standard IN Parameters :
23: -- p_api_version IN NUMBER Required
24: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
25: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
26: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
27: -- Based on this flag, the API will set the default attributes.
28: -- p_module_type In VARCHAR2 Default NULL
21: --
22: -- Standard IN Parameters :
23: -- p_api_version IN NUMBER Required
24: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
25: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
26: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
27: -- Based on this flag, the API will set the default attributes.
28: -- p_module_type In VARCHAR2 Default NULL
29: -- This will be null.
22: -- Standard IN Parameters :
23: -- p_api_version IN NUMBER Required
24: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
25: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
26: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
27: -- Based on this flag, the API will set the default attributes.
28: -- p_module_type In VARCHAR2 Default NULL
29: -- This will be null.
30: -- Standard out Parameters :
36: --
37: --
38: PROCEDURE Process_Planned_Materials (
39: p_api_version IN NUMBER,
40: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
41: p_commit IN VARCHAR2 := FND_API.g_false,
42: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
43: p_visit_id IN NUMBER,
44: p_visit_task_id IN NUMBER := NULL,
37: --
38: PROCEDURE Process_Planned_Materials (
39: p_api_version IN NUMBER,
40: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
41: p_commit IN VARCHAR2 := FND_API.g_false,
42: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
43: p_visit_id IN NUMBER,
44: p_visit_task_id IN NUMBER := NULL,
45: p_org_id IN NUMBER := NULL,
38: PROCEDURE Process_Planned_Materials (
39: p_api_version IN NUMBER,
40: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
41: p_commit IN VARCHAR2 := FND_API.g_false,
42: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
43: p_visit_id IN NUMBER,
44: p_visit_task_id IN NUMBER := NULL,
45: p_org_id IN NUMBER := NULL,
46: p_start_date IN DATE := NULL,
61: -- Parameters :
62: --
63: -- Standard IN Parameters :
64: -- p_api_version IN NUMBER Required
65: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
66: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
67: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
68: -- Based on this flag, the API will set the default attributes.
69: -- p_module_type In VARCHAR2 Default NULL
62: --
63: -- Standard IN Parameters :
64: -- p_api_version IN NUMBER Required
65: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
66: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
67: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
68: -- Based on this flag, the API will set the default attributes.
69: -- p_module_type In VARCHAR2 Default NULL
70: -- This will be null.
63: -- Standard IN Parameters :
64: -- p_api_version IN NUMBER Required
65: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
66: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
67: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
68: -- Based on this flag, the API will set the default attributes.
69: -- p_module_type In VARCHAR2 Default NULL
70: -- This will be null.
71: -- Standard out Parameters :
78: --
79: --
80: PROCEDURE Update_Planned_Materials (
81: p_api_version IN NUMBER,
82: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
83: p_commit IN VARCHAR2 := FND_API.g_false,
84: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
85: p_planned_materials_tbl IN ahl_ltp_reqst_matrl_pub.Planned_Materials_Tbl,
86: x_return_status OUT NOCOPY VARCHAR2,
79: --
80: PROCEDURE Update_Planned_Materials (
81: p_api_version IN NUMBER,
82: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
83: p_commit IN VARCHAR2 := FND_API.g_false,
84: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
85: p_planned_materials_tbl IN ahl_ltp_reqst_matrl_pub.Planned_Materials_Tbl,
86: x_return_status OUT NOCOPY VARCHAR2,
87: x_msg_count OUT NOCOPY NUMBER,
80: PROCEDURE Update_Planned_Materials (
81: p_api_version IN NUMBER,
82: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
83: p_commit IN VARCHAR2 := FND_API.g_false,
84: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
85: p_planned_materials_tbl IN ahl_ltp_reqst_matrl_pub.Planned_Materials_Tbl,
86: x_return_status OUT NOCOPY VARCHAR2,
87: x_msg_count OUT NOCOPY NUMBER,
88: x_msg_data OUT NOCOPY VARCHAR2);
97: -- Parameters :
98: --
99: -- Standard IN Parameters :
100: -- p_api_version IN NUMBER Required
101: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
102: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
103: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
104: -- Based on this flag, the API will set the default attributes.
105: -- This will be null.
98: --
99: -- Standard IN Parameters :
100: -- p_api_version IN NUMBER Required
101: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
102: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
103: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
104: -- Based on this flag, the API will set the default attributes.
105: -- This will be null.
106: -- Standard out Parameters :
99: -- Standard IN Parameters :
100: -- p_api_version IN NUMBER Required
101: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
102: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
103: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
104: -- Based on this flag, the API will set the default attributes.
105: -- This will be null.
106: -- Standard out Parameters :
107: -- x_return_status OUT VARCHAR2 Required
113: -- p_visit_task_id IN NUMBER, Optional
114: --
115: PROCEDURE Unschedule_visit_Task_Items
116: (p_api_version IN NUMBER,
117: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
118: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
119: p_visit_id IN NUMBER,
120: p_visit_task_id IN NUMBER := NULL,
121: x_return_status OUT NOCOPY VARCHAR2,
114: --
115: PROCEDURE Unschedule_visit_Task_Items
116: (p_api_version IN NUMBER,
117: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
118: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
119: p_visit_id IN NUMBER,
120: p_visit_task_id IN NUMBER := NULL,
121: x_return_status OUT NOCOPY VARCHAR2,
122: x_msg_count OUT NOCOPY NUMBER,
132: -- Parameters :
133: --
134: -- Standard IN Parameters :
135: -- p_api_version IN NUMBER Required
136: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
137: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
138: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
139: -- Based on this flag, the API will set the default attributes.
140: -- p_module_type In VARCHAR2 Default NULL
133: --
134: -- Standard IN Parameters :
135: -- p_api_version IN NUMBER Required
136: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
137: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
138: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
139: -- Based on this flag, the API will set the default attributes.
140: -- p_module_type In VARCHAR2 Default NULL
141: -- This will be null.
134: -- Standard IN Parameters :
135: -- p_api_version IN NUMBER Required
136: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
137: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
138: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
139: -- Based on this flag, the API will set the default attributes.
140: -- p_module_type In VARCHAR2 Default NULL
141: -- This will be null.
142: -- Standard out Parameters :
149: --
150: --
151: PROCEDURE Create_Task_Materials (
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
154: p_commit IN VARCHAR2 := FND_API.g_false,
155: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
156: p_visit_id IN NUMBER,
157: p_visit_task_id IN NUMBER := NULL,
150: --
151: PROCEDURE Create_Task_Materials (
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
154: p_commit IN VARCHAR2 := FND_API.g_false,
155: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
156: p_visit_id IN NUMBER,
157: p_visit_task_id IN NUMBER := NULL,
158: p_start_time IN DATE := NULL,
151: PROCEDURE Create_Task_Materials (
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
154: p_commit IN VARCHAR2 := FND_API.g_false,
155: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
156: p_visit_id IN NUMBER,
157: p_visit_task_id IN NUMBER := NULL,
158: p_start_time IN DATE := NULL,
159: p_org_id IN NUMBER := NULL,
170: -- Parameters :
171: --
172: -- Standard IN Parameters :
173: -- p_api_version IN NUMBER Required
174: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
175: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
176: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
177: -- Based on this flag, the API will set the default attributes.
178: -- p_module_type In VARCHAR2 Default NULL
171: --
172: -- Standard IN Parameters :
173: -- p_api_version IN NUMBER Required
174: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
175: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
176: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
177: -- Based on this flag, the API will set the default attributes.
178: -- p_module_type In VARCHAR2 Default NULL
179: -- This will be null.
172: -- Standard IN Parameters :
173: -- p_api_version IN NUMBER Required
174: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
175: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
176: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
177: -- Based on this flag, the API will set the default attributes.
178: -- p_module_type In VARCHAR2 Default NULL
179: -- This will be null.
180: -- Standard out Parameters :
191: --
192: --
193: PROCEDURE Modify_Visit_Task_Matrls (
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
196: p_commit IN VARCHAR2 := FND_API.g_false,
197: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
198: p_visit_id IN NUMBER,
199: p_visit_task_id IN NUMBER := NULL,
192: --
193: PROCEDURE Modify_Visit_Task_Matrls (
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
196: p_commit IN VARCHAR2 := FND_API.g_false,
197: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
198: p_visit_id IN NUMBER,
199: p_visit_task_id IN NUMBER := NULL,
200: p_start_time IN DATE := NULL,
193: PROCEDURE Modify_Visit_Task_Matrls (
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
196: p_commit IN VARCHAR2 := FND_API.g_false,
197: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
198: p_visit_id IN NUMBER,
199: p_visit_task_id IN NUMBER := NULL,
200: p_start_time IN DATE := NULL,
201: p_org_id IN NUMBER := NULL,
213: -- Parameters :
214: --
215: -- Standard IN Parameters :
216: -- p_api_version IN NUMBER Required
217: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
218: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
219: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
220: -- Based on this flag, the API will set the default attributes.
221: -- p_module_type In VARCHAR2 Default NULL
214: --
215: -- Standard IN Parameters :
216: -- p_api_version IN NUMBER Required
217: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
218: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
219: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
220: -- Based on this flag, the API will set the default attributes.
221: -- p_module_type In VARCHAR2 Default NULL
222: -- This will be null.
215: -- Standard IN Parameters :
216: -- p_api_version IN NUMBER Required
217: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
218: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
219: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
220: -- Based on this flag, the API will set the default attributes.
221: -- p_module_type In VARCHAR2 Default NULL
222: -- This will be null.
223: -- Standard out Parameters :
230: --
231: --
232: PROCEDURE Remove_Visit_Task_Matrls (
233: p_api_version 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: p_visit_id IN NUMBER,
238: p_visit_task_id IN NUMBER := NULL,
231: --
232: PROCEDURE Remove_Visit_Task_Matrls (
233: p_api_version 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: p_visit_id IN NUMBER,
238: p_visit_task_id IN NUMBER := NULL,
239: x_planned_order_flag OUT NOCOPY VARCHAR2 ,
232: PROCEDURE Remove_Visit_Task_Matrls (
233: p_api_version 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: p_visit_id IN NUMBER,
238: p_visit_task_id IN NUMBER := NULL,
239: x_planned_order_flag OUT NOCOPY VARCHAR2 ,
240: x_return_status OUT NOCOPY VARCHAR2,
250: -- Parameters :
251: --
252: -- Standard IN Parameters :
253: -- p_api_version IN NUMBER Required
254: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
255: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
256: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
257: -- Based on this flag, the API will set the default attributes.
258: -- p_module_type In VARCHAR2 Default NULL
251: --
252: -- Standard IN Parameters :
253: -- p_api_version IN NUMBER Required
254: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
255: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
256: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
257: -- Based on this flag, the API will set the default attributes.
258: -- p_module_type In VARCHAR2 Default NULL
259: -- This will be null.
252: -- Standard IN Parameters :
253: -- p_api_version IN NUMBER Required
254: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
255: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
256: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
257: -- Based on this flag, the API will set the default attributes.
258: -- p_module_type In VARCHAR2 Default NULL
259: -- This will be null.
260: -- Standard out Parameters :
267: --
268: --
269: PROCEDURE Update_Unplanned_Matrls (
270: p_api_version IN NUMBER,
271: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
272: p_commit IN VARCHAR2 := FND_API.g_false,
273: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
274: p_visit_id IN NUMBER,
275: x_return_status OUT NOCOPY VARCHAR2,
268: --
269: PROCEDURE Update_Unplanned_Matrls (
270: p_api_version IN NUMBER,
271: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
272: p_commit IN VARCHAR2 := FND_API.g_false,
273: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
274: p_visit_id IN NUMBER,
275: x_return_status OUT NOCOPY VARCHAR2,
276: x_msg_count OUT NOCOPY NUMBER,
269: PROCEDURE Update_Unplanned_Matrls (
270: p_api_version IN NUMBER,
271: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
272: p_commit IN VARCHAR2 := FND_API.g_false,
273: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
274: p_visit_id IN NUMBER,
275: x_return_status OUT NOCOPY VARCHAR2,
276: x_msg_count OUT NOCOPY NUMBER,
277: x_msg_data OUT NOCOPY VARCHAR2);
286: -- Parameters :
287: --
288: -- Standard IN Parameters :
289: -- p_api_version IN NUMBER Required
290: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
291: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
292: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
293: --
294: -- Standard OUT Parameters :
287: --
288: -- Standard IN Parameters :
289: -- p_api_version IN NUMBER Required
290: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
291: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
292: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
293: --
294: -- Standard OUT Parameters :
295: -- x_return_status OUT VARCHAR2 Required
288: -- Standard IN Parameters :
289: -- p_api_version IN NUMBER Required
290: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
291: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
292: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
293: --
294: -- Standard OUT Parameters :
295: -- x_return_status OUT VARCHAR2 Required
296: -- x_msg_count OUT NUMBER Required
305: -------------------------------------------------------------------
306:
307: PROCEDURE Update_Material_Reqrs_status
308: ( p_api_version IN NUMBER,
309: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
310: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
311: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
312: p_module_type IN VARCHAR2 := NULL,
313: p_visit_task_id IN NUMBER,
306:
307: PROCEDURE Update_Material_Reqrs_status
308: ( p_api_version IN NUMBER,
309: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
310: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
311: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
312: p_module_type IN VARCHAR2 := NULL,
313: p_visit_task_id IN NUMBER,
314: x_return_status OUT NOCOPY VARCHAR2,
307: PROCEDURE Update_Material_Reqrs_status
308: ( p_api_version IN NUMBER,
309: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
310: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
311: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
312: p_module_type IN VARCHAR2 := NULL,
313: p_visit_task_id IN NUMBER,
314: x_return_status OUT NOCOPY VARCHAR2,
315: x_msg_count OUT NOCOPY NUMBER,
324: -- Parameters :
325: --
326: -- Standard IN Parameters :
327: -- p_api_version IN NUMBER Required
328: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
329: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
330: -- p_module_type IN VARCHAR2 Default Null
331: --
332: -- Standard OUT Parameters :
325: --
326: -- Standard IN Parameters :
327: -- p_api_version IN NUMBER Required
328: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
329: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
330: -- p_module_type IN VARCHAR2 Default Null
331: --
332: -- Standard OUT Parameters :
333: -- x_return_status OUT VARCHAR2 Required
343: --
344: -------------------------------------------------------------------
345: PROCEDURE Associate_Stage_Materials (
346: p_api_version IN NUMBER := 1.0,
347: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
348: p_commit IN VARCHAR2 := FND_API.G_FALSE,
349: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
350: p_module_type IN VARCHAR2 := 'JSP',
351: p_visit_id IN NUMBER,
344: -------------------------------------------------------------------
345: PROCEDURE Associate_Stage_Materials (
346: p_api_version IN NUMBER := 1.0,
347: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
348: p_commit IN VARCHAR2 := FND_API.G_FALSE,
349: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
350: p_module_type IN VARCHAR2 := 'JSP',
351: p_visit_id IN NUMBER,
352: p_mr_header_id IN NUMBER,
345: PROCEDURE Associate_Stage_Materials (
346: p_api_version IN NUMBER := 1.0,
347: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
348: p_commit IN VARCHAR2 := FND_API.G_FALSE,
349: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
350: p_module_type IN VARCHAR2 := 'JSP',
351: p_visit_id IN NUMBER,
352: p_mr_header_id IN NUMBER,
353: p_instance_id IN NUMBER,
364: -- Parameters :
365: --
366: -- Standard IN Parameters :
367: -- p_api_version IN NUMBER Required
368: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
369: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
370: -- p_module_type IN VARCHAR2 Default Null
371: --
372: -- Standard OUT Parameters :
365: --
366: -- Standard IN Parameters :
367: -- p_api_version IN NUMBER Required
368: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
369: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
370: -- p_module_type IN VARCHAR2 Default Null
371: --
372: -- Standard OUT Parameters :
373: -- x_return_status OUT VARCHAR2 Required
383: --
384: -------------------------------------------------------------------
385: PROCEDURE Remove_Stage_Materials (
386: p_api_version IN NUMBER := 1.0,
387: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
388: p_commit IN VARCHAR2 := FND_API.G_FALSE,
389: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
390: p_module_type IN VARCHAR2 := 'JSP',
391: p_visit_id IN NUMBER,
384: -------------------------------------------------------------------
385: PROCEDURE Remove_Stage_Materials (
386: p_api_version IN NUMBER := 1.0,
387: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
388: p_commit IN VARCHAR2 := FND_API.G_FALSE,
389: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
390: p_module_type IN VARCHAR2 := 'JSP',
391: p_visit_id IN NUMBER,
392: p_mr_header_id IN NUMBER,
385: PROCEDURE Remove_Stage_Materials (
386: p_api_version IN NUMBER := 1.0,
387: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
388: p_commit IN VARCHAR2 := FND_API.G_FALSE,
389: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
390: p_module_type IN VARCHAR2 := 'JSP',
391: p_visit_id IN NUMBER,
392: p_mr_header_id IN NUMBER,
393: p_instance_id IN NUMBER,
406: -- Parameters :
407: --
408: -- Standard IN Parameters :
409: -- p_api_version IN NUMBER Required
410: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
411: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
412: -- p_module_type IN VARCHAR2 Default Null
413: --
414: -- Standard OUT Parameters :
407: --
408: -- Standard IN Parameters :
409: -- p_api_version IN NUMBER Required
410: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
411: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
412: -- p_module_type IN VARCHAR2 Default Null
413: --
414: -- Standard OUT Parameters :
415: -- x_return_status OUT VARCHAR2 Required
421: --
422: -------------------------------------------------------------------
423: PROCEDURE Delete_Default_Stage_Materials (
424: p_api_version IN NUMBER := 1.0,
425: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
426: p_commit IN VARCHAR2 := FND_API.G_FALSE,
427: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
428: p_module_type IN VARCHAR2 := 'JSP',
429: p_visit_task_id IN NUMBER,
422: -------------------------------------------------------------------
423: PROCEDURE Delete_Default_Stage_Materials (
424: p_api_version IN NUMBER := 1.0,
425: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
426: p_commit IN VARCHAR2 := FND_API.G_FALSE,
427: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
428: p_module_type IN VARCHAR2 := 'JSP',
429: p_visit_task_id IN NUMBER,
430: x_return_status OUT NOCOPY VARCHAR2,
423: PROCEDURE Delete_Default_Stage_Materials (
424: p_api_version IN NUMBER := 1.0,
425: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
426: p_commit IN VARCHAR2 := FND_API.G_FALSE,
427: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
428: p_module_type IN VARCHAR2 := 'JSP',
429: p_visit_task_id IN NUMBER,
430: x_return_status OUT NOCOPY VARCHAR2,
431: x_msg_count OUT NOCOPY NUMBER,