APPS.GMD_LCF_ENGINE dependencies on FND_LOBS

Line 24: -- This procedure is used to insert the clob as a blob into FND_LOBS

20: -- PROCEDURE:
21: -- insert_clob
22: --
23: -- DESCRIPTION:
24: -- This procedure is used to insert the clob as a blob into FND_LOBS
25: --
26: -- PARAMETERS:
27: --
28: -- HISTORY

Line 47: DELETE FROM FND_LOBS WHERE FILE_ID = l_spec_id;

43: l_src_offset := 1;
44: l_lang_context := 0;
45:
46: l_spec_id := -1 * p_spec_id;
47: DELETE FROM FND_LOBS WHERE FILE_ID = l_spec_id;
48:
49: INSERT INTO FND_LOBS (FILE_ID, FILE_NAME, FILE_CONTENT_TYPE,
50: FILE_DATA, LANGUAGE, ORACLE_CHARSET, FILE_FORMAT)
51: VALUES (l_spec_id, 'lcf.sql', 'text/plain', EMPTY_BLOB(), USERENV('LANG'), 'UTF8', 'text');

Line 49: INSERT INTO FND_LOBS (FILE_ID, FILE_NAME, FILE_CONTENT_TYPE,

45:
46: l_spec_id := -1 * p_spec_id;
47: DELETE FROM FND_LOBS WHERE FILE_ID = l_spec_id;
48:
49: INSERT INTO FND_LOBS (FILE_ID, FILE_NAME, FILE_CONTENT_TYPE,
50: FILE_DATA, LANGUAGE, ORACLE_CHARSET, FILE_FORMAT)
51: VALUES (l_spec_id, 'lcf.sql', 'text/plain', EMPTY_BLOB(), USERENV('LANG'), 'UTF8', 'text');
52:
53: SELECT file_data INTO l_blob

Line 54: FROM fnd_lobs

50: FILE_DATA, LANGUAGE, ORACLE_CHARSET, FILE_FORMAT)
51: VALUES (l_spec_id, 'lcf.sql', 'text/plain', EMPTY_BLOB(), USERENV('LANG'), 'UTF8', 'text');
52:
53: SELECT file_data INTO l_blob
54: FROM fnd_lobs
55: WHERE file_id = l_spec_id
56: FOR UPDATE NOWAIT;
57:
58: dbms_lob.convertToBlob(dest_lob => l_blob,