APPS.FND_SVC_COMPONENTS_PKG SQL Statements

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

Line: 4

procedure INSERT_ROW (
  X_ROWID in out nocopy VARCHAR2,
  X_COMPONENT_ID in NUMBER,
  X_COMPONENT_NAME in VARCHAR2,
  X_COMPONENT_STATUS in VARCHAR2,
  X_COMPONENT_TYPE in VARCHAR2,
  X_STARTUP_MODE in VARCHAR2,
  X_CONTAINER_TYPE in VARCHAR2,
  X_CUSTOMIZATION_LEVEL in VARCHAR2,
  X_APPLICATION_ID in NUMBER,
  X_CONCURRENT_QUEUE_ID in NUMBER,
  X_STANDALONE_CONTAINER_NAME in VARCHAR2,
  X_INBOUND_AGENT_NAME in VARCHAR2,
  X_OUTBOUND_AGENT_NAME in VARCHAR2,
  X_CORRELATION_ID in VARCHAR2,
  X_MAX_IDLE_TIME in NUMBER,
  X_COMPONENT_STATUS_INFO in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_CREATION_DATE in DATE,
  X_CREATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
  cursor C is select ROWID from FND_SVC_COMPONENTS
    where COMPONENT_ID = X_COMPONENT_ID
    ;

Line: 32

  insert into FND_SVC_COMPONENTS (
    COMPONENT_ID,
    COMPONENT_NAME,
    COMPONENT_STATUS,
    COMPONENT_TYPE,
    STARTUP_MODE,
    CONTAINER_TYPE,
    CUSTOMIZATION_LEVEL,
    APPLICATION_ID,
    CONCURRENT_QUEUE_ID,
    STANDALONE_CONTAINER_NAME,
    INBOUND_AGENT_NAME,
    OUTBOUND_AGENT_NAME,
    CORRELATION_ID,
    MAX_IDLE_TIME,
    COMPONENT_STATUS_INFO,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    OBJECT_VERSION_NUMBER
  ) values (
    X_COMPONENT_ID,
    X_COMPONENT_NAME,
    X_COMPONENT_STATUS,
    X_COMPONENT_TYPE,
    X_STARTUP_MODE,
    X_CONTAINER_TYPE,
    X_CUSTOMIZATION_LEVEL,
    X_APPLICATION_ID,
    X_CONCURRENT_QUEUE_ID,
    X_STANDALONE_CONTAINER_NAME,
    X_INBOUND_AGENT_NAME,
    X_OUTBOUND_AGENT_NAME,
    X_CORRELATION_ID,
    X_MAX_IDLE_TIME,
    X_COMPONENT_STATUS_INFO,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_OBJECT_VERSION_NUMBER
  );

Line: 88

    wf_core.context('FND_SVC_COMPONENTS_PKG', 'Insert_Row', X_COMPONENT_ID, X_COMPONENT_NAME);

Line: 91

end INSERT_ROW;

Line: 111

  cursor c is select
      COMPONENT_NAME,
      COMPONENT_STATUS,
      COMPONENT_TYPE,
      STARTUP_MODE,
      CONTAINER_TYPE,
      CUSTOMIZATION_LEVEL,
      APPLICATION_ID,
      CONCURRENT_QUEUE_ID,
      STANDALONE_CONTAINER_NAME,
      INBOUND_AGENT_NAME,
      OUTBOUND_AGENT_NAME,
      CORRELATION_ID,
      MAX_IDLE_TIME,
      COMPONENT_STATUS_INFO,
      OBJECT_VERSION_NUMBER
    from FND_SVC_COMPONENTS
    where COMPONENT_ID = X_COMPONENT_ID
    for update of COMPONENT_ID nowait;

Line: 137

    wf_core.raise('WF_RECORD_DELETED');

Line: 178

procedure UPDATE_ROW (
  X_COMPONENT_ID in NUMBER,
  X_COMPONENT_NAME in VARCHAR2,
  X_COMPONENT_STATUS in VARCHAR2,
  X_COMPONENT_TYPE in VARCHAR2,
  X_STARTUP_MODE in VARCHAR2,
  X_CONTAINER_TYPE in VARCHAR2,
  X_CUSTOMIZATION_LEVEL in VARCHAR2,
  X_APPLICATION_ID in NUMBER,
  X_CONCURRENT_QUEUE_ID in NUMBER,
  X_STANDALONE_CONTAINER_NAME in VARCHAR2,
  X_INBOUND_AGENT_NAME in VARCHAR2,
  X_OUTBOUND_AGENT_NAME in VARCHAR2,
  X_CORRELATION_ID in VARCHAR2,
  X_MAX_IDLE_TIME in NUMBER,
  X_COMPONENT_STATUS_INFO in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is

  l_object_version_number NUMBER;

Line: 211

    select OBJECT_VERSION_NUMBER
    into l_object_version_number
    from FND_SVC_COMPONENTS
    where COMPONENT_ID = X_COMPONENT_ID;

Line: 228

    select OBJECT_VERSION_NUMBER
    into l_object_version_number
    from FND_SVC_COMPONENTS
    where COMPONENT_ID = X_COMPONENT_ID
    for update;

Line: 240

        wf_core.translate('SVC_RECORD_ALREADY_UPDATED'));

Line: 257

      update FND_SVC_COMPONENTS set
        COMPONENT_NAME = X_COMPONENT_NAME,
        -- COMPONENT_STATUS = X_COMPONENT_STATUS, // run-time data
        COMPONENT_TYPE = X_COMPONENT_TYPE,
        STARTUP_MODE = X_STARTUP_MODE,
        CONTAINER_TYPE = X_CONTAINER_TYPE,
        CUSTOMIZATION_LEVEL = X_CUSTOMIZATION_LEVEL,
        APPLICATION_ID = X_APPLICATION_ID,
        CONCURRENT_QUEUE_ID = X_CONCURRENT_QUEUE_ID,
        STANDALONE_CONTAINER_NAME = X_STANDALONE_CONTAINER_NAME,
        INBOUND_AGENT_NAME = X_INBOUND_AGENT_NAME,
        OUTBOUND_AGENT_NAME = X_OUTBOUND_AGENT_NAME,
        CORRELATION_ID = X_CORRELATION_ID,
        MAX_IDLE_TIME = X_MAX_IDLE_TIME,
        -- COMPONENT_STATUS_INFO = X_COMPONENT_STATUS_INFO, // run-time data
        OBJECT_VERSION_NUMBER = l_object_version_number,
        LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
        LAST_UPDATED_BY = X_LAST_UPDATED_BY,
        LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
      where COMPONENT_ID = X_COMPONENT_ID;

Line: 302

      update FND_SVC_COMPONENTS set
        COMPONENT_NAME = X_COMPONENT_NAME,
        -- COMPONENT_STATUS = X_COMPONENT_STATUS, // run-time data
        COMPONENT_TYPE = X_COMPONENT_TYPE,
        -- STARTUP_MODE = X_STARTUP_MODE, // limit data
        CONTAINER_TYPE = X_CONTAINER_TYPE,
        CUSTOMIZATION_LEVEL = X_CUSTOMIZATION_LEVEL,
        APPLICATION_ID = X_APPLICATION_ID,
        CONCURRENT_QUEUE_ID = X_CONCURRENT_QUEUE_ID,
        STANDALONE_CONTAINER_NAME = X_STANDALONE_CONTAINER_NAME,
        INBOUND_AGENT_NAME = X_INBOUND_AGENT_NAME,
        OUTBOUND_AGENT_NAME = X_OUTBOUND_AGENT_NAME,
        CORRELATION_ID = X_CORRELATION_ID,
        -- MAX_IDLE_TIME = X_MAX_IDLE_TIME, // limit data
        -- COMPONENT_STATUS_INFO = X_COMPONENT_STATUS_INFO, // run-time data
        OBJECT_VERSION_NUMBER = l_object_version_number,
        LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
        LAST_UPDATED_BY = X_LAST_UPDATED_BY,
        LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
      where COMPONENT_ID = X_COMPONENT_ID;

Line: 334

      update FND_SVC_COMPONENTS set
        STARTUP_MODE = X_STARTUP_MODE,
        MAX_IDLE_TIME = X_MAX_IDLE_TIME,
        OBJECT_VERSION_NUMBER = l_object_version_number,
        LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
        LAST_UPDATED_BY = X_LAST_UPDATED_BY,
        LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
      where COMPONENT_ID = X_COMPONENT_ID;

Line: 365

      update FND_SVC_COMPONENTS set
        COMPONENT_NAME = X_COMPONENT_NAME,
        -- COMPONENT_STATUS = X_COMPONENT_STATUS, // run-time data
        COMPONENT_TYPE = X_COMPONENT_TYPE,
        STARTUP_MODE = X_STARTUP_MODE,
        CONTAINER_TYPE = X_CONTAINER_TYPE,
        CUSTOMIZATION_LEVEL = X_CUSTOMIZATION_LEVEL,
        APPLICATION_ID = X_APPLICATION_ID,
        CONCURRENT_QUEUE_ID = X_CONCURRENT_QUEUE_ID,
        STANDALONE_CONTAINER_NAME = X_STANDALONE_CONTAINER_NAME,
        INBOUND_AGENT_NAME = X_INBOUND_AGENT_NAME,
        OUTBOUND_AGENT_NAME = X_OUTBOUND_AGENT_NAME,
        CORRELATION_ID = X_CORRELATION_ID,
        MAX_IDLE_TIME = X_MAX_IDLE_TIME,
        -- COMPONENT_STATUS_INFO = X_COMPONENT_STATUS_INFO, // run-time data
        OBJECT_VERSION_NUMBER = l_object_version_number,
        LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
        LAST_UPDATED_BY = X_LAST_UPDATED_BY,
        LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
      where COMPONENT_ID = X_COMPONENT_ID;

Line: 393

    wf_core.context('FND_SVC_COMPONENTS_PKG', 'Update_Row', X_COMPONENT_ID, X_COMPONENT_NAME);

Line: 395

end UPDATE_ROW;

Line: 397

procedure DELETE_ROW (
  X_COMPONENT_ID in NUMBER
) is

l_customization_level varchar2(1);

Line: 404

  select CUSTOMIZATION_LEVEL
  into l_customization_level
  from FND_SVC_COMPONENTS
  where COMPONENT_ID = X_COMPONENT_ID;

Line: 411

    delete from FND_SVC_COMPONENTS
    where COMPONENT_ID = X_COMPONENT_ID;

Line: 420

    wf_core.context('FND_SVC_COMP_PARAM_VALS_PKG', 'Delete_Row', X_COMPONENT_ID);

Line: 423

end DELETE_ROW;

Line: 465

        SELECT concurrent_queue_id
        INTO l_concurrent_queue_id
        FROM fnd_concurrent_queues
        WHERE concurrent_queue_name = X_CONCURRENT_QUEUE_NAME;

Line: 471

            SELECT application_id
            INTO l_application_id
            FROM fnd_application
            WHERE application_short_name = X_APPLICATION_SHORT_NAME;

Line: 483

        SELECT component_id
        INTO l_component_id
        FROM fnd_svc_components
        WHERE component_name = X_COMPONENT_NAME;

Line: 488

        FND_SVC_COMPONENTS_PKG.UPDATE_ROW (
            X_COMPONENT_ID => l_component_id,
            X_COMPONENT_NAME => X_COMPONENT_NAME,
            X_COMPONENT_STATUS => X_COMPONENT_STATUS,
            X_COMPONENT_TYPE => X_COMPONENT_TYPE,
            X_STARTUP_MODE => X_STARTUP_MODE,
            X_CONTAINER_TYPE => X_CONTAINER_TYPE,
            X_CUSTOMIZATION_LEVEL => X_CUSTOMIZATION_LEVEL,
            X_APPLICATION_ID => l_application_id,
            X_CONCURRENT_QUEUE_ID => l_concurrent_queue_id,
            X_STANDALONE_CONTAINER_NAME => X_STANDALONE_CONTAINER_NAME,
            X_INBOUND_AGENT_NAME => X_INBOUND_AGENT_NAME,
            X_OUTBOUND_AGENT_NAME => X_OUTBOUND_AGENT_NAME,
            X_CORRELATION_ID => X_CORRELATION_ID,
            X_MAX_IDLE_TIME => X_MAX_IDLE_TIME,
            X_COMPONENT_STATUS_INFO => X_COMPONENT_STATUS_INFO,
            X_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER,
            X_LAST_UPDATE_DATE => sysdate,
            X_LAST_UPDATED_BY => user_id,
            X_LAST_UPDATE_LOGIN => 0);

Line: 511

            SELECT fnd_svc_components_s.nextval
            INTO l_component_id
            FROM dual;

Line: 515

            FND_SVC_COMPONENTS_PKG.INSERT_ROW (
            X_ROWID => row_id,
            X_COMPONENT_ID => l_component_id,
            X_COMPONENT_NAME => X_COMPONENT_NAME,
            X_COMPONENT_STATUS => X_COMPONENT_STATUS,
            X_COMPONENT_TYPE => X_COMPONENT_TYPE,
            X_STARTUP_MODE => X_STARTUP_MODE,
            X_CONTAINER_TYPE => X_CONTAINER_TYPE,
            X_CUSTOMIZATION_LEVEL => X_CUSTOMIZATION_LEVEL,
            X_APPLICATION_ID => l_application_id,
            X_CONCURRENT_QUEUE_ID => l_concurrent_queue_id,
            X_STANDALONE_CONTAINER_NAME => X_STANDALONE_CONTAINER_NAME,
            X_INBOUND_AGENT_NAME => X_INBOUND_AGENT_NAME,
            X_OUTBOUND_AGENT_NAME => X_OUTBOUND_AGENT_NAME,
            X_CORRELATION_ID => X_CORRELATION_ID,
            X_MAX_IDLE_TIME => X_MAX_IDLE_TIME,
            X_COMPONENT_STATUS_INFO => X_COMPONENT_STATUS_INFO,
            X_CREATION_DATE => sysdate,
            X_CREATED_BY => user_id,
            X_LAST_UPDATE_DATE => sysdate,
            X_LAST_UPDATED_BY => user_id,
            X_LAST_UPDATE_LOGIN => 0);