APPS.HZ_MATCH_RULE_238 dependencies on HZ_TRANS_PKG

Line 721: HZ_TRANS_PKG.clear_globals;

717: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
718: 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);
719: END IF;
720: -- Transform search criteria
721: HZ_TRANS_PKG.clear_globals;
722: MAP_PARTY_REC(FALSE,p_party_search_rec, l_dummy, g_party_stage_rec);
723: MAP_PARTY_SITE_REC(FALSE,p_party_site_list, l_dummy, g_party_site_stage_list);
724: MAP_CONTACT_REC(FALSE,p_contact_list, l_dummy, g_contact_stage_list);
725: MAP_CONTACT_POINT_REC(FALSE,p_contact_point_list, l_dummy, g_contact_pt_stage_list);

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

774: g_contact_pt_stage_list.DELETE;
775: call_order.DELETE;
776: call_max_score.DELETE;
777: HZ_DQM_SEARCH_UTIL.new_search;
778: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
779: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
780:
781: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
782: 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 3206: HZ_TRANS_PKG.EXACT(

3202: /********************* Find Parties private procedures *******/
3203: PROCEDURE set_person_party_type IS
3204: BEGIN
3205: g_party_stage_rec.TX36:=
3206: HZ_TRANS_PKG.EXACT(
3207: 'PERSON'
3208: ,null,'PARTY_TYPE'
3209: ,'PARTY');
3210: END;

Line 5922: HZ_TRANS_PKG.RM_SPLCHAR(

5918: END IF;
5919: IF p_search_ctx THEN
5920: IF p_search_rec.JGZZ_FISCAL_CODE IS NOT NULL THEN
5921: x_stage_rec.TX45 :=
5922: HZ_TRANS_PKG.RM_SPLCHAR(
5923: p_search_rec.JGZZ_FISCAL_CODE
5924: ,null,'JGZZ_FISCAL_CODE'
5925: ,'PARTY','SEARCH');
5926: ELSE

Line 5931: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

5927: x_stage_rec.TX45 := '';
5928: END IF;
5929: ELSE
5930: IF p_search_rec.JGZZ_FISCAL_CODE IS NOT NULL THEN
5931: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
5932: x_stage_rec.TX45
5933: ,null,'JGZZ_FISCAL_CODE'
5934: ,'PARTY','SCORE');
5935: IF tmp IS NOT NULL THEN

Line 5943: HZ_TRANS_PKG.WRNAMES_CLEANSE(

5939: END IF;
5940: IF p_search_ctx THEN
5941: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5942: x_stage_rec.TX4 :=
5943: HZ_TRANS_PKG.WRNAMES_CLEANSE(
5944: p_search_rec.PARTY_NAME
5945: ,null,'PARTY_NAME'
5946: ,'PARTY','SEARCH');
5947: ELSE

Line 5952: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

5948: x_stage_rec.TX4 := '';
5949: END IF;
5950: ELSE
5951: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5952: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
5953: x_stage_rec.TX4
5954: ,null,'PARTY_NAME'
5955: ,'PARTY','SCORE');
5956: IF tmp IS NOT NULL THEN

Line 5964: HZ_TRANS_PKG.EXACT(

5960: END IF;
5961: IF p_search_ctx THEN
5962: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
5963: x_stage_rec.TX36 :=
5964: HZ_TRANS_PKG.EXACT(
5965: p_search_rec.PARTY_TYPE
5966: ,null,'PARTY_TYPE'
5967: ,'PARTY');
5968: ELSE

Line 5975: HZ_TRANS_PKG.EXACT(

5971: END IF;
5972: IF p_search_ctx THEN
5973: IF p_search_rec.SIC_CODE IS NOT NULL THEN
5974: x_stage_rec.TX46 :=
5975: HZ_TRANS_PKG.EXACT(
5976: p_search_rec.SIC_CODE
5977: ,null,'SIC_CODE'
5978: ,'PARTY');
5979: ELSE

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

5984: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
5985: l_party_name := p_search_rec.PARTY_ALL_NAMES;
5986: END IF;
5987: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
5988: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
5989: END IF;
5990: EXCEPTION
5991: WHEN OTHERS THEN
5992: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 6043: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6039: FOR I IN 1..p_search_list.COUNT LOOP
6040: IF p_search_ctx THEN
6041: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6042: x_stage_list(I).TX4 :=
6043: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6044: p_search_list(I).ADDRESS
6045: ,null,'ADDRESS'
6046: ,'PARTY_SITES','SEARCH');
6047: ELSE

Line 6052: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6048: x_stage_list(I).TX4 := '';
6049: END IF;
6050: ELSE
6051: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6052: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6053: x_stage_list(I).TX4
6054: ,null,'ADDRESS'
6055: ,'PARTY_SITES','SCORE');
6056: IF tmp IS NOT NULL THEN

Line 6066: HZ_TRANS_PKG.RM_SPLCHAR(

6062: FOR I IN 1..p_search_list.COUNT LOOP
6063: IF p_search_ctx THEN
6064: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6065: x_stage_list(I).TX11 :=
6066: HZ_TRANS_PKG.RM_SPLCHAR(
6067: p_search_list(I).POSTAL_CODE
6068: ,null,'POSTAL_CODE'
6069: ,'PARTY_SITES','SEARCH');
6070: ELSE

Line 6075: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

6071: x_stage_list(I).TX11 := '';
6072: END IF;
6073: ELSE
6074: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6075: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
6076: x_stage_list(I).TX11
6077: ,null,'POSTAL_CODE'
6078: ,'PARTY_SITES','SCORE');
6079: IF tmp IS NOT NULL THEN

Line 6200: HZ_TRANS_PKG.RM_SPLCHAR(

6196: FOR I IN 1..p_search_list.COUNT LOOP
6197: IF p_search_ctx THEN
6198: IF p_search_list(I).PHONE_NUMBER IS NOT NULL THEN
6199: x_stage_list(I).TX2 :=
6200: HZ_TRANS_PKG.RM_SPLCHAR(
6201: p_search_list(I).PHONE_NUMBER
6202: ,null,'PHONE_NUMBER'
6203: ,'CONTACT_POINTS','SEARCH');
6204: ELSE

Line 6209: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

6205: x_stage_list(I).TX2 := '';
6206: END IF;
6207: ELSE
6208: IF p_search_list(I).PHONE_NUMBER IS NOT NULL THEN
6209: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
6210: x_stage_list(I).TX2
6211: ,null,'PHONE_NUMBER'
6212: ,'CONTACT_POINTS','SCORE');
6213: IF tmp IS NOT NULL THEN