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

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

Line 6239: HZ_TRANS_PKG.WRNAMES_CLEANSE(

6235: END IF;
6236: IF p_search_ctx THEN
6237: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6238: x_stage_rec.TX40 :=
6239: HZ_TRANS_PKG.WRNAMES_CLEANSE(
6240: p_search_rec.PARTY_ALL_NAMES
6241: ,null,'PARTY_ALL_NAMES'
6242: ,'PARTY','SDIB');
6243: ELSE

Line 6248: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

6244: x_stage_rec.TX40 := '';
6245: END IF;
6246: ELSE
6247: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6248: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
6249: x_stage_rec.TX40
6250: ,null,'PARTY_ALL_NAMES'
6251: ,'PARTY','SCORE');
6252: IF tmp IS NOT NULL THEN

Line 6260: HZ_TRANS_PKG.WRNAMES_EXACT(

6256: END IF;
6257: IF p_search_ctx THEN
6258: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6259: x_stage_rec.TX39 :=
6260: HZ_TRANS_PKG.WRNAMES_EXACT(
6261: p_search_rec.PARTY_ALL_NAMES
6262: ,null,'PARTY_ALL_NAMES'
6263: ,'PARTY','SDIB');
6264: ELSE

Line 6269: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

6265: x_stage_rec.TX39 := '';
6266: END IF;
6267: ELSE
6268: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6269: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
6270: x_stage_rec.TX39
6271: ,null,'PARTY_ALL_NAMES'
6272: ,'PARTY','SCORE');
6273: IF tmp IS NOT NULL THEN

Line 6281: HZ_TRANS_PKG.EXACT(

6277: END IF;
6278: IF p_search_ctx THEN
6279: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
6280: x_stage_rec.TX36 :=
6281: HZ_TRANS_PKG.EXACT(
6282: p_search_rec.PARTY_TYPE
6283: ,null,'PARTY_TYPE'
6284: ,'PARTY');
6285: ELSE

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

6290: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6291: l_party_name := p_search_rec.PARTY_ALL_NAMES;
6292: END IF;
6293: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
6294: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SDIB');
6295: END IF;
6296: EXCEPTION
6297: WHEN OTHERS THEN
6298: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 6364: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6360: FOR I IN 1..p_search_list.COUNT LOOP
6361: IF p_search_ctx THEN
6362: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6363: x_stage_list(I).TX4 :=
6364: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6365: p_search_list(I).ADDRESS
6366: ,null,'ADDRESS'
6367: ,'PARTY_SITES','SDIB');
6368: ELSE

Line 6373: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6369: x_stage_list(I).TX4 := '';
6370: END IF;
6371: ELSE
6372: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6373: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6374: x_stage_list(I).TX4
6375: ,null,'ADDRESS'
6376: ,'PARTY_SITES','SCORE');
6377: IF tmp IS NOT NULL THEN

