APPS.CS_CF_FLOW_TYPE_PAGES_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_FLOW_TYPE_PAGE_ID in NUMBER,
  X_FLOW_TYPE_CODE in VARCHAR2,
  X_PAGE_CODE in VARCHAR2,
  X_SEQUENCE in NUMBER,
  X_FUNCTION_NAME 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_FLOW_TYPE_PAGES
    where FLOW_TYPE_PAGE_ID = X_FLOW_TYPE_PAGE_ID
    ;

Line: 21

  insert into CS_CF_FLOW_TYPE_PAGES (
    FLOW_TYPE_PAGE_ID,
    FLOW_TYPE_CODE,
    PAGE_CODE,
    SEQUENCE,
    FUNCTION_NAME,
    OBJECT_VERSION_NUMBER,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_FLOW_TYPE_PAGE_ID,
    X_FLOW_TYPE_CODE,
    X_PAGE_CODE,
    X_SEQUENCE,
    X_FUNCTION_NAME,
    X_OBJECT_VERSION_NUMBER,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 55

end INSERT_ROW;

Line: 65

  cursor c is select
      FLOW_TYPE_CODE,
      PAGE_CODE,
      SEQUENCE,
      FUNCTION_NAME,
      OBJECT_VERSION_NUMBER
    from CS_CF_FLOW_TYPE_PAGES
    where FLOW_TYPE_PAGE_ID = X_FLOW_TYPE_PAGE_ID
    for update of FLOW_TYPE_PAGE_ID nowait;

Line: 81

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

Line: 105

procedure UPDATE_ROW (
  X_FLOW_TYPE_PAGE_ID in NUMBER,
  X_FLOW_TYPE_CODE in VARCHAR2,
  X_PAGE_CODE in VARCHAR2,
  X_SEQUENCE in NUMBER,
  X_FUNCTION_NAME 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_FLOW_TYPE_PAGES set
    FLOW_TYPE_CODE = X_FLOW_TYPE_CODE,
    PAGE_CODE = X_PAGE_CODE,
    SEQUENCE = X_SEQUENCE,
    FUNCTION_NAME = X_FUNCTION_NAME,
    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 FLOW_TYPE_PAGE_ID = X_FLOW_TYPE_PAGE_ID;

Line: 132

end UPDATE_ROW;

Line: 134

procedure DELETE_ROW (
  X_FLOW_TYPE_PAGE_ID in NUMBER
) is
begin

  delete from CS_CF_FLOW_TYPE_PAGES
  where FLOW_TYPE_PAGE_ID = X_FLOW_TYPE_PAGE_ID;

Line: 145

end DELETE_ROW;

Line: 155

  X_LAST_UPDATE_DATE in DATE,
  X_CUSTOM_MODE in VARCHAR2
) IS

  f_luby number ; -- entity owner in file

Line: 160

  f_ludate date ; -- entity update date in file

Line: 162

  db_ludate date; -- entity update date in db

Line: 170

  f_ludate := nvl(X_LAST_UPDATE_DATE, sysdate);

Line: 172

  select LAST_UPDATED_BY, LAST_UPDATE_DATE
  into db_luby, db_ludate
  from CS_CF_FLOW_TYPE_PAGES
  where flow_type_page_id = X_FLOW_TYPE_PAGE_ID;

Line: 179

    SELECT object_version_number, rowid
    INTO l_object_version_number, l_rowid
    FROM CS_CF_FLOW_TYPE_PAGES
    WHERE flow_type_page_id = X_FLOW_TYPE_PAGE_ID
    FOR UPDATE ;

Line: 185

    CS_CF_FLOW_TYPE_PAGES_PKG.Update_Row(
	 X_FLOW_TYPE_PAGE_ID => X_FLOW_TYPE_PAGE_ID,
	 X_FLOW_TYPE_CODE => X_FLOW_TYPE_CODE,
	 X_PAGE_CODE => X_PAGE_CODE,
	 X_SEQUENCE => X_SEQUENCE,
	 X_FUNCTION_NAME => X_FUNCTION_NAME,
	 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: 198

	 -- Record doesn't exist - insert in all cases
	 CS_CF_FLOW_TYPE_PAGES_PKG.Insert_Row(
	   X_ROWID => l_rowid,
	   X_FLOW_TYPE_PAGE_ID => X_FLOW_TYPE_PAGE_ID,
	   X_FLOW_TYPE_CODE => X_FLOW_TYPE_CODE,
	   X_PAGE_CODE => X_PAGE_CODE,
	   X_SEQUENCE => X_SEQUENCE,
	   X_FUNCTION_NAME => X_FUNCTION_NAME,
	   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);