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

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

Line: 3


  PROCEDURE Insert_Row (p_uwq_maction_defs_rec IN uwq_maction_defs_rec_type) IS

    CURSOR c IS 	SELECT 'X' FROM ieu_uwq_maction_defs_b
      		WHERE maction_def_id = p_uwq_maction_defs_rec.maction_def_id;

Line: 13


    INSERT INTO ieu_uwq_maction_defs_b (
      maction_def_id,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      action_proc,
      ACTION_PROC_TYPE_CODE,
      maction_def_type_flag,
      global_form_params,
      multi_select_flag,
      maction_def_key,
      application_id
    ) VALUES (
      p_uwq_maction_defs_rec.maction_def_id,
      p_uwq_maction_defs_rec.created_by,
      p_uwq_maction_defs_rec.creation_date,
      p_uwq_maction_defs_rec.last_updated_by,
      p_uwq_maction_defs_rec.last_update_date,
      p_uwq_maction_defs_rec.last_update_login,
      p_uwq_maction_defs_rec.action_proc,
      p_uwq_maction_defs_rec.ACTION_PROC_TYPE_CODE,
      p_uwq_maction_defs_rec.maction_def_type_flag,
      p_uwq_maction_defs_rec.global_form_params,
      p_uwq_maction_defs_rec.multi_select_flag,
      p_uwq_maction_defs_rec.maction_def_key,
      p_uwq_maction_defs_rec.application_id
    );

Line: 43


    INSERT INTO ieu_uwq_maction_defs_tl (
      maction_def_id,
      language,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      action_user_label,
      source_lang,
      action_description
    ) SELECT
      	p_uwq_maction_defs_rec.maction_def_id,
      	l.language_code,
      	p_uwq_maction_defs_rec.created_by,
      	p_uwq_maction_defs_rec.creation_date,
      	p_uwq_maction_defs_rec.last_updated_by,
      	p_uwq_maction_defs_rec.last_update_date,
      	p_uwq_maction_defs_rec.last_update_login,
      	p_uwq_maction_defs_rec.action_user_label,
      	USERENV('LANG'),
      	p_uwq_maction_defs_rec.action_description
      FROM fnd_languages l
      WHERE l.installed_flag IN ('I', 'B')
      AND NOT EXISTS
        (SELECT NULL
         FROM ieu_uwq_maction_defs_tl t
         WHERE t.maction_def_id = p_uwq_maction_defs_rec.maction_def_id
         AND t.language = l.language_code);

Line: 82


  END Insert_Row;

Line: 84


  PROCEDURE Update_Row (p_uwq_maction_defs_rec IN uwq_maction_defs_rec_type) IS

  BEGIN
     -- API body
    UPDATE ieu_uwq_maction_defs_b SET
      last_updated_by = p_uwq_maction_defs_rec.last_updated_by,
      last_update_date = p_uwq_maction_defs_rec.last_update_date,
      last_update_login = p_uwq_maction_defs_rec.last_update_login,
      action_proc = p_uwq_maction_defs_rec.action_proc,
      ACTION_PROC_TYPE_CODE = p_uwq_maction_defs_rec.ACTION_PROC_TYPE_CODE,
      MACTION_DEF_TYPE_FLAG =   p_uwq_maction_defs_rec.maction_def_type_flag,
      GLOBAL_FORM_PARAMS = p_uwq_maction_defs_rec.global_form_params,
      MULTI_SELECT_FLAG = p_uwq_maction_defs_rec.multi_select_flag,
      MACTION_DEF_KEY = p_uwq_maction_defs_rec.maction_def_key

    WHERE maction_def_id = p_uwq_maction_defs_rec.maction_def_id;

Line: 105


    UPDATE ieu_uwq_maction_defs_tl SET
      action_user_label = p_uwq_maction_defs_rec.action_user_label,
      source_lang = USERENV('LANG'),
      action_description = p_uwq_maction_defs_rec.action_description,
      last_updated_by = p_uwq_maction_defs_rec.last_updated_by,
      last_update_date = p_uwq_maction_defs_rec.last_update_date,
      last_update_login = p_uwq_maction_defs_rec.last_update_login
    WHERE maction_def_id = p_uwq_maction_defs_rec.maction_def_id
    AND USERENV('LANG') IN (language, source_lang);

Line: 120


  END Update_Row;

Line: 129


	            p_MULTI_SELECT_FLAG IN VARCHAR2,
	            p_MACTION_DEF_KEY IN VARCHAR2,
                  p_last_update_date IN VARCHAR2,
                p_application_short_name IN VARCHAR2,
		        p_action_user_label IN VARCHAR2,
                p_action_description IN VARCHAR2,
                p_owner IN VARCHAR2) IS
  BEGIN

    DECLARE
       user_id		     number := 0;

Line: 141


       l_last_update_date date;

Line: 152


       select a.application_id
       into   p_application_id
       from   fnd_application a
       where  a.application_short_name = p_application_short_name;

Line: 157


      if (p_last_update_date is null) then
           l_last_update_date := sysdate;

Line: 160


           l_last_update_date := to_date(p_last_update_date, 'YYYY/MM/DD');

Line: 168


	l_uwq_maction_defs_rec.multi_select_flag := p_MULTI_SELECT_FLAG;

Line: 173


    	l_uwq_maction_defs_rec.last_update_date := l_last_update_date;

Line: 174


     	l_uwq_maction_defs_rec.last_updated_by := user_id;

Line: 175


     	l_uwq_maction_defs_rec.last_update_login := 0;