Line 6387: HZ_TRANS_PKG.WRADDRESS_EXACT(

6383: FOR I IN 1..p_search_list.COUNT LOOP
6384: IF p_search_ctx THEN
6385: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6386: x_stage_list(I).TX3 :=
6387: HZ_TRANS_PKG.WRADDRESS_EXACT(
6388: p_search_list(I).ADDRESS
6389: ,null,'ADDRESS'
6390: ,'PARTY_SITES','SDIB');
6391: ELSE

Line 6396: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

6392: x_stage_list(I).TX3 := '';
6393: END IF;
6394: ELSE
6395: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6396: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(
6397: x_stage_list(I).TX3
6398: ,null,'ADDRESS'
6399: ,'PARTY_SITES','SCORE');
6400: IF tmp IS NOT NULL THEN

Line 6410: HZ_TRANS_PKG.CLEANSE(

6406: FOR I IN 1..p_search_list.COUNT LOOP
6407: IF p_search_ctx THEN
6408: IF p_search_list(I).CITY IS NOT NULL THEN
6409: x_stage_list(I).TX10 :=
6410: HZ_TRANS_PKG.CLEANSE(
6411: p_search_list(I).CITY
6412: ,null,'CITY'
6413: ,'PARTY_SITES');
6414: ELSE

Line 6423: HZ_TRANS_PKG.EXACT(

6419: FOR I IN 1..p_search_list.COUNT LOOP
6420: IF p_search_ctx THEN
6421: IF p_search_list(I).CITY IS NOT NULL THEN
6422: x_stage_list(I).TX9 :=
6423: HZ_TRANS_PKG.EXACT(
6424: p_search_list(I).CITY
6425: ,null,'CITY'
6426: ,'PARTY_SITES');
6427: ELSE

Line 6436: HZ_TRANS_PKG.EXACT(

6432: FOR I IN 1..p_search_list.COUNT LOOP
6433: IF p_search_ctx THEN
6434: IF p_search_list(I).COUNTRY IS NOT NULL THEN
6435: x_stage_list(I).TX22 :=
6436: HZ_TRANS_PKG.EXACT(
6437: p_search_list(I).COUNTRY
6438: ,null,'COUNTRY'
6439: ,'PARTY_SITES');
6440: ELSE

Line 6449: HZ_TRANS_PKG.CLEANSE(

6445: FOR I IN 1..p_search_list.COUNT LOOP
6446: IF p_search_ctx THEN
6447: IF p_search_list(I).COUNTY IS NOT NULL THEN
6448: x_stage_list(I).TX21 :=
6449: HZ_TRANS_PKG.CLEANSE(
6450: p_search_list(I).COUNTY
6451: ,null,'COUNTY'
6452: ,'PARTY_SITES');
6453: ELSE

Line 6462: HZ_TRANS_PKG.EXACT(

6458: FOR I IN 1..p_search_list.COUNT LOOP
6459: IF p_search_ctx THEN
6460: IF p_search_list(I).COUNTY IS NOT NULL THEN
6461: x_stage_list(I).TX20 :=
6462: HZ_TRANS_PKG.EXACT(
6463: p_search_list(I).COUNTY
6464: ,null,'COUNTY'
6465: ,'PARTY_SITES');
6466: ELSE

Line 6475: HZ_TRANS_PKG.RM_SPLCHAR(

6471: FOR I IN 1..p_search_list.COUNT LOOP
6472: IF p_search_ctx THEN
6473: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6474: x_stage_list(I).TX11 :=
6475: HZ_TRANS_PKG.RM_SPLCHAR(
6476: p_search_list(I).POSTAL_CODE
6477: ,null,'POSTAL_CODE'
6478: ,'PARTY_SITES','SDIB');
6479: ELSE

Line 6484: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

6480: x_stage_list(I).TX11 := '';
6481: END IF;
6482: ELSE
6483: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6484: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
6485: x_stage_list(I).TX11
6486: ,null,'POSTAL_CODE'
6487: ,'PARTY_SITES','SCORE');
6488: IF tmp IS NOT NULL THEN

Line 6498: HZ_TRANS_PKG.CLEANSE(

6494: FOR I IN 1..p_search_list.COUNT LOOP
6495: IF p_search_ctx THEN
6496: IF p_search_list(I).PROVINCE IS NOT NULL THEN
6497: x_stage_list(I).TX13 :=
6498: HZ_TRANS_PKG.CLEANSE(
6499: p_search_list(I).PROVINCE
6500: ,null,'PROVINCE'
6501: ,'PARTY_SITES');
6502: ELSE

Line 6511: HZ_TRANS_PKG.EXACT(

6507: FOR I IN 1..p_search_list.COUNT LOOP
6508: IF p_search_ctx THEN
6509: IF p_search_list(I).PROVINCE IS NOT NULL THEN
6510: x_stage_list(I).TX12 :=
6511: HZ_TRANS_PKG.EXACT(
6512: p_search_list(I).PROVINCE
6513: ,null,'PROVINCE'
6514: ,'PARTY_SITES');
6515: ELSE

Line 6524: HZ_TRANS_PKG.WRSTATE_CLEANSE(

6520: FOR I IN 1..p_search_list.COUNT LOOP
6521: IF p_search_ctx THEN
6522: IF p_search_list(I).STATE IS NOT NULL THEN
6523: x_stage_list(I).TX15 :=
6524: HZ_TRANS_PKG.WRSTATE_CLEANSE(
6525: p_search_list(I).STATE
6526: ,null,'STATE'
6527: ,'PARTY_SITES','SDIB');
6528: ELSE

Line 6533: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(

6529: x_stage_list(I).TX15 := '';
6530: END IF;
6531: ELSE
6532: IF p_search_list(I).STATE IS NOT NULL THEN
6533: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(
6534: x_stage_list(I).TX15
6535: ,null,'STATE'
6536: ,'PARTY_SITES','SCORE');
6537: IF tmp IS NOT NULL THEN

Line 6547: HZ_TRANS_PKG.WRSTATE_EXACT(

6543: FOR I IN 1..p_search_list.COUNT LOOP
6544: IF p_search_ctx THEN
6545: IF p_search_list(I).STATE IS NOT NULL THEN
6546: x_stage_list(I).TX14 :=
6547: HZ_TRANS_PKG.WRSTATE_EXACT(
6548: p_search_list(I).STATE
6549: ,null,'STATE'
6550: ,'PARTY_SITES','SDIB');
6551: ELSE

Line 6556: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(

6552: x_stage_list(I).TX14 := '';
6553: END IF;
6554: ELSE
6555: IF p_search_list(I).STATE IS NOT NULL THEN
6556: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(
6557: x_stage_list(I).TX14
6558: ,null,'STATE'
6559: ,'PARTY_SITES','SCORE');
6560: IF tmp IS NOT NULL THEN

Line 6614: HZ_TRANS_PKG.EXACT(

6610: FOR I IN 1..p_search_list.COUNT LOOP
6611: IF p_search_ctx THEN
6612: IF p_search_list(I).JOB_TITLE IS NOT NULL THEN
6613: x_stage_list(I).TX22 :=
6614: HZ_TRANS_PKG.EXACT(
6615: p_search_list(I).JOB_TITLE
6616: ,null,'JOB_TITLE'
6617: ,'CONTACTS');
6618: ELSE

Line 6675: HZ_TRANS_PKG.CLEANSED_EMAIL(

6671: FOR I IN 1..p_search_list.COUNT LOOP
6672: IF p_search_ctx THEN
6673: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
6674: x_stage_list(I).TX6 :=
6675: HZ_TRANS_PKG.CLEANSED_EMAIL(
6676: p_search_list(I).EMAIL_ADDRESS
6677: ,null,'EMAIL_ADDRESS'
6678: ,'CONTACT_POINTS','SDIB');
6679: ELSE

Line 6684: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(

6680: x_stage_list(I).TX6 := '';
6681: END IF;
6682: ELSE
6683: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
6684: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(
6685: x_stage_list(I).TX6
6686: ,null,'EMAIL_ADDRESS'
6687: ,'CONTACT_POINTS','SCORE');
6688: IF tmp IS NOT NULL THEN

Line 6698: HZ_TRANS_PKG.EXACT_EMAIL(

6694: FOR I IN 1..p_search_list.COUNT LOOP
6695: IF p_search_ctx THEN
6696: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
6697: x_stage_list(I).TX5 :=
6698: HZ_TRANS_PKG.EXACT_EMAIL(
6699: p_search_list(I).EMAIL_ADDRESS
6700: ,null,'EMAIL_ADDRESS'
6701: ,'CONTACT_POINTS');
6702: ELSE

Line 6711: HZ_TRANS_PKG.RM_SPLCHAR_CTX(

6707: FOR I IN 1..p_search_list.COUNT LOOP
6708: IF p_search_ctx THEN
6709: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
6710: x_stage_list(I).TX1 :=
6711: HZ_TRANS_PKG.RM_SPLCHAR_CTX(
6712: p_search_list(I).FLEX_FORMAT_PHONE_NUMBER
6713: ,null,'FLEX_FORMAT_PHONE_NUMBER'
6714: ,'CONTACT_POINTS','SDIB');
6715: ELSE

Line 6720: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(

6716: x_stage_list(I).TX1 := '';
6717: END IF;
6718: ELSE
6719: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
6720: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(
6721: x_stage_list(I).TX1
6722: ,null,'FLEX_FORMAT_PHONE_NUMBER'
6723: ,'CONTACT_POINTS','SCORE');
6724: IF tmp IS NOT NULL THEN