APPS.CS_CF_SOURCE_CXT_TYPES_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_SOURCE_CONTEXT_TYPE_ID in NUMBER,
  X_SOURCE_CODE in VARCHAR2,
  X_CONTEXT_TYPE in VARCHAR2,
  X_PRIORITY in NUMBER,
  X_SOURCE_TYPE in VARCHAR2,
  X_PURPOSE 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 CS_CF_SOURCE_CXT_TYPES
    where SOURCE_CONTEXT_TYPE_ID = X_SOURCE_CONTEXT_TYPE_ID
    ;

Line: 22

  insert into CS_CF_SOURCE_CXT_TYPES (
    SOURCE_CONTEXT_TYPE_ID,
    SOURCE_CODE,
    CONTEXT_TYPE,
    PRIORITY,
    SOURCE_TYPE,
    PURPOSE,
    OBJECT_VERSION_NUMBER,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_SOURCE_CONTEXT_TYPE_ID,
    X_SOURCE_CODE,
    X_CONTEXT_TYPE,
    X_PRIORITY,
    X_SOURCE_TYPE,
    X_PURPOSE,
    X_OBJECT_VERSION_NUMBER,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 57

end INSERT_ROW;

Line: 68

  cursor c is select
      SOURCE_CODE,
      CONTEXT_TYPE,
      PRIORITY,
      SOURCE_TYPE,
	 PURPOSE,
      OBJECT_VERSION_NUMBER
    from CS_CF_SOURCE_CXT_TYPES
    where SOURCE_CONTEXT_TYPE_ID = X_SOURCE_CONTEXT_TYPE_ID
    for update of SOURCE_CONTEXT_TYPE_ID nowait;

Line: 85

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

Line: 111

procedure UPDATE_ROW (
  X_SOURCE_CONTEXT_TYPE_ID in NUMBER,
  X_SOURCE_CODE in VARCHAR2,
  X_CONTEXT_TYPE in VARCHAR2,
  X_PRIORITY in NUMBER,
  X_SOURCE_TYPE in VARCHAR2,
  X_PURPOSE 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
begin
  update CS_CF_SOURCE_CXT_TYPES set
    SOURCE_CODE = X_SOURCE_CODE,
    CONTEXT_TYPE = X_CONTEXT_TYPE,
    PRIORITY = X_PRIORITY,
    SOURCE_TYPE = X_SOURCE_TYPE,
    PURPOSE = X_PURPOSE,
    OBJECT_VERSION_NUMBER = X_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 SOURCE_CONTEXT_TYPE_ID = X_SOURCE_CONTEXT_TYPE_ID;

Line: 140

end UPDATE_ROW;

Line: 142

procedure DELETE_ROW (
  X_SOURCE_CONTEXT_TYPE_ID in NUMBER
) is
begin

  delete from CS_CF_SOURCE_CXT_TYPES
  where SOURCE_CONTEXT_TYPE_ID = X_SOURCE_CONTEXT_TYPE_ID;

Line: 153

end DELETE_ROW;

Line: 163

  X_LAST_UPDATE_DATE in DATE,
  X_CUSTOM_MODE in VARCHAR2
) IS

  f_luby number ; -- entity owner in file

Line: 168

  f_ludate date ; -- entity update date in file

Line: 170

  db_ludate date; -- entity update date in db

Line: 178

  f_ludate := nvl(X_LAST_UPDATE_DATE, sysdate);

Line: 180

  select LAST_UPDATED_BY, LAST_UPDATE_DATE
  into db_luby, db_ludate
  from CS_CF_SOURCE_CXT_TYPES
  where source_context_type_id = X_SOURCE_CONTEXT_TYPE_ID;

Line: 187

    SELECT object_version_number, rowid
    INTO l_object_version_number, l_rowid
    FROM CS_CF_SOURCE_CXT_TYPES
    WHERE source_context_type_id = X_SOURCE_CONTEXT_TYPE_ID
    FOR UPDATE;

Line: 193

    CS_CF_SOURCE_CXT_TYPES_PKG.Update_Row(
	 X_SOURCE_CONTEXT_TYPE_ID => X_SOURCE_CONTEXT_TYPE_ID,
	 X_SOURCE_CODE => X_SOURCE_CODE,
	 X_CONTEXT_TYPE => X_CONTEXT_TYPE,
	 X_PRIORITY => X_PRIORITY,
	 X_SOURCE_TYPE => X_SOURCE_TYPE,
	 X_PURPOSE => X_PURPOSE,
	 X_OBJECT_VERSION_NUMBER => l_object_version_number + 1,
	 X_LAST_UPDATE_DATE => f_ludate,
	 X_LAST_UPDATED_BY => f_luby,
	 X_LAST_UPDATE_LOGIN => 0);

Line: 207

	 -- Record doesn't exist - insert in all cases
	 CS_CF_SOURCE_CXT_TYPES_PKG.Insert_Row(
	   X_ROWID => l_rowid,
	   X_SOURCE_CONTEXT_TYPE_ID => X_SOURCE_CONTEXT_TYPE_ID,
	   X_SOURCE_CODE => X_SOURCE_CODE,
	   X_CONTEXT_TYPE => X_CONTEXT_TYPE,
	   X_PRIORITY => X_PRIORITY,
	   X_SOURCE_TYPE => X_SOURCE_TYPE,
	   X_PURPOSE => X_PURPOSE,
	   X_OBJECT_VERSION_NUMBER => l_object_version_number,
	   X_CREATION_DATE => sysdate,
	   X_CREATED_BY => f_luby,
	   X_LAST_UPDATE_DATE => f_ludate,
	   X_LAST_UPDATED_BY => f_luby,
	   X_LAST_UPDATE_LOGIN => 0);