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

3775: /********************* Find Parties private procedures *******/
3776: PROCEDURE set_person_party_type IS
3777: BEGIN
3778: g_party_stage_rec.TX36:=
3779: HZ_TRANS_PKG.EXACT(
3780: 'PERSON'
3781: ,null,'PARTY_TYPE'
3782: ,'PARTY');
3783: END;

Line 6654: HZ_TRANS_PKG.RM_SPLCHAR(

6650: END IF;
6651: IF p_search_ctx THEN
6652: IF p_search_rec.ALL_ACCOUNT_NUMBERS IS NOT NULL THEN
6653: x_stage_rec.TX35 :=
6654: HZ_TRANS_PKG.RM_SPLCHAR(
6655: p_search_rec.ALL_ACCOUNT_NUMBERS
6656: ,null,'ALL_ACCOUNT_NUMBERS'
6657: ,'PARTY','SEARCH');
6658: ELSE

Line 6663: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6659: x_stage_rec.TX35 := '';
6660: END IF;
6661: ELSE
6662: IF p_search_rec.ALL_ACCOUNT_NUMBERS IS NOT NULL THEN
6663: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6664: x_stage_rec.TX35
6665: ,null,'ALL_ACCOUNT_NUMBERS'
6666: ,'PARTY','SCORE');
6667: IF tmp IS NOT NULL THEN

Line 6675: HZ_TRANS_PKG.RM_SPLCHAR(

6671: END IF;
6672: IF p_search_ctx THEN
6673: IF p_search_rec.JGZZ_FISCAL_CODE IS NOT NULL THEN
6674: x_stage_rec.TX45 :=
6675: HZ_TRANS_PKG.RM_SPLCHAR(
6676: p_search_rec.JGZZ_FISCAL_CODE
6677: ,null,'JGZZ_FISCAL_CODE'
6678: ,'PARTY','SEARCH');
6679: ELSE

Line 6684: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6680: x_stage_rec.TX45 := '';
6681: END IF;
6682: ELSE
6683: IF p_search_rec.JGZZ_FISCAL_CODE IS NOT NULL THEN
6684: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6685: x_stage_rec.TX45
6686: ,null,'JGZZ_FISCAL_CODE'
6687: ,'PARTY','SCORE');
6688: IF tmp IS NOT NULL THEN

Line 6696: HZ_TRANS_PKG.WRNAMES_CLEANSE(

6692: END IF;
6693: IF p_search_ctx THEN
6694: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6695: x_stage_rec.TX40 :=
6696: HZ_TRANS_PKG.WRNAMES_CLEANSE(
6697: p_search_rec.PARTY_ALL_NAMES
6698: ,null,'PARTY_ALL_NAMES'
6699: ,'PARTY','SEARCH');
6700: ELSE

Line 6705: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

6701: x_stage_rec.TX40 := '';
6702: END IF;
6703: ELSE
6704: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6705: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
6706: x_stage_rec.TX40
6707: ,null,'PARTY_ALL_NAMES'
6708: ,'PARTY','SCORE');
6709: IF tmp IS NOT NULL THEN

Line 6717: HZ_TRANS_PKG.WRNAMES_EXACT(

6713: END IF;
6714: IF p_search_ctx THEN
6715: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6716: x_stage_rec.TX39 :=
6717: HZ_TRANS_PKG.WRNAMES_EXACT(
6718: p_search_rec.PARTY_ALL_NAMES
6719: ,null,'PARTY_ALL_NAMES'
6720: ,'PARTY','SEARCH');
6721: ELSE

Line 6726: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

6722: x_stage_rec.TX39 := '';
6723: END IF;
6724: ELSE
6725: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6726: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
6727: x_stage_rec.TX39
6728: ,null,'PARTY_ALL_NAMES'
6729: ,'PARTY','SCORE');
6730: IF tmp IS NOT NULL THEN

Line 6738: HZ_TRANS_PKG.RM_SPLCHAR(

6734: END IF;
6735: IF p_search_ctx THEN
6736: IF p_search_rec.PARTY_NUMBER IS NOT NULL THEN
6737: x_stage_rec.TX34 :=
6738: HZ_TRANS_PKG.RM_SPLCHAR(
6739: p_search_rec.PARTY_NUMBER
6740: ,null,'PARTY_NUMBER'
6741: ,'PARTY','SEARCH');
6742: ELSE

Line 6747: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6743: x_stage_rec.TX34 := '';
6744: END IF;
6745: ELSE
6746: IF p_search_rec.PARTY_NUMBER IS NOT NULL THEN
6747: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6748: x_stage_rec.TX34
6749: ,null,'PARTY_NUMBER'
6750: ,'PARTY','SCORE');
6751: IF tmp IS NOT NULL THEN

Line 6759: HZ_TRANS_PKG.EXACT(

6755: END IF;
6756: IF p_search_ctx THEN
6757: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
6758: x_stage_rec.TX36 :=
6759: HZ_TRANS_PKG.EXACT(
6760: p_search_rec.PARTY_TYPE
6761: ,null,'PARTY_TYPE'
6762: ,'PARTY');
6763: ELSE

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

6768: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6769: l_party_name := p_search_rec.PARTY_ALL_NAMES;
6770: END IF;
6771: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
6772: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
6773: END IF;
6774: EXCEPTION
6775: WHEN OTHERS THEN
6776: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 6839: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6835: FOR I IN 1..p_search_list.COUNT LOOP
6836: IF p_search_ctx THEN
6837: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6838: x_stage_list(I).TX4 :=
6839: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6840: p_search_list(I).ADDRESS
6841: ,null,'ADDRESS'
6842: ,'PARTY_SITES','SEARCH');
6843: ELSE

Line 6848: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6844: x_stage_list(I).TX4 := '';
6845: END IF;
6846: ELSE
6847: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6848: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6849: x_stage_list(I).TX4
6850: ,null,'ADDRESS'
6851: ,'PARTY_SITES','SCORE');
6852: IF tmp IS NOT NULL THEN

Line 6862: HZ_TRANS_PKG.WRADDRESS_EXACT(

6858: FOR I IN 1..p_search_list.COUNT LOOP
6859: IF p_search_ctx THEN
6860: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6861: x_stage_list(I).TX3 :=
6862: HZ_TRANS_PKG.WRADDRESS_EXACT(
6863: p_search_list(I).ADDRESS
6864: ,null,'ADDRESS'
6865: ,'PARTY_SITES','SEARCH');
6866: ELSE

Line 6871: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

6867: x_stage_list(I).TX3 := '';
6868: END IF;
6869: ELSE
6870: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6871: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(
6872: x_stage_list(I).TX3
6873: ,null,'ADDRESS'
6874: ,'PARTY_SITES','SCORE');
6875: IF tmp IS NOT NULL THEN

Line 6885: HZ_TRANS_PKG.CLEANSE(

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

Line 6898: HZ_TRANS_PKG.EXACT(

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

Line 6911: HZ_TRANS_PKG.EXACT(

6907: FOR I IN 1..p_search_list.COUNT LOOP
6908: IF p_search_ctx THEN
6909: IF p_search_list(I).COUNTRY IS NOT NULL THEN
6910: x_stage_list(I).TX22 :=
6911: HZ_TRANS_PKG.EXACT(
6912: p_search_list(I).COUNTRY
6913: ,null,'COUNTRY'
6914: ,'PARTY_SITES');
6915: ELSE

Line 6924: HZ_TRANS_PKG.RM_SPLCHAR(

6920: FOR I IN 1..p_search_list.COUNT LOOP
6921: IF p_search_ctx THEN
6922: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6923: x_stage_list(I).TX11 :=
6924: HZ_TRANS_PKG.RM_SPLCHAR(
6925: p_search_list(I).POSTAL_CODE
6926: ,null,'POSTAL_CODE'
6927: ,'PARTY_SITES','SEARCH');
6928: ELSE

Line 6933: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

6929: x_stage_list(I).TX11 := '';
6930: END IF;
6931: ELSE
6932: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6933: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
6934: x_stage_list(I).TX11
6935: ,null,'POSTAL_CODE'
6936: ,'PARTY_SITES','SCORE');
6937: IF tmp IS NOT NULL THEN

Line 6947: HZ_TRANS_PKG.CLEANSE(

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

Line 6960: HZ_TRANS_PKG.EXACT(

6956: FOR I IN 1..p_search_list.COUNT LOOP
6957: IF p_search_ctx THEN
6958: IF p_search_list(I).PROVINCE IS NOT NULL THEN
6959: x_stage_list(I).TX12 :=
6960: HZ_TRANS_PKG.EXACT(
6961: p_search_list(I).PROVINCE
6962: ,null,'PROVINCE'
6963: ,'PARTY_SITES');
6964: ELSE

Line 6973: HZ_TRANS_PKG.WRSTATE_CLEANSE(

6969: FOR I IN 1..p_search_list.COUNT LOOP
6970: IF p_search_ctx THEN
6971: IF p_search_list(I).STATE IS NOT NULL THEN
6972: x_stage_list(I).TX15 :=
6973: HZ_TRANS_PKG.WRSTATE_CLEANSE(
6974: p_search_list(I).STATE
6975: ,null,'STATE'
6976: ,'PARTY_SITES','SEARCH');
6977: ELSE

Line 6982: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(

6978: x_stage_list(I).TX15 := '';
6979: END IF;
6980: ELSE
6981: IF p_search_list(I).STATE IS NOT NULL THEN
6982: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(
6983: x_stage_list(I).TX15
6984: ,null,'STATE'
6985: ,'PARTY_SITES','SCORE');
6986: IF tmp IS NOT NULL THEN

Line 6996: HZ_TRANS_PKG.WRSTATE_EXACT(

6992: FOR I IN 1..p_search_list.COUNT LOOP
6993: IF p_search_ctx THEN
6994: IF p_search_list(I).STATE IS NOT NULL THEN
6995: x_stage_list(I).TX14 :=
6996: HZ_TRANS_PKG.WRSTATE_EXACT(
6997: p_search_list(I).STATE
6998: ,null,'STATE'
6999: ,'PARTY_SITES','SEARCH');
7000: ELSE

Line 7005: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(

7001: x_stage_list(I).TX14 := '';
7002: END IF;
7003: ELSE
7004: IF p_search_list(I).STATE IS NOT NULL THEN
7005: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(
7006: x_stage_list(I).TX14
7007: ,null,'STATE'
7008: ,'PARTY_SITES','SCORE');
7009: IF tmp IS NOT NULL THEN

Line 7063: HZ_TRANS_PKG.EXACT(

7059: FOR I IN 1..p_search_list.COUNT LOOP
7060: IF p_search_ctx THEN
7061: IF p_search_list(I).JOB_TITLE IS NOT NULL THEN
7062: x_stage_list(I).TX22 :=
7063: HZ_TRANS_PKG.EXACT(
7064: p_search_list(I).JOB_TITLE
7065: ,null,'JOB_TITLE'
7066: ,'CONTACTS');
7067: ELSE

Line 7148: HZ_TRANS_PKG.CLEANSED_EMAIL(

7144: FOR I IN 1..p_search_list.COUNT LOOP
7145: IF p_search_ctx THEN
7146: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
7147: x_stage_list(I).TX6 :=
7148: HZ_TRANS_PKG.CLEANSED_EMAIL(
7149: p_search_list(I).EMAIL_ADDRESS
7150: ,null,'EMAIL_ADDRESS'
7151: ,'CONTACT_POINTS','SEARCH');
7152: ELSE

Line 7157: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(

7153: x_stage_list(I).TX6 := '';
7154: END IF;
7155: ELSE
7156: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
7157: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(
7158: x_stage_list(I).TX6
7159: ,null,'EMAIL_ADDRESS'
7160: ,'CONTACT_POINTS','SCORE');
7161: IF tmp IS NOT NULL THEN

Line 7171: HZ_TRANS_PKG.EXACT_EMAIL(

7167: FOR I IN 1..p_search_list.COUNT LOOP
7168: IF p_search_ctx THEN
7169: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
7170: x_stage_list(I).TX5 :=
7171: HZ_TRANS_PKG.EXACT_EMAIL(
7172: p_search_list(I).EMAIL_ADDRESS
7173: ,null,'EMAIL_ADDRESS'
7174: ,'CONTACT_POINTS');
7175: ELSE

Line 7184: HZ_TRANS_PKG.RM_SPLCHAR_CTX(

7180: FOR I IN 1..p_search_list.COUNT LOOP
7181: IF p_search_ctx THEN
7182: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
7183: x_stage_list(I).TX1 :=
7184: HZ_TRANS_PKG.RM_SPLCHAR_CTX(
7185: p_search_list(I).FLEX_FORMAT_PHONE_NUMBER
7186: ,null,'FLEX_FORMAT_PHONE_NUMBER'
7187: ,'CONTACT_POINTS','SEARCH');
7188: ELSE

Line 7193: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(

7189: x_stage_list(I).TX1 := '';
7190: END IF;
7191: ELSE
7192: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
7193: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(
7194: x_stage_list(I).TX1
7195: ,null,'FLEX_FORMAT_PHONE_NUMBER'
7196: ,'CONTACT_POINTS','SCORE');
7197: IF tmp IS NOT NULL THEN