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,
266: -- Parameters :
267: --
268: -- Standard IN Parameters :
269: -- p_api_version IN NUMBER Required
270: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
271: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
272: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
273: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
274: -- p_module_type IN VARCHAR2 Default NULL.
267: --
268: -- Standard IN Parameters :
269: -- p_api_version IN NUMBER Required
270: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
271: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
272: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
273: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
274: -- p_module_type IN VARCHAR2 Default NULL.
275: --
268: -- Standard IN Parameters :
269: -- p_api_version IN NUMBER Required
270: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
271: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
272: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
273: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
274: -- p_module_type IN VARCHAR2 Default NULL.
275: --
276: -- Standard OUT Parameters :
269: -- p_api_version IN NUMBER Required
270: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
271: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
272: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
273: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
274: -- p_module_type IN VARCHAR2 Default NULL.
275: --
276: -- Standard OUT Parameters :
277: -- x_return_status OUT VARCHAR2 Required
295:
296: PROCEDURE Capture_MR_Updates
297: (
298: p_api_version IN NUMBER,
299: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
300: p_commit IN VARCHAR2 := FND_API.G_FALSE,
301: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
302: p_default IN VARCHAR2 := FND_API.G_TRUE,
303: p_module_type IN VARCHAR2 := NULL,
296: PROCEDURE Capture_MR_Updates
297: (
298: p_api_version IN NUMBER,
299: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
300: p_commit IN VARCHAR2 := FND_API.G_FALSE,
301: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
302: p_default IN VARCHAR2 := FND_API.G_TRUE,
303: p_module_type IN VARCHAR2 := NULL,
304: p_unit_Effectivity_tbl IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_tbl_type,
297: (
298: p_api_version IN NUMBER,
299: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
300: p_commit IN VARCHAR2 := FND_API.G_FALSE,
301: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
302: p_default IN VARCHAR2 := FND_API.G_TRUE,
303: p_module_type IN VARCHAR2 := NULL,
304: p_unit_Effectivity_tbl IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_tbl_type,
305: p_x_unit_threshold_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type,
298: p_api_version IN NUMBER,
299: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
300: p_commit IN VARCHAR2 := FND_API.G_FALSE,
301: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
302: p_default IN VARCHAR2 := FND_API.G_TRUE,
303: p_module_type IN VARCHAR2 := NULL,
304: p_unit_Effectivity_tbl IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_tbl_type,
305: p_x_unit_threshold_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type,
306: p_x_unit_accomplish_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_tbl_type,
317: -- Parameters :
318: --
319: -- Standard IN Parameters :
320: -- p_api_version IN NUMBER Required
321: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
322: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
323: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
324: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
325: -- p_module_type IN VARCHAR2 Default NULL.
318: --
319: -- Standard IN Parameters :
320: -- p_api_version IN NUMBER Required
321: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
322: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
323: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
324: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
325: -- p_module_type IN VARCHAR2 Default NULL.
326: --
319: -- Standard IN Parameters :
320: -- p_api_version IN NUMBER Required
321: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
322: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
323: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
324: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
325: -- p_module_type IN VARCHAR2 Default NULL.
326: --
327: -- Standard OUT Parameters :
320: -- p_api_version IN NUMBER Required
321: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
322: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
323: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
324: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
325: -- p_module_type IN VARCHAR2 Default NULL.
326: --
327: -- Standard OUT Parameters :
328: -- x_return_status OUT VARCHAR2 Required
339:
340: PROCEDURE Validate_For_Initialize
341: (
342: p_api_version IN NUMBER,
343: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
344: -- This parameter does not make any sense in this method. Added for standard compliance
345: p_commit IN VARCHAR2 := FND_API.G_FALSE,
346: -- This parameter does not make any sense in this method. Added for standard compliance
347: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
341: (
342: p_api_version IN NUMBER,
343: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
344: -- This parameter does not make any sense in this method. Added for standard compliance
345: p_commit IN VARCHAR2 := FND_API.G_FALSE,
346: -- This parameter does not make any sense in this method. Added for standard compliance
347: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
348: -- This parameter does not make any sense in this method. Added for standard compliance
349: p_default IN VARCHAR2 := FND_API.G_TRUE,
343: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
344: -- This parameter does not make any sense in this method. Added for standard compliance
345: p_commit IN VARCHAR2 := FND_API.G_FALSE,
346: -- This parameter does not make any sense in this method. Added for standard compliance
347: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
348: -- This parameter does not make any sense in this method. Added for standard compliance
349: p_default IN VARCHAR2 := FND_API.G_TRUE,
350: -- This parameter does not make any sense in this method. Added for standard compliance
351: p_module_type IN VARCHAR2 := NULL,
345: p_commit IN VARCHAR2 := FND_API.G_FALSE,
346: -- This parameter does not make any sense in this method. Added for standard compliance
347: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
348: -- This parameter does not make any sense in this method. Added for standard compliance
349: p_default IN VARCHAR2 := FND_API.G_TRUE,
350: -- This parameter does not make any sense in this method. Added for standard compliance
351: p_module_type IN VARCHAR2 := NULL,
352: p_unit_effectivity_id IN NUMBER,
353: x_return_status OUT NOCOPY VARCHAR2,
368: -- Parameters :
369: --
370: -- Standard IN Parameters :
371: -- p_api_version IN NUMBER Required
372: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
373: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
374: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
375: -- Standard OUT Parameters :
376: -- x_return_status OUT VARCHAR2 Required
369: --
370: -- Standard IN Parameters :
371: -- p_api_version IN NUMBER Required
372: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
373: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
374: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
375: -- Standard OUT Parameters :
376: -- x_return_status OUT VARCHAR2 Required
377: -- x_msg_count OUT NUMBER Required
370: -- Standard IN Parameters :
371: -- p_api_version IN NUMBER Required
372: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
373: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
374: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
375: -- Standard OUT Parameters :
376: -- x_return_status OUT VARCHAR2 Required
377: -- x_msg_count OUT NUMBER Required
378: -- x_msg_data OUT VARCHAR2 Required
396: --
397: -- End of Comments.
398: PROCEDURE Terminate_MR_Instances(
399: p_api_version IN NUMBER := 1.0,
400: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
401: p_commit IN VARCHAR2 := FND_API.G_FALSE,
402: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
403: p_default IN VARCHAR2 := FND_API.G_TRUE,
404: p_module_type IN VARCHAR2 := NULL,
397: -- End of Comments.
398: PROCEDURE Terminate_MR_Instances(
399: p_api_version IN NUMBER := 1.0,
400: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
401: p_commit IN VARCHAR2 := FND_API.G_FALSE,
402: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
403: p_default IN VARCHAR2 := FND_API.G_TRUE,
404: p_module_type IN VARCHAR2 := NULL,
405: p_old_mr_header_id IN NUMBER,
398: PROCEDURE Terminate_MR_Instances(
399: p_api_version IN NUMBER := 1.0,
400: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
401: p_commit IN VARCHAR2 := FND_API.G_FALSE,
402: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
403: p_default IN VARCHAR2 := FND_API.G_TRUE,
404: p_module_type IN VARCHAR2 := NULL,
405: p_old_mr_header_id IN NUMBER,
406: p_old_mr_title IN VARCHAR2,
399: p_api_version IN NUMBER := 1.0,
400: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
401: p_commit IN VARCHAR2 := FND_API.G_FALSE,
402: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
403: p_default IN VARCHAR2 := FND_API.G_TRUE,
404: p_module_type IN VARCHAR2 := NULL,
405: p_old_mr_header_id IN NUMBER,
406: p_old_mr_title IN VARCHAR2,
407: p_old_version_number IN NUMBER,