[Home] [Help]
PACKAGE: APPS.AMS_REGISTRANTS_PUB
Source
1 PACKAGE AMS_Registrants_PUB AUTHID CURRENT_USER AS
2 /* $Header: amspevrs.pls 115.6 2003/02/05 19:31:19 soagrawa ship $ */
3
4 TYPE RegistrationDet 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 -- Event Details
12 event_source_code VARCHAR2(100),
13 registration_source_type VARCHAR2(30),
14 attendance_flag VARCHAR2(1),
15 waitlisted_flag VARCHAR2(1),
16 cancellation_flag VARCHAR2(1),
17 cancellation_reason_code VARCHAR2(30),
18 confirmation_code VARCHAR2(30),
19 original_system_reference VARCHAR2(240),
20 --Registrants Details
21 reg_party_id NUMBER,
22 reg_party_type VARCHAR2(30),
23 reg_contact_id NUMBER,
24 reg_party_name VARCHAR2(360),
25 reg_title VARCHAR2(30),
26 reg_first_name VARCHAR2(150),
27 reg_middle_name VARCHAR2(60),
28 reg_last_name VARCHAR2(150),
29 reg_address1 VARCHAR2(240),
30 reg_address2 VARCHAR2(240),
31 reg_address3 VARCHAR2(240),
32 reg_address4 VARCHAR2(240),
33 reg_gender VARCHAR2(30),
34 reg_address_line_phonetic VARCHAR2(360),
35 reg_analysis_fy VARCHAR2(5),
36 reg_apt_flag VARCHAR2(1),
37 reg_best_time_contact_begin DATE,
38 reg_best_time_contact_end DATE,
39 reg_category_code VARCHAR2(30),
40 reg_ceo_name VARCHAR2(360),
41 reg_city VARCHAR2(60),
42 reg_country VARCHAR2(60),
43 reg_county VARCHAR2(60),
44 reg_current_fy_potential_rev NUMBER,
45 reg_next_fy_potential_rev NUMBER,
46 reg_household_income NUMBER,
47 reg_decision_maker_flag VARCHAR2(1),
48 reg_department VARCHAR2(360),
49 reg_dun_no_c VARCHAR2(30),
50 reg_email_address VARCHAR2(2000),
51 reg_employee_total NUMBER,
52 reg_fy_end_month VARCHAR2(30),
53 reg_floor VARCHAR2(50),
54 reg_gsa_indicator_flag VARCHAR2(30),
55 reg_house_number NUMBER,
56 reg_identifying_address_flag VARCHAR2(1),
57 reg_jgzz_fiscal_code VARCHAR2(20),
58 reg_job_title VARCHAR2(100),
59 reg_last_order_date DATE,
60 reg_org_legal_status VARCHAR2(30),
61 reg_line_of_business VARCHAR2(240),
62 reg_mission_statement VARCHAR2(2000),
63 reg_org_name_phonetic VARCHAR2(320),
64 reg_overseas_address_flag VARCHAR2(1),
65 reg_name_suffix VARCHAR2(30),
66 reg_phone_area_code VARCHAR2(10),
67 reg_phone_country_code VARCHAR2(10),
68 reg_phone_extension VARCHAR2(20),
69 reg_phone_number VARCHAR2(40),
70 reg_postal_code VARCHAR2(60),
71 reg_postal_plus4_code VARCHAR2(4),
72 reg_po_box_no VARCHAR2(50),
73 reg_province VARCHAR2(60),
74 reg_rural_route_no VARCHAR2(50),
75 reg_rural_route_type VARCHAR2(30),
76 reg_secondary_suffix_element VARCHAR2(30),
77 reg_sic_code VARCHAR2(30),
78 reg_sic_code_type VARCHAR2(30),
79 reg_site_use_code VARCHAR2(30),
80 reg_state VARCHAR2(60),
81 reg_street VARCHAR2(50),
82 reg_street_number VARCHAR2(50),
83 reg_street_suffix VARCHAR2(50),
84 reg_suite VARCHAR2(50),
85 reg_tax_name VARCHAR2(30),
86 reg_tax_reference VARCHAR2(50),
87 reg_timezone NUMBER,
88 reg_total_no_of_orders NUMBER,
89 reg_total_order_amount NUMBER,
90 reg_year_established NUMBER,
91 reg_url VARCHAR2(2000),
92 reg_survey_notes VARCHAR2(240),
93 reg_contact_me_flag VARCHAR2(1),
94 reg_email_ok_flag VARCHAR2(1),
95 -- Attendent Details
96 att_party_id NUMBER,
97 att_party_type VARCHAR2(30),
98 att_contact_id NUMBER,
99 att_party_name VARCHAR2(360),
100 att_title VARCHAR2(30),
101 att_first_name VARCHAR2(150),
102 att_middle_name VARCHAR2(60),
103 att_last_name VARCHAR2(150),
104 att_address1 VARCHAR2(240),
105 att_address2 VARCHAR2(240),
106 att_address3 VARCHAR2(240),
107 att_address4 VARCHAR2(240),
108 att_gender VARCHAR2(30),
109 att_address_line_phonetic VARCHAR2(360),
110 att_analysis_fy VARCHAR2(5),
111 att_apt_flag VARCHAR2(1),
112 att_best_time_contact_begin DATE,
113 att_best_time_contact_end DATE,
114 att_category_code VARCHAR2(30),
115 att_ceo_name VARCHAR2(360),
116 att_city VARCHAR2(60),
117 att_country VARCHAR2(60),
118 att_county VARCHAR2(60),
119 att_current_fy_potential_rev NUMBER,
120 att_next_fy_potential_rev NUMBER,
121 att_household_income NUMBER,
122 att_decision_maker_flag VARCHAR2(1),
123 att_department VARCHAR2(360),
124 att_dun_no_c VARCHAR2(30), -- Verify
125 att_email_address VARCHAR2(2000),
126 att_employee_total NUMBER,
127 att_fy_end_month VARCHAR2(30),
128 att_floor NUMBER, --Verify
129 att_gsa_indicator_flag VARCHAR2(30),
130 att_house_number NUMBER,
131 att_identifying_address_flag VARCHAR2(1),
132 att_jgzz_fiscal_code VARCHAR2(20),
133 att_job_title VARCHAR2(15), -- Verify
134 att_last_order_date DATE,
135 att_org_legal_status VARCHAR2(30), -- Verify
136 att_line_of_business VARCHAR2(360), -- Verify
137 att_mission_statement VARCHAR2(2000),
138 att_org_name_phonetic VARCHAR2(320),
139 att_overseas_address_flag VARCHAR2(1),
140 att_name_suffix VARCHAR2(30),
141 att_phone_area_code VARCHAR2(10),
142 att_phone_country_code VARCHAR2(10),
143 att_phone_extension VARCHAR2(20),
144 att_phone_number VARCHAR2(40),
145 att_postal_code VARCHAR2(60),
146 att_postal_plus4_code VARCHAR2(4),
147 att_po_box_no NUMBER, --Verity
148 att_province VARCHAR2(60),
149 att_rural_route_no VARCHAR2(60), --Verify
150 att_rural_route_type VARCHAR2(30),
151 att_secondary_suffix_element VARCHAR2(30),
152 att_sic_code VARCHAR2(30),
153 att_sic_code_type VARCHAR2(30),
154 att_site_use_code VARCHAR2(30), -- Verify
155 att_state VARCHAR2(60),
156 att_street VARCHAR2(30), -- Verify
157 att_street_number VARCHAR2(30), -- Verify
158 att_street_suffix VARCHAR2(30), -- Verify
159 att_suite VARCHAR2(30), -- Verify
160 att_tax_name VARCHAR2(30),
161 att_tax_reference VARCHAR2(50),
162 att_timezone NUMBER,
163 att_total_no_of_orders NUMBER,
164 att_total_order_amount NUMBER,
165 att_year_established NUMBER,
166 att_url VARCHAR2(2000),
167 att_survey_notes VARCHAR2(240),
168 att_contact_me_flag VARCHAR2(1),
169 att_email_ok_flag VARCHAR2(1),
170 -- soagrawa 03-feb-2003 : Possible values:
171 -- Y : Default value - always update
172 -- N : Never update, throw an error back
173 -- C : Never update, always create new row - for multiple slots
174 update_reg_rec VARCHAR2(1)
175 );
176
177 --==============================================================================
178 -- Start of Comments
179 --==============================================================================
180 --API Name
181 -- Register
182 --Type
183 -- Public
184 --Pre-Req
185 --
186 --Parameters
187 --
188 --IN
189 -- p_api_version_number IN NUMBER Required
190 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
191 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
192 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
193 -- p_reg_det_rec IN RegistrationDet Required
194 --
195 --OUT
196 -- x_return_status OUT VARCHAR2
197 -- x_msg_count OUT NUMBER
198 -- x_msg_data OUT VARCHAR2
199 --Version : Current version 1.0
200 --
201 --End of Comments
202 --==============================================================================
203 --
204
205 PROCEDURE Register(
206 p_api_version_number IN NUMBER,
207 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
208 p_commit IN VARCHAR2 := FND_API.G_FALSE,
209 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
210
211 x_return_status OUT NOCOPY VARCHAR2,
212 x_msg_count OUT NOCOPY NUMBER,
213 x_msg_data OUT NOCOPY VARCHAR2,
214
215 p_reg_det_rec IN RegistrationDet ,
216 p_block_fulfillment IN VARCHAR2 := FND_API.G_FALSE,
217 p_owner_user_id IN NUMBER,
218 p_application_id IN NUMBER,
219 x_confirm_code OUT NOCOPY VARCHAR2
220 );
221
222 END AMS_Registrants_PUB;