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

Line 1479: HZ_TRANS_PKG.clear_globals;

1475: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1476: 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);
1477: END IF;
1478: -- Transform search criteria
1479: HZ_TRANS_PKG.clear_globals;
1480: MAP_PARTY_REC(FALSE,p_party_search_rec, l_dummy, g_party_stage_rec);
1481: MAP_PARTY_SITE_REC(FALSE,p_party_site_list, l_dummy, g_party_site_stage_list);
1482: MAP_CONTACT_REC(FALSE,p_contact_list, l_dummy, g_contact_stage_list);
1483: MAP_CONTACT_POINT_REC(FALSE,p_contact_point_list, l_dummy, g_contact_pt_stage_list);

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

1532: g_contact_pt_stage_list.DELETE;
1533: call_order.DELETE;
1534: call_max_score.DELETE;
1535: HZ_DQM_SEARCH_UTIL.new_search;
1536: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
1537: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1538:
1539: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1540: 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 4319: HZ_TRANS_PKG.EXACT(

4315: /********************* Find Parties private procedures *******/
4316: PROCEDURE set_person_party_type IS
4317: BEGIN
4318: g_party_stage_rec.TX36:=
4319: HZ_TRANS_PKG.EXACT(
4320: 'PERSON'
4321: ,null,'PARTY_TYPE'
4322: ,'PARTY');
4323: END;

Line 7314: HZ_TRANS_PKG.WRNAMES_EXACT(

7310: END IF;
7311: IF p_search_ctx THEN
7312: IF p_search_rec.ALL_ACCOUNT_NAMES IS NOT NULL THEN
7313: x_stage_rec.TX32 :=
7314: HZ_TRANS_PKG.WRNAMES_EXACT(
7315: p_search_rec.ALL_ACCOUNT_NAMES
7316: ,null,'ALL_ACCOUNT_NAMES'
7317: ,'PARTY','SEARCH');
7318: ELSE

Line 7323: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

7319: x_stage_rec.TX32 := '';
7320: END IF;
7321: ELSE
7322: IF p_search_rec.ALL_ACCOUNT_NAMES IS NOT NULL THEN
7323: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
7324: x_stage_rec.TX32
7325: ,null,'ALL_ACCOUNT_NAMES'
7326: ,'PARTY','SCORE');
7327: IF tmp IS NOT NULL THEN

Line 7335: HZ_TRANS_PKG.RM_SPLCHAR(

7331: END IF;
7332: IF p_search_ctx THEN
7333: IF p_search_rec.ALL_ACCOUNT_NUMBERS IS NOT NULL THEN
7334: x_stage_rec.TX35 :=
7335: HZ_TRANS_PKG.RM_SPLCHAR(
7336: p_search_rec.ALL_ACCOUNT_NUMBERS
7337: ,null,'ALL_ACCOUNT_NUMBERS'
7338: ,'PARTY','SEARCH');
7339: ELSE

Line 7344: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

7340: x_stage_rec.TX35 := '';
7341: END IF;
7342: ELSE
7343: IF p_search_rec.ALL_ACCOUNT_NUMBERS IS NOT NULL THEN
7344: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
7345: x_stage_rec.TX35
7346: ,null,'ALL_ACCOUNT_NUMBERS'
7347: ,'PARTY','SCORE');
7348: IF tmp IS NOT NULL THEN

Line 7356: HZ_TRANS_PKG.EXACT(

7352: END IF;
7353: IF p_search_ctx THEN
7354: IF p_search_rec.CATEGORY_CODE IS NOT NULL THEN
7355: x_stage_rec.TX48 :=
7356: HZ_TRANS_PKG.EXACT(
7357: p_search_rec.CATEGORY_CODE
7358: ,null,'CATEGORY_CODE'
7359: ,'PARTY');
7360: ELSE

Line 7367: HZ_TRANS_PKG.EXACT(

7363: END IF;
7364: IF p_search_ctx THEN
7365: IF p_search_rec.CORPORATION_CLASS IS NOT NULL THEN
7366: x_stage_rec.TX157 :=
7367: HZ_TRANS_PKG.EXACT(
7368: p_search_rec.CORPORATION_CLASS
7369: ,null,'CORPORATION_CLASS'
7370: ,'PARTY');
7371: ELSE

Line 7378: HZ_TRANS_PKG.RM_SPLCHAR(

7374: END IF;
7375: IF p_search_ctx THEN
7376: IF p_search_rec.JGZZ_FISCAL_CODE IS NOT NULL THEN
7377: x_stage_rec.TX45 :=
7378: HZ_TRANS_PKG.RM_SPLCHAR(
7379: p_search_rec.JGZZ_FISCAL_CODE
7380: ,null,'JGZZ_FISCAL_CODE'
7381: ,'PARTY','SEARCH');
7382: ELSE

Line 7387: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

7383: x_stage_rec.TX45 := '';
7384: END IF;
7385: ELSE
7386: IF p_search_rec.JGZZ_FISCAL_CODE IS NOT NULL THEN
7387: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
7388: x_stage_rec.TX45
7389: ,null,'JGZZ_FISCAL_CODE'
7390: ,'PARTY','SCORE');
7391: IF tmp IS NOT NULL THEN

Line 7399: HZ_TRANS_PKG.WRNAMES_EXACT(

7395: END IF;
7396: IF p_search_ctx THEN
7397: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
7398: x_stage_rec.TX8 :=
7399: HZ_TRANS_PKG.WRNAMES_EXACT(
7400: p_search_rec.PARTY_NAME
7401: ,null,'PARTY_NAME'
7402: ,'PARTY','SEARCH');
7403: ELSE

Line 7408: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

7404: x_stage_rec.TX8 := '';
7405: END IF;
7406: ELSE
7407: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
7408: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
7409: x_stage_rec.TX8
7410: ,null,'PARTY_NAME'
7411: ,'PARTY','SCORE');
7412: IF tmp IS NOT NULL THEN

Line 7419: HZ_TRANS_PKG.EXACT(

7415: END IF;
7416: END IF;
7417: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
7418: x_stage_rec.TX36 :=
7419: HZ_TRANS_PKG.EXACT(
7420: p_search_rec.PARTY_TYPE
7421: ,null,'PARTY_TYPE'
7422: ,'PARTY');
7423: ELSE

Line 7429: HZ_TRANS_PKG.EXACT(

7425: END IF;
7426: IF p_search_ctx THEN
7427: IF p_search_rec.REFERENCE_USE_FLAG IS NOT NULL THEN
7428: x_stage_rec.TX156 :=
7429: HZ_TRANS_PKG.EXACT(
7430: p_search_rec.REFERENCE_USE_FLAG
7431: ,null,'REFERENCE_USE_FLAG'
7432: ,'PARTY');
7433: ELSE

Line 7440: HZ_TRANS_PKG.EXACT(

7436: END IF;
7437: IF p_search_ctx THEN
7438: IF p_search_rec.SIC_CODE IS NOT NULL THEN
7439: x_stage_rec.TX46 :=
7440: HZ_TRANS_PKG.EXACT(
7441: p_search_rec.SIC_CODE
7442: ,null,'SIC_CODE'
7443: ,'PARTY');
7444: ELSE

Line 7451: HZ_TRANS_PKG.EXACT(

7447: END IF;
7448: IF p_search_ctx THEN
7449: IF p_search_rec.SIC_CODE_TYPE IS NOT NULL THEN
7450: x_stage_rec.TX47 :=
7451: HZ_TRANS_PKG.EXACT(
7452: p_search_rec.SIC_CODE_TYPE
7453: ,null,'SIC_CODE_TYPE'
7454: ,'PARTY');
7455: ELSE

Line 7462: HZ_TRANS_PKG.EXACT(

7458: END IF;
7459: IF p_search_ctx THEN
7460: IF p_search_rec.TAX_NAME IS NOT NULL THEN
7461: x_stage_rec.TX42 :=
7462: HZ_TRANS_PKG.EXACT(
7463: p_search_rec.TAX_NAME
7464: ,null,'TAX_NAME'
7465: ,'PARTY');
7466: ELSE

Line 7473: HZ_TRANS_PKG.RM_SPLCHAR(

7469: END IF;
7470: IF p_search_ctx THEN
7471: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
7472: x_stage_rec.TX44 :=
7473: HZ_TRANS_PKG.RM_SPLCHAR(
7474: p_search_rec.TAX_REFERENCE
7475: ,null,'TAX_REFERENCE'
7476: ,'PARTY','SEARCH');
7477: ELSE

Line 7482: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

7478: x_stage_rec.TX44 := '';
7479: END IF;
7480: ELSE
7481: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
7482: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
7483: x_stage_rec.TX44
7484: ,null,'TAX_REFERENCE'
7485: ,'PARTY','SCORE');
7486: IF tmp IS NOT NULL THEN

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

7492: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
7493: l_party_name := p_search_rec.PARTY_ALL_NAMES;
7494: END IF;
7495: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
7496: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
7497: END IF;
7498: EXCEPTION
7499: WHEN OTHERS THEN
7500: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 7566: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

7562: FOR I IN 1..p_search_list.COUNT LOOP
7563: IF p_search_ctx THEN
7564: IF p_search_list(I).ADDRESS IS NOT NULL THEN
7565: x_stage_list(I).TX4 :=
7566: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
7567: p_search_list(I).ADDRESS
7568: ,null,'ADDRESS'
7569: ,'PARTY_SITES','SEARCH');
7570: ELSE

Line 7575: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

7571: x_stage_list(I).TX4 := '';
7572: END IF;
7573: ELSE
7574: IF p_search_list(I).ADDRESS IS NOT NULL THEN
7575: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
7576: x_stage_list(I).TX4
7577: ,null,'ADDRESS'
7578: ,'PARTY_SITES','SCORE');
7579: IF tmp IS NOT NULL THEN

Line 7589: HZ_TRANS_PKG.WRADDRESS_EXACT(

7585: FOR I IN 1..p_search_list.COUNT LOOP
7586: IF p_search_ctx THEN
7587: IF p_search_list(I).ADDRESS IS NOT NULL THEN
7588: x_stage_list(I).TX3 :=
7589: HZ_TRANS_PKG.WRADDRESS_EXACT(
7590: p_search_list(I).ADDRESS
7591: ,null,'ADDRESS'
7592: ,'PARTY_SITES','SEARCH');
7593: ELSE

Line 7598: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

7594: x_stage_list(I).TX3 := '';
7595: END IF;
7596: ELSE
7597: IF p_search_list(I).ADDRESS IS NOT NULL THEN
7598: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(
7599: x_stage_list(I).TX3
7600: ,null,'ADDRESS'
7601: ,'PARTY_SITES','SCORE');
7602: IF tmp IS NOT NULL THEN

Line 7612: HZ_TRANS_PKG.EXACT(

7608: FOR I IN 1..p_search_list.COUNT LOOP
7609: IF p_search_ctx THEN
7610: IF p_search_list(I).CITY IS NOT NULL THEN
7611: x_stage_list(I).TX9 :=
7612: HZ_TRANS_PKG.EXACT(
7613: p_search_list(I).CITY
7614: ,null,'CITY'
7615: ,'PARTY_SITES');
7616: ELSE

Line 7625: HZ_TRANS_PKG.EXACT(

7621: FOR I IN 1..p_search_list.COUNT LOOP
7622: IF p_search_ctx THEN
7623: IF p_search_list(I).COUNTRY IS NOT NULL THEN
7624: x_stage_list(I).TX22 :=
7625: HZ_TRANS_PKG.EXACT(
7626: p_search_list(I).COUNTRY
7627: ,null,'COUNTRY'
7628: ,'PARTY_SITES');
7629: ELSE

Line 7638: HZ_TRANS_PKG.EXACT(

7634: FOR I IN 1..p_search_list.COUNT LOOP
7635: IF p_search_ctx THEN
7636: IF p_search_list(I).COUNTY IS NOT NULL THEN
7637: x_stage_list(I).TX20 :=
7638: HZ_TRANS_PKG.EXACT(
7639: p_search_list(I).COUNTY
7640: ,null,'COUNTY'
7641: ,'PARTY_SITES');
7642: ELSE

Line 7651: HZ_TRANS_PKG.RM_SPLCHAR(

7647: FOR I IN 1..p_search_list.COUNT LOOP
7648: IF p_search_ctx THEN
7649: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
7650: x_stage_list(I).TX11 :=
7651: HZ_TRANS_PKG.RM_SPLCHAR(
7652: p_search_list(I).POSTAL_CODE
7653: ,null,'POSTAL_CODE'
7654: ,'PARTY_SITES','SEARCH');
7655: ELSE

Line 7660: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

7656: x_stage_list(I).TX11 := '';
7657: END IF;
7658: ELSE
7659: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
7660: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
7661: x_stage_list(I).TX11
7662: ,null,'POSTAL_CODE'
7663: ,'PARTY_SITES','SCORE');
7664: IF tmp IS NOT NULL THEN

Line 7674: HZ_TRANS_PKG.EXACT(

7670: FOR I IN 1..p_search_list.COUNT LOOP
7671: IF p_search_ctx THEN
7672: IF p_search_list(I).PROVINCE IS NOT NULL THEN
7673: x_stage_list(I).TX12 :=
7674: HZ_TRANS_PKG.EXACT(
7675: p_search_list(I).PROVINCE
7676: ,null,'PROVINCE'
7677: ,'PARTY_SITES');
7678: ELSE

Line 7687: HZ_TRANS_PKG.WRSTATE_EXACT(

7683: FOR I IN 1..p_search_list.COUNT LOOP
7684: IF p_search_ctx THEN
7685: IF p_search_list(I).STATE IS NOT NULL THEN
7686: x_stage_list(I).TX14 :=
7687: HZ_TRANS_PKG.WRSTATE_EXACT(
7688: p_search_list(I).STATE
7689: ,null,'STATE'
7690: ,'PARTY_SITES','SEARCH');
7691: ELSE

Line 7696: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(

7692: x_stage_list(I).TX14 := '';
7693: END IF;
7694: ELSE
7695: IF p_search_list(I).STATE IS NOT NULL THEN
7696: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(
7697: x_stage_list(I).TX14
7698: ,null,'STATE'
7699: ,'PARTY_SITES','SCORE');
7700: IF tmp IS NOT NULL THEN

Line 7754: HZ_TRANS_PKG.EXACT_PADDED(

7750: FOR I IN 1..p_search_list.COUNT LOOP
7751: IF p_search_ctx THEN
7752: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
7753: x_stage_list(I).TX2 :=
7754: HZ_TRANS_PKG.EXACT_PADDED(
7755: p_search_list(I).CONTACT_NAME
7756: ,null,'CONTACT_NAME'
7757: ,'CONTACTS');
7758: ELSE

Line 7767: HZ_TRANS_PKG.WRPERSON_EXACT(

7763: FOR I IN 1..p_search_list.COUNT LOOP
7764: IF p_search_ctx THEN
7765: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
7766: x_stage_list(I).TX5 :=
7767: HZ_TRANS_PKG.WRPERSON_EXACT(
7768: p_search_list(I).CONTACT_NAME
7769: ,null,'CONTACT_NAME'
7770: ,'CONTACTS','SEARCH');
7771: ELSE

Line 7776: tmp := HZ_TRANS_PKG.WRPERSON_EXACT(

7772: x_stage_list(I).TX5 := '';
7773: END IF;
7774: ELSE
7775: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
7776: tmp := HZ_TRANS_PKG.WRPERSON_EXACT(
7777: x_stage_list(I).TX5
7778: ,null,'CONTACT_NAME'
7779: ,'CONTACTS','SCORE');
7780: IF tmp IS NOT NULL THEN

Line 7862: HZ_TRANS_PKG.EXACT_EMAIL(

7858: FOR I IN 1..p_search_list.COUNT LOOP
7859: IF p_search_ctx THEN
7860: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
7861: x_stage_list(I).TX5 :=
7862: HZ_TRANS_PKG.EXACT_EMAIL(
7863: p_search_list(I).EMAIL_ADDRESS
7864: ,null,'EMAIL_ADDRESS'
7865: ,'CONTACT_POINTS');
7866: ELSE

Line 7875: HZ_TRANS_PKG.RM_SPLCHAR_CTX(

7871: FOR I IN 1..p_search_list.COUNT LOOP
7872: IF p_search_ctx THEN
7873: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
7874: x_stage_list(I).TX1 :=
7875: HZ_TRANS_PKG.RM_SPLCHAR_CTX(
7876: p_search_list(I).FLEX_FORMAT_PHONE_NUMBER
7877: ,null,'FLEX_FORMAT_PHONE_NUMBER'
7878: ,'CONTACT_POINTS','SEARCH');
7879: ELSE

Line 7884: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(

7880: x_stage_list(I).TX1 := '';
7881: END IF;
7882: ELSE
7883: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
7884: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(
7885: x_stage_list(I).TX1
7886: ,null,'FLEX_FORMAT_PHONE_NUMBER'
7887: ,'CONTACT_POINTS','SCORE');
7888: IF tmp IS NOT NULL THEN