eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MTH_LOAD_TAG_READINGS_PKG dependencies on MTH_TAG_READINGS_STG

Line 147: MTH_TAG_READINGS_STG_ERR

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
146: INTO
147: MTH_TAG_READINGS_STG_ERR
148: (GROUP_ID,
149: READING_TIME,
150: TAG_CODE,
151: TAG_DATA,

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

225: AND TDM.ATTRIBUTE IS NULL )
226: )
227: )
228: ;
229: mth_util_pkg.log_msg('Number of rows inserted in MTH_TAG_READINGS_STG_ERR while proceesing the data from tag readings raw processed table- ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
230:
231: -- Inserting records in tag readings staging table
232: INSERT
233: INTO

Line 234: MTH_TAG_READINGS_STG

230:
231: -- Inserting records in tag readings staging table
232: INSERT
233: INTO
234: MTH_TAG_READINGS_STG
235: (GROUP_ID,
236: READING_TIME,
237: TAG_CODE,
238: TAG_DATA,

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

318: TDM.ATTRIBUTE IS NULL)
319: )
320:
321: ;
322: mth_util_pkg.log_msg('Number of rows inserted in MTH_TAG_READINGS_STG while proceesing the data from tag readings raw processed table - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
323: v_ret_code:=0;
324: RETURN v_ret_code;
325: EXCEPTION
326: WHEN OTHERS THEN

Line 439: MTH_TAG_READINGS_STG

435:
436: -- Inserting scheduled based contextualization records in tag readings staging table for the equipment whose staus is active
437: INSERT
438: INTO
439: MTH_TAG_READINGS_STG
440: (GROUP_ID,
441: READING_TIME,
442: TAG_CODE,
443: TAG_DATA,

Line 495: mth_util_pkg.log_msg('Number of rows inserted in MTH_TAG_READINGS_STG from tag readings error table- ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

491: AND MCM.CONTEXTUALIZE_METHOD = 2
492: AND TRE.EQUIPMENT_STATUS = 'ACTIVE'
493: )
494: ;
495: mth_util_pkg.log_msg('Number of rows inserted in MTH_TAG_READINGS_STG from tag readings error table- ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
496:
497: -- Inserting Remaining records in tag readings error table
498: INSERT
499: INTO

Line 678: MTH_TAG_READINGS_STG STG , MTH_CONTEXTUALIZATION_METHOD CM

674: STG.USER_MEASURE5,
675: STG.QUALITY_FLAG,
676: NVL( STG.PROCESSED_FLAG , 0)
677: FROM
678: MTH_TAG_READINGS_STG STG , MTH_CONTEXTUALIZATION_METHOD CM
679: WHERE
680: STG.EQUIPMENT_FK_KEY = CM.EQUIPMENT_FK_KEY (+)
681: AND CM.CONTEXTUALIZE_METHOD NOT IN ( 1 , 2 , 3 )
682: )

Line 841: MTH_TAG_READINGS_STG STG, MTH_CONTEXTUALIZATION_METHOD MCM

837: STG.USER_MEASURE4,
838: STG.USER_MEASURE5,
839: STG.QUALITY_FLAG
840: FROM
841: MTH_TAG_READINGS_STG STG, MTH_CONTEXTUALIZATION_METHOD MCM
842: WHERE
843: STG.EQUIPMENT_FK_KEY = MCM.EQUIPMENT_FK_KEY (+)
844: AND MCM.CONTEXTUALIZE_METHOD = 1 AND
845: ( STG.MTH_ENTITY IS NULL Or STG.MTH_ENTITY IS NOT NULL And NOT STG.MTH_ENTITY IN ( 2 , 3 , 4 , 14 , 15 ) )

Line 871: MTH_TAG_READINGS_STG STG ,MTH_CONTEXTUALIZATION_METHOD MCM

867: STG.ATTRIBUTE_GROUP,
868: STG.ATTRIBUTE,
869: STG.EQUIPMENT_FK_KEY
870: FROM
871: MTH_TAG_READINGS_STG STG ,MTH_CONTEXTUALIZATION_METHOD MCM
872: WHERE
873: STG.EQUIPMENT_FK_KEY = MCM.EQUIPMENT_FK_KEY (+) AND
874: MCM.CONTEXTUALIZE_METHOD = 1 AND
875: STG.MTH_ENTITY IS NOT NULL AND

Line 1071: MTH_TAG_READINGS_STG STG, MTH_CONTEXTUALIZATION_METHOD MCM

1067: STG.USER_MEASURE4,
1068: STG.USER_MEASURE5,
1069: STG.QUALITY_FLAG
1070: FROM
1071: MTH_TAG_READINGS_STG STG, MTH_CONTEXTUALIZATION_METHOD MCM
1072: WHERE
1073: STG.EQUIPMENT_FK_KEY = MCM.EQUIPMENT_FK_KEY (+)
1074: AND MCM.CONTEXTUALIZE_METHOD = 1 AND
1075: ( STG.MTH_ENTITY IS NULL Or STG.MTH_ENTITY IS NOT NULL And NOT STG.MTH_ENTITY IN ( 2 , 3 , 4 , 14 , 15 ) )

Line 1101: MTH_TAG_READINGS_STG STG ,MTH_CONTEXTUALIZATION_METHOD MCM

1097: STG.ATTRIBUTE_GROUP,
1098: STG.ATTRIBUTE,
1099: STG.EQUIPMENT_FK_KEY
1100: FROM
1101: MTH_TAG_READINGS_STG STG ,MTH_CONTEXTUALIZATION_METHOD MCM
1102: WHERE
1103: STG.EQUIPMENT_FK_KEY = MCM.EQUIPMENT_FK_KEY (+) AND
1104: MCM.CONTEXTUALIZE_METHOD = 1 AND
1105: STG.MTH_ENTITY IS NOT NULL AND

Line 1231: FROM MTH_TAG_READINGS_STG STG, MTH_CONTEXTUALIZATION_METHOD MCM ,MTH_EQUIP_PROD_SCHEDULE_F EQUIP_PROD_SCHEDULE,

1227: STG.USER_MEASURE5,
1228: STG.QUALITY_FLAG,
1229: NVL(STG.PROCESSED_FLAG , 0),
1230: EQUIPMENTS.STATUS
1231: FROM MTH_TAG_READINGS_STG STG, MTH_CONTEXTUALIZATION_METHOD MCM ,MTH_EQUIP_PROD_SCHEDULE_F EQUIP_PROD_SCHEDULE,
1232: MTH_EQUIPMENTS_D EQUIPMENTS, MTH_EQUIPMENT_SHIFTS_D EQP_SHIFTS,MTH_HOUR_D HOURS ,MTH_PRODUCTION_SCHEDULES_F PROD_SCHD ,
1233: MTH_CONTEXTUALIZATION_REQ MCR
1234: WHERE MCM.CONTEXTUALIZE_METHOD = 2
1235: AND STG.EQUIPMENT_FK_KEY = MCM.EQUIPMENT_FK_KEY (+)

Line 1342: MTH_TAG_READINGS_STG STG, MTH_CONTEXTUALIZATION_METHOD MCM ,MTH_EQUIP_PROD_SCHEDULE_F EQUIP_PROD_SCHEDULE,

1338: STG.QUALITY_FLAG,
1339: PROD_SCHD.RECIPE_NUM,
1340: PROD_SCHD.RECIPE_VERSION
1341: FROM
1342: MTH_TAG_READINGS_STG STG, MTH_CONTEXTUALIZATION_METHOD MCM ,MTH_EQUIP_PROD_SCHEDULE_F EQUIP_PROD_SCHEDULE,
1343: MTH_EQUIPMENTS_D EQUIPMENTS, MTH_EQUIPMENT_SHIFTS_D EQP_SHIFTS,MTH_HOUR_D HOURS ,MTH_PRODUCTION_SCHEDULES_F PROD_SCHD ,
1344: MTH_CONTEXTUALIZATION_REQ MCR
1345: WHERE MCM.CONTEXTUALIZE_METHOD = 2
1346: AND STG.EQUIPMENT_FK_KEY = MCM.EQUIPMENT_FK_KEY (+)

Line 1462: MTH_TAG_READINGS_STG STG ,MTH_CONTEXTUALIZATION_METHOD MCM , MTH_EQUIPMENT_SHIFTS_D EQP_SHIFTS ,MTH_CONTEXTUALIZATION_REQ CONTEXT_REQ,

1458: STG.USER_MEASURE4,
1459: STG.USER_MEASURE5,
1460: STG.QUALITY_FLAG
1461: FROM
1462: MTH_TAG_READINGS_STG STG ,MTH_CONTEXTUALIZATION_METHOD MCM , MTH_EQUIPMENT_SHIFTS_D EQP_SHIFTS ,MTH_CONTEXTUALIZATION_REQ CONTEXT_REQ,
1463: MTH_HOUR_D HOURS ,MTH_EQUIPMENTS_D EQUIPMENTS
1464: WHERE
1465: STG.EQUIPMENT_FK_KEY = MCM.EQUIPMENT_FK_KEY (+)
1466: AND MCM.CONTEXTUALIZE_METHOD = 3

Line 1542: MTH_TAG_READINGS_STG STG ,MTH_CONTEXTUALIZATION_METHOD MCM , MTH_EQUIPMENT_SHIFTS_D EQP_SHIFTS ,MTH_CONTEXTUALIZATION_REQ CONTEXT_REQ,

1538: STG.QUALITY_FLAG,
1539: NVL(STG.PROCESSED_FLAG , 0),
1540: EQUIPMENTS.STATUS
1541: FROM
1542: MTH_TAG_READINGS_STG STG ,MTH_CONTEXTUALIZATION_METHOD MCM , MTH_EQUIPMENT_SHIFTS_D EQP_SHIFTS ,MTH_CONTEXTUALIZATION_REQ CONTEXT_REQ,
1543: MTH_HOUR_D HOURS ,MTH_EQUIPMENTS_D EQUIPMENTS
1544: WHERE
1545: STG.EQUIPMENT_FK_KEY = MCM.EQUIPMENT_FK_KEY (+)
1546: AND MCM.CONTEXTUALIZE_METHOD = 3

Line 1677: and handles equpment down events from data in MTH_TAG_READINGS_STG table *

1673: END mth_recal_tag_raw_to_processed;
1674: /* ****************************************************************************
1675: * Procedure : MTH_GEN_HDL_EQP_DOWN_EVENT *
1676: * Description : The new procedure MTH_GEN_HDL_EQP_DOWN_EVENT generates *
1677: and handles equpment down events from data in MTH_TAG_READINGS_STG table *
1678: * File Name :MTHTAGB.PLS *
1679: * Visibility :Private *
1680: * Parameters : *
1681: **************************************************************************** */

Line 1691: from mth_tag_readings_stg

1687: (select MTH_ENTITY, tag_data, equipment_fk_key, reading_time,
1688: tag_code, lag( tag_data)
1689: over (partition by equipment_fk_key, tag_code
1690: order by reading_time ) prev_status
1691: from mth_tag_readings_stg
1692: --where MTH_ENTITY = 'Status'
1693: ) READINGS
1694: where
1695: READINGS.MTH_ENTITY = 5 And

Line 1726: and handles equpment out of control events from MTH_TAG_READINGS_STG table *

1722:
1723: /* ****************************************************************************
1724: * Procedure : MTH_HDL_EQP_OUT_OF_CTL_EVT *
1725: * Description : The new procedure MTH_HDL_EQP_OUT_OF_CTL_EVT generates *
1726: and handles equpment out of control events from MTH_TAG_READINGS_STG table *
1727: * File Name :MTHTAGB.PLS *
1728: * Visibility :Private *
1729: * Parameters : *
1730: **************************************************************************** */

Line 1768: JOIN MTH_TAG_READINGS_STG stg ON ( (( eagrps.ATTR_GROUP_ID = stg.ATTRIBUTE_GROUP ))

1764: EGO_ATTR_GROUPS_V eagrps
1765: JOIN EGO_ATTRS_V eattrs ON ( (( eagrps.ATTR_GROUP_TYPE = eattrs.ATTR_GROUP_TYPE ))
1766: AND (( eagrps.APPLICATION_ID = eattrs.APPLICATION_ID ))
1767: AND (( eattrs.ATTR_GROUP_NAME = eagrps.ATTR_GROUP_NAME )) )
1768: JOIN MTH_TAG_READINGS_STG stg ON ( (( eagrps.ATTR_GROUP_ID = stg.ATTRIBUTE_GROUP ))
1769: AND (( stg.ATTRIBUTE = eattrs.ATTR_ID )) )
1770: JOIN MTH_TAG_MASTER tag_mstr ON ( --(( stg.EQUIPMENT_FK_KEY = tag_mstr.EQUIPMENT_FK_KEY ))
1771: --AND
1772: (( stg.TAG_CODE = tag_mstr.TAG_CODE )) )

Line 1817: generates and handles equpment Control Limit warning events from MTH_TAG_READINGS_STG table*

1813: END ;
1814: /* ****************************************************************************
1815: * Procedure : MTH_GEN_HDL_CTL_LMT_WRNG_EVT *
1816: * Description :The new procedure MTH_GEN_HDL_CTL_LMT_WRNG_EVT *
1817: generates and handles equpment Control Limit warning events from MTH_TAG_READINGS_STG table*
1818: * File Name :MTHTAGB.PLS *
1819: * Visibility :Private *
1820: * Parameters : *
1821: **************************************************************************** */

Line 1855: JOIN MTH_TAG_READINGS_STG stg ON ( (( eagrps.ATTR_GROUP_ID = stg.ATTRIBUTE_GROUP ))

1851: EGO_ATTR_GROUPS_V eagrps
1852: JOIN EGO_ATTRS_V eattrs ON ( (( eagrps.ATTR_GROUP_TYPE = eattrs.ATTR_GROUP_TYPE ))
1853: AND (( eagrps.APPLICATION_ID = eattrs.APPLICATION_ID ))
1854: AND (( eattrs.ATTR_GROUP_NAME = eagrps.ATTR_GROUP_NAME )) )
1855: JOIN MTH_TAG_READINGS_STG stg ON ( (( eagrps.ATTR_GROUP_ID = stg.ATTRIBUTE_GROUP ))
1856: AND (( stg.ATTRIBUTE = eattrs.ATTR_ID )) )
1857: JOIN MTH_TAG_MASTER tag_mstr ON (-- (( stg.EQUIPMENT_FK_KEY = tag_mstr.EQUIPMENT_FK_KEY ))
1858: -- AND
1859: (( stg.TAG_CODE = tag_mstr.TAG_CODE )) )

Line 1889: generates and handles Equipment unstable events from MTH_TAG_READINGS_STG table*

1885:
1886: /* ****************************************************************************
1887: * Procedure : MTH_HDL_EQP_UNSTAB_EVT *
1888: * Description :The new procedure MTH_HDL_EQP_UNSTAB_EVT *
1889: generates and handles Equipment unstable events from MTH_TAG_READINGS_STG table*
1890: * File Name :MTHTAGB.PLS *
1891: * Visibility :Private *
1892: * Parameters : *
1893: **************************************************************************** */

Line 1918: FROM EGO_ATTR_GROUPS_V EAGV ,EGO_ATTRS_V EAV, MTH_TAG_READINGS_STG TRS , MTH_TAG_MASTER TM

1914: TRS.ATTRIBUTE ATTRIBUTE,
1915: TRS.EQUIPMENT_FK_KEY EQUIPMENT_FK_KEY ,
1916: TM.UOM ,
1917: TRS.READING_TIME
1918: FROM EGO_ATTR_GROUPS_V EAGV ,EGO_ATTRS_V EAV, MTH_TAG_READINGS_STG TRS , MTH_TAG_MASTER TM
1919: WHERE EAGV.ATTR_GROUP_TYPE = EAV.ATTR_GROUP_TYPE
1920: AND EAGV.APPLICATION_ID = EAV.APPLICATION_ID
1921: AND EAV.ATTR_GROUP_NAME = EAGV.ATTR_GROUP_NAME
1922: AND EAGV.ATTR_GROUP_ID = TRS.ATTRIBUTE_GROUP

Line 1938: FROM EGO_ATTR_GROUPS_V EAGV ,EGO_ATTRS_V EAV, MTH_TAG_READINGS_STG TRS , MTH_TAG_MASTER TM

1934: TRS.ATTRIBUTE,
1935: TRS.EQUIPMENT_FK_KEY EQUIPMENT_FK_KEY,
1936: TM.UOM ,
1937: TRS.READING_TIME
1938: FROM EGO_ATTR_GROUPS_V EAGV ,EGO_ATTRS_V EAV, MTH_TAG_READINGS_STG TRS , MTH_TAG_MASTER TM
1939: WHERE EAGV.ATTR_GROUP_TYPE = EAV.ATTR_GROUP_TYPE
1940: AND EAGV.APPLICATION_ID = EAV.APPLICATION_ID
1941: AND EAV.ATTR_GROUP_NAME = EAGV.ATTR_GROUP_NAME
1942: AND EAGV.ATTR_GROUP_ID = TRS.ATTRIBUTE_GROUP

Line 1986: generates and handles equpment fault events from MTH_TAG_READINGS_STG table*

1982:
1983: /* ****************************************************************************
1984: * Procedure : MTH_GEN_HDL_EQP_FAULT_EVENT *
1985: * Description :The new procedure MTH_GEN_HDL_EQP_FAULT_EVENT *
1986: generates and handles equpment fault events from MTH_TAG_READINGS_STG table*
1987: * File Name :MTHTAGB.PLS *
1988: * Visibility :Private *
1989: * Parameters : *
1990: **************************************************************************** */

Line 2000: from mth_tag_readings_stg

1996: (select MTH_ENTITY, tag_data, equipment_fk_key, reading_time,
1997: tag_code, lag( tag_data)
1998: over (partition by equipment_fk_key, tag_code
1999: order by reading_time ) prev_tag_data
2000: from mth_tag_readings_stg
2001: where MTH_ENTITY =19
2002: ) READINGS
2003: where
2004: READINGS.TAG_DATA = v_EQP_FAULT_THRESHOLD And

Line 2032: generates and handles scrap events from MTH_TAG_READINGS_STG table*

2028:
2029: /* ****************************************************************************
2030: * Procedure : MTH_GEN_HDL_SCRAP_EVENT *
2031: * Description :The new procedure MTH_GEN_HDL_SCRAP_EVENT *
2032: generates and handles scrap events from MTH_TAG_READINGS_STG table*
2033: * File Name :MTHTAGB.PLS *
2034: * Visibility :Private *
2035: * Parameters : *
2036: **************************************************************************** */

Line 2042: MTH_TAG_READINGS_STG READINGS

2038: PROCEDURE MTH_GEN_HDL_SCRAP_EVENT IS
2039: cursor c_readings IS
2040: select readings.*
2041: from MTH_EQUIPMENT_SHIFTS_D EQP_SHIFTS,
2042: MTH_TAG_READINGS_STG READINGS
2043: where
2044: READINGS.MTH_ENTITY = 12 And
2045: READINGS.EQUIPMENT_FK_KEY = EQP_SHIFTS.EQUIPMENT_FK_KEY And
2046: READINGS.READING_TIME BETWEEN EQP_SHIFTS.FROM_DATE AND EQP_SHIFTS.TO_DATE And

Line 2065: generates and handles Recalibration events from MTH_TAG_READINGS_STG table*

2061:
2062: /* ****************************************************************************
2063: * Procedure : MTH_GEN_HDL_RECALIBRATION_EVT *
2064: * Description :The new procedure MTH_GEN_HDL_RECALIBRATION_EVT *
2065: generates and handles Recalibration events from MTH_TAG_READINGS_STG table*
2066: * File Name :MTHTAGB.PLS *
2067: * Visibility :Private *
2068: * Parameters : *
2069: **************************************************************************** */

Line 2078: MTH_TAG_READINGS_STG readings,

2074: over (partition by readings.equipment_fk_key, readings.tag_code
2075: order by readings.reading_time ) prev_tag_data
2076:
2077: from MTH_EQUIPMENT_SHIFTS_D eqp_shifts,
2078: MTH_TAG_READINGS_STG readings,
2079: MTH_ENTITIES entities
2080: WHERE
2081: READINGS.MTH_ENTITY = 18 And
2082: READINGS.EQUIPMENT_FK_KEY = EQP_SHIFTS.EQUIPMENT_FK_KEY And

Line 2114: generates and handles events from the data in mth_tag_readings_stg table*

2110:
2111: /* ****************************************************************************
2112: * Procedure : MTH_GEN_HDL_EVENTS_READINGS *
2113: * Description :The new procedure MTH_GEN_HDL_EVENTS_READINGS *
2114: generates and handles events from the data in mth_tag_readings_stg table*
2115: * File Name :MTHTAGB.PLS *
2116: * Visibility :Private *
2117: * Parameters : *
2118: **************************************************************************** */

Line 2204: DELETE FROM MTH_TAG_READINGS_STG_ERR;

2200:
2201: DELETE FROM MTH_TAG_READINGS;
2202: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINGS - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2203:
2204: DELETE FROM MTH_TAG_READINGS_STG_ERR;
2205: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINGS_STG_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2206:
2207: DELETE FROM MTH_TAG_READINGS_ERR;
2208: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINGS_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

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

2201: DELETE FROM MTH_TAG_READINGS;
2202: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINGS - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2203:
2204: DELETE FROM MTH_TAG_READINGS_STG_ERR;
2205: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINGS_STG_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2206:
2207: DELETE FROM MTH_TAG_READINGS_ERR;
2208: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINGS_ERR - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2209:

Line 2275: DELETE FROM MTH_TAG_READINGS_STG;

2271: mth_util_pkg.log_msg('MTH_SCHD_BASED_CONTEXTUALIZE completeled succesfully', mth_util_pkg.G_DBG_PROC_FUN_END);
2272: p_ret_code :=MTH_LOAD_TAG_READINGS_PKG.MTH_MANUAL_BASED_CONTEXTUALIZE();
2273: IF(p_ret_code <> 2) THEN
2274: mth_util_pkg.log_msg('MTH_MANUAL_BASED_CONTEXTUALIZE completeled succesfully', mth_util_pkg.G_DBG_PROC_FUN_END);
2275: DELETE FROM MTH_TAG_READINGS_STG;
2276: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINGS_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2277: IF(v_current_processing_flag=1 OR v_current_processing_flag=2 ) THEN
2278: mth_util_pkg.truncate_table_partition('MTH_TAG_READINGS_RAW' ,v_current_processing_flag);
2279: END IF;

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

2272: p_ret_code :=MTH_LOAD_TAG_READINGS_PKG.MTH_MANUAL_BASED_CONTEXTUALIZE();
2273: IF(p_ret_code <> 2) THEN
2274: mth_util_pkg.log_msg('MTH_MANUAL_BASED_CONTEXTUALIZE completeled succesfully', mth_util_pkg.G_DBG_PROC_FUN_END);
2275: DELETE FROM MTH_TAG_READINGS_STG;
2276: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINGS_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2277: IF(v_current_processing_flag=1 OR v_current_processing_flag=2 ) THEN
2278: mth_util_pkg.truncate_table_partition('MTH_TAG_READINGS_RAW' ,v_current_processing_flag);
2279: END IF;
2280: COMMIT;

Line 2410: DELETE FROM MTH_TAG_READINGS_STG;

2406: mth_util_pkg.log_msg('MTH_SCHD_BASED_CONTEXTUALIZE completeled succesfully', mth_util_pkg.G_DBG_PROC_FUN_END);
2407: p_ret_code :=MTH_LOAD_TAG_READINGS_PKG.MTH_MANUAL_BASED_CONTEXTUALIZE();
2408: IF(p_ret_code <> 2) THEN
2409: mth_util_pkg.log_msg('MTH_MANUAL_BASED_CONTEXTUALIZE completeled succesfully', mth_util_pkg.G_DBG_PROC_FUN_END);
2410: DELETE FROM MTH_TAG_READINGS_STG;
2411: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINGS_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2412: IF(v_current_processing_flag=1 OR v_current_processing_flag=2 ) THEN
2413:
2414: mth_util_pkg.truncate_table_partition('MTH_TAG_READINGS_RAW' ,v_current_processing_flag);

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

2407: p_ret_code :=MTH_LOAD_TAG_READINGS_PKG.MTH_MANUAL_BASED_CONTEXTUALIZE();
2408: IF(p_ret_code <> 2) THEN
2409: mth_util_pkg.log_msg('MTH_MANUAL_BASED_CONTEXTUALIZE completeled succesfully', mth_util_pkg.G_DBG_PROC_FUN_END);
2410: DELETE FROM MTH_TAG_READINGS_STG;
2411: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINGS_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2412: IF(v_current_processing_flag=1 OR v_current_processing_flag=2 ) THEN
2413:
2414: mth_util_pkg.truncate_table_partition('MTH_TAG_READINGS_RAW' ,v_current_processing_flag);
2415:

Line 2514: DELETE FROM MTH_TAG_READINGS_STG;

2510: THEN
2511: p_ret_code :=MTH_LOAD_TAG_READINGS_PKG.MTH_MANUAL_BASED_CONTEXTUALIZE();
2512: IF(p_ret_code <> 2)
2513: THEN
2514: DELETE FROM MTH_TAG_READINGS_STG;
2515: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINGS_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2516: END IF;
2517: END IF;
2518: END IF;

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

2511: p_ret_code :=MTH_LOAD_TAG_READINGS_PKG.MTH_MANUAL_BASED_CONTEXTUALIZE();
2512: IF(p_ret_code <> 2)
2513: THEN
2514: DELETE FROM MTH_TAG_READINGS_STG;
2515: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINGS_STG - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2516: END IF;
2517: END IF;
2518: END IF;
2519: END IF;