APPS.HZ_MATCH_RULE_5 dependencies on HZ_TRANS_PKG

Line 565: HZ_TRANS_PKG.clear_globals;

561: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
562: 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);
563: END IF;
564: -- Transform search criteria
565: HZ_TRANS_PKG.clear_globals;
566: MAP_PARTY_REC(FALSE,p_party_search_rec, l_dummy, g_party_stage_rec);
567: MAP_PARTY_SITE_REC(FALSE,p_party_site_list, l_dummy, g_party_site_stage_list);
568: MAP_CONTACT_REC(FALSE,p_contact_list, l_dummy, g_contact_stage_list);
569: MAP_CONTACT_POINT_REC(FALSE,p_contact_point_list, l_dummy, g_contact_pt_stage_list);

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

618: g_contact_pt_stage_list.DELETE;
619: call_order.DELETE;
620: call_max_score.DELETE;
621: HZ_DQM_SEARCH_UTIL.new_search;
622: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
623: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
624:
625: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
626: 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 2900: HZ_TRANS_PKG.EXACT(

2896: /********************* Find Parties private procedures *******/
2897: PROCEDURE set_person_party_type IS
2898: BEGIN
2899: g_party_stage_rec.TX36:=
2900: HZ_TRANS_PKG.EXACT(
2901: 'PERSON'
2902: ,null,'PARTY_TYPE'
2903: ,'PARTY');
2904: END;

Line 5455: HZ_TRANS_PKG.EXACT_PADDED(

5451: END IF;
5452: IF p_search_ctx THEN
5453: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5454: x_stage_rec.TX2 :=
5455: HZ_TRANS_PKG.EXACT_PADDED(
5456: p_search_rec.PARTY_NAME
5457: ,null,'PARTY_NAME'
5458: ,'PARTY');
5459: ELSE

Line 5466: HZ_TRANS_PKG.WRNAMES_CLEANSE(

5462: END IF;
5463: IF p_search_ctx THEN
5464: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5465: x_stage_rec.TX4 :=
5466: HZ_TRANS_PKG.WRNAMES_CLEANSE(
5467: p_search_rec.PARTY_NAME
5468: ,null,'PARTY_NAME'
5469: ,'PARTY','SDIB');
5470: ELSE

Line 5475: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

5471: x_stage_rec.TX4 := '';
5472: END IF;
5473: ELSE
5474: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5475: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
5476: x_stage_rec.TX4
5477: ,null,'PARTY_NAME'
5478: ,'PARTY','SCORE');
5479: IF tmp IS NOT NULL THEN

Line 5487: HZ_TRANS_PKG.WRNAMES_EXACT(

5483: END IF;
5484: IF p_search_ctx THEN
5485: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5486: x_stage_rec.TX8 :=
5487: HZ_TRANS_PKG.WRNAMES_EXACT(
5488: p_search_rec.PARTY_NAME
5489: ,null,'PARTY_NAME'
5490: ,'PARTY','SDIB');
5491: ELSE

Line 5496: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

5492: x_stage_rec.TX8 := '';
5493: END IF;
5494: ELSE
5495: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5496: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
5497: x_stage_rec.TX8
5498: ,null,'PARTY_NAME'
5499: ,'PARTY','SCORE');
5500: IF tmp IS NOT NULL THEN

Line 5507: HZ_TRANS_PKG.EXACT(

5503: END IF;
5504: END IF;
5505: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
5506: x_stage_rec.TX36 :=
5507: HZ_TRANS_PKG.EXACT(
5508: p_search_rec.PARTY_TYPE
5509: ,null,'PARTY_TYPE'
5510: ,'PARTY');
5511: ELSE

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

5515: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
5516: l_party_name := p_search_rec.PARTY_ALL_NAMES;
5517: END IF;
5518: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
5519: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SDIB');
5520: END IF;
5521: EXCEPTION
5522: WHEN OTHERS THEN
5523: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 5571: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

5567: FOR I IN 1..p_search_list.COUNT LOOP
5568: IF p_search_ctx THEN
5569: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5570: x_stage_list(I).TX4 :=
5571: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
5572: p_search_list(I).ADDRESS
5573: ,null,'ADDRESS'
5574: ,'PARTY_SITES','SDIB');
5575: ELSE

Line 5580: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

5576: x_stage_list(I).TX4 := '';
5577: END IF;
5578: ELSE
5579: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5580: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
5581: x_stage_list(I).TX4
5582: ,null,'ADDRESS'
5583: ,'PARTY_SITES','SCORE');
5584: IF tmp IS NOT NULL THEN

Line 5594: HZ_TRANS_PKG.WRADDRESS_EXACT(

5590: FOR I IN 1..p_search_list.COUNT LOOP
5591: IF p_search_ctx THEN
5592: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5593: x_stage_list(I).TX3 :=
5594: HZ_TRANS_PKG.WRADDRESS_EXACT(
5595: p_search_list(I).ADDRESS
5596: ,null,'ADDRESS'
5597: ,'PARTY_SITES','SDIB');
5598: ELSE

Line 5603: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

5599: x_stage_list(I).TX3 := '';
5600: END IF;
5601: ELSE
5602: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5603: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(
5604: x_stage_list(I).TX3
5605: ,null,'ADDRESS'
5606: ,'PARTY_SITES','SCORE');
5607: IF tmp IS NOT NULL THEN

Line 5617: HZ_TRANS_PKG.RM_SPLCHAR(

5613: FOR I IN 1..p_search_list.COUNT LOOP
5614: IF p_search_ctx THEN
5615: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
5616: x_stage_list(I).TX11 :=
5617: HZ_TRANS_PKG.RM_SPLCHAR(
5618: p_search_list(I).POSTAL_CODE
5619: ,null,'POSTAL_CODE'
5620: ,'PARTY_SITES','SDIB');
5621: ELSE

Line 5626: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

5622: x_stage_list(I).TX11 := '';
5623: END IF;
5624: ELSE
5625: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
5626: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
5627: x_stage_list(I).TX11
5628: ,null,'POSTAL_CODE'
5629: ,'PARTY_SITES','SCORE');
5630: IF tmp IS NOT NULL THEN