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.PER_BF_PROC_ASSIGNMENT_API SQL Statements

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

Line: 16


    SELECT 'Y'
      FROM per_bf_processed_assignments
     WHERE payroll_run_id = p_payroll_run_id
       AND assignment_id = p_assignment_id;

Line: 299


procedure update_processed_assignment
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_processed_assignment_id       in     number
  ,p_bpa_attribute_category            in     varchar2 default hr_api.g_varchar2
  ,p_bpa_attribute1                    in     varchar2 default hr_api.g_varchar2
  ,p_bpa_attribute2                    in     varchar2 default hr_api.g_varchar2
  ,p_bpa_attribute3                    in     varchar2 default hr_api.g_varchar2
  ,p_bpa_attribute4                    in     varchar2 default hr_api.g_varchar2
  ,p_bpa_attribute5                    in     varchar2 default hr_api.g_varchar2
  ,p_bpa_attribute6                    in     varchar2 default hr_api.g_varchar2
  ,p_bpa_attribute7                    in     varchar2 default hr_api.g_varchar2
  ,p_bpa_attribute8                    in     varchar2 default hr_api.g_varchar2
  ,p_bpa_attribute9                    in     varchar2 default hr_api.g_varchar2
  ,p_bpa_attribute10                   in     varchar2 default hr_api.g_varchar2
  ,p_bpa_attribute11                   in     varchar2 default hr_api.g_varchar2
  ,p_bpa_attribute12                   in     varchar2 default hr_api.g_varchar2
  ,p_bpa_attribute13                   in     varchar2 default hr_api.g_varchar2
  ,p_bpa_attribute14                   in     varchar2 default hr_api.g_varchar2
  ,p_bpa_attribute15                   in     varchar2 default hr_api.g_varchar2
  ,p_bpa_attribute16                   in     varchar2 default hr_api.g_varchar2
  ,p_bpa_attribute17                   in     varchar2 default hr_api.g_varchar2
  ,p_bpa_attribute18                   in     varchar2 default hr_api.g_varchar2
  ,p_bpa_attribute19                   in     varchar2 default hr_api.g_varchar2
  ,p_bpa_attribute20                   in     varchar2 default hr_api.g_varchar2
  ,p_bpa_attribute21                   in     varchar2 default hr_api.g_varchar2
  ,p_bpa_attribute22                   in     varchar2 default hr_api.g_varchar2
  ,p_bpa_attribute23                   in     varchar2 default hr_api.g_varchar2
  ,p_bpa_attribute24                   in     varchar2 default hr_api.g_varchar2
  ,p_bpa_attribute25                   in     varchar2 default hr_api.g_varchar2
  ,p_bpa_attribute26                   in     varchar2 default hr_api.g_varchar2
  ,p_bpa_attribute27                   in     varchar2 default hr_api.g_varchar2
  ,p_bpa_attribute28                   in     varchar2 default hr_api.g_varchar2
  ,p_bpa_attribute29                   in     varchar2 default hr_api.g_varchar2
  ,p_bpa_attribute30                   in     varchar2 default hr_api.g_varchar2
  ,p_processed_assignment_ovn      in out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_processed_assignment_id   NUMBER;

Line: 344


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

Line: 350


  savepoint update_processed_assignment;

Line: 360


    PER_BF_PROC_ASSIGNMENT_BK2.UPDATE_PROCESSED_ASSIGNMENT_B
      (p_effective_date                => p_effective_date
      ,p_bpa_attribute_category            => p_bpa_attribute_category
      ,p_bpa_attribute1                    => p_bpa_attribute1
      ,p_bpa_attribute2                    => p_bpa_attribute2
      ,p_bpa_attribute3                    => p_bpa_attribute3
      ,p_bpa_attribute4                    => p_bpa_attribute4
      ,p_bpa_attribute5                    => p_bpa_attribute5
      ,p_bpa_attribute6                    => p_bpa_attribute6
      ,p_bpa_attribute7                    => p_bpa_attribute7
      ,p_bpa_attribute8                    => p_bpa_attribute8
      ,p_bpa_attribute9                    => p_bpa_attribute9
      ,p_bpa_attribute10                   => p_bpa_attribute10
      ,p_bpa_attribute11                   => p_bpa_attribute11
      ,p_bpa_attribute12                   => p_bpa_attribute12
      ,p_bpa_attribute13                   => p_bpa_attribute13
      ,p_bpa_attribute14                   => p_bpa_attribute14
      ,p_bpa_attribute15                   => p_bpa_attribute15
      ,p_bpa_attribute16                   => p_bpa_attribute16
      ,p_bpa_attribute17                   => p_bpa_attribute17
      ,p_bpa_attribute18                   => p_bpa_attribute18
      ,p_bpa_attribute19                   => p_bpa_attribute19
      ,p_bpa_attribute20                   => p_bpa_attribute20
      ,p_bpa_attribute21                   => p_bpa_attribute21
      ,p_bpa_attribute22                   => p_bpa_attribute22
      ,p_bpa_attribute23                   => p_bpa_attribute23
      ,p_bpa_attribute24                   => p_bpa_attribute24
      ,p_bpa_attribute25                   => p_bpa_attribute25
      ,p_bpa_attribute26                   => p_bpa_attribute26
      ,p_bpa_attribute27                   => p_bpa_attribute27
      ,p_bpa_attribute28                   => p_bpa_attribute28
      ,p_bpa_attribute29                   => p_bpa_attribute29
      ,p_bpa_attribute30                   => p_bpa_attribute30
      ,p_processed_assignment_id       => p_processed_assignment_id
      ,p_processed_assignment_ovn      => p_processed_assignment_ovn
       );

