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

3744: /********************* Find Parties private procedures *******/
3745: PROCEDURE set_person_party_type IS
3746: BEGIN
3747: g_party_stage_rec.TX36:=
3748: HZ_TRANS_PKG.EXACT(
3749: 'PERSON'
3750: ,null,'PARTY_TYPE'
3751: ,'PARTY');
3752: END;

Line 6619: HZ_TRANS_PKG.WRNAMES_CLEANSE(

6615: END IF;
6616: IF p_search_ctx THEN
6617: IF p_search_rec.ALL_ACCOUNT_NAMES IS NOT NULL THEN
6618: x_stage_rec.TX33 :=
6619: HZ_TRANS_PKG.WRNAMES_CLEANSE(
6620: p_search_rec.ALL_ACCOUNT_NAMES
6621: ,null,'ALL_ACCOUNT_NAMES'
6622: ,'PARTY','SEARCH');
6623: ELSE

Line 6628: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

6624: x_stage_rec.TX33 := '';
6625: END IF;
6626: ELSE
6627: IF p_search_rec.ALL_ACCOUNT_NAMES IS NOT NULL THEN
6628: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
6629: x_stage_rec.TX33
6630: ,null,'ALL_ACCOUNT_NAMES'
6631: ,'PARTY','SCORE');
6632: IF tmp IS NOT NULL THEN

Line 6640: HZ_TRANS_PKG.WRNAMES_EXACT(

6636: END IF;
6637: IF p_search_ctx THEN
6638: IF p_search_rec.ALL_ACCOUNT_NAMES IS NOT NULL THEN
6639: x_stage_rec.TX32 :=
6640: HZ_TRANS_PKG.WRNAMES_EXACT(
6641: p_search_rec.ALL_ACCOUNT_NAMES
6642: ,null,'ALL_ACCOUNT_NAMES'
6643: ,'PARTY','SEARCH');
6644: ELSE

Line 6649: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

6645: x_stage_rec.TX32 := '';
6646: END IF;
6647: ELSE
6648: IF p_search_rec.ALL_ACCOUNT_NAMES IS NOT NULL THEN
6649: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
6650: x_stage_rec.TX32
6651: ,null,'ALL_ACCOUNT_NAMES'
6652: ,'PARTY','SCORE');
6653: IF tmp IS NOT NULL THEN

