APPS.FND_TABLESPACES_PKG SQL Statements

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

Line: 7

PROCEDURE INSERT_ROW (
  X_ROWID IN OUT  NOCOPY VARCHAR2,
  P_TABLESPACE_TYPE IN VARCHAR2,
  P_TABLESPACE IN VARCHAR2,
  P_CUSTOM_FLAG IN VARCHAR2 DEFAULT NULL,
  P_CREATION_DATE IN DATE DEFAULT NULL,
  P_CREATED_BY IN NUMBER DEFAULT NULL,
  P_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
  P_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
  P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL)
IS
  cursor C is select ROWID from FND_TABLESPACES
  where TABLESPACE_TYPE = P_TABLESPACE_TYPE ;

Line: 22

   insert into FND_TABLESPACES (
     TABLESPACE_TYPE,
     TABLESPACE,
     CUSTOM_FLAG ,
     CREATION_DATE,
     CREATED_BY,
     LAST_UPDATE_DATE,
     LAST_UPDATED_BY,
     LAST_UPDATE_LOGIN
  ) values (
     P_TABLESPACE_TYPE,
     P_TABLESPACE,
     P_CUSTOM_FLAG ,
     P_CREATION_DATE,
     P_CREATED_BY,
     P_LAST_UPDATE_DATE,
     P_LAST_UPDATED_BY,
     P_LAST_UPDATE_LOGIN
  );

Line: 50

END INSERT_ROW;

Line: 52

PROCEDURE UPDATE_ROW (
  P_TABLESPACE_TYPE in VARCHAR2,
  P_TABLESPACE in VARCHAR2,
  P_CUSTOM_FLAG in VARCHAR2 DEFAULT NULL,
  P_LAST_UPDATE_DATE in DATE DEFAULT NULL,
  P_LAST_UPDATED_BY in NUMBER DEFAULT NULL,
  P_LAST_UPDATE_LOGIN in NUMBER DEFAULT NULL
  )
IS
BEGIN
  update FND_TABLESPACES set
    TABLESPACE = decode(P_TABLESPACE, null, TABLESPACE, P_TABLESPACE),
    CUSTOM_FLAG =  decode(P_CUSTOM_FLAG, null, CUSTOM_FLAG, P_CUSTOM_FLAG),
    LAST_UPDATE_DATE = decode(P_LAST_UPDATE_DATE, null, sysdate, P_LAST_UPDATE_DATE),
    LAST_UPDATED_BY = decode(P_LAST_UPDATED_BY, null, -1, P_LAST_UPDATED_BY),
    LAST_UPDATE_LOGIN = decode(P_LAST_UPDATE_LOGIN, null, -1, P_LAST_UPDATE_LOGIN)
  where TABLESPACE_TYPE = P_TABLESPACE_TYPE;

Line: 74

END UPDATE_ROW;

Line: 76

PROCEDURE DELETE_ROW (
  P_TABLESPACE_TYPE in VARCHAR2)
IS
BEGIN
  delete from FND_TABLESPACES
  where TABLESPACE_TYPE = P_TABLESPACE_TYPE ;

Line: 85

END DELETE_ROW;