APPS.GHR_PA_REMARKS_API SQL Statements

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

Line: 34

    Select pre.pa_remark_id,
          pre.object_version_number
    from  ghr_pa_remarks pre,
          ghr_noac_remarks nre
    where pre.pa_request_id     = p_pa_request_id and
          pre.remark_id         = p_remark_id and
          nre.remark_id         = pre.remark_id and
          (nre.nature_of_action_id =
                 (select par.first_noa_id
                  from   ghr_pa_requests par
                  where  pa_request_id = p_pa_request_id
                 ) or
          nre.nature_of_action_id =
                 (select par.second_noa_id
                  from   ghr_pa_requests par
                  where  pa_request_id = p_pa_request_id
                 )
            )
            and
          nvl(nre.required_flag,hr_api.g_varchar2)   = 'Y';

Line: 105

  update_pa_remarks
  (p_validate                 => p_validate
  ,p_pa_remark_id             => l_pa_remark_id
  ,p_description              => p_description
  ,p_remark_code_information1 => p_remark_code_information1
  ,p_remark_code_information2 => p_remark_code_information2
  ,p_remark_code_information3 => p_remark_code_information3
  ,p_remark_code_information4 => p_remark_code_information4
  ,p_remark_code_information5 => p_remark_code_information5
  ,p_object_version_number =>l_object_version_number
  );

Line: 203

procedure update_pa_remarks
  (p_validate                      in     boolean  default false
  ,p_pa_remark_id                  in     number
  ,p_object_version_number         in out nocopy number
  ,p_remark_code_information1      in     varchar2  default hr_api.g_varchar2
  ,p_remark_code_information2      in     varchar2  default hr_api.g_varchar2
  ,p_remark_code_information3      in     varchar2  default hr_api.g_varchar2
  ,p_remark_code_information4      in     varchar2  default hr_api.g_varchar2
  ,p_remark_code_information5      in     varchar2  default hr_api.g_varchar2
  ,p_description                   in     varchar2  default hr_api.g_varchar2
   )
is
  l_proc                varchar2(72) := g_package || 'update_pa_remarks';

Line: 223

    savepoint update_pa_remarks;

Line: 228

	ghr_pa_remarks_bk2.update_pa_remarks_b	(
           p_pa_remark_id             => p_pa_remark_id
          ,p_description              => p_description
          ,p_remark_code_information1 => p_remark_code_information1
          ,p_remark_code_information2 => p_remark_code_information2
          ,p_remark_code_information3 => p_remark_code_information3
          ,p_remark_code_information4 => p_remark_code_information4
          ,p_remark_code_information5 => p_remark_code_information5
          ,p_object_version_number    => p_object_version_number
	);

Line: 241

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

Line: 270

	ghr_pa_remarks_bk2.update_pa_remarks_a	(
           p_pa_remark_id             => p_pa_remark_id
          ,p_description              => p_description
          ,p_remark_code_information1 => p_remark_code_information1
          ,p_remark_code_information2 => p_remark_code_information2
          ,p_remark_code_information3 => p_remark_code_information3
          ,p_remark_code_information4 => p_remark_code_information4
          ,p_remark_code_information5 => p_remark_code_information5
          ,p_object_version_number    => l_object_version_number
	);

Line: 283

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

Line: 305

    ROLLBACK TO update_pa_remarks;

Line: 313

      ROLLBACK TO update_pa_remarks;

Line: 321

end update_pa_remarks;

Line: 329

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

Line: 341

    select  1
    from    ghr_noac_remarks  nre,
            ghr_pa_remarks    pre,
            ghr_pa_requests   par
    where   pre.pa_remark_id         = p_pa_remark_id
    and     par.pa_request_id        = pre.pa_request_id
    and     nre.remark_id            = pre.remark_id
    and     nre.nature_of_action_id  = par.first_noa_id
    and     nre.required_flag        = 'Y'
    and     nre.enabled_flag         = 'Y'
    and     nvl(par.effective_date,TRUNC(sysdate)) between nre.date_from
                         and nvl(nre.date_to,nvl(par.effective_date,TRUNC(sysdate)));

Line: 360

    select  1
    from    ghr_noac_remarks  nre,
            ghr_pa_remarks    pre,
            ghr_pa_requests   par
    where   pre.pa_remark_id         = p_pa_remark_id
    and     par.pa_request_id        = pre.pa_request_id
    and     nre.remark_id            = pre.remark_id
    and     nre.nature_of_action_id  = par.second_noa_id
    and     nre.required_flag        = 'Y'
    and     nre.enabled_flag         = 'Y'
    and     nvl(par.effective_date,TRUNC(sysdate)) between nre.date_from
                         and nvl(nre.date_to,nvl(par.effective_date,TRUNC(sysdate)));

Line: 377

    savepoint delete_pa_remarks;

Line: 383

	ghr_pa_remarks_bk3.delete_pa_remarks_b	(
              p_pa_remark_id            => p_pa_remark_id
             ,p_object_version_number   => p_object_version_number
		);

Line: 390

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

Line: 437

	ghr_pa_remarks_bk3.delete_pa_remarks_a	(
              p_pa_remark_id            => p_pa_remark_id
             ,p_object_version_number   => p_object_version_number
		);

Line: 444

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

Line: 464

    ROLLBACK TO delete_pa_remarks;

Line: 467

    ROLLBACK TO delete_pa_remarks;

Line: 471

end delete_pa_remarks;