DBA Data[Home] [Help]

APPS.HR_PHONE_API SQL Statements

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

Line: 283

procedure update_phone
  (p_phone_id                     in number,
  p_date_from                    in date             default hr_api.g_date,
  p_date_to                      in date             default hr_api.g_date,
  p_phone_type                   in varchar2         default hr_api.g_varchar2,
  p_phone_number                 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_attribute21                  in varchar2         default hr_api.g_varchar2,
  p_attribute22                  in varchar2         default hr_api.g_varchar2,
  p_attribute23                  in varchar2         default hr_api.g_varchar2,
  p_attribute24                  in varchar2         default hr_api.g_varchar2,
  p_attribute25                  in varchar2         default hr_api.g_varchar2,
  p_attribute26                  in varchar2         default hr_api.g_varchar2,
  p_attribute27                  in varchar2         default hr_api.g_varchar2,
  p_attribute28                  in varchar2         default hr_api.g_varchar2,
  p_attribute29                  in varchar2         default hr_api.g_varchar2,
  p_attribute30                  in varchar2         default hr_api.g_varchar2,
  p_object_version_number        in out nocopy number,
  p_validate                     in boolean          default false,
  p_effective_date               in date,
  p_party_id                     in number           default hr_api.g_number,
  p_validity                     in varchar2         default hr_api.g_varchar2
 )

is
  --
  -- Declare cursors and local variables
  --
  l_object_version_number per_phones.object_version_number%TYPE;
Line: 333

  l_proc                  varchar2(72) := g_package||'update_phone';
Line: 341

  savepoint update_phone;
Line: 351

      hr_phone_bk2.update_phone_b
   (p_phone_id                    =>     p_phone_id,
   p_date_from                    =>     p_date_from,
   p_date_to                      =>     p_date_to              ,
   p_phone_type                   =>     p_phone_type,
   p_phone_number                 =>     p_phone_number  ,
   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_attribute21                  =>     p_attribute21          ,
   p_attribute22                  =>     p_attribute22          ,
   p_attribute23                  =>     p_attribute23          ,
   p_attribute24                  =>     p_attribute24          ,
   p_attribute25                  =>     p_attribute25          ,
   p_attribute26                  =>     p_attribute26          ,
   p_attribute27                  =>     p_attribute27          ,
   p_attribute28                  =>     p_attribute28          ,
   p_attribute29                  =>     p_attribute29          ,
   p_attribute30                  =>     p_attribute30          ,
   p_object_version_number        =>     p_object_version_number,
   p_effective_date               =>     p_effective_date	,
   p_validity                     =>  	 p_validity);
Line: 394

          (p_module_name       => 'UPDATE_PHONE',
           p_hook_type         => 'BP'
         );
Line: 453

      hr_phone_bk2.update_phone_a
   (p_phone_id                    =>     p_phone_id,
   p_date_from                    =>     p_date_from,
   p_date_to                      =>     p_date_to              ,
   p_phone_type                   =>     p_phone_type,
   p_phone_number                 =>     p_phone_number  ,
   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_attribute21                  =>     p_attribute21          ,
   p_attribute22                  =>     p_attribute22          ,
   p_attribute23                  =>     p_attribute23          ,
   p_attribute24                  =>     p_attribute24          ,
   p_attribute25                  =>     p_attribute25          ,
   p_attribute26                  =>     p_attribute26          ,
   p_attribute27                  =>     p_attribute27          ,
   p_attribute28                  =>     p_attribute28          ,
   p_attribute29                  =>     p_attribute29          ,
   p_attribute30                  =>     p_attribute30          ,
   p_object_version_number        =>     l_object_version_number,
   p_effective_date               =>     p_effective_date 	,
   p_validity                     =>  	 p_validity);
Line: 497

          (p_module_name       => 'UPDATE_PHONE',
          p_hook_type         => 'AP'
          );
Line: 520

    ROLLBACK TO update_phone;
Line: 535

    ROLLBACK TO update_phone;
Line: 540

end update_phone;
Line: 546

procedure delete_phone
  (p_validate                       in     boolean  default false
  ,p_phone_id                       in     number
  ,p_object_version_number          in     number
  ) is
  --
  l_proc                varchar2(72) := g_package||'delete_phone';
Line: 559

  savepoint delete_phone;
Line: 570

      hr_phone_bk3.delete_phone_b
   (p_phone_id                       =>     p_phone_id
   ,p_object_version_number          =>     p_object_version_number
   );
Line: 577

          (p_module_name       => 'DELETE_PHONE',
           p_hook_type         => 'BP'
          );
Line: 595

      hr_phone_bk3.delete_phone_a
   (p_phone_id                       =>     p_phone_id
   ,p_object_version_number          =>     p_object_version_number
   );
Line: 602

          (p_module_name       => 'DELETE_PHONE',
           p_hook_type         => 'AP'
          );
Line: 624

    ROLLBACK TO delete_phone;
Line: 633

    ROLLBACK TO delete_phone;
