APPS.PQH_DE_INS_END_REASONS_API SQL Statements

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

Line: 12

procedure Insert_PENSION_END_REASONS
 ( p_validate                       in     boolean  default false
  ,p_effective_date                 in     date
  ,p_business_group_id              in     number
  ,p_provider_organization_id       in     number
  ,p_end_reason_number              in     varchar2
  ,p_end_reason_short_name          in     varchar2
  ,p_end_reason_description         in     varchar2
  ,p_InS_end_reason_id          out nocopy    number
  ,p_object_version_number          out nocopy    number
  )  is
  --
  -- Declare cursors and local variables
  --

  l_proc  varchar2(72)    := g_package||'Insert_PENSION_END_REASONS';

Line: 37

  savepoint Insert_PENSION_END_REASONS;

Line: 48

   PQH_DE_ins_END_REASONS_BK1.Insert_PENSION_END_REASONS_b
   (p_effective_date             => L_Effective_Date
   ,p_business_group_id          => p_business_group_id
   ,P_provider_organization_id   => P_provider_organization_id
   ,p_end_reason_number          => p_end_reason_number
   , p_end_reason_short_name     => p_end_reason_short_name
   ,p_end_reason_description     => p_end_reason_description
);

Line: 87

        PQH_DE_ins_END_REASONS_BK1.Insert_PENSION_END_REASONS_a
        (p_effective_date             => L_Effective_Date
        ,p_business_group_id          => p_business_group_id
        ,P_provider_organization_id   => P_provider_organization_id
        ,p_end_reason_number          => p_end_reason_number
        , p_end_reason_short_name     => p_end_reason_short_name
        ,p_end_reason_description     => p_end_reason_description
        ,p_InS_end_reason_id      => p_INS_end_reason_id
        ,p_object_version_number      => p_object_version_number
        );

Line: 101

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

Line: 125

    rollback to Insert_PENSION_END_REASONS;

Line: 141

    rollback to Insert_PENSION_END_REASONS;

Line: 144

end Insert_PENSION_END_REASONS;

Line: 151

procedure Update_PENSION_END_REASONS
 ( p_validate                      in     boolean  default false
  ,p_effective_date               in     date
  ,p_InS_end_reason_id        in     number
  ,p_object_version_number        in out nocopy number
  ,p_business_group_id            in     number    default hr_api.g_number
  ,p_provider_organization_id     in     number    default hr_api.g_number
  ,p_end_reason_number            in     varchar2  default hr_api.g_varchar2
  ,p_end_reason_short_name        in     varchar2  default hr_api.g_varchar2
  ,p_end_reason_description       in     varchar2  default hr_api.g_varchar2
  ) Is

  l_proc  varchar2(72)      := g_package||'Update_PENSION_END_REASONS';

Line: 172

  savepoint Update_PENSION_END_REASONS;

Line: 183

PQH_DE_ins_END_REASONS_BK2.Update_PENSION_END_REASONS_b
        (p_effective_date             => L_Effective_Date
        ,p_business_group_id          => p_business_group_id
        ,P_provider_organization_id   => P_provider_organization_id
        ,p_end_reason_number          => p_end_reason_number
        , p_end_reason_short_name     => p_end_reason_short_name
        ,p_end_reason_description     => p_end_reason_description
        ,p_InS_end_reason_id      => p_INS_end_reason_id
        ,p_object_version_number      => p_object_version_number
        );

Line: 198

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

Line: 221

 PQH_DE_ins_END_REASONS_BK2.Update_PENSION_END_REASONS_a
       (p_effective_date              => L_Effective_Date
        ,p_business_group_id          => p_business_group_id
        ,P_provider_organization_id   => P_provider_organization_id
        ,p_end_reason_number          => p_end_reason_number
        , p_end_reason_short_name     => p_end_reason_short_name
        ,p_end_reason_description     => p_end_reason_description
        ,p_InS_end_reason_id      => p_INS_end_reason_id
        ,p_object_version_number      => p_object_version_number
        );

Line: 236

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

Line: 260

    rollback to Update_PENSION_END_REASONS;

Line: 273

    rollback to Update_PENSION_END_REASONS;

Line: 276

end Update_PENSION_END_REASONS;

Line: 282

procedure delete_PENSION_END_REASONS
   (p_validate                      in     boolean  default false
  ,p_InS_end_reason_id       In     Number
  ,p_object_version_number         In     number) is

  -- Declare cursors and local variables
  --
  l_proc           varchar2(72) := g_package||'delete_PENSION_END_REASONS';

Line: 296

  savepoint delete_PENSION_END_REASONS;

Line: 301

  PQH_DE_ins_END_REASONS_BK3.Delete_PENSION_END_REASONS_b
  (p_InS_end_reason_id             =>   p_INS_END_REASON_Id
  ,p_object_version_number         =>   p_object_version_number);

Line: 307

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

Line: 322

  PQH_DE_ins_END_REASONS_BK3.Delete_PENSION_END_REASONS_a
  (p_InS_end_reason_id         =>   p_iNs_END_REASON_Id
  ,p_object_version_number         =>   p_object_version_number);

Line: 329

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

Line: 348

    rollback to delete_PENSION_END_REASONS;

Line: 359

    rollback to delete_PENSION_END_REASONS;

Line: 362

end delete_PENSION_END_REASONS;