APPS.FND_DOCUMENTS_PKG dependencies on FND_DOCUMENTS_LONG_TEXT

Line 62: l_longtxt fnd_documents_long_text.long_text%TYPE;

58: WHERE document_id = X_document_id;
59:
60: l_media_id number;
61: --l_longtxt varchar2(32767);
62: l_longtxt fnd_documents_long_text.long_text%TYPE;
63: l_app_s_v varchar2(255);
64:
65: BEGIN
66:

Line 91: SELECT fnd_documents_long_text_s.nextval

87: where media_id = l_media_id;
88:
89: END IF;
90: ELSIF (X_datatype_id = 2) THEN
91: SELECT fnd_documents_long_text_s.nextval
92: INTO X_media_id
93: FROM dual;
94: IF (X_create_doc = 'Y') then
95: select long_text,app_source_version into l_longtxt,l_app_s_v from fnd_documents_long_text

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

91: SELECT fnd_documents_long_text_s.nextval
92: INTO X_media_id
93: FROM dual;
94: IF (X_create_doc = 'Y') then
95: select long_text,app_source_version into l_longtxt,l_app_s_v from fnd_documents_long_text
96: where media_id = l_media_id;
97: insert into fnd_documents_long_text
98: (media_id,long_text,app_source_version)
99: values (X_media_id,l_longtxt,l_app_s_v);

Line 97: insert into fnd_documents_long_text

93: FROM dual;
94: IF (X_create_doc = 'Y') then
95: select long_text,app_source_version into l_longtxt,l_app_s_v from fnd_documents_long_text
96: where media_id = l_media_id;
97: insert into fnd_documents_long_text
98: (media_id,long_text,app_source_version)
99: values (X_media_id,l_longtxt,l_app_s_v);
100: END IF;
101: ELSIF ( (X_datatype_id = 4)

Line 724: DELETE FROM fnd_documents_long_text

720: (SELECT media_id
721: FROM fnd_documents
722: WHERE document_id = x_document_id);
723: ELSIF (X_datatype_id = 2) THEN
724: DELETE FROM fnd_documents_long_text
725: WHERE media_id IN
726: (SELECT media_id
727: FROM fnd_documents
728: WHERE document_id = x_document_id);