APPS.FND_SVC_COMP_REQUESTS_H_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_REQUEST_HISTORY_ID in NUMBER,
  X_COMPONENT_ID in NUMBER,
  X_EVENT_NAME in VARCHAR2,
  X_REQUEST_STATUS in VARCHAR2,
  X_REQUESTED_BY_USER in VARCHAR2,
  X_COMPLETION_DATE in DATE,
  X_COMPONENT_NAME in VARCHAR2,
  X_COMPONENT_STATUS in VARCHAR2,
  X_COMPONENT_TYPE in VARCHAR2,
  X_CONTAINER_TYPE in VARCHAR2,
  X_CONTAINER_NAME in VARCHAR2,
  X_EVENT_PARAMS 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_COMP_REQUESTS_H
    where REQUEST_HISTORY_ID = X_REQUEST_HISTORY_ID
    ;

Line: 29

  insert into FND_SVC_COMP_REQUESTS_H (
    REQUEST_HISTORY_ID,
    COMPONENT_ID,
    EVENT_NAME,
    REQUEST_STATUS,
    REQUESTED_BY_USER,
    COMPLETION_DATE,
    COMPONENT_NAME,
    COMPONENT_STATUS,
    COMPONENT_TYPE,
    CONTAINER_TYPE,
    CONTAINER_NAME,
    EVENT_PARAMS,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    OBJECT_VERSION_NUMBER
  ) values (
    X_REQUEST_HISTORY_ID,
    X_COMPONENT_ID,
    X_EVENT_NAME,
    X_REQUEST_STATUS,
    X_REQUESTED_BY_USER,
    X_COMPLETION_DATE,
    X_COMPONENT_NAME,
    X_COMPONENT_STATUS,
    X_COMPONENT_TYPE,
    X_CONTAINER_TYPE,
    X_CONTAINER_NAME,
    X_EVENT_PARAMS,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_OBJECT_VERSION_NUMBER
  );

Line: 79

    wf_core.context('FND_SVC_COMP_REQUESTS_H_PKG', 'Insert_Row', X_COMPONENT_ID, X_EVENT_NAME);

Line: 82

end INSERT_ROW;

Line: 99

  cursor c is select
      COMPONENT_ID,
      EVENT_NAME,
      REQUEST_STATUS,
      REQUESTED_BY_USER,
      COMPLETION_DATE,
      COMPONENT_NAME,
      COMPONENT_STATUS,
      COMPONENT_TYPE,
      CONTAINER_TYPE,
      CONTAINER_NAME,
      EVENT_PARAMS,
      OBJECT_VERSION_NUMBER
    from FND_SVC_COMP_REQUESTS_H
    where REQUEST_HISTORY_ID = X_REQUEST_HISTORY_ID
    for update of REQUEST_HISTORY_ID nowait;

Line: 124

    wf_core.raise('WF_RECORD_DELETED');

Line: 155

procedure UPDATE_ROW (
  X_REQUEST_HISTORY_ID in NUMBER,
  X_COMPONENT_ID in NUMBER,
  X_EVENT_NAME in VARCHAR2,
  X_REQUEST_STATUS in VARCHAR2,
  X_REQUESTED_BY_USER in VARCHAR2,
  X_COMPLETION_DATE in DATE,
  X_COMPONENT_NAME in VARCHAR2,
  X_COMPONENT_STATUS in VARCHAR2,
  X_COMPONENT_TYPE in VARCHAR2,
  X_CONTAINER_TYPE in VARCHAR2,
  X_CONTAINER_NAME in VARCHAR2,
  X_EVENT_PARAMS 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: 185

    select OBJECT_VERSION_NUMBER
    into l_object_version_number
    from FND_SVC_COMP_REQUESTS_H
    where REQUEST_HISTORY_ID = X_REQUEST_HISTORY_ID;

Line: 202

    select OBJECT_VERSION_NUMBER
    into l_object_version_number
    from FND_SVC_COMP_REQUESTS_H
    where REQUEST_HISTORY_ID = X_REQUEST_HISTORY_ID
    for update;

Line: 214

        wf_core.translate('SVC_RECORD_ALREADY_UPDATED'));

Line: 220

  update FND_SVC_COMP_REQUESTS_H set
    COMPONENT_ID = X_COMPONENT_ID,
    EVENT_NAME = X_EVENT_NAME,
    REQUEST_STATUS = X_REQUEST_STATUS,
    REQUESTED_BY_USER = X_REQUESTED_BY_USER,
    COMPLETION_DATE = X_COMPLETION_DATE,
    COMPONENT_NAME = X_COMPONENT_NAME,
    COMPONENT_STATUS = X_COMPONENT_STATUS,
    COMPONENT_TYPE = X_COMPONENT_TYPE,
    CONTAINER_TYPE = X_CONTAINER_TYPE,
    CONTAINER_NAME = X_CONTAINER_NAME,
    OBJECT_VERSION_NUMBER = l_object_version_number,
    EVENT_PARAMS = X_EVENT_PARAMS,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where REQUEST_HISTORY_ID = X_REQUEST_HISTORY_ID;

Line: 245

    wf_core.context('FND_SVC_COMP_REQUESTS_H_PKG', 'Update_Row', X_REQUEST_HISTORY_ID);

Line: 247

end UPDATE_ROW;

Line: 249

procedure DELETE_ROW (
  X_REQUEST_HISTORY_ID in NUMBER
) is
begin
  delete from FND_SVC_COMP_REQUESTS_H
  where REQUEST_HISTORY_ID = X_REQUEST_HISTORY_ID;

Line: 263

    wf_core.context('FND_SVC_COMP_REQUESTS_H_PKG', 'Delete_Row', X_REQUEST_HISTORY_ID);

Line: 265

end DELETE_ROW;