APPS.PQP_EXR_SWI SQL Statements

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

Line: 135

PROCEDURE delete_exception_report
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_exception_report_id          in     number
  ,p_object_version_number        in     number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 148

  l_proc    varchar2(72) := g_package ||'delete_exception_report';

Line: 154

  savepoint delete_exception_report_swi;

Line: 174

  pqp_exr_api.delete_exception_report
    (p_validate                     => l_validate
    ,p_exception_report_id          => p_exception_report_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 201

    rollback to delete_exception_report_swi;

Line: 215

    rollback to delete_exception_report_swi;

Line: 225

end delete_exception_report;

Line: 229

PROCEDURE update_exception_report
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_exception_report_name        in     varchar2  default hr_api.g_varchar2
  ,p_legislation_code             in     varchar2  default hr_api.g_varchar2
  ,p_business_group_id            in     number    default hr_api.g_number
  ,p_currency_code                in     varchar2  default hr_api.g_varchar2
  ,p_balance_type_id              in     number    default hr_api.g_number
  ,p_balance_dimension_id         in     number    default hr_api.g_number
  ,p_variance_type                in     varchar2  default hr_api.g_varchar2
  ,p_variance_value               in     number    default hr_api.g_number
  ,p_comparison_type              in     varchar2  default hr_api.g_varchar2
  ,p_comparison_value             in     number    default hr_api.g_number
  ,p_exception_report_id          in     number    default hr_api.g_number
  ,p_language_code                in     varchar2  default hr_api.g_varchar2
  ,p_object_version_number        in out nocopy number
  ,p_output_format_type           in     varchar2  default hr_api.g_varchar2
  ,p_variance_operator            in     varchar2  default hr_api.g_varchar2
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 256

  l_proc    varchar2(72) := g_package ||'update_exception_report';

Line: 262

  savepoint update_exception_report_swi;

Line: 283

  pqp_exr_api.update_exception_report
    (p_validate                     => l_validate
    ,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_language_code                => p_language_code
    ,p_object_version_number        => p_object_version_number
    ,p_output_format_type           => p_output_format_type
    ,p_variance_operator            => p_variance_operator
    );

Line: 323

    rollback to update_exception_report_swi;

Line: 338

    rollback to update_exception_report_swi;

Line: 349

end update_exception_report;

Line: 403

SELECT xtv.template_id FROM xdo_templates_vl xtv
where xtv.application_id=8303
and xtv.data_source_code = 'PQPRPEXR'
and xtv.template_name = p_template_name;

Line: 414

    SELECT PAY_US_RPT_TOTALS_S.NEXTVAL INTO l_ppa_finder
    FROM DUAL;

Line: 479

      SELECT substr(p.product_version,1,2) into l_product_release
        FROM fnd_application a, fnd_application_tl t, fnd_product_installations p
       WHERE a.application_id = p.application_id
         AND a.application_id = t.application_id
         AND t.language = Userenv ('LANG')
         AND Substr (a.application_short_name, 1, 5) = 'PAY';

Line: 608

           ,argument4=>l_request_name    --Select Report or Group
           ,argument5=>l_grp_request_code--'EG' if exception group else NULL
           ,argument6=>p_exception_grp_name
           ,argument7=>l_rep_request_code--'ER' if exception group else NULL
           ,argument8=>p_exception_report_id
           ,argument9=>p_variance_type
           ,argument10=>p_variance_value
           ,argument11=>p_payroll_id
           ,argument12=>p_consolidation_set_id
           ,argument13=>fnd_date.date_to_canonical(p_effective_date)
	   ,argument14=>p_template_name
	   ,argument15=>p_output_format
           );

Line: 654

  SELECT legislation_code
    INTO l_legislation_code_l
   FROM per_business_groups
   WHERE business_group_id      =p_business_group_id;

Line: 720

       Select application_short_name,template_code,default_language,default_territory
         from  xdo_templates_vl
        where template_name =c_template_name
	  and application_id=8303;

Line: 729

 SELECT exception_report_id
  FROM pqp_exception_reports
  WHERE exception_report_name=c_exception_report_id
    AND (business_group_id =c_business_group_id
     OR business_group_id IS NULL)
    AND (legislation_code=c_legislation_code
     OR legislation_code IS NULL);

Line: 799

          ,p_request_name    --Select Report or Group
          ,l_grp_request_code--'EG' if exception group else NULL
          ,p_exception_grp_name
          ,l_rep_request_code --p_rep_request_code--'ER' if exception group else NULL
          ,l_exception_report_id
          ,l_variance_type
          ,p_variance_value
          ,p_payroll_id
          ,p_consolidation_set_id
          ,p_effective_date--fnd_date.date_to_canonical(p_effective_date)
          );