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_PARTY_MERGE dependencies on HZ_MERGE_BATCH

Line 310: FROM HZ_MERGE_BATCH

306: ) IS
307:
308: CURSOR c_batch(cp_batch_id NUMBER) IS
309: SELECT batch_name, rule_set_name, batch_status, batch_delete, batch_commit
310: FROM HZ_MERGE_BATCH
311: WHERE batch_id = cp_batch_id;
312:
313: -----Cursor for grouping parties based on distinct merge_to party-----
314: CURSOR c_pre_merge(cp_batch_id NUMBER) IS

Line 390: HZ_MERGE_BATCH mb

386: select dbat.request_type
387: from
388: HZ_DUP_BATCH dbat,
389: HZ_DUP_SETS dset,
390: HZ_MERGE_BATCH mb
391: where
392: dbat.dup_batch_id = dset.dup_batch_id
393: and mb.batch_id = dset.dup_set_id
394: and mb.batch_id = cp_batch_id;

Line 430: l_batch_name HZ_MERGE_BATCH.BATCH_NAME%TYPE;

426:
427: l_proc_name HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;
428: --end bug 4634891
429:
430: l_batch_name HZ_MERGE_BATCH.BATCH_NAME%TYPE;
431: l_rule_set_name HZ_MERGE_BATCH.RULE_SET_NAME%TYPE;
432: l_batch_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;
433: l_merge_status HZ_MERGE_PARTIES.MERGE_STATUS%TYPE;
434:

Line 431: l_rule_set_name HZ_MERGE_BATCH.RULE_SET_NAME%TYPE;

427: l_proc_name HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;
428: --end bug 4634891
429:
430: l_batch_name HZ_MERGE_BATCH.BATCH_NAME%TYPE;
431: l_rule_set_name HZ_MERGE_BATCH.RULE_SET_NAME%TYPE;
432: l_batch_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;
433: l_merge_status HZ_MERGE_PARTIES.MERGE_STATUS%TYPE;
434:
435: l_batch_commit HZ_MERGE_BATCH.BATCH_COMMIT%TYPE;

Line 432: l_batch_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;

428: --end bug 4634891
429:
430: l_batch_name HZ_MERGE_BATCH.BATCH_NAME%TYPE;
431: l_rule_set_name HZ_MERGE_BATCH.RULE_SET_NAME%TYPE;
432: l_batch_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;
433: l_merge_status HZ_MERGE_PARTIES.MERGE_STATUS%TYPE;
434:
435: l_batch_commit HZ_MERGE_BATCH.BATCH_COMMIT%TYPE;
436: l_batch_delete HZ_MERGE_BATCH.BATCH_DELETE%TYPE;

Line 435: l_batch_commit HZ_MERGE_BATCH.BATCH_COMMIT%TYPE;

431: l_rule_set_name HZ_MERGE_BATCH.RULE_SET_NAME%TYPE;
432: l_batch_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;
433: l_merge_status HZ_MERGE_PARTIES.MERGE_STATUS%TYPE;
434:
435: l_batch_commit HZ_MERGE_BATCH.BATCH_COMMIT%TYPE;
436: l_batch_delete HZ_MERGE_BATCH.BATCH_DELETE%TYPE;
437:
438: l_pre_merge_to_party_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;
439: l_pre_merge_type HZ_MERGE_PARTIES.MERGE_TYPE%TYPE;

Line 436: l_batch_delete HZ_MERGE_BATCH.BATCH_DELETE%TYPE;

432: l_batch_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;
433: l_merge_status HZ_MERGE_PARTIES.MERGE_STATUS%TYPE;
434:
435: l_batch_commit HZ_MERGE_BATCH.BATCH_COMMIT%TYPE;
436: l_batch_delete HZ_MERGE_BATCH.BATCH_DELETE%TYPE;
437:
438: l_pre_merge_to_party_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;
439: l_pre_merge_type HZ_MERGE_PARTIES.MERGE_TYPE%TYPE;
440:

Line 651: UPDATE HZ_MERGE_BATCH

647: hz_common_pub.disable_cont_source_security;
648:
649:
650: -- Stamp concurrent request id to batch
651: UPDATE HZ_MERGE_BATCH
652: SET REQUEST_ID = hz_utility_pub.request_id
653: WHERE batch_id = p_batch_id;
654:
655: -- If not preview mode update batch status to COMPLETE

