APPS.MTH_PROCESS_UDA_PKG dependencies on MTH_EXT_ATTR_T_STG

Line 582: INSERT INTO MTH_EXT_ATTR_T_STG

578:
579:
580:
581:
582: INSERT INTO MTH_EXT_ATTR_T_STG
583: (
584: ATTR_GROUP_ID,
585: ATTR_NAME,
586: ATTR_VALUE,

Line 651: mth_util_pkg.log_msg('Number of rows inserted in MTH_EXT_ATTR_T_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

647: )
648: )
649: );
650:
651: mth_util_pkg.log_msg('Number of rows inserted in MTH_EXT_ATTR_T_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
652:
653:
654:
655:

Line 671: MTH_EXT_ATTR_T_STG stg

667: stg.attr_group_id
668: FROM
669: ego_attr_groups_v egv,
670: MTH_EXT_ATTR_ERR err,
671: MTH_EXT_ATTR_T_STG stg
672: WHERE
673: ( stg.ATTR_GROUP_ID = egv.ATTR_GROUP_ID) AND
674: (stg.GROUP_ID = err.GROUP_ID) AND
675: ( egv.ATTR_GROUP_NAME = err.ATTR_GRP_NAME)

Line 683: MTH_EXT_ATTR_T_STG

679:
680:
681: DELETE
682: FROM
683: MTH_EXT_ATTR_T_STG
684: WHERE EXISTS
685: ( SELECT 1 FROM
686: (SELECT
687: egv.ATTR_GROUP_ID,

Line 701: mth_util_pkg.log_msg('Number of rows deleted from MTH_EXT_ATTR_T_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

697: 'PRODUCTION_SCHEDULES','MTH_PROD_SCH_GROUP','PRODUCTION_SEGMENTS','MTH_PRODUCTION_SEGMENTS_GROUP',
698: 'USER_ENTITIES','MTH_USER_ENTITIES_GROUP')) AND
699: (err.ATTR_GRP_NAME = egv.ATTR_GROUP_NAME)
700: ));
701: mth_util_pkg.log_msg('Number of rows deleted from MTH_EXT_ATTR_T_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
702: mth_util_pkg.log_msg('PROCESS_INTERFACE_TO_STAGING end', mth_util_pkg.G_DBG_PROC_FUN_END);
703:
704: END PROCESS_INTERFACE_TO_STAGING;
705:

Line 741: MTH_UTIL_PKG.MTH_TRUNCATE_TABLE('MTH_EXT_ATTR_T_STG');

737: ELSE
738: MTH_UDA_PKG.NTB_UPLOAD(p_entity);
739: END IF;
740: MTH_UTIL_PKG.MTH_TRUNCATE_TABLE('MTH_EXT_ATTR_I_STG');
741: MTH_UTIL_PKG.MTH_TRUNCATE_TABLE('MTH_EXT_ATTR_T_STG');
742: p_retcode := 0;
743:
744: mth_util_pkg.log_msg('PROCESS_UDA_STATIC_DATA end', mth_util_pkg.G_DBG_PROC_FUN_END);
745: