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

Line 825: HZ_TRANS_PKG.clear_globals;

821: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
822: 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);
823: END IF;
824: -- Transform search criteria
825: HZ_TRANS_PKG.clear_globals;
826: MAP_PARTY_REC(FALSE,p_party_search_rec, l_dummy, g_party_stage_rec);
827: MAP_PARTY_SITE_REC(FALSE,p_party_site_list, l_dummy, g_party_site_stage_list);
828: MAP_CONTACT_REC(FALSE,p_contact_list, l_dummy, g_contact_stage_list);
829: MAP_CONTACT_POINT_REC(FALSE,p_contact_point_list, l_dummy, g_contact_pt_stage_list);

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

878: g_contact_pt_stage_list.DELETE;
879: call_order.DELETE;
880: call_max_score.DELETE;
881: HZ_DQM_SEARCH_UTIL.new_search;
882: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
883: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
884:
885: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
886: 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 3248: HZ_TRANS_PKG.EXACT(

3244: /********************* Find Parties private procedures *******/
3245: PROCEDURE set_person_party_type IS
3246: BEGIN
3247: g_party_stage_rec.TX36:=
3248: HZ_TRANS_PKG.EXACT(
3249: 'PERSON'
3250: ,null,'PARTY_TYPE'
3251: ,'PARTY');
3252: END;

Line 5844: HZ_TRANS_PKG.EXACT(

5840: END IF;
5841: IF p_search_ctx THEN
5842: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
5843: x_stage_rec.TX36 :=
5844: HZ_TRANS_PKG.EXACT(
5845: p_search_rec.PARTY_TYPE
5846: ,null,'PARTY_TYPE'
5847: ,'PARTY');
5848: ELSE

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

5853: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
5854: l_party_name := p_search_rec.PARTY_ALL_NAMES;
5855: END IF;
5856: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
5857: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SDIB');
5858: END IF;
5859: EXCEPTION
5860: WHEN OTHERS THEN
5861: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 5927: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

5923: FOR I IN 1..p_search_list.COUNT LOOP
5924: IF p_search_ctx THEN
5925: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5926: x_stage_list(I).TX4 :=
5927: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
5928: p_search_list(I).ADDRESS
5929: ,null,'ADDRESS'
5930: ,'PARTY_SITES','SDIB');
5931: ELSE

Line 5936: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

5932: x_stage_list(I).TX4 := '';
5933: END IF;
5934: ELSE
5935: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5936: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
5937: x_stage_list(I).TX4
5938: ,null,'ADDRESS'
5939: ,'PARTY_SITES','SCORE');
5940: IF tmp IS NOT NULL THEN

