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;
636: PROCEDURE INSERT_PARTY_SCORE (
637: p_party_id IN NUMBER
638: ,p_record_id IN NUMBER
639: ,p_search_ctx_id IN NUMBER
640: ,p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type
641: ,p_stage_rec IN HZ_PARTY_STAGE.party_stage_rec_type
642: ,p_table_TX34 VARCHAR2
643: ,p_table_TX40 VARCHAR2
644: ,p_table_TX158 VARCHAR2
822: PROCEDURE INSERT_PARTY_SITES_SCORE (
823: p_party_id IN NUMBER
824: ,p_record_id IN NUMBER
825: ,p_search_ctx_id IN NUMBER
826: ,p_search_rec IN HZ_PARTY_SEARCH.party_site_search_rec_type
827: ,p_stage_rec IN HZ_PARTY_STAGE.party_site_stage_rec_type
828: ,p_table_TX3 VARCHAR2
829: ,p_table_TX4 VARCHAR2
830: ,p_table_TX9 VARCHAR2
989: PROCEDURE INSERT_CONTACTS_SCORE (
990: p_party_id IN NUMBER
991: ,p_record_id IN NUMBER
992: ,p_search_ctx_id IN NUMBER
993: ,p_search_rec IN HZ_PARTY_SEARCH.contact_search_rec_type
994: ,p_stage_rec IN HZ_PARTY_STAGE.contact_stage_rec_type
995: ,p_table_TX2 VARCHAR2
996: ,p_table_TX156 VARCHAR2
997: ,p_table_TX6 VARCHAR2
1052: PROCEDURE INSERT_CONTACT_POINTS_SCORE (
1053: p_party_id IN NUMBER
1054: ,p_record_id IN NUMBER
1055: ,p_search_ctx_id IN NUMBER
1056: ,p_search_rec IN HZ_PARTY_SEARCH.contact_point_search_rec_type
1057: ,p_stage_rec IN HZ_PARTY_STAGE.contact_pt_stage_rec_type
1058: ,p_table_TX1 VARCHAR2
1059: ,p_table_TX6 VARCHAR2
1060: ,p_table_TX5 VARCHAR2
1130: for the PARTY Entity
1131: ************************************************/
1132:
1133: PROCEDURE POP_PARTY_COND_REC(
1134: p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type
1135: ) IS
1136: BEGIN
1137: NULL ;
1138: EXCEPTION
1150: for the PARTY_SITES Entity
1151: ************************************************/
1152:
1153: PROCEDURE POP_PARTY_SITES_COND_REC(
1154: p_search_list IN HZ_PARTY_SEARCH.party_site_list
1155: ) IS
1156: BEGIN
1157: ---------POPULATE THE GLOBAL WORD CONDITION REC FOR PARTY_SITES-------------
1158: ------ Populate global condition record only if search list is not empty -----------
1175: for the CONTACTS Entity
1176: ************************************************/
1177:
1178: PROCEDURE POP_CONTACTS_COND_REC(
1179: p_search_list IN HZ_PARTY_SEARCH.contact_list
1180: ) IS
1181: BEGIN
1182: NULL ;
1183: EXCEPTION
1195: for the CONTACT_POINTS Entity
1196: ************************************************/
1197:
1198: PROCEDURE POP_CONTACT_POINTS_COND_REC(
1199: p_search_list IN HZ_PARTY_SEARCH.contact_point_list
1200: ) IS
1201: BEGIN
1202: NULL ;
1203: EXCEPTION
1209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1210: END;
1211:
1212: PROCEDURE init_score_context (
1213: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
1214: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
1215: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1216: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1217: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1210: END;
1211:
1212: PROCEDURE init_score_context (
1213: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
1214: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
1215: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1216: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1217: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1218: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1211:
1212: PROCEDURE init_score_context (
1213: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
1214: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
1215: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1216: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1217: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1218: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1219: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
1212: PROCEDURE init_score_context (
1213: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
1214: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
1215: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1216: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1217: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1218: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1219: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
1220: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST
1213: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
1214: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
1215: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1216: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1217: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1218: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1219: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
1220: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST
1221: ) IS
1214: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
1215: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1216: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1217: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1218: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1219: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
1220: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST
1221: ) IS
1222: l_dummy NUMBER;
1215: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1216: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1217: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1218: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1219: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
1220: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST
1221: ) IS
1222: l_dummy NUMBER;
1223: BEGIN
1216: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1217: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1218: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1219: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
1220: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST
1221: ) IS
1222: l_dummy NUMBER;
1223: BEGIN
1224: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1236: MAP_CONTACT_POINT_REC(FALSE,p_contact_point_list, l_dummy, g_contact_pt_stage_list);
1237:
1238: END;
1239: FUNCTION init_search(
1240: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
1241: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
1242: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1243: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1244: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1237:
1238: END;
1239: FUNCTION init_search(
1240: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
1241: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
1242: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1243: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1244: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1245: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1238: END;
1239: FUNCTION init_search(
1240: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
1241: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
1242: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1243: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1244: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1245: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1246: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
1239: FUNCTION init_search(
1240: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
1241: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
1242: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1243: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1244: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1245: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1246: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
1247: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST,
1240: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=
1241: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
1242: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1243: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1244: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1245: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1246: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
1247: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST,
1248: p_match_type IN VARCHAR2,
1241: HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
1242: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1243: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1244: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1245: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1246: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
1247: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST,
1248: p_match_type IN VARCHAR2,
1249: x_party_max_score OUT NUMBER,
1242: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list:=
1243: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1244: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1245: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1246: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
1247: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST,
1248: p_match_type IN VARCHAR2,
1249: x_party_max_score OUT NUMBER,
1250: x_ps_max_score OUT NUMBER,
1243: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST,
1244: p_contact_list IN HZ_PARTY_SEARCH.contact_list:=
1245: HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
1246: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list:=
1247: HZ_PARTY_SEARCH.G_MISS_CONTACT_POINT_LIST,
1248: p_match_type IN VARCHAR2,
1249: x_party_max_score OUT NUMBER,
1250: x_ps_max_score OUT NUMBER,
1251: x_contact_max_score OUT NUMBER,
1255: l_ps_entered_max_score NUMBER:=0;
1256: l_ct_entered_max_score NUMBER:=0;
1257: l_cpt_entered_max_score NUMBER:=0;
1258: vlist vlisttype;
1259: maxscore HZ_PARTY_SEARCH.IDList;
1260: l_name VARCHAR2(200);
1261: l_idx NUMBER;
1262: l_num NUMBER;
1263: total NUMBER;
2819: p_party_id NUMBER,
2820: p_party_site_id NUMBER,
2821: p_org_contact_id NUMBER,
2822: p_contact_point_id NUMBER)
2823: RETURN HZ_PARTY_SEARCH.score_rec IS
2824: l_score_rec HZ_PARTY_SEARCH.score_rec;
2825: BEGIN
2826: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2827: 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);
2820: p_party_site_id NUMBER,
2821: p_org_contact_id NUMBER,
2822: p_contact_point_id NUMBER)
2823: RETURN HZ_PARTY_SEARCH.score_rec IS
2824: l_score_rec HZ_PARTY_SEARCH.score_rec;
2825: BEGIN
2826: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2827: 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);
2828: 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);
2852: **********************************************************/
2853:
2854: PROCEDURE find_parties (
2855: p_rule_id IN NUMBER,
2856: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2857: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2858: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2859: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2860: p_restrict_sql IN VARCHAR2,
2853:
2854: PROCEDURE find_parties (
2855: p_rule_id IN NUMBER,
2856: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2857: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2858: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2859: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2860: p_restrict_sql IN VARCHAR2,
2861: p_match_type IN VARCHAR2,
2854: PROCEDURE find_parties (
2855: p_rule_id IN NUMBER,
2856: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2857: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2858: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2859: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2860: p_restrict_sql IN VARCHAR2,
2861: p_match_type IN VARCHAR2,
2862: p_search_merged IN VARCHAR2,
2855: p_rule_id IN NUMBER,
2856: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
2857: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
2858: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
2859: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
2860: p_restrict_sql IN VARCHAR2,
2861: p_match_type IN VARCHAR2,
2862: p_search_merged IN VARCHAR2,
2863: p_dup_party_id IN NUMBER,
2908: l_TX45 VARCHAR2(2000);
2909: l_TX156 VARCHAR2(2000);
2910: l_TX14 VARCHAR2(2000);
2911: l_TX6 VARCHAR2(2000);
2912: H_SCORES HZ_PARTY_SEARCH.score_list;
2913: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
2914: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
2915:
2916: l_score NUMBER;
2909: l_TX156 VARCHAR2(2000);
2910: l_TX14 VARCHAR2(2000);
2911: l_TX6 VARCHAR2(2000);
2912: H_SCORES HZ_PARTY_SEARCH.score_list;
2913: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
2914: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
2915:
2916: l_score NUMBER;
2917: l_idx NUMBER;
2910: l_TX14 VARCHAR2(2000);
2911: l_TX6 VARCHAR2(2000);
2912: H_SCORES HZ_PARTY_SEARCH.score_list;
2913: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
2914: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
2915:
2916: l_score NUMBER;
2917: l_idx NUMBER;
2918: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
3102: /** Private procedure to acquire and score at party site level ***/
3103: 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
3104: l_party_id_idx NUMBER:=1;
3105: l_ctx_id NUMBER;
3106: h_ps_id HZ_PARTY_SEARCH.IDList;
3107: h_ps_party_id HZ_PARTY_SEARCH.IDList;
3108: h_ps_score HZ_PARTY_SEARCH.IDList;
3109: detcnt NUMBER := 1;
3110: BEGIN
3103: 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
3104: l_party_id_idx NUMBER:=1;
3105: l_ctx_id NUMBER;
3106: h_ps_id HZ_PARTY_SEARCH.IDList;
3107: h_ps_party_id HZ_PARTY_SEARCH.IDList;
3108: h_ps_score HZ_PARTY_SEARCH.IDList;
3109: detcnt NUMBER := 1;
3110: BEGIN
3111: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3104: l_party_id_idx NUMBER:=1;
3105: l_ctx_id NUMBER;
3106: h_ps_id HZ_PARTY_SEARCH.IDList;
3107: h_ps_party_id HZ_PARTY_SEARCH.IDList;
3108: h_ps_score HZ_PARTY_SEARCH.IDList;
3109: detcnt NUMBER := 1;
3110: BEGIN
3111: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3112: 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);
3224: /** Private procedure to acquire and score at contact point level ***/
3225: 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
3226: l_party_id_idx NUMBER:=1;
3227: l_ctx_id NUMBER;
3228: h_ct_id HZ_PARTY_SEARCH.IDList;
3229: h_ct_party_id HZ_PARTY_SEARCH.IDList;
3230: h_ct_score HZ_PARTY_SEARCH.IDList;
3231: detcnt NUMBER := 1;
3232: BEGIN
3225: 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
3226: l_party_id_idx NUMBER:=1;
3227: l_ctx_id NUMBER;
3228: h_ct_id HZ_PARTY_SEARCH.IDList;
3229: h_ct_party_id HZ_PARTY_SEARCH.IDList;
3230: h_ct_score HZ_PARTY_SEARCH.IDList;
3231: detcnt NUMBER := 1;
3232: BEGIN
3233: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3226: l_party_id_idx NUMBER:=1;
3227: l_ctx_id NUMBER;
3228: h_ct_id HZ_PARTY_SEARCH.IDList;
3229: h_ct_party_id HZ_PARTY_SEARCH.IDList;
3230: h_ct_score HZ_PARTY_SEARCH.IDList;
3231: detcnt NUMBER := 1;
3232: BEGIN
3233: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3234: 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);
3333: /** Private procedure to acquire and score at contact point level ***/
3334: 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
3335: l_party_id_idx NUMBER:=1;
3336: l_ctx_id NUMBER;
3337: h_cpt_id HZ_PARTY_SEARCH.IDList;
3338: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
3339: h_cpt_score HZ_PARTY_SEARCH.IDList;
3340: detcnt NUMBER := 1;
3341: l_cpt_flag VARCHAR2(1) := 'N';
3334: 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
3335: l_party_id_idx NUMBER:=1;
3336: l_ctx_id NUMBER;
3337: h_cpt_id HZ_PARTY_SEARCH.IDList;
3338: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
3339: h_cpt_score HZ_PARTY_SEARCH.IDList;
3340: detcnt NUMBER := 1;
3341: l_cpt_flag VARCHAR2(1) := 'N';
3342: is_a_match VARCHAR2(1) := 'Y';
3335: l_party_id_idx NUMBER:=1;
3336: l_ctx_id NUMBER;
3337: h_cpt_id HZ_PARTY_SEARCH.IDList;
3338: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
3339: h_cpt_score HZ_PARTY_SEARCH.IDList;
3340: detcnt NUMBER := 1;
3341: l_cpt_flag VARCHAR2(1) := 'N';
3342: is_a_match VARCHAR2(1) := 'Y';
3343: BEGIN
3822: END find_parties;
3823:
3824: PROCEDURE find_persons (
3825: p_rule_id IN NUMBER,
3826: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
3827: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
3828: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
3829: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
3830: p_restrict_sql IN VARCHAR2,
3823:
3824: PROCEDURE find_persons (
3825: p_rule_id IN NUMBER,
3826: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
3827: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
3828: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
3829: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
3830: p_restrict_sql IN VARCHAR2,
3831: p_match_type IN VARCHAR2,
3824: PROCEDURE find_persons (
3825: p_rule_id IN NUMBER,
3826: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
3827: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
3828: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
3829: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
3830: p_restrict_sql IN VARCHAR2,
3831: p_match_type IN VARCHAR2,
3832: p_search_merged IN VARCHAR2,
3825: p_rule_id IN NUMBER,
3826: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
3827: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
3828: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
3829: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
3830: p_restrict_sql IN VARCHAR2,
3831: p_match_type IN VARCHAR2,
3832: p_search_merged IN VARCHAR2,
3833: p_dup_party_id IN NUMBER,
3878: l_TX45 VARCHAR2(2000);
3879: l_TX156 VARCHAR2(2000);
3880: l_TX14 VARCHAR2(2000);
3881: l_TX6 VARCHAR2(2000);
3882: H_SCORES HZ_PARTY_SEARCH.score_list;
3883: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
3884: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
3885:
3886: l_score NUMBER;
3879: l_TX156 VARCHAR2(2000);
3880: l_TX14 VARCHAR2(2000);
3881: l_TX6 VARCHAR2(2000);
3882: H_SCORES HZ_PARTY_SEARCH.score_list;
3883: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
3884: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
3885:
3886: l_score NUMBER;
3887: l_idx NUMBER;
3880: l_TX14 VARCHAR2(2000);
3881: l_TX6 VARCHAR2(2000);
3882: H_SCORES HZ_PARTY_SEARCH.score_list;
3883: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
3884: H_PARTY_ID_LIST HZ_PARTY_SEARCH.IDList;
3885:
3886: l_score NUMBER;
3887: l_idx NUMBER;
3888: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
4120: /** Private procedure to acquire and score at party site level ***/
4121: 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
4122: l_party_id_idx NUMBER:=1;
4123: l_ctx_id NUMBER;
4124: h_ps_id HZ_PARTY_SEARCH.IDList;
4125: h_ps_party_id HZ_PARTY_SEARCH.IDList;
4126: h_ps_score HZ_PARTY_SEARCH.IDList;
4127: detcnt NUMBER := 1;
4128: l_person_id NUMBER;
4121: 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
4122: l_party_id_idx NUMBER:=1;
4123: l_ctx_id NUMBER;
4124: h_ps_id HZ_PARTY_SEARCH.IDList;
4125: h_ps_party_id HZ_PARTY_SEARCH.IDList;
4126: h_ps_score HZ_PARTY_SEARCH.IDList;
4127: detcnt NUMBER := 1;
4128: l_person_id NUMBER;
4129: BEGIN
4122: l_party_id_idx NUMBER:=1;
4123: l_ctx_id NUMBER;
4124: h_ps_id HZ_PARTY_SEARCH.IDList;
4125: h_ps_party_id HZ_PARTY_SEARCH.IDList;
4126: h_ps_score HZ_PARTY_SEARCH.IDList;
4127: detcnt NUMBER := 1;
4128: l_person_id NUMBER;
4129: BEGIN
4130: SAVEPOINT eval_start;
4219: /** Private procedure to acquire and score at party site level ***/
4220: PROCEDURE eval_contact_level(p_contact_contains_str VARCHAR2,p_ins_details VARCHAR2,p_emax_score NUMBER) IS
4221: l_party_id_idx NUMBER:=1;
4222: l_ctx_id NUMBER;
4223: h_ct_id HZ_PARTY_SEARCH.IDList;
4224: h_ct_party_id HZ_PARTY_SEARCH.IDList;
4225: h_ct_score HZ_PARTY_SEARCH.IDList;
4226: detcnt NUMBER := 1;
4227: l_person_id NUMBER;
4220: PROCEDURE eval_contact_level(p_contact_contains_str VARCHAR2,p_ins_details VARCHAR2,p_emax_score NUMBER) IS
4221: l_party_id_idx NUMBER:=1;
4222: l_ctx_id NUMBER;
4223: h_ct_id HZ_PARTY_SEARCH.IDList;
4224: h_ct_party_id HZ_PARTY_SEARCH.IDList;
4225: h_ct_score HZ_PARTY_SEARCH.IDList;
4226: detcnt NUMBER := 1;
4227: l_person_id NUMBER;
4228: BEGIN
4221: l_party_id_idx NUMBER:=1;
4222: l_ctx_id NUMBER;
4223: h_ct_id HZ_PARTY_SEARCH.IDList;
4224: h_ct_party_id HZ_PARTY_SEARCH.IDList;
4225: h_ct_score HZ_PARTY_SEARCH.IDList;
4226: detcnt NUMBER := 1;
4227: l_person_id NUMBER;
4228: BEGIN
4229: SAVEPOINT eval_start;
4277: /** Private procedure to acquire and score at contact point level ***/
4278: 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
4279: l_party_id_idx NUMBER:=1;
4280: l_ctx_id NUMBER;
4281: h_cpt_id HZ_PARTY_SEARCH.IDList;
4282: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
4283: h_cpt_score HZ_PARTY_SEARCH.IDList;
4284: detcnt NUMBER := 1;
4285: l_person_id NUMBER;
4278: 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
4279: l_party_id_idx NUMBER:=1;
4280: l_ctx_id NUMBER;
4281: h_cpt_id HZ_PARTY_SEARCH.IDList;
4282: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
4283: h_cpt_score HZ_PARTY_SEARCH.IDList;
4284: detcnt NUMBER := 1;
4285: l_person_id NUMBER;
4286: is_a_match VARCHAR2(1) := 'Y';
4279: l_party_id_idx NUMBER:=1;
4280: l_ctx_id NUMBER;
4281: h_cpt_id HZ_PARTY_SEARCH.IDList;
4282: h_cpt_party_id HZ_PARTY_SEARCH.IDList;
4283: h_cpt_score HZ_PARTY_SEARCH.IDList;
4284: detcnt NUMBER := 1;
4285: l_person_id NUMBER;
4286: is_a_match VARCHAR2(1) := 'Y';
4287: l_cpt_flag VARCHAR2(1) := 'N';
4690: END find_persons;
4691:
4692: PROCEDURE find_persons (
4693: p_rule_id IN NUMBER,
4694: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
4695: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
4696: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
4697: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
4698: p_restrict_sql IN VARCHAR2,
4691:
4692: PROCEDURE find_persons (
4693: p_rule_id IN NUMBER,
4694: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
4695: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
4696: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
4697: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
4698: p_restrict_sql IN VARCHAR2,
4699: p_match_type IN VARCHAR2,
4692: PROCEDURE find_persons (
4693: p_rule_id IN NUMBER,
4694: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
4695: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
4696: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
4697: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
4698: p_restrict_sql IN VARCHAR2,
4699: p_match_type IN VARCHAR2,
4700: p_search_merged IN VARCHAR2,
4693: p_rule_id IN NUMBER,
4694: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
4695: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
4696: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
4697: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
4698: p_restrict_sql IN VARCHAR2,
4699: p_match_type IN VARCHAR2,
4700: p_search_merged IN VARCHAR2,
4701: p_ins_details IN VARCHAR2,
4707: 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);
4708: END;
4709: PROCEDURE find_party_details (
4710: p_rule_id IN NUMBER,
4711: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
4712: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
4713: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
4714: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
4715: p_restrict_sql IN VARCHAR2,
4708: END;
4709: PROCEDURE find_party_details (
4710: p_rule_id IN NUMBER,
4711: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
4712: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
4713: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
4714: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
4715: p_restrict_sql IN VARCHAR2,
4716: p_match_type IN VARCHAR2,
4709: PROCEDURE find_party_details (
4710: p_rule_id IN NUMBER,
4711: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
4712: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
4713: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
4714: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
4715: p_restrict_sql IN VARCHAR2,
4716: p_match_type IN VARCHAR2,
4717: p_search_merged IN VARCHAR2,
4710: p_rule_id IN NUMBER,
4711: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
4712: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
4713: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
4714: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
4715: p_restrict_sql IN VARCHAR2,
4716: p_match_type IN VARCHAR2,
4717: p_search_merged IN VARCHAR2,
4718: x_search_ctx_id OUT NUMBER,
4767: x_dup_set_id OUT NUMBER,
4768: x_search_ctx_id OUT NUMBER,
4769: x_num_matches OUT NUMBER
4770: ) IS
4771: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
4772: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4773: l_contact_list HZ_PARTY_SEARCH.contact_list;
4774: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
4775: l_match_idx NUMBER;
4768: x_search_ctx_id OUT NUMBER,
4769: x_num_matches OUT NUMBER
4770: ) IS
4771: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
4772: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4773: l_contact_list HZ_PARTY_SEARCH.contact_list;
4774: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
4775: l_match_idx NUMBER;
4776:
4769: x_num_matches OUT NUMBER
4770: ) IS
4771: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
4772: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4773: l_contact_list HZ_PARTY_SEARCH.contact_list;
4774: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
4775: l_match_idx NUMBER;
4776:
4777: --Fix for bug 4417124
4770: ) IS
4771: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
4772: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4773: l_contact_list HZ_PARTY_SEARCH.contact_list;
4774: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
4775: l_match_idx NUMBER;
4776:
4777: --Fix for bug 4417124
4778: l_use_contact_addr_info BOOLEAN := TRUE;
4883: x_search_ctx_id OUT NUMBER,
4884: x_num_matches OUT NUMBER
4885: ) IS
4886:
4887: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
4888: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4889: l_contact_list HZ_PARTY_SEARCH.contact_list;
4890: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4891: contact_point_ids HZ_PARTY_SEARCH.IDList;
4884: x_num_matches OUT NUMBER
4885: ) IS
4886:
4887: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
4888: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4889: l_contact_list HZ_PARTY_SEARCH.contact_list;
4890: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4891: contact_point_ids HZ_PARTY_SEARCH.IDList;
4892: p_party_site_list HZ_PARTY_SEARCH.IDList;
4885: ) IS
4886:
4887: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
4888: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4889: l_contact_list HZ_PARTY_SEARCH.contact_list;
4890: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4891: contact_point_ids HZ_PARTY_SEARCH.IDList;
4892: p_party_site_list HZ_PARTY_SEARCH.IDList;
4893: p_contact_ids HZ_PARTY_SEARCH.IDList;
4886:
4887: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
4888: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4889: l_contact_list HZ_PARTY_SEARCH.contact_list;
4890: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4891: contact_point_ids HZ_PARTY_SEARCH.IDList;
4892: p_party_site_list HZ_PARTY_SEARCH.IDList;
4893: p_contact_ids HZ_PARTY_SEARCH.IDList;
4894: l_match_idx NUMBER;
4887: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
4888: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4889: l_contact_list HZ_PARTY_SEARCH.contact_list;
4890: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4891: contact_point_ids HZ_PARTY_SEARCH.IDList;
4892: p_party_site_list HZ_PARTY_SEARCH.IDList;
4893: p_contact_ids HZ_PARTY_SEARCH.IDList;
4894: l_match_idx NUMBER;
4895: cursor get_cpts_for_party_sites is select contact_point_id
4888: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4889: l_contact_list HZ_PARTY_SEARCH.contact_list;
4890: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4891: contact_point_ids HZ_PARTY_SEARCH.IDList;
4892: p_party_site_list HZ_PARTY_SEARCH.IDList;
4893: p_contact_ids HZ_PARTY_SEARCH.IDList;
4894: l_match_idx NUMBER;
4895: cursor get_cpts_for_party_sites is select contact_point_id
4896: from hz_contact_points
4889: l_contact_list HZ_PARTY_SEARCH.contact_list;
4890: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4891: contact_point_ids HZ_PARTY_SEARCH.IDList;
4892: p_party_site_list HZ_PARTY_SEARCH.IDList;
4893: p_contact_ids HZ_PARTY_SEARCH.IDList;
4894: l_match_idx NUMBER;
4895: cursor get_cpts_for_party_sites is select contact_point_id
4896: from hz_contact_points
4897: where owner_table_name = 'HZ_PARTY_SITES'
4918:
4919: get_search_criteria (
4920: null,
4921: p_party_site_list,
4922: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
4923: contact_point_ids,
4924: l_party_search_rec,
4925: l_party_site_list,
4926: l_contact_list,
4968: x_search_ctx_id OUT NUMBER,
4969: x_num_matches OUT NUMBER
4970: ) IS
4971:
4972: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
4973: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4974: l_contact_list HZ_PARTY_SEARCH.contact_list;
4975: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4976: contact_point_ids HZ_PARTY_SEARCH.IDList;
4969: x_num_matches OUT NUMBER
4970: ) IS
4971:
4972: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
4973: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4974: l_contact_list HZ_PARTY_SEARCH.contact_list;
4975: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4976: contact_point_ids HZ_PARTY_SEARCH.IDList;
4977: p_party_site_list HZ_PARTY_SEARCH.IDList;
4970: ) IS
4971:
4972: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
4973: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4974: l_contact_list HZ_PARTY_SEARCH.contact_list;
4975: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4976: contact_point_ids HZ_PARTY_SEARCH.IDList;
4977: p_party_site_list HZ_PARTY_SEARCH.IDList;
4978: p_contact_ids HZ_PARTY_SEARCH.IDList;
4971:
4972: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
4973: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4974: l_contact_list HZ_PARTY_SEARCH.contact_list;
4975: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4976: contact_point_ids HZ_PARTY_SEARCH.IDList;
4977: p_party_site_list HZ_PARTY_SEARCH.IDList;
4978: p_contact_ids HZ_PARTY_SEARCH.IDList;
4979: l_match_idx NUMBER;
4972: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
4973: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4974: l_contact_list HZ_PARTY_SEARCH.contact_list;
4975: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4976: contact_point_ids HZ_PARTY_SEARCH.IDList;
4977: p_party_site_list HZ_PARTY_SEARCH.IDList;
4978: p_contact_ids HZ_PARTY_SEARCH.IDList;
4979: l_match_idx NUMBER;
4980: cursor get_cpt_for_contact_id is select contact_point_id
4973: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
4974: l_contact_list HZ_PARTY_SEARCH.contact_list;
4975: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4976: contact_point_ids HZ_PARTY_SEARCH.IDList;
4977: p_party_site_list HZ_PARTY_SEARCH.IDList;
4978: p_contact_ids HZ_PARTY_SEARCH.IDList;
4979: l_match_idx NUMBER;
4980: cursor get_cpt_for_contact_id is select contact_point_id
4981: from hz_org_contacts a, hz_relationships b, hz_contact_points c
4974: l_contact_list HZ_PARTY_SEARCH.contact_list;
4975: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
4976: contact_point_ids HZ_PARTY_SEARCH.IDList;
4977: p_party_site_list HZ_PARTY_SEARCH.IDList;
4978: p_contact_ids HZ_PARTY_SEARCH.IDList;
4979: l_match_idx NUMBER;
4980: cursor get_cpt_for_contact_id is select contact_point_id
4981: from hz_org_contacts a, hz_relationships b, hz_contact_points c
4982: where a.party_relationship_id = b.relationship_id
5005: CLOSE get_cpt_for_contact_id;
5006:
5007: get_search_criteria (
5008: null,
5009: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
5010: p_contact_ids,
5011: contact_point_ids,
5012: l_party_search_rec,
5013: l_party_site_list,
5056: p_match_type IN VARCHAR2,
5057: x_search_ctx_id OUT NUMBER,
5058: x_num_matches OUT NUMBER
5059: ) IS
5060: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
5061: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
5062: l_contact_list HZ_PARTY_SEARCH.contact_list;
5063: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
5064: contact_point_ids HZ_PARTY_SEARCH.IDList;
5057: x_search_ctx_id OUT NUMBER,
5058: x_num_matches OUT NUMBER
5059: ) IS
5060: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
5061: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
5062: l_contact_list HZ_PARTY_SEARCH.contact_list;
5063: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
5064: contact_point_ids HZ_PARTY_SEARCH.IDList;
5065: p_party_site_list HZ_PARTY_SEARCH.IDList;
5058: x_num_matches OUT NUMBER
5059: ) IS
5060: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
5061: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
5062: l_contact_list HZ_PARTY_SEARCH.contact_list;
5063: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
5064: contact_point_ids HZ_PARTY_SEARCH.IDList;
5065: p_party_site_list HZ_PARTY_SEARCH.IDList;
5066: p_contact_ids HZ_PARTY_SEARCH.IDList;
5059: ) IS
5060: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
5061: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
5062: l_contact_list HZ_PARTY_SEARCH.contact_list;
5063: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
5064: contact_point_ids HZ_PARTY_SEARCH.IDList;
5065: p_party_site_list HZ_PARTY_SEARCH.IDList;
5066: p_contact_ids HZ_PARTY_SEARCH.IDList;
5067: l_match_idx NUMBER;
5060: l_party_search_rec HZ_PARTY_SEARCH.party_search_rec_type;
5061: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
5062: l_contact_list HZ_PARTY_SEARCH.contact_list;
5063: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
5064: contact_point_ids HZ_PARTY_SEARCH.IDList;
5065: p_party_site_list HZ_PARTY_SEARCH.IDList;
5066: p_contact_ids HZ_PARTY_SEARCH.IDList;
5067: l_match_idx NUMBER;
5068:
5061: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
5062: l_contact_list HZ_PARTY_SEARCH.contact_list;
5063: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
5064: contact_point_ids HZ_PARTY_SEARCH.IDList;
5065: p_party_site_list HZ_PARTY_SEARCH.IDList;
5066: p_contact_ids HZ_PARTY_SEARCH.IDList;
5067: l_match_idx NUMBER;
5068:
5069: BEGIN
5062: l_contact_list HZ_PARTY_SEARCH.contact_list;
5063: l_contact_point_list HZ_PARTY_SEARCH.contact_point_list;
5064: contact_point_ids HZ_PARTY_SEARCH.IDList;
5065: p_party_site_list HZ_PARTY_SEARCH.IDList;
5066: p_contact_ids HZ_PARTY_SEARCH.IDList;
5067: l_match_idx NUMBER;
5068:
5069: BEGIN
5070: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5079: END IF;
5080: contact_point_ids(1) := p_contact_point_id;
5081: get_search_criteria (
5082: null,
5083: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
5084: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
5085: contact_point_ids,
5086: l_party_search_rec,
5087: l_party_site_list,
5080: contact_point_ids(1) := p_contact_point_id;
5081: get_search_criteria (
5082: null,
5083: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
5084: HZ_PARTY_SEARCH.G_MISS_ID_LIST,
5085: contact_point_ids,
5086: l_party_search_rec,
5087: l_party_site_list,
5088: l_contact_list,
5233: ) IS
5234: TYPE AttrList IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
5235: l_match_idx NUMBER;
5236: AttrVals AttrList;
5237: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
5238: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
5239: l_contact_list HZ_PARTY_SEARCH.contact_list;
5240: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
5241: l_dup_set_id NUMBER;
5234: TYPE AttrList IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
5235: l_match_idx NUMBER;
5236: AttrVals AttrList;
5237: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
5238: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
5239: l_contact_list HZ_PARTY_SEARCH.contact_list;
5240: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
5241: l_dup_set_id NUMBER;
5242: l_idx NUMBER;
5235: l_match_idx NUMBER;
5236: AttrVals AttrList;
5237: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
5238: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
5239: l_contact_list HZ_PARTY_SEARCH.contact_list;
5240: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
5241: l_dup_set_id NUMBER;
5242: l_idx NUMBER;
5243: l_cpt_type VARCHAR2(255);
5236: AttrVals AttrList;
5237: l_party_rec HZ_PARTY_SEARCH.party_search_rec_type;
5238: l_party_site_list HZ_PARTY_SEARCH.party_site_list;
5239: l_contact_list HZ_PARTY_SEARCH.contact_list;
5240: l_cpt_list HZ_PARTY_SEARCH.contact_point_list;
5241: l_dup_set_id NUMBER;
5242: l_idx NUMBER;
5243: l_cpt_type VARCHAR2(255);
5244: FIRST BOOLEAN := TRUE;
5495:
5496: PROCEDURE get_matching_party_sites (
5497: p_rule_id IN NUMBER,
5498: p_party_id IN NUMBER,
5499: p_party_site_list IN HZ_PARTY_SEARCH.PARTY_SITE_LIST,
5500: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
5501: p_restrict_sql IN VARCHAR2,
5502: p_match_type IN VARCHAR2,
5503: p_dup_party_site_id IN NUMBER,
5496: PROCEDURE get_matching_party_sites (
5497: p_rule_id IN NUMBER,
5498: p_party_id IN NUMBER,
5499: p_party_site_list IN HZ_PARTY_SEARCH.PARTY_SITE_LIST,
5500: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
5501: p_restrict_sql IN VARCHAR2,
5502: p_match_type IN VARCHAR2,
5503: p_dup_party_site_id IN NUMBER,
5504: x_search_ctx_id OUT NUMBER,
5532: l_TX11 VARCHAR2(2000);
5533: l_TX5 VARCHAR2(2000);
5534: l_TX14 VARCHAR2(2000);
5535: l_TX6 VARCHAR2(2000);
5536: H_SCORES HZ_PARTY_SEARCH.score_list;
5537:
5538: l_score NUMBER;
5539: l_idx NUMBER;
5540: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
5563: defps NUMBER :=0;
5564: defct NUMBER :=0;
5565: defcpt NUMBER :=0;
5566: l_index NUMBER;
5567: l_match_ps_list HZ_PARTY_SEARCH.IDList;
5568: l_cnt NUMBER:=1;
5569:
5570:
5571: BEGIN
5587: l_match_str := ' AND ';
5588: ELSIF p_match_type = 'OR' THEN
5589: l_match_str := ' OR ';
5590: END IF;
5591: 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);
5592: g_score_until_thresh := false;
5593: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
5594:
5595: -- ************************************************************
5595: -- ************************************************************
5596: -- STEP 2. Setup of intermedia query strings for Acquisition query
5597: l_party_site_contains_str := INIT_PARTY_SITES_QUERY(l_match_str,l_tmp);
5598: l_contact_pt_contains_str := INIT_CONTACT_POINTS_QUERY(l_match_str,l_tmp);
5599: 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);
5600:
5601: -- Setup Search Context ID
5602: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;
5603: x_search_ctx_id := l_search_ctx_id;
5738:
5739: PROCEDURE get_matching_contacts (
5740: p_rule_id IN NUMBER,
5741: p_party_id IN NUMBER,
5742: p_contact_list IN HZ_PARTY_SEARCH.CONTACT_LIST,
5743: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
5744: p_restrict_sql IN VARCHAR2,
5745: p_match_type IN VARCHAR2,
5746: p_dup_contact_id IN NUMBER,
5739: PROCEDURE get_matching_contacts (
5740: p_rule_id IN NUMBER,
5741: p_party_id IN NUMBER,
5742: p_contact_list IN HZ_PARTY_SEARCH.CONTACT_LIST,
5743: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
5744: p_restrict_sql IN VARCHAR2,
5745: p_match_type IN VARCHAR2,
5746: p_dup_contact_id IN NUMBER,
5747: x_search_ctx_id OUT NUMBER,
5769: l_TX1 VARCHAR2(2000);
5770: l_TX5 VARCHAR2(2000);
5771: l_TX156 VARCHAR2(2000);
5772: l_TX6 VARCHAR2(2000);
5773: H_SCORES HZ_PARTY_SEARCH.score_list;
5774:
5775: l_score NUMBER;
5776: l_idx NUMBER;
5777: l_party_cur HZ_PARTY_STAGE.StageCurTyp;
5797: l_party_max_score NUMBER;
5798: l_ps_max_score NUMBER;
5799: l_contact_max_score NUMBER;
5800: l_cpt_max_score NUMBER;
5801: l_match_contact_list HZ_PARTY_SEARCH.IDList;
5802: l_cnt NUMBER:=1;
5803:
5804:
5805: BEGIN
5821: l_match_str := ' AND ';
5822: ELSIF p_match_type = 'OR' THEN
5823: l_match_str := ' OR ';
5824: END IF;
5825: 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);
5826: g_score_until_thresh := false;
5827: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
5828:
5829: -- ************************************************************
5829: -- ************************************************************
5830: -- STEP 2. Setup of intermedia query strings for Acquisition query
5831: l_contact_contains_str := INIT_CONTACTS_QUERY(l_match_str,l_tmp);
5832: l_contact_pt_contains_str := INIT_CONTACT_POINTS_QUERY(l_match_str,l_tmp);
5833: 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);
5834:
5835: -- Setup Search Context ID
5836: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;
5837: x_search_ctx_id := l_search_ctx_id;
5968:
5969: PROCEDURE get_matching_contact_points (
5970: p_rule_id IN NUMBER,
5971: p_party_id IN NUMBER,
5972: p_contact_point_list IN HZ_PARTY_SEARCH.CONTACT_POINT_LIST,
5973: p_restrict_sql IN VARCHAR2,
5974: p_match_type IN VARCHAR2,
5975: p_dup_contact_point_id IN NUMBER,
5976: x_search_ctx_id OUT NUMBER,
6000: l_cpt_ps_id NUMBER;
6001: l_cpt_contact_id NUMBER;
6002: l_contact_pt_id NUMBER;
6003: l_cpt_type VARCHAR2(100);
6004: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
6005: H_CONTACT_POINT_ID HZ_PARTY_SEARCH.IDList;
6006: H_SCORE HZ_PARTY_SEARCH.IDList;
6007:
6008: cnt NUMBER :=0;
6001: l_cpt_contact_id NUMBER;
6002: l_contact_pt_id NUMBER;
6003: l_cpt_type VARCHAR2(100);
6004: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
6005: H_CONTACT_POINT_ID HZ_PARTY_SEARCH.IDList;
6006: H_SCORE HZ_PARTY_SEARCH.IDList;
6007:
6008: cnt NUMBER :=0;
6009: l_party_max_score NUMBER;
6002: l_contact_pt_id NUMBER;
6003: l_cpt_type VARCHAR2(100);
6004: H_PARTY_ID HZ_PARTY_SEARCH.IDList;
6005: H_CONTACT_POINT_ID HZ_PARTY_SEARCH.IDList;
6006: H_SCORE HZ_PARTY_SEARCH.IDList;
6007:
6008: cnt NUMBER :=0;
6009: l_party_max_score NUMBER;
6010: l_ps_max_score NUMBER;
6031: l_match_str := ' AND ';
6032: ELSIF p_match_type = 'OR' THEN
6033: l_match_str := ' OR ';
6034: END IF;
6035: l_entered_max_score:= init_search(HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
6036: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST, HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
6037: p_contact_point_list,l_match_str, l_party_max_score, l_ps_max_score, l_contact_max_score, l_cpt_max_score);
6038: g_score_until_thresh := false;
6039: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
6032: ELSIF p_match_type = 'OR' THEN
6033: l_match_str := ' OR ';
6034: END IF;
6035: l_entered_max_score:= init_search(HZ_PARTY_SEARCH.G_MISS_PARTY_SEARCH_REC,
6036: HZ_PARTY_SEARCH.G_MISS_PARTY_SITE_LIST, HZ_PARTY_SEARCH.G_MISS_CONTACT_LIST,
6037: p_contact_point_list,l_match_str, l_party_max_score, l_ps_max_score, l_contact_max_score, l_cpt_max_score);
6038: g_score_until_thresh := false;
6039: IF l_entered_max_score = 0 THEN l_entered_max_score:=1; END IF;
6040:
6040:
6041: -- ************************************************************
6042: -- STEP 2. Setup of intermedia query strings for Acquisition query
6043: l_contact_pt_contains_str := INIT_CONTACT_POINTS_QUERY(l_match_str,l_tmp);
6044: 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);
6045:
6046: -- Setup Search Context ID
6047: SELECT hz_search_ctx_s.nextval INTO l_search_ctx_id FROM dual;
6048: x_search_ctx_id := l_search_ctx_id;
6115:
6116: PROCEDURE get_score_details (
6117: p_rule_id IN NUMBER,
6118: p_party_id IN NUMBER,
6119: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
6120: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
6121: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
6122: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
6123: x_search_ctx_id IN OUT NUMBER
6116: PROCEDURE get_score_details (
6117: p_rule_id IN NUMBER,
6118: p_party_id IN NUMBER,
6119: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
6120: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
6121: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
6122: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
6123: x_search_ctx_id IN OUT NUMBER
6124: ) IS
6117: p_rule_id IN NUMBER,
6118: p_party_id IN NUMBER,
6119: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
6120: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
6121: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
6122: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
6123: x_search_ctx_id IN OUT NUMBER
6124: ) IS
6125:
6118: p_party_id IN NUMBER,
6119: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
6120: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
6121: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
6122: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
6123: x_search_ctx_id IN OUT NUMBER
6124: ) IS
6125:
6126: -- Strings to hold the generated Intermedia query strings
6179: l_TX14 VARCHAR2(2000);
6180: l_max_TX14 VARCHAR2(2000);
6181: l_TX6 VARCHAR2(2000);
6182: l_max_TX6 VARCHAR2(2000);
6183: H_SCORES HZ_PARTY_SEARCH.score_list;
6184:
6185: l_score NUMBER;
6186: l_match_idx NUMBER;
6187: l_idx NUMBER;
6360: ************************************************/
6361:
6362: PROCEDURE get_party_for_search (
6363: p_party_id IN NUMBER,
6364: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
6365: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
6366: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
6367: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
6368: ) IS
6361:
6362: PROCEDURE get_party_for_search (
6363: p_party_id IN NUMBER,
6364: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
6365: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
6366: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
6367: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
6368: ) IS
6369: l_party_id NUMBER;
6362: PROCEDURE get_party_for_search (
6363: p_party_id IN NUMBER,
6364: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
6365: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
6366: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
6367: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
6368: ) IS
6369: l_party_id NUMBER;
6370: l_party_site_ids HZ_PARTY_SEARCH.IDList;
6363: p_party_id IN NUMBER,
6364: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
6365: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
6366: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
6367: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
6368: ) IS
6369: l_party_id NUMBER;
6370: l_party_site_ids HZ_PARTY_SEARCH.IDList;
6371: l_contact_ids HZ_PARTY_SEARCH.IDList;
6366: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
6367: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
6368: ) IS
6369: l_party_id NUMBER;
6370: l_party_site_ids HZ_PARTY_SEARCH.IDList;
6371: l_contact_ids HZ_PARTY_SEARCH.IDList;
6372: l_contact_pt_ids HZ_PARTY_SEARCH.IDList;
6373: ps NUMBER :=1;
6374: cpt NUMBER :=1;
6367: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
6368: ) IS
6369: l_party_id NUMBER;
6370: l_party_site_ids HZ_PARTY_SEARCH.IDList;
6371: l_contact_ids HZ_PARTY_SEARCH.IDList;
6372: l_contact_pt_ids HZ_PARTY_SEARCH.IDList;
6373: ps NUMBER :=1;
6374: cpt NUMBER :=1;
6375: ct NUMBER :=1;
6368: ) IS
6369: l_party_id NUMBER;
6370: l_party_site_ids HZ_PARTY_SEARCH.IDList;
6371: l_contact_ids HZ_PARTY_SEARCH.IDList;
6372: l_contact_pt_ids HZ_PARTY_SEARCH.IDList;
6373: ps NUMBER :=1;
6374: cpt NUMBER :=1;
6375: ct NUMBER :=1;
6376: l_use_contact_info varchar2(1);
6477: END get_party_for_search;
6478:
6479: PROCEDURE get_search_criteria (
6480: p_party_id IN NUMBER,
6481: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
6482: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
6483: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
6484: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
6485: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
6478:
6479: PROCEDURE get_search_criteria (
6480: p_party_id IN NUMBER,
6481: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
6482: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
6483: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
6484: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
6485: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
6486: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
6479: PROCEDURE get_search_criteria (
6480: p_party_id IN NUMBER,
6481: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
6482: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
6483: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
6484: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
6485: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
6486: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
6487: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
6480: p_party_id IN NUMBER,
6481: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
6482: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
6483: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
6484: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
6485: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
6486: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
6487: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
6488: ) IS
6481: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
6482: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
6483: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
6484: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
6485: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
6486: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
6487: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
6488: ) IS
6489: BEGIN
6482: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
6483: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
6484: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
6485: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
6486: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
6487: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
6488: ) IS
6489: BEGIN
6490:
6483: p_contact_pt_ids IN HZ_PARTY_SEARCH.IDList,
6484: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type,
6485: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list,
6486: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list,
6487: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
6488: ) IS
6489: BEGIN
6490:
6491: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6535: ************************************************/
6536:
6537: PROCEDURE get_party_rec (
6538: p_party_id IN NUMBER,
6539: x_party_search_rec OUT NOCOPY HZ_PARTY_SEARCH.party_search_rec_type
6540: ) IS
6541: l_party_type VARCHAR2(255);
6542: BEGIN
6543:
6608: the party site search record structure
6609: ************************************************/
6610:
6611: PROCEDURE get_party_site_rec (
6612: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
6613: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
6614: ) IS
6615: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
6616: SELECT party_site_id
6609: ************************************************/
6610:
6611: PROCEDURE get_party_site_rec (
6612: p_party_site_ids IN HZ_PARTY_SEARCH.IDList,
6613: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
6614: ) IS
6615: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
6616: SELECT party_site_id
6617: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6670: the contact search record structure
6671: ************************************************/
6672:
6673: PROCEDURE get_contact_rec (
6674: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
6675: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
6676: ) IS
6677: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
6678: SELECT org_contact_id
6671: ************************************************/
6672:
6673: PROCEDURE get_contact_rec (
6674: p_contact_ids IN HZ_PARTY_SEARCH.IDList,
6675: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
6676: ) IS
6677: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
6678: SELECT org_contact_id
6679: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
6728: the contact point search record structure
6729: ************************************************/
6730:
6731: PROCEDURE get_contact_point_rec (
6732: p_contact_point_ids IN HZ_PARTY_SEARCH.IDList,
6733: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
6734: ) IS
6735:
6736: -- Cursor to fetch primary contact points for party
6729: ************************************************/
6730:
6731: PROCEDURE get_contact_point_rec (
6732: p_contact_point_ids IN HZ_PARTY_SEARCH.IDList,
6733: x_contact_point_list OUT NOCOPY HZ_PARTY_SEARCH.contact_point_list
6734: ) IS
6735:
6736: -- Cursor to fetch primary contact points for party
6737: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
6787: ************************************************/
6788:
6789: PROCEDURE MAP_PARTY_REC(
6790: p_search_ctx IN BOOLEAN,
6791: p_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
6792: x_entered_max_score OUT NUMBER,
6793: x_stage_rec IN OUT NOCOPY HZ_PARTY_STAGE.party_stage_rec_type
6794: ) IS
6795: tmp VARCHAR2(4000);
7001: ************************************************/
7002:
7003: PROCEDURE MAP_PARTY_SITE_REC(
7004: p_search_ctx IN BOOLEAN,
7005: p_search_list IN HZ_PARTY_SEARCH.party_site_list,
7006: x_entered_max_score OUT NUMBER,
7007: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.party_site_stage_list
7008: ) IS
7009: l_current_max_score NUMBER;
7213: ************************************************/
7214:
7215: PROCEDURE MAP_CONTACT_REC(
7216: p_search_ctx IN BOOLEAN,
7217: p_search_list IN HZ_PARTY_SEARCH.contact_list,
7218: x_entered_max_score OUT NUMBER,
7219: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_stage_list
7220: ) IS
7221: l_current_max_score NUMBER;
7329: ************************************************/
7330:
7331: PROCEDURE MAP_CONTACT_POINT_REC(
7332: p_search_ctx IN BOOLEAN,
7333: p_search_list IN HZ_PARTY_SEARCH.contact_point_list,
7334: x_entered_max_score OUT NUMBER,
7335: x_stage_list IN OUT NOCOPY HZ_PARTY_STAGE.contact_pt_stage_list
7336: ) IS
7337: l_current_max_score NUMBER;
7459: 2. Contact Point Type is not null for each condition
7460: ************************************************/
7461:
7462: FUNCTION check_prim_cond(
7463: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
7464: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
7465: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
7466: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)
7467: RETURN BOOLEAN IS
7460: ************************************************/
7461:
7462: FUNCTION check_prim_cond(
7463: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
7464: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
7465: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
7466: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)
7467: RETURN BOOLEAN IS
7468: BEGIN
7461:
7462: FUNCTION check_prim_cond(
7463: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
7464: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
7465: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
7466: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)
7467: RETURN BOOLEAN IS
7468: BEGIN
7469: FOR I IN 1..p_contact_point_list.COUNT LOOP
7462: FUNCTION check_prim_cond(
7463: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type,
7464: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
7465: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
7466: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list)
7467: RETURN BOOLEAN IS
7468: BEGIN
7469: FOR I IN 1..p_contact_point_list.COUNT LOOP
7470: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
7552: has party site criteria.
7553: ************************************************/
7554:
7555: PROCEDURE check_party_site_cond(
7556: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
7557: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
7558: x_secondary OUT BOOLEAN,
7559: x_primary OUT BOOLEAN
7560: ) IS
7553: ************************************************/
7554:
7555: PROCEDURE check_party_site_cond(
7556: p_party_site_list IN HZ_PARTY_SEARCH.party_site_list,
7557: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
7558: x_secondary OUT BOOLEAN,
7559: x_primary OUT BOOLEAN
7560: ) IS
7561: BEGIN
7614: has contact criteria.
7615: ************************************************/
7616:
7617: PROCEDURE check_contact_cond(
7618: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
7619: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
7620: x_secondary OUT BOOLEAN,
7621: x_primary OUT BOOLEAN
7622: ) IS
7615: ************************************************/
7616:
7617: PROCEDURE check_contact_cond(
7618: p_contact_list IN HZ_PARTY_SEARCH.contact_list,
7619: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
7620: x_secondary OUT BOOLEAN,
7621: x_primary OUT BOOLEAN
7622: ) IS
7623: BEGIN
7670: has valid contact point criteria.
7671: ************************************************/
7672:
7673: PROCEDURE check_contact_point_cond(
7674: p_contact_point_list IN HZ_PARTY_SEARCH.contact_point_list,
7675: x_secondary OUT BOOLEAN,
7676: x_primary OUT BOOLEAN
7677: ) IS
7678: BEGIN