eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_DOCUMENTS_PKG dependencies on FND_DOCUMENTS

Line 1: PACKAGE BODY fnd_documents_pkg as

1: PACKAGE BODY fnd_documents_pkg as
2: /* $Header: AFAKADCB.pls 120.4 2008/02/01 21:04:25 ctilley ship $ */
3:
4:
5:

Line 52: FROM fnd_documents

48: X_url VARCHAR2 DEFAULT NULL,
49: X_title VARCHAR2 DEFAULT NULL
50: ) IS
51: CURSOR C IS SELECT rowid
52: FROM fnd_documents
53: WHERE document_id = X_document_id;
54:
55: l_media_id number;
56: l_longtxt varchar2(32767);

Line 64: SELECT fnd_documents_s.nextval

60:
61: l_media_id := X_media_id;
62:
63: -- Get document_id from sequence
64: SELECT fnd_documents_s.nextval
65: INTO X_document_id
66: FROM dual;
67:
68:

Line 73: SELECT fnd_documents_short_text_s.nextval

69: -- Get media_id from the correct sequence depending on if it's
70: -- a short-text, long-text, ole_object, or db-stored image
71:
72: IF (X_datatype_id = 1) THEN
73: SELECT fnd_documents_short_text_s.nextval
74: INTO X_media_id
75: FROM dual;
76: IF (X_create_doc = 'Y') then
77: insert into fnd_documents_short_text

Line 77: insert into fnd_documents_short_text

73: SELECT fnd_documents_short_text_s.nextval
74: INTO X_media_id
75: FROM dual;
76: IF (X_create_doc = 'Y') then
77: insert into fnd_documents_short_text
78: (media_id, short_text, app_source_version)
79: select X_media_id, short_text, app_source_version
80: from fnd_documents_short_text
81: where media_id = l_media_id;

Line 80: from fnd_documents_short_text

76: IF (X_create_doc = 'Y') then
77: insert into fnd_documents_short_text
78: (media_id, short_text, app_source_version)
79: select X_media_id, short_text, app_source_version
80: from fnd_documents_short_text
81: where media_id = l_media_id;
82:
83: END IF;
84: ELSIF (X_datatype_id = 2) THEN

Line 85: SELECT fnd_documents_long_text_s.nextval

81: where media_id = l_media_id;
82:
83: END IF;
84: ELSIF (X_datatype_id = 2) THEN
85: SELECT fnd_documents_long_text_s.nextval
86: INTO X_media_id
87: FROM dual;
88: IF (X_create_doc = 'Y') then
89: select long_text,app_source_version into l_longtxt,l_app_s_v from fnd_documents_long_text

Line 89: select long_text,app_source_version into l_longtxt,l_app_s_v from fnd_documents_long_text

85: SELECT fnd_documents_long_text_s.nextval
86: INTO X_media_id
87: FROM dual;
88: IF (X_create_doc = 'Y') then
89: select long_text,app_source_version into l_longtxt,l_app_s_v from fnd_documents_long_text
90: where media_id = l_media_id;
91: insert into fnd_documents_long_text
92: (media_id,long_text,app_source_version)
93: values (X_media_id,l_longtxt,l_app_s_v);

Line 91: insert into fnd_documents_long_text

