DBA Data[Home] [Help]

APPS.INVPULI2 dependencies on INV_ITEM_UTIL

Line 123: l_ego_cat_grp_flag := INV_ITEM_UTIL.Object_Exists(p_object_type => 'SYNONYM',p_object_name => 'EGO_CAT_GRP_TEMPLATES');

119: INVPUTLI.info('INVPULI2: begin copy_template_attributes');
120: END IF;
121:
122: --added for bug: 7033786
123: l_ego_cat_grp_flag := INV_ITEM_UTIL.Object_Exists(p_object_type => 'SYNONYM',p_object_name => 'EGO_CAT_GRP_TEMPLATES');
124:
125:
126: -- Populate Template Ids.
127: FOR cur IN item_rec LOOP

Line 174: AND (INV_ITEM_UTIL.Appl_Inst_EGO > 0)

170:
171: ELSIF (cur.template_id IS NULL)
172: AND (cur.TRANSACTION_TYPE = 'CREATE')
173: AND (cur.ITEM_CATALOG_GROUP_ID IS NOT NULL)
174: AND (INV_ITEM_UTIL.Appl_Inst_EGO > 0)
175: --AND (INV_ITEM_UTIL.Object_Exists(p_object_type => 'SYNONYM', p_object_name => 'EGO_CAT_GRP_TEMPLATES') = 'Y')
176: --end added for bug: 7033786
177: AND (l_ego_cat_grp_flag = 'Y')
178: -- Adding the below clause to prevent application of default templates in the case of SKU Item

Line 175: --AND (INV_ITEM_UTIL.Object_Exists(p_object_type => 'SYNONYM', p_object_name => 'EGO_CAT_GRP_TEMPLATES') = 'Y')

171: ELSIF (cur.template_id IS NULL)
172: AND (cur.TRANSACTION_TYPE = 'CREATE')
173: AND (cur.ITEM_CATALOG_GROUP_ID IS NOT NULL)
174: AND (INV_ITEM_UTIL.Appl_Inst_EGO > 0)
175: --AND (INV_ITEM_UTIL.Object_Exists(p_object_type => 'SYNONYM', p_object_name => 'EGO_CAT_GRP_TEMPLATES') = 'Y')
176: --end added for bug: 7033786
177: AND (l_ego_cat_grp_flag = 'Y')
178: -- Adding the below clause to prevent application of default templates in the case of SKU Item
179: AND ( cur.style_item_flag IS NULL OR cur.style_item_flag = 'Y')