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

Line 971: HZ_TRANS_PKG.clear_globals;

967: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
968: 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);
969: END IF;
970: -- Transform search criteria
971: HZ_TRANS_PKG.clear_globals;
972: MAP_PARTY_REC(FALSE,p_party_search_rec, l_dummy, g_party_stage_rec);
973: MAP_PARTY_SITE_REC(FALSE,p_party_site_list, l_dummy, g_party_site_stage_list);
974: MAP_CONTACT_REC(FALSE,p_contact_list, l_dummy, g_contact_stage_list);
975: MAP_CONTACT_POINT_REC(FALSE,p_contact_point_list, l_dummy, g_contact_pt_stage_list);

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

1024: g_contact_pt_stage_list.DELETE;
1025: call_order.DELETE;
1026: call_max_score.DELETE;
1027: HZ_DQM_SEARCH_UTIL.new_search;
1028: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
1029: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1030:
1031: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1032: 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 3541: HZ_TRANS_PKG.EXACT(

3537: /********************* Find Parties private procedures *******/
3538: PROCEDURE set_person_party_type IS
3539: BEGIN
3540: g_party_stage_rec.TX36:=
3541: HZ_TRANS_PKG.EXACT(
3542: 'PERSON'
3543: ,null,'PARTY_TYPE'
3544: ,'PARTY');
3545: END;

Line 6350: HZ_TRANS_PKG.WRNAMES_CLEANSE(

6346: END IF;
6347: IF p_search_ctx THEN
6348: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6349: x_stage_rec.TX40 :=
6350: HZ_TRANS_PKG.WRNAMES_CLEANSE(
6351: p_search_rec.PARTY_ALL_NAMES
6352: ,null,'PARTY_ALL_NAMES'
6353: ,'PARTY','SEARCH');
6354: ELSE

Line 6359: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

6355: x_stage_rec.TX40 := '';
6356: END IF;
6357: ELSE
6358: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6359: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
6360: x_stage_rec.TX40
6361: ,null,'PARTY_ALL_NAMES'
6362: ,'PARTY','SCORE');
6363: IF tmp IS NOT NULL THEN

Line 6371: HZ_TRANS_PKG.WRNAMES_EXACT(

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

Line 6380: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

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

Line 6392: HZ_TRANS_PKG.EXACT(

6388: END IF;
6389: IF p_search_ctx THEN
6390: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
6391: x_stage_rec.TX36 :=
6392: HZ_TRANS_PKG.EXACT(
6393: p_search_rec.PARTY_TYPE
6394: ,null,'PARTY_TYPE'
6395: ,'PARTY');
6396: ELSE

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

6401: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6402: l_party_name := p_search_rec.PARTY_ALL_NAMES;
6403: END IF;
6404: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
6405: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
6406: END IF;
6407: EXCEPTION
6408: WHEN OTHERS THEN
6409: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 6472: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6468: FOR I IN 1..p_search_list.COUNT LOOP
6469: IF p_search_ctx THEN
6470: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6471: x_stage_list(I).TX4 :=
6472: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6473: p_search_list(I).ADDRESS
6474: ,null,'ADDRESS'
6475: ,'PARTY_SITES','SEARCH');
6476: ELSE

Line 6481: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6477: x_stage_list(I).TX4 := '';
6478: END IF;
6479: ELSE
6480: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6481: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6482: x_stage_list(I).TX4
6483: ,null,'ADDRESS'
6484: ,'PARTY_SITES','SCORE');
6485: IF tmp IS NOT NULL THEN

Line 6495: HZ_TRANS_PKG.WRADDRESS_EXACT(

6491: FOR I IN 1..p_search_list.COUNT LOOP
6492: IF p_search_ctx THEN
6493: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6494: x_stage_list(I).TX3 :=
6495: HZ_TRANS_PKG.WRADDRESS_EXACT(
6496: p_search_list(I).ADDRESS
6497: ,null,'ADDRESS'
6498: ,'PARTY_SITES','SEARCH');
6499: ELSE

Line 6504: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

6500: x_stage_list(I).TX3 := '';
6501: END IF;
6502: ELSE
6503: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6504: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(
6505: x_stage_list(I).TX3
6506: ,null,'ADDRESS'
6507: ,'PARTY_SITES','SCORE');
6508: IF tmp IS NOT NULL THEN

Line 6518: HZ_TRANS_PKG.CLEANSE(

6514: FOR I IN 1..p_search_list.COUNT LOOP
6515: IF p_search_ctx THEN
6516: IF p_search_list(I).CITY IS NOT NULL THEN
6517: x_stage_list(I).TX10 :=
6518: HZ_TRANS_PKG.CLEANSE(
6519: p_search_list(I).CITY
6520: ,null,'CITY'
6521: ,'PARTY_SITES');
6522: ELSE

Line 6531: HZ_TRANS_PKG.EXACT(

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

Line 6544: HZ_TRANS_PKG.EXACT(

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

Line 6557: HZ_TRANS_PKG.RM_SPLCHAR(

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

Line 6566: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

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

Line 6580: HZ_TRANS_PKG.CLEANSE(

6576: FOR I IN 1..p_search_list.COUNT LOOP
6577: IF p_search_ctx THEN
6578: IF p_search_list(I).PROVINCE IS NOT NULL THEN
6579: x_stage_list(I).TX13 :=
6580: HZ_TRANS_PKG.CLEANSE(
6581: p_search_list(I).PROVINCE
6582: ,null,'PROVINCE'
6583: ,'PARTY_SITES');
6584: ELSE

Line 6593: HZ_TRANS_PKG.EXACT(

6589: FOR I IN 1..p_search_list.COUNT LOOP
6590: IF p_search_ctx THEN
6591: IF p_search_list(I).PROVINCE IS NOT NULL THEN
6592: x_stage_list(I).TX12 :=
6593: HZ_TRANS_PKG.EXACT(
6594: p_search_list(I).PROVINCE
6595: ,null,'PROVINCE'
6596: ,'PARTY_SITES');
6597: ELSE

Line 6606: HZ_TRANS_PKG.WRSTATE_CLEANSE(

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

Line 6615: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(

6611: x_stage_list(I).TX15 := '';
6612: END IF;
6613: ELSE
6614: IF p_search_list(I).STATE IS NOT NULL THEN
6615: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(
6616: x_stage_list(I).TX15
6617: ,null,'STATE'
6618: ,'PARTY_SITES','SCORE');
6619: IF tmp IS NOT NULL THEN

Line 6629: HZ_TRANS_PKG.WRSTATE_EXACT(

6625: FOR I IN 1..p_search_list.COUNT LOOP
6626: IF p_search_ctx THEN
6627: IF p_search_list(I).STATE IS NOT NULL THEN
6628: x_stage_list(I).TX14 :=
6629: HZ_TRANS_PKG.WRSTATE_EXACT(
6630: p_search_list(I).STATE
6631: ,null,'STATE'
6632: ,'PARTY_SITES','SEARCH');
6633: ELSE

Line 6638: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(

6634: x_stage_list(I).TX14 := '';
6635: END IF;
6636: ELSE
6637: IF p_search_list(I).STATE IS NOT NULL THEN
6638: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(
6639: x_stage_list(I).TX14
6640: ,null,'STATE'
6641: ,'PARTY_SITES','SCORE');
6642: IF tmp IS NOT NULL THEN

Line 6696: HZ_TRANS_PKG.EXACT(

6692: FOR I IN 1..p_search_list.COUNT LOOP
6693: IF p_search_ctx THEN
6694: IF p_search_list(I).JOB_TITLE IS NOT NULL THEN
6695: x_stage_list(I).TX22 :=
6696: HZ_TRANS_PKG.EXACT(
6697: p_search_list(I).JOB_TITLE
6698: ,null,'JOB_TITLE'
6699: ,'CONTACTS');
6700: ELSE

Line 6781: HZ_TRANS_PKG.CLEANSED_EMAIL(

6777: FOR I IN 1..p_search_list.COUNT LOOP
6778: IF p_search_ctx THEN
6779: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
6780: x_stage_list(I).TX6 :=
6781: HZ_TRANS_PKG.CLEANSED_EMAIL(
6782: p_search_list(I).EMAIL_ADDRESS
6783: ,null,'EMAIL_ADDRESS'
6784: ,'CONTACT_POINTS','SEARCH');
6785: ELSE

Line 6790: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(

6786: x_stage_list(I).TX6 := '';
6787: END IF;
6788: ELSE
6789: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
6790: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(
6791: x_stage_list(I).TX6
6792: ,null,'EMAIL_ADDRESS'
6793: ,'CONTACT_POINTS','SCORE');
6794: IF tmp IS NOT NULL THEN

Line 6804: HZ_TRANS_PKG.EXACT_EMAIL(

6800: FOR I IN 1..p_search_list.COUNT LOOP
6801: IF p_search_ctx THEN
6802: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
6803: x_stage_list(I).TX5 :=
6804: HZ_TRANS_PKG.EXACT_EMAIL(
6805: p_search_list(I).EMAIL_ADDRESS
6806: ,null,'EMAIL_ADDRESS'
6807: ,'CONTACT_POINTS');
6808: ELSE

Line 6817: HZ_TRANS_PKG.RM_SPLCHAR_CTX(

6813: FOR I IN 1..p_search_list.COUNT LOOP
6814: IF p_search_ctx THEN
6815: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
6816: x_stage_list(I).TX1 :=
6817: HZ_TRANS_PKG.RM_SPLCHAR_CTX(
6818: p_search_list(I).FLEX_FORMAT_PHONE_NUMBER
6819: ,null,'FLEX_FORMAT_PHONE_NUMBER'
6820: ,'CONTACT_POINTS','SEARCH');
6821: ELSE

Line 6826: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(

6822: x_stage_list(I).TX1 := '';
6823: END IF;
6824: ELSE
6825: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
6826: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(
6827: x_stage_list(I).TX1
6828: ,null,'FLEX_FORMAT_PHONE_NUMBER'
6829: ,'CONTACT_POINTS','SCORE');
6830: IF tmp IS NOT NULL THEN