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

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

Line 5600: HZ_TRANS_PKG.EXACT(

5596: END IF;
5597: IF p_search_ctx THEN
5598: IF p_search_rec.DUNS_NUMBER_C IS NOT NULL THEN
5599: x_stage_rec.TX41 :=
5600: HZ_TRANS_PKG.EXACT(
5601: p_search_rec.DUNS_NUMBER_C
5602: ,null,'DUNS_NUMBER_C'
5603: ,'PARTY');
5604: ELSE

Line 5615: HZ_TRANS_PKG.EXACT_PADDED(

5611: END IF;
5612: IF p_search_ctx THEN
5613: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5614: x_stage_rec.TX2 :=
5615: HZ_TRANS_PKG.EXACT_PADDED(
5616: p_search_rec.PARTY_NAME
5617: ,null,'PARTY_NAME'
5618: ,'PARTY');
5619: ELSE

Line 5626: HZ_TRANS_PKG.WRNAMES_CLEANSE(

5622: END IF;
5623: IF p_search_ctx THEN
5624: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5625: x_stage_rec.TX4 :=
5626: HZ_TRANS_PKG.WRNAMES_CLEANSE(
5627: p_search_rec.PARTY_NAME
5628: ,null,'PARTY_NAME'
5629: ,'PARTY','SDIB');
5630: ELSE

Line 5635: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

5631: x_stage_rec.TX4 := '';
5632: END IF;
5633: ELSE
5634: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5635: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
5636: x_stage_rec.TX4
5637: ,null,'PARTY_NAME'
5638: ,'PARTY','SCORE');
5639: IF tmp IS NOT NULL THEN

Line 5647: HZ_TRANS_PKG.WRNAMES_EXACT(

5643: END IF;
5644: IF p_search_ctx THEN
5645: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5646: x_stage_rec.TX8 :=
5647: HZ_TRANS_PKG.WRNAMES_EXACT(
5648: p_search_rec.PARTY_NAME
5649: ,null,'PARTY_NAME'
5650: ,'PARTY','SDIB');
5651: ELSE

Line 5656: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

5652: x_stage_rec.TX8 := '';
5653: END IF;
5654: ELSE
5655: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5656: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
5657: x_stage_rec.TX8
5658: ,null,'PARTY_NAME'
5659: ,'PARTY','SCORE');
5660: IF tmp IS NOT NULL THEN

Line 5667: HZ_TRANS_PKG.EXACT(

5663: END IF;
5664: END IF;
5665: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
5666: x_stage_rec.TX36 :=
5667: HZ_TRANS_PKG.EXACT(
5668: p_search_rec.PARTY_TYPE
5669: ,null,'PARTY_TYPE'
5670: ,'PARTY');
5671: ELSE

Line 5677: HZ_TRANS_PKG.RM_SPLCHAR(

5673: END IF;
5674: IF p_search_ctx THEN
5675: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
5676: x_stage_rec.TX44 :=
5677: HZ_TRANS_PKG.RM_SPLCHAR(
5678: p_search_rec.TAX_REFERENCE
5679: ,null,'TAX_REFERENCE'
5680: ,'PARTY','SDIB');
5681: ELSE

Line 5686: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

5682: x_stage_rec.TX44 := '';
5683: END IF;
5684: ELSE
5685: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
5686: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
5687: x_stage_rec.TX44
5688: ,null,'TAX_REFERENCE'
5689: ,'PARTY','SCORE');
5690: IF tmp IS NOT NULL THEN

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

5696: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
5697: l_party_name := p_search_rec.PARTY_ALL_NAMES;
5698: END IF;
5699: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
5700: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SDIB');
5701: END IF;
5702: EXCEPTION
5703: WHEN OTHERS THEN
5704: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 5752: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

5748: FOR I IN 1..p_search_list.COUNT LOOP
5749: IF p_search_ctx THEN
5750: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5751: x_stage_list(I).TX4 :=
5752: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
5753: p_search_list(I).ADDRESS
5754: ,null,'ADDRESS'
5755: ,'PARTY_SITES','SDIB');
5756: ELSE

Line 5761: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

5757: x_stage_list(I).TX4 := '';
5758: END IF;
5759: ELSE
5760: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5761: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
5762: x_stage_list(I).TX4
5763: ,null,'ADDRESS'
5764: ,'PARTY_SITES','SCORE');
5765: IF tmp IS NOT NULL THEN

Line 5775: HZ_TRANS_PKG.WRADDRESS_EXACT(

5771: FOR I IN 1..p_search_list.COUNT LOOP
5772: IF p_search_ctx THEN
5773: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5774: x_stage_list(I).TX3 :=
5775: HZ_TRANS_PKG.WRADDRESS_EXACT(
5776: p_search_list(I).ADDRESS
5777: ,null,'ADDRESS'
5778: ,'PARTY_SITES','SDIB');
5779: ELSE

Line 5784: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

5780: x_stage_list(I).TX3 := '';
5781: END IF;
5782: ELSE
5783: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5784: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(
5785: x_stage_list(I).TX3
5786: ,null,'ADDRESS'
5787: ,'PARTY_SITES','SCORE');
5788: IF tmp IS NOT NULL THEN

Line 5798: HZ_TRANS_PKG.RM_SPLCHAR(

5794: FOR I IN 1..p_search_list.COUNT LOOP
5795: IF p_search_ctx THEN
5796: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
5797: x_stage_list(I).TX11 :=
5798: HZ_TRANS_PKG.RM_SPLCHAR(
5799: p_search_list(I).POSTAL_CODE
5800: ,null,'POSTAL_CODE'
5801: ,'PARTY_SITES','SDIB');
5802: ELSE

Line 5807: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

5803: x_stage_list(I).TX11 := '';
5804: END IF;
5805: ELSE
5806: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
5807: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
5808: x_stage_list(I).TX11
5809: ,null,'POSTAL_CODE'
5810: ,'PARTY_SITES','SCORE');
5811: IF tmp IS NOT NULL THEN