eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_MERGE_DUP_PVT dependencies on HZ_UTILITY_V2PUB

Line 181: p_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,

177: p_BATCH_STATUS => 'MAPPING_PENDING',
178: p_BATCH_COMMIT => 'B',
179: p_BATCH_DELETE => 'N',
180: p_MERGE_REASON_CODE => 'DEDUPE',
181: p_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,
182: p_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,
183: p_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
184: p_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
185: p_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY);

Line 182: p_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,

178: p_BATCH_COMMIT => 'B',
179: p_BATCH_DELETE => 'N',
180: p_MERGE_REASON_CODE => 'DEDUPE',
181: p_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,
182: p_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,
183: p_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
184: p_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
185: p_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY);
186:

Line 183: p_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

179: p_BATCH_DELETE => 'N',
180: p_MERGE_REASON_CODE => 'DEDUPE',
181: p_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,
182: p_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,
183: p_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
184: p_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
185: p_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY);
186:
187: -- update the created_by_module to 'DL' since this api is only used by data librarian

Line 184: p_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

180: p_MERGE_REASON_CODE => 'DEDUPE',
181: p_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,
182: p_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,
183: p_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
184: p_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
185: p_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY);
186:
187: -- update the created_by_module to 'DL' since this api is only used by data librarian
188: -- to create merge batch data

Line 185: p_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY);

181: p_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,
182: p_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,
183: p_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
184: p_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
185: p_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY);
186:
187: -- update the created_by_module to 'DL' since this api is only used by data librarian
188: -- to create merge batch data
189: UPDATE HZ_MERGE_BATCH

Line 217: p_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,

213: p_from_party_id => l_merge_from,
214: p_to_party_id => l_merge_to,
215: p_merge_reason_code => 'DEDUPE',
216: p_merge_status => 'PENDING',
217: p_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,
218: p_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,
219: p_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
220: p_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
221: p_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY);

Line 218: p_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,

214: p_to_party_id => l_merge_to,
215: p_merge_reason_code => 'DEDUPE',
216: p_merge_status => 'PENDING',
217: p_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,
218: p_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,
219: p_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
220: p_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
221: p_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY);
222:

Line 219: p_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

215: p_merge_reason_code => 'DEDUPE',
216: p_merge_status => 'PENDING',
217: p_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,
218: p_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,
219: p_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
220: p_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
221: p_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY);
222:
223: --Call to insert details

Line 220: p_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

216: p_merge_status => 'PENDING',
217: p_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,
218: p_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,
219: p_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
220: p_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
221: p_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY);
222:
223: --Call to insert details
224: IF l_default_mapping = 'Y' THEN

Line 221: p_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY);

217: p_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,
218: p_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,
219: p_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
220: p_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
221: p_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY);
222:
223: --Call to insert details
224: IF l_default_mapping = 'Y' THEN
225: insert_party_details(l_batch_party_id,

Line 278: p_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,

274: p_from_party_id => l_merge_from,
275: p_to_party_id => l_merge_to,
276: p_merge_reason_code => 'DEDUPE',
277: p_merge_status => 'PENDING',
278: p_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,
279: p_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,
280: p_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
281: p_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
282: p_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY);

Line 279: p_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,

275: p_to_party_id => l_merge_to,
276: p_merge_reason_code => 'DEDUPE',
277: p_merge_status => 'PENDING',
278: p_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,
279: p_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,
280: p_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
281: p_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
282: p_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY);
283:

Line 280: p_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

276: p_merge_reason_code => 'DEDUPE',
277: p_merge_status => 'PENDING',
278: p_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,
279: p_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,
280: p_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
281: p_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
282: p_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY);
283:
284: END IF;

Line 281: p_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

277: p_merge_status => 'PENDING',
278: p_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,
279: p_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,
280: p_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
281: p_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
282: p_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY);
283:
284: END IF;
285: if p_default_mapping = 'Y'

Line 282: p_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY);

278: p_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,
279: p_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,
280: p_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
281: p_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
282: p_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY);
283:
284: END IF;
285: if p_default_mapping = 'Y'
286: then

Line 740: HZ_UTILITY_V2PUB.CREATED_BY,

736: l_from_rel_party_id,
737: l_to_rel_party_id,
738: 'DUPLICATE_RELN_PARTY',
739: 'PENDING',
740: HZ_UTILITY_V2PUB.CREATED_BY,
741: HZ_UTILITY_V2PUB.CREATION_DATE,
742: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
743: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
744: HZ_UTILITY_V2PUB.LAST_UPDATED_BY);

Line 741: HZ_UTILITY_V2PUB.CREATION_DATE,

737: l_to_rel_party_id,
738: 'DUPLICATE_RELN_PARTY',
739: 'PENDING',
740: HZ_UTILITY_V2PUB.CREATED_BY,
741: HZ_UTILITY_V2PUB.CREATION_DATE,
742: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
743: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
744: HZ_UTILITY_V2PUB.LAST_UPDATED_BY);
745:

Line 742: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

738: 'DUPLICATE_RELN_PARTY',
739: 'PENDING',
740: HZ_UTILITY_V2PUB.CREATED_BY,
741: HZ_UTILITY_V2PUB.CREATION_DATE,
742: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
743: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
744: HZ_UTILITY_V2PUB.LAST_UPDATED_BY);
745:
746: --Also insert the Party sites for reln Party

Line 743: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

739: 'PENDING',
740: HZ_UTILITY_V2PUB.CREATED_BY,
741: HZ_UTILITY_V2PUB.CREATION_DATE,
742: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
743: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
744: HZ_UTILITY_V2PUB.LAST_UPDATED_BY);
745:
746: --Also insert the Party sites for reln Party
747: -- if there are any

Line 744: HZ_UTILITY_V2PUB.LAST_UPDATED_BY);

