27: -- Pre-reqs :
28: --
29: -- Standard IN Parameters :
30: -- p_api_version IN NUMBER Required
31: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
32: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
33: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
34: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
35: -- p_module_type IN VARCHAR2 Required, default NULL
28: --
29: -- Standard IN Parameters :
30: -- p_api_version IN NUMBER Required
31: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
32: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
33: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
34: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
35: -- p_module_type IN VARCHAR2 Required, default NULL
36:
29: -- Standard IN Parameters :
30: -- p_api_version IN NUMBER Required
31: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
32: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
33: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
34: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
35: -- p_module_type IN VARCHAR2 Required, default NULL
36:
37: -- Standard OUT Parameters :
30: -- p_api_version IN NUMBER Required
31: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
32: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
33: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
34: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
35: -- p_module_type IN VARCHAR2 Required, default NULL
36:
37: -- Standard OUT Parameters :
38: -- x_return_status OUT VARCHAR2 Required
55: /*#
56: * Use this procedure to create a Maintenance Requirement and optionally, create associations to Document References, Routes,
57: * Visit Types, Effectivities and Relationships to other Maintenance Requirements.
58: * @param p_api_version API Version Number.
59: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
60: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
61: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
62: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
63: * @param p_module_type For Internal use only, should always be NULL, default value NULL
56: * Use this procedure to create a Maintenance Requirement and optionally, create associations to Document References, Routes,
57: * Visit Types, Effectivities and Relationships to other Maintenance Requirements.
58: * @param p_api_version API Version Number.
59: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
60: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
61: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
62: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
63: * @param p_module_type For Internal use only, should always be NULL, default value NULL
64: * @param x_return_status API Return status. Standard API parameter
57: * Visit Types, Effectivities and Relationships to other Maintenance Requirements.
58: * @param p_api_version API Version Number.
59: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
60: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
61: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
62: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
63: * @param p_module_type For Internal use only, should always be NULL, default value NULL
64: * @param x_return_status API Return status. Standard API parameter
65: * @param x_msg_count API Return message count, if any. Standard API parameter
58: * @param p_api_version API Version Number.
59: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
60: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
61: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
62: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
63: * @param p_module_type For Internal use only, should always be NULL, default value NULL
64: * @param x_return_status API Return status. Standard API parameter
65: * @param x_msg_count API Return message count, if any. Standard API parameter
66: * @param x_msg_data API Return message data, if any. Standard API parameter
78: PROCEDURE Create_Mr
79: (
80: -- standard IN params
81: p_api_version IN NUMBER,
82: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
83: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
84: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
85: p_default IN VARCHAR2 :=FND_API.G_FALSE,
86: p_module_type IN VARCHAR2 :=NULL,
79: (
80: -- standard IN params
81: p_api_version IN NUMBER,
82: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
83: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
84: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
85: p_default IN VARCHAR2 :=FND_API.G_FALSE,
86: p_module_type IN VARCHAR2 :=NULL,
87: -- standard OUT params
80: -- standard IN params
81: p_api_version IN NUMBER,
82: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
83: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
84: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
85: p_default IN VARCHAR2 :=FND_API.G_FALSE,
86: p_module_type IN VARCHAR2 :=NULL,
87: -- standard OUT params
88: x_return_status OUT NOCOPY VARCHAR2,
81: p_api_version IN NUMBER,
82: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
83: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
84: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
85: p_default IN VARCHAR2 :=FND_API.G_FALSE,
86: p_module_type IN VARCHAR2 :=NULL,
87: -- standard OUT params
88: x_return_status OUT NOCOPY VARCHAR2,
89: x_msg_count OUT NOCOPY NUMBER,
105: PROCEDURE Create_Mr
106: (
107: -- standard IN params
108: p_api_version IN NUMBER,
109: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
110: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
111: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
112: p_default IN VARCHAR2 :=FND_API.G_FALSE,
113: p_module_type IN VARCHAR2 :=NULL,
106: (
107: -- standard IN params
108: p_api_version IN NUMBER,
109: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
110: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
111: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
112: p_default IN VARCHAR2 :=FND_API.G_FALSE,
113: p_module_type IN VARCHAR2 :=NULL,
114: -- standard OUT params
107: -- standard IN params
108: p_api_version IN NUMBER,
109: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
110: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
111: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
112: p_default IN VARCHAR2 :=FND_API.G_FALSE,
113: p_module_type IN VARCHAR2 :=NULL,
114: -- standard OUT params
115: x_return_status OUT NOCOPY VARCHAR2,
108: p_api_version IN NUMBER,
109: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
110: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
111: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
112: p_default IN VARCHAR2 :=FND_API.G_FALSE,
113: p_module_type IN VARCHAR2 :=NULL,
114: -- standard OUT params
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
133: -- Pre-reqs :
134: --
135: -- Standard IN Parameters :
136: -- p_api_version IN NUMBER Required
137: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
138: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
139: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
140: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
141: -- p_module_type IN VARCHAR2 Required, default NULL
134: --
135: -- Standard IN Parameters :
136: -- p_api_version IN NUMBER Required
137: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
138: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
139: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
140: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
141: -- p_module_type IN VARCHAR2 Required, default NULL
142:
135: -- Standard IN Parameters :
136: -- p_api_version IN NUMBER Required
137: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
138: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
139: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
140: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
141: -- p_module_type IN VARCHAR2 Required, default NULL
142:
143: -- Standard OUT Parameters :
136: -- p_api_version IN NUMBER Required
137: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
138: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
139: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
140: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
141: -- p_module_type IN VARCHAR2 Required, default NULL
142:
143: -- Standard OUT Parameters :
144: -- x_return_status OUT VARCHAR2 Required
161: /*#
162: * Use this procedure to modify a Maintenance Requirement and optionally, create, modify, delete associated Document References,
163: * Routes, Visit Types, Effectivities and Relationships to other Maintenance Requirements.
164: * @param p_api_version API Version Number.
165: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
166: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
167: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
168: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
169: * @param p_module_type For Internal use only, should always be NULL, default value NULL
162: * Use this procedure to modify a Maintenance Requirement and optionally, create, modify, delete associated Document References,
163: * Routes, Visit Types, Effectivities and Relationships to other Maintenance Requirements.
164: * @param p_api_version API Version Number.
165: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
166: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
167: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
168: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
169: * @param p_module_type For Internal use only, should always be NULL, default value NULL
170: * @param x_return_status API Return status. Standard API parameter
163: * Routes, Visit Types, Effectivities and Relationships to other Maintenance Requirements.
164: * @param p_api_version API Version Number.
165: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
166: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
167: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
168: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
169: * @param p_module_type For Internal use only, should always be NULL, default value NULL
170: * @param x_return_status API Return status. Standard API parameter
171: * @param x_msg_count API Return message count, if any. Standard API parameter
164: * @param p_api_version API Version Number.
165: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
166: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
167: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
168: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
169: * @param p_module_type For Internal use only, should always be NULL, default value NULL
170: * @param x_return_status API Return status. Standard API parameter
171: * @param x_msg_count API Return message count, if any. Standard API parameter
172: * @param x_msg_data API Return message data, if any. Standard API parameter
184: PROCEDURE Modify_Mr
185: (
186: -- standard IN params
187: p_api_version IN NUMBER,
188: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
189: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
190: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
191: p_default IN VARCHAR2 :=FND_API.G_FALSE,
192: p_module_type IN VARCHAR2 :=NULL,
185: (
186: -- standard IN params
187: p_api_version IN NUMBER,
188: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
189: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
190: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
191: p_default IN VARCHAR2 :=FND_API.G_FALSE,
192: p_module_type IN VARCHAR2 :=NULL,
193: -- standard OUT params
186: -- standard IN params
187: p_api_version IN NUMBER,
188: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
189: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
190: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
191: p_default IN VARCHAR2 :=FND_API.G_FALSE,
192: p_module_type IN VARCHAR2 :=NULL,
193: -- standard OUT params
194: x_return_status OUT NOCOPY VARCHAR2,
187: p_api_version IN NUMBER,
188: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
189: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
190: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
191: p_default IN VARCHAR2 :=FND_API.G_FALSE,
192: p_module_type IN VARCHAR2 :=NULL,
193: -- standard OUT params
194: x_return_status OUT NOCOPY VARCHAR2,
195: x_msg_count OUT NOCOPY NUMBER,
211: PROCEDURE Modify_Mr
212: (
213: -- standard IN params
214: p_api_version IN NUMBER,
215: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
216: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
217: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
218: p_default IN VARCHAR2 :=FND_API.G_FALSE,
219: p_module_type IN VARCHAR2 :=NULL,
212: (
213: -- standard IN params
214: p_api_version IN NUMBER,
215: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
216: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
217: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
218: p_default IN VARCHAR2 :=FND_API.G_FALSE,
219: p_module_type IN VARCHAR2 :=NULL,
220: -- standard OUT params
213: -- standard IN params
214: p_api_version IN NUMBER,
215: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
216: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
217: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
218: p_default IN VARCHAR2 :=FND_API.G_FALSE,
219: p_module_type IN VARCHAR2 :=NULL,
220: -- standard OUT params
221: x_return_status OUT NOCOPY VARCHAR2,
214: p_api_version IN NUMBER,
215: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
216: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
217: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
218: p_default IN VARCHAR2 :=FND_API.G_FALSE,
219: p_module_type IN VARCHAR2 :=NULL,
220: -- standard OUT params
221: x_return_status OUT NOCOPY VARCHAR2,
222: x_msg_count OUT NOCOPY NUMBER,
239: -- Pre-reqs :
240: --
241: -- Standard IN Parameters :
242: -- p_api_version IN NUMBER Required
243: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
244: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
245: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
246: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
247: -- p_module_type IN VARCHAR2 Required, default NULL
240: --
241: -- Standard IN Parameters :
242: -- p_api_version IN NUMBER Required
243: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
244: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
245: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
246: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
247: -- p_module_type IN VARCHAR2 Required, default NULL
248:
241: -- Standard IN Parameters :
242: -- p_api_version IN NUMBER Required
243: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
244: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
245: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
246: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
247: -- p_module_type IN VARCHAR2 Required, default NULL
248:
249: -- Standard OUT Parameters :
242: -- p_api_version IN NUMBER Required
243: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
244: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
245: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
246: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
247: -- p_module_type IN VARCHAR2 Required, default NULL
248:
249: -- Standard OUT Parameters :
250: -- x_return_status OUT VARCHAR2 Required
264: /*#
265: * Use this procedure to delete Maintenance Requirement. All associations to Documents, Routes, Visit Types, Effectivities and
266: * relationships with other Maintenance Requirements are also deleted.
267: * @param p_api_version API Version Number.
268: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
269: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
270: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
271: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
272: * @param p_module_type For Internal use only, should always be NULL, default value NULL
265: * Use this procedure to delete Maintenance Requirement. All associations to Documents, Routes, Visit Types, Effectivities and
266: * relationships with other Maintenance Requirements are also deleted.
267: * @param p_api_version API Version Number.
268: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
269: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
270: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
271: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
272: * @param p_module_type For Internal use only, should always be NULL, default value NULL
273: * @param x_return_status API Return status. Standard API parameter
266: * relationships with other Maintenance Requirements are also deleted.
267: * @param p_api_version API Version Number.
268: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
269: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
270: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
271: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
272: * @param p_module_type For Internal use only, should always be NULL, default value NULL
273: * @param x_return_status API Return status. Standard API parameter
274: * @param x_msg_count API Return message count, if any. Standard API parameter
267: * @param p_api_version API Version Number.
268: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
269: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
270: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
271: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
272: * @param p_module_type For Internal use only, should always be NULL, default value NULL
273: * @param x_return_status API Return status. Standard API parameter
274: * @param x_msg_count API Return message count, if any. Standard API parameter
275: * @param x_msg_data API Return message data, if any. Standard API parameter
284: PROCEDURE Delete_Mr
285: (
286: -- standard IN params
287: p_api_version IN NUMBER,
288: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
289: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
290: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
291: p_default IN VARCHAR2 :=FND_API.G_FALSE,
292: p_module_type IN VARCHAR2 :=NULL,
285: (
286: -- standard IN params
287: p_api_version IN NUMBER,
288: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
289: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
290: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
291: p_default IN VARCHAR2 :=FND_API.G_FALSE,
292: p_module_type IN VARCHAR2 :=NULL,
293: -- standard OUT params
286: -- standard IN params
287: p_api_version IN NUMBER,
288: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
289: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
290: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
291: p_default IN VARCHAR2 :=FND_API.G_FALSE,
292: p_module_type IN VARCHAR2 :=NULL,
293: -- standard OUT params
294: x_return_status OUT NOCOPY VARCHAR2,
287: p_api_version IN NUMBER,
288: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
289: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
290: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
291: p_default IN VARCHAR2 :=FND_API.G_FALSE,
292: p_module_type IN VARCHAR2 :=NULL,
293: -- standard OUT params
294: x_return_status OUT NOCOPY VARCHAR2,
295: x_msg_count OUT NOCOPY NUMBER,
309: -- Pre-reqs :
310: --
311: -- Standard IN Parameters :
312: -- p_api_version IN NUMBER Required
313: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
314: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
315: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
316: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
317: -- p_module_type IN VARCHAR2 Required, default NULL
310: --
311: -- Standard IN Parameters :
312: -- p_api_version IN NUMBER Required
313: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
314: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
315: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
316: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
317: -- p_module_type IN VARCHAR2 Required, default NULL
318:
311: -- Standard IN Parameters :
312: -- p_api_version IN NUMBER Required
313: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
314: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
315: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
316: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
317: -- p_module_type IN VARCHAR2 Required, default NULL
318:
319: -- Standard OUT Parameters :
312: -- p_api_version IN NUMBER Required
313: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
314: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
315: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
316: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
317: -- p_module_type IN VARCHAR2 Required, default NULL
318:
319: -- Standard OUT Parameters :
320: -- x_return_status OUT VARCHAR2 Required
334: -- End of Comments --
335: /*#
336: * Use this procedure to create a new revision of an existing and completed Maintenance Requirement.
337: * @param p_api_version API Version Number.
338: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
339: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
340: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
341: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
342: * @param p_module_type For Internal use only, should always be NULL, default value NULL
335: /*#
336: * Use this procedure to create a new revision of an existing and completed Maintenance Requirement.
337: * @param p_api_version API Version Number.
338: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
339: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
340: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
341: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
342: * @param p_module_type For Internal use only, should always be NULL, default value NULL
343: * @param x_return_status API Return status. Standard API parameter
336: * Use this procedure to create a new revision of an existing and completed Maintenance Requirement.
337: * @param p_api_version API Version Number.
338: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
339: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
340: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
341: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
342: * @param p_module_type For Internal use only, should always be NULL, default value NULL
343: * @param x_return_status API Return status. Standard API parameter
344: * @param x_msg_count API Return message count, if any. Standard API parameter
337: * @param p_api_version API Version Number.
338: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
339: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
340: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
341: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
342: * @param p_module_type For Internal use only, should always be NULL, default value NULL
343: * @param x_return_status API Return status. Standard API parameter
344: * @param x_msg_count API Return message count, if any. Standard API parameter
345: * @param x_msg_data API Return message data, if any. Standard API parameter
355: PROCEDURE Create_Mr_Revision
356: (
357: -- standard IN params
358: p_api_version IN NUMBER,
359: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
360: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
361: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
362: p_default IN VARCHAR2 :=FND_API.G_FALSE,
363: p_module_type IN VARCHAR2 :=NULL,
356: (
357: -- standard IN params
358: p_api_version IN NUMBER,
359: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
360: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
361: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
362: p_default IN VARCHAR2 :=FND_API.G_FALSE,
363: p_module_type IN VARCHAR2 :=NULL,
364: -- standard OUT params
357: -- standard IN params
358: p_api_version IN NUMBER,
359: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
360: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
361: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
362: p_default IN VARCHAR2 :=FND_API.G_FALSE,
363: p_module_type IN VARCHAR2 :=NULL,
364: -- standard OUT params
365: x_return_status OUT NOCOPY VARCHAR2,
358: p_api_version IN NUMBER,
359: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
360: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
361: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
362: p_default IN VARCHAR2 :=FND_API.G_FALSE,
363: p_module_type IN VARCHAR2 :=NULL,
364: -- standard OUT params
365: x_return_status OUT NOCOPY VARCHAR2,
366: x_msg_count OUT NOCOPY NUMBER,
381: -- Pre-reqs :
382: --
383: -- Standard IN Parameters :
384: -- p_api_version IN NUMBER Required
385: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
386: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
387: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
388: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
389: -- p_module_type IN VARCHAR2 Required, default NULL
382: --
383: -- Standard IN Parameters :
384: -- p_api_version IN NUMBER Required
385: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
386: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
387: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
388: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
389: -- p_module_type IN VARCHAR2 Required, default NULL
390:
383: -- Standard IN Parameters :
384: -- p_api_version IN NUMBER Required
385: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
386: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
387: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
388: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
389: -- p_module_type IN VARCHAR2 Required, default NULL
390:
391: -- Standard OUT Parameters :
384: -- p_api_version IN NUMBER Required
385: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
386: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
387: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
388: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
389: -- p_module_type IN VARCHAR2 Required, default NULL
390:
391: -- Standard OUT Parameters :
392: -- x_return_status OUT VARCHAR2 Required
406: -- End of Comments --
407: /*#
408: * Use this procedure to submit a Maintenance Requirement for Completion or Termination approval workflows.
409: * @param p_api_version API Version Number.
410: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
411: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
412: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
413: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
414: * @param p_module_type For Internal use only, should always be NULL, default value NULL
407: /*#
408: * Use this procedure to submit a Maintenance Requirement for Completion or Termination approval workflows.
409: * @param p_api_version API Version Number.
410: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
411: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
412: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
413: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
414: * @param p_module_type For Internal use only, should always be NULL, default value NULL
415: * @param x_return_status API Return status. Standard API parameter
408: * Use this procedure to submit a Maintenance Requirement for Completion or Termination approval workflows.
409: * @param p_api_version API Version Number.
410: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
411: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
412: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
413: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
414: * @param p_module_type For Internal use only, should always be NULL, default value NULL
415: * @param x_return_status API Return status. Standard API parameter
416: * @param x_msg_count API Return message count, if any. Standard API parameter
409: * @param p_api_version API Version Number.
410: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
411: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
412: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
413: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
414: * @param p_module_type For Internal use only, should always be NULL, default value NULL
415: * @param x_return_status API Return status. Standard API parameter
416: * @param x_msg_count API Return message count, if any. Standard API parameter
417: * @param x_msg_data API Return message data, if any. Standard API parameter
427: PROCEDURE Initiate_Mr_Approval
428: (
429: -- standard IN params
430: p_api_version IN NUMBER,
431: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
432: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
433: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
434: p_default IN VARCHAR2 :=FND_API.G_FALSE,
435: p_module_type IN VARCHAR2 :=NULL,
428: (
429: -- standard IN params
430: p_api_version IN NUMBER,
431: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
432: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
433: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
434: p_default IN VARCHAR2 :=FND_API.G_FALSE,
435: p_module_type IN VARCHAR2 :=NULL,
436: -- standard OUT params
429: -- standard IN params
430: p_api_version IN NUMBER,
431: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
432: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
433: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
434: p_default IN VARCHAR2 :=FND_API.G_FALSE,
435: p_module_type IN VARCHAR2 :=NULL,
436: -- standard OUT params
437: x_return_status OUT NOCOPY VARCHAR2,
430: p_api_version IN NUMBER,
431: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
432: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
433: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
434: p_default IN VARCHAR2 :=FND_API.G_FALSE,
435: p_module_type IN VARCHAR2 :=NULL,
436: -- standard OUT params
437: x_return_status OUT NOCOPY VARCHAR2,
438: x_msg_count OUT NOCOPY NUMBER,
453: -- Pre-reqs :
454: --
455: -- Standard IN Parameters :
456: -- p_api_version IN NUMBER Required
457: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
458: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
459: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
460: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
461: -- p_module_type IN VARCHAR2 Required, default NULL
454: --
455: -- Standard IN Parameters :
456: -- p_api_version IN NUMBER Required
457: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
458: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
459: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
460: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
461: -- p_module_type IN VARCHAR2 Required, default NULL
462:
455: -- Standard IN Parameters :
456: -- p_api_version IN NUMBER Required
457: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
458: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
459: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
460: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
461: -- p_module_type IN VARCHAR2 Required, default NULL
462:
463: -- Standard OUT Parameters :
456: -- p_api_version IN NUMBER Required
457: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
458: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
459: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
460: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
461: -- p_module_type IN VARCHAR2 Required, default NULL
462:
463: -- Standard OUT Parameters :
464: -- x_return_status OUT VARCHAR2 Required
474: -- End of Comments --
475: /*#
476: * Use this procedure to create, modify and delete dependencies within the Maintenance Requirement Routes.
477: * @param p_api_version API Version Number.
478: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
479: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
480: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
481: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
482: * @param p_module_type For Internal use only, should always be NULL, default value NULL
475: /*#
476: * Use this procedure to create, modify and delete dependencies within the Maintenance Requirement Routes.
477: * @param p_api_version API Version Number.
478: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
479: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
480: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
481: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
482: * @param p_module_type For Internal use only, should always be NULL, default value NULL
483: * @param x_return_status API Return status. Standard API parameter
476: * Use this procedure to create, modify and delete dependencies within the Maintenance Requirement Routes.
477: * @param p_api_version API Version Number.
478: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
479: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
480: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
481: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
482: * @param p_module_type For Internal use only, should always be NULL, default value NULL
483: * @param x_return_status API Return status. Standard API parameter
484: * @param x_msg_count API Return message count, if any. Standard API parameter
477: * @param p_api_version API Version Number.
478: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
479: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
480: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
481: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
482: * @param p_module_type For Internal use only, should always be NULL, default value NULL
483: * @param x_return_status API Return status. Standard API parameter
484: * @param x_msg_count API Return message count, if any. Standard API parameter
485: * @param x_msg_data API Return message data, if any. Standard API parameter
491: PROCEDURE Process_Mr_Route_Seq
492: (
493: -- standard IN params
494: p_api_version IN NUMBER,
495: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
496: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
497: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
498: p_default IN VARCHAR2 :=FND_API.G_FALSE,
499: p_module_type IN VARCHAR2 :=NULL,
492: (
493: -- standard IN params
494: p_api_version IN NUMBER,
495: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
496: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
497: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
498: p_default IN VARCHAR2 :=FND_API.G_FALSE,
499: p_module_type IN VARCHAR2 :=NULL,
500: -- standard OUT params
493: -- standard IN params
494: p_api_version IN NUMBER,
495: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
496: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
497: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
498: p_default IN VARCHAR2 :=FND_API.G_FALSE,
499: p_module_type IN VARCHAR2 :=NULL,
500: -- standard OUT params
501: x_return_status OUT NOCOPY VARCHAR2,
494: p_api_version IN NUMBER,
495: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
496: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
497: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
498: p_default IN VARCHAR2 :=FND_API.G_FALSE,
499: p_module_type IN VARCHAR2 :=NULL,
500: -- standard OUT params
501: x_return_status OUT NOCOPY VARCHAR2,
502: x_msg_count OUT NOCOPY NUMBER,
514: -- Pre-reqs :
515: --
516: -- Standard IN Parameters :
517: -- p_api_version IN NUMBER Required
518: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
519: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
520: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
521: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
522: -- p_module_type IN VARCHAR2 Required, default NULL
515: --
516: -- Standard IN Parameters :
517: -- p_api_version IN NUMBER Required
518: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
519: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
520: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
521: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
522: -- p_module_type IN VARCHAR2 Required, default NULL
523:
516: -- Standard IN Parameters :
517: -- p_api_version IN NUMBER Required
518: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
519: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
520: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
521: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
522: -- p_module_type IN VARCHAR2 Required, default NULL
523:
524: -- Standard OUT Parameters :
517: -- p_api_version IN NUMBER Required
518: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
519: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
520: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
521: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
522: -- p_module_type IN VARCHAR2 Required, default NULL
523:
524: -- Standard OUT Parameters :
525: -- x_return_status OUT VARCHAR2 Required
543: /*#
544: * Use this procedure to create, modify and delete Effectivity Details and Interval thresholds for a Maintenance
545: * Requirement Effectivity.
546: * @param p_api_version API Version Number.
547: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
548: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
549: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
550: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
551: * @param p_module_type For Internal use only, should always be NULL, default value NULL
544: * Use this procedure to create, modify and delete Effectivity Details and Interval thresholds for a Maintenance
545: * Requirement Effectivity.
546: * @param p_api_version API Version Number.
547: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
548: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
549: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
550: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
551: * @param p_module_type For Internal use only, should always be NULL, default value NULL
552: * @param x_return_status API Return status. Standard API parameter
545: * Requirement Effectivity.
546: * @param p_api_version API Version Number.
547: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
548: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
549: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
550: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
551: * @param p_module_type For Internal use only, should always be NULL, default value NULL
552: * @param x_return_status API Return status. Standard API parameter
553: * @param x_msg_count API Return message count, if any. Standard API parameter
546: * @param p_api_version API Version Number.
547: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
548: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
549: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
550: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
551: * @param p_module_type For Internal use only, should always be NULL, default value NULL
552: * @param x_return_status API Return status. Standard API parameter
553: * @param x_msg_count API Return message count, if any. Standard API parameter
554: * @param x_msg_data API Return message data, if any. Standard API parameter
569: PROCEDURE Process_Mr_Effectivities
570: (
571: -- standard IN params
572: p_api_version IN NUMBER,
573: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
574: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
575: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
576: p_default IN VARCHAR2 :=FND_API.G_FALSE,
577: p_module_type IN VARCHAR2 :=NULL,
570: (
571: -- standard IN params
572: p_api_version IN NUMBER,
573: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
574: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
575: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
576: p_default IN VARCHAR2 :=FND_API.G_FALSE,
577: p_module_type IN VARCHAR2 :=NULL,
578: -- standard OUT params
571: -- standard IN params
572: p_api_version IN NUMBER,
573: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
574: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
575: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
576: p_default IN VARCHAR2 :=FND_API.G_FALSE,
577: p_module_type IN VARCHAR2 :=NULL,
578: -- standard OUT params
579: x_return_status OUT NOCOPY VARCHAR2,
572: p_api_version IN NUMBER,
573: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
574: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
575: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
576: p_default IN VARCHAR2 :=FND_API.G_FALSE,
577: p_module_type IN VARCHAR2 :=NULL,
578: -- standard OUT params
579: x_return_status OUT NOCOPY VARCHAR2,
580: x_msg_count OUT NOCOPY NUMBER,