eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_COMPLAINANT_APPEALS_API SQL Statements

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

Line: 249


procedure update_complainant_appeal
  (p_validate                     in     boolean   default false
  ,p_effective_date               in     date
  ,p_compl_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_appealed_to                  in     varchar2  default hr_api.g_varchar2
  ,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_org_notified_of_appeal       in     date      default hr_api.g_date
  ,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_agcy_recvd_appellant_brief   in     date      default hr_api.g_date
  ,p_agency_brief_due             in     date      default hr_api.g_date
  ,p_appellant_brief_forwd_org    in     date      default hr_api.g_date
  ,p_org_forwd_brief_to_agency    in     date      default hr_api.g_date
  ,p_agency_brief_forwd           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_complaint_appeal';

Line: 293


   savepoint update_complainant_appeal;

Line: 304


    ghr_complainant_appeals_bk_2.update_complainant_appeal_b
      (p_effective_date                 => trunc(p_effective_date)
      ,p_complaint_id                   => p_complaint_id
      ,p_appeal_date                    => p_appeal_date
      ,p_appealed_to                    => p_appealed_to
      ,p_reason_for_appeal              => p_reason_for_appeal
      ,p_source_decision_date           => p_source_decision_date
      ,p_docket_num                     => p_docket_num
      ,p_org_notified_of_appeal         => p_org_notified_of_appeal
      ,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_agcy_recvd_appellant_brief     => p_agcy_recvd_appellant_brief
      ,p_agency_brief_due               => p_agency_brief_due
      ,p_appellant_brief_forwd_org      => p_appellant_brief_forwd_org
      ,p_org_forwd_brief_to_agency      => p_org_forwd_brief_to_agency
      ,p_agency_brief_forwd             => p_agency_brief_forwd
      ,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_compl_appeal_id                => p_compl_appeal_id
      ,p_object_version_number          => p_object_version_number
      );

Line: 343


        (p_module_name => 'update_complainant_appeal'
        ,p_hook_type   => 'BP'
        );

Line: 394


    ghr_complainant_appeals_bk_2.update_complainant_appeal_a
      (p_effective_date                 => trunc(p_effective_date)
      ,p_complaint_id                   => p_complaint_id
      ,p_appeal_date                    => p_appeal_date
      ,p_appealed_to                    => p_appealed_to
      ,p_reason_for_appeal              => p_reason_for_appeal
      ,p_source_decision_date           => p_source_decision_date
      ,p_docket_num                     => p_docket_num
      ,p_org_notified_of_appeal         => p_org_notified_of_appeal
      ,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_agcy_recvd_appellant_brief     => p_agcy_recvd_appellant_brief
      ,p_agency_brief_due               => p_agency_brief_due
      ,p_appellant_brief_forwd_org      => p_appellant_brief_forwd_org
      ,p_org_forwd_brief_to_agency      => p_org_forwd_brief_to_agency
      ,p_agency_brief_forwd             => p_agency_brief_forwd
      ,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_compl_appeal_id                => p_compl_appeal_id
      ,p_object_version_number          => l_object_version_number
      );

Line: 433


        (p_module_name => 'update_complainant_appeal'
        ,p_hook_type   => 'AP'
        );

Line: 456


    rollback to update_complainant_appeal;

Line: 469


    rollback to update_complainant_appeal;

Line: 475


end update_complainant_appeal;

Line: 481


procedure delete_complainant_appeal
  (p_validate                      in     boolean  default false
  ,p_compl_appeal_id               in     number
  ,p_object_version_number         in     number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                  varchar2(72) := g_package||'delete_complaint_appeal';

Line: 496


  savepoint delete_complainant_appeal;

Line: 505


    ghr_complainant_appeals_bk_3.delete_complainant_appeal_b
      (p_compl_appeal_id                   => p_compl_appeal_id
      ,p_object_version_number             => p_object_version_number
      );

Line: 512


        (p_module_name => 'delete_complainant_appeal'
        ,p_hook_type   => 'BP'
        );

Line: 529


    ghr_complainant_appeals_bk_3.delete_complainant_appeal_a
      (p_compl_appeal_id                   => p_compl_appeal_id
      ,p_object_version_number             => p_object_version_number
      );

Line: 536


        (p_module_name => 'delete_complainant_appeal'
        ,p_hook_type   => 'AP'
        );

Line: 553


    ROLLBACK TO delete_complainant_appeal;

Line: 556


    ROLLBACK TO delete_complainant_appeal;

Line: 560


end delete_complainant_appeal;