1 PACKAGE HZ_BATCH_ACTION_PUB AUTHID CURRENT_USER AS
2 /*$Header: ARHBATAS.pls 120.4 2003/10/14 20:24:02 rpalanis noship $ */
3
4 --------------------------------------
5 -- declaration of public procedures and functions
6 --------------------------------------
7 /**
8 * PROCEDURE clear_status
9 *
10 * DESCRIPTION
11 * Clear the interface_status and dqm_action_flag of the interface
12 * tables.
13 *
14 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
15 *
16 * ARGUMENTS
17 * IN:
18 * p_batch_id Interface Batch ID.
19 *
20 * OUT:
21 * x_return_status Return status after the call. The status can
22 * be FND_API.G_RET_STS_SUCCESS (success),
23 * FND_API.G_RET_STS_ERROR (error).
24 * NOTES
25 *
26 * MODIFICATION HISTORY
27 *
28 * 08-17-2003 Rajeshwari P o Created.
29 *
30 */
31
32 PROCEDURE clear_status (
33 p_batch_id IN NUMBER,
34 x_return_status OUT NOCOPY VARCHAR2
35 );
36
37 /**
38 *PROCEDURE batch_dedup_action
39 *
40 * DESCRIPTION
41 * Mark the interface_status in the interface tables
42 * with 'R' to indicate which records should be removed from
43 * processing by Data Load program.
44 *
45 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
46 *
47 * ARGUMENTS
48 * IN:
49 * p_batch_id Batch ID from batch summary table.
50 * p_action_on_parties Action to be taken on duplicate party records
51 * in the interface tables.
52 * p_action_on_addresses Action to be taken on duplicate site records
53 * in the interface tables.
54 * p_action_on_contacts Action to be taken on duplicate contact records
55 * in the interface tables.
56 * p_action_on_contact_points Action to be taken on duplicate contact point
57 * records in the interface tables.
58 *
59 * OUT:
60 * x_return_status Return status after the call. The status can
61 * be FND_API.G_RET_STS_SUCCESS (success),
62 * FND_API.G_RET_STS_ERROR (error),
63 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
64 * x_msg_count Number of messages in message stack.
65 * x_msg_data Message text if x_msg_count is 1..
66 * NOTES
67 *
68 * MODIFICATION HISTORY
69 *
70 * 08-17-2003 Rajeshwari P o Created.
71 *
72 */
73
74 PROCEDURE batch_dedup_action (
75 p_batch_id IN NUMBER,
76 p_action_on_parties IN VARCHAR2,
77 p_action_on_addresses IN VARCHAR2,
78 p_action_on_contacts IN VARCHAR2,
79 p_action_on_contact_points 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 /**
86 *PROCEDURE registry_dedup_action
87 *
88 * DESCRIPTION
89 * This API will be called to reflect the user defined
90 * options into the interface tables after DQM has performed
91 * registry de-duplication.
92 *
93 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
94 *
95 * ARGUMENTS
96 * IN:
97 * p_batch_id Interface Batch ID
98 * p_action_new_parties New Parties,
99 * p_action_existing_parties Existing parties,
100 * p_action_dup_parties Dup parties,
101 * p_action_pot_dup_parties Potential duplicate parties,
102 * p_action_new_addrs New Address,
103 * p_action_existing_addrs Existing Address,
104 * p_action_pot_dup_addrs Potential Duplicate address,
105 * p_action_new_contacts New Contacts,
106 * p_action_existing_contacts Existing Contacts,
107 * p_action_pot_dup_contacts Potential duplicate Contacts,
108 * p_action_new_cpts New Contact Points,
109 * p_action_existing_cpts Existing Contact Points,
110 * p_action_pot_dup_cpts Potential Duplicate Contact Points,
111 * p_action_new_supents New Supents,
112 * p_action_existing_supents Existing Supents,
113 * p_action_new_finents New Finents,
114 * p_action_existing_finents Existing Finents,
115 *
116 * OUT:
117 * x_return_status Return status after the call. The status can
118 * be FND_API.G_RET_STS_SUCCESS (success),
119 * FND_API.G_RET_STS_ERROR (error),
120 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
121 * x_msg_count Number of messages in message stack.
122 * x_msg_data Message text if x_msg_count is 1..
123 * NOTES
124 *
125 * MODIFICATION HISTORY
126 *
127 * 08-17-2003 Rajeshwari P o Created.
128 *
129 */
130
131 PROCEDURE registry_dedup_action (
132 p_batch_id IN NUMBER,
133 p_action_new_parties IN VARCHAR2,
134 p_action_existing_parties IN VARCHAR2,
135 p_action_dup_parties IN VARCHAR2,
136 p_action_pot_dup_parties IN VARCHAR2,
137 p_action_new_addrs IN VARCHAR2,
138 p_action_existing_addrs IN VARCHAR2,
139 p_action_pot_dup_addrs IN VARCHAR2,
140 p_action_new_contacts IN VARCHAR2,
141 p_action_existing_contacts IN VARCHAR2,
142 p_action_pot_dup_contacts IN VARCHAR2,
143 p_action_new_cpts IN VARCHAR2,
144 p_action_existing_cpts IN VARCHAR2,
145 p_action_pot_dup_cpts IN VARCHAR2,
146 p_action_new_supents IN VARCHAR2,
147 p_action_existing_supents IN VARCHAR2,
148 p_action_new_finents IN VARCHAR2,
149 p_action_existing_finents IN VARCHAR2,
150 x_return_status OUT NOCOPY VARCHAR2,
151 x_msg_count OUT NOCOPY NUMBER,
152 x_msg_data OUT NOCOPY VARCHAR2
153 );
154
155 /**
156 *FUNCTION GET_DEDUP_BATCH_STATUS
157 *
158 * DESCRIPTION
159 * This API will be called to get the
160 * status (Import/Remove) of records in
161 * dedup results based on the action
162 * in batch summary.
163 *
164 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
165 *
166 * ARGUMENTS
167 * IN:
168 * p_batch_id Interface Batch ID
169 * p_entity Entity Name in Dedup Results,
170 * p_action_on_entity Action on entity in Batch Summary,
171 * p_winner_record_os Winner record Orig System in Dedup Results
172 * p_winner_record_osr Winner record Orig System Reference in Dedup Results
173 * p_dup_record_os Dup record Orig System in Dedup Results
174 * p_dup_record_osr Dup record Orig System Reference in Dedup Results
175 *
176 *
177 * NOTES
178 *
179 * MODIFICATION HISTORY
180 *
181 * 09-30-2003 Ramesh Ch o Created.
182 *
183 */
184
185 FUNCTION GET_DEDUP_BATCH_STATUS(p_batch_id IN NUMBER,
186 p_entity IN VARCHAR2,
187 p_action_on_entity IN VARCHAR2,
188 p_winner_record_os IN VARCHAR2,
189 p_winner_record_osr IN VARCHAR2,
190 p_dup_record_os IN VARCHAR2,
191 p_dup_record_osr IN VARCHAR2
192 ) RETURN VARCHAR2;
193
194
195 END HZ_BATCH_ACTION_PUB;