104: -- Type : Private
105: -- Description : This procedure creates, updates and deletes Ata Sequences attached with MELs/CDLs.
106: -- Pre-reqs :
107: --
108: -- Standard IN Parameters :
109: -- p_api_version NUMBER Required
110: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
111: -- p_commit VARCHAR2 := FND_API.G_FALSE
112: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
112: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
113: -- p_default VARCHAR2 := FND_API.G_FALSE
114: -- p_module_type VARCHAR2 := NULL
115: --
116: -- Standard OUT Parameters :
117: -- x_return_status VARCHAR2 Required
118: -- x_msg_count NUMBER Required
119: -- x_msg_data VARCHAR2 Required
120: --
126: --
127: -- End of Comments --
128: PROCEDURE Process_Ata_Sequences
129: (
130: -- Standard IN params
131: p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
133: p_commit IN VARCHAR2 := FND_API.G_FALSE,
134: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
133: p_commit IN VARCHAR2 := FND_API.G_FALSE,
134: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
135: p_default IN VARCHAR2 := FND_API.G_FALSE,
136: p_module_type IN VARCHAR2 := NULL,
137: -- Standard OUT params
138: x_return_status OUT NOCOPY VARCHAR2,
139: x_msg_count OUT NOCOPY NUMBER,
140: x_msg_data OUT NOCOPY VARCHAR2,
141: -- Procedure IN, OUT, IN/OUT params
148: -- Type : Private
149: -- Description : This procedure creates and deletes association of M&O procedures with Ata Sequence.
150: -- Pre-reqs :
151: --
152: -- Standard IN Parameters :
153: -- p_api_version NUMBER Required
154: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
155: -- p_commit VARCHAR2 := FND_API.G_FALSE
156: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
156: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
157: -- p_default VARCHAR2 := FND_API.G_FALSE
158: -- p_module_type VARCHAR2 := NULL
159: --
160: -- Standard OUT Parameters :
161: -- x_return_status VARCHAR2 Required
162: -- x_msg_count NUMBER Required
163: -- x_msg_data VARCHAR2 Required
164: --
170: --
171: -- End of Comments --
172: PROCEDURE Process_Mo_Procedures
173: (
174: -- Standard IN params
175: p_api_version IN NUMBER,
176: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
177: p_commit IN VARCHAR2 := FND_API.G_TRUE,
178: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
177: p_commit IN VARCHAR2 := FND_API.G_TRUE,
178: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
179: p_default IN VARCHAR2 := FND_API.G_FALSE,
180: p_module_type IN VARCHAR2 := NULL,
181: -- Standard OUT params
182: x_return_status OUT NOCOPY VARCHAR2,
183: x_msg_count OUT NOCOPY NUMBER,
184: x_msg_data OUT NOCOPY VARCHAR2,
185: -- Procedure IN, OUT, IN/OUT params
192: -- Type : Private
193: -- Description : This procedures creates and deletes association of Ata Sequences from other MELs/CDLs with Ata Sequence.
194: -- Pre-reqs :
195: --
196: -- Standard IN Parameters :
197: -- p_api_version NUMBER Required
198: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
199: -- p_commit VARCHAR2 := FND_API.G_FALSE
200: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
200: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
201: -- p_default VARCHAR2 := FND_API.G_FALSE
202: -- p_module_type VARCHAR2 := NULL
203: --
204: -- Standard OUT Parameters :
205: -- x_return_status VARCHAR2 Required
206: -- x_msg_count NUMBER Required
207: -- x_msg_data VARCHAR2 Required
208: --
214: --
215: -- End of Comments --
216: PROCEDURE Process_Ata_Relations
217: (
218: -- Standard IN params
219: p_api_version IN NUMBER,
220: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
221: p_commit IN VARCHAR2 := FND_API.G_TRUE,
222: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
221: p_commit IN VARCHAR2 := FND_API.G_TRUE,
222: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
223: p_default IN VARCHAR2 := FND_API.G_FALSE,
224: p_module_type IN VARCHAR2 := NULL,
225: -- Standard OUT params
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,
228: x_msg_data OUT NOCOPY VARCHAR2,
229: -- Procedure IN, OUT, IN/OUT params
235: -- Type : Private
236: -- Description : This procedures copies new revision of M & O Procedures to the ATA Sequences to which the old revision is also associated
237: -- Pre-reqs :
238: --
239: -- Standard IN Parameters :
240: -- p_api_version NUMBER Required
241: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
242: -- p_commit VARCHAR2 := FND_API.G_FALSE
243: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
243: -- p_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL
244: -- p_default VARCHAR2 := FND_API.G_FALSE
245: -- p_module_type VARCHAR2 := NULL
246: --
247: -- Standard OUT Parameters :
248: -- x_return_status VARCHAR2 Required
249: -- x_msg_count NUMBER Required
250: -- x_msg_data VARCHAR2 Required
251: --
258: --
259: -- End of Comments --
260: PROCEDURE Copy_MO_Proc_Revision
261: (
262: -- Standard IN params
263: p_api_version IN NUMBER,
264: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
265: p_commit IN VARCHAR2 := FND_API.G_TRUE,
266: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
265: p_commit IN VARCHAR2 := FND_API.G_TRUE,
266: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
267: p_default IN VARCHAR2 := FND_API.G_FALSE,
268: p_module_type IN VARCHAR2 := NULL,
269: -- Standard OUT params
270: x_return_status OUT NOCOPY VARCHAR2,
271: x_msg_count OUT NOCOPY NUMBER,
272: x_msg_data OUT NOCOPY VARCHAR2,
273: -- Procedure IN, OUT, IN/OUT params