APPS.CS_TP_LOOKUPS_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_LOOKUP_ID in NUMBER,
  X_LOOKUP_TYPE in VARCHAR2,
  X_DEFAULT_VALUE in VARCHAR2,
  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,
  X_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
  X_START_DATE_ACTIVE in DATE,
  X_END_DATE_ACTIVE in DATE
)
  is
    cursor c is SELECT ROWID from CS_TP_LOOKUPS
     where LOOKUP_ID = X_LOOKUP_ID;

Line: 37

   insert into CS_TP_LOOKUPS (
  LOOKUP_ID  ,
  LOOKUP_TYPE  ,
  DEFAULT_VALUE  ,
  CREATION_DATE ,
  CREATED_BY  ,
  LAST_UPDATE_DATE ,
  LAST_UPDATED_BY  ,
  LAST_UPDATE_LOGIN  ,
  ATTRIBUTE_CATEGORY  ,
  ATTRIBUTE1  ,
  ATTRIBUTE2  ,
  ATTRIBUTE3  ,
  ATTRIBUTE4  ,
  ATTRIBUTE5  ,
  ATTRIBUTE6  ,
  ATTRIBUTE7  ,
  ATTRIBUTE8  ,
  ATTRIBUTE9  ,
  ATTRIBUTE10  ,
  ATTRIBUTE11  ,
  ATTRIBUTE12  ,
  ATTRIBUTE13  ,
  ATTRIBUTE14  ,
  ATTRIBUTE15  ,
  START_DATE_ACTIVE  ,
  END_DATE_ACTIVE )
  values (
  X_LOOKUP_ID  ,
  X_LOOKUP_TYPE  ,
  X_DEFAULT_VALUE  ,
  X_CREATION_DATE ,
  X_CREATED_BY  ,
  X_LAST_UPDATE_DATE ,
  X_LAST_UPDATED_BY  ,
  X_LAST_UPDATE_LOGIN  ,
  X_ATTRIBUTE_CATEGORY  ,
  X_ATTRIBUTE1  ,
  X_ATTRIBUTE2  ,
  X_ATTRIBUTE3  ,
  X_ATTRIBUTE4  ,
  X_ATTRIBUTE5  ,
  X_ATTRIBUTE6  ,
  X_ATTRIBUTE7  ,
  X_ATTRIBUTE8  ,
  X_ATTRIBUTE9  ,
  X_ATTRIBUTE10  ,
  X_ATTRIBUTE11  ,
  X_ATTRIBUTE12  ,
  X_ATTRIBUTE13  ,
  X_ATTRIBUTE14  ,
  X_ATTRIBUTE15  ,
  X_START_DATE_ACTIVE  ,
  X_END_DATE_ACTIVE );

Line: 100

end  INSERT_ROW;

Line: 104

procedure UPDATE_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_LOOKUP_ID in NUMBER,
  X_LOOKUP_TYPE in VARCHAR2,
  X_DEFAULT_VALUE in VARCHAR2,
  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,
  X_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
  X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
  X_START_DATE_ACTIVE in DATE,
  X_END_DATE_ACTIVE in DATE
) is
begin
  update CS_TP_LOOKUPS set

  LOOKUP_TYPE  = X_LOOKUP_TYPE,
  DEFAULT_VALUE  = X_DEFAULT_VALUE,
  CREATION_DATE = X_CREATION_DATE,
  CREATED_BY  = X_CREATED_BY,
  LAST_UPDATE_DATE  = X_LAST_UPDATE_DATE,
  LAST_UPDATED_BY  = X_LAST_UPDATED_BY,
  LAST_UPDATE_LOGIN  = X_LAST_UPDATE_LOGIN,
  ATTRIBUTE_CATEGORY  = X_ATTRIBUTE_CATEGORY,
  ATTRIBUTE1  = X_ATTRIBUTE1,
  ATTRIBUTE2  = X_ATTRIBUTE2,
  ATTRIBUTE3  = X_ATTRIBUTE3,
  ATTRIBUTE4  = X_ATTRIBUTE4,
  ATTRIBUTE5  = X_ATTRIBUTE5,
  ATTRIBUTE6   =X_ATTRIBUTE6,
  ATTRIBUTE7  = X_ATTRIBUTE7,
  ATTRIBUTE8  = X_ATTRIBUTE8,
  ATTRIBUTE9  = X_ATTRIBUTE9,
  ATTRIBUTE10  = X_ATTRIBUTE10,
  ATTRIBUTE11  = X_ATTRIBUTE11,
  ATTRIBUTE12  = X_ATTRIBUTE12,
  ATTRIBUTE13  = X_ATTRIBUTE13,
  ATTRIBUTE14  = X_ATTRIBUTE14,
  ATTRIBUTE15  = X_ATTRIBUTE15,
  START_DATE_ACTIVE  = X_START_DATE_ACTIVE,
  END_DATE_ACTIVE = X_END_DATE_ACTIVE
   where  LOOKUP_ID  = X_LOOKUP_ID;

Line: 165

end UPDATE_ROW;

Line: 167

procedure DELETE_ROW (
  X_LOOKUP_ID in NUMBER
)  is
begin
  delete from CS_TP_LOOKUPS where
    LOOKUP_ID = X_LOOKUP_ID;

Line: 177

end DELETE_ROW;