APPS.ENGPKIMP dependencies on EGO_ATTR_GROUPS_V

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

253: l_multi_gdsn_item_pend_rec EGO_GTN_MUL_ATTR_CHG_VL%ROWTYPE;
254: abort_implementation exception;
255:
256: CURSOR cur_gdsn_singlerow_attr_grps IS
257: SELECT attr_group_id, attr_group_name FROM ego_attr_groups_v WHERE attr_group_type='EGO_ITEM_GTIN_ATTRS' AND application_id=431;
258:
259: BEGIN
260: l_single_changes_count := 0;
261: l_multi_changes_count := 0;

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

614:
615: IF 'ATTRIBUTE_GROUP' = rev_items.attribute_code THEN -- Attribute Groups
616: -- Get the attribute group id
617: l_current_attr_group_id := rev_items.attribute_number_value;
618: SELECT attr_group_type INTO l_attribute_group_type FROM ego_attr_groups_v WHERE attr_group_id = l_current_attr_group_id;
619:
620: IF l_attribute_group_type = 'EGO_ITEMMGMT_GROUP' THEN
621: -- Check if there are any UDA pending changes done through this Change Order for this attribute group
622: SELECT count(*) INTO l_pending_changes_count