24: -- Parameters :
25: --
26: -- Standard IN Parameters :
27: -- p_api_version IN NUMBER Default 1.0
28: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
29: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
30: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
31: -- Standard OUT Parameters :
32: -- x_return_status OUT VARCHAR2 Required
25: --
26: -- Standard IN Parameters :
27: -- p_api_version IN NUMBER Default 1.0
28: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
29: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
30: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
31: -- Standard OUT Parameters :
32: -- x_return_status OUT VARCHAR2 Required
33: -- x_msg_count OUT NUMBER Required
26: -- Standard IN Parameters :
27: -- p_api_version IN NUMBER Default 1.0
28: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
29: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
30: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
31: -- Standard OUT Parameters :
32: -- x_return_status OUT VARCHAR2 Required
33: -- x_msg_count OUT NUMBER Required
34: -- x_msg_data OUT VARCHAR2 Required
55: /*#
56: * For a given set of instances, records their statuses with either accomplishment date or deferred-next due date
57: * or termination date with their corresponding counter and counter values.
58: * @param p_api_version Api Version Number
59: * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE
60: * @param p_commit to decide whether to commit the transaction or not, default value FND_API.G_FALSE
61: * @param p_validation_level validation level, default value FND_API.G_VALID_LEVEL_FULL
62: * @param p_unit_Effectivity_tbl Unit Effectivity Table of type AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_tbl_type
63: * @param p_x_unit_threshold_tbl Unit Thresholds Details Table of type AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type
56: * For a given set of instances, records their statuses with either accomplishment date or deferred-next due date
57: * or termination date with their corresponding counter and counter values.
58: * @param p_api_version Api Version Number
59: * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE
60: * @param p_commit to decide whether to commit the transaction or not, default value FND_API.G_FALSE
61: * @param p_validation_level validation level, default value FND_API.G_VALID_LEVEL_FULL
62: * @param p_unit_Effectivity_tbl Unit Effectivity Table of type AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_tbl_type
63: * @param p_x_unit_threshold_tbl Unit Thresholds Details Table of type AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type
64: * @param p_x_unit_accomplish_tbl Unit Accomplishment Details Table of type AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type
57: * or termination date with their corresponding counter and counter values.
58: * @param p_api_version Api Version Number
59: * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE
60: * @param p_commit to decide whether to commit the transaction or not, default value FND_API.G_FALSE
61: * @param p_validation_level validation level, default value FND_API.G_VALID_LEVEL_FULL
62: * @param p_unit_Effectivity_tbl Unit Effectivity Table of type AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_tbl_type
63: * @param p_x_unit_threshold_tbl Unit Thresholds Details Table of type AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type
64: * @param p_x_unit_accomplish_tbl Unit Accomplishment Details Table of type AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type
65: * @param x_return_status return status
70: * @rep:displayname Capture Unit Maintenance Plan Updates
71: */
72: PROCEDURE Capture_MR_Updates (
73: p_api_version IN NUMBER := 1.0,
74: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
75: p_commit IN VARCHAR2 := FND_API.G_FALSE,
76: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
77: p_unit_Effectivity_tbl IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_tbl_type,
78: p_x_unit_threshold_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type,
71: */
72: PROCEDURE Capture_MR_Updates (
73: p_api_version IN NUMBER := 1.0,
74: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
75: p_commit IN VARCHAR2 := FND_API.G_FALSE,
76: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
77: p_unit_Effectivity_tbl IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_tbl_type,
78: p_x_unit_threshold_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type,
79: p_x_unit_accomplish_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_tbl_type,
72: PROCEDURE Capture_MR_Updates (
73: p_api_version IN NUMBER := 1.0,
74: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
75: p_commit IN VARCHAR2 := FND_API.G_FALSE,
76: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
77: p_unit_Effectivity_tbl IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_tbl_type,
78: p_x_unit_threshold_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type,
79: p_x_unit_accomplish_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_tbl_type,
80: x_return_status OUT NOCOPY VARCHAR2,
94: -- Parameters :
95: --
96: -- Standard IN Parameters :
97: -- p_api_version IN NUMBER Required
98: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
99: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
100: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
101: -- Standard OUT Parameters :
102: -- x_return_status OUT VARCHAR2 Required
95: --
96: -- Standard IN Parameters :
97: -- p_api_version IN NUMBER Required
98: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
99: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
100: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
101: -- Standard OUT Parameters :
102: -- x_return_status OUT VARCHAR2 Required
103: -- x_msg_count OUT NUMBER Required
96: -- Standard IN Parameters :
97: -- p_api_version IN NUMBER Required
98: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
99: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
100: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
101: -- Standard OUT Parameters :
102: -- x_return_status OUT VARCHAR2 Required
103: -- x_msg_count OUT NUMBER Required
104: -- x_msg_data OUT VARCHAR2 Required
120: /*#
121: * Terminate a Unit Maintenance Plan Schedule based on termination of a Maintenance Requirement. Also creates a new Unit Maintenance
122: * Plan based on new Maintenance Requirementthat replaces the terminated Maintenance Requirement.
123: * @param p_api_version Api Version Number
124: * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE
125: * @param p_commit to decide whether to commit the transaction or not, default value FND_API.G_FALSE
126: * @param p_validation_level validation level, default value FND_API.G_VALID_LEVEL_FULL
127: * @param p_module_type Module Type Value always NULL, For internal use
128: * @param p_default Defaulting , default value FND_API.G_TRUE
121: * Terminate a Unit Maintenance Plan Schedule based on termination of a Maintenance Requirement. Also creates a new Unit Maintenance
122: * Plan based on new Maintenance Requirementthat replaces the terminated Maintenance Requirement.
123: * @param p_api_version Api Version Number
124: * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE
125: * @param p_commit to decide whether to commit the transaction or not, default value FND_API.G_FALSE
126: * @param p_validation_level validation level, default value FND_API.G_VALID_LEVEL_FULL
127: * @param p_module_type Module Type Value always NULL, For internal use
128: * @param p_default Defaulting , default value FND_API.G_TRUE
129: * @param p_old_mr_header_id Terminated Maintenance Requirement ID
122: * Plan based on new Maintenance Requirementthat replaces the terminated Maintenance Requirement.
123: * @param p_api_version Api Version Number
124: * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE
125: * @param p_commit to decide whether to commit the transaction or not, default value FND_API.G_FALSE
126: * @param p_validation_level validation level, default value FND_API.G_VALID_LEVEL_FULL
127: * @param p_module_type Module Type Value always NULL, For internal use
128: * @param p_default Defaulting , default value FND_API.G_TRUE
129: * @param p_old_mr_header_id Terminated Maintenance Requirement ID
130: * @param p_old_mr_title Terminated Maintenance Requirement Title
124: * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE
125: * @param p_commit to decide whether to commit the transaction or not, default value FND_API.G_FALSE
126: * @param p_validation_level validation level, default value FND_API.G_VALID_LEVEL_FULL
127: * @param p_module_type Module Type Value always NULL, For internal use
128: * @param p_default Defaulting , default value FND_API.G_TRUE
129: * @param p_old_mr_header_id Terminated Maintenance Requirement ID
130: * @param p_old_mr_title Terminated Maintenance Requirement Title
131: * @param p_old_version_number Terminated Maintenance Requirement Version Number
132: * @param p_new_mr_header_id New Maintenance Requirement ID
140: * @rep:displayname Terminate Unit Maintenance Plan Schedule
141: */
142: PROCEDURE Terminate_MR_Instances (
143: p_api_version IN NUMBER := 1.0,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE,
146: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147: p_default IN VARCHAR2 := FND_API.G_TRUE,
148: p_module_type IN VARCHAR2 := NULL,
141: */
142: PROCEDURE Terminate_MR_Instances (
143: p_api_version IN NUMBER := 1.0,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE,
146: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147: p_default IN VARCHAR2 := FND_API.G_TRUE,
148: p_module_type IN VARCHAR2 := NULL,
149: p_old_mr_header_id IN NUMBER,
142: PROCEDURE Terminate_MR_Instances (
143: p_api_version IN NUMBER := 1.0,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE,
146: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147: p_default IN VARCHAR2 := FND_API.G_TRUE,
148: p_module_type IN VARCHAR2 := NULL,
149: p_old_mr_header_id IN NUMBER,
150: p_old_mr_title IN VARCHAR2,
143: p_api_version IN NUMBER := 1.0,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE,
146: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147: p_default IN VARCHAR2 := FND_API.G_TRUE,
148: p_module_type IN VARCHAR2 := NULL,
149: p_old_mr_header_id IN NUMBER,
150: p_old_mr_title IN VARCHAR2,
151: p_old_version_number IN NUMBER,
167: -- Parameters :
168: --
169: -- Standard IN Parameters :
170: -- p_api_version IN NUMBER Required
171: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
172: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
173: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
174: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
175: -- Based on this flag, the API will set the default attributes.
168: --
169: -- Standard IN Parameters :
170: -- p_api_version IN NUMBER Required
171: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
172: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
173: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
174: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
175: -- Based on this flag, the API will set the default attributes.
176: -- p_module_type In VARCHAR2 Default NULL
169: -- Standard IN Parameters :
170: -- p_api_version IN NUMBER Required
171: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
172: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
173: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
174: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
175: -- Based on this flag, the API will set the default attributes.
176: -- p_module_type In VARCHAR2 Default NULL
177: -- This will be null.
170: -- p_api_version IN NUMBER Required
171: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
172: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
173: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
174: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
175: -- Based on this flag, the API will set the default attributes.
176: -- p_module_type In VARCHAR2 Default NULL
177: -- This will be null.
178: -- Standard OUT Parameters :
192: --
193: /*#
194: * Builds applicable Unit Maintenance Plan Schedule for a Unit or Item Instance
195: * @param p_api_version Api Version Number
196: * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE
197: * @param p_commit to decide whether to commit the transaction or not, default value FND_API.G_FALSE
198: * @param p_validation_level validation level, default value FND_API.G_VALID_LEVEL_FULL
199: * @param p_default Defaulting , default value FND_API.G_TRUE
200: * @param p_module_type Module Type Value always NULL, For internal use
193: /*#
194: * Builds applicable Unit Maintenance Plan Schedule for a Unit or Item Instance
195: * @param p_api_version Api Version Number
196: * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE
197: * @param p_commit to decide whether to commit the transaction or not, default value FND_API.G_FALSE
198: * @param p_validation_level validation level, default value FND_API.G_VALID_LEVEL_FULL
199: * @param p_default Defaulting , default value FND_API.G_TRUE
200: * @param p_module_type Module Type Value always NULL, For internal use
201: * @param p_mr_header_id Maintenance Requirement Header ID
194: * Builds applicable Unit Maintenance Plan Schedule for a Unit or Item Instance
195: * @param p_api_version Api Version Number
196: * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE
197: * @param p_commit to decide whether to commit the transaction or not, default value FND_API.G_FALSE
198: * @param p_validation_level validation level, default value FND_API.G_VALID_LEVEL_FULL
199: * @param p_default Defaulting , default value FND_API.G_TRUE
200: * @param p_module_type Module Type Value always NULL, For internal use
201: * @param p_mr_header_id Maintenance Requirement Header ID
202: * @param p_mr_title Maintenance Requirement Title
195: * @param p_api_version Api Version Number
196: * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE
197: * @param p_commit to decide whether to commit the transaction or not, default value FND_API.G_FALSE
198: * @param p_validation_level validation level, default value FND_API.G_VALID_LEVEL_FULL
199: * @param p_default Defaulting , default value FND_API.G_TRUE
200: * @param p_module_type Module Type Value always NULL, For internal use
201: * @param p_mr_header_id Maintenance Requirement Header ID
202: * @param p_mr_title Maintenance Requirement Title
203: * @param p_mr_version_number Maintenance Requirement Version Number
213: * @rep:displayname Process Unit Maintenance Plan Schedule
214: */
215: PROCEDURE Process_UnitEffectivity (
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_default IN VARCHAR2 := FND_API.G_TRUE,
221: p_module_type IN VARCHAR2 := NULL,
214: */
215: PROCEDURE Process_UnitEffectivity (
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_default IN VARCHAR2 := FND_API.G_TRUE,
221: p_module_type IN VARCHAR2 := NULL,
222: x_return_status OUT NOCOPY VARCHAR2,
215: PROCEDURE Process_UnitEffectivity (
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_default IN VARCHAR2 := FND_API.G_TRUE,
221: p_module_type IN VARCHAR2 := NULL,
222: x_return_status OUT NOCOPY VARCHAR2,
223: x_msg_count OUT NOCOPY NUMBER,
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_default IN VARCHAR2 := FND_API.G_TRUE,
221: p_module_type IN VARCHAR2 := NULL,
222: x_return_status OUT NOCOPY VARCHAR2,
223: x_msg_count OUT NOCOPY NUMBER,
224: x_msg_data OUT NOCOPY VARCHAR2,