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_BATCH_DUPLICATE dependencies on HZ_PARTY_SEARCH

Line 475: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,

471: PROCEDURE find_party_dups (
472: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
473: p_rule_id IN NUMBER,
474: p_party_id IN NUMBER,
475: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
476: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
477: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
478: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list,
479: x_search_ctx_id OUT NOCOPY NUMBER,

Line 476: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,

472: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
473: p_rule_id IN NUMBER,
474: p_party_id IN NUMBER,
475: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
476: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
477: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
478: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list,
479: x_search_ctx_id OUT NOCOPY NUMBER,
480: x_num_matches OUT NOCOPY NUMBER,

Line 477: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,

473: p_rule_id IN NUMBER,
474: p_party_id IN NUMBER,
475: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
476: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
477: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
478: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list,
479: x_search_ctx_id OUT NOCOPY NUMBER,
480: x_num_matches OUT NOCOPY NUMBER,
481: x_return_status OUT NOCOPY VARCHAR2,

Line 478: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list,

474: p_party_id IN NUMBER,
475: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
476: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
477: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
478: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list,
479: x_search_ctx_id OUT NOCOPY NUMBER,
480: x_num_matches OUT NOCOPY NUMBER,
481: x_return_status OUT NOCOPY VARCHAR2,
482: x_msg_count OUT NOCOPY NUMBER,

Line 496: HZ_PARTY_SEARCH.get_party_for_search(

492:
493: BEGIN
494: l_rule_id := p_rule_id;
495:
496: HZ_PARTY_SEARCH.get_party_for_search(
497: FND_API.G_FALSE,l_rule_id, p_party_id, x_party_search_rec,
498: x_party_site_list, x_contact_list, x_contact_point_list,
499: l_return_status, l_msg_count, l_msg_data);
500:

Line 511: HZ_PARTY_SEARCH.find_duplicate_parties(

507: ELSE
508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
509: END IF;
510: ELSE
511: HZ_PARTY_SEARCH.find_duplicate_parties(
512: FND_API.G_FALSE,l_rule_id, p_party_id, NULL,
513: NULL, null, null, l_dup_set_id,x_search_ctx_id, l_num_matches,
514: l_return_status, l_msg_count, l_msg_data);
515: END IF;

Line 546: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,

542: PROCEDURE find_party_dups (
543: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
544: p_rule_id IN NUMBER,
545: p_party_id IN NUMBER,
546: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
547: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
548: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
549: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
550: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,

Line 547: p_contact_ids IN HZ_PARTY_SEARCH.IDList,

543: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
544: p_rule_id IN NUMBER,
545: p_party_id IN NUMBER,
546: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
547: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
548: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
549: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
550: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
551: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,

Line 548: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,

544: p_rule_id IN NUMBER,
545: p_party_id IN NUMBER,
546: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
547: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
548: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
549: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
550: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
551: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
552: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list,

Line 549: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,

545: p_party_id IN NUMBER,
546: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
547: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
548: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
549: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
550: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
551: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
552: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list,
553: x_search_ctx_id OUT NOCOPY NUMBER,

Line 550: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,

546: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
547: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
548: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
549: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
550: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
551: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
552: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list,
553: x_search_ctx_id OUT NOCOPY NUMBER,
554: x_num_matches OUT NOCOPY NUMBER,

Line 551: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,

547: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
548: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
549: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
550: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
551: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
552: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list,
553: x_search_ctx_id OUT NOCOPY NUMBER,
554: x_num_matches OUT NOCOPY NUMBER,
555: x_return_status OUT NOCOPY VARCHAR2,

Line 552: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list,

548: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
549: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
550: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
551: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
552: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list,
553: x_search_ctx_id OUT NOCOPY NUMBER,
554: x_num_matches OUT NOCOPY NUMBER,
555: x_return_status OUT NOCOPY VARCHAR2,
556: x_msg_count OUT NOCOPY NUMBER,

Line 569: HZ_PARTY_SEARCH.get_search_criteria(

565:
566: BEGIN
567: l_rule_id := p_rule_id;
568:
569: HZ_PARTY_SEARCH.get_search_criteria(
570: FND_API.G_FALSE,l_rule_id, p_party_id, p_party_site_ids,p_contact_ids,
571: p_contact_pt_ids, x_party_search_rec,
572: x_party_site_list, x_contact_list, x_contact_point_list,
573: l_return_status, l_msg_count, l_msg_data);

Line 585: HZ_PARTY_SEARCH.find_parties(

581: ELSE
582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
583: END IF;
584: ELSE
585: HZ_PARTY_SEARCH.find_parties(
586: FND_API.G_FALSE,l_rule_id,
587: x_party_search_rec, x_party_site_list,x_contact_list, x_contact_point_list,
588: 'party_id <> '||p_party_id || ' and ROWNUM < 1000',
589: 'N', x_search_ctx_id,x_num_matches,x_return_status,

Line 802: HZ_PARTY_SEARCH.find_duplicate_parties(

798: IF p_match_within_subset = 'Y' AND p_subset_defn IS NOT NULL THEN
799: l_subset_defn := 'EXISTS (select 1 FROM HZ_PARTIES parties '||
800: 'where parties.party_id = stage.party_id ' ||
801: 'and '||p_subset_defn||')';
802: HZ_PARTY_SEARCH.find_duplicate_parties(
803: FND_API.G_TRUE,l_rule_id, l_cur_party_id, l_subset_defn,
804: NULL, l_batch_id, p_search_merged, l_dup_set_id,l_search_ctx_id, l_num_matches,
805: l_return_status, l_msg_count, l_msg_data);
806: ELSE

Line 807: HZ_PARTY_SEARCH.find_duplicate_parties(

803: FND_API.G_TRUE,l_rule_id, l_cur_party_id, l_subset_defn,
804: NULL, l_batch_id, p_search_merged, l_dup_set_id,l_search_ctx_id, l_num_matches,
805: l_return_status, l_msg_count, l_msg_data);
806: ELSE
807: HZ_PARTY_SEARCH.find_duplicate_parties(
808: FND_API.G_TRUE,l_rule_id, l_cur_party_id, NULL,
809: NULL, l_batch_id, p_search_merged, l_dup_set_id,l_search_ctx_id, l_num_matches,
810: l_return_status, l_msg_count, l_msg_data);
811: END IF;

Line 1077: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;

1073: l_rule_id NUMBER;
1074: l_search_ctx_id NUMBER;
1075: l_winner_party_id NUMBER;
1076:
1077: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
1078: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
1079: l_contact_list HZ_PARTY_SEARCH.contact_list;
1080: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
1081:

Line 1078: l_party_site_list HZ_PARTY_SEARCH.party_site_list;

1074: l_search_ctx_id NUMBER;
1075: l_winner_party_id NUMBER;
1076:
1077: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
1078: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
1079: l_contact_list HZ_PARTY_SEARCH.contact_list;
1080: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
1081:
1082: l_return_status VARCHAR2(30);

Line 1079: l_contact_list HZ_PARTY_SEARCH.contact_list;

1075: l_winner_party_id NUMBER;
1076:
1077: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
1078: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
1079: l_contact_list HZ_PARTY_SEARCH.contact_list;
1080: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
1081:
1082: l_return_status VARCHAR2(30);
1083: L_msg_count NUMBER;

Line 1080: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;

1076:
1077: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
1078: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
1079: l_contact_list HZ_PARTY_SEARCH.contact_list;
1080: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
1081:
1082: l_return_status VARCHAR2(30);
1083: L_msg_count NUMBER;
1084: l_msg_data VARCHAR2(2000);

Line 1124: HZ_PARTY_SEARCH.get_party_for_search(

1120: FND_MSG_PUB.ADD;
1121: RAISE FND_API.G_EXC_ERROR;
1122: END IF;
1123:
1124: HZ_PARTY_SEARCH.get_party_for_search(
1125: FND_API.G_FALSE,p_rule_id, l_winner_party_id, l_party_rec,
1126: l_party_site_list, l_contact_list, l_cpt_list,
1127: l_return_status, l_msg_count, l_msg_data);
1128:

Line 1139: HZ_PARTY_SEARCH.get_score_details (

1135:
1136: FOR DUP IN (SELECT DUP_PARTY_ID
1137: FROM HZ_DUP_SET_PARTIES
1138: WHERE DUP_SET_ID = p_dup_set_id and dup_party_id <> l_winner_party_id) LOOP
1139: HZ_PARTY_SEARCH.get_score_details (
1140: FND_API.G_FALSE,p_rule_id, DUP.DUP_PARTY_ID,
1141: l_party_rec, l_party_site_list,l_contact_list, l_cpt_list,
1142: l_search_ctx_id, l_return_status, l_msg_count, l_msg_data);
1143: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1144: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_SEARCH_ERROR');

1140: FND_API.G_FALSE,p_rule_id, DUP.DUP_PARTY_ID,
1141: l_party_rec, l_party_site_list,l_contact_list, l_cpt_list,
1142: l_search_ctx_id, l_return_status, l_msg_count, l_msg_data);
1143: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1144: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_SEARCH_ERROR');
1145: FND_MESSAGE.SET_TOKEN('PARTY_ID', TO_CHAR(DUP.DUP_PARTY_ID));
1146: FND_MSG_PUB.ADD;
1147: RAISE FND_API.G_EXC_ERROR;
1148: ELSE