APPS.CSFW_ATTACHMENT_PVT dependencies on FND_DOCUMENTS_SHORT_TEXT

Line 69: -- get next sequence value for fnd_documents_short_text

65: IS
66: select fnd_lobs_s.nextval
67: from dual;
68:
69: -- get next sequence value for fnd_documents_short_text
70: CURSOR fnd_short_text_s_cursor
71: is
72: select fnd_documents_short_text_s.nextval
73: from dual;

Line 72: select fnd_documents_short_text_s.nextval

68:
69: -- get next sequence value for fnd_documents_short_text
70: CURSOR fnd_short_text_s_cursor
71: is
72: select fnd_documents_short_text_s.nextval
73: from dual;
74:
75: -- get language of user
76: CURSOR l_language_cursor

Line 161: -- Enter data into fnd_documents_short_text

157: end if;
158: close l_lobs_fileid_csr;
159: END;
160: ELSIF (p_datatype_id = 1) THEN
161: -- Enter data into fnd_documents_short_text
162: BEGIN
163: OPEN fnd_short_text_s_cursor;
164: FETCH fnd_short_text_s_cursor INTO l_fnd_text_id;
165: CLOSE fnd_short_text_s_cursor;

Line 167: INSERT INTO fnd_documents_short_text(media_id, short_text)

163: OPEN fnd_short_text_s_cursor;
164: FETCH fnd_short_text_s_cursor INTO l_fnd_text_id;
165: CLOSE fnd_short_text_s_cursor;
166:
167: INSERT INTO fnd_documents_short_text(media_id, short_text)
168: VALUES (l_fnd_text_id, p_text)
169: RETURN short_text into l_attachment_text;
170:
171: END;