APPS.AHL_VWP_VISITS_STAGES_PVT dependencies on FND_API

Line 153: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

149: -- Parameters :
150: --
151: -- Standard IN Parameters :
152: -- p_api_version IN NUMBER Required
153: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
154: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
155: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
156: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
157: -- p_module_type IN VARCHAR2 Default NULL.

Line 154: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

150: --
151: -- Standard IN Parameters :
152: -- p_api_version IN NUMBER Required
153: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
154: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
155: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
156: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
157: -- p_module_type IN VARCHAR2 Default NULL.
158: --

Line 155: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

151: -- Standard IN Parameters :
152: -- p_api_version IN NUMBER Required
153: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
154: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
155: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
156: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
157: -- p_module_type IN VARCHAR2 Default NULL.
158: --
159: -- Standard OUT Parameters :

Line 156: -- p_default IN VARCHAR2 Default FND_API.G_TRUE

152: -- p_api_version IN NUMBER Required
153: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
154: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
155: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
156: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
157: -- p_module_type IN VARCHAR2 Default NULL.
158: --
159: -- Standard OUT Parameters :
160: -- x_return_status OUT VARCHAR2 Required

Line 175: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

171: -- Initial Version 1.0
172: --------------------------------------------------------------------
173: PROCEDURE Update_Stages (
174: p_api_version IN NUMBER :=1.0,
175: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
176: p_commit IN VARCHAR2 := FND_API.g_false,
177: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
178: p_module_type IN VARCHAR2 := 'JSP',
179: p_visit_id IN NUMBER,

Line 176: p_commit IN VARCHAR2 := FND_API.g_false,

172: --------------------------------------------------------------------
173: PROCEDURE Update_Stages (
174: p_api_version IN NUMBER :=1.0,
175: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
176: p_commit IN VARCHAR2 := FND_API.g_false,
177: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
178: p_module_type IN VARCHAR2 := 'JSP',
179: p_visit_id IN NUMBER,
180: p_x_stages_tbl IN OUT NOCOPY Visit_Stages_Tbl_Type,

Line 177: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

173: PROCEDURE Update_Stages (
174: p_api_version IN NUMBER :=1.0,
175: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
176: p_commit IN VARCHAR2 := FND_API.g_false,
177: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
178: p_module_type IN VARCHAR2 := 'JSP',
179: p_visit_id IN NUMBER,
180: p_x_stages_tbl IN OUT NOCOPY Visit_Stages_Tbl_Type,
181: p_x_stages_ovn_tbl IN OUT NOCOPY Visit_Stages_OVN_Tbl_Type,--VWPE 12730539:: PRAKKUM :: 08-JUL-2011

Line 195: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

191: -- Parameters :
192: --
193: -- Standard IN Parameters :
194: -- p_api_version IN NUMBER Required
195: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
196: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
197: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
198: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
199: -- p_module_type IN VARCHAR2 Default NULL.

Line 196: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

192: --
193: -- Standard IN Parameters :
194: -- p_api_version IN NUMBER Required
195: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
196: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
197: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
198: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
199: -- p_module_type IN VARCHAR2 Default NULL.
200: --

Line 197: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

193: -- Standard IN Parameters :
194: -- p_api_version IN NUMBER Required
195: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
196: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
197: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
198: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
199: -- p_module_type IN VARCHAR2 Default NULL.
200: --
201: -- Standard OUT Parameters :

Line 198: -- p_default IN VARCHAR2 Default FND_API.G_TRUE

194: -- p_api_version IN NUMBER Required
195: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
196: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
197: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
198: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
199: -- p_module_type IN VARCHAR2 Default NULL.
200: --
201: -- Standard OUT Parameters :
202: -- x_return_status OUT VARCHAR2 Required

Line 217: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,

213: -- Initial Version 1.0
214: -------------------------------------------------------------------
215: PROCEDURE Get_Stages_Details (
216: p_api_version IN NUMBER,
217: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
218: p_commit IN VARCHAR2 := Fnd_Api.g_false,
219: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
220: p_module_type IN VARCHAR2 := 'JSP',
221: p_visit_id IN NUMBER,

Line 218: p_commit IN VARCHAR2 := Fnd_Api.g_false,

214: -------------------------------------------------------------------
215: PROCEDURE Get_Stages_Details (
216: p_api_version IN NUMBER,
217: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
218: p_commit IN VARCHAR2 := Fnd_Api.g_false,
219: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
220: p_module_type IN VARCHAR2 := 'JSP',
221: p_visit_id IN NUMBER,
222: p_start_row IN NUMBER,

Line 219: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,

215: PROCEDURE Get_Stages_Details (
216: p_api_version IN NUMBER,
217: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
218: p_commit IN VARCHAR2 := Fnd_Api.g_false,
219: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
220: p_module_type IN VARCHAR2 := 'JSP',
221: p_visit_id IN NUMBER,
222: p_start_row IN NUMBER,
223: p_rows_per_page IN NUMBER,

Line 241: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

237: -- Parameters :
238: --
239: -- Standard IN Parameters :
240: -- p_api_version IN NUMBER Required
241: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
242: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
243: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
244: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
245: -- p_module_type IN VARCHAR2 Default NULL.

Line 242: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

238: --
239: -- Standard IN Parameters :
240: -- p_api_version IN NUMBER Required
241: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
242: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
243: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
244: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
245: -- p_module_type IN VARCHAR2 Default NULL.
246: --

Line 243: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

239: -- Standard IN Parameters :
240: -- p_api_version IN NUMBER Required
241: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
242: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
243: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
244: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
245: -- p_module_type IN VARCHAR2 Default NULL.
246: --
247: -- Standard OUT Parameters :

Line 244: -- p_default IN VARCHAR2 Default FND_API.G_TRUE

240: -- p_api_version IN NUMBER Required
241: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
242: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
243: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
244: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
245: -- p_module_type IN VARCHAR2 Default NULL.
246: --
247: -- Standard OUT Parameters :
248: -- x_return_status OUT VARCHAR2 Required

Line 261: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

257: -- Initial Version 1.0
258: --------------------------------------------------------------------
259: PROCEDURE Create_Stages (
260: p_api_version IN NUMBER :=1.0,
261: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
262: p_commit IN VARCHAR2 := FND_API.g_false,
263: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
264: p_module_type IN VARCHAR2 := 'JSP',
265: p_visit_id IN NUMBER,

Line 262: p_commit IN VARCHAR2 := FND_API.g_false,

258: --------------------------------------------------------------------
259: PROCEDURE Create_Stages (
260: p_api_version IN NUMBER :=1.0,
261: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
262: p_commit IN VARCHAR2 := FND_API.g_false,
263: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
264: p_module_type IN VARCHAR2 := 'JSP',
265: p_visit_id IN NUMBER,
266: p_x_stages_tbl IN OUT NOCOPY Visit_Stages_Tbl_Type, -- PRAKKUM :: 15/03/2011 :: VWPE

Line 263: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

259: PROCEDURE Create_Stages (
260: p_api_version IN NUMBER :=1.0,
261: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
262: p_commit IN VARCHAR2 := FND_API.g_false,
263: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
264: p_module_type IN VARCHAR2 := 'JSP',
265: p_visit_id IN NUMBER,
266: p_x_stages_tbl IN OUT NOCOPY Visit_Stages_Tbl_Type, -- PRAKKUM :: 15/03/2011 :: VWPE
267: x_return_status OUT NOCOPY VARCHAR2,

Line 280: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

276: -- Parameters :
277: --
278: -- Standard IN Parameters :
279: -- p_api_version IN NUMBER Required
280: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
281: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
282: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
283: -- p_module_type IN VARCHAR2 Default NULL.
284: --

Line 281: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

277: --
278: -- Standard IN Parameters :
279: -- p_api_version IN NUMBER Required
280: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
281: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
282: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
283: -- p_module_type IN VARCHAR2 Default NULL.
284: --
285: -- Standard OUT Parameters :

Line 282: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

278: -- Standard IN Parameters :
279: -- p_api_version IN NUMBER Required
280: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
281: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
282: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
283: -- p_module_type IN VARCHAR2 Default NULL.
284: --
285: -- Standard OUT Parameters :
286: -- x_return_status OUT VARCHAR2 Required

Line 296: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,

292: -- p_x_stages_tbl IN Visit_Stages_Tbl_Type Required
293: --------------------------------------------------------------------
294: PROCEDURE Delete_Stages (
295: p_api_version IN NUMBER,
296: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
297: p_commit IN VARCHAR2 := Fnd_Api.g_false,
298: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
299: p_module_type IN VARCHAR2 := 'JSP',
300: p_visit_id IN NUMBER,

Line 297: p_commit IN VARCHAR2 := Fnd_Api.g_false,

293: --------------------------------------------------------------------
294: PROCEDURE Delete_Stages (
295: p_api_version IN NUMBER,
296: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
297: p_commit IN VARCHAR2 := Fnd_Api.g_false,
298: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
299: p_module_type IN VARCHAR2 := 'JSP',
300: p_visit_id IN NUMBER,
301: p_x_stages_tbl IN OUT NOCOPY Visit_Stages_Tbl_Type, -- PRAKKUM :: 15/03/2011 :: VWPE

Line 298: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,

294: PROCEDURE Delete_Stages (
295: p_api_version IN NUMBER,
296: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
297: p_commit IN VARCHAR2 := Fnd_Api.g_false,
298: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
299: p_module_type IN VARCHAR2 := 'JSP',
300: p_visit_id IN NUMBER,
301: p_x_stages_tbl IN OUT NOCOPY Visit_Stages_Tbl_Type, -- PRAKKUM :: 15/03/2011 :: VWPE
302: x_return_status OUT NOCOPY VARCHAR2,

Line 315: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

311: -- Parameters :
312: --
313: -- Standard IN Parameters :
314: -- p_api_version IN NUMBER Required
315: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
316: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
317: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
318: -- p_module_type IN VARCHAR2 Default NULL.
319: --

Line 316: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

312: --
313: -- Standard IN Parameters :
314: -- p_api_version IN NUMBER Required
315: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
316: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
317: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
318: -- p_module_type IN VARCHAR2 Default NULL.
319: --
320: -- Standard OUT Parameters :

Line 317: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

313: -- Standard IN Parameters :
314: -- p_api_version IN NUMBER Required
315: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
316: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
317: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
318: -- p_module_type IN VARCHAR2 Default NULL.
319: --
320: -- Standard OUT Parameters :
321: -- x_return_status OUT VARCHAR2 Required

Line 330: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,

326: -- p_visit_id IN NUMBER Required
327: --------------------------------------------------------------------
328: PROCEDURE Delete_All_Stages (
329: p_api_version IN NUMBER,
330: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
331: p_commit IN VARCHAR2 := Fnd_Api.g_false,
332: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
333: p_module_type IN VARCHAR2 := 'JSP',
334:

Line 331: p_commit IN VARCHAR2 := Fnd_Api.g_false,

327: --------------------------------------------------------------------
328: PROCEDURE Delete_All_Stages (
329: p_api_version IN NUMBER,
330: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
331: p_commit IN VARCHAR2 := Fnd_Api.g_false,
332: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
333: p_module_type IN VARCHAR2 := 'JSP',
334:
335: p_visit_id IN NUMBER,

Line 332: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,

328: PROCEDURE Delete_All_Stages (
329: p_api_version IN NUMBER,
330: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
331: p_commit IN VARCHAR2 := Fnd_Api.g_false,
332: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
333: p_module_type IN VARCHAR2 := 'JSP',
334:
335: p_visit_id IN NUMBER,
336: x_return_status OUT NOCOPY VARCHAR2,

Line 349: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

345: -- Parameters :
346: --
347: -- Standard IN Parameters :
348: -- p_api_version IN NUMBER Required
349: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
350: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
351: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
352: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
353: -- p_module_type IN VARCHAR2 Default NULL.

Line 350: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

346: --
347: -- Standard IN Parameters :
348: -- p_api_version IN NUMBER Required
349: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
350: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
351: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
352: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
353: -- p_module_type IN VARCHAR2 Default NULL.
354: --

Line 351: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

347: -- Standard IN Parameters :
348: -- p_api_version IN NUMBER Required
349: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
350: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
351: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
352: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
353: -- p_module_type IN VARCHAR2 Default NULL.
354: --
355: -- Standard OUT Parameters :

Line 352: -- p_default IN VARCHAR2 Default FND_API.G_TRUE

348: -- p_api_version IN NUMBER Required
349: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
350: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
351: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
352: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
353: -- p_module_type IN VARCHAR2 Default NULL.
354: --
355: -- Standard OUT Parameters :
356: -- x_return_status OUT VARCHAR2 Required

Line 369: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

365: -- Initial Version 1.0
366: --------------------------------------------------------------------
367: PROCEDURE VALIDATE_STAGE_UPDATES(
368: p_api_version IN NUMBER,
369: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
370: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
371: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
372: p_default IN VARCHAR2 := Fnd_Api.G_TRUE,
373: p_module_type IN VARCHAR2 := NULL,

Line 370: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,

366: --------------------------------------------------------------------
367: PROCEDURE VALIDATE_STAGE_UPDATES(
368: p_api_version IN NUMBER,
369: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
370: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
371: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
372: p_default IN VARCHAR2 := Fnd_Api.G_TRUE,
373: p_module_type IN VARCHAR2 := NULL,
374:

Line 371: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,

367: PROCEDURE VALIDATE_STAGE_UPDATES(
368: p_api_version IN NUMBER,
369: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
370: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
371: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
372: p_default IN VARCHAR2 := Fnd_Api.G_TRUE,
373: p_module_type IN VARCHAR2 := NULL,
374:
375: p_visit_id IN NUMBER,

Line 372: p_default IN VARCHAR2 := Fnd_Api.G_TRUE,

368: p_api_version IN NUMBER,
369: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
370: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
371: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
372: p_default IN VARCHAR2 := Fnd_Api.G_TRUE,
373: p_module_type IN VARCHAR2 := NULL,
374:
375: p_visit_id IN NUMBER,
376: p_visit_task_id IN NUMBER,

Line 421: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

417: -- Parameters :
418: --
419: -- Standard IN Parameters :
420: -- p_api_version IN NUMBER Required
421: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
422: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
423: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
424: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
425: -- p_module_type IN VARCHAR2 Default NULL.

Line 422: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

418: --
419: -- Standard IN Parameters :
420: -- p_api_version IN NUMBER Required
421: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
422: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
423: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
424: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
425: -- p_module_type IN VARCHAR2 Default NULL.
426: --

Line 423: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

419: -- Standard IN Parameters :
420: -- p_api_version IN NUMBER Required
421: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
422: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
423: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
424: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
425: -- p_module_type IN VARCHAR2 Default NULL.
426: --
427: -- Standard OUT Parameters :

Line 424: -- p_default IN VARCHAR2 Default FND_API.G_TRUE

420: -- p_api_version IN NUMBER Required
421: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
422: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
423: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
424: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
425: -- p_module_type IN VARCHAR2 Default NULL.
426: --
427: -- Standard OUT Parameters :
428: -- x_return_status OUT VARCHAR2 Required

Line 443: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,

439: -- Initial Version 1.0
440: --------------------------------------------------------------------
441: PROCEDURE Process_StageTyp_Assoc (
442: p_api_version IN NUMBER,
443: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
444: p_commit IN VARCHAR2 := Fnd_Api.g_false,
445: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
446: p_stage_type_assoc_tbl IN Stage_Type_Assoc_Tbl_Type,
447: x_return_status OUT NOCOPY VARCHAR2,

Line 444: p_commit IN VARCHAR2 := Fnd_Api.g_false,

440: --------------------------------------------------------------------
441: PROCEDURE Process_StageTyp_Assoc (
442: p_api_version IN NUMBER,
443: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
444: p_commit IN VARCHAR2 := Fnd_Api.g_false,
445: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
446: p_stage_type_assoc_tbl IN Stage_Type_Assoc_Tbl_Type,
447: x_return_status OUT NOCOPY VARCHAR2,
448: x_msg_count OUT NOCOPY NUMBER,

Line 445: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,

441: PROCEDURE Process_StageTyp_Assoc (
442: p_api_version IN NUMBER,
443: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
444: p_commit IN VARCHAR2 := Fnd_Api.g_false,
445: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
446: p_stage_type_assoc_tbl IN Stage_Type_Assoc_Tbl_Type,
447: x_return_status OUT NOCOPY VARCHAR2,
448: x_msg_count OUT NOCOPY NUMBER,
449: x_msg_data OUT NOCOPY VARCHAR2

Line 489: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,

485: -- To create stages and stage rules in a visit when visit type is associated to a visit.
486: ------------------------------------------------------------------------------------------
487: PROCEDURE Assoc_VisitType_to_Visit (
488: p_api_version IN NUMBER,
489: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
490: p_commit IN VARCHAR2 := Fnd_Api.g_false,
491: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
492: p_visit_id IN NUMBER,
493: p_visit_type_code IN VARCHAR2,

Line 490: p_commit IN VARCHAR2 := Fnd_Api.g_false,

486: ------------------------------------------------------------------------------------------
487: PROCEDURE Assoc_VisitType_to_Visit (
488: p_api_version IN NUMBER,
489: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
490: p_commit IN VARCHAR2 := Fnd_Api.g_false,
491: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
492: p_visit_id IN NUMBER,
493: p_visit_type_code IN VARCHAR2,
494: x_return_status OUT NOCOPY VARCHAR2,

Line 491: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,

487: PROCEDURE Assoc_VisitType_to_Visit (
488: p_api_version IN NUMBER,
489: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
490: p_commit IN VARCHAR2 := Fnd_Api.g_false,
491: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
492: p_visit_id IN NUMBER,
493: p_visit_type_code IN VARCHAR2,
494: x_return_status OUT NOCOPY VARCHAR2,
495: x_msg_count OUT NOCOPY NUMBER,

Line 529: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

525: -- Parameters :
526: --
527: -- Standard IN Parameters :
528: -- p_api_version IN NUMBER Required
529: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
530: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
531: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
532: -- p_module_type IN VARCHAR2 Default NULL.
533: --

Line 530: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

526: --
527: -- Standard IN Parameters :
528: -- p_api_version IN NUMBER Required
529: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
530: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
531: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
532: -- p_module_type IN VARCHAR2 Default NULL.
533: --
534: -- Standard OUT Parameters :

Line 531: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

527: -- Standard IN Parameters :
528: -- p_api_version IN NUMBER Required
529: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
530: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
531: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
532: -- p_module_type IN VARCHAR2 Default NULL.
533: --
534: -- Standard OUT Parameters :
535: -- x_return_status OUT VARCHAR2 Required

Line 547: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,

543: -- Initial Version 1.0
544: --------------------------------------------------------------------
545: PROCEDURE UPDATE_STAGES_HIERARICHY (
546: p_api_version IN NUMBER,
547: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
548: p_commit IN VARCHAR2 := Fnd_Api.g_false,
549: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
550: p_module_type IN VARCHAR2 := 'JSP',
551: p_visit_id IN NUMBER,

Line 548: p_commit IN VARCHAR2 := Fnd_Api.g_false,

544: --------------------------------------------------------------------
545: PROCEDURE UPDATE_STAGES_HIERARICHY (
546: p_api_version IN NUMBER,
547: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
548: p_commit IN VARCHAR2 := Fnd_Api.g_false,
549: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
550: p_module_type IN VARCHAR2 := 'JSP',
551: p_visit_id IN NUMBER,
552:

Line 549: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,

545: PROCEDURE UPDATE_STAGES_HIERARICHY (
546: p_api_version IN NUMBER,
547: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
548: p_commit IN VARCHAR2 := Fnd_Api.g_false,
549: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
550: p_module_type IN VARCHAR2 := 'JSP',
551: p_visit_id IN NUMBER,
552:
553: x_return_status OUT NOCOPY VARCHAR2,

Line 566: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

562: -- Parameters :
563: --
564: -- Standard IN Parameters :
565: -- p_api_version IN NUMBER Required
566: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
567: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
568: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
569: -- p_module_type IN VARCHAR2 Default NULL.
570: --

Line 567: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

563: --
564: -- Standard IN Parameters :
565: -- p_api_version IN NUMBER Required
566: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
567: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
568: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
569: -- p_module_type IN VARCHAR2 Default NULL.
570: --
571: -- Standard OUT Parameters :

Line 568: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

564: -- Standard IN Parameters :
565: -- p_api_version IN NUMBER Required
566: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
567: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
568: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
569: -- p_module_type IN VARCHAR2 Default NULL.
570: --
571: -- Standard OUT Parameters :
572: -- x_return_status OUT VARCHAR2 Required

Line 585: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,

581: -- Initial Version 1.0
582: --------------------------------------------------------------------
583: PROCEDURE UPDATE_STG_RUL_HIERARCHY (
584: p_api_version IN NUMBER,
585: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
586: p_commit IN VARCHAR2 := Fnd_Api.g_false,
587: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
588: p_module_type IN VARCHAR2 := 'JSP',
589: p_stage_link_id IN NUMBER,

Line 586: p_commit IN VARCHAR2 := Fnd_Api.g_false,

582: --------------------------------------------------------------------
583: PROCEDURE UPDATE_STG_RUL_HIERARCHY (
584: p_api_version IN NUMBER,
585: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
586: p_commit IN VARCHAR2 := Fnd_Api.g_false,
587: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
588: p_module_type IN VARCHAR2 := 'JSP',
589: p_stage_link_id IN NUMBER,
590: p_visit_id IN NUMBER,

Line 587: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,

583: PROCEDURE UPDATE_STG_RUL_HIERARCHY (
584: p_api_version IN NUMBER,
585: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
586: p_commit IN VARCHAR2 := Fnd_Api.g_false,
587: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
588: p_module_type IN VARCHAR2 := 'JSP',
589: p_stage_link_id IN NUMBER,
590: p_visit_id IN NUMBER,
591: x_return_status OUT NOCOPY VARCHAR2,

Line 604: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

600: -- Parameters :
601: --
602: -- Standard IN Parameters :
603: -- p_api_version IN NUMBER Required
604: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
605: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
606: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
607: -- p_module_type IN VARCHAR2 Default NULL.
608: --

Line 605: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

601: --
602: -- Standard IN Parameters :
603: -- p_api_version IN NUMBER Required
604: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
605: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
606: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
607: -- p_module_type IN VARCHAR2 Default NULL.
608: --
609: -- Standard OUT Parameters :

Line 606: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

602: -- Standard IN Parameters :
603: -- p_api_version IN NUMBER Required
604: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
605: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
606: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
607: -- p_module_type IN VARCHAR2 Default NULL.
608: --
609: -- Standard OUT Parameters :
610: -- x_return_status OUT VARCHAR2 Required

Line 625: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,

621: -- Initial Version 1.0
622: --------------------------------------------------------------------
623: PROCEDURE UPDATE_AS_STAGE_RULE_DEL (
624: p_api_version IN NUMBER,
625: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
626: p_commit IN VARCHAR2 := Fnd_Api.g_false,
627: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
628: p_module_type IN VARCHAR2 := 'JSP',
629:

Line 626: p_commit IN VARCHAR2 := Fnd_Api.g_false,

622: --------------------------------------------------------------------
623: PROCEDURE UPDATE_AS_STAGE_RULE_DEL (
624: p_api_version IN NUMBER,
625: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
626: p_commit IN VARCHAR2 := Fnd_Api.g_false,
627: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
628: p_module_type IN VARCHAR2 := 'JSP',
629:
630: p_object_id IN NUMBER,

Line 627: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,

623: PROCEDURE UPDATE_AS_STAGE_RULE_DEL (
624: p_api_version IN NUMBER,
625: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
626: p_commit IN VARCHAR2 := Fnd_Api.g_false,
627: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
628: p_module_type IN VARCHAR2 := 'JSP',
629:
630: p_object_id IN NUMBER,
631: p_subject_id IN NUMBER,