1 PACKAGE hz_event_pkg AS
2 /*$Header: ARHEVESS.pls 120.1 2005/06/16 21:11:47 jhuang 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 Hz Event to be raised
13 -- Item_Key is <Event_Name>-hzwfapp_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 AddParamEnvToList
23 ------------------------------------------------------
24 -- Add Application-Context parameter to the enter list
25 ------------------------------------------------------
26 ( x_list IN OUT NOCOPY WF_PARAMETER_LIST_T,
27 p_user_id IN VARCHAR2 DEFAULT NULL,
28 p_resp_id IN VARCHAR2 DEFAULT NULL,
29 p_resp_appl_id IN VARCHAR2 DEFAULT NULL,
30 p_security_group_id IN VARCHAR2 DEFAULT NULL,
31 p_org_id IN VARCHAR2 DEFAULT NULL);
32
33 PROCEDURE raise_event
34 ----------------------------------------------
35 -- Check if Event exist
36 -- Check if Event is like 'oracle.apps.ar.hz%'
37 -- Get the item_key
38 -- Raise event
39 ----------------------------------------------
40 (p_event_name IN VARCHAR2,
41 p_event_key IN VARCHAR2,
42 p_data IN CLOB DEFAULT NULL,
43 p_parameters IN wf_parameter_list_t DEFAULT NULL);
44
45 END;