740: HZ_UTILITY_V2PUB.CREATED_BY,
741: HZ_UTILITY_V2PUB.CREATION_DATE,
742: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
743: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
744: HZ_UTILITY_V2PUB.LAST_UPDATED_BY);
745:
746: --Also insert the Party sites for reln Party
747: -- if there are any
748: insert_party_site_details(l_from_rel_party_id,

Line 820: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

816: AND ROWNUM = 1;
817:
818: UPDATE HZ_DUP_SETS
819: SET STATUS = 'MAPPING',
820: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
821: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
822: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
823: WHERE DUP_SET_ID = l_dup_set_id;
824:

Line 821: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

817:
818: UPDATE HZ_DUP_SETS
819: SET STATUS = 'MAPPING',
820: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
821: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
822: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
823: WHERE DUP_SET_ID = l_dup_set_id;
824:
825: UPDATE HZ_MERGE_BATCH

Line 822: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY

818: UPDATE HZ_DUP_SETS
819: SET STATUS = 'MAPPING',
820: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
821: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
822: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
823: WHERE DUP_SET_ID = l_dup_set_id;
824:
825: UPDATE HZ_MERGE_BATCH
826: SET batch_status = 'IN_PROCESS',

Line 827: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

823: WHERE DUP_SET_ID = l_dup_set_id;
824:
825: UPDATE HZ_MERGE_BATCH
826: SET batch_status = 'IN_PROCESS',
827: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
828: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
829: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
830: WHERE BATCH_ID = l_dup_set_id;
831:

Line 828: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

824:
825: UPDATE HZ_MERGE_BATCH
826: SET batch_status = 'IN_PROCESS',
827: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
828: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
829: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
830: WHERE BATCH_ID = l_dup_set_id;
831:
832: ELSE

Line 829: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY

825: UPDATE HZ_MERGE_BATCH
826: SET batch_status = 'IN_PROCESS',
827: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
828: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
829: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
830: WHERE BATCH_ID = l_dup_set_id;
831:
832: ELSE
833: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

Line 1146: hz_utility_v2pub.created_by,

1142: 'HZ_PARTY_SITES',
1143: p_from_entity_id,
1144: p_to_entity_id,
1145: 'N',
1146: hz_utility_v2pub.created_by,
1147: hz_utility_v2pub.creation_Date,
1148: hz_utility_v2pub.last_update_login,
1149: hz_utility_v2pub.last_update_date,
1150: hz_utility_v2pub.last_updated_by);

Line 1147: hz_utility_v2pub.creation_Date,

1143: p_from_entity_id,
1144: p_to_entity_id,
1145: 'N',
1146: hz_utility_v2pub.created_by,
1147: hz_utility_v2pub.creation_Date,
1148: hz_utility_v2pub.last_update_login,
1149: hz_utility_v2pub.last_update_date,
1150: hz_utility_v2pub.last_updated_by);
1151:

Line 1148: hz_utility_v2pub.last_update_login,

1144: p_to_entity_id,
1145: 'N',
1146: hz_utility_v2pub.created_by,
1147: hz_utility_v2pub.creation_Date,
1148: hz_utility_v2pub.last_update_login,
1149: hz_utility_v2pub.last_update_date,
1150: hz_utility_v2pub.last_updated_by);
1151:
1152: ELSE

Line 1149: hz_utility_v2pub.last_update_date,

1145: 'N',
1146: hz_utility_v2pub.created_by,
1147: hz_utility_v2pub.creation_Date,
1148: hz_utility_v2pub.last_update_login,
1149: hz_utility_v2pub.last_update_date,
1150: hz_utility_v2pub.last_updated_by);
1151:
1152: ELSE
1153: IF l_map_dtl_count >0 THEN

Line 1150: hz_utility_v2pub.last_updated_by);

1146: hz_utility_v2pub.created_by,
1147: hz_utility_v2pub.creation_Date,
1148: hz_utility_v2pub.last_update_login,
1149: hz_utility_v2pub.last_update_date,
1150: hz_utility_v2pub.last_updated_by);
1151:
1152: ELSE
1153: IF l_map_dtl_count >0 THEN
1154: HZ_MERGE_PARTY_DETAILS_PKG.delete_row(

Line 1189: hz_utility_v2pub.created_by,

1185: 'HZ_PARTY_RELATIONSHIPS',
1186: p_from_entity_id,
1187: p_to_entity_id,
1188: 'N',
1189: hz_utility_v2pub.created_by,
1190: hz_utility_v2pub.creation_Date,
1191: hz_utility_v2pub.last_update_login,
1192: hz_utility_v2pub.last_update_date,
1193: hz_utility_v2pub.last_updated_by);

Line 1190: hz_utility_v2pub.creation_Date,

1186: p_from_entity_id,
1187: p_to_entity_id,
1188: 'N',
1189: hz_utility_v2pub.created_by,
1190: hz_utility_v2pub.creation_Date,
1191: hz_utility_v2pub.last_update_login,
1192: hz_utility_v2pub.last_update_date,
1193: hz_utility_v2pub.last_updated_by);
1194:

Line 1191: hz_utility_v2pub.last_update_login,

1187: p_to_entity_id,
1188: 'N',
1189: hz_utility_v2pub.created_by,
1190: hz_utility_v2pub.creation_Date,
1191: hz_utility_v2pub.last_update_login,
1192: hz_utility_v2pub.last_update_date,
1193: hz_utility_v2pub.last_updated_by);
1194:
1195:

Line 1192: hz_utility_v2pub.last_update_date,

1188: 'N',
1189: hz_utility_v2pub.created_by,
1190: hz_utility_v2pub.creation_Date,
1191: hz_utility_v2pub.last_update_login,
1192: hz_utility_v2pub.last_update_date,
1193: hz_utility_v2pub.last_updated_by);
1194:
1195:
1196: l_from_rel_party_id :=

Line 1193: hz_utility_v2pub.last_updated_by);

1189: hz_utility_v2pub.created_by,
1190: hz_utility_v2pub.creation_Date,
1191: hz_utility_v2pub.last_update_login,
1192: hz_utility_v2pub.last_update_date,
1193: hz_utility_v2pub.last_updated_by);
1194:
1195:
1196: l_from_rel_party_id :=
1197: HZ_MERGE_UTIL.get_reln_party_id(p_from_entity_id);

Line 1223: HZ_UTILITY_V2PUB.CREATED_BY,

1219: l_from_rel_party_id,
1220: l_to_rel_party_id,
1221: 'DUPLICATE_RELN_PARTY',
1222: 'PENDING',
1223: HZ_UTILITY_V2PUB.CREATED_BY,
1224: HZ_UTILITY_V2PUB.CREATION_DATE,
1225: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
1226: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
1227: HZ_UTILITY_V2PUB.LAST_UPDATED_BY);

Line 1224: HZ_UTILITY_V2PUB.CREATION_DATE,

1220: l_to_rel_party_id,
1221: 'DUPLICATE_RELN_PARTY',
1222: 'PENDING',
1223: HZ_UTILITY_V2PUB.CREATED_BY,
1224: HZ_UTILITY_V2PUB.CREATION_DATE,
1225: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
1226: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
1227: HZ_UTILITY_V2PUB.LAST_UPDATED_BY);
1228:

Line 1225: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

1221: 'DUPLICATE_RELN_PARTY',
1222: 'PENDING',
1223: HZ_UTILITY_V2PUB.CREATED_BY,
1224: HZ_UTILITY_V2PUB.CREATION_DATE,
1225: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
1226: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
1227: HZ_UTILITY_V2PUB.LAST_UPDATED_BY);
1228:
1229: --Also insert the Party sites for reln Party

Line 1226: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

