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_62 dependencies on HZ_TRANS_PKG

Line 1125: HZ_TRANS_PKG.clear_globals;

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

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

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

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

Line 6625: HZ_TRANS_PKG.RM_SPLCHAR(

6621: END IF;
6622: IF p_search_ctx THEN
6623: IF p_search_rec.ALL_ACCOUNT_NUMBERS IS NOT NULL THEN
6624: x_stage_rec.TX35 :=
6625: HZ_TRANS_PKG.RM_SPLCHAR(
6626: p_search_rec.ALL_ACCOUNT_NUMBERS
6627: ,null,'ALL_ACCOUNT_NUMBERS'
6628: ,'PARTY','SEARCH');
6629: ELSE

Line 6634: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6630: x_stage_rec.TX35 := '';
6631: END IF;
6632: ELSE
6633: IF p_search_rec.ALL_ACCOUNT_NUMBERS IS NOT NULL THEN
6634: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6635: x_stage_rec.TX35
6636: ,null,'ALL_ACCOUNT_NUMBERS'
6637: ,'PARTY','SCORE');
6638: IF tmp IS NOT NULL THEN

Line 6646: HZ_TRANS_PKG.EXACT(

6642: END IF;
6643: IF p_search_ctx THEN
6644: IF p_search_rec.DUNS_NUMBER_C IS NOT NULL THEN
6645: x_stage_rec.TX41 :=
6646: HZ_TRANS_PKG.EXACT(
6647: p_search_rec.DUNS_NUMBER_C
6648: ,null,'DUNS_NUMBER_C'
6649: ,'PARTY');
6650: ELSE

Line 6661: HZ_TRANS_PKG.RM_SPLCHAR(

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

Line 6670: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

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

Line 6682: HZ_TRANS_PKG.WRNAMES_CLEANSE(

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

Line 6691: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

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

Line 6703: HZ_TRANS_PKG.WRNAMES_EXACT(

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

Line 6712: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

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

Line 6724: HZ_TRANS_PKG.RM_SPLCHAR(

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

Line 6733: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

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

Line 6745: HZ_TRANS_PKG.EXACT(

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

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

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

Line 6825: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

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

Line 6834: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

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

Line 6848: HZ_TRANS_PKG.WRADDRESS_EXACT(

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

Line 6857: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

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

Line 6871: HZ_TRANS_PKG.CLEANSE(

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

Line 6884: HZ_TRANS_PKG.EXACT(

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

Line 6897: HZ_TRANS_PKG.EXACT(

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

Line 6910: HZ_TRANS_PKG.RM_SPLCHAR(

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

Line 6919: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

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

Line 6933: HZ_TRANS_PKG.CLEANSE(

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

Line 6946: HZ_TRANS_PKG.EXACT(

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

Line 6959: HZ_TRANS_PKG.WRSTATE_CLEANSE(

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

Line 6968: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(

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

Line 6982: HZ_TRANS_PKG.WRSTATE_EXACT(

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

Line 6991: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(

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

Line 7119: HZ_TRANS_PKG.RM_SPLCHAR_CTX(

7115: FOR I IN 1..p_search_list.COUNT LOOP
7116: IF p_search_ctx THEN
7117: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
7118: x_stage_list(I).TX1 :=
7119: HZ_TRANS_PKG.RM_SPLCHAR_CTX(
7120: p_search_list(I).FLEX_FORMAT_PHONE_NUMBER
7121: ,null,'FLEX_FORMAT_PHONE_NUMBER'
7122: ,'CONTACT_POINTS','SEARCH');
7123: ELSE

Line 7128: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(

7124: x_stage_list(I).TX1 := '';
7125: END IF;
7126: ELSE
7127: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
7128: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(
7129: x_stage_list(I).TX1
7130: ,null,'FLEX_FORMAT_PHONE_NUMBER'
7131: ,'CONTACT_POINTS','SCORE');
7132: IF tmp IS NOT NULL THEN

Line 7142: HZ_TRANS_PKG.CLEANSED_URL(

7138: FOR I IN 1..p_search_list.COUNT LOOP
7139: IF p_search_ctx THEN
7140: IF p_search_list(I).URL IS NOT NULL THEN
7141: x_stage_list(I).TX8 :=
7142: HZ_TRANS_PKG.CLEANSED_URL(
7143: p_search_list(I).URL
7144: ,null,'URL'
7145: ,'CONTACT_POINTS','SEARCH');
7146: ELSE

Line 7151: tmp := HZ_TRANS_PKG.CLEANSED_URL(

7147: x_stage_list(I).TX8 := '';
7148: END IF;
7149: ELSE
7150: IF p_search_list(I).URL IS NOT NULL THEN
7151: tmp := HZ_TRANS_PKG.CLEANSED_URL(
7152: x_stage_list(I).TX8
7153: ,null,'URL'
7154: ,'CONTACT_POINTS','SCORE');
7155: IF tmp IS NOT NULL THEN

Line 7165: HZ_TRANS_PKG.EXACT_URL(

7161: FOR I IN 1..p_search_list.COUNT LOOP
7162: IF p_search_ctx THEN
7163: IF p_search_list(I).URL IS NOT NULL THEN
7164: x_stage_list(I).TX7 :=
7165: HZ_TRANS_PKG.EXACT_URL(
7166: p_search_list(I).URL
7167: ,null,'URL'
7168: ,'CONTACT_POINTS');
7169: ELSE