APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_ANALYSE_TABLES_PK

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

665: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
666:
667: COMMIT;
668:
669: msc_analyse_tables_pk.analyse_table( 'MSC_CALENDAR_DATES');
670:
671:
672: END IF;
673:

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

4433:
4434: COMMIT;
4435: /* Bug7679044 */
4436: IF lv_tp_stat_stale = MSC_UTIL.SYS_YES OR lv_ins_records > lv_tp_id_count * 0.2 THEN
4437: msc_analyse_tables_pk.analyse_table( 'MSC_TP_ID_LID');
4438: lv_tp_stat_stale := MSC_UTIL.SYS_NO;
4439: lv_tp_id_count := lv_tp_id_count + lv_ins_records;
4440: END IF;
4441:

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

4656:
4657: COMMIT;
4658: /* Bug7679044 */
4659: IF lv_tp_site_stat_stale = MSC_UTIL.SYS_YES OR lv_ins_records > lv_tp_site_id_count * 0.2 THEN
4660: msc_analyse_tables_pk.analyse_table( 'MSC_TP_SITE_ID_LID');
4661: lv_tp_site_stat_stale := MSC_UTIL.SYS_NO;
4662: lv_tp_site_id_count := lv_tp_site_id_count + lv_ins_records;
4663: END IF;
4664:

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

4880:
4881: COMMIT;
4882: /* Bug7679044 */
4883: IF lv_tp_site_stat_stale = MSC_UTIL.SYS_YES OR lv_ins_records > lv_tp_site_id_count * 0.2 THEN
4884: msc_analyse_tables_pk.analyse_table( 'MSC_TP_SITE_ID_LID');
4885: lv_tp_site_stat_stale := MSC_UTIL.SYS_NO;
4886: lv_tp_site_id_count := lv_tp_site_id_count + lv_ins_records;
4887: END IF;
4888:

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

5067: COMMIT;
5068:
5069: /* analyse the key mapping tables */
5070: IF lv_tp_stat_stale = MSC_UTIL.SYS_YES THEN
5071: msc_analyse_tables_pk.analyse_table( 'MSC_TP_ID_LID');
5072: END IF;
5073: IF lv_tp_site_stat_stale = MSC_UTIL.SYS_YES THEN
5074: msc_analyse_tables_pk.analyse_table( 'MSC_TP_SITE_ID_LID');
5075: END IF;

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

5070: IF lv_tp_stat_stale = MSC_UTIL.SYS_YES THEN
5071: msc_analyse_tables_pk.analyse_table( 'MSC_TP_ID_LID');
5072: END IF;
5073: IF lv_tp_site_stat_stale = MSC_UTIL.SYS_YES THEN
5074: msc_analyse_tables_pk.analyse_table( 'MSC_TP_SITE_ID_LID');
5075: END IF;
5076:
5077: EXCEPTION
5078: