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;
576: PROCEDURE INSERT_PARTY_SCORE (
577: p_party_id IN NUMBER
578: ,p_record_id IN NUMBER
579: ,p_search_ctx_id IN NUMBER
580: ,p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type
581: ,p_stage_rec IN HZ_PARTY_STAGE.party_stage_rec_type
582: ,p_table_TX34 VARCHAR2
583: ,p_table_TX35 VARCHAR2
584: ,p_table_TX39 VARCHAR2
729: PROCEDURE INSERT_PARTY_SITES_SCORE (
730: p_party_id IN NUMBER
731: ,p_record_id IN NUMBER
732: ,p_search_ctx_id IN NUMBER
733: ,p_search_rec IN HZ_PARTY_SEARCH.party_site_search_rec_type
734: ,p_stage_rec IN HZ_PARTY_STAGE.party_site_stage_rec_type
735: ,p_table_TX3 VARCHAR2
736: ,p_table_TX4 VARCHAR2
737: ,p_table_TX9 VARCHAR2
929: PROCEDURE INSERT_CONTACTS_SCORE (
930: p_party_id IN NUMBER
931: ,p_record_id IN NUMBER
932: ,p_search_ctx_id IN NUMBER
933: ,p_search_rec IN HZ_PARTY_SEARCH.contact_search_rec_type
934: ,p_stage_rec IN HZ_PARTY_STAGE.contact_stage_rec_type
935: ,p_idx IN NUMBER) IS
936: l_current_score NUMBER:=0;
937: l_score NUMBER;
945: PROCEDURE INSERT_CONTACT_POINTS_SCORE (
946: p_party_id IN NUMBER
947: ,p_record_id IN NUMBER
948: ,p_search_ctx_id IN NUMBER
949: ,p_search_rec IN HZ_PARTY_SEARCH.contact_point_search_rec_type
950: ,p_stage_rec IN HZ_PARTY_STAGE.contact_pt_stage_rec_type
951: ,p_table_TX1 VARCHAR2
952: ,p_table_TX8 VARCHAR2
953: ,p_table_TX7 VARCHAR2
1023: for the PARTY Entity
1024: ************************************************/
1025:
1026: PROCEDURE POP_PARTY_COND_REC(
1027: p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type
1028: ) IS
1029: BEGIN
1030: NULL ;
1031: EXCEPTION
1043: for the PARTY_SITES Entity
1044: ************************************************/
1045:
1046: PROCEDURE POP_PARTY_SITES_COND_REC(
1047: p_search_list IN HZ_PARTY_SEARCH.party_site_list
1048: ) IS
1049: BEGIN
1050: ---------POPULATE THE GLOBAL WORD CONDITION REC FOR PARTY_SITES-------------
1051: ------ Populate global condition record only if search list is not empty -----------
1068: for the CONTACTS Entity
1069: ************************************************/
1070:
1071: PROCEDURE POP_CONTACTS_COND_REC(
1072: p_search_list IN HZ_PARTY_SEARCH.contact_list
1073: ) IS
1074: BEGIN
1075: NULL ;
1076: EXCEPTION
1088: for the CONTACT_POINTS Entity
1089: ************************************************/
1090:
1091: PROCEDURE POP_CONTACT_POINTS_COND_REC(
1092: p_search_list IN HZ_PARTY_SEARCH.contact_point_list
1093: ) IS
1094: BEGIN
1095: NULL ;
1096: EXCEPTION
1102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1103: END;
1104:
1105: PROCEDURE init_score_context (
1106: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
1107: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
1108: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1109: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1110: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1103: END;
1104:
1105: PROCEDURE init_score_context (
1106: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
1107: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
1108: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1109: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1110: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1111: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1104:
1105: PROCEDURE init_score_context (
1106: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
1107: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
1108: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1109: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1110: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1111: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1112: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
1105: PROCEDURE init_score_context (
1106: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
1107: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
1108: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1109: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1110: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1111: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1112: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
1113: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST
1106: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
1107: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
1108: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1109: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1110: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1111: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1112: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
1113: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST
1114: ) IS
1107: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
1108: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1109: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1110: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1111: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1112: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
1113: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST
1114: ) IS
1115: l_dummy NUMBER;
1108: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1109: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1110: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1111: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1112: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
1113: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST
1114: ) IS
1115: l_dummy NUMBER;
1116: BEGIN
1109: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1110: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1111: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1112: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
1113: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST
1114: ) IS
1115: l_dummy NUMBER;
1116: BEGIN
1117: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1129: MAP_CONTACT_POINT_REC(FALSE,p_contact_point_list, l_dummy, g_contact_pt_stage_list);
1130:
1131: END;
1132: FUNCTION init_search(
1133: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
1134: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
1135: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1136: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1137: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1130:
1131: END;
1132: FUNCTION init_search(
1133: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
1134: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
1135: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1136: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1137: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1138: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1131: END;
1132: FUNCTION init_search(
1133: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
1134: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
1135: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1136: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1137: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1138: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1139: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
1132: FUNCTION init_search(
1133: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
1134: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
1135: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1136: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1137: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1138: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1139: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
1140: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST,
1133: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
1134: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
1135: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1136: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1137: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1138: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1139: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
1140: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST,
1141: p_match_type IN VARCHAR2,
1134: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
1135: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1136: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1137: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1138: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1139: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
1140: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST,
1141: p_match_type IN VARCHAR2,
1142: x_party_max_score OUT NUMBER,
1135: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1136: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1137: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1138: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1139: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
1140: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST,
1141: p_match_type IN VARCHAR2,
1142: x_party_max_score OUT NUMBER,
1143: x_ps_max_score OUT NUMBER,
1136: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1137: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1138: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1139: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
1140: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST,
1141: p_match_type IN VARCHAR2,
1142: x_party_max_score OUT NUMBER,
1143: x_ps_max_score OUT NUMBER,
1144: x_contact_max_score OUT NUMBER,
1148: l_ps_entered_max_score NUMBER:=0;
1149: l_ct_entered_max_score NUMBER:=0;
1150: l_cpt_entered_max_score NUMBER:=0;
1151: vlist vlisttype;
1152: maxscore HZ_PARTY_SEARCH.IDList;
1153: l_name VARCHAR2(200);
1154: l_idx NUMBER;
1155: l_num NUMBER;
1156: total NUMBER;
2667: p_party_id NUMBER,
2668: p_party_site_id NUMBER,
2669: p_org_contact_id NUMBER,
2670: p_contact_point_id NUMBER)
2671: RETURN HZ_PARTY_SEARCH.score_rec IS
2672: l_score_rec HZ_PARTY_SEARCH.score_rec;
2673: BEGIN
2674: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2675: 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);
2668: p_party_site_id NUMBER,
2669: p_org_contact_id NUMBER,
2670: p_contact_point_id NUMBER)
2671: RETURN HZ_PARTY_SEARCH.score_rec IS
2672: l_score_rec HZ_PARTY_SEARCH.score_rec;
2673: BEGIN
2674: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2675: 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);
2676: 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);
2700: **********************************************************/
2701:
2702: PROCEDURE find_parties (
2703: p_rule_id IN NUMBER,
2704: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2705: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2706: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2707: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2708: p_restrict_sql IN VARCHAR2,
2701:
2702: PROCEDURE find_parties (
2703: p_rule_id IN NUMBER,
2704: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2705: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2706: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2707: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2708: p_restrict_sql IN VARCHAR2,
2709: p_match_type IN VARCHAR2,
2702: PROCEDURE find_parties (
2703: p_rule_id IN NUMBER,
2704: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2705: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2706: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2707: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2708: p_restrict_sql IN VARCHAR2,
2709: p_match_type IN VARCHAR2,
2710: p_search_merged IN VARCHAR2,
2703: p_rule_id IN NUMBER,
2704: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2705: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2706: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2707: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2708: p_restrict_sql IN VARCHAR2,
2709: p_match_type IN VARCHAR2,
2710: p_search_merged IN VARCHAR2,
2711: p_dup_party_id IN NUMBER,
2754: l_TX45 VARCHAR2(2000);
2755: l_TX8 VARCHAR2(2000);
2756: l_TX14 VARCHAR2(2000);
2757: l_TX7 VARCHAR2(2000);
2758: H_SCORES HZ_PARTY_SEARCH.score_list;
2759: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
2760: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
2761:
2762: l_score NUMBER;
2755: l_TX8 VARCHAR2(2000);
2756: l_TX14 VARCHAR2(2000);
2757: l_TX7 VARCHAR2(2000);
2758: H_SCORES HZ_PARTY_SEARCH.score_list;
2759: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
2760: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
2761:
2762: l_score NUMBER;
2763: l_idx NUMBER;
2756: l_TX14 VARCHAR2(2000);
2757: l_TX7 VARCHAR2(2000);
2758: H_SCORES HZ_PARTY_SEARCH.score_list;
2759: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
2760: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
2761:
2762: l_score NUMBER;
2763: l_idx NUMBER;
2764: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
2947: /** Private procedure to acquire and score at party site level ***/
2948: 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
2949: l_party_id_idx NUMBER:=1;
2950: l_ctx_id NUMBER;
2951: h_ps_id HZ_PARTY_SEARCH.IDList;
2952: h_ps_party_id HZ_PARTY_SEARCH.IDList;
2953: h_ps_score HZ_PARTY_SEARCH.IDList;
2954: detcnt NUMBER := 1;
2955: BEGIN
2948: 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
2949: l_party_id_idx NUMBER:=1;
2950: l_ctx_id NUMBER;
2951: h_ps_id HZ_PARTY_SEARCH.IDList;
2952: h_ps_party_id HZ_PARTY_SEARCH.IDList;
2953: h_ps_score HZ_PARTY_SEARCH.IDList;
2954: detcnt NUMBER := 1;
2955: BEGIN
2956: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2949: l_party_id_idx NUMBER:=1;
2950: l_ctx_id NUMBER;
2951: h_ps_id HZ_PARTY_SEARCH.IDList;
2952: h_ps_party_id HZ_PARTY_SEARCH.IDList;
2953: h_ps_score HZ_PARTY_SEARCH.IDList;
2954: detcnt NUMBER := 1;
2955: BEGIN
2956: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2957: 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);
3069: /** Private procedure to acquire and score at contact point level ***/
3070: 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
3071: l_party_id_idx NUMBER:=1;
3072: l_ctx_id NUMBER;
3073: h_ct_id HZ_PARTY_SEARCH.IDList;
3074: h_ct_party_id HZ_PARTY_SEARCH.IDList;
3075: h_ct_score HZ_PARTY_SEARCH.IDList;
3076: detcnt NUMBER := 1;
3077: BEGIN
3070: 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
3071: l_party_id_idx NUMBER:=1;
3072: l_ctx_id NUMBER;
3073: h_ct_id HZ_PARTY_SEARCH.IDList;
3074: h_ct_party_id HZ_PARTY_SEARCH.IDList;
3075: h_ct_score HZ_PARTY_SEARCH.IDList;
3076: detcnt NUMBER := 1;
3077: BEGIN
3078: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3071: l_party_id_idx NUMBER:=1;
3072: l_ctx_id NUMBER;
3073: h_ct_id HZ_PARTY_SEARCH.IDList;
3074: h_ct_party_id HZ_PARTY_SEARCH.IDList;
3075: h_ct_score HZ_PARTY_SEARCH.IDList;
3076: detcnt NUMBER := 1;
3077: BEGIN
3078: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3079: 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);
3178: /** Private procedure to acquire and score at contact point level ***/
3179: 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
3180: l_party_id_idx NUMBER:=1;
3181: l_ctx_id NUMBER;
3182: h_cpt_id HZ_PARTY_SEARCH.IDList;
3183: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
3184: h_cpt_score HZ_PARTY_SEARCH.IDList;
3185: detcnt NUMBER := 1;
3186: l_cpt_flag VARCHAR2(1) := 'N';
3179: 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
3180: l_party_id_idx NUMBER:=1;
3181: l_ctx_id NUMBER;
3182: h_cpt_id HZ_PARTY_SEARCH.IDList;
3183: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
3184: h_cpt_score HZ_PARTY_SEARCH.IDList;
3185: detcnt NUMBER := 1;
3186: l_cpt_flag VARCHAR2(1) := 'N';
3187: is_a_match VARCHAR2(1) := 'Y';
3180: l_party_id_idx NUMBER:=1;
3181: l_ctx_id NUMBER;
3182: h_cpt_id HZ_PARTY_SEARCH.IDList;
3183: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
3184: h_cpt_score HZ_PARTY_SEARCH.IDList;
3185: detcnt NUMBER := 1;
3186: l_cpt_flag VARCHAR2(1) := 'N';
3187: is_a_match VARCHAR2(1) := 'Y';
3188: BEGIN
3667: END find_parties;
3668:
3669: PROCEDURE find_persons (
3670: p_rule_id IN NUMBER,
3671: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
3672: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
3673: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
3674: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
3675: p_restrict_sql IN VARCHAR2,
3668:
3669: PROCEDURE find_persons (
3670: p_rule_id IN NUMBER,
3671: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
3672: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
3673: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
3674: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
3675: p_restrict_sql IN VARCHAR2,
3676: p_match_type IN VARCHAR2,
3669: PROCEDURE find_persons (
3670: p_rule_id IN NUMBER,
3671: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
3672: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
3673: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
3674: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
3675: p_restrict_sql IN VARCHAR2,
3676: p_match_type IN VARCHAR2,
3677: p_search_merged IN VARCHAR2,
3670: p_rule_id IN NUMBER,
3671: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
3672: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
3673: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
3674: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
3675: p_restrict_sql IN VARCHAR2,
3676: p_match_type IN VARCHAR2,
3677: p_search_merged IN VARCHAR2,
3678: p_dup_party_id IN NUMBER,
3721: l_TX45 VARCHAR2(2000);
3722: l_TX8 VARCHAR2(2000);
3723: l_TX14 VARCHAR2(2000);
3724: l_TX7 VARCHAR2(2000);
3725: H_SCORES HZ_PARTY_SEARCH.score_list;
3726: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
3727: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
3728:
3729: l_score NUMBER;
3722: l_TX8 VARCHAR2(2000);
3723: l_TX14 VARCHAR2(2000);
3724: l_TX7 VARCHAR2(2000);
3725: H_SCORES HZ_PARTY_SEARCH.score_list;
3726: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
3727: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
3728:
3729: l_score NUMBER;
3730: l_idx NUMBER;
3723: l_TX14 VARCHAR2(2000);
3724: l_TX7 VARCHAR2(2000);
3725: H_SCORES HZ_PARTY_SEARCH.score_list;
3726: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
3727: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
3728:
3729: l_score NUMBER;
3730: l_idx NUMBER;
3731: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
3962: /** Private procedure to acquire and score at party site level ***/
3963: 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
3964: l_party_id_idx NUMBER:=1;
3965: l_ctx_id NUMBER;
3966: h_ps_id HZ_PARTY_SEARCH.IDList;
3967: h_ps_party_id HZ_PARTY_SEARCH.IDList;
3968: h_ps_score HZ_PARTY_SEARCH.IDList;
3969: detcnt NUMBER := 1;
3970: l_person_id NUMBER;
3963: 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
3964: l_party_id_idx NUMBER:=1;
3965: l_ctx_id NUMBER;
3966: h_ps_id HZ_PARTY_SEARCH.IDList;
3967: h_ps_party_id HZ_PARTY_SEARCH.IDList;
3968: h_ps_score HZ_PARTY_SEARCH.IDList;
3969: detcnt NUMBER := 1;
3970: l_person_id NUMBER;
3971: BEGIN
3964: l_party_id_idx NUMBER:=1;
3965: l_ctx_id NUMBER;
3966: h_ps_id HZ_PARTY_SEARCH.IDList;
3967: h_ps_party_id HZ_PARTY_SEARCH.IDList;
3968: h_ps_score HZ_PARTY_SEARCH.IDList;
3969: detcnt NUMBER := 1;
3970: l_person_id NUMBER;
3971: BEGIN
3972: SAVEPOINT eval_start;
4061: /** Private procedure to acquire and score at party site level ***/
4062: PROCEDURE eval_contact_level(p_contact_contains_str VARCHAR2,p_ins_details VARCHAR2,p_emax_score NUMBER) IS
4063: l_party_id_idx NUMBER:=1;
4064: l_ctx_id NUMBER;
4065: h_ct_id HZ_PARTY_SEARCH.IDList;
4066: h_ct_party_id HZ_PARTY_SEARCH.IDList;
4067: h_ct_score HZ_PARTY_SEARCH.IDList;
4068: detcnt NUMBER := 1;
4069: l_person_id NUMBER;
4062: PROCEDURE eval_contact_level(p_contact_contains_str VARCHAR2,p_ins_details VARCHAR2,p_emax_score NUMBER) IS
4063: l_party_id_idx NUMBER:=1;
4064: l_ctx_id NUMBER;
4065: h_ct_id HZ_PARTY_SEARCH.IDList;
4066: h_ct_party_id HZ_PARTY_SEARCH.IDList;
4067: h_ct_score HZ_PARTY_SEARCH.IDList;
4068: detcnt NUMBER := 1;
4069: l_person_id NUMBER;
4070: BEGIN
4063: l_party_id_idx NUMBER:=1;
4064: l_ctx_id NUMBER;
4065: h_ct_id HZ_PARTY_SEARCH.IDList;
4066: h_ct_party_id HZ_PARTY_SEARCH.IDList;
4067: h_ct_score HZ_PARTY_SEARCH.IDList;
4068: detcnt NUMBER := 1;
4069: l_person_id NUMBER;
4070: BEGIN
4071: SAVEPOINT eval_start;
4119: /** Private procedure to acquire and score at contact point level ***/
4120: 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
4121: l_party_id_idx NUMBER:=1;
4122: l_ctx_id NUMBER;
4123: h_cpt_id HZ_PARTY_SEARCH.IDList;
4124: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
4125: h_cpt_score HZ_PARTY_SEARCH.IDList;
4126: detcnt NUMBER := 1;
4127: l_person_id NUMBER;
4120: 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
4121: l_party_id_idx NUMBER:=1;
4122: l_ctx_id NUMBER;
4123: h_cpt_id HZ_PARTY_SEARCH.IDList;
4124: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
4125: h_cpt_score HZ_PARTY_SEARCH.IDList;
4126: detcnt NUMBER := 1;
4127: l_person_id NUMBER;
4128: is_a_match VARCHAR2(1) := 'Y';
4121: l_party_id_idx NUMBER:=1;
4122: l_ctx_id NUMBER;
4123: h_cpt_id HZ_PARTY_SEARCH.IDList;
4124: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
4125: h_cpt_score HZ_PARTY_SEARCH.IDList;
4126: detcnt NUMBER := 1;
4127: l_person_id NUMBER;
4128: is_a_match VARCHAR2(1) := 'Y';
4129: l_cpt_flag VARCHAR2(1) := 'N';
4532: END find_persons;
4533:
4534: PROCEDURE find_persons (
4535: p_rule_id IN NUMBER,
4536: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
4537: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
4538: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
4539: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
4540: p_restrict_sql IN VARCHAR2,
4533:
4534: PROCEDURE find_persons (
4535: p_rule_id IN NUMBER,
4536: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
4537: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
4538: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
4539: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
4540: p_restrict_sql IN VARCHAR2,
4541: p_match_type IN VARCHAR2,
4534: PROCEDURE find_persons (
4535: p_rule_id IN NUMBER,
4536: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
4537: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
4538: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
4539: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
4540: p_restrict_sql IN VARCHAR2,
4541: p_match_type IN VARCHAR2,
4542: p_search_merged IN VARCHAR2,
4535: p_rule_id IN NUMBER,
4536: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
4537: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
4538: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
4539: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
4540: p_restrict_sql IN VARCHAR2,
4541: p_match_type IN VARCHAR2,
4542: p_search_merged IN VARCHAR2,
4543: p_ins_details IN VARCHAR2,
4549: 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);
4550: END;
4551: PROCEDURE find_party_details (
4552: p_rule_id IN NUMBER,
4553: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
4554: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
4555: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
4556: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
4557: p_restrict_sql IN VARCHAR2,
4550: END;
4551: PROCEDURE find_party_details (
4552: p_rule_id IN NUMBER,
4553: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
4554: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
4555: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
4556: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
4557: p_restrict_sql IN VARCHAR2,
4558: p_match_type IN VARCHAR2,
4551: PROCEDURE find_party_details (
4552: p_rule_id IN NUMBER,
4553: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
4554: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
4555: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
4556: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
4557: p_restrict_sql IN VARCHAR2,
4558: p_match_type IN VARCHAR2,
4559: p_search_merged IN VARCHAR2,
4552: p_rule_id IN NUMBER,
4553: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
4554: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
4555: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
4556: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
4557: p_restrict_sql IN VARCHAR2,
4558: p_match_type IN VARCHAR2,
4559: p_search_merged IN VARCHAR2,
4560: x_search_ctx_id OUT NUMBER,
4609: x_dup_set_id OUT NUMBER,
4610: x_search_ctx_id OUT NUMBER,
4611: x_num_matches OUT NUMBER
4612: ) IS
4613: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
4614: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4615: l_contact_list HZ_PARTY_SEARCH.contact_list;
4616: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
4617: l_match_idx NUMBER;
4610: x_search_ctx_id OUT NUMBER,
4611: x_num_matches OUT NUMBER
4612: ) IS
4613: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
4614: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4615: l_contact_list HZ_PARTY_SEARCH.contact_list;
4616: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
4617: l_match_idx NUMBER;
4618:
4611: x_num_matches OUT NUMBER
4612: ) IS
4613: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
4614: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4615: l_contact_list HZ_PARTY_SEARCH.contact_list;
4616: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
4617: l_match_idx NUMBER;
4618:
4619: --Fix for bug 4417124
4612: ) IS
4613: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
4614: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4615: l_contact_list HZ_PARTY_SEARCH.contact_list;
4616: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
4617: l_match_idx NUMBER;
4618:
4619: --Fix for bug 4417124
4620: l_use_contact_addr_info BOOLEAN := TRUE;
4725: x_search_ctx_id OUT NUMBER,
4726: x_num_matches OUT NUMBER
4727: ) IS
4728:
4729: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
4730: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4731: l_contact_list HZ_PARTY_SEARCH.contact_list;
4732: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4733: contact_point_ids HZ_PARTY_SEARCH.IDList;
4726: x_num_matches OUT NUMBER
4727: ) IS
4728:
4729: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
4730: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4731: l_contact_list HZ_PARTY_SEARCH.contact_list;
4732: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4733: contact_point_ids HZ_PARTY_SEARCH.IDList;
4734: p_party_site_list HZ_PARTY_SEARCH.IDList;
4727: ) IS
4728:
4729: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
4730: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4731: l_contact_list HZ_PARTY_SEARCH.contact_list;
4732: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4733: contact_point_ids HZ_PARTY_SEARCH.IDList;
4734: p_party_site_list HZ_PARTY_SEARCH.IDList;
4735: p_contact_ids HZ_PARTY_SEARCH.IDList;
4728:
4729: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
4730: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4731: l_contact_list HZ_PARTY_SEARCH.contact_list;
4732: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4733: contact_point_ids HZ_PARTY_SEARCH.IDList;
4734: p_party_site_list HZ_PARTY_SEARCH.IDList;
4735: p_contact_ids HZ_PARTY_SEARCH.IDList;
4736: l_match_idx NUMBER;
4729: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
4730: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4731: l_contact_list HZ_PARTY_SEARCH.contact_list;
4732: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4733: contact_point_ids HZ_PARTY_SEARCH.IDList;
4734: p_party_site_list HZ_PARTY_SEARCH.IDList;
4735: p_contact_ids HZ_PARTY_SEARCH.IDList;
4736: l_match_idx NUMBER;
4737: cursor get_cpts_for_party_sites is select contact_point_id
4730: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4731: l_contact_list HZ_PARTY_SEARCH.contact_list;
4732: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4733: contact_point_ids HZ_PARTY_SEARCH.IDList;
4734: p_party_site_list HZ_PARTY_SEARCH.IDList;
4735: p_contact_ids HZ_PARTY_SEARCH.IDList;
4736: l_match_idx NUMBER;
4737: cursor get_cpts_for_party_sites is select contact_point_id
4738: from hz_contact_points
4731: l_contact_list HZ_PARTY_SEARCH.contact_list;
4732: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4733: contact_point_ids HZ_PARTY_SEARCH.IDList;
4734: p_party_site_list HZ_PARTY_SEARCH.IDList;
4735: p_contact_ids HZ_PARTY_SEARCH.IDList;
4736: l_match_idx NUMBER;
4737: cursor get_cpts_for_party_sites is select contact_point_id
4738: from hz_contact_points
4739: where owner_table_name = 'HZ_PARTY_SITES'
4760:
4761: get_search_criteria (
4762: null,
4763: p_party_site_list,
4764: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
4765: contact_point_ids,
4766: l_party_search_rec,
4767: l_party_site_list,
4768: l_contact_list,
4810: x_search_ctx_id OUT NUMBER,
4811: x_num_matches OUT NUMBER
4812: ) IS
4813:
4814: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
4815: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4816: l_contact_list HZ_PARTY_SEARCH.contact_list;
4817: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4818: contact_point_ids HZ_PARTY_SEARCH.IDList;
4811: x_num_matches OUT NUMBER
4812: ) IS
4813:
4814: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
4815: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4816: l_contact_list HZ_PARTY_SEARCH.contact_list;
4817: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4818: contact_point_ids HZ_PARTY_SEARCH.IDList;
4819: p_party_site_list HZ_PARTY_SEARCH.IDList;
4812: ) IS
4813:
4814: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
4815: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4816: l_contact_list HZ_PARTY_SEARCH.contact_list;
4817: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4818: contact_point_ids HZ_PARTY_SEARCH.IDList;
4819: p_party_site_list HZ_PARTY_SEARCH.IDList;
4820: p_contact_ids HZ_PARTY_SEARCH.IDList;
4813:
4814: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
4815: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4816: l_contact_list HZ_PARTY_SEARCH.contact_list;
4817: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4818: contact_point_ids HZ_PARTY_SEARCH.IDList;
4819: p_party_site_list HZ_PARTY_SEARCH.IDList;
4820: p_contact_ids HZ_PARTY_SEARCH.IDList;
4821: l_match_idx NUMBER;
4814: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
4815: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4816: l_contact_list HZ_PARTY_SEARCH.contact_list;
4817: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4818: contact_point_ids HZ_PARTY_SEARCH.IDList;
4819: p_party_site_list HZ_PARTY_SEARCH.IDList;
4820: p_contact_ids HZ_PARTY_SEARCH.IDList;
4821: l_match_idx NUMBER;
4822: cursor get_cpt_for_contact_id is select contact_point_id
4815: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4816: l_contact_list HZ_PARTY_SEARCH.contact_list;
4817: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4818: contact_point_ids HZ_PARTY_SEARCH.IDList;
4819: p_party_site_list HZ_PARTY_SEARCH.IDList;
4820: p_contact_ids HZ_PARTY_SEARCH.IDList;
4821: l_match_idx NUMBER;
4822: cursor get_cpt_for_contact_id is select contact_point_id
4823: from hz_org_contacts a, hz_relationships b, hz_contact_points c
4816: l_contact_list HZ_PARTY_SEARCH.contact_list;
4817: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4818: contact_point_ids HZ_PARTY_SEARCH.IDList;
4819: p_party_site_list HZ_PARTY_SEARCH.IDList;
4820: p_contact_ids HZ_PARTY_SEARCH.IDList;
4821: l_match_idx NUMBER;
4822: cursor get_cpt_for_contact_id is select contact_point_id
4823: from hz_org_contacts a, hz_relationships b, hz_contact_points c
4824: where a.party_relationship_id = b.relationship_id
4847: CLOSE get_cpt_for_contact_id;
4848:
4849: get_search_criteria (
4850: null,
4851: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
4852: p_contact_ids,
4853: contact_point_ids,
4854: l_party_search_rec,
4855: l_party_site_list,
4898: p_match_type IN VARCHAR2,
4899: x_search_ctx_id OUT NUMBER,
4900: x_num_matches OUT NUMBER
4901: ) IS
4902: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
4903: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4904: l_contact_list HZ_PARTY_SEARCH.contact_list;
4905: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4906: contact_point_ids HZ_PARTY_SEARCH.IDList;
4899: x_search_ctx_id OUT NUMBER,
4900: x_num_matches OUT NUMBER
4901: ) IS
4902: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
4903: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4904: l_contact_list HZ_PARTY_SEARCH.contact_list;
4905: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4906: contact_point_ids HZ_PARTY_SEARCH.IDList;
4907: p_party_site_list HZ_PARTY_SEARCH.IDList;
4900: x_num_matches OUT NUMBER
4901: ) IS
4902: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
4903: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4904: l_contact_list HZ_PARTY_SEARCH.contact_list;
4905: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4906: contact_point_ids HZ_PARTY_SEARCH.IDList;
4907: p_party_site_list HZ_PARTY_SEARCH.IDList;
4908: p_contact_ids HZ_PARTY_SEARCH.IDList;
4901: ) IS
4902: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
4903: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4904: l_contact_list HZ_PARTY_SEARCH.contact_list;
4905: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4906: contact_point_ids HZ_PARTY_SEARCH.IDList;
4907: p_party_site_list HZ_PARTY_SEARCH.IDList;
4908: p_contact_ids HZ_PARTY_SEARCH.IDList;
4909: l_match_idx NUMBER;
4902: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
4903: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4904: l_contact_list HZ_PARTY_SEARCH.contact_list;
4905: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4906: contact_point_ids HZ_PARTY_SEARCH.IDList;
4907: p_party_site_list HZ_PARTY_SEARCH.IDList;
4908: p_contact_ids HZ_PARTY_SEARCH.IDList;
4909: l_match_idx NUMBER;
4910:
4903: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4904: l_contact_list HZ_PARTY_SEARCH.contact_list;
4905: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4906: contact_point_ids HZ_PARTY_SEARCH.IDList;
4907: p_party_site_list HZ_PARTY_SEARCH.IDList;
4908: p_contact_ids HZ_PARTY_SEARCH.IDList;
4909: l_match_idx NUMBER;
4910:
4911: BEGIN
4904: l_contact_list HZ_PARTY_SEARCH.contact_list;
4905: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4906: contact_point_ids HZ_PARTY_SEARCH.IDList;
4907: p_party_site_list HZ_PARTY_SEARCH.IDList;
4908: p_contact_ids HZ_PARTY_SEARCH.IDList;
4909: l_match_idx NUMBER;
4910:
4911: BEGIN
4912: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4921: END IF;
4922: contact_point_ids(1) := p_contact_point_id;
4923: get_search_criteria (
4924: null,
4925: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
4926: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
4927: contact_point_ids,
4928: l_party_search_rec,
4929: l_party_site_list,
4922: contact_point_ids(1) := p_contact_point_id;
4923: get_search_criteria (
4924: null,
4925: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
4926: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
4927: contact_point_ids,
4928: l_party_search_rec,
4929: l_party_site_list,
4930: l_contact_list,
5075: ) IS
5076: TYPE AttrList IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
5077: l_match_idx NUMBER;
5078: AttrVals AttrList;
5079: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
5080: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
5081: l_contact_list HZ_PARTY_SEARCH.contact_list;
5082: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
5083: l_dup_set_id NUMBER;
5076: TYPE AttrList IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
5077: l_match_idx NUMBER;
5078: AttrVals AttrList;
5079: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
5080: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
5081: l_contact_list HZ_PARTY_SEARCH.contact_list;
5082: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
5083: l_dup_set_id NUMBER;
5084: l_idx NUMBER;
5077: l_match_idx NUMBER;
5078: AttrVals AttrList;
5079: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
5080: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
5081: l_contact_list HZ_PARTY_SEARCH.contact_list;
5082: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
5083: l_dup_set_id NUMBER;
5084: l_idx NUMBER;
5085: l_cpt_type VARCHAR2(255);
5078: AttrVals AttrList;
5079: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
5080: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
5081: l_contact_list HZ_PARTY_SEARCH.contact_list;
5082: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
5083: l_dup_set_id NUMBER;
5084: l_idx NUMBER;
5085: l_cpt_type VARCHAR2(255);
5086: FIRST BOOLEAN := TRUE;
5323:
5324: PROCEDURE get_matching_party_sites (
5325: p_rule_id IN NUMBER,
5326: p_party_id IN NUMBER,
5327: p_party_site_list IN HZ_PARTY_SEARCH.PARTY_SITE_LIST,
5328: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
5329: p_restrict_sql IN VARCHAR2,
5330: p_match_type IN VARCHAR2,
5331: p_dup_party_site_id IN NUMBER,
5324: PROCEDURE get_matching_party_sites (
5325: p_rule_id IN NUMBER,
5326: p_party_id IN NUMBER,
5327: p_party_site_list IN HZ_PARTY_SEARCH.PARTY_SITE_LIST,
5328: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
5329: p_restrict_sql IN VARCHAR2,
5330: p_match_type IN VARCHAR2,
5331: p_dup_party_site_id IN NUMBER,
5332: x_search_ctx_id OUT NUMBER,
5362: l_TX11 VARCHAR2(2000);
5363: l_TX8 VARCHAR2(2000);
5364: l_TX14 VARCHAR2(2000);
5365: l_TX7 VARCHAR2(2000);
5366: H_SCORES HZ_PARTY_SEARCH.score_list;
5367:
5368: l_score NUMBER;
5369: l_idx NUMBER;
5370: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
5393: defps NUMBER :=0;
5394: defct NUMBER :=0;
5395: defcpt NUMBER :=0;
5396: l_index NUMBER;
5397: l_match_ps_list HZ_PARTY_SEARCH.IDList;
5398: l_cnt NUMBER:=1;
5399:
5400:
5401: BEGIN
5417: l_match_str := ' AND ';
5418: ELSIF p_match_type = 'OR' THEN
5419: l_match_str := ' OR ';
5420: END IF;
5421: 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);
5422: g_score_until_thresh := false;
5423: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
5424:
5425: -- ************************************************************
5425: -- ************************************************************
5426: -- STEP 2. Setup of intermedia query strings for Acquisition query
5427: l_party_site_contains_str := INIT_PARTY_SITES_QUERY(l_match_str,l_tmp);
5428: l_contact_pt_contains_str := INIT_CONTACT_POINTS_QUERY(l_match_str,l_tmp);
5429: 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);
5430:
5431: -- Setup Search Context ID
5432: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;
5433: x_search_ctx_id := l_search_ctx_id;
5568:
5569: PROCEDURE get_matching_contacts (
5570: p_rule_id IN NUMBER,
5571: p_party_id IN NUMBER,
5572: p_contact_list IN HZ_PARTY_SEARCH.CONTACT_LIST,
5573: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
5574: p_restrict_sql IN VARCHAR2,
5575: p_match_type IN VARCHAR2,
5576: p_dup_contact_id IN NUMBER,
5569: PROCEDURE get_matching_contacts (
5570: p_rule_id IN NUMBER,
5571: p_party_id IN NUMBER,
5572: p_contact_list IN HZ_PARTY_SEARCH.CONTACT_LIST,
5573: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
5574: p_restrict_sql IN VARCHAR2,
5575: p_match_type IN VARCHAR2,
5576: p_dup_contact_id IN NUMBER,
5577: x_search_ctx_id OUT NUMBER,
5597:
5598: l_TX1 VARCHAR2(2000);
5599: l_TX8 VARCHAR2(2000);
5600: l_TX7 VARCHAR2(2000);
5601: H_SCORES HZ_PARTY_SEARCH.score_list;
5602:
5603: l_score NUMBER;
5604: l_idx NUMBER;
5605: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
5625: l_party_max_score NUMBER;
5626: l_ps_max_score NUMBER;
5627: l_contact_max_score NUMBER;
5628: l_cpt_max_score NUMBER;
5629: l_match_contact_list HZ_PARTY_SEARCH.IDList;
5630: l_cnt NUMBER:=1;
5631:
5632:
5633: BEGIN
5649: l_match_str := ' AND ';
5650: ELSIF p_match_type = 'OR' THEN
5651: l_match_str := ' OR ';
5652: END IF;
5653: 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);
5654: g_score_until_thresh := false;
5655: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
5656:
5657: -- ************************************************************
5657: -- ************************************************************
5658: -- STEP 2. Setup of intermedia query strings for Acquisition query
5659: l_contact_contains_str := INIT_CONTACTS_QUERY(l_match_str,l_tmp);
5660: l_contact_pt_contains_str := INIT_CONTACT_POINTS_QUERY(l_match_str,l_tmp);
5661: 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);
5662:
5663: -- Setup Search Context ID
5664: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;
5665: x_search_ctx_id := l_search_ctx_id;
5796:
5797: PROCEDURE get_matching_contact_points (
5798: p_rule_id IN NUMBER,
5799: p_party_id IN NUMBER,
5800: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
5801: p_restrict_sql IN VARCHAR2,
5802: p_match_type IN VARCHAR2,
5803: p_dup_contact_point_id IN NUMBER,
5804: x_search_ctx_id OUT NUMBER,
5828: l_cpt_ps_id NUMBER;
5829: l_cpt_contact_id NUMBER;
5830: l_contact_pt_id NUMBER;
5831: l_cpt_type VARCHAR2(100);
5832: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
5833: H_CONTACT_POINT_ID HZ_PARTY_SEARCH.IDList;
5834: H_SCORE HZ_PARTY_SEARCH.IDList;
5835:
5836: cnt NUMBER :=0;
5829: l_cpt_contact_id NUMBER;
5830: l_contact_pt_id NUMBER;
5831: l_cpt_type VARCHAR2(100);
5832: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
5833: H_CONTACT_POINT_ID HZ_PARTY_SEARCH.IDList;
5834: H_SCORE HZ_PARTY_SEARCH.IDList;
5835:
5836: cnt NUMBER :=0;
5837: l_party_max_score NUMBER;
5830: l_contact_pt_id NUMBER;
5831: l_cpt_type VARCHAR2(100);
5832: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
5833: H_CONTACT_POINT_ID HZ_PARTY_SEARCH.IDList;
5834: H_SCORE HZ_PARTY_SEARCH.IDList;
5835:
5836: cnt NUMBER :=0;
5837: l_party_max_score NUMBER;
5838: l_ps_max_score NUMBER;
5859: l_match_str := ' AND ';
5860: ELSIF p_match_type = 'OR' THEN
5861: l_match_str := ' OR ';
5862: END IF;
5863: l_entered_max_score:= init_search(HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
5864: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST, HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
5865: p_contact_point_list,l_match_str, l_party_max_score, l_ps_max_score, l_contact_max_score, l_cpt_max_score);
5866: g_score_until_thresh := false;
5867: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
5860: ELSIF p_match_type = 'OR' THEN
5861: l_match_str := ' OR ';
5862: END IF;
5863: l_entered_max_score:= init_search(HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
5864: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST, HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
5865: p_contact_point_list,l_match_str, l_party_max_score, l_ps_max_score, l_contact_max_score, l_cpt_max_score);
5866: g_score_until_thresh := false;
5867: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
5868:
5868:
5869: -- ************************************************************
5870: -- STEP 2. Setup of intermedia query strings for Acquisition query
5871: l_contact_pt_contains_str := INIT_CONTACT_POINTS_QUERY(l_match_str,l_tmp);
5872: 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);
5873:
5874: -- Setup Search Context ID
5875: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;
5876: x_search_ctx_id := l_search_ctx_id;
5943:
5944: PROCEDURE get_score_details (
5945: p_rule_id IN NUMBER,
5946: p_party_id IN NUMBER,
5947: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
5948: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
5949: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
5950: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
5951: x_search_ctx_id IN OUT NUMBER
5944: PROCEDURE get_score_details (
5945: p_rule_id IN NUMBER,
5946: p_party_id IN NUMBER,
5947: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
5948: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
5949: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
5950: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
5951: x_search_ctx_id IN OUT NUMBER
5952: ) IS
5945: p_rule_id IN NUMBER,
5946: p_party_id IN NUMBER,
5947: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
5948: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
5949: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
5950: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
5951: x_search_ctx_id IN OUT NUMBER
5952: ) IS
5953:
5946: p_party_id IN NUMBER,
5947: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
5948: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
5949: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
5950: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
5951: x_search_ctx_id IN OUT NUMBER
5952: ) IS
5953:
5954: -- Strings to hold the generated Intermedia query strings
6003: l_TX14 VARCHAR2(2000);
6004: l_max_TX14 VARCHAR2(2000);
6005: l_TX7 VARCHAR2(2000);
6006: l_max_TX7 VARCHAR2(2000);
6007: H_SCORES HZ_PARTY_SEARCH.score_list;
6008:
6009: l_score NUMBER;
6010: l_match_idx NUMBER;
6011: l_idx NUMBER;
6181: ************************************************/
6182:
6183: PROCEDURE get_party_for_search (
6184: p_party_id IN NUMBER,
6185: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
6186: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
6187: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
6188: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
6189: ) IS
6182:
6183: PROCEDURE get_party_for_search (
6184: p_party_id IN NUMBER,
6185: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
6186: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
6187: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
6188: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
6189: ) IS
6190: l_party_id NUMBER;
6183: PROCEDURE get_party_for_search (
6184: p_party_id IN NUMBER,
6185: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
6186: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
6187: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
6188: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
6189: ) IS
6190: l_party_id NUMBER;
6191: l_party_site_ids HZ_PARTY_SEARCH.IDList;
6184: p_party_id IN NUMBER,
6185: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
6186: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
6187: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
6188: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
6189: ) IS
6190: l_party_id NUMBER;
6191: l_party_site_ids HZ_PARTY_SEARCH.IDList;
6192: l_contact_ids HZ_PARTY_SEARCH.IDList;
6187: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
6188: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
6189: ) IS
6190: l_party_id NUMBER;
6191: l_party_site_ids HZ_PARTY_SEARCH.IDList;
6192: l_contact_ids HZ_PARTY_SEARCH.IDList;
6193: l_contact_pt_ids HZ_PARTY_SEARCH.IDList;
6194: ps NUMBER :=1;
6195: cpt NUMBER :=1;
6188: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
6189: ) IS
6190: l_party_id NUMBER;
6191: l_party_site_ids HZ_PARTY_SEARCH.IDList;
6192: l_contact_ids HZ_PARTY_SEARCH.IDList;
6193: l_contact_pt_ids HZ_PARTY_SEARCH.IDList;
6194: ps NUMBER :=1;
6195: cpt NUMBER :=1;
6196: ct NUMBER :=1;
6189: ) IS
6190: l_party_id NUMBER;
6191: l_party_site_ids HZ_PARTY_SEARCH.IDList;
6192: l_contact_ids HZ_PARTY_SEARCH.IDList;
6193: l_contact_pt_ids HZ_PARTY_SEARCH.IDList;
6194: ps NUMBER :=1;
6195: cpt NUMBER :=1;
6196: ct NUMBER :=1;
6197: l_use_contact_info varchar2(1);
6285: END get_party_for_search;
6286:
6287: PROCEDURE get_search_criteria (
6288: p_party_id IN NUMBER,
6289: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
6290: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
6291: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
6292: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
6293: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
6286:
6287: PROCEDURE get_search_criteria (
6288: p_party_id IN NUMBER,
6289: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
6290: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
6291: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
6292: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
6293: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
6294: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
6287: PROCEDURE get_search_criteria (
6288: p_party_id IN NUMBER,
6289: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
6290: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
6291: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
6292: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
6293: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
6294: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
6295: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
6288: p_party_id IN NUMBER,
6289: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
6290: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
6291: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
6292: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
6293: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
6294: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
6295: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
6296: ) IS
6289: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
6290: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
6291: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
6292: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
6293: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
6294: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
6295: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
6296: ) IS
6297: BEGIN
6290: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
6291: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
6292: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
6293: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
6294: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
6295: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
6296: ) IS
6297: BEGIN
6298:
6291: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
6292: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
6293: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
6294: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
6295: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
6296: ) IS
6297: BEGIN
6298:
6299: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6337: ************************************************/
6338:
6339: PROCEDURE get_party_rec (
6340: p_party_id IN NUMBER,
6341: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type
6342: ) IS
6343: l_party_type VARCHAR2(255);
6344: BEGIN
6345:
6402: the party site search record structure
6403: ************************************************/
6404:
6405: PROCEDURE get_party_site_rec (
6406: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
6407: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
6408: ) IS
6409: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
6410: SELECT party_site_id
6403: ************************************************/
6404:
6405: PROCEDURE get_party_site_rec (
6406: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
6407: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
6408: ) IS
6409: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
6410: SELECT party_site_id
6411: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6466: the contact search record structure
6467: ************************************************/
6468:
6469: PROCEDURE get_contact_rec (
6470: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
6471: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
6472: ) IS
6473: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
6474: SELECT org_contact_id
6467: ************************************************/
6468:
6469: PROCEDURE get_contact_rec (
6470: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
6471: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
6472: ) IS
6473: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
6474: SELECT org_contact_id
6475: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
6522: the contact point search record structure
6523: ************************************************/
6524:
6525: PROCEDURE get_contact_point_rec (
6526: p_contact_point_ids IN HZ_PARTY_SEARCH.IDList,
6527: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
6528: ) IS
6529:
6530: -- Cursor to fetch primary contact points for party
6523: ************************************************/
6524:
6525: PROCEDURE get_contact_point_rec (
6526: p_contact_point_ids IN HZ_PARTY_SEARCH.IDList,
6527: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
6528: ) IS
6529:
6530: -- Cursor to fetch primary contact points for party
6531: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
6581: ************************************************/
6582:
6583: PROCEDURE MAP_PARTY_REC(
6584: p_search_ctx IN BOOLEAN,
6585: p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
6586: x_entered_max_score OUT NUMBER,
6587: x_stage_rec IN OUT NOCOPY HZ_PARTY_STAGE.party_stage_rec_type
6588: ) IS
6589: tmp VARCHAR2(4000);
6775: ************************************************/
6776:
6777: PROCEDURE MAP_PARTY_SITE_REC(
6778: p_search_ctx IN BOOLEAN,
6779: p_search_list IN HZ_PARTY_SEARCH.party_site_list,
6780: x_entered_max_score OUT NUMBER,
6781: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.party_site_stage_list
6782: ) IS
6783: l_current_max_score NUMBER;
7016: ************************************************/
7017:
7018: PROCEDURE MAP_CONTACT_REC(
7019: p_search_ctx IN BOOLEAN,
7020: p_search_list IN HZ_PARTY_SEARCH.contact_list,
7021: x_entered_max_score OUT NUMBER,
7022: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_stage_list
7023: ) IS
7024: l_current_max_score NUMBER;
7058: ************************************************/
7059:
7060: PROCEDURE MAP_CONTACT_POINT_REC(
7061: p_search_ctx IN BOOLEAN,
7062: p_search_list IN HZ_PARTY_SEARCH.contact_point_list,
7063: x_entered_max_score OUT NUMBER,
7064: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_pt_stage_list
7065: ) IS
7066: l_current_max_score NUMBER;
7188: 2. Contact Point Type is not null for each condition
7189: ************************************************/
7190:
7191: FUNCTION check_prim_cond(
7192: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
7193: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
7194: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
7195: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)
7196: RETURN BOOLEAN IS
7189: ************************************************/
7190:
7191: FUNCTION check_prim_cond(
7192: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
7193: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
7194: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
7195: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)
7196: RETURN BOOLEAN IS
7197: BEGIN
7190:
7191: FUNCTION check_prim_cond(
7192: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
7193: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
7194: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
7195: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)
7196: RETURN BOOLEAN IS
7197: BEGIN
7198: FOR I IN 1..p_contact_point_list.COUNT LOOP
7191: FUNCTION check_prim_cond(
7192: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
7193: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
7194: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
7195: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)
7196: RETURN BOOLEAN IS
7197: BEGIN
7198: FOR I IN 1..p_contact_point_list.COUNT LOOP
7199: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
7278: has party site criteria.
7279: ************************************************/
7280:
7281: PROCEDURE check_party_site_cond(
7282: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
7283: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
7284: x_secondary OUT BOOLEAN,
7285: x_primary OUT BOOLEAN
7286: ) IS
7279: ************************************************/
7280:
7281: PROCEDURE check_party_site_cond(
7282: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
7283: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
7284: x_secondary OUT BOOLEAN,
7285: x_primary OUT BOOLEAN
7286: ) IS
7287: BEGIN
7342: has contact criteria.
7343: ************************************************/
7344:
7345: PROCEDURE check_contact_cond(
7346: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
7347: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
7348: x_secondary OUT BOOLEAN,
7349: x_primary OUT BOOLEAN
7350: ) IS
7343: ************************************************/
7344:
7345: PROCEDURE check_contact_cond(
7346: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
7347: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
7348: x_secondary OUT BOOLEAN,
7349: x_primary OUT BOOLEAN
7350: ) IS
7351: BEGIN
7390: has valid contact point criteria.
7391: ************************************************/
7392:
7393: PROCEDURE check_contact_point_cond(
7394: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
7395: x_secondary OUT BOOLEAN,
7396: x_primary OUT BOOLEAN
7397: ) IS
7398: BEGIN