DBA Data[Home] [Help]

APPS.GHR_AGENCY_APPEALS_API SQL Statements

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

Line: 234

procedure update_agency_appeal
  (p_validate                     in     boolean   default false
  ,p_effective_date               in     date
  ,p_compl_agency_appeal_id       in     number
  ,p_object_version_number        in out nocopy number
  ,p_complaint_id                 in     number    default hr_api.g_number
  ,p_appeal_date                  in     date      default hr_api.g_date
  ,p_reason_for_appeal            in     varchar2  default hr_api.g_varchar2
  ,p_source_decision_date         in     date      default hr_api.g_date
  ,p_docket_num                   in     varchar2  default hr_api.g_varchar2
  ,p_agency_recvd_req_for_files   in     date      default hr_api.g_date
  ,p_files_due                    in     date      default hr_api.g_date
  ,p_files_forwd                  in     date      default hr_api.g_date
  ,p_agency_brief_due             in     date      default hr_api.g_date
  ,p_agency_brief_forwd           in     date      default hr_api.g_date
  ,p_agency_recvd_appellant_brief in     date      default hr_api.g_date
  ,p_decision_date                in     date      default hr_api.g_date
  ,p_dec_recvd_by_agency          in     date      default hr_api.g_date
  ,p_decision                     in     varchar2  default hr_api.g_varchar2
  ,p_dec_forwd_to_org             in     date      default hr_api.g_date
  ,p_agency_rfr_suspense          in     date      default hr_api.g_date
  ,p_request_for_rfr              in     date      default hr_api.g_date
  ,p_rfr_docket_num               in     varchar2  default hr_api.g_varchar2
  ,p_rfr_requested_by             in     varchar2  default hr_api.g_varchar2
  ,p_agency_rfr_due               in     date      default hr_api.g_date
  ,p_rfr_forwd_to_org             in     date      default hr_api.g_date
  ,p_org_forwd_rfr_to_agency      in     date      default hr_api.g_date
  ,p_agency_forwd_rfr_ofo         in     date      default hr_api.g_date
  ,p_rfr_decision                 in     varchar2  default hr_api.g_varchar2
  ,p_rfr_decision_date            in     date      default hr_api.g_date
  ,p_agency_recvd_rfr_dec         in     date      default hr_api.g_date
  ,p_rfr_decision_forwd_to_org    in     date      default hr_api.g_date
)

is
  l_proc                  varchar2(72) := g_package||'update_agency_appeal';
Line: 274

   savepoint update_agency_appeal;
Line: 282

    ghr_agency_appeals_bk_2.update_agency_appeal_b
      (p_effective_date                 => trunc(p_effective_date)
      ,p_compl_agency_appeal_id         => p_compl_agency_appeal_id
      ,p_complaint_id                   => p_complaint_id
      ,p_appeal_date                    => p_appeal_date
      ,p_reason_for_appeal              => p_reason_for_appeal
      ,p_source_decision_date           => p_source_decision_date
      ,p_docket_num                     => p_docket_num
      ,p_agency_recvd_req_for_files     => p_agency_recvd_req_for_files
      ,p_files_due                      => p_files_due
      ,p_files_forwd                    => p_files_forwd
      ,p_agency_brief_due               => p_agency_brief_due
      ,p_agency_brief_forwd             => p_agency_brief_forwd
      ,p_agency_recvd_appellant_brief   => p_agency_recvd_appellant_brief
      ,p_decision_date                  => p_decision_date
      ,p_dec_recvd_by_agency            => p_dec_recvd_by_agency
      ,p_decision                       => p_decision
      ,p_dec_forwd_to_org               => p_dec_forwd_to_org
      ,p_agency_rfr_suspense            => p_agency_rfr_suspense
      ,p_request_for_rfr                => p_request_for_rfr
      ,p_rfr_docket_num                 => p_rfr_docket_num
      ,p_rfr_requested_by               => p_rfr_requested_by
      ,p_agency_rfr_due                 => p_agency_rfr_due
      ,p_rfr_forwd_to_org               => p_rfr_forwd_to_org
      ,p_org_forwd_rfr_to_agency        => p_org_forwd_rfr_to_agency
      ,p_agency_forwd_rfr_ofo           => p_agency_forwd_rfr_ofo
      ,p_rfr_decision                   => p_rfr_decision
      ,p_rfr_decision_date              => p_rfr_decision_date
      ,p_agency_recvd_rfr_dec           => p_agency_recvd_rfr_dec
      ,p_rfr_decision_forwd_to_org      => p_rfr_decision_forwd_to_org
      ,p_object_version_number          => p_object_version_number
      );
