1 PACKAGE HZ_MERGE_ENTITY_ATTRI_PVT AUTHID CURRENT_USER AS
2 /*$Header: ARHMPATS.pls 115.4 2002/11/21 21:01:25 sponnamb noship $ */
3
4
5
6 --------------------------------------
7 -- declaration of public procedures and functions
8 --------------------------------------
9
10 /* This procedure will be called in party merge concurrent program.
11 Entity name supported are 'HZ_ORGANIZATION_PROFILES'
12 and 'HZ_PERSON_PROFILES'.
13 */
14
15 PROCEDURE do_profile_attribute_merge(
16 p_merge_batch_id IN NUMBER,
17 p_merge_to_party_id IN NUMBER,
18 p_entity_name IN VARCHAR2,
19 x_return_status OUT NOCOPY VARCHAR2
20 ) ;
21
22 PROCEDURE create_merge_attributes(
23 p_merge_batch_id IN NUMBER,
24 p_merge_to_party_id IN NUMBER,
25 p_entity_name IN VARCHAR2,
26 x_return_status OUT NOCOPY VARCHAR2,
27 x_msg_count OUT NOCOPY NUMBER,
28 x_msg_data OUT NOCOPY VARCHAR2
29 );
30
31 /* sync up attribute values in hz_merge_entity_attributes and hz_organization/person_profiles*/
32 PROCEDURE sync_merge_attributes(
33 p_merge_batch_id IN NUMBER,
34 p_merge_to_party_id IN NUMBER,
35 p_entity_name IN VARCHAR2,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2
39 );
40
41 PROCEDURE update_merge_attribute (
42 p_merge_batch_id IN NUMBER,
43 p_merge_to_party_id IN NUMBER,
44 p_attribute_name IN VARCHAR2,
45 p_attribute_value IN VARCHAR2,
46 p_attribute_party_id IN NUMBER,
47 p_entity_name IN VARCHAR2,
48 px_object_version_number IN OUT NOCOPY NUMBER,
49 x_return_status OUT NOCOPY VARCHAR2,
50 x_msg_count OUT NOCOPY NUMBER,
51 x_msg_data OUT NOCOPY VARCHAR2
52 );
53
54 /* This function is called in profile attribute merge UI */
55 function get_attri_value_meaning(p_profile_type in varchar2, p_attri_name in
56 varchar2, p_attri_value in varchar2) return varchar2;
57
58 END HZ_MERGE_ENTITY_ATTRI_PVT;