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.PER_DATA_UPDATE_REPORT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 12


  select parameter_value
    from pay_upgrade_parameters
   where parameter_name = f_parameter_name
     and upgrade_definition_id = f_upgrade_definition_id;

Line: 50


 select name process_name
 from   pay_upgrade_definitions_tl
 where  language = userenv('LANG');

Line: 56


  select
        pud.upgrade_definition_id upgrade_definition_id,
        pudt.NAME             process_name,
        pud.LEGISLATION_CODE  legislation_code,
        pud.DESCRIPTION       description,
        decode(pud.UPGRADE_LEVEL,'B','Business Group',
                                 'L', 'Legislation',
                                 'G', 'Global') upgrade_level,
        pud.CRITICALITY       criticality_code,
        decode(pud.CRITICALITY, 'C', 'Critical',
                                'R', 'Recommended',
                                'O', 'Optional') criticality,
        decode(pud.criticality, 'C', 1, 'R', 2, 'O', 3) criticality_sort,
        pud.THREADING_LEVEL   threading_level,
        pud.FAILURE_POINT     failure_point,
        pud.LEGISLATIVELY_ENABLED legislatively_enabled,
        pud.UPGRADE_METHOD    upgrade_method,
        pud.UPGRADE_PROCEDURE upgrade_procedure,
        pud.QUALIFYING_PROCEDURE qualifying_procedure,
        app.DESCRIPTION       application_name,
        pud.VALIDATE_CODE     validate_code,
        pud.FIRST_PATCHSET    introduced,
        pud.ADDITIONAL_INFO   additional_info
from    pay_upgrade_definitions_tl pudt,
        pay_upgrade_definitions    pud,
        fnd_application_vl         app
where   pud.owner_application_id = app.application_id (+)
and     pudt.upgrade_definition_id = pud.upgrade_definition_id
and     ((pud.first_patchset like '%' || p_product || '%')
or      (p_product is null))
and     instr(p_importance, pud.criticality) > 0
and     pudt.language = userenv('LANG')
order   by criticality_sort, pudt.name;

Line: 91


  select pul.legislation_code
    from pay_upgrade_legislations pul
   where pul.upgrade_definition_id = lg_upgrade_definition_id;

Line: 96


  select pus.legislation_code  status_leg_code,
         bus.name              status_bg_name,
         decode(pus.status, 'C', 'Complete',
                            'P', 'Processing') status,
         pus.executed          executed,
         pus.request_id        request_id
    from pay_upgrade_status    pus,
         per_business_groups   bus
   where pus.upgrade_definition_id = lp_upgrade_definition_id
     and pus.business_group_id     = bus.business_group_id (+);

Line: 108


       select upgrade_definition_id
         from pay_upgrade_status
        where upgrade_definition_id = p_upgrade_definition_id;

Line: 113


  select user_profile_option_name
    from fnd_profile_options_vl
   where profile_option_name = p_config_option_name;

Line: 247


  PER_DATA_UPDATE_REPORT.summXMLTable.DELETE;

Line: 249


  PER_DATA_UPDATE_REPORT.critXMLTable.DELETE;

Line: 251


  PER_DATA_UPDATE_REPORT.vXMLTable.DELETE;

Line: 257


  PER_DATA_UPDATE_REPORT.summXMLTable(summCtr).TagValue := '<' || l_str_list_g_summary || '>' ;

Line: 264


  PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '<' || l_str_list_g_criticality || '>';

Line: 310


   PER_DATA_UPDATE_REPORT.summXMLTable(summCtr).TagValue := '<' || l_str_g_summary || '>';

Line: 313


   PER_DATA_UPDATE_REPORT.summXMLTable(summCtr).TagValue := '<' || l_str_process_name || '>' || l_c_data_start || l_cursor_get_data.process_name || l_c_data_end || '';

Line: 316


   PER_DATA_UPDATE_REPORT.summXMLTable(summCtr).TagValue := '<' || l_str_upgrade_level || '>' || l_cursor_get_data.upgrade_level || '';

Line: 319


   PER_DATA_UPDATE_REPORT.summXMLTable(summCtr).TagValue := '<' || l_str_required || '>' || l_required || '';

Line: 330


   PER_DATA_UPDATE_REPORT.summXMLTable(summCtr).TagValue := '<' || l_str_exec_status || '>' || l_exec_status || '';

Line: 333


   PER_DATA_UPDATE_REPORT.summXMLTable(summCtr).TagValue := '<' || l_str_introduced || '>' || l_cursor_get_data.introduced || '';

Line: 336


   PER_DATA_UPDATE_REPORT.summXMLTable(summCtr).TagValue := '<' || l_str_criticality || '>' || l_cursor_get_data.criticality || '';

Line: 350


    PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '<' || l_str_g_criticality || '>';

