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_EQUIPMENT_PKG dependencies on MTH_RUN_LOG

Line 52: -- Call mth_run_log_pre_load

48:
49:
50: IF (v_error_code_1 IS NULL AND v_error_code_2 IS NULL ) THEN
51:
52: -- Call mth_run_log_pre_load
53: -- mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENT_DENORM_D',v_unassigned_val,'INCR',NULL,0,v_log_date);
54: -- Moved to call to inside MTH_POPULATE_EQUIP_DENORM
55:
56: -- call the procedure to populate entries into denorm table if the validations are successful

Line 53: -- mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENT_DENORM_D',v_unassigned_val,'INCR',NULL,0,v_log_date);

49:
50: IF (v_error_code_1 IS NULL AND v_error_code_2 IS NULL ) THEN
51:
52: -- Call mth_run_log_pre_load
53: -- mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENT_DENORM_D',v_unassigned_val,'INCR',NULL,0,v_log_date);
54: -- Moved to call to inside MTH_POPULATE_EQUIP_DENORM
55:
56: -- call the procedure to populate entries into denorm table if the validations are successful
57: MTH_POPULATE_EQUIP_DENORM();

Line 59: -- Call mth_run_log_post_load

55:
56: -- call the procedure to populate entries into denorm table if the validations are successful
57: MTH_POPULATE_EQUIP_DENORM();
58:
59: -- Call mth_run_log_post_load
60: mth_util_pkg.mth_run_log_post_load('MTH_EQUIPMENT_DENORM_D',v_unassigned_val);
61:
62: ELSE
63: mth_util_pkg.log_msg('Validations failed. Check log for more details',mth_util_pkg.G_DBG_EXCEPTION);

Line 60: mth_util_pkg.mth_run_log_post_load('MTH_EQUIPMENT_DENORM_D',v_unassigned_val);

56: -- call the procedure to populate entries into denorm table if the validations are successful
57: MTH_POPULATE_EQUIP_DENORM();
58:
59: -- Call mth_run_log_post_load
60: mth_util_pkg.mth_run_log_post_load('MTH_EQUIPMENT_DENORM_D',v_unassigned_val);
61:
62: ELSE
63: mth_util_pkg.log_msg('Validations failed. Check log for more details',mth_util_pkg.G_DBG_EXCEPTION);
64: END IF;

Line 258: FROM mth_run_log

254: SELECT Count(*) record_count
255: FROM mth_equip_hierarchy h,
256: mth_equipment_denorm_d d,
257: (SELECT Min(from_date) from_date
258: FROM mth_run_log
259: WHERE fact_table = 'MTH_EQUIPMENT_DENORM_D') r
260: WHERE h.creation_date > r.from_date
261: AND h.level_num <= 10
262: AND d.level_num >= h.level_num

Line 334: FROM mth_run_log

330: 10,d.equipment_effective_date) child_effective_date
331: FROM mth_equip_hierarchy h,
332: mth_equipment_denorm_d d,
333: (SELECT Min(from_date) from_date
334: FROM mth_run_log
335: WHERE fact_table = 'MTH_EQUIPMENT_DENORM_D') r
336: WHERE h.creation_date > r.from_date
337: AND h.level_num <= 10
338: AND d.level_num >= h.level_num

Line 456: MTH_RUN_LOG.FROM_DATE,

452: ORDER BY group_id )) - 1/(24*60*60) expiration_date
453: FROM mth_equip_hierarchy) equip_hierarchy /*,
454: (SELECT
455: DISTINCT
456: MTH_RUN_LOG.FROM_DATE,
457: MTH_RUN_LOG.TO_DATE
458: FROM
459: MTH_RUN_LOG
460: WHERE

Line 457: MTH_RUN_LOG.TO_DATE

453: FROM mth_equip_hierarchy) equip_hierarchy /*,
454: (SELECT
455: DISTINCT
456: MTH_RUN_LOG.FROM_DATE,
457: MTH_RUN_LOG.TO_DATE
458: FROM
459: MTH_RUN_LOG
460: WHERE
461: (MTH_RUN_LOG.FACT_TABLE = 'MTH_EQUIPMENT_DENORM_D')) denorm_run_log */

Line 459: MTH_RUN_LOG

