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

Line 884: HZ_TRANS_PKG.clear_globals;

880: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
881: 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);
882: END IF;
883: -- Transform search criteria
884: HZ_TRANS_PKG.clear_globals;
885: MAP_PARTY_REC(FALSE,p_party_search_rec, l_dummy, g_party_stage_rec);
886: MAP_PARTY_SITE_REC(FALSE,p_party_site_list, l_dummy, g_party_site_stage_list);
887: MAP_CONTACT_REC(FALSE,p_contact_list, l_dummy, g_contact_stage_list);
888: MAP_CONTACT_POINT_REC(FALSE,p_contact_point_list, l_dummy, g_contact_pt_stage_list);

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

937: g_contact_pt_stage_list.DELETE;
938: call_order.DELETE;
939: call_max_score.DELETE;
940: HZ_DQM_SEARCH_UTIL.new_search;
941: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
942: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
943:
944: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
945: 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 3348: HZ_TRANS_PKG.EXACT(

3344: /********************* Find Parties private procedures *******/
3345: PROCEDURE set_person_party_type IS
3346: BEGIN
3347: g_party_stage_rec.TX36:=
3348: HZ_TRANS_PKG.EXACT(
3349: 'PERSON'
3350: ,null,'PARTY_TYPE'
3351: ,'PARTY');
3352: END;

Line 6055: HZ_TRANS_PKG.EXACT(

6051: END IF;
6052: IF p_search_ctx THEN
6053: IF p_search_rec.DUNS_NUMBER_C IS NOT NULL THEN
6054: x_stage_rec.TX41 :=
6055: HZ_TRANS_PKG.EXACT(
6056: p_search_rec.DUNS_NUMBER_C
6057: ,null,'DUNS_NUMBER_C'
6058: ,'PARTY');
6059: ELSE

Line 6070: HZ_TRANS_PKG.EXACT_PADDED(

6066: END IF;
6067: IF p_search_ctx THEN
6068: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
6069: x_stage_rec.TX2 :=
6070: HZ_TRANS_PKG.EXACT_PADDED(
6071: p_search_rec.PARTY_NAME
6072: ,null,'PARTY_NAME'
6073: ,'PARTY');
6074: ELSE

Line 6081: HZ_TRANS_PKG.WRNAMES_CLEANSE(

6077: END IF;
6078: IF p_search_ctx THEN
6079: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
6080: x_stage_rec.TX4 :=
6081: HZ_TRANS_PKG.WRNAMES_CLEANSE(
6082: p_search_rec.PARTY_NAME
6083: ,null,'PARTY_NAME'
6084: ,'PARTY','SDIB');
6085: ELSE

Line 6090: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

6086: x_stage_rec.TX4 := '';
6087: END IF;
6088: ELSE
6089: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
6090: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
6091: x_stage_rec.TX4
6092: ,null,'PARTY_NAME'
6093: ,'PARTY','SCORE');
6094: IF tmp IS NOT NULL THEN

Line 6102: HZ_TRANS_PKG.WRNAMES_EXACT(

6098: END IF;
6099: IF p_search_ctx THEN
6100: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
6101: x_stage_rec.TX8 :=
6102: HZ_TRANS_PKG.WRNAMES_EXACT(
6103: p_search_rec.PARTY_NAME
6104: ,null,'PARTY_NAME'
6105: ,'PARTY','SDIB');
6106: ELSE

Line 6111: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

6107: x_stage_rec.TX8 := '';
6108: END IF;
6109: ELSE
6110: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
6111: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
6112: x_stage_rec.TX8
6113: ,null,'PARTY_NAME'
6114: ,'PARTY','SCORE');
6115: IF tmp IS NOT NULL THEN

Line 6123: HZ_TRANS_PKG.EXACT(

6119: END IF;
6120: IF p_search_ctx THEN
6121: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
6122: x_stage_rec.TX36 :=
6123: HZ_TRANS_PKG.EXACT(
6124: p_search_rec.PARTY_TYPE
6125: ,null,'PARTY_TYPE'
6126: ,'PARTY');
6127: ELSE

Line 6134: HZ_TRANS_PKG.EXACT(

6130: END IF;
6131: IF p_search_ctx THEN
6132: IF p_search_rec.SIC_CODE IS NOT NULL THEN
6133: x_stage_rec.TX46 :=
6134: HZ_TRANS_PKG.EXACT(
6135: p_search_rec.SIC_CODE
6136: ,null,'SIC_CODE'
6137: ,'PARTY');
6138: ELSE

Line 6145: HZ_TRANS_PKG.RM_SPLCHAR(

6141: END IF;
6142: IF p_search_ctx THEN
6143: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
6144: x_stage_rec.TX44 :=
6145: HZ_TRANS_PKG.RM_SPLCHAR(
6146: p_search_rec.TAX_REFERENCE
6147: ,null,'TAX_REFERENCE'
6148: ,'PARTY','SDIB');
6149: ELSE

Line 6154: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6150: x_stage_rec.TX44 := '';
6151: END IF;
6152: ELSE
6153: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
6154: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6155: x_stage_rec.TX44
6156: ,null,'TAX_REFERENCE'
6157: ,'PARTY','SCORE');
6158: IF tmp IS NOT NULL THEN

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

6164: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6165: l_party_name := p_search_rec.PARTY_ALL_NAMES;
6166: END IF;
6167: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
6168: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SDIB');
6169: END IF;
6170: EXCEPTION
6171: WHEN OTHERS THEN
6172: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 6223: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6219: FOR I IN 1..p_search_list.COUNT LOOP
6220: IF p_search_ctx THEN
6221: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6222: x_stage_list(I).TX4 :=
6223: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6224: p_search_list(I).ADDRESS
6225: ,null,'ADDRESS'
6226: ,'PARTY_SITES','SDIB');
6227: ELSE

Line 6232: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6228: x_stage_list(I).TX4 := '';
6229: END IF;
6230: ELSE
6231: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6232: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6233: x_stage_list(I).TX4
6234: ,null,'ADDRESS'
6235: ,'PARTY_SITES','SCORE');
6236: IF tmp IS NOT NULL THEN

Line 6246: HZ_TRANS_PKG.WRADDRESS_EXACT(

6242: FOR I IN 1..p_search_list.COUNT LOOP
6243: IF p_search_ctx THEN
6244: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6245: x_stage_list(I).TX3 :=
6246: HZ_TRANS_PKG.WRADDRESS_EXACT(
6247: p_search_list(I).ADDRESS
6248: ,null,'ADDRESS'
6249: ,'PARTY_SITES','SDIB');
6250: ELSE

Line 6255: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

6251: x_stage_list(I).TX3 := '';
6252: END IF;
6253: ELSE
6254: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6255: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(
6256: x_stage_list(I).TX3
6257: ,null,'ADDRESS'
6258: ,'PARTY_SITES','SCORE');
6259: IF tmp IS NOT NULL THEN

Line 6269: HZ_TRANS_PKG.RM_SPLCHAR(

6265: FOR I IN 1..p_search_list.COUNT LOOP
6266: IF p_search_ctx THEN
6267: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6268: x_stage_list(I).TX11 :=
6269: HZ_TRANS_PKG.RM_SPLCHAR(
6270: p_search_list(I).POSTAL_CODE
6271: ,null,'POSTAL_CODE'
6272: ,'PARTY_SITES','SDIB');
6273: ELSE

Line 6278: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

6274: x_stage_list(I).TX11 := '';
6275: END IF;
6276: ELSE
6277: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6278: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
6279: x_stage_list(I).TX11
6280: ,null,'POSTAL_CODE'
6281: ,'PARTY_SITES','SCORE');
6282: IF tmp IS NOT NULL THEN

Line 6336: HZ_TRANS_PKG.EXACT_PADDED(

6332: FOR I IN 1..p_search_list.COUNT LOOP
6333: IF p_search_ctx THEN
6334: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
6335: x_stage_list(I).TX2 :=
6336: HZ_TRANS_PKG.EXACT_PADDED(
6337: p_search_list(I).CONTACT_NAME
6338: ,null,'CONTACT_NAME'
6339: ,'CONTACTS');
6340: ELSE

Line 6349: HZ_TRANS_PKG.WRPERSON_CLEANSE(

6345: FOR I IN 1..p_search_list.COUNT LOOP
6346: IF p_search_ctx THEN
6347: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
6348: x_stage_list(I).TX6 :=
6349: HZ_TRANS_PKG.WRPERSON_CLEANSE(
6350: p_search_list(I).CONTACT_NAME
6351: ,null,'CONTACT_NAME'
6352: ,'CONTACTS','SDIB');
6353: ELSE

Line 6358: tmp := HZ_TRANS_PKG.WRPERSON_CLEANSE(

6354: x_stage_list(I).TX6 := '';
6355: END IF;
6356: ELSE
6357: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
6358: tmp := HZ_TRANS_PKG.WRPERSON_CLEANSE(
6359: x_stage_list(I).TX6
6360: ,null,'CONTACT_NAME'
6361: ,'CONTACTS','SCORE');
6362: IF tmp IS NOT NULL THEN

Line 6372: HZ_TRANS_PKG.WRPERSON_EXACT(

6368: FOR I IN 1..p_search_list.COUNT LOOP
6369: IF p_search_ctx THEN
6370: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
6371: x_stage_list(I).TX5 :=
6372: HZ_TRANS_PKG.WRPERSON_EXACT(
6373: p_search_list(I).CONTACT_NAME
6374: ,null,'CONTACT_NAME'
6375: ,'CONTACTS','SDIB');
6376: ELSE

Line 6381: tmp := HZ_TRANS_PKG.WRPERSON_EXACT(

6377: x_stage_list(I).TX5 := '';
6378: END IF;
6379: ELSE
6380: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
6381: tmp := HZ_TRANS_PKG.WRPERSON_EXACT(
6382: x_stage_list(I).TX5
6383: ,null,'CONTACT_NAME'
6384: ,'CONTACTS','SCORE');
6385: IF tmp IS NOT NULL THEN

Line 6440: HZ_TRANS_PKG.RM_SPLCHAR_CTX(

6436: FOR I IN 1..p_search_list.COUNT LOOP
6437: IF p_search_ctx THEN
6438: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
6439: x_stage_list(I).TX1 :=
6440: HZ_TRANS_PKG.RM_SPLCHAR_CTX(
6441: p_search_list(I).FLEX_FORMAT_PHONE_NUMBER
6442: ,null,'FLEX_FORMAT_PHONE_NUMBER'
6443: ,'CONTACT_POINTS','SDIB');
6444: ELSE

Line 6449: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(

6445: x_stage_list(I).TX1 := '';
6446: END IF;
6447: ELSE
6448: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
6449: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(
6450: x_stage_list(I).TX1
6451: ,null,'FLEX_FORMAT_PHONE_NUMBER'
6452: ,'CONTACT_POINTS','SCORE');
6453: IF tmp IS NOT NULL THEN