1 Package CS_SR_CHILD_AUDIT_PKG AUTHID CURRENT_USER AS
2 /* $Header: cssrauds.pls 120.1 2005/10/14 14:36:09 smisra noship $*/
3
4
5 /***************
6 Custom Function corrsponds to the business events published by SR child entities.
7 This custom function will be called from the subscriptions of the update/create/delete events for the
8 following SR child entities.
9 1. SR Tasks
10 2. SR Notes
11 3. SR Solution Links.
12 4. SR Task Assignments
13
14 ***************/
15
16 FUNCTION CS_SR_Audit_ChildEntities
17 (P_subscription_guid IN RAW,
18 P_event IN OUT NOCOPY WF_EVENT_T) RETURN VARCHAR2 ;
19
20
21
22 /***************
23 Procedure to create an audit record in SR audit table when ever a SR or SR child entity is updated.
24 ***************/
25
26 PROCEDURE CS_SR_AUDIT_CHILD
27 (P_incident_id IN NUMBER,
28 P_updated_entity_code IN VARCHAR2 ,
29 p_updated_entity_id IN NUMBER ,
30 p_entity_update_date IN DATE ,
31 p_entity_activity_code IN VARCHAR2 ,
32 p_status_id IN NUMBER DEFAULT NULL,
33 p_old_status_id IN NUMBER DEFAULT NULL,
34 p_closed_date IN DATE DEFAULT NULL,
35 p_old_closed_date IN DATE DEFAULT NULL,
36 p_owner_id IN NUMBER DEFAULT NULL,
37 p_old_owner_id IN NUMBER DEFAULT NULL,
38 p_owner_group_id IN NUMBER DEFAULT NULL,
39 p_old_owner_group_id IN NUMBER DEFAULT NULL,
40 p_resource_type IN VARCHAR2 DEFAULT NULL,
41 p_old_resource_type IN VARCHAR2 DEFAULT NULL,
42 p_owner_status_upd_flag IN VARCHAR2 DEFAULT 'NONE',
43 p_update_program_code IN VARCHAR2 DEFAULT 'NONE',
44 p_user_id IN NUMBER DEFAULT NULL,
45 p_old_inc_responded_by_date IN DATE DEFAULT NULL,
46 p_old_incident_resolved_date IN DATE DEFAULT NULL,
47 x_audit_id OUT NOCOPY NUMBER,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2 );
51
52
53 END CS_SR_CHILD_AUDIT_PKG;