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

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

Line 6835: HZ_TRANS_PKG.RM_SPLCHAR(

6831: END IF;
6832: IF p_search_ctx THEN
6833: IF p_search_rec.JGZZ_FISCAL_CODE IS NOT NULL THEN
6834: x_stage_rec.TX45 :=
6835: HZ_TRANS_PKG.RM_SPLCHAR(
6836: p_search_rec.JGZZ_FISCAL_CODE
6837: ,null,'JGZZ_FISCAL_CODE'
6838: ,'PARTY','SEARCH');
6839: ELSE

Line 6844: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6840: x_stage_rec.TX45 := '';
6841: END IF;
6842: ELSE
6843: IF p_search_rec.JGZZ_FISCAL_CODE IS NOT NULL THEN
6844: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6845: x_stage_rec.TX45
6846: ,null,'JGZZ_FISCAL_CODE'
6847: ,'PARTY','SCORE');
6848: IF tmp IS NOT NULL THEN

Line 6856: HZ_TRANS_PKG.SOUNDX(

6852: END IF;
6853: IF p_search_ctx THEN
6854: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6855: x_stage_rec.TX158 :=
6856: HZ_TRANS_PKG.SOUNDX(
6857: p_search_rec.PARTY_ALL_NAMES
6858: ,null,'PARTY_ALL_NAMES'
6859: ,'PARTY');
6860: ELSE

Line 6867: HZ_TRANS_PKG.WRNAMES_CLEANSE(

6863: END IF;
6864: IF p_search_ctx THEN
6865: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6866: x_stage_rec.TX40 :=
6867: HZ_TRANS_PKG.WRNAMES_CLEANSE(
6868: p_search_rec.PARTY_ALL_NAMES
6869: ,null,'PARTY_ALL_NAMES'
6870: ,'PARTY','SEARCH');
6871: ELSE

Line 6876: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

6872: x_stage_rec.TX40 := '';
6873: END IF;
6874: ELSE
6875: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6876: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
6877: x_stage_rec.TX40
6878: ,null,'PARTY_ALL_NAMES'
6879: ,'PARTY','SCORE');
6880: IF tmp IS NOT NULL THEN

Line 6888: HZ_TRANS_PKG.WRNAMES_EXACT(

6884: END IF;
6885: IF p_search_ctx THEN
6886: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6887: x_stage_rec.TX39 :=
6888: HZ_TRANS_PKG.WRNAMES_EXACT(
6889: p_search_rec.PARTY_ALL_NAMES
6890: ,null,'PARTY_ALL_NAMES'
6891: ,'PARTY','SEARCH');
6892: ELSE

Line 6897: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

6893: x_stage_rec.TX39 := '';
6894: END IF;
6895: ELSE
6896: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6897: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
6898: x_stage_rec.TX39
6899: ,null,'PARTY_ALL_NAMES'
6900: ,'PARTY','SCORE');
6901: IF tmp IS NOT NULL THEN

Line 6909: HZ_TRANS_PKG.RM_SPLCHAR(

6905: END IF;
6906: IF p_search_ctx THEN
6907: IF p_search_rec.PARTY_NUMBER IS NOT NULL THEN
6908: x_stage_rec.TX34 :=
6909: HZ_TRANS_PKG.RM_SPLCHAR(
6910: p_search_rec.PARTY_NUMBER
6911: ,null,'PARTY_NUMBER'
6912: ,'PARTY','SEARCH');
6913: ELSE

Line 6918: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6914: x_stage_rec.TX34 := '';
6915: END IF;
6916: ELSE
6917: IF p_search_rec.PARTY_NUMBER IS NOT NULL THEN
6918: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6919: x_stage_rec.TX34
6920: ,null,'PARTY_NUMBER'
6921: ,'PARTY','SCORE');
6922: IF tmp IS NOT NULL THEN

Line 6929: HZ_TRANS_PKG.EXACT(

6925: END IF;
6926: END IF;
6927: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
6928: x_stage_rec.TX36 :=
6929: HZ_TRANS_PKG.EXACT(
6930: p_search_rec.PARTY_TYPE
6931: ,null,'PARTY_TYPE'
6932: ,'PARTY');
6933: ELSE

Line 6939: HZ_TRANS_PKG.EXACT(

6935: END IF;
6936: IF p_search_ctx THEN
6937: IF p_search_rec.SIC_CODE IS NOT NULL THEN
6938: x_stage_rec.TX46 :=
6939: HZ_TRANS_PKG.EXACT(
6940: p_search_rec.SIC_CODE
6941: ,null,'SIC_CODE'
6942: ,'PARTY');
6943: ELSE

Line 6950: HZ_TRANS_PKG.EXACT(

6946: END IF;
6947: IF p_search_ctx THEN
6948: IF p_search_rec.SIC_CODE_TYPE IS NOT NULL THEN
6949: x_stage_rec.TX47 :=
6950: HZ_TRANS_PKG.EXACT(
6951: p_search_rec.SIC_CODE_TYPE
6952: ,null,'SIC_CODE_TYPE'
6953: ,'PARTY');
6954: ELSE

Line 6961: HZ_TRANS_PKG.RM_SPLCHAR(

6957: END IF;
6958: IF p_search_ctx THEN
6959: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
6960: x_stage_rec.TX44 :=
6961: HZ_TRANS_PKG.RM_SPLCHAR(
6962: p_search_rec.TAX_REFERENCE
6963: ,null,'TAX_REFERENCE'
6964: ,'PARTY','SEARCH');
6965: ELSE

Line 6970: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6966: x_stage_rec.TX44 := '';
6967: END IF;
6968: ELSE
6969: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
6970: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6971: x_stage_rec.TX44
6972: ,null,'TAX_REFERENCE'
6973: ,'PARTY','SCORE');
6974: IF tmp IS NOT NULL THEN

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

6980: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6981: l_party_name := p_search_rec.PARTY_ALL_NAMES;
6982: END IF;
6983: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
6984: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
6985: END IF;
6986: EXCEPTION
6987: WHEN OTHERS THEN
6988: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 7048: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

7044: FOR I IN 1..p_search_list.COUNT LOOP
7045: IF p_search_ctx THEN
7046: IF p_search_list(I).ADDRESS IS NOT NULL THEN
7047: x_stage_list(I).TX4 :=
7048: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
7049: p_search_list(I).ADDRESS
7050: ,null,'ADDRESS'
7051: ,'PARTY_SITES','SEARCH');
7052: ELSE

Line 7057: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

7053: x_stage_list(I).TX4 := '';
7054: END IF;
7055: ELSE
7056: IF p_search_list(I).ADDRESS IS NOT NULL THEN
7057: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
7058: x_stage_list(I).TX4
7059: ,null,'ADDRESS'
7060: ,'PARTY_SITES','SCORE');
7061: IF tmp IS NOT NULL THEN

Line 7071: HZ_TRANS_PKG.WRADDRESS_EXACT(

7067: FOR I IN 1..p_search_list.COUNT LOOP
7068: IF p_search_ctx THEN
7069: IF p_search_list(I).ADDRESS IS NOT NULL THEN
7070: x_stage_list(I).TX3 :=
7071: HZ_TRANS_PKG.WRADDRESS_EXACT(
7072: p_search_list(I).ADDRESS
7073: ,null,'ADDRESS'
7074: ,'PARTY_SITES','SEARCH');
7075: ELSE

Line 7080: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

7076: x_stage_list(I).TX3 := '';
7077: END IF;
7078: ELSE
7079: IF p_search_list(I).ADDRESS IS NOT NULL THEN
7080: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(
7081: x_stage_list(I).TX3
7082: ,null,'ADDRESS'
7083: ,'PARTY_SITES','SCORE');
7084: IF tmp IS NOT NULL THEN

Line 7094: HZ_TRANS_PKG.CLEANSE(

7090: FOR I IN 1..p_search_list.COUNT LOOP
7091: IF p_search_ctx THEN
7092: IF p_search_list(I).CITY IS NOT NULL THEN
7093: x_stage_list(I).TX10 :=
7094: HZ_TRANS_PKG.CLEANSE(
7095: p_search_list(I).CITY
7096: ,null,'CITY'
7097: ,'PARTY_SITES');
7098: ELSE

Line 7107: HZ_TRANS_PKG.EXACT(

7103: FOR I IN 1..p_search_list.COUNT LOOP
7104: IF p_search_ctx THEN
7105: IF p_search_list(I).CITY IS NOT NULL THEN
7106: x_stage_list(I).TX9 :=
7107: HZ_TRANS_PKG.EXACT(
7108: p_search_list(I).CITY
7109: ,null,'CITY'
7110: ,'PARTY_SITES');
7111: ELSE

Line 7120: HZ_TRANS_PKG.EXACT(

7116: FOR I IN 1..p_search_list.COUNT LOOP
7117: IF p_search_ctx THEN
7118: IF p_search_list(I).COUNTRY IS NOT NULL THEN
7119: x_stage_list(I).TX22 :=
7120: HZ_TRANS_PKG.EXACT(
7121: p_search_list(I).COUNTRY
7122: ,null,'COUNTRY'
7123: ,'PARTY_SITES');
7124: ELSE

Line 7133: HZ_TRANS_PKG.RM_SPLCHAR(

7129: FOR I IN 1..p_search_list.COUNT LOOP
7130: IF p_search_ctx THEN
7131: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
7132: x_stage_list(I).TX11 :=
7133: HZ_TRANS_PKG.RM_SPLCHAR(
7134: p_search_list(I).POSTAL_CODE
7135: ,null,'POSTAL_CODE'
7136: ,'PARTY_SITES','SEARCH');
7137: ELSE

Line 7142: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

7138: x_stage_list(I).TX11 := '';
7139: END IF;
7140: ELSE
7141: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
7142: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
7143: x_stage_list(I).TX11
7144: ,null,'POSTAL_CODE'
7145: ,'PARTY_SITES','SCORE');
7146: IF tmp IS NOT NULL THEN

Line 7156: HZ_TRANS_PKG.WRSTATE_CLEANSE(

7152: FOR I IN 1..p_search_list.COUNT LOOP
7153: IF p_search_ctx THEN
7154: IF p_search_list(I).STATE IS NOT NULL THEN
7155: x_stage_list(I).TX15 :=
7156: HZ_TRANS_PKG.WRSTATE_CLEANSE(
7157: p_search_list(I).STATE
7158: ,null,'STATE'
7159: ,'PARTY_SITES','SEARCH');
7160: ELSE

Line 7165: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(

7161: x_stage_list(I).TX15 := '';
7162: END IF;
7163: ELSE
7164: IF p_search_list(I).STATE IS NOT NULL THEN
7165: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(
7166: x_stage_list(I).TX15
7167: ,null,'STATE'
7168: ,'PARTY_SITES','SCORE');
7169: IF tmp IS NOT NULL THEN

Line 7179: HZ_TRANS_PKG.WRSTATE_EXACT(

7175: FOR I IN 1..p_search_list.COUNT LOOP
7176: IF p_search_ctx THEN
7177: IF p_search_list(I).STATE IS NOT NULL THEN
7178: x_stage_list(I).TX14 :=
7179: HZ_TRANS_PKG.WRSTATE_EXACT(
7180: p_search_list(I).STATE
7181: ,null,'STATE'
7182: ,'PARTY_SITES','SEARCH');
7183: ELSE

Line 7188: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(

7184: x_stage_list(I).TX14 := '';
7185: END IF;
7186: ELSE
7187: IF p_search_list(I).STATE IS NOT NULL THEN
7188: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(
7189: x_stage_list(I).TX14
7190: ,null,'STATE'
7191: ,'PARTY_SITES','SCORE');
7192: IF tmp IS NOT NULL THEN

Line 7246: HZ_TRANS_PKG.EXACT_PADDED(

7242: FOR I IN 1..p_search_list.COUNT LOOP
7243: IF p_search_ctx THEN
7244: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
7245: x_stage_list(I).TX2 :=
7246: HZ_TRANS_PKG.EXACT_PADDED(
7247: p_search_list(I).CONTACT_NAME
7248: ,null,'CONTACT_NAME'
7249: ,'CONTACTS');
7250: ELSE

Line 7259: HZ_TRANS_PKG.SOUNDX(

7255: FOR I IN 1..p_search_list.COUNT LOOP
7256: IF p_search_ctx THEN
7257: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
7258: x_stage_list(I).TX156 :=
7259: HZ_TRANS_PKG.SOUNDX(
7260: p_search_list(I).CONTACT_NAME
7261: ,null,'CONTACT_NAME'
7262: ,'CONTACTS');
7263: ELSE

Line 7272: HZ_TRANS_PKG.WRPERSON_CLEANSE(

7268: FOR I IN 1..p_search_list.COUNT LOOP
7269: IF p_search_ctx THEN
7270: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
7271: x_stage_list(I).TX6 :=
7272: HZ_TRANS_PKG.WRPERSON_CLEANSE(
7273: p_search_list(I).CONTACT_NAME
7274: ,null,'CONTACT_NAME'
7275: ,'CONTACTS','SEARCH');
7276: ELSE

Line 7281: tmp := HZ_TRANS_PKG.WRPERSON_CLEANSE(

7277: x_stage_list(I).TX6 := '';
7278: END IF;
7279: ELSE
7280: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
7281: tmp := HZ_TRANS_PKG.WRPERSON_CLEANSE(
7282: x_stage_list(I).TX6
7283: ,null,'CONTACT_NAME'
7284: ,'CONTACTS','SCORE');
7285: IF tmp IS NOT NULL THEN

Line 7295: HZ_TRANS_PKG.WRPERSON_EXACT(

7291: FOR I IN 1..p_search_list.COUNT LOOP
7292: IF p_search_ctx THEN
7293: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
7294: x_stage_list(I).TX5 :=
7295: HZ_TRANS_PKG.WRPERSON_EXACT(
7296: p_search_list(I).CONTACT_NAME
7297: ,null,'CONTACT_NAME'
7298: ,'CONTACTS','SEARCH');
7299: ELSE

Line 7304: tmp := HZ_TRANS_PKG.WRPERSON_EXACT(

7300: x_stage_list(I).TX5 := '';
7301: END IF;
7302: ELSE
7303: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
7304: tmp := HZ_TRANS_PKG.WRPERSON_EXACT(
7305: x_stage_list(I).TX5
7306: ,null,'CONTACT_NAME'
7307: ,'CONTACTS','SCORE');
7308: IF tmp IS NOT NULL THEN

Line 7390: HZ_TRANS_PKG.CLEANSED_EMAIL(

7386: FOR I IN 1..p_search_list.COUNT LOOP
7387: IF p_search_ctx THEN
7388: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
7389: x_stage_list(I).TX6 :=
7390: HZ_TRANS_PKG.CLEANSED_EMAIL(
7391: p_search_list(I).EMAIL_ADDRESS
7392: ,null,'EMAIL_ADDRESS'
7393: ,'CONTACT_POINTS','SEARCH');
7394: ELSE

Line 7399: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(

7395: x_stage_list(I).TX6 := '';
7396: END IF;
7397: ELSE
7398: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
7399: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(
7400: x_stage_list(I).TX6
7401: ,null,'EMAIL_ADDRESS'
7402: ,'CONTACT_POINTS','SCORE');
7403: IF tmp IS NOT NULL THEN

Line 7413: HZ_TRANS_PKG.EXACT_EMAIL(

7409: FOR I IN 1..p_search_list.COUNT LOOP
7410: IF p_search_ctx THEN
7411: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
7412: x_stage_list(I).TX5 :=
7413: HZ_TRANS_PKG.EXACT_EMAIL(
7414: p_search_list(I).EMAIL_ADDRESS
7415: ,null,'EMAIL_ADDRESS'
7416: ,'CONTACT_POINTS');
7417: ELSE

Line 7426: HZ_TRANS_PKG.RM_SPLCHAR_CTX(

7422: FOR I IN 1..p_search_list.COUNT LOOP
7423: IF p_search_ctx THEN
7424: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
7425: x_stage_list(I).TX1 :=
7426: HZ_TRANS_PKG.RM_SPLCHAR_CTX(
7427: p_search_list(I).FLEX_FORMAT_PHONE_NUMBER
7428: ,null,'FLEX_FORMAT_PHONE_NUMBER'
7429: ,'CONTACT_POINTS','SEARCH');
7430: ELSE

Line 7435: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(

7431: x_stage_list(I).TX1 := '';
7432: END IF;
7433: ELSE
7434: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
7435: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(
7436: x_stage_list(I).TX1
7437: ,null,'FLEX_FORMAT_PHONE_NUMBER'
7438: ,'CONTACT_POINTS','SCORE');
7439: IF tmp IS NOT NULL THEN