APPS.DOM_DOC_TEXT_UTIL dependencies on DOM_DOCUMENTS_IMTEXT_TL

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 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 ,