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 469: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,

465: PROCEDURE find_party_dups (
466: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
467: p_rule_id IN NUMBER,
468: p_party_id IN NUMBER,
469: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
470: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
471: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
472: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list,
473: x_search_ctx_id OUT NOCOPY NUMBER,

Line 470: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,

466: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
467: p_rule_id IN NUMBER,
468: p_party_id IN NUMBER,
469: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
470: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
471: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
472: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list,
473: x_search_ctx_id OUT NOCOPY NUMBER,
474: x_num_matches OUT NOCOPY NUMBER,

Line 471: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,

467: p_rule_id IN NUMBER,
468: p_party_id IN NUMBER,
469: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
470: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
471: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
472: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list,
473: x_search_ctx_id OUT NOCOPY NUMBER,
474: x_num_matches OUT NOCOPY NUMBER,
475: x_return_status OUT NOCOPY VARCHAR2,

Line 472: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list,

468: p_party_id IN NUMBER,
469: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
470: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
471: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
472: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list,
473: x_search_ctx_id OUT NOCOPY NUMBER,
474: x_num_matches OUT NOCOPY NUMBER,
475: x_return_status OUT NOCOPY VARCHAR2,
476: x_msg_count OUT NOCOPY NUMBER,

Line 490: HZ_PARTY_SEARCH.get_party_for_search(

486:
487: BEGIN
488: l_rule_id := p_rule_id;
489:
490: HZ_PARTY_SEARCH.get_party_for_search(
491: FND_API.G_FALSE,l_rule_id, p_party_id, x_party_search_rec,
492: x_party_site_list, x_contact_list, x_contact_point_list,
493: l_return_status, l_msg_count, l_msg_data);
494:

Line 505: HZ_PARTY_SEARCH.find_duplicate_parties(

501: ELSE
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: END IF;
504: ELSE
505: HZ_PARTY_SEARCH.find_duplicate_parties(
506: FND_API.G_FALSE,l_rule_id, p_party_id, NULL,
507: NULL, null, null, l_dup_set_id,x_search_ctx_id, l_num_matches,
508: l_return_status, l_msg_count, l_msg_data);
509: END IF;

Line 540: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,

536: PROCEDURE find_party_dups (
537: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
538: p_rule_id IN NUMBER,
539: p_party_id IN NUMBER,
540: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
541: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
542: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
543: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
544: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,

Line 541: p_contact_ids IN HZ_PARTY_SEARCH.IDList,

537: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
538: p_rule_id IN NUMBER,
539: p_party_id IN NUMBER,
540: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
541: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
542: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
543: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
544: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
545: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,

Line 542: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,

538: p_rule_id IN NUMBER,
539: p_party_id IN NUMBER,
540: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
541: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
542: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
543: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
544: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
545: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
546: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list,

Line 543: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,

539: p_party_id IN NUMBER,
540: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
541: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
542: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
543: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
544: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
545: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
546: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list,
547: x_search_ctx_id OUT NOCOPY NUMBER,

Line 544: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,

540: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
541: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
542: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
543: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
544: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
545: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
546: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list,
547: x_search_ctx_id OUT NOCOPY NUMBER,
548: x_num_matches OUT NOCOPY NUMBER,

Line 545: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,

541: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
542: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
543: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
544: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
545: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
546: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list,
547: x_search_ctx_id OUT NOCOPY NUMBER,
548: x_num_matches OUT NOCOPY NUMBER,
549: x_return_status OUT NOCOPY VARCHAR2,

Line 546: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list,

542: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
543: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
544: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
545: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
546: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list,
547: x_search_ctx_id OUT NOCOPY NUMBER,
548: x_num_matches OUT NOCOPY NUMBER,
549: x_return_status OUT NOCOPY VARCHAR2,
550: x_msg_count OUT NOCOPY NUMBER,

Line 563: HZ_PARTY_SEARCH.get_search_criteria(

559:
560: BEGIN
561: l_rule_id := p_rule_id;
562:
563: HZ_PARTY_SEARCH.get_search_criteria(
564: FND_API.G_FALSE,l_rule_id, p_party_id, p_party_site_ids,p_contact_ids,
565: p_contact_pt_ids, x_party_search_rec,
566: x_party_site_list, x_contact_list, x_contact_point_list,
567: l_return_status, l_msg_count, l_msg_data);

Line 579: HZ_PARTY_SEARCH.find_parties(

575: ELSE
576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
577: END IF;
578: ELSE
579: HZ_PARTY_SEARCH.find_parties(
580: FND_API.G_FALSE,l_rule_id,
581: x_party_search_rec, x_party_site_list,x_contact_list, x_contact_point_list,
582: 'party_id <> '||p_party_id || ' and ROWNUM < 1000',
583: 'N', x_search_ctx_id,x_num_matches,x_return_status,

Line 796: HZ_PARTY_SEARCH.find_duplicate_parties(

792: IF p_match_within_subset = 'Y' AND p_subset_defn IS NOT NULL THEN
793: l_subset_defn := 'EXISTS (select 1 FROM HZ_PARTIES parties '||
794: 'where parties.party_id = stage.party_id ' ||
795: 'and '||p_subset_defn||')';
796: HZ_PARTY_SEARCH.find_duplicate_parties(
797: FND_API.G_TRUE,l_rule_id, l_cur_party_id, l_subset_defn,
798: NULL, l_batch_id, p_search_merged, l_dup_set_id,l_search_ctx_id, l_num_matches,
799: l_return_status, l_msg_count, l_msg_data);
800: ELSE

Line 801: HZ_PARTY_SEARCH.find_duplicate_parties(

797: FND_API.G_TRUE,l_rule_id, l_cur_party_id, l_subset_defn,
798: NULL, l_batch_id, p_search_merged, l_dup_set_id,l_search_ctx_id, l_num_matches,
799: l_return_status, l_msg_count, l_msg_data);
800: ELSE
801: HZ_PARTY_SEARCH.find_duplicate_parties(
802: FND_API.G_TRUE,l_rule_id, l_cur_party_id, NULL,
803: NULL, l_batch_id, p_search_merged, l_dup_set_id,l_search_ctx_id, l_num_matches,
804: l_return_status, l_msg_count, l_msg_data);
805: END IF;

Line 1071: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;

1067: l_rule_id NUMBER;
1068: l_search_ctx_id NUMBER;
1069: l_winner_party_id NUMBER;
1070:
1071: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
1072: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
1073: l_contact_list HZ_PARTY_SEARCH.contact_list;
1074: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
1075:

Line 1072: l_party_site_list HZ_PARTY_SEARCH.party_site_list;

1068: l_search_ctx_id NUMBER;
1069: l_winner_party_id NUMBER;
1070:
1071: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
1072: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
1073: l_contact_list HZ_PARTY_SEARCH.contact_list;
1074: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
1075:
1076: l_return_status VARCHAR2(30);

Line 1073: l_contact_list HZ_PARTY_SEARCH.contact_list;

1069: l_winner_party_id NUMBER;
1070:
1071: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
1072: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
1073: l_contact_list HZ_PARTY_SEARCH.contact_list;
1074: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
1075:
1076: l_return_status VARCHAR2(30);
1077: L_msg_count NUMBER;

Line 1074: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;

1070:
1071: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
1072: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
1073: l_contact_list HZ_PARTY_SEARCH.contact_list;
1074: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
1075:
1076: l_return_status VARCHAR2(30);
1077: L_msg_count NUMBER;
1078: l_msg_data VARCHAR2(2000);

Line 1118: HZ_PARTY_SEARCH.get_party_for_search(

1114: FND_MSG_PUB.ADD;
1115: RAISE FND_API.G_EXC_ERROR;
1116: END IF;
1117:
1118: HZ_PARTY_SEARCH.get_party_for_search(
1119: FND_API.G_FALSE,p_rule_id, l_winner_party_id, l_party_rec,
1120: l_party_site_list, l_contact_list, l_cpt_list,
1121: l_return_status, l_msg_count, l_msg_data);
1122:

Line 1133: HZ_PARTY_SEARCH.get_score_details (

1129:
1130: FOR DUP IN (SELECT DUP_PARTY_ID
1131: FROM HZ_DUP_SET_PARTIES
1132: WHERE DUP_SET_ID = p_dup_set_id and dup_party_id <> l_winner_party_id) LOOP
1133: HZ_PARTY_SEARCH.get_score_details (
1134: FND_API.G_FALSE,p_rule_id, DUP.DUP_PARTY_ID,
1135: l_party_rec, l_party_site_list,l_contact_list, l_cpt_list,
1136: l_search_ctx_id, l_return_status, l_msg_count, l_msg_data);
1137: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

1134: FND_API.G_FALSE,p_rule_id, DUP.DUP_PARTY_ID,
1135: l_party_rec, l_party_site_list,l_contact_list, l_cpt_list,
1136: l_search_ctx_id, l_return_status, l_msg_count, l_msg_data);
1137: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1138: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_SEARCH_ERROR');
1139: FND_MESSAGE.SET_TOKEN('PARTY_ID', TO_CHAR(DUP.DUP_PARTY_ID));
1140: FND_MSG_PUB.ADD;
1141: RAISE FND_API.G_EXC_ERROR;
1142: ELSE