APPS.PQP_ERT_SHD SQL Statements

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

Line: 58

    select
       exception_report_id
      ,exception_report_name
      ,language
      ,source_lang
    from  pqp_exception_reports_tl
    where exception_report_id = p_exception_report_id
    and   language = p_language;

Line: 123

    select
       exception_report_id
      ,exception_report_name
      ,language
      ,source_lang
    from        pqp_exception_reports_tl
    where       exception_report_id = p_exception_report_id
    and   language = p_language
    for update nowait;

Line: 184

  delete from PQP_EXCEPTION_REPORTS_TL T
  where not exists
    (select NULL
    from PQP_EXCEPTION_REPORTS B
    where B.EXCEPTION_REPORT_ID = T.EXCEPTION_REPORT_ID
    );

Line: 191

  update PQP_EXCEPTION_REPORTS_TL T set (
      EXCEPTION_REPORT_NAME
    ) = (select
      B.EXCEPTION_REPORT_NAME
    from PQP_EXCEPTION_REPORTS_TL B
    where B.EXCEPTION_REPORT_ID = T.EXCEPTION_REPORT_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.EXCEPTION_REPORT_ID,
      T.LANGUAGE
  ) in (select
      SUBT.EXCEPTION_REPORT_ID,
      SUBT.LANGUAGE
    from PQP_EXCEPTION_REPORTS_TL SUBB, PQP_EXCEPTION_REPORTS_TL SUBT
    where SUBB.EXCEPTION_REPORT_ID = SUBT.EXCEPTION_REPORT_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.EXCEPTION_REPORT_NAME <> SUBT.EXCEPTION_REPORT_NAME
  ));

Line: 211

  insert into PQP_EXCEPTION_REPORTS_TL (
    EXCEPTION_REPORT_ID,
    EXCEPTION_REPORT_NAME,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    CREATED_BY,
    CREATION_DATE,
--    OBJECT_VERSION_NUMBER,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.EXCEPTION_REPORT_ID,
    B.EXCEPTION_REPORT_NAME,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATE_LOGIN,
    B.CREATED_BY,
    B.CREATION_DATE,
--  B.OBJECT_VERSION_NUMBER,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from PQP_EXCEPTION_REPORTS_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from PQP_EXCEPTION_REPORTS_TL T
    where T.EXCEPTION_REPORT_ID = B.EXCEPTION_REPORT_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 282

 pqp_exr_api.update_exception_report (
                          p_exception_report_name   => p_exception_report_name
                         ,p_legislation_code        => p_legislation_code
                         ,p_business_group_id       => p_business_group_id
                         ,p_currency_code           => p_currency_code
                         ,p_balance_type_id         => p_balance_type_id
                         ,p_balance_dimension_id    => p_balance_dimension_id
                         ,p_variance_type           => p_variance_type
                         ,p_variance_value          => p_variance_value
                         ,p_comparison_type         => p_comparison_type
                         ,p_comparison_value        => p_comparison_value
                         ,p_exception_report_id     => p_exception_report_id
                         ,p_object_version_number   => p_object_version_number
                         ,p_output_format_type	    => p_output_format_type
                         ,p_variance_operator	    => p_variance_operator );