Line 5950: HZ_TRANS_PKG.WRADDRESS_EXACT(

5946: FOR I IN 1..p_search_list.COUNT LOOP
5947: IF p_search_ctx THEN
5948: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5949: x_stage_list(I).TX3 :=
5950: HZ_TRANS_PKG.WRADDRESS_EXACT(
5951: p_search_list(I).ADDRESS
5952: ,null,'ADDRESS'
5953: ,'PARTY_SITES','SDIB');
5954: ELSE

Line 5959: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

5955: x_stage_list(I).TX3 := '';
5956: END IF;
5957: ELSE
5958: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5959: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(
5960: x_stage_list(I).TX3
5961: ,null,'ADDRESS'
5962: ,'PARTY_SITES','SCORE');
5963: IF tmp IS NOT NULL THEN

Line 5973: HZ_TRANS_PKG.CLEANSE(

5969: FOR I IN 1..p_search_list.COUNT LOOP
5970: IF p_search_ctx THEN
5971: IF p_search_list(I).CITY IS NOT NULL THEN
5972: x_stage_list(I).TX10 :=
5973: HZ_TRANS_PKG.CLEANSE(
5974: p_search_list(I).CITY
5975: ,null,'CITY'
5976: ,'PARTY_SITES');
5977: ELSE

Line 5986: HZ_TRANS_PKG.EXACT(

5982: FOR I IN 1..p_search_list.COUNT LOOP
5983: IF p_search_ctx THEN
5984: IF p_search_list(I).CITY IS NOT NULL THEN
5985: x_stage_list(I).TX9 :=
5986: HZ_TRANS_PKG.EXACT(
5987: p_search_list(I).CITY
5988: ,null,'CITY'
5989: ,'PARTY_SITES');
5990: ELSE

Line 5999: HZ_TRANS_PKG.EXACT(

5995: FOR I IN 1..p_search_list.COUNT LOOP
5996: IF p_search_ctx THEN
5997: IF p_search_list(I).COUNTRY IS NOT NULL THEN
5998: x_stage_list(I).TX22 :=
5999: HZ_TRANS_PKG.EXACT(
6000: p_search_list(I).COUNTRY
6001: ,null,'COUNTRY'
6002: ,'PARTY_SITES');
6003: ELSE

Line 6012: HZ_TRANS_PKG.CLEANSE(

6008: FOR I IN 1..p_search_list.COUNT LOOP
6009: IF p_search_ctx THEN
6010: IF p_search_list(I).COUNTY IS NOT NULL THEN
6011: x_stage_list(I).TX21 :=
6012: HZ_TRANS_PKG.CLEANSE(
6013: p_search_list(I).COUNTY
6014: ,null,'COUNTY'
6015: ,'PARTY_SITES');
6016: ELSE

Line 6025: HZ_TRANS_PKG.EXACT(

6021: FOR I IN 1..p_search_list.COUNT LOOP
6022: IF p_search_ctx THEN
6023: IF p_search_list(I).COUNTY IS NOT NULL THEN
6024: x_stage_list(I).TX20 :=
6025: HZ_TRANS_PKG.EXACT(
6026: p_search_list(I).COUNTY
6027: ,null,'COUNTY'
6028: ,'PARTY_SITES');
6029: ELSE

Line 6038: HZ_TRANS_PKG.RM_SPLCHAR(

6034: FOR I IN 1..p_search_list.COUNT LOOP
6035: IF p_search_ctx THEN
6036: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6037: x_stage_list(I).TX11 :=
6038: HZ_TRANS_PKG.RM_SPLCHAR(
6039: p_search_list(I).POSTAL_CODE
6040: ,null,'POSTAL_CODE'
6041: ,'PARTY_SITES','SDIB');
6042: ELSE

Line 6047: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

6043: x_stage_list(I).TX11 := '';
6044: END IF;
6045: ELSE
6046: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6047: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
6048: x_stage_list(I).TX11
6049: ,null,'POSTAL_CODE'
6050: ,'PARTY_SITES','SCORE');
6051: IF tmp IS NOT NULL THEN

Line 6061: HZ_TRANS_PKG.CLEANSE(

6057: FOR I IN 1..p_search_list.COUNT LOOP
6058: IF p_search_ctx THEN
6059: IF p_search_list(I).PROVINCE IS NOT NULL THEN
6060: x_stage_list(I).TX13 :=
6061: HZ_TRANS_PKG.CLEANSE(
6062: p_search_list(I).PROVINCE
6063: ,null,'PROVINCE'
6064: ,'PARTY_SITES');
6065: ELSE

Line 6074: HZ_TRANS_PKG.EXACT(

6070: FOR I IN 1..p_search_list.COUNT LOOP
6071: IF p_search_ctx THEN
6072: IF p_search_list(I).PROVINCE IS NOT NULL THEN
6073: x_stage_list(I).TX12 :=
6074: HZ_TRANS_PKG.EXACT(
6075: p_search_list(I).PROVINCE
6076: ,null,'PROVINCE'
6077: ,'PARTY_SITES');
6078: ELSE

Line 6087: HZ_TRANS_PKG.WRSTATE_CLEANSE(

6083: FOR I IN 1..p_search_list.COUNT LOOP
6084: IF p_search_ctx THEN
6085: IF p_search_list(I).STATE IS NOT NULL THEN
6086: x_stage_list(I).TX15 :=
6087: HZ_TRANS_PKG.WRSTATE_CLEANSE(
6088: p_search_list(I).STATE
6089: ,null,'STATE'
6090: ,'PARTY_SITES','SDIB');
6091: ELSE

Line 6096: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(

6092: x_stage_list(I).TX15 := '';
6093: END IF;
6094: ELSE
6095: IF p_search_list(I).STATE IS NOT NULL THEN
6096: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(
6097: x_stage_list(I).TX15
6098: ,null,'STATE'
6099: ,'PARTY_SITES','SCORE');
6100: IF tmp IS NOT NULL THEN

Line 6110: HZ_TRANS_PKG.WRSTATE_EXACT(

6106: FOR I IN 1..p_search_list.COUNT LOOP
6107: IF p_search_ctx THEN
6108: IF p_search_list(I).STATE IS NOT NULL THEN
6109: x_stage_list(I).TX14 :=
6110: HZ_TRANS_PKG.WRSTATE_EXACT(
6111: p_search_list(I).STATE
6112: ,null,'STATE'
6113: ,'PARTY_SITES','SDIB');
6114: ELSE

Line 6119: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(

6115: x_stage_list(I).TX14 := '';
6116: END IF;
6117: ELSE
6118: IF p_search_list(I).STATE IS NOT NULL THEN
6119: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(
6120: x_stage_list(I).TX14
6121: ,null,'STATE'
6122: ,'PARTY_SITES','SCORE');
6123: IF tmp IS NOT NULL THEN