[Home] [Help]
PACKAGE BODY: APPS.AMS_DIALOG_REGS_PUB_W
Source
1 package body ams_dialog_regs_pub_w as
2 /* $Header: amswderb.pls 120.5 2006/08/16 04:49:59 rrajesh noship $ */
3 -- This package is used in event registrion through scripting
4 rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
5 rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
6
7 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
8 function rosetta_g_miss_date_in_map(d date) return date as
9 begin
10 if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
11 return d;
12 end;
13
14 procedure register(p_api_version_number NUMBER
15 , p_init_msg_list VARCHAR2
16 , p_commit VARCHAR2
17 , p_validation_level NUMBER
18 , x_return_status out nocopy VARCHAR2
19 , x_msg_count out nocopy NUMBER
20 , x_msg_data out nocopy VARCHAR2
21 , p7_a0 DATE
22 , p7_a1 NUMBER
23 , p7_a2 DATE
24 , p7_a3 NUMBER
25 , p7_a4 NUMBER
26 , p7_a5 VARCHAR2
27 , p7_a6 VARCHAR2
28 , p7_a7 VARCHAR2
29 , p7_a8 VARCHAR2
30 , p7_a9 VARCHAR2
31 , p7_a10 VARCHAR2
32 , p7_a11 VARCHAR2
33 , p7_a12 VARCHAR2
34 , p7_a13 NUMBER
35 , p7_a14 VARCHAR2
36 , p7_a15 NUMBER
37 , p7_a16 VARCHAR2
38 , p7_a17 VARCHAR2
39 , p7_a18 VARCHAR2
40 , p7_a19 VARCHAR2
41 , p7_a20 VARCHAR2
42 , p7_a21 VARCHAR2
43 , p7_a22 VARCHAR2
44 , p7_a23 VARCHAR2
45 , p7_a24 VARCHAR2
46 , p7_a25 VARCHAR2
47 , p7_a26 VARCHAR2
48 , p7_a27 VARCHAR2
49 , p7_a28 VARCHAR2
50 , p7_a29 DATE
51 , p7_a30 DATE
52 , p7_a31 VARCHAR2
53 , p7_a32 VARCHAR2
54 , p7_a33 VARCHAR2
55 , p7_a34 VARCHAR2
56 , p7_a35 VARCHAR2
57 , p7_a36 NUMBER
58 , p7_a37 NUMBER
59 , p7_a38 NUMBER
60 , p7_a39 VARCHAR2
61 , p7_a40 VARCHAR2
62 , p7_a41 VARCHAR2
63 , p7_a42 VARCHAR2
64 , p7_a43 NUMBER
65 , p7_a44 VARCHAR2
66 , p7_a45 VARCHAR2
67 , p7_a46 VARCHAR2
68 , p7_a47 NUMBER
69 , p7_a48 VARCHAR2
70 , p7_a49 VARCHAR2
71 , p7_a50 VARCHAR2
72 , p7_a51 DATE
73 , p7_a52 VARCHAR2
74 , p7_a53 VARCHAR2
75 , p7_a54 VARCHAR2
76 , p7_a55 VARCHAR2
77 , p7_a56 VARCHAR2
78 , p7_a57 VARCHAR2
79 , p7_a58 VARCHAR2
80 , p7_a59 VARCHAR2
81 , p7_a60 VARCHAR2
82 , p7_a61 VARCHAR2
83 , p7_a62 VARCHAR2
84 , p7_a63 VARCHAR2
85 , p7_a64 VARCHAR2
86 , p7_a65 VARCHAR2
87 , p7_a66 VARCHAR2
88 , p7_a67 VARCHAR2
89 , p7_a68 VARCHAR2
90 , p7_a69 VARCHAR2
91 , p7_a70 VARCHAR2
92 , p7_a71 VARCHAR2
93 , p7_a72 VARCHAR2
94 , p7_a73 VARCHAR2
95 , p7_a74 VARCHAR2
96 , p7_a75 VARCHAR2
97 , p7_a76 VARCHAR2
98 , p7_a77 VARCHAR2
99 , p7_a78 VARCHAR2
100 , p7_a79 NUMBER
101 , p7_a80 NUMBER
102 , p7_a81 NUMBER
103 , p7_a82 NUMBER
104 , p7_a83 VARCHAR2
105 , p7_a84 VARCHAR2
106 , p7_a85 VARCHAR2
107 , p7_a86 VARCHAR2
108 , p7_a87 NUMBER
109 , p7_a88 VARCHAR2
110 , p7_a89 NUMBER
111 , p7_a90 VARCHAR2
112 , p7_a91 VARCHAR2
113 , p7_a92 VARCHAR2
114 , p7_a93 VARCHAR2
115 , p7_a94 VARCHAR2
116 , p7_a95 VARCHAR2
117 , p7_a96 VARCHAR2
118 , p7_a97 VARCHAR2
119 , p7_a98 VARCHAR2
120 , p7_a99 VARCHAR2
121 , p7_a100 VARCHAR2
122 , p7_a101 VARCHAR2
123 , p7_a102 VARCHAR2
124 , p7_a103 DATE
125 , p7_a104 DATE
126 , p7_a105 VARCHAR2
127 , p7_a106 VARCHAR2
128 , p7_a107 VARCHAR2
129 , p7_a108 VARCHAR2
130 , p7_a109 VARCHAR2
131 , p7_a110 NUMBER
132 , p7_a111 NUMBER
133 , p7_a112 NUMBER
134 , p7_a113 VARCHAR2
135 , p7_a114 VARCHAR2
136 , p7_a115 VARCHAR2
137 , p7_a116 VARCHAR2
138 , p7_a117 NUMBER
139 , p7_a118 VARCHAR2
140 , p7_a119 NUMBER
141 , p7_a120 VARCHAR2
142 , p7_a121 NUMBER
143 , p7_a122 VARCHAR2
144 , p7_a123 VARCHAR2
145 , p7_a124 VARCHAR2
146 , p7_a125 DATE
147 , p7_a126 VARCHAR2
148 , p7_a127 VARCHAR2
149 , p7_a128 VARCHAR2
150 , p7_a129 VARCHAR2
151 , p7_a130 VARCHAR2
152 , p7_a131 VARCHAR2
153 , p7_a132 VARCHAR2
154 , p7_a133 VARCHAR2
155 , p7_a134 VARCHAR2
156 , p7_a135 VARCHAR2
157 , p7_a136 VARCHAR2
158 , p7_a137 VARCHAR2
159 , p7_a138 NUMBER
160 , p7_a139 VARCHAR2
161 , p7_a140 VARCHAR2
162 , p7_a141 VARCHAR2
163 , p7_a142 VARCHAR2
164 , p7_a143 VARCHAR2
165 , p7_a144 VARCHAR2
166 , p7_a145 VARCHAR2
167 , p7_a146 VARCHAR2
168 , p7_a147 VARCHAR2
169 , p7_a148 VARCHAR2
170 , p7_a149 VARCHAR2
171 , p7_a150 VARCHAR2
172 , p7_a151 VARCHAR2
173 , p7_a152 VARCHAR2
174 , p7_a153 NUMBER
175 , p7_a154 NUMBER
176 , p7_a155 NUMBER
177 , p7_a156 NUMBER
178 , p7_a157 VARCHAR2
179 , p7_a158 VARCHAR2
180 , p7_a159 VARCHAR2
181 , p7_a160 VARCHAR2
182 , p_block_fulfillment VARCHAR2
183 , p_owner_user_id NUMBER
184 , p_application_id NUMBER
185 , x_confirm_code out nocopy VARCHAR2
186 , x_party_id out nocopy NUMBER
187 , x_system_status_code out nocopy VARCHAR2
188 , p7_a161 VARCHAR2
189 )
190
191 as
192 ddp_reg_det_rec ams_dialog_regs_pub.registrationdetails;
193 ddindx binary_integer; indx binary_integer;
194 begin
195
196 -- copy data to the local IN or IN-OUT args, if any
197
198
199
200
201
202
203
204 ddp_reg_det_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a0);
205 ddp_reg_det_rec.last_updated_by := p7_a1;
206 ddp_reg_det_rec.creation_date := rosetta_g_miss_date_in_map(p7_a2);
207 ddp_reg_det_rec.created_by := p7_a3;
208 ddp_reg_det_rec.last_update_login := p7_a4;
209 ddp_reg_det_rec.event_source_code := p7_a5;
210 ddp_reg_det_rec.registration_source_type := p7_a6;
211 ddp_reg_det_rec.attendance_flag := p7_a7;
212 ddp_reg_det_rec.waitlisted_flag := p7_a8;
213 ddp_reg_det_rec.cancellation_flag := p7_a9;
214 ddp_reg_det_rec.cancellation_reason_code := p7_a10;
215 ddp_reg_det_rec.confirmation_code := p7_a11;
216 ddp_reg_det_rec.original_system_reference := p7_a12;
217 ddp_reg_det_rec.reg_party_id := p7_a13;
218 ddp_reg_det_rec.reg_party_type := p7_a14;
219 ddp_reg_det_rec.reg_contact_id := p7_a15;
220 ddp_reg_det_rec.reg_party_name := p7_a16;
221 ddp_reg_det_rec.reg_title := p7_a17;
222 ddp_reg_det_rec.reg_first_name := p7_a18;
223 ddp_reg_det_rec.reg_middle_name := p7_a19;
224 ddp_reg_det_rec.reg_last_name := p7_a20;
225 ddp_reg_det_rec.reg_address1 := p7_a21;
226 ddp_reg_det_rec.reg_address2 := p7_a22;
227 ddp_reg_det_rec.reg_address3 := p7_a23;
228 ddp_reg_det_rec.reg_address4 := p7_a24;
229 ddp_reg_det_rec.reg_gender := p7_a25;
230 ddp_reg_det_rec.reg_address_line_phonetic := p7_a26;
231 ddp_reg_det_rec.reg_analysis_fy := p7_a27;
232 ddp_reg_det_rec.reg_apt_flag := p7_a28;
233 ddp_reg_det_rec.reg_best_time_contact_begin := rosetta_g_miss_date_in_map(p7_a29);
234 ddp_reg_det_rec.reg_best_time_contact_end := rosetta_g_miss_date_in_map(p7_a30);
235 ddp_reg_det_rec.reg_category_code := p7_a31;
236 ddp_reg_det_rec.reg_ceo_name := p7_a32;
237 ddp_reg_det_rec.reg_city := p7_a33;
238 ddp_reg_det_rec.reg_country := p7_a34;
239 ddp_reg_det_rec.reg_county := p7_a35;
240 ddp_reg_det_rec.reg_current_fy_potential_rev := p7_a36;
241 ddp_reg_det_rec.reg_next_fy_potential_rev := p7_a37;
242 ddp_reg_det_rec.reg_household_income := p7_a38;
243 ddp_reg_det_rec.reg_decision_maker_flag := p7_a39;
244 ddp_reg_det_rec.reg_department := p7_a40;
245 ddp_reg_det_rec.reg_dun_no_c := p7_a41;
246 ddp_reg_det_rec.reg_email_address := p7_a42;
247 ddp_reg_det_rec.reg_employee_total := p7_a43;
248 ddp_reg_det_rec.reg_fy_end_month := p7_a44;
249 ddp_reg_det_rec.reg_floor := p7_a45;
250 ddp_reg_det_rec.reg_gsa_indicator_flag := p7_a46;
251 ddp_reg_det_rec.reg_house_number := p7_a47;
252 ddp_reg_det_rec.reg_identifying_address_flag := p7_a48;
253 ddp_reg_det_rec.reg_jgzz_fiscal_code := p7_a49;
254 ddp_reg_det_rec.reg_job_title := p7_a50;
255 ddp_reg_det_rec.reg_last_order_date := rosetta_g_miss_date_in_map(p7_a51);
256 ddp_reg_det_rec.reg_org_legal_status := p7_a52;
257 ddp_reg_det_rec.reg_line_of_business := p7_a53;
258 ddp_reg_det_rec.reg_mission_statement := p7_a54;
259 ddp_reg_det_rec.reg_org_name_phonetic := p7_a55;
260 ddp_reg_det_rec.reg_overseas_address_flag := p7_a56;
261 ddp_reg_det_rec.reg_name_suffix := p7_a57;
262 ddp_reg_det_rec.reg_phone_area_code := p7_a58;
263 ddp_reg_det_rec.reg_phone_country_code := p7_a59;
264 ddp_reg_det_rec.reg_phone_extension := p7_a60;
265 ddp_reg_det_rec.reg_phone_number := p7_a61;
266 ddp_reg_det_rec.reg_postal_code := p7_a62;
267 ddp_reg_det_rec.reg_postal_plus4_code := p7_a63;
268 ddp_reg_det_rec.reg_po_box_no := p7_a64;
269 ddp_reg_det_rec.reg_province := p7_a65;
270 ddp_reg_det_rec.reg_rural_route_no := p7_a66;
271 ddp_reg_det_rec.reg_rural_route_type := p7_a67;
272 ddp_reg_det_rec.reg_secondary_suffix_element := p7_a68;
273 ddp_reg_det_rec.reg_sic_code := p7_a69;
274 ddp_reg_det_rec.reg_sic_code_type := p7_a70;
275 ddp_reg_det_rec.reg_site_use_code := p7_a71;
276 ddp_reg_det_rec.reg_state := p7_a72;
277 ddp_reg_det_rec.reg_street := p7_a73;
278 ddp_reg_det_rec.reg_street_number := p7_a74;
279 ddp_reg_det_rec.reg_street_suffix := p7_a75;
280 ddp_reg_det_rec.reg_suite := p7_a76;
281 ddp_reg_det_rec.reg_tax_name := p7_a77;
282 ddp_reg_det_rec.reg_tax_reference := p7_a78;
283 ddp_reg_det_rec.reg_timezone := p7_a79;
284 ddp_reg_det_rec.reg_total_no_of_orders := p7_a80;
285 ddp_reg_det_rec.reg_total_order_amount := p7_a81;
286 ddp_reg_det_rec.reg_year_established := p7_a82;
287 ddp_reg_det_rec.reg_url := p7_a83;
288 ddp_reg_det_rec.reg_survey_notes := p7_a84;
289 ddp_reg_det_rec.reg_contact_me_flag := p7_a85;
290 ddp_reg_det_rec.reg_email_ok_flag := p7_a86;
291 ddp_reg_det_rec.att_party_id := p7_a87;
292 ddp_reg_det_rec.att_party_type := p7_a88;
293 ddp_reg_det_rec.att_contact_id := p7_a89;
294 ddp_reg_det_rec.att_party_name := p7_a90;
295 ddp_reg_det_rec.att_title := p7_a91;
296 ddp_reg_det_rec.att_first_name := p7_a92;
297 ddp_reg_det_rec.att_middle_name := p7_a93;
298 ddp_reg_det_rec.att_last_name := p7_a94;
299 ddp_reg_det_rec.att_address1 := p7_a95;
300 ddp_reg_det_rec.att_address2 := p7_a96;
301 ddp_reg_det_rec.att_address3 := p7_a97;
302 ddp_reg_det_rec.att_address4 := p7_a98;
303 ddp_reg_det_rec.att_gender := p7_a99;
304 ddp_reg_det_rec.att_address_line_phonetic := p7_a100;
305 ddp_reg_det_rec.att_analysis_fy := p7_a101;
306 ddp_reg_det_rec.att_apt_flag := p7_a102;
307 ddp_reg_det_rec.att_best_time_contact_begin := rosetta_g_miss_date_in_map(p7_a103);
308 ddp_reg_det_rec.att_best_time_contact_end := rosetta_g_miss_date_in_map(p7_a104);
309 ddp_reg_det_rec.att_category_code := p7_a105;
310 ddp_reg_det_rec.att_ceo_name := p7_a106;
311 ddp_reg_det_rec.att_city := p7_a107;
312 ddp_reg_det_rec.att_country := p7_a108;
313 ddp_reg_det_rec.att_county := p7_a109;
314 ddp_reg_det_rec.att_current_fy_potential_rev := p7_a110;
315 ddp_reg_det_rec.att_next_fy_potential_rev := p7_a111;
316 ddp_reg_det_rec.att_household_income := p7_a112;
317 ddp_reg_det_rec.att_decision_maker_flag := p7_a113;
318 ddp_reg_det_rec.att_department := p7_a114;
319 ddp_reg_det_rec.att_dun_no_c := p7_a115;
320 ddp_reg_det_rec.att_email_address := p7_a116;
321 ddp_reg_det_rec.att_employee_total := p7_a117;
322 ddp_reg_det_rec.att_fy_end_month := p7_a118;
323 ddp_reg_det_rec.att_floor := p7_a119;
324 ddp_reg_det_rec.att_gsa_indicator_flag := p7_a120;
325 ddp_reg_det_rec.att_house_number := p7_a121;
326 ddp_reg_det_rec.att_identifying_address_flag := p7_a122;
327 ddp_reg_det_rec.att_jgzz_fiscal_code := p7_a123;
328 ddp_reg_det_rec.att_job_title := p7_a124;
329 ddp_reg_det_rec.att_last_order_date := rosetta_g_miss_date_in_map(p7_a125);
330 ddp_reg_det_rec.att_org_legal_status := p7_a126;
331 ddp_reg_det_rec.att_line_of_business := p7_a127;
332 ddp_reg_det_rec.att_mission_statement := p7_a128;
333 ddp_reg_det_rec.att_org_name_phonetic := p7_a129;
334 ddp_reg_det_rec.att_overseas_address_flag := p7_a130;
335 ddp_reg_det_rec.att_name_suffix := p7_a131;
336 ddp_reg_det_rec.att_phone_area_code := p7_a132;
337 ddp_reg_det_rec.att_phone_country_code := p7_a133;
338 ddp_reg_det_rec.att_phone_extension := p7_a134;
339 ddp_reg_det_rec.att_phone_number := p7_a135;
340 ddp_reg_det_rec.att_postal_code := p7_a136;
341 ddp_reg_det_rec.att_postal_plus4_code := p7_a137;
342 ddp_reg_det_rec.att_po_box_no := p7_a138;
343 ddp_reg_det_rec.att_province := p7_a139;
344 ddp_reg_det_rec.att_rural_route_no := p7_a140;
345 ddp_reg_det_rec.att_rural_route_type := p7_a141;
346 ddp_reg_det_rec.att_secondary_suffix_element := p7_a142;
347 ddp_reg_det_rec.att_sic_code := p7_a143;
351 ddp_reg_det_rec.att_street := p7_a147;
348 ddp_reg_det_rec.att_sic_code_type := p7_a144;
349 ddp_reg_det_rec.att_site_use_code := p7_a145;
350 ddp_reg_det_rec.att_state := p7_a146;
352 ddp_reg_det_rec.att_street_number := p7_a148;
353 ddp_reg_det_rec.att_street_suffix := p7_a149;
354 ddp_reg_det_rec.att_suite := p7_a150;
355 ddp_reg_det_rec.att_tax_name := p7_a151;
356 ddp_reg_det_rec.att_tax_reference := p7_a152;
357 ddp_reg_det_rec.att_timezone := p7_a153;
358 ddp_reg_det_rec.att_total_no_of_orders := p7_a154;
359 ddp_reg_det_rec.att_total_order_amount := p7_a155;
360 ddp_reg_det_rec.att_year_established := p7_a156;
361 ddp_reg_det_rec.att_url := p7_a157;
362 ddp_reg_det_rec.att_survey_notes := p7_a158;
363 ddp_reg_det_rec.att_contact_me_flag := p7_a159;
364 ddp_reg_det_rec.att_email_ok_flag := p7_a160;
365 ddp_reg_det_rec.update_reg_rec := p7_a161;
366
367
368
369
370
371
372
373 -- here's the delegated call to the old PL/SQL routine
374 ams_dialog_regs_pub.register(p_api_version_number,
375 p_init_msg_list,
376 p_commit,
377 p_validation_level,
378 x_return_status,
379 x_msg_count,
380 x_msg_data,
381 ddp_reg_det_rec,
382 p_block_fulfillment,
383 p_owner_user_id,
384 p_application_id,
385 x_confirm_code,
386 x_party_id,
387 x_system_status_code);
388
389 -- copy data back from the local variables to OUT or IN-OUT args, if any
390
391
392
393
394
395
396
397
398
399
400
401
402
403 end;
404
405 end ams_dialog_regs_pub_w;