120: p_from_party_id => p_from_party_id,
121: p_to_party_id => p_to_party_id,
122: p_merge_reason_code => p_MERGE_REASON_CODE,
123: p_merge_status => 'PENDING',
124: p_CREATED_BY => HZ_UTILITY_PUB.CREATED_BY,
125: p_CREATION_DATE => HZ_UTILITY_PUB.CREATION_DATE,
126: p_LAST_UPDATE_LOGIN => HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
127: p_LAST_UPDATE_DATE => HZ_UTILITY_PUB.LAST_UPDATE_DATE,
128: p_LAST_UPDATED_BY => HZ_UTILITY_PUB.LAST_UPDATED_BY);
121: p_to_party_id => p_to_party_id,
122: p_merge_reason_code => p_MERGE_REASON_CODE,
123: p_merge_status => 'PENDING',
124: p_CREATED_BY => HZ_UTILITY_PUB.CREATED_BY,
125: p_CREATION_DATE => HZ_UTILITY_PUB.CREATION_DATE,
126: p_LAST_UPDATE_LOGIN => HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
127: p_LAST_UPDATE_DATE => HZ_UTILITY_PUB.LAST_UPDATE_DATE,
128: p_LAST_UPDATED_BY => HZ_UTILITY_PUB.LAST_UPDATED_BY);
129:
122: p_merge_reason_code => p_MERGE_REASON_CODE,
123: p_merge_status => 'PENDING',
124: p_CREATED_BY => HZ_UTILITY_PUB.CREATED_BY,
125: p_CREATION_DATE => HZ_UTILITY_PUB.CREATION_DATE,
126: p_LAST_UPDATE_LOGIN => HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
127: p_LAST_UPDATE_DATE => HZ_UTILITY_PUB.LAST_UPDATE_DATE,
128: p_LAST_UPDATED_BY => HZ_UTILITY_PUB.LAST_UPDATED_BY);
129:
130: END do_create_merge_party;
123: p_merge_status => 'PENDING',
124: p_CREATED_BY => HZ_UTILITY_PUB.CREATED_BY,
125: p_CREATION_DATE => HZ_UTILITY_PUB.CREATION_DATE,
126: p_LAST_UPDATE_LOGIN => HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
127: p_LAST_UPDATE_DATE => HZ_UTILITY_PUB.LAST_UPDATE_DATE,
128: p_LAST_UPDATED_BY => HZ_UTILITY_PUB.LAST_UPDATED_BY);
129:
130: END do_create_merge_party;
131:
124: p_CREATED_BY => HZ_UTILITY_PUB.CREATED_BY,
125: p_CREATION_DATE => HZ_UTILITY_PUB.CREATION_DATE,
126: p_LAST_UPDATE_LOGIN => HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
127: p_LAST_UPDATE_DATE => HZ_UTILITY_PUB.LAST_UPDATE_DATE,
128: p_LAST_UPDATED_BY => HZ_UTILITY_PUB.LAST_UPDATED_BY);
129:
130: END do_create_merge_party;
131:
132:
138: hz_merge_util.insert_party_site_details(
139: cp_from_party_id,
140: cp_to_party_id,
141: cp_batch_party_id,
142: HZ_UTILITY_PUB.CREATED_BY,
143: HZ_UTILITY_PUB.CREATION_DATE,
144: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
145: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
146: HZ_UTILITY_PUB.LAST_UPDATED_BY);
139: cp_from_party_id,
140: cp_to_party_id,
141: cp_batch_party_id,
142: HZ_UTILITY_PUB.CREATED_BY,
143: HZ_UTILITY_PUB.CREATION_DATE,
144: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
145: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
146: HZ_UTILITY_PUB.LAST_UPDATED_BY);
147:
140: cp_to_party_id,
141: cp_batch_party_id,
142: HZ_UTILITY_PUB.CREATED_BY,
143: HZ_UTILITY_PUB.CREATION_DATE,
144: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
145: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
146: HZ_UTILITY_PUB.LAST_UPDATED_BY);
147:
148: -----Insert Party Relations details
141: cp_batch_party_id,
142: HZ_UTILITY_PUB.CREATED_BY,
143: HZ_UTILITY_PUB.CREATION_DATE,
144: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
145: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
146: HZ_UTILITY_PUB.LAST_UPDATED_BY);
147:
148: -----Insert Party Relations details
149: hz_merge_util.insert_party_reln_details(
142: HZ_UTILITY_PUB.CREATED_BY,
143: HZ_UTILITY_PUB.CREATION_DATE,
144: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
145: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
146: HZ_UTILITY_PUB.LAST_UPDATED_BY);
147:
148: -----Insert Party Relations details
149: hz_merge_util.insert_party_reln_details(
150: cp_from_party_id,
149: hz_merge_util.insert_party_reln_details(
150: cp_from_party_id,
151: cp_to_party_id,
152: cp_batch_party_id,
153: HZ_UTILITY_PUB.CREATED_BY,
154: HZ_UTILITY_PUB.CREATION_DATE,
155: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
156: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
157: HZ_UTILITY_PUB.LAST_UPDATED_BY);
150: cp_from_party_id,
151: cp_to_party_id,
152: cp_batch_party_id,
153: HZ_UTILITY_PUB.CREATED_BY,
154: HZ_UTILITY_PUB.CREATION_DATE,
155: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
156: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
157: HZ_UTILITY_PUB.LAST_UPDATED_BY);
158:
151: cp_to_party_id,
152: cp_batch_party_id,
153: HZ_UTILITY_PUB.CREATED_BY,
154: HZ_UTILITY_PUB.CREATION_DATE,
155: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
156: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
157: HZ_UTILITY_PUB.LAST_UPDATED_BY);
158:
159: END insert_party_details;
152: cp_batch_party_id,
153: HZ_UTILITY_PUB.CREATED_BY,
154: HZ_UTILITY_PUB.CREATION_DATE,
155: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
156: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
157: HZ_UTILITY_PUB.LAST_UPDATED_BY);
158:
159: END insert_party_details;
160:
153: HZ_UTILITY_PUB.CREATED_BY,
154: HZ_UTILITY_PUB.CREATION_DATE,
155: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
156: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
157: HZ_UTILITY_PUB.LAST_UPDATED_BY);
158:
159: END insert_party_details;
160:
161:
209: l_from_reln_party_id,
210: l_to_reln_party_id,
211: 'DUPLICATE_RELN_PARTY',
212: 'PENDING',
213: HZ_UTILITY_PUB.CREATED_BY,
214: HZ_UTILITY_PUB.CREATION_DATE,
215: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
216: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
217: HZ_UTILITY_PUB.LAST_UPDATED_BY);
210: l_to_reln_party_id,
211: 'DUPLICATE_RELN_PARTY',
212: 'PENDING',
213: HZ_UTILITY_PUB.CREATED_BY,
214: HZ_UTILITY_PUB.CREATION_DATE,
215: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
216: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
217: HZ_UTILITY_PUB.LAST_UPDATED_BY);
218:
211: 'DUPLICATE_RELN_PARTY',
212: 'PENDING',
213: HZ_UTILITY_PUB.CREATED_BY,
214: HZ_UTILITY_PUB.CREATION_DATE,
215: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
216: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
217: HZ_UTILITY_PUB.LAST_UPDATED_BY);
218:
219: num := num+1;
212: 'PENDING',
213: HZ_UTILITY_PUB.CREATED_BY,
214: HZ_UTILITY_PUB.CREATION_DATE,
215: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
216: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
217: HZ_UTILITY_PUB.LAST_UPDATED_BY);
218:
219: num := num+1;
220: END IF;
213: HZ_UTILITY_PUB.CREATED_BY,
214: HZ_UTILITY_PUB.CREATION_DATE,
215: HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
216: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
217: HZ_UTILITY_PUB.LAST_UPDATED_BY);
218:
219: num := num+1;
220: END IF;
221: END LOOP;