1 PACKAGE CSM_SERVICE_HISTORY_EVENT_PKG AUTHID CURRENT_USER AS
2 /* $Header: csmsrhs.pls 120.3 2008/02/08 06:51:55 anaraman ship $ */
3
4 /*Procedure calculates the x number of history service request for the given sr */
5 PROCEDURE CALCULATE_HISTORY( l_incident_id in number,
6 l_user_id in number);
7
8
9 /*Procedure that loops over the acc table to gather incidents*/
10 PROCEDURE CONCURRENT_HISTORY(p_status OUT NOCOPY VARCHAR2, p_message OUT NOCOPY VARCHAR2);
11
12 PROCEDURE SERVICE_HISTORY_ACC_I(p_parent_incident_id IN NUMBER,
13 p_incident_id IN NUMBER,
14 p_user_id IN NUMBER);
15
16 /*Procedure deletes all history records for a given service request*/
17 PROCEDURE DELETE_HISTORY(p_task_assignment_id IN NUMBER,
18 p_incident_id IN NUMBER,
19 p_user_id IN NUMBER) ;
20
21 PROCEDURE SERVICE_HISTORY_ACC_D(p_parent_incident_id IN NUMBER,
22 p_incident_id IN NUMBER,
23 p_user_id IN NUMBER);
24
25 PROCEDURE PROCESS_OWNER_HISTORY( p_return_status OUT NOCOPY VARCHAR2,p_error_message OUT NOCOPY VARCHAR2
26 );
27
28 END; -- Package spec