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.AMW_OPINION_VALUES_PKG SQL Statements

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

Line: 4


procedure INSERT_ROW (
  X_ROWID in out nocopy VARCHAR2,
  X_OPINION_VALUE_ID in NUMBER,
  X_OPINION_VALUE_CODE in VARCHAR2,
  X_OPINION_COMPONENT_ID in NUMBER,
  X_END_DATE in DATE,
  X_ATTACHMENT_ID in NUMBER,
  X_IMAGE_FILE_NAME in VARCHAR2,
  X_DISPLAY_ORDER in NUMBER,
  X_SECURITY_GROUP_ID in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_OPINION_VALUE_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
) is
  cursor C is select ROWID from AMW_OPINION_VALUES_B
    where OPINION_VALUE_ID = X_OPINION_VALUE_ID
    ;

Line: 26


  insert into AMW_OPINION_VALUES_B (
    OPINION_VALUE_ID,
    OPINION_VALUE_CODE,
    OPINION_COMPONENT_ID,
    END_DATE,
    ATTACHMENT_ID,
    IMAGE_FILE_NAME,
    DISPLAY_ORDER,
    SECURITY_GROUP_ID,
    OBJECT_VERSION_NUMBER,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_OPINION_VALUE_ID,
    X_OPINION_VALUE_CODE,
    X_OPINION_COMPONENT_ID,
    X_END_DATE,
    X_ATTACHMENT_ID,
    X_IMAGE_FILE_NAME,
    X_DISPLAY_ORDER,
    X_SECURITY_GROUP_ID,
    X_OBJECT_VERSION_NUMBER,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 58


  insert into AMW_OPINION_VALUES_TL (
    OPINION_VALUE_ID,
    OPINION_VALUE_NAME,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    SECURITY_GROUP_ID,
    OBJECT_VERSION_NUMBER,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_OPINION_VALUE_ID,
    X_OPINION_VALUE_NAME,
    X_CREATED_BY,
    X_CREATION_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATE_LOGIN,
    X_SECURITY_GROUP_ID,
    X_OBJECT_VERSION_NUMBER,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from AMW_OPINION_VALUES_TL T
    where T.OPINION_VALUE_ID = X_OPINION_VALUE_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 98


end INSERT_ROW;

Line: 112


  cursor c is select
      OPINION_VALUE_CODE,
      OPINION_COMPONENT_ID,
      END_DATE,
      ATTACHMENT_ID,
      IMAGE_FILE_NAME,
	DISPLAY_ORDER,
      SECURITY_GROUP_ID,
      OBJECT_VERSION_NUMBER
    from AMW_OPINION_VALUES_B
    where OPINION_VALUE_ID = X_OPINION_VALUE_ID
    for update of OPINION_VALUE_ID nowait;

Line: 126


  cursor c1 is select
      OPINION_VALUE_NAME,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from AMW_OPINION_VALUES_TL
    where OPINION_VALUE_ID = X_OPINION_VALUE_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of OPINION_VALUE_ID nowait;

Line: 138


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

Line: 178


procedure UPDATE_ROW (
  X_OPINION_VALUE_ID in NUMBER,
  X_OPINION_VALUE_CODE in VARCHAR2,
  X_OPINION_COMPONENT_ID in NUMBER,
  X_END_DATE in DATE,
  X_ATTACHMENT_ID in NUMBER,
  X_IMAGE_FILE_NAME in VARCHAR2,
  X_DISPLAY_ORDER in NUMBER,
  X_SECURITY_GROUP_ID in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_OPINION_VALUE_NAME in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update AMW_OPINION_VALUES_B set
    OPINION_VALUE_CODE = X_OPINION_VALUE_CODE,
    OPINION_COMPONENT_ID = X_OPINION_COMPONENT_ID,
    END_DATE = X_END_DATE,
    ATTACHMENT_ID = X_ATTACHMENT_ID,
    IMAGE_FILE_NAME = X_IMAGE_FILE_NAME,
    DISPLAY_ORDER = X_DISPLAY_ORDER,
    SECURITY_GROUP_ID = X_SECURITY_GROUP_ID,
    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 OPINION_VALUE_ID = X_OPINION_VALUE_ID;

Line: 212


  update AMW_OPINION_VALUES_TL set
    OPINION_VALUE_NAME = X_OPINION_VALUE_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 OPINION_VALUE_ID = X_OPINION_VALUE_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 224


end UPDATE_ROW;

Line: 226


procedure DELETE_ROW (
  X_OPINION_VALUE_ID in NUMBER
) is
begin
  delete from AMW_OPINION_VALUES_TL
  where OPINION_VALUE_ID = X_OPINION_VALUE_ID;

Line: 237


  delete from AMW_OPINION_VALUES_B
  where OPINION_VALUE_ID = X_OPINION_VALUE_ID;

Line: 243


end DELETE_ROW;

Line: 248


  delete from AMW_OPINION_VALUES_TL T
  where not exists
    (select NULL
    from AMW_OPINION_VALUES_B B
    where B.OPINION_VALUE_ID = T.OPINION_VALUE_ID
    );

Line: 255


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

Line: 276


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

Line: 319


	X_LAST_UPDATE_DATE    		in VARCHAR2,
	X_OWNER				in VARCHAR2,
	X_CUSTOM_MODE			in VARCHAR2) is

f_luby	number;	-- entity owner in file

Line: 324


f_ludate	date;		-- entity update date in file

Line: 326


db_ludate	date;		-- entity update date in db

Line: 331


	-- Translate owner to file_last_updated_by
	f_luby := fnd_load_util.owner_id(X_OWNER);

Line: 334


	-- Translate char last_update_date to date
	f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);

Line: 337


	select last_updated_by, last_update_date into db_luby, db_ludate
	from AMW_OPINION_VALUES_B
	where opinion_value_id = X_OPINION_VALUE_ID;

Line: 342


	then AMW_OPINION_VALUES_PKG.UPDATE_ROW(
		X_OPINION_VALUE_ID		=> X_OPINION_VALUE_ID,
		X_OPINION_VALUE_CODE		=> X_OPINION_VALUE_CODE,
		X_OPINION_COMPONENT_ID		=> X_OPINION_COMPONENT_ID,
		X_END_DATE				=> to_date(X_END_DATE, 'YYYY/MM/DD'),
		X_ATTACHMENT_ID			=> X_ATTACHMENT_ID,
		X_IMAGE_FILE_NAME			=> X_IMAGE_FILE_NAME,
		X_DISPLAY_ORDER			=> X_DISPLAY_ORDER,
		X_SECURITY_GROUP_ID		=> null,
		X_OBJECT_VERSION_NUMBER		=> 1,
		X_OPINION_VALUE_NAME		=> X_OPINION_VALUE_NAME,
		X_LAST_UPDATE_DATE		=> f_ludate,
		X_LAST_UPDATED_BY			=> f_luby,
		X_LAST_UPDATE_LOGIN		=> 0);

Line: 358


	then AMW_OPINION_VALUES_PKG.INSERT_ROW(
		X_ROWID				=> row_id,
		X_OPINION_VALUE_ID		=> X_OPINION_VALUE_ID,
		X_OPINION_VALUE_CODE		=> X_OPINION_VALUE_CODE,
		X_OPINION_COMPONENT_ID		=> X_OPINION_COMPONENT_ID,
		X_END_DATE				=> to_date(X_END_DATE, 'YYYY/MM/DD'),
		X_ATTACHMENT_ID			=> X_ATTACHMENT_ID,
		X_IMAGE_FILE_NAME			=> X_IMAGE_FILE_NAME,
		X_DISPLAY_ORDER			=> X_DISPLAY_ORDER,
		X_SECURITY_GROUP_ID		=> null,
		X_OBJECT_VERSION_NUMBER		=> 1,
		X_OPINION_VALUE_NAME		=> X_OPINION_VALUE_NAME,
		X_CREATION_DATE			=> f_ludate,
		X_CREATED_BY			=> f_luby,
		X_LAST_UPDATE_DATE		=> f_ludate,
		X_LAST_UPDATED_BY			=> f_luby,
		X_LAST_UPDATE_LOGIN		=> 0);

Line: 380


	X_LAST_UPDATE_DATE    	in VARCHAR2,
	X_OWNER			in VARCHAR2,
	X_CUSTOM_MODE		in VARCHAR2) is

f_luby	number;	-- entity owner in file

Line: 385


f_ludate	date;		-- entity update date in file

Line: 387


db_ludate	date;		-- entity update date in db

Line: 390


	-- Translate owner to file_last_updated_by
	f_luby := fnd_load_util.owner_id(X_OWNER);

Line: 393


	-- Translate char last_update_date to date
	f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);

Line: 396


	select last_updated_by, last_update_date into db_luby, db_ludate
	from AMW_OPINION_VALUES_TL
	where opinion_value_id = X_OPINION_VALUE_ID and language = userenv('LANG');

Line: 401


	then update AMW_OPINION_VALUES_TL set
		opinion_value_name	= nvl(X_OPINION_VALUE_NAME, opinion_value_name),
		source_lang			= userenv('LANG'),
		last_update_date		= f_ludate,
		last_updated_by		= f_luby,
		last_update_login		= 0
	where	opinion_value_id = X_OPINION_VALUE_ID and userenv('LANG') in (language, source_lang);