[Home] [Help]
PACKAGE: APPS.AMS_REGISTRANTS_PVT
Source
1 PACKAGE AMS_Registrants_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvevrs.pls 115.6 2002/11/22 23:37:10 dbiswas ship $ */
3 -- PACKAGE
4 -- AMS_Registrants_PVT
5 --
6 -- HISTORY
7 -- 12-MAR-2002 dcastlem Added support for general Public API
8 -- (AMS_Registrants_PUB)
9 -- 18-MAR-2002 dcastlem Cleaned up some code in B2B and added
10 -- org party id as an out parameter
11 -- 05-APR-2002 dcastlem Rewrote party_detail_rec_type to include all fields
12
13 /*
14 TYPE party_detail_rec_type IS RECORD(
15 PERSON_FIRST_NAME VARCHAR2(150):= FND_API.G_MISS_CHAR,
16 PERSON_MIDDLE_NAME VARCHAR2(60) := FND_API.G_MISS_CHAR,
17 PERSON_LAST_NAME VARCHAR2(150):= FND_API.G_MISS_CHAR,
18 PERSON_NAME_SUFFIX VARCHAR2(30) := FND_API.G_MISS_CHAR,
19 PERSON_TITLE VARCHAR2(60) := FND_API.G_MISS_CHAR,
20 PRE_NAME_ADJUNCT VARCHAR2(30) := FND_API.G_MISS_CHAR,
21 SALUTATION VARCHAR2(60) := FND_API.G_MISS_CHAR,
22
23 JOB_TITLE VARCHAR2(100) := FND_API.G_MISS_CHAR,
24 DECISION_MAKER_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
25 DEPARTMENT VARCHAR2(30) := FND_API.G_MISS_CHAR,
26 PARTY_NAME VARCHAR2(360) := FND_API.G_MISS_CHAR,
27 ORGANIZATION_NAME_PHONETIC VARCHAR2(320) := FND_API.G_MISS_CHAR,
28
29 BEST_TIME_CONTACT_BEGIN DATE := FND_API.G_MISS_DATE,
30 BEST_TIME_CONTACT_END DATE := FND_API.G_MISS_DATE,
31 COUNTRY VARCHAR2(60) := FND_API.G_MISS_CHAR,
32 ADDRESS1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
33 ADDRESS2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
34 CITY VARCHAR2(60) := FND_API.G_MISS_CHAR,
35 COUNTY VARCHAR2(60) := FND_API.G_MISS_CHAR,
36 STATE VARCHAR2(60) := FND_API.G_MISS_CHAR,
37 PROVINCE VARCHAR2(60) := FND_API.G_MISS_CHAR,
38 POSTAL_CODE VARCHAR2(60):= FND_API.G_MISS_CHAR,
39 TIME_ZONE VARCHAR2(50) := FND_API.G_MISS_CHAR,
40 ADDRESS3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
41 ADDRESS4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
42 ADDRESS_LINES_PHONETIC VARCHAR2(560) := FND_API.G_MISS_CHAR ,
43 APARTMENT_FLAG VARCHAR2(1):= FND_API.G_MISS_CHAR ,
44 PO_BOX_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
45 HOUSE_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
46 STREET_SUFFIX VARCHAR2(50):= FND_API.G_MISS_CHAR,
47 SECONDARY_SUFFIX_ELEMENT VARCHAR2(240) := FND_API.G_MISS_CHAR,
48 STREET VARCHAR2(50) := FND_API.G_MISS_CHAR,
49 RURAL_ROUTE_TYPE VARCHAR2(50) := FND_API.G_MISS_CHAR,
50 RURAL_ROUTE_NUMBER VARCHAR2(50) := FND_API.G_MISS_CHAR,
51 STREET_NUMBER VARCHAR2(50):= FND_API.G_MISS_CHAR,
52 FLOOR VARCHAR2(50):= FND_API.G_MISS_CHAR,
53 SUITE VARCHAR2(50) := FND_API.G_MISS_CHAR,
54 POSTAL_PLUS4_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
55 OVERSEAS_ADDRESS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
56 EMAIL_ADDRESS VARCHAR2(2000) := FND_API.G_MISS_CHAR ,
57 PHONE_COUNTRY_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
58 PHONE_AREA_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR,
59 PHONE_NUMBER VARCHAR2(40):= FND_API.G_MISS_CHAR,
60 PHONE_EXTENTION VARCHAR2(20) := FND_API.G_MISS_CHAR
61 );
62 */
63 TYPE party_detail_rec_type IS RECORD(
64 party_id NUMBER,
65 party_type VARCHAR2(30),
66 contact_id NUMBER,
67 party_name VARCHAR2(360),
68 title VARCHAR2(30),
69 first_name VARCHAR2(150),
70 middle_name VARCHAR2(60),
71 last_name VARCHAR2(150),
72 address1 VARCHAR2(240),
73 address2 VARCHAR2(240),
74 address3 VARCHAR2(240),
75 address4 VARCHAR2(240),
76 gender VARCHAR2(30),
77 address_line_phonetic VARCHAR2(360),
78 analysis_fy VARCHAR2(5),
79 apt_flag VARCHAR2(1),
80 best_time_contact_begin DATE,
81 best_time_contact_end DATE,
82 category_code VARCHAR2(30),
83 ceo_name VARCHAR2(360),
84 city VARCHAR2(60),
85 country VARCHAR2(60),
86 county VARCHAR2(60),
87 current_fy_potential_rev NUMBER,
88 next_fy_potential_rev NUMBER,
89 household_income NUMBER,
90 decision_maker_flag VARCHAR2(1),
91 department VARCHAR2(360),
92 dun_no_c VARCHAR2(30),
93 email_address VARCHAR2(2000),
94 employee_total NUMBER,
95 fy_end_month VARCHAR2(30),
96 floor VARCHAR2(50),
97 gsa_indicator_flag VARCHAR2(30),
98 house_number NUMBER,
99 identifying_address_flag VARCHAR2(1),
100 jgzz_fiscal_code VARCHAR2(20),
101 job_title VARCHAR2(100),
102 last_order_date DATE,
103 org_legal_status VARCHAR2(30),
104 line_of_business VARCHAR2(240),
105 mission_statement VARCHAR2(2000),
106 org_name_phonetic VARCHAR2(320),
107 overseas_address_flag VARCHAR2(1),
108 name_suffix VARCHAR2(30),
109 phone_area_code VARCHAR2(10),
110 phone_country_code VARCHAR2(10),
111 phone_extension VARCHAR2(20),
112 phone_number VARCHAR2(40),
113 postal_code VARCHAR2(60),
114 postal_plus4_code VARCHAR2(4),
115 po_box_no VARCHAR2(50),
116 province VARCHAR2(60),
117 rural_route_no VARCHAR2(50),
118 rural_route_type VARCHAR2(30),
119 secondary_suffix_element VARCHAR2(30),
120 sic_code VARCHAR2(30),
121 sic_code_type VARCHAR2(30),
122 site_use_code VARCHAR2(30),
123 state VARCHAR2(60),
124 street VARCHAR2(50),
125 street_number VARCHAR2(50),
126 street_suffix VARCHAR2(50),
127 suite VARCHAR2(50),
128 tax_name VARCHAR2(30),
129 tax_reference VARCHAR2(50),
130 timezone NUMBER,
131 total_no_of_orders NUMBER,
132 total_order_amount NUMBER,
133 year_established NUMBER,
134 url VARCHAR2(2000),
135 survey_notes VARCHAR2(240),
136 contact_me_flag VARCHAR2(1),
137 email_ok_flag VARCHAR2(1)
138
139 /*
140 PERSON_FIRST_NAME VARCHAR2(150),
141 PERSON_MIDDLE_NAME VARCHAR2(60) ,
142 PERSON_LAST_NAME VARCHAR2(150),
143 PERSON_NAME_SUFFIX VARCHAR2(30) ,
144 PERSON_TITLE VARCHAR2(60) ,
145 PRE_NAME_ADJUNCT VARCHAR2(30) ,
146 SALUTATION VARCHAR2(60),
147
148 JOB_TITLE VARCHAR2(100),
149 DECISION_MAKER_FLAG VARCHAR2(1),
150 DEPARTMENT VARCHAR2(30),
151 PARTY_NAME VARCHAR2(360) ,
152 ORGANIZATION_NAME_PHONETIC VARCHAR2(320) ,
153
154 BEST_TIME_CONTACT_BEGIN DATE ,
155 BEST_TIME_CONTACT_END DATE ,
156 COUNTRY VARCHAR2(60),
157 ADDRESS1 VARCHAR2(240) ,
158 ADDRESS2 VARCHAR2(240) ,
159 CITY VARCHAR2(60) ,
160 COUNTY VARCHAR2(60) ,
161 STATE VARCHAR2(60) ,
162 PROVINCE VARCHAR2(60) ,
163 POSTAL_CODE VARCHAR2(60),
164 TIME_ZONE VARCHAR2(50) ,
165 ADDRESS3 VARCHAR2(240) ,
166 ADDRESS4 VARCHAR2(240),
167 ADDRESS_LINES_PHONETIC VARCHAR2(560) ,
168 APARTMENT_FLAG VARCHAR2(1),
169 PO_BOX_NUMBER VARCHAR2(50) ,
170 HOUSE_NUMBER VARCHAR2(50),
171 STREET_SUFFIX VARCHAR2(50),
172 SECONDARY_SUFFIX_ELEMENT VARCHAR2(240) ,
173 STREET VARCHAR2(50) ,
174 RURAL_ROUTE_TYPE VARCHAR2(50) ,
175 RURAL_ROUTE_NUMBER VARCHAR2(50),
176 STREET_NUMBER VARCHAR2(50),
177 FLOOR VARCHAR2(50),
178 SUITE VARCHAR2(50) ,
179 POSTAL_PLUS4_CODE VARCHAR2(10),
180 OVERSEAS_ADDRESS_FLAG VARCHAR2(1),
181 EMAIL_ADDRESS VARCHAR2(2000) ,
182 PHONE_COUNTRY_CODE VARCHAR2(10) ,
183 PHONE_AREA_CODE VARCHAR2(10) ,
184 PHONE_NUMBER VARCHAR2(40),
185 PHONE_EXTENTION VARCHAR2(20)
186 */
187 );
188
189 ---------------------------------------------------------------------
190 -- PROCEDURE
191 -- find_a_party
192 --
193 -- PURPOSE
194 -- Find the party id of a party
195 --
196 -- PARAMETERS
197 -- p_party_rec: the new record contains parameter for a party
198 -- x_party_id: return the event_offer_id of the new event offer
199 --
200 -- NOTES
201
202 ---------------------------------------------------------------------
203
204 PROCEDURE find_a_party(
205 p_api_version IN NUMBER,
206 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
207 p_rec IN party_detail_rec_type,
208 x_return_status OUT NOCOPY VARCHAR2,
209 x_msg_count OUT NOCOPY NUMBER,
210 x_msg_data OUT NOCOPY VARCHAR2,
211 x_party_id OUT NOCOPY NUMBER
212 );
213
214 ---------------------------------------------------------------------
215 -- PROCEDURE
216 -- create_party
217 --
218 -- PURPOSE
219 -- Find the party id of a party
220 --
221 -- PARAMETERS
222 -- p_party_rec: the new record contains parameter for a party
223 -- x_party_id: return the event_offer_id of the new event offer
224 --
225 -- NOTES
226
227 ---------------------------------------------------------------------
228
229 PROCEDURE create_registrant_party(
230 p_api_version IN NUMBER,
231 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
232 p_commit IN VARCHAR2 := FND_API.g_false,
233 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
234 p_rec IN party_detail_rec_type,
235
236 x_return_status OUT NOCOPY VARCHAR2,
237 x_msg_count OUT NOCOPY NUMBER,
238 x_msg_data OUT NOCOPY VARCHAR2,
239
240 x_new_party_id OUT NOCOPY NUMBER,
241 x_new_org_party_id OUT NOCOPY NUMBER
242 );
243
244 ---------------------------------------------------------------------
245 -- PROCEDURE
246 -- get_party_id
247 --
248 -- PURPOSE
249 -- get the party id of a party
250 --
251 -- PARAMETERS
252 -- p_party_rec: the new record contains parameter for a party
253 -- x_party_id: return the event_offer_id of the new event offer
254 --
255 -- NOTES
256
257 ---------------------------------------------------------------------
258
259 PROCEDURE get_party_id(
260 p_api_version IN NUMBER,
261 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
262 p_commit IN VARCHAR2 := FND_API.g_false,
263 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
264 p_rec IN party_detail_rec_type,
265
266 x_return_status OUT NOCOPY VARCHAR2,
267 x_msg_count OUT NOCOPY NUMBER,
268 x_msg_data OUT NOCOPY VARCHAR2,
269
270 x_new_party_id OUT NOCOPY NUMBER,
271 x_new_org_party_id OUT NOCOPY NUMBER
272 );
273
274 --=================================================================================
275 --Function
276 -- Get_Event_Det
277 --
278 --Purpose
279 -- Function will return the Event id for the source code passed.
280 --
281 -- History
282 -- 24-Feb-2002 ptendulk Created
283 --
284 --=================================================================================
285 FUNCTION Get_Event_Det(p_source_code IN VARCHAR2)
286 RETURN NUMBER ;
287
288 END AMS_Registrants_PVT;