DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_48 dependencies on HZ_TRANS_PKG

Line 859: HZ_TRANS_PKG.clear_globals;

855: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
856: 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);
857: END IF;
858: -- Transform search criteria
859: HZ_TRANS_PKG.clear_globals;
860: MAP_PARTY_REC(FALSE,p_party_search_rec, l_dummy, g_party_stage_rec);
861: MAP_PARTY_SITE_REC(FALSE,p_party_site_list, l_dummy, g_party_site_stage_list);
862: MAP_CONTACT_REC(FALSE,p_contact_list, l_dummy, g_contact_stage_list);
863: MAP_CONTACT_POINT_REC(FALSE,p_contact_point_list, l_dummy, g_contact_pt_stage_list);

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

912: g_contact_pt_stage_list.DELETE;
913: call_order.DELETE;
914: call_max_score.DELETE;
915: HZ_DQM_SEARCH_UTIL.new_search;
916: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
917: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
918:
919: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
920: 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 3316: HZ_TRANS_PKG.EXACT(

3312: /********************* Find Parties private procedures *******/
3313: PROCEDURE set_person_party_type IS
3314: BEGIN
3315: g_party_stage_rec.TX36:=
3316: HZ_TRANS_PKG.EXACT(
3317: 'PERSON'
3318: ,null,'PARTY_TYPE'
3319: ,'PARTY');
3320: END;

Line 5939: HZ_TRANS_PKG.SOUNDX(

5935: END IF;
5936: IF p_search_ctx THEN
5937: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5938: x_stage_rec.TX19 :=
5939: HZ_TRANS_PKG.SOUNDX(
5940: p_search_rec.PARTY_NAME
5941: ,null,'PARTY_NAME'
5942: ,'PARTY');
5943: ELSE

Line 5950: HZ_TRANS_PKG.WRNAMES_CLEANSE(

5946: END IF;
5947: IF p_search_ctx THEN
5948: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5949: x_stage_rec.TX4 :=
5950: HZ_TRANS_PKG.WRNAMES_CLEANSE(
5951: p_search_rec.PARTY_NAME
5952: ,null,'PARTY_NAME'
5953: ,'PARTY','SDIB');
5954: ELSE

Line 5959: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

5955: x_stage_rec.TX4 := '';
5956: END IF;
5957: ELSE
5958: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5959: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
5960: x_stage_rec.TX4
5961: ,null,'PARTY_NAME'
5962: ,'PARTY','SCORE');
5963: IF tmp IS NOT NULL THEN

Line 5971: HZ_TRANS_PKG.WRNAMES_EXACT(

5967: END IF;
5968: IF p_search_ctx THEN
5969: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5970: x_stage_rec.TX8 :=
5971: HZ_TRANS_PKG.WRNAMES_EXACT(
5972: p_search_rec.PARTY_NAME
5973: ,null,'PARTY_NAME'
5974: ,'PARTY','SDIB');
5975: ELSE

Line 5980: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

5976: x_stage_rec.TX8 := '';
5977: END IF;
5978: ELSE
5979: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5980: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
5981: x_stage_rec.TX8
5982: ,null,'PARTY_NAME'
5983: ,'PARTY','SCORE');
5984: IF tmp IS NOT NULL THEN

Line 5992: HZ_TRANS_PKG.RM_SPLCHAR(

5988: END IF;
5989: IF p_search_ctx THEN
5990: IF p_search_rec.PARTY_NUMBER IS NOT NULL THEN
5991: x_stage_rec.TX34 :=
5992: HZ_TRANS_PKG.RM_SPLCHAR(
5993: p_search_rec.PARTY_NUMBER
5994: ,null,'PARTY_NUMBER'
5995: ,'PARTY','SDIB');
5996: ELSE

Line 6001: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

5997: x_stage_rec.TX34 := '';
5998: END IF;
5999: ELSE
6000: IF p_search_rec.PARTY_NUMBER IS NOT NULL THEN
6001: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6002: x_stage_rec.TX34
6003: ,null,'PARTY_NUMBER'
6004: ,'PARTY','SCORE');
6005: IF tmp IS NOT NULL THEN

Line 6013: HZ_TRANS_PKG.EXACT(

6009: END IF;
6010: IF p_search_ctx THEN
6011: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
6012: x_stage_rec.TX36 :=
6013: HZ_TRANS_PKG.EXACT(
6014: p_search_rec.PARTY_TYPE
6015: ,null,'PARTY_TYPE'
6016: ,'PARTY');
6017: ELSE

Line 6024: HZ_TRANS_PKG.EXACT(

6020: END IF;
6021: IF p_search_ctx THEN
6022: IF p_search_rec.SIC_CODE IS NOT NULL THEN
6023: x_stage_rec.TX46 :=
6024: HZ_TRANS_PKG.EXACT(
6025: p_search_rec.SIC_CODE
6026: ,null,'SIC_CODE'
6027: ,'PARTY');
6028: ELSE

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

6033: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6034: l_party_name := p_search_rec.PARTY_ALL_NAMES;
6035: END IF;
6036: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
6037: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SDIB');
6038: END IF;
6039: EXCEPTION
6040: WHEN OTHERS THEN
6041: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 6098: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6094: FOR I IN 1..p_search_list.COUNT LOOP
6095: IF p_search_ctx THEN
6096: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6097: x_stage_list(I).TX4 :=
6098: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6099: p_search_list(I).ADDRESS
6100: ,null,'ADDRESS'
6101: ,'PARTY_SITES','SDIB');
6102: ELSE

Line 6107: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6103: x_stage_list(I).TX4 := '';
6104: END IF;
6105: ELSE
6106: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6107: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6108: x_stage_list(I).TX4
6109: ,null,'ADDRESS'
6110: ,'PARTY_SITES','SCORE');
6111: IF tmp IS NOT NULL THEN

Line 6121: HZ_TRANS_PKG.CLEANSE(

6117: FOR I IN 1..p_search_list.COUNT LOOP
6118: IF p_search_ctx THEN
6119: IF p_search_list(I).CITY IS NOT NULL THEN
6120: x_stage_list(I).TX10 :=
6121: HZ_TRANS_PKG.CLEANSE(
6122: p_search_list(I).CITY
6123: ,null,'CITY'
6124: ,'PARTY_SITES');
6125: ELSE

Line 6134: HZ_TRANS_PKG.EXACT(

6130: FOR I IN 1..p_search_list.COUNT LOOP
6131: IF p_search_ctx THEN
6132: IF p_search_list(I).COUNTRY IS NOT NULL THEN
6133: x_stage_list(I).TX22 :=
6134: HZ_TRANS_PKG.EXACT(
6135: p_search_list(I).COUNTRY
6136: ,null,'COUNTRY'
6137: ,'PARTY_SITES');
6138: ELSE

Line 6147: HZ_TRANS_PKG.WRSTATE_EXACT(

6143: FOR I IN 1..p_search_list.COUNT LOOP
6144: IF p_search_ctx THEN
6145: IF p_search_list(I).STATE IS NOT NULL THEN
6146: x_stage_list(I).TX14 :=
6147: HZ_TRANS_PKG.WRSTATE_EXACT(
6148: p_search_list(I).STATE
6149: ,null,'STATE'
6150: ,'PARTY_SITES','SDIB');
6151: ELSE

Line 6156: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(

6152: x_stage_list(I).TX14 := '';
6153: END IF;
6154: ELSE
6155: IF p_search_list(I).STATE IS NOT NULL THEN
6156: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(
6157: x_stage_list(I).TX14
6158: ,null,'STATE'
6159: ,'PARTY_SITES','SCORE');
6160: IF tmp IS NOT NULL THEN