20: ,x_msg_count OUT NOCOPY NUMBER
21: ,x_msg_data OUT NOCOPY VARCHAR2) IS
22: BEGIN
23:
24: IF (INV_ITEM_UTIL.Object_Exists
25: (p_object_type => 'PACKAGE',
26: p_object_name => 'ENI_ITEMS_STAR_PKG') = 'Y')
27: THEN
28:
46: OUT x_msg_data;
47:
48: END IF;
49:
50: IF ((INV_ITEM_UTIL.Object_Exists
51: (p_object_type => 'PACKAGE',
52: p_object_name => 'ENI_UPD_ASSGN') = 'Y')
53: AND x_return_status ='S' )
54: THEN
100: ----------------------------------------------------------------------
101:
102: l_object_type CONSTANT VARCHAR2(20) := 'CATEGORY_SET';
103: BEGIN
104: IF (INV_ITEM_UTIL.Object_Exists
105: (p_object_type => 'PACKAGE',
106: p_object_name => 'ENI_DENORM_HRCHY') = 'Y') THEN
107: -- the package exists
108: EXECUTE IMMEDIATE
145: ,x_msg_count OUT NOCOPY NUMBER
146: ,x_msg_data OUT NOCOPY VARCHAR2) IS
147: BEGIN
148:
149: IF (INV_ITEM_UTIL.Object_Exists
150: (p_object_type => 'PACKAGE',
151: p_object_name => 'ENI_ITEMS_STAR_PKG') = 'Y') THEN
152: -- the package exists
153: EXECUTE IMMEDIATE
185: ,x_msg_count OUT NOCOPY NUMBER
186: ,x_msg_data OUT NOCOPY VARCHAR2) IS
187: BEGIN
188:
189: IF (INV_ITEM_UTIL.Object_Exists
190: (p_object_type => 'PACKAGE',
191: p_object_name => 'ENI_ITEMS_STAR_PKG') = 'Y') THEN
192: -- the package exists
193: EXECUTE IMMEDIATE