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

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

Line 5934: HZ_TRANS_PKG.SOUNDX(

5930: END IF;
5931: IF p_search_ctx THEN
5932: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5933: x_stage_rec.TX19 :=
5934: HZ_TRANS_PKG.SOUNDX(
5935: p_search_rec.PARTY_NAME
5936: ,null,'PARTY_NAME'
5937: ,'PARTY');
5938: ELSE

Line 5945: HZ_TRANS_PKG.WRNAMES_CLEANSE(

5941: END IF;
5942: IF p_search_ctx THEN
5943: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5944: x_stage_rec.TX4 :=
5945: HZ_TRANS_PKG.WRNAMES_CLEANSE(
5946: p_search_rec.PARTY_NAME
5947: ,null,'PARTY_NAME'
5948: ,'PARTY','SDIB');
5949: ELSE

Line 5954: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

5950: x_stage_rec.TX4 := '';
5951: END IF;
5952: ELSE
5953: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5954: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
5955: x_stage_rec.TX4
5956: ,null,'PARTY_NAME'
5957: ,'PARTY','SCORE');
5958: IF tmp IS NOT NULL THEN

Line 5966: HZ_TRANS_PKG.WRNAMES_EXACT(

5962: END IF;
5963: IF p_search_ctx THEN
5964: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5965: x_stage_rec.TX8 :=
5966: HZ_TRANS_PKG.WRNAMES_EXACT(
5967: p_search_rec.PARTY_NAME
5968: ,null,'PARTY_NAME'
5969: ,'PARTY','SDIB');
5970: ELSE

Line 5975: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

5971: x_stage_rec.TX8 := '';
5972: END IF;
5973: ELSE
5974: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5975: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
5976: x_stage_rec.TX8
5977: ,null,'PARTY_NAME'
5978: ,'PARTY','SCORE');
5979: IF tmp IS NOT NULL THEN

Line 5987: HZ_TRANS_PKG.RM_SPLCHAR(

5983: END IF;
5984: IF p_search_ctx THEN
5985: IF p_search_rec.PARTY_NUMBER IS NOT NULL THEN
5986: x_stage_rec.TX34 :=
5987: HZ_TRANS_PKG.RM_SPLCHAR(
5988: p_search_rec.PARTY_NUMBER
5989: ,null,'PARTY_NUMBER'
5990: ,'PARTY','SDIB');
5991: ELSE

Line 5996: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

5992: x_stage_rec.TX34 := '';
5993: END IF;
5994: ELSE
5995: IF p_search_rec.PARTY_NUMBER IS NOT NULL THEN
5996: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
5997: x_stage_rec.TX34
5998: ,null,'PARTY_NUMBER'
5999: ,'PARTY','SCORE');
6000: IF tmp IS NOT NULL THEN

Line 6008: HZ_TRANS_PKG.EXACT(

6004: END IF;
6005: IF p_search_ctx THEN
6006: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
6007: x_stage_rec.TX36 :=
6008: HZ_TRANS_PKG.EXACT(
6009: p_search_rec.PARTY_TYPE
6010: ,null,'PARTY_TYPE'
6011: ,'PARTY');
6012: ELSE

Line 6019: HZ_TRANS_PKG.EXACT(

6015: END IF;
6016: IF p_search_ctx THEN
6017: IF p_search_rec.SIC_CODE IS NOT NULL THEN
6018: x_stage_rec.TX46 :=
6019: HZ_TRANS_PKG.EXACT(
6020: p_search_rec.SIC_CODE
6021: ,null,'SIC_CODE'
6022: ,'PARTY');
6023: ELSE

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

6028: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6029: l_party_name := p_search_rec.PARTY_ALL_NAMES;
6030: END IF;
6031: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
6032: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SDIB');
6033: END IF;
6034: EXCEPTION
6035: WHEN OTHERS THEN
6036: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 6093: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6089: FOR I IN 1..p_search_list.COUNT LOOP
6090: IF p_search_ctx THEN
6091: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6092: x_stage_list(I).TX4 :=
6093: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6094: p_search_list(I).ADDRESS
6095: ,null,'ADDRESS'
6096: ,'PARTY_SITES','SDIB');
6097: ELSE

Line 6102: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6098: x_stage_list(I).TX4 := '';
6099: END IF;
6100: ELSE
6101: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6102: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6103: x_stage_list(I).TX4
6104: ,null,'ADDRESS'
6105: ,'PARTY_SITES','SCORE');
6106: IF tmp IS NOT NULL THEN

Line 6116: HZ_TRANS_PKG.CLEANSE(

6112: FOR I IN 1..p_search_list.COUNT LOOP
6113: IF p_search_ctx THEN
6114: IF p_search_list(I).CITY IS NOT NULL THEN
6115: x_stage_list(I).TX10 :=
6116: HZ_TRANS_PKG.CLEANSE(
6117: p_search_list(I).CITY
6118: ,null,'CITY'
6119: ,'PARTY_SITES');
6120: ELSE

Line 6129: HZ_TRANS_PKG.EXACT(

6125: FOR I IN 1..p_search_list.COUNT LOOP
6126: IF p_search_ctx THEN
6127: IF p_search_list(I).COUNTRY IS NOT NULL THEN
6128: x_stage_list(I).TX22 :=
6129: HZ_TRANS_PKG.EXACT(
6130: p_search_list(I).COUNTRY
6131: ,null,'COUNTRY'
6132: ,'PARTY_SITES');
6133: ELSE

Line 6142: HZ_TRANS_PKG.WRSTATE_EXACT(

6138: FOR I IN 1..p_search_list.COUNT LOOP
6139: IF p_search_ctx THEN
6140: IF p_search_list(I).STATE IS NOT NULL THEN
6141: x_stage_list(I).TX14 :=
6142: HZ_TRANS_PKG.WRSTATE_EXACT(
6143: p_search_list(I).STATE
6144: ,null,'STATE'
6145: ,'PARTY_SITES','SDIB');
6146: ELSE

Line 6151: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(

6147: x_stage_list(I).TX14 := '';
6148: END IF;
6149: ELSE
6150: IF p_search_list(I).STATE IS NOT NULL THEN
6151: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(
6152: x_stage_list(I).TX14
6153: ,null,'STATE'
6154: ,'PARTY_SITES','SCORE');
6155: IF tmp IS NOT NULL THEN