APPS.FND_DOCUMENTS_PKG dependencies on FND_DOCUMENTS_TL

Line 252: INSERT INTO fnd_Documents_tl (

248: IS
249: BEGIN
250:
251: -- insert into "language" specific table
252: INSERT INTO fnd_Documents_tl (
253: document_id,
254: creation_date,
255: created_by,
256: last_update_date,

Line 316: FROM fnd_documents_tl TL

312: X_title
313: FROM fnd_languages L
314: WHERE l.installed_flag IN ('I','B')
315: AND NOT EXISTS (SELECT null
316: FROM fnd_documents_tl TL
317: WHERE document_id = x_document_id
318: AND TL.language = l.language_code);
319:
320: END Insert_tl_Row;

Line 459: FROM fnd_documents_tl

455: X_title VARCHAR2 DEFAULT NULL
456: ) IS
457: CURSOR C IS
458: SELECT *
459: FROM fnd_documents_tl
460: WHERE document_id = X_document_id
461: AND language = X_language
462: FOR UPDATE of language NOWAIT;
463: Recinfo C%ROWTYPE;

Line 666: UPDATE fnd_documents_tl

662: X_Attribute15 VARCHAR2 DEFAULT NULL,
663: X_title VARCHAR2 DEFAULT NULL
664: ) IS
665: BEGIN
666: UPDATE fnd_documents_tl
667: SET document_id = X_document_id,
668: last_update_date = X_last_update_date,
669: last_updated_by = X_last_updated_by,
670: last_update_login = X_last_update_login,

Line 707: -- 3. fnd_documents_tl

703: -- need to delete in this order for R10-10SC compatibility
704: -- triggers to operate properly
705: -- 1. fnd_attached_documents
706: -- 2. fnd_documents_short_text/long_text/long_raw
707: -- 3. fnd_documents_tl
708: -- 4. fnd_documents
709: -- Delete the Reference if flag set to Y
710: IF (delete_ref_flag = 'Y') THEN
711: DELETE FROM fnd_attached_documents

Line 743: DELETE FROM fnd_documents_tl

739: from fnd_documents
740: WHERE document_id = x_document_id);
741: END IF;
742:
743: DELETE FROM fnd_documents_tl
744: WHERE document_id = X_document_id;
745:
746: DELETE FROM fnd_documents
747: WHERE document_id = X_document_id;

Line 760: delete from FND_DOCUMENTS_TL T

756: /* as a quick workaround to fix the time-consuming table handler issue */
757: /* Eventually we'll need to turn them into a separate fix_language procedure */
758: /*
759:
760: delete from FND_DOCUMENTS_TL T
761: where not exists
762: (select NULL
763: from FND_DOCUMENTS B
764: where B.DOCUMENT_ID = T.DOCUMENT_ID

Line 767: update FND_DOCUMENTS_TL T set (

763: from FND_DOCUMENTS B
764: where B.DOCUMENT_ID = T.DOCUMENT_ID
765: );
766:
767: update FND_DOCUMENTS_TL T set (
768: DESCRIPTION
769: ) = (select
770: B.DESCRIPTION
771: from FND_DOCUMENTS_TL B

Line 771: from FND_DOCUMENTS_TL B

767: update FND_DOCUMENTS_TL T set (
768: DESCRIPTION
769: ) = (select
770: B.DESCRIPTION
771: from FND_DOCUMENTS_TL B
772: where B.DOCUMENT_ID = T.DOCUMENT_ID
773: and B.LANGUAGE = T.SOURCE_LANG)
774: where (
775: T.DOCUMENT_ID,

Line 780: from FND_DOCUMENTS_TL SUBB, FND_DOCUMENTS_TL SUBT

776: T.LANGUAGE
777: ) in (select
778: SUBT.DOCUMENT_ID,
779: SUBT.LANGUAGE
780: from FND_DOCUMENTS_TL SUBB, FND_DOCUMENTS_TL SUBT
781: where SUBB.DOCUMENT_ID = SUBT.DOCUMENT_ID
782: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
783: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
784: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 789: insert /*+ append parallel(tt) */ into FND_DOCUMENTS_TL tt (

785: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
786: ));
787: */
788:
789: insert /*+ append parallel(tt) */ into FND_DOCUMENTS_TL tt (
790: DOCUMENT_ID,
791: CREATION_DATE,
792: CREATED_BY,
793: LAST_UPDATE_DATE,

Line 854: from FND_DOCUMENTS_TL B, FND_LANGUAGES L

850: B.APP_SOURCE_VERSION,
851: B.SHORT_TEXT,
852: L.LANGUAGE_CODE,
853: B.SOURCE_LANG
854: from FND_DOCUMENTS_TL B, FND_LANGUAGES L
855: where L.INSTALLED_FLAG in ('I', 'B')
856: and B.LANGUAGE = userenv('LANG')
857: ) v, fnd_documents_tl t
858: where T.DOCUMENT_ID(+) = v.DOCUMENT_ID

Line 857: ) v, fnd_documents_tl t

853: B.SOURCE_LANG
854: from FND_DOCUMENTS_TL B, FND_LANGUAGES L
855: where L.INSTALLED_FLAG in ('I', 'B')
856: and B.LANGUAGE = userenv('LANG')
857: ) v, fnd_documents_tl t
858: where T.DOCUMENT_ID(+) = v.DOCUMENT_ID
859: and T.LANGUAGE(+) = v.LANGUAGE_CODE
860: and t.document_id IS NULL;
861: