[Home] [Help]
PACKAGE: APPS.AMS_CAMPAIGN_SCHEDULES_B_PKG
Source
1 PACKAGE AMS_CAMPAIGN_SCHEDULES_B_PKG AS
2 /* $Header: amstschs.pls 120.3 2006/05/31 11:55:41 srivikri ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_CAMPAIGN_SCHEDULES_B_PKG
7 -- Purpose
8 -- Table api to create/insert/update campaign Schedules.
9 -- History
10 -- 22-Jan-2000 ptendulk Created.
11 -- 24-sep-2001 soagrawa Removed security group id from everywhere
12 -- 12-jun-2002 soagrawa Added add_language for bug# 2323843 for mainline
13 -- 27-jun-2003 anchaudh Added four more columns(trig_repeat_flag,trgp_exclude_prev,orig_csch_id,cover_letter_version) to be inserted and updated into the table.
14 -- 12-aug-2003 dbiswas Added 3 new columns(usage,purpose,last_activation_date) to be inserted and updated into the table.
15 -- 25-aug-2003 dbiswas Added 1 new columns(sales_methodology_id) to be inserted and updated into the table.
16 -- 27-jul-2005 dbiswas Added 1 new columns(notify_on_activation_flag) to be inserted and updated into the table.
17 -- 29-May-2006 srivikri Added new column - Delivery Mode
18 -- NOTE
19 --
20 -- End of Comments
21 -- ===============================================================
22
23
24 -- ===============================================================
25 -- Start of Comments
26 -- Procedure name
27 -- Insert_Row
28 -- Purpose
29 -- Table api to insert campaign Schedules.
30 -- History
31 -- 22-Jan-2000 ptendulk Created.
32 -- NOTE
33 --
34 -- End of Comments
35 -- ===============================================================
36 PROCEDURE Insert_Row(
37 px_schedule_id IN OUT NOCOPY NUMBER,
38 p_last_update_date DATE,
39 p_last_updated_by NUMBER,
40 p_creation_date DATE,
41 p_created_by NUMBER,
42 p_last_update_login NUMBER,
43 px_object_version_number IN OUT NOCOPY NUMBER,
44 p_campaign_id NUMBER,
45 p_user_status_id NUMBER,
46 p_status_code VARCHAR2,
47 p_status_date DATE,
48 p_source_code VARCHAR2,
49 p_use_parent_code_flag VARCHAR2,
50 p_start_date_time DATE,
51 p_end_date_time DATE,
52 p_timezone_id NUMBER,
53 p_activity_type_code VARCHAR2,
54 p_activity_id NUMBER,
55 p_arc_marketing_medium_from VARCHAR2,
56 p_marketing_medium_id NUMBER,
57 p_custom_setup_id NUMBER,
58 p_triggerable_flag VARCHAR2,
59 p_trigger_id NUMBER,
60 p_notify_user_id NUMBER,
61 p_approver_user_id NUMBER,
62 p_owner_user_id NUMBER,
63 p_active_flag VARCHAR2,
64 p_cover_letter_id NUMBER,
65 p_reply_to_mail VARCHAR2,
66 p_mail_sender_name VARCHAR2,
67 p_mail_subject VARCHAR2,
68 p_from_fax_no VARCHAR2,
69 p_accounts_closed_flag VARCHAR2,
70 px_org_id IN OUT NOCOPY NUMBER,
71 p_objective_code VARCHAR2,
72 p_country_id NUMBER,
73 p_campaign_calendar VARCHAR2,
74 p_start_period_name VARCHAR2,
75 p_end_period_name VARCHAR2,
76 p_priority VARCHAR2,
77 p_workflow_item_key VARCHAR2,
78 p_transaction_currency_code VARCHAR2,
79 p_functional_currency_code VARCHAR2,
80 p_budget_amount_tc NUMBER,
81 p_budget_amount_fc NUMBER,
82 p_language_code VARCHAR2,
83 p_task_id NUMBER,
84 p_related_event_from VARCHAR2,
85 p_related_event_id NUMBER,
86 p_attribute_category VARCHAR2,
87 p_attribute1 VARCHAR2,
88 p_attribute2 VARCHAR2,
89 p_attribute3 VARCHAR2,
90 p_attribute4 VARCHAR2,
91 p_attribute5 VARCHAR2,
92 p_attribute6 VARCHAR2,
93 p_attribute7 VARCHAR2,
94 p_attribute8 VARCHAR2,
95 p_attribute9 VARCHAR2,
96 p_attribute10 VARCHAR2,
97 p_attribute11 VARCHAR2,
98 p_attribute12 VARCHAR2,
99 p_attribute13 VARCHAR2,
100 p_attribute14 VARCHAR2,
101 p_attribute15 VARCHAR2,
102 p_activity_attribute_category VARCHAR2,
103 p_activity_attribute1 VARCHAR2,
104 p_activity_attribute2 VARCHAR2,
105 p_activity_attribute3 VARCHAR2,
106 p_activity_attribute4 VARCHAR2,
107 p_activity_attribute5 VARCHAR2,
108 p_activity_attribute6 VARCHAR2,
109 p_activity_attribute7 VARCHAR2,
110 p_activity_attribute8 VARCHAR2,
111 p_activity_attribute9 VARCHAR2,
112 p_activity_attribute10 VARCHAR2,
113 p_activity_attribute11 VARCHAR2,
114 p_activity_attribute12 VARCHAR2,
115 p_activity_attribute13 VARCHAR2,
116 p_activity_attribute14 VARCHAR2,
117 p_activity_attribute15 VARCHAR2,
118 -- removed by soagrawa on 24-sep-2001
119 -- p_security_group_id NUMBER,
120 p_query_id NUMBER,
121 p_include_content_flag VARCHAR2,
122 p_content_type VARCHAR2,
123 p_test_email_address VARCHAR2,
124 p_schedule_name VARCHAR2,
125 p_schedule_description VARCHAR2,
126 p_greeting_text VARCHAR2,
127 p_footer_text VARCHAR2,
128 --added by anchaudh on 30-apr-2003
129 p_trig_repeat_flag VARCHAR2,
130 p_tgrp_exclude_prev_flag VARCHAR2,
131 --added by anchaudh on 06-may-2003
132 p_orig_csch_id NUMBER,
133 p_cover_letter_version NUMBER,
134 --added by dbiswas on 12-aug-2003
135 p_usage VARCHAR2,
136 p_purpose VARCHAR2,
137 p_last_activation_date DATE,
138 p_sales_methodology_id NUMBER,
139 p_printer_address VARCHAR2,
140 --added by dbiswas on 27-jul-2005
141 p_notify_on_activation_flag VARCHAR2,
142 --added by anchaudh on 01-feb-2006
143 p_sender_display_name VARCHAR2,
144 -- added by srivikri on 29-May-2006
145 p_delivery_mode VARCHAR2
146 );
147
148 -- ===============================================================
149 -- Start of Comments
150 -- Procedure name
151 -- Update_Row
152 -- Purpose
153 -- Table api to update campaign Schedules.
154 -- History
155 -- 22-Jan-2000 ptendulk Created.
156 -- NOTE
157 --
158 -- End of Comments
159 -- ===============================================================
160 PROCEDURE Update_Row(
161 p_schedule_id NUMBER,
162 p_last_update_date DATE,
163 p_last_updated_by NUMBER,
164 p_creation_date DATE,
165 p_created_by NUMBER,
166 p_last_update_login NUMBER,
167 p_object_version_number NUMBER,
168 p_campaign_id NUMBER,
169 p_user_status_id NUMBER,
170 p_status_code VARCHAR2,
171 p_status_date DATE,
172 p_source_code VARCHAR2,
173 p_use_parent_code_flag VARCHAR2,
174 p_start_date_time DATE,
175 p_end_date_time DATE,
176 p_timezone_id NUMBER,
177 p_activity_type_code VARCHAR2,
178 p_activity_id NUMBER,
179 p_arc_marketing_medium_from VARCHAR2,
180 p_marketing_medium_id NUMBER,
181 p_custom_setup_id NUMBER,
182 p_triggerable_flag VARCHAR2,
183 p_trigger_id NUMBER,
184 p_notify_user_id NUMBER,
185 p_approver_user_id NUMBER,
186 p_owner_user_id NUMBER,
187 p_active_flag VARCHAR2,
188 p_cover_letter_id NUMBER,
189 p_reply_to_mail VARCHAR2,
190 p_mail_sender_name VARCHAR2,
191 p_mail_subject VARCHAR2,
192 p_from_fax_no VARCHAR2,
193 p_accounts_closed_flag VARCHAR2,
194 p_org_id NUMBER,
195 p_objective_code VARCHAR2,
196 p_country_id NUMBER,
197 p_campaign_calendar VARCHAR2,
198 p_start_period_name VARCHAR2,
199 p_end_period_name VARCHAR2,
200 p_priority VARCHAR2,
201 p_workflow_item_key VARCHAR2,
202 p_transaction_currency_code VARCHAR2,
203 p_functional_currency_code VARCHAR2,
204 p_budget_amount_tc NUMBER,
205 p_budget_amount_fc NUMBER,
206 p_language_code VARCHAR2,
207 p_task_id NUMBER,
208 p_related_event_from VARCHAR2,
209 p_related_event_id NUMBER,
210 p_attribute_category VARCHAR2,
211 p_attribute1 VARCHAR2,
212 p_attribute2 VARCHAR2,
213 p_attribute3 VARCHAR2,
214 p_attribute4 VARCHAR2,
215 p_attribute5 VARCHAR2,
216 p_attribute6 VARCHAR2,
217 p_attribute7 VARCHAR2,
218 p_attribute8 VARCHAR2,
219 p_attribute9 VARCHAR2,
220 p_attribute10 VARCHAR2,
221 p_attribute11 VARCHAR2,
222 p_attribute12 VARCHAR2,
223 p_attribute13 VARCHAR2,
224 p_attribute14 VARCHAR2,
225 p_attribute15 VARCHAR2,
226 p_activity_attribute_category VARCHAR2,
227 p_activity_attribute1 VARCHAR2,
228 p_activity_attribute2 VARCHAR2,
229 p_activity_attribute3 VARCHAR2,
230 p_activity_attribute4 VARCHAR2,
231 p_activity_attribute5 VARCHAR2,
232 p_activity_attribute6 VARCHAR2,
233 p_activity_attribute7 VARCHAR2,
234 p_activity_attribute8 VARCHAR2,
235 p_activity_attribute9 VARCHAR2,
236 p_activity_attribute10 VARCHAR2,
237 p_activity_attribute11 VARCHAR2,
238 p_activity_attribute12 VARCHAR2,
239 p_activity_attribute13 VARCHAR2,
240 p_activity_attribute14 VARCHAR2,
241 p_activity_attribute15 VARCHAR2,
242 -- removed by soagrawa on 24-sep-2001
243 -- p_security_group_id NUMBER,
244 p_query_id NUMBER,
245 p_include_content_flag VARCHAR2,
246 p_content_type VARCHAR2,
247 p_test_email_address VARCHAR2,
248 p_schedule_name VARCHAR2,
249 p_schedule_description VARCHAR2,
250 p_greeting_text VARCHAR2,
251 p_footer_text VARCHAR2,
252 --added by anchaudh on 30-apr-2003
253 p_trig_repeat_flag VARCHAR2,
254 p_tgrp_exclude_prev_flag VARCHAR2,
255 --added by anchaudh on 06-may-2003
256 p_orig_csch_id NUMBER,
257 p_cover_letter_version NUMBER,
258 --added by dbiswas on 12-aug-2003
259 p_usage VARCHAR2,
260 p_purpose VARCHAR2,
261 p_last_activation_date DATE,
262 p_sales_methodology_id NUMBER,
263 p_printer_address VARCHAR2,
264 --added by dbiswas on 27-jul-2005
265 p_notify_on_activation_flag VARCHAR2,
266 --added by anchaudh on 01-feb-2006
267 p_sender_display_name VARCHAR2,
268 -- added by srivikri on 29-May-2006
269 p_delivery_mode VARCHAR2
270
271 );
272
273 -- ===============================================================
274 -- Start of Comments
275 -- Procedure name
276 -- Delete_Row
277 -- Purpose
278 -- Table api to Delete campaign Schedules.
279 -- History
280 -- 22-Jan-2000 ptendulk Created.
281 -- NOTE
282 --
283 -- End of Comments
284 -- ===============================================================
285 PROCEDURE Delete_Row(
286 p_schedule_id NUMBER);
287
288 -- ===============================================================
289 -- Start of Comments
290 -- Procedure name
291 -- Lock_Row
292 -- Purpose
293 -- Table api to Lock campaign Schedules.
294 -- History
295 -- 22-Jan-2000 ptendulk Created.
296 -- NOTE
297 --
298 -- End of Comments
299 -- ===============================================================
300 PROCEDURE Lock_Row(
301 p_schedule_id NUMBER );
302
303
304
305
306 -- ===============================================================
307 -- Start of Comments
308 -- Procedure name
309 -- ADD_LANGUAGE
310 -- Purpose
311 --
312 -- History
313 -- 12-jun-2002 soagrawa Created. Refer to bug# 2323843 for mailine
314 -- NOTE
315 --
316 -- End of Comments
317 -- ===============================================================
318
319 PROCEDURE ADD_LANGUAGE;
320
321
322 END AMS_CAMPAIGN_SCHEDULES_B_PKG;