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

Line 958: HZ_TRANS_PKG.clear_globals;

954: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
955: 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);
956: END IF;
957: -- Transform search criteria
958: HZ_TRANS_PKG.clear_globals;
959: MAP_PARTY_REC(FALSE,p_party_search_rec, l_dummy, g_party_stage_rec);
960: MAP_PARTY_SITE_REC(FALSE,p_party_site_list, l_dummy, g_party_site_stage_list);
961: MAP_CONTACT_REC(FALSE,p_contact_list, l_dummy, g_contact_stage_list);
962: MAP_CONTACT_POINT_REC(FALSE,p_contact_point_list, l_dummy, g_contact_pt_stage_list);

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

1011: g_contact_pt_stage_list.DELETE;
1012: call_order.DELETE;
1013: call_max_score.DELETE;
1014: HZ_DQM_SEARCH_UTIL.new_search;
1015: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
1016: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1017:
1018: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1019: 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 3523: HZ_TRANS_PKG.EXACT(

3519: /********************* Find Parties private procedures *******/
3520: PROCEDURE set_person_party_type IS
3521: BEGIN
3522: g_party_stage_rec.TX36:=
3523: HZ_TRANS_PKG.EXACT(
3524: 'PERSON'
3525: ,null,'PARTY_TYPE'
3526: ,'PARTY');
3527: END;

Line 6355: HZ_TRANS_PKG.EXACT(

6351: END IF;
6352: IF p_search_ctx THEN
6353: IF p_search_rec.DUNS_NUMBER_C IS NOT NULL THEN
6354: x_stage_rec.TX41 :=
6355: HZ_TRANS_PKG.EXACT(
6356: p_search_rec.DUNS_NUMBER_C
6357: ,null,'DUNS_NUMBER_C'
6358: ,'PARTY');
6359: ELSE

Line 6370: HZ_TRANS_PKG.WRNAMES_CLEANSE(

6366: END IF;
6367: IF p_search_ctx THEN
6368: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6369: x_stage_rec.TX40 :=
6370: HZ_TRANS_PKG.WRNAMES_CLEANSE(
6371: p_search_rec.PARTY_ALL_NAMES
6372: ,null,'PARTY_ALL_NAMES'
6373: ,'PARTY','SEARCH');
6374: ELSE

Line 6379: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

6375: x_stage_rec.TX40 := '';
6376: END IF;
6377: ELSE
6378: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6379: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
6380: x_stage_rec.TX40
6381: ,null,'PARTY_ALL_NAMES'
6382: ,'PARTY','SCORE');
6383: IF tmp IS NOT NULL THEN

Line 6391: HZ_TRANS_PKG.WRNAMES_EXACT(

6387: END IF;
6388: IF p_search_ctx THEN
6389: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6390: x_stage_rec.TX39 :=
6391: HZ_TRANS_PKG.WRNAMES_EXACT(
6392: p_search_rec.PARTY_ALL_NAMES
6393: ,null,'PARTY_ALL_NAMES'
6394: ,'PARTY','SEARCH');
6395: ELSE

Line 6400: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

6396: x_stage_rec.TX39 := '';
6397: END IF;
6398: ELSE
6399: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6400: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
6401: x_stage_rec.TX39
6402: ,null,'PARTY_ALL_NAMES'
6403: ,'PARTY','SCORE');
6404: IF tmp IS NOT NULL THEN

Line 6412: HZ_TRANS_PKG.EXACT(

6408: END IF;
6409: IF p_search_ctx THEN
6410: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
6411: x_stage_rec.TX36 :=
6412: HZ_TRANS_PKG.EXACT(
6413: p_search_rec.PARTY_TYPE
6414: ,null,'PARTY_TYPE'
6415: ,'PARTY');
6416: ELSE

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

6421: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6422: l_party_name := p_search_rec.PARTY_ALL_NAMES;
6423: END IF;
6424: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
6425: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
6426: END IF;
6427: EXCEPTION
6428: WHEN OTHERS THEN
6429: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 6486: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6482: FOR I IN 1..p_search_list.COUNT LOOP
6483: IF p_search_ctx THEN
6484: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6485: x_stage_list(I).TX4 :=
6486: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6487: p_search_list(I).ADDRESS
6488: ,null,'ADDRESS'
6489: ,'PARTY_SITES','SEARCH');
6490: ELSE

Line 6495: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6491: x_stage_list(I).TX4 := '';
6492: END IF;
6493: ELSE
6494: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6495: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6496: x_stage_list(I).TX4
6497: ,null,'ADDRESS'
6498: ,'PARTY_SITES','SCORE');
6499: IF tmp IS NOT NULL THEN

Line 6509: HZ_TRANS_PKG.WRADDRESS_EXACT(

6505: FOR I IN 1..p_search_list.COUNT LOOP
6506: IF p_search_ctx THEN
6507: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6508: x_stage_list(I).TX3 :=
6509: HZ_TRANS_PKG.WRADDRESS_EXACT(
6510: p_search_list(I).ADDRESS
6511: ,null,'ADDRESS'
6512: ,'PARTY_SITES','SEARCH');
6513: ELSE

Line 6518: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

6514: x_stage_list(I).TX3 := '';
6515: END IF;
6516: ELSE
6517: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6518: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(
6519: x_stage_list(I).TX3
6520: ,null,'ADDRESS'
6521: ,'PARTY_SITES','SCORE');
6522: IF tmp IS NOT NULL THEN

Line 6532: HZ_TRANS_PKG.CLEANSE(

6528: FOR I IN 1..p_search_list.COUNT LOOP
6529: IF p_search_ctx THEN
6530: IF p_search_list(I).CITY IS NOT NULL THEN
6531: x_stage_list(I).TX10 :=
6532: HZ_TRANS_PKG.CLEANSE(
6533: p_search_list(I).CITY
6534: ,null,'CITY'
6535: ,'PARTY_SITES');
6536: ELSE

Line 6545: HZ_TRANS_PKG.EXACT(

6541: FOR I IN 1..p_search_list.COUNT LOOP
6542: IF p_search_ctx THEN
6543: IF p_search_list(I).CITY IS NOT NULL THEN
6544: x_stage_list(I).TX9 :=
6545: HZ_TRANS_PKG.EXACT(
6546: p_search_list(I).CITY
6547: ,null,'CITY'
6548: ,'PARTY_SITES');
6549: ELSE

Line 6558: HZ_TRANS_PKG.RM_SPLCHAR(

6554: FOR I IN 1..p_search_list.COUNT LOOP
6555: IF p_search_ctx THEN
6556: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6557: x_stage_list(I).TX11 :=
6558: HZ_TRANS_PKG.RM_SPLCHAR(
6559: p_search_list(I).POSTAL_CODE
6560: ,null,'POSTAL_CODE'
6561: ,'PARTY_SITES','SEARCH');
6562: ELSE

Line 6567: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

6563: x_stage_list(I).TX11 := '';
6564: END IF;
6565: ELSE
6566: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6567: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
6568: x_stage_list(I).TX11
6569: ,null,'POSTAL_CODE'
6570: ,'PARTY_SITES','SCORE');
6571: IF tmp IS NOT NULL THEN

Line 6581: HZ_TRANS_PKG.WRSTATE_CLEANSE(

6577: FOR I IN 1..p_search_list.COUNT LOOP
6578: IF p_search_ctx THEN
6579: IF p_search_list(I).STATE IS NOT NULL THEN
6580: x_stage_list(I).TX15 :=
6581: HZ_TRANS_PKG.WRSTATE_CLEANSE(
6582: p_search_list(I).STATE
6583: ,null,'STATE'
6584: ,'PARTY_SITES','SEARCH');
6585: ELSE

Line 6590: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(

6586: x_stage_list(I).TX15 := '';
6587: END IF;
6588: ELSE
6589: IF p_search_list(I).STATE IS NOT NULL THEN
6590: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(
6591: x_stage_list(I).TX15
6592: ,null,'STATE'
6593: ,'PARTY_SITES','SCORE');
6594: IF tmp IS NOT NULL THEN

Line 6604: HZ_TRANS_PKG.WRSTATE_EXACT(

6600: FOR I IN 1..p_search_list.COUNT LOOP
6601: IF p_search_ctx THEN
6602: IF p_search_list(I).STATE IS NOT NULL THEN
6603: x_stage_list(I).TX14 :=
6604: HZ_TRANS_PKG.WRSTATE_EXACT(
6605: p_search_list(I).STATE
6606: ,null,'STATE'
6607: ,'PARTY_SITES','SEARCH');
6608: ELSE

Line 6613: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(

6609: x_stage_list(I).TX14 := '';
6610: END IF;
6611: ELSE
6612: IF p_search_list(I).STATE IS NOT NULL THEN
6613: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(
6614: x_stage_list(I).TX14
6615: ,null,'STATE'
6616: ,'PARTY_SITES','SCORE');
6617: IF tmp IS NOT NULL THEN

Line 6671: HZ_TRANS_PKG.WRPERSON_CLEANSE(

6667: FOR I IN 1..p_search_list.COUNT LOOP
6668: IF p_search_ctx THEN
6669: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
6670: x_stage_list(I).TX6 :=
6671: HZ_TRANS_PKG.WRPERSON_CLEANSE(
6672: p_search_list(I).CONTACT_NAME
6673: ,null,'CONTACT_NAME'
6674: ,'CONTACTS','SEARCH');
6675: ELSE

Line 6680: tmp := HZ_TRANS_PKG.WRPERSON_CLEANSE(

6676: x_stage_list(I).TX6 := '';
6677: END IF;
6678: ELSE
6679: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
6680: tmp := HZ_TRANS_PKG.WRPERSON_CLEANSE(
6681: x_stage_list(I).TX6
6682: ,null,'CONTACT_NAME'
6683: ,'CONTACTS','SCORE');
6684: IF tmp IS NOT NULL THEN

Line 6694: HZ_TRANS_PKG.WRPERSON_EXACT(

6690: FOR I IN 1..p_search_list.COUNT LOOP
6691: IF p_search_ctx THEN
6692: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
6693: x_stage_list(I).TX5 :=
6694: HZ_TRANS_PKG.WRPERSON_EXACT(
6695: p_search_list(I).CONTACT_NAME
6696: ,null,'CONTACT_NAME'
6697: ,'CONTACTS','SEARCH');
6698: ELSE

Line 6703: tmp := HZ_TRANS_PKG.WRPERSON_EXACT(

6699: x_stage_list(I).TX5 := '';
6700: END IF;
6701: ELSE
6702: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
6703: tmp := HZ_TRANS_PKG.WRPERSON_EXACT(
6704: x_stage_list(I).TX5
6705: ,null,'CONTACT_NAME'
6706: ,'CONTACTS','SCORE');
6707: IF tmp IS NOT NULL THEN

Line 6792: HZ_TRANS_PKG.CLEANSED_EMAIL(

6788: FOR I IN 1..p_search_list.COUNT LOOP
6789: IF p_search_ctx THEN
6790: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
6791: x_stage_list(I).TX6 :=
6792: HZ_TRANS_PKG.CLEANSED_EMAIL(
6793: p_search_list(I).EMAIL_ADDRESS
6794: ,null,'EMAIL_ADDRESS'
6795: ,'CONTACT_POINTS','SEARCH');
6796: ELSE

Line 6801: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(

6797: x_stage_list(I).TX6 := '';
6798: END IF;
6799: ELSE
6800: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
6801: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(
6802: x_stage_list(I).TX6
6803: ,null,'EMAIL_ADDRESS'
6804: ,'CONTACT_POINTS','SCORE');
6805: IF tmp IS NOT NULL THEN

Line 6815: HZ_TRANS_PKG.EXACT_EMAIL(

6811: FOR I IN 1..p_search_list.COUNT LOOP
6812: IF p_search_ctx THEN
6813: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
6814: x_stage_list(I).TX5 :=
6815: HZ_TRANS_PKG.EXACT_EMAIL(
6816: p_search_list(I).EMAIL_ADDRESS
6817: ,null,'EMAIL_ADDRESS'
6818: ,'CONTACT_POINTS');
6819: ELSE

Line 6828: HZ_TRANS_PKG.RM_SPLCHAR_CTX(

6824: FOR I IN 1..p_search_list.COUNT LOOP
6825: IF p_search_ctx THEN
6826: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
6827: x_stage_list(I).TX1 :=
6828: HZ_TRANS_PKG.RM_SPLCHAR_CTX(
6829: p_search_list(I).FLEX_FORMAT_PHONE_NUMBER
6830: ,null,'FLEX_FORMAT_PHONE_NUMBER'
6831: ,'CONTACT_POINTS','SEARCH');
6832: ELSE

Line 6837: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(

6833: x_stage_list(I).TX1 := '';
6834: END IF;
6835: ELSE
6836: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
6837: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(
6838: x_stage_list(I).TX1
6839: ,null,'FLEX_FORMAT_PHONE_NUMBER'
6840: ,'CONTACT_POINTS','SCORE');
6841: IF tmp IS NOT NULL THEN

Line 6851: HZ_TRANS_PKG.CLEANSED_URL(

6847: FOR I IN 1..p_search_list.COUNT LOOP
6848: IF p_search_ctx THEN
6849: IF p_search_list(I).URL IS NOT NULL THEN
6850: x_stage_list(I).TX8 :=
6851: HZ_TRANS_PKG.CLEANSED_URL(
6852: p_search_list(I).URL
6853: ,null,'URL'
6854: ,'CONTACT_POINTS','SEARCH');
6855: ELSE

Line 6860: tmp := HZ_TRANS_PKG.CLEANSED_URL(

6856: x_stage_list(I).TX8 := '';
6857: END IF;
6858: ELSE
6859: IF p_search_list(I).URL IS NOT NULL THEN
6860: tmp := HZ_TRANS_PKG.CLEANSED_URL(
6861: x_stage_list(I).TX8
6862: ,null,'URL'
6863: ,'CONTACT_POINTS','SCORE');
6864: IF tmp IS NOT NULL THEN