Line 6661: HZ_TRANS_PKG.RM_SPLCHAR(

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

Line 6670: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6666: x_stage_rec.TX35 := '';
6667: END IF;
6668: ELSE
6669: IF p_search_rec.ALL_ACCOUNT_NUMBERS IS NOT NULL THEN
6670: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6671: x_stage_rec.TX35
6672: ,null,'ALL_ACCOUNT_NUMBERS'
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 6826: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

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

Line 6835: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

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

Line 6849: HZ_TRANS_PKG.WRADDRESS_EXACT(

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

Line 6858: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

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

Line 6872: HZ_TRANS_PKG.CLEANSE(

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

Line 6885: HZ_TRANS_PKG.EXACT(

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).TX9 :=
6885: HZ_TRANS_PKG.EXACT(
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).COUNTRY IS NOT NULL THEN
6897: x_stage_list(I).TX22 :=
6898: HZ_TRANS_PKG.EXACT(
6899: p_search_list(I).COUNTRY
6900: ,null,'COUNTRY'
6901: ,'PARTY_SITES');
6902: ELSE

Line 6911: HZ_TRANS_PKG.RM_SPLCHAR(

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

Line 6920: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

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

Line 6934: HZ_TRANS_PKG.RM_SPLCHAR(

6930: FOR I IN 1..p_search_list.COUNT LOOP
6931: IF p_search_ctx THEN
6932: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6933: x_stage_list(I).TX11 :=
6934: HZ_TRANS_PKG.RM_SPLCHAR(
6935: p_search_list(I).POSTAL_CODE
6936: ,null,'POSTAL_CODE'
6937: ,'PARTY_SITES','SEARCH');
6938: ELSE

Line 6943: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

6939: x_stage_list(I).TX11 := '';
6940: END IF;
6941: ELSE
6942: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6943: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
6944: x_stage_list(I).TX11
6945: ,null,'POSTAL_CODE'
6946: ,'PARTY_SITES','SCORE');
6947: IF tmp IS NOT NULL THEN

Line 6957: HZ_TRANS_PKG.WRSTATE_CLEANSE(

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

Line 6966: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(

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

Line 6980: HZ_TRANS_PKG.WRSTATE_EXACT(

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

Line 6989: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(

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

Line 7047: HZ_TRANS_PKG.SOUNDX(

7043: FOR I IN 1..p_search_list.COUNT LOOP
7044: IF p_search_ctx THEN
7045: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
7046: x_stage_list(I).TX156 :=
7047: HZ_TRANS_PKG.SOUNDX(
7048: p_search_list(I).CONTACT_NAME
7049: ,null,'CONTACT_NAME'
7050: ,'CONTACTS');
7051: ELSE

Line 7060: HZ_TRANS_PKG.WRPERSON_CLEANSE(

7056: FOR I IN 1..p_search_list.COUNT LOOP
7057: IF p_search_ctx THEN
7058: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
7059: x_stage_list(I).TX6 :=
7060: HZ_TRANS_PKG.WRPERSON_CLEANSE(
7061: p_search_list(I).CONTACT_NAME
7062: ,null,'CONTACT_NAME'
7063: ,'CONTACTS','SEARCH');
7064: ELSE

Line 7069: tmp := HZ_TRANS_PKG.WRPERSON_CLEANSE(

7065: x_stage_list(I).TX6 := '';
7066: END IF;
7067: ELSE
7068: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
7069: tmp := HZ_TRANS_PKG.WRPERSON_CLEANSE(
7070: x_stage_list(I).TX6
7071: ,null,'CONTACT_NAME'
7072: ,'CONTACTS','SCORE');
7073: IF tmp IS NOT NULL THEN

Line 7083: HZ_TRANS_PKG.WRPERSON_EXACT(

7079: FOR I IN 1..p_search_list.COUNT LOOP
7080: IF p_search_ctx THEN
7081: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
7082: x_stage_list(I).TX5 :=
7083: HZ_TRANS_PKG.WRPERSON_EXACT(
7084: p_search_list(I).CONTACT_NAME
7085: ,null,'CONTACT_NAME'
7086: ,'CONTACTS','SEARCH');
7087: ELSE

Line 7092: tmp := HZ_TRANS_PKG.WRPERSON_EXACT(

7088: x_stage_list(I).TX5 := '';
7089: END IF;
7090: ELSE
7091: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
7092: tmp := HZ_TRANS_PKG.WRPERSON_EXACT(
7093: x_stage_list(I).TX5
7094: ,null,'CONTACT_NAME'
7095: ,'CONTACTS','SCORE');
7096: IF tmp IS NOT NULL THEN

Line 7178: HZ_TRANS_PKG.CLEANSED_EMAIL(

7174: FOR I IN 1..p_search_list.COUNT LOOP
7175: IF p_search_ctx THEN
7176: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
7177: x_stage_list(I).TX6 :=
7178: HZ_TRANS_PKG.CLEANSED_EMAIL(
7179: p_search_list(I).EMAIL_ADDRESS
7180: ,null,'EMAIL_ADDRESS'
7181: ,'CONTACT_POINTS','SEARCH');
7182: ELSE

Line 7187: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(

7183: x_stage_list(I).TX6 := '';
7184: END IF;
7185: ELSE
7186: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
7187: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(
7188: x_stage_list(I).TX6
7189: ,null,'EMAIL_ADDRESS'
7190: ,'CONTACT_POINTS','SCORE');
7191: IF tmp IS NOT NULL THEN

Line 7201: HZ_TRANS_PKG.EXACT_EMAIL(

7197: FOR I IN 1..p_search_list.COUNT LOOP
7198: IF p_search_ctx THEN
7199: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
7200: x_stage_list(I).TX5 :=
7201: HZ_TRANS_PKG.EXACT_EMAIL(
7202: p_search_list(I).EMAIL_ADDRESS
7203: ,null,'EMAIL_ADDRESS'
7204: ,'CONTACT_POINTS');
7205: ELSE

Line 7214: HZ_TRANS_PKG.RM_SPLCHAR_CTX(

7210: FOR I IN 1..p_search_list.COUNT LOOP
7211: IF p_search_ctx THEN
7212: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
7213: x_stage_list(I).TX1 :=
7214: HZ_TRANS_PKG.RM_SPLCHAR_CTX(
7215: p_search_list(I).FLEX_FORMAT_PHONE_NUMBER
7216: ,null,'FLEX_FORMAT_PHONE_NUMBER'
7217: ,'CONTACT_POINTS','SEARCH');
7218: ELSE

Line 7223: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(

7219: x_stage_list(I).TX1 := '';
7220: END IF;
7221: ELSE
7222: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
7223: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(
7224: x_stage_list(I).TX1
7225: ,null,'FLEX_FORMAT_PHONE_NUMBER'
7226: ,'CONTACT_POINTS','SCORE');
7227: IF tmp IS NOT NULL THEN