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

4305: /********************* Find Parties private procedures *******/
4306: PROCEDURE set_person_party_type IS
4307: BEGIN
4308: g_party_stage_rec.TX36:=
4309: HZ_TRANS_PKG.EXACT(
4310: 'PERSON'
4311: ,null,'PARTY_TYPE'
4312: ,'PARTY');
4313: END;

Line 7296: HZ_TRANS_PKG.WRNAMES_CLEANSE(

7292: END IF;
7293: IF p_search_ctx THEN
7294: IF p_search_rec.ALL_ACCOUNT_NAMES IS NOT NULL THEN
7295: x_stage_rec.TX33 :=
7296: HZ_TRANS_PKG.WRNAMES_CLEANSE(
7297: p_search_rec.ALL_ACCOUNT_NAMES
7298: ,null,'ALL_ACCOUNT_NAMES'
7299: ,'PARTY','SEARCH');
7300: ELSE

Line 7305: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

7301: x_stage_rec.TX33 := '';
7302: END IF;
7303: ELSE
7304: IF p_search_rec.ALL_ACCOUNT_NAMES IS NOT NULL THEN
7305: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
7306: x_stage_rec.TX33
7307: ,null,'ALL_ACCOUNT_NAMES'
7308: ,'PARTY','SCORE');
7309: IF tmp IS NOT NULL THEN

