eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSD_PUSH_SETUP_DATA dependencies on MSD_SETUP_PARAMETERS

Line 79: x_source_table := 'MSD_SETUP_PARAMETERS'||x_dblink;

75: errbuf := 'Error while getting db_link';
76: return;
77: end if;
78:
79: x_source_table := 'MSD_SETUP_PARAMETERS'||x_dblink;
80: x_sql_stmt := 'SELECT COUNT(*) FROM '||x_source_table||' where instance_id = '||p_instance_id;
81:
82: open l_cur for x_sql_stmt;
83: fetch l_cur into x_num_params;

Line 196: -- Find out if there are rows in msd_setup_parameters in the source instance

192: /* Initialization parameter values */
193: Init;
194:
195:
196: -- Find out if there are rows in msd_setup_parameters in the source instance
197: --
198: -- Call MSD_CONC_LOG_UTIL.Initialize for log file for concurrent program
199: --
200: msd_conc_log_util.Initilize(msd_conc_log_util.C_OUTPUT_TO_FNDFILE);

Line 407: msd_conc_log_util.display_message('Deleting records from msd_setup_parameters in the Source instance', msd_conc_log_util.C_HEADING);

403: msd_conc_log_util.display_message('Please make sure that profiles ' ||
404: 'MSD_CONVERSION_TYPE and MSD_MASTER_ORG are set in Source instance.', msd_conc_log_util.C_ERROR);
405: msd_conc_log_util.display_message(' and MSD_CURRENCY_CODE profile in the Planning Server are set.', msd_conc_log_util.C_ERROR);
406: ELSE
407: msd_conc_log_util.display_message('Deleting records from msd_setup_parameters in the Source instance', msd_conc_log_util.C_HEADING);
408: /* Truncate Source msd_setup_parameters */
409: l_sql := 'delete from msd_setup_parameters' || g_dblink;
410: EXECUTE IMMEDIATE l_sql;
411:

Line 408: /* Truncate Source msd_setup_parameters */

404: 'MSD_CONVERSION_TYPE and MSD_MASTER_ORG are set in Source instance.', msd_conc_log_util.C_ERROR);
405: msd_conc_log_util.display_message(' and MSD_CURRENCY_CODE profile in the Planning Server are set.', msd_conc_log_util.C_ERROR);
406: ELSE
407: msd_conc_log_util.display_message('Deleting records from msd_setup_parameters in the Source instance', msd_conc_log_util.C_HEADING);
408: /* Truncate Source msd_setup_parameters */
409: l_sql := 'delete from msd_setup_parameters' || g_dblink;
410: EXECUTE IMMEDIATE l_sql;
411:
412: msd_conc_log_util.display_message('Inserting profile into source msd_setup_parameters', msd_conc_log_util.C_INFORMATION);

Line 409: l_sql := 'delete from msd_setup_parameters' || g_dblink;

405: msd_conc_log_util.display_message(' and MSD_CURRENCY_CODE profile in the Planning Server are set.', msd_conc_log_util.C_ERROR);
406: ELSE
407: msd_conc_log_util.display_message('Deleting records from msd_setup_parameters in the Source instance', msd_conc_log_util.C_HEADING);
408: /* Truncate Source msd_setup_parameters */
409: l_sql := 'delete from msd_setup_parameters' || g_dblink;
410: EXECUTE IMMEDIATE l_sql;
411:
412: msd_conc_log_util.display_message('Inserting profile into source msd_setup_parameters', msd_conc_log_util.C_INFORMATION);
413:

Line 412: msd_conc_log_util.display_message('Inserting profile into source msd_setup_parameters', msd_conc_log_util.C_INFORMATION);

408: /* Truncate Source msd_setup_parameters */
409: l_sql := 'delete from msd_setup_parameters' || g_dblink;
410: EXECUTE IMMEDIATE l_sql;
411:
412: msd_conc_log_util.display_message('Inserting profile into source msd_setup_parameters', msd_conc_log_util.C_INFORMATION);
413:
414: /* Insert profiles in source msd_setup_parameters */
415: l_sql := 'insert into msd_setup_parameters' || g_dblink ||
416: ' (instance_id, parameter_name, parameter_value) values (:1, :2, :3)';

Line 414: /* Insert profiles in source msd_setup_parameters */

410: EXECUTE IMMEDIATE l_sql;
411:
412: msd_conc_log_util.display_message('Inserting profile into source msd_setup_parameters', msd_conc_log_util.C_INFORMATION);
413:
414: /* Insert profiles in source msd_setup_parameters */
415: l_sql := 'insert into msd_setup_parameters' || g_dblink ||
416: ' (instance_id, parameter_name, parameter_value) values (:1, :2, :3)';
417:
418: FOR j IN l_para_prof.FIRST..l_para_prof.LAST LOOP

Line 415: l_sql := 'insert into msd_setup_parameters' || g_dblink ||

411:
412: msd_conc_log_util.display_message('Inserting profile into source msd_setup_parameters', msd_conc_log_util.C_INFORMATION);
413:
414: /* Insert profiles in source msd_setup_parameters */
415: l_sql := 'insert into msd_setup_parameters' || g_dblink ||
416: ' (instance_id, parameter_name, parameter_value) values (:1, :2, :3)';
417:
418: FOR j IN l_para_prof.FIRST..l_para_prof.LAST LOOP
419: EXECUTE IMMEDIATE l_sql using p_instance_id, l_para_prof(j).profile_name, l_para_prof(j).parameter_value;

Line 497: TYPE parameter_name_tab IS TABLE OF MSD_SETUP_PARAMETERS.parameter_name%TYPE;

493:
494: TYPE Source_Profile_Value IS REF CURSOR;
495: c_source_profile Source_Profile_Value;
496:
497: TYPE parameter_name_tab IS TABLE OF MSD_SETUP_PARAMETERS.parameter_name%TYPE;
498: TYPE parameter_value_tab IS TABLE OF MSD_SETUP_PARAMETERS.parameter_value%TYPE;
499:
500: a_parameter_name parameter_name_tab;
501: a_parameter_value parameter_value_tab;

Line 498: TYPE parameter_value_tab IS TABLE OF MSD_SETUP_PARAMETERS.parameter_value%TYPE;

494: TYPE Source_Profile_Value IS REF CURSOR;
495: c_source_profile Source_Profile_Value;
496:
497: TYPE parameter_name_tab IS TABLE OF MSD_SETUP_PARAMETERS.parameter_name%TYPE;
498: TYPE parameter_value_tab IS TABLE OF MSD_SETUP_PARAMETERS.parameter_value%TYPE;
499:
500: a_parameter_name parameter_name_tab;
501: a_parameter_value parameter_value_tab;
502:

Line 541: v_sql_stmt := 'SELECT parameter_name, parameter_value FROM MSD_SETUP_PARAMETERS'||g_dblink ||

537: FOR i IN l_para_prof.FIRST..l_para_prof.LAST LOOP
538: l_para_prof(i).parameter_value := decode_profile_function(l_para_prof(i));
539: END LOOP;
540:
541: v_sql_stmt := 'SELECT parameter_name, parameter_value FROM MSD_SETUP_PARAMETERS'||g_dblink ||
542: ' where instance_id = ' || p_instance_id;
543:
544: /* Does not work on Oracle 8i
545: * OPEN c_source_profile FOR v_sql_stmt;