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

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

Line 5841: HZ_TRANS_PKG.EXACT_PADDED(

5837: END IF;
5838: IF p_search_ctx THEN
5839: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5840: x_stage_rec.TX2 :=
5841: HZ_TRANS_PKG.EXACT_PADDED(
5842: p_search_rec.PARTY_NAME
5843: ,null,'PARTY_NAME'
5844: ,'PARTY');
5845: ELSE

Line 5852: HZ_TRANS_PKG.WRNAMES_CLEANSE(

5848: END IF;
5849: IF p_search_ctx THEN
5850: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5851: x_stage_rec.TX4 :=
5852: HZ_TRANS_PKG.WRNAMES_CLEANSE(
5853: p_search_rec.PARTY_NAME
5854: ,null,'PARTY_NAME'
5855: ,'PARTY','SDIB');
5856: ELSE

Line 5861: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

5857: x_stage_rec.TX4 := '';
5858: END IF;
5859: ELSE
5860: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5861: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
5862: x_stage_rec.TX4
5863: ,null,'PARTY_NAME'
5864: ,'PARTY','SCORE');
5865: IF tmp IS NOT NULL THEN

Line 5873: HZ_TRANS_PKG.WRNAMES_EXACT(

5869: END IF;
5870: IF p_search_ctx THEN
5871: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5872: x_stage_rec.TX8 :=
5873: HZ_TRANS_PKG.WRNAMES_EXACT(
5874: p_search_rec.PARTY_NAME
5875: ,null,'PARTY_NAME'
5876: ,'PARTY','SDIB');
5877: ELSE

Line 5882: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

5878: x_stage_rec.TX8 := '';
5879: END IF;
5880: ELSE
5881: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5882: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
5883: x_stage_rec.TX8
5884: ,null,'PARTY_NAME'
5885: ,'PARTY','SCORE');
5886: IF tmp IS NOT NULL THEN

Line 5894: HZ_TRANS_PKG.EXACT(

5890: END IF;
5891: IF p_search_ctx THEN
5892: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
5893: x_stage_rec.TX36 :=
5894: HZ_TRANS_PKG.EXACT(
5895: p_search_rec.PARTY_TYPE
5896: ,null,'PARTY_TYPE'
5897: ,'PARTY');
5898: ELSE

Line 5905: HZ_TRANS_PKG.RM_SPLCHAR(

5901: END IF;
5902: IF p_search_ctx THEN
5903: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
5904: x_stage_rec.TX44 :=
5905: HZ_TRANS_PKG.RM_SPLCHAR(
5906: p_search_rec.TAX_REFERENCE
5907: ,null,'TAX_REFERENCE'
5908: ,'PARTY','SDIB');
5909: ELSE

Line 5914: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

5910: x_stage_rec.TX44 := '';
5911: END IF;
5912: ELSE
5913: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
5914: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
5915: x_stage_rec.TX44
5916: ,null,'TAX_REFERENCE'
5917: ,'PARTY','SCORE');
5918: IF tmp IS NOT NULL THEN

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

5924: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
5925: l_party_name := p_search_rec.PARTY_ALL_NAMES;
5926: END IF;
5927: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
5928: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SDIB');
5929: END IF;
5930: EXCEPTION
5931: WHEN OTHERS THEN
5932: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 5983: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

5979: FOR I IN 1..p_search_list.COUNT LOOP
5980: IF p_search_ctx THEN
5981: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5982: x_stage_list(I).TX4 :=
5983: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
5984: p_search_list(I).ADDRESS
5985: ,null,'ADDRESS'
5986: ,'PARTY_SITES','SDIB');
5987: ELSE

Line 5992: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

5988: x_stage_list(I).TX4 := '';
5989: END IF;
5990: ELSE
5991: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5992: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
5993: x_stage_list(I).TX4
5994: ,null,'ADDRESS'
5995: ,'PARTY_SITES','SCORE');
5996: IF tmp IS NOT NULL THEN

Line 6006: HZ_TRANS_PKG.WRADDRESS_EXACT(

6002: FOR I IN 1..p_search_list.COUNT LOOP
6003: IF p_search_ctx THEN
6004: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6005: x_stage_list(I).TX3 :=
6006: HZ_TRANS_PKG.WRADDRESS_EXACT(
6007: p_search_list(I).ADDRESS
6008: ,null,'ADDRESS'
6009: ,'PARTY_SITES','SDIB');
6010: ELSE

Line 6015: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

6011: x_stage_list(I).TX3 := '';
6012: END IF;
6013: ELSE
6014: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6015: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(
6016: x_stage_list(I).TX3
6017: ,null,'ADDRESS'
6018: ,'PARTY_SITES','SCORE');
6019: IF tmp IS NOT NULL THEN

Line 6029: HZ_TRANS_PKG.RM_SPLCHAR(

6025: FOR I IN 1..p_search_list.COUNT LOOP
6026: IF p_search_ctx THEN
6027: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6028: x_stage_list(I).TX11 :=
6029: HZ_TRANS_PKG.RM_SPLCHAR(
6030: p_search_list(I).POSTAL_CODE
6031: ,null,'POSTAL_CODE'
6032: ,'PARTY_SITES','SDIB');
6033: ELSE

Line 6038: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

6034: x_stage_list(I).TX11 := '';
6035: END IF;
6036: ELSE
6037: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6038: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
6039: x_stage_list(I).TX11
6040: ,null,'POSTAL_CODE'
6041: ,'PARTY_SITES','SCORE');
6042: IF tmp IS NOT NULL THEN

Line 6142: HZ_TRANS_PKG.CLEANSED_EMAIL(

6138: FOR I IN 1..p_search_list.COUNT LOOP
6139: IF p_search_ctx THEN
6140: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
6141: x_stage_list(I).TX6 :=
6142: HZ_TRANS_PKG.CLEANSED_EMAIL(
6143: p_search_list(I).EMAIL_ADDRESS
6144: ,null,'EMAIL_ADDRESS'
6145: ,'CONTACT_POINTS','SDIB');
6146: ELSE

Line 6151: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(

6147: x_stage_list(I).TX6 := '';
6148: END IF;
6149: ELSE
6150: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
6151: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(
6152: x_stage_list(I).TX6
6153: ,null,'EMAIL_ADDRESS'
6154: ,'CONTACT_POINTS','SCORE');
6155: IF tmp IS NOT NULL THEN

Line 6165: HZ_TRANS_PKG.EXACT_EMAIL(

6161: FOR I IN 1..p_search_list.COUNT LOOP
6162: IF p_search_ctx THEN
6163: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
6164: x_stage_list(I).TX5 :=
6165: HZ_TRANS_PKG.EXACT_EMAIL(
6166: p_search_list(I).EMAIL_ADDRESS
6167: ,null,'EMAIL_ADDRESS'
6168: ,'CONTACT_POINTS');
6169: ELSE

Line 6178: HZ_TRANS_PKG.RM_SPLCHAR_CTX(

6174: FOR I IN 1..p_search_list.COUNT LOOP
6175: IF p_search_ctx THEN
6176: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
6177: x_stage_list(I).TX1 :=
6178: HZ_TRANS_PKG.RM_SPLCHAR_CTX(
6179: p_search_list(I).FLEX_FORMAT_PHONE_NUMBER
6180: ,null,'FLEX_FORMAT_PHONE_NUMBER'
6181: ,'CONTACT_POINTS','SDIB');
6182: ELSE

Line 6187: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(

6183: x_stage_list(I).TX1 := '';
6184: END IF;
6185: ELSE
6186: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
6187: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(
6188: x_stage_list(I).TX1
6189: ,null,'FLEX_FORMAT_PHONE_NUMBER'
6190: ,'CONTACT_POINTS','SCORE');
6191: IF tmp IS NOT NULL THEN