[Home] [Help]
PACKAGE: APPS.QA_ALERT_PKG
Source
1 PACKAGE qa_alert_pkg AUTHID CURRENT_USER AS
2 /* $Header: qaalrs.pls 115.2 2002/11/27 19:12:36 jezheng ship $ */
3
4
5 --
6 -- Create an Alert Action record. Action ID will be generated from
7 -- alr_actions_s and returned in x_action_id parameter.
8 --
9 -- Output variable: x_return_status will be
10 -- fnd_api.g_ret_sts_success if successful
11 -- fnd_api.g_ret_sts_error if error
12 --
13 PROCEDURE insert_alr_actions(
14 p_application_id NUMBER,
15 p_name VARCHAR2,
16 p_alert_id NUMBER,
17 p_action_type VARCHAR2,
18 p_end_date_active DATE,
19 p_enabled_flag VARCHAR2,
20 p_description VARCHAR2,
21 p_action_level_type VARCHAR2,
22 p_date_last_executed DATE,
23 p_file_name VARCHAR2,
24 p_argument_string VARCHAR2,
25 p_concurrent_program_id NUMBER,
26 p_program_application_id NUMBER,
27 p_list_application_id NUMBER,
28 p_list_id NUMBER,
29 p_to_recipients VARCHAR2,
30 p_cc_recipients VARCHAR2,
31 p_bcc_recipients VARCHAR2,
32 p_print_recipients VARCHAR2,
33 p_printer VARCHAR2,
34 p_subject VARCHAR2,
35 p_reply_to VARCHAR2,
36 p_response_set_id NUMBER,
37 p_follow_up_after_days NUMBER,
38 p_column_wrap_flag VARCHAR2,
39 p_max_summary_message_width NUMBER,
40 p_body VARCHAR2,
41 p_version_Number NUMBER,
42 p_creation_date DATE,
43 p_created_by NUMBER,
44 p_last_update_date DATE,
45 p_last_updated_by NUMBER,
46 p_last_update_login NUMBER,
47 x_action_id OUT NOCOPY NUMBER,
48 x_return_status OUT NOCOPY VARCHAR2
49 );
50
51 --
52 -- Update an Alert Action record. This function can be used to
53 -- update in two different modes. When p_rowid is given, then
54 -- it will be used as the update clause (used in Forms). When
55 -- it is null, then p_application_id + p_alert_id + p_name
56 -- will be used as key.
57 --
58 -- Output variable: x_return_status will be
59 -- fnd_api.g_ret_sts_success if successful
60 -- fnd_api.g_ret_sts_error if record is not found
61 --
62 PROCEDURE update_alr_actions(
63 p_rowid VARCHAR2,
64 p_application_id NUMBER,
65 p_action_id NUMBER,
66 p_name VARCHAR2,
67 p_alert_id NUMBER,
68 p_action_type VARCHAR2,
69 p_end_date_active DATE,
70 p_enabled_flag VARCHAR2,
71 p_description VARCHAR2,
72 p_action_level_type VARCHAR2,
73 p_date_last_executed DATE,
74 p_file_name VARCHAR2,
75 p_argument_string VARCHAR2,
76 p_concurrent_program_id NUMBER,
77 p_program_application_id NUMBER,
78 p_list_application_id NUMBER,
79 p_list_id NUMBER,
80 p_to_recipients VARCHAR2,
81 p_cc_recipients VARCHAR2,
82 p_bcc_recipients VARCHAR2,
83 p_print_recipients VARCHAR2,
84 p_printer VARCHAR2,
85 p_subject VARCHAR2,
86 p_reply_to VARCHAR2,
87 p_response_set_id NUMBER,
88 p_follow_up_after_days NUMBER,
89 p_column_wrap_flag VARCHAR2,
90 p_max_summary_message_width NUMBER,
91 p_body VARCHAR2,
92 p_version_Number NUMBER,
93 p_last_update_date DATE,
94 p_last_updated_by NUMBER,
95 p_last_update_login NUMBER,
96 x_return_status OUT NOCOPY VARCHAR2
97 );
98
99
100 --
101 -- Create an alr_action_sets record.
102 -- Return the created action_set_id and sequence into
103 -- x_action_set_id and x_sequence params.
104 --
105 -- Output variable: x_return_status will be
106 -- fnd_api.g_ret_sts_success if successful
107 -- fnd_api.g_ret_sts_error if not
108 --
109 PROCEDURE insert_alr_action_sets(
110 p_application_id NUMBER,
111 p_alert_id NUMBER,
112 p_name VARCHAR2,
113 p_end_date_active DATE,
114 p_enabled_flag VARCHAR2,
115 p_recipients_view_only_flag VARCHAR2,
116 p_description VARCHAR2,
117 p_suppress_flag VARCHAR2,
118 p_suppress_days NUMBER,
119 p_creation_date DATE,
120 p_created_by NUMBER,
121 p_last_update_date DATE,
122 p_last_updated_by NUMBER,
123 p_last_update_login NUMBER,
124 x_action_set_id OUT NOCOPY NUMBER,
125 x_sequence OUT NOCOPY NUMBER,
126 x_return_status OUT NOCOPY VARCHAR2
127 );
128
129
130 --
131 -- Create an alr_action_set_members record.
132 -- Return the created action_set_member_id and sequence into
133 -- x_action_set_member_id and x_sequence params.
134 --
135 -- Output variable: x_return_status will be
136 -- fnd_api.g_ret_sts_success if successful
137 -- fnd_api.g_ret_sts_error if not
138 --
139 PROCEDURE insert_alr_action_set_members(
140 p_application_id NUMBER,
141 p_action_set_id NUMBER,
142 p_action_id NUMBER,
143 p_action_group_id NUMBER,
144 p_alert_id NUMBER,
145 p_end_date_active DATE,
146 p_enabled_flag VARCHAR2,
147 p_summary_threshold VARCHAR2,
148 p_abort_flag VARCHAR2,
149 p_error_action_sequence NUMBER,
150 p_creation_date DATE,
151 p_created_by NUMBER,
152 p_last_update_date DATE,
153 p_last_updated_by NUMBER,
154 p_last_update_login NUMBER,
155 x_action_set_member_id OUT NOCOPY NUMBER,
156 x_sequence OUT NOCOPY NUMBER,
157 x_return_status OUT NOCOPY VARCHAR2
158 );
159
160
161 --
162 -- Create an alr_action_set_outputs record.
163 --
164 -- Output variable: x_return_status will be
165 -- fnd_api.g_ret_sts_success if successful
166 -- fnd_api.g_ret_sts_error if not
167 --
168 PROCEDURE insert_alr_action_set_outputs(
169 p_application_id NUMBER,
170 p_action_set_id NUMBER,
171 p_alert_id NUMBER,
172 p_creation_date DATE,
173 p_created_by NUMBER,
174 p_last_update_date DATE,
175 p_last_updated_by NUMBER,
176 p_last_update_login NUMBER,
177 x_return_status OUT NOCOPY VARCHAR2
178 );
179
180
181 --
182 -- Create an alr_action_set_inputs record.
183 --
184 -- Output variable: x_return_status will be
185 -- fnd_api.g_ret_sts_success if successful
186 -- fnd_api.g_ret_sts_error if not
187 --
188 PROCEDURE insert_alr_action_set_inputs(
189 p_application_id NUMBER,
190 p_action_set_id NUMBER,
191 p_alert_id NUMBER,
192 p_creation_date DATE,
193 p_created_by NUMBER,
194 p_last_update_date DATE,
195 p_last_updated_by NUMBER,
196 p_last_update_login NUMBER,
197 x_return_status OUT NOCOPY VARCHAR2
198 );
199
200
201 END qa_alert_pkg;