DBA Data[Home] [Help]

APPS.MTH_SEED_DATA_PKG dependencies on MTH_EQUIPMENTS_D

Line 238: mth_util_pkg.log_msg('Inserting MTH_EQUIPMENTS_D ', mth_util_pkg.G_DBG_USER_INFO);

234: MTH_UTIL_PKG.MTH_UA_GET_VAL(),
235: MTH_UTIL_PKG.MTH_UA_GET_VAL());
236:
237: mth_util_pkg.log_msg('Inserted/Updated ' || SQL%ROWCOUNT || ' rows.',mth_util_pkg.G_DBG_USER_INFO);
238: mth_util_pkg.log_msg('Inserting MTH_EQUIPMENTS_D ', mth_util_pkg.G_DBG_USER_INFO);
239:
240: merge INTO MTH_EQUIPMENTS_D t
241: USING
242: (

Line 240: merge INTO MTH_EQUIPMENTS_D t

236:
237: mth_util_pkg.log_msg('Inserted/Updated ' || SQL%ROWCOUNT || ' rows.',mth_util_pkg.G_DBG_USER_INFO);
238: mth_util_pkg.log_msg('Inserting MTH_EQUIPMENTS_D ', mth_util_pkg.G_DBG_USER_INFO);
239:
240: merge INTO MTH_EQUIPMENTS_D t
241: USING
242: (
243: SELECT MTH_UTIL_PKG.MTH_UA_GET_VAL() EQUIPMENT_PK_KEY, MTH_UTIL_PKG.MTH_UA_GET_VAL() EQUIPMENT_PK, MTH_UTIL_PKG.MTH_UA_GET_VAL() PLANT_FK_KEY, MTH_UTIL_PKG.MTH_UA_GET_MEANING() EQUIPMENT_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() SYSTEM_FK_KEY FROM DUAL
244: )s