[Home] [Help]
162: INTO l_reading_time
163: FROM mth_equip_output_stg
164: FOR UPDATE OF reading_time;
165:
166: MTH_PROCESS_OUTPUT_PKG.VALIDATE(p_mode,
167: p_source,
168: l_retcode,
169: l_err_buff
170: );
197: END IF;
198: END IF;
199:
200: IF (p_source IN ('CSVO','CSVSO') ) THEN
201: MTH_PROCESS_OUTPUT_PKG.PROCESS_OUTPUT( p_mode,
202: p_source,
203: l_recal_from_date,
204: l_recal_to_date,
205: p_equipment_pk_key,
251: FROM mth_run_log
252: WHERE fact_table = 'MTH_EQUIP_OUTPUT_SUMMARY'
253: FOR UPDATE OF from_date;
254:
255: MTH_PROCESS_OUTPUT_PKG.PROCESS_OUTPUT_SUMMARY( p_mode,
256: l_recal_from_date,
257: l_recal_to_date,
258: p_equipment_pk_key,
259: p_plant_pk_key,
304: IF(l_retcode = 1) THEN
305: l_ret_code := l_retcode;
306: END IF;
307:
308: MTH_PROCESS_OUTPUT_PKG.PROCESS_OUTPUT( p_mode,
309: p_source,
310: l_recal_from_date,
311: l_recal_to_date,
312: p_equipment_pk_key,
338: END IF;
339:
340:
341:
342: MTH_PROCESS_OUTPUT_PKG.PROCESS_OUTPUT_SUMMARY( p_mode,
343: l_recal_from_date,
344: l_recal_to_date,
345: p_equipment_pk_key,
346: p_plant_pk_key,
416: END IF;
417: END IF;
418:
419: IF (p_source IN ('CSVO','CSVSO') ) THEN
420: MTH_PROCESS_OUTPUT_PKG.PROCESS_OUTPUT( p_mode,
421: p_source,
422: l_recal_from_date,
423: l_recal_to_date,
424: p_equipment_pk_key,
451: END IF;
452: END IF;
453:
454: IF (p_source IN ('CSVO','CSVSO') ) THEN
455: MTH_PROCESS_OUTPUT_PKG.PROCESS_OUTPUT_SUMMARY( p_mode,
456: l_recal_from_date,
457: l_recal_to_date,
458: p_equipment_pk_key,
459: p_plant_pk_key,