28: -- ==========================================================================================
29:
30: TYPE vlisttype IS TABLE of VARCHAR2(255) INDEX BY BINARY_INTEGER ;
31: call_order vlisttype;
32: call_max_score HZ_PARTY_SEARCH.IDList;
33: call_type vlisttype;
34: g_party_stage_rec HZ_PARTY_STAGE.party_stage_rec_type;
35: g_party_site_stage_list HZ_PARTY_STAGE.party_site_stage_list;
36: g_contact_stage_list HZ_PARTY_STAGE.contact_stage_list;
34: g_party_stage_rec HZ_PARTY_STAGE.party_stage_rec_type;
35: g_party_site_stage_list HZ_PARTY_STAGE.party_site_stage_list;
36: g_contact_stage_list HZ_PARTY_STAGE.contact_stage_list;
37: g_contact_pt_stage_list HZ_PARTY_STAGE.contact_pt_stage_list;
38: g_mappings HZ_PARTY_SEARCH.IDList;
39: g_max_id NUMBER:=2000000000;
40: g_other_party_level_attribs BOOLEAN;
41:
42: g_debug_count NUMBER := 0;
331: PROCEDURE INSERT_PARTY_SCORE (
332: p_party_id IN NUMBER
333: ,p_record_id IN NUMBER
334: ,p_search_ctx_id IN NUMBER
335: ,p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type
336: ,p_stage_rec IN HZ_PARTY_STAGE.party_stage_rec_type
337: ,p_table_TX44 VARCHAR2
338: ,p_idx IN NUMBER) IS
339: l_current_score NUMBER:=0;
373: PROCEDURE INSERT_PARTY_SITES_SCORE (
374: p_party_id IN NUMBER
375: ,p_record_id IN NUMBER
376: ,p_search_ctx_id IN NUMBER
377: ,p_search_rec IN HZ_PARTY_SEARCH.party_site_search_rec_type
378: ,p_stage_rec IN HZ_PARTY_STAGE.party_site_stage_rec_type
379: ,p_idx IN NUMBER) IS
380: l_current_score NUMBER:=0;
381: l_score NUMBER;
389: PROCEDURE INSERT_CONTACTS_SCORE (
390: p_party_id IN NUMBER
391: ,p_record_id IN NUMBER
392: ,p_search_ctx_id IN NUMBER
393: ,p_search_rec IN HZ_PARTY_SEARCH.contact_search_rec_type
394: ,p_stage_rec IN HZ_PARTY_STAGE.contact_stage_rec_type
395: ,p_idx IN NUMBER) IS
396: l_current_score NUMBER:=0;
397: l_score NUMBER;
405: PROCEDURE INSERT_CONTACT_POINTS_SCORE (
406: p_party_id IN NUMBER
407: ,p_record_id IN NUMBER
408: ,p_search_ctx_id IN NUMBER
409: ,p_search_rec IN HZ_PARTY_SEARCH.contact_point_search_rec_type
410: ,p_stage_rec IN HZ_PARTY_STAGE.contact_pt_stage_rec_type
411: ,p_table_TX1 VARCHAR2
412: ,p_table_TX6 VARCHAR2
413: ,p_table_TX5 VARCHAR2
483: for the PARTY Entity
484: ************************************************/
485:
486: PROCEDURE POP_PARTY_COND_REC(
487: p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type
488: ) IS
489: BEGIN
490: NULL ;
491: EXCEPTION
503: for the PARTY_SITES Entity
504: ************************************************/
505:
506: PROCEDURE POP_PARTY_SITES_COND_REC(
507: p_search_list IN HZ_PARTY_SEARCH.party_site_list
508: ) IS
509: BEGIN
510: NULL ;
511: EXCEPTION
523: for the CONTACTS Entity
524: ************************************************/
525:
526: PROCEDURE POP_CONTACTS_COND_REC(
527: p_search_list IN HZ_PARTY_SEARCH.contact_list
528: ) IS
529: BEGIN
530: NULL ;
531: EXCEPTION
543: for the CONTACT_POINTS Entity
544: ************************************************/
545:
546: PROCEDURE POP_CONTACT_POINTS_COND_REC(
547: p_search_list IN HZ_PARTY_SEARCH.contact_point_list
548: ) IS
549: BEGIN
550: NULL ;
551: EXCEPTION
557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
558: END;
559:
560: PROCEDURE init_score_context (
561: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
562: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
563: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
564: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
565: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
558: END;
559:
560: PROCEDURE init_score_context (
561: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
562: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
563: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
564: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
565: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
566: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
559:
560: PROCEDURE init_score_context (
561: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
562: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
563: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
564: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
565: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
566: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
567: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
560: PROCEDURE init_score_context (
561: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
562: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
563: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
564: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
565: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
566: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
567: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
568: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST
561: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
562: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
563: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
564: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
565: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
566: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
567: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
568: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST
569: ) IS
562: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
563: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
564: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
565: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
566: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
567: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
568: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST
569: ) IS
570: l_dummy NUMBER;
563: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
564: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
565: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
566: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
567: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
568: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST
569: ) IS
570: l_dummy NUMBER;
571: BEGIN
564: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
565: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
566: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
567: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
568: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST
569: ) IS
570: l_dummy NUMBER;
571: BEGIN
572: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
584: MAP_CONTACT_POINT_REC(FALSE,p_contact_point_list, l_dummy, g_contact_pt_stage_list);
585:
586: END;
587: FUNCTION init_search(
588: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
589: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
590: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
591: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
592: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
585:
586: END;
587: FUNCTION init_search(
588: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
589: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
590: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
591: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
592: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
593: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
586: END;
587: FUNCTION init_search(
588: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
589: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
590: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
591: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
592: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
593: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
594: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
587: FUNCTION init_search(
588: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
589: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
590: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
591: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
592: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
593: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
594: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
595: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST,
588: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
589: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
590: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
591: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
592: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
593: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
594: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
595: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST,
596: p_match_type IN VARCHAR2,
589: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
590: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
591: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
592: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
593: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
594: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
595: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST,
596: p_match_type IN VARCHAR2,
597: x_party_max_score OUT NUMBER,
590: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
591: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
592: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
593: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
594: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
595: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST,
596: p_match_type IN VARCHAR2,
597: x_party_max_score OUT NUMBER,
598: x_ps_max_score OUT NUMBER,
591: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
592: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
593: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
594: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
595: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST,
596: p_match_type IN VARCHAR2,
597: x_party_max_score OUT NUMBER,
598: x_ps_max_score OUT NUMBER,
599: x_contact_max_score OUT NUMBER,
603: l_ps_entered_max_score NUMBER:=0;
604: l_ct_entered_max_score NUMBER:=0;
605: l_cpt_entered_max_score NUMBER:=0;
606: vlist vlisttype;
607: maxscore HZ_PARTY_SEARCH.IDList;
608: l_name VARCHAR2(200);
609: l_idx NUMBER;
610: l_num NUMBER;
611: total NUMBER;
1888: p_party_id NUMBER,
1889: p_party_site_id NUMBER,
1890: p_org_contact_id NUMBER,
1891: p_contact_point_id NUMBER)
1892: RETURN HZ_PARTY_SEARCH.score_rec IS
1893: l_score_rec HZ_PARTY_SEARCH.score_rec;
1894: BEGIN
1895: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1896: hz_utility_v2pub.debug(p_message=>'-----------------',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1889: p_party_site_id NUMBER,
1890: p_org_contact_id NUMBER,
1891: p_contact_point_id NUMBER)
1892: RETURN HZ_PARTY_SEARCH.score_rec IS
1893: l_score_rec HZ_PARTY_SEARCH.score_rec;
1894: BEGIN
1895: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1896: hz_utility_v2pub.debug(p_message=>'-----------------',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1897: hz_utility_v2pub.debug(p_message=>'calling the function get_new_score_rec to set the l_score_rec structure',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1921: **********************************************************/
1922:
1923: PROCEDURE find_parties (
1924: p_rule_id IN NUMBER,
1925: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
1926: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
1927: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
1928: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
1929: p_restrict_sql IN VARCHAR2,
1922:
1923: PROCEDURE find_parties (
1924: p_rule_id IN NUMBER,
1925: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
1926: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
1927: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
1928: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
1929: p_restrict_sql IN VARCHAR2,
1930: p_match_type IN VARCHAR2,
1923: PROCEDURE find_parties (
1924: p_rule_id IN NUMBER,
1925: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
1926: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
1927: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
1928: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
1929: p_restrict_sql IN VARCHAR2,
1930: p_match_type IN VARCHAR2,
1931: p_search_merged IN VARCHAR2,
1924: p_rule_id IN NUMBER,
1925: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
1926: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
1927: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
1928: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
1929: p_restrict_sql IN VARCHAR2,
1930: p_match_type IN VARCHAR2,
1931: p_search_merged IN VARCHAR2,
1932: p_dup_party_id IN NUMBER,
1960: l_TX44 VARCHAR2(2000);
1961: l_TX1 VARCHAR2(2000);
1962: l_TX5 VARCHAR2(2000);
1963: l_TX6 VARCHAR2(2000);
1964: H_SCORES HZ_PARTY_SEARCH.score_list;
1965: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
1966: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
1967:
1968: l_score NUMBER;
1961: l_TX1 VARCHAR2(2000);
1962: l_TX5 VARCHAR2(2000);
1963: l_TX6 VARCHAR2(2000);
1964: H_SCORES HZ_PARTY_SEARCH.score_list;
1965: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
1966: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
1967:
1968: l_score NUMBER;
1969: l_idx NUMBER;
1962: l_TX5 VARCHAR2(2000);
1963: l_TX6 VARCHAR2(2000);
1964: H_SCORES HZ_PARTY_SEARCH.score_list;
1965: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
1966: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
1967:
1968: l_score NUMBER;
1969: l_idx NUMBER;
1970: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
2154: /** Private procedure to acquire and score at party site level ***/
2155: PROCEDURE eval_party_site_level(p_party_site_contains_str VARCHAR2,p_call_type VARCHAR2, p_index NUMBER,p_ins_details VARCHAR2,p_emax_score NUMBER) IS
2156: l_party_id_idx NUMBER:=1;
2157: l_ctx_id NUMBER;
2158: h_ps_id HZ_PARTY_SEARCH.IDList;
2159: h_ps_party_id HZ_PARTY_SEARCH.IDList;
2160: h_ps_score HZ_PARTY_SEARCH.IDList;
2161: detcnt NUMBER := 1;
2162: BEGIN
2155: PROCEDURE eval_party_site_level(p_party_site_contains_str VARCHAR2,p_call_type VARCHAR2, p_index NUMBER,p_ins_details VARCHAR2,p_emax_score NUMBER) IS
2156: l_party_id_idx NUMBER:=1;
2157: l_ctx_id NUMBER;
2158: h_ps_id HZ_PARTY_SEARCH.IDList;
2159: h_ps_party_id HZ_PARTY_SEARCH.IDList;
2160: h_ps_score HZ_PARTY_SEARCH.IDList;
2161: detcnt NUMBER := 1;
2162: BEGIN
2163: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2156: l_party_id_idx NUMBER:=1;
2157: l_ctx_id NUMBER;
2158: h_ps_id HZ_PARTY_SEARCH.IDList;
2159: h_ps_party_id HZ_PARTY_SEARCH.IDList;
2160: h_ps_score HZ_PARTY_SEARCH.IDList;
2161: detcnt NUMBER := 1;
2162: BEGIN
2163: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2164: hz_utility_v2pub.debug(p_message=>'-----------------',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2276: /** Private procedure to acquire and score at contact point level ***/
2277: PROCEDURE eval_contact_level(p_contact_contains_str VARCHAR2,p_call_type VARCHAR2, p_index NUMBER,p_ins_details VARCHAR2,p_emax_score NUMBER) IS
2278: l_party_id_idx NUMBER:=1;
2279: l_ctx_id NUMBER;
2280: h_ct_id HZ_PARTY_SEARCH.IDList;
2281: h_ct_party_id HZ_PARTY_SEARCH.IDList;
2282: h_ct_score HZ_PARTY_SEARCH.IDList;
2283: detcnt NUMBER := 1;
2284: BEGIN
2277: PROCEDURE eval_contact_level(p_contact_contains_str VARCHAR2,p_call_type VARCHAR2, p_index NUMBER,p_ins_details VARCHAR2,p_emax_score NUMBER) IS
2278: l_party_id_idx NUMBER:=1;
2279: l_ctx_id NUMBER;
2280: h_ct_id HZ_PARTY_SEARCH.IDList;
2281: h_ct_party_id HZ_PARTY_SEARCH.IDList;
2282: h_ct_score HZ_PARTY_SEARCH.IDList;
2283: detcnt NUMBER := 1;
2284: BEGIN
2285: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2278: l_party_id_idx NUMBER:=1;
2279: l_ctx_id NUMBER;
2280: h_ct_id HZ_PARTY_SEARCH.IDList;
2281: h_ct_party_id HZ_PARTY_SEARCH.IDList;
2282: h_ct_score HZ_PARTY_SEARCH.IDList;
2283: detcnt NUMBER := 1;
2284: BEGIN
2285: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2286: hz_utility_v2pub.debug(p_message=>'-----------------',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2385: /** Private procedure to acquire and score at contact point level ***/
2386: PROCEDURE eval_cpt_level(p_contact_pt_contains_str VARCHAR2,p_call_type VARCHAR2, p_index NUMBER, p_ins_details VARCHAR2,p_emax_score NUMBER) IS
2387: l_party_id_idx NUMBER:=1;
2388: l_ctx_id NUMBER;
2389: h_cpt_id HZ_PARTY_SEARCH.IDList;
2390: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
2391: h_cpt_score HZ_PARTY_SEARCH.IDList;
2392: detcnt NUMBER := 1;
2393: l_cpt_flag VARCHAR2(1) := 'N';
2386: PROCEDURE eval_cpt_level(p_contact_pt_contains_str VARCHAR2,p_call_type VARCHAR2, p_index NUMBER, p_ins_details VARCHAR2,p_emax_score NUMBER) IS
2387: l_party_id_idx NUMBER:=1;
2388: l_ctx_id NUMBER;
2389: h_cpt_id HZ_PARTY_SEARCH.IDList;
2390: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
2391: h_cpt_score HZ_PARTY_SEARCH.IDList;
2392: detcnt NUMBER := 1;
2393: l_cpt_flag VARCHAR2(1) := 'N';
2394: is_a_match VARCHAR2(1) := 'Y';
2387: l_party_id_idx NUMBER:=1;
2388: l_ctx_id NUMBER;
2389: h_cpt_id HZ_PARTY_SEARCH.IDList;
2390: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
2391: h_cpt_score HZ_PARTY_SEARCH.IDList;
2392: detcnt NUMBER := 1;
2393: l_cpt_flag VARCHAR2(1) := 'N';
2394: is_a_match VARCHAR2(1) := 'Y';
2395: BEGIN
2836: END find_parties;
2837:
2838: PROCEDURE find_persons (
2839: p_rule_id IN NUMBER,
2840: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2841: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2842: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2843: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2844: p_restrict_sql IN VARCHAR2,
2837:
2838: PROCEDURE find_persons (
2839: p_rule_id IN NUMBER,
2840: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2841: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2842: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2843: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2844: p_restrict_sql IN VARCHAR2,
2845: p_match_type IN VARCHAR2,
2838: PROCEDURE find_persons (
2839: p_rule_id IN NUMBER,
2840: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2841: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2842: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2843: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2844: p_restrict_sql IN VARCHAR2,
2845: p_match_type IN VARCHAR2,
2846: p_search_merged IN VARCHAR2,
2839: p_rule_id IN NUMBER,
2840: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2841: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2842: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2843: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2844: p_restrict_sql IN VARCHAR2,
2845: p_match_type IN VARCHAR2,
2846: p_search_merged IN VARCHAR2,
2847: p_dup_party_id IN NUMBER,
2875: l_TX44 VARCHAR2(2000);
2876: l_TX1 VARCHAR2(2000);
2877: l_TX5 VARCHAR2(2000);
2878: l_TX6 VARCHAR2(2000);
2879: H_SCORES HZ_PARTY_SEARCH.score_list;
2880: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
2881: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
2882:
2883: l_score NUMBER;
2876: l_TX1 VARCHAR2(2000);
2877: l_TX5 VARCHAR2(2000);
2878: l_TX6 VARCHAR2(2000);
2879: H_SCORES HZ_PARTY_SEARCH.score_list;
2880: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
2881: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
2882:
2883: l_score NUMBER;
2884: l_idx NUMBER;
2877: l_TX5 VARCHAR2(2000);
2878: l_TX6 VARCHAR2(2000);
2879: H_SCORES HZ_PARTY_SEARCH.score_list;
2880: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
2881: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
2882:
2883: l_score NUMBER;
2884: l_idx NUMBER;
2885: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
3117: /** Private procedure to acquire and score at party site level ***/
3118: PROCEDURE eval_party_site_level(p_party_site_contains_str VARCHAR2,p_call_type VARCHAR2, p_index NUMBER,p_ins_details VARCHAR2,p_emax_score NUMBER) IS
3119: l_party_id_idx NUMBER:=1;
3120: l_ctx_id NUMBER;
3121: h_ps_id HZ_PARTY_SEARCH.IDList;
3122: h_ps_party_id HZ_PARTY_SEARCH.IDList;
3123: h_ps_score HZ_PARTY_SEARCH.IDList;
3124: detcnt NUMBER := 1;
3125: l_person_id NUMBER;
3118: PROCEDURE eval_party_site_level(p_party_site_contains_str VARCHAR2,p_call_type VARCHAR2, p_index NUMBER,p_ins_details VARCHAR2,p_emax_score NUMBER) IS
3119: l_party_id_idx NUMBER:=1;
3120: l_ctx_id NUMBER;
3121: h_ps_id HZ_PARTY_SEARCH.IDList;
3122: h_ps_party_id HZ_PARTY_SEARCH.IDList;
3123: h_ps_score HZ_PARTY_SEARCH.IDList;
3124: detcnt NUMBER := 1;
3125: l_person_id NUMBER;
3126: BEGIN
3119: l_party_id_idx NUMBER:=1;
3120: l_ctx_id NUMBER;
3121: h_ps_id HZ_PARTY_SEARCH.IDList;
3122: h_ps_party_id HZ_PARTY_SEARCH.IDList;
3123: h_ps_score HZ_PARTY_SEARCH.IDList;
3124: detcnt NUMBER := 1;
3125: l_person_id NUMBER;
3126: BEGIN
3127: SAVEPOINT eval_start;
3216: /** Private procedure to acquire and score at party site level ***/
3217: PROCEDURE eval_contact_level(p_contact_contains_str VARCHAR2,p_ins_details VARCHAR2,p_emax_score NUMBER) IS
3218: l_party_id_idx NUMBER:=1;
3219: l_ctx_id NUMBER;
3220: h_ct_id HZ_PARTY_SEARCH.IDList;
3221: h_ct_party_id HZ_PARTY_SEARCH.IDList;
3222: h_ct_score HZ_PARTY_SEARCH.IDList;
3223: detcnt NUMBER := 1;
3224: l_person_id NUMBER;
3217: PROCEDURE eval_contact_level(p_contact_contains_str VARCHAR2,p_ins_details VARCHAR2,p_emax_score NUMBER) IS
3218: l_party_id_idx NUMBER:=1;
3219: l_ctx_id NUMBER;
3220: h_ct_id HZ_PARTY_SEARCH.IDList;
3221: h_ct_party_id HZ_PARTY_SEARCH.IDList;
3222: h_ct_score HZ_PARTY_SEARCH.IDList;
3223: detcnt NUMBER := 1;
3224: l_person_id NUMBER;
3225: BEGIN
3218: l_party_id_idx NUMBER:=1;
3219: l_ctx_id NUMBER;
3220: h_ct_id HZ_PARTY_SEARCH.IDList;
3221: h_ct_party_id HZ_PARTY_SEARCH.IDList;
3222: h_ct_score HZ_PARTY_SEARCH.IDList;
3223: detcnt NUMBER := 1;
3224: l_person_id NUMBER;
3225: BEGIN
3226: SAVEPOINT eval_start;
3274: /** Private procedure to acquire and score at contact point level ***/
3275: PROCEDURE eval_cpt_level(p_contact_pt_contains_str VARCHAR2,p_call_type VARCHAR2, p_index NUMBER, p_ins_details VARCHAR2,p_emax_score NUMBER) IS
3276: l_party_id_idx NUMBER:=1;
3277: l_ctx_id NUMBER;
3278: h_cpt_id HZ_PARTY_SEARCH.IDList;
3279: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
3280: h_cpt_score HZ_PARTY_SEARCH.IDList;
3281: detcnt NUMBER := 1;
3282: l_person_id NUMBER;
3275: PROCEDURE eval_cpt_level(p_contact_pt_contains_str VARCHAR2,p_call_type VARCHAR2, p_index NUMBER, p_ins_details VARCHAR2,p_emax_score NUMBER) IS
3276: l_party_id_idx NUMBER:=1;
3277: l_ctx_id NUMBER;
3278: h_cpt_id HZ_PARTY_SEARCH.IDList;
3279: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
3280: h_cpt_score HZ_PARTY_SEARCH.IDList;
3281: detcnt NUMBER := 1;
3282: l_person_id NUMBER;
3283: is_a_match VARCHAR2(1) := 'Y';
3276: l_party_id_idx NUMBER:=1;
3277: l_ctx_id NUMBER;
3278: h_cpt_id HZ_PARTY_SEARCH.IDList;
3279: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
3280: h_cpt_score HZ_PARTY_SEARCH.IDList;
3281: detcnt NUMBER := 1;
3282: l_person_id NUMBER;
3283: is_a_match VARCHAR2(1) := 'Y';
3284: l_cpt_flag VARCHAR2(1) := 'N';
3618: END find_persons;
3619:
3620: PROCEDURE find_persons (
3621: p_rule_id IN NUMBER,
3622: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
3623: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
3624: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
3625: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
3626: p_restrict_sql IN VARCHAR2,
3619:
3620: PROCEDURE find_persons (
3621: p_rule_id IN NUMBER,
3622: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
3623: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
3624: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
3625: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
3626: p_restrict_sql IN VARCHAR2,
3627: p_match_type IN VARCHAR2,
3620: PROCEDURE find_persons (
3621: p_rule_id IN NUMBER,
3622: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
3623: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
3624: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
3625: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
3626: p_restrict_sql IN VARCHAR2,
3627: p_match_type IN VARCHAR2,
3628: p_search_merged IN VARCHAR2,
3621: p_rule_id IN NUMBER,
3622: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
3623: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
3624: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
3625: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
3626: p_restrict_sql IN VARCHAR2,
3627: p_match_type IN VARCHAR2,
3628: p_search_merged IN VARCHAR2,
3629: p_ins_details IN VARCHAR2,
3635: find_persons(p_rule_id,p_party_search_rec,p_party_site_list,p_contact_list,p_contact_point_list,p_restrict_sql,p_match_type,p_search_merged,null,null,null,p_ins_details,x_search_ctx_id,x_num_matches);
3636: END;
3637: PROCEDURE find_party_details (
3638: p_rule_id IN NUMBER,
3639: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
3640: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
3641: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
3642: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
3643: p_restrict_sql IN VARCHAR2,
3636: END;
3637: PROCEDURE find_party_details (
3638: p_rule_id IN NUMBER,
3639: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
3640: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
3641: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
3642: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
3643: p_restrict_sql IN VARCHAR2,
3644: p_match_type IN VARCHAR2,
3637: PROCEDURE find_party_details (
3638: p_rule_id IN NUMBER,
3639: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
3640: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
3641: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
3642: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
3643: p_restrict_sql IN VARCHAR2,
3644: p_match_type IN VARCHAR2,
3645: p_search_merged IN VARCHAR2,
3638: p_rule_id IN NUMBER,
3639: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
3640: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
3641: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
3642: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
3643: p_restrict_sql IN VARCHAR2,
3644: p_match_type IN VARCHAR2,
3645: p_search_merged IN VARCHAR2,
3646: x_search_ctx_id OUT NUMBER,
3695: x_dup_set_id OUT NUMBER,
3696: x_search_ctx_id OUT NUMBER,
3697: x_num_matches OUT NUMBER
3698: ) IS
3699: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
3700: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3701: l_contact_list HZ_PARTY_SEARCH.contact_list;
3702: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
3703: l_match_idx NUMBER;
3696: x_search_ctx_id OUT NUMBER,
3697: x_num_matches OUT NUMBER
3698: ) IS
3699: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
3700: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3701: l_contact_list HZ_PARTY_SEARCH.contact_list;
3702: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
3703: l_match_idx NUMBER;
3704:
3697: x_num_matches OUT NUMBER
3698: ) IS
3699: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
3700: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3701: l_contact_list HZ_PARTY_SEARCH.contact_list;
3702: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
3703: l_match_idx NUMBER;
3704:
3705: --Fix for bug 4417124
3698: ) IS
3699: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
3700: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3701: l_contact_list HZ_PARTY_SEARCH.contact_list;
3702: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
3703: l_match_idx NUMBER;
3704:
3705: --Fix for bug 4417124
3706: l_use_contact_addr_info BOOLEAN := TRUE;
3811: x_search_ctx_id OUT NUMBER,
3812: x_num_matches OUT NUMBER
3813: ) IS
3814:
3815: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3816: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3817: l_contact_list HZ_PARTY_SEARCH.contact_list;
3818: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3819: contact_point_ids HZ_PARTY_SEARCH.IDList;
3812: x_num_matches OUT NUMBER
3813: ) IS
3814:
3815: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3816: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3817: l_contact_list HZ_PARTY_SEARCH.contact_list;
3818: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3819: contact_point_ids HZ_PARTY_SEARCH.IDList;
3820: p_party_site_list HZ_PARTY_SEARCH.IDList;
3813: ) IS
3814:
3815: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3816: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3817: l_contact_list HZ_PARTY_SEARCH.contact_list;
3818: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3819: contact_point_ids HZ_PARTY_SEARCH.IDList;
3820: p_party_site_list HZ_PARTY_SEARCH.IDList;
3821: p_contact_ids HZ_PARTY_SEARCH.IDList;
3814:
3815: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3816: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3817: l_contact_list HZ_PARTY_SEARCH.contact_list;
3818: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3819: contact_point_ids HZ_PARTY_SEARCH.IDList;
3820: p_party_site_list HZ_PARTY_SEARCH.IDList;
3821: p_contact_ids HZ_PARTY_SEARCH.IDList;
3822: l_match_idx NUMBER;
3815: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3816: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3817: l_contact_list HZ_PARTY_SEARCH.contact_list;
3818: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3819: contact_point_ids HZ_PARTY_SEARCH.IDList;
3820: p_party_site_list HZ_PARTY_SEARCH.IDList;
3821: p_contact_ids HZ_PARTY_SEARCH.IDList;
3822: l_match_idx NUMBER;
3823: cursor get_cpts_for_party_sites is select contact_point_id
3816: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3817: l_contact_list HZ_PARTY_SEARCH.contact_list;
3818: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3819: contact_point_ids HZ_PARTY_SEARCH.IDList;
3820: p_party_site_list HZ_PARTY_SEARCH.IDList;
3821: p_contact_ids HZ_PARTY_SEARCH.IDList;
3822: l_match_idx NUMBER;
3823: cursor get_cpts_for_party_sites is select contact_point_id
3824: from hz_contact_points
3817: l_contact_list HZ_PARTY_SEARCH.contact_list;
3818: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3819: contact_point_ids HZ_PARTY_SEARCH.IDList;
3820: p_party_site_list HZ_PARTY_SEARCH.IDList;
3821: p_contact_ids HZ_PARTY_SEARCH.IDList;
3822: l_match_idx NUMBER;
3823: cursor get_cpts_for_party_sites is select contact_point_id
3824: from hz_contact_points
3825: where owner_table_name = 'HZ_PARTY_SITES'
3846:
3847: get_search_criteria (
3848: null,
3849: p_party_site_list,
3850: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
3851: contact_point_ids,
3852: l_party_search_rec,
3853: l_party_site_list,
3854: l_contact_list,
3896: x_search_ctx_id OUT NUMBER,
3897: x_num_matches OUT NUMBER
3898: ) IS
3899:
3900: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3901: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3902: l_contact_list HZ_PARTY_SEARCH.contact_list;
3903: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3904: contact_point_ids HZ_PARTY_SEARCH.IDList;
3897: x_num_matches OUT NUMBER
3898: ) IS
3899:
3900: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3901: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3902: l_contact_list HZ_PARTY_SEARCH.contact_list;
3903: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3904: contact_point_ids HZ_PARTY_SEARCH.IDList;
3905: p_party_site_list HZ_PARTY_SEARCH.IDList;
3898: ) IS
3899:
3900: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3901: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3902: l_contact_list HZ_PARTY_SEARCH.contact_list;
3903: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3904: contact_point_ids HZ_PARTY_SEARCH.IDList;
3905: p_party_site_list HZ_PARTY_SEARCH.IDList;
3906: p_contact_ids HZ_PARTY_SEARCH.IDList;
3899:
3900: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3901: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3902: l_contact_list HZ_PARTY_SEARCH.contact_list;
3903: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3904: contact_point_ids HZ_PARTY_SEARCH.IDList;
3905: p_party_site_list HZ_PARTY_SEARCH.IDList;
3906: p_contact_ids HZ_PARTY_SEARCH.IDList;
3907: l_match_idx NUMBER;
3900: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3901: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3902: l_contact_list HZ_PARTY_SEARCH.contact_list;
3903: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3904: contact_point_ids HZ_PARTY_SEARCH.IDList;
3905: p_party_site_list HZ_PARTY_SEARCH.IDList;
3906: p_contact_ids HZ_PARTY_SEARCH.IDList;
3907: l_match_idx NUMBER;
3908: cursor get_cpt_for_contact_id is select contact_point_id
3901: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3902: l_contact_list HZ_PARTY_SEARCH.contact_list;
3903: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3904: contact_point_ids HZ_PARTY_SEARCH.IDList;
3905: p_party_site_list HZ_PARTY_SEARCH.IDList;
3906: p_contact_ids HZ_PARTY_SEARCH.IDList;
3907: l_match_idx NUMBER;
3908: cursor get_cpt_for_contact_id is select contact_point_id
3909: from hz_org_contacts a, hz_relationships b, hz_contact_points c
3902: l_contact_list HZ_PARTY_SEARCH.contact_list;
3903: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3904: contact_point_ids HZ_PARTY_SEARCH.IDList;
3905: p_party_site_list HZ_PARTY_SEARCH.IDList;
3906: p_contact_ids HZ_PARTY_SEARCH.IDList;
3907: l_match_idx NUMBER;
3908: cursor get_cpt_for_contact_id is select contact_point_id
3909: from hz_org_contacts a, hz_relationships b, hz_contact_points c
3910: where a.party_relationship_id = b.relationship_id
3933: CLOSE get_cpt_for_contact_id;
3934:
3935: get_search_criteria (
3936: null,
3937: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
3938: p_contact_ids,
3939: contact_point_ids,
3940: l_party_search_rec,
3941: l_party_site_list,
3984: p_match_type IN VARCHAR2,
3985: x_search_ctx_id OUT NUMBER,
3986: x_num_matches OUT NUMBER
3987: ) IS
3988: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3989: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3990: l_contact_list HZ_PARTY_SEARCH.contact_list;
3991: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3992: contact_point_ids HZ_PARTY_SEARCH.IDList;
3985: x_search_ctx_id OUT NUMBER,
3986: x_num_matches OUT NUMBER
3987: ) IS
3988: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3989: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3990: l_contact_list HZ_PARTY_SEARCH.contact_list;
3991: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3992: contact_point_ids HZ_PARTY_SEARCH.IDList;
3993: p_party_site_list HZ_PARTY_SEARCH.IDList;
3986: x_num_matches OUT NUMBER
3987: ) IS
3988: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3989: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3990: l_contact_list HZ_PARTY_SEARCH.contact_list;
3991: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3992: contact_point_ids HZ_PARTY_SEARCH.IDList;
3993: p_party_site_list HZ_PARTY_SEARCH.IDList;
3994: p_contact_ids HZ_PARTY_SEARCH.IDList;
3987: ) IS
3988: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3989: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3990: l_contact_list HZ_PARTY_SEARCH.contact_list;
3991: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3992: contact_point_ids HZ_PARTY_SEARCH.IDList;
3993: p_party_site_list HZ_PARTY_SEARCH.IDList;
3994: p_contact_ids HZ_PARTY_SEARCH.IDList;
3995: l_match_idx NUMBER;
3988: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3989: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3990: l_contact_list HZ_PARTY_SEARCH.contact_list;
3991: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3992: contact_point_ids HZ_PARTY_SEARCH.IDList;
3993: p_party_site_list HZ_PARTY_SEARCH.IDList;
3994: p_contact_ids HZ_PARTY_SEARCH.IDList;
3995: l_match_idx NUMBER;
3996:
3989: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3990: l_contact_list HZ_PARTY_SEARCH.contact_list;
3991: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3992: contact_point_ids HZ_PARTY_SEARCH.IDList;
3993: p_party_site_list HZ_PARTY_SEARCH.IDList;
3994: p_contact_ids HZ_PARTY_SEARCH.IDList;
3995: l_match_idx NUMBER;
3996:
3997: BEGIN
3990: l_contact_list HZ_PARTY_SEARCH.contact_list;
3991: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3992: contact_point_ids HZ_PARTY_SEARCH.IDList;
3993: p_party_site_list HZ_PARTY_SEARCH.IDList;
3994: p_contact_ids HZ_PARTY_SEARCH.IDList;
3995: l_match_idx NUMBER;
3996:
3997: BEGIN
3998: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4007: END IF;
4008: contact_point_ids(1) := p_contact_point_id;
4009: get_search_criteria (
4010: null,
4011: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
4012: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
4013: contact_point_ids,
4014: l_party_search_rec,
4015: l_party_site_list,
4008: contact_point_ids(1) := p_contact_point_id;
4009: get_search_criteria (
4010: null,
4011: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
4012: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
4013: contact_point_ids,
4014: l_party_search_rec,
4015: l_party_site_list,
4016: l_contact_list,
4161: ) IS
4162: TYPE AttrList IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
4163: l_match_idx NUMBER;
4164: AttrVals AttrList;
4165: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
4166: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4167: l_contact_list HZ_PARTY_SEARCH.contact_list;
4168: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
4169: l_dup_set_id NUMBER;
4162: TYPE AttrList IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
4163: l_match_idx NUMBER;
4164: AttrVals AttrList;
4165: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
4166: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4167: l_contact_list HZ_PARTY_SEARCH.contact_list;
4168: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
4169: l_dup_set_id NUMBER;
4170: l_idx NUMBER;
4163: l_match_idx NUMBER;
4164: AttrVals AttrList;
4165: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
4166: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4167: l_contact_list HZ_PARTY_SEARCH.contact_list;
4168: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
4169: l_dup_set_id NUMBER;
4170: l_idx NUMBER;
4171: l_cpt_type VARCHAR2(255);
4164: AttrVals AttrList;
4165: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
4166: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4167: l_contact_list HZ_PARTY_SEARCH.contact_list;
4168: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
4169: l_dup_set_id NUMBER;
4170: l_idx NUMBER;
4171: l_cpt_type VARCHAR2(255);
4172: FIRST BOOLEAN := TRUE;
4346:
4347: PROCEDURE get_matching_party_sites (
4348: p_rule_id IN NUMBER,
4349: p_party_id IN NUMBER,
4350: p_party_site_list IN HZ_PARTY_SEARCH.PARTY_SITE_LIST,
4351: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
4352: p_restrict_sql IN VARCHAR2,
4353: p_match_type IN VARCHAR2,
4354: p_dup_party_site_id IN NUMBER,
4347: PROCEDURE get_matching_party_sites (
4348: p_rule_id IN NUMBER,
4349: p_party_id IN NUMBER,
4350: p_party_site_list IN HZ_PARTY_SEARCH.PARTY_SITE_LIST,
4351: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
4352: p_restrict_sql IN VARCHAR2,
4353: p_match_type IN VARCHAR2,
4354: p_dup_party_site_id IN NUMBER,
4355: x_search_ctx_id OUT NUMBER,
4375:
4376: l_TX1 VARCHAR2(2000);
4377: l_TX5 VARCHAR2(2000);
4378: l_TX6 VARCHAR2(2000);
4379: H_SCORES HZ_PARTY_SEARCH.score_list;
4380:
4381: l_score NUMBER;
4382: l_idx NUMBER;
4383: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4406: defps NUMBER :=0;
4407: defct NUMBER :=0;
4408: defcpt NUMBER :=0;
4409: l_index NUMBER;
4410: l_match_ps_list HZ_PARTY_SEARCH.IDList;
4411: l_cnt NUMBER:=1;
4412:
4413:
4414: BEGIN
4430: l_match_str := ' AND ';
4431: ELSIF p_match_type = 'OR' THEN
4432: l_match_str := ' OR ';
4433: END IF;
4434: l_entered_max_score:= init_search( HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC, p_party_site_list, HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST, p_contact_point_list,l_match_str, l_party_max_score, l_ps_max_score, l_contact_max_score, l_cpt_max_score);
4435: g_score_until_thresh := false;
4436: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4437:
4438: -- ************************************************************
4438: -- ************************************************************
4439: -- STEP 2. Setup of intermedia query strings for Acquisition query
4440: l_party_site_contains_str := INIT_PARTY_SITES_QUERY(l_match_str,l_tmp);
4441: l_contact_pt_contains_str := INIT_CONTACT_POINTS_QUERY(l_match_str,l_tmp);
4442: init_score_context(HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,p_party_site_list,HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,p_contact_point_list);
4443:
4444: -- Setup Search Context ID
4445: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;
4446: x_search_ctx_id := l_search_ctx_id;
4581:
4582: PROCEDURE get_matching_contacts (
4583: p_rule_id IN NUMBER,
4584: p_party_id IN NUMBER,
4585: p_contact_list IN HZ_PARTY_SEARCH.CONTACT_LIST,
4586: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
4587: p_restrict_sql IN VARCHAR2,
4588: p_match_type IN VARCHAR2,
4589: p_dup_contact_id IN NUMBER,
4582: PROCEDURE get_matching_contacts (
4583: p_rule_id IN NUMBER,
4584: p_party_id IN NUMBER,
4585: p_contact_list IN HZ_PARTY_SEARCH.CONTACT_LIST,
4586: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
4587: p_restrict_sql IN VARCHAR2,
4588: p_match_type IN VARCHAR2,
4589: p_dup_contact_id IN NUMBER,
4590: x_search_ctx_id OUT NUMBER,
4610:
4611: l_TX1 VARCHAR2(2000);
4612: l_TX5 VARCHAR2(2000);
4613: l_TX6 VARCHAR2(2000);
4614: H_SCORES HZ_PARTY_SEARCH.score_list;
4615:
4616: l_score NUMBER;
4617: l_idx NUMBER;
4618: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4638: l_party_max_score NUMBER;
4639: l_ps_max_score NUMBER;
4640: l_contact_max_score NUMBER;
4641: l_cpt_max_score NUMBER;
4642: l_match_contact_list HZ_PARTY_SEARCH.IDList;
4643: l_cnt NUMBER:=1;
4644:
4645:
4646: BEGIN
4662: l_match_str := ' AND ';
4663: ELSIF p_match_type = 'OR' THEN
4664: l_match_str := ' OR ';
4665: END IF;
4666: l_entered_max_score:= init_search( HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC, HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST, p_contact_list, p_contact_point_list,l_match_str, l_party_max_score, l_ps_max_score, l_contact_max_score, l_cpt_max_score);
4667: g_score_until_thresh := false;
4668: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4669:
4670: -- ************************************************************
4670: -- ************************************************************
4671: -- STEP 2. Setup of intermedia query strings for Acquisition query
4672: l_contact_contains_str := INIT_CONTACTS_QUERY(l_match_str,l_tmp);
4673: l_contact_pt_contains_str := INIT_CONTACT_POINTS_QUERY(l_match_str,l_tmp);
4674: init_score_context(HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,p_contact_list,p_contact_point_list);
4675:
4676: -- Setup Search Context ID
4677: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;
4678: x_search_ctx_id := l_search_ctx_id;
4809:
4810: PROCEDURE get_matching_contact_points (
4811: p_rule_id IN NUMBER,
4812: p_party_id IN NUMBER,
4813: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
4814: p_restrict_sql IN VARCHAR2,
4815: p_match_type IN VARCHAR2,
4816: p_dup_contact_point_id IN NUMBER,
4817: x_search_ctx_id OUT NUMBER,
4841: l_cpt_ps_id NUMBER;
4842: l_cpt_contact_id NUMBER;
4843: l_contact_pt_id NUMBER;
4844: l_cpt_type VARCHAR2(100);
4845: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
4846: H_CONTACT_POINT_ID HZ_PARTY_SEARCH.IDList;
4847: H_SCORE HZ_PARTY_SEARCH.IDList;
4848:
4849: cnt NUMBER :=0;
4842: l_cpt_contact_id NUMBER;
4843: l_contact_pt_id NUMBER;
4844: l_cpt_type VARCHAR2(100);
4845: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
4846: H_CONTACT_POINT_ID HZ_PARTY_SEARCH.IDList;
4847: H_SCORE HZ_PARTY_SEARCH.IDList;
4848:
4849: cnt NUMBER :=0;
4850: l_party_max_score NUMBER;
4843: l_contact_pt_id NUMBER;
4844: l_cpt_type VARCHAR2(100);
4845: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
4846: H_CONTACT_POINT_ID HZ_PARTY_SEARCH.IDList;
4847: H_SCORE HZ_PARTY_SEARCH.IDList;
4848:
4849: cnt NUMBER :=0;
4850: l_party_max_score NUMBER;
4851: l_ps_max_score NUMBER;
4872: l_match_str := ' AND ';
4873: ELSIF p_match_type = 'OR' THEN
4874: l_match_str := ' OR ';
4875: END IF;
4876: l_entered_max_score:= init_search(HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
4877: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST, HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
4878: p_contact_point_list,l_match_str, l_party_max_score, l_ps_max_score, l_contact_max_score, l_cpt_max_score);
4879: g_score_until_thresh := false;
4880: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4873: ELSIF p_match_type = 'OR' THEN
4874: l_match_str := ' OR ';
4875: END IF;
4876: l_entered_max_score:= init_search(HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
4877: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST, HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
4878: p_contact_point_list,l_match_str, l_party_max_score, l_ps_max_score, l_contact_max_score, l_cpt_max_score);
4879: g_score_until_thresh := false;
4880: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4881:
4881:
4882: -- ************************************************************
4883: -- STEP 2. Setup of intermedia query strings for Acquisition query
4884: l_contact_pt_contains_str := INIT_CONTACT_POINTS_QUERY(l_match_str,l_tmp);
4885: init_score_context(HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,p_contact_point_list);
4886:
4887: -- Setup Search Context ID
4888: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;
4889: x_search_ctx_id := l_search_ctx_id;
4956:
4957: PROCEDURE get_score_details (
4958: p_rule_id IN NUMBER,
4959: p_party_id IN NUMBER,
4960: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
4961: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
4962: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
4963: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
4964: x_search_ctx_id IN OUT NUMBER
4957: PROCEDURE get_score_details (
4958: p_rule_id IN NUMBER,
4959: p_party_id IN NUMBER,
4960: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
4961: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
4962: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
4963: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
4964: x_search_ctx_id IN OUT NUMBER
4965: ) IS
4958: p_rule_id IN NUMBER,
4959: p_party_id IN NUMBER,
4960: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
4961: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
4962: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
4963: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
4964: x_search_ctx_id IN OUT NUMBER
4965: ) IS
4966:
4959: p_party_id IN NUMBER,
4960: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
4961: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
4962: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
4963: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
4964: x_search_ctx_id IN OUT NUMBER
4965: ) IS
4966:
4967: -- Strings to hold the generated Intermedia query strings
4986: l_TX5 VARCHAR2(2000);
4987: l_max_TX5 VARCHAR2(2000);
4988: l_TX6 VARCHAR2(2000);
4989: l_max_TX6 VARCHAR2(2000);
4990: H_SCORES HZ_PARTY_SEARCH.score_list;
4991:
4992: l_score NUMBER;
4993: l_match_idx NUMBER;
4994: l_idx NUMBER;
5155: ************************************************/
5156:
5157: PROCEDURE get_party_for_search (
5158: p_party_id IN NUMBER,
5159: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
5160: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
5161: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
5162: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5163: ) IS
5156:
5157: PROCEDURE get_party_for_search (
5158: p_party_id IN NUMBER,
5159: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
5160: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
5161: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
5162: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5163: ) IS
5164: l_party_id NUMBER;
5157: PROCEDURE get_party_for_search (
5158: p_party_id IN NUMBER,
5159: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
5160: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
5161: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
5162: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5163: ) IS
5164: l_party_id NUMBER;
5165: l_party_site_ids HZ_PARTY_SEARCH.IDList;
5158: p_party_id IN NUMBER,
5159: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
5160: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
5161: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
5162: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5163: ) IS
5164: l_party_id NUMBER;
5165: l_party_site_ids HZ_PARTY_SEARCH.IDList;
5166: l_contact_ids HZ_PARTY_SEARCH.IDList;
5161: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
5162: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5163: ) IS
5164: l_party_id NUMBER;
5165: l_party_site_ids HZ_PARTY_SEARCH.IDList;
5166: l_contact_ids HZ_PARTY_SEARCH.IDList;
5167: l_contact_pt_ids HZ_PARTY_SEARCH.IDList;
5168: ps NUMBER :=1;
5169: cpt NUMBER :=1;
5162: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5163: ) IS
5164: l_party_id NUMBER;
5165: l_party_site_ids HZ_PARTY_SEARCH.IDList;
5166: l_contact_ids HZ_PARTY_SEARCH.IDList;
5167: l_contact_pt_ids HZ_PARTY_SEARCH.IDList;
5168: ps NUMBER :=1;
5169: cpt NUMBER :=1;
5170: ct NUMBER :=1;
5163: ) IS
5164: l_party_id NUMBER;
5165: l_party_site_ids HZ_PARTY_SEARCH.IDList;
5166: l_contact_ids HZ_PARTY_SEARCH.IDList;
5167: l_contact_pt_ids HZ_PARTY_SEARCH.IDList;
5168: ps NUMBER :=1;
5169: cpt NUMBER :=1;
5170: ct NUMBER :=1;
5171: l_use_contact_info varchar2(1);
5224: END get_party_for_search;
5225:
5226: PROCEDURE get_search_criteria (
5227: p_party_id IN NUMBER,
5228: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
5229: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
5230: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
5231: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
5232: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
5225:
5226: PROCEDURE get_search_criteria (
5227: p_party_id IN NUMBER,
5228: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
5229: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
5230: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
5231: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
5232: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
5233: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
5226: PROCEDURE get_search_criteria (
5227: p_party_id IN NUMBER,
5228: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
5229: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
5230: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
5231: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
5232: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
5233: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
5234: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5227: p_party_id IN NUMBER,
5228: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
5229: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
5230: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
5231: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
5232: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
5233: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
5234: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5235: ) IS
5228: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
5229: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
5230: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
5231: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
5232: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
5233: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
5234: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5235: ) IS
5236: BEGIN
5229: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
5230: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
5231: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
5232: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
5233: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
5234: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5235: ) IS
5236: BEGIN
5237:
5230: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
5231: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
5232: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
5233: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
5234: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5235: ) IS
5236: BEGIN
5237:
5238: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5270: ************************************************/
5271:
5272: PROCEDURE get_party_rec (
5273: p_party_id IN NUMBER,
5274: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type
5275: ) IS
5276: l_party_type VARCHAR2(255);
5277: BEGIN
5278:
5329: the party site search record structure
5330: ************************************************/
5331:
5332: PROCEDURE get_party_site_rec (
5333: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
5334: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
5335: ) IS
5336: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5337: SELECT party_site_id
5330: ************************************************/
5331:
5332: PROCEDURE get_party_site_rec (
5333: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
5334: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
5335: ) IS
5336: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5337: SELECT party_site_id
5338: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5381: the contact search record structure
5382: ************************************************/
5383:
5384: PROCEDURE get_contact_rec (
5385: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
5386: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
5387: ) IS
5388: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
5389: SELECT org_contact_id
5382: ************************************************/
5383:
5384: PROCEDURE get_contact_rec (
5385: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
5386: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
5387: ) IS
5388: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
5389: SELECT org_contact_id
5390: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
5437: the contact point search record structure
5438: ************************************************/
5439:
5440: PROCEDURE get_contact_point_rec (
5441: p_contact_point_ids IN HZ_PARTY_SEARCH.IDList,
5442: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5443: ) IS
5444:
5445: -- Cursor to fetch primary contact points for party
5438: ************************************************/
5439:
5440: PROCEDURE get_contact_point_rec (
5441: p_contact_point_ids IN HZ_PARTY_SEARCH.IDList,
5442: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5443: ) IS
5444:
5445: -- Cursor to fetch primary contact points for party
5446: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
5496: ************************************************/
5497:
5498: PROCEDURE MAP_PARTY_REC(
5499: p_search_ctx IN BOOLEAN,
5500: p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
5501: x_entered_max_score OUT NUMBER,
5502: x_stage_rec IN OUT NOCOPY HZ_PARTY_STAGE.party_stage_rec_type
5503: ) IS
5504: tmp VARCHAR2(4000);
5574: ************************************************/
5575:
5576: PROCEDURE MAP_PARTY_SITE_REC(
5577: p_search_ctx IN BOOLEAN,
5578: p_search_list IN HZ_PARTY_SEARCH.party_site_list,
5579: x_entered_max_score OUT NUMBER,
5580: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.party_site_stage_list
5581: ) IS
5582: l_current_max_score NUMBER;
5617: ************************************************/
5618:
5619: PROCEDURE MAP_CONTACT_REC(
5620: p_search_ctx IN BOOLEAN,
5621: p_search_list IN HZ_PARTY_SEARCH.contact_list,
5622: x_entered_max_score OUT NUMBER,
5623: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_stage_list
5624: ) IS
5625: l_current_max_score NUMBER;
5659: ************************************************/
5660:
5661: PROCEDURE MAP_CONTACT_POINT_REC(
5662: p_search_ctx IN BOOLEAN,
5663: p_search_list IN HZ_PARTY_SEARCH.contact_point_list,
5664: x_entered_max_score OUT NUMBER,
5665: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_pt_stage_list
5666: ) IS
5667: l_current_max_score NUMBER;
5765: 2. Contact Point Type is not null for each condition
5766: ************************************************/
5767:
5768: FUNCTION check_prim_cond(
5769: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
5770: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
5771: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
5772: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)
5773: RETURN BOOLEAN IS
5766: ************************************************/
5767:
5768: FUNCTION check_prim_cond(
5769: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
5770: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
5771: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
5772: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)
5773: RETURN BOOLEAN IS
5774: BEGIN
5767:
5768: FUNCTION check_prim_cond(
5769: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
5770: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
5771: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
5772: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)
5773: RETURN BOOLEAN IS
5774: BEGIN
5775: FOR I IN 1..p_contact_point_list.COUNT LOOP
5768: FUNCTION check_prim_cond(
5769: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
5770: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
5771: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
5772: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)
5773: RETURN BOOLEAN IS
5774: BEGIN
5775: FOR I IN 1..p_contact_point_list.COUNT LOOP
5776: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
5813: has party site criteria.
5814: ************************************************/
5815:
5816: PROCEDURE check_party_site_cond(
5817: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
5818: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
5819: x_secondary OUT BOOLEAN,
5820: x_primary OUT BOOLEAN
5821: ) IS
5814: ************************************************/
5815:
5816: PROCEDURE check_party_site_cond(
5817: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
5818: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
5819: x_secondary OUT BOOLEAN,
5820: x_primary OUT BOOLEAN
5821: ) IS
5822: BEGIN
5859: has contact criteria.
5860: ************************************************/
5861:
5862: PROCEDURE check_contact_cond(
5863: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
5864: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
5865: x_secondary OUT BOOLEAN,
5866: x_primary OUT BOOLEAN
5867: ) IS
5860: ************************************************/
5861:
5862: PROCEDURE check_contact_cond(
5863: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
5864: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
5865: x_secondary OUT BOOLEAN,
5866: x_primary OUT BOOLEAN
5867: ) IS
5868: BEGIN
5907: has valid contact point criteria.
5908: ************************************************/
5909:
5910: PROCEDURE check_contact_point_cond(
5911: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
5912: x_secondary OUT BOOLEAN,
5913: x_primary OUT BOOLEAN
5914: ) IS
5915: BEGIN