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

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

Line: 24


  SELECT *
  FROM  csm_task_assignments_inq
  WHERE tranid$$ = b_tranid
  AND   clid$$cs = b_user_name;

Line: 30


  This procedure is called by APPLY_CLIENT_CHANGES when an inserted record is to be processed.
***/
PROCEDURE APPLY_INSERT
         (
           p_record        IN c_task_assignments_inq%ROWTYPE,
           p_error_msg     OUT NOCOPY    VARCHAR2,
           x_return_status IN OUT NOCOPY VARCHAR2
         ) IS

l_task_assignment_id NUMBER;

Line: 47


    SELECT jta.object_version_number
    FROM   jtf_task_assignments jta
    WHERE  jta.task_assignment_id = b_task_assignment_id;

Line: 58


  CSM_UTIL_PKG.LOG('Entering CSM_TASK_ASSIGNMENTS_PKG.APPLY_INSERT for task_assignment_id ' || p_record.task_assignment_id ,
                         'CSM_TASK_ASSIGNMENTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);

Line: 97


    CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
      || ' ROOT ERROR: JTF_TASK_ASSIGNMENTS_PUB.create_task_assignment'
      || ' for PK ' || p_record.TASK_ASSIGNMENT_ID,
      g_object_name || '.APPLY_INSERT',FND_LOG.LEVEL_ERROR );

Line: 114


  csf_task_assignments_pub.update_assignment_status
    ( p_api_version                => 1.0
    , p_init_msg_list              => FND_API.G_TRUE
    , p_commit                     => FND_API.G_FALSE
    , p_validation_level 		   => FND_API.G_VALID_LEVEL_NONE
    , x_return_status              => x_return_status
    , x_msg_count                  => l_msg_count
    , x_msg_data                   => l_msg_data
    , p_task_assignment_id         => p_record.task_assignment_id
    , p_assignment_status_id       => p_record.assignment_status_id
    , p_object_version_number      => l_ovn
    , p_update_task                => 'T'
    , x_task_object_version_number => l_task_object_version_number
    , x_task_status_id             => l_task_status_id
    );

Line: 134


    CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
      || ' ROOT ERROR: csf_tasks_pub.update_assignment_status'
      || ' for PK ' || p_record.TASK_ASSIGNMENT_ID,
      g_object_name || '.APPLY_UPDATE',FND_LOG.LEVEL_ERROR );

Line: 146


     CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:' ||g_object_name || '.APPLY_INSERT',
       FND_LOG.LEVEL_EXCEPTION );

Line: 150


END APPLY_INSERT;

Line: 154


  an updated record is to be processed.
***/
PROCEDURE APPLY_UPDATE
         (
           p_record        IN c_task_assignments_inq%ROWTYPE,
           p_error_msg     OUT NOCOPY    VARCHAR2,
           x_return_status IN OUT NOCOPY VARCHAR2
         ) IS

  CURSOR c_task_assignment
    ( b_task_assignment_id number
    )
  IS
    SELECT jta.task_id
    ,      jta.object_version_number
    ,      jta.last_update_date
    ,      jta.last_updated_by
    FROM   jtf_task_assignments jta
    WHERE  jta.task_assignment_id = b_task_assignment_id;

Line: 202


    IF(r_task_assignment.last_update_date <> p_record.server_last_update_date AND r_task_assignment.last_updated_by <> asg_base.get_user_id(p_record.clid$$cs)) THEN
      p_error_msg := 'UPWARD SYNC CONFLICT: CLIENT LOST For JTF_TASK_ASSIGNMENTS: CSM_TASK_ASSIGNMENTS_PKG.APPLY_UPDATE: P_KEY = '
        || p_record.task_assignment_id;

Line: 207


        g_object_name || '.APPLY_UPDATE',
        FND_LOG.LEVEL_ERROR);

Line: 221


  csf_task_assignments_pub.update_assignment_status
    ( p_api_version                => 1.0
    , p_init_msg_list              => FND_API.G_TRUE
    , p_commit                     => FND_API.G_FALSE
    , p_validation_level 		   => FND_API.G_VALID_LEVEL_NONE
    , x_return_status              => x_return_status
    , x_msg_count                  => l_msg_count
    , x_msg_data                   => l_msg_data
    , p_task_assignment_id         => p_record.task_assignment_id
    , p_assignment_status_id       => p_record.assignment_status_id
    , p_object_version_number      => l_ovn
    , p_update_task                => 'T'
    , x_task_object_version_number => l_task_object_version_number
    , x_task_status_id             => l_task_status_id
    );

Line: 240


    CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'
      || ' ROOT ERROR: csf_tasks_pub.update_assignment_status'
      || ' for PK ' || p_record.TASK_ASSIGNMENT_ID,
      g_object_name || '.APPLY_UPDATE',FND_LOG.LEVEL_ERROR );

