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

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

Line: 12


/* Select all inq records */
CURSOR c_ta_audit( b_user_name VARCHAR2, b_tranid NUMBER, b_assignment_id NUMBER) is
  SELECT *
  FROM  CSM_TASK_ASSIGNMENTS_AUDIT_INQ
  WHERE tranid$$ = b_tranid
  AND   clid$$cs = b_user_name
  AND   assignment_id = b_assignment_id;

Line: 28


SELECT JTF_TASK_AUDITS_S.nextval INTO l_t_id FROM DUAL;

Line: 33


SELECT OBJECT_VERSION_NUMBER INTO l_ovn FROM JTF_TASKS_B WHERE TASK_ID=p_record.TASK_ID;

Line: 37


JTF_TASK_AUDITS_PVT.INSERT_ROW(
  X_ROWID => l_r_id,
  X_TASK_AUDIT_ID =>l_t_id,
  X_TASK_ID =>p_record.TASK_ID,
  X_CREATION_DATE =>p_record.CREATION_DATE,
  X_CREATED_BY =>p_record.CREATED_BY,
  X_LAST_UPDATE_DATE =>p_record.LAST_UPDATE_DATE,
  X_LAST_UPDATED_BY =>p_record.LAST_UPDATED_BY,
  X_LAST_UPDATE_LOGIN =>p_record.LAST_UPDATE_LOGIN,
  X_OBJECT_VERSION_NUMBER =>l_ovn,
  X_OLD_TASK_STATUS_ID =>p_record.OLD_ASSIGNMENT_STATUS_ID,
  X_NEW_TASK_STATUS_ID =>p_record.NEW_ASSIGNMENT_STATUS_ID,
  X_NEW_NOTIFICATION_PERIOD => NULL,  X_OLD_NOTIFICATION_PERIOD_UOM => NULL,  X_NEW_NOTIFICATION_PERIOD_UOM => NULL,
  X_OLD_PARENT_TASK_ID => NULL,  X_NEW_PARENT_TASK_ID => NULL,
  X_OLD_RECURRENCE_RULE_ID => NULL,  X_NEW_RECURRENCE_RULE_ID => NULL,
  X_PALM_CHANGED_FLAG => NULL,  X_WINCE_CHANGED_FLAG => NULL,  X_LAPTOP_CHANGED_FLAG => NULL,
  X_DEVICE1_CHANGED_FLAG => NULL,  X_DEVICE2_CHANGED_FLAG => NULL,  X_DEVICE3_CHANGED_FLAG => NULL,
  X_OLD_CURRENCY_CODE => NULL,  X_NEW_CURRENCY_CODE => NULL,
  X_OLD_COSTS => NULL,  X_NEW_COSTS => NULL,
  X_OLD_TASK_TYPE_ID => NULL,  X_NEW_TASK_TYPE_ID => NULL,
  X_OLD_TASK_PRIORITY_ID => NULL,  X_NEW_TASK_PRIORITY_ID => NULL,
  X_OLD_OWNER_ID => NULL,  X_NEW_OWNER_ID => NULL,
  X_OLD_OWNER_TYPE_CODE => NULL,  X_NEW_OWNER_TYPE_CODE => NULL,
  X_OLD_ASSIGNED_BY_ID => NULL,  X_NEW_ASSIGNED_BY_ID => NULL,
  X_OLD_CUST_ACCOUNT_ID => NULL,  X_NEW_CUST_ACCOUNT_ID => NULL,
  X_OLD_CUSTOMER_ID => NULL,  X_NEW_CUSTOMER_ID => NULL,
  X_OLD_ADDRESS_ID => NULL,  X_NEW_ADDRESS_ID => NULL,
  X_OLD_PLANNED_START_DATE => NULL,  X_NEW_PLANNED_START_DATE => NULL,
  X_OLD_PLANNED_END_DATE => NULL,  X_NEW_PLANNED_END_DATE => NULL,
  X_OLD_SCHEDULED_START_DATE => NULL,  X_NEW_SCHEDULED_START_DATE => NULL,
  X_OLD_SCHEDULED_END_DATE => NULL,  X_NEW_SCHEDULED_END_DATE => NULL,
  X_OLD_ACTUAL_START_DATE => NULL,  X_NEW_ACTUAL_START_DATE => NULL,
  X_OLD_ACTUAL_END_DATE => NULL,  X_NEW_ACTUAL_END_DATE => NULL,
  X_OLD_SOURCE_OBJECT_TYPE_CODE => NULL,  X_NEW_SOURCE_OBJECT_TYPE_CODE => NULL,
  X_OLD_TIMEZONE_ID => NULL,  X_NEW_TIMEZONE_ID => NULL,
  X_OLD_SOURCE_OBJECT_ID => NULL,  X_NEW_SOURCE_OBJECT_ID => NULL,
  X_OLD_SOURCE_OBJECT_NAME => NULL,  X_NEW_SOURCE_OBJECT_NAME => NULL,
  X_OLD_DURATION => NULL,  X_NEW_DURATION => NULL,
  X_OLD_DURATION_UOM => NULL,  X_NEW_DURATION_UOM => NULL,
  X_OLD_PLANNED_EFFORT => NULL,  X_NEW_PLANNED_EFFORT => NULL,
  X_OLD_PLANNED_EFFORT_UOM => NULL,  X_NEW_PLANNED_EFFORT_UOM => NULL,
  X_OLD_ACTUAL_EFFORT => NULL,  X_NEW_ACTUAL_EFFORT => NULL,
  X_OLD_ACTUAL_EFFORT_UOM => NULL,  X_NEW_ACTUAL_EFFORT_UOM => NULL,
  X_OLD_PERCENTAGE_COMPLETE => NULL,  X_NEW_PERCENTAGE_COMPLETE => NULL,
  X_OLD_REASON_CODE => NULL,  X_NEW_REASON_CODE => NULL,
  X_PRIVATE_CHANGED_FLAG => NULL,  X_PUBLISH_CHANGED_FLAG => NULL,
  X_RESTRICT_CLOSURE_CHANGE_FLAG => NULL,  X_MULTI_BOOKED_CHANGED_FLAG => NULL,
  X_MILESTONE_CHANGED_FLAG => NULL,  X_HOLIDAY_CHANGED_FLAG => NULL,
  X_BILLABLE_CHANGED_FLAG => NULL,  X_OLD_BOUND_MODE_CODE => NULL,
  X_NEW_BOUND_MODE_CODE => NULL,  X_SOFT_BOUND_CHANGED_FLAG => NULL,
  X_OLD_WORKFLOW_PROCESS_ID => NULL,  X_NEW_WORKFLOW_PROCESS_ID => NULL,
  X_NOTIFICATION_CHANGED_FLAG => NULL,  X_OLD_NOTIFICATION_PERIOD => NULL,
  X_OLD_TASK_NAME => NULL,  X_NEW_TASK_NAME => NULL,
  X_OLD_DESCRIPTION => NULL,  X_NEW_DESCRIPTION => NULL,
  X_OLD_OWNER_TERRITORY_ID => NULL,  X_NEW_OWNER_TERRITORY_ID => NULL,
  X_NEW_ESCALATION_LEVEL => NULL,  X_OLD_ESCALATION_LEVEL => NULL,
  X_OLD_DATE_SELECTED => NULL,  X_NEW_DATE_SELECTED => NULL,
  X_OLD_LOCATION_ID => NULL,  X_NEW_LOCATION_ID => NULL);

