APPS.PAY_PPE_API SQL Statements

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

Line: 23

  ,p_event_update_id                in     number     default null
  ,p_org_process_event_group_id     in     number     default null
  ,p_business_group_id              in     number     default null
  ,p_surrogate_key                  in     varchar2   default null
  ,p_calculation_date               in     date       default null
  ,p_retroactive_status             in     varchar2   default null
  ,p_noted_value                    in     varchar2   default null
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                  varchar2(72) := g_package||'create_process_event';

Line: 57

  ,p_event_update_id                => p_event_update_id
  ,p_org_process_event_group_id     => p_org_process_event_group_id
  ,p_business_group_id              => p_business_group_id
  ,p_surrogate_key                  => p_surrogate_key
  ,p_calculation_date               => p_calculation_date
  ,p_retroactive_status             => p_retroactive_status
  ,p_noted_value                    => p_noted_value
  );

Line: 82

  ,p_event_update_id                => p_event_update_id
  ,p_business_group_id              => p_business_group_id
  ,p_org_process_event_group_id     => p_org_process_event_group_id
  ,p_surrogate_key                  => p_surrogate_key
  ,p_calculation_date               => p_calculation_date
  ,p_retroactive_status             => p_retroactive_status
  ,p_noted_value                    => p_noted_value
  ,p_process_event_id               => l_process_event_id
  ,p_object_version_number          => l_object_version_number
  );

Line: 106

  ,p_event_update_id                => p_event_update_id
  ,p_org_process_event_group_id     => p_org_process_event_group_id
  ,p_business_group_id              => p_business_group_id
  ,p_surrogate_key                  => p_surrogate_key
  ,p_calculation_date               => p_calculation_date
  ,p_retroactive_status             => p_retroactive_status
  ,p_noted_value                    => p_noted_value
  );

Line: 148

procedure update_process_event
  (
   p_validate                       in     boolean default false
  ,p_process_event_id             in     number
  ,p_object_version_number        in out nocopy    number
  ,p_assignment_id                in     number    default hr_api.g_number
  ,p_effective_date               in     date      default hr_api.g_date
  ,p_change_type                  in     varchar2  default hr_api.g_varchar2
  ,p_status                       in     varchar2  default hr_api.g_varchar2
  ,p_description                  in     varchar2  default hr_api.g_varchar2
  ,p_event_update_id              in     number    default hr_api.g_number
  ,p_org_process_event_group_id   in     number    default hr_api.g_number
  ,p_business_group_id            in     number    default hr_api.g_number
  ,p_surrogate_key                in     varchar2  default hr_api.g_varchar2
  ,p_calculation_date             in     date      default hr_api.g_date
  ,p_retroactive_status           in     varchar2  default hr_api.g_varchar2
  ,p_noted_value                  in     varchar2  default hr_api.g_varchar2
  )is
  --
  -- Declare cursors and local variables
  --
  l_proc         varchar2(72) := g_package ||'update_process_event';

Line: 177

    savepoint update_process_event;

Line: 185

  pay_ppe_bk2.update_process_event_b
  (p_process_event_id               => p_process_event_id
  ,p_object_version_number          => p_object_version_number
  ,p_assignment_id                  => p_assignment_id
  ,p_effective_date                 => p_effective_date
  ,p_change_type                    => p_change_type
  ,p_status                         => p_status
  ,p_description                    => p_description
  ,p_event_update_id                => p_event_update_id
  ,p_org_process_event_group_id     => p_org_process_event_group_id
  ,p_business_group_id              => p_business_group_id
  ,p_surrogate_key                  => p_surrogate_key
  ,p_calculation_date               => p_calculation_date
  ,p_retroactive_status             => p_retroactive_status
  ,p_noted_value                    => p_noted_value
  );

Line: 204

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

Line: 217

  ,p_event_update_id                => p_event_update_id
  ,p_business_group_id              => p_business_group_id
  ,p_org_process_event_group_id     => p_org_process_event_group_id
  ,p_surrogate_key                  => p_surrogate_key
  ,p_calculation_date               => p_calculation_date
  ,p_retroactive_status             => p_retroactive_status
  ,p_noted_value                    => p_noted_value
  );

Line: 230

  pay_ppe_bk2.update_process_event_a
  (p_process_event_id               => p_process_event_id
  ,p_object_version_number          => p_object_version_number
  ,p_assignment_id                  => p_assignment_id
  ,p_effective_date                 => p_effective_date
  ,p_change_type                    => p_change_type
  ,p_status                         => p_status
  ,p_description                    => p_description
  ,p_event_update_id                => p_event_update_id
  ,p_org_process_event_group_id     => p_org_process_event_group_id
  ,p_business_group_id              => p_business_group_id
  ,p_surrogate_key                  => p_surrogate_key
  ,p_calculation_date               => p_calculation_date
  ,p_retroactive_status             => p_retroactive_status
  ,p_noted_value                    => p_noted_value
  );

Line: 249

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

Line: 268

    ROLLBACK TO update_process_event;

Line: 272

end update_process_event;

Line: 282

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

Line: 297

    savepoint delete_process_event;

Line: 305

  pay_ppe_bk3.delete_process_event_b
  (
    p_process_event_id         => p_process_event_id
   ,p_object_version_number    => l_object_version_number
  );

Line: 313

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

Line: 328

  pay_ppe_bk3.delete_process_event_a
  (
    p_process_event_id         => p_process_event_id
   ,p_object_version_number    => l_object_version_number
  );

Line: 336

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

Line: 350

    ROLLBACK TO delete_process_event;

Line: 352

end delete_process_event;