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

4310: /********************* Find Parties private procedures *******/
4311: PROCEDURE set_person_party_type IS
4312: BEGIN
4313: g_party_stage_rec.TX36:=
4314: HZ_TRANS_PKG.EXACT(
4315: 'PERSON'
4316: ,null,'PARTY_TYPE'
4317: ,'PARTY');
4318: END;

Line 7303: HZ_TRANS_PKG.WRNAMES_EXACT(

7299: END IF;
7300: IF p_search_ctx THEN
7301: IF p_search_rec.ALL_ACCOUNT_NAMES IS NOT NULL THEN
7302: x_stage_rec.TX32 :=
7303: HZ_TRANS_PKG.WRNAMES_EXACT(
7304: p_search_rec.ALL_ACCOUNT_NAMES
7305: ,null,'ALL_ACCOUNT_NAMES'
7306: ,'PARTY','SEARCH');
7307: ELSE

Line 7312: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

7308: x_stage_rec.TX32 := '';
7309: END IF;
7310: ELSE
7311: IF p_search_rec.ALL_ACCOUNT_NAMES IS NOT NULL THEN
7312: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
7313: x_stage_rec.TX32
7314: ,null,'ALL_ACCOUNT_NAMES'
7315: ,'PARTY','SCORE');
7316: IF tmp IS NOT NULL THEN

Line 7324: HZ_TRANS_PKG.RM_SPLCHAR(

7320: END IF;
7321: IF p_search_ctx THEN
7322: IF p_search_rec.ALL_ACCOUNT_NUMBERS IS NOT NULL THEN
7323: x_stage_rec.TX35 :=
7324: HZ_TRANS_PKG.RM_SPLCHAR(
7325: p_search_rec.ALL_ACCOUNT_NUMBERS
7326: ,null,'ALL_ACCOUNT_NUMBERS'
7327: ,'PARTY','SEARCH');
7328: ELSE

Line 7333: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

7329: x_stage_rec.TX35 := '';
7330: END IF;
7331: ELSE
7332: IF p_search_rec.ALL_ACCOUNT_NUMBERS IS NOT NULL THEN
7333: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
7334: x_stage_rec.TX35
7335: ,null,'ALL_ACCOUNT_NUMBERS'
7336: ,'PARTY','SCORE');
7337: IF tmp IS NOT NULL THEN

