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 815: FROM EGO_ATTR_GROUPS_V

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

Line 1312: FROM EGO_ATTR_GROUPS_V

1308: SET process_flag = 3
1309: WHERE rowid = cur.rowid;
1310:
1311: SELECT ATTR_GROUP_DISP_NAME INTO l_attr_grp_name
1312: FROM EGO_ATTR_GROUPS_V
1313: WHERE ATTR_GROUP_ID = l_attr_group_id;
1314:
1315: FND_MESSAGE.SET_NAME('INV','INV_IOI_CHANGE_NOT_ALLOWED');
1316: FND_MESSAGE.SET_TOKEN('ATTR_GROUP_NAME',l_attr_grp_name);