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_OUTCOMES_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_OUTCOME_ID in NUMBER,
  X_GENERATE_PUBLIC_CALLBACK in VARCHAR2,
  X_GENERATE_PRIVATE_CALLBACK in VARCHAR2,
  X_SCORE in NUMBER,
  X_POSITIVE_OUTCOME_FLAG in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_RESULT_REQUIRED in VARCHAR2,
  X_VERSATILITY_CODE in NUMBER,
  X_OUTCOME_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_OUTCOMES_B
    where OUTCOME_ID = X_OUTCOME_ID
    ;

Line: 27


  insert into JTF_IH_OUTCOMES_B (
    GENERATE_PUBLIC_CALLBACK,
    GENERATE_PRIVATE_CALLBACK,
    SCORE,
    POSITIVE_OUTCOME_FLAG,
    OUTCOME_ID,
    OBJECT_VERSION_NUMBER,
    RESULT_REQUIRED,
    VERSATILITY_CODE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_GENERATE_PUBLIC_CALLBACK,
    X_GENERATE_PRIVATE_CALLBACK,
    X_SCORE,
    X_POSITIVE_OUTCOME_FLAG,
    X_OUTCOME_ID,
    X_OBJECT_VERSION_NUMBER,
    X_RESULT_REQUIRED,
    X_VERSATILITY_CODE,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 57


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

Line: 101


end INSERT_ROW;

Line: 117


  cursor c is select
      GENERATE_PUBLIC_CALLBACK,
      GENERATE_PRIVATE_CALLBACK,
      SCORE,
      POSITIVE_OUTCOME_FLAG,
      OBJECT_VERSION_NUMBER,
      RESULT_REQUIRED,
      VERSATILITY_CODE
    from JTF_IH_OUTCOMES_B
    where OUTCOME_ID = X_OUTCOME_ID
    for update of OUTCOME_ID nowait;

Line: 130


  cursor c1 is select
      OUTCOME_CODE,
      MEDIA_TYPE,
      SHORT_DESCRIPTION,
      LONG_DESCRIPTION,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from JTF_IH_OUTCOMES_TL
    where OUTCOME_ID = X_OUTCOME_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of OUTCOME_ID nowait;

Line: 145


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

Line: 188


procedure UPDATE_ROW (
  X_OUTCOME_ID in NUMBER,
  X_GENERATE_PUBLIC_CALLBACK in VARCHAR2,
  X_GENERATE_PRIVATE_CALLBACK in VARCHAR2,
  X_SCORE in NUMBER,
  X_POSITIVE_OUTCOME_FLAG in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_RESULT_REQUIRED in VARCHAR2,
  X_VERSATILITY_CODE in NUMBER,
  X_OUTCOME_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_OUTCOMES_B set
    GENERATE_PUBLIC_CALLBACK = X_GENERATE_PUBLIC_CALLBACK,
    GENERATE_PRIVATE_CALLBACK = X_GENERATE_PRIVATE_CALLBACK,
    SCORE = X_SCORE,
    POSITIVE_OUTCOME_FLAG = X_POSITIVE_OUTCOME_FLAG,
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
    RESULT_REQUIRED = X_RESULT_REQUIRED,
    VERSATILITY_CODE = X_VERSATILITY_CODE,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where OUTCOME_ID = X_OUTCOME_ID;

Line: 223


  update JTF_IH_OUTCOMES_TL set
    OUTCOME_CODE = X_OUTCOME_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 OUTCOME_ID = X_OUTCOME_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 238


end UPDATE_ROW;

Line: 240


procedure DELETE_ROW (
  X_OUTCOME_ID in NUMBER
) is
begin
  delete from JTF_IH_OUTCOMES_TL
  where OUTCOME_ID = X_OUTCOME_ID;

Line: 251


  delete from JTF_IH_OUTCOMES_B
  where OUTCOME_ID = X_OUTCOME_ID;

Line: 257


end DELETE_ROW;

Line: 262


  delete from JTF_IH_OUTCOMES_TL T
  where not exists
    (select NULL
    from JTF_IH_OUTCOMES_B B
    where B.OUTCOME_ID = T.OUTCOME_ID
    );

Line: 269


  update JTF_IH_OUTCOMES_TL T set (
      OUTCOME_CODE,
      MEDIA_TYPE,
      SHORT_DESCRIPTION,
      LONG_DESCRIPTION
    ) = (select
      B.OUTCOME_CODE,
      B.MEDIA_TYPE,
      B.SHORT_DESCRIPTION,
      B.LONG_DESCRIPTION
    from JTF_IH_OUTCOMES_TL B
    where B.OUTCOME_ID = T.OUTCOME_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.OUTCOME_ID,
      T.LANGUAGE
  ) in (select
      SUBT.OUTCOME_ID,
      SUBT.LANGUAGE
    from JTF_IH_OUTCOMES_TL SUBB, JTF_IH_OUTCOMES_TL SUBT
    where SUBB.OUTCOME_ID = SUBT.OUTCOME_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.OUTCOME_CODE <> SUBT.OUTCOME_CODE
      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.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: 301


  insert into JTF_IH_OUTCOMES_TL (
    OUTCOME_ID,
    OBJECT_VERSION_NUMBER,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    LONG_DESCRIPTION,
    SHORT_DESCRIPTION,
    OUTCOME_CODE,
    MEDIA_TYPE,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.OUTCOME_ID,
    B.OBJECT_VERSION_NUMBER,
    B.CREATED_BY,
    B.CREATION_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATE_LOGIN,
    B.LONG_DESCRIPTION,
    B.SHORT_DESCRIPTION,
    B.OUTCOME_CODE,
    B.MEDIA_TYPE,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from JTF_IH_OUTCOMES_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_OUTCOMES_TL T
    where T.OUTCOME_ID = B.OUTCOME_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 377


	l_last_update_date	DATE;

Line: 378


	l_last_updated_by	NUMBER;

Line: 379


	l_last_update_login	NUMBER;

Line: 399


	l_last_update_date := sysdate;

Line: 400


	l_last_updated_by := user_id;

Line: 401


	l_last_update_login := 0;

Line: 403


	UPDATE_ROW(
  			X_OUTCOME_ID => l_outcome_id,
  			X_GENERATE_PUBLIC_CALLBACK => l_generate_public_callback,
  			X_GENERATE_PRIVATE_CALLBACK => l_generate_private_callback,
  			X_SCORE => l_score,
  			X_POSITIVE_OUTCOME_FLAG => l_positive_outcome_flag,
  			X_OBJECT_VERSION_NUMBER => l_object_version_number,
  			X_RESULT_REQUIRED => l_result_required,
  			X_VERSATILITY_CODE => l_versatility_code,
  			X_OUTCOME_CODE => l_outcome_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: 423


			INSERT_ROW(
			row_id,
  			X_OUTCOME_ID => l_outcome_id,
  			X_GENERATE_PUBLIC_CALLBACK => l_generate_public_callback,
  			X_GENERATE_PRIVATE_CALLBACK => l_generate_private_callback,
  			X_SCORE => l_score,
  			X_POSITIVE_OUTCOME_FLAG => l_positive_outcome_flag,
  			X_OBJECT_VERSION_NUMBER => l_object_version_number,
  			X_RESULT_REQUIRED => l_result_required,
  			X_VERSATILITY_CODE => l_versatility_code,
  			X_OUTCOME_CODE => l_outcome_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: 452


	UPDATE jtf_ih_outcomes_tl SET
		outcome_id = X_OUTCOME_CODE,
		media_type = X_OUTCOME_CODE,
		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
		outcome_id = X_OUTCOME_ID;