Line: 107


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

--Variable Declarations
l_object_version_number  NUMBER := 1;

Line: 124


   CSM_UTIL_PKG.LOG('Entering CSM_TA_AUDIT_PKG.APPLY_INSERT for Task Assignment Audit ID ' || p_record.ASSIGNMENT_AUDIT_ID ,
                         'CSM_TA_AUDIT_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);

Line: 127


   SELECT JTF_TASK_ASSIGNMENTS_AUDIT_S.nextval INTO l_t_id FROM DUAL;

Line: 129


   CSM_UTIL_PKG.LOG('Before calling JTF_TASK_ASSIGNMENT_AUDIT_PKG.INSERT_ROW for Task Assignment Audit ID ' || l_t_id ,
                         'CSM_TA_AUDIT_PKG.APPLY_INSERT',FND_LOG.LEVEL_EVENT);

Line: 133


    JTF_TASK_ASSIGNMENT_AUDIT_PKG.INSERT_ROW(
        X_ASSIGNMENT_AUDIT_ID         => l_t_id,
        X_ASSIGNMENT_ID               => p_record.ASSIGNMENT_ID,
        X_TASK_ID                     => p_record.TASK_ID,
        X_CREATION_DATE               => p_record.CREATION_DATE,
        X_CREATED_BY                  => p_record.CREATED_BY,
        X_LAST_UPDATE_DATE            => p_record.LAST_UPDATE_DATE,
        X_LAST_UPDATED_BY             => p_record.LAST_UPDATED_BY,
        X_LAST_UPDATE_LOGIN           => p_record.LAST_UPDATE_LOGIN,
        X_OLD_RESOURCE_TYPE_CODE      => p_record.OLD_RESOURCE_TYPE_CODE,
        X_NEW_RESOURCE_TYPE_CODE      => p_record.NEW_RESOURCE_TYPE_CODE,
        X_OLD_RESOURCE_ID             => p_record.OLD_RESOURCE_ID,
        X_NEW_RESOURCE_ID             => p_record.NEW_RESOURCE_ID,
        X_OLD_ASSIGNMENT_STATUS_ID    => p_record.OLD_ASSIGNMENT_STATUS_ID,
        X_NEW_ASSIGNMENT_STATUS_ID    => p_record.NEW_ASSIGNMENT_STATUS_ID,
        X_OLD_ACTUAL_EFFORT           => NULL,
        X_NEW_ACTUAL_EFFORT           => NULL,
        X_OLD_ACTUAL_EFFORT_UOM       => NULL,
        X_NEW_ACTUAL_EFFORT_UOM       => NULL,
        X_OLD_RES_TERRITORY_ID        => NULL,
        X_NEW_RES_TERRITORY_ID        => NULL,
        X_OLD_ASSIGNEE_ROLE           => NULL,
        X_NEW_ASSIGNEE_ROLE           => NULL,
        X_OLD_ALARM_TYPE              => NULL,
        X_NEW_ALARM_TYPE              => NULL,
        X_OLD_ALARM_CONTACT           => NULL,
        X_NEW_ALARM_CONTACT           => NULL,
        X_OLD_CATEGORY_ID             => NULL,
        X_NEW_CATEGORY_ID             => NULL,
        X_OLD_BOOKING_START_DATE      => NULL,
        X_NEW_BOOKING_START_DATE      => NULL,
        X_OLD_BOOKING_END_DATE        => NULL,
        X_NEW_BOOKING_END_DATE        => NULL,
        X_OLD_ACTUAL_TRAVEL_DISTANCE  => p_record.OLD_ACTUAL_TRAVEL_DISTANCE,
        X_NEW_ACTUAL_TRAVEL_DISTANCE  => p_record.NEW_ACTUAL_TRAVEL_DISTANCE,
        X_OLD_ACTUAL_TRAVEL_DURATION  => p_record.OLD_ACTUAL_TRAVEL_DURATION,
        X_NEW_ACTUAL_TRAVEL_DURATION  => p_record.NEW_ACTUAL_TRAVEL_DURATION,
        X_OLD_ACTUAL_TRAVEL_DUR_UOM   => p_record.OLD_ACTUAL_TRAVEL_DURATION_UOM,
        X_NEW_ACTUAL_TRAVEL_DUR_UOM   => p_record.NEW_ACTUAL_TRAVEL_DURATION_UOM,
        X_OLD_SCHED_TRAVEL_DISTANCE   => p_record.OLD_SCHED_TRAVEL_DISTANCE,
        X_NEW_SCHED_TRAVEL_DISTANCE   => p_record.NEW_SCHED_TRAVEL_DISTANCE,
        X_OLD_SCHED_TRAVEL_DURATION   => p_record.OLD_SCHED_TRAVEL_DURATION,
        X_NEW_SCHED_TRAVEL_DURATION   => p_record.NEW_SCHED_TRAVEL_DURATION,
        X_OLD_SCHED_TRAVEL_DUR_UOM    => p_record.OLD_SCHED_TRAVEL_DURATION_UOM,
        X_NEW_SCHED_TRAVEL_DUR_UOM    => p_record.NEW_SCHED_TRAVEL_DURATION_UOM,
        X_OLD_ACTUAL_START_DATE       => p_record.OLD_ACTUAL_START_DATE,
        X_NEW_ACTUAL_START_DATE       => p_record.NEW_ACTUAL_START_DATE,
        X_OLD_ACTUAL_END_DATE         => p_record.OLD_ACTUAL_END_DATE,
        X_NEW_ACTUAL_END_DATE         => p_record.NEW_ACTUAL_END_DATE,
        X_FREE_BUSY_TYPE_CHANGED      => NULL,
        X_UPDATE_STATUS_FLAG_CHANGED  => NULL,
        X_SHOW_ON_CALENDAR_CHANGED    => NULL,
        X_SCHEDULED_FLAG_CHANGED      => NULL
      );

Line: 188


  CSM_UTIL_PKG.LOG('Leaving CSM_TA_AUDIT_PKG.APPLY_INSERT for Task Assignment Audit ID ' || p_record.ASSIGNMENT_AUDIT_ID ,
                         'CSM_TA_AUDIT_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);

Line: 195


  fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);

Line: 200


     CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT: ' || sqlerrm
               || ' for Task Assignment Audit ID ' || p_record.ASSIGNMENT_AUDIT_ID ,'CSM_TA_AUDIT_PKG.APPLY_INSERT',FND_LOG.LEVEL_EXCEPTION);

