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

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

Line 6050: HZ_TRANS_PKG.EXACT(

6046: END IF;
6047: IF p_search_ctx THEN
6048: IF p_search_rec.DUNS_NUMBER_C IS NOT NULL THEN
6049: x_stage_rec.TX41 :=
6050: HZ_TRANS_PKG.EXACT(
6051: p_search_rec.DUNS_NUMBER_C
6052: ,null,'DUNS_NUMBER_C'
6053: ,'PARTY');
6054: ELSE

Line 6065: HZ_TRANS_PKG.EXACT_PADDED(

6061: END IF;
6062: IF p_search_ctx THEN
6063: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
6064: x_stage_rec.TX2 :=
6065: HZ_TRANS_PKG.EXACT_PADDED(
6066: p_search_rec.PARTY_NAME
6067: ,null,'PARTY_NAME'
6068: ,'PARTY');
6069: ELSE

Line 6076: HZ_TRANS_PKG.WRNAMES_CLEANSE(

6072: END IF;
6073: IF p_search_ctx THEN
6074: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
6075: x_stage_rec.TX4 :=
6076: HZ_TRANS_PKG.WRNAMES_CLEANSE(
6077: p_search_rec.PARTY_NAME
6078: ,null,'PARTY_NAME'
6079: ,'PARTY','SDIB');
6080: ELSE

Line 6085: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

6081: x_stage_rec.TX4 := '';
6082: END IF;
6083: ELSE
6084: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
6085: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
6086: x_stage_rec.TX4
6087: ,null,'PARTY_NAME'
6088: ,'PARTY','SCORE');
6089: IF tmp IS NOT NULL THEN

Line 6097: HZ_TRANS_PKG.WRNAMES_EXACT(

6093: END IF;
6094: IF p_search_ctx THEN
6095: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
6096: x_stage_rec.TX8 :=
6097: HZ_TRANS_PKG.WRNAMES_EXACT(
6098: p_search_rec.PARTY_NAME
6099: ,null,'PARTY_NAME'
6100: ,'PARTY','SDIB');
6101: ELSE

Line 6106: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

6102: x_stage_rec.TX8 := '';
6103: END IF;
6104: ELSE
6105: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
6106: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
6107: x_stage_rec.TX8
6108: ,null,'PARTY_NAME'
6109: ,'PARTY','SCORE');
6110: IF tmp IS NOT NULL THEN

Line 6118: HZ_TRANS_PKG.EXACT(

6114: END IF;
6115: IF p_search_ctx THEN
6116: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
6117: x_stage_rec.TX36 :=
6118: HZ_TRANS_PKG.EXACT(
6119: p_search_rec.PARTY_TYPE
6120: ,null,'PARTY_TYPE'
6121: ,'PARTY');
6122: ELSE

Line 6129: HZ_TRANS_PKG.EXACT(

6125: END IF;
6126: IF p_search_ctx THEN
6127: IF p_search_rec.SIC_CODE IS NOT NULL THEN
6128: x_stage_rec.TX46 :=
6129: HZ_TRANS_PKG.EXACT(
6130: p_search_rec.SIC_CODE
6131: ,null,'SIC_CODE'
6132: ,'PARTY');
6133: ELSE

Line 6140: HZ_TRANS_PKG.RM_SPLCHAR(

6136: END IF;
6137: IF p_search_ctx THEN
6138: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
6139: x_stage_rec.TX44 :=
6140: HZ_TRANS_PKG.RM_SPLCHAR(
6141: p_search_rec.TAX_REFERENCE
6142: ,null,'TAX_REFERENCE'
6143: ,'PARTY','SDIB');
6144: ELSE

Line 6149: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6145: x_stage_rec.TX44 := '';
6146: END IF;
6147: ELSE
6148: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
6149: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6150: x_stage_rec.TX44
6151: ,null,'TAX_REFERENCE'
6152: ,'PARTY','SCORE');
6153: IF tmp IS NOT NULL THEN

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

6159: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6160: l_party_name := p_search_rec.PARTY_ALL_NAMES;
6161: END IF;
6162: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
6163: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SDIB');
6164: END IF;
6165: EXCEPTION
6166: WHEN OTHERS THEN
6167: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 6218: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6214: FOR I IN 1..p_search_list.COUNT LOOP
6215: IF p_search_ctx THEN
6216: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6217: x_stage_list(I).TX4 :=
6218: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6219: p_search_list(I).ADDRESS
6220: ,null,'ADDRESS'
6221: ,'PARTY_SITES','SDIB');
6222: ELSE

Line 6227: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6223: x_stage_list(I).TX4 := '';
6224: END IF;
6225: ELSE
6226: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6227: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6228: x_stage_list(I).TX4
6229: ,null,'ADDRESS'
6230: ,'PARTY_SITES','SCORE');
6231: IF tmp IS NOT NULL THEN

Line 6241: HZ_TRANS_PKG.WRADDRESS_EXACT(

6237: FOR I IN 1..p_search_list.COUNT LOOP
6238: IF p_search_ctx THEN
6239: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6240: x_stage_list(I).TX3 :=
6241: HZ_TRANS_PKG.WRADDRESS_EXACT(
6242: p_search_list(I).ADDRESS
6243: ,null,'ADDRESS'
6244: ,'PARTY_SITES','SDIB');
6245: ELSE

Line 6250: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

6246: x_stage_list(I).TX3 := '';
6247: END IF;
6248: ELSE
6249: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6250: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(
6251: x_stage_list(I).TX3
6252: ,null,'ADDRESS'
6253: ,'PARTY_SITES','SCORE');
6254: IF tmp IS NOT NULL THEN

Line 6264: HZ_TRANS_PKG.RM_SPLCHAR(

6260: FOR I IN 1..p_search_list.COUNT LOOP
6261: IF p_search_ctx THEN
6262: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6263: x_stage_list(I).TX11 :=
6264: HZ_TRANS_PKG.RM_SPLCHAR(
6265: p_search_list(I).POSTAL_CODE
6266: ,null,'POSTAL_CODE'
6267: ,'PARTY_SITES','SDIB');
6268: ELSE

Line 6273: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

6269: x_stage_list(I).TX11 := '';
6270: END IF;
6271: ELSE
6272: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6273: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
6274: x_stage_list(I).TX11
6275: ,null,'POSTAL_CODE'
6276: ,'PARTY_SITES','SCORE');
6277: IF tmp IS NOT NULL THEN

Line 6331: HZ_TRANS_PKG.EXACT_PADDED(

6327: FOR I IN 1..p_search_list.COUNT LOOP
6328: IF p_search_ctx THEN
6329: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
6330: x_stage_list(I).TX2 :=
6331: HZ_TRANS_PKG.EXACT_PADDED(
6332: p_search_list(I).CONTACT_NAME
6333: ,null,'CONTACT_NAME'
6334: ,'CONTACTS');
6335: ELSE

Line 6344: HZ_TRANS_PKG.WRPERSON_CLEANSE(

6340: FOR I IN 1..p_search_list.COUNT LOOP
6341: IF p_search_ctx THEN
6342: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
6343: x_stage_list(I).TX6 :=
6344: HZ_TRANS_PKG.WRPERSON_CLEANSE(
6345: p_search_list(I).CONTACT_NAME
6346: ,null,'CONTACT_NAME'
6347: ,'CONTACTS','SDIB');
6348: ELSE

Line 6353: tmp := HZ_TRANS_PKG.WRPERSON_CLEANSE(

6349: x_stage_list(I).TX6 := '';
6350: END IF;
6351: ELSE
6352: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
6353: tmp := HZ_TRANS_PKG.WRPERSON_CLEANSE(
6354: x_stage_list(I).TX6
6355: ,null,'CONTACT_NAME'
6356: ,'CONTACTS','SCORE');
6357: IF tmp IS NOT NULL THEN

Line 6367: HZ_TRANS_PKG.WRPERSON_EXACT(

6363: FOR I IN 1..p_search_list.COUNT LOOP
6364: IF p_search_ctx THEN
6365: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
6366: x_stage_list(I).TX5 :=
6367: HZ_TRANS_PKG.WRPERSON_EXACT(
6368: p_search_list(I).CONTACT_NAME
6369: ,null,'CONTACT_NAME'
6370: ,'CONTACTS','SDIB');
6371: ELSE

Line 6376: tmp := HZ_TRANS_PKG.WRPERSON_EXACT(

6372: x_stage_list(I).TX5 := '';
6373: END IF;
6374: ELSE
6375: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
6376: tmp := HZ_TRANS_PKG.WRPERSON_EXACT(
6377: x_stage_list(I).TX5
6378: ,null,'CONTACT_NAME'
6379: ,'CONTACTS','SCORE');
6380: IF tmp IS NOT NULL THEN

Line 6435: HZ_TRANS_PKG.RM_SPLCHAR_CTX(

6431: FOR I IN 1..p_search_list.COUNT LOOP
6432: IF p_search_ctx THEN
6433: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
6434: x_stage_list(I).TX1 :=
6435: HZ_TRANS_PKG.RM_SPLCHAR_CTX(
6436: p_search_list(I).FLEX_FORMAT_PHONE_NUMBER
6437: ,null,'FLEX_FORMAT_PHONE_NUMBER'
6438: ,'CONTACT_POINTS','SDIB');
6439: ELSE

Line 6444: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(

6440: x_stage_list(I).TX1 := '';
6441: END IF;
6442: ELSE
6443: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
6444: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(
6445: x_stage_list(I).TX1
6446: ,null,'FLEX_FORMAT_PHONE_NUMBER'
6447: ,'CONTACT_POINTS','SCORE');
6448: IF tmp IS NOT NULL THEN