DBA Data[Home] [Help]

APPS.GHR_COMPLAINTS_CA_HEADERS_API SQL Statements

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

Line: 212

procedure update_ca_header
  (p_validate                     in     boolean   default false
  ,p_effective_date               in     date
  ,p_compl_ca_header_id           in     number
  ,p_object_version_number        in out nocopy number
  ,p_complaint_id                 in     number    default hr_api.g_number
  ,p_ca_source                    in     varchar2  default hr_api.g_varchar2
  ,p_last_compliance_report       in     date      default hr_api.g_date
  ,p_compliance_closed            in     date      default hr_api.g_date
  ,p_compl_docket_number          in     varchar2  default hr_api.g_varchar2
  ,p_appeal_docket_number         in     varchar2  default hr_api.g_varchar2
  ,p_pfe_docket_number            in     varchar2  default hr_api.g_varchar2
  ,p_pfe_received                 in     date      default hr_api.g_date
  ,p_agency_brief_pfe_due         in     date      default hr_api.g_date
  ,p_agency_brief_pfe_date        in     date      default hr_api.g_date
  ,p_decision_pfe_date            in     date      default hr_api.g_date
  ,p_decision_pfe                 in     varchar2  default hr_api.g_varchar2
  ,p_agency_recvd_pfe_decision    in     date      default hr_api.g_date
  ,p_agency_pfe_brief_forwd       in     date      default hr_api.g_date
  ,p_agency_notified_noncom       in     date      default hr_api.g_date
  ,p_comrep_noncom_req            in     varchar2  default hr_api.g_varchar2
  ,p_eeo_off_req_data_from_org    in     date      default hr_api.g_date
  ,p_org_forwd_data_to_eeo_off    in     date      default hr_api.g_date
  ,p_dec_implemented              in     date      default hr_api.g_date
  ,p_complaint_reinstated         in     date      default hr_api.g_date
  ,p_stage_complaint_reinstated   in     varchar2  default hr_api.g_varchar2
 )

is
  l_proc                varchar2(72) := g_package||'update_ca_header';
Line: 247

   savepoint update_ca_header;
Line: 258

    ghr_complaints_ca_headers_bk_2.update_ca_header_b
      (p_effective_date                 => trunc(p_effective_date)
      ,p_complaint_id                   => p_complaint_id
      ,p_ca_source                      => p_ca_source
      ,p_last_compliance_report         => p_last_compliance_report
      ,p_compliance_closed              => p_compliance_closed
      ,p_compl_docket_number            => p_compl_docket_number
      ,p_appeal_docket_number           => p_appeal_docket_number
      ,p_pfe_docket_number              => p_pfe_docket_number
      ,p_pfe_received                   => p_pfe_received
      ,p_agency_brief_pfe_due           => p_agency_brief_pfe_due
      ,p_agency_brief_pfe_date          => p_agency_brief_pfe_date
      ,p_decision_pfe_date              => p_decision_pfe_date
      ,p_decision_pfe                   => p_decision_pfe
      ,p_agency_recvd_pfe_decision      => p_agency_recvd_pfe_decision
      ,p_agency_pfe_brief_forwd         => p_agency_pfe_brief_forwd
      ,p_agency_notified_noncom         => p_agency_notified_noncom
      ,p_comrep_noncom_req              => p_comrep_noncom_req
      ,p_eeo_off_req_data_from_org      => p_eeo_off_req_data_from_org
      ,p_org_forwd_data_to_eeo_off      => p_org_forwd_data_to_eeo_off
      ,p_dec_implemented                => p_dec_implemented
      ,p_complaint_reinstated           => p_complaint_reinstated
      ,p_stage_complaint_reinstated     => p_stage_complaint_reinstated
      ,p_compl_ca_header_id             => p_compl_ca_header_id
      ,p_object_version_number          => p_object_version_number
      );
Line: 287

        (p_module_name => 'update_ca_header'
        ,p_hook_type   => 'BP'
        );
Line: 330

    ghr_complaints_ca_headers_bk_2.update_ca_header_a
      (p_effective_date                 => trunc(p_effective_date)
      ,p_complaint_id                   => p_complaint_id
      ,p_ca_source                      => p_ca_source
      ,p_last_compliance_report         => p_last_compliance_report
      ,p_compliance_closed              => p_compliance_closed
      ,p_compl_docket_number            => p_compl_docket_number
      ,p_appeal_docket_number           => p_appeal_docket_number
      ,p_pfe_docket_number              => p_pfe_docket_number
      ,p_pfe_received                   => p_pfe_received
      ,p_agency_brief_pfe_due           => p_agency_brief_pfe_due
      ,p_agency_brief_pfe_date          => p_agency_brief_pfe_date
      ,p_decision_pfe_date              => p_decision_pfe_date
      ,p_decision_pfe                   => p_decision_pfe
      ,p_agency_recvd_pfe_decision      => p_agency_recvd_pfe_decision
      ,p_agency_pfe_brief_forwd         => p_agency_pfe_brief_forwd
      ,p_agency_notified_noncom         => p_agency_notified_noncom
      ,p_comrep_noncom_req              => p_comrep_noncom_req
      ,p_eeo_off_req_data_from_org      => p_eeo_off_req_data_from_org
      ,p_org_forwd_data_to_eeo_off      => p_org_forwd_data_to_eeo_off
      ,p_dec_implemented                => p_dec_implemented
      ,p_complaint_reinstated           => p_complaint_reinstated
      ,p_stage_complaint_reinstated     => p_stage_complaint_reinstated
      ,p_compl_ca_header_id             => p_compl_ca_header_id
      ,p_object_version_number          => l_object_version_number
      );
Line: 359

        (p_module_name => 'update_ca_header'
        ,p_hook_type   => 'AP'
        );
Line: 381

    rollback to update_ca_header;
Line: 393

    rollback to update_ca_header;
Line: 399

end update_ca_header;
Line: 405

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

  savepoint delete_ca_header;
Line: 429

    ghr_complaints_ca_headers_bk_3.delete_ca_header_b
      (p_compl_ca_header_id            => p_compl_ca_header_id
      ,p_object_version_number         => p_object_version_number
      );
Line: 436

        (p_module_name => 'delete_ca_header'
        ,p_hook_type   => 'BP'
        );
Line: 453

    ghr_complaints_ca_headers_bk_3.delete_ca_header_a
      (p_compl_ca_header_id            => p_compl_ca_header_id
      ,p_object_version_number         => p_object_version_number
      );
Line: 460

        (p_module_name => 'delete_ca_header'
        ,p_hook_type   => 'AP'
        );
Line: 476

    ROLLBACK TO delete_ca_header;
Line: 479

    ROLLBACK TO delete_ca_header;
Line: 483

end delete_ca_header;