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

Line 1232: HZ_TRANS_PKG.clear_globals;

1228: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1229: 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);
1230: END IF;
1231: -- Transform search criteria
1232: HZ_TRANS_PKG.clear_globals;
1233: MAP_PARTY_REC(FALSE,p_party_search_rec, l_dummy, g_party_stage_rec);
1234: MAP_PARTY_SITE_REC(FALSE,p_party_site_list, l_dummy, g_party_site_stage_list);
1235: MAP_CONTACT_REC(FALSE,p_contact_list, l_dummy, g_contact_stage_list);
1236: MAP_CONTACT_POINT_REC(FALSE,p_contact_point_list, l_dummy, g_contact_pt_stage_list);

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

1285: g_contact_pt_stage_list.DELETE;
1286: call_order.DELETE;
1287: call_max_score.DELETE;
1288: HZ_DQM_SEARCH_UTIL.new_search;
1289: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
1290: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1291:
1292: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1293: 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 3925: HZ_TRANS_PKG.EXACT(

3921: /********************* Find Parties private procedures *******/
3922: PROCEDURE set_person_party_type IS
3923: BEGIN
3924: g_party_stage_rec.TX36:=
3925: HZ_TRANS_PKG.EXACT(
3926: 'PERSON'
3927: ,null,'PARTY_TYPE'
3928: ,'PARTY');
3929: END;

Line 6830: HZ_TRANS_PKG.RM_SPLCHAR(

6826: END IF;
6827: IF p_search_ctx THEN
6828: IF p_search_rec.JGZZ_FISCAL_CODE IS NOT NULL THEN
6829: x_stage_rec.TX45 :=
6830: HZ_TRANS_PKG.RM_SPLCHAR(
6831: p_search_rec.JGZZ_FISCAL_CODE
6832: ,null,'JGZZ_FISCAL_CODE'
6833: ,'PARTY','SEARCH');
6834: ELSE

Line 6839: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6835: x_stage_rec.TX45 := '';
6836: END IF;
6837: ELSE
6838: IF p_search_rec.JGZZ_FISCAL_CODE IS NOT NULL THEN
6839: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6840: x_stage_rec.TX45
6841: ,null,'JGZZ_FISCAL_CODE'
6842: ,'PARTY','SCORE');
6843: IF tmp IS NOT NULL THEN

Line 6851: HZ_TRANS_PKG.SOUNDX(

6847: END IF;
6848: IF p_search_ctx THEN
6849: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6850: x_stage_rec.TX158 :=
6851: HZ_TRANS_PKG.SOUNDX(
6852: p_search_rec.PARTY_ALL_NAMES
6853: ,null,'PARTY_ALL_NAMES'
6854: ,'PARTY');
6855: ELSE

Line 6862: HZ_TRANS_PKG.WRNAMES_CLEANSE(

6858: END IF;
6859: IF p_search_ctx THEN
6860: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6861: x_stage_rec.TX40 :=
6862: HZ_TRANS_PKG.WRNAMES_CLEANSE(
6863: p_search_rec.PARTY_ALL_NAMES
6864: ,null,'PARTY_ALL_NAMES'
6865: ,'PARTY','SEARCH');
6866: ELSE

Line 6871: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

6867: x_stage_rec.TX40 := '';
6868: END IF;
6869: ELSE
6870: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6871: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
6872: x_stage_rec.TX40
6873: ,null,'PARTY_ALL_NAMES'
6874: ,'PARTY','SCORE');
6875: IF tmp IS NOT NULL THEN

Line 6883: HZ_TRANS_PKG.WRNAMES_EXACT(

6879: END IF;
6880: IF p_search_ctx THEN
6881: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6882: x_stage_rec.TX39 :=
6883: HZ_TRANS_PKG.WRNAMES_EXACT(
6884: p_search_rec.PARTY_ALL_NAMES
6885: ,null,'PARTY_ALL_NAMES'
6886: ,'PARTY','SEARCH');
6887: ELSE

Line 6892: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

6888: x_stage_rec.TX39 := '';
6889: END IF;
6890: ELSE
6891: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6892: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
6893: x_stage_rec.TX39
6894: ,null,'PARTY_ALL_NAMES'
6895: ,'PARTY','SCORE');
6896: IF tmp IS NOT NULL THEN

Line 6904: HZ_TRANS_PKG.RM_SPLCHAR(

6900: END IF;
6901: IF p_search_ctx THEN
6902: IF p_search_rec.PARTY_NUMBER IS NOT NULL THEN
6903: x_stage_rec.TX34 :=
6904: HZ_TRANS_PKG.RM_SPLCHAR(
6905: p_search_rec.PARTY_NUMBER
6906: ,null,'PARTY_NUMBER'
6907: ,'PARTY','SEARCH');
6908: ELSE

Line 6913: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6909: x_stage_rec.TX34 := '';
6910: END IF;
6911: ELSE
6912: IF p_search_rec.PARTY_NUMBER IS NOT NULL THEN
6913: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6914: x_stage_rec.TX34
6915: ,null,'PARTY_NUMBER'
6916: ,'PARTY','SCORE');
6917: IF tmp IS NOT NULL THEN

Line 6924: HZ_TRANS_PKG.EXACT(

6920: END IF;
6921: END IF;
6922: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
6923: x_stage_rec.TX36 :=
6924: HZ_TRANS_PKG.EXACT(
6925: p_search_rec.PARTY_TYPE
6926: ,null,'PARTY_TYPE'
6927: ,'PARTY');
6928: ELSE

Line 6934: HZ_TRANS_PKG.EXACT(

6930: END IF;
6931: IF p_search_ctx THEN
6932: IF p_search_rec.SIC_CODE IS NOT NULL THEN
6933: x_stage_rec.TX46 :=
6934: HZ_TRANS_PKG.EXACT(
6935: p_search_rec.SIC_CODE
6936: ,null,'SIC_CODE'
6937: ,'PARTY');
6938: ELSE

Line 6945: HZ_TRANS_PKG.EXACT(

6941: END IF;
6942: IF p_search_ctx THEN
6943: IF p_search_rec.SIC_CODE_TYPE IS NOT NULL THEN
6944: x_stage_rec.TX47 :=
6945: HZ_TRANS_PKG.EXACT(
6946: p_search_rec.SIC_CODE_TYPE
6947: ,null,'SIC_CODE_TYPE'
6948: ,'PARTY');
6949: ELSE

Line 6956: HZ_TRANS_PKG.RM_SPLCHAR(

6952: END IF;
6953: IF p_search_ctx THEN
6954: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
6955: x_stage_rec.TX44 :=
6956: HZ_TRANS_PKG.RM_SPLCHAR(
6957: p_search_rec.TAX_REFERENCE
6958: ,null,'TAX_REFERENCE'
6959: ,'PARTY','SEARCH');
6960: ELSE

Line 6965: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6961: x_stage_rec.TX44 := '';
6962: END IF;
6963: ELSE
6964: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
6965: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6966: x_stage_rec.TX44
6967: ,null,'TAX_REFERENCE'
6968: ,'PARTY','SCORE');
6969: IF tmp IS NOT NULL THEN

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

6975: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6976: l_party_name := p_search_rec.PARTY_ALL_NAMES;
6977: END IF;
6978: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
6979: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
6980: END IF;
6981: EXCEPTION
6982: WHEN OTHERS THEN
6983: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 7043: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

7039: FOR I IN 1..p_search_list.COUNT LOOP
7040: IF p_search_ctx THEN
7041: IF p_search_list(I).ADDRESS IS NOT NULL THEN
7042: x_stage_list(I).TX4 :=
7043: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
7044: p_search_list(I).ADDRESS
7045: ,null,'ADDRESS'
7046: ,'PARTY_SITES','SEARCH');
7047: ELSE

Line 7052: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

7048: x_stage_list(I).TX4 := '';
7049: END IF;
7050: ELSE
7051: IF p_search_list(I).ADDRESS IS NOT NULL THEN
7052: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
7053: x_stage_list(I).TX4
7054: ,null,'ADDRESS'
7055: ,'PARTY_SITES','SCORE');
7056: IF tmp IS NOT NULL THEN

Line 7066: HZ_TRANS_PKG.WRADDRESS_EXACT(

7062: FOR I IN 1..p_search_list.COUNT LOOP
7063: IF p_search_ctx THEN
7064: IF p_search_list(I).ADDRESS IS NOT NULL THEN
7065: x_stage_list(I).TX3 :=
7066: HZ_TRANS_PKG.WRADDRESS_EXACT(
7067: p_search_list(I).ADDRESS
7068: ,null,'ADDRESS'
7069: ,'PARTY_SITES','SEARCH');
7070: ELSE

Line 7075: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

7071: x_stage_list(I).TX3 := '';
7072: END IF;
7073: ELSE
7074: IF p_search_list(I).ADDRESS IS NOT NULL THEN
7075: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(
7076: x_stage_list(I).TX3
7077: ,null,'ADDRESS'
7078: ,'PARTY_SITES','SCORE');
7079: IF tmp IS NOT NULL THEN

Line 7089: HZ_TRANS_PKG.CLEANSE(

7085: FOR I IN 1..p_search_list.COUNT LOOP
7086: IF p_search_ctx THEN
7087: IF p_search_list(I).CITY IS NOT NULL THEN
7088: x_stage_list(I).TX10 :=
7089: HZ_TRANS_PKG.CLEANSE(
7090: p_search_list(I).CITY
7091: ,null,'CITY'
7092: ,'PARTY_SITES');
7093: ELSE

Line 7102: HZ_TRANS_PKG.EXACT(

7098: FOR I IN 1..p_search_list.COUNT LOOP
7099: IF p_search_ctx THEN
7100: IF p_search_list(I).CITY IS NOT NULL THEN
7101: x_stage_list(I).TX9 :=
7102: HZ_TRANS_PKG.EXACT(
7103: p_search_list(I).CITY
7104: ,null,'CITY'
7105: ,'PARTY_SITES');
7106: ELSE

Line 7115: HZ_TRANS_PKG.EXACT(

7111: FOR I IN 1..p_search_list.COUNT LOOP
7112: IF p_search_ctx THEN
7113: IF p_search_list(I).COUNTRY IS NOT NULL THEN
7114: x_stage_list(I).TX22 :=
7115: HZ_TRANS_PKG.EXACT(
7116: p_search_list(I).COUNTRY
7117: ,null,'COUNTRY'
7118: ,'PARTY_SITES');
7119: ELSE

Line 7128: HZ_TRANS_PKG.RM_SPLCHAR(

7124: FOR I IN 1..p_search_list.COUNT LOOP
7125: IF p_search_ctx THEN
7126: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
7127: x_stage_list(I).TX11 :=
7128: HZ_TRANS_PKG.RM_SPLCHAR(
7129: p_search_list(I).POSTAL_CODE
7130: ,null,'POSTAL_CODE'
7131: ,'PARTY_SITES','SEARCH');
7132: ELSE

Line 7137: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

7133: x_stage_list(I).TX11 := '';
7134: END IF;
7135: ELSE
7136: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
7137: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
7138: x_stage_list(I).TX11
7139: ,null,'POSTAL_CODE'
7140: ,'PARTY_SITES','SCORE');
7141: IF tmp IS NOT NULL THEN

Line 7151: HZ_TRANS_PKG.WRSTATE_CLEANSE(

7147: FOR I IN 1..p_search_list.COUNT LOOP
7148: IF p_search_ctx THEN
7149: IF p_search_list(I).STATE IS NOT NULL THEN
7150: x_stage_list(I).TX15 :=
7151: HZ_TRANS_PKG.WRSTATE_CLEANSE(
7152: p_search_list(I).STATE
7153: ,null,'STATE'
7154: ,'PARTY_SITES','SEARCH');
7155: ELSE

Line 7160: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(

7156: x_stage_list(I).TX15 := '';
7157: END IF;
7158: ELSE
7159: IF p_search_list(I).STATE IS NOT NULL THEN
7160: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(
7161: x_stage_list(I).TX15
7162: ,null,'STATE'
7163: ,'PARTY_SITES','SCORE');
7164: IF tmp IS NOT NULL THEN

Line 7174: HZ_TRANS_PKG.WRSTATE_EXACT(

7170: FOR I IN 1..p_search_list.COUNT LOOP
7171: IF p_search_ctx THEN
7172: IF p_search_list(I).STATE IS NOT NULL THEN
7173: x_stage_list(I).TX14 :=
7174: HZ_TRANS_PKG.WRSTATE_EXACT(
7175: p_search_list(I).STATE
7176: ,null,'STATE'
7177: ,'PARTY_SITES','SEARCH');
7178: ELSE

Line 7183: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(

7179: x_stage_list(I).TX14 := '';
7180: END IF;
7181: ELSE
7182: IF p_search_list(I).STATE IS NOT NULL THEN
7183: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(
7184: x_stage_list(I).TX14
7185: ,null,'STATE'
7186: ,'PARTY_SITES','SCORE');
7187: IF tmp IS NOT NULL THEN

Line 7241: HZ_TRANS_PKG.EXACT_PADDED(

7237: FOR I IN 1..p_search_list.COUNT LOOP
7238: IF p_search_ctx THEN
7239: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
7240: x_stage_list(I).TX2 :=
7241: HZ_TRANS_PKG.EXACT_PADDED(
7242: p_search_list(I).CONTACT_NAME
7243: ,null,'CONTACT_NAME'
7244: ,'CONTACTS');
7245: ELSE

Line 7254: HZ_TRANS_PKG.SOUNDX(

7250: FOR I IN 1..p_search_list.COUNT LOOP
7251: IF p_search_ctx THEN
7252: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
7253: x_stage_list(I).TX156 :=
7254: HZ_TRANS_PKG.SOUNDX(
7255: p_search_list(I).CONTACT_NAME
7256: ,null,'CONTACT_NAME'
7257: ,'CONTACTS');
7258: ELSE

Line 7267: HZ_TRANS_PKG.WRPERSON_CLEANSE(

7263: FOR I IN 1..p_search_list.COUNT LOOP
7264: IF p_search_ctx THEN
7265: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
7266: x_stage_list(I).TX6 :=
7267: HZ_TRANS_PKG.WRPERSON_CLEANSE(
7268: p_search_list(I).CONTACT_NAME
7269: ,null,'CONTACT_NAME'
7270: ,'CONTACTS','SEARCH');
7271: ELSE

Line 7276: tmp := HZ_TRANS_PKG.WRPERSON_CLEANSE(

7272: x_stage_list(I).TX6 := '';
7273: END IF;
7274: ELSE
7275: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
7276: tmp := HZ_TRANS_PKG.WRPERSON_CLEANSE(
7277: x_stage_list(I).TX6
7278: ,null,'CONTACT_NAME'
7279: ,'CONTACTS','SCORE');
7280: IF tmp IS NOT NULL THEN

Line 7290: HZ_TRANS_PKG.WRPERSON_EXACT(

7286: FOR I IN 1..p_search_list.COUNT LOOP
7287: IF p_search_ctx THEN
7288: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
7289: x_stage_list(I).TX5 :=
7290: HZ_TRANS_PKG.WRPERSON_EXACT(
7291: p_search_list(I).CONTACT_NAME
7292: ,null,'CONTACT_NAME'
7293: ,'CONTACTS','SEARCH');
7294: ELSE

Line 7299: tmp := HZ_TRANS_PKG.WRPERSON_EXACT(

7295: x_stage_list(I).TX5 := '';
7296: END IF;
7297: ELSE
7298: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
7299: tmp := HZ_TRANS_PKG.WRPERSON_EXACT(
7300: x_stage_list(I).TX5
7301: ,null,'CONTACT_NAME'
7302: ,'CONTACTS','SCORE');
7303: IF tmp IS NOT NULL THEN

Line 7385: HZ_TRANS_PKG.CLEANSED_EMAIL(

7381: FOR I IN 1..p_search_list.COUNT LOOP
7382: IF p_search_ctx THEN
7383: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
7384: x_stage_list(I).TX6 :=
7385: HZ_TRANS_PKG.CLEANSED_EMAIL(
7386: p_search_list(I).EMAIL_ADDRESS
7387: ,null,'EMAIL_ADDRESS'
7388: ,'CONTACT_POINTS','SEARCH');
7389: ELSE

Line 7394: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(

7390: x_stage_list(I).TX6 := '';
7391: END IF;
7392: ELSE
7393: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
7394: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(
7395: x_stage_list(I).TX6
7396: ,null,'EMAIL_ADDRESS'
7397: ,'CONTACT_POINTS','SCORE');
7398: IF tmp IS NOT NULL THEN

Line 7408: HZ_TRANS_PKG.EXACT_EMAIL(

7404: FOR I IN 1..p_search_list.COUNT LOOP
7405: IF p_search_ctx THEN
7406: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
7407: x_stage_list(I).TX5 :=
7408: HZ_TRANS_PKG.EXACT_EMAIL(
7409: p_search_list(I).EMAIL_ADDRESS
7410: ,null,'EMAIL_ADDRESS'
7411: ,'CONTACT_POINTS');
7412: ELSE

Line 7421: HZ_TRANS_PKG.RM_SPLCHAR_CTX(

7417: FOR I IN 1..p_search_list.COUNT LOOP
7418: IF p_search_ctx THEN
7419: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
7420: x_stage_list(I).TX1 :=
7421: HZ_TRANS_PKG.RM_SPLCHAR_CTX(
7422: p_search_list(I).FLEX_FORMAT_PHONE_NUMBER
7423: ,null,'FLEX_FORMAT_PHONE_NUMBER'
7424: ,'CONTACT_POINTS','SEARCH');
7425: ELSE

Line 7430: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(

7426: x_stage_list(I).TX1 := '';
7427: END IF;
7428: ELSE
7429: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
7430: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(
7431: x_stage_list(I).TX1
7432: ,null,'FLEX_FORMAT_PHONE_NUMBER'
7433: ,'CONTACT_POINTS','SCORE');
7434: IF tmp IS NOT NULL THEN