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 2922: HZ_TRANS_PKG.EXACT(

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

Line 5519: HZ_TRANS_PKG.EXACT(

5515: END IF;
5516: END IF;
5517: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
5518: x_stage_rec.TX36 :=
5519: HZ_TRANS_PKG.EXACT(
5520: p_search_rec.PARTY_TYPE
5521: ,null,'PARTY_TYPE'
5522: ,'PARTY');
5523: ELSE

Line 5529: HZ_TRANS_PKG.RM_SPLCHAR(

5525: END IF;
5526: IF p_search_ctx THEN
5527: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
5528: x_stage_rec.TX44 :=
5529: HZ_TRANS_PKG.RM_SPLCHAR(
5530: p_search_rec.TAX_REFERENCE
5531: ,null,'TAX_REFERENCE'
5532: ,'PARTY','SDIB');
5533: ELSE

Line 5538: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

5534: x_stage_rec.TX44 := '';
5535: END IF;
5536: ELSE
5537: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
5538: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
5539: x_stage_rec.TX44
5540: ,null,'TAX_REFERENCE'
5541: ,'PARTY','SCORE');
5542: IF tmp IS NOT NULL THEN

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

5548: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
5549: l_party_name := p_search_rec.PARTY_ALL_NAMES;
5550: END IF;
5551: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
5552: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SDIB');
5553: END IF;
5554: EXCEPTION
5555: WHEN OTHERS THEN
5556: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 5691: HZ_TRANS_PKG.CLEANSED_EMAIL(

5687: FOR I IN 1..p_search_list.COUNT LOOP
5688: IF p_search_ctx THEN
5689: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
5690: x_stage_list(I).TX6 :=
5691: HZ_TRANS_PKG.CLEANSED_EMAIL(
5692: p_search_list(I).EMAIL_ADDRESS
5693: ,null,'EMAIL_ADDRESS'
5694: ,'CONTACT_POINTS','SDIB');
5695: ELSE

Line 5700: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(

5696: x_stage_list(I).TX6 := '';
5697: END IF;
5698: ELSE
5699: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
5700: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(
5701: x_stage_list(I).TX6
5702: ,null,'EMAIL_ADDRESS'
5703: ,'CONTACT_POINTS','SCORE');
5704: IF tmp IS NOT NULL THEN

Line 5714: HZ_TRANS_PKG.EXACT_EMAIL(

5710: FOR I IN 1..p_search_list.COUNT LOOP
5711: IF p_search_ctx THEN
5712: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
5713: x_stage_list(I).TX5 :=
5714: HZ_TRANS_PKG.EXACT_EMAIL(
5715: p_search_list(I).EMAIL_ADDRESS
5716: ,null,'EMAIL_ADDRESS'
5717: ,'CONTACT_POINTS');
5718: ELSE

Line 5727: HZ_TRANS_PKG.RM_SPLCHAR_CTX(

5723: FOR I IN 1..p_search_list.COUNT LOOP
5724: IF p_search_ctx THEN
5725: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
5726: x_stage_list(I).TX1 :=
5727: HZ_TRANS_PKG.RM_SPLCHAR_CTX(
5728: p_search_list(I).FLEX_FORMAT_PHONE_NUMBER
5729: ,null,'FLEX_FORMAT_PHONE_NUMBER'
5730: ,'CONTACT_POINTS','SDIB');
5731: ELSE

Line 5736: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(

5732: x_stage_list(I).TX1 := '';
5733: END IF;
5734: ELSE
5735: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
5736: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(
5737: x_stage_list(I).TX1
5738: ,null,'FLEX_FORMAT_PHONE_NUMBER'
5739: ,'CONTACT_POINTS','SCORE');
5740: IF tmp IS NOT NULL THEN