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

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

Line 6345: HZ_TRANS_PKG.WRNAMES_CLEANSE(

6341: END IF;
6342: IF p_search_ctx THEN
6343: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6344: x_stage_rec.TX40 :=
6345: HZ_TRANS_PKG.WRNAMES_CLEANSE(
6346: p_search_rec.PARTY_ALL_NAMES
6347: ,null,'PARTY_ALL_NAMES'
6348: ,'PARTY','SEARCH');
6349: ELSE

Line 6354: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

6350: x_stage_rec.TX40 := '';
6351: END IF;
6352: ELSE
6353: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6354: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
6355: x_stage_rec.TX40
6356: ,null,'PARTY_ALL_NAMES'
6357: ,'PARTY','SCORE');
6358: IF tmp IS NOT NULL THEN

Line 6366: HZ_TRANS_PKG.WRNAMES_EXACT(

6362: END IF;
6363: IF p_search_ctx THEN
6364: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6365: x_stage_rec.TX39 :=
6366: HZ_TRANS_PKG.WRNAMES_EXACT(
6367: p_search_rec.PARTY_ALL_NAMES
6368: ,null,'PARTY_ALL_NAMES'
6369: ,'PARTY','SEARCH');
6370: ELSE

Line 6375: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

6371: x_stage_rec.TX39 := '';
6372: END IF;
6373: ELSE
6374: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6375: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
6376: x_stage_rec.TX39
6377: ,null,'PARTY_ALL_NAMES'
6378: ,'PARTY','SCORE');
6379: IF tmp IS NOT NULL THEN

Line 6387: HZ_TRANS_PKG.EXACT(

6383: END IF;
6384: IF p_search_ctx THEN
6385: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
6386: x_stage_rec.TX36 :=
6387: HZ_TRANS_PKG.EXACT(
6388: p_search_rec.PARTY_TYPE
6389: ,null,'PARTY_TYPE'
6390: ,'PARTY');
6391: ELSE

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

6396: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6397: l_party_name := p_search_rec.PARTY_ALL_NAMES;
6398: END IF;
6399: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
6400: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
6401: END IF;
6402: EXCEPTION
6403: WHEN OTHERS THEN
6404: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 6467: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6463: FOR I IN 1..p_search_list.COUNT LOOP
6464: IF p_search_ctx THEN
6465: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6466: x_stage_list(I).TX4 :=
6467: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6468: p_search_list(I).ADDRESS
6469: ,null,'ADDRESS'
6470: ,'PARTY_SITES','SEARCH');
6471: ELSE

Line 6476: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6472: x_stage_list(I).TX4 := '';
6473: END IF;
6474: ELSE
6475: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6476: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6477: x_stage_list(I).TX4
6478: ,null,'ADDRESS'
6479: ,'PARTY_SITES','SCORE');
6480: IF tmp IS NOT NULL THEN

