PACKAGE: APPS.MTH_EVENT_PKG

Source

1 PACKAGE Mth_event_PKG AUTHID CURRENT_USER AS
2 /*$Header: mthevnts.pls 120.4 2011/03/01 09:59:03 pwaghmar noship $ */
3 
4 TYPE ActionHandlerRec IS RECORD (
5      Person_fk_key  MTH_EVENT_ACTION_SETUP.personnel_fk_key%TYPE,
6      email_notification MTH_EVENT_ACTION_SETUP.email_notification%TYPE,
7      mobile_notification MTH_EVENT_ACTION_SETUP.mobile_notification%TYPE,
8  	   Action_type_code MTH_EVENT_ACTION_SETUP.ACTION_TYPE_CODE%TYPE,
9 	   Action_Handler_API VARCHAR2(1024),
10      domain_name MTH_EVENT_ACTION_SETUP.DOMAIN_NAME%TYPE
11 	);
12 
13 TYPE ActionHandlerTableType IS VARRAY(50) OF ActionHandlerRec;
14 
15 TYPE ActionStatusRec IS RECORD (
16     action_type_code MTH_EVENT_ACTIONS.action_type_code%TYPE,
17     notification_id MTH_EVENT_ACTIONS.notification_id%TYPE,
18     notification_content MTH_EVENT_ACTIONS.notification_content%TYPE,
19     action_reference_id MTH_EVENT_ACTIONS.action_reference_id%TYPE,
20     action_status MTH_EVENT_ACTIONS.action_status%TYPE,
21     action_handler_api MTH_EVENT_ACTIONS.action_handler_api%TYPE
22   );
23 
24 TYPE ActionStatusTableType IS VARRAY(50) OF ActionStatusRec;
25 
26 PROCEDURE init_action_handler_rec;
27 PROCEDURE init_action_status_rec;
28 
29 PROCEDURE handle_event(p_equipment_fk_key IN NUMBER,
30                        p_event_type IN VARCHAR2,
31                        p_Shift_workday_fk_key IN NUMBER,
32                        p_Workorder_fk_key IN NUMBER,
33                        p_Reading_time IN DATE,
34                        p_reason_code IN VARCHAR2,
35                        p_equip_status IN NUMBER,
36                        p_event_description IN VARCHAR2);
37 
38 
39 FUNCTION create_mth_event(p_equipment_fk_key IN NUMBER,
40                           p_event_type IN VARCHAR2,
41                           p_Shift_workday_fk_key IN NUMBER,
42                           p_Workorder_fk_key IN NUMBER,
43                           p_Reading_time IN DATE,
44                           p_reason_code IN VARCHAR2,
45                           p_equip_status IN NUMBER,
46                           p_event_description IN VARCHAR2) RETURN NUMBER;
47 
48 
49 PROCEDURE ACTION_HANDLER_LOOKUP (p_equipment_fk_key IN NUMBER,
50                                  p_event_type IN VARCHAR2,
51                                  p_reason_code IN VARCHAR2,
52                                  p_event_actions OUT NOCOPY ActionHandlerTableType);
53 
54 PROCEDURE ACTION_HANDLER_DISPATCHER (p_event_id IN NUMBER,
55                                      p_event_action_rec IN ActionHandlerRec,
56                                      p_action_statuses OUT NOCOPY ActionStatusTableType);
57 
58 PROCEDURE UPDATE_MTH_EVENT_ACTION (p_event_id IN NUMBER,
59                                    p_action_statuses IN ActionStatusTableType) ;
60 
61 PROCEDURE INVOKE_EVENT_NOTIFICATION(p_event_id IN NUMBER,
62                                     p_event_action_rec IN ActionHandlerRec,
63                                     p_action_statuses OUT NOCOPY ActionStatusTableType);
64 
65 FUNCTION SEND_NOTIFICATION(p_send_to varchar2,
66                            p_subject varchar2,
67                            p_text varchar2 ) RETURN VARCHAR2;
68 
69 PROCEDURE INVOKE_EVENT_EAM_WR(p_event_id IN NUMBER,
70                               p_event_action_rec IN ActionHandlerRec,
71                               p_action_statuses OUT NOCOPY ActionStatusTableType);
72 
73 PROCEDURE INVOKE_EVENT_PLSQL_API(p_event_id IN NUMBER,
74                                  p_event_action_rec IN ActionHandlerRec,
75                                  p_action_statuses OUT NOCOPY ActionStatusTableType);
76 
77 PROCEDURE INVOKE_EVENT_BPEL(p_event_id IN NUMBER,
78                             p_event_action_rec IN ActionHandlerRec,
79                             p_action_statuses OUT NOCOPY ActionStatusTableType);
80 
81 FUNCTION invoke_http_request(p_event_id   IN NUMBER,
82                              p_url        IN VARCHAR2,
83                              p_namespace  IN VARCHAR2,
84                              p_action     IN VARCHAR2) RETURN VARCHAR2;
85 
86 END Mth_event_PKG;