Line: 317

        (p_module_name => 'update_agency_appeal'
        ,p_hook_type   => 'BP'
        );
Line: 366

    ghr_agency_appeals_bk_2.update_agency_appeal_a
      (p_effective_date                 => trunc(p_effective_date)
      ,p_compl_agency_appeal_id         => p_compl_agency_appeal_id
      ,p_complaint_id                   => p_complaint_id
      ,p_appeal_date                    => p_appeal_date
      ,p_reason_for_appeal              => p_reason_for_appeal
      ,p_source_decision_date           => p_source_decision_date
      ,p_docket_num                     => p_docket_num
      ,p_agency_recvd_req_for_files     => p_agency_recvd_req_for_files
      ,p_files_due                      => p_files_due
      ,p_files_forwd                    => p_files_forwd
      ,p_agency_brief_due               => p_agency_brief_due
      ,p_agency_brief_forwd             => p_agency_brief_forwd
      ,p_agency_recvd_appellant_brief   => p_agency_recvd_appellant_brief
      ,p_decision_date                  => p_decision_date
      ,p_dec_recvd_by_agency            => p_dec_recvd_by_agency
      ,p_decision                       => p_decision
      ,p_dec_forwd_to_org               => p_dec_forwd_to_org
      ,p_agency_rfr_suspense            => p_agency_rfr_suspense
      ,p_request_for_rfr                => p_request_for_rfr
      ,p_rfr_docket_num                 => p_rfr_docket_num
      ,p_rfr_requested_by               => p_rfr_requested_by
      ,p_agency_rfr_due                 => p_agency_rfr_due
      ,p_rfr_forwd_to_org               => p_rfr_forwd_to_org
      ,p_org_forwd_rfr_to_agency        => p_org_forwd_rfr_to_agency
      ,p_agency_forwd_rfr_ofo           => p_agency_forwd_rfr_ofo
      ,p_rfr_decision                   => p_rfr_decision
      ,p_rfr_decision_date              => p_rfr_decision_date
      ,p_agency_recvd_rfr_dec           => p_agency_recvd_rfr_dec
      ,p_rfr_decision_forwd_to_org      => p_rfr_decision_forwd_to_org
      ,p_object_version_number          => l_object_version_number
      );
Line: 401

        (p_module_name => 'update_agency_appeal'
        ,p_hook_type   => 'AP'
        );
Line: 423

    rollback to update_agency_appeal;
Line: 435

    rollback to update_agency_appeal;
Line: 440

end update_agency_appeal;
Line: 446

procedure delete_agency_appeal
  (p_validate                      in     boolean  default false
  ,p_compl_agency_appeal_id        in     number
  ,p_object_version_number         in     number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                  varchar2(72) := g_package||'delete_agency_appeal';
Line: 461

  savepoint delete_agency_appeal;
Line: 469

    ghr_agency_appeals_bk_3.delete_agency_appeal_b
      (p_compl_agency_appeal_id            => p_compl_agency_appeal_id
      ,p_object_version_number             => p_object_version_number
      );
Line: 476

        (p_module_name => 'delete_agency_appeal'
        ,p_hook_type   => 'BP'
        );
Line: 495

    ghr_agency_appeals_bk_3.delete_agency_appeal_a
      (p_compl_agency_appeal_id            => p_compl_agency_appeal_id
      ,p_object_version_number             => p_object_version_number
      );
Line: 502

        (p_module_name => 'delete_agency_appeal'
        ,p_hook_type   => 'AP'
        );
Line: 518

    ROLLBACK TO delete_agency_appeal;
Line: 521

    ROLLBACK TO delete_agency_appeal;
Line: 525

end delete_agency_appeal;