[Home] [Help]
502: EXECUTE IMMEDIATE x_sql USING g_profile_list(j).profile_code, g_profile_list(j).profile_value, g_user_id, g_user_id, g_login_id;
503: END LOOP;
504:
505: msd_dem_common_utilities.log_message ('Analyzing destination msd_dem_setup_parameters');
506: msd_dem_collect_history_data.analyze_table (x_errbuf, x_retcode, 'MSD_DEM_SETUP_PARAMETERS');
507:
508: COMMIT;
509:
510: END IF;
625: ' FROM msd_dem_app_instance_orgs' || g_dblink;
626: EXECUTE IMMEDIATE x_sql USING g_user_id, g_user_id, g_login_id;
627:
628: msd_dem_common_utilities.log_message ('Analyzing destination msd_dem_app_instance_orgs');
629: msd_dem_collect_history_data.analyze_table (x_errbuf, x_retcode, 'MSD_DEM_APP_INSTANCE_ORGS');
630:
631: COMMIT;
632:
633: END IF;
767: msd_dem_common_utilities.log_debug(x_sql);
768: EXECUTE IMMEDIATE x_sql USING g_user_id, g_user_id, g_login_id;
769:
770: msd_dem_common_utilities.log_message ('Analyzing destination msd_dem_dates');
771: msd_dem_collect_history_data.analyze_table (x_errbuf, x_retcode, 'MSD_DEM_DATES');
772: END IF;
773:
774: COMMIT;
775:
792: msd_dem_common_utilities.log_debug(x_sql);
793: EXECUTE IMMEDIATE x_sql USING g_user_id, g_user_id, g_login_id;
794:
795: msd_dem_common_utilities.log_message ('Analyzing destination msd_dem_day_dates');
796: msd_dem_collect_history_data.analyze_table (x_errbuf, x_retcode, 'MSD_DEM_DAY_DATES');
797:
798: commit;
799:
800: IF (g_dblink IS NOT NULL) THEN