455: DISTINCT
456: MTH_RUN_LOG.FROM_DATE,
457: MTH_RUN_LOG.TO_DATE
458: FROM
459: MTH_RUN_LOG
460: WHERE
461: (MTH_RUN_LOG.FACT_TABLE = 'MTH_EQUIPMENT_DENORM_D')) denorm_run_log */
462: WHERE equip_hierarchy.creation_date > p_from_date
463: AND equip_hierarchy.creation_date <= p_to_date

Line 461: (MTH_RUN_LOG.FACT_TABLE = 'MTH_EQUIPMENT_DENORM_D')) denorm_run_log */

457: MTH_RUN_LOG.TO_DATE
458: FROM
459: MTH_RUN_LOG
460: WHERE
461: (MTH_RUN_LOG.FACT_TABLE = 'MTH_EQUIPMENT_DENORM_D')) denorm_run_log */
462: WHERE equip_hierarchy.creation_date > p_from_date
463: AND equip_hierarchy.creation_date <= p_to_date
464: --ORDER BY HIERARCHY_ID, GROUP_ID, LEVEL_NUM ;
465: ORDER BY HIERARCHY_ID, EFFECTIVE_DATE, LEVEL_NUM, GROUP_ID ;

Line 477: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENT_DENORM_D',v_unassigned_val,'INCR',NULL,0,v_log_to_date);

473: -- Initialize default parameters
474: v_log_to_date := sysdate;
475: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
476:
477: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENT_DENORM_D',v_unassigned_val,'INCR',NULL,0,v_log_to_date);
478: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIPMENT_DENORM_D',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
479:
480:
481: open c_equip_hierarchy(v_log_from_date,v_log_to_date);

Line 1498: -- Call mth_run_log_pre_load

1494: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
1495:
1496: mth_util_pkg.log_msg('MTH_EQUIP_HRCHY_UA_MAP start', mth_util_pkg.G_DBG_PROC_FUN_START);
1497:
1498: -- Call mth_run_log_pre_load
1499: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIP_HRCHY_UA_MAP',v_unassigned_val,NULL,NULL,0,v_log_to_date);
1500:
1501: -- Call GET_RUN_LOG_DATES
1502: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIP_HRCHY_UA_MAP',NULL,NULL,NULL,v_log_from_date,v_log_to_date);

Line 1499: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIP_HRCHY_UA_MAP',v_unassigned_val,NULL,NULL,0,v_log_to_date);

1495:
1496: mth_util_pkg.log_msg('MTH_EQUIP_HRCHY_UA_MAP start', mth_util_pkg.G_DBG_PROC_FUN_START);
1497:
1498: -- Call mth_run_log_pre_load
1499: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIP_HRCHY_UA_MAP',v_unassigned_val,NULL,NULL,0,v_log_to_date);
1500:
1501: -- Call GET_RUN_LOG_DATES
1502: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIP_HRCHY_UA_MAP',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
1503:

Line 1701: ----Call mth_run_log_post_load

1697: 1)
1698: ;
1699: mth_util_pkg.log_msg('Number of rows merged in MTH_EQUIP_HIERARCHY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1700:
1701: ----Call mth_run_log_post_load
1702: mth_util_pkg.mth_run_log_post_load('MTH_EQUIP_HRCHY_UA_MAP',v_unassigned_val);
1703:
1704: mth_util_pkg.log_msg('MTH_EQUIP_HRCHY_UA_MAP end', mth_util_pkg.G_DBG_PROC_FUN_END);
1705: COMMIT;

Line 1702: mth_util_pkg.mth_run_log_post_load('MTH_EQUIP_HRCHY_UA_MAP',v_unassigned_val);

1698: ;
1699: mth_util_pkg.log_msg('Number of rows merged in MTH_EQUIP_HIERARCHY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1700:
1701: ----Call mth_run_log_post_load
1702: mth_util_pkg.mth_run_log_post_load('MTH_EQUIP_HRCHY_UA_MAP',v_unassigned_val);
1703:
1704: mth_util_pkg.log_msg('MTH_EQUIP_HRCHY_UA_MAP end', mth_util_pkg.G_DBG_PROC_FUN_END);
1705: COMMIT;
1706: EXCEPTION