Line 7317: HZ_TRANS_PKG.WRNAMES_EXACT(

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

Line 7326: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

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

Line 7338: HZ_TRANS_PKG.RM_SPLCHAR(

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

Line 7347: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

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

Line 7359: HZ_TRANS_PKG.EXACT(

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

Line 7370: HZ_TRANS_PKG.EXACT(

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

Line 7381: HZ_TRANS_PKG.SOUNDX(

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

Line 7392: HZ_TRANS_PKG.WRNAMES_CLEANSE(

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.TX40 :=
7392: HZ_TRANS_PKG.WRNAMES_CLEANSE(
7393: p_search_rec.PARTY_ALL_NAMES
7394: ,null,'PARTY_ALL_NAMES'
7395: ,'PARTY','SEARCH');
7396: ELSE

Line 7401: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

7397: x_stage_rec.TX40 := '';
7398: END IF;
7399: ELSE
7400: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
7401: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
7402: x_stage_rec.TX40
7403: ,null,'PARTY_ALL_NAMES'
7404: ,'PARTY','SCORE');
7405: IF tmp IS NOT NULL THEN

Line 7413: HZ_TRANS_PKG.WRNAMES_EXACT(

7409: END IF;
7410: IF p_search_ctx THEN
7411: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
7412: x_stage_rec.TX39 :=
7413: HZ_TRANS_PKG.WRNAMES_EXACT(
7414: p_search_rec.PARTY_ALL_NAMES
7415: ,null,'PARTY_ALL_NAMES'
7416: ,'PARTY','SEARCH');
7417: ELSE

Line 7422: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

7418: x_stage_rec.TX39 := '';
7419: END IF;
7420: ELSE
7421: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
7422: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
7423: x_stage_rec.TX39
7424: ,null,'PARTY_ALL_NAMES'
7425: ,'PARTY','SCORE');
7426: IF tmp IS NOT NULL THEN

Line 7434: HZ_TRANS_PKG.RM_SPLCHAR(

7430: END IF;
7431: IF p_search_ctx THEN
7432: IF p_search_rec.PARTY_NUMBER IS NOT NULL THEN
7433: x_stage_rec.TX34 :=
7434: HZ_TRANS_PKG.RM_SPLCHAR(
7435: p_search_rec.PARTY_NUMBER
7436: ,null,'PARTY_NUMBER'
7437: ,'PARTY','SEARCH');
7438: ELSE

Line 7443: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

7439: x_stage_rec.TX34 := '';
7440: END IF;
7441: ELSE
7442: IF p_search_rec.PARTY_NUMBER IS NOT NULL THEN
7443: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
7444: x_stage_rec.TX34
7445: ,null,'PARTY_NUMBER'
7446: ,'PARTY','SCORE');
7447: IF tmp IS NOT NULL THEN

Line 7454: HZ_TRANS_PKG.EXACT(

7450: END IF;
7451: END IF;
7452: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
7453: x_stage_rec.TX36 :=
7454: HZ_TRANS_PKG.EXACT(
7455: p_search_rec.PARTY_TYPE
7456: ,null,'PARTY_TYPE'
7457: ,'PARTY');
7458: ELSE

Line 7464: HZ_TRANS_PKG.EXACT(

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

Line 7475: HZ_TRANS_PKG.EXACT(

7471: END IF;
7472: IF p_search_ctx THEN
7473: IF p_search_rec.SIC_CODE IS NOT NULL THEN
7474: x_stage_rec.TX46 :=
7475: HZ_TRANS_PKG.EXACT(
7476: p_search_rec.SIC_CODE
7477: ,null,'SIC_CODE'
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_TYPE IS NOT NULL THEN
7485: x_stage_rec.TX47 :=
7486: HZ_TRANS_PKG.EXACT(
7487: p_search_rec.SIC_CODE_TYPE
7488: ,null,'SIC_CODE_TYPE'
7489: ,'PARTY');
7490: ELSE

Line 7497: HZ_TRANS_PKG.CLEANSE(

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

Line 7508: HZ_TRANS_PKG.EXACT(

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

Line 7519: HZ_TRANS_PKG.RM_SPLCHAR(

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

Line 7528: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

7524: x_stage_rec.TX44 := '';
7525: END IF;
7526: ELSE
7527: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
7528: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
7529: x_stage_rec.TX44
7530: ,null,'TAX_REFERENCE'
7531: ,'PARTY','SCORE');
7532: IF tmp IS NOT NULL THEN

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

7538: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
7539: l_party_name := p_search_rec.PARTY_ALL_NAMES;
7540: END IF;
7541: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
7542: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
7543: END IF;
7544: EXCEPTION
7545: WHEN OTHERS THEN
7546: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 7608: HZ_TRANS_PKG.CLEANSE(

7604: FOR I IN 1..p_search_list.COUNT LOOP
7605: IF p_search_ctx THEN
7606: IF p_search_list(I).CITY IS NOT NULL THEN
7607: x_stage_list(I).TX10 :=
7608: HZ_TRANS_PKG.CLEANSE(
7609: p_search_list(I).CITY
7610: ,null,'CITY'
7611: ,'PARTY_SITES');
7612: ELSE

Line 7621: HZ_TRANS_PKG.EXACT(

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

Line 7634: HZ_TRANS_PKG.EXACT(

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

Line 7647: HZ_TRANS_PKG.CLEANSE(

7643: FOR I IN 1..p_search_list.COUNT LOOP
7644: IF p_search_ctx THEN
7645: IF p_search_list(I).COUNTY IS NOT NULL THEN
7646: x_stage_list(I).TX21 :=
7647: HZ_TRANS_PKG.CLEANSE(
7648: p_search_list(I).COUNTY
7649: ,null,'COUNTY'
7650: ,'PARTY_SITES');
7651: ELSE

Line 7660: HZ_TRANS_PKG.EXACT(

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

Line 7673: HZ_TRANS_PKG.RM_SPLCHAR(

7669: FOR I IN 1..p_search_list.COUNT LOOP
7670: IF p_search_ctx THEN
7671: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
7672: x_stage_list(I).TX11 :=
7673: HZ_TRANS_PKG.RM_SPLCHAR(
7674: p_search_list(I).POSTAL_CODE
7675: ,null,'POSTAL_CODE'
7676: ,'PARTY_SITES','SEARCH');
7677: ELSE

Line 7682: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

7678: x_stage_list(I).TX11 := '';
7679: END IF;
7680: ELSE
7681: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
7682: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
7683: x_stage_list(I).TX11
7684: ,null,'POSTAL_CODE'
7685: ,'PARTY_SITES','SCORE');
7686: IF tmp IS NOT NULL THEN

Line 7696: HZ_TRANS_PKG.CLEANSE(

7692: FOR I IN 1..p_search_list.COUNT LOOP
7693: IF p_search_ctx THEN
7694: IF p_search_list(I).PROVINCE IS NOT NULL THEN
7695: x_stage_list(I).TX13 :=
7696: HZ_TRANS_PKG.CLEANSE(
7697: p_search_list(I).PROVINCE
7698: ,null,'PROVINCE'
7699: ,'PARTY_SITES');
7700: ELSE

Line 7709: HZ_TRANS_PKG.WRSTATE_CLEANSE(

7705: FOR I IN 1..p_search_list.COUNT LOOP
7706: IF p_search_ctx THEN
7707: IF p_search_list(I).STATE IS NOT NULL THEN
7708: x_stage_list(I).TX15 :=
7709: HZ_TRANS_PKG.WRSTATE_CLEANSE(
7710: p_search_list(I).STATE
7711: ,null,'STATE'
7712: ,'PARTY_SITES','SEARCH');
7713: ELSE

Line 7718: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(

7714: x_stage_list(I).TX15 := '';
7715: END IF;
7716: ELSE
7717: IF p_search_list(I).STATE IS NOT NULL THEN
7718: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(
7719: x_stage_list(I).TX15
7720: ,null,'STATE'
7721: ,'PARTY_SITES','SCORE');
7722: IF tmp IS NOT NULL THEN

Line 7732: HZ_TRANS_PKG.WRSTATE_EXACT(

7728: FOR I IN 1..p_search_list.COUNT LOOP
7729: IF p_search_ctx THEN
7730: IF p_search_list(I).STATE IS NOT NULL THEN
7731: x_stage_list(I).TX14 :=
7732: HZ_TRANS_PKG.WRSTATE_EXACT(
7733: p_search_list(I).STATE
7734: ,null,'STATE'
7735: ,'PARTY_SITES','SEARCH');
7736: ELSE

Line 7741: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(

7737: x_stage_list(I).TX14 := '';
7738: END IF;
7739: ELSE
7740: IF p_search_list(I).STATE IS NOT NULL THEN
7741: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(
7742: x_stage_list(I).TX14
7743: ,null,'STATE'
7744: ,'PARTY_SITES','SCORE');
7745: IF tmp IS NOT NULL THEN

Line 7872: HZ_TRANS_PKG.RM_SPLCHAR_CTX(

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

Line 7881: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(

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

Line 7895: HZ_TRANS_PKG.RM_SPLCHAR(

7891: FOR I IN 1..p_search_list.COUNT LOOP
7892: IF p_search_ctx THEN
7893: IF p_search_list(I).PHONE_AREA_CODE IS NOT NULL THEN
7894: x_stage_list(I).TX3 :=
7895: HZ_TRANS_PKG.RM_SPLCHAR(
7896: p_search_list(I).PHONE_AREA_CODE
7897: ,null,'PHONE_AREA_CODE'
7898: ,'CONTACT_POINTS','SEARCH');
7899: ELSE

Line 7904: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

7900: x_stage_list(I).TX3 := '';
7901: END IF;
7902: ELSE
7903: IF p_search_list(I).PHONE_AREA_CODE IS NOT NULL THEN
7904: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
7905: x_stage_list(I).TX3
7906: ,null,'PHONE_AREA_CODE'
7907: ,'CONTACT_POINTS','SCORE');
7908: IF tmp IS NOT NULL THEN

Line 7918: HZ_TRANS_PKG.RM_SPLCHAR(

7914: FOR I IN 1..p_search_list.COUNT LOOP
7915: IF p_search_ctx THEN
7916: IF p_search_list(I).PHONE_COUNTRY_CODE IS NOT NULL THEN
7917: x_stage_list(I).TX4 :=
7918: HZ_TRANS_PKG.RM_SPLCHAR(
7919: p_search_list(I).PHONE_COUNTRY_CODE
7920: ,null,'PHONE_COUNTRY_CODE'
7921: ,'CONTACT_POINTS','SEARCH');
7922: ELSE

Line 7927: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

7923: x_stage_list(I).TX4 := '';
7924: END IF;
7925: ELSE
7926: IF p_search_list(I).PHONE_COUNTRY_CODE IS NOT NULL THEN
7927: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
7928: x_stage_list(I).TX4
7929: ,null,'PHONE_COUNTRY_CODE'
7930: ,'CONTACT_POINTS','SCORE');
7931: IF tmp IS NOT NULL THEN