DBA Data[Home] [Help]

APPS.MTH_PROCESS_UDA_PKG dependencies on MTH_RUN_LOG

Line 108: MTH_RUN_LOG RUN_LOG

104:
105: SELECT Count(1)
106: INTO v_tag_reading_count
107: FROM MTH_TAG_READINGS TAG,
108: MTH_RUN_LOG RUN_LOG
109: WHERE
110: (TAG.CREATION_DATE < p_recal_from_date
111: AND TAG.CREATION_DATE > p_recal_to_date)
112: OR TAG.last_update_date >= RUN_LOG.FROM_DATE;

Line 173: -- Call mth_run_log_pre_load

169: -- Initialize default parameters
170: v_log_to_date := sysdate;
171: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
172:
173: -- Call mth_run_log_pre_load
174: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENTS_EXT_B',v_unassigned_val,'INCR',NULL,0,v_log_to_date);
175:
176: -- Call GET_RUN_LOG_DATES
177: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIPMENTS_EXT_B',NULL,NULL,NULL,v_log_from_date,v_log_to_date);

Line 174: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENTS_EXT_B',v_unassigned_val,'INCR',NULL,0,v_log_to_date);

170: v_log_to_date := sysdate;
171: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
172:
173: -- Call mth_run_log_pre_load
174: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENTS_EXT_B',v_unassigned_val,'INCR',NULL,0,v_log_to_date);
175:
176: -- Call GET_RUN_LOG_DATES
177: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIPMENTS_EXT_B',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
178: mth_util_pkg.log_msg('v_log_from_date : '||v_log_from_date, mth_util_pkg.G_DBG_PROC_FUN_START);

Line 208: MTH_RUN_LOG RUN_LOG,

204: TAG.TAG_DATA,
205: EGO.DATABASE_COLUMN,
206: TAG.ATTRIBUTE_GROUP
207: FROM MTH_TAG_READINGS TAG,
208: MTH_RUN_LOG RUN_LOG,
209: EGO_ATTRS_V EGO,
210: EGO_ATTR_GROUPS_V EGO_ATTR_GRP
211: WHERE RUN_LOG.FACT_TABLE = 'MTH_EQUIPMENTS_EXT_B'
212: AND TAG.creation_date >= RUN_LOG.from_date

Line 237: ----Call mth_run_log_post_load

233:
234: TB_UPLOAD_NO_COMMIT();
235: p_retcode := 0;
236:
237: ----Call mth_run_log_post_load
238: mth_util_pkg.mth_run_log_post_load('MTH_EQUIPMENTS_EXT_B',v_unassigned_val);
239:
240: mth_util_pkg.log_msg('PROCESS_EQUIPUDA_IN_INCR_MODE end', mth_util_pkg.G_DBG_PROC_FUN_START);
241:

Line 238: mth_util_pkg.mth_run_log_post_load('MTH_EQUIPMENTS_EXT_B',v_unassigned_val);

234: TB_UPLOAD_NO_COMMIT();
235: p_retcode := 0;
236:
237: ----Call mth_run_log_post_load
238: mth_util_pkg.mth_run_log_post_load('MTH_EQUIPMENTS_EXT_B',v_unassigned_val);
239:
240: mth_util_pkg.log_msg('PROCESS_EQUIPUDA_IN_INCR_MODE end', mth_util_pkg.G_DBG_PROC_FUN_START);
241:
242: EXCEPTION

Line 303: MTH_RUN_LOG RUN_LOG,

299: TAG.TAG_DATA,
300: EGO.DATABASE_COLUMN,
301: TAG.GROUP_ID
302: FROM MTH_TAG_READINGS TAG,
303: MTH_RUN_LOG RUN_LOG,
304: EGO_ATTRS_V EGO,
305: EGO_ATTR_GROUPS_V EGO_ATTR_GRP
306: WHERE RUN_LOG.FACT_TABLE = 'MTH_EQUIPMENTS_EXT_B'
307: AND TAG.EQUIPMENT_FK_KEY = NVL(p_equipment_pk_key, TAG.EQUIPMENT_FK_KEY)