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: 400

    SELECT TO_CHAR(sysdate,'HHSSSSS') INTO l_ppa_finder
    FROM DUAL;

Line: 514

           ,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: 560

  SELECT legislation_code
    INTO l_legislation_code_l
   FROM per_business_groups
   WHERE business_group_id      =p_business_group_id;

Line: 626

       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: 635

 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: 705

          ,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)
          );