Line 658: UPDATE HZ_MERGE_BATCH

654:
655: -- If not preview mode update batch status to COMPLETE
656: IF p_preview <> 'Y' then
657: -- Update the merge batch status to COMPLETE
658: UPDATE HZ_MERGE_BATCH
659: SET BATCH_STATUS = 'SUBMITTED'
660: WHERE BATCH_ID = p_batch_id;
661:
662: BEGIN

Line 678: -- Lock HZ_MERGE_BATCH, HZ_MERGE_PARTIES and HZ_MERGE_PARTY_DETAILS records

674: --Bug No: 3267877
675: SAVEPOINT batch_merge;
676: l_batch_merge_spt:=TRUE;
677:
678: -- Lock HZ_MERGE_BATCH, HZ_MERGE_PARTIES and HZ_MERGE_PARTY_DETAILS records
679: log ('.... Locking batch for execution');
680: lock_batch(p_batch_id, l_return_status);
681: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
682: ROLLBACK to batch_merge;

Line 1160: UPDATE HZ_MERGE_BATCH

1156:
1157: -- If not preview mode update batch status to COMPLETE
1158: IF p_preview <> 'Y' then
1159: -- Update the merge batch status to COMPLETE
1160: UPDATE HZ_MERGE_BATCH
1161: SET BATCH_STATUS = 'COMPLETE'
1162: WHERE BATCH_ID = p_batch_id;
1163:
1164: BEGIN

Line 1199: UPDATE HZ_MERGE_BATCH

1195: WHERE batch_id = p_batch_id
1196: AND merge_status = 'DONE';
1197:
1198: IF l_num_merged > 0 THEN
1199: UPDATE HZ_MERGE_BATCH
1200: SET BATCH_STATUS = 'PART_COMPLETE'
1201: WHERE BATCH_ID = p_batch_id;
1202:
1203: ELSE

Line 1205: UPDATE HZ_MERGE_BATCH

1201: WHERE BATCH_ID = p_batch_id;
1202:
1203: ELSE
1204: --BUG 4199594
1205: UPDATE HZ_MERGE_BATCH
1206: SET BATCH_STATUS = 'ERROR'
1207: WHERE BATCH_ID = p_batch_id;
1208:
1209: retcode:=2;

Line 2076: | Procedure to lock HZ_MERGE_BATCH, HZ_MERGE_PARTIES and HZ_MERGE_PARTY_DETAILS

2072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2073: END do_merge;
2074:
2075: /*------------------------------------------------------------------------------
2076: | Procedure to lock HZ_MERGE_BATCH, HZ_MERGE_PARTIES and HZ_MERGE_PARTY_DETAILS
2077: | for a given batch
2078: |-------------------------------------------------------------------------------*/
2079:
2080: PROCEDURE lock_batch(

Line 2096: EXECUTE IMMEDIATE 'SELECT batch_id from HZ_MERGE_BATCH ' ||

2092: EXECUTE IMMEDIATE 'SELECT batch_party_id from HZ_MERGE_PARTIES ' ||
2093: 'WHERE batch_id = :batchid FOR UPDATE NOWAIT' USING p_batch_id;
2094:
2095: -- Lock batch
2096: EXECUTE IMMEDIATE 'SELECT batch_id from HZ_MERGE_BATCH ' ||
2097: 'WHERE batch_id = :batchid FOR UPDATE NOWAIT' USING p_batch_id;
2098:
2099: EXCEPTION
2100: WHEN OTHERS THEN

Line 2101: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_BATCH_LOCK_ERROR');

2097: 'WHERE batch_id = :batchid FOR UPDATE NOWAIT' USING p_batch_id;
2098:
2099: EXCEPTION
2100: WHEN OTHERS THEN
2101: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_BATCH_LOCK_ERROR');
2102: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2103: FND_MSG_PUB.ADD;
2104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2105: END lock_batch;

Line 2880: FROM HZ_MERGE_BATCH

2876: p_batch_id IN NUMBER) IS
2877:
2878: CURSOR pre_batch(cp_batch_id NUMBER) IS
2879: SELECT batch_name, rule_set_name ,batch_status, batch_delete, batch_commit
2880: FROM HZ_MERGE_BATCH
2881: WHERE batch_id = cp_batch_id;
2882:
2883:
2884: CURSOR party_sites_for_pre_merge(cp_to_party_id IN NUMBER, cp_batch_id IN NUMBER) IS

Line 2931: l_batch_name HZ_MERGE_BATCH.BATCH_NAME%TYPE;

2927: and to_party_id<>from_party_id
2928: and batch_id = cp_batch_id)
2929: and d2.merge_from_entity_id <> d1.merge_to_entity_id );
2930:
2931: l_batch_name HZ_MERGE_BATCH.BATCH_NAME%TYPE;
2932: l_rule_set_name HZ_MERGE_BATCH.RULE_SET_NAME%TYPE;
2933: l_batch_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;
2934: l_merge_status HZ_MERGE_PARTIES.MERGE_STATUS%TYPE;
2935:

Line 2932: l_rule_set_name HZ_MERGE_BATCH.RULE_SET_NAME%TYPE;

2928: and batch_id = cp_batch_id)
2929: and d2.merge_from_entity_id <> d1.merge_to_entity_id );
2930:
2931: l_batch_name HZ_MERGE_BATCH.BATCH_NAME%TYPE;
2932: l_rule_set_name HZ_MERGE_BATCH.RULE_SET_NAME%TYPE;
2933: l_batch_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;
2934: l_merge_status HZ_MERGE_PARTIES.MERGE_STATUS%TYPE;
2935:
2936: l_batch_commit HZ_MERGE_BATCH.BATCH_COMMIT%TYPE;

Line 2933: l_batch_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;

2929: and d2.merge_from_entity_id <> d1.merge_to_entity_id );
2930:
2931: l_batch_name HZ_MERGE_BATCH.BATCH_NAME%TYPE;
2932: l_rule_set_name HZ_MERGE_BATCH.RULE_SET_NAME%TYPE;
2933: l_batch_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;
2934: l_merge_status HZ_MERGE_PARTIES.MERGE_STATUS%TYPE;
2935:
2936: l_batch_commit HZ_MERGE_BATCH.BATCH_COMMIT%TYPE;
2937: l_batch_delete HZ_MERGE_BATCH.BATCH_DELETE%TYPE;

Line 2936: l_batch_commit HZ_MERGE_BATCH.BATCH_COMMIT%TYPE;

2932: l_rule_set_name HZ_MERGE_BATCH.RULE_SET_NAME%TYPE;
2933: l_batch_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;
2934: l_merge_status HZ_MERGE_PARTIES.MERGE_STATUS%TYPE;
2935:
2936: l_batch_commit HZ_MERGE_BATCH.BATCH_COMMIT%TYPE;
2937: l_batch_delete HZ_MERGE_BATCH.BATCH_DELETE%TYPE;
2938:
2939: l_batch_party_id HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE;
2940: l_from_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;

Line 2937: l_batch_delete HZ_MERGE_BATCH.BATCH_DELETE%TYPE;

2933: l_batch_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;
2934: l_merge_status HZ_MERGE_PARTIES.MERGE_STATUS%TYPE;
2935:
2936: l_batch_commit HZ_MERGE_BATCH.BATCH_COMMIT%TYPE;
2937: l_batch_delete HZ_MERGE_BATCH.BATCH_DELETE%TYPE;
2938:
2939: l_batch_party_id HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE;
2940: l_from_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;
2941: l_merge_to_entity_id hz_merge_party_details.merge_to_entity_id%TYPE;

Line 3356: FROM HZ_MERGE_PARTIES p, HZ_MERGE_BATCH b

3352: ) IS
3353:
3354: CURSOR c_merge_batch IS
3355: SELECT b.batch_id, b.batch_name, b.created_by, b.creation_date
3356: FROM HZ_MERGE_PARTIES p, HZ_MERGE_BATCH b
3357: WHERE b.batch_id = p.batch_id
3358: AND b.batch_status <> 'COMPLETE'
3359: AND (p.from_party_id = p_party_id
3360: OR p.to_party_id = p_party_id);