1 PACKAGE CSI_HANDLE_EVENT_PKG AUTHID CURRENT_USER AS
2 /* $Header: csitbess.pls 120.1 2007/10/21 06:31:45 fli noship $ */
3
4 FUNCTION exist_subscription(p_event_name IN VARCHAR2) RETURN VARCHAR2;
5 -----------------------------------------------------------------------
6 -- Return 'Y' if there are some active subscription for the given event
7 -- Otherwise it returns 'N'
8 -----------------------------------------------------------------------
9
10 FUNCTION item_key(p_event_name IN VARCHAR2) RETURN VARCHAR2;
11 -----------------------------------------------------
12 -- Return Item_Key according to CSI Event to be raised
13 -- Item_Key is <Event_Name>-CSI_WF_ITEM_KEY_NUMBER_S.nextval
14 -----------------------------------------------------
15
16 FUNCTION event(p_event_name IN VARCHAR2) RETURN VARCHAR2;
17 -----------------------------------------------
18 -- Return event name if the entered event exist
19 -- Otherwise return NOTFOUND
20 -----------------------------------------------
21
22 PROCEDURE raise_event
23 ----------------------------------------------
24 -- Check if Event exist
25 -- Check if Event is like 'oracle.apps.csi%'
26 -- Get the item_key
27 -- Raise event
28 ----------------------------------------------
29 (p_api_version IN NUMBER
30 ,p_commit IN VARCHAR2
31 ,p_init_msg_list IN VARCHAR2
32 ,p_validation_level IN NUMBER
33 ,p_event_name IN VARCHAR2
34 ,p_event_key IN VARCHAR2
35 ,p_instance_id IN NUMBER
36 ,p_subject_instance_Id IN NUMBER
37 ,p_correlation_value IN VARCHAR2);
38
39 END;