Line: 204


END APPLY_INSERT;

Line: 228


    APPLY_INSERT
      (
        p_record,
        p_error_msg,
        x_return_status
      );

Line: 234


  ELSE --Delete and update is not supported for this PI
    -- invalid dml type
      CSM_UTIL_PKG.LOG
        ( 'Invalid DML type: ' || p_record.dmltype$$ || ' is not supported for this entity'
      || ' for Task Assignment Audit ID ' || p_record.ASSIGNMENT_AUDIT_ID ,'CSM_TA_AUDIT_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);

Line: 268


  a fast sync. This procedure will insert the data that came from mobile into the backend tables using
  public APIs.
***/
PROCEDURE APPLY_CLIENT_CHANGES
         (
           p_user_name     IN VARCHAR2,
           p_tranid        IN NUMBER,
           p_assignment_id IN NUMBER,
           p_debug_level   IN NUMBER,
           x_return_status IN out nocopy VARCHAR2
         ) IS

  l_process_status VARCHAR2(1);

Line: 303


      CSM_UTIL_PKG.DELETE_RECORD
        (
          p_user_name,
          p_tranid,
          r_ta_audit_rec.seqno$$,
          r_ta_audit_rec.ASSIGNMENT_AUDIT_ID,
          g_object_name,
          g_pub_name,
          l_error_msg,
          l_process_status
        );

Line: 314


      /*** was delete successful? ***/
      IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
       /*** no -> rollback ***/
          CSM_UTIL_PKG.LOG
          ( 'Deleting from inqueue failed, No rolling back to savepoint'
      || ' for Task Assignment Audit ID ' || r_ta_audit_rec.ASSIGNMENT_AUDIT_ID ,'CSM_TA_AUDIT_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

Line: 367


  a fast sync. This procedure will insert the data that came from mobile into the backend tables using
  public APIs.
***/
PROCEDURE DEFER_CLIENT_CHANGES
         (
           p_user_name     IN VARCHAR2,
           p_tranid        IN NUMBER,
           p_assignment_id IN NUMBER,
           p_debug_level   IN NUMBER,
           x_return_status IN out nocopy VARCHAR2
         ) IS

l_process_status VARCHAR2(10);