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