APPS.MTH_PROCESS_STATUS_PKG dependencies on MTH_EQUIP_STATUSES_ERR

Line 885: FROM mth_equip_statuses_err

881: user_measure3,
882: user_measure4,
883: user_measure5,
884: downtime_reason_code
885: FROM mth_equip_statuses_err
886: WHERE reprocess_ready_yn = 'Y');
887: mth_util_pkg.log_msg('Number of rows inserted in MTH_EQUIP_STATUSES_STG from error table - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
888:
889: --delete status table

Line 890: DELETE FROM MTH_EQUIP_STATUSES_ERR

886: WHERE reprocess_ready_yn = 'Y');
887: mth_util_pkg.log_msg('Number of rows inserted in MTH_EQUIP_STATUSES_STG from error table - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
888:
889: --delete status table
890: DELETE FROM MTH_EQUIP_STATUSES_ERR
891: WHERE REPROCESS_READY_YN = 'Y';
892: mth_util_pkg.log_msg('Number of rows deleted in MTH_EQUIP_STATUSES - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
893:
894:

Line 1280: --Insert records into mth_equip_statuses_err

1276: WHERE stg.processing_flag = v_processing_flag
1277: AND stg.status NOT IN (1,2,3,4);
1278: mth_util_pkg.log_msg('Number of rows with STS in MTH_EQUIP_STATUSES_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1279:
1280: --Insert records into mth_equip_statuses_err
1281: INSERT INTO mth_equip_statuses_err(equipment_fk,
1282: shift_workday_fk,
1283: from_date,
1284: To_Date,

Line 1281: INSERT INTO mth_equip_statuses_err(equipment_fk,

1277: AND stg.status NOT IN (1,2,3,4);
1278: mth_util_pkg.log_msg('Number of rows with STS in MTH_EQUIP_STATUSES_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1279:
1280: --Insert records into mth_equip_statuses_err
1281: INSERT INTO mth_equip_statuses_err(equipment_fk,
1282: shift_workday_fk,
1283: from_date,
1284: To_Date,
1285: status,

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

1328: downtime_reason_code
1329: FROM mth_equip_statuses_stg
1330: WHERE err_code IS NOT NULL
1331: AND processing_flag = v_processing_flag);
1332: mth_util_pkg.log_msg('Number of rows inserted in MTH_EQUIP_STATUSES_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1333:
1334: --Insert records into mth_equip_statuses table
1335: INSERT INTO mth_equip_statuses( equipment_fk_key,
1336: shift_workday_fk_key,

Line 1629: FROM mth_equip_statuses_err

1625: user_measure4,
1626: user_measure5,
1627: downtime_reason_code,
1628: v_processing_flag
1629: FROM mth_equip_statuses_err
1630: WHERE reprocess_ready_yn = 'Y');
1631: mth_util_pkg.log_msg('Number of rows inserted in MTH_EQUIP_STATUSES_STG from error table - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1632:
1633: --delete status table

Line 1634: DELETE FROM MTH_EQUIP_STATUSES_ERR

1630: WHERE reprocess_ready_yn = 'Y');
1631: mth_util_pkg.log_msg('Number of rows inserted in MTH_EQUIP_STATUSES_STG from error table - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1632:
1633: --delete status table
1634: DELETE FROM MTH_EQUIP_STATUSES_ERR
1635: WHERE REPROCESS_READY_YN = 'Y';
1636: mth_util_pkg.log_msg('Number of rows deleted in MTH_EQUIP_STATUSES - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1637:
1638:

Line 2020: --Insert records into mth_equip_statuses_err

2016: WHERE stg.processing_flag = v_processing_flag
2017: AND stg.status NOT IN (1,2,3,4);
2018: mth_util_pkg.log_msg('Number of rows with STS in MTH_EQUIP_STATUSES_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2019:
2020: --Insert records into mth_equip_statuses_err
2021: INSERT INTO mth_equip_statuses_err(equipment_fk,
2022: shift_workday_fk,
2023: from_date,
2024: To_Date,

Line 2021: INSERT INTO mth_equip_statuses_err(equipment_fk,

2017: AND stg.status NOT IN (1,2,3,4);
2018: mth_util_pkg.log_msg('Number of rows with STS in MTH_EQUIP_STATUSES_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2019:
2020: --Insert records into mth_equip_statuses_err
2021: INSERT INTO mth_equip_statuses_err(equipment_fk,
2022: shift_workday_fk,
2023: from_date,
2024: To_Date,
2025: status,

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

2068: downtime_reason_code
2069: FROM mth_equip_statuses_stg
2070: WHERE err_code IS NOT NULL
2071: AND processing_flag = v_processing_flag);
2072: mth_util_pkg.log_msg('Number of rows inserted in MTH_EQUIP_STATUSES_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2073:
2074: MERGE
2075: INTO
2076: MTH_EQUIP_STATUSES stat

Line 2998: /*--Insert records into mth_equip_statuses_err

2994: SET stg.err_code = stg.err_code ||'STS '
2995: WHERE stg.status NOT IN (1,2,3,4);
2996: mth_util_pkg.log_msg('Number of rows with STS in MTH_EQUIP_STATUSES_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2997:
2998: /*--Insert records into mth_equip_statuses_err
2999: INSERT INTO mth_equip_statuses_err(equipment_fk,
3000: shift_workday_fk,
3001: from_date,
3002: To_Date,

Line 2999: INSERT INTO mth_equip_statuses_err(equipment_fk,

2995: WHERE stg.status NOT IN (1,2,3,4);
2996: mth_util_pkg.log_msg('Number of rows with STS in MTH_EQUIP_STATUSES_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2997:
2998: /*--Insert records into mth_equip_statuses_err
2999: INSERT INTO mth_equip_statuses_err(equipment_fk,
3000: shift_workday_fk,
3001: from_date,
3002: To_Date,
3003: status,

Line 3049: mth_util_pkg.log_msg('Number of rows inserted in MTH_EQUIP_STATUSES_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);*/

3045: err_code,
3046: downtime_reason_code
3047: FROM mth_equip_statuses_stg
3048: WHERE err_code IS NOT NULL);
3049: mth_util_pkg.log_msg('Number of rows inserted in MTH_EQUIP_STATUSES_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);*/
3050:
3051: OPEN c_error_rows;
3052: LOOP
3053: FETCH c_error_rows BULK COLLECT INTO l_err_rows;