Line: 400


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

Line: 453


    PER_BF_PROC_ASSIGNMENT_BK2.UPDATE_PROCESSED_ASSIGNMENT_A
      (p_effective_date                => p_effective_date
      ,p_processed_assignment_id       => p_processed_assignment_id
      ,p_bpa_attribute_category            => p_bpa_attribute_category
      ,p_bpa_attribute1                    => p_bpa_attribute1
      ,p_bpa_attribute2                    => p_bpa_attribute2
      ,p_bpa_attribute3                    => p_bpa_attribute3
      ,p_bpa_attribute4                    => p_bpa_attribute4
      ,p_bpa_attribute5                    => p_bpa_attribute5
      ,p_bpa_attribute6                    => p_bpa_attribute6
      ,p_bpa_attribute7                    => p_bpa_attribute7
      ,p_bpa_attribute8                    => p_bpa_attribute8
      ,p_bpa_attribute9                    => p_bpa_attribute9
      ,p_bpa_attribute10                   => p_bpa_attribute10
      ,p_bpa_attribute11                   => p_bpa_attribute11
      ,p_bpa_attribute12                   => p_bpa_attribute12
      ,p_bpa_attribute13                   => p_bpa_attribute13
      ,p_bpa_attribute14                   => p_bpa_attribute14
      ,p_bpa_attribute15                   => p_bpa_attribute15
      ,p_bpa_attribute16                   => p_bpa_attribute16
      ,p_bpa_attribute17                   => p_bpa_attribute17
      ,p_bpa_attribute18                   => p_bpa_attribute18
      ,p_bpa_attribute19                   => p_bpa_attribute19
      ,p_bpa_attribute20                   => p_bpa_attribute20
      ,p_bpa_attribute21                   => p_bpa_attribute21
      ,p_bpa_attribute22                   => p_bpa_attribute22
      ,p_bpa_attribute23                   => p_bpa_attribute23
      ,p_bpa_attribute24                   => p_bpa_attribute24
      ,p_bpa_attribute25                   => p_bpa_attribute25
      ,p_bpa_attribute26                   => p_bpa_attribute26
      ,p_bpa_attribute27                   => p_bpa_attribute27
      ,p_bpa_attribute28                   => p_bpa_attribute28
      ,p_bpa_attribute29                   => p_bpa_attribute29
      ,p_bpa_attribute30                   => p_bpa_attribute30
      ,p_processed_assignment_ovn      => l_processed_assignment_ovn
      );

Line: 492


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

Line: 515


    rollback to update_processed_assignment;

Line: 528


    rollback to update_processed_assignment;

Line: 533


end UPDATE_PROCESSED_ASSIGNMENT;

Line: 539


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

Line: 554


  savepoint delete_processed_assignment;

Line: 563


    PER_BF_PROC_ASSIGNMENT_BK3.DELETE_PROCESSED_ASSIGNMENT_B
      (p_processed_assignment_id       => p_processed_assignment_id
      ,p_processed_assignment_ovn      => p_processed_assignment_ovn
       );

Line: 571


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

Line: 595


    PER_BF_PROC_ASSIGNMENT_BK3.DELETE_PROCESSED_ASSIGNMENT_A
      (
       p_processed_assignment_id       => p_processed_assignment_id
      ,p_processed_assignment_ovn      => p_processed_assignment_ovn
      );

Line: 603


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

Line: 624


    rollback to delete_processed_assignment;

Line: 635


    rollback to delete_processed_assignment;

Line: 638


end DELETE_PROCESSED_ASSIGNMENT;