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 171: --Create a merge batch in HZ_MERGE_BATCH

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

Line 172: HZ_MERGE_BATCH_PKG.INSERT_ROW(

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

Line 189: UPDATE HZ_MERGE_BATCH

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

Line 491: l_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;

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

Line 825: UPDATE HZ_MERGE_BATCH

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

Line 925: l_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;

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

Line 1283: UPDATE HZ_MERGE_BATCH

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

Line 1380: l_batch_status HZ_MERGE_BATCH.BATCH_STATUS%TYPE;

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

Line 1399: FROM hz_merge_batch

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

Line 1405: FROM hz_dup_sets ds, hz_merge_batch mb

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

Line 1486: UPDATE HZ_MERGE_BATCH

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

Line 3880: from hz_merge_batch

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

Line 3922: update hz_merge_batch

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

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

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

Line 4414: from hz_merge_batch

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

Line 4457: from hz_merge_batch mb, hz_merge_parties mp,

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

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

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