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

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

Line 5839: HZ_TRANS_PKG.EXACT(

5835: END IF;
5836: IF p_search_ctx THEN
5837: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
5838: x_stage_rec.TX36 :=
5839: HZ_TRANS_PKG.EXACT(
5840: p_search_rec.PARTY_TYPE
5841: ,null,'PARTY_TYPE'
5842: ,'PARTY');
5843: ELSE

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

5848: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
5849: l_party_name := p_search_rec.PARTY_ALL_NAMES;
5850: END IF;
5851: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
5852: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SDIB');
5853: END IF;
5854: EXCEPTION
5855: WHEN OTHERS THEN
5856: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 5922: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

5918: FOR I IN 1..p_search_list.COUNT LOOP
5919: IF p_search_ctx THEN
5920: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5921: x_stage_list(I).TX4 :=
5922: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
5923: p_search_list(I).ADDRESS
5924: ,null,'ADDRESS'
5925: ,'PARTY_SITES','SDIB');
5926: ELSE

Line 5931: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

5927: x_stage_list(I).TX4 := '';
5928: END IF;
5929: ELSE
5930: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5931: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
5932: x_stage_list(I).TX4
5933: ,null,'ADDRESS'
5934: ,'PARTY_SITES','SCORE');
5935: IF tmp IS NOT NULL THEN

