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;
1886: p_party_id NUMBER,
1887: p_party_site_id NUMBER,
1888: p_org_contact_id NUMBER,
1889: p_contact_point_id NUMBER)
1890: RETURN HZ_PARTY_SEARCH.score_rec IS
1891: l_score_rec HZ_PARTY_SEARCH.score_rec;
1892: BEGIN
1893: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1894: 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);
1887: p_party_site_id NUMBER,
1888: p_org_contact_id NUMBER,
1889: p_contact_point_id NUMBER)
1890: RETURN HZ_PARTY_SEARCH.score_rec IS
1891: l_score_rec HZ_PARTY_SEARCH.score_rec;
1892: BEGIN
1893: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1894: 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);
1895: 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);
1919: **********************************************************/
1920:
1921: PROCEDURE find_parties (
1922: p_rule_id IN NUMBER,
1923: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
1924: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
1925: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
1926: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
1927: p_restrict_sql IN VARCHAR2,
1920:
1921: PROCEDURE find_parties (
1922: p_rule_id IN NUMBER,
1923: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
1924: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
1925: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
1926: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
1927: p_restrict_sql IN VARCHAR2,
1928: p_match_type IN VARCHAR2,
1921: PROCEDURE find_parties (
1922: p_rule_id IN NUMBER,
1923: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
1924: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
1925: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
1926: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
1927: p_restrict_sql IN VARCHAR2,
1928: p_match_type IN VARCHAR2,
1929: p_search_merged IN VARCHAR2,
1922: p_rule_id IN NUMBER,
1923: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
1924: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
1925: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
1926: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
1927: p_restrict_sql IN VARCHAR2,
1928: p_match_type IN VARCHAR2,
1929: p_search_merged IN VARCHAR2,
1930: p_dup_party_id IN NUMBER,
1958: l_TX44 VARCHAR2(2000);
1959: l_TX1 VARCHAR2(2000);
1960: l_TX5 VARCHAR2(2000);
1961: l_TX6 VARCHAR2(2000);
1962: H_SCORES HZ_PARTY_SEARCH.score_list;
1963: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
1964: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
1965:
1966: l_score NUMBER;
1959: l_TX1 VARCHAR2(2000);
1960: l_TX5 VARCHAR2(2000);
1961: l_TX6 VARCHAR2(2000);
1962: H_SCORES HZ_PARTY_SEARCH.score_list;
1963: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
1964: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
1965:
1966: l_score NUMBER;
1967: l_idx NUMBER;
1960: l_TX5 VARCHAR2(2000);
1961: l_TX6 VARCHAR2(2000);
1962: H_SCORES HZ_PARTY_SEARCH.score_list;
1963: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
1964: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
1965:
1966: l_score NUMBER;
1967: l_idx NUMBER;
1968: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
2151: /** Private procedure to acquire and score at party site level ***/
2152: 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
2153: l_party_id_idx NUMBER:=1;
2154: l_ctx_id NUMBER;
2155: h_ps_id HZ_PARTY_SEARCH.IDList;
2156: h_ps_party_id HZ_PARTY_SEARCH.IDList;
2157: h_ps_score HZ_PARTY_SEARCH.IDList;
2158: detcnt NUMBER := 1;
2159: BEGIN
2152: 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
2153: l_party_id_idx NUMBER:=1;
2154: l_ctx_id NUMBER;
2155: h_ps_id HZ_PARTY_SEARCH.IDList;
2156: h_ps_party_id HZ_PARTY_SEARCH.IDList;
2157: h_ps_score HZ_PARTY_SEARCH.IDList;
2158: detcnt NUMBER := 1;
2159: BEGIN
2160: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2153: l_party_id_idx NUMBER:=1;
2154: l_ctx_id NUMBER;
2155: h_ps_id HZ_PARTY_SEARCH.IDList;
2156: h_ps_party_id HZ_PARTY_SEARCH.IDList;
2157: h_ps_score HZ_PARTY_SEARCH.IDList;
2158: detcnt NUMBER := 1;
2159: BEGIN
2160: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2161: 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);
2273: /** Private procedure to acquire and score at contact point level ***/
2274: 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
2275: l_party_id_idx NUMBER:=1;
2276: l_ctx_id NUMBER;
2277: h_ct_id HZ_PARTY_SEARCH.IDList;
2278: h_ct_party_id HZ_PARTY_SEARCH.IDList;
2279: h_ct_score HZ_PARTY_SEARCH.IDList;
2280: detcnt NUMBER := 1;
2281: BEGIN
2274: 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
2275: l_party_id_idx NUMBER:=1;
2276: l_ctx_id NUMBER;
2277: h_ct_id HZ_PARTY_SEARCH.IDList;
2278: h_ct_party_id HZ_PARTY_SEARCH.IDList;
2279: h_ct_score HZ_PARTY_SEARCH.IDList;
2280: detcnt NUMBER := 1;
2281: BEGIN
2282: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2275: l_party_id_idx NUMBER:=1;
2276: l_ctx_id NUMBER;
2277: h_ct_id HZ_PARTY_SEARCH.IDList;
2278: h_ct_party_id HZ_PARTY_SEARCH.IDList;
2279: h_ct_score HZ_PARTY_SEARCH.IDList;
2280: detcnt NUMBER := 1;
2281: BEGIN
2282: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2283: 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);
2382: /** Private procedure to acquire and score at contact point level ***/
2383: 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
2384: l_party_id_idx NUMBER:=1;
2385: l_ctx_id NUMBER;
2386: h_cpt_id HZ_PARTY_SEARCH.IDList;
2387: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
2388: h_cpt_score HZ_PARTY_SEARCH.IDList;
2389: detcnt NUMBER := 1;
2390: l_cpt_flag VARCHAR2(1) := 'N';
2383: 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
2384: l_party_id_idx NUMBER:=1;
2385: l_ctx_id NUMBER;
2386: h_cpt_id HZ_PARTY_SEARCH.IDList;
2387: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
2388: h_cpt_score HZ_PARTY_SEARCH.IDList;
2389: detcnt NUMBER := 1;
2390: l_cpt_flag VARCHAR2(1) := 'N';
2391: is_a_match VARCHAR2(1) := 'Y';
2384: l_party_id_idx NUMBER:=1;
2385: l_ctx_id NUMBER;
2386: h_cpt_id HZ_PARTY_SEARCH.IDList;
2387: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
2388: h_cpt_score HZ_PARTY_SEARCH.IDList;
2389: detcnt NUMBER := 1;
2390: l_cpt_flag VARCHAR2(1) := 'N';
2391: is_a_match VARCHAR2(1) := 'Y';
2392: BEGIN
2833: END find_parties;
2834:
2835: PROCEDURE find_persons (
2836: p_rule_id IN NUMBER,
2837: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2838: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2839: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2840: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2841: p_restrict_sql IN VARCHAR2,
2834:
2835: PROCEDURE find_persons (
2836: p_rule_id IN NUMBER,
2837: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2838: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2839: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2840: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2841: p_restrict_sql IN VARCHAR2,
2842: p_match_type IN VARCHAR2,
2835: PROCEDURE find_persons (
2836: p_rule_id IN NUMBER,
2837: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2838: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2839: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2840: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2841: p_restrict_sql IN VARCHAR2,
2842: p_match_type IN VARCHAR2,
2843: p_search_merged IN VARCHAR2,
2836: p_rule_id IN NUMBER,
2837: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2838: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2839: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2840: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2841: p_restrict_sql IN VARCHAR2,
2842: p_match_type IN VARCHAR2,
2843: p_search_merged IN VARCHAR2,
2844: p_dup_party_id IN NUMBER,
2872: l_TX44 VARCHAR2(2000);
2873: l_TX1 VARCHAR2(2000);
2874: l_TX5 VARCHAR2(2000);
2875: l_TX6 VARCHAR2(2000);
2876: H_SCORES HZ_PARTY_SEARCH.score_list;
2877: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
2878: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
2879:
2880: l_score NUMBER;
2873: l_TX1 VARCHAR2(2000);
2874: l_TX5 VARCHAR2(2000);
2875: l_TX6 VARCHAR2(2000);
2876: H_SCORES HZ_PARTY_SEARCH.score_list;
2877: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
2878: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
2879:
2880: l_score NUMBER;
2881: l_idx NUMBER;
2874: l_TX5 VARCHAR2(2000);
2875: l_TX6 VARCHAR2(2000);
2876: H_SCORES HZ_PARTY_SEARCH.score_list;
2877: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
2878: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
2879:
2880: l_score NUMBER;
2881: l_idx NUMBER;
2882: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
3113: /** Private procedure to acquire and score at party site level ***/
3114: 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
3115: l_party_id_idx NUMBER:=1;
3116: l_ctx_id NUMBER;
3117: h_ps_id HZ_PARTY_SEARCH.IDList;
3118: h_ps_party_id HZ_PARTY_SEARCH.IDList;
3119: h_ps_score HZ_PARTY_SEARCH.IDList;
3120: detcnt NUMBER := 1;
3121: l_person_id NUMBER;
3114: 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
3115: l_party_id_idx NUMBER:=1;
3116: l_ctx_id NUMBER;
3117: h_ps_id HZ_PARTY_SEARCH.IDList;
3118: h_ps_party_id HZ_PARTY_SEARCH.IDList;
3119: h_ps_score HZ_PARTY_SEARCH.IDList;
3120: detcnt NUMBER := 1;
3121: l_person_id NUMBER;
3122: BEGIN
3115: l_party_id_idx NUMBER:=1;
3116: l_ctx_id NUMBER;
3117: h_ps_id HZ_PARTY_SEARCH.IDList;
3118: h_ps_party_id HZ_PARTY_SEARCH.IDList;
3119: h_ps_score HZ_PARTY_SEARCH.IDList;
3120: detcnt NUMBER := 1;
3121: l_person_id NUMBER;
3122: BEGIN
3123: SAVEPOINT eval_start;
3212: /** Private procedure to acquire and score at party site level ***/
3213: PROCEDURE eval_contact_level(p_contact_contains_str VARCHAR2,p_ins_details VARCHAR2,p_emax_score NUMBER) IS
3214: l_party_id_idx NUMBER:=1;
3215: l_ctx_id NUMBER;
3216: h_ct_id HZ_PARTY_SEARCH.IDList;
3217: h_ct_party_id HZ_PARTY_SEARCH.IDList;
3218: h_ct_score HZ_PARTY_SEARCH.IDList;
3219: detcnt NUMBER := 1;
3220: l_person_id NUMBER;
3213: PROCEDURE eval_contact_level(p_contact_contains_str VARCHAR2,p_ins_details VARCHAR2,p_emax_score NUMBER) IS
3214: l_party_id_idx NUMBER:=1;
3215: l_ctx_id NUMBER;
3216: h_ct_id HZ_PARTY_SEARCH.IDList;
3217: h_ct_party_id HZ_PARTY_SEARCH.IDList;
3218: h_ct_score HZ_PARTY_SEARCH.IDList;
3219: detcnt NUMBER := 1;
3220: l_person_id NUMBER;
3221: BEGIN
3214: l_party_id_idx NUMBER:=1;
3215: l_ctx_id NUMBER;
3216: h_ct_id HZ_PARTY_SEARCH.IDList;
3217: h_ct_party_id HZ_PARTY_SEARCH.IDList;
3218: h_ct_score HZ_PARTY_SEARCH.IDList;
3219: detcnt NUMBER := 1;
3220: l_person_id NUMBER;
3221: BEGIN
3222: SAVEPOINT eval_start;
3270: /** Private procedure to acquire and score at contact point level ***/
3271: 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
3272: l_party_id_idx NUMBER:=1;
3273: l_ctx_id NUMBER;
3274: h_cpt_id HZ_PARTY_SEARCH.IDList;
3275: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
3276: h_cpt_score HZ_PARTY_SEARCH.IDList;
3277: detcnt NUMBER := 1;
3278: l_person_id NUMBER;
3271: 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
3272: l_party_id_idx NUMBER:=1;
3273: l_ctx_id NUMBER;
3274: h_cpt_id HZ_PARTY_SEARCH.IDList;
3275: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
3276: h_cpt_score HZ_PARTY_SEARCH.IDList;
3277: detcnt NUMBER := 1;
3278: l_person_id NUMBER;
3279: is_a_match VARCHAR2(1) := 'Y';
3272: l_party_id_idx NUMBER:=1;
3273: l_ctx_id NUMBER;
3274: h_cpt_id HZ_PARTY_SEARCH.IDList;
3275: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
3276: h_cpt_score HZ_PARTY_SEARCH.IDList;
3277: detcnt NUMBER := 1;
3278: l_person_id NUMBER;
3279: is_a_match VARCHAR2(1) := 'Y';
3280: l_cpt_flag VARCHAR2(1) := 'N';
3614: END find_persons;
3615:
3616: PROCEDURE find_persons (
3617: p_rule_id IN NUMBER,
3618: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
3619: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
3620: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
3621: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
3622: p_restrict_sql IN VARCHAR2,
3615:
3616: PROCEDURE find_persons (
3617: p_rule_id IN NUMBER,
3618: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
3619: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
3620: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
3621: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
3622: p_restrict_sql IN VARCHAR2,
3623: p_match_type IN VARCHAR2,
3616: PROCEDURE find_persons (
3617: p_rule_id IN NUMBER,
3618: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
3619: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
3620: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
3621: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
3622: p_restrict_sql IN VARCHAR2,
3623: p_match_type IN VARCHAR2,
3624: p_search_merged IN VARCHAR2,
3617: p_rule_id IN NUMBER,
3618: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
3619: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
3620: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
3621: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
3622: p_restrict_sql IN VARCHAR2,
3623: p_match_type IN VARCHAR2,
3624: p_search_merged IN VARCHAR2,
3625: p_ins_details IN VARCHAR2,
3631: 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);
3632: END;
3633: PROCEDURE find_party_details (
3634: p_rule_id IN NUMBER,
3635: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
3636: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
3637: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
3638: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
3639: p_restrict_sql IN VARCHAR2,
3632: END;
3633: PROCEDURE find_party_details (
3634: p_rule_id IN NUMBER,
3635: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
3636: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
3637: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
3638: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
3639: p_restrict_sql IN VARCHAR2,
3640: p_match_type IN VARCHAR2,
3633: PROCEDURE find_party_details (
3634: p_rule_id IN NUMBER,
3635: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
3636: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
3637: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
3638: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
3639: p_restrict_sql IN VARCHAR2,
3640: p_match_type IN VARCHAR2,
3641: p_search_merged IN VARCHAR2,
3634: p_rule_id IN NUMBER,
3635: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
3636: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
3637: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
3638: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
3639: p_restrict_sql IN VARCHAR2,
3640: p_match_type IN VARCHAR2,
3641: p_search_merged IN VARCHAR2,
3642: x_search_ctx_id OUT NUMBER,
3691: x_dup_set_id OUT NUMBER,
3692: x_search_ctx_id OUT NUMBER,
3693: x_num_matches OUT NUMBER
3694: ) IS
3695: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
3696: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3697: l_contact_list HZ_PARTY_SEARCH.contact_list;
3698: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
3699: l_match_idx NUMBER;
3692: x_search_ctx_id OUT NUMBER,
3693: x_num_matches OUT NUMBER
3694: ) IS
3695: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
3696: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3697: l_contact_list HZ_PARTY_SEARCH.contact_list;
3698: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
3699: l_match_idx NUMBER;
3700:
3693: x_num_matches OUT NUMBER
3694: ) IS
3695: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
3696: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3697: l_contact_list HZ_PARTY_SEARCH.contact_list;
3698: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
3699: l_match_idx NUMBER;
3700:
3701: --Fix for bug 4417124
3694: ) IS
3695: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
3696: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3697: l_contact_list HZ_PARTY_SEARCH.contact_list;
3698: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
3699: l_match_idx NUMBER;
3700:
3701: --Fix for bug 4417124
3702: l_use_contact_addr_info BOOLEAN := TRUE;
3807: x_search_ctx_id OUT NUMBER,
3808: x_num_matches OUT NUMBER
3809: ) IS
3810:
3811: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3812: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3813: l_contact_list HZ_PARTY_SEARCH.contact_list;
3814: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3815: contact_point_ids HZ_PARTY_SEARCH.IDList;
3808: x_num_matches OUT NUMBER
3809: ) IS
3810:
3811: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3812: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3813: l_contact_list HZ_PARTY_SEARCH.contact_list;
3814: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3815: contact_point_ids HZ_PARTY_SEARCH.IDList;
3816: p_party_site_list HZ_PARTY_SEARCH.IDList;
3809: ) IS
3810:
3811: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3812: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3813: l_contact_list HZ_PARTY_SEARCH.contact_list;
3814: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3815: contact_point_ids HZ_PARTY_SEARCH.IDList;
3816: p_party_site_list HZ_PARTY_SEARCH.IDList;
3817: p_contact_ids HZ_PARTY_SEARCH.IDList;
3810:
3811: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3812: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3813: l_contact_list HZ_PARTY_SEARCH.contact_list;
3814: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3815: contact_point_ids HZ_PARTY_SEARCH.IDList;
3816: p_party_site_list HZ_PARTY_SEARCH.IDList;
3817: p_contact_ids HZ_PARTY_SEARCH.IDList;
3818: l_match_idx NUMBER;
3811: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3812: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3813: l_contact_list HZ_PARTY_SEARCH.contact_list;
3814: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3815: contact_point_ids HZ_PARTY_SEARCH.IDList;
3816: p_party_site_list HZ_PARTY_SEARCH.IDList;
3817: p_contact_ids HZ_PARTY_SEARCH.IDList;
3818: l_match_idx NUMBER;
3819: cursor get_cpts_for_party_sites is select contact_point_id
3812: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3813: l_contact_list HZ_PARTY_SEARCH.contact_list;
3814: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3815: contact_point_ids HZ_PARTY_SEARCH.IDList;
3816: p_party_site_list HZ_PARTY_SEARCH.IDList;
3817: p_contact_ids HZ_PARTY_SEARCH.IDList;
3818: l_match_idx NUMBER;
3819: cursor get_cpts_for_party_sites is select contact_point_id
3820: from hz_contact_points
3813: l_contact_list HZ_PARTY_SEARCH.contact_list;
3814: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3815: contact_point_ids HZ_PARTY_SEARCH.IDList;
3816: p_party_site_list HZ_PARTY_SEARCH.IDList;
3817: p_contact_ids HZ_PARTY_SEARCH.IDList;
3818: l_match_idx NUMBER;
3819: cursor get_cpts_for_party_sites is select contact_point_id
3820: from hz_contact_points
3821: where owner_table_name = 'HZ_PARTY_SITES'
3842:
3843: get_search_criteria (
3844: null,
3845: p_party_site_list,
3846: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
3847: contact_point_ids,
3848: l_party_search_rec,
3849: l_party_site_list,
3850: l_contact_list,
3892: x_search_ctx_id OUT NUMBER,
3893: x_num_matches OUT NUMBER
3894: ) IS
3895:
3896: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3897: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3898: l_contact_list HZ_PARTY_SEARCH.contact_list;
3899: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3900: contact_point_ids HZ_PARTY_SEARCH.IDList;
3893: x_num_matches OUT NUMBER
3894: ) IS
3895:
3896: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3897: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3898: l_contact_list HZ_PARTY_SEARCH.contact_list;
3899: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3900: contact_point_ids HZ_PARTY_SEARCH.IDList;
3901: p_party_site_list HZ_PARTY_SEARCH.IDList;
3894: ) IS
3895:
3896: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3897: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3898: l_contact_list HZ_PARTY_SEARCH.contact_list;
3899: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3900: contact_point_ids HZ_PARTY_SEARCH.IDList;
3901: p_party_site_list HZ_PARTY_SEARCH.IDList;
3902: p_contact_ids HZ_PARTY_SEARCH.IDList;
3895:
3896: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3897: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3898: l_contact_list HZ_PARTY_SEARCH.contact_list;
3899: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3900: contact_point_ids HZ_PARTY_SEARCH.IDList;
3901: p_party_site_list HZ_PARTY_SEARCH.IDList;
3902: p_contact_ids HZ_PARTY_SEARCH.IDList;
3903: l_match_idx NUMBER;
3896: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3897: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3898: l_contact_list HZ_PARTY_SEARCH.contact_list;
3899: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3900: contact_point_ids HZ_PARTY_SEARCH.IDList;
3901: p_party_site_list HZ_PARTY_SEARCH.IDList;
3902: p_contact_ids HZ_PARTY_SEARCH.IDList;
3903: l_match_idx NUMBER;
3904: cursor get_cpt_for_contact_id is select contact_point_id
3897: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3898: l_contact_list HZ_PARTY_SEARCH.contact_list;
3899: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3900: contact_point_ids HZ_PARTY_SEARCH.IDList;
3901: p_party_site_list HZ_PARTY_SEARCH.IDList;
3902: p_contact_ids HZ_PARTY_SEARCH.IDList;
3903: l_match_idx NUMBER;
3904: cursor get_cpt_for_contact_id is select contact_point_id
3905: from hz_org_contacts a, hz_relationships b, hz_contact_points c
3898: l_contact_list HZ_PARTY_SEARCH.contact_list;
3899: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3900: contact_point_ids HZ_PARTY_SEARCH.IDList;
3901: p_party_site_list HZ_PARTY_SEARCH.IDList;
3902: p_contact_ids HZ_PARTY_SEARCH.IDList;
3903: l_match_idx NUMBER;
3904: cursor get_cpt_for_contact_id is select contact_point_id
3905: from hz_org_contacts a, hz_relationships b, hz_contact_points c
3906: where a.party_relationship_id = b.relationship_id
3929: CLOSE get_cpt_for_contact_id;
3930:
3931: get_search_criteria (
3932: null,
3933: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
3934: p_contact_ids,
3935: contact_point_ids,
3936: l_party_search_rec,
3937: l_party_site_list,
3980: p_match_type IN VARCHAR2,
3981: x_search_ctx_id OUT NUMBER,
3982: x_num_matches OUT NUMBER
3983: ) IS
3984: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3985: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3986: l_contact_list HZ_PARTY_SEARCH.contact_list;
3987: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3988: contact_point_ids HZ_PARTY_SEARCH.IDList;
3981: x_search_ctx_id OUT NUMBER,
3982: x_num_matches OUT NUMBER
3983: ) IS
3984: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3985: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3986: l_contact_list HZ_PARTY_SEARCH.contact_list;
3987: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3988: contact_point_ids HZ_PARTY_SEARCH.IDList;
3989: p_party_site_list HZ_PARTY_SEARCH.IDList;
3982: x_num_matches OUT NUMBER
3983: ) IS
3984: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3985: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3986: l_contact_list HZ_PARTY_SEARCH.contact_list;
3987: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3988: contact_point_ids HZ_PARTY_SEARCH.IDList;
3989: p_party_site_list HZ_PARTY_SEARCH.IDList;
3990: p_contact_ids HZ_PARTY_SEARCH.IDList;
3983: ) IS
3984: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3985: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3986: l_contact_list HZ_PARTY_SEARCH.contact_list;
3987: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3988: contact_point_ids HZ_PARTY_SEARCH.IDList;
3989: p_party_site_list HZ_PARTY_SEARCH.IDList;
3990: p_contact_ids HZ_PARTY_SEARCH.IDList;
3991: l_match_idx NUMBER;
3984: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
3985: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3986: l_contact_list HZ_PARTY_SEARCH.contact_list;
3987: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3988: contact_point_ids HZ_PARTY_SEARCH.IDList;
3989: p_party_site_list HZ_PARTY_SEARCH.IDList;
3990: p_contact_ids HZ_PARTY_SEARCH.IDList;
3991: l_match_idx NUMBER;
3992:
3985: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
3986: l_contact_list HZ_PARTY_SEARCH.contact_list;
3987: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3988: contact_point_ids HZ_PARTY_SEARCH.IDList;
3989: p_party_site_list HZ_PARTY_SEARCH.IDList;
3990: p_contact_ids HZ_PARTY_SEARCH.IDList;
3991: l_match_idx NUMBER;
3992:
3993: BEGIN
3986: l_contact_list HZ_PARTY_SEARCH.contact_list;
3987: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
3988: contact_point_ids HZ_PARTY_SEARCH.IDList;
3989: p_party_site_list HZ_PARTY_SEARCH.IDList;
3990: p_contact_ids HZ_PARTY_SEARCH.IDList;
3991: l_match_idx NUMBER;
3992:
3993: BEGIN
3994: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4003: END IF;
4004: contact_point_ids(1) := p_contact_point_id;
4005: get_search_criteria (
4006: null,
4007: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
4008: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
4009: contact_point_ids,
4010: l_party_search_rec,
4011: l_party_site_list,
4004: contact_point_ids(1) := p_contact_point_id;
4005: get_search_criteria (
4006: null,
4007: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
4008: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
4009: contact_point_ids,
4010: l_party_search_rec,
4011: l_party_site_list,
4012: l_contact_list,
4157: ) IS
4158: TYPE AttrList IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
4159: l_match_idx NUMBER;
4160: AttrVals AttrList;
4161: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
4162: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4163: l_contact_list HZ_PARTY_SEARCH.contact_list;
4164: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
4165: l_dup_set_id NUMBER;
4158: TYPE AttrList IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
4159: l_match_idx NUMBER;
4160: AttrVals AttrList;
4161: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
4162: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4163: l_contact_list HZ_PARTY_SEARCH.contact_list;
4164: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
4165: l_dup_set_id NUMBER;
4166: l_idx NUMBER;
4159: l_match_idx NUMBER;
4160: AttrVals AttrList;
4161: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
4162: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4163: l_contact_list HZ_PARTY_SEARCH.contact_list;
4164: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
4165: l_dup_set_id NUMBER;
4166: l_idx NUMBER;
4167: l_cpt_type VARCHAR2(255);
4160: AttrVals AttrList;
4161: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
4162: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4163: l_contact_list HZ_PARTY_SEARCH.contact_list;
4164: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
4165: l_dup_set_id NUMBER;
4166: l_idx NUMBER;
4167: l_cpt_type VARCHAR2(255);
4168: FIRST BOOLEAN := TRUE;
4342:
4343: PROCEDURE get_matching_party_sites (
4344: p_rule_id IN NUMBER,
4345: p_party_id IN NUMBER,
4346: p_party_site_list IN HZ_PARTY_SEARCH.PARTY_SITE_LIST,
4347: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
4348: p_restrict_sql IN VARCHAR2,
4349: p_match_type IN VARCHAR2,
4350: p_dup_party_site_id IN NUMBER,
4343: PROCEDURE get_matching_party_sites (
4344: p_rule_id IN NUMBER,
4345: p_party_id IN NUMBER,
4346: p_party_site_list IN HZ_PARTY_SEARCH.PARTY_SITE_LIST,
4347: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
4348: p_restrict_sql IN VARCHAR2,
4349: p_match_type IN VARCHAR2,
4350: p_dup_party_site_id IN NUMBER,
4351: x_search_ctx_id OUT NUMBER,
4371:
4372: l_TX1 VARCHAR2(2000);
4373: l_TX5 VARCHAR2(2000);
4374: l_TX6 VARCHAR2(2000);
4375: H_SCORES HZ_PARTY_SEARCH.score_list;
4376:
4377: l_score NUMBER;
4378: l_idx NUMBER;
4379: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4402: defps NUMBER :=0;
4403: defct NUMBER :=0;
4404: defcpt NUMBER :=0;
4405: l_index NUMBER;
4406: l_match_ps_list HZ_PARTY_SEARCH.IDList;
4407: l_cnt NUMBER:=1;
4408:
4409:
4410: BEGIN
4426: l_match_str := ' AND ';
4427: ELSIF p_match_type = 'OR' THEN
4428: l_match_str := ' OR ';
4429: END IF;
4430: 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);
4431: g_score_until_thresh := false;
4432: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4433:
4434: -- ************************************************************
4434: -- ************************************************************
4435: -- STEP 2. Setup of intermedia query strings for Acquisition query
4436: l_party_site_contains_str := INIT_PARTY_SITES_QUERY(l_match_str,l_tmp);
4437: l_contact_pt_contains_str := INIT_CONTACT_POINTS_QUERY(l_match_str,l_tmp);
4438: 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);
4439:
4440: -- Setup Search Context ID
4441: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;
4442: x_search_ctx_id := l_search_ctx_id;
4577:
4578: PROCEDURE get_matching_contacts (
4579: p_rule_id IN NUMBER,
4580: p_party_id IN NUMBER,
4581: p_contact_list IN HZ_PARTY_SEARCH.CONTACT_LIST,
4582: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
4583: p_restrict_sql IN VARCHAR2,
4584: p_match_type IN VARCHAR2,
4585: p_dup_contact_id IN NUMBER,
4578: PROCEDURE get_matching_contacts (
4579: p_rule_id IN NUMBER,
4580: p_party_id IN NUMBER,
4581: p_contact_list IN HZ_PARTY_SEARCH.CONTACT_LIST,
4582: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
4583: p_restrict_sql IN VARCHAR2,
4584: p_match_type IN VARCHAR2,
4585: p_dup_contact_id IN NUMBER,
4586: x_search_ctx_id OUT NUMBER,
4606:
4607: l_TX1 VARCHAR2(2000);
4608: l_TX5 VARCHAR2(2000);
4609: l_TX6 VARCHAR2(2000);
4610: H_SCORES HZ_PARTY_SEARCH.score_list;
4611:
4612: l_score NUMBER;
4613: l_idx NUMBER;
4614: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4634: l_party_max_score NUMBER;
4635: l_ps_max_score NUMBER;
4636: l_contact_max_score NUMBER;
4637: l_cpt_max_score NUMBER;
4638: l_match_contact_list HZ_PARTY_SEARCH.IDList;
4639: l_cnt NUMBER:=1;
4640:
4641:
4642: BEGIN
4658: l_match_str := ' AND ';
4659: ELSIF p_match_type = 'OR' THEN
4660: l_match_str := ' OR ';
4661: END IF;
4662: 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);
4663: g_score_until_thresh := false;
4664: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4665:
4666: -- ************************************************************
4666: -- ************************************************************
4667: -- STEP 2. Setup of intermedia query strings for Acquisition query
4668: l_contact_contains_str := INIT_CONTACTS_QUERY(l_match_str,l_tmp);
4669: l_contact_pt_contains_str := INIT_CONTACT_POINTS_QUERY(l_match_str,l_tmp);
4670: 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);
4671:
4672: -- Setup Search Context ID
4673: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;
4674: x_search_ctx_id := l_search_ctx_id;
4805:
4806: PROCEDURE get_matching_contact_points (
4807: p_rule_id IN NUMBER,
4808: p_party_id IN NUMBER,
4809: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
4810: p_restrict_sql IN VARCHAR2,
4811: p_match_type IN VARCHAR2,
4812: p_dup_contact_point_id IN NUMBER,
4813: x_search_ctx_id OUT NUMBER,
4837: l_cpt_ps_id NUMBER;
4838: l_cpt_contact_id NUMBER;
4839: l_contact_pt_id NUMBER;
4840: l_cpt_type VARCHAR2(100);
4841: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
4842: H_CONTACT_POINT_ID HZ_PARTY_SEARCH.IDList;
4843: H_SCORE HZ_PARTY_SEARCH.IDList;
4844:
4845: cnt NUMBER :=0;
4838: l_cpt_contact_id NUMBER;
4839: l_contact_pt_id NUMBER;
4840: l_cpt_type VARCHAR2(100);
4841: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
4842: H_CONTACT_POINT_ID HZ_PARTY_SEARCH.IDList;
4843: H_SCORE HZ_PARTY_SEARCH.IDList;
4844:
4845: cnt NUMBER :=0;
4846: l_party_max_score NUMBER;
4839: l_contact_pt_id NUMBER;
4840: l_cpt_type VARCHAR2(100);
4841: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
4842: H_CONTACT_POINT_ID HZ_PARTY_SEARCH.IDList;
4843: H_SCORE HZ_PARTY_SEARCH.IDList;
4844:
4845: cnt NUMBER :=0;
4846: l_party_max_score NUMBER;
4847: l_ps_max_score NUMBER;
4868: l_match_str := ' AND ';
4869: ELSIF p_match_type = 'OR' THEN
4870: l_match_str := ' OR ';
4871: END IF;
4872: l_entered_max_score:= init_search(HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
4873: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST, HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
4874: p_contact_point_list,l_match_str, l_party_max_score, l_ps_max_score, l_contact_max_score, l_cpt_max_score);
4875: g_score_until_thresh := false;
4876: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4869: ELSIF p_match_type = 'OR' THEN
4870: l_match_str := ' OR ';
4871: END IF;
4872: l_entered_max_score:= init_search(HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
4873: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST, HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
4874: p_contact_point_list,l_match_str, l_party_max_score, l_ps_max_score, l_contact_max_score, l_cpt_max_score);
4875: g_score_until_thresh := false;
4876: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
4877:
4877:
4878: -- ************************************************************
4879: -- STEP 2. Setup of intermedia query strings for Acquisition query
4880: l_contact_pt_contains_str := INIT_CONTACT_POINTS_QUERY(l_match_str,l_tmp);
4881: 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);
4882:
4883: -- Setup Search Context ID
4884: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;
4885: x_search_ctx_id := l_search_ctx_id;
4952:
4953: PROCEDURE get_score_details (
4954: p_rule_id IN NUMBER,
4955: p_party_id IN NUMBER,
4956: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
4957: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
4958: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
4959: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
4960: x_search_ctx_id IN OUT NUMBER
4953: PROCEDURE get_score_details (
4954: p_rule_id IN NUMBER,
4955: p_party_id IN NUMBER,
4956: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
4957: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
4958: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
4959: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
4960: x_search_ctx_id IN OUT NUMBER
4961: ) IS
4954: p_rule_id IN NUMBER,
4955: p_party_id IN NUMBER,
4956: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
4957: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
4958: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
4959: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
4960: x_search_ctx_id IN OUT NUMBER
4961: ) IS
4962:
4955: p_party_id IN NUMBER,
4956: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
4957: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
4958: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
4959: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
4960: x_search_ctx_id IN OUT NUMBER
4961: ) IS
4962:
4963: -- Strings to hold the generated Intermedia query strings
4982: l_TX5 VARCHAR2(2000);
4983: l_max_TX5 VARCHAR2(2000);
4984: l_TX6 VARCHAR2(2000);
4985: l_max_TX6 VARCHAR2(2000);
4986: H_SCORES HZ_PARTY_SEARCH.score_list;
4987:
4988: l_score NUMBER;
4989: l_match_idx NUMBER;
4990: l_idx NUMBER;
5150: ************************************************/
5151:
5152: PROCEDURE get_party_for_search (
5153: p_party_id IN NUMBER,
5154: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
5155: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
5156: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
5157: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5158: ) IS
5151:
5152: PROCEDURE get_party_for_search (
5153: p_party_id IN NUMBER,
5154: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
5155: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
5156: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
5157: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5158: ) IS
5159: l_party_id NUMBER;
5152: PROCEDURE get_party_for_search (
5153: p_party_id IN NUMBER,
5154: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
5155: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
5156: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
5157: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5158: ) IS
5159: l_party_id NUMBER;
5160: l_party_site_ids HZ_PARTY_SEARCH.IDList;
5153: p_party_id IN NUMBER,
5154: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
5155: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
5156: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
5157: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5158: ) IS
5159: l_party_id NUMBER;
5160: l_party_site_ids HZ_PARTY_SEARCH.IDList;
5161: l_contact_ids HZ_PARTY_SEARCH.IDList;
5156: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
5157: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5158: ) IS
5159: l_party_id NUMBER;
5160: l_party_site_ids HZ_PARTY_SEARCH.IDList;
5161: l_contact_ids HZ_PARTY_SEARCH.IDList;
5162: l_contact_pt_ids HZ_PARTY_SEARCH.IDList;
5163: ps NUMBER :=1;
5164: cpt NUMBER :=1;
5157: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5158: ) IS
5159: l_party_id NUMBER;
5160: l_party_site_ids HZ_PARTY_SEARCH.IDList;
5161: l_contact_ids HZ_PARTY_SEARCH.IDList;
5162: l_contact_pt_ids HZ_PARTY_SEARCH.IDList;
5163: ps NUMBER :=1;
5164: cpt NUMBER :=1;
5165: ct NUMBER :=1;
5158: ) IS
5159: l_party_id NUMBER;
5160: l_party_site_ids HZ_PARTY_SEARCH.IDList;
5161: l_contact_ids HZ_PARTY_SEARCH.IDList;
5162: l_contact_pt_ids HZ_PARTY_SEARCH.IDList;
5163: ps NUMBER :=1;
5164: cpt NUMBER :=1;
5165: ct NUMBER :=1;
5166: l_use_contact_info varchar2(1);
5219: END get_party_for_search;
5220:
5221: PROCEDURE get_search_criteria (
5222: p_party_id IN NUMBER,
5223: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
5224: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
5225: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
5226: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
5227: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
5220:
5221: PROCEDURE get_search_criteria (
5222: p_party_id IN NUMBER,
5223: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
5224: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
5225: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
5226: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
5227: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
5228: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
5221: PROCEDURE get_search_criteria (
5222: p_party_id IN NUMBER,
5223: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
5224: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
5225: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
5226: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
5227: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
5228: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
5229: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5222: p_party_id IN NUMBER,
5223: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
5224: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
5225: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
5226: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
5227: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
5228: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
5229: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5230: ) IS
5223: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
5224: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
5225: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
5226: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
5227: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
5228: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
5229: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5230: ) IS
5231: BEGIN
5224: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
5225: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
5226: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
5227: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
5228: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
5229: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5230: ) IS
5231: BEGIN
5232:
5225: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
5226: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
5227: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
5228: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
5229: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5230: ) IS
5231: BEGIN
5232:
5233: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5265: ************************************************/
5266:
5267: PROCEDURE get_party_rec (
5268: p_party_id IN NUMBER,
5269: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type
5270: ) IS
5271: l_party_type VARCHAR2(255);
5272: BEGIN
5273:
5324: the party site search record structure
5325: ************************************************/
5326:
5327: PROCEDURE get_party_site_rec (
5328: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
5329: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
5330: ) IS
5331: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5332: SELECT party_site_id
5325: ************************************************/
5326:
5327: PROCEDURE get_party_site_rec (
5328: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
5329: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
5330: ) IS
5331: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5332: SELECT party_site_id
5333: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5376: the contact search record structure
5377: ************************************************/
5378:
5379: PROCEDURE get_contact_rec (
5380: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
5381: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
5382: ) IS
5383: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
5384: SELECT org_contact_id
5377: ************************************************/
5378:
5379: PROCEDURE get_contact_rec (
5380: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
5381: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
5382: ) IS
5383: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
5384: SELECT org_contact_id
5385: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
5432: the contact point search record structure
5433: ************************************************/
5434:
5435: PROCEDURE get_contact_point_rec (
5436: p_contact_point_ids IN HZ_PARTY_SEARCH.IDList,
5437: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5438: ) IS
5439:
5440: -- Cursor to fetch primary contact points for party
5433: ************************************************/
5434:
5435: PROCEDURE get_contact_point_rec (
5436: p_contact_point_ids IN HZ_PARTY_SEARCH.IDList,
5437: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
5438: ) IS
5439:
5440: -- Cursor to fetch primary contact points for party
5441: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
5491: ************************************************/
5492:
5493: PROCEDURE MAP_PARTY_REC(
5494: p_search_ctx IN BOOLEAN,
5495: p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
5496: x_entered_max_score OUT NUMBER,
5497: x_stage_rec IN OUT NOCOPY HZ_PARTY_STAGE.party_stage_rec_type
5498: ) IS
5499: tmp VARCHAR2(4000);
5569: ************************************************/
5570:
5571: PROCEDURE MAP_PARTY_SITE_REC(
5572: p_search_ctx IN BOOLEAN,
5573: p_search_list IN HZ_PARTY_SEARCH.party_site_list,
5574: x_entered_max_score OUT NUMBER,
5575: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.party_site_stage_list
5576: ) IS
5577: l_current_max_score NUMBER;
5612: ************************************************/
5613:
5614: PROCEDURE MAP_CONTACT_REC(
5615: p_search_ctx IN BOOLEAN,
5616: p_search_list IN HZ_PARTY_SEARCH.contact_list,
5617: x_entered_max_score OUT NUMBER,
5618: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_stage_list
5619: ) IS
5620: l_current_max_score NUMBER;
5654: ************************************************/
5655:
5656: PROCEDURE MAP_CONTACT_POINT_REC(
5657: p_search_ctx IN BOOLEAN,
5658: p_search_list IN HZ_PARTY_SEARCH.contact_point_list,
5659: x_entered_max_score OUT NUMBER,
5660: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_pt_stage_list
5661: ) IS
5662: l_current_max_score NUMBER;
5760: 2. Contact Point Type is not null for each condition
5761: ************************************************/
5762:
5763: FUNCTION check_prim_cond(
5764: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
5765: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
5766: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
5767: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)
5768: RETURN BOOLEAN IS
5761: ************************************************/
5762:
5763: FUNCTION check_prim_cond(
5764: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
5765: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
5766: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
5767: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)
5768: RETURN BOOLEAN IS
5769: BEGIN
5762:
5763: FUNCTION check_prim_cond(
5764: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
5765: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
5766: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
5767: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)
5768: RETURN BOOLEAN IS
5769: BEGIN
5770: FOR I IN 1..p_contact_point_list.COUNT LOOP
5763: FUNCTION check_prim_cond(
5764: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
5765: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
5766: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
5767: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)
5768: RETURN BOOLEAN IS
5769: BEGIN
5770: FOR I IN 1..p_contact_point_list.COUNT LOOP
5771: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
5808: has party site criteria.
5809: ************************************************/
5810:
5811: PROCEDURE check_party_site_cond(
5812: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
5813: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
5814: x_secondary OUT BOOLEAN,
5815: x_primary OUT BOOLEAN
5816: ) IS
5809: ************************************************/
5810:
5811: PROCEDURE check_party_site_cond(
5812: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
5813: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
5814: x_secondary OUT BOOLEAN,
5815: x_primary OUT BOOLEAN
5816: ) IS
5817: BEGIN
5854: has contact criteria.
5855: ************************************************/
5856:
5857: PROCEDURE check_contact_cond(
5858: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
5859: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
5860: x_secondary OUT BOOLEAN,
5861: x_primary OUT BOOLEAN
5862: ) IS
5855: ************************************************/
5856:
5857: PROCEDURE check_contact_cond(
5858: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
5859: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
5860: x_secondary OUT BOOLEAN,
5861: x_primary OUT BOOLEAN
5862: ) IS
5863: BEGIN
5902: has valid contact point criteria.
5903: ************************************************/
5904:
5905: PROCEDURE check_contact_point_cond(
5906: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
5907: x_secondary OUT BOOLEAN,
5908: x_primary OUT BOOLEAN
5909: ) IS
5910: BEGIN