APPS.CSFW_ATTACHMENT_PVT dependencies on FND_LOBS_S

Line 64: CURSOR l_fnd_lobs_s_cursor

60: FROM fnd_document_categories_tl
61: WHERE user_name = p_category_user_name;
62:
63: -- get next sequence value for FND_LOBS
64: CURSOR l_fnd_lobs_s_cursor
65: IS
66: select fnd_lobs_s.nextval
67: from dual;
68:

Line 66: select fnd_lobs_s.nextval

62:
63: -- get next sequence value for FND_LOBS
64: CURSOR l_fnd_lobs_s_cursor
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

Line 113: OPEN l_fnd_lobs_s_cursor;

109:
110: IF (p_datatype_id = 6) THEN
111: BEGIN
112: -- enter data into fnd_lobs
113: OPEN l_fnd_lobs_s_cursor;
114: FETCH l_fnd_lobs_s_cursor INTO l_fnd_lobs_id;
115: CLOSE l_fnd_lobs_s_cursor;
116:
117: INSERT INTO fnd_lobs(file_id, file_name, file_content_type, file_data, upload_date, language, file_format)

Line 114: FETCH l_fnd_lobs_s_cursor INTO l_fnd_lobs_id;

110: IF (p_datatype_id = 6) THEN
111: BEGIN
112: -- enter data into fnd_lobs
113: OPEN l_fnd_lobs_s_cursor;
114: FETCH l_fnd_lobs_s_cursor INTO l_fnd_lobs_id;
115: CLOSE l_fnd_lobs_s_cursor;
116:
117: INSERT INTO fnd_lobs(file_id, file_name, file_content_type, file_data, upload_date, language, file_format)
118: VALUES (l_fnd_lobs_id, p_file_name, p_file_content_type, empty_blob(), SYSDATE, l_language, 'binary')

Line 115: CLOSE l_fnd_lobs_s_cursor;

111: BEGIN
112: -- enter data into fnd_lobs
113: OPEN l_fnd_lobs_s_cursor;
114: FETCH l_fnd_lobs_s_cursor INTO l_fnd_lobs_id;
115: CLOSE l_fnd_lobs_s_cursor;
116:
117: INSERT INTO fnd_lobs(file_id, file_name, file_content_type, file_data, upload_date, language, file_format)
118: VALUES (l_fnd_lobs_id, p_file_name, p_file_content_type, empty_blob(), SYSDATE, l_language, 'binary')
119: RETURN file_data into l_attachment_loc;