1 package ALR_MLR_PACKAGE AUTHID CURRENT_USER as
2 /* $Header: alrwfmlrs.pls 120.0 2006/08/02 22:09:28 jwsmith noship $ */
3
4 ALR_EMAIL_TABLE WF_MAIL.wf_recipient_list_t;
5
6 type ALR_MSG_DTLS_REC is record
7 (
8 app_id number,
9 alert_id number,
10 response_set_id number,
11 open_closed varchar2(1)
12 );
13
14 TYPE alr_msg_dtls_tbl_type is table of ALR_MSG_DTLS_REC
15 index by binary_integer;
16
17 type ALR_INIT_RESP_REC is record
18 (
19 var_num number,
20 name varchar2(30),
21 data_type varchar2(1),
22 default_value varchar2(240),
23 max_len number
24 );
25
26 TYPE alr_init_resp_tbl_type is table of ALR_INIT_RESP_REC
27 index by binary_integer;
28
29 type ALR_INIT_VALID_RESP_REC is record
30 (
31 resp_id number,
32 resp_type varchar2(1),
33 resp_text long,
34 resp_name varchar2(240)
35 );
36
37 TYPE alr_init_valid_resp_tbl_type is table of ALR_INIT_VALID_RESP_REC
38 index by binary_integer;
39
40 type ALR_GET_RESP_ACT_REC is record
41 (
42 response_id number,
43 action_id number,
44 action_name varchar2(80),
45 action_type varchar2(1),
46 action_body varchar2(2000),
47 conc_pgm_id number,
48 to_recip varchar2(240),
49 cc_recip varchar2(240),
50 bcc_recip varchar2(240),
51 print_recip varchar2(240),
52 printer varchar2(30),
53 subject varchar2(240),
54 reply_to varchar2(240),
55 column_wrap_flag varchar2(1),
56 max_sum_msg_width number,
57 action_level_type varchar2(1),
58 action_level varchar2(1),
59 file_name varchar2(240),
60 arg_string varchar2(240),
61 pgm_app_id number,
62 list_app_id number,
63 act_resp_set_id number,
64 follow_up_after_days number,
65 version_num number
66 );
67
68 TYPE alr_get_resp_act_tbl_type is table of ALR_GET_RESP_ACT_REC
69 index by binary_integer;
70
71 TYPE alr_match_resp_act_tbl_type is table of ALR_GET_RESP_ACT_REC
72 index by binary_integer;
73
74 TYPE ALR_RESP_VAR_VALUES_REC is record
75 (
76 variable_name varchar2(30),
77 value varchar2(240),
78 data_type varchar2(1),
79 detail_max_len number
80 );
81 TYPE alr_resp_var_values_tbl_type is table of ALR_RESP_VAR_VALUES_REC
82 index by binary_integer;
83
84 --
85 -- Generic mailer routines
86 --
87 -- Send
88 -- Sends a e-mail notification to the specified list of recipients.
89 -- This API unlike wf_notification.send does not require workflow
90 -- message or workflow roles to send a notification.
91
92 procedure Send(a_idstring in varchar2,
93 a_module in varchar2,
94 a_replyto in varchar2 default null,
95 a_subject in varchar2,
96 a_message in varchar2);
97
98 procedure Send2(a_idstring in varchar2,
99 a_module in varchar2,
100 a_replyto in varchar2 default null,
101 a_subject in varchar2,
102 a_chunk1 in varchar2,
103 a_chunk2 in varchar2);
104
105 procedure InitRecipientList;
106
107 procedure AddRecipientToList(p_name in varchar2,
108 p_value in varchar2,
109 p_recipient_type in varchar2);
110
111 function Response(p_subscription_guid in raw,
112 p_event in out NOCOPY WF_EVENT_T) return varchar2;
113
114 function OpenResponses return number;
115
116 procedure GetMessageDetails(msg_handle in number,
117 node_handle in number,
118 alr_msg_dtls_tbl out NOCOPY alr_msg_dtls_tbl_type);
119
120 procedure InitResponseVar(alr_msg_dtls_tbl in alr_msg_dtls_tbl_type,
121 alr_init_resp_tbl out NOCOPY alr_init_resp_tbl_type);
122
123 procedure InitValidResponses(alr_msg_dtls_tbl in alr_msg_dtls_tbl_type,
124 alr_init_valid_resp_tbl out NOCOPY
125 alr_init_valid_resp_tbl_type);
126
127 procedure GetRespActions(alr_msg_dtls_tbl in alr_msg_dtls_tbl_type,
128 alr_init_valid_resp_tbl in
129 alr_init_valid_resp_tbl_type,
130 alr_get_resp_act_tbl out NOCOPY
131 alr_get_resp_act_tbl_type);
132
133 procedure GetOutputValues(msg_handle in number, node_handle in number,
134 alr_resp_var_values_tbl out NOCOPY
135 alr_resp_var_values_tbl_type);
136
137 procedure SaveRespHistory(msg_handle in number,
138 node_handle in number,
139 alr_msg_dtls_tbl in alr_msg_dtls_tbl_type,
140 l_from in varchar2,
141 p_response_body in varchar2,
142 p_resp_id in number);
143
144 procedure SaveRespVar(alr_msg_dtls_tbl in alr_msg_dtls_tbl_type,
145 msg_handle in number,
146 node_handle in number,
147 alr_init_resp_tbl in
148 alr_init_resp_tbl_type);
149
150 procedure SaveOneRespVar(alr_msg_dtls_tbl in alr_msg_dtls_tbl_type,
151 msg_handle in number,
152 node_handle in number,
153 variable_name in varchar2,
154 value in varchar2,
155 alr_init_resp_tbl in
156 alr_init_resp_tbl_type);
157
158 procedure SaveRespActHistory(msg_handle in number,
159 node_handle in number,
160 response_msg_id in number,
161 oracle_id in number,
162 seq in number,
163 alr_msg_dtls_tbl in
164 alr_msg_dtls_tbl_type,
165 alr_get_resp_act_tbl in
166 alr_get_resp_act_tbl_type,
167 version_num in number,
168 success_flag in varchar2);
169
170 procedure CloseResp(msg_handle in number,
171 node_handle in number,
172 alr_init_valid_resp_tbl in
173 alr_init_valid_resp_tbl_type,
174 open_closed in varchar2,
175 action_set_pass_fail in varchar2);
176
177 procedure test;
178
179 end ALR_MLR_PACKAGE;