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

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

Line 6636: HZ_TRANS_PKG.RM_SPLCHAR(

6632: END IF;
6633: IF p_search_ctx THEN
6634: IF p_search_rec.ALL_ACCOUNT_NUMBERS IS NOT NULL THEN
6635: x_stage_rec.TX35 :=
6636: HZ_TRANS_PKG.RM_SPLCHAR(
6637: p_search_rec.ALL_ACCOUNT_NUMBERS
6638: ,null,'ALL_ACCOUNT_NUMBERS'
6639: ,'PARTY','SEARCH');
6640: ELSE

Line 6645: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6641: x_stage_rec.TX35 := '';
6642: END IF;
6643: ELSE
6644: IF p_search_rec.ALL_ACCOUNT_NUMBERS IS NOT NULL THEN
6645: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6646: x_stage_rec.TX35
6647: ,null,'ALL_ACCOUNT_NUMBERS'
6648: ,'PARTY','SCORE');
6649: IF tmp IS NOT NULL THEN

Line 6657: HZ_TRANS_PKG.EXACT(

6653: END IF;
6654: IF p_search_ctx THEN
6655: IF p_search_rec.DUNS_NUMBER_C IS NOT NULL THEN
6656: x_stage_rec.TX41 :=
6657: HZ_TRANS_PKG.EXACT(
6658: p_search_rec.DUNS_NUMBER_C
6659: ,null,'DUNS_NUMBER_C'
6660: ,'PARTY');
6661: ELSE

Line 6672: HZ_TRANS_PKG.RM_SPLCHAR(

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

Line 6681: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

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

Line 6693: HZ_TRANS_PKG.WRNAMES_CLEANSE(

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

Line 6702: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

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

Line 6714: HZ_TRANS_PKG.WRNAMES_EXACT(

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

Line 6723: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

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

Line 6735: HZ_TRANS_PKG.RM_SPLCHAR(

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

Line 6744: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

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

Line 6756: HZ_TRANS_PKG.EXACT(

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

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

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

Line 6836: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

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

Line 6845: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

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

Line 6859: HZ_TRANS_PKG.WRADDRESS_EXACT(

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

Line 6868: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

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

Line 6882: HZ_TRANS_PKG.CLEANSE(

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

Line 6895: HZ_TRANS_PKG.EXACT(

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

Line 6908: HZ_TRANS_PKG.EXACT(

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

Line 6921: HZ_TRANS_PKG.RM_SPLCHAR(

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

Line 6930: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

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

Line 6944: HZ_TRANS_PKG.CLEANSE(

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

Line 6957: HZ_TRANS_PKG.EXACT(

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

Line 6970: HZ_TRANS_PKG.WRSTATE_CLEANSE(

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

Line 6979: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(

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

Line 6993: HZ_TRANS_PKG.WRSTATE_EXACT(

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

Line 7002: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(

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

Line 7130: HZ_TRANS_PKG.RM_SPLCHAR_CTX(

7126: FOR I IN 1..p_search_list.COUNT LOOP
7127: IF p_search_ctx THEN
7128: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
7129: x_stage_list(I).TX1 :=
7130: HZ_TRANS_PKG.RM_SPLCHAR_CTX(
7131: p_search_list(I).FLEX_FORMAT_PHONE_NUMBER
7132: ,null,'FLEX_FORMAT_PHONE_NUMBER'
7133: ,'CONTACT_POINTS','SEARCH');
7134: ELSE

Line 7139: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(

7135: x_stage_list(I).TX1 := '';
7136: END IF;
7137: ELSE
7138: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
7139: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(
7140: x_stage_list(I).TX1
7141: ,null,'FLEX_FORMAT_PHONE_NUMBER'
7142: ,'CONTACT_POINTS','SCORE');
7143: IF tmp IS NOT NULL THEN

Line 7153: HZ_TRANS_PKG.CLEANSED_URL(

7149: FOR I IN 1..p_search_list.COUNT LOOP
7150: IF p_search_ctx THEN
7151: IF p_search_list(I).URL IS NOT NULL THEN
7152: x_stage_list(I).TX8 :=
7153: HZ_TRANS_PKG.CLEANSED_URL(
7154: p_search_list(I).URL
7155: ,null,'URL'
7156: ,'CONTACT_POINTS','SEARCH');
7157: ELSE

Line 7162: tmp := HZ_TRANS_PKG.CLEANSED_URL(

7158: x_stage_list(I).TX8 := '';
7159: END IF;
7160: ELSE
7161: IF p_search_list(I).URL IS NOT NULL THEN
7162: tmp := HZ_TRANS_PKG.CLEANSED_URL(
7163: x_stage_list(I).TX8
7164: ,null,'URL'
7165: ,'CONTACT_POINTS','SCORE');
7166: IF tmp IS NOT NULL THEN

Line 7176: HZ_TRANS_PKG.EXACT_URL(

7172: FOR I IN 1..p_search_list.COUNT LOOP
7173: IF p_search_ctx THEN
7174: IF p_search_list(I).URL IS NOT NULL THEN
7175: x_stage_list(I).TX7 :=
7176: HZ_TRANS_PKG.EXACT_URL(
7177: p_search_list(I).URL
7178: ,null,'URL'
7179: ,'CONTACT_POINTS');
7180: ELSE