APPS.MTH_LOAD_TAG_READINGS_PKG dependencies on MTH_TAG_READINGS_RAW_ERR

Line 101: MTH_TAG_READINGS_RAW_ERR

97: v_ret_code NUMBER;
98: BEGIN
99: INSERT
100: INTO
101: MTH_TAG_READINGS_RAW_ERR
102: (GROUP_ID,
103: READING_TIME,
104: TAG_CODE,
105: TAG_DATA,

Line 141: mth_util_pkg.log_msg('Number of rows inserted in MTH_TAG_READINGS_RAW_ERR while proceesing the data from tag readings raw processed table - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

137: FROM MTH_TAG_READINGS_RAW_PROCESSED RP
138: GROUP BY RP.READING_TIME , RP.TAG_CODE
139: HAVING COUNT(RP.TAG_CODE) > 1
140: ) ;
141: mth_util_pkg.log_msg('Number of rows inserted in MTH_TAG_READINGS_RAW_ERR while proceesing the data from tag readings raw processed table - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
142:
143: ---Inserting records missing equipment or plant or incorrect status information or missing mth entity,attribute group and attribute information in tag readings staging error table
144:
145: INSERT

Line 2195: DELETE FROM MTH_TAG_READINGS_RAW_ERR;

2191:
2192: DELETE FROM MTH_TAG_READINGS_UNPROCESS_ERR;
2193: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINGS_UNPROCESS_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2194:
2195: DELETE FROM MTH_TAG_READINGS_RAW_ERR;
2196: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINGS_RAW_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2197:
2198: DELETE FROM MTH_TAG_READINGS_RAW_PROCESSED;
2199: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINGS_RAW_PROCESSED - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

Line 2196: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINGS_RAW_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

2192: DELETE FROM MTH_TAG_READINGS_UNPROCESS_ERR;
2193: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINGS_UNPROCESS_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2194:
2195: DELETE FROM MTH_TAG_READINGS_RAW_ERR;
2196: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINGS_RAW_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2197:
2198: DELETE FROM MTH_TAG_READINGS_RAW_PROCESSED;
2199: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINGS_RAW_PROCESSED - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2200: