APPS.HZ_MATCH_RULE_7 dependencies on HZ_TRANS_PKG

Line 766: HZ_TRANS_PKG.clear_globals;

762: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
763: 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);
764: END IF;
765: -- Transform search criteria
766: HZ_TRANS_PKG.clear_globals;
767: MAP_PARTY_REC(FALSE,p_party_search_rec, l_dummy, g_party_stage_rec);
768: MAP_PARTY_SITE_REC(FALSE,p_party_site_list, l_dummy, g_party_site_stage_list);
769: MAP_CONTACT_REC(FALSE,p_contact_list, l_dummy, g_contact_stage_list);
770: MAP_CONTACT_POINT_REC(FALSE,p_contact_point_list, l_dummy, g_contact_pt_stage_list);

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

819: g_contact_pt_stage_list.DELETE;
820: call_order.DELETE;
821: call_max_score.DELETE;
822: HZ_DQM_SEARCH_UTIL.new_search;
823: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
824: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
825:
826: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
827: 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 3168: HZ_TRANS_PKG.EXACT(

3164: /********************* Find Parties private procedures *******/
3165: PROCEDURE set_person_party_type IS
3166: BEGIN
3167: g_party_stage_rec.TX36:=
3168: HZ_TRANS_PKG.EXACT(
3169: 'PERSON'
3170: ,null,'PARTY_TYPE'
3171: ,'PARTY');
3172: END;

Line 5846: HZ_TRANS_PKG.EXACT_PADDED(

5842: END IF;
5843: IF p_search_ctx THEN
5844: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5845: x_stage_rec.TX2 :=
5846: HZ_TRANS_PKG.EXACT_PADDED(
5847: p_search_rec.PARTY_NAME
5848: ,null,'PARTY_NAME'
5849: ,'PARTY');
5850: ELSE

Line 5857: HZ_TRANS_PKG.WRNAMES_CLEANSE(

5853: END IF;
5854: IF p_search_ctx THEN
5855: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5856: x_stage_rec.TX4 :=
5857: HZ_TRANS_PKG.WRNAMES_CLEANSE(
5858: p_search_rec.PARTY_NAME
5859: ,null,'PARTY_NAME'
5860: ,'PARTY','SDIB');
5861: ELSE

Line 5866: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

5862: x_stage_rec.TX4 := '';
5863: END IF;
5864: ELSE
5865: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5866: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
5867: x_stage_rec.TX4
5868: ,null,'PARTY_NAME'
5869: ,'PARTY','SCORE');
5870: IF tmp IS NOT NULL THEN

Line 5878: HZ_TRANS_PKG.WRNAMES_EXACT(

5874: END IF;
5875: IF p_search_ctx THEN
5876: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5877: x_stage_rec.TX8 :=
5878: HZ_TRANS_PKG.WRNAMES_EXACT(
5879: p_search_rec.PARTY_NAME
5880: ,null,'PARTY_NAME'
5881: ,'PARTY','SDIB');
5882: ELSE

Line 5887: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

5883: x_stage_rec.TX8 := '';
5884: END IF;
5885: ELSE
5886: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5887: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
5888: x_stage_rec.TX8
5889: ,null,'PARTY_NAME'
5890: ,'PARTY','SCORE');
5891: IF tmp IS NOT NULL THEN

Line 5899: HZ_TRANS_PKG.EXACT(

5895: END IF;
5896: IF p_search_ctx THEN
5897: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
5898: x_stage_rec.TX36 :=
5899: HZ_TRANS_PKG.EXACT(
5900: p_search_rec.PARTY_TYPE
5901: ,null,'PARTY_TYPE'
5902: ,'PARTY');
5903: ELSE

Line 5910: HZ_TRANS_PKG.RM_SPLCHAR(

5906: END IF;
5907: IF p_search_ctx THEN
5908: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
5909: x_stage_rec.TX44 :=
5910: HZ_TRANS_PKG.RM_SPLCHAR(
5911: p_search_rec.TAX_REFERENCE
5912: ,null,'TAX_REFERENCE'
5913: ,'PARTY','SDIB');
5914: ELSE

Line 5919: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

5915: x_stage_rec.TX44 := '';
5916: END IF;
5917: ELSE
5918: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
5919: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
5920: x_stage_rec.TX44
5921: ,null,'TAX_REFERENCE'
5922: ,'PARTY','SCORE');
5923: IF tmp IS NOT NULL THEN

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

5929: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
5930: l_party_name := p_search_rec.PARTY_ALL_NAMES;
5931: END IF;
5932: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
5933: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SDIB');
5934: END IF;
5935: EXCEPTION
5936: WHEN OTHERS THEN
5937: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 5988: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

5984: FOR I IN 1..p_search_list.COUNT LOOP
5985: IF p_search_ctx THEN
5986: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5987: x_stage_list(I).TX4 :=
5988: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
5989: p_search_list(I).ADDRESS
5990: ,null,'ADDRESS'
5991: ,'PARTY_SITES','SDIB');
5992: ELSE

Line 5997: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

5993: x_stage_list(I).TX4 := '';
5994: END IF;
5995: ELSE
5996: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5997: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
5998: x_stage_list(I).TX4
5999: ,null,'ADDRESS'
6000: ,'PARTY_SITES','SCORE');
6001: IF tmp IS NOT NULL THEN

Line 6011: HZ_TRANS_PKG.WRADDRESS_EXACT(

6007: FOR I IN 1..p_search_list.COUNT LOOP
6008: IF p_search_ctx THEN
6009: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6010: x_stage_list(I).TX3 :=
6011: HZ_TRANS_PKG.WRADDRESS_EXACT(
6012: p_search_list(I).ADDRESS
6013: ,null,'ADDRESS'
6014: ,'PARTY_SITES','SDIB');
6015: ELSE

Line 6020: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

6016: x_stage_list(I).TX3 := '';
6017: END IF;
6018: ELSE
6019: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6020: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(
6021: x_stage_list(I).TX3
6022: ,null,'ADDRESS'
6023: ,'PARTY_SITES','SCORE');
6024: IF tmp IS NOT NULL THEN

Line 6034: HZ_TRANS_PKG.RM_SPLCHAR(

6030: FOR I IN 1..p_search_list.COUNT LOOP
6031: IF p_search_ctx THEN
6032: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6033: x_stage_list(I).TX11 :=
6034: HZ_TRANS_PKG.RM_SPLCHAR(
6035: p_search_list(I).POSTAL_CODE
6036: ,null,'POSTAL_CODE'
6037: ,'PARTY_SITES','SDIB');
6038: ELSE

Line 6043: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

6039: x_stage_list(I).TX11 := '';
6040: END IF;
6041: ELSE
6042: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6043: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
6044: x_stage_list(I).TX11
6045: ,null,'POSTAL_CODE'
6046: ,'PARTY_SITES','SCORE');
6047: IF tmp IS NOT NULL THEN

Line 6147: HZ_TRANS_PKG.CLEANSED_EMAIL(

6143: FOR I IN 1..p_search_list.COUNT LOOP
6144: IF p_search_ctx THEN
6145: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
6146: x_stage_list(I).TX6 :=
6147: HZ_TRANS_PKG.CLEANSED_EMAIL(
6148: p_search_list(I).EMAIL_ADDRESS
6149: ,null,'EMAIL_ADDRESS'
6150: ,'CONTACT_POINTS','SDIB');
6151: ELSE

Line 6156: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(

6152: x_stage_list(I).TX6 := '';
6153: END IF;
6154: ELSE
6155: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
6156: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(
6157: x_stage_list(I).TX6
6158: ,null,'EMAIL_ADDRESS'
6159: ,'CONTACT_POINTS','SCORE');
6160: IF tmp IS NOT NULL THEN

Line 6170: HZ_TRANS_PKG.EXACT_EMAIL(

6166: FOR I IN 1..p_search_list.COUNT LOOP
6167: IF p_search_ctx THEN
6168: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
6169: x_stage_list(I).TX5 :=
6170: HZ_TRANS_PKG.EXACT_EMAIL(
6171: p_search_list(I).EMAIL_ADDRESS
6172: ,null,'EMAIL_ADDRESS'
6173: ,'CONTACT_POINTS');
6174: ELSE

Line 6183: HZ_TRANS_PKG.RM_SPLCHAR_CTX(

6179: FOR I IN 1..p_search_list.COUNT LOOP
6180: IF p_search_ctx THEN
6181: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
6182: x_stage_list(I).TX1 :=
6183: HZ_TRANS_PKG.RM_SPLCHAR_CTX(
6184: p_search_list(I).FLEX_FORMAT_PHONE_NUMBER
6185: ,null,'FLEX_FORMAT_PHONE_NUMBER'
6186: ,'CONTACT_POINTS','SDIB');
6187: ELSE

Line 6192: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(

6188: x_stage_list(I).TX1 := '';
6189: END IF;
6190: ELSE
6191: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
6192: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(
6193: x_stage_list(I).TX1
6194: ,null,'FLEX_FORMAT_PHONE_NUMBER'
6195: ,'CONTACT_POINTS','SCORE');
6196: IF tmp IS NOT NULL THEN