[Home] [Help]
PACKAGE: APPS.AMS_DIALOG_REGS_PUB
Source
1 PACKAGE AMS_Dialog_Regs_PUB AUTHID CURRENT_USER AS
2 /* $Header: amspders.pls 120.3 2006/08/16 05:23:00 rrajesh noship $ */
3
4 TYPE RegistrationDetails IS RECORD(
5 -- Who Columns
6 /*last_update_date DATE := FND_API.G_MISS_DATE,
7 last_updated_by NUMBER := FND_API.G_MISS_NUM,
8 creation_date DATE := FND_API.G_MISS_DATE,
9 created_by NUMBER := FND_API.G_MISS_NUM,
10 last_update_login NUMBER := FND_API.G_MISS_NUM,*/
11
12 last_update_date DATE,
13 last_updated_by NUMBER,
14 creation_date DATE,
15 created_by NUMBER,
16 last_update_login NUMBER,
17 -- Event Details
18 event_source_code VARCHAR2(100),
19 registration_source_type VARCHAR2(30),
20 attendance_flag VARCHAR2(1),
21 waitlisted_flag VARCHAR2(1),
22 cancellation_flag VARCHAR2(1),
23 cancellation_reason_code VARCHAR2(30),
24 confirmation_code VARCHAR2(30),
25 original_system_reference VARCHAR2(240),
26 --Registrants Details
27 reg_party_id NUMBER,
28 reg_party_type VARCHAR2(30),
29 reg_contact_id NUMBER,
30 reg_party_name VARCHAR2(360),
31 reg_title VARCHAR2(30),
32 reg_first_name VARCHAR2(150),
33 reg_middle_name VARCHAR2(60),
34 reg_last_name VARCHAR2(150),
35 reg_address1 VARCHAR2(240),
36 reg_address2 VARCHAR2(240),
37 reg_address3 VARCHAR2(240),
38 reg_address4 VARCHAR2(240),
39 reg_gender VARCHAR2(30),
40 reg_address_line_phonetic VARCHAR2(360),
41 reg_analysis_fy VARCHAR2(5),
42 reg_apt_flag VARCHAR2(1),
43 reg_best_time_contact_begin DATE,
44 reg_best_time_contact_end DATE,
45 reg_category_code VARCHAR2(30),
46 reg_ceo_name VARCHAR2(360),
47 reg_city VARCHAR2(60),
48 reg_country VARCHAR2(60),
49 reg_county VARCHAR2(60),
50 reg_current_fy_potential_rev NUMBER,
51 reg_next_fy_potential_rev NUMBER,
52 reg_household_income NUMBER,
53 reg_decision_maker_flag VARCHAR2(1),
54 reg_department VARCHAR2(360),
55 reg_dun_no_c VARCHAR2(30),
56 reg_email_address VARCHAR2(2000),
57 reg_employee_total NUMBER,
58 reg_fy_end_month VARCHAR2(30),
59 reg_floor VARCHAR2(50),
60 reg_gsa_indicator_flag VARCHAR2(30),
61 reg_house_number NUMBER,
62 reg_identifying_address_flag VARCHAR2(1),
63 reg_jgzz_fiscal_code VARCHAR2(20),
64 reg_job_title VARCHAR2(100),
65 reg_last_order_date DATE,
66 reg_org_legal_status VARCHAR2(30),
67 reg_line_of_business VARCHAR2(240),
68 reg_mission_statement VARCHAR2(2000),
69 reg_org_name_phonetic VARCHAR2(320),
70 reg_overseas_address_flag VARCHAR2(1),
71 reg_name_suffix VARCHAR2(30),
72 reg_phone_area_code VARCHAR2(10),
73 reg_phone_country_code VARCHAR2(10),
74 reg_phone_extension VARCHAR2(20),
75 reg_phone_number VARCHAR2(40),
76 reg_postal_code VARCHAR2(60),
77 reg_postal_plus4_code VARCHAR2(4),
78 reg_po_box_no VARCHAR2(50),
79 reg_province VARCHAR2(60),
80 reg_rural_route_no VARCHAR2(50),
81 reg_rural_route_type VARCHAR2(30),
82 reg_secondary_suffix_element VARCHAR2(30),
83 reg_sic_code VARCHAR2(30),
84 reg_sic_code_type VARCHAR2(30),
85 reg_site_use_code VARCHAR2(30),
86 reg_state VARCHAR2(60),
87 reg_street VARCHAR2(50),
88 reg_street_number VARCHAR2(50),
89 reg_street_suffix VARCHAR2(50),
90 reg_suite VARCHAR2(50),
91 reg_tax_name VARCHAR2(30),
92 reg_tax_reference VARCHAR2(50),
93 reg_timezone NUMBER,
94 reg_total_no_of_orders NUMBER,
95 reg_total_order_amount NUMBER,
96 reg_year_established NUMBER,
97 reg_url VARCHAR2(2000),
98 reg_survey_notes VARCHAR2(240),
99 reg_contact_me_flag VARCHAR2(1),
100 reg_email_ok_flag VARCHAR2(1),
101 -- Attendant Details
102 att_party_id NUMBER,
103 att_party_type VARCHAR2(30),
104 att_contact_id NUMBER,
105 att_party_name VARCHAR2(360),
106 att_title VARCHAR2(30),
107 att_first_name VARCHAR2(150),
108 att_middle_name VARCHAR2(60),
109 att_last_name VARCHAR2(150),
110 att_address1 VARCHAR2(240),
111 att_address2 VARCHAR2(240),
112 att_address3 VARCHAR2(240),
113 att_address4 VARCHAR2(240),
114 att_gender VARCHAR2(30),
115 att_address_line_phonetic VARCHAR2(360),
116 att_analysis_fy VARCHAR2(5),
117 att_apt_flag VARCHAR2(1),
118 att_best_time_contact_begin DATE,
119 att_best_time_contact_end DATE,
120 att_category_code VARCHAR2(30),
121 att_ceo_name VARCHAR2(360),
122 att_city VARCHAR2(60),
123 att_country VARCHAR2(60),
124 att_county VARCHAR2(60),
125 att_current_fy_potential_rev NUMBER,
126 att_next_fy_potential_rev NUMBER,
127 att_household_income NUMBER,
128 att_decision_maker_flag VARCHAR2(1),
129 att_department VARCHAR2(360),
130 att_dun_no_c VARCHAR2(30), -- Verify
131 att_email_address VARCHAR2(2000),
132 att_employee_total NUMBER,
133 att_fy_end_month VARCHAR2(30),
134 att_floor NUMBER, --Verify
135 att_gsa_indicator_flag VARCHAR2(30),
136 att_house_number NUMBER,
137 att_identifying_address_flag VARCHAR2(1),
138 att_jgzz_fiscal_code VARCHAR2(20),
139 att_job_title VARCHAR2(15), -- Verify
140 att_last_order_date DATE,
141 att_org_legal_status VARCHAR2(30), -- Verify
142 att_line_of_business VARCHAR2(360), -- Verify
143 att_mission_statement VARCHAR2(2000),
144 att_org_name_phonetic VARCHAR2(320),
145 att_overseas_address_flag VARCHAR2(1),
146 att_name_suffix VARCHAR2(30),
147 att_phone_area_code VARCHAR2(10),
148 att_phone_country_code VARCHAR2(10),
149 att_phone_extension VARCHAR2(20),
150 att_phone_number VARCHAR2(40),
151 att_postal_code VARCHAR2(60),
152 att_postal_plus4_code VARCHAR2(4),
153 att_po_box_no NUMBER, --Verity
154 att_province VARCHAR2(60),
155 att_rural_route_no VARCHAR2(60), --Verify
156 att_rural_route_type VARCHAR2(30),
157 att_secondary_suffix_element VARCHAR2(30),
158 att_sic_code VARCHAR2(30),
159 att_sic_code_type VARCHAR2(30),
160 att_site_use_code VARCHAR2(30), -- Verify
161 att_state VARCHAR2(60),
162 att_street VARCHAR2(30), -- Verify
163 att_street_number VARCHAR2(30), -- Verify
164 att_street_suffix VARCHAR2(30), -- Verify
165 att_suite VARCHAR2(30), -- Verify
166 att_tax_name VARCHAR2(30),
167 att_tax_reference VARCHAR2(50),
168 att_timezone NUMBER,
169 att_total_no_of_orders NUMBER,
170 att_total_order_amount NUMBER,
171 att_year_established NUMBER,
172 att_url VARCHAR2(2000),
173 att_survey_notes VARCHAR2(240),
174 att_contact_me_flag VARCHAR2(1),
175 att_email_ok_flag VARCHAR2(1),
176 update_reg_rec VARCHAR2(1)
177 );
178
179 --==============================================================================
180 -- Start of Comments
181 --==============================================================================
182 --API Name
183 -- Register
184 --Type
185 -- Public
186 --Pre-Req
187 --
188 --Parameters
189 --
190 --IN
191 -- p_api_version_number IN NUMBER Required
192 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
193 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
194 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
195 -- p_reg_det_rec IN RegistrationDetails Required
196 --
197 --OUT
198 -- x_return_status OUT VARCHAR2
199 -- x_msg_count OUT NUMBER
200 -- x_msg_data OUT VARCHAR2
201 -- x_confirm_code OUT VARCHAR2 (the confirmation code)
202 -- x_party_id OUT NUMBER (the attendant contact id - maps to a party_id in hz_parties)
203 -- x_system_status_code OUT VARCHAR2 (the status code of the registration)
204 --Version : Current version 1.0
205 --
206 --End of Comments
207 --==============================================================================
208 PROCEDURE Register( p_api_version_number IN NUMBER
209 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
210 , p_commit IN VARCHAR2 := FND_API.G_FALSE
211 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
212
213 , x_return_status OUT NOCOPY VARCHAR2
214 , x_msg_count OUT NOCOPY NUMBER
215 , x_msg_data OUT NOCOPY VARCHAR2
216
217 , p_reg_det_rec IN RegistrationDetails
218 , p_block_fulfillment IN VARCHAR2 := FND_API.G_TRUE
219 , p_owner_user_id IN NUMBER
220 , p_application_id IN NUMBER
221
222 , x_confirm_code OUT NOCOPY VARCHAR2
223 , x_party_id OUT NOCOPY NUMBER
224 , x_system_status_code OUT NOCOPY VARCHAR2
225 );
226
227 --==============================================================================
228 -- Start of Comments
229 --==============================================================================
230 --API Name
231 -- IsRegistered
232 --Type
233 -- Public
234 --Pre-Req
235 --
236 --Parameters
237 --
238 --IN
239 -- p_api_version_number IN NUMBER Required
240 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
241 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
242 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
243 -- p_confirm_code IN RegistrationDetails Required
244 --
245 --OUT
246 -- x_return_status OUT VARCHAR2
247 -- x_msg_count OUT NUMBER
248 -- x_msg_data OUT VARCHAR2
249 -- x_is_registered OUT VARCHAR2 ('Y' if registrant has status REGISTERED, 'N' otherwise)
250 --Version : Current version 1.0
251 --
252 --End of Comments
253 --==============================================================================
254 Procedure IsRegistered( p_api_version_number IN NUMBER
255 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
256 , p_commit IN VARCHAR2 := FND_API.G_FALSE
257 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
258
259 , x_return_status OUT NOCOPY VARCHAR2
260 , x_msg_count OUT NOCOPY NUMBER
261 , x_msg_data OUT NOCOPY VARCHAR2
262
263 , p_confirm_code IN VARCHAR2
264 , x_is_registered OUT NOCOPY VARCHAR2
265 );
266
267 END AMS_Dialog_Regs_PUB;