APPS.ICX_QUESTIONS_PKG SQL Statements

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

Line: 4

procedure INSERT_ROW (
  X_ROWID			in out VARCHAR2,
  X_QUESTION_CODE 	in 	VARCHAR2,
  X_APPLICATION_ID 		in	NUMBER,
  X_TYPE			in VARCHAR2,
  X_QUESTION 		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 ICX_QUESTIONS
    where QUESTION_CODE = X_QUESTION_CODE;

Line: 20

  insert into ICX_QUESTIONS (
    QUESTION_CODE,
    APPLICATION_ID,
    TYPE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_QUESTION_CODE,
    X_APPLICATION_ID,
    X_TYPE,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 40

  insert into ICX_QUESTIONS_TL (
    QUESTION_CODE,
    QUESTION,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
	SOURCE_LANG
  ) select
    X_QUESTION_CODE,
    X_QUESTION,
    X_CREATED_BY,
    X_CREATION_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATE_LOGIN,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG IN ('I','B')
  and   not exists
    (select NULL
     from   ICX_QUESTIONS_TL T
     where  T.QUESTION_CODE = X_QUESTION_CODE
     and    T.LANGUAGE = L.LANGUAGE_CODE);

Line: 75

end INSERT_ROW;

Line: 77

procedure UPDATE_ROW (
  X_QUESTION_CODE		in VARCHAR2,
  X_APPLICATION_ID 			in NUMBER,
  X_TYPE				in VARCHAR2,
  X_QUESTION				in VARCHAR2,
  X_LAST_UPDATE_DATE 		in DATE,
  X_LAST_UPDATED_BY 		in NUMBER,
  X_LAST_UPDATE_LOGIN 		in NUMBER
) is
begin
  update ICX_QUESTIONS set
    APPLICATION_ID = X_APPLICATION_ID,
    TYPE = X_TYPE,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where QUESTION_CODE = X_QUESTION_CODE;

Line: 99

  update ICX_QUESTIONS_TL set
    QUESTION = X_QUESTION,
    SOURCE_LANG = userenv('LANG'),
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where QUESTION_CODE = X_QUESTION_CODE
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 111

end UPDATE_ROW;

Line: 119

  update ICX_QUESTIONS_tl set
    question                 = X_QUESTION,
    SOURCE_LANG		     = userenv('LANG'),
    last_update_date         = sysdate,
    last_updated_by          = decode(X_OWNER, 'SEED', 1, 0),
    last_update_login        = 0
  where question_code = X_QUESTION_CODE
  and userenv('LANG') in (language, source_lang);

Line: 148

     select QUESTION_CODE into ques_code
     from   ICX_QUESTIONS
     where  QUESTION_CODE = X_QUESTION_CODE;

Line: 152

     icx_questions_pkg.UPDATE_ROW (
	X_QUESTION_CODE =>		X_QUESTION_CODE,
	X_APPLICATION_ID =>		X_APPLICATION_ID,
	X_TYPE		=>		X_TYPE,
	X_QUESTION =>		X_QUESTION,
	X_LAST_UPDATE_DATE =>		sysdate,
	X_LAST_UPDATED_BY =>		user_id,
	X_LAST_UPDATE_LOGIN =>		0);

Line: 164

       icx_questions_pkg.INSERT_ROW (
	X_ROWID =>				row_id,
	X_QUESTION_CODE =>		X_QUESTION_CODE,
	X_APPLICATION_ID =>		X_APPLICATION_ID,
	X_TYPE =>			X_TYPE,
	X_QUESTION =>		X_QUESTION,
	X_CREATION_DATE => 		sysdate,
	X_CREATED_BY => 		user_id,
	X_LAST_UPDATE_DATE =>		sysdate,
	X_LAST_UPDATED_BY =>		user_id,
	X_LAST_UPDATE_LOGIN =>		0);

Line: 182

  delete from ICX_QUESTIONS_TL T
  where not exists
    (select NULL
    from ICX_QUESTIONS B
    where B.QUESTION_CODE = T.QUESTION_CODE
    );

Line: 189

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

Line: 209

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