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

Line 1033: HZ_TRANS_PKG.clear_globals;

1029: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1030: 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);
1031: END IF;
1032: -- Transform search criteria
1033: HZ_TRANS_PKG.clear_globals;
1034: MAP_PARTY_REC(FALSE,p_party_search_rec, l_dummy, g_party_stage_rec);
1035: MAP_PARTY_SITE_REC(FALSE,p_party_site_list, l_dummy, g_party_site_stage_list);
1036: MAP_CONTACT_REC(FALSE,p_contact_list, l_dummy, g_contact_stage_list);
1037: MAP_CONTACT_POINT_REC(FALSE,p_contact_point_list, l_dummy, g_contact_pt_stage_list);

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

1086: g_contact_pt_stage_list.DELETE;
1087: call_order.DELETE;
1088: call_max_score.DELETE;
1089: HZ_DQM_SEARCH_UTIL.new_search;
1090: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
1091: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1092:
1093: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1094: 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 3479: HZ_TRANS_PKG.EXACT(

3475: /********************* Find Parties private procedures *******/
3476: PROCEDURE set_person_party_type IS
3477: BEGIN
3478: g_party_stage_rec.TX36:=
3479: HZ_TRANS_PKG.EXACT(
3480: 'PERSON'
3481: ,null,'PARTY_TYPE'
3482: ,'PARTY');
3483: END;

Line 6234: HZ_TRANS_PKG.WRNAMES_CLEANSE(

6230: END IF;
6231: IF p_search_ctx THEN
6232: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6233: x_stage_rec.TX40 :=
6234: HZ_TRANS_PKG.WRNAMES_CLEANSE(
6235: p_search_rec.PARTY_ALL_NAMES
6236: ,null,'PARTY_ALL_NAMES'
6237: ,'PARTY','SDIB');
6238: ELSE

Line 6243: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

6239: x_stage_rec.TX40 := '';
6240: END IF;
6241: ELSE
6242: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6243: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
6244: x_stage_rec.TX40
6245: ,null,'PARTY_ALL_NAMES'
6246: ,'PARTY','SCORE');
6247: IF tmp IS NOT NULL THEN

Line 6255: HZ_TRANS_PKG.WRNAMES_EXACT(

6251: END IF;
6252: IF p_search_ctx THEN
6253: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6254: x_stage_rec.TX39 :=
6255: HZ_TRANS_PKG.WRNAMES_EXACT(
6256: p_search_rec.PARTY_ALL_NAMES
6257: ,null,'PARTY_ALL_NAMES'
6258: ,'PARTY','SDIB');
6259: ELSE

Line 6264: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

6260: x_stage_rec.TX39 := '';
6261: END IF;
6262: ELSE
6263: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6264: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
6265: x_stage_rec.TX39
6266: ,null,'PARTY_ALL_NAMES'
6267: ,'PARTY','SCORE');
6268: IF tmp IS NOT NULL THEN

Line 6276: HZ_TRANS_PKG.EXACT(

6272: END IF;
6273: IF p_search_ctx THEN
6274: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
6275: x_stage_rec.TX36 :=
6276: HZ_TRANS_PKG.EXACT(
6277: p_search_rec.PARTY_TYPE
6278: ,null,'PARTY_TYPE'
6279: ,'PARTY');
6280: ELSE

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

6285: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6286: l_party_name := p_search_rec.PARTY_ALL_NAMES;
6287: END IF;
6288: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
6289: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SDIB');
6290: END IF;
6291: EXCEPTION
6292: WHEN OTHERS THEN
6293: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 6359: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6355: FOR I IN 1..p_search_list.COUNT LOOP
6356: IF p_search_ctx THEN
6357: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6358: x_stage_list(I).TX4 :=
6359: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6360: p_search_list(I).ADDRESS
6361: ,null,'ADDRESS'
6362: ,'PARTY_SITES','SDIB');
6363: ELSE

Line 6368: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6364: x_stage_list(I).TX4 := '';
6365: END IF;
6366: ELSE
6367: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6368: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6369: x_stage_list(I).TX4
6370: ,null,'ADDRESS'
6371: ,'PARTY_SITES','SCORE');
6372: IF tmp IS NOT NULL THEN

