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,
60: -- Parameters :
61: --
62: -- Standard IN Parameters :
63: -- p_api_version IN NUMBER Required
64: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
65: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
66: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
67: -- Based on this flag, the API will set the default attributes.
68: -- p_module_type In VARCHAR2 Default NULL
61: --
62: -- Standard IN Parameters :
63: -- p_api_version IN NUMBER Required
64: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
65: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
66: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
67: -- Based on this flag, the API will set the default attributes.
68: -- p_module_type In VARCHAR2 Default NULL
69: -- This will be null.
62: -- Standard IN Parameters :
63: -- p_api_version IN NUMBER Required
64: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
65: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
66: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
67: -- Based on this flag, the API will set the default attributes.
68: -- p_module_type In VARCHAR2 Default NULL
69: -- This will be null.
70: -- Standard out Parameters :
77: --
78: --
79: PROCEDURE Update_Planned_Materials (
80: p_api_version IN NUMBER,
81: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
82: p_commit IN VARCHAR2 := FND_API.g_false,
83: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
84: p_planned_materials_tbl IN ahl_ltp_reqst_matrl_pub.Planned_Materials_Tbl,
85: x_return_status OUT NOCOPY VARCHAR2,
78: --
79: PROCEDURE Update_Planned_Materials (
80: p_api_version IN NUMBER,
81: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
82: p_commit IN VARCHAR2 := FND_API.g_false,
83: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
84: p_planned_materials_tbl IN ahl_ltp_reqst_matrl_pub.Planned_Materials_Tbl,
85: x_return_status OUT NOCOPY VARCHAR2,
86: x_msg_count OUT NOCOPY NUMBER,
79: PROCEDURE Update_Planned_Materials (
80: p_api_version IN NUMBER,
81: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
82: p_commit IN VARCHAR2 := FND_API.g_false,
83: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
84: p_planned_materials_tbl IN ahl_ltp_reqst_matrl_pub.Planned_Materials_Tbl,
85: x_return_status OUT NOCOPY VARCHAR2,
86: x_msg_count OUT NOCOPY NUMBER,
87: x_msg_data OUT NOCOPY VARCHAR2);
96: -- Parameters :
97: --
98: -- Standard IN Parameters :
99: -- p_api_version IN NUMBER Required
100: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
101: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
102: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
103: -- Based on this flag, the API will set the default attributes.
104: -- This will be null.
97: --
98: -- Standard IN Parameters :
99: -- p_api_version IN NUMBER Required
100: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
101: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
102: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
103: -- Based on this flag, the API will set the default attributes.
104: -- This will be null.
105: -- Standard out Parameters :
98: -- Standard IN Parameters :
99: -- p_api_version IN NUMBER Required
100: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
101: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
102: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
103: -- Based on this flag, the API will set the default attributes.
104: -- This will be null.
105: -- Standard out Parameters :
106: -- x_return_status OUT VARCHAR2 Required
112: -- p_visit_task_id IN NUMBER, Optional
113: --
114: PROCEDURE Unschedule_visit_Task_Items
115: (p_api_version IN NUMBER,
116: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
117: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
118: p_visit_id IN NUMBER,
119: p_visit_task_id IN NUMBER := NULL,
120: x_return_status OUT NOCOPY VARCHAR2,
113: --
114: PROCEDURE Unschedule_visit_Task_Items
115: (p_api_version IN NUMBER,
116: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
117: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
118: p_visit_id IN NUMBER,
119: p_visit_task_id IN NUMBER := NULL,
120: x_return_status OUT NOCOPY VARCHAR2,
121: x_msg_count OUT NOCOPY NUMBER,
131: -- Parameters :
132: --
133: -- Standard IN Parameters :
134: -- p_api_version IN NUMBER Required
135: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
136: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
137: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
138: -- Based on this flag, the API will set the default attributes.
139: -- p_module_type In VARCHAR2 Default NULL
132: --
133: -- Standard IN Parameters :
134: -- p_api_version IN NUMBER Required
135: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
136: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
137: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
138: -- Based on this flag, the API will set the default attributes.
139: -- p_module_type In VARCHAR2 Default NULL
140: -- This will be null.
133: -- Standard IN Parameters :
134: -- p_api_version IN NUMBER Required
135: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
136: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
137: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
138: -- Based on this flag, the API will set the default attributes.
139: -- p_module_type In VARCHAR2 Default NULL
140: -- This will be null.
141: -- Standard out Parameters :
148: --
149: --
150: PROCEDURE Create_Task_Materials (
151: p_api_version IN NUMBER,
152: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
153: p_commit IN VARCHAR2 := FND_API.g_false,
154: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
155: p_visit_id IN NUMBER,
156: p_visit_task_id IN NUMBER := NULL,
149: --
150: PROCEDURE Create_Task_Materials (
151: p_api_version IN NUMBER,
152: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
153: p_commit IN VARCHAR2 := FND_API.g_false,
154: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
155: p_visit_id IN NUMBER,
156: p_visit_task_id IN NUMBER := NULL,
157: p_start_time IN DATE := NULL,
150: PROCEDURE Create_Task_Materials (
151: p_api_version IN NUMBER,
152: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
153: p_commit IN VARCHAR2 := FND_API.g_false,
154: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
155: p_visit_id IN NUMBER,
156: p_visit_task_id IN NUMBER := NULL,
157: p_start_time IN DATE := NULL,
158: p_org_id IN NUMBER := NULL,
169: -- Parameters :
170: --
171: -- Standard IN Parameters :
172: -- p_api_version IN NUMBER Required
173: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
174: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
175: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
176: -- Based on this flag, the API will set the default attributes.
177: -- p_module_type In VARCHAR2 Default NULL
170: --
171: -- Standard IN Parameters :
172: -- p_api_version IN NUMBER Required
173: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
174: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
175: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
176: -- Based on this flag, the API will set the default attributes.
177: -- p_module_type In VARCHAR2 Default NULL
178: -- This will be null.
171: -- Standard IN Parameters :
172: -- p_api_version IN NUMBER Required
173: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
174: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
175: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
176: -- Based on this flag, the API will set the default attributes.
177: -- p_module_type In VARCHAR2 Default NULL
178: -- This will be null.
179: -- Standard out Parameters :
186: --
187: --
188: PROCEDURE Modify_Visit_Task_Matrls (
189: p_api_version IN NUMBER,
190: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
191: p_commit IN VARCHAR2 := FND_API.g_false,
192: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
193: p_visit_id IN NUMBER,
194: p_visit_task_id IN NUMBER := NULL,
187: --
188: PROCEDURE Modify_Visit_Task_Matrls (
189: p_api_version IN NUMBER,
190: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
191: p_commit IN VARCHAR2 := FND_API.g_false,
192: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
193: p_visit_id IN NUMBER,
194: p_visit_task_id IN NUMBER := NULL,
195: p_start_time IN DATE := NULL,
188: PROCEDURE Modify_Visit_Task_Matrls (
189: p_api_version IN NUMBER,
190: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
191: p_commit IN VARCHAR2 := FND_API.g_false,
192: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
193: p_visit_id IN NUMBER,
194: p_visit_task_id IN NUMBER := NULL,
195: p_start_time IN DATE := NULL,
196: p_org_id IN NUMBER := NULL,
207: -- Parameters :
208: --
209: -- Standard IN Parameters :
210: -- p_api_version IN NUMBER Required
211: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
212: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
213: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
214: -- Based on this flag, the API will set the default attributes.
215: -- p_module_type In VARCHAR2 Default NULL
208: --
209: -- Standard IN Parameters :
210: -- p_api_version IN NUMBER Required
211: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
212: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
213: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
214: -- Based on this flag, the API will set the default attributes.
215: -- p_module_type In VARCHAR2 Default NULL
216: -- This will be null.
209: -- Standard IN Parameters :
210: -- p_api_version IN NUMBER Required
211: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
212: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
213: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
214: -- Based on this flag, the API will set the default attributes.
215: -- p_module_type In VARCHAR2 Default NULL
216: -- This will be null.
217: -- Standard out Parameters :
224: --
225: --
226: PROCEDURE Remove_Visit_Task_Matrls (
227: p_api_version IN NUMBER,
228: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
229: p_commit IN VARCHAR2 := FND_API.g_false,
230: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
231: p_visit_id IN NUMBER,
232: p_visit_task_id IN NUMBER := NULL,
225: --
226: PROCEDURE Remove_Visit_Task_Matrls (
227: p_api_version IN NUMBER,
228: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
229: p_commit IN VARCHAR2 := FND_API.g_false,
230: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
231: p_visit_id IN NUMBER,
232: p_visit_task_id IN NUMBER := NULL,
233: x_planned_order_flag OUT NOCOPY VARCHAR2 ,
226: PROCEDURE Remove_Visit_Task_Matrls (
227: p_api_version IN NUMBER,
228: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
229: p_commit IN VARCHAR2 := FND_API.g_false,
230: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
231: p_visit_id IN NUMBER,
232: p_visit_task_id IN NUMBER := NULL,
233: x_planned_order_flag OUT NOCOPY VARCHAR2 ,
234: x_return_status OUT NOCOPY VARCHAR2,
244: -- Parameters :
245: --
246: -- Standard IN Parameters :
247: -- p_api_version IN NUMBER Required
248: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
249: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
250: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
251: -- Based on this flag, the API will set the default attributes.
252: -- p_module_type In VARCHAR2 Default NULL
245: --
246: -- Standard IN Parameters :
247: -- p_api_version IN NUMBER Required
248: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
249: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
250: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
251: -- Based on this flag, the API will set the default attributes.
252: -- p_module_type In VARCHAR2 Default NULL
253: -- This will be null.
246: -- Standard IN Parameters :
247: -- p_api_version IN NUMBER Required
248: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
249: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
250: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
251: -- Based on this flag, the API will set the default attributes.
252: -- p_module_type In VARCHAR2 Default NULL
253: -- This will be null.
254: -- Standard out Parameters :
261: --
262: --
263: PROCEDURE Update_Unplanned_Matrls (
264: p_api_version IN NUMBER,
265: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
266: p_commit IN VARCHAR2 := FND_API.g_false,
267: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
268: p_visit_id IN NUMBER,
269: x_return_status OUT NOCOPY VARCHAR2,
262: --
263: PROCEDURE Update_Unplanned_Matrls (
264: p_api_version IN NUMBER,
265: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
266: p_commit IN VARCHAR2 := FND_API.g_false,
267: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
268: p_visit_id IN NUMBER,
269: x_return_status OUT NOCOPY VARCHAR2,
270: x_msg_count OUT NOCOPY NUMBER,
263: PROCEDURE Update_Unplanned_Matrls (
264: p_api_version IN NUMBER,
265: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
266: p_commit IN VARCHAR2 := FND_API.g_false,
267: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
268: p_visit_id IN NUMBER,
269: x_return_status OUT NOCOPY VARCHAR2,
270: x_msg_count OUT NOCOPY NUMBER,
271: x_msg_data OUT NOCOPY VARCHAR2);
280: -- Parameters :
281: --
282: -- Standard IN Parameters :
283: -- p_api_version IN NUMBER Required
284: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
285: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
286: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
287: --
288: -- Standard OUT Parameters :
281: --
282: -- Standard IN Parameters :
283: -- p_api_version IN NUMBER Required
284: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
285: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
286: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
287: --
288: -- Standard OUT Parameters :
289: -- x_return_status OUT VARCHAR2 Required
282: -- Standard IN Parameters :
283: -- p_api_version IN NUMBER Required
284: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
285: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
286: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
287: --
288: -- Standard OUT Parameters :
289: -- x_return_status OUT VARCHAR2 Required
290: -- x_msg_count OUT NUMBER Required
299: -------------------------------------------------------------------
300:
301: PROCEDURE Update_Material_Reqrs_status
302: ( p_api_version IN NUMBER,
303: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
304: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
305: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
306: p_module_type IN VARCHAR2 := NULL,
307: p_visit_task_id IN NUMBER,
300:
301: PROCEDURE Update_Material_Reqrs_status
302: ( p_api_version IN NUMBER,
303: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
304: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
305: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
306: p_module_type IN VARCHAR2 := NULL,
307: p_visit_task_id IN NUMBER,
308: x_return_status OUT NOCOPY VARCHAR2,
301: PROCEDURE Update_Material_Reqrs_status
302: ( p_api_version IN NUMBER,
303: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
304: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
305: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
306: p_module_type IN VARCHAR2 := NULL,
307: p_visit_task_id IN NUMBER,
308: x_return_status OUT NOCOPY VARCHAR2,
309: x_msg_count OUT NOCOPY NUMBER,