APPS.AHL_MC_ITEMGROUP_PUB dependencies on AHL_ITEM_GROUPS_B

Line 24: -- Function : Creates Item Group for Master Configuration in ahl_item_groups_b and TL tables. Also creates item-group association in

20:
21: -- Start of Comments --
22: -- Procedure name : PROCESS_ITEM_GROUP
23: -- Type : Public
24: -- Function : Creates Item Group for Master Configuration in ahl_item_groups_b and TL tables. Also creates item-group association in
25: --
26: --ahl_item_associations table.
27: -- Pre-reqs :
28: -- Parameters :

Line 74: FROM ahl_item_groups_b

70: -- For item_group_id.
71: CURSOR ahl_item_group_csr(p_grp_name IN VARCHAR2) IS
72: SELECT item_group_id,
73: type_code
74: FROM ahl_item_groups_b
75: WHERE name = p_grp_name;
76:
77: -- For item_group_id.
78: CURSOR Item_grp_name_csr(p_item_grp_id IN VARCHAR2) IS

Line 81: FROM ahl_item_groups_b

77: -- For item_group_id.
78: CURSOR Item_grp_name_csr(p_item_grp_id IN VARCHAR2) IS
79: SELECT name,
80: type_code
81: FROM ahl_item_groups_b
82: WHERE item_group_id = p_item_grp_id;
83:
84: l_item_group_id NUMBER;
85: l_item_group_name AHL_ITEM_GROUPS_B.NAME%TYPE;

Line 85: l_item_group_name AHL_ITEM_GROUPS_B.NAME%TYPE;

81: FROM ahl_item_groups_b
82: WHERE item_group_id = p_item_grp_id;
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;

Line 86: l_type_code AHL_ITEM_GROUPS_B.TYPE_CODE%TYPE;

82: WHERE item_group_id = p_item_grp_id;
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);