[Home] [Help]
PACKAGE BODY: APPS.AMS_DIALOG_REGS_PUB
Source
1 PACKAGE BODY AMS_Dialog_Regs_PUB AS
2 /* $Header: amspderb.pls 120.3 2006/08/16 04:49:37 rrajesh noship $ */
3 -- This package is used in event registrion through scripting
4 g_pkg_name CONSTANT VARCHAR2(30):='AMS_Dialog_Regs_PUB';
5
6 Procedure transform_record( p_reg_det_rec IN RegistrationDetails
7 , x_reg_det_rec out NOCOPY AMS_Registrants_PUB.RegistrationDet
8 );
9
10 --==============================================================================
11 -- Start of Comments
12 --==============================================================================
13 --API Name
14 -- Register
15 --Type
16 -- Public
17 --Pre-Req
18 --
19 --Parameters
20 --
21 --IN
22 -- p_api_version_number IN NUMBER Required
23 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
24 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
25 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
26 -- p_reg_det_rec IN RegistrationDetails Required
27 --
28 --OUT
29 -- x_return_status OUT VARCHAR2
30 -- x_msg_count OUT NUMBER
31 -- x_msg_data OUT VARCHAR2
32 -- x_confirm_code OUT VARCHAR2 (the confirmation code)
33 -- x_party_id OUT NUMBER (the attendant contact id - maps to a party_id in hz_parties)
34 -- x_system_status_code OUT VARCHAR2 (the status code of the registration)
35 --Version : Current version 1.0
36 --
37 --End of Comments
38 --==============================================================================
39 PROCEDURE Register( p_api_version_number IN NUMBER
40 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
41 , p_commit IN VARCHAR2 := FND_API.G_FALSE
42 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
43
44 , x_return_status OUT NOCOPY VARCHAR2
45 , x_msg_count OUT NOCOPY NUMBER
46 , x_msg_data OUT NOCOPY VARCHAR2
47
48 , p_reg_det_rec IN RegistrationDetails
49 , p_block_fulfillment IN VARCHAR2 := FND_API.G_TRUE
50 , p_owner_user_id IN NUMBER
51 , p_application_id IN NUMBER
52
53 , x_confirm_code OUT NOCOPY VARCHAR2
54 , x_party_id OUT NOCOPY NUMBER
55 , x_system_status_code OUT NOCOPY VARCHAR2
56 )
57
58 IS
59
60 L_API_NAME CONSTANT VARCHAR2(30) := 'Register';
61 L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
62 l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
63
64 l_return_status VARCHAR2(1);
65 l_reg_det_rec AMS_Registrants_PUB.RegistrationDet;
66
67 cursor c_get_extra_details(p_confirmation_code VARCHAR2) is
68 select attendant_contact_id,
69 system_status_code
70 from ams_event_registrations
71 where confirmation_code = p_confirmation_code;
72
73 BEGIN
74
75 SAVEPOINT Register_Dialog_Regs_PUB;
76 AMS_Utility_PVT.debug_message(l_full_name || ': start');
77
78 -- Standard call to check for call compatibility.
79 IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
80 p_api_version_number,
81 l_api_name,
82 G_PKG_NAME)
83 THEN
84 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
85 END IF;
86
87 l_return_status := FND_API.g_ret_sts_success;
88
89 -- Initialize message list if p_init_msg_list is set to TRUE.
90 IF FND_API.to_Boolean( p_init_msg_list )
91 THEN
92 FND_MSG_PUB.initialize;
93 END IF;
94
95 transform_record( p_reg_det_rec => p_reg_det_rec
96 , x_reg_det_rec => l_reg_det_rec
97 );
98
99 AMS_Registrants_Pub.Register( p_api_version_number => 1.0
100 , p_init_msg_list => FND_API.G_FALSE
101 , p_commit => FND_API.G_FALSE
102 , p_validation_level => p_validation_level
103
104 , x_return_status => l_return_status
105 , x_msg_count => x_msg_count
106 , x_msg_data => x_msg_data
107
108 , p_reg_det_rec => l_reg_det_rec
109 , p_block_fulfillment => p_block_fulfillment
110 , p_owner_user_id => p_owner_user_id
111 , p_application_id => p_application_id
112
113 , x_confirm_code => x_confirm_code
114 );
115
116 IF (l_return_status = FND_API.g_ret_sts_unexp_error)
117 THEN
118 RAISE FND_API.g_exc_unexpected_error;
119 ELSIF (l_return_status = FND_API.g_ret_sts_error)
120 THEN
121 RAISE FND_API.g_exc_error;
122 END IF; -- l_return_status
123
124 open c_get_extra_details(x_confirm_code);
125 fetch c_get_extra_details
126 into x_party_id,
127 x_system_status_code;
128 close c_get_extra_details;
129
130 IF FND_API.to_boolean(p_commit)
131 THEN
132 COMMIT;
133 END IF; -- p_commit
134
135 FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
136 , p_count => x_msg_count
137 , p_data => x_msg_data
138 );
139
140 x_return_status := l_return_status;
141
142 AMS_Utility_PVT.debug_message(l_full_name || ': end');
143
144 EXCEPTION
145
146 WHEN FND_API.g_exc_error
147 THEN
148 ROLLBACK TO Register_Registrants_PUB;
149 x_return_status := FND_API.g_ret_sts_error;
150 FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
151 , p_count => x_msg_count
152 , p_data => x_msg_data
153 );
154
155 --sanshuma : temp soln
156 fnd_message.set_encoded(fnd_msg_pub.get(x_msg_count));
157 x_msg_data := fnd_message.get;
158
159
160 WHEN FND_API.g_exc_unexpected_error
161 THEN
162 ROLLBACK TO Register_Registrants_PUB;
163 x_return_status := FND_API.g_ret_sts_unexp_error ;
164 FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
165 , p_count => x_msg_count
166 , p_data => x_msg_data
167 );
168
169 WHEN OTHERS
170 THEN
171 ROLLBACK TO Register_Registrants_PUB;
172 x_return_status := FND_API.g_ret_sts_unexp_error ;
173 IF (FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error))
174 THEN
175 FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
176 END IF; -- check_msg_level
177 FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
178 , p_count => x_msg_count
179 , p_data => x_msg_data
180 );
181
182 END Register;
183
184 --==============================================================================
185 -- Start of Comments
186 --==============================================================================
187 --API Name
188 -- IsRegistered
189 --Type
190 -- Public
191 --Pre-Req
192 --
193 --Parameters
194 --
195 --IN
196 -- p_api_version_number IN NUMBER Required
197 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
198 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
199 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
200 -- p_confirm_code IN RegistrationDetails Required
201 --
202 --OUT
203 -- x_return_status OUT VARCHAR2
204 -- x_msg_count OUT NUMBER
205 -- x_msg_data OUT VARCHAR2
206 -- x_is_registered OUT VARCHAR2 ('Y' if registrant has status REGISTERED, 'N' otherwise)
207 --Version : Current version 1.0
208 --
209 --End of Comments
210 --==============================================================================
211 Procedure IsRegistered( p_api_version_number IN NUMBER
212 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
213 , p_commit IN VARCHAR2 := FND_API.G_FALSE
214 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
215
216 , x_return_status OUT NOCOPY VARCHAR2
217 , x_msg_count OUT NOCOPY NUMBER
218 , x_msg_data OUT NOCOPY VARCHAR2
219
220 , p_confirm_code IN VARCHAR2
221 , x_is_registered OUT NOCOPY VARCHAR2
222 )
223 IS
224
225 L_API_NAME CONSTANT VARCHAR2(30) := 'IsRegistered';
226 L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
227 l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
228
229 l_status_code VARCHAR2(30);
230 l_return_status VARCHAR2(1);
231
232 cursor c_get_status_code(p_confirmation_code VARCHAR2) is
233 select system_status_code
234 from ams_event_registrations
235 where confirmation_code = p_confirmation_code;
236
237 BEGIN
238
239 SAVEPOINT IsRegistered_Dialog_Regs_PUB;
240 AMS_Utility_PVT.debug_message(l_full_name || ': start');
241
242 -- Standard call to check for call compatibility.
243 IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
244 p_api_version_number,
245 l_api_name,
246 G_PKG_NAME)
247 THEN
248 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
249 END IF;
250
251 l_return_status := FND_API.g_ret_sts_success;
252
253 -- Initialize message list if p_init_msg_list is set to TRUE.
254 IF FND_API.to_Boolean( p_init_msg_list )
255 THEN
256 FND_MSG_PUB.initialize;
257 END IF;
258
259 open c_get_status_code(p_confirm_code);
260 fetch c_get_status_code
261 into l_status_code;
262 close c_get_status_code;
263
264 if (nvl(l_status_code, 'X') = 'REGISTERED')
265 then
266 x_is_registered := 'Y';
267 else
268 x_is_registered := 'N';
269 end if;
270
271 IF FND_API.to_boolean(p_commit)
272 THEN
273 COMMIT;
274 END IF; -- p_commit
275
276 FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
277 , p_count => x_msg_count
278 , p_data => x_msg_data
279 );
280
281 x_return_status := l_return_status;
282
283 AMS_Utility_PVT.debug_message(l_full_name || ': end');
284
285 END IsRegistered;
286
287 Procedure transform_record( p_reg_det_rec IN RegistrationDetails
288 , x_reg_det_rec out NOCOPY AMS_Registrants_PUB.RegistrationDet
289 )
290 IS
291
292 BEGIN
293
294 x_reg_det_rec.last_update_date := p_reg_det_rec.last_update_date;
295 x_reg_det_rec.last_updated_by := p_reg_det_rec.last_updated_by;
296 x_reg_det_rec.creation_date := p_reg_det_rec.creation_date;
297 x_reg_det_rec.created_by := p_reg_det_rec.created_by;
298 x_reg_det_rec.last_update_login := p_reg_det_rec.last_update_login;
299 x_reg_det_rec.event_source_code := p_reg_det_rec.event_source_code;
300 x_reg_det_rec.registration_source_type := p_reg_det_rec.registration_source_type;
301 x_reg_det_rec.attendance_flag := p_reg_det_rec.attendance_flag;
302 x_reg_det_rec.waitlisted_flag := p_reg_det_rec.waitlisted_flag;
303 x_reg_det_rec.cancellation_flag := p_reg_det_rec.cancellation_flag;
304 x_reg_det_rec.cancellation_reason_code := p_reg_det_rec.cancellation_reason_code;
305 x_reg_det_rec.confirmation_code := p_reg_det_rec.confirmation_code;
306 x_reg_det_rec.original_system_reference := p_reg_det_rec.original_system_reference;
307 x_reg_det_rec.reg_party_id := p_reg_det_rec.reg_party_id;
308 x_reg_det_rec.reg_party_type := p_reg_det_rec.reg_party_type;
309 x_reg_det_rec.reg_contact_id := p_reg_det_rec.reg_contact_id;
310 x_reg_det_rec.reg_party_name := p_reg_det_rec.reg_party_name;
311 x_reg_det_rec.reg_title := p_reg_det_rec.reg_title;
312 x_reg_det_rec.reg_first_name := p_reg_det_rec.reg_first_name;
313 x_reg_det_rec.reg_middle_name := p_reg_det_rec.reg_middle_name;
314 x_reg_det_rec.reg_last_name := p_reg_det_rec.reg_last_name;
315 x_reg_det_rec.reg_address1 := p_reg_det_rec.reg_address1;
316 x_reg_det_rec.reg_address2 := p_reg_det_rec.reg_address2;
317 x_reg_det_rec.reg_address3 := p_reg_det_rec.reg_address3;
318 x_reg_det_rec.reg_address4 := p_reg_det_rec.reg_address4;
319 x_reg_det_rec.reg_gender := p_reg_det_rec.reg_gender;
320 x_reg_det_rec.reg_address_line_phonetic := p_reg_det_rec.reg_address_line_phonetic;
321 x_reg_det_rec.reg_analysis_fy := p_reg_det_rec.reg_analysis_fy;
322 x_reg_det_rec.reg_apt_flag := p_reg_det_rec.reg_apt_flag;
323 x_reg_det_rec.reg_best_time_contact_begin := p_reg_det_rec.reg_best_time_contact_begin;
324 x_reg_det_rec.reg_best_time_contact_end := p_reg_det_rec.reg_best_time_contact_end;
325 x_reg_det_rec.reg_category_code := p_reg_det_rec.reg_category_code;
326 x_reg_det_rec.reg_ceo_name := p_reg_det_rec.reg_ceo_name;
327 x_reg_det_rec.reg_city := p_reg_det_rec.reg_city;
328 x_reg_det_rec.reg_country := p_reg_det_rec.reg_country;
329 x_reg_det_rec.reg_county := p_reg_det_rec.reg_county;
330 x_reg_det_rec.reg_current_fy_potential_rev := p_reg_det_rec.reg_current_fy_potential_rev;
331 x_reg_det_rec.reg_next_fy_potential_rev := p_reg_det_rec.reg_next_fy_potential_rev;
332 x_reg_det_rec.reg_household_income := p_reg_det_rec.reg_household_income;
333 x_reg_det_rec.reg_decision_maker_flag := p_reg_det_rec.reg_decision_maker_flag;
334 x_reg_det_rec.reg_department := p_reg_det_rec.reg_department;
335 x_reg_det_rec.reg_dun_no_c := p_reg_det_rec.reg_dun_no_c;
336 x_reg_det_rec.reg_email_address := p_reg_det_rec.reg_email_address;
337 x_reg_det_rec.reg_employee_total := p_reg_det_rec.reg_employee_total;
338 x_reg_det_rec.reg_fy_end_month := p_reg_det_rec.reg_fy_end_month;
339 x_reg_det_rec.reg_floor := p_reg_det_rec.reg_floor;
340 x_reg_det_rec.reg_gsa_indicator_flag := p_reg_det_rec.reg_gsa_indicator_flag;
341 x_reg_det_rec.reg_house_number := p_reg_det_rec.reg_house_number;
342 x_reg_det_rec.reg_identifying_address_flag := p_reg_det_rec.reg_identifying_address_flag;
343 x_reg_det_rec.reg_jgzz_fiscal_code := p_reg_det_rec.reg_jgzz_fiscal_code;
344 x_reg_det_rec.reg_job_title := p_reg_det_rec.reg_job_title;
345 x_reg_det_rec.reg_last_order_date := p_reg_det_rec.reg_last_order_date;
346 x_reg_det_rec.reg_org_legal_status := p_reg_det_rec.reg_org_legal_status;
347 x_reg_det_rec.reg_line_of_business := p_reg_det_rec.reg_line_of_business;
348 x_reg_det_rec.reg_mission_statement := p_reg_det_rec.reg_mission_statement;
349 x_reg_det_rec.reg_org_name_phonetic := p_reg_det_rec.reg_org_name_phonetic;
350 x_reg_det_rec.reg_overseas_address_flag := p_reg_det_rec.reg_overseas_address_flag;
351 x_reg_det_rec.reg_name_suffix := p_reg_det_rec.reg_name_suffix;
352 x_reg_det_rec.reg_phone_area_code := p_reg_det_rec.reg_phone_area_code;
353 x_reg_det_rec.reg_phone_country_code := p_reg_det_rec.reg_phone_country_code;
354 x_reg_det_rec.reg_phone_extension := p_reg_det_rec.reg_phone_extension;
355 x_reg_det_rec.reg_phone_number := p_reg_det_rec.reg_phone_number;
356 x_reg_det_rec.reg_postal_code := p_reg_det_rec.reg_postal_code;
357 x_reg_det_rec.reg_postal_plus4_code := p_reg_det_rec.reg_postal_plus4_code;
361 x_reg_det_rec.reg_rural_route_type := p_reg_det_rec.reg_rural_route_type;
358 x_reg_det_rec.reg_po_box_no := p_reg_det_rec.reg_po_box_no;
359 x_reg_det_rec.reg_province := p_reg_det_rec.reg_province;
360 x_reg_det_rec.reg_rural_route_no := p_reg_det_rec.reg_rural_route_no;
362 x_reg_det_rec.reg_secondary_suffix_element := p_reg_det_rec.reg_secondary_suffix_element;
363 x_reg_det_rec.reg_sic_code := p_reg_det_rec.reg_sic_code;
364 x_reg_det_rec.reg_sic_code_type := p_reg_det_rec.reg_sic_code_type;
365 x_reg_det_rec.reg_site_use_code := p_reg_det_rec.reg_site_use_code;
366 x_reg_det_rec.reg_state := p_reg_det_rec.reg_state;
367 x_reg_det_rec.reg_street := p_reg_det_rec.reg_street;
368 x_reg_det_rec.reg_street_number := p_reg_det_rec.reg_street_number;
369 x_reg_det_rec.reg_street_suffix := p_reg_det_rec.reg_street_suffix;
370 x_reg_det_rec.reg_suite := p_reg_det_rec.reg_suite;
371 x_reg_det_rec.reg_tax_name := p_reg_det_rec.reg_tax_name;
372 x_reg_det_rec.reg_tax_reference := p_reg_det_rec.reg_tax_reference;
373 x_reg_det_rec.reg_timezone := p_reg_det_rec.reg_timezone;
374 x_reg_det_rec.reg_total_no_of_orders := p_reg_det_rec.reg_total_no_of_orders;
375 x_reg_det_rec.reg_total_order_amount := p_reg_det_rec.reg_total_order_amount;
376 x_reg_det_rec.reg_year_established := p_reg_det_rec.reg_year_established;
377 x_reg_det_rec.reg_url := p_reg_det_rec.reg_url;
378 x_reg_det_rec.reg_survey_notes := p_reg_det_rec.reg_survey_notes;
379 x_reg_det_rec.reg_contact_me_flag := p_reg_det_rec.reg_contact_me_flag;
380 x_reg_det_rec.reg_email_ok_flag := p_reg_det_rec.reg_email_ok_flag;
381 x_reg_det_rec.att_party_id := p_reg_det_rec.att_party_id;
382 x_reg_det_rec.att_party_type := p_reg_det_rec.att_party_type;
383 x_reg_det_rec.att_contact_id := p_reg_det_rec.att_contact_id;
384 x_reg_det_rec.att_party_name := p_reg_det_rec.att_party_name;
385 x_reg_det_rec.att_title := p_reg_det_rec.att_title;
386 x_reg_det_rec.att_first_name := p_reg_det_rec.att_first_name;
387 x_reg_det_rec.att_middle_name := p_reg_det_rec.att_middle_name;
388 x_reg_det_rec.att_last_name := p_reg_det_rec.att_last_name;
389 x_reg_det_rec.att_address1 := p_reg_det_rec.att_address1;
390 x_reg_det_rec.att_address2 := p_reg_det_rec.att_address2;
391 x_reg_det_rec.att_address3 := p_reg_det_rec.att_address3;
392 x_reg_det_rec.att_address4 := p_reg_det_rec.att_address4;
393 x_reg_det_rec.att_gender := p_reg_det_rec.att_gender;
394 x_reg_det_rec.att_address_line_phonetic := p_reg_det_rec.att_address_line_phonetic;
395 x_reg_det_rec.att_analysis_fy := p_reg_det_rec.att_analysis_fy;
396 x_reg_det_rec.att_apt_flag := p_reg_det_rec.att_apt_flag;
397 x_reg_det_rec.att_best_time_contact_begin := p_reg_det_rec.att_best_time_contact_begin;
398 x_reg_det_rec.att_best_time_contact_end := p_reg_det_rec.att_best_time_contact_end;
399 x_reg_det_rec.att_category_code := p_reg_det_rec.att_category_code;
400 x_reg_det_rec.att_ceo_name := p_reg_det_rec.att_ceo_name;
401 x_reg_det_rec.att_city := p_reg_det_rec.att_city;
402 x_reg_det_rec.att_country := p_reg_det_rec.att_country;
403 x_reg_det_rec.att_county := p_reg_det_rec.att_county;
404 x_reg_det_rec.att_current_fy_potential_rev := p_reg_det_rec.att_current_fy_potential_rev;
405 x_reg_det_rec.att_next_fy_potential_rev := p_reg_det_rec.att_next_fy_potential_rev;
406 x_reg_det_rec.att_household_income := p_reg_det_rec.att_household_income;
407 x_reg_det_rec.att_decision_maker_flag := p_reg_det_rec.att_decision_maker_flag;
408 x_reg_det_rec.att_department := p_reg_det_rec.att_department;
409 x_reg_det_rec.att_dun_no_c := p_reg_det_rec.att_dun_no_c;
410 x_reg_det_rec.att_email_address := p_reg_det_rec.att_email_address;
411 x_reg_det_rec.att_employee_total := p_reg_det_rec.att_employee_total;
412 x_reg_det_rec.att_fy_end_month := p_reg_det_rec.att_fy_end_month;
413 x_reg_det_rec.att_floor := p_reg_det_rec.att_floor;
414 x_reg_det_rec.att_gsa_indicator_flag := p_reg_det_rec.att_gsa_indicator_flag;
415 x_reg_det_rec.att_house_number := p_reg_det_rec.att_house_number;
416 x_reg_det_rec.att_identifying_address_flag := p_reg_det_rec.att_identifying_address_flag;
417 x_reg_det_rec.att_jgzz_fiscal_code := p_reg_det_rec.att_jgzz_fiscal_code;
418 x_reg_det_rec.att_job_title := p_reg_det_rec.att_job_title;
419 x_reg_det_rec.att_last_order_date := p_reg_det_rec.att_last_order_date;
420 x_reg_det_rec.att_org_legal_status := p_reg_det_rec.att_org_legal_status;
421 x_reg_det_rec.att_line_of_business := p_reg_det_rec.att_line_of_business;
422 x_reg_det_rec.att_mission_statement := p_reg_det_rec.att_mission_statement;
423 x_reg_det_rec.att_org_name_phonetic := p_reg_det_rec.att_org_name_phonetic;
424 x_reg_det_rec.att_overseas_address_flag := p_reg_det_rec.att_overseas_address_flag;
425 x_reg_det_rec.att_name_suffix := p_reg_det_rec.att_name_suffix;
426 x_reg_det_rec.att_phone_area_code := p_reg_det_rec.att_phone_area_code;
427 x_reg_det_rec.att_phone_country_code := p_reg_det_rec.att_phone_country_code;
428 x_reg_det_rec.att_phone_extension := p_reg_det_rec.att_phone_extension;
429 x_reg_det_rec.att_phone_number := p_reg_det_rec.att_phone_number;
430 x_reg_det_rec.att_postal_code := p_reg_det_rec.att_postal_code;
431 x_reg_det_rec.att_postal_plus4_code := p_reg_det_rec.att_postal_plus4_code;
432 x_reg_det_rec.att_po_box_no := p_reg_det_rec.att_po_box_no;
433 x_reg_det_rec.att_province := p_reg_det_rec.att_province;
434 x_reg_det_rec.att_rural_route_no := p_reg_det_rec.att_rural_route_no;
435 x_reg_det_rec.att_rural_route_type := p_reg_det_rec.att_rural_route_type;
436 x_reg_det_rec.att_secondary_suffix_element := p_reg_det_rec.att_secondary_suffix_element;
437 x_reg_det_rec.att_sic_code := p_reg_det_rec.att_sic_code;
438 x_reg_det_rec.att_sic_code_type := p_reg_det_rec.att_sic_code_type;
439 x_reg_det_rec.att_site_use_code := p_reg_det_rec.att_site_use_code;
440 x_reg_det_rec.att_state := p_reg_det_rec.att_state;
441 x_reg_det_rec.att_street := p_reg_det_rec.att_street;
442 x_reg_det_rec.att_street_number := p_reg_det_rec.att_street_number;
443 x_reg_det_rec.att_street_suffix := p_reg_det_rec.att_street_suffix;
444 x_reg_det_rec.att_suite := p_reg_det_rec.att_suite;
445 x_reg_det_rec.att_tax_name := p_reg_det_rec.att_tax_name;
446 x_reg_det_rec.att_tax_reference := p_reg_det_rec.att_tax_reference;
447 x_reg_det_rec.att_timezone := p_reg_det_rec.att_timezone;
448 x_reg_det_rec.att_total_no_of_orders := p_reg_det_rec.att_total_no_of_orders;
449 x_reg_det_rec.att_total_order_amount := p_reg_det_rec.att_total_order_amount;
450 x_reg_det_rec.att_year_established := p_reg_det_rec.att_year_established;
451 x_reg_det_rec.att_url := p_reg_det_rec.att_url;
452 x_reg_det_rec.att_survey_notes := p_reg_det_rec.att_survey_notes;
453 x_reg_det_rec.att_contact_me_flag := p_reg_det_rec.att_contact_me_flag;
454 x_reg_det_rec.att_email_ok_flag := p_reg_det_rec.att_email_ok_flag;
455 x_reg_det_rec.update_reg_rec := p_reg_det_rec.update_reg_rec;
456
457 END transform_record;
458
459 END AMS_Dialog_Regs_PUB;