Line: 177


       Update_Row (p_uwq_maction_defs_rec => l_uwq_maction_defs_rec);

Line: 186


	l_uwq_maction_defs_rec.multi_select_flag := p_MULTI_SELECT_FLAG;

Line: 191


     	l_uwq_maction_defs_rec.last_update_date := l_last_update_date;

Line: 192


    	l_uwq_maction_defs_rec.last_updated_by := user_id;

Line: 193


     	l_uwq_maction_defs_rec.last_update_login := 0;

Line: 197


        Insert_Row (p_uwq_maction_defs_rec => l_uwq_maction_defs_rec);

Line: 206


    p_last_update_date IN VARCHAR2,
    p_owner IN VARCHAR2) IS
  user_id		     number := 0;

Line: 215


      UPDATE ieu_uwq_maction_defs_tl SET
	action_user_label = p_action_user_label,
      source_lang = userenv('LANG'),
	action_description = p_action_description,
      last_update_date = decode(p_last_update_date, null, sysdate, to_date(p_last_update_date, 'YYYY/MM/DD')),
      --last_updated_by = decode(p_owner, 'SEED', -1, 0),
      last_updated_by = user_id,
      last_update_login = 0
      WHERE maction_def_id = p_maction_def_id
      AND   userenv('LANG') IN (language, source_lang);

Line: 230


  delete from IEU_UWQ_MACTION_DEFS_TL T
  where not exists
    (select NULL
    from IEU_UWQ_MACTION_DEFS_B B
    where B.MACTION_DEF_ID = T.MACTION_DEF_ID
    );

Line: 237


  update IEU_UWQ_MACTION_DEFS_TL T set (
      ACTION_USER_LABEL,
      ACTION_DESCRIPTION
    ) = (select
      B.ACTION_USER_LABEL,
      B.ACTION_DESCRIPTION
    from IEU_UWQ_MACTION_DEFS_TL B
    where B.MACTION_DEF_ID = T.MACTION_DEF_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.MACTION_DEF_ID,
      T.LANGUAGE
  ) in (select
      SUBT.MACTION_DEF_ID,
      SUBT.LANGUAGE
    from IEU_UWQ_MACTION_DEFS_TL SUBB, IEU_UWQ_MACTION_DEFS_TL SUBT
    where SUBB.MACTION_DEF_ID = SUBT.MACTION_DEF_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.ACTION_USER_LABEL <> SUBT.ACTION_USER_LABEL
      or SUBB.ACTION_DESCRIPTION <> SUBT.ACTION_DESCRIPTION
      or (SUBB.ACTION_DESCRIPTION is null and SUBT.ACTION_DESCRIPTION is not null)
      or (SUBB.ACTION_DESCRIPTION is not null and SUBT.ACTION_DESCRIPTION is null)
  ));

Line: 261


  insert into IEU_UWQ_MACTION_DEFS_TL (
    ACTION_DESCRIPTION,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    ACTION_USER_LABEL,
    MACTION_DEF_ID,
    CREATED_BY,
    object_version_number,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.ACTION_DESCRIPTION,
    B.CREATION_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATE_LOGIN,
    B.ACTION_USER_LABEL,
    B.MACTION_DEF_ID,
    B.CREATED_BY,
    1,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from IEU_UWQ_MACTION_DEFS_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from IEU_UWQ_MACTION_DEFS_TL T
    where T.MACTION_DEF_ID = B.MACTION_DEF_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 307


  cursor c is select
      ACTION_PROC,
      ACTION_PROC_TYPE_CODE,
      MACTION_DEF_TYPE_FLAG,
      APPLICATION_ID,
      GLOBAL_FORM_PARAMS
    from IEU_UWQ_MACTION_DEFS_B
    where MACTION_DEF_ID = X_MACTION_DEF_ID
    for update of MACTION_DEF_ID nowait;

Line: 318


  cursor c1 is select
      ACTION_USER_LABEL,
      ACTION_DESCRIPTION,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from IEU_UWQ_MACTION_DEFS_TL
    where MACTION_DEF_ID = X_MACTION_DEF_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of MACTION_DEF_ID nowait;

Line: 331


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

Line: 366


procedure DELETE_ROW (
  X_MACTION_DEF_ID in NUMBER
) is
begin
  delete from IEU_UWQ_MACTION_DEFS_TL
  where MACTION_DEF_ID = X_MACTION_DEF_ID;

Line: 377


  delete from IEU_UWQ_MACTION_DEFS_B
  where MACTION_DEF_ID = X_MACTION_DEF_ID;

Line: 383


end DELETE_ROW;

Line: 392


  p_MULTI_SELECT_FLAG IN VARCHAR2,
  p_MACTION_DEF_KEY IN VARCHAR2,
  p_last_update_date IN VARCHAR2,
  p_application_short_name IN VARCHAR2,
  p_action_user_label IN VARCHAR2,
  p_action_description IN VARCHAR2,
  p_owner IN VARCHAR2
)is
begin

  if (P_UPLOAD_MODE = 'NLS') then
          TRANSLATE_ROW (
             P_MACTION_DEF_ID,
             P_ACTION_USER_LABEL,
             P_ACTION_DESCRIPTION,
             P_LAST_UPDATE_DATE,
             P_OWNER);

Line: 417


                   P_MULTI_SELECT_FLAG,
                   p_MACTION_DEF_KEY,
                   P_LAST_UPDATE_DATE,
                   P_APPLICATION_SHORT_NAME,
                   P_ACTION_USER_LABEL,
                   P_ACTION_DESCRIPTION,
                   P_OWNER);