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;
365: PROCEDURE INSERT_PARTY_SCORE (
366: p_party_id IN NUMBER
367: ,p_record_id IN NUMBER
368: ,p_search_ctx_id IN NUMBER
369: ,p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type
370: ,p_stage_rec IN HZ_PARTY_STAGE.party_stage_rec_type
371: ,p_table_TX39 VARCHAR2
372: ,p_table_TX40 VARCHAR2
373: ,p_table_TX41 VARCHAR2
466: PROCEDURE INSERT_PARTY_SITES_SCORE (
467: p_party_id IN NUMBER
468: ,p_record_id IN NUMBER
469: ,p_search_ctx_id IN NUMBER
470: ,p_search_rec IN HZ_PARTY_SEARCH.party_site_search_rec_type
471: ,p_stage_rec IN HZ_PARTY_STAGE.party_site_stage_rec_type
472: ,p_table_TX4 VARCHAR2
473: ,p_table_TX3 VARCHAR2
474: ,p_idx IN NUMBER) IS
515: PROCEDURE INSERT_CONTACTS_SCORE (
516: p_party_id IN NUMBER
517: ,p_record_id IN NUMBER
518: ,p_search_ctx_id IN NUMBER
519: ,p_search_rec IN HZ_PARTY_SEARCH.contact_search_rec_type
520: ,p_stage_rec IN HZ_PARTY_STAGE.contact_stage_rec_type
521: ,p_idx IN NUMBER) IS
522: l_current_score NUMBER:=0;
523: l_score NUMBER;
531: PROCEDURE INSERT_CONTACT_POINTS_SCORE (
532: p_party_id IN NUMBER
533: ,p_record_id IN NUMBER
534: ,p_search_ctx_id IN NUMBER
535: ,p_search_rec IN HZ_PARTY_SEARCH.contact_point_search_rec_type
536: ,p_stage_rec IN HZ_PARTY_STAGE.contact_pt_stage_rec_type
537: ,p_idx IN NUMBER) IS
538: l_current_score NUMBER:=0;
539: l_score NUMBER;
550: for the PARTY Entity
551: ************************************************/
552:
553: PROCEDURE POP_PARTY_COND_REC(
554: p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type
555: ) IS
556: BEGIN
557: NULL ;
558: EXCEPTION
570: for the PARTY_SITES Entity
571: ************************************************/
572:
573: PROCEDURE POP_PARTY_SITES_COND_REC(
574: p_search_list IN HZ_PARTY_SEARCH.party_site_list
575: ) IS
576: BEGIN
577: NULL ;
578: EXCEPTION
590: for the CONTACTS Entity
591: ************************************************/
592:
593: PROCEDURE POP_CONTACTS_COND_REC(
594: p_search_list IN HZ_PARTY_SEARCH.contact_list
595: ) IS
596: BEGIN
597: NULL ;
598: EXCEPTION
610: for the CONTACT_POINTS Entity
611: ************************************************/
612:
613: PROCEDURE POP_CONTACT_POINTS_COND_REC(
614: p_search_list IN HZ_PARTY_SEARCH.contact_point_list
615: ) IS
616: BEGIN
617: NULL ;
618: EXCEPTION
624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
625: END;
626:
627: PROCEDURE init_score_context (
628: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
629: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
630: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
631: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
632: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
625: END;
626:
627: PROCEDURE init_score_context (
628: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
629: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
630: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
631: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
632: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
633: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
626:
627: PROCEDURE init_score_context (
628: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
629: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
630: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
631: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
632: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
633: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
634: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
627: PROCEDURE init_score_context (
628: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
629: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
630: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
631: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
632: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
633: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
634: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
635: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST
628: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
629: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
630: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
631: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
632: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
633: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
634: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
635: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST
636: ) IS
629: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
630: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
631: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
632: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
633: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
634: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
635: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST
636: ) IS
637: l_dummy NUMBER;
630: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
631: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
632: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
633: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
634: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
635: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST
636: ) IS
637: l_dummy NUMBER;
638: BEGIN
631: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
632: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
633: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
634: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
635: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST
636: ) IS
637: l_dummy NUMBER;
638: BEGIN
639: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
651: MAP_CONTACT_POINT_REC(FALSE,p_contact_point_list, l_dummy, g_contact_pt_stage_list);
652:
653: END;
654: FUNCTION init_search(
655: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
656: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
657: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
658: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
659: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
652:
653: END;
654: FUNCTION init_search(
655: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
656: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
657: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
658: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
659: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
660: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
653: END;
654: FUNCTION init_search(
655: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
656: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
657: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
658: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
659: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
660: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
661: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
654: FUNCTION init_search(
655: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
656: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
657: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
658: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
659: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
660: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
661: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
662: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST,
655: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
656: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
657: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
658: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
659: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
660: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
661: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
662: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST,
663: p_match_type IN VARCHAR2,
656: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
657: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
658: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
659: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
660: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
661: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
662: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST,
663: p_match_type IN VARCHAR2,
664: x_party_max_score OUT NUMBER,
657: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
658: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
659: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
660: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
661: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
662: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST,
663: p_match_type IN VARCHAR2,
664: x_party_max_score OUT NUMBER,
665: x_ps_max_score OUT NUMBER,
658: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
659: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
660: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
661: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
662: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST,
663: p_match_type IN VARCHAR2,
664: x_party_max_score OUT NUMBER,
665: x_ps_max_score OUT NUMBER,
666: x_contact_max_score OUT NUMBER,
670: l_ps_entered_max_score NUMBER:=0;
671: l_ct_entered_max_score NUMBER:=0;
672: l_cpt_entered_max_score NUMBER:=0;
673: vlist vlisttype;
674: maxscore HZ_PARTY_SEARCH.IDList;
675: l_name VARCHAR2(200);
676: l_idx NUMBER;
677: l_num NUMBER;
678: total NUMBER;
1960: p_party_id NUMBER,
1961: p_party_site_id NUMBER,
1962: p_org_contact_id NUMBER,
1963: p_contact_point_id NUMBER)
1964: RETURN HZ_PARTY_SEARCH.score_rec IS
1965: l_score_rec HZ_PARTY_SEARCH.score_rec;
1966: BEGIN
1967: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1968: 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);
1961: p_party_site_id NUMBER,
1962: p_org_contact_id NUMBER,
1963: p_contact_point_id NUMBER)
1964: RETURN HZ_PARTY_SEARCH.score_rec IS
1965: l_score_rec HZ_PARTY_SEARCH.score_rec;
1966: BEGIN
1967: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1968: 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);
1969: 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);
1993: **********************************************************/
1994:
1995: PROCEDURE find_parties (
1996: p_rule_id IN NUMBER,
1997: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
1998: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
1999: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2000: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2001: p_restrict_sql IN VARCHAR2,
1994:
1995: PROCEDURE find_parties (
1996: p_rule_id IN NUMBER,
1997: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
1998: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
1999: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2000: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2001: p_restrict_sql IN VARCHAR2,
2002: p_match_type IN VARCHAR2,
1995: PROCEDURE find_parties (
1996: p_rule_id IN NUMBER,
1997: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
1998: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
1999: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2000: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2001: p_restrict_sql IN VARCHAR2,
2002: p_match_type IN VARCHAR2,
2003: p_search_merged IN VARCHAR2,
1996: p_rule_id IN NUMBER,
1997: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
1998: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
1999: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2000: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2001: p_restrict_sql IN VARCHAR2,
2002: p_match_type IN VARCHAR2,
2003: p_search_merged IN VARCHAR2,
2004: p_dup_party_id IN NUMBER,
2034: l_TX44 VARCHAR2(2000);
2035: l_TX3 VARCHAR2(2000);
2036: l_TX4 VARCHAR2(2000);
2037: l_TX40 VARCHAR2(2000);
2038: H_SCORES HZ_PARTY_SEARCH.score_list;
2039: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
2040: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
2041:
2042: l_score NUMBER;
2035: l_TX3 VARCHAR2(2000);
2036: l_TX4 VARCHAR2(2000);
2037: l_TX40 VARCHAR2(2000);
2038: H_SCORES HZ_PARTY_SEARCH.score_list;
2039: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
2040: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
2041:
2042: l_score NUMBER;
2043: l_idx NUMBER;
2036: l_TX4 VARCHAR2(2000);
2037: l_TX40 VARCHAR2(2000);
2038: H_SCORES HZ_PARTY_SEARCH.score_list;
2039: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
2040: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
2041:
2042: l_score NUMBER;
2043: l_idx NUMBER;
2044: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
2227: /** Private procedure to acquire and score at party site level ***/
2228: 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
2229: l_party_id_idx NUMBER:=1;
2230: l_ctx_id NUMBER;
2231: h_ps_id HZ_PARTY_SEARCH.IDList;
2232: h_ps_party_id HZ_PARTY_SEARCH.IDList;
2233: h_ps_score HZ_PARTY_SEARCH.IDList;
2234: detcnt NUMBER := 1;
2235: BEGIN
2228: 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
2229: l_party_id_idx NUMBER:=1;
2230: l_ctx_id NUMBER;
2231: h_ps_id HZ_PARTY_SEARCH.IDList;
2232: h_ps_party_id HZ_PARTY_SEARCH.IDList;
2233: h_ps_score HZ_PARTY_SEARCH.IDList;
2234: detcnt NUMBER := 1;
2235: BEGIN
2236: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2229: l_party_id_idx NUMBER:=1;
2230: l_ctx_id NUMBER;
2231: h_ps_id HZ_PARTY_SEARCH.IDList;
2232: h_ps_party_id HZ_PARTY_SEARCH.IDList;
2233: h_ps_score HZ_PARTY_SEARCH.IDList;
2234: detcnt NUMBER := 1;
2235: BEGIN
2236: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2237: 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);
2349: /** Private procedure to acquire and score at contact point level ***/
2350: 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
2351: l_party_id_idx NUMBER:=1;
2352: l_ctx_id NUMBER;
2353: h_ct_id HZ_PARTY_SEARCH.IDList;
2354: h_ct_party_id HZ_PARTY_SEARCH.IDList;
2355: h_ct_score HZ_PARTY_SEARCH.IDList;
2356: detcnt NUMBER := 1;
2357: BEGIN
2350: 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
2351: l_party_id_idx NUMBER:=1;
2352: l_ctx_id NUMBER;
2353: h_ct_id HZ_PARTY_SEARCH.IDList;
2354: h_ct_party_id HZ_PARTY_SEARCH.IDList;
2355: h_ct_score HZ_PARTY_SEARCH.IDList;
2356: detcnt NUMBER := 1;
2357: BEGIN
2358: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2351: l_party_id_idx NUMBER:=1;
2352: l_ctx_id NUMBER;
2353: h_ct_id HZ_PARTY_SEARCH.IDList;
2354: h_ct_party_id HZ_PARTY_SEARCH.IDList;
2355: h_ct_score HZ_PARTY_SEARCH.IDList;
2356: detcnt NUMBER := 1;
2357: BEGIN
2358: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2359: 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);
2458: /** Private procedure to acquire and score at contact point level ***/
2459: 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
2460: l_party_id_idx NUMBER:=1;
2461: l_ctx_id NUMBER;
2462: h_cpt_id HZ_PARTY_SEARCH.IDList;
2463: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
2464: h_cpt_score HZ_PARTY_SEARCH.IDList;
2465: detcnt NUMBER := 1;
2466: l_cpt_flag VARCHAR2(1) := 'N';
2459: 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
2460: l_party_id_idx NUMBER:=1;
2461: l_ctx_id NUMBER;
2462: h_cpt_id HZ_PARTY_SEARCH.IDList;
2463: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
2464: h_cpt_score HZ_PARTY_SEARCH.IDList;
2465: detcnt NUMBER := 1;
2466: l_cpt_flag VARCHAR2(1) := 'N';
2467: is_a_match VARCHAR2(1) := 'Y';
2460: l_party_id_idx NUMBER:=1;
2461: l_ctx_id NUMBER;
2462: h_cpt_id HZ_PARTY_SEARCH.IDList;
2463: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
2464: h_cpt_score HZ_PARTY_SEARCH.IDList;
2465: detcnt NUMBER := 1;
2466: l_cpt_flag VARCHAR2(1) := 'N';
2467: is_a_match VARCHAR2(1) := 'Y';
2468: BEGIN
2947: END find_parties;
2948:
2949: PROCEDURE find_persons (
2950: p_rule_id IN NUMBER,
2951: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2952: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2953: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2954: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2955: p_restrict_sql IN VARCHAR2,
2948:
2949: PROCEDURE find_persons (
2950: p_rule_id IN NUMBER,
2951: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2952: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2953: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2954: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2955: p_restrict_sql IN VARCHAR2,
2956: p_match_type IN VARCHAR2,
2949: PROCEDURE find_persons (
2950: p_rule_id IN NUMBER,
2951: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2952: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2953: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2954: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2955: p_restrict_sql IN VARCHAR2,
2956: p_match_type IN VARCHAR2,
2957: p_search_merged IN VARCHAR2,
2950: p_rule_id IN NUMBER,
2951: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2952: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2953: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2954: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2955: p_restrict_sql IN VARCHAR2,
2956: p_match_type IN VARCHAR2,
2957: p_search_merged IN VARCHAR2,
2958: p_dup_party_id IN NUMBER,
2988: l_TX44 VARCHAR2(2000);
2989: l_TX3 VARCHAR2(2000);
2990: l_TX4 VARCHAR2(2000);
2991: l_TX40 VARCHAR2(2000);
2992: H_SCORES HZ_PARTY_SEARCH.score_list;
2993: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
2994: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
2995:
2996: l_score NUMBER;
2989: l_TX3 VARCHAR2(2000);
2990: l_TX4 VARCHAR2(2000);
2991: l_TX40 VARCHAR2(2000);
2992: H_SCORES HZ_PARTY_SEARCH.score_list;
2993: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
2994: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
2995:
2996: l_score NUMBER;
2997: l_idx NUMBER;
2990: l_TX4 VARCHAR2(2000);
2991: l_TX40 VARCHAR2(2000);
2992: H_SCORES HZ_PARTY_SEARCH.score_list;
2993: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
2994: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
2995:
2996: l_score NUMBER;
2997: l_idx NUMBER;
2998: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
3229: /** Private procedure to acquire and score at party site level ***/
3230: 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
3231: l_party_id_idx NUMBER:=1;
3232: l_ctx_id NUMBER;
3233: h_ps_id HZ_PARTY_SEARCH.IDList;
3234: h_ps_party_id HZ_PARTY_SEARCH.IDList;
3235: h_ps_score HZ_PARTY_SEARCH.IDList;
3236: detcnt NUMBER := 1;
3237: l_person_id NUMBER;
3230: 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
3231: l_party_id_idx NUMBER:=1;
3232: l_ctx_id NUMBER;
3233: h_ps_id HZ_PARTY_SEARCH.IDList;
3234: h_ps_party_id HZ_PARTY_SEARCH.IDList;
3235: h_ps_score HZ_PARTY_SEARCH.IDList;
3236: detcnt NUMBER := 1;
3237: l_person_id NUMBER;
3238: BEGIN
3231: l_party_id_idx NUMBER:=1;
3232: l_ctx_id NUMBER;
3233: h_ps_id HZ_PARTY_SEARCH.IDList;
3234: h_ps_party_id HZ_PARTY_SEARCH.IDList;
3235: h_ps_score HZ_PARTY_SEARCH.IDList;
3236: detcnt NUMBER := 1;
3237: l_person_id NUMBER;
3238: BEGIN
3239: SAVEPOINT eval_start;
3328: /** Private procedure to acquire and score at party site level ***/
3329: PROCEDURE eval_contact_level(p_contact_contains_str VARCHAR2,p_ins_details VARCHAR2,p_emax_score NUMBER) IS
3330: l_party_id_idx NUMBER:=1;
3331: l_ctx_id NUMBER;
3332: h_ct_id HZ_PARTY_SEARCH.IDList;
3333: h_ct_party_id HZ_PARTY_SEARCH.IDList;
3334: h_ct_score HZ_PARTY_SEARCH.IDList;
3335: detcnt NUMBER := 1;
3336: l_person_id NUMBER;
3329: PROCEDURE eval_contact_level(p_contact_contains_str VARCHAR2,p_ins_details VARCHAR2,p_emax_score NUMBER) IS
3330: l_party_id_idx NUMBER:=1;
3331: l_ctx_id NUMBER;
3332: h_ct_id HZ_PARTY_SEARCH.IDList;
3333: h_ct_party_id HZ_PARTY_SEARCH.IDList;
3334: h_ct_score HZ_PARTY_SEARCH.IDList;
3335: detcnt NUMBER := 1;
3336: l_person_id NUMBER;
3337: BEGIN
3330: l_party_id_idx NUMBER:=1;
3331: l_ctx_id NUMBER;
3332: h_ct_id HZ_PARTY_SEARCH.IDList;
3333: h_ct_party_id HZ_PARTY_SEARCH.IDList;
3334: h_ct_score HZ_PARTY_SEARCH.IDList;
3335: detcnt NUMBER := 1;
3336: l_person_id NUMBER;
3337: BEGIN
3338: SAVEPOINT eval_start;
3386: /** Private procedure to acquire and score at contact point level ***/
3387: 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
3388: l_party_id_idx NUMBER:=1;
3389: l_ctx_id NUMBER;
3390: h_cpt_id HZ_PARTY_SEARCH.IDList;
3391: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
3392: h_cpt_score HZ_PARTY_SEARCH.IDList;
3393: detcnt NUMBER := 1;
3394: l_person_id NUMBER;
3387: 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
3388: l_party_id_idx NUMBER:=1;
3389: l_ctx_id NUMBER;
3390: h_cpt_id HZ_PARTY_SEARCH.IDList;
3391: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
3392: h_cpt_score HZ_PARTY_SEARCH.IDList;
3393: detcnt NUMBER := 1;
3394: l_person_id NUMBER;
3395: is_a_match VARCHAR2(1) := 'Y';
3388: l_party_id_idx NUMBER:=1;
3389: l_ctx_id NUMBER;
3390: h_cpt_id HZ_PARTY_SEARCH.IDList;
3391: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
3392: h_cpt_score HZ_PARTY_SEARCH.IDList;
3393: detcnt NUMBER := 1;
3394: l_person_id NUMBER;
3395: is_a_match VARCHAR2(1) := 'Y';
3396: l_cpt_flag VARCHAR2(1) := 'N';
3799: END find_persons;
3800:
3801: PROCEDURE find_persons (
3802: p_rule_id IN NUMBER,
3803: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
3804: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
3805: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
3806: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
3807: p_restrict_sql IN VARCHAR2,
3800:
3801: PROCEDURE find_persons (
3802: p_rule_id IN NUMBER,
3803: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
3804: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
3805: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
3806: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
3807: p_restrict_sql IN VARCHAR2,
3808: p_match_type IN VARCHAR2,
3801: PROCEDURE find_persons (
3802: p_rule_id IN NUMBER,
3803: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
3804: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
3805: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
3806: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
3807: p_restrict_sql IN VARCHAR2,
3808: p_match_type IN VARCHAR2,
3809: p_search_merged IN VARCHAR2,
3802: p_rule_id IN NUMBER,
3803: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
3804: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
3805: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
3806: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
3807: p_restrict_sql IN VARCHAR2,
3808: p_match_type IN VARCHAR2,
3809: p_search_merged IN VARCHAR2,
3810: p_ins_details IN VARCHAR2,
3816: 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);
3817: END;
3818: PROCEDURE find_party_details (
3819: p_rule_id IN NUMBER,
3820: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
3821: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
3822: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
3823: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
3824: p_restrict_sql IN VARCHAR2,
3817: END;
3818: PROCEDURE find_party_details (
3819: p_rule_id IN NUMBER,
3820: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
3821: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
3822: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
3823: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
3824: p_restrict_sql IN VARCHAR2,
3825: p_match_type IN VARCHAR2,
3818: PROCEDURE find_party_details (
3819: p_rule_id IN NUMBER,
3820: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
3821: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
3822: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
3823: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
3824: p_restrict_sql IN VARCHAR2,
3825: p_match_type IN VARCHAR2,
3826: p_search_merged IN VARCHAR2,
3819: p_rule_id IN NUMBER,
3820: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
3821: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
3822: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
3823: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
3824: p_restrict_sql IN VARCHAR2,
3825: p_match_type IN VARCHAR2,
3826: p_search_merged IN VARCHAR2,
3827: x_search_ctx_id OUT NUMBER,
3876: x_dup_set_id OUT NUMBER,
3877: x_search_ctx_id OUT NUMBER,
3878: x_num_matches OUT NUMBER
3879: ) IS
3880: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
3881: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3882: l_contact_list HZ_PARTY_SEARCH.contact_list;
3883: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
3884: l_match_idx NUMBER;
3877: x_search_ctx_id OUT NUMBER,
3878: x_num_matches OUT NUMBER
3879: ) IS
3880: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
3881: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3882: l_contact_list HZ_PARTY_SEARCH.contact_list;
3883: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
3884: l_match_idx NUMBER;
3885:
3878: x_num_matches OUT NUMBER
3879: ) IS
3880: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
3881: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3882: l_contact_list HZ_PARTY_SEARCH.contact_list;
3883: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
3884: l_match_idx NUMBER;
3885:
3886: --Fix for bug 4417124
3879: ) IS
3880: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
3881: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3882: l_contact_list HZ_PARTY_SEARCH.contact_list;
3883: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
3884: l_match_idx NUMBER;
3885:
3886: --Fix for bug 4417124
3887: l_use_contact_addr_info BOOLEAN := TRUE;
3992: x_search_ctx_id OUT NUMBER,
3993: x_num_matches OUT NUMBER
3994: ) IS
3995:
3996: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3997: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3998: l_contact_list HZ_PARTY_SEARCH.contact_list;
3999: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4000: contact_point_ids HZ_PARTY_SEARCH.IDList;
3993: x_num_matches OUT NUMBER
3994: ) IS
3995:
3996: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3997: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3998: l_contact_list HZ_PARTY_SEARCH.contact_list;
3999: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4000: contact_point_ids HZ_PARTY_SEARCH.IDList;
4001: p_party_site_list HZ_PARTY_SEARCH.IDList;
3994: ) IS
3995:
3996: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3997: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3998: l_contact_list HZ_PARTY_SEARCH.contact_list;
3999: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4000: contact_point_ids HZ_PARTY_SEARCH.IDList;
4001: p_party_site_list HZ_PARTY_SEARCH.IDList;
4002: p_contact_ids HZ_PARTY_SEARCH.IDList;
3995:
3996: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3997: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3998: l_contact_list HZ_PARTY_SEARCH.contact_list;
3999: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4000: contact_point_ids HZ_PARTY_SEARCH.IDList;
4001: p_party_site_list HZ_PARTY_SEARCH.IDList;
4002: p_contact_ids HZ_PARTY_SEARCH.IDList;
4003: l_match_idx NUMBER;
3996: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3997: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3998: l_contact_list HZ_PARTY_SEARCH.contact_list;
3999: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4000: contact_point_ids HZ_PARTY_SEARCH.IDList;
4001: p_party_site_list HZ_PARTY_SEARCH.IDList;
4002: p_contact_ids HZ_PARTY_SEARCH.IDList;
4003: l_match_idx NUMBER;
4004: cursor get_cpts_for_party_sites is select contact_point_id
3997: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3998: l_contact_list HZ_PARTY_SEARCH.contact_list;
3999: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4000: contact_point_ids HZ_PARTY_SEARCH.IDList;
4001: p_party_site_list HZ_PARTY_SEARCH.IDList;
4002: p_contact_ids HZ_PARTY_SEARCH.IDList;
4003: l_match_idx NUMBER;
4004: cursor get_cpts_for_party_sites is select contact_point_id
4005: from hz_contact_points
3998: l_contact_list HZ_PARTY_SEARCH.contact_list;
3999: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4000: contact_point_ids HZ_PARTY_SEARCH.IDList;
4001: p_party_site_list HZ_PARTY_SEARCH.IDList;
4002: p_contact_ids HZ_PARTY_SEARCH.IDList;
4003: l_match_idx NUMBER;
4004: cursor get_cpts_for_party_sites is select contact_point_id
4005: from hz_contact_points
4006: where owner_table_name = 'HZ_PARTY_SITES'
4027:
4028: get_search_criteria (
4029: null,
4030: p_party_site_list,
4031: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
4032: contact_point_ids,
4033: l_party_search_rec,
4034: l_party_site_list,
4035: l_contact_list,
4077: x_search_ctx_id OUT NUMBER,
4078: x_num_matches OUT NUMBER
4079: ) IS
4080:
4081: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
4082: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4083: l_contact_list HZ_PARTY_SEARCH.contact_list;
4084: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4085: contact_point_ids HZ_PARTY_SEARCH.IDList;
4078: x_num_matches OUT NUMBER
4079: ) IS
4080:
4081: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
4082: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4083: l_contact_list HZ_PARTY_SEARCH.contact_list;
4084: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4085: contact_point_ids HZ_PARTY_SEARCH.IDList;
4086: p_party_site_list HZ_PARTY_SEARCH.IDList;
4079: ) IS
4080:
4081: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
4082: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4083: l_contact_list HZ_PARTY_SEARCH.contact_list;
4084: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4085: contact_point_ids HZ_PARTY_SEARCH.IDList;
4086: p_party_site_list HZ_PARTY_SEARCH.IDList;
4087: p_contact_ids HZ_PARTY_SEARCH.IDList;
4080:
4081: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
4082: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4083: l_contact_list HZ_PARTY_SEARCH.contact_list;
4084: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4085: contact_point_ids HZ_PARTY_SEARCH.IDList;
4086: p_party_site_list HZ_PARTY_SEARCH.IDList;
4087: p_contact_ids HZ_PARTY_SEARCH.IDList;
4088: l_match_idx NUMBER;
4081: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
4082: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4083: l_contact_list HZ_PARTY_SEARCH.contact_list;
4084: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4085: contact_point_ids HZ_PARTY_SEARCH.IDList;
4086: p_party_site_list HZ_PARTY_SEARCH.IDList;
4087: p_contact_ids HZ_PARTY_SEARCH.IDList;
4088: l_match_idx NUMBER;
4089: cursor get_cpt_for_contact_id is select contact_point_id
4082: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4083: l_contact_list HZ_PARTY_SEARCH.contact_list;
4084: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4085: contact_point_ids HZ_PARTY_SEARCH.IDList;
4086: p_party_site_list HZ_PARTY_SEARCH.IDList;
4087: p_contact_ids HZ_PARTY_SEARCH.IDList;
4088: l_match_idx NUMBER;
4089: cursor get_cpt_for_contact_id is select contact_point_id
4090: from hz_org_contacts a, hz_relationships b, hz_contact_points c
4083: l_contact_list HZ_PARTY_SEARCH.contact_list;
4084: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4085: contact_point_ids HZ_PARTY_SEARCH.IDList;
4086: p_party_site_list HZ_PARTY_SEARCH.IDList;
4087: p_contact_ids HZ_PARTY_SEARCH.IDList;
4088: l_match_idx NUMBER;
4089: cursor get_cpt_for_contact_id is select contact_point_id
4090: from hz_org_contacts a, hz_relationships b, hz_contact_points c
4091: where a.party_relationship_id = b.relationship_id
4114: CLOSE get_cpt_for_contact_id;
4115:
4116: get_search_criteria (
4117: null,
4118: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
4119: p_contact_ids,
4120: contact_point_ids,
4121: l_party_search_rec,
4122: l_party_site_list,
4165: p_match_type IN VARCHAR2,
4166: x_search_ctx_id OUT NUMBER,
4167: x_num_matches OUT NUMBER
4168: ) IS
4169: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
4170: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4171: l_contact_list HZ_PARTY_SEARCH.contact_list;
4172: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4173: contact_point_ids HZ_PARTY_SEARCH.IDList;
4166: x_search_ctx_id OUT NUMBER,
4167: x_num_matches OUT NUMBER
4168: ) IS
4169: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
4170: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4171: l_contact_list HZ_PARTY_SEARCH.contact_list;
4172: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4173: contact_point_ids HZ_PARTY_SEARCH.IDList;
4174: p_party_site_list HZ_PARTY_SEARCH.IDList;
4167: x_num_matches OUT NUMBER
4168: ) IS
4169: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
4170: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4171: l_contact_list HZ_PARTY_SEARCH.contact_list;
4172: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4173: contact_point_ids HZ_PARTY_SEARCH.IDList;
4174: p_party_site_list HZ_PARTY_SEARCH.IDList;
4175: p_contact_ids HZ_PARTY_SEARCH.IDList;
4168: ) IS
4169: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
4170: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4171: l_contact_list HZ_PARTY_SEARCH.contact_list;
4172: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4173: contact_point_ids HZ_PARTY_SEARCH.IDList;
4174: p_party_site_list HZ_PARTY_SEARCH.IDList;
4175: p_contact_ids HZ_PARTY_SEARCH.IDList;
4176: l_match_idx NUMBER;
4169: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
4170: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4171: l_contact_list HZ_PARTY_SEARCH.contact_list;
4172: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4173: contact_point_ids HZ_PARTY_SEARCH.IDList;
4174: p_party_site_list HZ_PARTY_SEARCH.IDList;
4175: p_contact_ids HZ_PARTY_SEARCH.IDList;
4176: l_match_idx NUMBER;
4177:
4170: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4171: l_contact_list HZ_PARTY_SEARCH.contact_list;
4172: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4173: contact_point_ids HZ_PARTY_SEARCH.IDList;
4174: p_party_site_list HZ_PARTY_SEARCH.IDList;
4175: p_contact_ids HZ_PARTY_SEARCH.IDList;
4176: l_match_idx NUMBER;
4177:
4178: BEGIN
4171: l_contact_list HZ_PARTY_SEARCH.contact_list;
4172: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4173: contact_point_ids HZ_PARTY_SEARCH.IDList;
4174: p_party_site_list HZ_PARTY_SEARCH.IDList;
4175: p_contact_ids HZ_PARTY_SEARCH.IDList;
4176: l_match_idx NUMBER;
4177:
4178: BEGIN
4179: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4188: END IF;
4189: contact_point_ids(1) := p_contact_point_id;
4190: get_search_criteria (
4191: null,
4192: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
4193: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
4194: contact_point_ids,
4195: l_party_search_rec,
4196: l_party_site_list,
4189: contact_point_ids(1) := p_contact_point_id;
4190: get_search_criteria (
4191: null,
4192: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
4193: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
4194: contact_point_ids,
4195: l_party_search_rec,
4196: l_party_site_list,
4197: l_contact_list,
4342: ) IS
4343: TYPE AttrList IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
4344: l_match_idx NUMBER;
4345: AttrVals AttrList;
4346: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
4347: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4348: l_contact_list HZ_PARTY_SEARCH.contact_list;
4349: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
4350: l_dup_set_id NUMBER;
4343: TYPE AttrList IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
4344: l_match_idx NUMBER;
4345: AttrVals AttrList;
4346: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
4347: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4348: l_contact_list HZ_PARTY_SEARCH.contact_list;
4349: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
4350: l_dup_set_id NUMBER;
4351: l_idx NUMBER;
4344: l_match_idx NUMBER;
4345: AttrVals AttrList;
4346: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
4347: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4348: l_contact_list HZ_PARTY_SEARCH.contact_list;
4349: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
4350: l_dup_set_id NUMBER;
4351: l_idx NUMBER;
4352: l_cpt_type VARCHAR2(255);
4345: AttrVals AttrList;
4346: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
4347: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4348: l_contact_list HZ_PARTY_SEARCH.contact_list;
4349: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
4350: l_dup_set_id NUMBER;
4351: l_idx NUMBER;
4352: l_cpt_type VARCHAR2(255);
4353: FIRST BOOLEAN := TRUE;
4507:
4508: PROCEDURE get_matching_party_sites (
4509: p_rule_id IN NUMBER,
4510: p_party_id IN NUMBER,
4511: p_party_site_list IN HZ_PARTY_SEARCH.PARTY_SITE_LIST,
4512: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
4513: p_restrict_sql IN VARCHAR2,
4514: p_match_type IN VARCHAR2,
4515: p_dup_party_site_id IN NUMBER,
4508: PROCEDURE get_matching_party_sites (
4509: p_rule_id IN NUMBER,
4510: p_party_id IN NUMBER,
4511: p_party_site_list IN HZ_PARTY_SEARCH.PARTY_SITE_LIST,
4512: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
4513: p_restrict_sql IN VARCHAR2,
4514: p_match_type IN VARCHAR2,
4515: p_dup_party_site_id IN NUMBER,
4516: x_search_ctx_id OUT NUMBER,
4535: l_search_ctx_id NUMBER; -- Generated Search Context ID
4536:
4537: l_TX3 VARCHAR2(2000);
4538: l_TX4 VARCHAR2(2000);
4539: H_SCORES HZ_PARTY_SEARCH.score_list;
4540:
4541: l_score NUMBER;
4542: l_idx NUMBER;
4543: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4566: defps NUMBER :=0;
4567: defct NUMBER :=0;
4568: defcpt NUMBER :=0;
4569: l_index NUMBER;
4570: l_match_ps_list HZ_PARTY_SEARCH.IDList;
4571: l_cnt NUMBER:=1;
4572:
4573:
4574: BEGIN
4590: l_match_str := ' AND ';
4591: ELSIF p_match_type = 'OR' THEN
4592: l_match_str := ' OR ';
4593: END IF;
4594: 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);
4595: g_score_until_thresh := false;
4596: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4597:
4598: -- ************************************************************
4598: -- ************************************************************
4599: -- STEP 2. Setup of intermedia query strings for Acquisition query
4600: l_party_site_contains_str := INIT_PARTY_SITES_QUERY(l_match_str,l_tmp);
4601: l_contact_pt_contains_str := INIT_CONTACT_POINTS_QUERY(l_match_str,l_tmp);
4602: 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);
4603:
4604: -- Setup Search Context ID
4605: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;
4606: x_search_ctx_id := l_search_ctx_id;
4741:
4742: PROCEDURE get_matching_contacts (
4743: p_rule_id IN NUMBER,
4744: p_party_id IN NUMBER,
4745: p_contact_list IN HZ_PARTY_SEARCH.CONTACT_LIST,
4746: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
4747: p_restrict_sql IN VARCHAR2,
4748: p_match_type IN VARCHAR2,
4749: p_dup_contact_id IN NUMBER,
4742: PROCEDURE get_matching_contacts (
4743: p_rule_id IN NUMBER,
4744: p_party_id IN NUMBER,
4745: p_contact_list IN HZ_PARTY_SEARCH.CONTACT_LIST,
4746: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
4747: p_restrict_sql IN VARCHAR2,
4748: p_match_type IN VARCHAR2,
4749: p_dup_contact_id IN NUMBER,
4750: x_search_ctx_id OUT NUMBER,
4767: l_entered_max_score NUMBER;
4768: FIRST BOOLEAN;
4769: l_search_ctx_id NUMBER; -- Generated Search Context ID
4770:
4771: H_SCORES HZ_PARTY_SEARCH.score_list;
4772:
4773: l_score NUMBER;
4774: l_idx NUMBER;
4775: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4795: l_party_max_score NUMBER;
4796: l_ps_max_score NUMBER;
4797: l_contact_max_score NUMBER;
4798: l_cpt_max_score NUMBER;
4799: l_match_contact_list HZ_PARTY_SEARCH.IDList;
4800: l_cnt NUMBER:=1;
4801:
4802:
4803: BEGIN
4819: l_match_str := ' AND ';
4820: ELSIF p_match_type = 'OR' THEN
4821: l_match_str := ' OR ';
4822: END IF;
4823: 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);
4824: g_score_until_thresh := false;
4825: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4826:
4827: -- ************************************************************
4827: -- ************************************************************
4828: -- STEP 2. Setup of intermedia query strings for Acquisition query
4829: l_contact_contains_str := INIT_CONTACTS_QUERY(l_match_str,l_tmp);
4830: l_contact_pt_contains_str := INIT_CONTACT_POINTS_QUERY(l_match_str,l_tmp);
4831: 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);
4832:
4833: -- Setup Search Context ID
4834: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;
4835: x_search_ctx_id := l_search_ctx_id;
4966:
4967: PROCEDURE get_matching_contact_points (
4968: p_rule_id IN NUMBER,
4969: p_party_id IN NUMBER,
4970: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
4971: p_restrict_sql IN VARCHAR2,
4972: p_match_type IN VARCHAR2,
4973: p_dup_contact_point_id IN NUMBER,
4974: x_search_ctx_id OUT NUMBER,
4995: l_cpt_ps_id NUMBER;
4996: l_cpt_contact_id NUMBER;
4997: l_contact_pt_id NUMBER;
4998: l_cpt_type VARCHAR2(100);
4999: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
5000: H_CONTACT_POINT_ID HZ_PARTY_SEARCH.IDList;
5001: H_SCORE HZ_PARTY_SEARCH.IDList;
5002:
5003: cnt NUMBER :=0;
4996: l_cpt_contact_id NUMBER;
4997: l_contact_pt_id NUMBER;
4998: l_cpt_type VARCHAR2(100);
4999: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
5000: H_CONTACT_POINT_ID HZ_PARTY_SEARCH.IDList;
5001: H_SCORE HZ_PARTY_SEARCH.IDList;
5002:
5003: cnt NUMBER :=0;
5004: l_party_max_score NUMBER;
4997: l_contact_pt_id NUMBER;
4998: l_cpt_type VARCHAR2(100);
4999: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
5000: H_CONTACT_POINT_ID HZ_PARTY_SEARCH.IDList;
5001: H_SCORE HZ_PARTY_SEARCH.IDList;
5002:
5003: cnt NUMBER :=0;
5004: l_party_max_score NUMBER;
5005: l_ps_max_score NUMBER;
5026: l_match_str := ' AND ';
5027: ELSIF p_match_type = 'OR' THEN
5028: l_match_str := ' OR ';
5029: END IF;
5030: l_entered_max_score:= init_search(HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
5031: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST, HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
5032: p_contact_point_list,l_match_str, l_party_max_score, l_ps_max_score, l_contact_max_score, l_cpt_max_score);
5033: g_score_until_thresh := false;
5034: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
5027: ELSIF p_match_type = 'OR' THEN
5028: l_match_str := ' OR ';
5029: END IF;
5030: l_entered_max_score:= init_search(HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
5031: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST, HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
5032: p_contact_point_list,l_match_str, l_party_max_score, l_ps_max_score, l_contact_max_score, l_cpt_max_score);
5033: g_score_until_thresh := false;
5034: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
5035:
5035:
5036: -- ************************************************************
5037: -- STEP 2. Setup of intermedia query strings for Acquisition query
5038: l_contact_pt_contains_str := INIT_CONTACT_POINTS_QUERY(l_match_str,l_tmp);
5039: 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);
5040:
5041: -- Setup Search Context ID
5042: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;
5043: x_search_ctx_id := l_search_ctx_id;
5110:
5111: PROCEDURE get_score_details (
5112: p_rule_id IN NUMBER,
5113: p_party_id IN NUMBER,
5114: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
5115: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
5116: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
5117: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
5118: x_search_ctx_id IN OUT NUMBER
5111: PROCEDURE get_score_details (
5112: p_rule_id IN NUMBER,
5113: p_party_id IN NUMBER,
5114: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
5115: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
5116: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
5117: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
5118: x_search_ctx_id IN OUT NUMBER
5119: ) IS
5112: p_rule_id IN NUMBER,
5113: p_party_id IN NUMBER,
5114: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
5115: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
5116: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
5117: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
5118: x_search_ctx_id IN OUT NUMBER
5119: ) IS
5120:
5113: p_party_id IN NUMBER,
5114: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
5115: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
5116: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
5117: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
5118: x_search_ctx_id IN OUT NUMBER
5119: ) IS
5120:
5121: -- Strings to hold the generated Intermedia query strings
5144: l_TX4 VARCHAR2(2000);
5145: l_max_TX4 VARCHAR2(2000);
5146: l_TX40 VARCHAR2(2000);
5147: l_max_TX40 VARCHAR2(2000);
5148: H_SCORES HZ_PARTY_SEARCH.score_list;
5149:
5150: l_score NUMBER;
5151: l_match_idx NUMBER;
5152: l_idx NUMBER;
5311: ************************************************/
5312:
5313: PROCEDURE get_party_for_search (
5314: p_party_id IN NUMBER,
5315: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
5316: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
5317: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
5318: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5319: ) IS
5312:
5313: PROCEDURE get_party_for_search (
5314: p_party_id IN NUMBER,
5315: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
5316: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
5317: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
5318: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5319: ) IS
5320: l_party_id NUMBER;
5313: PROCEDURE get_party_for_search (
5314: p_party_id IN NUMBER,
5315: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
5316: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
5317: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
5318: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5319: ) IS
5320: l_party_id NUMBER;
5321: l_party_site_ids HZ_PARTY_SEARCH.IDList;
5314: p_party_id IN NUMBER,
5315: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
5316: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
5317: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
5318: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5319: ) IS
5320: l_party_id NUMBER;
5321: l_party_site_ids HZ_PARTY_SEARCH.IDList;
5322: l_contact_ids HZ_PARTY_SEARCH.IDList;
5317: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
5318: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5319: ) IS
5320: l_party_id NUMBER;
5321: l_party_site_ids HZ_PARTY_SEARCH.IDList;
5322: l_contact_ids HZ_PARTY_SEARCH.IDList;
5323: l_contact_pt_ids HZ_PARTY_SEARCH.IDList;
5324: ps NUMBER :=1;
5325: cpt NUMBER :=1;
5318: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5319: ) IS
5320: l_party_id NUMBER;
5321: l_party_site_ids HZ_PARTY_SEARCH.IDList;
5322: l_contact_ids HZ_PARTY_SEARCH.IDList;
5323: l_contact_pt_ids HZ_PARTY_SEARCH.IDList;
5324: ps NUMBER :=1;
5325: cpt NUMBER :=1;
5326: ct NUMBER :=1;
5319: ) IS
5320: l_party_id NUMBER;
5321: l_party_site_ids HZ_PARTY_SEARCH.IDList;
5322: l_contact_ids HZ_PARTY_SEARCH.IDList;
5323: l_contact_pt_ids HZ_PARTY_SEARCH.IDList;
5324: ps NUMBER :=1;
5325: cpt NUMBER :=1;
5326: ct NUMBER :=1;
5327: l_use_contact_info varchar2(1);
5383: END get_party_for_search;
5384:
5385: PROCEDURE get_search_criteria (
5386: p_party_id IN NUMBER,
5387: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
5388: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
5389: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
5390: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
5391: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
5384:
5385: PROCEDURE get_search_criteria (
5386: p_party_id IN NUMBER,
5387: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
5388: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
5389: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
5390: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
5391: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
5392: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
5385: PROCEDURE get_search_criteria (
5386: p_party_id IN NUMBER,
5387: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
5388: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
5389: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
5390: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
5391: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
5392: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
5393: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5386: p_party_id IN NUMBER,
5387: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
5388: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
5389: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
5390: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
5391: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
5392: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
5393: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5394: ) IS
5387: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
5388: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
5389: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
5390: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
5391: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
5392: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
5393: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5394: ) IS
5395: BEGIN
5388: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
5389: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
5390: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
5391: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
5392: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
5393: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5394: ) IS
5395: BEGIN
5396:
5389: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
5390: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
5391: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
5392: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
5393: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5394: ) IS
5395: BEGIN
5396:
5397: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5429: ************************************************/
5430:
5431: PROCEDURE get_party_rec (
5432: p_party_id IN NUMBER,
5433: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type
5434: ) IS
5435: l_party_type VARCHAR2(255);
5436: BEGIN
5437:
5492: the party site search record structure
5493: ************************************************/
5494:
5495: PROCEDURE get_party_site_rec (
5496: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
5497: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
5498: ) IS
5499: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5500: SELECT party_site_id
5493: ************************************************/
5494:
5495: PROCEDURE get_party_site_rec (
5496: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
5497: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
5498: ) IS
5499: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5500: SELECT party_site_id
5501: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5548: the contact search record structure
5549: ************************************************/
5550:
5551: PROCEDURE get_contact_rec (
5552: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
5553: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
5554: ) IS
5555: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
5556: SELECT org_contact_id
5549: ************************************************/
5550:
5551: PROCEDURE get_contact_rec (
5552: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
5553: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
5554: ) IS
5555: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
5556: SELECT org_contact_id
5557: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
5604: the contact point search record structure
5605: ************************************************/
5606:
5607: PROCEDURE get_contact_point_rec (
5608: p_contact_point_ids IN HZ_PARTY_SEARCH.IDList,
5609: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5610: ) IS
5611:
5612: -- Cursor to fetch primary contact points for party
5605: ************************************************/
5606:
5607: PROCEDURE get_contact_point_rec (
5608: p_contact_point_ids IN HZ_PARTY_SEARCH.IDList,
5609: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5610: ) IS
5611:
5612: -- Cursor to fetch primary contact points for party
5613: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
5659: ************************************************/
5660:
5661: PROCEDURE MAP_PARTY_REC(
5662: p_search_ctx IN BOOLEAN,
5663: p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
5664: x_entered_max_score OUT NUMBER,
5665: x_stage_rec IN OUT NOCOPY HZ_PARTY_STAGE.party_stage_rec_type
5666: ) IS
5667: tmp VARCHAR2(4000);
5796: ************************************************/
5797:
5798: PROCEDURE MAP_PARTY_SITE_REC(
5799: p_search_ctx IN BOOLEAN,
5800: p_search_list IN HZ_PARTY_SEARCH.party_site_list,
5801: x_entered_max_score OUT NUMBER,
5802: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.party_site_stage_list
5803: ) IS
5804: l_current_max_score NUMBER;
5911: ************************************************/
5912:
5913: PROCEDURE MAP_CONTACT_REC(
5914: p_search_ctx IN BOOLEAN,
5915: p_search_list IN HZ_PARTY_SEARCH.contact_list,
5916: x_entered_max_score OUT NUMBER,
5917: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_stage_list
5918: ) IS
5919: l_current_max_score NUMBER;
5953: ************************************************/
5954:
5955: PROCEDURE MAP_CONTACT_POINT_REC(
5956: p_search_ctx IN BOOLEAN,
5957: p_search_list IN HZ_PARTY_SEARCH.contact_point_list,
5958: x_entered_max_score OUT NUMBER,
5959: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_pt_stage_list
5960: ) IS
5961: l_current_max_score NUMBER;
6019: 2. Contact Point Type is not null for each condition
6020: ************************************************/
6021:
6022: FUNCTION check_prim_cond(
6023: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
6024: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
6025: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
6026: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)
6027: RETURN BOOLEAN IS
6020: ************************************************/
6021:
6022: FUNCTION check_prim_cond(
6023: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
6024: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
6025: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
6026: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)
6027: RETURN BOOLEAN IS
6028: BEGIN
6021:
6022: FUNCTION check_prim_cond(
6023: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
6024: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
6025: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
6026: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)
6027: RETURN BOOLEAN IS
6028: BEGIN
6029: IF p_party_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6022: FUNCTION check_prim_cond(
6023: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
6024: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
6025: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
6026: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)
6027: RETURN BOOLEAN IS
6028: BEGIN
6029: IF p_party_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6030: RETURN TRUE;
6051: has party site criteria.
6052: ************************************************/
6053:
6054: PROCEDURE check_party_site_cond(
6055: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
6056: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
6057: x_secondary OUT BOOLEAN,
6058: x_primary OUT BOOLEAN
6059: ) IS
6052: ************************************************/
6053:
6054: PROCEDURE check_party_site_cond(
6055: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
6056: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
6057: x_secondary OUT BOOLEAN,
6058: x_primary OUT BOOLEAN
6059: ) IS
6060: BEGIN
6095: has contact criteria.
6096: ************************************************/
6097:
6098: PROCEDURE check_contact_cond(
6099: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
6100: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
6101: x_secondary OUT BOOLEAN,
6102: x_primary OUT BOOLEAN
6103: ) IS
6096: ************************************************/
6097:
6098: PROCEDURE check_contact_cond(
6099: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
6100: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
6101: x_secondary OUT BOOLEAN,
6102: x_primary OUT BOOLEAN
6103: ) IS
6104: BEGIN
6133: has valid contact point criteria.
6134: ************************************************/
6135:
6136: PROCEDURE check_contact_point_cond(
6137: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
6138: x_secondary OUT BOOLEAN,
6139: x_primary OUT BOOLEAN
6140: ) IS
6141: BEGIN