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

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

Line 5460: HZ_TRANS_PKG.EXACT_PADDED(

5456: END IF;
5457: IF p_search_ctx THEN
5458: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5459: x_stage_rec.TX2 :=
5460: HZ_TRANS_PKG.EXACT_PADDED(
5461: p_search_rec.PARTY_NAME
5462: ,null,'PARTY_NAME'
5463: ,'PARTY');
5464: ELSE

Line 5471: HZ_TRANS_PKG.WRNAMES_CLEANSE(

5467: END IF;
5468: IF p_search_ctx THEN
5469: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5470: x_stage_rec.TX4 :=
5471: HZ_TRANS_PKG.WRNAMES_CLEANSE(
5472: p_search_rec.PARTY_NAME
5473: ,null,'PARTY_NAME'
5474: ,'PARTY','SDIB');
5475: ELSE

Line 5480: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

5476: x_stage_rec.TX4 := '';
5477: END IF;
5478: ELSE
5479: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5480: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
5481: x_stage_rec.TX4
5482: ,null,'PARTY_NAME'
5483: ,'PARTY','SCORE');
5484: IF tmp IS NOT NULL THEN

Line 5492: HZ_TRANS_PKG.WRNAMES_EXACT(

5488: END IF;
5489: IF p_search_ctx THEN
5490: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5491: x_stage_rec.TX8 :=
5492: HZ_TRANS_PKG.WRNAMES_EXACT(
5493: p_search_rec.PARTY_NAME
5494: ,null,'PARTY_NAME'
5495: ,'PARTY','SDIB');
5496: ELSE

Line 5501: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

5497: x_stage_rec.TX8 := '';
5498: END IF;
5499: ELSE
5500: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5501: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
5502: x_stage_rec.TX8
5503: ,null,'PARTY_NAME'
5504: ,'PARTY','SCORE');
5505: IF tmp IS NOT NULL THEN

Line 5512: HZ_TRANS_PKG.EXACT(

5508: END IF;
5509: END IF;
5510: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
5511: x_stage_rec.TX36 :=
5512: HZ_TRANS_PKG.EXACT(
5513: p_search_rec.PARTY_TYPE
5514: ,null,'PARTY_TYPE'
5515: ,'PARTY');
5516: ELSE

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

5520: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
5521: l_party_name := p_search_rec.PARTY_ALL_NAMES;
5522: END IF;
5523: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
5524: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SDIB');
5525: END IF;
5526: EXCEPTION
5527: WHEN OTHERS THEN
5528: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 5576: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

5572: FOR I IN 1..p_search_list.COUNT LOOP
5573: IF p_search_ctx THEN
5574: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5575: x_stage_list(I).TX4 :=
5576: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
5577: p_search_list(I).ADDRESS
5578: ,null,'ADDRESS'
5579: ,'PARTY_SITES','SDIB');
5580: ELSE

Line 5585: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

5581: x_stage_list(I).TX4 := '';
5582: END IF;
5583: ELSE
5584: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5585: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
5586: x_stage_list(I).TX4
5587: ,null,'ADDRESS'
5588: ,'PARTY_SITES','SCORE');
5589: IF tmp IS NOT NULL THEN

Line 5599: HZ_TRANS_PKG.WRADDRESS_EXACT(

5595: FOR I IN 1..p_search_list.COUNT LOOP
5596: IF p_search_ctx THEN
5597: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5598: x_stage_list(I).TX3 :=
5599: HZ_TRANS_PKG.WRADDRESS_EXACT(
5600: p_search_list(I).ADDRESS
5601: ,null,'ADDRESS'
5602: ,'PARTY_SITES','SDIB');
5603: ELSE

Line 5608: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

5604: x_stage_list(I).TX3 := '';
5605: END IF;
5606: ELSE
5607: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5608: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(
5609: x_stage_list(I).TX3
5610: ,null,'ADDRESS'
5611: ,'PARTY_SITES','SCORE');
5612: IF tmp IS NOT NULL THEN

Line 5622: HZ_TRANS_PKG.RM_SPLCHAR(

5618: FOR I IN 1..p_search_list.COUNT LOOP
5619: IF p_search_ctx THEN
5620: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
5621: x_stage_list(I).TX11 :=
5622: HZ_TRANS_PKG.RM_SPLCHAR(
5623: p_search_list(I).POSTAL_CODE
5624: ,null,'POSTAL_CODE'
5625: ,'PARTY_SITES','SDIB');
5626: ELSE

Line 5631: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

5627: x_stage_list(I).TX11 := '';
5628: END IF;
5629: ELSE
5630: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
5631: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
5632: x_stage_list(I).TX11
5633: ,null,'POSTAL_CODE'
5634: ,'PARTY_SITES','SCORE');
5635: IF tmp IS NOT NULL THEN