94: -- Pre-reqs :
95: -- Parameters :
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: --
102: -- Standard OUT Parameters :
95: -- Parameters :
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: --
102: -- Standard OUT Parameters :
103: -- x_return_status OUT VARCHAR2 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: --
102: -- Standard OUT Parameters :
103: -- x_return_status OUT VARCHAR2 Required
104: -- x_msg_count OUT NUMBER Required
114: -- End of Comments --
115:
116:
117: PROCEDURE Create_Item_group (p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
119: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
120: x_return_status OUT NOCOPY VARCHAR2,
121: x_msg_count OUT NOCOPY NUMBER,
122: x_msg_data OUT NOCOPY VARCHAR2,
115:
116:
117: PROCEDURE Create_Item_group (p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
119: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
120: x_return_status OUT NOCOPY VARCHAR2,
121: x_msg_count OUT NOCOPY NUMBER,
122: x_msg_data OUT NOCOPY VARCHAR2,
123: p_x_item_group_rec IN OUT NOCOPY AHL_MC_ITEMGROUP_PVT.Item_Group_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
155: -- Operation_flag Required. (C = Create, M = Modify, D = Delete).
156: -- End of Comments --
157:
158: PROCEDURE Modify_Item_group (p_api_version IN NUMBER,
159: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
160: --p_commit IN VARCHAR2 := FND_API.G_FALSE,
161: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
162: x_return_status OUT NOCOPY VARCHAR2,
163: x_msg_count OUT NOCOPY NUMBER,
156: -- End of Comments --
157:
158: PROCEDURE Modify_Item_group (p_api_version IN NUMBER,
159: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
160: --p_commit IN VARCHAR2 := FND_API.G_FALSE,
161: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
162: x_return_status OUT NOCOPY VARCHAR2,
163: x_msg_count OUT NOCOPY NUMBER,
164: x_msg_data OUT NOCOPY VARCHAR2,
157:
158: PROCEDURE Modify_Item_group (p_api_version IN NUMBER,
159: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
160: --p_commit IN VARCHAR2 := FND_API.G_FALSE,
161: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
162: x_return_status OUT NOCOPY VARCHAR2,
163: x_msg_count OUT NOCOPY NUMBER,
164: x_msg_data OUT NOCOPY VARCHAR2,
165: p_item_group_rec IN AHL_MC_ITEMGROUP_PVT.Item_Group_Rec_Type,
175: -- Pre-reqs :
176: -- Parameters :
177: -- Standard IN Parameters :
178: -- p_api_version IN NUMBER Required
179: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
180: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
181: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
182: --
183: -- Standard OUT Parameters :
176: -- Parameters :
177: -- Standard IN Parameters :
178: -- p_api_version IN NUMBER Required
179: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
180: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
181: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
182: --
183: -- Standard OUT Parameters :
184: -- x_return_status OUT VARCHAR2 Required
177: -- Standard IN Parameters :
178: -- p_api_version IN NUMBER Required
179: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
180: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
181: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
182: --
183: -- Standard OUT Parameters :
184: -- x_return_status OUT VARCHAR2 Required
185: -- x_msg_count OUT NUMBER Required
191: --
192: -- End of Comments --
193:
194: PROCEDURE Remove_Item_group (p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
196: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
197: x_return_status OUT NOCOPY VARCHAR2,
198: x_msg_count OUT NOCOPY NUMBER,
199: x_msg_data OUT NOCOPY VARCHAR2,
192: -- End of Comments --
193:
194: PROCEDURE Remove_Item_group (p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
196: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
197: x_return_status OUT NOCOPY VARCHAR2,
198: x_msg_count OUT NOCOPY NUMBER,
199: x_msg_data OUT NOCOPY VARCHAR2,
200: p_item_group_rec IN AHL_MC_ITEMGROUP_PVT.Item_Group_Rec_Type
211: -- Pre-reqs :
212: -- Parameters :
213: -- Standard IN Parameters :
214: -- p_api_version IN NUMBER Required
215: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
216: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
217: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
218: --
219: -- Standard OUT Parameters :
212: -- Parameters :
213: -- Standard IN Parameters :
214: -- p_api_version IN NUMBER Required
215: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
216: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
217: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
218: --
219: -- Standard OUT Parameters :
220: -- x_return_status OUT VARCHAR2 Required
213: -- Standard IN Parameters :
214: -- p_api_version IN NUMBER Required
215: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
216: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
217: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
218: --
219: -- Standard OUT Parameters :
220: -- x_return_status OUT VARCHAR2 Required
221: -- x_msg_count OUT NUMBER Required
229: -- End of Comments --
230:
231: PROCEDURE Initiate_Itemgroup_Appr (
232: p_api_version IN NUMBER,
233: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
234: p_commit 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_FALSE,
237: P_MODULE_TYPE IN VARCHAR2,
230:
231: PROCEDURE Initiate_Itemgroup_Appr (
232: p_api_version IN NUMBER,
233: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
234: p_commit 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_FALSE,
237: P_MODULE_TYPE IN VARCHAR2,
238: x_return_status OUT NOCOPY VARCHAR2,
231: PROCEDURE Initiate_Itemgroup_Appr (
232: p_api_version IN NUMBER,
233: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
234: p_commit 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_FALSE,
237: P_MODULE_TYPE IN VARCHAR2,
238: x_return_status OUT NOCOPY VARCHAR2,
239: x_msg_count OUT NOCOPY NUMBER,
232: p_api_version IN NUMBER,
233: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
234: p_commit 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_FALSE,
237: P_MODULE_TYPE IN VARCHAR2,
238: x_return_status OUT NOCOPY VARCHAR2,
239: x_msg_count OUT NOCOPY NUMBER,
240: x_msg_data OUT NOCOPY VARCHAR2,
253: -- Pre-reqs :
254: -- Parameters :
255: -- Standard IN Parameters :
256: -- p_api_version IN NUMBER Required
257: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
258: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
259: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
260: --
261: -- Standard OUT Parameters :
254: -- Parameters :
255: -- Standard IN Parameters :
256: -- p_api_version IN NUMBER Required
257: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
258: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
259: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
260: --
261: -- Standard OUT Parameters :
262: -- x_return_status OUT VARCHAR2 Required
255: -- Standard IN Parameters :
256: -- p_api_version IN NUMBER Required
257: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
258: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
259: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
260: --
261: -- Standard OUT Parameters :
262: -- x_return_status OUT VARCHAR2 Required
263: -- x_msg_count OUT NUMBER Required
271:
272:
273: PROCEDURE Create_ItemGroup_Revision (
274: p_api_version IN NUMBER,
275: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
276: p_commit IN VARCHAR2 := FND_API.G_FALSE,
277: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
278: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
279: P_MODULE_TYPE IN VARCHAR2,
272:
273: PROCEDURE Create_ItemGroup_Revision (
274: p_api_version IN NUMBER,
275: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
276: p_commit IN VARCHAR2 := FND_API.G_FALSE,
277: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
278: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
279: P_MODULE_TYPE IN VARCHAR2,
280: x_return_status OUT NOCOPY VARCHAR2,
273: PROCEDURE Create_ItemGroup_Revision (
274: p_api_version IN NUMBER,
275: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
276: p_commit IN VARCHAR2 := FND_API.G_FALSE,
277: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
278: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
279: P_MODULE_TYPE IN VARCHAR2,
280: x_return_status OUT NOCOPY VARCHAR2,
281: x_msg_count OUT NOCOPY NUMBER,
274: p_api_version IN NUMBER,
275: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
276: p_commit IN VARCHAR2 := FND_API.G_FALSE,
277: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
278: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
279: P_MODULE_TYPE IN VARCHAR2,
280: x_return_status OUT NOCOPY VARCHAR2,
281: x_msg_count OUT NOCOPY NUMBER,
282: x_msg_data OUT NOCOPY VARCHAR2,
295: -- Pre-reqs :
296: -- Parameters :
297: -- Standard IN Parameters :
298: -- p_api_version IN NUMBER Required
299: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
300: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
301: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
302: --
303: -- Standard OUT Parameters :
296: -- Parameters :
297: -- Standard IN Parameters :
298: -- p_api_version IN NUMBER Required
299: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
300: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
301: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
302: --
303: -- Standard OUT Parameters :
304: -- x_return_status OUT VARCHAR2 Required
297: -- Standard IN Parameters :
298: -- p_api_version IN NUMBER Required
299: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
300: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
301: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
302: --
303: -- Standard OUT Parameters :
304: -- x_return_status OUT VARCHAR2 Required
305: -- x_msg_count OUT NUMBER Required
314:
315:
316: PROCEDURE Approve_ItemGroups (
317: p_api_version IN NUMBER,
318: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
319: p_commit IN VARCHAR2 := FND_API.G_FALSE,
320: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
321: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
322: P_MODULE_TYPE IN VARCHAR2,
315:
316: PROCEDURE Approve_ItemGroups (
317: p_api_version IN NUMBER,
318: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
319: p_commit IN VARCHAR2 := FND_API.G_FALSE,
320: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
321: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
322: P_MODULE_TYPE IN VARCHAR2,
323: x_return_status OUT NOCOPY VARCHAR2,
316: PROCEDURE Approve_ItemGroups (
317: p_api_version IN NUMBER,
318: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
319: p_commit IN VARCHAR2 := FND_API.G_FALSE,
320: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
321: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
322: P_MODULE_TYPE IN VARCHAR2,
323: x_return_status OUT NOCOPY VARCHAR2,
324: x_msg_count OUT NOCOPY NUMBER,
317: p_api_version IN NUMBER,
318: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
319: p_commit IN VARCHAR2 := FND_API.G_FALSE,
320: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
321: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
322: P_MODULE_TYPE IN VARCHAR2,
323: x_return_status OUT NOCOPY VARCHAR2,
324: x_msg_count OUT NOCOPY NUMBER,
325: x_msg_data OUT NOCOPY VARCHAR2,
330:
331: PROCEDURE Modify_Position_Assos
332: (
333: p_api_version IN NUMBER,
334: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
335: p_commit IN VARCHAR2 := FND_API.G_FALSE,
336: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
337: p_module_type IN VARCHAR2,
338: x_return_status OUT NOCOPY VARCHAR2,
331: PROCEDURE Modify_Position_Assos
332: (
333: p_api_version IN NUMBER,
334: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
335: p_commit IN VARCHAR2 := FND_API.G_FALSE,
336: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
337: p_module_type IN VARCHAR2,
338: x_return_status OUT NOCOPY VARCHAR2,
339: x_msg_count OUT NOCOPY NUMBER,
332: (
333: p_api_version IN NUMBER,
334: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
335: p_commit IN VARCHAR2 := FND_API.G_FALSE,
336: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
337: p_module_type IN VARCHAR2,
338: x_return_status OUT NOCOPY VARCHAR2,
339: x_msg_count OUT NOCOPY NUMBER,
340: x_msg_data OUT NOCOPY VARCHAR2,