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_LOAD_TAG_READINGS_PKG

Line 1: PACKAGE BODY MTH_LOAD_TAG_READINGS_PKG AS

1: PACKAGE BODY MTH_LOAD_TAG_READINGS_PKG AS
2: /*$Header: mthtagb.pls 120.8.12020000.5 2012/10/17 08:00:56 aksachde noship $*/
3:
4: PROCEDURE INIT_READINGS_FROM_RAW(
5: p_from_tz IN VARCHAR2 DEFAULT NULL,

Line 2221: p_ret_code := MTH_LOAD_TAG_READINGS_PKG.MTH_TRANSFORM_TAG_DATA_TO_STG();

2217: IF (v_current_processing_flag=1 OR v_current_processing_flag=2 OR v_reprocess_flag>0 ) THEN
2218:
2219: mth_util_pkg.mth_load_tag_raw_to_processed(v_current_processing_flag, p_from_tz , p_to_tz); --commit to be removed from procedure
2220:
2221: p_ret_code := MTH_LOAD_TAG_READINGS_PKG.MTH_TRANSFORM_TAG_DATA_TO_STG();
2222:
2223: IF (p_ret_code <> 2) THEN
2224:
2225: SELECT Count(*)

Line 2263: p_ret_code := MTH_LOAD_TAG_READINGS_PKG.MTH_READINGS_ERRORS_TO_STG();

2259: IF(p_ret_code <> 2) THEN
2260:
2261: DELETE FROM MTH_TAG_READINGS_RAW_PROCESSED;
2262: MTH_GEN_HDL_EVENTS_READINGS();
2263: p_ret_code := MTH_LOAD_TAG_READINGS_PKG.MTH_READINGS_ERRORS_TO_STG();
2264: IF(p_ret_code <> 2) THEN
2265: mth_util_pkg.log_msg('MTH_READINGS_ERRORS_TO_STG completeled succesfully', mth_util_pkg.G_DBG_PROC_FUN_END);
2266: p_ret_code :=MTH_LOAD_TAG_READINGS_PKG.MTH_TAG_BASED_CONTEXTUALIZE();
2267: IF(p_ret_code <> 2) THEN

Line 2266: p_ret_code :=MTH_LOAD_TAG_READINGS_PKG.MTH_TAG_BASED_CONTEXTUALIZE();

2262: MTH_GEN_HDL_EVENTS_READINGS();
2263: p_ret_code := MTH_LOAD_TAG_READINGS_PKG.MTH_READINGS_ERRORS_TO_STG();
2264: IF(p_ret_code <> 2) THEN
2265: mth_util_pkg.log_msg('MTH_READINGS_ERRORS_TO_STG completeled succesfully', mth_util_pkg.G_DBG_PROC_FUN_END);
2266: p_ret_code :=MTH_LOAD_TAG_READINGS_PKG.MTH_TAG_BASED_CONTEXTUALIZE();
2267: IF(p_ret_code <> 2) THEN
2268: mth_util_pkg.log_msg('MTH_TAG_BASED_CONTEXTUALIZE completeled succesfully', mth_util_pkg.G_DBG_PROC_FUN_END);
2269: p_ret_code :=MTH_LOAD_TAG_READINGS_PKG.MTH_SCHD_BASED_CONTEXTUALIZE();
2270: IF(p_ret_code <> 2) THEN

Line 2269: p_ret_code :=MTH_LOAD_TAG_READINGS_PKG.MTH_SCHD_BASED_CONTEXTUALIZE();

2265: mth_util_pkg.log_msg('MTH_READINGS_ERRORS_TO_STG completeled succesfully', mth_util_pkg.G_DBG_PROC_FUN_END);
2266: p_ret_code :=MTH_LOAD_TAG_READINGS_PKG.MTH_TAG_BASED_CONTEXTUALIZE();
2267: IF(p_ret_code <> 2) THEN
2268: mth_util_pkg.log_msg('MTH_TAG_BASED_CONTEXTUALIZE completeled succesfully', mth_util_pkg.G_DBG_PROC_FUN_END);
2269: p_ret_code :=MTH_LOAD_TAG_READINGS_PKG.MTH_SCHD_BASED_CONTEXTUALIZE();
2270: IF(p_ret_code <> 2) THEN
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

Line 2272: p_ret_code :=MTH_LOAD_TAG_READINGS_PKG.MTH_MANUAL_BASED_CONTEXTUALIZE();

2268: mth_util_pkg.log_msg('MTH_TAG_BASED_CONTEXTUALIZE completeled succesfully', mth_util_pkg.G_DBG_PROC_FUN_END);
2269: p_ret_code :=MTH_LOAD_TAG_READINGS_PKG.MTH_SCHD_BASED_CONTEXTUALIZE();
2270: IF(p_ret_code <> 2) THEN
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);

