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

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

Line: 374


procedure UPDATE_TASK_IN_CKL
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_task_in_checklist_id          in     number
  ,p_checklist_id                  in     number
  ,p_checklist_task_name           in     varchar2
  ,p_eligibility_object_id         in     number default null
  ,p_eligibility_profile_id        in     number default null
  ,p_ame_attribute_identifier      in     varchar2 default null
  ,p_description                   in     varchar2 default null
  ,p_task_sequence                 in     number default null
  ,p_mandatory                     in     varchar2 default null
  ,p_target_duration               in     number   default null
  ,p_target_duration_uom           in     varchar2 default null
  ,p_action_url                    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_in_ckl';

Line: 447


  savepoint UPDATE_TASK_IN_CKL;

Line: 468


    PER_TASKS_IN_CHECKLIST_BK2.UPDATE_TASK_IN_CKL_B
     (p_effective_date                => l_effective_date
     ,p_task_in_checklist_id          => p_task_in_checklist_id
--
     ,p_checklist_id                  => p_checklist_id
     ,p_checklist_task_name           => p_checklist_task_name
     ,p_eligibility_object_id         => p_eligibility_object_id
     ,p_eligibility_profile_id        => p_eligibility_profile_id
     ,p_ame_attribute_identifier      => p_ame_attribute_identifier
     ,p_description                   => p_description
     ,p_task_sequence                 => p_task_sequence
     ,p_mandatory                     => p_mandatory
     ,p_target_duration               => p_target_duration
     ,p_target_duration_uom           => p_target_duration_uom
     ,p_action_url                    => p_action_url
--
     ,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_object_version_number         => l_object_version_number
     );

Line: 532


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

Line: 605


  PER_TASKS_IN_CHECKLIST_BK2.UPDATE_TASK_IN_CKL_A
    (p_effective_date                => l_effective_date
    ,p_task_in_checklist_id          => p_task_in_checklist_id
--
     ,p_checklist_id                  => p_checklist_id
     ,p_checklist_task_name           => p_checklist_task_name
     ,p_eligibility_object_id         => p_eligibility_object_id
     ,p_eligibility_profile_id        => p_eligibility_profile_id
     ,p_ame_attribute_identifier      => p_ame_attribute_identifier
     ,p_description                   => p_description
     ,p_task_sequence                 => p_task_sequence
     ,p_mandatory                     => p_mandatory
     ,p_target_duration               => p_target_duration
     ,p_target_duration_uom           => p_target_duration_uom
     ,p_action_url                    => p_action_url
--
    ,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_object_version_number         => l_object_version_number);

Line: 667


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

Line: 688


    rollback to UPDATE_TASK_IN_CKL;

Line: 700


    rollback to UPDATE_TASK_IN_CKL;

Line: 704


end UPDATE_TASK_IN_CKL;

Line: 710


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

Line: 726


  savepoint DELETE_TASK_IN_CKL;

Line: 731


    PER_TASKS_IN_CHECKLIST_BK3.DELETE_TASK_IN_CKL_B
      (p_task_in_checklist_id          => p_task_in_checklist_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 738


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

Line: 755


    PER_TASKS_IN_CHECKLIST_BK3.DELETE_TASK_IN_CKL_A
      (p_task_in_checklist_id          => p_task_in_checklist_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 762


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

Line: 780


    rollback to DELETE_TASK_IN_CKL;

Line: 787


    rollback to DELETE_TASK_IN_CKL;

Line: 790


end DELETE_TASK_IN_CKL;