67: v_user_id := fnd_global.user_id;
68:
69: select userenv('LANG')
70: into l_Source_Lang
71: from dual ;
72:
73: IF ( SQL%NOTFOUND ) THEN
74: RAISE no_data_found;
75: END IF;
113: l_stmt_num := 3 ;
114:
115: select MTL_CATEGORIES_S.nextval
116: into l_New_Category_ID
117: from dual ;
118:
119: INSERT INTO MTL_CATEGORIES_B
120: (
121: CATEGORY_ID ,
471: v_user_id ,
472: sysdate ,
473: v_user_id ,
474: null
475: FROM dual
476: WHERE NOT EXISTS
477: ( SELECT 'x'
478: FROM MTL_ITEM_CATEGORIES icat
479: WHERE icat.INVENTORY_ITEM_ID = l_item_id