APPS.FND_DOCUMENTS_PKG dependencies on FND_DOCUMENTS_SHORT_TEXT

Line 79: SELECT fnd_documents_short_text_s.nextval

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

Line 83: insert into fnd_documents_short_text

79: SELECT fnd_documents_short_text_s.nextval
80: INTO X_media_id
81: FROM dual;
82: IF (X_create_doc = 'Y') then
83: insert into fnd_documents_short_text
84: (media_id, short_text, app_source_version)
85: select X_media_id, short_text, app_source_version
86: from fnd_documents_short_text
87: where media_id = l_media_id;

Line 86: from fnd_documents_short_text

82: IF (X_create_doc = 'Y') then
83: insert into fnd_documents_short_text
84: (media_id, short_text, app_source_version)
85: select X_media_id, short_text, app_source_version
86: from fnd_documents_short_text
87: where media_id = l_media_id;
88:
89: END IF;
90: ELSIF (X_datatype_id = 2) THEN

Line 706: -- 2. fnd_documents_short_text/long_text/long_raw

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

Line 718: DELETE FROM fnd_documents_short_text

714:
715: -- now go about the business of deleting the document from
716: -- the document tables
717: IF (X_datatype_id = 1) THEN
718: DELETE FROM fnd_documents_short_text
719: WHERE media_id IN
720: (SELECT media_id
721: FROM fnd_documents
722: WHERE document_id = x_document_id);