DBA Data[Home] [Help]

PACKAGE: APPS.HZ_BUSINESS_EVENT_V2PVT

Source


1 PACKAGE hz_business_event_v2pvt AS
2 /*$Header: ARH2BESS.pls 120.9 2006/03/24 07:27:30 svemuri ship $ */
3 
4 
5 -- HZ_PARTY_V2PUB
6 
7   PROCEDURE create_person_event (
8     p_person_rec           IN     hz_party_v2pub.person_rec_type
9   );
10 
11   PROCEDURE update_person_event (
12     p_person_rec           IN     hz_party_v2pub.person_rec_type,
13     p_old_person_rec       IN     hz_party_v2pub.person_rec_type
14   );
15 
16   PROCEDURE create_group_event (
17     p_group_rec            IN     hz_party_v2pub.group_rec_type
18   );
19 
20   PROCEDURE update_group_event (
21     p_group_rec            IN     hz_party_v2pub.group_rec_type,
22     p_old_group_rec        IN     hz_party_v2pub.group_rec_type
23   );
24 
25   PROCEDURE create_organization_event (
26     p_organization_rec     IN     hz_party_v2pub.organization_rec_type
27   );
28 
29   PROCEDURE update_organization_event (
30     p_organization_rec     IN     hz_party_v2pub.organization_rec_type,
31     p_old_organization_rec IN     hz_party_v2pub.organization_rec_type
32   );
33 
34   -- HZ_RELATIONSHIP_V2PUB
35 
36   PROCEDURE create_relationship_event (
37     p_relationship_rec     IN     hz_relationship_v2pub.relationship_rec_type,
38     p_party_created        IN     VARCHAR2
39   );
40 
41   PROCEDURE update_relationship_event (
42     p_relationship_rec     IN     hz_relationship_v2pub.relationship_rec_type,
43     p_old_relationship_rec IN     hz_relationship_v2pub.relationship_rec_type
44   );
45 
46   -- HZ_PARTY_SITE_V2PUB
47 
48   PROCEDURE create_party_site_event (
49     p_party_site_rec       IN     hz_party_site_v2pub.party_site_rec_type
50   );
51 
52   PROCEDURE update_party_site_event (
53     p_party_site_rec       IN     hz_party_site_v2pub.party_site_rec_type,
54     p_old_party_site_rec   IN     hz_party_site_v2pub.party_site_rec_type
55   );
56 
57   PROCEDURE create_party_site_use_event (
58     p_party_site_use_rec   IN     hz_party_site_v2pub.party_site_use_rec_type
59   );
60 
61   PROCEDURE update_party_site_use_event (
62     p_party_site_use_rec       IN     hz_party_site_v2pub.party_site_use_rec_type,
63     p_old_party_site_use_rec   IN     hz_party_site_v2pub.party_site_use_rec_type
64 );
65 
66   -- HZ_PARTY_CONTACT_V2PUB
67 
68   PROCEDURE create_org_contact_event (
69     p_org_contact_rec      IN     hz_party_contact_v2pub.org_contact_rec_type
70 
71   );
72 
73   PROCEDURE update_org_contact_event (
74     p_org_contact_rec      IN     hz_party_contact_v2pub.org_contact_rec_type,
75     p_old_org_contact_rec  IN     hz_party_contact_v2pub.org_contact_rec_type
76   );
77 
78   PROCEDURE create_org_contact_role_event (
79     p_org_contact_role_rec IN hz_party_contact_v2pub.org_contact_role_rec_type
80   );
81 
82   PROCEDURE update_org_contact_role_event (
83     p_org_contact_role_rec      IN hz_party_contact_v2pub.org_contact_role_rec_type,
84     p_old_org_contact_role_rec  IN hz_party_contact_v2pub.org_contact_role_rec_type
85   );
86 
87   --HZ_LOCATION_V2PUB
88 
89   PROCEDURE create_location_event (
90     p_location_rec         IN     hz_location_v2pub.location_rec_type
91   );
92 
93   PROCEDURE update_location_event (
94     p_location_rec         IN     hz_location_v2pub.location_rec_type,
95     p_old_location_rec     IN     hz_location_v2pub.location_rec_type
96   );
97 
98   -- HZ_CONTACT_POINT_V2PUB
99 
100   -- Bug 2116225: Bank consolidation support.  The next two declarations are
101   -- new for bank support.
102   PROCEDURE create_contact_point_event (
103     p_contact_point_rec     IN   hz_contact_point_v2pub.contact_point_rec_type,
104     p_edi_rec               IN   hz_contact_point_v2pub.edi_rec_type,
105     p_eft_rec               IN   hz_contact_point_v2pub.eft_rec_type,
106     p_email_rec             IN   hz_contact_point_v2pub.email_rec_type,
107     p_phone_rec             IN   hz_contact_point_v2pub.phone_rec_type,
108     p_telex_rec             IN   hz_contact_point_v2pub.telex_rec_type,
109     p_web_rec               IN   hz_contact_point_v2pub.web_rec_type
110   );
111 
112   PROCEDURE update_contact_point_event (
113     p_contact_point_rec     IN   hz_contact_point_v2pub.contact_point_rec_type,
114     p_old_contact_point_rec IN   hz_contact_point_v2pub.contact_point_rec_type,
115     p_edi_rec               IN   hz_contact_point_v2pub.edi_rec_type,
116     p_old_edi_rec           IN   hz_contact_point_v2pub.edi_rec_type,
117     p_eft_rec               IN   hz_contact_point_v2pub.eft_rec_type,
118     p_old_eft_rec           IN   hz_contact_point_v2pub.eft_rec_type,
119     p_email_rec             IN   hz_contact_point_v2pub.email_rec_type,
120     p_old_email_rec         IN   hz_contact_point_v2pub.email_rec_type,
121     p_phone_rec             IN   hz_contact_point_v2pub.phone_rec_type,
122     p_old_phone_rec         IN   hz_contact_point_v2pub.phone_rec_type,
123     p_telex_rec             IN   hz_contact_point_v2pub.telex_rec_type,
124     p_old_telex_rec         IN   hz_contact_point_v2pub.telex_rec_type,
125     p_web_rec               IN   hz_contact_point_v2pub.web_rec_type,
126     p_old_web_rec           IN   hz_contact_point_v2pub.web_rec_type
127   );
128 
129 
130   -- HZ_CONTACT_PREFERENCE_V2PUB
131 
132   PROCEDURE create_contact_prefer_event (
133     p_contact_preference_rec IN hz_contact_preference_v2pub.contact_preference_rec_type
134   );
135 
136   PROCEDURE update_contact_prefer_event (
137     p_contact_preference_rec     IN hz_contact_preference_v2pub.contact_preference_rec_type,
138     p_old_contact_preference_rec IN hz_contact_preference_v2pub.contact_preference_rec_type
139   );
140 
141   -- HZ_CUST_ACCOUNT_V2PUB
142 
143   PROCEDURE create_cust_account_event (
144     p_cust_account_rec       IN  hz_cust_account_v2pub.cust_account_rec_type,
145     p_person_rec             IN  hz_party_v2pub.person_rec_type,
146     p_customer_profile_rec   IN  hz_customer_profile_v2pub.customer_profile_rec_type,
147     p_create_profile_amt     IN  VARCHAR2
148   );
149 
150   PROCEDURE create_cust_account_event (
151     p_cust_account_rec       IN  hz_cust_account_v2pub.cust_account_rec_type,
152     p_organization_rec       IN  hz_party_v2pub.organization_rec_type,
153     p_customer_profile_rec   IN  hz_customer_profile_v2pub.customer_profile_rec_type,
154     p_create_profile_amt     IN  VARCHAR2
155   );
156 
157   PROCEDURE update_cust_account_event (
158     p_cust_account_rec       IN  hz_cust_account_v2pub.cust_account_rec_type,
159     p_old_cust_account_rec   IN  hz_cust_account_v2pub.cust_account_rec_type
160   );
161 
162   PROCEDURE create_cust_acct_relate_event (
163     p_cust_acct_relate_rec IN hz_cust_account_v2pub.cust_acct_relate_rec_type
164   );
165 
166   PROCEDURE update_cust_acct_relate_event (
167     p_cust_acct_relate_rec     IN hz_cust_account_v2pub.cust_acct_relate_rec_type,
168     p_old_cust_acct_relate_rec IN hz_cust_account_v2pub.cust_acct_relate_rec_type
169   );
170 
171   -- HZ_CUSTOMER_PROFILE_V2PUB
172 
173   PROCEDURE create_customer_profile_event (
174     p_customer_profile_rec   IN  hz_customer_profile_v2pub.customer_profile_rec_type,
175     p_create_profile_amt     IN  VARCHAR2
176   );
177 
178   PROCEDURE update_customer_profile_event (
179     p_customer_profile_rec       IN  hz_customer_profile_v2pub.customer_profile_rec_type,
180     p_old_customer_profile_rec   IN  hz_customer_profile_v2pub.customer_profile_rec_type
181   );
182 
183   PROCEDURE create_cust_profile_amt_event (
184     p_cust_profile_amt_rec   IN  hz_customer_profile_v2pub.cust_profile_amt_rec_type
185   );
186 
187   PROCEDURE update_cust_profile_amt_event (
188     p_cust_profile_amt_rec       IN  hz_customer_profile_v2pub.cust_profile_amt_rec_type,
189     p_old_cust_profile_amt_rec   IN  hz_customer_profile_v2pub.cust_profile_amt_rec_type
190   );
191 
192   -- HZ_CUST_ACCOUNT_SITE_V2PUB
193 
194   PROCEDURE create_cust_acct_site_event (
195     p_cust_acct_site_rec IN hz_cust_account_site_v2pub.cust_acct_site_rec_type
196   );
197 
198   PROCEDURE update_cust_acct_site_event (
199     p_cust_acct_site_rec     IN hz_cust_account_site_v2pub.cust_acct_site_rec_type,
200     p_old_cust_acct_site_rec IN hz_cust_account_site_v2pub.cust_acct_site_rec_type
201   );
202 
203   PROCEDURE create_cust_site_use_event (
204     p_cust_site_use_rec    IN     hz_cust_account_site_v2pub.cust_site_use_rec_type,
205     p_customer_profile_rec IN     hz_customer_profile_v2pub.customer_profile_rec_type,
206     p_create_profile       IN     VARCHAR2,
207     p_create_profile_amt   IN     VARCHAR2
208   );
209 
210   PROCEDURE update_cust_site_use_event (
211     p_cust_site_use_rec     IN hz_cust_account_site_v2pub.cust_site_use_rec_type,
212     p_old_cust_site_use_rec IN hz_cust_account_site_v2pub.cust_site_use_rec_type
213   );
214 
215   -- HZ_CUST_ACCOUNT_ROLE_V2PUB
216 
217   PROCEDURE create_cust_account_role_event (
218     p_cust_account_role_rec   IN    hz_cust_account_role_v2pub.cust_account_role_rec_type
219   );
220 
221   PROCEDURE update_cust_account_role_event (
222     p_cust_account_role_rec     IN     hz_cust_account_role_v2pub.cust_account_role_rec_type,
223     p_old_cust_account_role_rec IN     hz_cust_account_role_v2pub.cust_account_role_rec_type
224   );
225 
226   PROCEDURE create_role_resp_event (
227     p_role_responsibility_rec IN     hz_cust_account_role_v2pub.role_responsibility_rec_type
228   );
229 
230   PROCEDURE update_role_resp_event (
231     p_role_responsibility_rec     IN     hz_cust_account_role_v2pub.role_responsibility_rec_type,
232     p_old_role_responsibility_rec IN     hz_cust_account_role_v2pub.role_responsibility_rec_type
233   );
234 
235   -- HZ_CLASSIFICATION_V2PUB
236 
237   PROCEDURE create_class_category_event (
238     p_class_category_rec          IN     hz_classification_v2pub.class_category_rec_type
239   );
240 
241   PROCEDURE update_class_category_event (
242     p_class_category_rec          IN     hz_classification_v2pub.class_category_rec_type,
243     p_old_class_category_rec      IN     hz_classification_v2pub.class_category_rec_type
244   );
245 
246   PROCEDURE create_class_code_event (
247     p_class_code_rec          IN     hz_classification_v2pub.class_code_rec_type
248   );
249 
250   PROCEDURE update_class_code_event (
251     p_class_code_rec          IN     hz_classification_v2pub.class_code_rec_type,
252     p_old_class_code_rec      IN     hz_classification_v2pub.class_code_rec_type
253   );
254 
255   PROCEDURE create_class_code_rel_event (
256     p_class_code_relation_rec     IN     hz_classification_v2pub.class_code_relation_rec_type
257   );
258 
259   PROCEDURE update_class_code_rel_event (
260     p_class_code_relation_rec     IN     hz_classification_v2pub.class_code_relation_rec_type,
261     p_old_class_code_relation_rec IN     hz_classification_v2pub.class_code_relation_rec_type
262   );
263 
264   PROCEDURE create_code_assignment_event (
265     p_code_assignment_rec         IN     hz_classification_v2pub.code_assignment_rec_type
266   );
267 
268   PROCEDURE update_code_assignment_event (
269     p_code_assignment_rec         IN     hz_classification_v2pub.code_assignment_rec_type,
270     p_old_code_assignment_rec     IN     hz_classification_v2pub.code_assignment_rec_type
271   );
272 
273   PROCEDURE create_class_cat_use_event (
274     p_class_category_use_rec      IN     hz_classification_v2pub.class_category_use_rec_type
275   );
276 
277   PROCEDURE update_class_cat_use_event (
278     p_class_category_use_rec      IN     hz_classification_v2pub.class_category_use_rec_type,
279     p_old_class_category_use_rec  IN     hz_classification_v2pub.class_category_use_rec_type
280   );
281 
282   -- HZ_PERSON_INFO_V2PUB
283 
284   PROCEDURE create_person_language_event (
285     p_person_language_rec  IN     hz_person_info_v2pub.person_language_rec_type
286   );
287 
288   PROCEDURE update_person_language_event (
289     p_person_language_rec     IN     hz_person_info_v2pub.person_language_rec_type,
290     p_old_person_language_rec IN     hz_person_info_v2pub.person_language_rec_type
291   );
292 
293   PROCEDURE create_citizenship_event (
294     p_citizenship_rec     IN     hz_person_info_v2pub.citizenship_rec_type
295   );
296 
297   PROCEDURE update_citizenship_event (
298     p_citizenship_rec     IN     hz_person_info_v2pub.citizenship_rec_type,
299     p_old_citizenship_rec IN     hz_person_info_v2pub.citizenship_rec_type
300   );
301 
302   PROCEDURE create_education_event (
303      p_education_rec      IN     hz_person_info_v2pub.education_rec_type
304 
305   );
306 
307   PROCEDURE update_education_event (
308      p_education_rec      IN     hz_person_info_v2pub.education_rec_type,
309      p_old_education_rec  IN     hz_person_info_v2pub.education_rec_type
310   );
311 
312   PROCEDURE create_emp_history_event (
313      p_emp_history_rec    IN     hz_person_info_v2pub.employment_history_rec_type
314 
315   );
316 
317   PROCEDURE update_emp_history_event (
318      p_emp_history_rec     IN     hz_person_info_v2pub.employment_history_rec_type,
319      p_old_emp_history_rec IN     hz_person_info_v2pub.employment_history_rec_type
320 
321   );
322 
323   PROCEDURE create_person_interest_event (
324      p_per_interest_rec     IN    hz_person_info_v2pub.person_interest_rec_type
325   );
326 
327   PROCEDURE update_person_interest_event  (
328      p_per_interest_rec     IN    hz_person_info_v2pub.person_interest_rec_type,
329      p_old_per_interest_rec IN    hz_person_info_v2pub.person_interest_rec_type
330   );
331 
332   PROCEDURE create_work_class_event   (
333      p_work_class_rec          IN    hz_person_info_v2pub.work_class_rec_type
334   );
335 
336   PROCEDURE update_work_class_event  (
337       p_work_class_rec         IN    hz_person_info_v2pub.work_class_rec_type,
338       p_old_work_class_rec     IN    hz_person_info_v2pub.work_class_rec_type
339   );
340 
341 
342   -- HZ_CUST_ACCT_INFO_PUB
343 /* Bug No : 4580024
344 
345   PROCEDURE create_bill_pref_event
346   ( p_billing_preferences_rec   IN hz_cust_acct_info_pub.billing_preferences_rec_type);
347 
348   PROCEDURE update_bill_pref_event
349   ( p_billing_preferences_rec   IN hz_cust_acct_info_pub.billing_preferences_rec_type);
350 
351   PROCEDURE create_bank_acct_uses_event
352   ( p_bank_acct_uses_rec   IN  hz_cust_acct_info_pub.bank_acct_uses_rec_type );
353 
354   PROCEDURE update_bank_acct_uses_event
355   ( p_bank_acct_uses_rec   IN  hz_cust_acct_info_pub.bank_acct_uses_rec_type );
356 
357   PROCEDURE create_suspension_act_event
358   ( p_suspension_activity_rec   IN  hz_cust_acct_info_pub.suspension_activity_rec_type );
359 
360   PROCEDURE update_suspension_act_event
361   ( p_suspension_activity_rec   IN  hz_cust_acct_info_pub.suspension_activity_rec_type );
362 
363 Bug No : 4580024 */
364 
365   -- HZ_ORG_INFO_PUB
366 
367   PROCEDURE create_stock_markets_event
368   ( p_stock_markets_rec IN hz_org_info_pub.stock_markets_rec_type );
369 
370   PROCEDURE update_stock_markets_event
371   ( p_stock_markets_rec IN hz_org_info_pub.stock_markets_rec_type );
372 
373   PROCEDURE create_sec_issued_event
374   ( p_security_issued_rec IN hz_org_info_pub.security_issued_rec_type );
375 
376   PROCEDURE update_sec_issued_event
377   ( p_security_issued_rec IN hz_org_info_pub.security_issued_rec_type );
378 
379   PROCEDURE create_fin_reports_event
380   ( p_financial_reports_rec IN hz_organization_info_v2pub.financial_report_rec_type );
381 
382   PROCEDURE update_fin_reports_event
383   ( p_financial_reports_rec IN hz_organization_info_v2pub.financial_report_rec_type,
384     p_old_financial_reports_rec IN hz_organization_info_v2pub.financial_report_rec_type );
385 
386   PROCEDURE create_fin_numbers_event
390   ( p_financial_numbers_rec IN hz_organization_info_v2pub.financial_number_rec_type,
387   ( p_financial_numbers_rec IN hz_organization_info_v2pub.financial_number_rec_type );
388 
389   PROCEDURE update_fin_numbers_event
391     p_old_financial_numbers_rec IN hz_organization_info_v2pub.financial_number_rec_type );
392 
393   PROCEDURE create_certifications_event
394   ( p_certifications_rec IN hz_org_info_pub.certifications_rec_type );
395 
396   PROCEDURE update_certifications_event
397   ( p_certifications_rec IN hz_org_info_pub.certifications_rec_type );
398 
399 
400   -- hz_party_info_v2pub
401 
402   PROCEDURE create_credit_ratings_event
403   (p_credit_ratings_rec IN hz_party_info_v2pub.credit_rating_rec_type);
404 
405   PROCEDURE update_credit_ratings_event
406   (p_credit_ratings_rec IN hz_party_info_v2pub.credit_rating_rec_type,
407    p_old_credit_ratings_rec IN hz_party_info_v2pub.credit_rating_rec_type);
408 
409   PROCEDURE create_fin_profile_event
410   (p_financial_profile_rec IN hz_party_info_pub.financial_profile_rec_type);
411 
412   PROCEDURE update_fin_profile_event
416 
413   (p_financial_profile_rec IN hz_party_info_pub.financial_profile_rec_type);
414 
415   -- hz_orig_system_reference
417    PROCEDURE create_orig_system_ref_event (
418     p_orig_sys_reference_rec	  IN HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE
419   );
420 
421   PROCEDURE update_orig_system_ref_event (
422     p_orig_sys_reference_rec	  IN HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE,
426 
423     p_old_orig_sys_reference_re   IN HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE
424   );
425 
427 END hz_business_event_v2pvt;