Line 6382: HZ_TRANS_PKG.WRADDRESS_EXACT(

6378: FOR I IN 1..p_search_list.COUNT LOOP
6379: IF p_search_ctx THEN
6380: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6381: x_stage_list(I).TX3 :=
6382: HZ_TRANS_PKG.WRADDRESS_EXACT(
6383: p_search_list(I).ADDRESS
6384: ,null,'ADDRESS'
6385: ,'PARTY_SITES','SDIB');
6386: ELSE

Line 6391: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

6387: x_stage_list(I).TX3 := '';
6388: END IF;
6389: ELSE
6390: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6391: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(
6392: x_stage_list(I).TX3
6393: ,null,'ADDRESS'
6394: ,'PARTY_SITES','SCORE');
6395: IF tmp IS NOT NULL THEN

Line 6405: HZ_TRANS_PKG.CLEANSE(

6401: FOR I IN 1..p_search_list.COUNT LOOP
6402: IF p_search_ctx THEN
6403: IF p_search_list(I).CITY IS NOT NULL THEN
6404: x_stage_list(I).TX10 :=
6405: HZ_TRANS_PKG.CLEANSE(
6406: p_search_list(I).CITY
6407: ,null,'CITY'
6408: ,'PARTY_SITES');
6409: ELSE

Line 6418: HZ_TRANS_PKG.EXACT(

6414: FOR I IN 1..p_search_list.COUNT LOOP
6415: IF p_search_ctx THEN
6416: IF p_search_list(I).CITY IS NOT NULL THEN
6417: x_stage_list(I).TX9 :=
6418: HZ_TRANS_PKG.EXACT(
6419: p_search_list(I).CITY
6420: ,null,'CITY'
6421: ,'PARTY_SITES');
6422: ELSE

Line 6431: HZ_TRANS_PKG.EXACT(

6427: FOR I IN 1..p_search_list.COUNT LOOP
6428: IF p_search_ctx THEN
6429: IF p_search_list(I).COUNTRY IS NOT NULL THEN
6430: x_stage_list(I).TX22 :=
6431: HZ_TRANS_PKG.EXACT(
6432: p_search_list(I).COUNTRY
6433: ,null,'COUNTRY'
6434: ,'PARTY_SITES');
6435: ELSE

Line 6444: HZ_TRANS_PKG.CLEANSE(

6440: FOR I IN 1..p_search_list.COUNT LOOP
6441: IF p_search_ctx THEN
6442: IF p_search_list(I).COUNTY IS NOT NULL THEN
6443: x_stage_list(I).TX21 :=
6444: HZ_TRANS_PKG.CLEANSE(
6445: p_search_list(I).COUNTY
6446: ,null,'COUNTY'
6447: ,'PARTY_SITES');
6448: ELSE

Line 6457: HZ_TRANS_PKG.EXACT(

6453: FOR I IN 1..p_search_list.COUNT LOOP
6454: IF p_search_ctx THEN
6455: IF p_search_list(I).COUNTY IS NOT NULL THEN
6456: x_stage_list(I).TX20 :=
6457: HZ_TRANS_PKG.EXACT(
6458: p_search_list(I).COUNTY
6459: ,null,'COUNTY'
6460: ,'PARTY_SITES');
6461: ELSE

Line 6470: HZ_TRANS_PKG.RM_SPLCHAR(

6466: FOR I IN 1..p_search_list.COUNT LOOP
6467: IF p_search_ctx THEN
6468: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6469: x_stage_list(I).TX11 :=
6470: HZ_TRANS_PKG.RM_SPLCHAR(
6471: p_search_list(I).POSTAL_CODE
6472: ,null,'POSTAL_CODE'
6473: ,'PARTY_SITES','SDIB');
6474: ELSE

Line 6479: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

6475: x_stage_list(I).TX11 := '';
6476: END IF;
6477: ELSE
6478: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6479: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
6480: x_stage_list(I).TX11
6481: ,null,'POSTAL_CODE'
6482: ,'PARTY_SITES','SCORE');
6483: IF tmp IS NOT NULL THEN

Line 6493: HZ_TRANS_PKG.CLEANSE(

6489: FOR I IN 1..p_search_list.COUNT LOOP
6490: IF p_search_ctx THEN
6491: IF p_search_list(I).PROVINCE IS NOT NULL THEN
6492: x_stage_list(I).TX13 :=
6493: HZ_TRANS_PKG.CLEANSE(
6494: p_search_list(I).PROVINCE
6495: ,null,'PROVINCE'
6496: ,'PARTY_SITES');
6497: ELSE

Line 6506: HZ_TRANS_PKG.EXACT(

6502: FOR I IN 1..p_search_list.COUNT LOOP
6503: IF p_search_ctx THEN
6504: IF p_search_list(I).PROVINCE IS NOT NULL THEN
6505: x_stage_list(I).TX12 :=
6506: HZ_TRANS_PKG.EXACT(
6507: p_search_list(I).PROVINCE
6508: ,null,'PROVINCE'
6509: ,'PARTY_SITES');
6510: ELSE

Line 6519: HZ_TRANS_PKG.WRSTATE_CLEANSE(

6515: FOR I IN 1..p_search_list.COUNT LOOP
6516: IF p_search_ctx THEN
6517: IF p_search_list(I).STATE IS NOT NULL THEN
6518: x_stage_list(I).TX15 :=
6519: HZ_TRANS_PKG.WRSTATE_CLEANSE(
6520: p_search_list(I).STATE
6521: ,null,'STATE'
6522: ,'PARTY_SITES','SDIB');
6523: ELSE

Line 6528: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(

6524: x_stage_list(I).TX15 := '';
6525: END IF;
6526: ELSE
6527: IF p_search_list(I).STATE IS NOT NULL THEN
6528: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(
6529: x_stage_list(I).TX15
6530: ,null,'STATE'
6531: ,'PARTY_SITES','SCORE');
6532: IF tmp IS NOT NULL THEN

Line 6542: HZ_TRANS_PKG.WRSTATE_EXACT(

6538: FOR I IN 1..p_search_list.COUNT LOOP
6539: IF p_search_ctx THEN
6540: IF p_search_list(I).STATE IS NOT NULL THEN
6541: x_stage_list(I).TX14 :=
6542: HZ_TRANS_PKG.WRSTATE_EXACT(
6543: p_search_list(I).STATE
6544: ,null,'STATE'
6545: ,'PARTY_SITES','SDIB');
6546: ELSE

Line 6551: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(

6547: x_stage_list(I).TX14 := '';
6548: END IF;
6549: ELSE
6550: IF p_search_list(I).STATE IS NOT NULL THEN
6551: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(
6552: x_stage_list(I).TX14
6553: ,null,'STATE'
6554: ,'PARTY_SITES','SCORE');
6555: IF tmp IS NOT NULL THEN

Line 6609: HZ_TRANS_PKG.EXACT(

6605: FOR I IN 1..p_search_list.COUNT LOOP
6606: IF p_search_ctx THEN
6607: IF p_search_list(I).JOB_TITLE IS NOT NULL THEN
6608: x_stage_list(I).TX22 :=
6609: HZ_TRANS_PKG.EXACT(
6610: p_search_list(I).JOB_TITLE
6611: ,null,'JOB_TITLE'
6612: ,'CONTACTS');
6613: ELSE

Line 6670: HZ_TRANS_PKG.CLEANSED_EMAIL(

6666: FOR I IN 1..p_search_list.COUNT LOOP
6667: IF p_search_ctx THEN
6668: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
6669: x_stage_list(I).TX6 :=
6670: HZ_TRANS_PKG.CLEANSED_EMAIL(
6671: p_search_list(I).EMAIL_ADDRESS
6672: ,null,'EMAIL_ADDRESS'
6673: ,'CONTACT_POINTS','SDIB');
6674: ELSE

Line 6679: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(

6675: x_stage_list(I).TX6 := '';
6676: END IF;
6677: ELSE
6678: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
6679: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(
6680: x_stage_list(I).TX6
6681: ,null,'EMAIL_ADDRESS'
6682: ,'CONTACT_POINTS','SCORE');
6683: IF tmp IS NOT NULL THEN

Line 6693: HZ_TRANS_PKG.EXACT_EMAIL(

6689: FOR I IN 1..p_search_list.COUNT LOOP
6690: IF p_search_ctx THEN
6691: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
6692: x_stage_list(I).TX5 :=
6693: HZ_TRANS_PKG.EXACT_EMAIL(
6694: p_search_list(I).EMAIL_ADDRESS
6695: ,null,'EMAIL_ADDRESS'
6696: ,'CONTACT_POINTS');
6697: ELSE

Line 6706: HZ_TRANS_PKG.RM_SPLCHAR_CTX(

6702: FOR I IN 1..p_search_list.COUNT LOOP
6703: IF p_search_ctx THEN
6704: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
6705: x_stage_list(I).TX1 :=
6706: HZ_TRANS_PKG.RM_SPLCHAR_CTX(
6707: p_search_list(I).FLEX_FORMAT_PHONE_NUMBER
6708: ,null,'FLEX_FORMAT_PHONE_NUMBER'
6709: ,'CONTACT_POINTS','SDIB');
6710: ELSE

Line 6715: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(

6711: x_stage_list(I).TX1 := '';
6712: END IF;
6713: ELSE
6714: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
6715: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(
6716: x_stage_list(I).TX1
6717: ,null,'FLEX_FORMAT_PHONE_NUMBER'
6718: ,'CONTACT_POINTS','SCORE');
6719: IF tmp IS NOT NULL THEN