APPS.CSFW_ATTACHMENT_PVT dependencies on FND_DOCUMENTS

Line 46: fnd_documents fd

42: CURSOR l_max_seq_no_cursor(x_incident_id IN number)
43: IS
44: SELECT nvl(max(fad.seq_num),0)+10
45: FROM fnd_attached_documents fad,
46: fnd_documents fd
47: WHERE fad.pk1_value = to_char(x_incident_id)
48: AND fd.document_id = fad.document_id
49: AND EXISTS
50: (SELECT 1

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;