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

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

Line: 3


procedure INSERT_ROW (
  X_ROWID IN OUT NOCOPY VARCHAR2,
  X_ACTION_PARAM_ID in NUMBER,
  X_ACTION_ID in NUMBER,
  X_ACTION_CODE in VARCHAR2,
  X_ACTION_PARAM_CODE in VARCHAR2,
  X_ENABLED_FLAG in VARCHAR2,
  X_TRACK_FLAG in VARCHAR2,
  X_MANDATORY_FLAG in VARCHAR2,
  X_ENCRYPT_FLAG in VARCHAR2,
  X_LOV in VARCHAR2,
  X_ACTION_PARAM_CODE_MEANING in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_CREATION_DATE in DATE,
  X_CREATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER
)
is
  cursor c is select ROWID from AMS_CLIK_THRU_ACT_PARAMS_B
    where ACTION_PARAM_ID = X_ACTION_PARAM_ID
    ;

Line: 27


  cursor ctl is select ROWID from AMS_CLIK_THRU_ACT_PARAMS_TL
    where ACTION_PARAM_ID = X_ACTION_PARAM_ID
    ;

Line: 32


	insert into AMS_CLIK_THRU_ACT_PARAMS_B (
		ACTION_PARAM_ID
		,ACTION_ID
		,ACTION_CODE
		,ACTION_PARAM_CODE
		,ENABLED_FLAG
		,TRACK_FLAG
		,MANDATORY_FLAG
		,ENCRYPT_FLAG
		,LOV
		,LAST_UPDATE_DATE
		,LAST_UPDATED_BY
		,CREATION_DATE
		,CREATED_BY
		,LAST_UPDATE_LOGIN
		,OBJECT_VERSION_NUMBER
	) values (
		X_ACTION_PARAM_ID
		,X_ACTION_ID
		,X_ACTION_CODE
		,X_ACTION_PARAM_CODE
		,X_ENABLED_FLAG
		,X_TRACK_FLAG
		,X_MANDATORY_FLAG
		,X_ENCRYPT_FLAG
		,X_LOV
		,DECODE(X_LAST_UPDATE_DATE,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,X_LAST_UPDATE_DATE)
		,DECODE(X_LAST_UPDATED_BY,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,X_LAST_UPDATED_BY)
		,DECODE(X_CREATION_DATE,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,X_CREATION_DATE)
		,DECODE(X_CREATED_BY,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,X_CREATED_BY)
		,DECODE(X_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,X_LAST_UPDATE_LOGIN)
		,X_OBJECT_VERSION_NUMBER
	);

Line: 74


	insert into AMS_CLIK_THRU_ACT_PARAMS_TL (
		ACTION_PARAM_ID
		,ACTION_PARAM_CODE_MEANING
		,DESCRIPTION
		,LANGUAGE
		,SOURCE_LANG
		,LAST_UPDATE_DATE
		,LAST_UPDATED_BY
		,CREATION_DATE
		,CREATED_BY
		,LAST_UPDATE_LOGIN
	)
	SELECT
     X_ACTION_PARAM_ID
    ,X_ACTION_PARAM_CODE_MEANING
    ,DECODE(X_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,X_DESCRIPTION)
    ,l.language_code
    ,USERENV('lang')
    ,DECODE(X_LAST_UPDATE_DATE,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,X_LAST_UPDATE_DATE)
    ,DECODE(X_LAST_UPDATED_BY,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,X_LAST_UPDATED_BY)
    ,DECODE(X_CREATION_DATE,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,X_CREATION_DATE)
    ,DECODE(X_CREATED_BY,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,X_CREATED_BY)
    ,DECODE(X_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,X_LAST_UPDATE_LOGIN)
  FROM fnd_languages l
  WHERE l.installed_flag IN ('I', 'B')
  AND NOT EXISTS
    (SELECT NULL
    FROM AMS_CLIK_THRU_ACT_PARAMS_TL T
    WHERE T.ACTION_PARAM_ID = X_ACTION_PARAM_ID
    AND T.LANGUAGE = l.language_code);

Line: 115


end INSERT_ROW;

Line: 131


  cursor c is select
     OBJECT_VERSION_NUMBER
		,ACTION_ID
		,ACTION_CODE
		,ACTION_PARAM_CODE
		,ENABLED_FLAG
		,TRACK_FLAG
		,MANDATORY_FLAG
		,ENCRYPT_FLAG
		,LOV		,LAST_UPDATE_DATE
		,LAST_UPDATED_BY
		,CREATION_DATE
		,CREATED_BY
		,LAST_UPDATE_LOGIN
    from AMS_CLIK_THRU_ACT_PARAMS_B
    where ACTION_PARAM_ID = X_ACTION_PARAM_ID
    for update of ACTION_PARAM_ID nowait;

Line: 150


  CURSOR ctl IS SELECT
      ACTION_PARAM_CODE_MEANING,
      DESCRIPTION,
      DECODE(LANGUAGE, USERENV('lang'), 'y', 'n') baselang
    FROM AMS_CLIK_THRU_ACT_PARAMS_TL
    WHERE ACTION_PARAM_ID = X_ACTION_PARAM_ID
    AND USERENV('lang') IN (LANGUAGE, source_lang)
    FOR UPDATE OF ACTION_PARAM_ID NOWAIT;

Line: 164


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

Line: 213


procedure UPDATE_ROW (
  X_ACTION_PARAM_ID in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_ACTION_ID in NUMBER,
  X_ACTION_CODE in VARCHAR2,
  X_ACTION_PARAM_CODE in VARCHAR2,
  X_ENABLED_FLAG in VARCHAR2,
  X_TRACK_FLAG in VARCHAR2,
  X_MANDATORY_FLAG in VARCHAR2,
  X_ENCRYPT_FLAG in VARCHAR2,
  X_LOV in VARCHAR2,
  X_ACTION_PARAM_CODE_MEANING in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
)
is
begin


  update AMS_CLIK_THRU_ACT_PARAMS_B set
		OBJECT_VERSION_NUMBER	= X_OBJECT_VERSION_NUMBER
		,ACTION_ID					= X_ACTION_ID
		,ACTION_CODE				= X_ACTION_CODE
		,ACTION_PARAM_CODE		= X_ACTION_PARAM_CODE
		,ENABLED_FLAG				= X_ENABLED_FLAG
		,TRACK_FLAG					= X_TRACK_FLAG
		,MANDATORY_FLAG			= X_MANDATORY_FLAG
		,ENCRYPT_FLAG				= X_ENCRYPT_FLAG
		,LOV							= X_LOV
		,LAST_UPDATE_DATE			= X_LAST_UPDATE_DATE
		,LAST_UPDATED_BY			= X_LAST_UPDATED_BY
		,LAST_UPDATE_LOGIN		= X_LAST_UPDATE_LOGIN
  where ACTION_PARAM_ID       = X_ACTION_PARAM_ID
    and ACTION_ID					= X_ACTION_ID;

Line: 254


  update AMS_CLIK_THRU_ACT_PARAMS_TL set
    ACTION_PARAM_CODE_MEANING = X_ACTION_PARAM_CODE_MEANING,
    DESCRIPTION = X_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 ACTION_PARAM_ID = X_ACTION_PARAM_ID
  and USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);

Line: 268


end UPDATE_ROW;

Line: 270


procedure DELETE_ROW (
  X_ACTION_PARAM_ID in NUMBER
)
is
begin
  delete from AMS_CLIK_THRU_ACT_PARAMS_TL
  where ACTION_PARAM_ID = X_ACTION_PARAM_ID;

Line: 282


  delete from AMS_CLIK_THRU_ACT_PARAMS_B
  where ACTION_PARAM_ID = X_ACTION_PARAM_ID;

Line: 291


end DELETE_ROW;

Line: 312


    l_last_updated_by number;

Line: 316


	select OBJECT_VERSION_NUMBER, last_updated_by
	from   AMS_CLIK_THRU_ACT_PARAMS_B
	where  ACTION_PARAM_ID =  X_ACTION_PARAM_ID;

Line: 321


	select 'x'
	from   AMS_CLIK_THRU_ACT_PARAMS_B
	where  ACTION_PARAM_ID =  X_ACTION_PARAM_ID;

Line: 342


	AMS_CLIK_THRU_ACT_PARAM_PKG.INSERT_ROW(
		  X_ROWID								=> l_row_id
		  ,X_ACTION_PARAM_ID					=> X_ACTION_PARAM_ID
		  ,X_ACTION_ID							=> X_ACTION_ID
		  ,X_ACTION_CODE						=> X_ACTION_CODE
		  ,X_ACTION_PARAM_CODE				=> X_ACTION_PARAM_CODE
		  ,X_ENABLED_FLAG						=> X_ENABLED_FLAG
		  ,X_TRACK_FLAG						=> X_TRACK_FLAG
		  ,X_MANDATORY_FLAG					=> X_MANDATORY_FLAG
		  ,X_ENCRYPT_FLAG						=> X_ENCRYPT_FLAG
		  ,X_LOV									=> X_LOV
		  ,X_ACTION_PARAM_CODE_MEANING	=> X_ACTION_PARAM_CODE_MEANING
		  ,X_DESCRIPTION						=> X_DESCRIPTION
		  ,X_LAST_UPDATE_DATE				=> SYSDATE
		  ,X_LAST_UPDATED_BY					=> l_user_id
		  ,X_CREATION_DATE					=> SYSDATE
		  ,X_CREATED_BY						=> l_user_id
		  ,X_LAST_UPDATE_LOGIN				=> 0
		  ,X_OBJECT_VERSION_NUMBER			=> 1
	);

Line: 366


	fetch c_obj_verno into l_obj_verno,l_last_updated_by;

Line: 369


	if (l_last_updated_by in (1,2,0) OR
	       NVL(x_custom_mode,'PRESERVE')='FORCE') THEN

	       AMS_CLIK_THRU_ACT_PARAM_PKG.UPDATE_ROW(
			X_ACTION_PARAM_ID             =>   X_ACTION_PARAM_ID,
			X_ACTION_ID	=>   X_ACTION_ID,
			X_ACTION_CODE	=>	  X_ACTION_CODE,
			X_ACTION_PARAM_CODE=>	  X_ACTION_PARAM_CODE,
			X_ENABLED_FLAG	=>	  X_ENABLED_FLAG,
			X_TRACK_FLAG	=>	  X_TRACK_FLAG,
			X_MANDATORY_FLAG=>	  X_MANDATORY_FLAG,
			X_ENCRYPT_FLAG	=>	  X_ENCRYPT_FLAG,
			X_LOV		=>	  X_LOV,
			X_ACTION_PARAM_CODE_MEANING	=>  X_ACTION_PARAM_CODE_MEANING,
			X_DESCRIPTION	=>	  X_DESCRIPTION,
			X_LAST_UPDATE_DATE =>   SYSDATE,
			X_LAST_UPDATED_BY =>   l_user_id,
			X_LAST_UPDATE_LOGIN =>   0,
			X_OBJECT_VERSION_NUMBER =>   l_obj_verno + 1
		 );

Line: 402


    cursor c_last_updated_by is
	      select last_updated_by
	      FROM AMS_CLIK_THRU_ACT_PARAMS_TL
              where  ACTION_PARAM_ID =  X_ACTION_PARAM_ID
	      and  USERENV('LANG') = LANGUAGE;

Line: 408


    l_last_updated_by number;

Line: 412


  open c_last_updated_by;

Line: 413


  fetch c_last_updated_by into l_last_updated_by;

Line: 414


  close c_last_updated_by;

Line: 416


  if (l_last_updated_by in (1,2,0) OR
	 NVL(x_custom_mode,'PRESERVE')='FORCE') THEN

     -- Only update rows which have not been altered by user
     UPDATE AMS_CLIK_THRU_ACT_PARAMS_TL
     SET description = X_DESCRIPTION,
      action_param_code_meaning = X_ACTION_PARAM_CODE_MEANING,
      source_lang = USERENV('LANG'),
      last_update_date = SYSDATE,
      last_updated_by = DECODE(X_OWNER, 'SEED', 1,
			       'ORACLE',2,
			       'SYSADMIN',0, -1),
      last_update_login = 0
      WHERE ACTION_PARAM_ID = X_ACTION_PARAM_ID
      AND USERENV('LANG') IN (LANGUAGE, source_lang);

Line: 439


  DELETE FROM AMS_CLIK_THRU_ACT_PARAMS_TL T
  WHERE NOT EXISTS
    (SELECT NULL
     FROM AMS_CLIK_THRU_ACT_PARAMS_B B
     WHERE B.ACTION_PARAM_ID = T.ACTION_PARAM_ID
    );

Line: 446


  UPDATE AMS_CLIK_THRU_ACT_PARAMS_TL T SET (
      ACTION_PARAM_CODE_MEANING,
      DESCRIPTION
    ) =
	 (SELECT
      T1.ACTION_PARAM_CODE_MEANING,
      T1.DESCRIPTION
    FROM AMS_CLIK_THRU_ACT_PARAMS_TL T1
    WHERE T1.ACTION_PARAM_ID = T.ACTION_PARAM_ID
    AND T1.LANGUAGE = T.SOURCE_LANG)
  WHERE (
      T.ACTION_PARAM_ID,
      T.LANGUAGE
   ) IN
   (SELECT
      subt.ACTION_PARAM_ID,
      subt.LANGUAGE
    FROM AMS_CLIK_THRU_ACT_PARAMS_TL subb, AMS_CLIK_THRU_ACT_PARAMS_TL subt
    WHERE subb.ACTION_PARAM_ID = subt.ACTION_PARAM_ID
    AND subb.LANGUAGE = subt.SOURCE_LANG
    AND (subb.ACTION_PARAM_CODE_MEANING <> subt.ACTION_PARAM_CODE_MEANING
      OR subb.DESCRIPTION <> subt.DESCRIPTION
      OR (subb.DESCRIPTION IS NULL AND subt.DESCRIPTION IS NOT NULL)
      OR (subb.DESCRIPTION IS NOT NULL AND subt.DESCRIPTION IS NULL)
  ));

Line: 472


  INSERT INTO AMS_CLIK_THRU_ACT_PARAMS_TL (
    action_param_id,
    action_param_code_meaning,
    description,
    created_by,
    creation_date,
    last_updated_by,
    last_update_date,
    last_update_login,
    LANGUAGE,
    source_lang
  ) SELECT /*+ ordered */
    b.action_param_id,
    b.action_param_code_meaning,
    b.description,
    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 AMS_CLIK_THRU_ACT_PARAMS_TL b, fnd_languages l
  WHERE l.installed_flag IN ('I', 'B')
  AND b.LANGUAGE = USERENV('lang')
  AND NOT EXISTS
    (SELECT NULL
    FROM AMS_CLIK_THRU_ACT_PARAMS_TL T
    WHERE T.action_param_id = b.action_param_id
    AND T.LANGUAGE = l.language_code);