Line 7345: HZ_TRANS_PKG.EXACT(

7341: END IF;
7342: IF p_search_ctx THEN
7343: IF p_search_rec.CATEGORY_CODE IS NOT NULL THEN
7344: x_stage_rec.TX48 :=
7345: HZ_TRANS_PKG.EXACT(
7346: p_search_rec.CATEGORY_CODE
7347: ,null,'CATEGORY_CODE'
7348: ,'PARTY');
7349: ELSE

Line 7356: HZ_TRANS_PKG.EXACT(

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

Line 7367: HZ_TRANS_PKG.RM_SPLCHAR(

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

Line 7376: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

7372: x_stage_rec.TX45 := '';
7373: END IF;
7374: ELSE
7375: IF p_search_rec.JGZZ_FISCAL_CODE IS NOT NULL THEN
7376: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
7377: x_stage_rec.TX45
7378: ,null,'JGZZ_FISCAL_CODE'
7379: ,'PARTY','SCORE');
7380: IF tmp IS NOT NULL THEN

Line 7388: HZ_TRANS_PKG.WRNAMES_EXACT(

7384: END IF;
7385: IF p_search_ctx THEN
7386: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
7387: x_stage_rec.TX8 :=
7388: HZ_TRANS_PKG.WRNAMES_EXACT(
7389: p_search_rec.PARTY_NAME
7390: ,null,'PARTY_NAME'
7391: ,'PARTY','SEARCH');
7392: ELSE

Line 7397: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

7393: x_stage_rec.TX8 := '';
7394: END IF;
7395: ELSE
7396: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
7397: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
7398: x_stage_rec.TX8
7399: ,null,'PARTY_NAME'
7400: ,'PARTY','SCORE');
7401: IF tmp IS NOT NULL THEN

Line 7408: HZ_TRANS_PKG.EXACT(

7404: END IF;
7405: END IF;
7406: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
7407: x_stage_rec.TX36 :=
7408: HZ_TRANS_PKG.EXACT(
7409: p_search_rec.PARTY_TYPE
7410: ,null,'PARTY_TYPE'
7411: ,'PARTY');
7412: ELSE

Line 7418: HZ_TRANS_PKG.EXACT(

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

Line 7429: HZ_TRANS_PKG.EXACT(

7425: END IF;
7426: IF p_search_ctx THEN
7427: IF p_search_rec.SIC_CODE IS NOT NULL THEN
7428: x_stage_rec.TX46 :=
7429: HZ_TRANS_PKG.EXACT(
7430: p_search_rec.SIC_CODE
7431: ,null,'SIC_CODE'
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_TYPE IS NOT NULL THEN
7439: x_stage_rec.TX47 :=
7440: HZ_TRANS_PKG.EXACT(
7441: p_search_rec.SIC_CODE_TYPE
7442: ,null,'SIC_CODE_TYPE'
7443: ,'PARTY');
7444: ELSE

Line 7451: HZ_TRANS_PKG.EXACT(

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

Line 7462: HZ_TRANS_PKG.RM_SPLCHAR(

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

Line 7471: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

7467: x_stage_rec.TX44 := '';
7468: END IF;
7469: ELSE
7470: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
7471: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
7472: x_stage_rec.TX44
7473: ,null,'TAX_REFERENCE'
7474: ,'PARTY','SCORE');
7475: IF tmp IS NOT NULL THEN

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

7481: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
7482: l_party_name := p_search_rec.PARTY_ALL_NAMES;
7483: END IF;
7484: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
7485: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
7486: END IF;
7487: EXCEPTION
7488: WHEN OTHERS THEN
7489: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 7555: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

7551: FOR I IN 1..p_search_list.COUNT LOOP
7552: IF p_search_ctx THEN
7553: IF p_search_list(I).ADDRESS IS NOT NULL THEN
7554: x_stage_list(I).TX4 :=
7555: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
7556: p_search_list(I).ADDRESS
7557: ,null,'ADDRESS'
7558: ,'PARTY_SITES','SEARCH');
7559: ELSE

Line 7564: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

7560: x_stage_list(I).TX4 := '';
7561: END IF;
7562: ELSE
7563: IF p_search_list(I).ADDRESS IS NOT NULL THEN
7564: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
7565: x_stage_list(I).TX4
7566: ,null,'ADDRESS'
7567: ,'PARTY_SITES','SCORE');
7568: IF tmp IS NOT NULL THEN

Line 7578: HZ_TRANS_PKG.WRADDRESS_EXACT(

7574: FOR I IN 1..p_search_list.COUNT LOOP
7575: IF p_search_ctx THEN
7576: IF p_search_list(I).ADDRESS IS NOT NULL THEN
7577: x_stage_list(I).TX3 :=
7578: HZ_TRANS_PKG.WRADDRESS_EXACT(
7579: p_search_list(I).ADDRESS
7580: ,null,'ADDRESS'
7581: ,'PARTY_SITES','SEARCH');
7582: ELSE

Line 7587: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

7583: x_stage_list(I).TX3 := '';
7584: END IF;
7585: ELSE
7586: IF p_search_list(I).ADDRESS IS NOT NULL THEN
7587: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(
7588: x_stage_list(I).TX3
7589: ,null,'ADDRESS'
7590: ,'PARTY_SITES','SCORE');
7591: IF tmp IS NOT NULL THEN

Line 7601: HZ_TRANS_PKG.EXACT(

7597: FOR I IN 1..p_search_list.COUNT LOOP
7598: IF p_search_ctx THEN
7599: IF p_search_list(I).CITY IS NOT NULL THEN
7600: x_stage_list(I).TX9 :=
7601: HZ_TRANS_PKG.EXACT(
7602: p_search_list(I).CITY
7603: ,null,'CITY'
7604: ,'PARTY_SITES');
7605: ELSE

Line 7614: HZ_TRANS_PKG.EXACT(

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

Line 7627: HZ_TRANS_PKG.EXACT(

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

Line 7640: HZ_TRANS_PKG.RM_SPLCHAR(

7636: FOR I IN 1..p_search_list.COUNT LOOP
7637: IF p_search_ctx THEN
7638: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
7639: x_stage_list(I).TX11 :=
7640: HZ_TRANS_PKG.RM_SPLCHAR(
7641: p_search_list(I).POSTAL_CODE
7642: ,null,'POSTAL_CODE'
7643: ,'PARTY_SITES','SEARCH');
7644: ELSE

Line 7649: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

7645: x_stage_list(I).TX11 := '';
7646: END IF;
7647: ELSE
7648: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
7649: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
7650: x_stage_list(I).TX11
7651: ,null,'POSTAL_CODE'
7652: ,'PARTY_SITES','SCORE');
7653: IF tmp IS NOT NULL THEN

Line 7663: HZ_TRANS_PKG.EXACT(

7659: FOR I IN 1..p_search_list.COUNT LOOP
7660: IF p_search_ctx THEN
7661: IF p_search_list(I).PROVINCE IS NOT NULL THEN
7662: x_stage_list(I).TX12 :=
7663: HZ_TRANS_PKG.EXACT(
7664: p_search_list(I).PROVINCE
7665: ,null,'PROVINCE'
7666: ,'PARTY_SITES');
7667: ELSE

Line 7676: HZ_TRANS_PKG.WRSTATE_EXACT(

7672: FOR I IN 1..p_search_list.COUNT LOOP
7673: IF p_search_ctx THEN
7674: IF p_search_list(I).STATE IS NOT NULL THEN
7675: x_stage_list(I).TX14 :=
7676: HZ_TRANS_PKG.WRSTATE_EXACT(
7677: p_search_list(I).STATE
7678: ,null,'STATE'
7679: ,'PARTY_SITES','SEARCH');
7680: ELSE

Line 7685: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(

7681: x_stage_list(I).TX14 := '';
7682: END IF;
7683: ELSE
7684: IF p_search_list(I).STATE IS NOT NULL THEN
7685: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(
7686: x_stage_list(I).TX14
7687: ,null,'STATE'
7688: ,'PARTY_SITES','SCORE');
7689: IF tmp IS NOT NULL THEN

Line 7743: HZ_TRANS_PKG.EXACT_PADDED(

7739: FOR I IN 1..p_search_list.COUNT LOOP
7740: IF p_search_ctx THEN
7741: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
7742: x_stage_list(I).TX2 :=
7743: HZ_TRANS_PKG.EXACT_PADDED(
7744: p_search_list(I).CONTACT_NAME
7745: ,null,'CONTACT_NAME'
7746: ,'CONTACTS');
7747: ELSE

Line 7756: HZ_TRANS_PKG.WRPERSON_EXACT(

7752: FOR I IN 1..p_search_list.COUNT LOOP
7753: IF p_search_ctx THEN
7754: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
7755: x_stage_list(I).TX5 :=
7756: HZ_TRANS_PKG.WRPERSON_EXACT(
7757: p_search_list(I).CONTACT_NAME
7758: ,null,'CONTACT_NAME'
7759: ,'CONTACTS','SEARCH');
7760: ELSE

Line 7765: tmp := HZ_TRANS_PKG.WRPERSON_EXACT(

7761: x_stage_list(I).TX5 := '';
7762: END IF;
7763: ELSE
7764: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
7765: tmp := HZ_TRANS_PKG.WRPERSON_EXACT(
7766: x_stage_list(I).TX5
7767: ,null,'CONTACT_NAME'
7768: ,'CONTACTS','SCORE');
7769: IF tmp IS NOT NULL THEN

Line 7851: HZ_TRANS_PKG.EXACT_EMAIL(

7847: FOR I IN 1..p_search_list.COUNT LOOP
7848: IF p_search_ctx THEN
7849: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
7850: x_stage_list(I).TX5 :=
7851: HZ_TRANS_PKG.EXACT_EMAIL(
7852: p_search_list(I).EMAIL_ADDRESS
7853: ,null,'EMAIL_ADDRESS'
7854: ,'CONTACT_POINTS');
7855: ELSE

Line 7864: HZ_TRANS_PKG.RM_SPLCHAR_CTX(

7860: FOR I IN 1..p_search_list.COUNT LOOP
7861: IF p_search_ctx THEN
7862: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
7863: x_stage_list(I).TX1 :=
7864: HZ_TRANS_PKG.RM_SPLCHAR_CTX(
7865: p_search_list(I).FLEX_FORMAT_PHONE_NUMBER
7866: ,null,'FLEX_FORMAT_PHONE_NUMBER'
7867: ,'CONTACT_POINTS','SEARCH');
7868: ELSE

Line 7873: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(

7869: x_stage_list(I).TX1 := '';
7870: END IF;
7871: ELSE
7872: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
7873: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(
7874: x_stage_list(I).TX1
7875: ,null,'FLEX_FORMAT_PHONE_NUMBER'
7876: ,'CONTACT_POINTS','SCORE');
7877: IF tmp IS NOT NULL THEN