Line: 638

end delete_phone;
Line: 643

procedure create_or_update_phone
 (p_update_mode                  in     varchar2     default hr_api.g_correction,
  p_phone_id                     in out nocopy number,
  p_object_version_number        in out nocopy number,
  p_date_from                    in date             default hr_api.g_date,
  p_date_to                      in date             default hr_api.g_date,
  p_phone_type                   in varchar2         default hr_api.g_varchar2,
  p_phone_number                 in varchar2         default hr_api.g_varchar2,
  p_parent_id                    in number           default hr_api.g_number,
  p_parent_table                 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_attribute21                  in varchar2         default hr_api.g_varchar2,
  p_attribute22                  in varchar2         default hr_api.g_varchar2,
  p_attribute23                  in varchar2         default hr_api.g_varchar2,
  p_attribute24                  in varchar2         default hr_api.g_varchar2,
  p_attribute25                  in varchar2         default hr_api.g_varchar2,
  p_attribute26                  in varchar2         default hr_api.g_varchar2,
  p_attribute27                  in varchar2         default hr_api.g_varchar2,
  p_attribute28                  in varchar2         default hr_api.g_varchar2,
  p_attribute29                  in varchar2         default hr_api.g_varchar2,
  p_attribute30                  in varchar2         default hr_api.g_varchar2,
  p_validate                     in boolean          default false,
  p_effective_date               in date,
  p_party_id                     in number           default hr_api.g_number,
  p_validity                     in varchar2         default hr_api.g_varchar2
 ) is
  --
  l_proc                varchar2(72) := g_package||'create_or_update_phone';
Line: 694

  l_update_mode varchar2(30);
Line: 701

  savepoint create_or_update_phone;
Line: 703

  l_update_mode:=p_update_mode;
Line: 823

    if (l_update_mode not in (hr_api.g_update,hr_api.g_correction)) then
      hr_utility.set_location(l_proc, 80);
Line: 855

      l_update_mode:= hr_api.g_correction;
Line: 860

    if l_update_mode = hr_api.g_correction then
      --
      -- correct the data
      --
      hr_utility.set_location(l_proc, 140);
Line: 866

      hr_phone_api.update_phone
      (p_date_from             => l_phn_rec.date_from
      ,p_date_to               => l_phn_rec.date_to
      ,p_phone_type            => l_phn_rec.phone_type
      ,p_phone_number          => l_phn_rec.phone_number
      ,p_attribute_category    => l_phn_rec.attribute_category
      ,p_attribute1            => l_phn_rec.attribute1
      ,p_attribute2            => l_phn_rec.attribute2
      ,p_attribute3            => l_phn_rec.attribute3
      ,p_attribute4            => l_phn_rec.attribute4
      ,p_attribute5            => l_phn_rec.attribute5
      ,p_attribute6            => l_phn_rec.attribute6
      ,p_attribute7            => l_phn_rec.attribute7
      ,p_attribute8            => l_phn_rec.attribute8
      ,p_attribute9            => l_phn_rec.attribute9
      ,p_attribute10           => l_phn_rec.attribute10
      ,p_attribute11           => l_phn_rec.attribute11
      ,p_attribute12           => l_phn_rec.attribute12
      ,p_attribute13           => l_phn_rec.attribute13
      ,p_attribute14           => l_phn_rec.attribute14
      ,p_attribute15           => l_phn_rec.attribute15
      ,p_attribute16           => l_phn_rec.attribute16
      ,p_attribute17           => l_phn_rec.attribute17
      ,p_attribute18           => l_phn_rec.attribute18
      ,p_attribute19           => l_phn_rec.attribute19
      ,p_attribute20           => l_phn_rec.attribute20
      ,p_attribute21           => l_phn_rec.attribute21
      ,p_attribute22           => l_phn_rec.attribute22
      ,p_attribute23           => l_phn_rec.attribute23
      ,p_attribute24           => l_phn_rec.attribute24
      ,p_attribute25           => l_phn_rec.attribute25
      ,p_attribute26           => l_phn_rec.attribute26
      ,p_attribute27           => l_phn_rec.attribute27
      ,p_attribute28           => l_phn_rec.attribute28
      ,p_attribute29           => l_phn_rec.attribute29
      ,p_attribute30           => l_phn_rec.attribute30
      ,p_validate              => FALSE
      ,p_effective_date        => l_effective_date
      ,p_object_version_number => l_phn_rec.object_version_number
      ,p_phone_id              => l_phn_rec.phone_id
      ,p_validity              => l_phn_rec.validity
      );
Line: 933

      hr_phone_api.update_phone
      (p_phone_id              => l_phn_rec.phone_id
      ,p_date_to               => l_effective_date-1
      ,p_object_version_number => l_phn_rec.object_version_number
      ,p_validate              => FALSE
      ,p_effective_date        => l_effective_date);
Line: 1005

    rollback to create_or_update_phone;
Line: 1011

    rollback to create_or_update_phone;
Line: 1015

end create_or_update_phone;