1 PACKAGE CAC_SYNC_CONTACTS_PVT AUTHID CURRENT_USER as
2 /* $Header: cacvscts.pls 120.1.12000000.1 2007/01/18 16:23:04 appldev ship $ */
3 /*#
4 * This package is used to perform fast and slow synchronization.
5 *
6 * @rep:scope private
7 * @rep:product CAC
8 * @rep:lifecycle active
9 * @rep:displayname Contact Synchronization API
10 * @rep:compatibility N
11 * @rep:category BUSINESS_ENTITY CAC_SYNC_SERVER
12 */
13
14 /*******************************************************************************
15 ** Private APIs
16 *******************************************************************************/
17
18 /**
19 * This function formats the phone number and returns formatted phone number
20 * by calling CAC_SYNC_CONTACT_UTIL_PVT.format_phone().
21 *
22 * @param p_country_code phone country code
23 * @param p_area_code area code
24 * @param p_phone_number phone number
25 * @param p_phone_extension extension number
26 * @return The formatted phone number
27 * @rep:displayname Format Phone
28 * @rep:lifecycle active
29 * @rep:compatibility N
30 */
31 FUNCTION FORMAT_PHONE
32 (
33 p_country_code IN VARCHAR2
34 , p_area_code IN VARCHAR2
35 , p_phone_number IN VARCHAR2
36 , p_phone_extension IN VARCHAR2 DEFAULT NULL
37 ) RETURN VARCHAR2;
38
39
40 /**
41 * This procedure is executed to retrieve contacts modified since last sync.
42 * It performs a fetch from HZ tables based on the timestamp and
43 * populates the CAC_SYNC_CONTACT_TEMPS table.
44 *
45 * @param p_api_version an api version i.e 1.0
46 * @param p_init_msg_list a message initialization flag
47 * @param p_principal_id a principal id
48 * @param p_person_party_id a person party id
49 * @param p_sync_anchor a sync anchor
50 * @return Returns a status, the number of messages and an error message
51 * @rep:displayname Prepare Fast Sync
52 * @rep:lifecycle active
53 * @rep:compatibility N
54 */
55 PROCEDURE PREPARE_FASTSYNC
56 (
57 p_api_version IN NUMBER -- Standard version parameter
58 , p_init_msg_list IN VARCHAR2 DEFAULT NULL -- Standard message initialization flag
59 , p_principal_id IN NUMBER -- Principal ID
60 , p_person_party_id IN NUMBER -- Person Party ID
61 , p_sync_anchor IN DATE -- Timestamp for sync anchor
62 , x_return_status OUT NOCOPY VARCHAR2 -- Standard API return status parameter
63 , x_msg_count OUT NOCOPY NUMBER -- Standard return parameter for the no of msgs in the stack
64 , x_msg_data OUT NOCOPY VARCHAR2 -- Standard return parameter for the msgs in the stack
65 );
66
67 /**
68 * This procedure is executed to retrieve contacts modified since last sync.
69 * It performs a fetch from HZ tables for all synchronoxable contact records
70 * and populates the CAC_SYNC_CONTACT_TEMPS table.
71 *
72 * @param p_api_version an api version i.e 1.0
73 * @param p_init_msg_list a message initialization flag
74 * @param p_person_party_id a person party id
75 * @return Returns a status, the number of messages and an error message
76 * @rep:displayname Prepare Slow Sync
77 * @rep:lifecycle active
78 * @rep:compatibility N
79 */
80 PROCEDURE PREPARE_SLOWSYNC
81 (
82 p_api_version IN NUMBER -- Standard version parameter
83 , p_init_msg_list IN VARCHAR2 DEFAULT NULL -- Standard message initialization flag
84 , p_person_party_id IN NUMBER -- Person Party ID
85 , x_return_status OUT NOCOPY VARCHAR2 -- Standard API return status parameter
86 , x_msg_count OUT NOCOPY NUMBER -- Standard return parameter for the no of msgs in the stack
87 , x_msg_data OUT NOCOPY VARCHAR2 -- Standard return parameter for the msgs in the stack
88 );
89
90 SERVER_URI_CONST CONSTANT cac_sync_mappings.server_uri%TYPE := './contacts';
91
92 END CAC_SYNC_CONTACTS_PVT;