1222: 'PENDING',
1223: HZ_UTILITY_V2PUB.CREATED_BY,
1224: HZ_UTILITY_V2PUB.CREATION_DATE,
1225: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
1226: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
1227: HZ_UTILITY_V2PUB.LAST_UPDATED_BY);
1228:
1229: --Also insert the Party sites for reln Party
1230: -- if there are any

Line 1227: HZ_UTILITY_V2PUB.LAST_UPDATED_BY);

1223: HZ_UTILITY_V2PUB.CREATED_BY,
1224: HZ_UTILITY_V2PUB.CREATION_DATE,
1225: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
1226: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
1227: HZ_UTILITY_V2PUB.LAST_UPDATED_BY);
1228:
1229: --Also insert the Party sites for reln Party
1230: -- if there are any
1231: insert_party_site_details(l_from_rel_party_id,

Line 1276: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

1272: end if; --p_entity
1273:
1274: UPDATE HZ_DUP_SETS
1275: SET STATUS = 'MAPPING',
1276: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
1277: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
1278: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
1279: WHERE DUP_SET_ID = (SELECT batch_id FROM hz_merge_parties
1280: WHERE batch_party_id = p_batch_party_id

Line 1277: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

1273:
1274: UPDATE HZ_DUP_SETS
1275: SET STATUS = 'MAPPING',
1276: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
1277: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
1278: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
1279: WHERE DUP_SET_ID = (SELECT batch_id FROM hz_merge_parties
1280: WHERE batch_party_id = p_batch_party_id
1281: AND ROWNUM = 1);

Line 1278: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY

1274: UPDATE HZ_DUP_SETS
1275: SET STATUS = 'MAPPING',
1276: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
1277: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
1278: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
1279: WHERE DUP_SET_ID = (SELECT batch_id FROM hz_merge_parties
1280: WHERE batch_party_id = p_batch_party_id
1281: AND ROWNUM = 1);
1282:

Line 1285: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

1281: AND ROWNUM = 1);
1282:
1283: UPDATE HZ_MERGE_BATCH
1284: SET batch_status = 'IN_PROCESS',
1285: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
1286: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
1287: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
1288: WHERE BATCH_ID = (SELECT batch_id FROM hz_merge_parties
1289: WHERE batch_party_id = p_batch_party_id

Line 1286: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

1282:
1283: UPDATE HZ_MERGE_BATCH
1284: SET batch_status = 'IN_PROCESS',
1285: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
1286: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
1287: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
1288: WHERE BATCH_ID = (SELECT batch_id FROM hz_merge_parties
1289: WHERE batch_party_id = p_batch_party_id
1290: AND ROWNUM = 1);

Line 1287: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY

1283: UPDATE HZ_MERGE_BATCH
1284: SET batch_status = 'IN_PROCESS',
1285: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
1286: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
1287: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
1288: WHERE BATCH_ID = (SELECT batch_id FROM hz_merge_parties
1289: WHERE batch_party_id = p_batch_party_id
1290: AND ROWNUM = 1);
1291:

Line 1489: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

1485: IF l_request_id is not null THen
1486: UPDATE HZ_MERGE_BATCH
1487: SET batch_status = 'SUBMITTED' ,
1488: request_id = l_request_id,
1489: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
1490: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
1491: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
1492: WHERE batch_id = p_batch_id;
1493:

Line 1490: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

1486: UPDATE HZ_MERGE_BATCH
1487: SET batch_status = 'SUBMITTED' ,
1488: request_id = l_request_id,
1489: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
1490: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
1491: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
1492: WHERE batch_id = p_batch_id;
1493:
1494: UPDATE HZ_DUP_SETS

Line 1491: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY

1487: SET batch_status = 'SUBMITTED' ,
1488: request_id = l_request_id,
1489: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
1490: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
1491: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
1492: WHERE batch_id = p_batch_id;
1493:
1494: UPDATE HZ_DUP_SETS
1495: SET status = 'SUBMITTED',

Line 1496: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

1492: WHERE batch_id = p_batch_id;
1493:
1494: UPDATE HZ_DUP_SETS
1495: SET status = 'SUBMITTED',
1496: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
1497: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
1498: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
1499: WHERE dup_set_id = p_batch_id;
1500: END IF;

Line 1497: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

1493:
1494: UPDATE HZ_DUP_SETS
1495: SET status = 'SUBMITTED',
1496: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
1497: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
1498: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
1499: WHERE dup_set_id = p_batch_id;
1500: END IF;
1501:

Line 1498: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY

1494: UPDATE HZ_DUP_SETS
1495: SET status = 'SUBMITTED',
1496: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
1497: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
1498: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
1499: WHERE dup_set_id = p_batch_id;
1500: END IF;
1501:
1502: x_request_id := l_request_id;

Line 1631: HZ_UTILITY_V2PUB.CREATED_BY,

1627: l_from_reln_party_id,
1628: l_to_reln_party_id,
1629: 'DUPLICATE_RELN_PARTY',
1630: 'PENDING',
1631: HZ_UTILITY_V2PUB.CREATED_BY,
1632: HZ_UTILITY_V2PUB.CREATION_DATE,
1633: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
1634: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
1635: HZ_UTILITY_V2PUB.LAST_UPDATED_BY);

Line 1632: HZ_UTILITY_V2PUB.CREATION_DATE,

1628: l_to_reln_party_id,
1629: 'DUPLICATE_RELN_PARTY',
1630: 'PENDING',
1631: HZ_UTILITY_V2PUB.CREATED_BY,
1632: HZ_UTILITY_V2PUB.CREATION_DATE,
1633: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
1634: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
1635: HZ_UTILITY_V2PUB.LAST_UPDATED_BY);
1636:

Line 1633: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

1629: 'DUPLICATE_RELN_PARTY',
1630: 'PENDING',
1631: HZ_UTILITY_V2PUB.CREATED_BY,
1632: HZ_UTILITY_V2PUB.CREATION_DATE,
1633: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
1634: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
1635: HZ_UTILITY_V2PUB.LAST_UPDATED_BY);
1636:
1637: --Also insert the Party sites for reln Party

Line 1634: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

1630: 'PENDING',
1631: HZ_UTILITY_V2PUB.CREATED_BY,
1632: HZ_UTILITY_V2PUB.CREATION_DATE,
1633: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
1634: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
1635: HZ_UTILITY_V2PUB.LAST_UPDATED_BY);
1636:
1637: --Also insert the Party sites for reln Party
1638: -- if there are any

Line 1635: HZ_UTILITY_V2PUB.LAST_UPDATED_BY);

1631: HZ_UTILITY_V2PUB.CREATED_BY,
1632: HZ_UTILITY_V2PUB.CREATION_DATE,
1633: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
1634: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
1635: HZ_UTILITY_V2PUB.LAST_UPDATED_BY);
1636:
1637: --Also insert the Party sites for reln Party
1638: -- if there are any
1639: insert_party_site_details(l_from_reln_party_id,

Line 1732: hz_utility_v2pub.created_by,

1728: 'HZ_PARTY_SITES',
1729: l_ps_id,
1730: l_to_entity_id,
1731: l_mandatory_merge,
1732: hz_utility_v2pub.created_by,
1733: hz_utility_v2pub.creation_Date,
1734: hz_utility_v2pub.last_update_login,
1735: hz_utility_v2pub.last_update_date,
1736: hz_utility_v2pub.last_updated_by);

Line 1733: hz_utility_v2pub.creation_Date,

1729: l_ps_id,
1730: l_to_entity_id,
1731: l_mandatory_merge,
1732: hz_utility_v2pub.created_by,
1733: hz_utility_v2pub.creation_Date,
1734: hz_utility_v2pub.last_update_login,
1735: hz_utility_v2pub.last_update_date,
1736: hz_utility_v2pub.last_updated_by);
1737: ELSE

Line 1734: hz_utility_v2pub.last_update_login,

1730: l_to_entity_id,
1731: l_mandatory_merge,
1732: hz_utility_v2pub.created_by,
1733: hz_utility_v2pub.creation_Date,
1734: hz_utility_v2pub.last_update_login,
1735: hz_utility_v2pub.last_update_date,
1736: hz_utility_v2pub.last_updated_by);
1737: ELSE
1738: l_to_entity_id := l_ps_id;

Line 1735: hz_utility_v2pub.last_update_date,

1731: l_mandatory_merge,
1732: hz_utility_v2pub.created_by,
1733: hz_utility_v2pub.creation_Date,
1734: hz_utility_v2pub.last_update_login,
1735: hz_utility_v2pub.last_update_date,
1736: hz_utility_v2pub.last_updated_by);
1737: ELSE
1738: l_to_entity_id := l_ps_id;
1739:

Line 1736: hz_utility_v2pub.last_updated_by);

1732: hz_utility_v2pub.created_by,
1733: hz_utility_v2pub.creation_Date,
1734: hz_utility_v2pub.last_update_login,
1735: hz_utility_v2pub.last_update_date,
1736: hz_utility_v2pub.last_updated_by);
1737: ELSE
1738: l_to_entity_id := l_ps_id;
1739:
1740: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(

Line 1746: hz_utility_v2pub.created_by,

1742: 'HZ_PARTY_SITES',
1743: l_ps_id,
1744: l_to_entity_id,
1745: 'N',
1746: hz_utility_v2pub.created_by,
1747: hz_utility_v2pub.creation_Date,
1748: hz_utility_v2pub.last_update_login,
1749: hz_utility_v2pub.last_update_date,
1750: hz_utility_v2pub.last_updated_by);

Line 1747: hz_utility_v2pub.creation_Date,

1743: l_ps_id,
1744: l_to_entity_id,
1745: 'N',
1746: hz_utility_v2pub.created_by,
1747: hz_utility_v2pub.creation_Date,
1748: hz_utility_v2pub.last_update_login,
1749: hz_utility_v2pub.last_update_date,
1750: hz_utility_v2pub.last_updated_by);
1751: END IF;

Line 1748: hz_utility_v2pub.last_update_login,

1744: l_to_entity_id,
1745: 'N',
1746: hz_utility_v2pub.created_by,
1747: hz_utility_v2pub.creation_Date,
1748: hz_utility_v2pub.last_update_login,
1749: hz_utility_v2pub.last_update_date,
1750: hz_utility_v2pub.last_updated_by);
1751: END IF;
1752: CLOSE c_dup_to_ps;

Line 1749: hz_utility_v2pub.last_update_date,

1745: 'N',
1746: hz_utility_v2pub.created_by,
1747: hz_utility_v2pub.creation_Date,
1748: hz_utility_v2pub.last_update_login,
1749: hz_utility_v2pub.last_update_date,
1750: hz_utility_v2pub.last_updated_by);
1751: END IF;
1752: CLOSE c_dup_to_ps;
1753: END LOOP;

Line 1750: hz_utility_v2pub.last_updated_by);

1746: hz_utility_v2pub.created_by,
1747: hz_utility_v2pub.creation_Date,
1748: hz_utility_v2pub.last_update_login,
1749: hz_utility_v2pub.last_update_date,
1750: hz_utility_v2pub.last_updated_by);
1751: END IF;
1752: CLOSE c_dup_to_ps;
1753: END LOOP;
1754: CLOSE c_from_ps_loc;

Line 2084: hz_utility_v2pub.created_by,

2080: 'HZ_PARTY_RELATIONSHIPS',
2081: l_pr_id,
2082: l_dup_pr_id,
2083: l_mandatory_merge,
2084: hz_utility_v2pub.created_by,
2085: hz_utility_v2pub.creation_Date,
2086: hz_utility_v2pub.last_update_login,
2087: hz_utility_v2pub.last_update_date,
2088: hz_utility_v2pub.last_updated_by);

Line 2085: hz_utility_v2pub.creation_Date,

2081: l_pr_id,
2082: l_dup_pr_id,
2083: l_mandatory_merge,
2084: hz_utility_v2pub.created_by,
2085: hz_utility_v2pub.creation_Date,
2086: hz_utility_v2pub.last_update_login,
2087: hz_utility_v2pub.last_update_date,
2088: hz_utility_v2pub.last_updated_by);
2089:

Line 2086: hz_utility_v2pub.last_update_login,

2082: l_dup_pr_id,
2083: l_mandatory_merge,
2084: hz_utility_v2pub.created_by,
2085: hz_utility_v2pub.creation_Date,
2086: hz_utility_v2pub.last_update_login,
2087: hz_utility_v2pub.last_update_date,
2088: hz_utility_v2pub.last_updated_by);
2089:
2090: ELSE

Line 2087: hz_utility_v2pub.last_update_date,

2083: l_mandatory_merge,
2084: hz_utility_v2pub.created_by,
2085: hz_utility_v2pub.creation_Date,
2086: hz_utility_v2pub.last_update_login,
2087: hz_utility_v2pub.last_update_date,
2088: hz_utility_v2pub.last_updated_by);
2089:
2090: ELSE
2091:

Line 2088: hz_utility_v2pub.last_updated_by);

2084: hz_utility_v2pub.created_by,
2085: hz_utility_v2pub.creation_Date,
2086: hz_utility_v2pub.last_update_login,
2087: hz_utility_v2pub.last_update_date,
2088: hz_utility_v2pub.last_updated_by);
2089:
2090: ELSE
2091:
2092: --5400786

Line 2101: hz_utility_v2pub.created_by,

2097: 'HZ_PARTY_RELATIONSHIPS',
2098: l_pr_id,
2099: l_pr_id,
2100: 'N',
2101: hz_utility_v2pub.created_by,
2102: hz_utility_v2pub.creation_Date,
2103: hz_utility_v2pub.last_update_login,
2104: hz_utility_v2pub.last_update_date,
2105: hz_utility_v2pub.last_updated_by);

Line 2102: hz_utility_v2pub.creation_Date,

2098: l_pr_id,
2099: l_pr_id,
2100: 'N',
2101: hz_utility_v2pub.created_by,
2102: hz_utility_v2pub.creation_Date,
2103: hz_utility_v2pub.last_update_login,
2104: hz_utility_v2pub.last_update_date,
2105: hz_utility_v2pub.last_updated_by);
2106:

Line 2103: hz_utility_v2pub.last_update_login,

2099: l_pr_id,
2100: 'N',
2101: hz_utility_v2pub.created_by,
2102: hz_utility_v2pub.creation_Date,
2103: hz_utility_v2pub.last_update_login,
2104: hz_utility_v2pub.last_update_date,
2105: hz_utility_v2pub.last_updated_by);
2106:
2107: END IF;

Line 2104: hz_utility_v2pub.last_update_date,

2100: 'N',
2101: hz_utility_v2pub.created_by,
2102: hz_utility_v2pub.creation_Date,
2103: hz_utility_v2pub.last_update_login,
2104: hz_utility_v2pub.last_update_date,
2105: hz_utility_v2pub.last_updated_by);
2106:
2107: END IF;
2108: END IF;--l_temp_flag-- bug 4867151

Line 2105: hz_utility_v2pub.last_updated_by);

2101: hz_utility_v2pub.created_by,
2102: hz_utility_v2pub.creation_Date,
2103: hz_utility_v2pub.last_update_login,
2104: hz_utility_v2pub.last_update_date,
2105: hz_utility_v2pub.last_updated_by);
2106:
2107: END IF;
2108: END IF;--l_temp_flag-- bug 4867151
2109: -- bug 5194384

Line 2576: , last_update_date = hz_utility_v2pub.last_update_date

2572:
2573: UPDATE HZ_MERGE_PARTYDTLS_SUGG
2574: SET merge_to_entity_id = l_master_site
2575: , mandatory_merge = 'N'
2576: , last_update_date = hz_utility_v2pub.last_update_date
2577: , last_updated_by = hz_utility_v2pub.last_updated_by
2578: , last_update_login = hz_utility_v2pub.last_update_login
2579: WHERE batch_party_id IN
2580: ( SELECT batch_party_id

Line 2577: , last_updated_by = hz_utility_v2pub.last_updated_by

2573: UPDATE HZ_MERGE_PARTYDTLS_SUGG
2574: SET merge_to_entity_id = l_master_site
2575: , mandatory_merge = 'N'
2576: , last_update_date = hz_utility_v2pub.last_update_date
2577: , last_updated_by = hz_utility_v2pub.last_updated_by
2578: , last_update_login = hz_utility_v2pub.last_update_login
2579: WHERE batch_party_id IN
2580: ( SELECT batch_party_id
2581: FROM HZ_MERGE_PARTIES_SUGG

Line 2578: , last_update_login = hz_utility_v2pub.last_update_login

2574: SET merge_to_entity_id = l_master_site
2575: , mandatory_merge = 'N'
2576: , last_update_date = hz_utility_v2pub.last_update_date
2577: , last_updated_by = hz_utility_v2pub.last_updated_by
2578: , last_update_login = hz_utility_v2pub.last_update_login
2579: WHERE batch_party_id IN
2580: ( SELECT batch_party_id
2581: FROM HZ_MERGE_PARTIES_SUGG
2582: WHERE batch_id = p_batch_id )

Line 2714: ,hz_utility_v2pub.created_by

2710: ,'HZ_PARTY_SITES'
2711: ,l_merge_from_site
2712: ,l_master_site
2713: ,'N'
2714: ,hz_utility_v2pub.created_by
2715: ,hz_utility_v2pub.creation_date
2716: ,hz_utility_v2pub.last_update_login
2717: ,hz_utility_v2pub.last_update_date
2718: ,hz_utility_v2pub.last_updated_by

Line 2715: ,hz_utility_v2pub.creation_date

2711: ,l_merge_from_site
2712: ,l_master_site
2713: ,'N'
2714: ,hz_utility_v2pub.created_by
2715: ,hz_utility_v2pub.creation_date
2716: ,hz_utility_v2pub.last_update_login
2717: ,hz_utility_v2pub.last_update_date
2718: ,hz_utility_v2pub.last_updated_by
2719: ,1

Line 2716: ,hz_utility_v2pub.last_update_login

2712: ,l_master_site
2713: ,'N'
2714: ,hz_utility_v2pub.created_by
2715: ,hz_utility_v2pub.creation_date
2716: ,hz_utility_v2pub.last_update_login
2717: ,hz_utility_v2pub.last_update_date
2718: ,hz_utility_v2pub.last_updated_by
2719: ,1
2720: );

Line 2717: ,hz_utility_v2pub.last_update_date

2713: ,'N'
2714: ,hz_utility_v2pub.created_by
2715: ,hz_utility_v2pub.creation_date
2716: ,hz_utility_v2pub.last_update_login
2717: ,hz_utility_v2pub.last_update_date
2718: ,hz_utility_v2pub.last_updated_by
2719: ,1
2720: );
2721: END IF;--l_flag_merge

Line 2718: ,hz_utility_v2pub.last_updated_by

2714: ,hz_utility_v2pub.created_by
2715: ,hz_utility_v2pub.creation_date
2716: ,hz_utility_v2pub.last_update_login
2717: ,hz_utility_v2pub.last_update_date
2718: ,hz_utility_v2pub.last_updated_by
2719: ,1
2720: );
2721: END IF;--l_flag_merge
2722: END IF; --l_merge_yn

Line 2955: , last_update_date = hz_utility_v2pub.last_update_date

2951:
2952: UPDATE HZ_MERGE_PARTYDTLS_SUGG
2953: SET merge_to_entity_id = l_reln_id
2954: , mandatory_merge = 'N'
2955: , last_update_date = hz_utility_v2pub.last_update_date
2956: , last_updated_by = hz_utility_v2pub.last_updated_by
2957: , last_update_login = hz_utility_v2pub.last_update_login
2958: WHERE batch_party_id in
2959: ( SELECT batch_party_id

Line 2956: , last_updated_by = hz_utility_v2pub.last_updated_by

2952: UPDATE HZ_MERGE_PARTYDTLS_SUGG
2953: SET merge_to_entity_id = l_reln_id
2954: , mandatory_merge = 'N'
2955: , last_update_date = hz_utility_v2pub.last_update_date
2956: , last_updated_by = hz_utility_v2pub.last_updated_by
2957: , last_update_login = hz_utility_v2pub.last_update_login
2958: WHERE batch_party_id in
2959: ( SELECT batch_party_id
2960: FROM HZ_MERGE_PARTIES_SUGG

Line 2957: , last_update_login = hz_utility_v2pub.last_update_login

2953: SET merge_to_entity_id = l_reln_id
2954: , mandatory_merge = 'N'
2955: , last_update_date = hz_utility_v2pub.last_update_date
2956: , last_updated_by = hz_utility_v2pub.last_updated_by
2957: , last_update_login = hz_utility_v2pub.last_update_login
2958: WHERE batch_party_id in
2959: ( SELECT batch_party_id
2960: FROM HZ_MERGE_PARTIES_SUGG
2961: WHERE batch_id = p_batch_id )

Line 3115: ,hz_utility_v2pub.created_by

3111: ,'HZ_PARTY_RELATIONSHIPS'
3112: ,l_merge_from_reln
3113: ,l_reln_id
3114: ,'N'
3115: ,hz_utility_v2pub.created_by
3116: ,hz_utility_v2pub.creation_date
3117: ,hz_utility_v2pub.last_update_login
3118: ,hz_utility_v2pub.last_update_date
3119: ,hz_utility_v2pub.last_updated_by

Line 3116: ,hz_utility_v2pub.creation_date

3112: ,l_merge_from_reln
3113: ,l_reln_id
3114: ,'N'
3115: ,hz_utility_v2pub.created_by
3116: ,hz_utility_v2pub.creation_date
3117: ,hz_utility_v2pub.last_update_login
3118: ,hz_utility_v2pub.last_update_date
3119: ,hz_utility_v2pub.last_updated_by
3120: ,1

Line 3117: ,hz_utility_v2pub.last_update_login

3113: ,l_reln_id
3114: ,'N'
3115: ,hz_utility_v2pub.created_by
3116: ,hz_utility_v2pub.creation_date
3117: ,hz_utility_v2pub.last_update_login
3118: ,hz_utility_v2pub.last_update_date
3119: ,hz_utility_v2pub.last_updated_by
3120: ,1
3121: );

Line 3118: ,hz_utility_v2pub.last_update_date

3114: ,'N'
3115: ,hz_utility_v2pub.created_by
3116: ,hz_utility_v2pub.creation_date
3117: ,hz_utility_v2pub.last_update_login
3118: ,hz_utility_v2pub.last_update_date
3119: ,hz_utility_v2pub.last_updated_by
3120: ,1
3121: );
3122:

Line 3119: ,hz_utility_v2pub.last_updated_by

3115: ,hz_utility_v2pub.created_by
3116: ,hz_utility_v2pub.creation_date
3117: ,hz_utility_v2pub.last_update_login
3118: ,hz_utility_v2pub.last_update_date
3119: ,hz_utility_v2pub.last_updated_by
3120: ,1
3121: );
3122:
3123: -- find out those related party sites

Line 3235: ,hz_utility_v2pub.created_by

3231: ,'HZ_PARTY_SITES'
3232: ,l_ps_id
3233: ,l_dup_ps_id
3234: ,l_mandatory_merge
3235: ,hz_utility_v2pub.created_by
3236: ,hz_utility_v2pub.creation_date
3237: ,hz_utility_v2pub.last_update_login
3238: ,hz_utility_v2pub.last_update_date
3239: ,hz_utility_v2pub.last_updated_by

Line 3236: ,hz_utility_v2pub.creation_date

3232: ,l_ps_id
3233: ,l_dup_ps_id
3234: ,l_mandatory_merge
3235: ,hz_utility_v2pub.created_by
3236: ,hz_utility_v2pub.creation_date
3237: ,hz_utility_v2pub.last_update_login
3238: ,hz_utility_v2pub.last_update_date
3239: ,hz_utility_v2pub.last_updated_by
3240: ,1

Line 3237: ,hz_utility_v2pub.last_update_login

3233: ,l_dup_ps_id
3234: ,l_mandatory_merge
3235: ,hz_utility_v2pub.created_by
3236: ,hz_utility_v2pub.creation_date
3237: ,hz_utility_v2pub.last_update_login
3238: ,hz_utility_v2pub.last_update_date
3239: ,hz_utility_v2pub.last_updated_by
3240: ,1
3241: );

Line 3238: ,hz_utility_v2pub.last_update_date

3234: ,l_mandatory_merge
3235: ,hz_utility_v2pub.created_by
3236: ,hz_utility_v2pub.creation_date
3237: ,hz_utility_v2pub.last_update_login
3238: ,hz_utility_v2pub.last_update_date
3239: ,hz_utility_v2pub.last_updated_by
3240: ,1
3241: );
3242: ELSE

Line 3239: ,hz_utility_v2pub.last_updated_by

3235: ,hz_utility_v2pub.created_by
3236: ,hz_utility_v2pub.creation_date
3237: ,hz_utility_v2pub.last_update_login
3238: ,hz_utility_v2pub.last_update_date
3239: ,hz_utility_v2pub.last_updated_by
3240: ,1
3241: );
3242: ELSE
3243: IF p_reln_parties = 'N' THEN

Line 3265: ,hz_utility_v2pub.created_by

3261: ,'HZ_PARTY_SITES'
3262: ,l_ps_id
3263: ,null
3264: ,'N'
3265: ,hz_utility_v2pub.created_by
3266: ,hz_utility_v2pub.creation_date
3267: ,hz_utility_v2pub.last_update_login
3268: ,hz_utility_v2pub.last_update_date
3269: ,hz_utility_v2pub.last_updated_by

Line 3266: ,hz_utility_v2pub.creation_date

3262: ,l_ps_id
3263: ,null
3264: ,'N'
3265: ,hz_utility_v2pub.created_by
3266: ,hz_utility_v2pub.creation_date
3267: ,hz_utility_v2pub.last_update_login
3268: ,hz_utility_v2pub.last_update_date
3269: ,hz_utility_v2pub.last_updated_by
3270: ,1

Line 3267: ,hz_utility_v2pub.last_update_login

3263: ,null
3264: ,'N'
3265: ,hz_utility_v2pub.created_by
3266: ,hz_utility_v2pub.creation_date
3267: ,hz_utility_v2pub.last_update_login
3268: ,hz_utility_v2pub.last_update_date
3269: ,hz_utility_v2pub.last_updated_by
3270: ,1
3271: );

Line 3268: ,hz_utility_v2pub.last_update_date

