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.MSC_CL_COPY_DP_FORECAST dependencies on MSD_DP_SCENARIO_REVISIONS

Line 465: Delete from MSD_DP_SCENARIO_REVISIONS; --commit;

461: PROCEDURE COPY_DP_SCENARIO_REVISIONS IS
462:
463: BEGIN
464:
465: Delete from MSD_DP_SCENARIO_REVISIONS; --commit;
466: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The number of rows deleted from MSD_DP_SCENARIO_REVISIONS '|| SQL%ROWCOUNT);
467:
468: v_sql_stmt:=
469: 'Insert into MSD_DP_SCENARIO_REVISIONS ('

Line 466: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The number of rows deleted from MSD_DP_SCENARIO_REVISIONS '|| SQL%ROWCOUNT);

462:
463: BEGIN
464:
465: Delete from MSD_DP_SCENARIO_REVISIONS; --commit;
466: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The number of rows deleted from MSD_DP_SCENARIO_REVISIONS '|| SQL%ROWCOUNT);
467:
468: v_sql_stmt:=
469: 'Insert into MSD_DP_SCENARIO_REVISIONS ('
470: || 'DEMAND_PLAN_ID,'

Line 469: 'Insert into MSD_DP_SCENARIO_REVISIONS ('

465: Delete from MSD_DP_SCENARIO_REVISIONS; --commit;
466: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The number of rows deleted from MSD_DP_SCENARIO_REVISIONS '|| SQL%ROWCOUNT);
467:
468: v_sql_stmt:=
469: 'Insert into MSD_DP_SCENARIO_REVISIONS ('
470: || 'DEMAND_PLAN_ID,'
471: || 'SCENARIO_ID,'
472: || 'REVISION,'
473: || 'REVISION_NAME,'

Line 492: || ' from MSD_DP_SCENARIO_REVISIONS'|| v_aps_dblink;

488: || 'CREATION_DATE,'
489: || 'CREATED_BY,'
490: || 'LAST_UPDATE_LOGIN,'
491: || 'ERROR_TYPE'
492: || ' from MSD_DP_SCENARIO_REVISIONS'|| v_aps_dblink;
493:
494: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL for Insert into MSD_DP_SCENARIO_REVISIONS table is :- '||v_sql_stmt);
495: EXECUTE IMMEDIATE v_sql_stmt ;
496: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted into MSD_DP_SCENARIO_REVISIONS is :- '||sql%rowcount);

Line 494: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL for Insert into MSD_DP_SCENARIO_REVISIONS table is :- '||v_sql_stmt);

490: || 'LAST_UPDATE_LOGIN,'
491: || 'ERROR_TYPE'
492: || ' from MSD_DP_SCENARIO_REVISIONS'|| v_aps_dblink;
493:
494: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL for Insert into MSD_DP_SCENARIO_REVISIONS table is :- '||v_sql_stmt);
495: EXECUTE IMMEDIATE v_sql_stmt ;
496: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted into MSD_DP_SCENARIO_REVISIONS is :- '||sql%rowcount);
497:
498: EXCEPTION

Line 496: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted into MSD_DP_SCENARIO_REVISIONS is :- '||sql%rowcount);

492: || ' from MSD_DP_SCENARIO_REVISIONS'|| v_aps_dblink;
493:
494: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SQL for Insert into MSD_DP_SCENARIO_REVISIONS table is :- '||v_sql_stmt);
495: EXECUTE IMMEDIATE v_sql_stmt ;
496: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted into MSD_DP_SCENARIO_REVISIONS is :- '||sql%rowcount);
497:
498: EXCEPTION
499: WHEN NO_DATA_FOUND THEN
500: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No records in MSD_DP_SCENARIO_REVISIONS ' );

Line 500: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No records in MSD_DP_SCENARIO_REVISIONS ' );

496: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Records inserted into MSD_DP_SCENARIO_REVISIONS is :- '||sql%rowcount);
497:
498: EXCEPTION
499: WHEN NO_DATA_FOUND THEN
500: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No records in MSD_DP_SCENARIO_REVISIONS ' );
501: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, SQLERRM);
502: --RETCODE := MSC_UTIL.G_ERROR;
503: --ERRBUF := 'No data found';
504: RETURN;