DBA Data[Home] [Help]

APPS.MTH_SEED_DATA_PKG dependencies on MTH_DIM_LEVEL_LOOKUP

Line 62: mth_util_pkg.log_msg('Inserting MTH_DIM_LEVEL_LOOKUP ', mth_util_pkg.G_DBG_USER_INFO);

58: s.HIER_INTERNAL_NAME,
59: s.NUMBER_OF_LEVEL);
60:
61: mth_util_pkg.log_msg('Inserted/Updated ' || SQL%ROWCOUNT || ' rows.',mth_util_pkg.G_DBG_USER_INFO);
62: mth_util_pkg.log_msg('Inserting MTH_DIM_LEVEL_LOOKUP ', mth_util_pkg.G_DBG_USER_INFO);
63:
64: merge INTO MTH_DIM_LEVEL_LOOKUP t
65: USING
66: (

Line 64: merge INTO MTH_DIM_LEVEL_LOOKUP t

60:
61: mth_util_pkg.log_msg('Inserted/Updated ' || SQL%ROWCOUNT || ' rows.',mth_util_pkg.G_DBG_USER_INFO);
62: mth_util_pkg.log_msg('Inserting MTH_DIM_LEVEL_LOOKUP ', mth_util_pkg.G_DBG_USER_INFO);
63:
64: merge INTO MTH_DIM_LEVEL_LOOKUP t
65: USING
66: (
67:
68: SELECT -1 DIMENSION_ID, -1 HIERARCHY_ID, 8 LEVEL_NUM, 'RESOURCE GROUP' LEVEL_TYPE, 'RESOURCE GROUP' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL