APPS.MSC_CL_COLLECTION dependencies on MSC_ANALYSE_TABLES_PK

Line 2852: msc_analyse_tables_pk.analyse_table( 'SUPPLIES_'||v_instance_code, v_instance_id, -1);

2848: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Index creation on Temp Supplies table failed.');
2849: RAISE SUPPLIES_INDEX_FAIL;
2850: END IF;
2851:
2852: msc_analyse_tables_pk.analyse_table( 'SUPPLIES_'||v_instance_code, v_instance_id, -1);
2853:
2854: end if; --- any one of the Supplies will be done Targeted
2855:
2856: ELSIF (v_is_incremental_refresh) then

Line 2896: msc_analyse_tables_pk.analyse_table( 'SUPPLIES_'||v_instance_code, v_instance_id, -1);

2892: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Index creation on Temp Supplies table failed.');
2893: RAISE SUPPLIES_INDEX_FAIL;
2894: END IF;
2895:
2896: msc_analyse_tables_pk.analyse_table( 'SUPPLIES_'||v_instance_code, v_instance_id, -1);
2897:
2898: END IF;
2899:
2900: COMMIT;

Line 4499: msc_analyse_tables_pk.analyse_table( 'MSC_TRADING_PARTNERS');

4495:
4496: /* CP-ACK ends */
4497:
4498: IF v_is_complete_refresh THEN
4499: msc_analyse_tables_pk.analyse_table( 'MSC_TRADING_PARTNERS');
4500: msc_analyse_tables_pk.analyse_table( 'MSC_DESIGNATORS');
4501: END IF;
4502:
4503:

Line 4500: msc_analyse_tables_pk.analyse_table( 'MSC_DESIGNATORS');

4496: /* CP-ACK ends */
4497:
4498: IF v_is_complete_refresh THEN
4499: msc_analyse_tables_pk.analyse_table( 'MSC_TRADING_PARTNERS');
4500: msc_analyse_tables_pk.analyse_table( 'MSC_DESIGNATORS');
4501: END IF;
4502:
4503:
4504: IF (v_instance_type <> MSC_UTIL.G_INS_OTHER) AND (v_is_complete_refresh OR

Line 7651: msc_analyse_tables_pk.analyse_table(lv_temp_tbl_name);

7647: END IF;
7648:
7649: lv_temp_tbl_name := SUBSTR(p_part_table, 5, LENGTH(p_part_table)) || '_' || p_instance_code;
7650:
7651: msc_analyse_tables_pk.analyse_table(lv_temp_tbl_name);
7652:
7653: lv_crt_ind_status := MSC_CL_EXCHANGE_PARTTBL.create_temp_table_index
7654: ('UNIQUE',
7655: p_part_table,