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_MERGE_BATCH

Line 89: l_batch_id HZ_MERGE_BATCH.BATCH_ID%TYPE;

85: l_dup_set_count NUMBER;
86: l_default_mapping VARCHAR2(1);
87: l_party_type VARCHAR2(255);
88:
89: l_batch_id HZ_MERGE_BATCH.BATCH_ID%TYPE;
90: l_batch_name HZ_MERGE_BATCH.BATCH_NAME%TYPE;
91: l_batch_party_id HZ_DUP_SET_PARTIES.DUP_PARTY_ID%TYPE;
92: l_object_version_number NUMBER;
93: db_object_version_number NUMBER;

Line 90: l_batch_name HZ_MERGE_BATCH.BATCH_NAME%TYPE;

86: l_default_mapping VARCHAR2(1);
87: l_party_type VARCHAR2(255);
88:
89: l_batch_id HZ_MERGE_BATCH.BATCH_ID%TYPE;
90: l_batch_name HZ_MERGE_BATCH.BATCH_NAME%TYPE;
91: l_batch_party_id HZ_DUP_SET_PARTIES.DUP_PARTY_ID%TYPE;
92: l_object_version_number NUMBER;
93: db_object_version_number NUMBER;
94: l_automerge_flag varchar2(1);

Line 170: --Create a merge batch in HZ_MERGE_BATCH

166: end if;
167:
168:
169:
170: --Create a merge batch in HZ_MERGE_BATCH
171: HZ_MERGE_BATCH_PKG.INSERT_ROW(
172: px_BATCH_ID => l_batch_id,
173: p_RULE_SET_NAME => 'DEFAULT',
174: p_BATCH_NAME => l_batch_name,

Line 171: HZ_MERGE_BATCH_PKG.INSERT_ROW(

167:
168:
169:
170: --Create a merge batch in HZ_MERGE_BATCH
171: HZ_MERGE_BATCH_PKG.INSERT_ROW(
172: px_BATCH_ID => l_batch_id,
173: p_RULE_SET_NAME => 'DEFAULT',
174: p_BATCH_NAME => l_batch_name,
175: p_REQUEST_ID => NULL,

Line 188: UPDATE HZ_MERGE_BATCH

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
189: SET CREATED_BY_MODULE = l_created_by_module
190: WHERE batch_id = p_dup_set_id;
191:
192: IF l_merge_type='PARTY_MERGE' THEN

Line 490: l_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;

486:
487: l_total_count NUMBER;
488: l_count NUMBER;
489: l_batch_id NUMBER;
490: l_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;
491: l_loc NUMBER;
492: l_org NUMBER;
493: l_object_version_number NUMBER;
494: db_object_version_number NUMBER;

Line 824: UPDATE HZ_MERGE_BATCH

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',
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

Line 924: l_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;

920: l_from_party_id NUMBER;
921: l_to_party_id NUMBER;
922:
923: l_merge_type HZ_MERGE_PARTIES.MERGE_TYPE%TYPE;
924: l_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;
925: l_from_site_party_id NUMBER;
926: l_to_site_party_id NUMBER;
927: l_from_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;
928: l_to_rel_type HZ_RELATIONSHIPS.RELATIONSHIP_TYPE%TYPE;

Line 1282: UPDATE HZ_MERGE_BATCH

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:
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

Line 1379: l_batch_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;

1375: l_conc_dev_phase VARCHAR2(30);
1376: l_conc_dev_status VARCHAR2(30);
1377: l_message VARCHAR2(240);
1378: call_status boolean;
1379: l_batch_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;
1380: l_dup_set_status VARCHAR2(30);
1381: retcode number;
1382:
1383: BEGIN

Line 1398: FROM hz_merge_batch

1394: END IF;
1395:
1396: SELECT batch_status , request_id
1397: INTO l_batch_status ,l_last_request_id
1398: FROM hz_merge_batch
1399: WHERE batch_id = p_batch_id;
1400:
1401: -- a data librarian dup set must have merge batch
1402: SELECT ds.status

Line 1404: FROM hz_dup_sets ds, hz_merge_batch mb

1400:
1401: -- a data librarian dup set must have merge batch
1402: SELECT ds.status
1403: INTO l_dup_set_status
1404: FROM hz_dup_sets ds, hz_merge_batch mb
1405: WHERE ds.dup_set_id = mb.batch_id
1406: AND ds.dup_set_id = p_batch_id;
1407:
1408: IF l_last_request_id IS NOT NULL THEN

Line 1485: UPDATE HZ_MERGE_BATCH

1481:
1482: -- if batch is resubmitted, update the status
1483: -- fix bug 3081305
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,

Line 3878: from hz_merge_batch

3874: where party_id = l_party_id;
3875:
3876: cursor is_sugg_request_done_csr is
3877: select count(*)
3878: from hz_merge_batch
3879: where batch_id = p_batch_id
3880: and created_by_module = 'DL_DONESUGG';
3881:
3882:

Line 3920: update hz_merge_batch

3916: fnd_msg_pub.initialize;
3917:
3918: savepoint create_reln_sysbatch;
3919:
3920: update hz_merge_batch
3921: set created_by_module = 'DL_DONESUGG'
3922: where batch_id = p_batch_id;
3923:
3924:

Line 4410: -- Added new column created_by_module in hz_merge_batch instead of above checking

4406: and not exists ( select 'x'
4407: from hz_dup_set_parties dsp
4408: where dsp.dup_set_id = mp.batch_id
4409: and mp.batch_id = p_merge_batch_id); */
4410: -- Added new column created_by_module in hz_merge_batch instead of above checking
4411: select 'x'
4412: from hz_merge_batch
4413: where batch_id = p_merge_batch_id
4414: and nvl(created_by_module,'##') <> 'DL';

Line 4412: from hz_merge_batch

4408: where dsp.dup_set_id = mp.batch_id
4409: and mp.batch_id = p_merge_batch_id); */
4410: -- Added new column created_by_module in hz_merge_batch instead of above checking
4411: select 'x'
4412: from hz_merge_batch
4413: where batch_id = p_merge_batch_id
4414: and nvl(created_by_module,'##') <> 'DL';
4415:
4416: l_tmp varchar2(1);

Line 4455: from hz_merge_batch mb, hz_merge_parties mp,

4451: and ds.dup_set_id = p_dup_set_id;
4452:
4453: cursor dset_overlap_req_party_csr is
4454: select distinct mp.batch_id,dsp.dup_party_id,ds.object_version_number
4455: from hz_merge_batch mb, hz_merge_parties mp,
4456: hz_dup_sets ds, hz_dup_set_parties dsp, hz_dup_batch db
4457: where mp.batch_id <> ds.dup_set_id
4458: and mb.batch_id = mp.batch_id
4459: and db.dup_batch_id = ds.dup_batch_id

Line 4468: from hz_parties party, hz_merge_parties mp, hz_merge_batch mb

4464: and ds.dup_set_id = p_dup_set_id;
4465:
4466: cursor batch_overlap_merged_party_csr is
4467: select distinct party.party_number
4468: from hz_parties party, hz_merge_parties mp, hz_merge_batch mb
4469: where (party.party_id = mp.from_party_id or party.party_id = mp.to_party_id)
4470: and party.status = 'M'
4471: and mp.batch_id = p_merge_batch_id
4472: and mb.batch_id = mp.batch_id