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

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

Line: 107


        SELECT DECODE(p_task_template_id, fnd_api.g_miss_num, NULL, p_task_template_id)
          INTO l_task_template_id
          FROM DUAL;

Line: 129


        SELECT DECODE(p_task_id, fnd_api.g_miss_num, NULL, p_task_id)
          INTO l_task_id
          FROM DUAL;

Line: 133


        SELECT DECODE(p_task_number, fnd_api.g_miss_char, NULL, p_task_number)
          INTO l_task_number
          FROM DUAL;

Line: 158


        SELECT DECODE(p_task_type_id, fnd_api.g_miss_num, NULL, p_task_type_id)
          INTO l_task_type_id
          FROM DUAL;

Line: 162


        SELECT DECODE(p_task_type_name, fnd_api.g_miss_char, NULL, p_task_type_name)
          INTO l_task_type_name
          FROM DUAL;

Line: 304


  PROCEDURE update_task_rscr_req(
    p_api_version           IN            NUMBER
  , p_object_version_number IN OUT NOCOPY NUMBER
  , p_init_msg_list         IN            VARCHAR2 DEFAULT fnd_api.g_false
  , p_commit                IN            VARCHAR2 DEFAULT fnd_api.g_false
  , p_resource_req_id       IN            NUMBER
  , p_task_id               IN            NUMBER DEFAULT fnd_api.g_miss_num
  , p_task_name             IN            VARCHAR2 DEFAULT NULL
  , p_task_number           IN            VARCHAR2 DEFAULT NULL
  , p_task_type_id          IN            NUMBER DEFAULT fnd_api.g_miss_num
  , p_task_type_name        IN            VARCHAR2 DEFAULT NULL
  , p_task_template_id      IN            NUMBER DEFAULT fnd_api.g_miss_num
  , p_task_template_name    IN            VARCHAR2 DEFAULT NULL
  , p_resource_type_code    IN            VARCHAR2
  , p_required_units        IN            NUMBER
  , p_enabled_flag          IN            VARCHAR2 DEFAULT jtf_task_utl.g_no
  , x_return_status         OUT NOCOPY    VARCHAR2
  , x_msg_count             OUT NOCOPY    NUMBER
  , x_msg_data              OUT NOCOPY    VARCHAR2
  , p_attribute1            IN            VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
  , p_attribute2            IN            VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
  , p_attribute3            IN            VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
  , p_attribute4            IN            VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
  , p_attribute5            IN            VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
  , p_attribute6            IN            VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
  , p_attribute7            IN            VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
  , p_attribute8            IN            VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
  , p_attribute9            IN            VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
  , p_attribute10           IN            VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
  , p_attribute11           IN            VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
  , p_attribute12           IN            VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
  , p_attribute13           IN            VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
  , p_attribute14           IN            VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
  , p_attribute15           IN            VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
  , p_attribute_category    IN            VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
  ) IS
    l_api_version CONSTANT NUMBER                                       := 1.0;

Line: 341


    l_api_name    CONSTANT VARCHAR2(30)                                 := 'UPDATE_TASK_RSRC_REQ';

Line: 360


      SELECT DECODE(p_task_id, fnd_api.g_miss_num, task_id, p_task_id) task_id
           , DECODE(p_task_template_id, fnd_api.g_miss_num, task_template_id, p_task_template_id)
                                                                                   task_template_id
           , p_task_type_id task_type_id
           , p_resource_type_code resource_type_code
           , p_required_units required_units
           , enabled_flag
           , DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1
           , DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2
           , DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3
           , DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4
           , DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5
           , DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6
           , DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7
           , DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8
           , DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9
           , DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10
           , DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11
           , DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12
           , DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13
           , DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) attribute14
           , DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) attribute15
           , DECODE(
               p_attribute_category
             , fnd_api.g_miss_char, attribute_category
             , p_attribute_category
             ) attribute_category
        FROM jtf_task_rsc_reqs
       WHERE resource_req_id = p_resource_req_id;

Line: 392


    SAVEPOINT update_task_rsrc_req;

Line: 429


      SELECT DECODE(p_task_id, fnd_api.g_miss_num, NULL, p_task_id)
        INTO l_task_id
        FROM DUAL;

