1 PACKAGE HZ_MERGE_DUP_CHECK AUTHID CURRENT_USER AS
2 /* $Header: ARHMDUPS.pls 120.5 2005/09/13 08:41:45 rbandi noship $ */
3
4 FUNCTION check_cust_account_dup(
5 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
6 x_to_id IN OUT NOCOPY NUMBER,
7 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
8 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
9 x_return_status IN OUT NOCOPY VARCHAR2)
10 RETURN VARCHAR2;
11
12 FUNCTION check_cust_account_role_dup(
13 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
14 x_to_id IN OUT NOCOPY NUMBER,
15 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
16 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
17 x_return_status IN OUT NOCOPY VARCHAR2)
18 RETURN VARCHAR2;
19
20 FUNCTION check_cust_account_site_dup(
21 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
22 x_to_id IN OUT NOCOPY NUMBER,
23 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
24 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
25 x_return_status IN OUT NOCOPY VARCHAR2)
26 RETURN VARCHAR2;
27
28 FUNCTION check_financial_profile_dup(
29 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
30 x_to_id IN OUT NOCOPY NUMBER,
31 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
32 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
33 x_return_status IN OUT NOCOPY VARCHAR2)
34 RETURN VARCHAR2;
35
36 FUNCTION check_contact_point_dup(
37 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
38 x_to_id IN OUT NOCOPY NUMBER,
39 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
40 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
41 p_owner_table_name IN VARCHAR2,
42 x_return_status IN OUT NOCOPY VARCHAR2)
43 RETURN VARCHAR2;
44
45 FUNCTION check_references_dup(
46 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
47 x_to_id IN OUT NOCOPY NUMBER,
48 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
49 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
50 x_return_status IN OUT NOCOPY VARCHAR2)
51 RETURN VARCHAR2;
52
53 FUNCTION check_certification_dup(
54 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
55 x_to_id IN OUT NOCOPY NUMBER,
56 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
57 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
58 x_return_status IN OUT NOCOPY VARCHAR2)
59 RETURN VARCHAR2;
60
61 FUNCTION check_credit_ratings_dup(
62 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
63 x_to_id IN OUT NOCOPY NUMBER,
64 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
65 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
66 x_return_status IN OUT NOCOPY VARCHAR2)
67 RETURN VARCHAR2;
68
69 FUNCTION check_security_issued_dup(
70 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
71 x_to_id IN OUT NOCOPY NUMBER,
72 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
73 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
74 x_return_status IN OUT NOCOPY VARCHAR2)
75 RETURN VARCHAR2;
76
77 FUNCTION check_financial_reports_dup(
78 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
79 x_to_id IN OUT NOCOPY NUMBER,
80 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
81 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
82 x_return_status IN OUT NOCOPY VARCHAR2)
83 RETURN VARCHAR2;
84
85 FUNCTION check_org_indicators_dup(
86 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
87 x_to_id IN OUT NOCOPY NUMBER,
88 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
89 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
90 x_return_status IN OUT NOCOPY VARCHAR2)
91 RETURN VARCHAR2;
92
93 FUNCTION check_ind_reference_dup(
94 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
95 x_to_id IN OUT NOCOPY NUMBER,
96 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
97 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
98 x_return_status IN OUT NOCOPY VARCHAR2)
99 RETURN VARCHAR2;
100
101 FUNCTION check_per_interest_dup(
102 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
103 x_to_id IN OUT NOCOPY NUMBER,
104 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
105 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
106 x_return_status IN OUT NOCOPY VARCHAR2)
107 RETURN VARCHAR2;
108
109 FUNCTION check_citizenship_dup(
110 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
111 x_to_id IN OUT NOCOPY NUMBER,
112 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
113 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
114 x_return_status IN OUT NOCOPY VARCHAR2)
115 RETURN VARCHAR2;
116
117 FUNCTION check_education_dup(
118 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
119 x_to_id IN OUT NOCOPY NUMBER,
120 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
121 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
122 x_return_status IN OUT NOCOPY VARCHAR2)
123 RETURN VARCHAR2;
124
125 FUNCTION check_emp_history_dup(
126 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
127 x_to_id IN OUT NOCOPY NUMBER,
128 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
129 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
130 x_return_status IN OUT NOCOPY VARCHAR2)
131 RETURN VARCHAR2;
132
133 FUNCTION check_work_class_dup(
134 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
135 x_to_id IN OUT NOCOPY NUMBER,
136 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
137 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
138 x_return_status IN OUT NOCOPY VARCHAR2)
139 RETURN VARCHAR2;
140
141 FUNCTION check_languages_dup(
142 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
143 x_to_id IN OUT NOCOPY NUMBER,
144 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
145 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
146 x_return_status IN OUT NOCOPY VARCHAR2)
147 RETURN VARCHAR2;
148
149 FUNCTION check_party_site_use_dup(
150 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
151 x_to_id IN OUT NOCOPY NUMBER,
152 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
153 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
154 x_return_status IN OUT NOCOPY VARCHAR2)
155 RETURN VARCHAR2;
156
157 FUNCTION check_party_site_dup(
158 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
159 x_to_id IN OUT NOCOPY NUMBER,
160 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
161 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
162 x_return_status IN OUT NOCOPY VARCHAR2)
163 RETURN VARCHAR2;
164
165 FUNCTION check_financial_number_dup(
166 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
167 x_to_id IN OUT NOCOPY NUMBER,
168 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
169 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
170 x_return_status IN OUT NOCOPY VARCHAR2)
171 RETURN VARCHAR2;
172
173 FUNCTION check_org_contact_role_dup(
174 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
175 x_to_id IN OUT NOCOPY NUMBER,
176 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
177 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
178 x_return_status IN OUT NOCOPY VARCHAR2)
179 RETURN VARCHAR2;
180
181 FUNCTION check_code_assignment_dup(
182 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
183 x_to_id IN OUT NOCOPY NUMBER,
184 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
185 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
186 p_owner_table_name IN VARCHAR2,
187 x_return_status IN OUT NOCOPY VARCHAR2)
188 RETURN VARCHAR2;
189
190 FUNCTION check_contact_preference_dup(
191 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
192 x_to_id IN OUT NOCOPY NUMBER,
193 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
194 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
195 p_owner_table_name IN VARCHAR2,
196 x_return_status IN OUT NOCOPY VARCHAR2)
197 RETURN VARCHAR2;
198
199 --Bug Fix 4577535
200 FUNCTION check_address_dup(
201 p_from_location_id IN NUMBER:=FND_API.G_MISS_NUM,
202 x_to_id IN OUT NOCOPY NUMBER,
203 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
204 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
205 x_return_status IN OUT NOCOPY VARCHAR2)
206 RETURN VARCHAR2;
207
208
209 END HZ_MERGE_DUP_CHECK;