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

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

Line: 28


  ,p_program_update_date            in     date     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_comments                       in     varchar2 default null
  ) is
  --
  -- Declare cursors and local variables
  --

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

Line: 86


      ,p_program_update_date            => p_program_update_date
      ,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_comments                       => p_comments
      );

Line: 138


      ,p_program_update_date            => p_program_update_date
      ,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_comments                       => p_comments
      ,p_txn_job_requirement_id         => l_txn_job_requirement_id
      ,p_object_version_number          => l_object_version_number
  );

Line: 185


      ,p_program_update_date            => p_program_update_date
      ,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_comments                       => p_comments
      );

Line: 259


procedure UPDATE_TXN_JOB_REQUIREMENT
  (p_validate                     in     boolean  default false
  ,p_effective_date               in     date
  ,p_txn_job_requirement_id       in     number
  ,p_object_version_number        in out nocopy number
  ,p_business_group_id            in     number    default hr_api.g_number
  ,p_analysis_criteria_id         in     number    default hr_api.g_number
  ,p_position_transaction_id      in     number    default hr_api.g_number
  ,p_job_requirement_id           in     number    default hr_api.g_number
  ,p_date_from                    in     date      default hr_api.g_date
  ,p_date_to                      in     date      default hr_api.g_date
  ,p_essential                    in     varchar2  default hr_api.g_varchar2
  ,p_job_id                       in     number    default hr_api.g_number
  ,p_request_id                   in     number    default hr_api.g_number
  ,p_program_application_id       in     number    default hr_api.g_number
  ,p_program_id                   in     number    default hr_api.g_number
  ,p_program_update_date          in     date      default hr_api.g_date
  ,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_comments                     in     varchar2  default hr_api.g_varchar2
  ) is
  --
  -- Declare cursors and local variables
  --

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

Line: 310


  savepoint UPDATE_TXN_JOB_REQUIREMENT;

Line: 319


    PQH_TXN_JOB_REQUIREMENTS_BK2.UPDATE_TXN_JOB_REQUIREMENT_b
      (p_effective_date                 => p_effective_date
      ,p_business_group_id              => p_business_group_id
      ,p_analysis_criteria_id           => p_analysis_criteria_id
      ,p_position_transaction_id        => p_position_transaction_id
      ,p_job_requirement_id             => p_job_requirement_id
      ,p_date_from                      => p_date_from
      ,p_date_to                        => p_date_to
      ,p_essential                      => p_essential
      ,p_job_id                         => p_job_id
      ,p_request_id                     => p_request_id
      ,p_program_application_id         => p_program_application_id
      ,p_program_id                     => p_program_id
      ,p_program_update_date            => p_program_update_date
      ,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_comments                       => p_comments
      ,p_txn_job_requirement_id         => p_txn_job_requirement_id
      ,p_object_version_number          => p_object_version_number
      );

Line: 361


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

Line: 386


      ,p_program_update_date            => p_program_update_date
      ,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_comments                       => p_comments
      ,p_txn_job_requirement_id         => p_txn_job_requirement_id
      ,p_object_version_number          => l_object_version_number
  );

Line: 418


    PQH_TXN_JOB_REQUIREMENTS_BK2.UPDATE_TXN_JOB_REQUIREMENT_a
      (p_effective_date                 => p_effective_date
      ,p_txn_job_requirement_id         => p_txn_job_requirement_id
      ,p_object_version_number          => l_object_version_number
      ,p_business_group_id              => p_business_group_id
      ,p_analysis_criteria_id           => p_analysis_criteria_id
      ,p_position_transaction_id        => p_position_transaction_id
      ,p_job_requirement_id             => p_job_requirement_id
      ,p_date_from                      => p_date_from
      ,p_date_to                        => p_date_to
      ,p_essential                      => p_essential
      ,p_job_id                         => p_job_id
      ,p_request_id                     => p_request_id
      ,p_program_application_id         => p_program_application_id
      ,p_program_id                     => p_program_id
      ,p_program_update_date            => p_program_update_date
      ,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_comments                       => p_comments
      );

Line: 460


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

Line: 482


    rollback to UPDATE_TXN_JOB_REQUIREMENT;

Line: 495


    rollback to UPDATE_TXN_JOB_REQUIREMENT;

Line: 498


end UPDATE_TXN_JOB_REQUIREMENT;

Line: 504


procedure DELETE_TXN_JOB_REQUIREMENT
  (p_validate                       in     boolean  default false
  ,p_effective_date                 in     date
  ,p_txn_job_requirement_id         in     number
  ,p_object_version_number          in     number
  ) is
  --
  -- Declare cursors and local variables
  --

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

Line: 521


  savepoint DELETE_TXN_JOB_REQUIREMENT;

Line: 530


    PQH_TXN_JOB_REQUIREMENTS_BK3.DELETE_TXN_JOB_REQUIREMENT_b
      (p_effective_date                 => p_effective_date
      ,p_txn_job_requirement_id         => p_txn_job_requirement_id
      ,p_object_version_number          => l_object_version_number
      );

Line: 538


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

Line: 561


    PQH_TXN_JOB_REQUIREMENTS_BK3.DELETE_TXN_JOB_REQUIREMENT_a
      (p_effective_date                 => p_effective_date
      ,p_txn_job_requirement_id         => p_txn_job_requirement_id
      ,p_object_version_number          => l_object_version_number
      );

Line: 569


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

Line: 590


    rollback to DELETE_TXN_JOB_REQUIREMENT;

Line: 601


    rollback to DELETE_TXN_JOB_REQUIREMENT;

Line: 604


end DELETE_TXN_JOB_REQUIREMENT;