APPS.IEU_SH_PVT SQL Statements

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

Line: 53

      INSERT INTO IEU_SH_SESSIONS (
       SESSION_ID,
       OBJECT_VERSION_NUMBER,
       CREATED_BY,
       CREATION_DATE,
       LAST_UPDATED_BY,
       LAST_UPDATE_DATE,
       LAST_UPDATE_LOGIN,
       RESOURCE_ID,
       BEGIN_DATE_TIME,
       END_DATE_TIME,
       ACTIVE_FLAG,
       EXTENSION,
       APPLICATION_ID
     ) values
     (
       IEU_SH_SESSIONS_S1.NEXTVAL,
       l_object_version_number,
       P_USER_ID,
       SYSDATE,
       P_USER_ID,
       SYSDATE,
       P_LOGIN_ID,
       P_RESOURCE_ID,
       SYSDATE,
       NULL,
       l_active_flag,
       P_EXTENSION,
       P_APPLICATION_ID)
     RETURNING SESSION_ID INTO X_SESSION_ID;

Line: 195

      update IEU_SH_SESSIONS set
       OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
       END_DATE_TIME = SYSDATE,
       ACTIVE_FLAG = NULL,
       END_REASON_CODE = P_END_REASON_CODE,
       FORCE_CLOSED_BY_UWQ_FLAG = 'N',
	  LAST_UPDATE_DATE = SYSDATE
      WHERE SESSION_ID = P_SESSION_ID;

Line: 343

      UPDATE ieu_sh_sessions
      SET    active_flag = 'Y',
             end_date_time = NULL
      WHERE  session_id = p_session_id
      AND    end_date_time is not null
      AND    active_flag <> 'Y';

Line: 352

         SELECT activity_type_id
         INTO   l_activity_type_id
         FROM   ieu_sh_act_types_b
         WHERE  activity_type_code = p_activity_type_code;

Line: 375

      SELECT SYSDATE INTO l_begin_date_time FROM DUAL;

Line: 385

          SELECT END_DATE_TIME INTO l_begin_date_time FROM IEU_SH_ACTIVITIES
            WHERE ACTIVITY_ID = l_last_activity_id;

Line: 389

          SELECT BEGIN_DATE_TIME INTO l_begin_date_time FROM IEU_SH_ACTIVITIES
            WHERE ACTIVITY_ID = l_last_activity_id;

Line: 396

      INSERT INTO IEU_SH_ACTIVITIES (
       ACTIVITY_ID,
       SESSION_ID,
       ACTIVITY_TYPE_ID,
       ACTIVITY_TYPE_CODE,
       MEDIA_TYPE_ID,
       MEDIA_ID,
       OBJECT_VERSION_NUMBER,
       CREATED_BY,
       CREATION_DATE,
       LAST_UPDATED_BY,
       LAST_UPDATE_DATE,
       LAST_UPDATE_LOGIN,
       BEGIN_DATE_TIME,
       END_DATE_TIME,
       ACTIVE_FLAG,
       REASON_CODE,
       REQUEST_METHOD,
       REQUESTED_MEDIA_TYPE_ID,
       WORK_ITEM_TYPE_CODE,
       WORK_ITEM_PK_ID,
       STATE_CODE,
       PARENT_CYCLE_ID,
       CATEGORY_TYPE,
       CATEGORY_VALUE
      ) values
      (
       IEU_SH_ACTIVITIES_S1.NEXTVAL,
       P_SESSION_ID,
       L_ACTIVITY_TYPE_ID,
       P_ACTIVITY_TYPE_CODE,
       P_MEDIA_TYPE_ID,
       P_MEDIA_ID,
       1,
       P_USER_ID,
       l_begin_date_time,
       P_USER_ID,
       l_begin_date_time,
       P_LOGIN_ID,
       l_begin_date_time,
       NULL,
       'T',
       P_REASON_CODE,
       P_REQUEST_METHOD,
       P_REQUESTED_MEDIA_TYPE_ID,
       P_WORK_ITEM_TYPE_CODE,
       P_WORK_ITEM_PK_ID,
       'BEGIN',
       P_PARENT_CYCLE_ID,
       P_CATEGORY_TYPE,
       P_CATEGORY_VALUE)
       RETURNING ACTIVITY_ID INTO X_ACTIVITY_ID;

Line: 564

PROCEDURE UWQ_UPDATE_ACTIVITY
( P_API_VERSION               IN NUMBER,
  P_INIT_MSG_LIST             IN VARCHAR2 DEFAULT fnd_api.g_false,
  P_COMMIT                    IN VARCHAR2 DEFAULT fnd_api.g_false,
  P_ACTIVITY_ID               IN NUMBER,
  P_INTERMEDIATE_STATE_CODE   IN VARCHAR2 DEFAULT NULL,
  P_MEDIA_TYPE_ID             IN NUMBER   DEFAULT NULL,
  P_MEDIA_ID                  IN NUMBER   DEFAULT NULL,
  P_REASON_CODE               IN VARCHAR2 DEFAULT NULL,
  X_MSG_COUNT                 OUT NOCOPY NUMBER,
  X_MSG_DATA                  OUT NOCOPY VARCHAR2,
  X_RETURN_STATUS             OUT NOCOPY VARCHAR2)  IS

  PRAGMA AUTONOMOUS_TRANSACTION;

Line: 580

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

Line: 609

        update IEU_SH_ACTIVITIES set
	 OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
	 DELIVER_DATE_TIME = SYSDATE,
	 STATE_CODE = P_INTERMEDIATE_STATE_CODE
       WHERE ACTIVITY_ID = P_ACTIVITY_ID;

Line: 624

         UPDATE IEU_SH_ACTIVITIES SET
          MEDIA_ID = P_MEDIA_ID,
		LAST_UPDATE_DATE = SYSDATE
         WHERE ACTIVITY_ID = P_ACTIVITY_ID;

Line: 634

         UPDATE IEU_SH_ACTIVITIES SET
          MEDIA_TYPE_ID = P_MEDIA_TYPE_ID,
		LAST_UPDATE_DATE = SYSDATE
         WHERE ACTIVITY_ID = P_ACTIVITY_ID;

Line: 644

         UPDATE IEU_SH_ACTIVITIES SET
          REASON_CODE = P_REASON_CODE,
		LAST_UPDATE_DATE = SYSDATE
         WHERE ACTIVITY_ID = P_ACTIVITY_ID;

Line: 658

         FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_ACTIVITY_FAILED');

Line: 659

         FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_SH_PVT.UWQ_UPDATE_ACTIVITY');

Line: 715

END UWQ_UPDATE_ACTIVITY;

Line: 769

      SELECT SYSDATE INTO l_end_date_time FROM DUAL;

Line: 773

        SELECT END_DATE_TIME INTO l_end_date_time FROM IEU_SH_ACTIVITIES WHERE
          ACTIVITY_ID = P_LAST_ACTIVITY_ID;

Line: 779

      update IEU_SH_ACTIVITIES set
        OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
        END_DATE_TIME = l_end_date_time,
        MEDIA_ID = P_MEDIA_ID,
        MEDIA_TYPE_ID = P_MEDIA_TYPE_ID,
        ACTIVE_FLAG = NULL,
        COMPLETION_CODE = P_COMPLETION_CODE,
        STATE_CODE = 'END',
        FORCE_CLOSED_BY_UWQ_FLAG = 'N',
	   LAST_UPDATE_DATE = l_end_date_time
      WHERE ACTIVITY_ID = P_ACTIVITY_ID;