APPS.ENGPKIMP dependencies on EGO_ATTR_GROUPS_V

Line 329: SELECT attr_group_id, attr_group_name FROM ego_attr_groups_v WHERE attr_group_type='EGO_ITEM_GTIN_ATTRS' AND application_id=431;

325: l_multi_gdsn_item_pend_rec EGO_GTN_MUL_ATTR_CHG_VL%ROWTYPE;
326: abort_implementation exception;
327:
328: CURSOR cur_gdsn_singlerow_attr_grps IS
329: SELECT attr_group_id, attr_group_name FROM ego_attr_groups_v WHERE attr_group_type='EGO_ITEM_GTIN_ATTRS' AND application_id=431;
330:
331: BEGIN
332: l_single_changes_count := 0;
333: l_multi_changes_count := 0;

Line 690: SELECT attr_group_type INTO l_attribute_group_type FROM ego_attr_groups_v WHERE attr_group_id = l_current_attr_group_id;

686:
687: IF 'ATTRIBUTE_GROUP' = rev_items.attribute_code THEN -- Attribute Groups
688: -- Get the attribute group id
689: l_current_attr_group_id := rev_items.attribute_number_value;
690: SELECT attr_group_type INTO l_attribute_group_type FROM ego_attr_groups_v WHERE attr_group_id = l_current_attr_group_id;
691:
692: IF l_attribute_group_type = 'EGO_ITEMMGMT_GROUP' THEN
693: -- Check if there are any UDA pending changes done through this Change Order for this attribute group
694: SELECT count(*) INTO l_pending_changes_count