Line 5945: HZ_TRANS_PKG.WRADDRESS_EXACT(

5941: FOR I IN 1..p_search_list.COUNT LOOP
5942: IF p_search_ctx THEN
5943: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5944: x_stage_list(I).TX3 :=
5945: HZ_TRANS_PKG.WRADDRESS_EXACT(
5946: p_search_list(I).ADDRESS
5947: ,null,'ADDRESS'
5948: ,'PARTY_SITES','SDIB');
5949: ELSE

Line 5954: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

5950: x_stage_list(I).TX3 := '';
5951: END IF;
5952: ELSE
5953: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5954: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(
5955: x_stage_list(I).TX3
5956: ,null,'ADDRESS'
5957: ,'PARTY_SITES','SCORE');
5958: IF tmp IS NOT NULL THEN

Line 5968: HZ_TRANS_PKG.CLEANSE(

5964: FOR I IN 1..p_search_list.COUNT LOOP
5965: IF p_search_ctx THEN
5966: IF p_search_list(I).CITY IS NOT NULL THEN
5967: x_stage_list(I).TX10 :=
5968: HZ_TRANS_PKG.CLEANSE(
5969: p_search_list(I).CITY
5970: ,null,'CITY'
5971: ,'PARTY_SITES');
5972: ELSE

Line 5981: HZ_TRANS_PKG.EXACT(

5977: FOR I IN 1..p_search_list.COUNT LOOP
5978: IF p_search_ctx THEN
5979: IF p_search_list(I).CITY IS NOT NULL THEN
5980: x_stage_list(I).TX9 :=
5981: HZ_TRANS_PKG.EXACT(
5982: p_search_list(I).CITY
5983: ,null,'CITY'
5984: ,'PARTY_SITES');
5985: ELSE

Line 5994: HZ_TRANS_PKG.EXACT(

5990: FOR I IN 1..p_search_list.COUNT LOOP
5991: IF p_search_ctx THEN
5992: IF p_search_list(I).COUNTRY IS NOT NULL THEN
5993: x_stage_list(I).TX22 :=
5994: HZ_TRANS_PKG.EXACT(
5995: p_search_list(I).COUNTRY
5996: ,null,'COUNTRY'
5997: ,'PARTY_SITES');
5998: ELSE

Line 6007: HZ_TRANS_PKG.CLEANSE(

6003: FOR I IN 1..p_search_list.COUNT LOOP
6004: IF p_search_ctx THEN
6005: IF p_search_list(I).COUNTY IS NOT NULL THEN
6006: x_stage_list(I).TX21 :=
6007: HZ_TRANS_PKG.CLEANSE(
6008: p_search_list(I).COUNTY
6009: ,null,'COUNTY'
6010: ,'PARTY_SITES');
6011: ELSE

Line 6020: HZ_TRANS_PKG.EXACT(

6016: FOR I IN 1..p_search_list.COUNT LOOP
6017: IF p_search_ctx THEN
6018: IF p_search_list(I).COUNTY IS NOT NULL THEN
6019: x_stage_list(I).TX20 :=
6020: HZ_TRANS_PKG.EXACT(
6021: p_search_list(I).COUNTY
6022: ,null,'COUNTY'
6023: ,'PARTY_SITES');
6024: ELSE

Line 6033: HZ_TRANS_PKG.RM_SPLCHAR(

6029: FOR I IN 1..p_search_list.COUNT LOOP
6030: IF p_search_ctx THEN
6031: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6032: x_stage_list(I).TX11 :=
6033: HZ_TRANS_PKG.RM_SPLCHAR(
6034: p_search_list(I).POSTAL_CODE
6035: ,null,'POSTAL_CODE'
6036: ,'PARTY_SITES','SDIB');
6037: ELSE

Line 6042: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

6038: x_stage_list(I).TX11 := '';
6039: END IF;
6040: ELSE
6041: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6042: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
6043: x_stage_list(I).TX11
6044: ,null,'POSTAL_CODE'
6045: ,'PARTY_SITES','SCORE');
6046: IF tmp IS NOT NULL THEN

Line 6056: HZ_TRANS_PKG.CLEANSE(

6052: FOR I IN 1..p_search_list.COUNT LOOP
6053: IF p_search_ctx THEN
6054: IF p_search_list(I).PROVINCE IS NOT NULL THEN
6055: x_stage_list(I).TX13 :=
6056: HZ_TRANS_PKG.CLEANSE(
6057: p_search_list(I).PROVINCE
6058: ,null,'PROVINCE'
6059: ,'PARTY_SITES');
6060: ELSE

Line 6069: HZ_TRANS_PKG.EXACT(

6065: FOR I IN 1..p_search_list.COUNT LOOP
6066: IF p_search_ctx THEN
6067: IF p_search_list(I).PROVINCE IS NOT NULL THEN
6068: x_stage_list(I).TX12 :=
6069: HZ_TRANS_PKG.EXACT(
6070: p_search_list(I).PROVINCE
6071: ,null,'PROVINCE'
6072: ,'PARTY_SITES');
6073: ELSE

Line 6082: HZ_TRANS_PKG.WRSTATE_CLEANSE(

6078: FOR I IN 1..p_search_list.COUNT LOOP
6079: IF p_search_ctx THEN
6080: IF p_search_list(I).STATE IS NOT NULL THEN
6081: x_stage_list(I).TX15 :=
6082: HZ_TRANS_PKG.WRSTATE_CLEANSE(
6083: p_search_list(I).STATE
6084: ,null,'STATE'
6085: ,'PARTY_SITES','SDIB');
6086: ELSE

Line 6091: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(

6087: x_stage_list(I).TX15 := '';
6088: END IF;
6089: ELSE
6090: IF p_search_list(I).STATE IS NOT NULL THEN
6091: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(
6092: x_stage_list(I).TX15
6093: ,null,'STATE'
6094: ,'PARTY_SITES','SCORE');
6095: IF tmp IS NOT NULL THEN

Line 6105: HZ_TRANS_PKG.WRSTATE_EXACT(

6101: FOR I IN 1..p_search_list.COUNT LOOP
6102: IF p_search_ctx THEN
6103: IF p_search_list(I).STATE IS NOT NULL THEN
6104: x_stage_list(I).TX14 :=
6105: HZ_TRANS_PKG.WRSTATE_EXACT(
6106: p_search_list(I).STATE
6107: ,null,'STATE'
6108: ,'PARTY_SITES','SDIB');
6109: ELSE

Line 6114: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(

6110: x_stage_list(I).TX14 := '';
6111: END IF;
6112: ELSE
6113: IF p_search_list(I).STATE IS NOT NULL THEN
6114: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(
6115: x_stage_list(I).TX14
6116: ,null,'STATE'
6117: ,'PARTY_SITES','SCORE');
6118: IF tmp IS NOT NULL THEN