APPS.DOM_DOC_TEXT_UTIL SQL Statements

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

Line: 185

   SELECT NAME , NUMBER, DESCRIPTION
   FROM  DOM_DOCUMENTS
   WHERE
   DOCUMENT_NUMBER= l_doc_number;

Line: 192

   SELECT DESCRIPTION FROM  DOM_DOCUMENT_ACTIONS_TL TL ,DOM_DOCUMENT_ACTIONS B
   WHERE
   TL.ACTION_ID = B.ACTION_ID
   AND B.OBJECT_ID1 = L_CHG_ID
   AND B.OBJECT_NAME = 'DOM_DOCUMENT'
   AND TL.LANGUAGE = L_LANG
   AND DESCRIPTION IS NOT NULL;

Line: 206

 SELECT  ddt.NAME , dd.DOC_NUMBER, ddt.DESCRIPTION
      ,  (dd.DOC_NUMBER||' '||ddt.NAME||' '||ddt.DESCRIPTION)
      , ddt.language
      INTO
         l_doc_name
      ,  l_doc_number
      ,  l_description
      ,  l_text
      , l_language
      FROM
    DOM_DOCUMENTS dd,
    DOM_DOCUMENTS_TL ddt,
    DOM_DOCUMENTS_IMTEXT_TL  ddit
      WHERE
    ddit.document_id =  ddt.document_id
    AND ddt.document_id = dd.document_id
    AND ddt.language = ddit.language
    AND ddit.rowid = p_rowid;

Line: 317

   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
   ,  'DOM_DOCUMENT_IMTEXT_TL'
   ,  p_msg_name
   ,  SUBSTRB(p_error_text, 1,240)
   ,  l_sysdate
   ,  1
   ,  l_sysdate
   ,  1
   );

Line: 495

PROCEDURE Insert_Update_Doc
(
   p_doc_id            IN  NUMBER      DEFAULT  FND_API.G_MISS_NUM
)
IS
   l_doc_id		NUMBER;

Line: 505

   SELECT document_id,  text
   FROM DOM_DOCUMENTS_IMTEXT_TL
   WHERE
	document_id = p_doc_id;

Line: 514

	UPDATE DOM_DOCUMENTS_IMTEXT_TL SET TEXT = DECODE(l_text,'1','0','1') WHERE document_id = l_doc_id;

Line: 520

	INSERT INTO DOM_DOCUMENTS_IMTEXT_TL
	(
		DOCUMENT_ID       ,
		LANGUAGE          ,
		TEXT 		  ,
		CREATED_BY        ,
		CREATION_DATE     ,
		LAST_UPDATED_BY   ,
		LAST_UPDATE_DATE  ,
		LAST_UPDATE_LOGIN )
		SELECT DOC.DOCUMENT_ID,
		  FLA.LANGUAGE_CODE,
		  TEXT,
		  DOC.CREATED_BY        ,
		  DOC.CREATION_DATE     ,
		  DOC.LAST_UPDATED_BY   ,
		  DOC.LAST_UPDATE_DATE  ,
		  DOC.LAST_UPDATE_LOGIN
		  FROM
		  (SELECT DOM.DOCUMENT_ID,  1 TEXT,
		  DOM.CREATED_BY        ,
		  DOM.CREATION_DATE     ,
		  DOM.LAST_UPDATED_BY   ,
		  DOM.LAST_UPDATE_DATE  ,
		  DOM.LAST_UPDATE_LOGIN FROM DOM_DOCUMENTS DOM
		  WHERE
			DOCUMENT_ID = p_doc_id ) DOC, FND_LANGUAGES FLA
		  WHERE FLA.INSTALLED_FLAG IN ('I','B');

Line: 556

			DOM_DOC_TEXT_PVT.Log_Line ('DOM_DOC_TEXT_UTIL : Error in Insert_Update_Document');

Line: 559

END Insert_Update_Doc;

Line: 586

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