Line: 352


    PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '<' || l_str_criticality_code || '>' || l_cursor_get_data.criticality_code  || '';

Line: 354


    PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '<' || l_str_list_g_process || '>';

Line: 361


      PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '';

Line: 363


      PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '';

Line: 365


      PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '<' || l_str_g_criticality || '>';

Line: 368


      PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '<' || l_str_g_criticality || '>';

Line: 371


    PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '<' || l_str_criticality_code || '>' || l_cursor_get_data.criticality_code  || '';

Line: 373


    PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '<' || l_str_list_g_process  || '>';

Line: 380


      PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '';

Line: 382


      PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '';

Line: 384


      PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '<' || l_str_g_criticality || '>';

Line: 387


      PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '<' || l_str_g_criticality || '>';

Line: 390


    PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '<' || l_str_criticality_code || '>' || l_cursor_get_data.criticality_code  || '';

Line: 392


    PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '<' || l_str_list_g_process  || '>';

Line: 398


    PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '<' || l_str_g_process  || '>';

Line: 512


  PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '<' || l_str_upgrade_level || '>' || l_cursor_get_data.upgrade_level || '';

Line: 515


  PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '<' || l_str_criticality || '>' || l_cursor_get_data.criticality || '';

Line: 518


  PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '<' || l_str_process_name || '>' || l_c_data_start ||  l_cursor_get_data.process_name || l_c_data_end  || '';

Line: 521


  PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '<' || l_str_legislation_code || '>' || l_cursor_get_data.legislation_code || '';

Line: 524


  PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '<' || l_str_enabled_leg_code || '>' || l_enabled_leg_code || '' ;

Line: 527


  PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '<' || l_str_required || '>' || l_required || '';

Line: 530


  PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '<' || l_str_prepatch || '>' || l_prepatch || '';

Line: 533


  PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '<' || l_str_inpatch || '>' || l_inpatch || '';

Line: 536


  PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '<' || l_str_postpatch || '>' || l_postpatch || '';

Line: 539


  PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '<' || l_str_configurable || '>' || l_configurable || '';

Line: 542


  PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '<' || l_str_config_option_name || '>' || l_c_data_start || l_config_option_name || l_c_data_end || '';

Line: 545


  PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '<' || l_str_execution_point || '>' || l_execution_point || '';

Line: 548


  PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '<' || l_str_introduced || '>' || l_cursor_get_data.introduced || '';

Line: 551


  PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '<' || l_str_additional_info || '>' || l_c_data_start || l_cursor_get_data.additional_info || l_c_data_end || '';

Line: 557


    PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '<' || l_str_g_status || '>';

Line: 560


    PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '<' || l_str_status_leg_code || '>' || l_cursor_status_data.status_leg_code || '';

Line: 563


    PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '<' || l_str_status_bg_name || '>' || l_c_data_start || nvl(l_cursor_status_data.status_bg_name,'N/A') || l_c_data_end || '';

Line: 566


    PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '<' || l_str_status || '>' || l_cursor_status_data.status || '';

Line: 573


    PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '<' || l_str_executed || '>' || l_executed || '';

Line: 576


    PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '<' || l_str_request_id || '>' || to_char(l_request_id) || '';

Line: 579


    PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '';

Line: 584


PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '';

Line: 591


   PER_DATA_UPDATE_REPORT.summXMLTable(summCtr).TagValue := '';

Line: 603


    PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '';

Line: 605


  PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '';

Line: 608


  PER_DATA_UPDATE_REPORT.critXMLTable(critCtr).TagValue := '';

Line: 615


  PER_DATA_UPDATE_REPORT.summXMLTable(summCtr).TagValue := '';

Line: 637


  select name into l_database_name from v$database;

Line: 690


                SELECT value
                INTO l_audit_log_dir
                FROM v$parameter
                WHERE LOWER(name) = 'utl_file_dir';

Line: 716


  PER_DATA_UPDATE_REPORT.vXMLTable(vCtr).TagValue := '';

Line: 721


  select name into l_database_name from v$database;

Line: 722


  PER_DATA_UPDATE_REPORT.vXMLTable(vCtr).TagValue := '' || l_database_name || '';

Line: 729


            PER_DATA_UPDATE_REPORT.vXMLTable(vCtr).TagValue := summXMLTable(ctr_summ_table).TagValue;

Line: 738


            PER_DATA_UPDATE_REPORT.vXMLTable(vCtr).TagValue := critXMLTable(ctr_crit_table).TagValue;

Line: 745


  PER_DATA_UPDATE_REPORT.vXMLTable(vCtr).TagValue := '';

Line: 767


select file_data
into p_rtf_blob
from fnd_lobs
where file_name like '%/per/11.5.0/patch/115/publisher/templates/PERDTUPR.rtf';