APPS.CSFW_SIGNATURE_PVT dependencies on FND_LOBS

Line 44: l_fnd_lobs_id number;

40: l_seq_num number;
41: l_category_id number;
42: l_msg_count NUMBER;
43: l_msg_data VARCHAR2(240);
44: l_fnd_lobs_id number;
45: l_language VARCHAR2(4);
46: l_error_msg varchar(1024);
47:
48: l_signature_loc blob;

Line 75: -- get next sequence value for FND_LOBS

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

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

84: select userenv('LANG')
85: from dual;
86:
87: --to check if the record exists in the database
88: cursor l_lobs_fileid_csr (p_file_id fnd_lobs.file_id%TYPE) is
89: select 1
90: from fnd_lobs
91: where file_id = p_file_id;
92:

Line 90: from fnd_lobs

86:
87: --to check if the record exists in the database
88: cursor l_lobs_fileid_csr (p_file_id fnd_lobs.file_id%TYPE) is
89: select 1
90: from fnd_lobs
91: where file_id = p_file_id;
92:
93: RECORD_NOT_INSERTED EXCEPTION;
94: DEBRIEF_ATTACH_FAILED EXCEPTION;

Line 115: -- enter data into fnd_lobs

111: OPEN l_language_cursor;
112: FETCH l_language_cursor INTO l_language;
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;

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')

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

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')
124: RETURN file_data into l_signature_loc;
125:
126: l_signature_size := dbms_lob.getLength(p_file_data);

Line 123: VALUES (l_fnd_lobs_id, p_file_name, p_file_type, empty_blob(), SYSDATE, l_language, 'binary')

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')
124: RETURN file_data into l_signature_loc;
125:
126: l_signature_size := dbms_lob.getLength(p_file_data);
127: dbms_lob.read(p_file_data, l_signature_size, 1, l_signature_raw);

Line 134: open l_lobs_fileid_csr(l_fnd_lobs_id) ;

130:
131: EXCEPTION
132: WHEN OTHERS THEN
133: -- check if the record exists
134: open l_lobs_fileid_csr(l_fnd_lobs_id) ;
135: fetch l_lobs_fileid_csr into l_dummy;
136: if l_lobs_fileid_csr%found then
137: --the record exists. Dont show any error.
138: null;

Line 165: media_id => l_fnd_lobs_id,

161: pk2_value => NULL,
162: pk3_value => NULL,
163: pk4_value => NULL,
164: pk5_value => NULL,
165: media_id => l_fnd_lobs_id,
166: user_id => fnd_global.login_id);
167: EXCEPTION
168: WHEN OTHERS THEN
169: raise DEBRIEF_ATTACH_FAILED;

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

176: p_error_msg := 'Record not inserted';
177:
178: WHEN DEBRIEF_ATTACH_FAILED THEN
179: x_return_status := FND_API.G_RET_STS_ERROR;
180: p_error_msg := 'Attachment of BLOB:' || l_fnd_lobs_id || ' to Debrief Header Id:'|| p_debrief_header_id || ' failed';
181:
182: WHEN OTHERS THEN
183:
184: p_error_msg := SQLERRM;