87: FROM dual;
88: IF (X_create_doc = 'Y') then
89: select long_text,app_source_version into l_longtxt,l_app_s_v from fnd_documents_long_text
90: where media_id = l_media_id;
91: insert into fnd_documents_long_text
92: (media_id,long_text,app_source_version)
93: values (X_media_id,l_longtxt,l_app_s_v);
94: END IF;
95: ELSIF ( (X_datatype_id = 4)

Line 98: SELECT fnd_documents_long_raw_s.nextval

94: END IF;
95: ELSIF ( (X_datatype_id = 4)
96: OR ( X_datatype_id = 3
97: AND X_storage_type = 1) ) THEN
98: SELECT fnd_documents_long_raw_s.nextval
99: INTO X_media_id
100: FROM dual;
101: ELSIF (X_datatype_id = 6 and X_media_id is NULL) THEN
102: SELECT fnd_lobs_s.nextval

Line 108: INSERT INTO fnd_documents(

104: FROM dual;
105: END IF;
106:
107: -- First insert row into "base" table
108: INSERT INTO fnd_documents(
109: document_id,
110: creation_date,
111: created_by,
112: last_update_date,

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 341: FROM fnd_documents

337: X_url VARCHAR2 DEFAULT NULL,
338: X_title VARCHAR2 DEFAULT NULL) IS
339: CURSOR C IS
340: SELECT *
341: FROM fnd_documents
342: WHERE document_id = X_document_id
343: FOR UPDATE of document_id NOWAIT;
344: Recinfo C%ROWTYPE;
345: BEGIN

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 560: UPDATE fnd_documents

556: X_url VARCHAR2 DEFAULT NULL,
557: X_title VARCHAR2 DEFAULT NULL
558: ) IS
559: BEGIN
560: UPDATE fnd_documents
561: SET document_id = X_document_id,
562: last_update_date = X_last_update_date,
563: last_updated_by = X_last_updated_by,
564: last_update_login = X_last_update_login,

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 678: -- 2. fnd_documents_short_text/long_text/long_raw

674: BEGIN
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

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 680: -- 4. fnd_documents

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
684: WHERE document_id = X_document_id;

Line 690: DELETE FROM fnd_documents_short_text

686:
687: -- now go about the business of deleting the document from
688: -- the document tables
689: IF (X_datatype_id = 1) THEN
690: DELETE FROM fnd_documents_short_text
691: WHERE media_id IN
692: (SELECT media_id
693: FROM fnd_documents
694: WHERE document_id = x_document_id);

Line 693: FROM fnd_documents

689: IF (X_datatype_id = 1) THEN
690: DELETE FROM fnd_documents_short_text
691: WHERE media_id IN
692: (SELECT media_id
693: FROM fnd_documents
694: WHERE document_id = x_document_id);
695: ELSIF (X_datatype_id = 2) THEN
696: DELETE FROM fnd_documents_long_text
697: WHERE media_id IN

Line 696: DELETE FROM fnd_documents_long_text

692: (SELECT media_id
693: FROM fnd_documents
694: WHERE document_id = x_document_id);
695: ELSIF (X_datatype_id = 2) THEN
696: DELETE FROM fnd_documents_long_text
697: WHERE media_id IN
698: (SELECT media_id
699: FROM fnd_documents
700: WHERE document_id = x_document_id);

Line 699: FROM fnd_documents

695: ELSIF (X_datatype_id = 2) THEN
696: DELETE FROM fnd_documents_long_text
697: WHERE media_id IN
698: (SELECT media_id
699: FROM fnd_documents
700: WHERE document_id = x_document_id);
701: ELSIF (X_datatype_id IN (3,4) ) THEN
702: DELETE FROM fnd_documents_long_raw
703: WHERE media_id IN

Line 702: DELETE FROM fnd_documents_long_raw

698: (SELECT media_id
699: FROM fnd_documents
700: WHERE document_id = x_document_id);
701: ELSIF (X_datatype_id IN (3,4) ) THEN
702: DELETE FROM fnd_documents_long_raw
703: WHERE media_id IN
704: (SELECT media_id
705: FROM fnd_documents
706: WHERE document_id = x_document_id);

Line 705: FROM fnd_documents

701: ELSIF (X_datatype_id IN (3,4) ) THEN
702: DELETE FROM fnd_documents_long_raw
703: WHERE media_id IN
704: (SELECT media_id
705: FROM fnd_documents
706: WHERE document_id = x_document_id);
707: ELSIF (X_datatype_id = 6) THEN
708: DELETE FROM fnd_lobs
709: WHERE file_id in

Line 711: from fnd_documents

707: ELSIF (X_datatype_id = 6) THEN
708: DELETE FROM fnd_lobs
709: WHERE file_id in
710: (SELECT media_id
711: from fnd_documents
712: WHERE document_id = x_document_id);
713: END IF;
714:
715: DELETE FROM fnd_documents_tl

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 718: DELETE FROM fnd_documents

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;
720:
721: END Delete_Row;
722:

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 735: from FND_DOCUMENTS B

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
737: );
738:
739: update FND_DOCUMENTS_TL T set (

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:

Line 836: END fnd_documents_pkg;

832: and t.document_id IS NULL;
833:
834: end ADD_LANGUAGE;
835:
836: END fnd_documents_pkg;