APPS.HZ_MATCH_RULE_3 dependencies on HZ_TRANS_PKG

Line 580: HZ_TRANS_PKG.clear_globals;

576: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
577: hz_utility_v2pub.debug(p_message=>'In init_score_context calling the Map procedures',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
578: END IF;
579: -- Transform search criteria
580: HZ_TRANS_PKG.clear_globals;
581: MAP_PARTY_REC(FALSE,p_party_search_rec, l_dummy, g_party_stage_rec);
582: MAP_PARTY_SITE_REC(FALSE,p_party_site_list, l_dummy, g_party_site_stage_list);
583: MAP_CONTACT_REC(FALSE,p_contact_list, l_dummy, g_contact_stage_list);
584: MAP_CONTACT_POINT_REC(FALSE,p_contact_point_list, l_dummy, g_contact_pt_stage_list);

Line 637: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);

633: g_contact_pt_stage_list.DELETE;
634: call_order.DELETE;
635: call_max_score.DELETE;
636: HZ_DQM_SEARCH_UTIL.new_search;
637: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
638: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
639:
640: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
641: hz_utility_v2pub.debug(p_message=>'In init_search calling the Map procedures',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 2925: HZ_TRANS_PKG.EXACT(

2921: /********************* Find Parties private procedures *******/
2922: PROCEDURE set_person_party_type IS
2923: BEGIN
2924: g_party_stage_rec.TX36:=
2925: HZ_TRANS_PKG.EXACT(
2926: 'PERSON'
2927: ,null,'PARTY_TYPE'
2928: ,'PARTY');
2929: END;

Line 5524: HZ_TRANS_PKG.EXACT(

5520: END IF;
5521: END IF;
5522: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
5523: x_stage_rec.TX36 :=
5524: HZ_TRANS_PKG.EXACT(
5525: p_search_rec.PARTY_TYPE
5526: ,null,'PARTY_TYPE'
5527: ,'PARTY');
5528: ELSE

Line 5534: HZ_TRANS_PKG.RM_SPLCHAR(

5530: END IF;
5531: IF p_search_ctx THEN
5532: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
5533: x_stage_rec.TX44 :=
5534: HZ_TRANS_PKG.RM_SPLCHAR(
5535: p_search_rec.TAX_REFERENCE
5536: ,null,'TAX_REFERENCE'
5537: ,'PARTY','SDIB');
5538: ELSE

Line 5543: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

5539: x_stage_rec.TX44 := '';
5540: END IF;
5541: ELSE
5542: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
5543: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
5544: x_stage_rec.TX44
5545: ,null,'TAX_REFERENCE'
5546: ,'PARTY','SCORE');
5547: IF tmp IS NOT NULL THEN

Line 5557: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SDIB');

5553: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
5554: l_party_name := p_search_rec.PARTY_ALL_NAMES;
5555: END IF;
5556: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
5557: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SDIB');
5558: END IF;
5559: EXCEPTION
5560: WHEN OTHERS THEN
5561: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 5696: HZ_TRANS_PKG.CLEANSED_EMAIL(

5692: FOR I IN 1..p_search_list.COUNT LOOP
5693: IF p_search_ctx THEN
5694: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
5695: x_stage_list(I).TX6 :=
5696: HZ_TRANS_PKG.CLEANSED_EMAIL(
5697: p_search_list(I).EMAIL_ADDRESS
5698: ,null,'EMAIL_ADDRESS'
5699: ,'CONTACT_POINTS','SDIB');
5700: ELSE

Line 5705: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(

5701: x_stage_list(I).TX6 := '';
5702: END IF;
5703: ELSE
5704: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
5705: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(
5706: x_stage_list(I).TX6
5707: ,null,'EMAIL_ADDRESS'
5708: ,'CONTACT_POINTS','SCORE');
5709: IF tmp IS NOT NULL THEN

Line 5719: HZ_TRANS_PKG.EXACT_EMAIL(

5715: FOR I IN 1..p_search_list.COUNT LOOP
5716: IF p_search_ctx THEN
5717: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
5718: x_stage_list(I).TX5 :=
5719: HZ_TRANS_PKG.EXACT_EMAIL(
5720: p_search_list(I).EMAIL_ADDRESS
5721: ,null,'EMAIL_ADDRESS'
5722: ,'CONTACT_POINTS');
5723: ELSE

Line 5732: HZ_TRANS_PKG.RM_SPLCHAR_CTX(

5728: FOR I IN 1..p_search_list.COUNT LOOP
5729: IF p_search_ctx THEN
5730: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
5731: x_stage_list(I).TX1 :=
5732: HZ_TRANS_PKG.RM_SPLCHAR_CTX(
5733: p_search_list(I).FLEX_FORMAT_PHONE_NUMBER
5734: ,null,'FLEX_FORMAT_PHONE_NUMBER'
5735: ,'CONTACT_POINTS','SDIB');
5736: ELSE

Line 5741: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(

5737: x_stage_list(I).TX1 := '';
5738: END IF;
5739: ELSE
5740: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
5741: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(
5742: x_stage_list(I).TX1
5743: ,null,'FLEX_FORMAT_PHONE_NUMBER'
5744: ,'CONTACT_POINTS','SCORE');
5745: IF tmp IS NOT NULL THEN