APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_ANALYSE_TABLES_PK

Line 672: msc_analyse_tables_pk.analyse_table( 'MSC_CALENDAR_DATES');

668: AND exception_set_id = -1;
669:
670: COMMIT;
671:
672: msc_analyse_tables_pk.analyse_table( 'MSC_CALENDAR_DATES');
673:
674:
675: END IF;
676:

Line 4447: msc_analyse_tables_pk.analyse_table( 'MSC_TP_ID_LID');

4443:
4444: COMMIT;
4445: /* Bug7679044 */
4446: IF lv_tp_stat_stale = MSC_UTIL.SYS_YES OR lv_ins_records > lv_tp_id_count * 0.2 THEN
4447: msc_analyse_tables_pk.analyse_table( 'MSC_TP_ID_LID');
4448: lv_tp_stat_stale := MSC_UTIL.SYS_NO;
4449: lv_tp_id_count := lv_tp_id_count + lv_ins_records;
4450: END IF;
4451:

Line 4670: msc_analyse_tables_pk.analyse_table( 'MSC_TP_SITE_ID_LID');

4666:
4667: COMMIT;
4668: /* Bug7679044 */
4669: IF lv_tp_site_stat_stale = MSC_UTIL.SYS_YES OR lv_ins_records > lv_tp_site_id_count * 0.2 THEN
4670: msc_analyse_tables_pk.analyse_table( 'MSC_TP_SITE_ID_LID');
4671: lv_tp_site_stat_stale := MSC_UTIL.SYS_NO;
4672: lv_tp_site_id_count := lv_tp_site_id_count + lv_ins_records;
4673: END IF;
4674:

Line 4894: msc_analyse_tables_pk.analyse_table( 'MSC_TP_SITE_ID_LID');

4890:
4891: COMMIT;
4892: /* Bug7679044 */
4893: IF lv_tp_site_stat_stale = MSC_UTIL.SYS_YES OR lv_ins_records > lv_tp_site_id_count * 0.2 THEN
4894: msc_analyse_tables_pk.analyse_table( 'MSC_TP_SITE_ID_LID');
4895: lv_tp_site_stat_stale := MSC_UTIL.SYS_NO;
4896: lv_tp_site_id_count := lv_tp_site_id_count + lv_ins_records;
4897: END IF;
4898:

Line 5081: msc_analyse_tables_pk.analyse_table( 'MSC_TP_ID_LID');

5077: COMMIT;
5078:
5079: /* analyse the key mapping tables */
5080: IF lv_tp_stat_stale = MSC_UTIL.SYS_YES THEN
5081: msc_analyse_tables_pk.analyse_table( 'MSC_TP_ID_LID');
5082: END IF;
5083: IF lv_tp_site_stat_stale = MSC_UTIL.SYS_YES THEN
5084: msc_analyse_tables_pk.analyse_table( 'MSC_TP_SITE_ID_LID');
5085: END IF;

Line 5084: msc_analyse_tables_pk.analyse_table( 'MSC_TP_SITE_ID_LID');

5080: IF lv_tp_stat_stale = MSC_UTIL.SYS_YES THEN
5081: msc_analyse_tables_pk.analyse_table( 'MSC_TP_ID_LID');
5082: END IF;
5083: IF lv_tp_site_stat_stale = MSC_UTIL.SYS_YES THEN
5084: msc_analyse_tables_pk.analyse_table( 'MSC_TP_SITE_ID_LID');
5085: END IF;
5086:
5087: EXCEPTION
5088: