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 180: p_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,

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

Line 181: p_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,

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

Line 182: p_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

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

Line 183: p_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

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

Line 184: p_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY);

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

Line 216: p_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,

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

Line 217: p_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,

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

Line 218: p_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

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

Line 219: p_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

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

Line 220: p_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY);

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

Line 277: p_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,

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

Line 278: p_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,

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

Line 279: p_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

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

Line 280: p_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

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

Line 281: p_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY);

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

Line 739: HZ_UTILITY_V2PUB.CREATED_BY,

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

Line 740: HZ_UTILITY_V2PUB.CREATION_DATE,

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

Line 741: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

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

Line 742: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

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

Line 743: HZ_UTILITY_V2PUB.LAST_UPDATED_BY);

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

Line 819: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

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

Line 820: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

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

Line 821: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY

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

Line 826: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

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

Line 827: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

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

Line 828: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY

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

Line 1145: hz_utility_v2pub.created_by,

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

Line 1146: hz_utility_v2pub.creation_Date,

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

Line 1147: hz_utility_v2pub.last_update_login,

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

Line 1148: hz_utility_v2pub.last_update_date,

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

Line 1149: hz_utility_v2pub.last_updated_by);

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

Line 1188: hz_utility_v2pub.created_by,

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

Line 1189: hz_utility_v2pub.creation_Date,

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

Line 1190: hz_utility_v2pub.last_update_login,

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

Line 1191: hz_utility_v2pub.last_update_date,

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

Line 1192: hz_utility_v2pub.last_updated_by);

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

Line 1222: HZ_UTILITY_V2PUB.CREATED_BY,

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

Line 1223: HZ_UTILITY_V2PUB.CREATION_DATE,

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

Line 1224: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

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

Line 1225: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

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

Line 1226: HZ_UTILITY_V2PUB.LAST_UPDATED_BY);

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

Line 1275: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

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

Line 1276: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

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

Line 1277: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY

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

Line 1284: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

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

Line 1285: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

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

Line 1286: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY

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

Line 1488: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

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

Line 1489: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

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

Line 1490: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY

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

Line 1495: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

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

Line 1496: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

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

Line 1497: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY

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

Line 1630: HZ_UTILITY_V2PUB.CREATED_BY,

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

Line 1631: HZ_UTILITY_V2PUB.CREATION_DATE,

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

Line 1632: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

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

Line 1633: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

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

Line 1634: HZ_UTILITY_V2PUB.LAST_UPDATED_BY);

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

Line 1731: hz_utility_v2pub.created_by,

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

Line 1732: hz_utility_v2pub.creation_Date,

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

Line 1733: hz_utility_v2pub.last_update_login,

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

Line 1734: hz_utility_v2pub.last_update_date,

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

Line 1735: hz_utility_v2pub.last_updated_by);

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

Line 1745: hz_utility_v2pub.created_by,

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

Line 1746: hz_utility_v2pub.creation_Date,

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

Line 1747: hz_utility_v2pub.last_update_login,

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

Line 1748: hz_utility_v2pub.last_update_date,

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

Line 1749: hz_utility_v2pub.last_updated_by);

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

Line 2083: hz_utility_v2pub.created_by,

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

Line 2084: hz_utility_v2pub.creation_Date,

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

Line 2085: hz_utility_v2pub.last_update_login,

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

Line 2086: hz_utility_v2pub.last_update_date,

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

Line 2087: hz_utility_v2pub.last_updated_by);

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

Line 2100: hz_utility_v2pub.created_by,

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

Line 2101: hz_utility_v2pub.creation_Date,

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

Line 2102: hz_utility_v2pub.last_update_login,

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

Line 2103: hz_utility_v2pub.last_update_date,

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

Line 2104: hz_utility_v2pub.last_updated_by);

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

Line 2575: , last_update_date = hz_utility_v2pub.last_update_date

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

Line 2576: , last_updated_by = hz_utility_v2pub.last_updated_by

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

Line 2577: , last_update_login = hz_utility_v2pub.last_update_login

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

Line 2713: ,hz_utility_v2pub.created_by

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

Line 2714: ,hz_utility_v2pub.creation_date

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

Line 2715: ,hz_utility_v2pub.last_update_login

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

Line 2716: ,hz_utility_v2pub.last_update_date

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

Line 2717: ,hz_utility_v2pub.last_updated_by

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

Line 2953: , last_update_date = hz_utility_v2pub.last_update_date

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

Line 2954: , last_updated_by = hz_utility_v2pub.last_updated_by

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

Line 2955: , last_update_login = hz_utility_v2pub.last_update_login

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

Line 3113: ,hz_utility_v2pub.created_by

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

Line 3114: ,hz_utility_v2pub.creation_date

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

Line 3115: ,hz_utility_v2pub.last_update_login

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

Line 3116: ,hz_utility_v2pub.last_update_date

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

Line 3117: ,hz_utility_v2pub.last_updated_by

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

Line 3233: ,hz_utility_v2pub.created_by

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

Line 3234: ,hz_utility_v2pub.creation_date

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

Line 3235: ,hz_utility_v2pub.last_update_login

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

Line 3236: ,hz_utility_v2pub.last_update_date

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

Line 3237: ,hz_utility_v2pub.last_updated_by

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

Line 3263: ,hz_utility_v2pub.created_by

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

Line 3264: ,hz_utility_v2pub.creation_date

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

Line 3265: ,hz_utility_v2pub.last_update_login

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

Line 3266: ,hz_utility_v2pub.last_update_date

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

Line 3267: ,hz_utility_v2pub.last_updated_by

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

Line 3292: ,hz_utility_v2pub.created_by

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

Line 3293: ,hz_utility_v2pub.creation_date

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

Line 3294: ,hz_utility_v2pub.last_update_login

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

Line 3295: ,hz_utility_v2pub.last_update_date

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

Line 3296: ,hz_utility_v2pub.last_updated_by

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

Line 3347: ,hz_utility_v2pub.created_by

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

Line 3348: ,hz_utility_v2pub.creation_date

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

Line 3349: ,hz_utility_v2pub.last_update_login

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

Line 3350: ,hz_utility_v2pub.last_update_date

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

Line 3351: ,hz_utility_v2pub.last_updated_by

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

Line 3431: ,hz_utility_v2pub.created_by

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

Line 3432: ,hz_utility_v2pub.creation_date

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

Line 3433: ,hz_utility_v2pub.last_update_login

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

Line 3434: ,hz_utility_v2pub.last_updated_by

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

Line 3435: ,hz_utility_v2pub.last_update_date

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

Line 3595: mpd.last_update_login = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN ,

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

Line 3596: mpd.last_updated_by = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

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

Line 3597: mpd.last_update_date = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

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

Line 3649: ,hz_utility_v2pub.created_by

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

Line 3650: ,hz_utility_v2pub.creation_date

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

Line 3651: ,hz_utility_v2pub.last_update_login

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

Line 3652: ,hz_utility_v2pub.last_updated_by

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

Line 3653: ,hz_utility_v2pub.last_update_date

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

Line 4564: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

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

Line 4565: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

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

Line 4566: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY

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