276: MTH_UTIL_PKG.MTH_UA_GET_VAL(),
277: MTH_UTIL_PKG.MTH_UA_GET_VAL());
278:
279: mth_util_pkg.log_msg('Inserted/Updated ' || SQL%ROWCOUNT || ' rows.',mth_util_pkg.G_DBG_USER_INFO);
280: mth_util_pkg.log_msg('Inserting MTH_ITEM_CATEGORIES_D ', mth_util_pkg.G_DBG_USER_INFO);
281:
282: merge INTO MTH_ITEM_CATEGORIES_D t
283: USING
284: (
278:
279: mth_util_pkg.log_msg('Inserted/Updated ' || SQL%ROWCOUNT || ' rows.',mth_util_pkg.G_DBG_USER_INFO);
280: mth_util_pkg.log_msg('Inserting MTH_ITEM_CATEGORIES_D ', mth_util_pkg.G_DBG_USER_INFO);
281:
282: merge INTO MTH_ITEM_CATEGORIES_D t
283: USING
284: (
285: SELECT
286: MTH_UTIL_PKG.MTH_UA_GET_VAL() CATEGORY_PK_KEY,