APPS.FND_DOCUMENTS_PKG dependencies on FND_DOCUMENTS_SHORT_TEXT

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 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 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);