DBA Data[Home] [Help]

APPS.BIS_SAVE_REPORT dependencies on FND_LOBS

Line 9: -- from fnd_lobs --

5: ----------------------------------------------------------------------------
6: -- PACKAGE: bis_save_report --
7: -- --
8: -- DESCRIPTION: use this package to save and retrieve html output --
9: -- from fnd_lobs --
10: -- --
11: -- MODIFICATIONS --
12: -- Date User Modification --
13: -- 04/10/2001 aleung Initial creation --

Line 53: from fnd_lobs

49: begin
50:
51: select file_data
52: into loc
53: from fnd_lobs
54: where file_id = initWrite.file_id
55: for update of file_data;
56:
57: length := dbms_lob.getLength(loc);

Line 81: from fnd_lobs

77: --ocs varchar2(30);
78: begin
79: select file_data
80: into loc
81: from fnd_lobs
82: where file_id = appendWrite.file_id
83: for update of file_data;
84:
85: --dbms_lob.writeappend(loc, amount, convert(buffer,ocs));

Line 151: update fnd_lobs

147: ) IS
148: BEGIN
149: -- Expire after n days.
150: IF (p_file_id IS NOT NULL) THEN
151: update fnd_lobs
152: SET expiration_date = SYSDATE + 90
153: WHERE file_id = p_file_id;
154:
155: COMMIT;