1 PACKAGE CAC_SYNC_CONTACT_MAPPINGS_PKG AUTHID CURRENT_USER AS
2 /* $Header: cacvscms.pls 120.1 2005/07/02 02:20:25 appldev noship $ */
3
4 PROCEDURE INSERT_ROW
5 ( x_rowid IN OUT NOCOPY VARCHAR2
6 , x_sync_contact_mapping_id IN NUMBER
7 , x_contact_party_id IN NUMBER
8 , x_org_party_id IN NUMBER
9 , x_person_party_id IN NUMBER
10 , x_party_site_id IN NUMBER
11 , x_work_contact_point_id IN NUMBER
12 , x_home_contact_point_id IN NUMBER
13 , x_fax_contact_point_id IN NUMBER
14 , x_cell_contact_point_id IN NUMBER
15 , x_pager_contact_point_id IN NUMBER
16 , x_email_contact_point_id IN NUMBER
17 , x_created_by IN NUMBER
18 , x_creation_date IN DATE
19 , x_last_updated_by IN NUMBER
20 , x_last_update_date IN DATE
21 , x_last_update_login IN NUMBER
22 );
23
24 PROCEDURE UPDATE_ROW
25 ( x_sync_contact_mapping_id IN NUMBER
26 , x_contact_party_id IN NUMBER
27 , x_org_party_id IN NUMBER
28 , x_person_party_id IN NUMBER
29 , x_party_site_id IN NUMBER
30 , x_work_contact_point_id IN NUMBER
31 , x_home_contact_point_id IN NUMBER
32 , x_fax_contact_point_id IN NUMBER
33 , x_cell_contact_point_id IN NUMBER
34 , x_pager_contact_point_id IN NUMBER
35 , x_email_contact_point_id IN NUMBER
36 , x_last_updated_by IN NUMBER
37 , x_last_update_date IN DATE
38 , x_last_update_login IN NUMBER
39 );
40
41 PROCEDURE DELETE_ROW(x_sync_contact_mapping_id IN NUMBER);
42
43 end CAC_SYNC_CONTACT_MAPPINGS_PKG;