eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_ELC_CONSTITUENCYS_API SQL Statements

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

Line: 288


procedure update_election_constituency
 (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_election_constituency_id      in out nocopy number
  ,p_election_id                   in     number   default hr_api.g_number
  ,p_business_group_id             in     number   default hr_api.g_number
  ,p_constituency_id               in     number   default hr_api.g_number
  ,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
  ) is
  --
  -- Declare cursors and local variables
  --
   l_object_version_number per_elections.object_version_number%TYPE;

Line: 337


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

Line: 344


  savepoint update_election_constituency;

Line: 372


  hr_utility.set_location('Entering: call - update_election_constituency_b ', 30);

Line: 376


hr_elc_constituencys_api_bk2.update_election_constituency_b
  (p_effective_date                =>   l_effective_date
  ,p_election_constituency_id		=>	p_election_constituency_id
  ,p_election_id				=>	p_election_id
  ,p_business_group_id             =>   p_business_group_id
  ,p_constituency_id               =>   p_constituency_id
  ,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
  );

Line: 418


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

Line: 470


  hr_utility.set_location('Entering: call - update_election_constituency_a', 50);

Line: 474


hr_elc_constituencys_api_bk2.update_election_constituency_a
  (p_effective_date                =>   l_effective_date
  ,p_election_constituency_id      =>   p_election_constituency_id
  ,p_election_id		   =>	p_election_id
  ,p_business_group_id             =>   p_business_group_id
  ,p_constituency_id               =>   p_constituency_id
  ,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
  );

Line: 517


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

Line: 536


    rollback to update_election_constituency;

Line: 549


    rollback to update_election_constituency;

Line: 557


end update_election_constituency;

Line: 563


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

Line: 576


  select election_id
  from per_election_constituencys
  where election_constituency_id = p_election_constituency_id;

Line: 586


  savepoint delete_election_constituency;

Line: 610


    hr_elc_constituencys_api_bk3.delete_election_constituency_b
      (
       p_election_constituency_id       =>  p_election_constituency_id
      ,p_object_version_number          =>  l_object_version_number
      );

Line: 618


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

Line: 638


    hr_elc_constituencys_api_bk3.delete_election_constituency_a
       (p_election_constituency_id       =>  p_election_constituency_id
      ,p_object_version_number          =>  l_object_version_number
      );

Line: 645


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

Line: 670


    ROLLBACK TO delete_election_constituency;

Line: 681


    ROLLBACK TO delete_election_constituency;

Line: 684


end delete_election_constituency;