Line 2346: p_ret_code := MTH_LOAD_TAG_READINGS_PKG.MTH_TRANSFORM_TAG_DATA_TO_STG();

2342: SELECT Count(*) INTO v_reprocess_flag FROM MTH_TAG_READINGS_ERR WHERE RE_PROCESS_FLAG='Y';
2343:
2344: IF(v_current_processing_flag=1 OR v_current_processing_flag=2 OR v_reprocess_flag>0 ) THEN
2345: mth_util_pkg.mth_load_tag_raw_to_processed(v_current_processing_flag, p_from_tz , p_to_tz );
2346: p_ret_code := MTH_LOAD_TAG_READINGS_PKG.MTH_TRANSFORM_TAG_DATA_TO_STG();
2347: IF(p_ret_code <> 2)
2348: THEN
2349: -- Dbms_Output.put_line('p_ret_code1' || p_ret_code);
2350: SELECT Count(*)

Line 2398: p_ret_code := MTH_LOAD_TAG_READINGS_PKG.MTH_READINGS_ERRORS_TO_STG();

2394: IF(p_ret_code <> 2) THEN
2395:
2396: DELETE FROM MTH_TAG_READINGS_RAW_PROCESSED;
2397: MTH_GEN_HDL_EVENTS_READINGS();
2398: p_ret_code := MTH_LOAD_TAG_READINGS_PKG.MTH_READINGS_ERRORS_TO_STG();
2399: IF(p_ret_code <> 2) THEN
2400: mth_util_pkg.log_msg('MTH_READINGS_ERRORS_TO_STG completeled succesfully', mth_util_pkg.G_DBG_PROC_FUN_END);
2401: p_ret_code :=MTH_LOAD_TAG_READINGS_PKG.MTH_TAG_BASED_CONTEXTUALIZE();
2402: IF(p_ret_code <> 2) THEN

Line 2401: p_ret_code :=MTH_LOAD_TAG_READINGS_PKG.MTH_TAG_BASED_CONTEXTUALIZE();

2397: MTH_GEN_HDL_EVENTS_READINGS();
2398: p_ret_code := MTH_LOAD_TAG_READINGS_PKG.MTH_READINGS_ERRORS_TO_STG();
2399: IF(p_ret_code <> 2) THEN
2400: mth_util_pkg.log_msg('MTH_READINGS_ERRORS_TO_STG completeled succesfully', mth_util_pkg.G_DBG_PROC_FUN_END);
2401: p_ret_code :=MTH_LOAD_TAG_READINGS_PKG.MTH_TAG_BASED_CONTEXTUALIZE();
2402: IF(p_ret_code <> 2) THEN
2403: mth_util_pkg.log_msg('MTH_TAG_BASED_CONTEXTUALIZE completeled succesfully', mth_util_pkg.G_DBG_PROC_FUN_END);
2404: p_ret_code :=MTH_LOAD_TAG_READINGS_PKG.MTH_SCHD_BASED_CONTEXTUALIZE();
2405: IF(p_ret_code <> 2) THEN

Line 2404: p_ret_code :=MTH_LOAD_TAG_READINGS_PKG.MTH_SCHD_BASED_CONTEXTUALIZE();

2400: mth_util_pkg.log_msg('MTH_READINGS_ERRORS_TO_STG completeled succesfully', mth_util_pkg.G_DBG_PROC_FUN_END);
2401: p_ret_code :=MTH_LOAD_TAG_READINGS_PKG.MTH_TAG_BASED_CONTEXTUALIZE();
2402: IF(p_ret_code <> 2) THEN
2403: mth_util_pkg.log_msg('MTH_TAG_BASED_CONTEXTUALIZE completeled succesfully', mth_util_pkg.G_DBG_PROC_FUN_END);
2404: p_ret_code :=MTH_LOAD_TAG_READINGS_PKG.MTH_SCHD_BASED_CONTEXTUALIZE();
2405: IF(p_ret_code <> 2) THEN
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

Line 2407: p_ret_code :=MTH_LOAD_TAG_READINGS_PKG.MTH_MANUAL_BASED_CONTEXTUALIZE();

2403: mth_util_pkg.log_msg('MTH_TAG_BASED_CONTEXTUALIZE completeled succesfully', mth_util_pkg.G_DBG_PROC_FUN_END);
2404: p_ret_code :=MTH_LOAD_TAG_READINGS_PKG.MTH_SCHD_BASED_CONTEXTUALIZE();
2405: IF(p_ret_code <> 2) THEN
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);

Line 2488: MTH_LOAD_TAG_READINGS_PKG.mth_recal_tag_raw_to_processed(v_current_processing_flag, p_from_tz , p_to_tz,p_ret_code);