3264: ,'N'
3265: ,hz_utility_v2pub.created_by
3266: ,hz_utility_v2pub.creation_date
3267: ,hz_utility_v2pub.last_update_login
3268: ,hz_utility_v2pub.last_update_date
3269: ,hz_utility_v2pub.last_updated_by
3270: ,1
3271: );
3272: ELSE

Line 3269: ,hz_utility_v2pub.last_updated_by

3265: ,hz_utility_v2pub.created_by
3266: ,hz_utility_v2pub.creation_date
3267: ,hz_utility_v2pub.last_update_login
3268: ,hz_utility_v2pub.last_update_date
3269: ,hz_utility_v2pub.last_updated_by
3270: ,1
3271: );
3272: ELSE
3273: INSERT INTO HZ_MERGE_PARTYDTLS_SUGG

Line 3294: ,hz_utility_v2pub.created_by

3290: ,'HZ_PARTY_SITES'
3291: ,l_ps_id
3292: ,l_ps_id
3293: ,'N'
3294: ,hz_utility_v2pub.created_by
3295: ,hz_utility_v2pub.creation_date
3296: ,hz_utility_v2pub.last_update_login
3297: ,hz_utility_v2pub.last_update_date
3298: ,hz_utility_v2pub.last_updated_by

Line 3295: ,hz_utility_v2pub.creation_date

3291: ,l_ps_id
3292: ,l_ps_id
3293: ,'N'
3294: ,hz_utility_v2pub.created_by
3295: ,hz_utility_v2pub.creation_date
3296: ,hz_utility_v2pub.last_update_login
3297: ,hz_utility_v2pub.last_update_date
3298: ,hz_utility_v2pub.last_updated_by
3299: ,1

Line 3296: ,hz_utility_v2pub.last_update_login

3292: ,l_ps_id
3293: ,'N'
3294: ,hz_utility_v2pub.created_by
3295: ,hz_utility_v2pub.creation_date
3296: ,hz_utility_v2pub.last_update_login
3297: ,hz_utility_v2pub.last_update_date
3298: ,hz_utility_v2pub.last_updated_by
3299: ,1
3300: );

Line 3297: ,hz_utility_v2pub.last_update_date

3293: ,'N'
3294: ,hz_utility_v2pub.created_by
3295: ,hz_utility_v2pub.creation_date
3296: ,hz_utility_v2pub.last_update_login
3297: ,hz_utility_v2pub.last_update_date
3298: ,hz_utility_v2pub.last_updated_by
3299: ,1
3300: );
3301: END IF; -- p_reln_parties = 'N'

Line 3298: ,hz_utility_v2pub.last_updated_by

3294: ,hz_utility_v2pub.created_by
3295: ,hz_utility_v2pub.creation_date
3296: ,hz_utility_v2pub.last_update_login
3297: ,hz_utility_v2pub.last_update_date
3298: ,hz_utility_v2pub.last_updated_by
3299: ,1
3300: );
3301: END IF; -- p_reln_parties = 'N'
3302: END IF;

Line 3349: ,hz_utility_v2pub.created_by

3345: ,p_from_rel_party_id
3346: ,p_to_rel_party_id
3347: ,'DUPLICATE_RELN_PARTY'
3348: ,'PENDING'
3349: ,hz_utility_v2pub.created_by
3350: ,hz_utility_v2pub.creation_date
3351: ,hz_utility_v2pub.last_update_login
3352: ,hz_utility_v2pub.last_update_date
3353: ,hz_utility_v2pub.last_updated_by

Line 3350: ,hz_utility_v2pub.creation_date

3346: ,p_to_rel_party_id
3347: ,'DUPLICATE_RELN_PARTY'
3348: ,'PENDING'
3349: ,hz_utility_v2pub.created_by
3350: ,hz_utility_v2pub.creation_date
3351: ,hz_utility_v2pub.last_update_login
3352: ,hz_utility_v2pub.last_update_date
3353: ,hz_utility_v2pub.last_updated_by
3354: );

Line 3351: ,hz_utility_v2pub.last_update_login

3347: ,'DUPLICATE_RELN_PARTY'
3348: ,'PENDING'
3349: ,hz_utility_v2pub.created_by
3350: ,hz_utility_v2pub.creation_date
3351: ,hz_utility_v2pub.last_update_login
3352: ,hz_utility_v2pub.last_update_date
3353: ,hz_utility_v2pub.last_updated_by
3354: );
3355:

Line 3352: ,hz_utility_v2pub.last_update_date

3348: ,'PENDING'
3349: ,hz_utility_v2pub.created_by
3350: ,hz_utility_v2pub.creation_date
3351: ,hz_utility_v2pub.last_update_login
3352: ,hz_utility_v2pub.last_update_date
3353: ,hz_utility_v2pub.last_updated_by
3354: );
3355:
3356: EXCEPTION

Line 3353: ,hz_utility_v2pub.last_updated_by

3349: ,hz_utility_v2pub.created_by
3350: ,hz_utility_v2pub.creation_date
3351: ,hz_utility_v2pub.last_update_login
3352: ,hz_utility_v2pub.last_update_date
3353: ,hz_utility_v2pub.last_updated_by
3354: );
3355:
3356: EXCEPTION
3357: WHEN OTHERS THEN

Line 3433: ,hz_utility_v2pub.created_by

3429: ,entity_name
3430: ,merge_from_entity_id
3431: ,merge_to_entity_id
3432: ,mandatory_merge
3433: ,hz_utility_v2pub.created_by
3434: ,hz_utility_v2pub.creation_date
3435: ,hz_utility_v2pub.last_update_login
3436: ,hz_utility_v2pub.last_updated_by
3437: ,hz_utility_v2pub.last_update_date

Line 3434: ,hz_utility_v2pub.creation_date

3430: ,merge_from_entity_id
3431: ,merge_to_entity_id
3432: ,mandatory_merge
3433: ,hz_utility_v2pub.created_by
3434: ,hz_utility_v2pub.creation_date
3435: ,hz_utility_v2pub.last_update_login
3436: ,hz_utility_v2pub.last_updated_by
3437: ,hz_utility_v2pub.last_update_date
3438: ,1

Line 3435: ,hz_utility_v2pub.last_update_login

3431: ,merge_to_entity_id
3432: ,mandatory_merge
3433: ,hz_utility_v2pub.created_by
3434: ,hz_utility_v2pub.creation_date
3435: ,hz_utility_v2pub.last_update_login
3436: ,hz_utility_v2pub.last_updated_by
3437: ,hz_utility_v2pub.last_update_date
3438: ,1
3439: FROM HZ_MERGE_PARTYDTLS_SUGG

Line 3436: ,hz_utility_v2pub.last_updated_by

3432: ,mandatory_merge
3433: ,hz_utility_v2pub.created_by
3434: ,hz_utility_v2pub.creation_date
3435: ,hz_utility_v2pub.last_update_login
3436: ,hz_utility_v2pub.last_updated_by
3437: ,hz_utility_v2pub.last_update_date
3438: ,1
3439: FROM HZ_MERGE_PARTYDTLS_SUGG
3440: WHERE entity_name = p_entity_name

Line 3437: ,hz_utility_v2pub.last_update_date

3433: ,hz_utility_v2pub.created_by
3434: ,hz_utility_v2pub.creation_date
3435: ,hz_utility_v2pub.last_update_login
3436: ,hz_utility_v2pub.last_updated_by
3437: ,hz_utility_v2pub.last_update_date
3438: ,1
3439: FROM HZ_MERGE_PARTYDTLS_SUGG
3440: WHERE entity_name = p_entity_name
3441: AND batch_party_id IN

Line 3597: mpd.last_update_login = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN ,

3593: FROM HZ_MERGE_PARTYDTLS_SUGG mps
3594: WHERE mpd.batch_party_id = mps.batch_party_id
3595: AND mpd.merge_from_entity_id = mps.merge_from_entity_id
3596: AND mpd.entity_name = mps.entity_name ),
3597: mpd.last_update_login = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN ,
3598: mpd.last_updated_by = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
3599: mpd.last_update_date = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
3600: mpd.object_version_number = nvl(mpd.object_version_number,1)+1
3601: WHERE entity_name = p_entity_name

Line 3598: mpd.last_updated_by = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

3594: WHERE mpd.batch_party_id = mps.batch_party_id
3595: AND mpd.merge_from_entity_id = mps.merge_from_entity_id
3596: AND mpd.entity_name = mps.entity_name ),
3597: mpd.last_update_login = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN ,
3598: mpd.last_updated_by = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
3599: mpd.last_update_date = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
3600: mpd.object_version_number = nvl(mpd.object_version_number,1)+1
3601: WHERE entity_name = p_entity_name
3602: AND batch_party_id IN

Line 3599: mpd.last_update_date = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

3595: AND mpd.merge_from_entity_id = mps.merge_from_entity_id
3596: AND mpd.entity_name = mps.entity_name ),
3597: mpd.last_update_login = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN ,
3598: mpd.last_updated_by = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
3599: mpd.last_update_date = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
3600: mpd.object_version_number = nvl(mpd.object_version_number,1)+1
3601: WHERE entity_name = p_entity_name
3602: AND batch_party_id IN
3603: ( SELECT batch_party_id

Line 3651: ,hz_utility_v2pub.created_by

3647: ,entity_name
3648: ,merge_from_entity_id
3649: ,merge_to_entity_id
3650: ,mandatory_merge
3651: ,hz_utility_v2pub.created_by
3652: ,hz_utility_v2pub.creation_date
3653: ,hz_utility_v2pub.last_update_login
3654: ,hz_utility_v2pub.last_updated_by
3655: ,hz_utility_v2pub.last_update_date

Line 3652: ,hz_utility_v2pub.creation_date

3648: ,merge_from_entity_id
3649: ,merge_to_entity_id
3650: ,mandatory_merge
3651: ,hz_utility_v2pub.created_by
3652: ,hz_utility_v2pub.creation_date
3653: ,hz_utility_v2pub.last_update_login
3654: ,hz_utility_v2pub.last_updated_by
3655: ,hz_utility_v2pub.last_update_date
3656: ,1

Line 3653: ,hz_utility_v2pub.last_update_login

3649: ,merge_to_entity_id
3650: ,mandatory_merge
3651: ,hz_utility_v2pub.created_by
3652: ,hz_utility_v2pub.creation_date
3653: ,hz_utility_v2pub.last_update_login
3654: ,hz_utility_v2pub.last_updated_by
3655: ,hz_utility_v2pub.last_update_date
3656: ,1
3657: FROM HZ_MERGE_PARTYDTLS_SUGG

Line 3654: ,hz_utility_v2pub.last_updated_by

3650: ,mandatory_merge
3651: ,hz_utility_v2pub.created_by
3652: ,hz_utility_v2pub.creation_date
3653: ,hz_utility_v2pub.last_update_login
3654: ,hz_utility_v2pub.last_updated_by
3655: ,hz_utility_v2pub.last_update_date
3656: ,1
3657: FROM HZ_MERGE_PARTYDTLS_SUGG
3658: WHERE mandatory_merge = 'Y'

Line 3655: ,hz_utility_v2pub.last_update_date

3651: ,hz_utility_v2pub.created_by
3652: ,hz_utility_v2pub.creation_date
3653: ,hz_utility_v2pub.last_update_login
3654: ,hz_utility_v2pub.last_updated_by
3655: ,hz_utility_v2pub.last_update_date
3656: ,1
3657: FROM HZ_MERGE_PARTYDTLS_SUGG
3658: WHERE mandatory_merge = 'Y'
3659: AND entity_name = p_entity_name

Line 4506: if HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE <> 'BO_API' -- BO API handled overlapping logic already. Skip it here.

4502: IF FND_API.to_Boolean( p_init_msg_list )
4503: THEN
4504: FND_MSG_PUB.initialize;
4505: END IF;
4506: if HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE <> 'BO_API' -- BO API handled overlapping logic already. Skip it here.
4507: then
4508: if p_dup_set_id is not null -- data passed in from Data librarian(DL) UI
4509: -- or sys dup identification from FORM
4510: then

Line 4567: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

4563: -- Update dup set status to 'Error'
4564: UPDATE HZ_DUP_SETS
4565: SET STATUS = 'ERROR',
4566: OBJECT_VERSION_NUMBER = nvl(OBJECT_VERSION_NUMBER,1)+1,
4567: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
4568: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
4569: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
4570: WHERE DUP_SET_ID = p_dup_set_id;
4571:

Line 4568: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

4564: UPDATE HZ_DUP_SETS
4565: SET STATUS = 'ERROR',
4566: OBJECT_VERSION_NUMBER = nvl(OBJECT_VERSION_NUMBER,1)+1,
4567: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
4568: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
4569: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
4570: WHERE DUP_SET_ID = p_dup_set_id;
4571:
4572: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4569: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY

4565: SET STATUS = 'ERROR',
4566: OBJECT_VERSION_NUMBER = nvl(OBJECT_VERSION_NUMBER,1)+1,
4567: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
4568: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
4569: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
4570: WHERE DUP_SET_ID = p_dup_set_id;
4571:
4572: x_return_status := FND_API.G_RET_STS_ERROR;
4573: end if;

Line 4619: end if; --HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE <> 'BO_API'

4615: end loop;
4616: close batch_overlap_merged_party_csr;
4617:
4618: end if;
4619: end if; --HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE <> 'BO_API'
4620: EXCEPTION
4621: WHEN OTHERS THEN
4622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4623: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');