Line: 433


      SELECT DECODE(p_task_number, fnd_api.g_miss_char, NULL, p_task_number)
        INTO l_task_number
        FROM DUAL;

Line: 490


    jtf_task_resources_pvt.update_task_rscr_req
                                       (
      p_api_version                => 1.0
    , p_object_version_number      => p_object_version_number
    , p_init_msg_list              => fnd_api.g_false
    , p_commit                     => fnd_api.g_false
    , p_resource_req_id            => l_resource_req_id
    , p_task_id                    => l_task_id
    , p_task_name                  => l_task_name
    , p_task_number                => NULL
    , p_task_type_id               => l_task_type_id
    , p_task_type_name             => NULL
    , p_task_template_id           => l_task_template_id
    , p_task_template_name         => NULL
    , p_resource_type_code         => l_resource_type_code
    , p_required_units             => l_required_units
    , p_enabled_flag               => l_enabled_flag
    , x_return_status              => l_return_status
    , x_msg_data                   => l_msg_data
    , x_msg_count                  => l_msg_count
    , p_attribute1                 => task_rsrc_req_rec.attribute1
    , p_attribute2                 => task_rsrc_req_rec.attribute2
    , p_attribute3                 => task_rsrc_req_rec.attribute3
    , p_attribute4                 => task_rsrc_req_rec.attribute4
    , p_attribute5                 => task_rsrc_req_rec.attribute5
    , p_attribute6                 => task_rsrc_req_rec.attribute6
    , p_attribute7                 => task_rsrc_req_rec.attribute7
    , p_attribute8                 => task_rsrc_req_rec.attribute8
    , p_attribute9                 => task_rsrc_req_rec.attribute9
    , p_attribute10                => task_rsrc_req_rec.attribute10
    , p_attribute11                => task_rsrc_req_rec.attribute11
    , p_attribute12                => task_rsrc_req_rec.attribute12
    , p_attribute13                => task_rsrc_req_rec.attribute13
    , p_attribute14                => task_rsrc_req_rec.attribute14
    , p_attribute15                => task_rsrc_req_rec.attribute15
    , p_attribute_category         => task_rsrc_req_rec.attribute_category
    );

Line: 545


      ROLLBACK TO update_task_rsrc_req;

Line: 554


      ROLLBACK TO update_task_rsrc_req;

Line: 563


      ROLLBACK TO update_task_rsrc_req;

Line: 579


  PROCEDURE delete_task_rsrc_req(
    p_api_version           IN            NUMBER
  , p_object_version_number IN            NUMBER
  , p_init_msg_list         IN            VARCHAR2 DEFAULT fnd_api.g_false
  , p_commit                IN            VARCHAR2 DEFAULT fnd_api.g_false
  , p_resource_req_id       IN            NUMBER
  , x_return_status         OUT NOCOPY    VARCHAR2
  , x_msg_count             OUT NOCOPY    NUMBER
  , x_msg_data              OUT NOCOPY    VARCHAR2
  ) IS
    l_api_version CONSTANT NUMBER                                   := 1.0;

Line: 590


    l_api_name    CONSTANT VARCHAR2(30)                             := 'DELETE_TASK_RSRC_REQ';

Line: 597


      SELECT 1
        FROM jtf_task_rsc_reqs
       WHERE resource_req_id = l_resource_req_id;

Line: 603


    SAVEPOINT delete_task_rsrc_req;

Line: 653


      jtf_task_resources_pvt.delete_task_rsrc_req
                                                (
        p_api_version                => l_api_version
      , p_object_version_number      => p_object_version_number
      , p_init_msg_list              => fnd_api.g_false
      , p_commit                     => fnd_api.g_false
      , p_resource_req_id            => l_resource_req_id
      , x_return_status              => l_return_status
      , x_msg_count                  => l_msg_count
      , x_msg_data                   => l_msg_data
      );

Line: 683


      ROLLBACK TO delete_task_rsrc_req;

Line: 692


      ROLLBACK TO delete_task_rsrc_req;

Line: 701


      ROLLBACK TO delete_task_rsrc_req;