200: -- Parameters :
201: --
202: -- Standard IN Parameters :
203: -- p_api_version IN NUMBER Required
204: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
205: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
206: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
207: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
208: -- p_module_type IN VARCHAR2 Default NULL.
201: --
202: -- Standard IN Parameters :
203: -- p_api_version IN NUMBER Required
204: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
205: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
206: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
207: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
208: -- p_module_type IN VARCHAR2 Default NULL.
209: --
202: -- Standard IN Parameters :
203: -- p_api_version IN NUMBER Required
204: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
205: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
206: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
207: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
208: -- p_module_type IN VARCHAR2 Default NULL.
209: --
210: -- Standard OUT Parameters :
203: -- p_api_version IN NUMBER Required
204: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
205: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
206: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
207: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
208: -- p_module_type IN VARCHAR2 Default NULL.
209: --
210: -- Standard OUT Parameters :
211: -- x_return_status OUT VARCHAR2 Required
220: -- Initial Version 1.0
221: --------------------------------------------------------------------
222: PROCEDURE Process_Visit (
223: p_api_version IN NUMBER,
224: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
225: p_commit IN VARCHAR2 := FND_API.g_false,
226: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
227: p_module_type IN VARCHAR2 := 'JSP',
228: p_x_Visit_tbl IN OUT NOCOPY Visit_Tbl_Type,
221: --------------------------------------------------------------------
222: PROCEDURE Process_Visit (
223: p_api_version IN NUMBER,
224: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
225: p_commit IN VARCHAR2 := FND_API.g_false,
226: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
227: p_module_type IN VARCHAR2 := 'JSP',
228: p_x_Visit_tbl IN OUT NOCOPY Visit_Tbl_Type,
229: x_return_status OUT NOCOPY VARCHAR2,
222: PROCEDURE Process_Visit (
223: p_api_version IN NUMBER,
224: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
225: p_commit IN VARCHAR2 := FND_API.g_false,
226: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
227: p_module_type IN VARCHAR2 := 'JSP',
228: p_x_Visit_tbl IN OUT NOCOPY Visit_Tbl_Type,
229: x_return_status OUT NOCOPY VARCHAR2,
230: x_msg_count OUT NOCOPY NUMBER,
238: -- Parameters :
239: --
240: -- Standard IN Parameters :
241: -- p_api_version IN NUMBER Required
242: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
243: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
244: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
245: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
246: -- p_module_type IN VARCHAR2 Default NULL.
239: --
240: -- Standard IN Parameters :
241: -- p_api_version IN NUMBER Required
242: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
243: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
244: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
245: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
246: -- p_module_type IN VARCHAR2 Default NULL.
247: --
240: -- Standard IN Parameters :
241: -- p_api_version IN NUMBER Required
242: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
243: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
244: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
245: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
246: -- p_module_type IN VARCHAR2 Default NULL.
247: --
248: -- Standard OUT Parameters :
241: -- p_api_version IN NUMBER Required
242: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
243: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
244: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
245: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
246: -- p_module_type IN VARCHAR2 Default NULL.
247: --
248: -- Standard OUT Parameters :
249: -- x_return_status OUT VARCHAR2 Required
260: -- Initial Version 1.0
261: -------------------------------------------------------------------
262: PROCEDURE Get_Visit_Details (
263: p_api_version IN NUMBER,
264: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
265: p_commit IN VARCHAR2 := Fnd_Api.g_false,
266: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
267: p_module_type IN VARCHAR2 := 'JSP',
268: p_visit_id IN NUMBER,
261: -------------------------------------------------------------------
262: PROCEDURE Get_Visit_Details (
263: p_api_version IN NUMBER,
264: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
265: p_commit IN VARCHAR2 := Fnd_Api.g_false,
266: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
267: p_module_type IN VARCHAR2 := 'JSP',
268: p_visit_id IN NUMBER,
269: x_Visit_rec OUT NOCOPY Visit_Rec_Type,
262: PROCEDURE Get_Visit_Details (
263: p_api_version IN NUMBER,
264: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
265: p_commit IN VARCHAR2 := Fnd_Api.g_false,
266: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
267: p_module_type IN VARCHAR2 := 'JSP',
268: p_visit_id IN NUMBER,
269: x_Visit_rec OUT NOCOPY Visit_Rec_Type,
270: x_return_status 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: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
288: -- p_module_type IN VARCHAR2 Default NULL.
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: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
288: -- p_module_type IN VARCHAR2 Default NULL.
289: --
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: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
288: -- p_module_type IN VARCHAR2 Default NULL.
289: --
290: -- Standard OUT 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: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
288: -- p_module_type IN VARCHAR2 Default NULL.
289: --
290: -- Standard OUT Parameters :
291: -- x_return_status OUT VARCHAR2 Required
300: -- Initial Version 1.0
301: -------------------------------------------------------------------
302: PROCEDURE UMP_Visit_Info (
303: p_api_version IN NUMBER,
304: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
305: p_commit IN VARCHAR2 := Fnd_Api.g_false,
306: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
307: p_module_type IN VARCHAR2 := Null,
308: p_unit_effectivity_id IN NUMBER,
301: -------------------------------------------------------------------
302: PROCEDURE UMP_Visit_Info (
303: p_api_version IN NUMBER,
304: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
305: p_commit IN VARCHAR2 := Fnd_Api.g_false,
306: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
307: p_module_type IN VARCHAR2 := Null,
308: p_unit_effectivity_id IN NUMBER,
309:
302: PROCEDURE UMP_Visit_Info (
303: p_api_version IN NUMBER,
304: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
305: p_commit IN VARCHAR2 := Fnd_Api.g_false,
306: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
307: p_module_type IN VARCHAR2 := Null,
308: p_unit_effectivity_id IN NUMBER,
309:
310: x_ump_visit_rec OUT NOCOPY Srch_UMP_Rec_Type,
320: -- Parameters :
321: --
322: -- Standard IN Parameters :
323: -- p_api_version IN NUMBER Required
324: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
325: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
326: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
327: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
328: -- p_module_type IN VARCHAR2 Default NULL.
321: --
322: -- Standard IN Parameters :
323: -- p_api_version IN NUMBER Required
324: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
325: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
326: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
327: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
328: -- p_module_type IN VARCHAR2 Default NULL.
329: --
322: -- Standard IN Parameters :
323: -- p_api_version IN NUMBER Required
324: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
325: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
326: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
327: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
328: -- p_module_type IN VARCHAR2 Default NULL.
329: --
330: -- Standard OUT Parameters :
323: -- p_api_version IN NUMBER Required
324: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
325: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
326: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
327: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
328: -- p_module_type IN VARCHAR2 Default NULL.
329: --
330: -- Standard OUT Parameters :
331: -- x_return_status OUT VARCHAR2 Required
341: -- Added by Srini p_x_cost_session, p_x_mr_session to support costing functionality
342: -------------------------------------------------------------------
343: PROCEDURE Close_Visit(
344: p_api_version IN NUMBER,
345: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
346: p_commit IN VARCHAR2 := Fnd_Api.g_false,
347: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
348: p_module_type IN VARCHAR2 := Null,
349: p_visit_id IN NUMBER,
342: -------------------------------------------------------------------
343: PROCEDURE Close_Visit(
344: p_api_version IN NUMBER,
345: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
346: p_commit IN VARCHAR2 := Fnd_Api.g_false,
347: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
348: p_module_type IN VARCHAR2 := Null,
349: p_visit_id IN NUMBER,
350: p_x_cost_session_id IN OUT NOCOPY NUMBER,
343: PROCEDURE Close_Visit(
344: p_api_version IN NUMBER,
345: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
346: p_commit IN VARCHAR2 := Fnd_Api.g_false,
347: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
348: p_module_type IN VARCHAR2 := Null,
349: p_visit_id IN NUMBER,
350: p_x_cost_session_id IN OUT NOCOPY NUMBER,
351: p_x_mr_session_id IN OUT NOCOPY NUMBER,
363: -- Parameters :
364: --
365: -- Standard IN Parameters :
366: -- p_api_version IN NUMBER Required
367: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
368: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
369: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
370: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
371: -- p_module_type IN VARCHAR2 Default NULL.
364: --
365: -- Standard IN Parameters :
366: -- p_api_version IN NUMBER Required
367: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
368: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
369: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
370: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
371: -- p_module_type IN VARCHAR2 Default NULL.
372: --
365: -- Standard IN Parameters :
366: -- p_api_version IN NUMBER Required
367: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
368: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
369: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
370: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
371: -- p_module_type IN VARCHAR2 Default NULL.
372: --
373: -- Standard OUT Parameters :
366: -- p_api_version IN NUMBER Required
367: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
368: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
369: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
370: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
371: -- p_module_type IN VARCHAR2 Default NULL.
372: --
373: -- Standard OUT Parameters :
374: -- x_return_status OUT VARCHAR2 Required
385: -- Initial Version 1.0
386: -------------------------------------------------------------------
387: PROCEDURE Cancel_Visit(
388: p_api_version IN NUMBER := 1.0,
389: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
390: p_commit IN VARCHAR2 := Fnd_Api.g_false,
391: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
392: p_module_type IN VARCHAR2 := Null,
393: p_visit_id IN NUMBER,
386: -------------------------------------------------------------------
387: PROCEDURE Cancel_Visit(
388: p_api_version IN NUMBER := 1.0,
389: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
390: p_commit IN VARCHAR2 := Fnd_Api.g_false,
391: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
392: p_module_type IN VARCHAR2 := Null,
393: p_visit_id IN NUMBER,
394: p_obj_ver_num IN NUMBER,
387: PROCEDURE Cancel_Visit(
388: p_api_version IN NUMBER := 1.0,
389: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
390: p_commit IN VARCHAR2 := Fnd_Api.g_false,
391: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
392: p_module_type IN VARCHAR2 := Null,
393: p_visit_id IN NUMBER,
394: p_obj_ver_num IN NUMBER,
395: x_return_status OUT NOCOPY VARCHAR2,