933:
934: /* Select Statement to fetch Long_Descrition -Bug 7591561 */
935: SELECT long_description
936: INTO X_long_description
937: FROM MTL_SYSTEM_ITEMS_TL
938: WHERE INVENTORY_ITEM_ID = X_eng_item_id
939: AND ORGANIZATION_ID = X_org_id
940: AND LANGUAGE=userenv('LANG');
941: /* End Bug 7591561 */
939: AND ORGANIZATION_ID = X_org_id
940: AND LANGUAGE=userenv('LANG');
941: /* End Bug 7591561 */
942:
943: insert into MTL_SYSTEM_ITEMS_TL (
944: INVENTORY_ITEM_ID,
945: ORGANIZATION_ID,
946: LANGUAGE,
947: SOURCE_LANG,
969: from FND_LANGUAGES L
970: where L.INSTALLED_FLAG in ('I', 'B')
971: and not exists
972: ( select NULL
973: from MTL_SYSTEM_ITEMS_TL T
974: where T.INVENTORY_ITEM_ID = X_mfg_item_id
975: and T.ORGANIZATION_ID = X_master_org
976: and T.LANGUAGE = L.LANGUAGE_CODE );
977: EXCEPTION