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

Line 1109: HZ_TRANS_PKG.clear_globals;

1105: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1106: 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);
1107: END IF;
1108: -- Transform search criteria
1109: HZ_TRANS_PKG.clear_globals;
1110: MAP_PARTY_REC(FALSE,p_party_search_rec, l_dummy, g_party_stage_rec);
1111: MAP_PARTY_SITE_REC(FALSE,p_party_site_list, l_dummy, g_party_site_stage_list);
1112: MAP_CONTACT_REC(FALSE,p_contact_list, l_dummy, g_contact_stage_list);
1113: MAP_CONTACT_POINT_REC(FALSE,p_contact_point_list, l_dummy, g_contact_pt_stage_list);

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

1162: g_contact_pt_stage_list.DELETE;
1163: call_order.DELETE;
1164: call_max_score.DELETE;
1165: HZ_DQM_SEARCH_UTIL.new_search;
1166: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
1167: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1168:
1169: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1170: 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 3743: HZ_TRANS_PKG.EXACT(

3739: /********************* Find Parties private procedures *******/
3740: PROCEDURE set_person_party_type IS
3741: BEGIN
3742: g_party_stage_rec.TX36:=
3743: HZ_TRANS_PKG.EXACT(
3744: 'PERSON'
3745: ,null,'PARTY_TYPE'
3746: ,'PARTY');
3747: END;

Line 6608: HZ_TRANS_PKG.WRNAMES_CLEANSE(

6604: END IF;
6605: IF p_search_ctx THEN
6606: IF p_search_rec.ALL_ACCOUNT_NAMES IS NOT NULL THEN
6607: x_stage_rec.TX33 :=
6608: HZ_TRANS_PKG.WRNAMES_CLEANSE(
6609: p_search_rec.ALL_ACCOUNT_NAMES
6610: ,null,'ALL_ACCOUNT_NAMES'
6611: ,'PARTY','SEARCH');
6612: ELSE

Line 6617: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

6613: x_stage_rec.TX33 := '';
6614: END IF;
6615: ELSE
6616: IF p_search_rec.ALL_ACCOUNT_NAMES IS NOT NULL THEN
6617: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
6618: x_stage_rec.TX33
6619: ,null,'ALL_ACCOUNT_NAMES'
6620: ,'PARTY','SCORE');
6621: IF tmp IS NOT NULL THEN

Line 6629: HZ_TRANS_PKG.WRNAMES_EXACT(

6625: END IF;
6626: IF p_search_ctx THEN
6627: IF p_search_rec.ALL_ACCOUNT_NAMES IS NOT NULL THEN
6628: x_stage_rec.TX32 :=
6629: HZ_TRANS_PKG.WRNAMES_EXACT(
6630: p_search_rec.ALL_ACCOUNT_NAMES
6631: ,null,'ALL_ACCOUNT_NAMES'
6632: ,'PARTY','SEARCH');
6633: ELSE

Line 6638: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

6634: x_stage_rec.TX32 := '';
6635: END IF;
6636: ELSE
6637: IF p_search_rec.ALL_ACCOUNT_NAMES IS NOT NULL THEN
6638: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
6639: x_stage_rec.TX32
6640: ,null,'ALL_ACCOUNT_NAMES'
6641: ,'PARTY','SCORE');
6642: IF tmp IS NOT NULL THEN

Line 6650: HZ_TRANS_PKG.RM_SPLCHAR(

6646: END IF;
6647: IF p_search_ctx THEN
6648: IF p_search_rec.ALL_ACCOUNT_NUMBERS IS NOT NULL THEN
6649: x_stage_rec.TX35 :=
6650: HZ_TRANS_PKG.RM_SPLCHAR(
6651: p_search_rec.ALL_ACCOUNT_NUMBERS
6652: ,null,'ALL_ACCOUNT_NUMBERS'
6653: ,'PARTY','SEARCH');
6654: ELSE

Line 6659: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6655: x_stage_rec.TX35 := '';
6656: END IF;
6657: ELSE
6658: IF p_search_rec.ALL_ACCOUNT_NUMBERS IS NOT NULL THEN
6659: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6660: x_stage_rec.TX35
6661: ,null,'ALL_ACCOUNT_NUMBERS'
6662: ,'PARTY','SCORE');
6663: IF tmp IS NOT NULL THEN

Line 6671: HZ_TRANS_PKG.WRNAMES_CLEANSE(

6667: END IF;
6668: IF p_search_ctx THEN
6669: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6670: x_stage_rec.TX40 :=
6671: HZ_TRANS_PKG.WRNAMES_CLEANSE(
6672: p_search_rec.PARTY_ALL_NAMES
6673: ,null,'PARTY_ALL_NAMES'
6674: ,'PARTY','SEARCH');
6675: ELSE

Line 6680: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

6676: x_stage_rec.TX40 := '';
6677: END IF;
6678: ELSE
6679: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6680: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
6681: x_stage_rec.TX40
6682: ,null,'PARTY_ALL_NAMES'
6683: ,'PARTY','SCORE');
6684: IF tmp IS NOT NULL THEN

Line 6692: HZ_TRANS_PKG.WRNAMES_EXACT(

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

Line 6701: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

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

Line 6713: HZ_TRANS_PKG.RM_SPLCHAR(

6709: END IF;
6710: IF p_search_ctx THEN
6711: IF p_search_rec.PARTY_NUMBER IS NOT NULL THEN
6712: x_stage_rec.TX34 :=
6713: HZ_TRANS_PKG.RM_SPLCHAR(
6714: p_search_rec.PARTY_NUMBER
6715: ,null,'PARTY_NUMBER'
6716: ,'PARTY','SEARCH');
6717: ELSE

Line 6722: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6718: x_stage_rec.TX34 := '';
6719: END IF;
6720: ELSE
6721: IF p_search_rec.PARTY_NUMBER IS NOT NULL THEN
6722: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6723: x_stage_rec.TX34
6724: ,null,'PARTY_NUMBER'
6725: ,'PARTY','SCORE');
6726: IF tmp IS NOT NULL THEN

Line 6734: HZ_TRANS_PKG.EXACT(

6730: END IF;
6731: IF p_search_ctx THEN
6732: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
6733: x_stage_rec.TX36 :=
6734: HZ_TRANS_PKG.EXACT(
6735: p_search_rec.PARTY_TYPE
6736: ,null,'PARTY_TYPE'
6737: ,'PARTY');
6738: ELSE

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

6743: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6744: l_party_name := p_search_rec.PARTY_ALL_NAMES;
6745: END IF;
6746: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
6747: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
6748: END IF;
6749: EXCEPTION
6750: WHEN OTHERS THEN
6751: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 6815: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6811: FOR I IN 1..p_search_list.COUNT LOOP
6812: IF p_search_ctx THEN
6813: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6814: x_stage_list(I).TX4 :=
6815: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6816: p_search_list(I).ADDRESS
6817: ,null,'ADDRESS'
6818: ,'PARTY_SITES','SEARCH');
6819: ELSE

Line 6824: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6820: x_stage_list(I).TX4 := '';
6821: END IF;
6822: ELSE
6823: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6824: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6825: x_stage_list(I).TX4
6826: ,null,'ADDRESS'
6827: ,'PARTY_SITES','SCORE');
6828: IF tmp IS NOT NULL THEN

Line 6838: HZ_TRANS_PKG.WRADDRESS_EXACT(

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

Line 6847: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

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

Line 6861: HZ_TRANS_PKG.CLEANSE(

6857: FOR I IN 1..p_search_list.COUNT LOOP
6858: IF p_search_ctx THEN
6859: IF p_search_list(I).CITY IS NOT NULL THEN
6860: x_stage_list(I).TX10 :=
6861: HZ_TRANS_PKG.CLEANSE(
6862: p_search_list(I).CITY
6863: ,null,'CITY'
6864: ,'PARTY_SITES');
6865: ELSE

Line 6874: HZ_TRANS_PKG.EXACT(

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).TX9 :=
6874: HZ_TRANS_PKG.EXACT(
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).COUNTRY IS NOT NULL THEN
6886: x_stage_list(I).TX22 :=
6887: HZ_TRANS_PKG.EXACT(
6888: p_search_list(I).COUNTRY
6889: ,null,'COUNTRY'
6890: ,'PARTY_SITES');
6891: ELSE

Line 6900: HZ_TRANS_PKG.RM_SPLCHAR(

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

Line 6909: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

6905: x_stage_list(I).TX17 := '';
6906: END IF;
6907: ELSE
6908: IF p_search_list(I).PARTY_SITE_NUMBER IS NOT NULL THEN
6909: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
6910: x_stage_list(I).TX17
6911: ,null,'PARTY_SITE_NUMBER'
6912: ,'PARTY_SITES','SCORE');
6913: IF tmp IS NOT NULL THEN

Line 6923: HZ_TRANS_PKG.RM_SPLCHAR(

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

Line 6932: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

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

Line 6946: HZ_TRANS_PKG.WRSTATE_CLEANSE(

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

Line 6955: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(

6951: x_stage_list(I).TX15 := '';
6952: END IF;
6953: ELSE
6954: IF p_search_list(I).STATE IS NOT NULL THEN
6955: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(
6956: x_stage_list(I).TX15
6957: ,null,'STATE'
6958: ,'PARTY_SITES','SCORE');
6959: IF tmp IS NOT NULL THEN

Line 6969: HZ_TRANS_PKG.WRSTATE_EXACT(

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

Line 6978: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(

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

Line 7036: HZ_TRANS_PKG.SOUNDX(

7032: FOR I IN 1..p_search_list.COUNT LOOP
7033: IF p_search_ctx THEN
7034: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
7035: x_stage_list(I).TX156 :=
7036: HZ_TRANS_PKG.SOUNDX(
7037: p_search_list(I).CONTACT_NAME
7038: ,null,'CONTACT_NAME'
7039: ,'CONTACTS');
7040: ELSE

Line 7049: HZ_TRANS_PKG.WRPERSON_CLEANSE(

7045: FOR I IN 1..p_search_list.COUNT LOOP
7046: IF p_search_ctx THEN
7047: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
7048: x_stage_list(I).TX6 :=
7049: HZ_TRANS_PKG.WRPERSON_CLEANSE(
7050: p_search_list(I).CONTACT_NAME
7051: ,null,'CONTACT_NAME'
7052: ,'CONTACTS','SEARCH');
7053: ELSE

Line 7058: tmp := HZ_TRANS_PKG.WRPERSON_CLEANSE(

7054: x_stage_list(I).TX6 := '';
7055: END IF;
7056: ELSE
7057: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
7058: tmp := HZ_TRANS_PKG.WRPERSON_CLEANSE(
7059: x_stage_list(I).TX6
7060: ,null,'CONTACT_NAME'
7061: ,'CONTACTS','SCORE');
7062: IF tmp IS NOT NULL THEN

Line 7072: HZ_TRANS_PKG.WRPERSON_EXACT(

7068: FOR I IN 1..p_search_list.COUNT LOOP
7069: IF p_search_ctx THEN
7070: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
7071: x_stage_list(I).TX5 :=
7072: HZ_TRANS_PKG.WRPERSON_EXACT(
7073: p_search_list(I).CONTACT_NAME
7074: ,null,'CONTACT_NAME'
7075: ,'CONTACTS','SEARCH');
7076: ELSE

Line 7081: tmp := HZ_TRANS_PKG.WRPERSON_EXACT(

7077: x_stage_list(I).TX5 := '';
7078: END IF;
7079: ELSE
7080: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
7081: tmp := HZ_TRANS_PKG.WRPERSON_EXACT(
7082: x_stage_list(I).TX5
7083: ,null,'CONTACT_NAME'
7084: ,'CONTACTS','SCORE');
7085: IF tmp IS NOT NULL THEN

Line 7167: HZ_TRANS_PKG.CLEANSED_EMAIL(

7163: FOR I IN 1..p_search_list.COUNT LOOP
7164: IF p_search_ctx THEN
7165: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
7166: x_stage_list(I).TX6 :=
7167: HZ_TRANS_PKG.CLEANSED_EMAIL(
7168: p_search_list(I).EMAIL_ADDRESS
7169: ,null,'EMAIL_ADDRESS'
7170: ,'CONTACT_POINTS','SEARCH');
7171: ELSE

Line 7176: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(

7172: x_stage_list(I).TX6 := '';
7173: END IF;
7174: ELSE
7175: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
7176: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(
7177: x_stage_list(I).TX6
7178: ,null,'EMAIL_ADDRESS'
7179: ,'CONTACT_POINTS','SCORE');
7180: IF tmp IS NOT NULL THEN

Line 7190: HZ_TRANS_PKG.EXACT_EMAIL(

7186: FOR I IN 1..p_search_list.COUNT LOOP
7187: IF p_search_ctx THEN
7188: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
7189: x_stage_list(I).TX5 :=
7190: HZ_TRANS_PKG.EXACT_EMAIL(
7191: p_search_list(I).EMAIL_ADDRESS
7192: ,null,'EMAIL_ADDRESS'
7193: ,'CONTACT_POINTS');
7194: ELSE

Line 7203: HZ_TRANS_PKG.RM_SPLCHAR_CTX(

7199: FOR I IN 1..p_search_list.COUNT LOOP
7200: IF p_search_ctx THEN
7201: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
7202: x_stage_list(I).TX1 :=
7203: HZ_TRANS_PKG.RM_SPLCHAR_CTX(
7204: p_search_list(I).FLEX_FORMAT_PHONE_NUMBER
7205: ,null,'FLEX_FORMAT_PHONE_NUMBER'
7206: ,'CONTACT_POINTS','SEARCH');
7207: ELSE

Line 7212: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(

7208: x_stage_list(I).TX1 := '';
7209: END IF;
7210: ELSE
7211: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
7212: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(
7213: x_stage_list(I).TX1
7214: ,null,'FLEX_FORMAT_PHONE_NUMBER'
7215: ,'CONTACT_POINTS','SCORE');
7216: IF tmp IS NOT NULL THEN