1 PACKAGE CSM_ACCESS_PURGE_PKG AUTHID CURRENT_USER AS
2 /* $Header: csmeacps.pls 120.0.12010000.1 2008/07/28 16:12:47 appldev ship $ */
3
4 --
5 -- Purpose: Encapsulate various operations on counter.
6 -- Methods willbe called by workflow engine
7 -- MODIFICATION HISTORY
8 -- Person Date Comments
9 -- TRAJASEK 28MAY07 Initial Revision
10 -----------------------------------------------------------
11
12 /****
13 Procedure that deletes all acc records for an acc table for a resource
14 ****/
15
16 PROCEDURE DELETE_ACC_FOR_USER( p_acc_table_name IN VARCHAR2
17 , p_user_id IN NUMBER
18 );
19
20 PROCEDURE DELETE_ACC_FOR_RESOURCE( p_acc_table_name IN VARCHAR2
21 , p_resource_id IN NUMBER
22 );
23
24 PROCEDURE PURGE_INVALID_ACC_DATA(p_status OUT NOCOPY VARCHAR2,
25 p_message OUT NOCOPY VARCHAR2);
26
27 END CSM_ACCESS_PURGE_PKG; -- Package spec of CSM_ACCESS_PURGE_PKG