APPS.CSFW_SIGNATURE_PVT dependencies on FND_LOBS_S

Line 70: CURSOR l_fnd_lobs_s_cursor

66: FROM fnd_document_categories_tl
67: WHERE user_name = 'Signature';
68:
69: -- get next sequence value for FND_LOBS
70: CURSOR l_fnd_lobs_s_cursor
71: IS
72: select fnd_lobs_s.nextval
73: from dual;
74:

Line 72: select fnd_lobs_s.nextval

68:
69: -- get next sequence value for FND_LOBS
70: CURSOR l_fnd_lobs_s_cursor
71: IS
72: select fnd_lobs_s.nextval
73: from dual;
74:
75: -- get language of user
76: CURSOR l_language_cursor

Line 111: OPEN l_fnd_lobs_s_cursor;

107: CLOSE l_language_cursor;
108:
109: -- enter data into fnd_lobs
110: BEGIN
111: OPEN l_fnd_lobs_s_cursor;
112: FETCH l_fnd_lobs_s_cursor INTO l_fnd_lobs_id;
113: CLOSE l_fnd_lobs_s_cursor;
114:
115: INSERT INTO fnd_lobs(file_id, file_name, file_content_type, file_data, upload_date, language, file_format)

Line 112: FETCH l_fnd_lobs_s_cursor INTO l_fnd_lobs_id;

108:
109: -- enter data into fnd_lobs
110: BEGIN
111: OPEN l_fnd_lobs_s_cursor;
112: FETCH l_fnd_lobs_s_cursor INTO l_fnd_lobs_id;
113: CLOSE l_fnd_lobs_s_cursor;
114:
115: INSERT INTO fnd_lobs(file_id, file_name, file_content_type, file_data, upload_date, language, file_format)
116: VALUES (l_fnd_lobs_id, 'INTERNAL', 'image/bmp', empty_blob(), SYSDATE, l_language, 'binary')

Line 113: CLOSE l_fnd_lobs_s_cursor;

109: -- enter data into fnd_lobs
110: BEGIN
111: OPEN l_fnd_lobs_s_cursor;
112: FETCH l_fnd_lobs_s_cursor INTO l_fnd_lobs_id;
113: CLOSE l_fnd_lobs_s_cursor;
114:
115: INSERT INTO fnd_lobs(file_id, file_name, file_content_type, file_data, upload_date, language, file_format)
116: VALUES (l_fnd_lobs_id, 'INTERNAL', 'image/bmp', empty_blob(), SYSDATE, l_language, 'binary')
117: RETURN file_data into l_signature_loc;