DBA Data[Home] [Help]

APPS.BISM_EXPORT_READER dependencies on BISM_EXPORT_READER

Line 1: PACKAGE BODY BISM_EXPORT_READER AS

1: PACKAGE BODY BISM_EXPORT_READER AS
2: /* $Header: bibexpb.pls 120.2 2006/04/03 05:21:58 akbansal noship $ */
3: PROCEDURE delete_objects(a_timeinsecs integer)
4: IS
5: v_secs INTEGER;

Line 40: -- to BISM_EXPORT_READER package can potentially wipe out all objects

36: SELECT to_timestamp(v_temp, 'DD-MON-YY HH24.MI.SS') into v_timestamp from dual;
37: -- delete objects from local cache
38: EXECUTE IMMEDIATE 'delete from bism_export_temp where to_char(time_created, ''DD-MON-YY HH24.MI.SS'') < :1' using v_temp;
39: -- we do not want to delete from actual table because an adversary having access (EXECUTE priv)
40: -- to BISM_EXPORT_READER package can potentially wipe out all objects
41: --
42: -- delete from bism_export where to_char(time_created, 'DD-MON-YY HH24.MI.SS') < v_temp;
43: COMMIT;
44: