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

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

Line 6360: HZ_TRANS_PKG.EXACT(

6356: END IF;
6357: IF p_search_ctx THEN
6358: IF p_search_rec.DUNS_NUMBER_C IS NOT NULL THEN
6359: x_stage_rec.TX41 :=
6360: HZ_TRANS_PKG.EXACT(
6361: p_search_rec.DUNS_NUMBER_C
6362: ,null,'DUNS_NUMBER_C'
6363: ,'PARTY');
6364: ELSE

Line 6375: HZ_TRANS_PKG.WRNAMES_CLEANSE(

6371: END IF;
6372: IF p_search_ctx THEN
6373: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6374: x_stage_rec.TX40 :=
6375: HZ_TRANS_PKG.WRNAMES_CLEANSE(
6376: p_search_rec.PARTY_ALL_NAMES
6377: ,null,'PARTY_ALL_NAMES'
6378: ,'PARTY','SEARCH');
6379: ELSE

Line 6384: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

6380: x_stage_rec.TX40 := '';
6381: END IF;
6382: ELSE
6383: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6384: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
6385: x_stage_rec.TX40
6386: ,null,'PARTY_ALL_NAMES'
6387: ,'PARTY','SCORE');
6388: IF tmp IS NOT NULL THEN

Line 6396: HZ_TRANS_PKG.WRNAMES_EXACT(

6392: END IF;
6393: IF p_search_ctx THEN
6394: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6395: x_stage_rec.TX39 :=
6396: HZ_TRANS_PKG.WRNAMES_EXACT(
6397: p_search_rec.PARTY_ALL_NAMES
6398: ,null,'PARTY_ALL_NAMES'
6399: ,'PARTY','SEARCH');
6400: ELSE

Line 6405: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

6401: x_stage_rec.TX39 := '';
6402: END IF;
6403: ELSE
6404: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6405: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
6406: x_stage_rec.TX39
6407: ,null,'PARTY_ALL_NAMES'
6408: ,'PARTY','SCORE');
6409: IF tmp IS NOT NULL THEN

Line 6417: HZ_TRANS_PKG.EXACT(

6413: END IF;
6414: IF p_search_ctx THEN
6415: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
6416: x_stage_rec.TX36 :=
6417: HZ_TRANS_PKG.EXACT(
6418: p_search_rec.PARTY_TYPE
6419: ,null,'PARTY_TYPE'
6420: ,'PARTY');
6421: ELSE

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

6426: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6427: l_party_name := p_search_rec.PARTY_ALL_NAMES;
6428: END IF;
6429: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
6430: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
6431: END IF;
6432: EXCEPTION
6433: WHEN OTHERS THEN
6434: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 6491: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6487: FOR I IN 1..p_search_list.COUNT LOOP
6488: IF p_search_ctx THEN
6489: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6490: x_stage_list(I).TX4 :=
6491: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6492: p_search_list(I).ADDRESS
6493: ,null,'ADDRESS'
6494: ,'PARTY_SITES','SEARCH');
6495: ELSE

Line 6500: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6496: x_stage_list(I).TX4 := '';
6497: END IF;
6498: ELSE
6499: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6500: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6501: x_stage_list(I).TX4
6502: ,null,'ADDRESS'
6503: ,'PARTY_SITES','SCORE');
6504: IF tmp IS NOT NULL THEN

