[Home] [Help]
PACKAGE: APPS.CAC_SYNC_CONTACT_DQM_PVT
Source
1 PACKAGE CAC_SYNC_CONTACT_DQM_PVT AUTHID CURRENT_USER as
2 /* $Header: cacvscqs.pls 120.2 2005/08/09 20:59:21 cijang noship $ */
3 /*#
4 * This package is used to perform DQM check.
5 * @rep:scope private
6 * @rep:product CAC
7 * @rep:lifecycle active
8 * @rep:displayname Contact Synchronization DQM API
9 * @rep:compatibility N
10 * @rep:category BUSINESS_ENTITY CAC_SYNC_SERVER
11 */
12
13 /**
14 * This procedure is used to find a matching organizaiton through DQM check.
15 * @param p_init_msg_list message list initialization flag
16 * @param p_organization_name organization name
17 * @param p_contact_name contact name
18 * @param x_organization_id organization id
19 * @param x_return_status return status
20 * @param x_msg_count message count
21 * @param x_msg_data message data
22 * @rep:displayname Find Organization
23 * @rep:lifecycle active
24 * @rep:compatibility N
25 */
26 PROCEDURE FIND_ORGANIZATION
27 ( p_init_msg_list IN VARCHAR2 DEFAULT NULL
28 , p_organization_name IN VARCHAR2
29 , p_contact_name IN VARCHAR2
30 , x_organization_id OUT NOCOPY NUMBER
31 , x_return_status OUT NOCOPY VARCHAR2
32 , x_msg_count OUT NOCOPY NUMBER
33 , x_msg_data OUT NOCOPY VARCHAR2
34 );
35
36 /**
37 * This procedure performs DQM check.
38 * @param p_init_msg_list initialize message list
39 * @param p_org_party_id organization party id
40 * @param p_person_full_name person full name
41 * @param p_person_first_name person first name
42 * @param p_person_last_name person last name
43 * @param p_person_middle_name person middle nameIN VARCHAR2
44 * @param p_person_name_suffix person suffix
45 * @param p_person_title person title
46 * @param p_job_title job title
47 * @param p_work_phone_country_code work phone country code
48 * @param p_work_phone_area_code work phone area code
49 * @param p_work_phone_number work phone number
50 * @param p_home_phone_country_code home phone country code
51 * @param p_home_phone_area_code home phone area code
52 * @param p_home_phone_number home phone number
53 * @param p_fax_phone_country_code fax phone country code
54 * @param p_fax_phone_area_code fax phone area code
55 * @param p_fax_phone_number fax phone number
56 * @param p_pager_phone_country_code pager country code
57 * @param p_pager_phone_area_code pager phone area code
58 * @param p_pager_phone_number pager phone number
59 * @param p_cell_phone_country_code cell phone country code
60 * @param p_cell_phone_area_code cell phone area code
61 * @param p_cell_phone_number cell phone number
62 * @param p_text_email_address email address
63 * @param p_html_email_address email address
64 * @param x_return_status return status
65 * @param x_msg_count message count
66 * @param x_msg_data message data
67 * @rep:displayname Check Contact
68 * @rep:lifecycle active
69 * @rep:compatibility N
70 */
71 PROCEDURE CHECK_CONTACT
72 ( p_init_msg_list IN VARCHAR2 DEFAULT NULL
73 , p_org_party_id IN NUMBER
74 , p_organization_name IN VARCHAR2
75 , p_person_full_name IN VARCHAR2
76 , p_person_first_name IN VARCHAR2
77 , p_person_last_name IN VARCHAR2
78 , p_person_middle_name IN VARCHAR2
79 , p_person_name_suffix IN VARCHAR2
80 , p_person_title IN VARCHAR2
81 , p_job_title IN VARCHAR2
82 , p_work_phone_country_code IN VARCHAR2
83 , p_work_phone_area_code IN VARCHAR2
84 , p_work_phone_number IN VARCHAR2
85 , p_home_phone_country_code IN VARCHAR2
86 , p_home_phone_area_code IN VARCHAR2
87 , p_home_phone_number IN VARCHAR2
88 , p_fax_phone_country_code IN VARCHAR2
89 , p_fax_phone_area_code IN VARCHAR2
90 , p_fax_phone_number IN VARCHAR2
91 , p_pager_phone_country_code IN VARCHAR2
92 , p_pager_phone_area_code IN VARCHAR2
93 , p_pager_phone_number IN VARCHAR2
94 , p_cell_phone_country_code IN VARCHAR2
95 , p_cell_phone_area_code IN VARCHAR2
96 , p_cell_phone_number IN VARCHAR2
97 , p_text_email_address IN VARCHAR2
98 , p_html_email_address IN VARCHAR2
99 , p_match_type IN VARCHAR2
100 , x_return_status OUT NOCOPY VARCHAR2
101 , x_msg_count OUT NOCOPY NUMBER
102 , x_msg_data OUT NOCOPY VARCHAR2
103 , x_num_of_matches OUT NOCOPY NUMBER
104 , x_party_id OUT NOCOPY NUMBER
105 );
106
107 END CAC_SYNC_CONTACT_DQM_PVT;