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.

[Home] [Help]

APPS.MTH_MV_TO_FACT_PKG dependencies on MTH_UTIL_PKG

Line 21: mth_util_pkg.log_msg('MTH_POPULATE_EQUIP_HRCHY_MV start', mth_util_pkg.G_DBG_PROC_FUN_START);

17: v_log_to_date DATE;
18: v_unassigned_val VARCHAR2(30);
19:
20: BEGIN
21: mth_util_pkg.log_msg('MTH_POPULATE_EQUIP_HRCHY_MV start', mth_util_pkg.G_DBG_PROC_FUN_START);
22:
23: -- Initialize default parameters
24: v_log_to_date := sysdate;
25: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;

Line 25: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;

21: mth_util_pkg.log_msg('MTH_POPULATE_EQUIP_HRCHY_MV start', mth_util_pkg.G_DBG_PROC_FUN_START);
22:
23: -- Initialize default parameters
24: v_log_to_date := sysdate;
25: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
26:
27: -- Call mth_run_log_pre_load
28: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENT_DENORM_D_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date);
29: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIPMENT_DENORM_D_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);

Line 28: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENT_DENORM_D_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date);

24: v_log_to_date := sysdate;
25: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
26:
27: -- Call mth_run_log_pre_load
28: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENT_DENORM_D_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date);
29: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIPMENT_DENORM_D_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
30: mth_util_pkg.log_msg('v_log_from_date - ' || to_char(v_log_from_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
31: mth_util_pkg.log_msg('v_log_to_date - ' || to_char(v_log_to_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
32:

Line 29: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIPMENT_DENORM_D_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);

25: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
26:
27: -- Call mth_run_log_pre_load
28: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENT_DENORM_D_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date);
29: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIPMENT_DENORM_D_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
30: mth_util_pkg.log_msg('v_log_from_date - ' || to_char(v_log_from_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
31: mth_util_pkg.log_msg('v_log_to_date - ' || to_char(v_log_to_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
32:
33: -- Update the Resource cost and other columns on the equipment shifts table

Line 30: mth_util_pkg.log_msg('v_log_from_date - ' || to_char(v_log_from_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);

26:
27: -- Call mth_run_log_pre_load
28: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENT_DENORM_D_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date);
29: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIPMENT_DENORM_D_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
30: mth_util_pkg.log_msg('v_log_from_date - ' || to_char(v_log_from_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
31: mth_util_pkg.log_msg('v_log_to_date - ' || to_char(v_log_to_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
32:
33: -- Update the Resource cost and other columns on the equipment shifts table
34:

Line 31: mth_util_pkg.log_msg('v_log_to_date - ' || to_char(v_log_to_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);

27: -- Call mth_run_log_pre_load
28: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENT_DENORM_D_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date);
29: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIPMENT_DENORM_D_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
30: mth_util_pkg.log_msg('v_log_from_date - ' || to_char(v_log_from_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
31: mth_util_pkg.log_msg('v_log_to_date - ' || to_char(v_log_to_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
32:
33: -- Update the Resource cost and other columns on the equipment shifts table
34:
35: MERGE

Line 117: mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIPMENT_SHIFTS_D - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

113: LAST_UPDATE_LOGIN = MERGE_EQUIP_SHIFTS_SQ.LAST_UPDATE_LOGIN,
114: RESOURCE_FK_KEY = MERGE_EQUIP_SHIFTS_SQ.RESOURCE_FK_KEY,
115: RESOURCE_COST = MERGE_EQUIP_SHIFTS_SQ.COST ;
116:
117: mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIPMENT_SHIFTS_D - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
118:
119: -- Update the Resource cost and other columns on the output summary table
120:
121: MERGE

Line 202: mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_OUTPUT_SUMMARY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

198: RESOURCE_FK_KEY = MERGE_EQUIP_OUTPUT_SQ.RESOURCE_FK_KEY,
199: RESOURCE_COST = MERGE_EQUIP_OUTPUT_SQ.COST ;
200:
201:
202: mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_OUTPUT_SUMMARY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
203:
204: -- Update the Resource cost and other columns on the status summary table
205:
206: MERGE

Line 287: mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_STATUS_SUMMARY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

283: RESOURCE_FK_KEY = MERGE_EQUIP_STATUS_SQ.RESOURCE_FK_KEY,
284: RESOURCE_COST = MERGE_EQUIP_STATUS_SQ.COST ;
285:
286:
287: mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_STATUS_SUMMARY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
288:
289:
290:
291:

Line 293: mth_util_pkg.mth_run_log_post_load('MTH_EQUIPMENT_DENORM_D_MV',v_unassigned_val);

289:
290:
291:
292: ----Call mth_run_log_post_load
293: mth_util_pkg.mth_run_log_post_load('MTH_EQUIPMENT_DENORM_D_MV',v_unassigned_val);
294:
295: COMMIT;
296: mth_util_pkg.log_msg('MTH_POPULATE_EQUIP_HRCHY_MV end', mth_util_pkg.G_DBG_PROC_FUN_END);
297: EXCEPTION

Line 296: mth_util_pkg.log_msg('MTH_POPULATE_EQUIP_HRCHY_MV end', mth_util_pkg.G_DBG_PROC_FUN_END);

292: ----Call mth_run_log_post_load
293: mth_util_pkg.mth_run_log_post_load('MTH_EQUIPMENT_DENORM_D_MV',v_unassigned_val);
294:
295: COMMIT;
296: mth_util_pkg.log_msg('MTH_POPULATE_EQUIP_HRCHY_MV end', mth_util_pkg.G_DBG_PROC_FUN_END);
297: EXCEPTION
298: WHEN OTHERS THEN
299: mth_util_pkg.log_msg('Exception OTHERS in MTH_EQUIP_HRCHY_MV_ALL_MAP', mth_util_pkg.G_DBG_EXCEPTION);
300: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);

Line 299: mth_util_pkg.log_msg('Exception OTHERS in MTH_EQUIP_HRCHY_MV_ALL_MAP', mth_util_pkg.G_DBG_EXCEPTION);

295: COMMIT;
296: mth_util_pkg.log_msg('MTH_POPULATE_EQUIP_HRCHY_MV end', mth_util_pkg.G_DBG_PROC_FUN_END);
297: EXCEPTION
298: WHEN OTHERS THEN
299: mth_util_pkg.log_msg('Exception OTHERS in MTH_EQUIP_HRCHY_MV_ALL_MAP', mth_util_pkg.G_DBG_EXCEPTION);
300: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
301: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
302: ROLLBACK;
303: RAISE;

Line 300: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);

296: mth_util_pkg.log_msg('MTH_POPULATE_EQUIP_HRCHY_MV end', mth_util_pkg.G_DBG_PROC_FUN_END);
297: EXCEPTION
298: WHEN OTHERS THEN
299: mth_util_pkg.log_msg('Exception OTHERS in MTH_EQUIP_HRCHY_MV_ALL_MAP', mth_util_pkg.G_DBG_EXCEPTION);
300: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
301: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
302: ROLLBACK;
303: RAISE;
304: END MTH_POPULATE_EQUIP_HRCHY_MV;

Line 301: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);

297: EXCEPTION
298: WHEN OTHERS THEN
299: mth_util_pkg.log_msg('Exception OTHERS in MTH_EQUIP_HRCHY_MV_ALL_MAP', mth_util_pkg.G_DBG_EXCEPTION);
300: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
301: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
302: ROLLBACK;
303: RAISE;
304: END MTH_POPULATE_EQUIP_HRCHY_MV;
305:

Line 323: mth_util_pkg.log_msg('MTH_POPULATE_PROD_SCHD_MV start', mth_util_pkg.G_DBG_PROC_FUN_START);

319: v_log_to_date DATE;
320: v_unassigned_val VARCHAR2(30);
321:
322: BEGIN
323: mth_util_pkg.log_msg('MTH_POPULATE_PROD_SCHD_MV start', mth_util_pkg.G_DBG_PROC_FUN_START);
324:
325: -- Initialize default parameters
326: v_log_to_date := sysdate;
327: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;

Line 327: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;

323: mth_util_pkg.log_msg('MTH_POPULATE_PROD_SCHD_MV start', mth_util_pkg.G_DBG_PROC_FUN_START);
324:
325: -- Initialize default parameters
326: v_log_to_date := sysdate;
327: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
328:
329: -- Call mth_run_log_pre_load
330: mth_util_pkg.mth_run_log_pre_load('MTH_PRODUCTION_SCHEDULES_F_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date);
331: mth_util_pkg.GET_RUN_LOG_DATES('MTH_PRODUCTION_SCHEDULES_F_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);

Line 330: mth_util_pkg.mth_run_log_pre_load('MTH_PRODUCTION_SCHEDULES_F_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date);

326: v_log_to_date := sysdate;
327: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
328:
329: -- Call mth_run_log_pre_load
330: mth_util_pkg.mth_run_log_pre_load('MTH_PRODUCTION_SCHEDULES_F_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date);
331: mth_util_pkg.GET_RUN_LOG_DATES('MTH_PRODUCTION_SCHEDULES_F_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
332: mth_util_pkg.log_msg('v_log_from_date - ' || to_char(v_log_from_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
333: mth_util_pkg.log_msg('v_log_to_date - ' || to_char(v_log_to_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
334:

Line 331: mth_util_pkg.GET_RUN_LOG_DATES('MTH_PRODUCTION_SCHEDULES_F_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);

327: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
328:
329: -- Call mth_run_log_pre_load
330: mth_util_pkg.mth_run_log_pre_load('MTH_PRODUCTION_SCHEDULES_F_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date);
331: mth_util_pkg.GET_RUN_LOG_DATES('MTH_PRODUCTION_SCHEDULES_F_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
332: mth_util_pkg.log_msg('v_log_from_date - ' || to_char(v_log_from_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
333: mth_util_pkg.log_msg('v_log_to_date - ' || to_char(v_log_to_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
334:
335:

Line 332: mth_util_pkg.log_msg('v_log_from_date - ' || to_char(v_log_from_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);

328:
329: -- Call mth_run_log_pre_load
330: mth_util_pkg.mth_run_log_pre_load('MTH_PRODUCTION_SCHEDULES_F_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date);
331: mth_util_pkg.GET_RUN_LOG_DATES('MTH_PRODUCTION_SCHEDULES_F_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
332: mth_util_pkg.log_msg('v_log_from_date - ' || to_char(v_log_from_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
333: mth_util_pkg.log_msg('v_log_to_date - ' || to_char(v_log_to_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
334:
335:
336: -- Update the Prod Schedule and other columns on the Equip Prod Schedule table

Line 333: mth_util_pkg.log_msg('v_log_to_date - ' || to_char(v_log_to_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);

329: -- Call mth_run_log_pre_load
330: mth_util_pkg.mth_run_log_pre_load('MTH_PRODUCTION_SCHEDULES_F_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date);
331: mth_util_pkg.GET_RUN_LOG_DATES('MTH_PRODUCTION_SCHEDULES_F_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
332: mth_util_pkg.log_msg('v_log_from_date - ' || to_char(v_log_from_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
333: mth_util_pkg.log_msg('v_log_to_date - ' || to_char(v_log_to_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
334:
335:
336: -- Update the Prod Schedule and other columns on the Equip Prod Schedule table
337:

Line 375: mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_PROD_SCHEDULE0_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

371: MEPSF.LAST_UPDATED_BY = MERGE_EQUIP_PROD_SCHEDULE_SQ.LAST_UPDATED_BY,
372: MEPSF.LAST_UPDATE_LOGIN = MERGE_EQUIP_PROD_SCHEDULE_SQ.LAST_UPDATE_LOGIN,
373: MEPSF.STATUS_CODE = MERGE_EQUIP_PROD_SCHEDULE_SQ.STATUS_CODE;
374:
375: mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_PROD_SCHEDULE0_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
376:
377: -- Update the Prod Schedule and other columns on the Resource Transaction table
378:
379: MERGE

Line 422: mth_util_pkg.log_msg('Number of rows updated in MTH_RESOURCE_TXN_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

418: MRTF.PLANNED_COMPLETION_DATE = MERGE_RESOURCE_TXN_SQ.PLANNED_COMPLETION_DATE,
419: MRTF.ACTUAL_START_DATE = MERGE_RESOURCE_TXN_SQ.ACTUAL_START_DATE,
420: MRTF.ACTUAL_COMPLETION_DATE = MERGE_RESOURCE_TXN_SQ.ACTUAL_COMPLETION_DATE;
421:
422: mth_util_pkg.log_msg('Number of rows updated in MTH_RESOURCE_TXN_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
423:
424:
425: -- Update the Prod Schedule and other columns on the WO Sales Orders table
426:

Line 470: mth_util_pkg.log_msg('Number of rows updated in MTH_WO_SALES_ORDERS_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

466: MWSOF.PLANNED_COMPLETION_DATE = MERGE_WO_SALES_ORDERS_SQ.PLANNED_COMPLETION_DATE,
467: MWSOF.ACTUAL_START_DATE = MERGE_WO_SALES_ORDERS_SQ.ACTUAL_START_DATE,
468: MWSOF.ACTUAL_COMPLETION_DATE = MERGE_WO_SALES_ORDERS_SQ.ACTUAL_COMPLETION_DATE;
469:
470: mth_util_pkg.log_msg('Number of rows updated in MTH_WO_SALES_ORDERS_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
471:
472: -- Update the Prod Schedule and other columns on the Resource Requirement table
473:
474: MERGE

Line 517: mth_util_pkg.log_msg('Number of rows updated in MTH_RESOURCE_REQUIREMENTS_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

513: MRRF.PLANNED_COMPLETION_DATE = MERGE_RESOURCE_REQUIREMENTS_SQ.PLANNED_COMPLETION_DATE,
514: MRRF.ACTUAL_START_DATE = MERGE_RESOURCE_REQUIREMENTS_SQ.ACTUAL_START_DATE,
515: MRRF.ACTUAL_COMPLETION_DATE = MERGE_RESOURCE_REQUIREMENTS_SQ.ACTUAL_COMPLETION_DATE;
516:
517: mth_util_pkg.log_msg('Number of rows updated in MTH_RESOURCE_REQUIREMENTS_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
518:
519:
520: -- Update the Prod Schedule and other columns on the Prod MTL Consumed table
521:

Line 565: mth_util_pkg.log_msg('Number of rows updated in MTH_PROD_MTL_CONSUMED_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

561: MPMCF.PLANNED_COMPLETION_DATE = MERGE_PROD_MTL_CONSUMED_SQ.PLANNED_COMPLETION_DATE,
562: MPMCF.ACTUAL_START_DATE = MERGE_PROD_MTL_CONSUMED_SQ.ACTUAL_START_DATE,
563: MPMCF.ACTUAL_COMPLETION_DATE = MERGE_PROD_MTL_CONSUMED_SQ.ACTUAL_COMPLETION_DATE;
564:
565: mth_util_pkg.log_msg('Number of rows updated in MTH_PROD_MTL_CONSUMED_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
566:
567:
568: -- Update the Prod Schedule and other columns on the Prod MTL Produced table
569:

Line 615: mth_util_pkg.log_msg('Number of rows updated in MTH_PROD_MTL_PRODUCED_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

611: MPMPF.ACTUAL_START_DATE = MERGE_PROD_MTL_PRODUCED_SQ.ACTUAL_START_DATE,
612: MPMPF.ACTUAL_COMPLETION_DATE = MERGE_PROD_MTL_PRODUCED_SQ.ACTUAL_COMPLETION_DATE,
613: MPMPF.STATUS_CODE = MERGE_PROD_MTL_PRODUCED_SQ.STATUS_CODE;
614:
615: mth_util_pkg.log_msg('Number of rows updated in MTH_PROD_MTL_PRODUCED_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
616:
617: ----Call mth_run_log_post_load
618: mth_util_pkg.mth_run_log_post_load('MTH_PRODUCTION_SCHEDULES_F_MV',v_unassigned_val);
619:

Line 618: mth_util_pkg.mth_run_log_post_load('MTH_PRODUCTION_SCHEDULES_F_MV',v_unassigned_val);

614:
615: mth_util_pkg.log_msg('Number of rows updated in MTH_PROD_MTL_PRODUCED_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
616:
617: ----Call mth_run_log_post_load
618: mth_util_pkg.mth_run_log_post_load('MTH_PRODUCTION_SCHEDULES_F_MV',v_unassigned_val);
619:
620: COMMIT;
621: mth_util_pkg.log_msg('MTH_POPULATE_PROD_SCHD_MV end', mth_util_pkg.G_DBG_PROC_FUN_END);
622: EXCEPTION

Line 621: mth_util_pkg.log_msg('MTH_POPULATE_PROD_SCHD_MV end', mth_util_pkg.G_DBG_PROC_FUN_END);

617: ----Call mth_run_log_post_load
618: mth_util_pkg.mth_run_log_post_load('MTH_PRODUCTION_SCHEDULES_F_MV',v_unassigned_val);
619:
620: COMMIT;
621: mth_util_pkg.log_msg('MTH_POPULATE_PROD_SCHD_MV end', mth_util_pkg.G_DBG_PROC_FUN_END);
622: EXCEPTION
623: WHEN OTHERS THEN
624: mth_util_pkg.log_msg('Exception OTHERS in MTH_PROD_SCHD_MV_ALL_MAP', mth_util_pkg.G_DBG_EXCEPTION);
625: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);

Line 624: mth_util_pkg.log_msg('Exception OTHERS in MTH_PROD_SCHD_MV_ALL_MAP', mth_util_pkg.G_DBG_EXCEPTION);

620: COMMIT;
621: mth_util_pkg.log_msg('MTH_POPULATE_PROD_SCHD_MV end', mth_util_pkg.G_DBG_PROC_FUN_END);
622: EXCEPTION
623: WHEN OTHERS THEN
624: mth_util_pkg.log_msg('Exception OTHERS in MTH_PROD_SCHD_MV_ALL_MAP', mth_util_pkg.G_DBG_EXCEPTION);
625: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
626: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
627: ROLLBACK;
628: RAISE;

Line 625: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);

621: mth_util_pkg.log_msg('MTH_POPULATE_PROD_SCHD_MV end', mth_util_pkg.G_DBG_PROC_FUN_END);
622: EXCEPTION
623: WHEN OTHERS THEN
624: mth_util_pkg.log_msg('Exception OTHERS in MTH_PROD_SCHD_MV_ALL_MAP', mth_util_pkg.G_DBG_EXCEPTION);
625: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
626: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
627: ROLLBACK;
628: RAISE;
629: END MTH_POPULATE_PROD_SCHD_MV;

Line 626: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);

622: EXCEPTION
623: WHEN OTHERS THEN
624: mth_util_pkg.log_msg('Exception OTHERS in MTH_PROD_SCHD_MV_ALL_MAP', mth_util_pkg.G_DBG_EXCEPTION);
625: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
626: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
627: ROLLBACK;
628: RAISE;
629: END MTH_POPULATE_PROD_SCHD_MV;
630:

Line 649: mth_util_pkg.log_msg('MTH_POPULATE_EQP_STD_RATES_MV start', mth_util_pkg.G_DBG_PROC_FUN_START);

645: v_log_to_date DATE;
646: v_unassigned_val VARCHAR2(30);
647:
648: BEGIN
649: mth_util_pkg.log_msg('MTH_POPULATE_EQP_STD_RATES_MV start', mth_util_pkg.G_DBG_PROC_FUN_START);
650:
651: -- Initialize default parameters
652: v_log_to_date := sysdate;
653: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;

Line 653: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;

649: mth_util_pkg.log_msg('MTH_POPULATE_EQP_STD_RATES_MV start', mth_util_pkg.G_DBG_PROC_FUN_START);
650:
651: -- Initialize default parameters
652: v_log_to_date := sysdate;
653: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
654:
655: -- Call mth_run_log_pre_load
656: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIP_STD_RATES_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date);
657: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIP_STD_RATES_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);

Line 656: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIP_STD_RATES_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date);

652: v_log_to_date := sysdate;
653: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
654:
655: -- Call mth_run_log_pre_load
656: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIP_STD_RATES_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date);
657: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIP_STD_RATES_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
658: mth_util_pkg.log_msg('v_log_from_date - ' || to_char(v_log_from_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
659: mth_util_pkg.log_msg('v_log_to_date - ' || to_char(v_log_to_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
660:

Line 657: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIP_STD_RATES_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);

653: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
654:
655: -- Call mth_run_log_pre_load
656: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIP_STD_RATES_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date);
657: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIP_STD_RATES_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
658: mth_util_pkg.log_msg('v_log_from_date - ' || to_char(v_log_from_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
659: mth_util_pkg.log_msg('v_log_to_date - ' || to_char(v_log_to_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
660:
661: -- Update the standard rates and other columns on the euip production schedule table

Line 658: mth_util_pkg.log_msg('v_log_from_date - ' || to_char(v_log_from_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);

654:
655: -- Call mth_run_log_pre_load
656: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIP_STD_RATES_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date);
657: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIP_STD_RATES_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
658: mth_util_pkg.log_msg('v_log_from_date - ' || to_char(v_log_from_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
659: mth_util_pkg.log_msg('v_log_to_date - ' || to_char(v_log_to_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
660:
661: -- Update the standard rates and other columns on the euip production schedule table
662:

Line 659: mth_util_pkg.log_msg('v_log_to_date - ' || to_char(v_log_to_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);

655: -- Call mth_run_log_pre_load
656: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIP_STD_RATES_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date);
657: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIP_STD_RATES_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
658: mth_util_pkg.log_msg('v_log_from_date - ' || to_char(v_log_from_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
659: mth_util_pkg.log_msg('v_log_to_date - ' || to_char(v_log_to_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
660:
661: -- Update the standard rates and other columns on the euip production schedule table
662:
663: MERGE

Line 698: mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_PROD_SCHEDULE_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

694: SET
695: MEPRSF.LAST_UPDATE_DATE = MERGE_EQUIP_PROD_SQ.LAST_UPDATE_DATE,
696: MEPRSF.STANDARD_RATE_1= MERGE_EQUIP_PROD_SQ.STANDARD_RATE_1;
697:
698: mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_PROD_SCHEDULE_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
699:
700: -- Update the standard rates and other columns on the output summary table
701:
702: MERGE

Line 737: mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_OUTPUT_SUMMARY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

733: SET
734: MEOS.LAST_UPDATE_DATE = MERGE_EQUIP_OUTPUT_SQ.LAST_UPDATE_DATE,
735: MEOS.STANDARD_RATE_1= MERGE_EQUIP_OUTPUT_SQ.STANDARD_RATE_1;
736:
737: mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_OUTPUT_SUMMARY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
738:
739: ----Call mth_run_log_post_load
740: mth_util_pkg.mth_run_log_post_load('MTH_EQUIP_STD_RATES_MV',v_unassigned_val);
741:

Line 740: mth_util_pkg.mth_run_log_post_load('MTH_EQUIP_STD_RATES_MV',v_unassigned_val);

736:
737: mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_OUTPUT_SUMMARY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
738:
739: ----Call mth_run_log_post_load
740: mth_util_pkg.mth_run_log_post_load('MTH_EQUIP_STD_RATES_MV',v_unassigned_val);
741:
742: COMMIT;
743: mth_util_pkg.log_msg('MTH_POPULATE_EQP_STD_RATES_MV end', mth_util_pkg.G_DBG_PROC_FUN_END);
744: EXCEPTION

Line 743: mth_util_pkg.log_msg('MTH_POPULATE_EQP_STD_RATES_MV end', mth_util_pkg.G_DBG_PROC_FUN_END);

739: ----Call mth_run_log_post_load
740: mth_util_pkg.mth_run_log_post_load('MTH_EQUIP_STD_RATES_MV',v_unassigned_val);
741:
742: COMMIT;
743: mth_util_pkg.log_msg('MTH_POPULATE_EQP_STD_RATES_MV end', mth_util_pkg.G_DBG_PROC_FUN_END);
744: EXCEPTION
745: WHEN OTHERS THEN
746: mth_util_pkg.log_msg('Exception OTHERS in MTH_EQP_STD_RATES_MV_ALL_MAP', mth_util_pkg.G_DBG_EXCEPTION);
747: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);

Line 746: mth_util_pkg.log_msg('Exception OTHERS in MTH_EQP_STD_RATES_MV_ALL_MAP', mth_util_pkg.G_DBG_EXCEPTION);

742: COMMIT;
743: mth_util_pkg.log_msg('MTH_POPULATE_EQP_STD_RATES_MV end', mth_util_pkg.G_DBG_PROC_FUN_END);
744: EXCEPTION
745: WHEN OTHERS THEN
746: mth_util_pkg.log_msg('Exception OTHERS in MTH_EQP_STD_RATES_MV_ALL_MAP', mth_util_pkg.G_DBG_EXCEPTION);
747: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
748: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
749: ROLLBACK;
750: RAISE;

Line 747: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);

743: mth_util_pkg.log_msg('MTH_POPULATE_EQP_STD_RATES_MV end', mth_util_pkg.G_DBG_PROC_FUN_END);
744: EXCEPTION
745: WHEN OTHERS THEN
746: mth_util_pkg.log_msg('Exception OTHERS in MTH_EQP_STD_RATES_MV_ALL_MAP', mth_util_pkg.G_DBG_EXCEPTION);
747: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
748: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
749: ROLLBACK;
750: RAISE;
751: END MTH_POPULATE_EQP_STD_RATES_MV;

Line 748: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);

744: EXCEPTION
745: WHEN OTHERS THEN
746: mth_util_pkg.log_msg('Exception OTHERS in MTH_EQP_STD_RATES_MV_ALL_MAP', mth_util_pkg.G_DBG_EXCEPTION);
747: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
748: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
749: ROLLBACK;
750: RAISE;
751: END MTH_POPULATE_EQP_STD_RATES_MV;
752:

Line 771: mth_util_pkg.log_msg('MTH_POPULATE_ITEM_COST_MV start', mth_util_pkg.G_DBG_PROC_FUN_START);

767: v_log_to_date DATE;
768: v_unassigned_val VARCHAR2(30);
769:
770: BEGIN
771: mth_util_pkg.log_msg('MTH_POPULATE_ITEM_COST_MV start', mth_util_pkg.G_DBG_PROC_FUN_START);
772:
773: -- Initialize default parameters
774: v_log_to_date := sysdate;
775: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;

Line 775: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;

771: mth_util_pkg.log_msg('MTH_POPULATE_ITEM_COST_MV start', mth_util_pkg.G_DBG_PROC_FUN_START);
772:
773: -- Initialize default parameters
774: v_log_to_date := sysdate;
775: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
776:
777: -- Call mth_run_log_pre_load
778: mth_util_pkg.mth_run_log_pre_load('MTH_ITEM_COST_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date);
779: mth_util_pkg.GET_RUN_LOG_DATES('MTH_ITEM_COST_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);

Line 778: mth_util_pkg.mth_run_log_pre_load('MTH_ITEM_COST_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date);

774: v_log_to_date := sysdate;
775: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
776:
777: -- Call mth_run_log_pre_load
778: mth_util_pkg.mth_run_log_pre_load('MTH_ITEM_COST_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date);
779: mth_util_pkg.GET_RUN_LOG_DATES('MTH_ITEM_COST_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
780: mth_util_pkg.log_msg('v_log_from_date - ' || to_char(v_log_from_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
781: mth_util_pkg.log_msg('v_log_to_date - ' || to_char(v_log_to_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
782:

Line 779: mth_util_pkg.GET_RUN_LOG_DATES('MTH_ITEM_COST_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);

775: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
776:
777: -- Call mth_run_log_pre_load
778: mth_util_pkg.mth_run_log_pre_load('MTH_ITEM_COST_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date);
779: mth_util_pkg.GET_RUN_LOG_DATES('MTH_ITEM_COST_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
780: mth_util_pkg.log_msg('v_log_from_date - ' || to_char(v_log_from_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
781: mth_util_pkg.log_msg('v_log_to_date - ' || to_char(v_log_to_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
782:
783: -- Update the Item cost and other columns on the Production Schedules table

Line 780: mth_util_pkg.log_msg('v_log_from_date - ' || to_char(v_log_from_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);

776:
777: -- Call mth_run_log_pre_load
778: mth_util_pkg.mth_run_log_pre_load('MTH_ITEM_COST_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date);
779: mth_util_pkg.GET_RUN_LOG_DATES('MTH_ITEM_COST_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
780: mth_util_pkg.log_msg('v_log_from_date - ' || to_char(v_log_from_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
781: mth_util_pkg.log_msg('v_log_to_date - ' || to_char(v_log_to_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
782:
783: -- Update the Item cost and other columns on the Production Schedules table
784:

Line 781: mth_util_pkg.log_msg('v_log_to_date - ' || to_char(v_log_to_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);

777: -- Call mth_run_log_pre_load
778: mth_util_pkg.mth_run_log_pre_load('MTH_ITEM_COST_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date);
779: mth_util_pkg.GET_RUN_LOG_DATES('MTH_ITEM_COST_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
780: mth_util_pkg.log_msg('v_log_from_date - ' || to_char(v_log_from_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
781: mth_util_pkg.log_msg('v_log_to_date - ' || to_char(v_log_to_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
782:
783: -- Update the Item cost and other columns on the Production Schedules table
784:
785: MERGE

Line 825: mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_PROD_SCHEDULE_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

821: SET
822: PROD_SCHED_F.LAST_UPDATE_DATE = MERGE_EQUIP_PROD_SCHED_SQ.LAST_UPDATE_DATE,
823: PROD_SCHED_F.ITEM_COST = MERGE_EQUIP_PROD_SCHED_SQ.COST;
824:
825: mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_PROD_SCHEDULE_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
826:
827: -- Update the item cost and other columns on the output summary table
828:
829: MERGE

Line 867: mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_OUTPUT_SUMMARY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

863: SET
864: OUTPUT_SUMMARY.LAST_UPDATE_DATE = MERGE_EQUIP_OUTPUT_SUM_SQ.LAST_UPDATE_DATE,
865: OUTPUT_SUMMARY.ITEM_COST = MERGE_EQUIP_OUTPUT_SUM_SQ.COST ;
866:
867: mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_OUTPUT_SUMMARY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
868:
869: -- Update the item cost and other columns on the Production Consumed table
870:
871: MERGE

Line 911: mth_util_pkg.log_msg('Number of rows updated in MTH_PROD_MTL_CONSUMED_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

907: SET
908: PROD_CONSUMED_F.LAST_UPDATE_DATE = MERGE_PR0D_CONSUMED_SQ.LAST_UPDATE_DATE,
909: PROD_CONSUMED_F.ITEM_COST = MERGE_PR0D_CONSUMED_SQ.COST;
910:
911: mth_util_pkg.log_msg('Number of rows updated in MTH_PROD_MTL_CONSUMED_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
912:
913: ----Call mth_run_log_post_load
914: mth_util_pkg.mth_run_log_post_load('MTH_ITEM_COST_MV',v_unassigned_val);
915: COMMIT;

Line 914: mth_util_pkg.mth_run_log_post_load('MTH_ITEM_COST_MV',v_unassigned_val);

910:
911: mth_util_pkg.log_msg('Number of rows updated in MTH_PROD_MTL_CONSUMED_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
912:
913: ----Call mth_run_log_post_load
914: mth_util_pkg.mth_run_log_post_load('MTH_ITEM_COST_MV',v_unassigned_val);
915: COMMIT;
916: mth_util_pkg.log_msg('MTH_POPULATE_ITEM_COST_MV end', mth_util_pkg.G_DBG_PROC_FUN_END);
917: EXCEPTION
918: WHEN OTHERS THEN

Line 916: mth_util_pkg.log_msg('MTH_POPULATE_ITEM_COST_MV end', mth_util_pkg.G_DBG_PROC_FUN_END);

912:
913: ----Call mth_run_log_post_load
914: mth_util_pkg.mth_run_log_post_load('MTH_ITEM_COST_MV',v_unassigned_val);
915: COMMIT;
916: mth_util_pkg.log_msg('MTH_POPULATE_ITEM_COST_MV end', mth_util_pkg.G_DBG_PROC_FUN_END);
917: EXCEPTION
918: WHEN OTHERS THEN
919: mth_util_pkg.log_msg('Exception OTHERS in MTH_ITEM_COST_MV_ALL_MAP', mth_util_pkg.G_DBG_EXCEPTION);
920: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);

Line 919: mth_util_pkg.log_msg('Exception OTHERS in MTH_ITEM_COST_MV_ALL_MAP', mth_util_pkg.G_DBG_EXCEPTION);

915: COMMIT;
916: mth_util_pkg.log_msg('MTH_POPULATE_ITEM_COST_MV end', mth_util_pkg.G_DBG_PROC_FUN_END);
917: EXCEPTION
918: WHEN OTHERS THEN
919: mth_util_pkg.log_msg('Exception OTHERS in MTH_ITEM_COST_MV_ALL_MAP', mth_util_pkg.G_DBG_EXCEPTION);
920: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
921: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
922: ROLLBACK;
923: RAISE;

Line 920: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);

916: mth_util_pkg.log_msg('MTH_POPULATE_ITEM_COST_MV end', mth_util_pkg.G_DBG_PROC_FUN_END);
917: EXCEPTION
918: WHEN OTHERS THEN
919: mth_util_pkg.log_msg('Exception OTHERS in MTH_ITEM_COST_MV_ALL_MAP', mth_util_pkg.G_DBG_EXCEPTION);
920: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
921: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
922: ROLLBACK;
923: RAISE;
924: END MTH_POPULATE_ITEM_COST_MV;

Line 921: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);

917: EXCEPTION
918: WHEN OTHERS THEN
919: mth_util_pkg.log_msg('Exception OTHERS in MTH_ITEM_COST_MV_ALL_MAP', mth_util_pkg.G_DBG_EXCEPTION);
920: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
921: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
922: ROLLBACK;
923: RAISE;
924: END MTH_POPULATE_ITEM_COST_MV;
925:

Line 943: mth_util_pkg.log_msg('MTH_POPULATE_RESOURCE_COST_MV start', mth_util_pkg.G_DBG_PROC_FUN_START);

939: v_log_to_date DATE;
940: v_unassigned_val VARCHAR2(30);
941:
942: BEGIN
943: mth_util_pkg.log_msg('MTH_POPULATE_RESOURCE_COST_MV start', mth_util_pkg.G_DBG_PROC_FUN_START);
944:
945: -- Initialize default parameters
946: v_log_to_date := sysdate;
947: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;

Line 947: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;

943: mth_util_pkg.log_msg('MTH_POPULATE_RESOURCE_COST_MV start', mth_util_pkg.G_DBG_PROC_FUN_START);
944:
945: -- Initialize default parameters
946: v_log_to_date := sysdate;
947: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
948:
949: -- Call mth_run_log_pre_load
950: --mth_util_pkg.mth_run_log_pre_load('MTH_RESOURCE_COST_MV',v_unassigned_val,'INITIAL',NULL,0,v_log_date);
951: mth_util_pkg.mth_run_log_pre_load('MTH_RESOURCE_COST_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date); -- changed mode (sasuren)

Line 950: --mth_util_pkg.mth_run_log_pre_load('MTH_RESOURCE_COST_MV',v_unassigned_val,'INITIAL',NULL,0,v_log_date);

946: v_log_to_date := sysdate;
947: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
948:
949: -- Call mth_run_log_pre_load
950: --mth_util_pkg.mth_run_log_pre_load('MTH_RESOURCE_COST_MV',v_unassigned_val,'INITIAL',NULL,0,v_log_date);
951: mth_util_pkg.mth_run_log_pre_load('MTH_RESOURCE_COST_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date); -- changed mode (sasuren)
952: mth_util_pkg.GET_RUN_LOG_DATES('MTH_RESOURCE_COST_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
953: mth_util_pkg.log_msg('v_log_from_date - ' || to_char(v_log_from_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
954: mth_util_pkg.log_msg('v_log_to_date - ' || to_char(v_log_to_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);

Line 951: mth_util_pkg.mth_run_log_pre_load('MTH_RESOURCE_COST_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date); -- changed mode (sasuren)

947: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
948:
949: -- Call mth_run_log_pre_load
950: --mth_util_pkg.mth_run_log_pre_load('MTH_RESOURCE_COST_MV',v_unassigned_val,'INITIAL',NULL,0,v_log_date);
951: mth_util_pkg.mth_run_log_pre_load('MTH_RESOURCE_COST_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date); -- changed mode (sasuren)
952: mth_util_pkg.GET_RUN_LOG_DATES('MTH_RESOURCE_COST_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
953: mth_util_pkg.log_msg('v_log_from_date - ' || to_char(v_log_from_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
954: mth_util_pkg.log_msg('v_log_to_date - ' || to_char(v_log_to_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
955:

Line 952: mth_util_pkg.GET_RUN_LOG_DATES('MTH_RESOURCE_COST_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);

948:
949: -- Call mth_run_log_pre_load
950: --mth_util_pkg.mth_run_log_pre_load('MTH_RESOURCE_COST_MV',v_unassigned_val,'INITIAL',NULL,0,v_log_date);
951: mth_util_pkg.mth_run_log_pre_load('MTH_RESOURCE_COST_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date); -- changed mode (sasuren)
952: mth_util_pkg.GET_RUN_LOG_DATES('MTH_RESOURCE_COST_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
953: mth_util_pkg.log_msg('v_log_from_date - ' || to_char(v_log_from_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
954: mth_util_pkg.log_msg('v_log_to_date - ' || to_char(v_log_to_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
955:
956: -- Update the Resource cost and other columns on the equipment shifts table

Line 953: mth_util_pkg.log_msg('v_log_from_date - ' || to_char(v_log_from_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);

949: -- Call mth_run_log_pre_load
950: --mth_util_pkg.mth_run_log_pre_load('MTH_RESOURCE_COST_MV',v_unassigned_val,'INITIAL',NULL,0,v_log_date);
951: mth_util_pkg.mth_run_log_pre_load('MTH_RESOURCE_COST_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date); -- changed mode (sasuren)
952: mth_util_pkg.GET_RUN_LOG_DATES('MTH_RESOURCE_COST_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
953: mth_util_pkg.log_msg('v_log_from_date - ' || to_char(v_log_from_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
954: mth_util_pkg.log_msg('v_log_to_date - ' || to_char(v_log_to_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
955:
956: -- Update the Resource cost and other columns on the equipment shifts table
957:

Line 954: mth_util_pkg.log_msg('v_log_to_date - ' || to_char(v_log_to_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);

950: --mth_util_pkg.mth_run_log_pre_load('MTH_RESOURCE_COST_MV',v_unassigned_val,'INITIAL',NULL,0,v_log_date);
951: mth_util_pkg.mth_run_log_pre_load('MTH_RESOURCE_COST_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date); -- changed mode (sasuren)
952: mth_util_pkg.GET_RUN_LOG_DATES('MTH_RESOURCE_COST_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
953: mth_util_pkg.log_msg('v_log_from_date - ' || to_char(v_log_from_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
954: mth_util_pkg.log_msg('v_log_to_date - ' || to_char(v_log_to_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
955:
956: -- Update the Resource cost and other columns on the equipment shifts table
957:
958: MERGE

Line 1002: mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIPMENT_SHIFTS_D - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

998: LAST_UPDATED_BY = MERGE_EQUIP_SHIFTS_SQ.LAST_UPDATED_BY,
999: LAST_UPDATE_LOGIN = MERGE_EQUIP_SHIFTS_SQ.LAST_UPDATE_LOGIN,
1000: RESOURCE_COST = MERGE_EQUIP_SHIFTS_SQ.RESOURCE_COST ;
1001:
1002: mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIPMENT_SHIFTS_D - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1003:
1004: -- Update the Resource cost and other columns on the resource requirements table
1005:
1006: MERGE

Line 1050: mth_util_pkg.log_msg('Number of rows updated in MTH_RESOURCE_REQUIREMENTS_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

1046: LAST_UPDATED_BY = MERGE_RESOURCE_REQ_SQ.LAST_UPDATED_BY,
1047: LAST_UPDATE_LOGIN = MERGE_RESOURCE_REQ_SQ.LAST_UPDATE_LOGIN,
1048: RESOURCE_COST = MERGE_RESOURCE_REQ_SQ.RESOURCE_COST ;
1049:
1050: mth_util_pkg.log_msg('Number of rows updated in MTH_RESOURCE_REQUIREMENTS_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1051:
1052: -- Update the Resource cost and other columns on the status summary table
1053:
1054: MERGE

Line 1098: mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_STATUS_SUMMARY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

1094: LAST_UPDATED_BY = MERGE_EQUIP_STATUS_SUM_SQ.LAST_UPDATED_BY,
1095: LAST_UPDATE_LOGIN = MERGE_EQUIP_STATUS_SUM_SQ.LAST_UPDATE_LOGIN,
1096: RESOURCE_COST = MERGE_EQUIP_STATUS_SUM_SQ.RESOURCE_COST ;
1097:
1098: mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_STATUS_SUMMARY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1099:
1100: -- Update the Resource cost and other columns on the output summary table
1101:
1102: MERGE

Line 1146: mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_OUTPUT_SUMMARY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

1142: LAST_UPDATED_BY = MERGE_EQUIP_OUTPUT_SUM_SQ.LAST_UPDATED_BY,
1143: LAST_UPDATE_LOGIN = MERGE_EQUIP_OUTPUT_SUM_SQ.LAST_UPDATE_LOGIN,
1144: RESOURCE_COST = MERGE_EQUIP_OUTPUT_SUM_SQ.RESOURCE_COST ;
1145:
1146: mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_OUTPUT_SUMMARY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1147:
1148: -- Update the Resource cost and other columns on the resource transactions table
1149:
1150: MERGE

Line 1194: mth_util_pkg.log_msg('Number of rows updated in MTH_RESOURCE_TXN_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

1190: LAST_UPDATED_BY = MERGE_RESOURCE_TXN_SQ.LAST_UPDATED_BY,
1191: LAST_UPDATE_LOGIN = MERGE_RESOURCE_TXN_SQ.LAST_UPDATE_LOGIN,
1192: RESOURCE_COST = MERGE_RESOURCE_TXN_SQ.RESOURCE_COST ;
1193:
1194: mth_util_pkg.log_msg('Number of rows updated in MTH_RESOURCE_TXN_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1195:
1196: ----Call mth_run_log_post_load
1197: mth_util_pkg.mth_run_log_post_load('MTH_RESOURCE_COST_MV',v_unassigned_val);
1198:

Line 1197: mth_util_pkg.mth_run_log_post_load('MTH_RESOURCE_COST_MV',v_unassigned_val);

1193:
1194: mth_util_pkg.log_msg('Number of rows updated in MTH_RESOURCE_TXN_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1195:
1196: ----Call mth_run_log_post_load
1197: mth_util_pkg.mth_run_log_post_load('MTH_RESOURCE_COST_MV',v_unassigned_val);
1198:
1199: COMMIT;
1200: mth_util_pkg.log_msg('MTH_POPULATE_RESOURCE_COST_MV end', mth_util_pkg.G_DBG_PROC_FUN_END);
1201: EXCEPTION

Line 1200: mth_util_pkg.log_msg('MTH_POPULATE_RESOURCE_COST_MV end', mth_util_pkg.G_DBG_PROC_FUN_END);

1196: ----Call mth_run_log_post_load
1197: mth_util_pkg.mth_run_log_post_load('MTH_RESOURCE_COST_MV',v_unassigned_val);
1198:
1199: COMMIT;
1200: mth_util_pkg.log_msg('MTH_POPULATE_RESOURCE_COST_MV end', mth_util_pkg.G_DBG_PROC_FUN_END);
1201: EXCEPTION
1202: WHEN OTHERS THEN
1203: mth_util_pkg.log_msg('Exception OTHERS in MTH_RESOURCE_COST_MV_ALL_MAP', mth_util_pkg.G_DBG_EXCEPTION);
1204: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);

Line 1203: mth_util_pkg.log_msg('Exception OTHERS in MTH_RESOURCE_COST_MV_ALL_MAP', mth_util_pkg.G_DBG_EXCEPTION);

1199: COMMIT;
1200: mth_util_pkg.log_msg('MTH_POPULATE_RESOURCE_COST_MV end', mth_util_pkg.G_DBG_PROC_FUN_END);
1201: EXCEPTION
1202: WHEN OTHERS THEN
1203: mth_util_pkg.log_msg('Exception OTHERS in MTH_RESOURCE_COST_MV_ALL_MAP', mth_util_pkg.G_DBG_EXCEPTION);
1204: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
1205: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
1206: ROLLBACK;
1207: RAISE;

Line 1204: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);

1200: mth_util_pkg.log_msg('MTH_POPULATE_RESOURCE_COST_MV end', mth_util_pkg.G_DBG_PROC_FUN_END);
1201: EXCEPTION
1202: WHEN OTHERS THEN
1203: mth_util_pkg.log_msg('Exception OTHERS in MTH_RESOURCE_COST_MV_ALL_MAP', mth_util_pkg.G_DBG_EXCEPTION);
1204: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
1205: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
1206: ROLLBACK;
1207: RAISE;
1208: END MTH_POPULATE_RESOURCE_COST_MV;

Line 1205: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);

1201: EXCEPTION
1202: WHEN OTHERS THEN
1203: mth_util_pkg.log_msg('Exception OTHERS in MTH_RESOURCE_COST_MV_ALL_MAP', mth_util_pkg.G_DBG_EXCEPTION);
1204: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
1205: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
1206: ROLLBACK;
1207: RAISE;
1208: END MTH_POPULATE_RESOURCE_COST_MV;
1209: