APPS.ENG_CHANGE_TEXT_UTIL SQL Statements

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

Line: 186

   SELECT NAME , DESCRIPTION FROM  ENG_CHANGE_LINES_TL TL ,ENG_CHANGE_LINES B
   WHERE
   TL.CHANGE_LINE_ID = B.CHANGE_LINE_ID
   AND B.CHANGE_ID = L_CHG_ID
   AND TL.LANGUAGE = L_LANG;

Line: 193

   SELECT DESCRIPTION FROM  ENG_CHANGE_ACTIONS_TL TL ,ENG_CHANGE_ACTIONS B
   WHERE
   TL.ACTION_ID = B.ACTION_ID
   AND B.OBJECT_ID1 = L_CHG_ID
   AND B.OBJECT_NAME = 'ENG_CHANGE'
   AND TL.LANGUAGE = L_LANG
   AND DESCRIPTION IS NOT NULL;

Line: 206

      SELECT  eec.change_id
      ,  eec.change_notice
      ,   eitl.LANGUAGE
      ,  eec.change_notice||' '||eec.change_name||' '||eec.description || ' ' || eec.resolution
      INTO
         l_change_id
      ,  l_change_notice
      ,  l_language
      ,  l_text
      FROM
         ENG_CHANGE_IMTEXT_TL     eitl
      ,  ENG_ENGINEERING_CHANGES  eec
      WHERE
          eitl.rowid = p_rowid
      and eitl.change_id = eec.change_id
      and eitl.language in(select language_code
      from fnd_languages
      where INSTALLED_FLAG ='B' or INSTALLED_FLAG='I');  -- use fnd_languages

Line: 307

   INSERT INTO mtl_interface_errors
   (
      transaction_id
   ,  unique_id
   ,  organization_id
   ,  table_name
   ,  message_name
   ,  error_message
   ,  creation_date
   ,  created_by
   ,  last_update_date
   ,  last_updated_by
   )
   VALUES
   (
      mtl_system_items_interface_s.NEXTVAL
   ,  p_change_id
   ,  p_org_id
   ,  'ENG_CHANGE_IMTEXT_TL'
   ,  p_msg_name
   ,  SUBSTRB(p_error_text, 1,240)
   ,  l_sysdate
   ,  1
   ,  l_sysdate
   ,  1
   );

Line: 493

PROCEDURE Insert_Update_Change
(
   p_change_id            IN  NUMBER      DEFAULT  FND_API.G_MISS_NUM
)
IS
   l_change_id		NUMBER;

Line: 503

   SELECT change_id,  text
   FROM ENG_CHANGE_IMTEXT_TL
   WHERE
	change_id = p_change_id;

Line: 512

	UPDATE ENG_CHANGE_IMTEXT_TL SET TEXT = DECODE(l_text,'1','0','1') WHERE change_id = l_change_id;

Line: 518

	INSERT INTO ENG_CHANGE_IMTEXT_TL
	(
		CHANGE_ID         ,
		LANGUAGE          ,
		TEXT 		  ,
		CREATED_BY        ,
		CREATION_DATE     ,
		LAST_UPDATED_BY   ,
		LAST_UPDATE_DATE  ,
		LAST_UPDATE_LOGIN )
		SELECT EEC.CHANGE_ID,
		  FLA.LANGUAGE_CODE,
		  TEXT,
		  EEC.CREATED_BY     ,
		  EEC.CREATION_DATE     ,
		  EEC.LAST_UPDATED_BY   ,
		  EEC.LAST_UPDATE_DATE  ,
		  EEC.LAST_UPDATE_LOGIN
		  FROM
		  (SELECT EEC.CHANGE_ID,  1 TEXT,
		  EEC.CREATED_BY     ,
		  EEC.CREATION_DATE     ,
		  EEC.LAST_UPDATED_BY   ,
		  EEC.LAST_UPDATE_DATE  ,
		  EEC.LAST_UPDATE_LOGIN FROM ENG_ENGINEERING_CHANGES EEC
		  WHERE
			CHANGE_ID = p_change_id ) EEC, FND_LANGUAGES FLA
		  WHERE FLA.INSTALLED_FLAG IN ('I','B');

Line: 554

			ENG_CHANGE_TEXT_PVT.Log_Line ('ENG_CHANGE_TEXT_UTIL : Error in Insert_Update_Change');

Line: 557

END Insert_Update_Change;

Line: 582

   SELECT SUBSTR(VALUE,0,1) into l_DB_Numeric_Character
     FROM V$NLS_PARAMETERS
     Where PARAMETER = 'NLS_NUMERIC_CHARACTERS';