APPS.MTH_PROCESS_OUTPUT_PKG dependencies on MTH_TAG_REASON_READINGS

Line 1135: INSERT INTO MTH_TAG_REASON_READINGS (REASON_TYPE,

1131: AND stg.processing_flag = v_processing_flag);
1132: mth_util_pkg.log_msg('Number of rows inserted in MTH_EQUIP_OUTPUT - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1133:
1134: -- Insert into tag reason readings
1135: INSERT INTO MTH_TAG_REASON_READINGS (REASON_TYPE,
1136: EQUIPMENT_FK_KEY,
1137: FROM_DATE,
1138: To_DATE,
1139: REASON_CODE,

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

1165: AND stg.processing_flag = v_processing_flag
1166: AND stg.ERR_CODE IS NULL
1167: AND stg.qty_scrap IS NOT NULL);
1168:
1169: mth_util_pkg.log_msg('Number of rows inserted in MTH_TAG_REASON_READINGS - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1170:
1171: mth_util_pkg.truncate_table_partition('MTH_EQUIP_OUTPUT_STG',v_processing_flag);
1172:
1173: mth_util_pkg.log_msg('INIT_OUTPUT_FROM_CSV end', mth_util_pkg.G_DBG_PROC_FUN_END);

Line 1698: INSERT INTO MTH_TAG_REASON_READINGS (REASON_TYPE,

1694: AND stg.processing_flag = v_processing_flag);
1695: mth_util_pkg.log_msg('Number of rows inserted in MTH_EQUIP_OUTPUT - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1696:
1697: -- Insert into tag reason readings
1698: INSERT INTO MTH_TAG_REASON_READINGS (REASON_TYPE,
1699: EQUIPMENT_FK_KEY,
1700: FROM_DATE,
1701: To_DATE,
1702: REASON_CODE,

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

1728: AND stg.processing_flag = v_processing_flag
1729: AND stg.ERR_CODE IS NULL
1730: AND stg.qty_scrap IS NOT NULL);
1731:
1732: mth_util_pkg.log_msg('Number of rows inserted in MTH_TAG_REASON_READINGS - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1733:
1734: mth_util_pkg.truncate_table_partition('MTH_EQUIP_OUTPUT_STG',v_processing_flag);
1735:
1736: mth_util_pkg.log_msg('INCR_OUTPUT_FROM_CSV end', mth_util_pkg.G_DBG_PROC_FUN_END);

Line 1885: FROM mth_tag_reason_readings

1881:
1882: --Delete records from tag reason readings table for the recalculation time range
1883: IF (p_equipment_pk_key IS NULL AND p_plant_pk_key IS NOT NULL) THEN
1884: DELETE
1885: FROM mth_tag_reason_readings
1886: WHERE reading_time >= p_recal_from_date
1887: AND reading_time <= Nvl(p_recal_to_date,SYSDATE)
1888: AND REASON_TYPE=2
1889: AND equipment_fk_key IN ( SELECT equipment_pk_key

Line 1894: FROM mth_tag_reason_readings

1890: FROM mth_equipments_d
1891: WHERE plant_fk_key = p_plant_pk_key);
1892: ELSE
1893: DELETE
1894: FROM mth_tag_reason_readings
1895: WHERE reading_time >= p_recal_from_date
1896: AND reading_time <= Nvl(p_recal_to_date,SYSDATE)
1897: AND REASON_TYPE=2
1898: AND equipment_fk_key = NVL(p_equipment_pk_key,equipment_fk_key);

Line 2257: INSERT INTO MTH_TAG_REASON_READINGS (REASON_TYPE,

2253: mth_util_pkg.log_msg('Number of rows inserted in MTH_EQUIP_OUTPUT - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2254: v_count := SQL%ROWCOUNT;
2255:
2256: -- Insert into tag reason readings
2257: INSERT INTO MTH_TAG_REASON_READINGS (REASON_TYPE,
2258: EQUIPMENT_FK_KEY,
2259: FROM_DATE,
2260: To_DATE,
2261: REASON_CODE,

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

2286: AND med.status = 'ACTIVE'
2287: AND stg.ERR_CODE IS NULL
2288: AND stg.qty_scrap IS NOT NULL);
2289:
2290: mth_util_pkg.log_msg('Number of rows inserted in MTH_TAG_REASON_READINGS - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2291:
2292: IF (v_count > 0) THEN
2293: DELETE FROM MTH_EQUIP_OUTPUT_STG;
2294: END IF;