APPS.HZ_PARTY_MERGE dependencies on HZ_DUP_SETS

Line 389: HZ_DUP_SETS dset,

385: cursor c_request_type(cp_batch_id NUMBER) is
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

Line 663: UPDATE HZ_DUP_SETS

659: SET BATCH_STATUS = 'SUBMITTED'
660: WHERE BATCH_ID = p_batch_id;
661:
662: BEGIN
663: UPDATE HZ_DUP_SETS
664: SET STATUS = 'SUBMITTED'
665: WHERE dup_set_id = p_batch_id;
666: EXCEPTION
667: WHEN NO_DATA_FOUND THEN

Line 694: FROM hz_dup_sets ds, hz_dup_batch db

690:
691: g_automerge_flag := 'N';
692: BEGIN
693: SELECT NVL(automerge_flag, 'N') INTO g_automerge_flag
694: FROM hz_dup_sets ds, hz_dup_batch db
695: WHERE ds.dup_set_id = l_batch_id
696: AND db.dup_batch_id = ds.dup_batch_id
697: AND rownum = 1;
698: EXCEPTION

Line 1165: UPDATE HZ_DUP_SETS

1161: SET BATCH_STATUS = 'COMPLETE'
1162: WHERE BATCH_ID = p_batch_id;
1163:
1164: BEGIN
1165: UPDATE HZ_DUP_SETS
1166: SET STATUS = 'COMPLETED'
1167: WHERE dup_set_id = p_batch_id;
1168: EXCEPTION
1169: WHEN NO_DATA_FOUND THEN

Line 1213: UPDATE HZ_DUP_SETS

1209: retcode:=2;
1210: END IF;
1211:
1212: BEGIN
1213: UPDATE HZ_DUP_SETS
1214: SET STATUS = 'ERROR'
1215: WHERE DUP_SET_ID = p_batch_id;
1216: EXCEPTION
1217: WHEN NO_DATA_FOUND THEN

Line 1299: UPDATE HZ_DUP_SETS

1295: ELSIF l_batch_merge_spt THEN
1296: ROLLBACK to batch_merge;
1297: END IF;
1298: END IF;
1299: UPDATE HZ_DUP_SETS
1300: set status = 'ERROR'
1301: where dup_set_id = p_batch_id;
1302: commit;
1303: hz_common_pub.enable_cont_source_security;

Line 1324: UPDATE HZ_DUP_SETS

1320: ELSIF l_batch_merge_spt THEN
1321: ROLLBACK to batch_merge;
1322: END IF;
1323: END IF;
1324: UPDATE HZ_DUP_SETS
1325: set status = 'ERROR'
1326: where dup_set_id = p_batch_id;
1327: commit;
1328: hz_common_pub.enable_cont_source_security;

Line 1349: UPDATE HZ_DUP_SETS

1345: ELSIF l_batch_merge_spt THEN
1346: ROLLBACK to batch_merge;
1347: END IF;
1348: END IF;
1349: UPDATE HZ_DUP_SETS
1350: set status = 'ERROR'
1351: where dup_set_id = p_batch_id;
1352: commit;
1353: hz_common_pub.enable_cont_source_security;