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_ALLOCATED_TASK_API SQL Statements

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

Line: 390


procedure UPDATE_ALLOC_TASK
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_allocated_task_id             in     number
  ,p_allocated_checklist_id        in     number
  ,p_task_name                     in     varchar2 default null
  ,p_description                   in     varchar2 default null
  ,p_performer_orig_system         in     varchar2 default null
  ,p_performer_orig_sys_id      in     number   default null
  ,p_task_owner_person_id          in     number   default null
  ,p_task_sequence                 in     number   default null
  ,p_target_start_date             in     date     default null
  ,p_target_end_date               in     date     default null
  ,p_actual_start_date             in     date     default null
  ,p_actual_end_date               in     date     default null
  ,p_action_url                    in     varchar2 default null
  ,p_mandatory_flag                in     varchar2 default null
  ,p_status                        in     varchar2 default null
  ,p_attribute_category            in     varchar2 default null
  ,p_attribute1                    in     varchar2 default null
  ,p_attribute2                    in     varchar2 default null
  ,p_attribute3                    in     varchar2 default null
  ,p_attribute4                    in     varchar2 default null
  ,p_attribute5                    in     varchar2 default null
  ,p_attribute6                    in     varchar2 default null
  ,p_attribute7                    in     varchar2 default null
  ,p_attribute8                    in     varchar2 default null
  ,p_attribute9                    in     varchar2 default null
  ,p_attribute10                   in     varchar2 default null
  ,p_attribute11                   in     varchar2 default null
  ,p_attribute12                   in     varchar2 default null
  ,p_attribute13                   in     varchar2 default null
  ,p_attribute14                   in     varchar2 default null
  ,p_attribute15                   in     varchar2 default null
  ,p_attribute16                   in     varchar2 default null
  ,p_attribute17                   in     varchar2 default null
  ,p_attribute18                   in     varchar2 default null
  ,p_attribute19                   in     varchar2 default null
  ,p_attribute20                   in     varchar2 default null
  ,p_information_category          in     varchar2 default null
  ,p_information1                  in     varchar2 default null
  ,p_information2                  in     varchar2 default null
  ,p_information3                  in     varchar2 default null
  ,p_information4                  in     varchar2 default null
  ,p_information5                  in     varchar2 default null
  ,p_information6                  in     varchar2 default null
  ,p_information7                  in     varchar2 default null
  ,p_information8                  in     varchar2 default null
  ,p_information9                  in     varchar2 default null
  ,p_information10                 in     varchar2 default null
  ,p_information11                 in     varchar2 default null
  ,p_information12                 in     varchar2 default null
  ,p_information13                 in     varchar2 default null
  ,p_information14                 in     varchar2 default null
  ,p_information15                 in     varchar2 default null
  ,p_information16                 in     varchar2 default null
  ,p_information17                 in     varchar2 default null
  ,p_information18                 in     varchar2 default null
  ,p_information19                 in     varchar2 default null
  ,p_information20                 in     varchar2 default null
  ,p_object_version_number         in out nocopy   number
  ) is

  --
  -- Declare cursors and local variables
  --
  l_proc                      varchar2(72) := g_package||'update_task';

Line: 466


  savepoint UPDATE_ALLOC_TASK;

