eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_MATCH_RULE_60 dependencies on HZ_TRANS_PKG

Line 1122: HZ_TRANS_PKG.clear_globals;

1118: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1119: 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);
1120: END IF;
1121: -- Transform search criteria
1122: HZ_TRANS_PKG.clear_globals;
1123: MAP_PARTY_REC(FALSE,p_party_search_rec, l_dummy, g_party_stage_rec);
1124: MAP_PARTY_SITE_REC(FALSE,p_party_site_list, l_dummy, g_party_site_stage_list);
1125: MAP_CONTACT_REC(FALSE,p_contact_list, l_dummy, g_contact_stage_list);
1126: MAP_CONTACT_POINT_REC(FALSE,p_contact_point_list, l_dummy, g_contact_pt_stage_list);

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

1175: g_contact_pt_stage_list.DELETE;
1176: call_order.DELETE;
1177: call_max_score.DELETE;
1178: HZ_DQM_SEARCH_UTIL.new_search;
1179: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
1180: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1181:
1182: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1183: 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 3774: HZ_TRANS_PKG.EXACT(

3770: /********************* Find Parties private procedures *******/
3771: PROCEDURE set_person_party_type IS
3772: BEGIN
3773: g_party_stage_rec.TX36:=
3774: HZ_TRANS_PKG.EXACT(
3775: 'PERSON'
3776: ,null,'PARTY_TYPE'
3777: ,'PARTY');
3778: END;

Line 6643: HZ_TRANS_PKG.RM_SPLCHAR(

6639: END IF;
6640: IF p_search_ctx THEN
6641: IF p_search_rec.ALL_ACCOUNT_NUMBERS IS NOT NULL THEN
6642: x_stage_rec.TX35 :=
6643: HZ_TRANS_PKG.RM_SPLCHAR(
6644: p_search_rec.ALL_ACCOUNT_NUMBERS
6645: ,null,'ALL_ACCOUNT_NUMBERS'
6646: ,'PARTY','SEARCH');
6647: ELSE

Line 6652: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6648: x_stage_rec.TX35 := '';
6649: END IF;
6650: ELSE
6651: IF p_search_rec.ALL_ACCOUNT_NUMBERS IS NOT NULL THEN
6652: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6653: x_stage_rec.TX35
6654: ,null,'ALL_ACCOUNT_NUMBERS'
6655: ,'PARTY','SCORE');
6656: IF tmp IS NOT NULL THEN

Line 6664: HZ_TRANS_PKG.RM_SPLCHAR(

6660: END IF;
6661: IF p_search_ctx THEN
6662: IF p_search_rec.JGZZ_FISCAL_CODE IS NOT NULL THEN
6663: x_stage_rec.TX45 :=
6664: HZ_TRANS_PKG.RM_SPLCHAR(
6665: p_search_rec.JGZZ_FISCAL_CODE
6666: ,null,'JGZZ_FISCAL_CODE'
6667: ,'PARTY','SEARCH');
6668: ELSE

Line 6673: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6669: x_stage_rec.TX45 := '';
6670: END IF;
6671: ELSE
6672: IF p_search_rec.JGZZ_FISCAL_CODE IS NOT NULL THEN
6673: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6674: x_stage_rec.TX45
6675: ,null,'JGZZ_FISCAL_CODE'
6676: ,'PARTY','SCORE');
6677: IF tmp IS NOT NULL THEN

Line 6685: HZ_TRANS_PKG.WRNAMES_CLEANSE(

6681: END IF;
6682: IF p_search_ctx THEN
6683: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6684: x_stage_rec.TX40 :=
6685: HZ_TRANS_PKG.WRNAMES_CLEANSE(
6686: p_search_rec.PARTY_ALL_NAMES
6687: ,null,'PARTY_ALL_NAMES'
6688: ,'PARTY','SEARCH');
6689: ELSE

Line 6694: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

6690: x_stage_rec.TX40 := '';
6691: END IF;
6692: ELSE
6693: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6694: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
6695: x_stage_rec.TX40
6696: ,null,'PARTY_ALL_NAMES'
6697: ,'PARTY','SCORE');
6698: IF tmp IS NOT NULL THEN

Line 6706: HZ_TRANS_PKG.WRNAMES_EXACT(

6702: END IF;
6703: IF p_search_ctx THEN
6704: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6705: x_stage_rec.TX39 :=
6706: HZ_TRANS_PKG.WRNAMES_EXACT(
6707: p_search_rec.PARTY_ALL_NAMES
6708: ,null,'PARTY_ALL_NAMES'
6709: ,'PARTY','SEARCH');
6710: ELSE

Line 6715: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

6711: x_stage_rec.TX39 := '';
6712: END IF;
6713: ELSE
6714: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6715: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
6716: x_stage_rec.TX39
6717: ,null,'PARTY_ALL_NAMES'
6718: ,'PARTY','SCORE');
6719: IF tmp IS NOT NULL THEN

Line 6727: HZ_TRANS_PKG.RM_SPLCHAR(

6723: END IF;
6724: IF p_search_ctx THEN
6725: IF p_search_rec.PARTY_NUMBER IS NOT NULL THEN
6726: x_stage_rec.TX34 :=
6727: HZ_TRANS_PKG.RM_SPLCHAR(
6728: p_search_rec.PARTY_NUMBER
6729: ,null,'PARTY_NUMBER'
6730: ,'PARTY','SEARCH');
6731: ELSE

Line 6736: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6732: x_stage_rec.TX34 := '';
6733: END IF;
6734: ELSE
6735: IF p_search_rec.PARTY_NUMBER IS NOT NULL THEN
6736: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6737: x_stage_rec.TX34
6738: ,null,'PARTY_NUMBER'
6739: ,'PARTY','SCORE');
6740: IF tmp IS NOT NULL THEN

Line 6748: HZ_TRANS_PKG.EXACT(

6744: END IF;
6745: IF p_search_ctx THEN
6746: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
6747: x_stage_rec.TX36 :=
6748: HZ_TRANS_PKG.EXACT(
6749: p_search_rec.PARTY_TYPE
6750: ,null,'PARTY_TYPE'
6751: ,'PARTY');
6752: ELSE

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

6757: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6758: l_party_name := p_search_rec.PARTY_ALL_NAMES;
6759: END IF;
6760: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
6761: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
6762: END IF;
6763: EXCEPTION
6764: WHEN OTHERS THEN
6765: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 6828: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6824: FOR I IN 1..p_search_list.COUNT LOOP
6825: IF p_search_ctx THEN
6826: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6827: x_stage_list(I).TX4 :=
6828: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6829: p_search_list(I).ADDRESS
6830: ,null,'ADDRESS'
6831: ,'PARTY_SITES','SEARCH');
6832: ELSE

Line 6837: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6833: x_stage_list(I).TX4 := '';
6834: END IF;
6835: ELSE
6836: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6837: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6838: x_stage_list(I).TX4
6839: ,null,'ADDRESS'
6840: ,'PARTY_SITES','SCORE');
6841: IF tmp IS NOT NULL THEN

Line 6851: HZ_TRANS_PKG.WRADDRESS_EXACT(

6847: FOR I IN 1..p_search_list.COUNT LOOP
6848: IF p_search_ctx THEN
6849: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6850: x_stage_list(I).TX3 :=
6851: HZ_TRANS_PKG.WRADDRESS_EXACT(
6852: p_search_list(I).ADDRESS
6853: ,null,'ADDRESS'
6854: ,'PARTY_SITES','SEARCH');
6855: ELSE

Line 6860: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

6856: x_stage_list(I).TX3 := '';
6857: END IF;
6858: ELSE
6859: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6860: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(
6861: x_stage_list(I).TX3
6862: ,null,'ADDRESS'
6863: ,'PARTY_SITES','SCORE');
6864: IF tmp IS NOT NULL THEN

Line 6874: HZ_TRANS_PKG.CLEANSE(

6870: FOR I IN 1..p_search_list.COUNT LOOP
6871: IF p_search_ctx THEN
6872: IF p_search_list(I).CITY IS NOT NULL THEN
6873: x_stage_list(I).TX10 :=
6874: HZ_TRANS_PKG.CLEANSE(
6875: p_search_list(I).CITY
6876: ,null,'CITY'
6877: ,'PARTY_SITES');
6878: ELSE

Line 6887: HZ_TRANS_PKG.EXACT(

6883: FOR I IN 1..p_search_list.COUNT LOOP
6884: IF p_search_ctx THEN
6885: IF p_search_list(I).CITY IS NOT NULL THEN
6886: x_stage_list(I).TX9 :=
6887: HZ_TRANS_PKG.EXACT(
6888: p_search_list(I).CITY
6889: ,null,'CITY'
6890: ,'PARTY_SITES');
6891: ELSE

Line 6900: HZ_TRANS_PKG.EXACT(

6896: FOR I IN 1..p_search_list.COUNT LOOP
6897: IF p_search_ctx THEN
6898: IF p_search_list(I).COUNTRY IS NOT NULL THEN
6899: x_stage_list(I).TX22 :=
6900: HZ_TRANS_PKG.EXACT(
6901: p_search_list(I).COUNTRY
6902: ,null,'COUNTRY'
6903: ,'PARTY_SITES');
6904: ELSE

Line 6913: HZ_TRANS_PKG.RM_SPLCHAR(

6909: FOR I IN 1..p_search_list.COUNT LOOP
6910: IF p_search_ctx THEN
6911: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6912: x_stage_list(I).TX11 :=
6913: HZ_TRANS_PKG.RM_SPLCHAR(
6914: p_search_list(I).POSTAL_CODE
6915: ,null,'POSTAL_CODE'
6916: ,'PARTY_SITES','SEARCH');
6917: ELSE

Line 6922: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

6918: x_stage_list(I).TX11 := '';
6919: END IF;
6920: ELSE
6921: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6922: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
6923: x_stage_list(I).TX11
6924: ,null,'POSTAL_CODE'
6925: ,'PARTY_SITES','SCORE');
6926: IF tmp IS NOT NULL THEN

Line 6936: HZ_TRANS_PKG.CLEANSE(

6932: FOR I IN 1..p_search_list.COUNT LOOP
6933: IF p_search_ctx THEN
6934: IF p_search_list(I).PROVINCE IS NOT NULL THEN
6935: x_stage_list(I).TX13 :=
6936: HZ_TRANS_PKG.CLEANSE(
6937: p_search_list(I).PROVINCE
6938: ,null,'PROVINCE'
6939: ,'PARTY_SITES');
6940: ELSE

Line 6949: HZ_TRANS_PKG.EXACT(

6945: FOR I IN 1..p_search_list.COUNT LOOP
6946: IF p_search_ctx THEN
6947: IF p_search_list(I).PROVINCE IS NOT NULL THEN
6948: x_stage_list(I).TX12 :=
6949: HZ_TRANS_PKG.EXACT(
6950: p_search_list(I).PROVINCE
6951: ,null,'PROVINCE'
6952: ,'PARTY_SITES');
6953: ELSE

Line 6962: HZ_TRANS_PKG.WRSTATE_CLEANSE(

6958: FOR I IN 1..p_search_list.COUNT LOOP
6959: IF p_search_ctx THEN
6960: IF p_search_list(I).STATE IS NOT NULL THEN
6961: x_stage_list(I).TX15 :=
6962: HZ_TRANS_PKG.WRSTATE_CLEANSE(
6963: p_search_list(I).STATE
6964: ,null,'STATE'
6965: ,'PARTY_SITES','SEARCH');
6966: ELSE

Line 6971: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(

6967: x_stage_list(I).TX15 := '';
6968: END IF;
6969: ELSE
6970: IF p_search_list(I).STATE IS NOT NULL THEN
6971: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(
6972: x_stage_list(I).TX15
6973: ,null,'STATE'
6974: ,'PARTY_SITES','SCORE');
6975: IF tmp IS NOT NULL THEN

Line 6985: HZ_TRANS_PKG.WRSTATE_EXACT(

6981: FOR I IN 1..p_search_list.COUNT LOOP
6982: IF p_search_ctx THEN
6983: IF p_search_list(I).STATE IS NOT NULL THEN
6984: x_stage_list(I).TX14 :=
6985: HZ_TRANS_PKG.WRSTATE_EXACT(
6986: p_search_list(I).STATE
6987: ,null,'STATE'
6988: ,'PARTY_SITES','SEARCH');
6989: ELSE

Line 6994: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(

6990: x_stage_list(I).TX14 := '';
6991: END IF;
6992: ELSE
6993: IF p_search_list(I).STATE IS NOT NULL THEN
6994: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(
6995: x_stage_list(I).TX14
6996: ,null,'STATE'
6997: ,'PARTY_SITES','SCORE');
6998: IF tmp IS NOT NULL THEN

Line 7052: HZ_TRANS_PKG.EXACT(

7048: FOR I IN 1..p_search_list.COUNT LOOP
7049: IF p_search_ctx THEN
7050: IF p_search_list(I).JOB_TITLE IS NOT NULL THEN
7051: x_stage_list(I).TX22 :=
7052: HZ_TRANS_PKG.EXACT(
7053: p_search_list(I).JOB_TITLE
7054: ,null,'JOB_TITLE'
7055: ,'CONTACTS');
7056: ELSE

Line 7137: HZ_TRANS_PKG.CLEANSED_EMAIL(

7133: FOR I IN 1..p_search_list.COUNT LOOP
7134: IF p_search_ctx THEN
7135: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
7136: x_stage_list(I).TX6 :=
7137: HZ_TRANS_PKG.CLEANSED_EMAIL(
7138: p_search_list(I).EMAIL_ADDRESS
7139: ,null,'EMAIL_ADDRESS'
7140: ,'CONTACT_POINTS','SEARCH');
7141: ELSE

Line 7146: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(

7142: x_stage_list(I).TX6 := '';
7143: END IF;
7144: ELSE
7145: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
7146: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(
7147: x_stage_list(I).TX6
7148: ,null,'EMAIL_ADDRESS'
7149: ,'CONTACT_POINTS','SCORE');
7150: IF tmp IS NOT NULL THEN

Line 7160: HZ_TRANS_PKG.EXACT_EMAIL(

7156: FOR I IN 1..p_search_list.COUNT LOOP
7157: IF p_search_ctx THEN
7158: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
7159: x_stage_list(I).TX5 :=
7160: HZ_TRANS_PKG.EXACT_EMAIL(
7161: p_search_list(I).EMAIL_ADDRESS
7162: ,null,'EMAIL_ADDRESS'
7163: ,'CONTACT_POINTS');
7164: ELSE

Line 7173: HZ_TRANS_PKG.RM_SPLCHAR_CTX(

7169: FOR I IN 1..p_search_list.COUNT LOOP
7170: IF p_search_ctx THEN
7171: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
7172: x_stage_list(I).TX1 :=
7173: HZ_TRANS_PKG.RM_SPLCHAR_CTX(
7174: p_search_list(I).FLEX_FORMAT_PHONE_NUMBER
7175: ,null,'FLEX_FORMAT_PHONE_NUMBER'
7176: ,'CONTACT_POINTS','SEARCH');
7177: ELSE

Line 7182: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(

7178: x_stage_list(I).TX1 := '';
7179: END IF;
7180: ELSE
7181: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
7182: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(
7183: x_stage_list(I).TX1
7184: ,null,'FLEX_FORMAT_PHONE_NUMBER'
7185: ,'CONTACT_POINTS','SCORE');
7186: IF tmp IS NOT NULL THEN