DBA Data[Home] [Help]

APPS.AHL_ENIGMA_IPC_PROCS_PVT dependencies on AHL_MC_ITEMGROUP_PVT

Line 131: -- p_item_group_rec IN AHL_MC_ITEMGROUP_PVT.Item_Group_Rec_Type Required

127: -- Parameters :
128: --
129: -- Process_Item_Group Parameters:
130: -- p_report_file_name IN VARCHAR2 Required
131: -- p_item_group_rec IN AHL_MC_ITEMGROUP_PVT.Item_Group_Rec_Type Required
132: -- p_items_tbl IN AHL_MC_ITEMGROUP_PVT.Item_Association_Tbl_Type Required
133: --
134: -- End of Comments
135:

Line 132: -- p_items_tbl IN AHL_MC_ITEMGROUP_PVT.Item_Association_Tbl_Type Required

128: --
129: -- Process_Item_Group Parameters:
130: -- p_report_file_name IN VARCHAR2 Required
131: -- p_item_group_rec IN AHL_MC_ITEMGROUP_PVT.Item_Group_Rec_Type Required
132: -- p_items_tbl IN AHL_MC_ITEMGROUP_PVT.Item_Association_Tbl_Type Required
133: --
134: -- End of Comments
135:
136: PROCEDURE Process_Item_Group (

Line 144: p_item_group_rec IN AHL_MC_ITEMGROUP_PVT.Item_Group_Rec_Type,

140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
143: p_report_file_name IN VARCHAR2 := NULL,
144: p_item_group_rec IN AHL_MC_ITEMGROUP_PVT.Item_Group_Rec_Type,
145: p_items_tbl IN AHL_MC_ITEMGROUP_PVT.Item_Association_Tbl_Type
146: ) IS
147:
148: CURSOR get_ig_id_csr (p_ig_name VARCHAR2) IS

Line 145: p_items_tbl IN AHL_MC_ITEMGROUP_PVT.Item_Association_Tbl_Type

141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
143: p_report_file_name IN VARCHAR2 := NULL,
144: p_item_group_rec IN AHL_MC_ITEMGROUP_PVT.Item_Group_Rec_Type,
145: p_items_tbl IN AHL_MC_ITEMGROUP_PVT.Item_Association_Tbl_Type
146: ) IS
147:
148: CURSOR get_ig_id_csr (p_ig_name VARCHAR2) IS
149: SELECT item_group_id

Line 188: l_item_group_rec AHL_MC_ITEMGROUP_PVT.Item_Group_Rec_Type DEFAULT p_item_group_rec;

184: l_api_version CONSTANT NUMBER := 1.0;
185: l_api_name CONSTANT VARCHAR2(30) := 'Process_Item_Group';
186: l_full_name CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
187:
188: l_item_group_rec AHL_MC_ITEMGROUP_PVT.Item_Group_Rec_Type DEFAULT p_item_group_rec;
189: l_items_tbl AHL_MC_ITEMGROUP_PVT.Item_Association_Tbl_Type DEFAULT p_items_tbl;
190: l_org_id NUMBER := NULL;
191: l_dummy VARCHAR2(1);
192: l_msg_count NUMBER;

Line 189: l_items_tbl AHL_MC_ITEMGROUP_PVT.Item_Association_Tbl_Type DEFAULT p_items_tbl;

185: l_api_name CONSTANT VARCHAR2(30) := 'Process_Item_Group';
186: l_full_name CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
187:
188: l_item_group_rec AHL_MC_ITEMGROUP_PVT.Item_Group_Rec_Type DEFAULT p_item_group_rec;
189: l_items_tbl AHL_MC_ITEMGROUP_PVT.Item_Association_Tbl_Type DEFAULT p_items_tbl;
190: l_org_id NUMBER := NULL;
191: l_dummy VARCHAR2(1);
192: l_msg_count NUMBER;
193: --

Line 299: 'Calling private API AHL_MC_ITEMGROUP_PVT.Remove_Item_group.');

295: CLOSE get_ig_id_csr;
296:
297: IF (l_log_statement >= l_log_current_level) THEN
298: FND_LOG.string(l_log_statement, l_full_name,
299: 'Calling private API AHL_MC_ITEMGROUP_PVT.Remove_Item_group.');
300: END IF;
301:
302: -- call the private API
303: AHL_MC_ITEMGROUP_PVT.Remove_Item_group(

Line 303: AHL_MC_ITEMGROUP_PVT.Remove_Item_group(

299: 'Calling private API AHL_MC_ITEMGROUP_PVT.Remove_Item_group.');
300: END IF;
301:
302: -- call the private API
303: AHL_MC_ITEMGROUP_PVT.Remove_Item_group(
304: p_api_version => p_api_version,
305: p_init_msg_list => p_init_msg_list,
306: x_return_status => x_return_status,
307: x_msg_count => x_msg_count,

Line 314: 'AHL_MC_ITEMGROUP_PVT.Remove_Item_group returned x_return_status as ' || x_return_status);

310: );
311:
312: IF (l_log_statement >= l_log_current_level) THEN
313: FND_LOG.string(l_log_statement, l_full_name,
314: 'AHL_MC_ITEMGROUP_PVT.Remove_Item_group returned x_return_status as ' || x_return_status);
315: END IF;
316:
317: -- check for the return status
318: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 389: 'Calling private API AHL_MC_ITEMGROUP_PVT.Create_Item_group.');

