APPS.FND_SVC_COMP_REQUESTS_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_REQUEST_ID in NUMBER,
  X_COMPONENT_ID in NUMBER,
  X_EVENT_NAME in VARCHAR2,
  X_EVENT_DATE in DATE,
  X_REQUESTED_BY_USER in VARCHAR2,
  X_JOB_ID in NUMBER,
  X_EVENT_PARAMS in VARCHAR2,
  X_EVENT_FREQUENCY in NUMBER,
  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
    where COMPONENT_REQUEST_ID = X_COMPONENT_REQUEST_ID
    ;

Line: 25

  insert into FND_SVC_COMP_REQUESTS (
    COMPONENT_REQUEST_ID,
    COMPONENT_ID,
    EVENT_NAME,
    EVENT_DATE,
    REQUESTED_BY_USER,
    JOB_ID,
    EVENT_PARAMS,
    EVENT_FREQUENCY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    OBJECT_VERSION_NUMBER
  ) values (
    X_COMPONENT_REQUEST_ID,
    X_COMPONENT_ID,
    X_EVENT_NAME,
    X_EVENT_DATE,
    X_REQUESTED_BY_USER,
    X_JOB_ID,
    X_EVENT_PARAMS,
    X_EVENT_FREQUENCY,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_OBJECT_VERSION_NUMBER
  );

Line: 67

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

Line: 70

end INSERT_ROW;

Line: 83

  cursor c is select
      COMPONENT_ID,
      EVENT_NAME,
      EVENT_DATE,
      REQUESTED_BY_USER,
      JOB_ID,
      EVENT_FREQUENCY,
      OBJECT_VERSION_NUMBER,
      EVENT_PARAMS
    from FND_SVC_COMP_REQUESTS
    where COMPONENT_REQUEST_ID = X_COMPONENT_REQUEST_ID
    for update of COMPONENT_REQUEST_ID nowait;

Line: 103

    wf_core.raise('WF_RECORD_DELETED');

Line: 131

procedure UPDATE_ROW (
  X_COMPONENT_REQUEST_ID in NUMBER,
  X_COMPONENT_ID in NUMBER,
  X_EVENT_NAME in VARCHAR2,
  X_EVENT_DATE in DATE,
  X_REQUESTED_BY_USER in VARCHAR2,
  X_JOB_ID in NUMBER,
  X_EVENT_PARAMS in VARCHAR2,
  X_EVENT_FREQUENCY in NUMBER,
  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: 157

    select OBJECT_VERSION_NUMBER
    into l_object_version_number
    from FND_SVC_COMP_REQUESTS
    where COMPONENT_REQUEST_ID = X_COMPONENT_REQUEST_ID;

Line: 174

    select OBJECT_VERSION_NUMBER
    into l_object_version_number
    from FND_SVC_COMP_REQUESTS
    where COMPONENT_REQUEST_ID = X_COMPONENT_REQUEST_ID
    for update;

Line: 186

        wf_core.translate('SVC_RECORD_ALREADY_UPDATED'));

Line: 192

  update FND_SVC_COMP_REQUESTS set
    COMPONENT_ID = X_COMPONENT_ID,
    EVENT_NAME = X_EVENT_NAME,
    EVENT_DATE = X_EVENT_DATE,
    REQUESTED_BY_USER = X_REQUESTED_BY_USER,
    JOB_ID = X_JOB_ID,
    EVENT_PARAMS = X_EVENT_PARAMS,
    EVENT_FREQUENCY = X_EVENT_FREQUENCY,
    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_REQUEST_ID = X_COMPONENT_REQUEST_ID;

Line: 212

    wf_core.context('FND_SVC_COMP_REQUESTS_PKG', 'Update_Row', X_COMPONENT_REQUEST_ID);

Line: 214

end UPDATE_ROW;

Line: 216

procedure DELETE_ROW (
  X_COMPONENT_REQUEST_ID in NUMBER
) is
begin
  delete from FND_SVC_COMP_REQUESTS
  where COMPONENT_REQUEST_ID = X_COMPONENT_REQUEST_ID;

Line: 229

    wf_core.context('FND_SVC_COMP_REQUESTS_PKG', 'Delete_Row', X_COMPONENT_REQUEST_ID);

Line: 231

end DELETE_ROW;

Line: 262

      SELECT component_id
      INTO l_component_id
      FROM fnd_svc_components
      WHERE component_name = X_COMPONENT_NAME;

Line: 281

        SELECT component_request_id, job_id
        INTO l_component_request_id, l_job_id
        FROM fnd_svc_comp_requests
        WHERE component_id = l_component_id
          AND rownum = 1
          AND event_name = X_EVENT_NAME
          AND event_date = X_EVENT_DATE
          AND ( (event_frequency is NULL AND X_EVENT_FREQUENCY IS NULL)
             OR (event_frequency = X_EVENT_FREQUENCY));

Line: 292

        FND_SVC_COMP_REQUESTS_PKG.UPDATE_ROW (
            X_COMPONENT_REQUEST_ID => l_component_request_id,
            X_COMPONENT_ID => l_component_id,
            X_EVENT_NAME => X_EVENT_NAME,
            X_EVENT_DATE => X_EVENT_DATE,
            X_REQUESTED_BY_USER => X_REQUESTED_BY_USER,
            X_JOB_ID => l_job_id,
            X_EVENT_PARAMS => X_EVENT_PARAMS,
            X_EVENT_FREQUENCY => X_EVENT_FREQUENCY,
            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: 317

          SELECT fnd_svc_comp_requests_s.nextval
          INTO l_component_request_id
          FROM dual;

Line: 329

          FND_SVC_COMP_REQUESTS_PKG.INSERT_ROW (
              X_ROWID => row_id,
              X_COMPONENT_REQUEST_ID => l_component_request_id,
              X_COMPONENT_ID => l_component_id,
              X_EVENT_NAME => X_EVENT_NAME,
              X_EVENT_DATE => X_EVENT_DATE,
              X_REQUESTED_BY_USER => X_REQUESTED_BY_USER,
              X_JOB_ID => l_job_id,
              X_EVENT_PARAMS => X_EVENT_PARAMS,
              X_EVENT_FREQUENCY => X_EVENT_FREQUENCY,
              X_CREATED_BY => user_id,
              X_LAST_UPDATED_BY => user_id,
              X_LAST_UPDATE_LOGIN => 0);