Line: 487


    PER_ALLOCATED_TASK_BK2.UPDATE_ALLOC_TASK_B
     (p_effective_date                => l_effective_date
     ,p_allocated_checklist_id        => p_allocated_checklist_id
     ,p_task_name                     => p_task_name
     ,p_description                   => p_description
     ,p_performer_orig_system         => p_performer_orig_system
     ,p_performer_orig_sys_id      => p_performer_orig_sys_id
     ,p_task_owner_person_id          => p_task_owner_person_id
     ,p_task_sequence                 => p_task_sequence
     ,p_target_start_date             => p_target_start_date
     ,p_target_end_date               => p_target_end_date
     ,p_actual_start_date             => p_actual_start_date
     ,p_actual_end_date               => p_actual_end_date
--
     ,p_action_url                    => p_action_url
     ,p_mandatory_flag                => p_mandatory_flag
     ,p_status                        => p_status
     ,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_information_category          => p_information_category
     ,p_information1                  => p_information1
     ,p_information2                  => p_information2
     ,p_information3                  => p_information3
     ,p_information4                  => p_information4
     ,p_information5                  => p_information5
     ,p_information6                  => p_information6
     ,p_information7                  => p_information7
     ,p_information8                  => p_information8
     ,p_information9                  => p_information9
     ,p_information10                 => p_information10
     ,p_information11                 => p_information11
     ,p_information12                 => p_information12
     ,p_information13                 => p_information13
     ,p_information14                 => p_information14
     ,p_information15                 => p_information15
     ,p_information16                 => p_information16
     ,p_information17                 => p_information17
     ,p_information18                 => p_information18
     ,p_information19                 => p_information19
     ,p_information20                 => p_information20
     ,p_allocated_task_id             => p_allocated_task_id
     ,p_object_version_number         => l_object_version_number

     );

Line: 554


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

Line: 629


  PER_ALLOCATED_TASK_BK2.UPDATE_ALLOC_TASK_A
     (p_effective_date                => l_effective_date
     ,p_allocated_checklist_id        => p_allocated_checklist_id
     ,p_task_name                     => p_task_name
     ,p_description                   => p_description
     ,p_performer_orig_system         => p_performer_orig_system
     ,p_performer_orig_sys_id      => p_performer_orig_sys_id
     ,p_task_owner_person_id          => p_task_owner_person_id
     ,p_task_sequence                 => p_task_sequence
     ,p_target_start_date             => p_target_start_date
     ,p_target_end_date               => p_target_end_date
     ,p_actual_start_date             => p_actual_start_date
     ,p_actual_end_date               => p_actual_end_date
     ,p_action_url                    => p_action_url
     ,p_mandatory_flag                => p_mandatory_flag
     ,p_status                        => p_status
    ,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_information_category          => p_information_category
    ,p_information1                  => p_information1
    ,p_information2                  => p_information2
    ,p_information3                  => p_information3
    ,p_information4                  => p_information4
    ,p_information5                  => p_information5
    ,p_information6                  => p_information6
    ,p_information7                  => p_information7
    ,p_information8                  => p_information8
    ,p_information9                  => p_information9
    ,p_information10                 => p_information10
    ,p_information11                 => p_information11
    ,p_information12                 => p_information12
    ,p_information13                 => p_information13
    ,p_information14                 => p_information14
    ,p_information15                 => p_information15
    ,p_information16                 => p_information16
    ,p_information17                 => p_information17
    ,p_information18                 => p_information18
    ,p_information19                 => p_information19
    ,p_information20                 => p_information20
    ,p_allocated_task_id             => p_allocated_task_id
    ,p_object_version_number         => l_object_version_number);

Line: 693


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

Line: 714


    rollback to UPDATE_ALLOC_TASK;

Line: 726


    rollback to UPDATE_ALLOC_TASK;

Line: 730


end UPDATE_ALLOC_TASK;

Line: 736


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

Line: 752


  savepoint DELETE_ALLOC_TASK;

Line: 757


    PER_ALLOCATED_TASK_BK3.DELETE_ALLOC_TASK_B
      (p_allocated_task_id          => p_allocated_task_id
      ,p_object_version_number      => p_object_version_number
      );

Line: 764


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

Line: 781


    PER_ALLOCATED_TASK_BK3.DELETE_ALLOC_TASK_A
      (p_allocated_task_id          => p_allocated_task_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 788


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

Line: 806


    rollback to DELETE_ALLOC_TASK;

Line: 813


    rollback to DELETE_ALLOC_TASK;

Line: 816


end DELETE_ALLOC_TASK;