83: -- Pre-reqs :
84: -- Parameters :
85: -- Standard IN Parameters :
86: -- p_api_version IN NUMBER Required
87: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
88: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
89: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
90: --
91: -- Standard OUT Parameters :
84: -- Parameters :
85: -- Standard IN Parameters :
86: -- p_api_version IN NUMBER Required
87: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
88: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
89: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
90: --
91: -- Standard OUT Parameters :
92: -- x_return_status OUT VARCHAR2 Required
85: -- Standard IN Parameters :
86: -- p_api_version IN NUMBER Required
87: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
88: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
89: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
90: --
91: -- Standard OUT Parameters :
92: -- x_return_status OUT VARCHAR2 Required
93: -- x_msg_count OUT NUMBER Required
110:
111:
112: PROCEDURE Create_Item_Composition(
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
115: p_commit IN VARCHAR2 := FND_API.G_FALSE,
116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117: x_return_status OUT NOCOPY VARCHAR2,
118: x_msg_count OUT NOCOPY NUMBER,
111:
112: PROCEDURE Create_Item_Composition(
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
115: p_commit IN VARCHAR2 := FND_API.G_FALSE,
116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117: x_return_status OUT NOCOPY VARCHAR2,
118: x_msg_count OUT NOCOPY NUMBER,
119: x_msg_data OUT NOCOPY VARCHAR2,
112: PROCEDURE Create_Item_Composition(
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
115: p_commit IN VARCHAR2 := FND_API.G_FALSE,
116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117: x_return_status OUT NOCOPY VARCHAR2,
118: x_msg_count OUT NOCOPY NUMBER,
119: x_msg_data OUT NOCOPY VARCHAR2,
120: p_x_ic_header_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Header_Rec_Type,
133: -- Pre-reqs :
134: -- Parameters :
135: -- Standard IN Parameters :
136: -- p_api_version IN NUMBER Required
137: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
138: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
139: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
140: --
141: -- Standard OUT Parameters :
134: -- Parameters :
135: -- Standard IN Parameters :
136: -- p_api_version IN NUMBER Required
137: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
138: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
139: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
140: --
141: -- Standard OUT Parameters :
142: -- x_return_status OUT VARCHAR2 Required
135: -- Standard IN Parameters :
136: -- p_api_version IN NUMBER Required
137: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
138: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
139: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
140: --
141: -- Standard OUT Parameters :
142: -- x_return_status OUT VARCHAR2 Required
143: -- x_msg_count OUT NUMBER Required
159: -- End of Comments --
160:
161: PROCEDURE Modify_Item_Composition(
162: p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
164: p_commit IN VARCHAR2 := FND_API.G_FALSE,
165: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
166: x_return_status OUT NOCOPY VARCHAR2,
167: x_msg_count OUT NOCOPY NUMBER,
160:
161: PROCEDURE Modify_Item_Composition(
162: p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
164: p_commit IN VARCHAR2 := FND_API.G_FALSE,
165: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
166: x_return_status OUT NOCOPY VARCHAR2,
167: x_msg_count OUT NOCOPY NUMBER,
168: x_msg_data OUT NOCOPY VARCHAR2,
161: PROCEDURE Modify_Item_Composition(
162: p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
164: p_commit IN VARCHAR2 := FND_API.G_FALSE,
165: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
166: x_return_status OUT NOCOPY VARCHAR2,
167: x_msg_count OUT NOCOPY NUMBER,
168: x_msg_data OUT NOCOPY VARCHAR2,
169: p_x_ic_header_rec IN OUT NOCOPY AHL_MC_ITEM_COMP_PVT.Header_Rec_Type,
182: -- Pre-reqs :
183: -- Parameters :
184: -- Standard IN Parameters :
185: -- p_api_version IN NUMBER Required
186: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
187: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
188: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
189: --
190: -- Standard OUT Parameters :
183: -- Parameters :
184: -- Standard IN Parameters :
185: -- p_api_version IN NUMBER Required
186: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
187: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
188: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
189: --
190: -- Standard OUT Parameters :
191: -- x_return_status OUT VARCHAR2 Required
184: -- Standard IN Parameters :
185: -- p_api_version IN NUMBER Required
186: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
187: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
188: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
189: --
190: -- Standard OUT Parameters :
191: -- x_return_status OUT VARCHAR2 Required
192: -- x_msg_count OUT NUMBER Required
197: -- End of Comments --
198:
199: PROCEDURE Delete_Item_Composition (
200: p_api_version IN NUMBER,
201: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
202: p_commit IN VARCHAR2 := FND_API.G_FALSE,
203: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
204: x_return_status OUT NOCOPY VARCHAR2,
205: x_msg_count OUT NOCOPY NUMBER,
198:
199: PROCEDURE Delete_Item_Composition (
200: p_api_version IN NUMBER,
201: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
202: p_commit IN VARCHAR2 := FND_API.G_FALSE,
203: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
204: x_return_status OUT NOCOPY VARCHAR2,
205: x_msg_count OUT NOCOPY NUMBER,
206: x_msg_data OUT NOCOPY VARCHAR2,
199: PROCEDURE Delete_Item_Composition (
200: p_api_version IN NUMBER,
201: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
202: p_commit IN VARCHAR2 := FND_API.G_FALSE,
203: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
204: x_return_status OUT NOCOPY VARCHAR2,
205: x_msg_count OUT NOCOPY NUMBER,
206: x_msg_data OUT NOCOPY VARCHAR2,
207: p_item_composition_ID IN NUMBER ,
221: -- Pre-reqs :
222: -- Parameters :
223: -- Standard IN Parameters :
224: -- p_api_version IN NUMBER Required
225: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
226: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
227: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
228: --
229: -- Standard OUT Parameters :
222: -- Parameters :
223: -- Standard IN Parameters :
224: -- p_api_version IN NUMBER Required
225: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
226: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
227: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
228: --
229: -- Standard OUT Parameters :
230: -- x_return_status OUT VARCHAR2 Required
223: -- Standard IN Parameters :
224: -- p_api_version IN NUMBER Required
225: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
226: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
227: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
228: --
229: -- Standard OUT Parameters :
230: -- x_return_status OUT VARCHAR2 Required
231: -- x_msg_count OUT NUMBER Required
237:
238:
239: PROCEDURE Reopen_Item_Composition (
240: p_api_version IN NUMBER,
241: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
242: p_commit IN VARCHAR2 := FND_API.G_FALSE,
243: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
244: x_return_status OUT NOCOPY VARCHAR2,
245: x_msg_count OUT NOCOPY NUMBER,
238:
239: PROCEDURE Reopen_Item_Composition (
240: p_api_version IN NUMBER,
241: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
242: p_commit IN VARCHAR2 := FND_API.G_FALSE,
243: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
244: x_return_status OUT NOCOPY VARCHAR2,
245: x_msg_count OUT NOCOPY NUMBER,
246: x_msg_data OUT NOCOPY VARCHAR2,
239: PROCEDURE Reopen_Item_Composition (
240: p_api_version IN NUMBER,
241: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
242: p_commit IN VARCHAR2 := FND_API.G_FALSE,
243: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
244: x_return_status OUT NOCOPY VARCHAR2,
245: x_msg_count OUT NOCOPY NUMBER,
246: x_msg_data OUT NOCOPY VARCHAR2,
247: p_item_composition_ID IN NUMBER ,
260: -- Pre-reqs :
261: -- Parameters :
262: -- Standard IN Parameters :
263: -- p_api_version IN NUMBER Required
264: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
265: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
266: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
267: --
268: -- Standard OUT Parameters :
261: -- Parameters :
262: -- Standard IN Parameters :
263: -- p_api_version IN NUMBER Required
264: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
265: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
266: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
267: --
268: -- Standard OUT Parameters :
269: -- x_return_status OUT VARCHAR2 Required
262: -- Standard IN Parameters :
263: -- p_api_version IN NUMBER Required
264: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
265: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
266: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
267: --
268: -- Standard OUT Parameters :
269: -- x_return_status OUT VARCHAR2 Required
270: -- x_msg_count OUT NUMBER Required
279:
280:
281: PROCEDURE Create_Item_Comp_Revision (
282: p_api_version IN NUMBER,
283: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
284: p_commit IN VARCHAR2 := FND_API.G_FALSE,
285: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
286: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
287: P_MODULE_TYPE IN VARCHAR2,
280:
281: PROCEDURE Create_Item_Comp_Revision (
282: p_api_version IN NUMBER,
283: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
284: p_commit IN VARCHAR2 := FND_API.G_FALSE,
285: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
286: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
287: P_MODULE_TYPE IN VARCHAR2,
288: x_return_status OUT NOCOPY VARCHAR2,
281: PROCEDURE Create_Item_Comp_Revision (
282: p_api_version IN NUMBER,
283: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
284: p_commit IN VARCHAR2 := FND_API.G_FALSE,
285: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
286: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
287: P_MODULE_TYPE IN VARCHAR2,
288: x_return_status OUT NOCOPY VARCHAR2,
289: x_msg_count OUT NOCOPY NUMBER,
282: p_api_version IN NUMBER,
283: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
284: p_commit IN VARCHAR2 := FND_API.G_FALSE,
285: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
286: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
287: P_MODULE_TYPE IN VARCHAR2,
288: x_return_status OUT NOCOPY VARCHAR2,
289: x_msg_count OUT NOCOPY NUMBER,
290: x_msg_data OUT NOCOPY VARCHAR2,
303: -- Pre-reqs :
304: -- Parameters :
305: -- Standard IN Parameters :
306: -- p_api_version IN NUMBER Required
307: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
308: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
309: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
310: --
311: -- Standard OUT Parameters :
304: -- Parameters :
305: -- Standard IN Parameters :
306: -- p_api_version IN NUMBER Required
307: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
308: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
309: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
310: --
311: -- Standard OUT Parameters :
312: -- x_return_status OUT VARCHAR2 Required
305: -- Standard IN Parameters :
306: -- p_api_version IN NUMBER Required
307: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
308: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
309: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
310: --
311: -- Standard OUT Parameters :
312: -- x_return_status OUT VARCHAR2 Required
313: -- x_msg_count OUT NUMBER Required
321:
322:
323: PROCEDURE Initiate_Item_Comp_Approval (
324: p_api_version IN NUMBER,
325: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
326: p_commit IN VARCHAR2 := FND_API.G_FALSE,
327: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
328: x_return_status OUT NOCOPY VARCHAR2,
329: x_msg_count OUT NOCOPY NUMBER,
322:
323: PROCEDURE Initiate_Item_Comp_Approval (
324: p_api_version IN NUMBER,
325: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
326: p_commit IN VARCHAR2 := FND_API.G_FALSE,
327: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
328: x_return_status OUT NOCOPY VARCHAR2,
329: x_msg_count OUT NOCOPY NUMBER,
330: x_msg_data OUT NOCOPY VARCHAR2,
323: PROCEDURE Initiate_Item_Comp_Approval (
324: p_api_version IN NUMBER,
325: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
326: p_commit IN VARCHAR2 := FND_API.G_FALSE,
327: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
328: x_return_status OUT NOCOPY VARCHAR2,
329: x_msg_count OUT NOCOPY NUMBER,
330: x_msg_data OUT NOCOPY VARCHAR2,
331: p_Item_Composition_id IN NUMBER,
344: -- Pre-reqs :
345: -- Parameters :
346: -- Standard IN Parameters :
347: -- p_api_version IN NUMBER Required
348: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
349: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
350: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
351: --
352: -- Standard OUT Parameters :
345: -- Parameters :
346: -- Standard IN Parameters :
347: -- p_api_version IN NUMBER Required
348: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
349: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
350: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
351: --
352: -- Standard OUT Parameters :
353: -- x_return_status OUT VARCHAR2 Required
346: -- Standard IN Parameters :
347: -- p_api_version IN NUMBER Required
348: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
349: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
350: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
351: --
352: -- Standard OUT Parameters :
353: -- x_return_status OUT VARCHAR2 Required
354: -- x_msg_count OUT NUMBER Required
361:
362:
363: PROCEDURE Approve_Item_Composiiton (
364: p_api_version IN NUMBER,
365: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
366: p_commit IN VARCHAR2 := FND_API.G_FALSE,
367: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
368: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
369: P_MODULE_TYPE IN VARCHAR2,
362:
363: PROCEDURE Approve_Item_Composiiton (
364: p_api_version IN NUMBER,
365: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
366: p_commit IN VARCHAR2 := FND_API.G_FALSE,
367: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
368: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
369: P_MODULE_TYPE IN VARCHAR2,
370: x_return_status OUT NOCOPY VARCHAR2,
363: PROCEDURE Approve_Item_Composiiton (
364: p_api_version IN NUMBER,
365: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
366: p_commit IN VARCHAR2 := FND_API.G_FALSE,
367: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
368: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
369: P_MODULE_TYPE IN VARCHAR2,
370: x_return_status OUT NOCOPY VARCHAR2,
371: x_msg_count OUT NOCOPY NUMBER,
364: p_api_version IN NUMBER,
365: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
366: p_commit IN VARCHAR2 := FND_API.G_FALSE,
367: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
368: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
369: P_MODULE_TYPE IN VARCHAR2,
370: x_return_status OUT NOCOPY VARCHAR2,
371: x_msg_count OUT NOCOPY NUMBER,
372: x_msg_data OUT NOCOPY VARCHAR2,