DBA Data[Home] [Help]

APPS.INVNIRIS dependencies on EGO_ATTR_GROUPS_V

Line 699: l_attr_grp_name EGO_ATTR_GROUPS_V.ATTR_GROUP_DISP_NAME%TYPE;

695: l_status_code mtl_system_items_b.inventory_item_status_code%TYPE;
696: l_eng_item_flag mtl_system_items_b.eng_item_flag%TYPE;
697:
698: --Bug: 5532737
699: l_attr_grp_name EGO_ATTR_GROUPS_V.ATTR_GROUP_DISP_NAME%TYPE;
700: l_ch_policy_found BOOLEAN := FALSE;
701: l_delim_pos NUMBER := 1;
702: l_attr_group_id VARCHAR2(10);
703: l_msg_text VARCHAR2(2000);

Line 821: FROM EGO_ATTR_GROUPS_V

817:
818: --Get attribute group+id
819: SELECT ATTR_GROUP_ID||':'||UPPER(ATTR_GROUP_NAME)
820: BULK COLLECT INTO Attribute_Grp_Table
821: FROM EGO_ATTR_GROUPS_V
822: WHERE ATTR_GROUP_TYPE ='EGO_MASTER_ITEMS';
823:
824: -- Bug 4870703 : Change policy check should take precedence over batch options
825: -- Bug 4676583 : Honouring batch option - Add All Imported Items to Change Order

Line 1318: FROM EGO_ATTR_GROUPS_V

1314: SET process_flag = 3
1315: WHERE rowid = cur.rowid;
1316:
1317: SELECT ATTR_GROUP_DISP_NAME INTO l_attr_grp_name
1318: FROM EGO_ATTR_GROUPS_V
1319: WHERE ATTR_GROUP_ID = l_attr_group_id;
1320:
1321: FND_MESSAGE.SET_NAME('INV','INV_IOI_CHANGE_NOT_ALLOWED');
1322: FND_MESSAGE.SET_TOKEN('ATTR_GROUP_NAME',l_attr_grp_name);