APPS.FND_DOCUMENTS_PKG dependencies on FND_DOCUMENTS_TL

Line 234: INSERT INTO fnd_Documents_tl (

230: IS
231: BEGIN
232:
233: -- insert into "language" specific table
234: INSERT INTO fnd_Documents_tl (
235: document_id,
236: creation_date,
237: created_by,
238: last_update_date,

Line 298: FROM fnd_documents_tl TL

294: X_title
295: FROM fnd_languages L
296: WHERE l.installed_flag IN ('I','B')
297: AND NOT EXISTS (SELECT null
298: FROM fnd_documents_tl TL
299: WHERE document_id = x_document_id
300: AND TL.language = l.language_code);
301:
302: END Insert_tl_Row;

Line 441: FROM fnd_documents_tl

437: X_title VARCHAR2 DEFAULT NULL
438: ) IS
439: CURSOR C IS
440: SELECT *
441: FROM fnd_documents_tl
442: WHERE document_id = X_document_id
443: AND language = X_language
444: FOR UPDATE of language NOWAIT;
445: Recinfo C%ROWTYPE;

Line 638: UPDATE fnd_documents_tl

634: X_Attribute15 VARCHAR2 DEFAULT NULL,
635: X_title VARCHAR2 DEFAULT NULL
636: ) IS
637: BEGIN
638: UPDATE fnd_documents_tl
639: SET document_id = X_document_id,
640: last_update_date = X_last_update_date,
641: last_updated_by = X_last_updated_by,
642: last_update_login = X_last_update_login,

Line 679: -- 3. fnd_documents_tl

675: -- need to delete in this order for R10-10SC compatibility
676: -- triggers to operate properly
677: -- 1. fnd_attached_documents
678: -- 2. fnd_documents_short_text/long_text/long_raw
679: -- 3. fnd_documents_tl
680: -- 4. fnd_documents
681: -- Delete the Reference if flag set to Y
682: IF (delete_ref_flag = 'Y') THEN
683: DELETE FROM fnd_attached_documents

Line 715: DELETE FROM fnd_documents_tl

711: from fnd_documents
712: WHERE document_id = x_document_id);
713: END IF;
714:
715: DELETE FROM fnd_documents_tl
716: WHERE document_id = X_document_id;
717:
718: DELETE FROM fnd_documents
719: WHERE document_id = X_document_id;

Line 732: delete from FND_DOCUMENTS_TL T

728: /* as a quick workaround to fix the time-consuming table handler issue */
729: /* Eventually we'll need to turn them into a separate fix_language procedure */
730: /*
731:
732: delete from FND_DOCUMENTS_TL T
733: where not exists
734: (select NULL
735: from FND_DOCUMENTS B
736: where B.DOCUMENT_ID = T.DOCUMENT_ID

Line 739: update FND_DOCUMENTS_TL T set (

735: from FND_DOCUMENTS B
736: where B.DOCUMENT_ID = T.DOCUMENT_ID
737: );
738:
739: update FND_DOCUMENTS_TL T set (
740: DESCRIPTION
741: ) = (select
742: B.DESCRIPTION
743: from FND_DOCUMENTS_TL B

Line 743: from FND_DOCUMENTS_TL B

739: update FND_DOCUMENTS_TL T set (
740: DESCRIPTION
741: ) = (select
742: B.DESCRIPTION
743: from FND_DOCUMENTS_TL B
744: where B.DOCUMENT_ID = T.DOCUMENT_ID
745: and B.LANGUAGE = T.SOURCE_LANG)
746: where (
747: T.DOCUMENT_ID,

Line 752: from FND_DOCUMENTS_TL SUBB, FND_DOCUMENTS_TL SUBT

748: T.LANGUAGE
749: ) in (select
750: SUBT.DOCUMENT_ID,
751: SUBT.LANGUAGE
752: from FND_DOCUMENTS_TL SUBB, FND_DOCUMENTS_TL SUBT
753: where SUBB.DOCUMENT_ID = SUBT.DOCUMENT_ID
754: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
755: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
756: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

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

757: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
758: ));
759: */
760:
761: insert /*+ append parallel(tt) */ into FND_DOCUMENTS_TL tt (
762: DOCUMENT_ID,
763: CREATION_DATE,
764: CREATED_BY,
765: LAST_UPDATE_DATE,

Line 826: from FND_DOCUMENTS_TL B, FND_LANGUAGES L

822: B.APP_SOURCE_VERSION,
823: B.SHORT_TEXT,
824: L.LANGUAGE_CODE,
825: B.SOURCE_LANG
826: from FND_DOCUMENTS_TL B, FND_LANGUAGES L
827: where L.INSTALLED_FLAG in ('I', 'B')
828: and B.LANGUAGE = userenv('LANG')
829: ) v, fnd_documents_tl t
830: where T.DOCUMENT_ID(+) = v.DOCUMENT_ID

Line 829: ) v, fnd_documents_tl t

825: B.SOURCE_LANG
826: from FND_DOCUMENTS_TL B, FND_LANGUAGES L
827: where L.INSTALLED_FLAG in ('I', 'B')
828: and B.LANGUAGE = userenv('LANG')
829: ) v, fnd_documents_tl t
830: where T.DOCUMENT_ID(+) = v.DOCUMENT_ID
831: and T.LANGUAGE(+) = v.LANGUAGE_CODE
832: and t.document_id IS NULL;
833: