eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_CF_FLOWS_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_ID in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_FLOW_TYPE_CODE in VARCHAR2,
  X_FLOW_DISPLAY_NAME 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,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_SEEDED_FLAG in VARCHAR2

) is
  cursor C is select ROWID from CS_CF_FLOWS_B
    where FLOW_ID = X_FLOW_ID
    ;

Line: 37


  insert into CS_CF_FLOWS_B (
    OBJECT_VERSION_NUMBER,
    FLOW_ID,
    FLOW_TYPE_CODE,
    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,
    SEEDED_FLAG
  ) values (
    X_OBJECT_VERSION_NUMBER,
    X_FLOW_ID,
    X_FLOW_TYPE_CODE,
    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_SEEDED_FLAG
  );

Line: 91


  insert into CS_CF_FLOWS_TL (
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    FLOW_ID,
    FLOW_DISPLAY_NAME,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_CREATED_BY,
    X_CREATION_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATE_LOGIN,
    X_FLOW_ID,
    X_FLOW_DISPLAY_NAME,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from CS_CF_FLOWS_TL T
    where T.FLOW_ID = X_FLOW_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 127


end INSERT_ROW;

Line: 153


  cursor c is select
      OBJECT_VERSION_NUMBER,
      FLOW_TYPE_CODE,
	 ATTRIBUTE_CATEGORY,
	 ATTRIBUTE1,
	 ATTRIBUTE2,
	 ATTRIBUTE3,
	 ATTRIBUTE4,
	 ATTRIBUTE5,
	 ATTRIBUTE6,
	 ATTRIBUTE7,
	 ATTRIBUTE8,
	 ATTRIBUTE9,
	 ATTRIBUTE10,
	 ATTRIBUTE11,
	 ATTRIBUTE12,
	 ATTRIBUTE13,
	 ATTRIBUTE14,
	 ATTRIBUTE15,
         SEEDED_FLAG
    from CS_CF_FLOWS_B
    where FLOW_ID = X_FLOW_ID
    for update of FLOW_ID nowait;

Line: 178


  cursor c1 is select
      FLOW_DISPLAY_NAME,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from CS_CF_FLOWS_TL
    where FLOW_ID = X_FLOW_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of FLOW_ID nowait;

Line: 190


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

Line: 254


procedure UPDATE_ROW (
  X_FLOW_ID in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_FLOW_TYPE_CODE in VARCHAR2,
  X_FLOW_DISPLAY_NAME in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_SEEDED_FLAG in VARCHAR2

) is
begin
  update CS_CF_FLOWS_B set
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
    FLOW_TYPE_CODE = X_FLOW_TYPE_CODE,
    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,
    SEEDED_FLAG = X_SEEDED_FLAG
  where FLOW_ID = X_FLOW_ID;

Line: 311


  update CS_CF_FLOWS_TL set
    FLOW_DISPLAY_NAME = X_FLOW_DISPLAY_NAME,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    SOURCE_LANG = userenv('LANG')
  where FLOW_ID = X_FLOW_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 323


end UPDATE_ROW;

Line: 325


procedure DELETE_ROW (
  X_FLOW_ID in NUMBER
) is
begin
  delete from CS_CF_FLOWS_TL
  where FLOW_ID = X_FLOW_ID;

Line: 336


  delete from CS_CF_FLOWS_B
  where FLOW_ID = X_FLOW_ID;

Line: 342


end DELETE_ROW;

Line: 347


  delete from CS_CF_FLOWS_TL T
  where not exists
    (select NULL
    from CS_CF_FLOWS_B B
    where B.FLOW_ID = T.FLOW_ID
    );

Line: 354


  update CS_CF_FLOWS_TL T set (
      FLOW_DISPLAY_NAME
    ) = (select
      B.FLOW_DISPLAY_NAME
    from CS_CF_FLOWS_TL B
    where B.FLOW_ID = T.FLOW_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.FLOW_ID,
      T.LANGUAGE
  ) in (select
      SUBT.FLOW_ID,
      SUBT.LANGUAGE
    from CS_CF_FLOWS_TL SUBB, CS_CF_FLOWS_TL SUBT
    where SUBB.FLOW_ID = SUBT.FLOW_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.FLOW_DISPLAY_NAME <> SUBT.FLOW_DISPLAY_NAME
      or (SUBB.FLOW_DISPLAY_NAME is null and SUBT.FLOW_DISPLAY_NAME is not null)
      or (SUBB.FLOW_DISPLAY_NAME is not null and SUBT.FLOW_DISPLAY_NAME is null)
  ));

Line: 375


  insert into CS_CF_FLOWS_TL (
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    FLOW_ID,
    FLOW_DISPLAY_NAME,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.CREATED_BY,
    B.CREATION_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATE_LOGIN,
    B.FLOW_ID,
    B.FLOW_DISPLAY_NAME,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from CS_CF_FLOWS_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from CS_CF_FLOWS_TL T
    where T.FLOW_ID = B.FLOW_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 410


  X_LAST_UPDATE_DATE in DATE,
  X_OWNER in VARCHAR2,
  X_SEEDED_FLAG in VARCHAR2,
  X_CUSTOM_MODE in VARCHAR2
) IS

  f_luby number ; -- entity owner in file

Line: 417


  f_ludate date ; -- entity update date in file

Line: 419


  db_ludate date; -- entity update date in db