Line 6514: HZ_TRANS_PKG.WRADDRESS_EXACT(

6510: FOR I IN 1..p_search_list.COUNT LOOP
6511: IF p_search_ctx THEN
6512: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6513: x_stage_list(I).TX3 :=
6514: HZ_TRANS_PKG.WRADDRESS_EXACT(
6515: p_search_list(I).ADDRESS
6516: ,null,'ADDRESS'
6517: ,'PARTY_SITES','SEARCH');
6518: ELSE

Line 6523: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

6519: x_stage_list(I).TX3 := '';
6520: END IF;
6521: ELSE
6522: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6523: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(
6524: x_stage_list(I).TX3
6525: ,null,'ADDRESS'
6526: ,'PARTY_SITES','SCORE');
6527: IF tmp IS NOT NULL THEN

Line 6537: HZ_TRANS_PKG.CLEANSE(

6533: FOR I IN 1..p_search_list.COUNT LOOP
6534: IF p_search_ctx THEN
6535: IF p_search_list(I).CITY IS NOT NULL THEN
6536: x_stage_list(I).TX10 :=
6537: HZ_TRANS_PKG.CLEANSE(
6538: p_search_list(I).CITY
6539: ,null,'CITY'
6540: ,'PARTY_SITES');
6541: ELSE

Line 6550: HZ_TRANS_PKG.EXACT(

6546: FOR I IN 1..p_search_list.COUNT LOOP
6547: IF p_search_ctx THEN
6548: IF p_search_list(I).CITY IS NOT NULL THEN
6549: x_stage_list(I).TX9 :=
6550: HZ_TRANS_PKG.EXACT(
6551: p_search_list(I).CITY
6552: ,null,'CITY'
6553: ,'PARTY_SITES');
6554: ELSE

Line 6563: HZ_TRANS_PKG.RM_SPLCHAR(

6559: FOR I IN 1..p_search_list.COUNT LOOP
6560: IF p_search_ctx THEN
6561: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6562: x_stage_list(I).TX11 :=
6563: HZ_TRANS_PKG.RM_SPLCHAR(
6564: p_search_list(I).POSTAL_CODE
6565: ,null,'POSTAL_CODE'
6566: ,'PARTY_SITES','SEARCH');
6567: ELSE

Line 6572: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

6568: x_stage_list(I).TX11 := '';
6569: END IF;
6570: ELSE
6571: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6572: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
6573: x_stage_list(I).TX11
6574: ,null,'POSTAL_CODE'
6575: ,'PARTY_SITES','SCORE');
6576: IF tmp IS NOT NULL THEN

Line 6586: HZ_TRANS_PKG.WRSTATE_CLEANSE(

6582: FOR I IN 1..p_search_list.COUNT LOOP
6583: IF p_search_ctx THEN
6584: IF p_search_list(I).STATE IS NOT NULL THEN
6585: x_stage_list(I).TX15 :=
6586: HZ_TRANS_PKG.WRSTATE_CLEANSE(
6587: p_search_list(I).STATE
6588: ,null,'STATE'
6589: ,'PARTY_SITES','SEARCH');
6590: ELSE

Line 6595: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(

6591: x_stage_list(I).TX15 := '';
6592: END IF;
6593: ELSE
6594: IF p_search_list(I).STATE IS NOT NULL THEN
6595: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(
6596: x_stage_list(I).TX15
6597: ,null,'STATE'
6598: ,'PARTY_SITES','SCORE');
6599: IF tmp IS NOT NULL THEN

Line 6609: HZ_TRANS_PKG.WRSTATE_EXACT(

6605: FOR I IN 1..p_search_list.COUNT LOOP
6606: IF p_search_ctx THEN
6607: IF p_search_list(I).STATE IS NOT NULL THEN
6608: x_stage_list(I).TX14 :=
6609: HZ_TRANS_PKG.WRSTATE_EXACT(
6610: p_search_list(I).STATE
6611: ,null,'STATE'
6612: ,'PARTY_SITES','SEARCH');
6613: ELSE

Line 6618: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(

6614: x_stage_list(I).TX14 := '';
6615: END IF;
6616: ELSE
6617: IF p_search_list(I).STATE IS NOT NULL THEN
6618: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(
6619: x_stage_list(I).TX14
6620: ,null,'STATE'
6621: ,'PARTY_SITES','SCORE');
6622: IF tmp IS NOT NULL THEN

Line 6676: HZ_TRANS_PKG.WRPERSON_CLEANSE(

6672: FOR I IN 1..p_search_list.COUNT LOOP
6673: IF p_search_ctx THEN
6674: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
6675: x_stage_list(I).TX6 :=
6676: HZ_TRANS_PKG.WRPERSON_CLEANSE(
6677: p_search_list(I).CONTACT_NAME
6678: ,null,'CONTACT_NAME'
6679: ,'CONTACTS','SEARCH');
6680: ELSE

Line 6685: tmp := HZ_TRANS_PKG.WRPERSON_CLEANSE(

6681: x_stage_list(I).TX6 := '';
6682: END IF;
6683: ELSE
6684: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
6685: tmp := HZ_TRANS_PKG.WRPERSON_CLEANSE(
6686: x_stage_list(I).TX6
6687: ,null,'CONTACT_NAME'
6688: ,'CONTACTS','SCORE');
6689: IF tmp IS NOT NULL THEN

Line 6699: HZ_TRANS_PKG.WRPERSON_EXACT(

6695: FOR I IN 1..p_search_list.COUNT LOOP
6696: IF p_search_ctx THEN
6697: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
6698: x_stage_list(I).TX5 :=
6699: HZ_TRANS_PKG.WRPERSON_EXACT(
6700: p_search_list(I).CONTACT_NAME
6701: ,null,'CONTACT_NAME'
6702: ,'CONTACTS','SEARCH');
6703: ELSE

Line 6708: tmp := HZ_TRANS_PKG.WRPERSON_EXACT(

6704: x_stage_list(I).TX5 := '';
6705: END IF;
6706: ELSE
6707: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
6708: tmp := HZ_TRANS_PKG.WRPERSON_EXACT(
6709: x_stage_list(I).TX5
6710: ,null,'CONTACT_NAME'
6711: ,'CONTACTS','SCORE');
6712: IF tmp IS NOT NULL THEN

Line 6797: HZ_TRANS_PKG.CLEANSED_EMAIL(

6793: FOR I IN 1..p_search_list.COUNT LOOP
6794: IF p_search_ctx THEN
6795: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
6796: x_stage_list(I).TX6 :=
6797: HZ_TRANS_PKG.CLEANSED_EMAIL(
6798: p_search_list(I).EMAIL_ADDRESS
6799: ,null,'EMAIL_ADDRESS'
6800: ,'CONTACT_POINTS','SEARCH');
6801: ELSE

Line 6806: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(

6802: x_stage_list(I).TX6 := '';
6803: END IF;
6804: ELSE
6805: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
6806: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(
6807: x_stage_list(I).TX6
6808: ,null,'EMAIL_ADDRESS'
6809: ,'CONTACT_POINTS','SCORE');
6810: IF tmp IS NOT NULL THEN

Line 6820: HZ_TRANS_PKG.EXACT_EMAIL(

6816: FOR I IN 1..p_search_list.COUNT LOOP
6817: IF p_search_ctx THEN
6818: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
6819: x_stage_list(I).TX5 :=
6820: HZ_TRANS_PKG.EXACT_EMAIL(
6821: p_search_list(I).EMAIL_ADDRESS
6822: ,null,'EMAIL_ADDRESS'
6823: ,'CONTACT_POINTS');
6824: ELSE

Line 6833: HZ_TRANS_PKG.RM_SPLCHAR_CTX(

6829: FOR I IN 1..p_search_list.COUNT LOOP
6830: IF p_search_ctx THEN
6831: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
6832: x_stage_list(I).TX1 :=
6833: HZ_TRANS_PKG.RM_SPLCHAR_CTX(
6834: p_search_list(I).FLEX_FORMAT_PHONE_NUMBER
6835: ,null,'FLEX_FORMAT_PHONE_NUMBER'
6836: ,'CONTACT_POINTS','SEARCH');
6837: ELSE

Line 6842: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(

6838: x_stage_list(I).TX1 := '';
6839: END IF;
6840: ELSE
6841: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
6842: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(
6843: x_stage_list(I).TX1
6844: ,null,'FLEX_FORMAT_PHONE_NUMBER'
6845: ,'CONTACT_POINTS','SCORE');
6846: IF tmp IS NOT NULL THEN

Line 6856: HZ_TRANS_PKG.CLEANSED_URL(

6852: FOR I IN 1..p_search_list.COUNT LOOP
6853: IF p_search_ctx THEN
6854: IF p_search_list(I).URL IS NOT NULL THEN
6855: x_stage_list(I).TX8 :=
6856: HZ_TRANS_PKG.CLEANSED_URL(
6857: p_search_list(I).URL
6858: ,null,'URL'
6859: ,'CONTACT_POINTS','SEARCH');
6860: ELSE

Line 6865: tmp := HZ_TRANS_PKG.CLEANSED_URL(

6861: x_stage_list(I).TX8 := '';
6862: END IF;
6863: ELSE
6864: IF p_search_list(I).URL IS NOT NULL THEN
6865: tmp := HZ_TRANS_PKG.CLEANSED_URL(
6866: x_stage_list(I).TX8
6867: ,null,'URL'
6868: ,'CONTACT_POINTS','SCORE');
6869: IF tmp IS NOT NULL THEN