APPS.CSFW_SIGNATURE_PVT dependencies on FND_LOBS

Line 38: l_fnd_lobs_id number;

34: l_seq_num number;
35: l_category_id number;
36: l_msg_count NUMBER;
37: l_msg_data VARCHAR2(240);
38: l_fnd_lobs_id number;
39: l_language VARCHAR2(4);
40: l_error_msg varchar(1024);
41:
42: l_signature_loc blob;

Line 69: -- get next sequence value for FND_LOBS

65: SELECT category_id
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;

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 82: cursor l_lobs_fileid_csr (p_file_id fnd_lobs.file_id%TYPE) is

78: select userenv('LANG')
79: from dual;
80:
81: --to check if the record exists in the database
82: cursor l_lobs_fileid_csr (p_file_id fnd_lobs.file_id%TYPE) is
83: select 1
84: from fnd_lobs
85: where file_id = p_file_id;
86:

Line 84: from fnd_lobs

80:
81: --to check if the record exists in the database
82: cursor l_lobs_fileid_csr (p_file_id fnd_lobs.file_id%TYPE) is
83: select 1
84: from fnd_lobs
85: where file_id = p_file_id;
86:
87: RECORD_NOT_INSERTED EXCEPTION;
88: DEBRIEF_ATTACH_FAILED EXCEPTION;

Line 109: -- enter data into fnd_lobs

105: OPEN l_language_cursor;
106: FETCH l_language_cursor INTO l_language;
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;

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;

Line 115: INSERT INTO fnd_lobs(file_id, file_name, file_content_type, file_data, upload_date, language, file_format)

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;
118:
119: l_signature_size := dbms_lob.getLength(p_file_data);

Line 116: VALUES (l_fnd_lobs_id, 'INTERNAL', 'image/bmp', empty_blob(), SYSDATE, l_language, 'binary')

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;
118:
119: l_signature_size := dbms_lob.getLength(p_file_data);
120: dbms_lob.read(p_file_data, l_signature_size, 1, l_signature_raw);

Line 127: open l_lobs_fileid_csr(l_fnd_lobs_id) ;

123:
124: EXCEPTION
125: WHEN OTHERS THEN
126: -- check if the record exists
127: open l_lobs_fileid_csr(l_fnd_lobs_id) ;
128: fetch l_lobs_fileid_csr into l_dummy;
129: if l_lobs_fileid_csr%found then
130: --the record exists. Dont show any error.
131: null;

Line 158: media_id => l_fnd_lobs_id,

154: pk2_value => NULL,
155: pk3_value => NULL,
156: pk4_value => NULL,
157: pk5_value => NULL,
158: media_id => l_fnd_lobs_id,
159: user_id => fnd_global.login_id);
160: EXCEPTION
161: WHEN OTHERS THEN
162: raise DEBRIEF_ATTACH_FAILED;

Line 173: p_error_msg := 'Attachment of BLOB:' || l_fnd_lobs_id || ' to Debrief Header Id:'|| p_debrief_header_id || ' failed';

169: p_error_msg := 'Record not inserted';
170:
171: WHEN DEBRIEF_ATTACH_FAILED THEN
172: x_return_status := FND_API.G_RET_STS_ERROR;
173: p_error_msg := 'Attachment of BLOB:' || l_fnd_lobs_id || ' to Debrief Header Id:'|| p_debrief_header_id || ' failed';
174:
175: WHEN OTHERS THEN
176:
177: p_error_msg := SQLERRM;