APPS.PER_ESTAB_ATTENDANCES_API SQL Statements

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

Line: 247

procedure UPDATE_ATTENDED_ESTAB
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_attendance_id                 in     number
  ,p_fulltime                      in     varchar2
  ,p_attended_start_date           in     date     default hr_api.g_date
  ,p_attended_end_date             in     date     default hr_api.g_date
  ,p_establishment                 in     varchar2 default hr_api.g_varchar2
  ,p_establishment_id              in     number   default hr_api.g_number
  ,p_address			   in     varchar2 default hr_api.g_varchar2
  ,p_attribute_category            in     varchar2 default hr_api.g_varchar2
  ,p_attribute1                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute2                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute3                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute4                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute5                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute6                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute7                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute8                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute9                    in     varchar2 default hr_api.g_varchar2
  ,p_attribute10                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute11                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute12                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute13                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute14                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute15                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute16                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute17                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute18                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute19                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute20                   in     varchar2 default hr_api.g_varchar2
  ,p_object_version_number         in out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --

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

Line: 295

  savepoint UPDATE_ATTENDED_ESTAB;

Line: 307

  PER_ESTAB_ATTENDANCES_BK2.UPDATE_ATTENDED_ESTAB_b
  (p_effective_date               => l_effective_date
  ,p_attendance_id                => p_attendance_id
  ,p_establishment_id             => p_establishment_id
  ,p_establishment                => p_establishment
  ,p_attended_start_date          => l_attended_start_date
  ,p_attended_end_date            => l_attended_end_date
  ,p_fulltime                     => p_fulltime
  ,p_attribute_category           => p_attribute_category
  ,p_attribute1                   => p_attribute1
  ,p_attribute2                   => p_attribute2
  ,p_attribute3                   => p_attribute3
  ,p_attribute4                   => p_attribute4
  ,p_attribute5                   => p_attribute5
  ,p_attribute6                   => p_attribute6
  ,p_attribute7                   => p_attribute7
  ,p_attribute8                   => p_attribute8
  ,p_attribute9                   => p_attribute9
  ,p_attribute10                  => p_attribute10
  ,p_attribute11                  => p_attribute11
  ,p_attribute12                  => p_attribute12
  ,p_attribute13                  => p_attribute13
  ,p_attribute14                  => p_attribute14
  ,p_attribute15                  => p_attribute15
  ,p_attribute16                  => p_attribute16
  ,p_attribute17                  => p_attribute17
  ,p_attribute18                  => p_attribute18
  ,p_attribute19                  => p_attribute19
  ,p_attribute20                  => p_attribute20
  ,p_object_version_number        => l_object_version_number
  ,p_address			  => p_address
  );

Line: 342

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

Line: 388

  PER_ESTAB_ATTENDANCES_BK2.UPDATE_ATTENDED_ESTAB_a
  (p_effective_date               => l_effective_date
  ,p_attendance_id                => p_attendance_id
  ,p_establishment_id             => p_establishment_id
  ,p_establishment                => p_establishment
  ,p_attended_start_date          => l_attended_start_date
  ,p_attended_end_date            => l_attended_end_date
  ,p_fulltime                     => p_fulltime
  ,p_attribute_category           => p_attribute_category
  ,p_attribute1                   => p_attribute1
  ,p_attribute2                   => p_attribute2
  ,p_attribute3                   => p_attribute3
  ,p_attribute4                   => p_attribute4
  ,p_attribute5                   => p_attribute5
  ,p_attribute6                   => p_attribute6
  ,p_attribute7                   => p_attribute7
  ,p_attribute8                   => p_attribute8
  ,p_attribute9                   => p_attribute9
  ,p_attribute10                  => p_attribute10
  ,p_attribute11                  => p_attribute11
  ,p_attribute12                  => p_attribute12
  ,p_attribute13                  => p_attribute13
  ,p_attribute14                  => p_attribute14
  ,p_attribute15                  => p_attribute15
  ,p_attribute16                  => p_attribute16
  ,p_attribute17                  => p_attribute17
  ,p_attribute18                  => p_attribute18
  ,p_attribute19                  => p_attribute19
  ,p_attribute20                  => p_attribute20
  ,p_object_version_number        => l_object_version_number
  ,p_address			  => p_address
  );

Line: 424

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

Line: 446

    rollback to UPDATE_ATTENDED_ESTAB;

Line: 457

    rollback to UPDATE_ATTENDED_ESTAB;

Line: 464

end UPDATE_ATTENDED_ESTAB;

Line: 472

procedure DELETE_ATTENDED_ESTAB
  (p_validate                      in     boolean  default false
  ,p_attendance_id                 in     number
  ,p_object_version_number         in     number
  ) is
  --
  -- Declare cursors and local variables
  --

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

Line: 487

  savepoint DELETE_ATTENDED_ESTAB;

Line: 492

  PER_ESTAB_ATTENDANCES_BK3.DELETE_ATTENDED_ESTAB_b
  (p_attendance_id                => p_attendance_id
  ,p_object_version_number        => p_object_version_number
  );

Line: 499

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

Line: 518

  PER_ESTAB_ATTENDANCES_BK3.DELETE_ATTENDED_ESTAB_a
  (p_attendance_id                => p_attendance_id
  ,p_object_version_number        => p_object_version_number
  );

Line: 526

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

Line: 547

    rollback to DELETE_ATTENDED_ESTAB;

Line: 558

    rollback to DELETE_ATTENDED_ESTAB;

Line: 561

end DELETE_ATTENDED_ESTAB;