385: END IF;
386:
387: IF (l_log_statement >= l_log_current_level) THEN
388: FND_LOG.string(l_log_statement, l_full_name,
389: 'Calling private API AHL_MC_ITEMGROUP_PVT.Create_Item_group.');
390: END IF;
391:
392: -- call the private API
393: AHL_MC_ITEMGROUP_PVT.Create_Item_group(

Line 393: AHL_MC_ITEMGROUP_PVT.Create_Item_group(

389: 'Calling private API AHL_MC_ITEMGROUP_PVT.Create_Item_group.');
390: END IF;
391:
392: -- call the private API
393: AHL_MC_ITEMGROUP_PVT.Create_Item_group(
394: p_api_version => p_api_version,
395: p_init_msg_list => p_init_msg_list,
396: x_return_status => x_return_status,
397: x_msg_count => x_msg_count,

Line 405: 'AHL_MC_ITEMGROUP_PVT.Create_Item_group returned x_return_status as ' || x_return_status);

401: );
402:
403: IF (l_log_statement >= l_log_current_level) THEN
404: FND_LOG.string(l_log_statement, l_full_name,
405: 'AHL_MC_ITEMGROUP_PVT.Create_Item_group returned x_return_status as ' || x_return_status);
406: END IF;
407:
408: -- check for the return status
409: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 420: 'Calling private API AHL_MC_ITEMGROUP_PVT.Approve_ItemGroups.');

416:
417: -- move the item group to Complete status
418: IF (l_log_statement >= l_log_current_level) THEN
419: FND_LOG.string(l_log_statement, l_full_name,
420: 'Calling private API AHL_MC_ITEMGROUP_PVT.Approve_ItemGroups.');
421: END IF;
422:
423: -- call the private API
424: AHL_MC_ITEMGROUP_PVT.Approve_ItemGroups(

Line 424: AHL_MC_ITEMGROUP_PVT.Approve_ItemGroups(

420: 'Calling private API AHL_MC_ITEMGROUP_PVT.Approve_ItemGroups.');
421: END IF;
422:
423: -- call the private API
424: AHL_MC_ITEMGROUP_PVT.Approve_ItemGroups(
425: p_api_version => p_api_version,
426: p_init_msg_list => p_init_msg_list,
427: p_module_type => NULL, -- not used in the API
428: x_return_status => x_return_status,

Line 438: 'AHL_MC_ITEMGROUP_PVT.Approve_ItemGroups returned x_return_status as ' || x_return_status);

434: );
435:
436: IF (l_log_statement >= l_log_current_level) THEN
437: FND_LOG.string(l_log_statement, l_full_name,
438: 'AHL_MC_ITEMGROUP_PVT.Approve_ItemGroups returned x_return_status as ' || x_return_status);
439: END IF;
440:
441: -- check for the return status
442: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 548: 'Calling private API AHL_MC_ITEMGROUP_PVT.Modify_Item_group.');

544: END IF;
545:
546: IF (l_log_statement >= l_log_current_level) THEN
547: FND_LOG.string(l_log_statement, l_full_name,
548: 'Calling private API AHL_MC_ITEMGROUP_PVT.Modify_Item_group.');
549: END IF;
550:
551: -- call the private API
552: AHL_MC_ITEMGROUP_PVT.Modify_Item_group(

Line 552: AHL_MC_ITEMGROUP_PVT.Modify_Item_group(

548: 'Calling private API AHL_MC_ITEMGROUP_PVT.Modify_Item_group.');
549: END IF;
550:
551: -- call the private API
552: AHL_MC_ITEMGROUP_PVT.Modify_Item_group(
553: p_api_version => p_api_version,
554: p_init_msg_list => p_init_msg_list,
555: x_return_status => x_return_status,
556: x_msg_count => x_msg_count,

Line 564: 'AHL_MC_ITEMGROUP_PVT.Modify_Item_group returned x_return_status as ' || x_return_status);

560: );
561:
562: IF (l_log_statement >= l_log_current_level) THEN
563: FND_LOG.string(l_log_statement, l_full_name,
564: 'AHL_MC_ITEMGROUP_PVT.Modify_Item_group returned x_return_status as ' || x_return_status);
565: END IF;
566:
567: -- check for the return status
568: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN