DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_39 dependencies on HZ_TRANS_PKG

Line 647: HZ_TRANS_PKG.clear_globals;

643: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
644: 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);
645: END IF;
646: -- Transform search criteria
647: HZ_TRANS_PKG.clear_globals;
648: MAP_PARTY_REC(FALSE,p_party_search_rec, l_dummy, g_party_stage_rec);
649: MAP_PARTY_SITE_REC(FALSE,p_party_site_list, l_dummy, g_party_site_stage_list);
650: MAP_CONTACT_REC(FALSE,p_contact_list, l_dummy, g_contact_stage_list);
651: MAP_CONTACT_POINT_REC(FALSE,p_contact_point_list, l_dummy, g_contact_pt_stage_list);

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

700: g_contact_pt_stage_list.DELETE;
701: call_order.DELETE;
702: call_max_score.DELETE;
703: HZ_DQM_SEARCH_UTIL.new_search;
704: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
705: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
706:
707: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
708: 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 3041: HZ_TRANS_PKG.EXACT(

3037: /********************* Find Parties private procedures *******/
3038: PROCEDURE set_person_party_type IS
3039: BEGIN
3040: g_party_stage_rec.TX36:=
3041: HZ_TRANS_PKG.EXACT(
3042: 'PERSON'
3043: ,null,'PARTY_TYPE'
3044: ,'PARTY');
3045: END;

Line 5695: HZ_TRANS_PKG.EXACT(

5691: END IF;
5692: IF p_search_ctx THEN
5693: IF p_search_rec.DUNS_NUMBER_C IS NOT NULL THEN
5694: x_stage_rec.TX41 :=
5695: HZ_TRANS_PKG.EXACT(
5696: p_search_rec.DUNS_NUMBER_C
5697: ,null,'DUNS_NUMBER_C'
5698: ,'PARTY');
5699: ELSE

Line 5710: HZ_TRANS_PKG.WRNAMES_CLEANSE(

5706: END IF;
5707: IF p_search_ctx THEN
5708: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
5709: x_stage_rec.TX40 :=
5710: HZ_TRANS_PKG.WRNAMES_CLEANSE(
5711: p_search_rec.PARTY_ALL_NAMES
5712: ,null,'PARTY_ALL_NAMES'
5713: ,'PARTY','SEARCH');
5714: ELSE

Line 5719: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

5715: x_stage_rec.TX40 := '';
5716: END IF;
5717: ELSE
5718: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
5719: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
5720: x_stage_rec.TX40
5721: ,null,'PARTY_ALL_NAMES'
5722: ,'PARTY','SCORE');
5723: IF tmp IS NOT NULL THEN

Line 5731: HZ_TRANS_PKG.WRNAMES_EXACT(

5727: END IF;
5728: IF p_search_ctx THEN
5729: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
5730: x_stage_rec.TX39 :=
5731: HZ_TRANS_PKG.WRNAMES_EXACT(
5732: p_search_rec.PARTY_ALL_NAMES
5733: ,null,'PARTY_ALL_NAMES'
5734: ,'PARTY','SEARCH');
5735: ELSE

Line 5740: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

5736: x_stage_rec.TX39 := '';
5737: END IF;
5738: ELSE
5739: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
5740: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
5741: x_stage_rec.TX39
5742: ,null,'PARTY_ALL_NAMES'
5743: ,'PARTY','SCORE');
5744: IF tmp IS NOT NULL THEN

Line 5751: HZ_TRANS_PKG.EXACT(

5747: END IF;
5748: END IF;
5749: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
5750: x_stage_rec.TX36 :=
5751: HZ_TRANS_PKG.EXACT(
5752: p_search_rec.PARTY_TYPE
5753: ,null,'PARTY_TYPE'
5754: ,'PARTY');
5755: ELSE

Line 5761: HZ_TRANS_PKG.RM_SPLCHAR(

5757: END IF;
5758: IF p_search_ctx THEN
5759: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
5760: x_stage_rec.TX44 :=
5761: HZ_TRANS_PKG.RM_SPLCHAR(
5762: p_search_rec.TAX_REFERENCE
5763: ,null,'TAX_REFERENCE'
5764: ,'PARTY','SEARCH');
5765: ELSE

Line 5770: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

5766: x_stage_rec.TX44 := '';
5767: END IF;
5768: ELSE
5769: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
5770: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
5771: x_stage_rec.TX44
5772: ,null,'TAX_REFERENCE'
5773: ,'PARTY','SCORE');
5774: IF tmp IS NOT NULL THEN

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

5780: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
5781: l_party_name := p_search_rec.PARTY_ALL_NAMES;
5782: END IF;
5783: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
5784: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
5785: END IF;
5786: EXCEPTION
5787: WHEN OTHERS THEN
5788: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 5836: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

5832: FOR I IN 1..p_search_list.COUNT LOOP
5833: IF p_search_ctx THEN
5834: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5835: x_stage_list(I).TX4 :=
5836: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
5837: p_search_list(I).ADDRESS
5838: ,null,'ADDRESS'
5839: ,'PARTY_SITES','SEARCH');
5840: ELSE

Line 5845: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

5841: x_stage_list(I).TX4 := '';
5842: END IF;
5843: ELSE
5844: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5845: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
5846: x_stage_list(I).TX4
5847: ,null,'ADDRESS'
5848: ,'PARTY_SITES','SCORE');
5849: IF tmp IS NOT NULL THEN

Line 5859: HZ_TRANS_PKG.WRADDRESS_EXACT(

5855: FOR I IN 1..p_search_list.COUNT LOOP
5856: IF p_search_ctx THEN
5857: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5858: x_stage_list(I).TX3 :=
5859: HZ_TRANS_PKG.WRADDRESS_EXACT(
5860: p_search_list(I).ADDRESS
5861: ,null,'ADDRESS'
5862: ,'PARTY_SITES','SEARCH');
5863: ELSE

Line 5868: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

5864: x_stage_list(I).TX3 := '';
5865: END IF;
5866: ELSE
5867: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5868: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(
5869: x_stage_list(I).TX3
5870: ,null,'ADDRESS'
5871: ,'PARTY_SITES','SCORE');
5872: IF tmp IS NOT NULL THEN

Line 5882: HZ_TRANS_PKG.RM_SPLCHAR(

5878: FOR I IN 1..p_search_list.COUNT LOOP
5879: IF p_search_ctx THEN
5880: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
5881: x_stage_list(I).TX11 :=
5882: HZ_TRANS_PKG.RM_SPLCHAR(
5883: p_search_list(I).POSTAL_CODE
5884: ,null,'POSTAL_CODE'
5885: ,'PARTY_SITES','SEARCH');
5886: ELSE

Line 5891: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

5887: x_stage_list(I).TX11 := '';
5888: END IF;
5889: ELSE
5890: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
5891: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
5892: x_stage_list(I).TX11
5893: ,null,'POSTAL_CODE'
5894: ,'PARTY_SITES','SCORE');
5895: IF tmp IS NOT NULL THEN