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

Line 1496: HZ_TRANS_PKG.clear_globals;

1492: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1493: 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);
1494: END IF;
1495: -- Transform search criteria
1496: HZ_TRANS_PKG.clear_globals;
1497: MAP_PARTY_REC(FALSE,p_party_search_rec, l_dummy, g_party_stage_rec);
1498: MAP_PARTY_SITE_REC(FALSE,p_party_site_list, l_dummy, g_party_site_stage_list);
1499: MAP_CONTACT_REC(FALSE,p_contact_list, l_dummy, g_contact_stage_list);
1500: MAP_CONTACT_POINT_REC(FALSE,p_contact_point_list, l_dummy, g_contact_pt_stage_list);

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

1549: g_contact_pt_stage_list.DELETE;
1550: call_order.DELETE;
1551: call_max_score.DELETE;
1552: HZ_DQM_SEARCH_UTIL.new_search;
1553: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
1554: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1555:
1556: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1557: 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 7307: HZ_TRANS_PKG.WRNAMES_CLEANSE(

7303: END IF;
7304: IF p_search_ctx THEN
7305: IF p_search_rec.ALL_ACCOUNT_NAMES IS NOT NULL THEN
7306: x_stage_rec.TX33 :=
7307: HZ_TRANS_PKG.WRNAMES_CLEANSE(
7308: p_search_rec.ALL_ACCOUNT_NAMES
7309: ,null,'ALL_ACCOUNT_NAMES'
7310: ,'PARTY','SEARCH');
7311: ELSE

Line 7316: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

7312: x_stage_rec.TX33 := '';
7313: END IF;
7314: ELSE
7315: IF p_search_rec.ALL_ACCOUNT_NAMES IS NOT NULL THEN
7316: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
7317: x_stage_rec.TX33
7318: ,null,'ALL_ACCOUNT_NAMES'
7319: ,'PARTY','SCORE');
7320: IF tmp IS NOT NULL THEN

Line 7328: HZ_TRANS_PKG.WRNAMES_EXACT(

7324: END IF;
7325: IF p_search_ctx THEN
7326: IF p_search_rec.ALL_ACCOUNT_NAMES IS NOT NULL THEN
7327: x_stage_rec.TX32 :=
7328: HZ_TRANS_PKG.WRNAMES_EXACT(
7329: p_search_rec.ALL_ACCOUNT_NAMES
7330: ,null,'ALL_ACCOUNT_NAMES'
7331: ,'PARTY','SEARCH');
7332: ELSE

Line 7337: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

7333: x_stage_rec.TX32 := '';
7334: END IF;
7335: ELSE
7336: IF p_search_rec.ALL_ACCOUNT_NAMES IS NOT NULL THEN
7337: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
7338: x_stage_rec.TX32
7339: ,null,'ALL_ACCOUNT_NAMES'
7340: ,'PARTY','SCORE');
7341: IF tmp IS NOT NULL THEN

Line 7349: HZ_TRANS_PKG.RM_SPLCHAR(

7345: END IF;
7346: IF p_search_ctx THEN
7347: IF p_search_rec.ALL_ACCOUNT_NUMBERS IS NOT NULL THEN
7348: x_stage_rec.TX35 :=
7349: HZ_TRANS_PKG.RM_SPLCHAR(
7350: p_search_rec.ALL_ACCOUNT_NUMBERS
7351: ,null,'ALL_ACCOUNT_NUMBERS'
7352: ,'PARTY','SEARCH');
7353: ELSE

Line 7358: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

7354: x_stage_rec.TX35 := '';
7355: END IF;
7356: ELSE
7357: IF p_search_rec.ALL_ACCOUNT_NUMBERS IS NOT NULL THEN
7358: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
7359: x_stage_rec.TX35
7360: ,null,'ALL_ACCOUNT_NUMBERS'
7361: ,'PARTY','SCORE');
7362: IF tmp IS NOT NULL THEN

