1 PACKAGE HZ_MERGE_DUP_PVT AUTHID CURRENT_USER AS
2 /* $Header: ARHCMBAS.pls 115.9 2004/03/25 03:09:26 awu noship $ */
3
4 PROCEDURE Create_Merge_Batch(
5 p_dup_set_id IN NUMBER,
6 p_default_mapping IN VARCHAR2,
7 p_object_version_number IN OUT NOCOPY NUMBER,
8 x_merge_batch_id OUT NOCOPY NUMBER,
9 x_return_status OUT NOCOPY VARCHAR2,
10 x_msg_count OUT NOCOPY NUMBER,
11 x_msg_data OUT NOCOPY VARCHAR2 );
12
13 PROCEDURE map_detail_record(
14 p_batch_party_id IN NUMBER,
15 p_entity IN VARCHAR2,
16 p_from_entity_id IN NUMBER,
17 p_to_entity_id IN NUMBER,
18 p_object_version_number IN OUT NOCOPY NUMBER,
19 x_return_status OUT NOCOPY VARCHAR2,
20 x_msg_count OUT NOCOPY NUMBER,
21 x_msg_data OUT NOCOPY VARCHAR2 );
22
23 PROCEDURE map_within_party(
24 p_batch_party_id IN NUMBER,
25 p_entity IN VARCHAR2,
26 p_from_entity_id IN NUMBER,
27 p_to_entity_id IN NUMBER,
28 x_return_status OUT NOCOPY VARCHAR2,
29 x_msg_count OUT NOCOPY NUMBER,
30 x_msg_data OUT NOCOPY VARCHAR2);
31
32 PROCEDURE submit_batch(
33 p_batch_id IN NUMBER,
34 p_preview IN VARCHAR2,
35 x_request_id OUT NOCOPY NUMBER,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2 );
39
40 -- create records in dup batch, dup set and dup set parties
41 PROCEDURE suggested_defaults (
42 p_batch_id IN NUMBER
43 ,x_return_status OUT NOCOPY VARCHAR2
44 ,x_msg_count OUT NOCOPY NUMBER
45 ,x_msg_data OUT NOCOPY VARCHAR2
46 );
47
48 PROCEDURE apply_suggested_default (
49 p_batch_id IN NUMBER
50 ,p_entity_name IN VARCHAR2
51 ,x_return_status OUT NOCOPY VARCHAR2
52 ,x_msg_count OUT NOCOPY NUMBER
53 ,x_msg_data OUT NOCOPY VARCHAR2
54 );
55
56 PROCEDURE clear_suggested_default (
57 p_batch_id IN NUMBER
58 ,p_entity_name IN VARCHAR2
59 ,p_merge_type IN VARCHAR2
60 ,x_return_status OUT NOCOPY VARCHAR2
61 ,x_msg_count OUT NOCOPY NUMBER
62 ,x_msg_data OUT NOCOPY VARCHAR2
63 );
64
65 PROCEDURE suggested_party_sites (
66 p_batch_id IN NUMBER
67 ,p_merge_type IN VARCHAR2
68 ,p_rule_id IN NUMBER
69 );
70
71 PROCEDURE suggested_party_reln (
72 p_batch_id IN NUMBER
73 ,p_merge_type IN VARCHAR2
74 ,p_rule_id IN NUMBER
75 );
76
77 PROCEDURE create_reln_sysbatch (
78 p_batch_id IN NUMBER
79 ,p_merge_type IN VARCHAR2
80 ,x_return_status OUT NOCOPY VARCHAR2
81 ,x_msg_count OUT NOCOPY NUMBER
82 ,x_msg_data OUT NOCOPY VARCHAR2
83 );
84
85 PROCEDURE delete_mapping (
86 p_batch_id IN NUMBER
87 ,p_merge_type IN VARCHAR2
88 ,x_return_status OUT NOCOPY VARCHAR2
89 ,x_msg_count OUT NOCOPY NUMBER
90 ,x_msg_data OUT NOCOPY VARCHAR2
91 );
92
93 PROCEDURE unmap_child_records(
94 p_merge_batch_id IN NUMBER,
95 p_entity IN VARCHAR2,
96 p_entity_id IN NUMBER,
97 p_merge_type IN VARCHAR2,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2
101 );
102 -- If it has been called from DL project, pass in p_dup_set_id
103 -- if it has been called from party merge concurrent, pass in merge_batch_id only
104 -- and pass in null for p_dup_set_id
105 procedure validate_overlapping_merge_req(
106 p_dup_set_id IN NUMBER,
107 p_merge_batch_id IN NUMBER,
108 p_init_msg_list IN VARCHAR2,
109 p_reject_req_flag IN VARCHAR2,
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2 );
113
114 -- Only called from Data Librarian UI
115 function is_acct_site_merge_required(p_merge_batch_id in number) return varchar2;
116
117 -- Only called from Data Librarian UI
118 procedure site_merge_warning(
119 p_merge_batch_id IN NUMBER,
120 p_generate_note_flag IN VARCHAR2,
121 x_return_status OUT NOCOPY VARCHAR2,
122 x_msg_count OUT NOCOPY NUMBER,
123 x_msg_data OUT NOCOPY VARCHAR2 );
124
125 END HZ_MERGE_DUP_PVT;