Line: 251


  csf_task_assignments_pub.Update_Task_Assignment
    ( p_api_version                => 1.0
    , p_init_msg_list              => FND_API.G_TRUE
    , p_commit                     => FND_API.G_FALSE
    , p_task_assignment_id         => p_record.task_assignment_id
    , p_object_version_number      => l_ovn
    , p_task_id                    => p_record.task_id
    , p_resource_type_code         => FND_API.G_MISS_CHAR
    , p_resource_id                => FND_API.G_MISS_NUM --p_record.resource_id
    , p_resource_territory_id      => FND_API.G_MISS_NUM
    , p_assignment_status_id       => FND_API.G_MISS_NUM
    , p_actual_start_date          => p_record.actual_start_date
    , p_actual_end_date            => p_record.actual_end_date
    , p_sched_travel_distance      => FND_API.G_MISS_NUM
    , p_sched_travel_duration      => FND_API.G_MISS_NUM
    , p_sched_travel_duration_uom  => FND_API.G_MISS_CHAR
    , p_shift_construct_id         => FND_API.G_MISS_NUM
    , p_object_capacity_id         => FND_API.G_MISS_NUM
    , p_attribute1                 => p_record.attribute1
    , p_attribute2                 => p_record.attribute2
    , p_attribute3                 => p_record.attribute3
    , p_attribute4                 => p_record.attribute4
    , p_attribute5                 => p_record.attribute5
    , p_attribute6                 => p_record.attribute6
    , p_attribute7                 => p_record.attribute7
    , p_attribute8                 => p_record.attribute8
    , p_attribute9                 => p_record.attribute9
    , p_attribute10                => p_record.attribute10
    , p_attribute11                => p_record.attribute11
    , p_attribute12                => p_record.attribute12
    , p_attribute13                => p_record.attribute13
    , p_attribute14                => p_record.attribute14
    , p_attribute15                => p_record.attribute15
--Bug 5182470
    , p_attribute_category         => p_record.attribute_category
    , x_return_status              => x_return_status
    , x_msg_count                  => l_msg_count
    , x_msg_data                   => l_msg_data
    , x_task_object_version_number => l_task_object_version_number
    , x_task_status_id             => l_task_status_id
    );

Line: 297


    CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'
      || ' ROOT ERROR: csf_tasks_pub.Update_Task_Assignment'
      || ' for PK ' || p_record.TASK_ASSIGNMENT_ID,
      g_object_name || '.APPLY_UPDATE',
      FND_LOG.LEVEL_ERROR );

Line: 310


     CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE:'
       || ' for PK ' || p_record.task_assignment_id,
       g_object_name || '.APPLY_UPDATE',
       FND_LOG.LEVEL_EXCEPTION );

Line: 317


END APPLY_UPDATE;

Line: 339


    APPLY_INSERT
      (
        p_record,
        p_error_msg,
        x_return_status
      );

Line: 347


    APPLY_UPDATE
      (
        p_record,
        p_error_msg,
        x_return_status
      );

Line: 357


      ( 'Delete and Insert is not supported for this entity'
        || ' for PK ' || p_record.task_assignment_id ,
        g_object_name || '.APPLY_RECORD',
        FND_LOG.LEVEL_ERROR);

Line: 410


SELECT dh.debrief_header_id, tst.rejected_flag, tst.on_hold_flag,
         tst.cancelled_flag, tst.closed_flag, tst.completed_flag
FROM csf_debrief_headers dh, jtf_task_assignments tas,
           jtf_task_statuses_b tst
WHERE dh.task_assignment_id  = tas.task_assignment_id
AND tas.assignment_status_id = tst.task_status_id
AND tas.task_assignment_id   = p_task_assignment_id;

Line: 460


           csf_debrief_update_pkg.form_Call (1.0, l_header_id);

Line: 470


      /*** If Yes -> delete record from inqueue ***/
      CSM_UTIL_PKG.DELETE_RECORD
        (
          p_user_name,
          p_tranid,
          r_task_assignments.seqno$$,
          r_task_assignments.task_assignment_id,
          g_object_name,
          g_pub_name,
          l_error_msg,
          l_process_status
        );

Line: 483


      /*** was delete successful? ***/
      IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
        /*** If No -> rollback ***/
        CSM_UTIL_PKG.LOG
        ( 'Deleting from inqueue failed, rolling back to savepoint'
          || ' for PK ' || r_task_assignments.task_assignment_id ,
          g_object_name || '.APPLY_CLIENT_CHANGES',
          FND_LOG.LEVEL_ERROR); -- put PK column here

Line: 497


      /*** Record was not processed successfully or delete failed
      -> defer and reject record ***/
      CSM_UTIL_PKG.LOG
      ( 'Record not processed successfully, deferring and rejecting record'
        || ' for PK ' || r_task_assignments.task_assignment_id ,
        g_object_name || '.APPLY_CLIENT_CHANGES',
        FND_LOG.LEVEL_ERROR); -- put PK column here

Line: 555


SELECT b.last_updated_by
FROM JTF_TASK_ASSIGNMENTS b,
     CSM_TASK_ASSIGNMENTS_INQ a
WHERE a.clid$$cs = l_user_name
AND tranid$$ = l_tran_id
AND seqno$$ = l_sequence
AND a.task_assignment_id = b.task_assignment_id ;