1 PACKAGE CSL_SERVICE_HISTORY_PKG AS
2 /* $Header: cslsrhis.pls 120.0 2005/05/25 11:01:30 appldev noship $ */
3
4 /*Function returns the history count allowed for a resource*/
5 FUNCTION GET_HISTORY_COUNT( p_resource_id IN NUMBER ) RETURN NUMBER;
6
7 /*Procedure calculates the x number of history service request for the given sr */
8 PROCEDURE CALCULATE_HISTORY( p_incident_id IN NUMBER
9 , p_resource_id IN NUMBER );
10
11 /*Procedure deletes all history records for a given service request*/
12 PROCEDURE DELETE_HISTORY( p_incident_id IN NUMBER
13 , p_resource_id IN NUMBER );
14
15 /*Procedure that loops over the acc table to gather incidents*/
16 PROCEDURE CONCURRENT_HISTORY;
17
18 END CSL_SERVICE_HISTORY_PKG;