APPS.DOM_DOC_TEXT_UTIL dependencies on DOM_DOCUMENTS

Line 186: FROM DOM_DOCUMENTS

182: -- Gopi select correct data.
183: /*
184: cursor l_line_text(L_CHG_ID NUMBER,L_LANG VARCHAR2) is
185: SELECT NAME , NUMBER, DESCRIPTION
186: FROM DOM_DOCUMENTS
187: WHERE
188: DOCUMENT_NUMBER= l_doc_number;
189:
190:

Line 216: DOM_DOCUMENTS dd,

212: , l_description
213: , l_text
214: , l_language
215: FROM
216: DOM_DOCUMENTS dd,
217: DOM_DOCUMENTS_TL ddt,
218: DOM_DOCUMENTS_IMTEXT_TL ddit
219: WHERE
220: ddit.document_id = ddt.document_id

Line 217: DOM_DOCUMENTS_TL ddt,

213: , l_text
214: , l_language
215: FROM
216: DOM_DOCUMENTS dd,
217: DOM_DOCUMENTS_TL ddt,
218: DOM_DOCUMENTS_IMTEXT_TL ddit
219: WHERE
220: ddit.document_id = ddt.document_id
221: AND ddt.document_id = dd.document_id

Line 218: DOM_DOCUMENTS_IMTEXT_TL ddit

214: , l_language
215: FROM
216: DOM_DOCUMENTS dd,
217: DOM_DOCUMENTS_TL ddt,
218: DOM_DOCUMENTS_IMTEXT_TL ddit
219: WHERE
220: ddit.document_id = ddt.document_id
221: AND ddt.document_id = dd.document_id
222: AND ddt.language = ddit.language

Line 226: DOM_DOCUMENTS dd,

222: AND ddt.language = ddit.language
223: AND ddit.rowid = p_rowid;
224:
225: /*
226: DOM_DOCUMENTS dd,
227: DOM_DOCUMENTS_TL ddt
228: WHERE
229: ddt.rowid = p_rowid;
230: */

Line 227: DOM_DOCUMENTS_TL ddt

223: AND ddit.rowid = p_rowid;
224:
225: /*
226: DOM_DOCUMENTS dd,
227: DOM_DOCUMENTS_TL ddt
228: WHERE
229: ddt.rowid = p_rowid;
230: */
231:

Line 506: FROM DOM_DOCUMENTS_IMTEXT_TL

502: temp VARCHAR2(500);
503: l_text VARCHAR2(1);
504: cursor EEC_REC is
505: SELECT document_id, text
506: FROM DOM_DOCUMENTS_IMTEXT_TL
507: WHERE
508: document_id = p_doc_id;
509: BEGIN
510: OPEN EEC_REC;

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

510: OPEN EEC_REC;
511: LOOP
512: FETCH EEC_REC INTO l_doc_id,l_text;
513: EXIT WHEN EEC_REC%NOTFOUND;
514: UPDATE DOM_DOCUMENTS_IMTEXT_TL SET TEXT = DECODE(l_text,'1','0','1') WHERE document_id = l_doc_id;
515: -- debug ( p_doc_id , 0471 , 'update','updated ' || l_text );
516: END LOOP;
517:
518: IF ( EEC_REC%ROWCOUNT = 0 ) THEN

Line 520: INSERT INTO DOM_DOCUMENTS_IMTEXT_TL

516: END LOOP;
517:
518: IF ( EEC_REC%ROWCOUNT = 0 ) THEN
519: -- debug ( p_doc_id , 0471 , 'create','created ' || l_text );
520: INSERT INTO DOM_DOCUMENTS_IMTEXT_TL
521: (
522: DOCUMENT_ID ,
523: LANGUAGE ,
524: TEXT ,

Line 544: DOM.LAST_UPDATE_LOGIN FROM DOM_DOCUMENTS DOM

540: DOM.CREATED_BY ,
541: DOM.CREATION_DATE ,
542: DOM.LAST_UPDATED_BY ,
543: DOM.LAST_UPDATE_DATE ,
544: DOM.LAST_UPDATE_LOGIN FROM DOM_DOCUMENTS DOM
545: WHERE
546: DOCUMENT_ID = p_doc_id ) DOC, FND_LANGUAGES FLA
547: WHERE FLA.INSTALLED_FLAG IN ('I','B');
548: END IF;