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

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

Line: 3


procedure INSERT_ROW (
  X_ROWID in out VARCHAR2,
  X_RESULT_ID in NUMBER,
  X_GENERATE_PRIVATE_CALLBACK in VARCHAR2,
  X_POSITIVE_RESPONSE_FLAG in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_GENERATE_PUBLIC_CALLBACK in VARCHAR2,
  X_VERSATILITY_CODE in NUMBER,
  X_RESULT_REQUIRED in VARCHAR2,
  X_RESULT_CODE in VARCHAR2,
  X_MEDIA_TYPE in VARCHAR2,
  X_SHORT_DESCRIPTION in VARCHAR2,
  X_LONG_DESCRIPTION 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 JTF_IH_RESULTS_B
    where RESULT_ID = X_RESULT_ID
    ;

Line: 26


  insert into JTF_IH_RESULTS_B (
    GENERATE_PRIVATE_CALLBACK,
    POSITIVE_RESPONSE_FLAG,
    RESULT_ID,
    OBJECT_VERSION_NUMBER,
    GENERATE_PUBLIC_CALLBACK,
    VERSATILITY_CODE,
    RESULT_REQUIRED,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_GENERATE_PRIVATE_CALLBACK,
    X_POSITIVE_RESPONSE_FLAG,
    X_RESULT_ID,
    X_OBJECT_VERSION_NUMBER,
    X_GENERATE_PUBLIC_CALLBACK,
    X_VERSATILITY_CODE,
    X_RESULT_REQUIRED,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 54


  insert into JTF_IH_RESULTS_TL (
    RESULT_CODE,
    LONG_DESCRIPTION,
    OBJECT_VERSION_NUMBER,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    MEDIA_TYPE,
    SHORT_DESCRIPTION,
    RESULT_ID,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_RESULT_CODE,
    X_LONG_DESCRIPTION,
    X_OBJECT_VERSION_NUMBER,
    X_CREATED_BY,
    X_CREATION_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATE_LOGIN,
    X_MEDIA_TYPE,
    X_SHORT_DESCRIPTION,
    X_RESULT_ID,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from JTF_IH_RESULTS_TL T
    where T.RESULT_ID = X_RESULT_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 98


end INSERT_ROW;

Line: 113


  cursor c is select
      GENERATE_PRIVATE_CALLBACK,
      POSITIVE_RESPONSE_FLAG,
      OBJECT_VERSION_NUMBER,
      GENERATE_PUBLIC_CALLBACK,
      VERSATILITY_CODE,
      RESULT_REQUIRED
    from JTF_IH_RESULTS_B
    where RESULT_ID = X_RESULT_ID
    for update of RESULT_ID nowait;

Line: 125


  cursor c1 is select
      RESULT_CODE,
      MEDIA_TYPE,
      SHORT_DESCRIPTION,
      LONG_DESCRIPTION,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from JTF_IH_RESULTS_TL
    where RESULT_ID = X_RESULT_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of RESULT_ID nowait;

Line: 140


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

Line: 183


procedure UPDATE_ROW (
  X_RESULT_ID in NUMBER,
  X_GENERATE_PRIVATE_CALLBACK in VARCHAR2,
  X_POSITIVE_RESPONSE_FLAG in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_GENERATE_PUBLIC_CALLBACK in VARCHAR2,
  X_VERSATILITY_CODE in NUMBER,
  X_RESULT_REQUIRED in VARCHAR2,
  X_RESULT_CODE in VARCHAR2,
  X_MEDIA_TYPE in VARCHAR2,
  X_SHORT_DESCRIPTION in VARCHAR2,
  X_LONG_DESCRIPTION in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update JTF_IH_RESULTS_B set
    GENERATE_PRIVATE_CALLBACK = X_GENERATE_PRIVATE_CALLBACK,
    POSITIVE_RESPONSE_FLAG = X_POSITIVE_RESPONSE_FLAG,
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
    GENERATE_PUBLIC_CALLBACK = X_GENERATE_PUBLIC_CALLBACK,
    VERSATILITY_CODE = X_VERSATILITY_CODE,
    RESULT_REQUIRED = X_RESULT_REQUIRED,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where RESULT_ID = X_RESULT_ID;

Line: 216


  update JTF_IH_RESULTS_TL set
    RESULT_CODE = X_RESULT_CODE,
    MEDIA_TYPE = X_MEDIA_TYPE,
    SHORT_DESCRIPTION = X_SHORT_DESCRIPTION,
    LONG_DESCRIPTION = X_LONG_DESCRIPTION,
    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 RESULT_ID = X_RESULT_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 231


end UPDATE_ROW;

Line: 233


procedure DELETE_ROW (
  X_RESULT_ID in NUMBER
) is
begin
  delete from JTF_IH_RESULTS_TL
  where RESULT_ID = X_RESULT_ID;

Line: 244


  delete from JTF_IH_RESULTS_B
  where RESULT_ID = X_RESULT_ID;

Line: 250


end DELETE_ROW;

Line: 255


  delete from JTF_IH_RESULTS_TL T
  where not exists
    (select NULL
    from JTF_IH_RESULTS_B B
    where B.RESULT_ID = T.RESULT_ID
    );

Line: 262


  update JTF_IH_RESULTS_TL T set (
      RESULT_CODE,
      MEDIA_TYPE,
      SHORT_DESCRIPTION,
      LONG_DESCRIPTION
    ) = (select
      B.RESULT_CODE,
      B.MEDIA_TYPE,
      B.SHORT_DESCRIPTION,
      B.LONG_DESCRIPTION
    from JTF_IH_RESULTS_TL B
    where B.RESULT_ID = T.RESULT_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.RESULT_ID,
      T.LANGUAGE
  ) in (select
      SUBT.RESULT_ID,
      SUBT.LANGUAGE
    from JTF_IH_RESULTS_TL SUBB, JTF_IH_RESULTS_TL SUBT
    where SUBB.RESULT_ID = SUBT.RESULT_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.RESULT_CODE <> SUBT.RESULT_CODE
      or (SUBB.RESULT_CODE is null and SUBT.RESULT_CODE is not null)
      or (SUBB.RESULT_CODE is not null and SUBT.RESULT_CODE is null)
      or SUBB.MEDIA_TYPE <> SUBT.MEDIA_TYPE
      or (SUBB.MEDIA_TYPE is null and SUBT.MEDIA_TYPE is not null)
      or (SUBB.MEDIA_TYPE is not null and SUBT.MEDIA_TYPE is null)
      or SUBB.SHORT_DESCRIPTION <> SUBT.SHORT_DESCRIPTION
      or (SUBB.SHORT_DESCRIPTION is null and SUBT.SHORT_DESCRIPTION is not null)
      or (SUBB.SHORT_DESCRIPTION is not null and SUBT.SHORT_DESCRIPTION is null)
      or SUBB.LONG_DESCRIPTION <> SUBT.LONG_DESCRIPTION
      or (SUBB.LONG_DESCRIPTION is null and SUBT.LONG_DESCRIPTION is not null)
      or (SUBB.LONG_DESCRIPTION is not null and SUBT.LONG_DESCRIPTION is null)
  ));

Line: 298


  insert into JTF_IH_RESULTS_TL (
    RESULT_CODE,
    LONG_DESCRIPTION,
    OBJECT_VERSION_NUMBER,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    MEDIA_TYPE,
    SHORT_DESCRIPTION,
    RESULT_ID,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.RESULT_CODE,
    B.LONG_DESCRIPTION,
    B.OBJECT_VERSION_NUMBER,
    B.CREATED_BY,
    B.CREATION_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATE_LOGIN,
    B.MEDIA_TYPE,
    B.SHORT_DESCRIPTION,
    B.RESULT_ID,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from JTF_IH_RESULTS_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from JTF_IH_RESULTS_TL T
    where T.RESULT_ID = B.RESULT_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 372


	l_last_update_date	DATE;

Line: 373


	l_last_updated_by	NUMBER;

Line: 374


	l_last_update_login	NUMBER;

Line: 393


	l_last_update_date := sysdate;

Line: 394


	l_last_updated_by := user_id;

Line: 395


	l_last_update_login := 0;

Line: 397


	UPDATE_ROW(
  			X_RESULT_ID => l_result_id,
  			X_GENERATE_PUBLIC_CALLBACK => l_generate_public_callback,
  			X_GENERATE_PRIVATE_CALLBACK => l_generate_private_callback,
  			X_POSITIVE_RESPONSE_FLAG => l_positive_response_flag,
  			X_OBJECT_VERSION_NUMBER => l_object_version_number,
  			X_RESULT_REQUIRED => l_result_required,
  			X_VERSATILITY_CODE => l_versatility_code,
  			X_RESULT_CODE => l_result_code,
  			X_MEDIA_TYPE => l_media_type,
  			X_SHORT_DESCRIPTION => l_short_description,
  			X_LONG_DESCRIPTION => l_long_description,
  			X_LAST_UPDATE_DATE => l_last_update_date,
  			X_LAST_UPDATED_BY => l_last_updated_by,
  			X_LAST_UPDATE_LOGIN => l_last_update_login);

Line: 416


			INSERT_ROW(
			row_id,
  			X_RESULT_ID => l_result_id,
  			X_GENERATE_PUBLIC_CALLBACK => l_generate_public_callback,
  			X_GENERATE_PRIVATE_CALLBACK => l_generate_private_callback,
  			X_POSITIVE_RESPONSE_FLAG => l_positive_response_flag,
  			X_OBJECT_VERSION_NUMBER => l_object_version_number,
  			X_RESULT_REQUIRED => l_result_required,
  			X_VERSATILITY_CODE => l_versatility_code,
  			X_RESULT_CODE => l_result_code,
  			X_MEDIA_TYPE => l_media_type,
  			X_SHORT_DESCRIPTION => l_short_description,
  			X_LONG_DESCRIPTION => l_long_description,
			X_CREATION_DATE => l_creation_date,
			X_CREATED_BY => l_created_by,
  			X_LAST_UPDATE_DATE => l_last_update_date,
  			X_LAST_UPDATED_BY => l_last_updated_by,
  			X_LAST_UPDATE_LOGIN => l_last_update_login);

Line: 444


	UPDATE jtf_ih_results_tl SET
		result_id = X_RESULT_ID,
		result_code = X_RESULT_CODE,
		media_type = X_MEDIA_TYPE,
		short_description = X_SHORT_DESCRIPTION,
		long_description = X_LONG_DESCRIPTION,
		last_update_date = sysdate,
		last_updated_by = decode(X_OWNER, 'SEED', 1, 0),
		last_update_login = 0,
		source_lang = userenv('LANG')
	WHERE userenv('LANG') in (LANGUAGE, SOURCE_LANG) AND
		result_id = X_RESULT_ID;