APPS.CSFW_SIGNATURE_PVT dependencies on FND_LOBS_S

Line 76: CURSOR l_fnd_lobs_s_cursor

72: FROM fnd_document_categories_tl
73: WHERE user_name = 'Signature';
74:
75: -- get next sequence value for FND_LOBS
76: CURSOR l_fnd_lobs_s_cursor
77: IS
78: select fnd_lobs_s.nextval
79: from dual;
80:

Line 78: select fnd_lobs_s.nextval

74:
75: -- get next sequence value for FND_LOBS
76: CURSOR l_fnd_lobs_s_cursor
77: IS
78: select fnd_lobs_s.nextval
79: from dual;
80:
81: -- get language of user
82: CURSOR l_language_cursor

Line 117: OPEN l_fnd_lobs_s_cursor;

113: CLOSE l_language_cursor;
114:
115: -- enter data into fnd_lobs
116: BEGIN
117: OPEN l_fnd_lobs_s_cursor;
118: FETCH l_fnd_lobs_s_cursor INTO l_fnd_lobs_id;
119: CLOSE l_fnd_lobs_s_cursor;
120:
121: --13411903

Line 118: FETCH l_fnd_lobs_s_cursor INTO l_fnd_lobs_id;

114:
115: -- enter data into fnd_lobs
116: BEGIN
117: OPEN l_fnd_lobs_s_cursor;
118: FETCH l_fnd_lobs_s_cursor INTO l_fnd_lobs_id;
119: CLOSE l_fnd_lobs_s_cursor;
120:
121: --13411903
122: INSERT INTO fnd_lobs(file_id, file_name, file_content_type, file_data, upload_date, language, file_format)

Line 119: CLOSE l_fnd_lobs_s_cursor;

115: -- enter data into fnd_lobs
116: BEGIN
117: OPEN l_fnd_lobs_s_cursor;
118: FETCH l_fnd_lobs_s_cursor INTO l_fnd_lobs_id;
119: CLOSE l_fnd_lobs_s_cursor;
120:
121: --13411903
122: INSERT INTO fnd_lobs(file_id, file_name, file_content_type, file_data, upload_date, language, file_format)
123: VALUES (l_fnd_lobs_id, p_file_name, p_file_type, empty_blob(), SYSDATE, l_language, 'binary')