Line: 446


  f_ludate := nvl(X_LAST_UPDATE_DATE, sysdate);

Line: 448


  select LAST_UPDATED_BY, LAST_UPDATE_DATE
  into db_luby, db_ludate
  from CS_CF_FLOWS_B
  where flow_id = X_FLOW_ID;

Line: 455


    SELECT object_version_number, rowid,
		 attribute_category,
		 attribute1,
		 attribute2,
		 attribute3,
		 attribute4,
		 attribute5,
		 attribute6,
		 attribute7,
		 attribute8,
		 attribute9,
		 attribute10,
		 attribute11,
		 attribute12,
		 attribute13,
		 attribute14,
		 attribute15
    INTO l_object_version_number, l_rowid,
	    l_attribute_category,
	    l_attribute1,
	    l_attribute2,
	    l_attribute3,
	    l_attribute4,
	    l_attribute5,
	    l_attribute6,
	    l_attribute7,
	    l_attribute8,
	    l_attribute9,
	    l_attribute10,
	    l_attribute11,
	    l_attribute12,
	    l_attribute13,
	    l_attribute14,
	    l_attribute15
    FROM CS_CF_FLOWS_B
    WHERE flow_id = X_FLOW_ID
    FOR UPDATE;

Line: 493


    CS_CF_FLOWS_PKG.Update_Row(
	 X_FLOW_ID => X_FLOW_ID,
	 X_FLOW_TYPE_CODE => X_FLOW_TYPE_CODE,
	 X_FLOW_DISPLAY_NAME => X_FLOW_DISPLAY_NAME,
	 X_OBJECT_VERSION_NUMBER => l_object_version_number + 1,
         X_SEEDED_FLAG => X_SEEDED_FLAG,
	 X_ATTRIBUTE_CATEGORY => l_attribute_category,
	 X_ATTRIBUTE1 => l_attribute1,
	 X_ATTRIBUTE2 => l_attribute2,
	 X_ATTRIBUTE3 => l_attribute3,
	 X_ATTRIBUTE4 => l_attribute4,
	 X_ATTRIBUTE5 => l_attribute5,
	 X_ATTRIBUTE6 => l_attribute6,
	 X_ATTRIBUTE7 => l_attribute7,
	 X_ATTRIBUTE8 => l_attribute8,
	 X_ATTRIBUTE9 => l_attribute9,
	 X_ATTRIBUTE10 => l_attribute10,
	 X_ATTRIBUTE11 => l_attribute11,
	 X_ATTRIBUTE12 => l_attribute12,
	 X_ATTRIBUTE13 => l_attribute13,
	 X_ATTRIBUTE14 => l_attribute14,
	 X_ATTRIBUTE15 => l_attribute15,
	 X_LAST_UPDATE_DATE => f_ludate,
	 X_LAST_UPDATED_BY => f_luby,
	 X_LAST_UPDATE_LOGIN => 0);

Line: 521


	 -- Record doesn't exist - insert in all cases
	 CS_CF_FLOWS_PKG.Insert_Row(
	   X_ROWID => l_rowid,
	   X_FLOW_ID => X_FLOW_ID,
	   X_FLOW_TYPE_CODE => X_FLOW_TYPE_CODE,
	   X_FLOW_DISPLAY_NAME => X_FLOW_DISPLAY_NAME,
	   X_OBJECT_VERSION_NUMBER => l_object_version_number,
	   X_ATTRIBUTE_CATEGORY => NULL,
        X_ATTRIBUTE1 => NULL,
        X_ATTRIBUTE2 => NULL,
        X_ATTRIBUTE3 => NULL,
        X_ATTRIBUTE4 => NULL,
        X_ATTRIBUTE5 => NULL,
        X_ATTRIBUTE6 => NULL,
        X_ATTRIBUTE7 => NULL,
        X_ATTRIBUTE8 => NULL,
        X_ATTRIBUTE9 => NULL,
        X_ATTRIBUTE10 => NULL,
        X_ATTRIBUTE11 => NULL,
        X_ATTRIBUTE12 => NULL,
        X_ATTRIBUTE13 => NULL,
        X_ATTRIBUTE14 => NULL,
        X_ATTRIBUTE15 => NULL,
        X_SEEDED_FLAG => X_SEEDED_FLAG,
	   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);

Line: 555


  X_LAST_UPDATE_DATE in DATE,
  X_FLOW_TYPE_CODE in VARCHAR2,
  X_FLOW_DISPLAY_NAME in VARCHAR2,
  X_CUSTOM_MODE in VARCHAR2

) IS

  f_luby		NUMBER;

Line: 573


  f_ludate := nvl(X_LAST_UPDATE_DATE, sysdate) ;

Line: 575


  SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE
  into db_luby, db_ludate
  from CS_CF_FLOWS_TL
  where flow_id = X_FLOW_ID
  and language = userenv('LANG');

Line: 582


    update CS_CF_FLOWS_TL set
	 FLOW_DISPLAY_NAME = nvl(X_FLOW_DISPLAY_NAME, FLOW_DISPLAY_NAME),
	 LAST_UPDATE_DATE = f_ludate,
	 LAST_UPDATED_BY = f_luby,
	 LAST_UPDATE_LOGIN = 0,
	 SOURCE_LANG = userenv('LANG')
    where FLOW_ID = X_FLOW_ID
    and   userenv('LANG') in (LANGUAGE, SOURCE_LANG);