25: LV_ATTRIBUTE_VALUE JAI_RGM_ITM_TMPL_ATTRS.ATTRIBUTE_VALUE%TYPE DEFAULT NULL ;
26: -- Added by sacsethi for bug 5631784 on 31-01-2007
27: LN_RGM_ITEM_REGNS_ID JAI_RGM_ITM_TMPL_ATTRS.RGM_ITEM_REGNS_ID%TYPE DEFAULT NULL ;
28: LN_TEMPLATE_ID JAI_RGM_ITM_TMPL_ATTRS.TEMPLATE_ID%TYPE DEFAULT NULL ;
29: LV_ITEM_NAME MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE ;
30: --END 5631784
31:
32: /* Added by Brathod from bug# 4299606 */
33: CURSOR cur_get_item_attrib
42:
43: CURSOR C_GET_ITEM_NAME
44: IS
45: SELECT CONCATENATED_SEGMENTS
46: FROM MTL_SYSTEM_ITEMS_KFV
47: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
48: AND INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;
49: --END 5631784
50: BEGIN