eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_MC_ITEMGROUP_PUB dependencies on AHL_MC_ITEMGROUP_PVT

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_MC_ITEMGROUP_PVT';

1: PACKAGE BODY AHL_MC_ITEMGROUP_PUB AS
2: /* $Header: AHLPIGPB.pls 120.1.12020000.2 2012/12/07 00:16:44 sareepar ship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_MC_ITEMGROUP_PVT';
6:
7:
8:
9: ------------------------------

Line 13: PROCEDURE Convert_InTo_ID(p_x_item_assoc_rec IN OUT NOCOPY AHL_MC_ItemGroup_Pvt.Item_association_rec_type);

9: ------------------------------
10: -- Declare Local Procedures --
11: ------------------------------
12:
13: PROCEDURE Convert_InTo_ID(p_x_item_assoc_rec IN OUT NOCOPY AHL_MC_ItemGroup_Pvt.Item_association_rec_type);
14:
15:
16:
17: -----------------------------------------

Line 61: p_x_item_group_rec IN OUT NOCOPY AHL_MC_ItemGroup_Pvt.Item_Group_Rec_Type,

57: p_module_type IN VARCHAR2 := NULL,
58: x_return_status OUT NOCOPY VARCHAR2,
59: x_msg_count OUT NOCOPY NUMBER,
60: x_msg_data OUT NOCOPY VARCHAR2,
61: p_x_item_group_rec IN OUT NOCOPY AHL_MC_ItemGroup_Pvt.Item_Group_Rec_Type,
62: p_x_items_tbl IN OUT NOCOPY AHL_MC_ItemGroup_Pvt.Item_Association_Tbl_Type
63: ) IS
64:
65:

Line 62: p_x_items_tbl IN OUT NOCOPY AHL_MC_ItemGroup_Pvt.Item_Association_Tbl_Type

58: x_return_status OUT NOCOPY VARCHAR2,
59: x_msg_count OUT NOCOPY NUMBER,
60: x_msg_data OUT NOCOPY VARCHAR2,
61: p_x_item_group_rec IN OUT NOCOPY AHL_MC_ItemGroup_Pvt.Item_Group_Rec_Type,
62: p_x_items_tbl IN OUT NOCOPY AHL_MC_ItemGroup_Pvt.Item_Association_Tbl_Type
63: ) IS
64:
65:
66: l_api_name CONSTANT VARCHAR2(30) := 'Process_Item_Group';

Line 87: l_item_group_rec AHL_MC_ItemGroup_Pvt.Item_Group_Rec_Type DEFAULT p_X_item_group_rec;

83:
84: l_item_group_id NUMBER;
85: l_item_group_name AHL_ITEM_GROUPS_B.NAME%TYPE;
86: l_type_code AHL_ITEM_GROUPS_B.TYPE_CODE%TYPE;
87: l_item_group_rec AHL_MC_ItemGroup_Pvt.Item_Group_Rec_Type DEFAULT p_X_item_group_rec;
88: l_lookup_code VARCHAR2(30);
89: l_return_val BOOLEAN;
90: l_status VARCHAR2(1);
91:

Line 334: 'ahl_mc_itemgroup_pub.process_item_group', 'Calling ahl_mc_itemgroup_pvt.Create_Item_group');

330:
331: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
332: THEN
333: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
334: 'ahl_mc_itemgroup_pub.process_item_group', 'Calling ahl_mc_itemgroup_pvt.Create_Item_group');
335: END IF;
336:
337: -- Call Private API for Create
338:

Line 339: ahl_mc_itemgroup_pvt.Create_Item_group(

335: END IF;
336:
337: -- Call Private API for Create
338:
339: ahl_mc_itemgroup_pvt.Create_Item_group(
340: p_api_version => p_api_version,
341: --p_init_msg_list => p_init_msg_list,
342: --p_commit => p_commit,
343: p_validation_level => p_validation_level,

Line 355: 'ahl_mc_itemgroup_pub.process_item_group', 'Calling ahl_mc_itemgroup_pvt.Modify_Item_group');

351:
352: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
353: THEN
354: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
355: 'ahl_mc_itemgroup_pub.process_item_group', 'Calling ahl_mc_itemgroup_pvt.Modify_Item_group');
356: END IF;
357:
358: -- Call Private API for Create
359: AHL_MC_ItemGroup_Pvt.Modify_Item_group(

Line 359: AHL_MC_ItemGroup_Pvt.Modify_Item_group(

355: 'ahl_mc_itemgroup_pub.process_item_group', 'Calling ahl_mc_itemgroup_pvt.Modify_Item_group');
356: END IF;
357:
358: -- Call Private API for Create
359: AHL_MC_ItemGroup_Pvt.Modify_Item_group(
360: p_api_version => p_api_version,
361: p_init_msg_list => p_init_msg_list,
362: --p_commit => p_commit,
363: p_validation_level => p_validation_level,

Line 375: 'ahl_mc_itemgroup_pub.process_item_group', 'Calling ahl_mc_itemgroup_pvt.Remove_Item_group');

371:
372: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
373: THEN
374: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
375: 'ahl_mc_itemgroup_pub.process_item_group', 'Calling ahl_mc_itemgroup_pvt.Remove_Item_group');
376: END IF;
377:
378: -- Call Private API for Create
379: AHL_MC_ItemGroup_Pvt.Remove_Item_group(

Line 379: AHL_MC_ItemGroup_Pvt.Remove_Item_group(

375: 'ahl_mc_itemgroup_pub.process_item_group', 'Calling ahl_mc_itemgroup_pvt.Remove_Item_group');
376: END IF;
377:
378: -- Call Private API for Create
379: AHL_MC_ItemGroup_Pvt.Remove_Item_group(
380: p_api_version => p_api_version,
381: --p_init_msg_list => p_init_msg_list,
382: --p_commit => p_commit,
383: p_validation_level => p_validation_level,

Line 471: PROCEDURE Convert_InTo_ID(p_x_item_assoc_rec IN OUT NOCOPY AHL_MC_ItemGroup_Pvt.Item_association_rec_type) IS

467: ------------------------------
468: -- Define Local Procedures --
469: ------------------------------
470:
471: PROCEDURE Convert_InTo_ID(p_x_item_assoc_rec IN OUT NOCOPY AHL_MC_ItemGroup_Pvt.Item_association_rec_type) IS
472:
473:
474: -- For organization id.
475: CURSOR mtl_parameters_csr (p_org_code IN VARCHAR2) IS

Line 508: l_item_assoc_rec ahl_mc_itemgroup_pvt.Item_association_rec_type DEFAULT p_x_item_assoc_rec;

504: AND inventory_item_id = p_inventory_item_id;
505:
506:
507: l_inventory_id NUMBER;
508: l_item_assoc_rec ahl_mc_itemgroup_pvt.Item_association_rec_type DEFAULT p_x_item_assoc_rec;
509: l_inventory_org_id NUMBER;
510: l_item_association_id NUMBER;
511: l_item_group_id NUMBER;
512: l_lookup_code fnd_lookups.lookup_code%TYPE;

Line 658: 'ahl_mc_itemgroup_pvt.Convert_InTo_ID', l_dummy);

654: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
655: THEN
656: l_dummy := 'Inventory p_x_item_assoc_rec '||to_char(p_x_item_assoc_rec.inventory_item_id);
657: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
658: 'ahl_mc_itemgroup_pvt.Convert_InTo_ID', l_dummy);
659: END IF;
660:
661:
662: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )