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 291: FROM HZ_MERGE_BATCH

287: ) IS
288:
289: CURSOR c_batch(cp_batch_id NUMBER) IS
290: SELECT batch_name, rule_set_name, batch_status, batch_delete, batch_commit
291: FROM HZ_MERGE_BATCH
292: WHERE batch_id = cp_batch_id;
293:
294: -----Cursor for grouping parties based on distinct merge_to party-----
295: CURSOR c_pre_merge(cp_batch_id NUMBER) IS

Line 367: HZ_MERGE_BATCH mb

363: select dbat.request_type
364: from
365: HZ_DUP_BATCH dbat,
366: HZ_DUP_SETS dset,
367: HZ_MERGE_BATCH mb
368: where
369: dbat.dup_batch_id = dset.dup_batch_id
370: and mb.batch_id = dset.dup_set_id
371: and mb.batch_id = cp_batch_id;

Line 407: l_batch_name HZ_MERGE_BATCH.BATCH_NAME%TYPE;

403:
404: l_proc_name HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;
405: --end bug 4634891
406:
407: l_batch_name HZ_MERGE_BATCH.BATCH_NAME%TYPE;
408: l_rule_set_name HZ_MERGE_BATCH.RULE_SET_NAME%TYPE;
409: l_batch_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;
410: l_merge_status HZ_MERGE_PARTIES.MERGE_STATUS%TYPE;
411:

Line 408: l_rule_set_name HZ_MERGE_BATCH.RULE_SET_NAME%TYPE;

404: l_proc_name HZ_MERGE_DICTIONARY.PROCEDURE_NAME%TYPE;
405: --end bug 4634891
406:
407: l_batch_name HZ_MERGE_BATCH.BATCH_NAME%TYPE;
408: l_rule_set_name HZ_MERGE_BATCH.RULE_SET_NAME%TYPE;
409: l_batch_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;
410: l_merge_status HZ_MERGE_PARTIES.MERGE_STATUS%TYPE;
411:
412: l_batch_commit HZ_MERGE_BATCH.BATCH_COMMIT%TYPE;

Line 409: l_batch_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;

405: --end bug 4634891
406:
407: l_batch_name HZ_MERGE_BATCH.BATCH_NAME%TYPE;
408: l_rule_set_name HZ_MERGE_BATCH.RULE_SET_NAME%TYPE;
409: l_batch_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;
410: l_merge_status HZ_MERGE_PARTIES.MERGE_STATUS%TYPE;
411:
412: l_batch_commit HZ_MERGE_BATCH.BATCH_COMMIT%TYPE;
413: l_batch_delete HZ_MERGE_BATCH.BATCH_DELETE%TYPE;

Line 412: l_batch_commit HZ_MERGE_BATCH.BATCH_COMMIT%TYPE;

408: l_rule_set_name HZ_MERGE_BATCH.RULE_SET_NAME%TYPE;
409: l_batch_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;
410: l_merge_status HZ_MERGE_PARTIES.MERGE_STATUS%TYPE;
411:
412: l_batch_commit HZ_MERGE_BATCH.BATCH_COMMIT%TYPE;
413: l_batch_delete HZ_MERGE_BATCH.BATCH_DELETE%TYPE;
414:
415: l_pre_merge_to_party_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;
416: l_pre_merge_type HZ_MERGE_PARTIES.MERGE_TYPE%TYPE;

Line 413: l_batch_delete HZ_MERGE_BATCH.BATCH_DELETE%TYPE;

409: l_batch_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;
410: l_merge_status HZ_MERGE_PARTIES.MERGE_STATUS%TYPE;
411:
412: l_batch_commit HZ_MERGE_BATCH.BATCH_COMMIT%TYPE;
413: l_batch_delete HZ_MERGE_BATCH.BATCH_DELETE%TYPE;
414:
415: l_pre_merge_to_party_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;
416: l_pre_merge_type HZ_MERGE_PARTIES.MERGE_TYPE%TYPE;
417:

Line 628: UPDATE HZ_MERGE_BATCH

624: hz_common_pub.disable_cont_source_security;
625:
626:
627: -- Stamp concurrent request id to batch
628: UPDATE HZ_MERGE_BATCH
629: SET REQUEST_ID = hz_utility_pub.request_id
630: WHERE batch_id = p_batch_id;
631:
632: -- If not preview mode update batch status to COMPLETE

Line 635: UPDATE HZ_MERGE_BATCH

631:
632: -- If not preview mode update batch status to COMPLETE
633: IF p_preview <> 'Y' then
634: -- Update the merge batch status to COMPLETE
635: UPDATE HZ_MERGE_BATCH
636: SET BATCH_STATUS = 'SUBMITTED'
637: WHERE BATCH_ID = p_batch_id;
638:
639: BEGIN

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

651: --Bug No: 3267877
652: SAVEPOINT batch_merge;
653: l_batch_merge_spt:=TRUE;
654:
655: -- Lock HZ_MERGE_BATCH, HZ_MERGE_PARTIES and HZ_MERGE_PARTY_DETAILS records
656: log ('.... Locking batch for execution');
657: lock_batch(p_batch_id, l_return_status);
658: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
659: ROLLBACK to batch_merge;

Line 1123: UPDATE HZ_MERGE_BATCH

1119:
1120: -- If not preview mode update batch status to COMPLETE
1121: IF p_preview <> 'Y' then
1122: -- Update the merge batch status to COMPLETE
1123: UPDATE HZ_MERGE_BATCH
1124: SET BATCH_STATUS = 'COMPLETE'
1125: WHERE BATCH_ID = p_batch_id;
1126:
1127: BEGIN

Line 1162: UPDATE HZ_MERGE_BATCH

1158: WHERE batch_id = p_batch_id
1159: AND merge_status = 'DONE';
1160:
1161: IF l_num_merged > 0 THEN
1162: UPDATE HZ_MERGE_BATCH
1163: SET BATCH_STATUS = 'PART_COMPLETE'
1164: WHERE BATCH_ID = p_batch_id;
1165:
1166: ELSE

Line 1168: UPDATE HZ_MERGE_BATCH

1164: WHERE BATCH_ID = p_batch_id;
1165:
1166: ELSE
1167: --BUG 4199594
1168: UPDATE HZ_MERGE_BATCH
1169: SET BATCH_STATUS = 'ERROR'
1170: WHERE BATCH_ID = p_batch_id;
1171:
1172: retcode:=2;

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

2032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2033: END do_merge;
2034:
2035: /*------------------------------------------------------------------------------
2036: | Procedure to lock HZ_MERGE_BATCH, HZ_MERGE_PARTIES and HZ_MERGE_PARTY_DETAILS
2037: | for a given batch
2038: |-------------------------------------------------------------------------------*/
2039:
2040: PROCEDURE lock_batch(

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

2052: EXECUTE IMMEDIATE 'SELECT batch_party_id from HZ_MERGE_PARTIES ' ||
2053: 'WHERE batch_id = :batchid FOR UPDATE NOWAIT' USING p_batch_id;
2054:
2055: -- Lock batch
2056: EXECUTE IMMEDIATE 'SELECT batch_id from HZ_MERGE_BATCH ' ||
2057: 'WHERE batch_id = :batchid FOR UPDATE NOWAIT' USING p_batch_id;
2058:
2059: EXCEPTION
2060: WHEN OTHERS THEN

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

2057: 'WHERE batch_id = :batchid FOR UPDATE NOWAIT' USING p_batch_id;
2058:
2059: EXCEPTION
2060: WHEN OTHERS THEN
2061: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_BATCH_LOCK_ERROR');
2062: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2063: FND_MSG_PUB.ADD;
2064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2065: END lock_batch;

Line 2840: FROM HZ_MERGE_BATCH

2836: p_batch_id IN NUMBER) IS
2837:
2838: CURSOR pre_batch(cp_batch_id NUMBER) IS
2839: SELECT batch_name, rule_set_name ,batch_status, batch_delete, batch_commit
2840: FROM HZ_MERGE_BATCH
2841: WHERE batch_id = cp_batch_id;
2842:
2843:
2844: CURSOR party_sites_for_pre_merge(cp_to_party_id IN NUMBER, cp_batch_id IN NUMBER) IS

Line 2891: l_batch_name HZ_MERGE_BATCH.BATCH_NAME%TYPE;

2887: and to_party_id<>from_party_id
2888: and batch_id = cp_batch_id)
2889: and d2.merge_from_entity_id <> d1.merge_to_entity_id );
2890:
2891: l_batch_name HZ_MERGE_BATCH.BATCH_NAME%TYPE;
2892: l_rule_set_name HZ_MERGE_BATCH.RULE_SET_NAME%TYPE;
2893: l_batch_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;
2894: l_merge_status HZ_MERGE_PARTIES.MERGE_STATUS%TYPE;
2895:

Line 2892: l_rule_set_name HZ_MERGE_BATCH.RULE_SET_NAME%TYPE;

2888: and batch_id = cp_batch_id)
2889: and d2.merge_from_entity_id <> d1.merge_to_entity_id );
2890:
2891: l_batch_name HZ_MERGE_BATCH.BATCH_NAME%TYPE;
2892: l_rule_set_name HZ_MERGE_BATCH.RULE_SET_NAME%TYPE;
2893: l_batch_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;
2894: l_merge_status HZ_MERGE_PARTIES.MERGE_STATUS%TYPE;
2895:
2896: l_batch_commit HZ_MERGE_BATCH.BATCH_COMMIT%TYPE;

Line 2893: l_batch_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;

2889: and d2.merge_from_entity_id <> d1.merge_to_entity_id );
2890:
2891: l_batch_name HZ_MERGE_BATCH.BATCH_NAME%TYPE;
2892: l_rule_set_name HZ_MERGE_BATCH.RULE_SET_NAME%TYPE;
2893: l_batch_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;
2894: l_merge_status HZ_MERGE_PARTIES.MERGE_STATUS%TYPE;
2895:
2896: l_batch_commit HZ_MERGE_BATCH.BATCH_COMMIT%TYPE;
2897: l_batch_delete HZ_MERGE_BATCH.BATCH_DELETE%TYPE;

Line 2896: l_batch_commit HZ_MERGE_BATCH.BATCH_COMMIT%TYPE;

2892: l_rule_set_name HZ_MERGE_BATCH.RULE_SET_NAME%TYPE;
2893: l_batch_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;
2894: l_merge_status HZ_MERGE_PARTIES.MERGE_STATUS%TYPE;
2895:
2896: l_batch_commit HZ_MERGE_BATCH.BATCH_COMMIT%TYPE;
2897: l_batch_delete HZ_MERGE_BATCH.BATCH_DELETE%TYPE;
2898:
2899: l_batch_party_id HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE;
2900: l_from_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;

Line 2897: l_batch_delete HZ_MERGE_BATCH.BATCH_DELETE%TYPE;

2893: l_batch_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;
2894: l_merge_status HZ_MERGE_PARTIES.MERGE_STATUS%TYPE;
2895:
2896: l_batch_commit HZ_MERGE_BATCH.BATCH_COMMIT%TYPE;
2897: l_batch_delete HZ_MERGE_BATCH.BATCH_DELETE%TYPE;
2898:
2899: l_batch_party_id HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE;
2900: l_from_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;
2901: l_merge_to_entity_id hz_merge_party_details.merge_to_entity_id%TYPE;

Line 3316: FROM HZ_MERGE_PARTIES p, HZ_MERGE_BATCH b

3312: ) IS
3313:
3314: CURSOR c_merge_batch IS
3315: SELECT b.batch_id, b.batch_name, b.created_by, b.creation_date
3316: FROM HZ_MERGE_PARTIES p, HZ_MERGE_BATCH b
3317: WHERE b.batch_id = p.batch_id
3318: AND b.batch_status <> 'COMPLETE'
3319: AND (p.from_party_id = p_party_id
3320: OR p.to_party_id = p_party_id);