181: -- Parameters :
182: --
183: -- Standard IN Parameters :
184: -- p_api_version IN NUMBER Required
185: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
186: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
187: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
188: -- Based on this flag, the API will set the default attributes.
189: -- p_module_type In VARCHAR2 Default NULL
182: --
183: -- Standard IN Parameters :
184: -- p_api_version IN NUMBER Required
185: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
186: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
187: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
188: -- Based on this flag, the API will set the default attributes.
189: -- p_module_type In VARCHAR2 Default NULL
190: -- This will be null.
183: -- Standard IN Parameters :
184: -- p_api_version IN NUMBER Required
185: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
186: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
187: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
188: -- Based on this flag, the API will set the default attributes.
189: -- p_module_type In VARCHAR2 Default NULL
190: -- This will be null.
191: -- Standard out Parameters :
199: --
200: --
201: PROCEDURE Search_Scheduled_Visits (
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 := 'JSP',
207: p_search_visits_Rec IN search_visits_rec_type,
200: --
201: PROCEDURE Search_Scheduled_Visits (
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 := 'JSP',
207: p_search_visits_Rec IN search_visits_rec_type,
208: x_scheduled_visit_tbl OUT NOCOPY scheduled_visits_tbl,
201: PROCEDURE Search_Scheduled_Visits (
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 := 'JSP',
207: p_search_visits_Rec IN search_visits_rec_type,
208: x_scheduled_visit_tbl OUT NOCOPY scheduled_visits_tbl,
209: x_display_rec OUT NOCOPY display_rec_type,
219: -- Parameters :
220: --
221: -- Standard IN Parameters :
222: -- p_api_version IN NUMBER Required
223: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
224: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
225: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
226: -- Based on this flag, the API will set the default attributes.
227: -- p_module_type In VARCHAR2 Default NULL
220: --
221: -- Standard IN Parameters :
222: -- p_api_version IN NUMBER Required
223: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
224: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
225: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
226: -- Based on this flag, the API will set the default attributes.
227: -- p_module_type In VARCHAR2 Default NULL
228: -- This will be null.
221: -- Standard IN Parameters :
222: -- p_api_version IN NUMBER Required
223: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
224: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
225: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
226: -- Based on this flag, the API will set the default attributes.
227: -- p_module_type In VARCHAR2 Default NULL
228: -- This will be null.
229: -- Standard out Parameters :
238: --
239: --
240: PROCEDURE Get_Visit_Details (
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 := 'JSP',
246: p_search_visits_Rec IN search_visits_rec_type,
239: --
240: PROCEDURE Get_Visit_Details (
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 := 'JSP',
246: p_search_visits_Rec IN search_visits_rec_type,
247: x_visit_details_tbl OUT NOCOPY visit_details_tbl,
240: PROCEDURE Get_Visit_Details (
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 := 'JSP',
246: p_search_visits_Rec IN search_visits_rec_type,
247: x_visit_details_tbl OUT NOCOPY visit_details_tbl,
248: x_return_status OUT NOCOPY VARCHAR2,