Line 6490: HZ_TRANS_PKG.WRADDRESS_EXACT(

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

Line 6499: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

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

Line 6513: HZ_TRANS_PKG.CLEANSE(

6509: FOR I IN 1..p_search_list.COUNT LOOP
6510: IF p_search_ctx THEN
6511: IF p_search_list(I).CITY IS NOT NULL THEN
6512: x_stage_list(I).TX10 :=
6513: HZ_TRANS_PKG.CLEANSE(
6514: p_search_list(I).CITY
6515: ,null,'CITY'
6516: ,'PARTY_SITES');
6517: ELSE

Line 6526: HZ_TRANS_PKG.EXACT(

6522: FOR I IN 1..p_search_list.COUNT LOOP
6523: IF p_search_ctx THEN
6524: IF p_search_list(I).CITY IS NOT NULL THEN
6525: x_stage_list(I).TX9 :=
6526: HZ_TRANS_PKG.EXACT(
6527: p_search_list(I).CITY
6528: ,null,'CITY'
6529: ,'PARTY_SITES');
6530: ELSE

Line 6539: HZ_TRANS_PKG.EXACT(

6535: FOR I IN 1..p_search_list.COUNT LOOP
6536: IF p_search_ctx THEN
6537: IF p_search_list(I).COUNTRY IS NOT NULL THEN
6538: x_stage_list(I).TX22 :=
6539: HZ_TRANS_PKG.EXACT(
6540: p_search_list(I).COUNTRY
6541: ,null,'COUNTRY'
6542: ,'PARTY_SITES');
6543: ELSE

Line 6552: HZ_TRANS_PKG.RM_SPLCHAR(

6548: FOR I IN 1..p_search_list.COUNT LOOP
6549: IF p_search_ctx THEN
6550: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6551: x_stage_list(I).TX11 :=
6552: HZ_TRANS_PKG.RM_SPLCHAR(
6553: p_search_list(I).POSTAL_CODE
6554: ,null,'POSTAL_CODE'
6555: ,'PARTY_SITES','SEARCH');
6556: ELSE

Line 6561: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

6557: x_stage_list(I).TX11 := '';
6558: END IF;
6559: ELSE
6560: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6561: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
6562: x_stage_list(I).TX11
6563: ,null,'POSTAL_CODE'
6564: ,'PARTY_SITES','SCORE');
6565: IF tmp IS NOT NULL THEN

Line 6575: HZ_TRANS_PKG.CLEANSE(

6571: FOR I IN 1..p_search_list.COUNT LOOP
6572: IF p_search_ctx THEN
6573: IF p_search_list(I).PROVINCE IS NOT NULL THEN
6574: x_stage_list(I).TX13 :=
6575: HZ_TRANS_PKG.CLEANSE(
6576: p_search_list(I).PROVINCE
6577: ,null,'PROVINCE'
6578: ,'PARTY_SITES');
6579: ELSE

Line 6588: HZ_TRANS_PKG.EXACT(

6584: FOR I IN 1..p_search_list.COUNT LOOP
6585: IF p_search_ctx THEN
6586: IF p_search_list(I).PROVINCE IS NOT NULL THEN
6587: x_stage_list(I).TX12 :=
6588: HZ_TRANS_PKG.EXACT(
6589: p_search_list(I).PROVINCE
6590: ,null,'PROVINCE'
6591: ,'PARTY_SITES');
6592: ELSE

Line 6601: HZ_TRANS_PKG.WRSTATE_CLEANSE(

6597: FOR I IN 1..p_search_list.COUNT LOOP
6598: IF p_search_ctx THEN
6599: IF p_search_list(I).STATE IS NOT NULL THEN
6600: x_stage_list(I).TX15 :=
6601: HZ_TRANS_PKG.WRSTATE_CLEANSE(
6602: p_search_list(I).STATE
6603: ,null,'STATE'
6604: ,'PARTY_SITES','SEARCH');
6605: ELSE

Line 6610: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(

6606: x_stage_list(I).TX15 := '';
6607: END IF;
6608: ELSE
6609: IF p_search_list(I).STATE IS NOT NULL THEN
6610: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(
6611: x_stage_list(I).TX15
6612: ,null,'STATE'
6613: ,'PARTY_SITES','SCORE');
6614: IF tmp IS NOT NULL THEN

Line 6624: HZ_TRANS_PKG.WRSTATE_EXACT(

6620: FOR I IN 1..p_search_list.COUNT LOOP
6621: IF p_search_ctx THEN
6622: IF p_search_list(I).STATE IS NOT NULL THEN
6623: x_stage_list(I).TX14 :=
6624: HZ_TRANS_PKG.WRSTATE_EXACT(
6625: p_search_list(I).STATE
6626: ,null,'STATE'
6627: ,'PARTY_SITES','SEARCH');
6628: ELSE

Line 6633: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(

6629: x_stage_list(I).TX14 := '';
6630: END IF;
6631: ELSE
6632: IF p_search_list(I).STATE IS NOT NULL THEN
6633: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(
6634: x_stage_list(I).TX14
6635: ,null,'STATE'
6636: ,'PARTY_SITES','SCORE');
6637: IF tmp IS NOT NULL THEN

Line 6691: HZ_TRANS_PKG.EXACT(

6687: FOR I IN 1..p_search_list.COUNT LOOP
6688: IF p_search_ctx THEN
6689: IF p_search_list(I).JOB_TITLE IS NOT NULL THEN
6690: x_stage_list(I).TX22 :=
6691: HZ_TRANS_PKG.EXACT(
6692: p_search_list(I).JOB_TITLE
6693: ,null,'JOB_TITLE'
6694: ,'CONTACTS');
6695: ELSE

Line 6776: HZ_TRANS_PKG.CLEANSED_EMAIL(

6772: FOR I IN 1..p_search_list.COUNT LOOP
6773: IF p_search_ctx THEN
6774: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
6775: x_stage_list(I).TX6 :=
6776: HZ_TRANS_PKG.CLEANSED_EMAIL(
6777: p_search_list(I).EMAIL_ADDRESS
6778: ,null,'EMAIL_ADDRESS'
6779: ,'CONTACT_POINTS','SEARCH');
6780: ELSE

Line 6785: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(

6781: x_stage_list(I).TX6 := '';
6782: END IF;
6783: ELSE
6784: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
6785: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(
6786: x_stage_list(I).TX6
6787: ,null,'EMAIL_ADDRESS'
6788: ,'CONTACT_POINTS','SCORE');
6789: IF tmp IS NOT NULL THEN

Line 6799: HZ_TRANS_PKG.EXACT_EMAIL(

6795: FOR I IN 1..p_search_list.COUNT LOOP
6796: IF p_search_ctx THEN
6797: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
6798: x_stage_list(I).TX5 :=
6799: HZ_TRANS_PKG.EXACT_EMAIL(
6800: p_search_list(I).EMAIL_ADDRESS
6801: ,null,'EMAIL_ADDRESS'
6802: ,'CONTACT_POINTS');
6803: ELSE

Line 6812: HZ_TRANS_PKG.RM_SPLCHAR_CTX(

6808: FOR I IN 1..p_search_list.COUNT LOOP
6809: IF p_search_ctx THEN
6810: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
6811: x_stage_list(I).TX1 :=
6812: HZ_TRANS_PKG.RM_SPLCHAR_CTX(
6813: p_search_list(I).FLEX_FORMAT_PHONE_NUMBER
6814: ,null,'FLEX_FORMAT_PHONE_NUMBER'
6815: ,'CONTACT_POINTS','SEARCH');
6816: ELSE

Line 6821: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(

6817: x_stage_list(I).TX1 := '';
6818: END IF;
6819: ELSE
6820: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
6821: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(
6822: x_stage_list(I).TX1
6823: ,null,'FLEX_FORMAT_PHONE_NUMBER'
6824: ,'CONTACT_POINTS','SCORE');
6825: IF tmp IS NOT NULL THEN