144:
145: commit;
146:
147: /* Added by esubrama */
148: MSD_ANALYZE_TABLES.analyze_table('MSD_SHIPMENT_DATA',null);
149: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_SHIPMENT_DATA',null);
150: exception
151:
152: when others then
145: commit;
146:
147: /* Added by esubrama */
148: MSD_ANALYZE_TABLES.analyze_table('MSD_SHIPMENT_DATA',null);
149: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_SHIPMENT_DATA',null);
150: exception
151:
152: when others then
153:
220:
221: commit;
222:
223: /* Added by esubrama */
224: MSD_ANALYZE_TABLES.analyze_table('MSD_BOOKING_DATA',null);
225: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_BOOKING_DATA',null);
226:
227: EXCEPTION
228:
221: commit;
222:
223: /* Added by esubrama */
224: MSD_ANALYZE_TABLES.analyze_table('MSD_BOOKING_DATA',null);
225: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_BOOKING_DATA',null);
226:
227: EXCEPTION
228:
229: when others then
294:
295: commit;
296:
297: /* Added by esubrama */
298: MSD_ANALYZE_TABLES.analyze_table('MSD_UOM_CONVERSIONS',null);
299: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_UOM_CONVERSIONS',null);
300: exception
301:
302: when others then
295: commit;
296:
297: /* Added by esubrama */
298: MSD_ANALYZE_TABLES.analyze_table('MSD_UOM_CONVERSIONS',null);
299: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_UOM_CONVERSIONS',null);
300: exception
301:
302: when others then
303:
361:
362: commit;
363:
364: /* Added by esubrama */
365: MSD_ANALYZE_TABLES.analyze_table('MSD_CURRENCY_CONVERSIONS',null);
366: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_CURRENCY_CONVERSIONS',null);
367:
368: exception
369:
362: commit;
363:
364: /* Added by esubrama */
365: MSD_ANALYZE_TABLES.analyze_table('MSD_CURRENCY_CONVERSIONS',null);
366: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_CURRENCY_CONVERSIONS',null);
367:
368: exception
369:
370: when others then
423:
424: commit;
425:
426: -- Added by esubrama
427: MSD_ANALYZE_TABLES.analyze_table('MSD_SALES_OPPORTUNITY_DATA',null);
428: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_SALES_OPPORTUNITY_DATA',null);
429:
430: exception
431:
424: commit;
425:
426: -- Added by esubrama
427: MSD_ANALYZE_TABLES.analyze_table('MSD_SALES_OPPORTUNITY_DATA',null);
428: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_SALES_OPPORTUNITY_DATA',null);
429:
430: exception
431:
432: when others then
490:
491: End Loop ;
492:
493: -- Added by esubrama
494: MSD_ANALYZE_TABLES.analyze_table('MSD_SALES_FORECAST',null);
495: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_SALES_FORECAST',null);
496:
497: exception
498:
491: End Loop ;
492:
493: -- Added by esubrama
494: MSD_ANALYZE_TABLES.analyze_table('MSD_SALES_FORECAST',null);
495: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_SALES_FORECAST',null);
496:
497: exception
498:
499: when others then
637:
638: COMMIT;
639:
640: /* Added by esubrama */
641: MSD_ANALYZE_TABLES.analyze_table('MSD_MFG_FORECAST',null);
642: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_MFG_FORECAST',null);
643:
644: EXCEPTION
645: when others then
638: COMMIT;
639:
640: /* Added by esubrama */
641: MSD_ANALYZE_TABLES.analyze_table('MSD_MFG_FORECAST',null);
642: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_MFG_FORECAST',null);
643:
644: EXCEPTION
645: when others then
646: errbuf := substr(SQLERRM,1,150);
703:
704: commit;
705:
706: /* Added by esubrama */
707: MSD_ANALYZE_TABLES.analyze_table('MSD_PRICE_LIST',null);
708: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_PRICE_LIST',null);
709:
710: exception
711: when others then
704: commit;
705:
706: /* Added by esubrama */
707: MSD_ANALYZE_TABLES.analyze_table('MSD_PRICE_LIST',null);
708: MSD_ANALYZE_TABLES.analyze_table('MSD_ST_PRICE_LIST',null);
709:
710: exception
711: when others then
712: