DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_4 dependencies on HZ_TRANS_PKG

Line 676: HZ_TRANS_PKG.clear_globals;

672: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
673: 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);
674: END IF;
675: -- Transform search criteria
676: HZ_TRANS_PKG.clear_globals;
677: MAP_PARTY_REC(FALSE,p_party_search_rec, l_dummy, g_party_stage_rec);
678: MAP_PARTY_SITE_REC(FALSE,p_party_site_list, l_dummy, g_party_site_stage_list);
679: MAP_CONTACT_REC(FALSE,p_contact_list, l_dummy, g_contact_stage_list);
680: MAP_CONTACT_POINT_REC(FALSE,p_contact_point_list, l_dummy, g_contact_pt_stage_list);

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

729: g_contact_pt_stage_list.DELETE;
730: call_order.DELETE;
731: call_max_score.DELETE;
732: HZ_DQM_SEARCH_UTIL.new_search;
733: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
734: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
735:
736: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
737: 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 3018: HZ_TRANS_PKG.EXACT(

3014: /********************* Find Parties private procedures *******/
3015: PROCEDURE set_person_party_type IS
3016: BEGIN
3017: g_party_stage_rec.TX36:=
3018: HZ_TRANS_PKG.EXACT(
3019: 'PERSON'
3020: ,null,'PARTY_TYPE'
3021: ,'PARTY');
3022: END;

Line 5605: HZ_TRANS_PKG.EXACT(

5601: END IF;
5602: IF p_search_ctx THEN
5603: IF p_search_rec.DUNS_NUMBER_C IS NOT NULL THEN
5604: x_stage_rec.TX41 :=
5605: HZ_TRANS_PKG.EXACT(
5606: p_search_rec.DUNS_NUMBER_C
5607: ,null,'DUNS_NUMBER_C'
5608: ,'PARTY');
5609: ELSE

Line 5620: HZ_TRANS_PKG.EXACT_PADDED(

5616: END IF;
5617: IF p_search_ctx THEN
5618: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5619: x_stage_rec.TX2 :=
5620: HZ_TRANS_PKG.EXACT_PADDED(
5621: p_search_rec.PARTY_NAME
5622: ,null,'PARTY_NAME'
5623: ,'PARTY');
5624: ELSE

Line 5631: HZ_TRANS_PKG.WRNAMES_CLEANSE(

5627: END IF;
5628: IF p_search_ctx THEN
5629: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5630: x_stage_rec.TX4 :=
5631: HZ_TRANS_PKG.WRNAMES_CLEANSE(
5632: p_search_rec.PARTY_NAME
5633: ,null,'PARTY_NAME'
5634: ,'PARTY','SDIB');
5635: ELSE

Line 5640: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

5636: x_stage_rec.TX4 := '';
5637: END IF;
5638: ELSE
5639: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5640: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
5641: x_stage_rec.TX4
5642: ,null,'PARTY_NAME'
5643: ,'PARTY','SCORE');
5644: IF tmp IS NOT NULL THEN

Line 5652: HZ_TRANS_PKG.WRNAMES_EXACT(

5648: END IF;
5649: IF p_search_ctx THEN
5650: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5651: x_stage_rec.TX8 :=
5652: HZ_TRANS_PKG.WRNAMES_EXACT(
5653: p_search_rec.PARTY_NAME
5654: ,null,'PARTY_NAME'
5655: ,'PARTY','SDIB');
5656: ELSE

Line 5661: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

5657: x_stage_rec.TX8 := '';
5658: END IF;
5659: ELSE
5660: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5661: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
5662: x_stage_rec.TX8
5663: ,null,'PARTY_NAME'
5664: ,'PARTY','SCORE');
5665: IF tmp IS NOT NULL THEN

Line 5672: HZ_TRANS_PKG.EXACT(

5668: END IF;
5669: END IF;
5670: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
5671: x_stage_rec.TX36 :=
5672: HZ_TRANS_PKG.EXACT(
5673: p_search_rec.PARTY_TYPE
5674: ,null,'PARTY_TYPE'
5675: ,'PARTY');
5676: ELSE

Line 5682: HZ_TRANS_PKG.RM_SPLCHAR(

5678: END IF;
5679: IF p_search_ctx THEN
5680: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
5681: x_stage_rec.TX44 :=
5682: HZ_TRANS_PKG.RM_SPLCHAR(
5683: p_search_rec.TAX_REFERENCE
5684: ,null,'TAX_REFERENCE'
5685: ,'PARTY','SDIB');
5686: ELSE

Line 5691: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

5687: x_stage_rec.TX44 := '';
5688: END IF;
5689: ELSE
5690: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
5691: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
5692: x_stage_rec.TX44
5693: ,null,'TAX_REFERENCE'
5694: ,'PARTY','SCORE');
5695: IF tmp IS NOT NULL THEN

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

5701: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
5702: l_party_name := p_search_rec.PARTY_ALL_NAMES;
5703: END IF;
5704: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
5705: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SDIB');
5706: END IF;
5707: EXCEPTION
5708: WHEN OTHERS THEN
5709: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 5757: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

5753: FOR I IN 1..p_search_list.COUNT LOOP
5754: IF p_search_ctx THEN
5755: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5756: x_stage_list(I).TX4 :=
5757: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
5758: p_search_list(I).ADDRESS
5759: ,null,'ADDRESS'
5760: ,'PARTY_SITES','SDIB');
5761: ELSE

Line 5766: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

5762: x_stage_list(I).TX4 := '';
5763: END IF;
5764: ELSE
5765: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5766: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
5767: x_stage_list(I).TX4
5768: ,null,'ADDRESS'
5769: ,'PARTY_SITES','SCORE');
5770: IF tmp IS NOT NULL THEN

Line 5780: HZ_TRANS_PKG.WRADDRESS_EXACT(

5776: FOR I IN 1..p_search_list.COUNT LOOP
5777: IF p_search_ctx THEN
5778: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5779: x_stage_list(I).TX3 :=
5780: HZ_TRANS_PKG.WRADDRESS_EXACT(
5781: p_search_list(I).ADDRESS
5782: ,null,'ADDRESS'
5783: ,'PARTY_SITES','SDIB');
5784: ELSE

Line 5789: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

5785: x_stage_list(I).TX3 := '';
5786: END IF;
5787: ELSE
5788: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5789: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(
5790: x_stage_list(I).TX3
5791: ,null,'ADDRESS'
5792: ,'PARTY_SITES','SCORE');
5793: IF tmp IS NOT NULL THEN

Line 5803: HZ_TRANS_PKG.RM_SPLCHAR(

5799: FOR I IN 1..p_search_list.COUNT LOOP
5800: IF p_search_ctx THEN
5801: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
5802: x_stage_list(I).TX11 :=
5803: HZ_TRANS_PKG.RM_SPLCHAR(
5804: p_search_list(I).POSTAL_CODE
5805: ,null,'POSTAL_CODE'
5806: ,'PARTY_SITES','SDIB');
5807: ELSE

Line 5812: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

5808: x_stage_list(I).TX11 := '';
5809: END IF;
5810: ELSE
5811: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
5812: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
5813: x_stage_list(I).TX11
5814: ,null,'POSTAL_CODE'
5815: ,'PARTY_SITES','SCORE');
5816: IF tmp IS NOT NULL THEN