APPS.FND_OAM_DSCFG_PROCS_PKG SQL Statements

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

Line: 13

      SELECT /*+ FIRST_ROWS(1) */ P.proc_id, P.proc_type, P.error_is_fatal_flag, P.location, P.executable
      FROM fnd_oam_dscfg_procs P
      WHERE P.STAGE = p_stage
      AND SYSDATE BETWEEN NVL(P.START_DATE, SYSDATE) and NVL(P.END_DATE, SYSDATE)
      ORDER BY P.priority ASC, P.proc_id ASC;

Line: 208

      SELECT proc_id, proc_type, error_is_fatal_flag, location, executable
         INTO l_proc_id, l_proc_type, l_error_is_fatal_flag, l_location, l_executable
         FROM fnd_oam_dscfg_procs
         WHERE proc_id = p_proc_id
         AND SYSDATE BETWEEN NVL(START_DATE, SYSDATE) and NVL(END_DATE, SYSDATE);

Line: 247

      X_LAST_UPDATE_DATE    in varchar2)
    is
      mproc_id number;

Line: 252

      f_ludate  date;    -- entity update date in file

Line: 254

      db_ludate date;    -- entity update date in db

Line: 261

      f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 265

	select proc_id, LAST_UPDATED_BY, LAST_UPDATE_DATE
	into mproc_id, db_luby, db_ludate
	from   fnd_oam_dscfg_procs
    where  proc_id = to_number(X_PROC_ID);

Line: 272

        FND_OAM_DSCFG_PROCS_PKG.UPDATE_ROW (
          X_PROC_ID => mproc_id,
          X_PROC_TYPE => X_PROC_TYPE,
          X_STAGE => X_STAGE,
          X_START_DATE => X_START_DATE,
          X_END_DATE => X_END_DATE,
          X_PRIORITY => X_PRIORITY,
          X_ERROR_IS_FATAL_FLAG => X_ERROR_IS_FATAL_FLAG,
          X_LOCATION => X_LOCATION,
          X_EXECUTABLE => X_EXECUTABLE,
          X_LAST_UPDATED_BY => f_luby,
          X_LAST_UPDATE_DATE => f_ludate,
          X_LAST_UPDATE_LOGIN => 0 );

Line: 290

        FND_OAM_DSCFG_PROCS_PKG.INSERT_ROW (
          X_ROWID => row_id,
          X_PROC_ID => X_PROC_ID,
          X_PROC_TYPE => X_PROC_TYPE,
          X_STAGE => X_STAGE,
          X_START_DATE => X_START_DATE,
          X_END_DATE => X_END_DATE,
          X_PRIORITY => X_PRIORITY,
          X_ERROR_IS_FATAL_FLAG => X_ERROR_IS_FATAL_FLAG,
          X_LOCATION => X_LOCATION,
          X_EXECUTABLE => X_EXECUTABLE,
          X_CREATION_DATE => f_ludate,
          X_CREATED_BY => f_luby,
          X_LAST_UPDATE_DATE => f_ludate,
          X_LAST_UPDATED_BY => f_luby,
          X_LAST_UPDATE_LOGIN => 0 );

Line: 311

  procedure INSERT_ROW (
      X_ROWID               in out nocopy VARCHAR2,
      X_PROC_ID             in NUMBER,
      X_PROC_TYPE           IN VARCHAR2,
      X_STAGE               IN VARCHAR2,
      X_START_DATE          IN DATE,
      X_END_DATE            IN DATE,
      X_PRIORITY            IN NUMBER,
      X_ERROR_IS_FATAL_FLAG IN VARCHAR2,
      X_LOCATION            IN VARCHAR2,
      X_EXECUTABLE          IN VARCHAR2,
      X_CREATED_BY          in NUMBER,
      X_CREATION_DATE       in DATE,
      X_LAST_UPDATED_BY     in NUMBER,
      X_LAST_UPDATE_DATE    in DATE,
      X_LAST_UPDATE_LOGIN   in NUMBER)
 is
  cursor C is select ROWID from FND_OAM_DSCFG_PROCS
    where PROC_ID = X_PROC_ID;

Line: 331

  insert into FND_OAM_DSCFG_PROCS (
	PROC_ID,
  PROC_TYPE,
  STAGE,
	START_DATE,
	END_DATE,
  PRIORITY,
  ERROR_IS_FATAL_FLAG,
  LOCATION,
  EXECUTABLE,
	CREATED_BY,
	CREATION_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_DATE,
	LAST_UPDATE_LOGIN
  ) values (
	X_PROC_ID,
  X_PROC_TYPE,
  X_STAGE,
	X_START_DATE,
	X_END_DATE,
  X_PRIORITY,
  X_ERROR_IS_FATAL_FLAG,
  X_LOCATION,
  X_EXECUTABLE,
	X_CREATED_BY,
	X_CREATION_DATE,
	X_LAST_UPDATED_BY,
	X_LAST_UPDATE_DATE,
	X_LAST_UPDATE_LOGIN
  );

Line: 371

end INSERT_ROW;

Line: 388

      X_LAST_UPDATED_BY     in NUMBER,
      X_LAST_UPDATE_DATE    in DATE,
      X_LAST_UPDATE_LOGIN   in NUMBER
) is
  cursor c is select
	PROC_ID,
  PROC_TYPE,
  STAGE,
	START_DATE,
	END_DATE,
  PRIORITY,
  ERROR_IS_FATAL_FLAG,
  LOCATION,
  EXECUTABLE,
	CREATED_BY,
	CREATION_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_DATE,
	LAST_UPDATE_LOGIN
    from FND_OAM_DSCFG_PROCS
    where PROC_ID = X_PROC_ID
    for update of PROC_ID nowait;

Line: 417

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 449

  procedure UPDATE_ROW (
      X_PROC_ID             in NUMBER,
      X_PROC_TYPE           IN VARCHAR2,
      X_STAGE               IN VARCHAR2,
      X_START_DATE          IN DATE,
      X_END_DATE            IN DATE,
      X_PRIORITY            IN NUMBER,
      X_ERROR_IS_FATAL_FLAG IN VARCHAR2,
      X_LOCATION            IN VARCHAR2,
      X_EXECUTABLE          IN VARCHAR2,
      X_LAST_UPDATED_BY     in NUMBER,
      X_LAST_UPDATE_DATE    in DATE,
      X_LAST_UPDATE_LOGIN   in NUMBER
) is
begin
  update FND_OAM_DSCFG_PROCS set
          PROC_TYPE = X_PROC_TYPE,
          STAGE = X_STAGE,
          START_DATE = X_START_DATE,
          END_DATE = X_END_DATE,
          PRIORITY = X_PRIORITY,
          ERROR_IS_FATAL_FLAG = X_ERROR_IS_FATAL_FLAG,
          LOCATION = X_LOCATION,
          EXECUTABLE = X_EXECUTABLE,
          LAST_UPDATED_BY = X_LAST_UPDATED_BY,
          LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
          LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where PROC_ID = X_PROC_ID;

Line: 482

end UPDATE_ROW;

Line: 484

procedure DELETE_ROW (
      X_PROC_ID           in NUMBER
) is
begin
  delete from FND_OAM_DSCFG_PROCS
  where PROC_ID = X_PROC_ID;

Line: 495

end DELETE_ROW;