113: -- Parameters :
114: --
115: -- Standard IN Parameters :
116: -- p_api_version IN NUMBER Required
117: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
118: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
119: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
120: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
121: -- p_module_type IN VARCHAR2 Default NULL.
114: --
115: -- Standard IN Parameters :
116: -- p_api_version IN NUMBER Required
117: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
118: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
119: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
120: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
121: -- p_module_type IN VARCHAR2 Default NULL.
122: --
115: -- Standard IN Parameters :
116: -- p_api_version IN NUMBER Required
117: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
118: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
119: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
120: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
121: -- p_module_type IN VARCHAR2 Default NULL.
122: --
123: -- Standard OUT Parameters :
116: -- p_api_version IN NUMBER Required
117: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
118: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
119: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
120: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
121: -- p_module_type IN VARCHAR2 Default NULL.
122: --
123: -- Standard OUT Parameters :
124: -- x_return_status OUT VARCHAR2 Required
153:
154: PROCEDURE Derive_Visit_Task_Times
155: (
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
158: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
159: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
160: p_default IN VARCHAR2 := Fnd_Api.G_TRUE,
161: p_module_type IN VARCHAR2 := NULL,
154: PROCEDURE Derive_Visit_Task_Times
155: (
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
158: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
159: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
160: p_default IN VARCHAR2 := Fnd_Api.G_TRUE,
161: p_module_type IN VARCHAR2 := NULL,
162: p_visit_id IN NUMBER,
155: (
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
158: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
159: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
160: p_default IN VARCHAR2 := Fnd_Api.G_TRUE,
161: p_module_type IN VARCHAR2 := NULL,
162: p_visit_id IN NUMBER,
163: p_start_time IN DATE := NULL,
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
158: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
159: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
160: p_default IN VARCHAR2 := Fnd_Api.G_TRUE,
161: p_module_type IN VARCHAR2 := NULL,
162: p_visit_id IN NUMBER,
163: p_start_time IN DATE := NULL,
164: p_end_time IN DATE := NULL,
180: -- Parameters :
181: --
182: -- Standard IN Parameters :
183: -- p_api_version IN NUMBER Required
184: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
185: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
186: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
187: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
188: -- p_module_type IN VARCHAR2 Default NULL.
181: --
182: -- Standard IN Parameters :
183: -- p_api_version IN NUMBER Required
184: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
185: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
186: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
187: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
188: -- p_module_type IN VARCHAR2 Default NULL.
189: --
182: -- Standard IN Parameters :
183: -- p_api_version IN NUMBER Required
184: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
185: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
186: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
187: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
188: -- p_module_type IN VARCHAR2 Default NULL.
189: --
190: -- Standard OUT Parameters :
183: -- p_api_version IN NUMBER Required
184: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
185: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
186: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
187: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
188: -- p_module_type IN VARCHAR2 Default NULL.
189: --
190: -- Standard OUT Parameters :
191: -- x_return_status OUT VARCHAR2 Required
216: -- End of Comments.
217: PROCEDURE Get_Plan_Resources
218: (
219: p_api_version IN NUMBER,
220: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
221: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
222: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
223: p_default IN VARCHAR2 := Fnd_Api.G_TRUE,
224: p_module_type IN VARCHAR2 := NULL,
217: PROCEDURE Get_Plan_Resources
218: (
219: p_api_version IN NUMBER,
220: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
221: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
222: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
223: p_default IN VARCHAR2 := Fnd_Api.G_TRUE,
224: p_module_type IN VARCHAR2 := NULL,
225: p_dept_id IN NUMBER,
218: (
219: p_api_version IN NUMBER,
220: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
221: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
222: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
223: p_default IN VARCHAR2 := Fnd_Api.G_TRUE,
224: p_module_type IN VARCHAR2 := NULL,
225: p_dept_id IN NUMBER,
226: p_dept_name IN VARCHAR2,
219: p_api_version IN NUMBER,
220: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
221: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
222: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
223: p_default IN VARCHAR2 := Fnd_Api.G_TRUE,
224: p_module_type IN VARCHAR2 := NULL,
225: p_dept_id IN NUMBER,
226: p_dept_name IN VARCHAR2,
227: p_org_name IN 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: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
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: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
252: -- p_module_type IN VARCHAR2 Default NULL.
253: --
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: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
252: -- p_module_type IN VARCHAR2 Default NULL.
253: --
254: -- Standard OUT 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: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
252: -- p_module_type IN VARCHAR2 Default NULL.
253: --
254: -- Standard OUT Parameters :
255: -- x_return_status OUT VARCHAR2 Required
286: -- End of Comments.
287: PROCEDURE Get_Rsrc_Req_By_Period
288: (
289: p_api_version IN NUMBER,
290: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
291: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
292: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
293: p_default IN VARCHAR2 := Fnd_Api.G_TRUE,
294: p_module_type IN VARCHAR2 := NULL,
287: PROCEDURE Get_Rsrc_Req_By_Period
288: (
289: p_api_version IN NUMBER,
290: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
291: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
292: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
293: p_default IN VARCHAR2 := Fnd_Api.G_TRUE,
294: p_module_type IN VARCHAR2 := NULL,
295: p_dept_id IN NUMBER,
288: (
289: p_api_version IN NUMBER,
290: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
291: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
292: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
293: p_default IN VARCHAR2 := Fnd_Api.G_TRUE,
294: p_module_type IN VARCHAR2 := NULL,
295: p_dept_id IN NUMBER,
296: p_dept_name IN VARCHAR2,
289: p_api_version IN NUMBER,
290: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
291: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
292: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
293: p_default IN VARCHAR2 := Fnd_Api.G_TRUE,
294: p_module_type IN VARCHAR2 := NULL,
295: p_dept_id IN NUMBER,
296: p_dept_name IN VARCHAR2,
297: p_org_name IN VARCHAR2,
316: -- Parameters :
317: --
318: -- Standard IN Parameters :
319: -- p_api_version IN NUMBER Required
320: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
321: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
322: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
323: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
324: -- p_module_type IN VARCHAR2 Default NULL.
317: --
318: -- Standard IN Parameters :
319: -- p_api_version IN NUMBER Required
320: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
321: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
322: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
323: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
324: -- p_module_type IN VARCHAR2 Default NULL.
325: --
318: -- Standard IN Parameters :
319: -- p_api_version IN NUMBER Required
320: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
321: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
322: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
323: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
324: -- p_module_type IN VARCHAR2 Default NULL.
325: --
326: -- Standard OUT Parameters :
319: -- p_api_version IN NUMBER Required
320: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
321: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
322: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
323: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
324: -- p_module_type IN VARCHAR2 Default NULL.
325: --
326: -- Standard OUT Parameters :
327: -- x_return_status OUT VARCHAR2 Required
356: -- End of Comments.
357: PROCEDURE Get_Task_Requirements
358: (
359: p_api_version IN NUMBER,
360: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
361: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
362: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
363: p_default IN VARCHAR2 := Fnd_Api.G_TRUE,
364: p_module_type IN VARCHAR2 := NULL,
357: PROCEDURE Get_Task_Requirements
358: (
359: p_api_version IN NUMBER,
360: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
361: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
362: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
363: p_default IN VARCHAR2 := Fnd_Api.G_TRUE,
364: p_module_type IN VARCHAR2 := NULL,
365: p_dept_id IN NUMBER,
358: (
359: p_api_version IN NUMBER,
360: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
361: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
362: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
363: p_default IN VARCHAR2 := Fnd_Api.G_TRUE,
364: p_module_type IN VARCHAR2 := NULL,
365: p_dept_id IN NUMBER,
366: p_dept_name IN VARCHAR2,
359: p_api_version IN NUMBER,
360: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
361: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
362: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
363: p_default IN VARCHAR2 := Fnd_Api.G_TRUE,
364: p_module_type IN VARCHAR2 := NULL,
365: p_dept_id IN NUMBER,
366: p_dept_name IN VARCHAR2,
367: p_org_name IN VARCHAR2,