Line 7370: HZ_TRANS_PKG.EXACT(

7366: END IF;
7367: IF p_search_ctx THEN
7368: IF p_search_rec.CATEGORY_CODE IS NOT NULL THEN
7369: x_stage_rec.TX48 :=
7370: HZ_TRANS_PKG.EXACT(
7371: p_search_rec.CATEGORY_CODE
7372: ,null,'CATEGORY_CODE'
7373: ,'PARTY');
7374: ELSE

Line 7381: HZ_TRANS_PKG.EXACT(

7377: END IF;
7378: IF p_search_ctx THEN
7379: IF p_search_rec.CORPORATION_CLASS IS NOT NULL THEN
7380: x_stage_rec.TX157 :=
7381: HZ_TRANS_PKG.EXACT(
7382: p_search_rec.CORPORATION_CLASS
7383: ,null,'CORPORATION_CLASS'
7384: ,'PARTY');
7385: ELSE

Line 7392: HZ_TRANS_PKG.SOUNDX(

7388: END IF;
7389: IF p_search_ctx THEN
7390: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
7391: x_stage_rec.TX158 :=
7392: HZ_TRANS_PKG.SOUNDX(
7393: p_search_rec.PARTY_ALL_NAMES
7394: ,null,'PARTY_ALL_NAMES'
7395: ,'PARTY');
7396: ELSE

Line 7403: HZ_TRANS_PKG.WRNAMES_CLEANSE(

7399: END IF;
7400: IF p_search_ctx THEN
7401: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
7402: x_stage_rec.TX40 :=
7403: HZ_TRANS_PKG.WRNAMES_CLEANSE(
7404: p_search_rec.PARTY_ALL_NAMES
7405: ,null,'PARTY_ALL_NAMES'
7406: ,'PARTY','SEARCH');
7407: ELSE

Line 7412: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

7408: x_stage_rec.TX40 := '';
7409: END IF;
7410: ELSE
7411: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
7412: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
7413: x_stage_rec.TX40
7414: ,null,'PARTY_ALL_NAMES'
7415: ,'PARTY','SCORE');
7416: IF tmp IS NOT NULL THEN

Line 7424: HZ_TRANS_PKG.WRNAMES_EXACT(

7420: END IF;
7421: IF p_search_ctx THEN
7422: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
7423: x_stage_rec.TX39 :=
7424: HZ_TRANS_PKG.WRNAMES_EXACT(
7425: p_search_rec.PARTY_ALL_NAMES
7426: ,null,'PARTY_ALL_NAMES'
7427: ,'PARTY','SEARCH');
7428: ELSE

Line 7433: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

7429: x_stage_rec.TX39 := '';
7430: END IF;
7431: ELSE
7432: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
7433: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
7434: x_stage_rec.TX39
7435: ,null,'PARTY_ALL_NAMES'
7436: ,'PARTY','SCORE');
7437: IF tmp IS NOT NULL THEN

Line 7445: HZ_TRANS_PKG.RM_SPLCHAR(

7441: END IF;
7442: IF p_search_ctx THEN
7443: IF p_search_rec.PARTY_NUMBER IS NOT NULL THEN
7444: x_stage_rec.TX34 :=
7445: HZ_TRANS_PKG.RM_SPLCHAR(
7446: p_search_rec.PARTY_NUMBER
7447: ,null,'PARTY_NUMBER'
7448: ,'PARTY','SEARCH');
7449: ELSE

Line 7454: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

7450: x_stage_rec.TX34 := '';
7451: END IF;
7452: ELSE
7453: IF p_search_rec.PARTY_NUMBER IS NOT NULL THEN
7454: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
7455: x_stage_rec.TX34
7456: ,null,'PARTY_NUMBER'
7457: ,'PARTY','SCORE');
7458: IF tmp IS NOT NULL THEN

Line 7465: HZ_TRANS_PKG.EXACT(

7461: END IF;
7462: END IF;
7463: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
7464: x_stage_rec.TX36 :=
7465: HZ_TRANS_PKG.EXACT(
7466: p_search_rec.PARTY_TYPE
7467: ,null,'PARTY_TYPE'
7468: ,'PARTY');
7469: ELSE

Line 7475: HZ_TRANS_PKG.EXACT(

7471: END IF;
7472: IF p_search_ctx THEN
7473: IF p_search_rec.REFERENCE_USE_FLAG IS NOT NULL THEN
7474: x_stage_rec.TX156 :=
7475: HZ_TRANS_PKG.EXACT(
7476: p_search_rec.REFERENCE_USE_FLAG
7477: ,null,'REFERENCE_USE_FLAG'
7478: ,'PARTY');
7479: ELSE

Line 7486: HZ_TRANS_PKG.EXACT(

7482: END IF;
7483: IF p_search_ctx THEN
7484: IF p_search_rec.SIC_CODE IS NOT NULL THEN
7485: x_stage_rec.TX46 :=
7486: HZ_TRANS_PKG.EXACT(
7487: p_search_rec.SIC_CODE
7488: ,null,'SIC_CODE'
7489: ,'PARTY');
7490: ELSE

Line 7497: HZ_TRANS_PKG.EXACT(

7493: END IF;
7494: IF p_search_ctx THEN
7495: IF p_search_rec.SIC_CODE_TYPE IS NOT NULL THEN
7496: x_stage_rec.TX47 :=
7497: HZ_TRANS_PKG.EXACT(
7498: p_search_rec.SIC_CODE_TYPE
7499: ,null,'SIC_CODE_TYPE'
7500: ,'PARTY');
7501: ELSE

Line 7508: HZ_TRANS_PKG.CLEANSE(

7504: END IF;
7505: IF p_search_ctx THEN
7506: IF p_search_rec.TAX_NAME IS NOT NULL THEN
7507: x_stage_rec.TX43 :=
7508: HZ_TRANS_PKG.CLEANSE(
7509: p_search_rec.TAX_NAME
7510: ,null,'TAX_NAME'
7511: ,'PARTY');
7512: ELSE

Line 7519: HZ_TRANS_PKG.EXACT(

7515: END IF;
7516: IF p_search_ctx THEN
7517: IF p_search_rec.TAX_NAME IS NOT NULL THEN
7518: x_stage_rec.TX42 :=
7519: HZ_TRANS_PKG.EXACT(
7520: p_search_rec.TAX_NAME
7521: ,null,'TAX_NAME'
7522: ,'PARTY');
7523: ELSE

Line 7530: HZ_TRANS_PKG.RM_SPLCHAR(

7526: END IF;
7527: IF p_search_ctx THEN
7528: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
7529: x_stage_rec.TX44 :=
7530: HZ_TRANS_PKG.RM_SPLCHAR(
7531: p_search_rec.TAX_REFERENCE
7532: ,null,'TAX_REFERENCE'
7533: ,'PARTY','SEARCH');
7534: ELSE

Line 7539: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

7535: x_stage_rec.TX44 := '';
7536: END IF;
7537: ELSE
7538: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
7539: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
7540: x_stage_rec.TX44
7541: ,null,'TAX_REFERENCE'
7542: ,'PARTY','SCORE');
7543: IF tmp IS NOT NULL THEN

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

7549: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
7550: l_party_name := p_search_rec.PARTY_ALL_NAMES;
7551: END IF;
7552: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
7553: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
7554: END IF;
7555: EXCEPTION
7556: WHEN OTHERS THEN
7557: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 7619: HZ_TRANS_PKG.CLEANSE(

7615: FOR I IN 1..p_search_list.COUNT LOOP
7616: IF p_search_ctx THEN
7617: IF p_search_list(I).CITY IS NOT NULL THEN
7618: x_stage_list(I).TX10 :=
7619: HZ_TRANS_PKG.CLEANSE(
7620: p_search_list(I).CITY
7621: ,null,'CITY'
7622: ,'PARTY_SITES');
7623: ELSE

Line 7632: HZ_TRANS_PKG.EXACT(

7628: FOR I IN 1..p_search_list.COUNT LOOP
7629: IF p_search_ctx THEN
7630: IF p_search_list(I).CITY IS NOT NULL THEN
7631: x_stage_list(I).TX9 :=
7632: HZ_TRANS_PKG.EXACT(
7633: p_search_list(I).CITY
7634: ,null,'CITY'
7635: ,'PARTY_SITES');
7636: ELSE

Line 7645: HZ_TRANS_PKG.EXACT(

7641: FOR I IN 1..p_search_list.COUNT LOOP
7642: IF p_search_ctx THEN
7643: IF p_search_list(I).COUNTRY IS NOT NULL THEN
7644: x_stage_list(I).TX22 :=
7645: HZ_TRANS_PKG.EXACT(
7646: p_search_list(I).COUNTRY
7647: ,null,'COUNTRY'
7648: ,'PARTY_SITES');
7649: ELSE

Line 7658: HZ_TRANS_PKG.CLEANSE(

7654: FOR I IN 1..p_search_list.COUNT LOOP
7655: IF p_search_ctx THEN
7656: IF p_search_list(I).COUNTY IS NOT NULL THEN
7657: x_stage_list(I).TX21 :=
7658: HZ_TRANS_PKG.CLEANSE(
7659: p_search_list(I).COUNTY
7660: ,null,'COUNTY'
7661: ,'PARTY_SITES');
7662: ELSE

Line 7671: HZ_TRANS_PKG.EXACT(

7667: FOR I IN 1..p_search_list.COUNT LOOP
7668: IF p_search_ctx THEN
7669: IF p_search_list(I).COUNTY IS NOT NULL THEN
7670: x_stage_list(I).TX20 :=
7671: HZ_TRANS_PKG.EXACT(
7672: p_search_list(I).COUNTY
7673: ,null,'COUNTY'
7674: ,'PARTY_SITES');
7675: ELSE

Line 7684: HZ_TRANS_PKG.RM_SPLCHAR(

7680: FOR I IN 1..p_search_list.COUNT LOOP
7681: IF p_search_ctx THEN
7682: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
7683: x_stage_list(I).TX11 :=
7684: HZ_TRANS_PKG.RM_SPLCHAR(
7685: p_search_list(I).POSTAL_CODE
7686: ,null,'POSTAL_CODE'
7687: ,'PARTY_SITES','SEARCH');
7688: ELSE

Line 7693: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

7689: x_stage_list(I).TX11 := '';
7690: END IF;
7691: ELSE
7692: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
7693: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
7694: x_stage_list(I).TX11
7695: ,null,'POSTAL_CODE'
7696: ,'PARTY_SITES','SCORE');
7697: IF tmp IS NOT NULL THEN

Line 7707: HZ_TRANS_PKG.CLEANSE(

7703: FOR I IN 1..p_search_list.COUNT LOOP
7704: IF p_search_ctx THEN
7705: IF p_search_list(I).PROVINCE IS NOT NULL THEN
7706: x_stage_list(I).TX13 :=
7707: HZ_TRANS_PKG.CLEANSE(
7708: p_search_list(I).PROVINCE
7709: ,null,'PROVINCE'
7710: ,'PARTY_SITES');
7711: ELSE

Line 7720: HZ_TRANS_PKG.WRSTATE_CLEANSE(

7716: FOR I IN 1..p_search_list.COUNT LOOP
7717: IF p_search_ctx THEN
7718: IF p_search_list(I).STATE IS NOT NULL THEN
7719: x_stage_list(I).TX15 :=
7720: HZ_TRANS_PKG.WRSTATE_CLEANSE(
7721: p_search_list(I).STATE
7722: ,null,'STATE'
7723: ,'PARTY_SITES','SEARCH');
7724: ELSE

Line 7729: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(

7725: x_stage_list(I).TX15 := '';
7726: END IF;
7727: ELSE
7728: IF p_search_list(I).STATE IS NOT NULL THEN
7729: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(
7730: x_stage_list(I).TX15
7731: ,null,'STATE'
7732: ,'PARTY_SITES','SCORE');
7733: IF tmp IS NOT NULL THEN

Line 7743: HZ_TRANS_PKG.WRSTATE_EXACT(

7739: FOR I IN 1..p_search_list.COUNT LOOP
7740: IF p_search_ctx THEN
7741: IF p_search_list(I).STATE IS NOT NULL THEN
7742: x_stage_list(I).TX14 :=
7743: HZ_TRANS_PKG.WRSTATE_EXACT(
7744: p_search_list(I).STATE
7745: ,null,'STATE'
7746: ,'PARTY_SITES','SEARCH');
7747: ELSE

Line 7752: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(

7748: x_stage_list(I).TX14 := '';
7749: END IF;
7750: ELSE
7751: IF p_search_list(I).STATE IS NOT NULL THEN
7752: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(
7753: x_stage_list(I).TX14
7754: ,null,'STATE'
7755: ,'PARTY_SITES','SCORE');
7756: IF tmp IS NOT NULL THEN

Line 7883: HZ_TRANS_PKG.RM_SPLCHAR_CTX(

7879: FOR I IN 1..p_search_list.COUNT LOOP
7880: IF p_search_ctx THEN
7881: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
7882: x_stage_list(I).TX1 :=
7883: HZ_TRANS_PKG.RM_SPLCHAR_CTX(
7884: p_search_list(I).FLEX_FORMAT_PHONE_NUMBER
7885: ,null,'FLEX_FORMAT_PHONE_NUMBER'
7886: ,'CONTACT_POINTS','SEARCH');
7887: ELSE

Line 7892: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(

7888: x_stage_list(I).TX1 := '';
7889: END IF;
7890: ELSE
7891: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
7892: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(
7893: x_stage_list(I).TX1
7894: ,null,'FLEX_FORMAT_PHONE_NUMBER'
7895: ,'CONTACT_POINTS','SCORE');
7896: IF tmp IS NOT NULL THEN

Line 7906: HZ_TRANS_PKG.RM_SPLCHAR(

7902: FOR I IN 1..p_search_list.COUNT LOOP
7903: IF p_search_ctx THEN
7904: IF p_search_list(I).PHONE_AREA_CODE IS NOT NULL THEN
7905: x_stage_list(I).TX3 :=
7906: HZ_TRANS_PKG.RM_SPLCHAR(
7907: p_search_list(I).PHONE_AREA_CODE
7908: ,null,'PHONE_AREA_CODE'
7909: ,'CONTACT_POINTS','SEARCH');
7910: ELSE

Line 7915: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

7911: x_stage_list(I).TX3 := '';
7912: END IF;
7913: ELSE
7914: IF p_search_list(I).PHONE_AREA_CODE IS NOT NULL THEN
7915: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
7916: x_stage_list(I).TX3
7917: ,null,'PHONE_AREA_CODE'
7918: ,'CONTACT_POINTS','SCORE');
7919: IF tmp IS NOT NULL THEN

Line 7929: HZ_TRANS_PKG.RM_SPLCHAR(

7925: FOR I IN 1..p_search_list.COUNT LOOP
7926: IF p_search_ctx THEN
7927: IF p_search_list(I).PHONE_COUNTRY_CODE IS NOT NULL THEN
7928: x_stage_list(I).TX4 :=
7929: HZ_TRANS_PKG.RM_SPLCHAR(
7930: p_search_list(I).PHONE_COUNTRY_CODE
7931: ,null,'PHONE_COUNTRY_CODE'
7932: ,'CONTACT_POINTS','SEARCH');
7933: ELSE

Line 7938: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

7934: x_stage_list(I).TX4 := '';
7935: END IF;
7936: ELSE
7937: IF p_search_list(I).PHONE_COUNTRY_CODE IS NOT NULL THEN
7938: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
7939: x_stage_list(I).TX4
7940: ,null,'PHONE_COUNTRY_CODE'
7941: ,'CONTACT_POINTS','SCORE');
7942: IF tmp IS NOT NULL THEN