145: -- Parameters :
146: --
147: -- Standard IN Parameters :
148: -- p_api_version IN NUMBER Required
149: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
150: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
151: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
152: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
153: -- Based on this flag, the API will set the default attributes.
146: --
147: -- Standard IN Parameters :
148: -- p_api_version IN NUMBER Required
149: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
150: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
151: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
152: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
153: -- Based on this flag, the API will set the default attributes.
154: -- p_module_type In VARCHAR2 Default NULL
147: -- Standard IN Parameters :
148: -- p_api_version IN NUMBER Required
149: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
150: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
151: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
152: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
153: -- Based on this flag, the API will set the default attributes.
154: -- p_module_type In VARCHAR2 Default NULL
155: -- This will be null.
148: -- p_api_version IN NUMBER Required
149: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
150: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
151: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
152: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
153: -- Based on this flag, the API will set the default attributes.
154: -- p_module_type In VARCHAR2 Default NULL
155: -- This will be null.
156: -- Standard OUT Parameters :
170: --
171:
172: PROCEDURE Process_UnitEffectivity (
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
175: p_commit IN VARCHAR2 := FND_API.G_FALSE,
176: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
177: p_default IN VARCHAR2 := FND_API.G_TRUE,
178: p_module_type IN VARCHAR2 := NULL,
171:
172: PROCEDURE Process_UnitEffectivity (
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
175: p_commit IN VARCHAR2 := FND_API.G_FALSE,
176: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
177: p_default IN VARCHAR2 := FND_API.G_TRUE,
178: p_module_type IN VARCHAR2 := NULL,
179: x_return_status OUT NOCOPY VARCHAR2,
172: PROCEDURE Process_UnitEffectivity (
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
175: p_commit IN VARCHAR2 := FND_API.G_FALSE,
176: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
177: p_default IN VARCHAR2 := FND_API.G_TRUE,
178: p_module_type IN VARCHAR2 := NULL,
179: x_return_status OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
175: p_commit IN VARCHAR2 := FND_API.G_FALSE,
176: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
177: p_default IN VARCHAR2 := FND_API.G_TRUE,
178: p_module_type IN VARCHAR2 := NULL,
179: x_return_status OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,
181: x_msg_data OUT NOCOPY VARCHAR2,
230: -- p_concurrent_flag will be 'Y' if this procedure is called by the concurrent program else it
231: -- will be N. Default is N.
232: --
233: PROCEDURE Build_UnitEffectivity (
234: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
235: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
236: p_default IN VARCHAR2 := FND_API.G_TRUE,
237: p_module_type IN VARCHAR2 := NULL,
238: x_return_status OUT NOCOPY VARCHAR2,
231: -- will be N. Default is N.
232: --
233: PROCEDURE Build_UnitEffectivity (
234: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
235: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
236: p_default IN VARCHAR2 := FND_API.G_TRUE,
237: p_module_type IN VARCHAR2 := NULL,
238: x_return_status OUT NOCOPY VARCHAR2,
239: x_msg_count OUT NOCOPY NUMBER,
232: --
233: PROCEDURE Build_UnitEffectivity (
234: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
235: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
236: p_default IN VARCHAR2 := FND_API.G_TRUE,
237: p_module_type IN VARCHAR2 := NULL,
238: x_return_status OUT NOCOPY VARCHAR2,
239: x_msg_count OUT NOCOPY NUMBER,
240: x_msg_data OUT NOCOPY VARCHAR2,
282: -- Parameters :
283: --
284: -- Standard IN Parameters :
285: -- p_api_version IN NUMBER Required
286: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
287: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
288: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
289: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
290: -- p_module_type IN VARCHAR2 Default NULL.
283: --
284: -- Standard IN Parameters :
285: -- p_api_version IN NUMBER Required
286: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
287: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
288: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
289: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
290: -- p_module_type IN VARCHAR2 Default NULL.
291: --
284: -- Standard IN Parameters :
285: -- p_api_version IN NUMBER Required
286: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
287: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
288: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
289: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
290: -- p_module_type IN VARCHAR2 Default NULL.
291: --
292: -- Standard OUT Parameters :
285: -- p_api_version IN NUMBER Required
286: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
287: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
288: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
289: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
290: -- p_module_type IN VARCHAR2 Default NULL.
291: --
292: -- Standard OUT Parameters :
293: -- x_return_status OUT VARCHAR2 Required
311:
312: PROCEDURE Capture_MR_Updates
313: (
314: p_api_version IN NUMBER,
315: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
316: p_commit IN VARCHAR2 := FND_API.G_FALSE,
317: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
318: p_default IN VARCHAR2 := FND_API.G_TRUE,
319: p_module_type IN VARCHAR2 := NULL,
312: PROCEDURE Capture_MR_Updates
313: (
314: p_api_version IN NUMBER,
315: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
316: p_commit IN VARCHAR2 := FND_API.G_FALSE,
317: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
318: p_default IN VARCHAR2 := FND_API.G_TRUE,
319: p_module_type IN VARCHAR2 := NULL,
320: p_unit_Effectivity_tbl IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_tbl_type,
313: (
314: p_api_version IN NUMBER,
315: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
316: p_commit IN VARCHAR2 := FND_API.G_FALSE,
317: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
318: p_default IN VARCHAR2 := FND_API.G_TRUE,
319: p_module_type IN VARCHAR2 := NULL,
320: p_unit_Effectivity_tbl IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_tbl_type,
321: p_x_unit_threshold_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type,
314: p_api_version IN NUMBER,
315: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
316: p_commit IN VARCHAR2 := FND_API.G_FALSE,
317: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
318: p_default IN VARCHAR2 := FND_API.G_TRUE,
319: p_module_type IN VARCHAR2 := NULL,
320: p_unit_Effectivity_tbl IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_tbl_type,
321: p_x_unit_threshold_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type,
322: p_x_unit_accomplish_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_tbl_type,
333: -- Parameters :
334: --
335: -- Standard IN Parameters :
336: -- p_api_version IN NUMBER Required
337: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
338: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
339: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
340: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
341: -- p_module_type IN VARCHAR2 Default NULL.
334: --
335: -- Standard IN Parameters :
336: -- p_api_version IN NUMBER Required
337: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
338: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
339: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
340: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
341: -- p_module_type IN VARCHAR2 Default NULL.
342: --
335: -- Standard IN Parameters :
336: -- p_api_version IN NUMBER Required
337: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
338: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
339: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
340: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
341: -- p_module_type IN VARCHAR2 Default NULL.
342: --
343: -- Standard OUT Parameters :
336: -- p_api_version IN NUMBER Required
337: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
338: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
339: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
340: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
341: -- p_module_type IN VARCHAR2 Default NULL.
342: --
343: -- Standard OUT Parameters :
344: -- x_return_status OUT VARCHAR2 Required
355:
356: PROCEDURE Validate_For_Initialize
357: (
358: p_api_version IN NUMBER,
359: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
360: -- This parameter does not make any sense in this method. Added for standard compliance
361: p_commit IN VARCHAR2 := FND_API.G_FALSE,
362: -- This parameter does not make any sense in this method. Added for standard compliance
363: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
357: (
358: p_api_version IN NUMBER,
359: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
360: -- This parameter does not make any sense in this method. Added for standard compliance
361: p_commit IN VARCHAR2 := FND_API.G_FALSE,
362: -- This parameter does not make any sense in this method. Added for standard compliance
363: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
364: -- This parameter does not make any sense in this method. Added for standard compliance
365: p_default IN VARCHAR2 := FND_API.G_TRUE,
359: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
360: -- This parameter does not make any sense in this method. Added for standard compliance
361: p_commit IN VARCHAR2 := FND_API.G_FALSE,
362: -- This parameter does not make any sense in this method. Added for standard compliance
363: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
364: -- This parameter does not make any sense in this method. Added for standard compliance
365: p_default IN VARCHAR2 := FND_API.G_TRUE,
366: -- This parameter does not make any sense in this method. Added for standard compliance
367: p_module_type IN VARCHAR2 := NULL,
361: p_commit IN VARCHAR2 := FND_API.G_FALSE,
362: -- This parameter does not make any sense in this method. Added for standard compliance
363: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
364: -- This parameter does not make any sense in this method. Added for standard compliance
365: p_default IN VARCHAR2 := FND_API.G_TRUE,
366: -- This parameter does not make any sense in this method. Added for standard compliance
367: p_module_type IN VARCHAR2 := NULL,
368: p_unit_effectivity_id IN NUMBER,
369: x_return_status OUT NOCOPY VARCHAR2,
384: -- Parameters :
385: --
386: -- Standard IN Parameters :
387: -- p_api_version IN NUMBER Required
388: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
389: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
390: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
391: -- Standard OUT Parameters :
392: -- x_return_status OUT VARCHAR2 Required
385: --
386: -- Standard IN Parameters :
387: -- p_api_version IN NUMBER Required
388: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
389: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
390: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
391: -- Standard OUT Parameters :
392: -- x_return_status OUT VARCHAR2 Required
393: -- x_msg_count OUT NUMBER Required
386: -- Standard IN Parameters :
387: -- p_api_version IN NUMBER Required
388: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
389: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
390: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
391: -- Standard OUT Parameters :
392: -- x_return_status OUT VARCHAR2 Required
393: -- x_msg_count OUT NUMBER Required
394: -- x_msg_data OUT VARCHAR2 Required
412: --
413: -- End of Comments.
414: PROCEDURE Terminate_MR_Instances(
415: p_api_version IN NUMBER := 1.0,
416: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
417: p_commit IN VARCHAR2 := FND_API.G_FALSE,
418: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
419: p_default IN VARCHAR2 := FND_API.G_TRUE,
420: p_module_type IN VARCHAR2 := NULL,
413: -- End of Comments.
414: PROCEDURE Terminate_MR_Instances(
415: p_api_version IN NUMBER := 1.0,
416: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
417: p_commit IN VARCHAR2 := FND_API.G_FALSE,
418: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
419: p_default IN VARCHAR2 := FND_API.G_TRUE,
420: p_module_type IN VARCHAR2 := NULL,
421: p_old_mr_header_id IN NUMBER,
414: PROCEDURE Terminate_MR_Instances(
415: p_api_version IN NUMBER := 1.0,
416: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
417: p_commit IN VARCHAR2 := FND_API.G_FALSE,
418: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
419: p_default IN VARCHAR2 := FND_API.G_TRUE,
420: p_module_type IN VARCHAR2 := NULL,
421: p_old_mr_header_id IN NUMBER,
422: p_old_mr_title IN VARCHAR2,
415: p_api_version IN NUMBER := 1.0,
416: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
417: p_commit IN VARCHAR2 := FND_API.G_FALSE,
418: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
419: p_default IN VARCHAR2 := FND_API.G_TRUE,
420: p_module_type IN VARCHAR2 := NULL,
421: p_old_mr_header_id IN NUMBER,
422: p_old_mr_title IN VARCHAR2,
423: p_old_version_number IN NUMBER,