2484: AND o.READING_TIME BETWEEN p_recal_from_date AND nvl(p_recal_to_date,o.READING_TIME);
2485:
2486: mth_util_pkg.log_msg('Number of rows deleted in MTH_TAG_READINGS - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2487:
2488: MTH_LOAD_TAG_READINGS_PKG.mth_recal_tag_raw_to_processed(v_current_processing_flag, p_from_tz , p_to_tz,p_ret_code);
2489: IF(p_ret_code <> 2)
2490: THEN
2491: mth_util_pkg.truncate_table_partition('MTH_TAG_READINGS_RAW' ,v_current_processing_flag);
2492: p_ret_code := MTH_LOAD_TAG_READINGS_PKG.MTH_TRANSFORM_TAG_DATA_TO_STG();

Line 2492: p_ret_code := MTH_LOAD_TAG_READINGS_PKG.MTH_TRANSFORM_TAG_DATA_TO_STG();

2488: MTH_LOAD_TAG_READINGS_PKG.mth_recal_tag_raw_to_processed(v_current_processing_flag, p_from_tz , p_to_tz,p_ret_code);
2489: IF(p_ret_code <> 2)
2490: THEN
2491: mth_util_pkg.truncate_table_partition('MTH_TAG_READINGS_RAW' ,v_current_processing_flag);
2492: p_ret_code := MTH_LOAD_TAG_READINGS_PKG.MTH_TRANSFORM_TAG_DATA_TO_STG();
2493: IF(p_ret_code <> 2)
2494: THEN
2495: SELECT B.DESCRIPTION INTO v_desc FROM FND_LOOKUPS B
2496: WHERE B.LOOKUP_TYPE IN ('MTH_TAG_BUS_RULES_PLSQL_API');

Line 2502: /* p_ret_code := MTH_LOAD_TAG_READINGS_PKG.MTH_READINGS_ERRORS_TO_STG();

2498: EXECUTE IMMEDIATE l_sql_stmt USING OUT v_ret_code;
2499: IF(v_ret_code <> 2)
2500: THEN
2501: DELETE FROM MTH_TAG_READINGS_RAW_PROCESSED ;
2502: /* p_ret_code := MTH_LOAD_TAG_READINGS_PKG.MTH_READINGS_ERRORS_TO_STG();
2503: IF(p_ret_code <> 2)
2504: THEN */
2505: p_ret_code :=MTH_LOAD_TAG_READINGS_PKG.MTH_TAG_BASED_CONTEXTUALIZE();
2506: IF(p_ret_code <> 2)

Line 2505: p_ret_code :=MTH_LOAD_TAG_READINGS_PKG.MTH_TAG_BASED_CONTEXTUALIZE();

2501: DELETE FROM MTH_TAG_READINGS_RAW_PROCESSED ;
2502: /* p_ret_code := MTH_LOAD_TAG_READINGS_PKG.MTH_READINGS_ERRORS_TO_STG();
2503: IF(p_ret_code <> 2)
2504: THEN */
2505: p_ret_code :=MTH_LOAD_TAG_READINGS_PKG.MTH_TAG_BASED_CONTEXTUALIZE();
2506: IF(p_ret_code <> 2)
2507: THEN
2508: p_ret_code :=MTH_LOAD_TAG_READINGS_PKG.MTH_SCHD_BASED_CONTEXTUALIZE();
2509: IF(p_ret_code <> 2)

Line 2508: p_ret_code :=MTH_LOAD_TAG_READINGS_PKG.MTH_SCHD_BASED_CONTEXTUALIZE();

2504: THEN */
2505: p_ret_code :=MTH_LOAD_TAG_READINGS_PKG.MTH_TAG_BASED_CONTEXTUALIZE();
2506: IF(p_ret_code <> 2)
2507: THEN
2508: p_ret_code :=MTH_LOAD_TAG_READINGS_PKG.MTH_SCHD_BASED_CONTEXTUALIZE();
2509: IF(p_ret_code <> 2)
2510: THEN
2511: p_ret_code :=MTH_LOAD_TAG_READINGS_PKG.MTH_MANUAL_BASED_CONTEXTUALIZE();
2512: IF(p_ret_code <> 2)

Line 2511: p_ret_code :=MTH_LOAD_TAG_READINGS_PKG.MTH_MANUAL_BASED_CONTEXTUALIZE();

2507: THEN
2508: p_ret_code :=MTH_LOAD_TAG_READINGS_PKG.MTH_SCHD_BASED_CONTEXTUALIZE();
2509: IF(p_ret_code <> 2)
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);

Line 2540: END MTH_LOAD_TAG_READINGS_PKG;

2536:
2537:
2538:
2539:
2540: END MTH_LOAD_TAG_READINGS_PKG;