DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_35 dependencies on HZ_TRANS_PKG

Line 876: HZ_TRANS_PKG.clear_globals;

872: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
873: 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);
874: END IF;
875: -- Transform search criteria
876: HZ_TRANS_PKG.clear_globals;
877: MAP_PARTY_REC(FALSE,p_party_search_rec, l_dummy, g_party_stage_rec);
878: MAP_PARTY_SITE_REC(FALSE,p_party_site_list, l_dummy, g_party_site_stage_list);
879: MAP_CONTACT_REC(FALSE,p_contact_list, l_dummy, g_contact_stage_list);
880: MAP_CONTACT_POINT_REC(FALSE,p_contact_point_list, l_dummy, g_contact_pt_stage_list);

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

929: g_contact_pt_stage_list.DELETE;
930: call_order.DELETE;
931: call_max_score.DELETE;
932: HZ_DQM_SEARCH_UTIL.new_search;
933: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
934: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
935:
936: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
937: 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 3390: HZ_TRANS_PKG.EXACT(

3386: /********************* Find Parties private procedures *******/
3387: PROCEDURE set_person_party_type IS
3388: BEGIN
3389: g_party_stage_rec.TX36:=
3390: HZ_TRANS_PKG.EXACT(
3391: 'PERSON'
3392: ,null,'PARTY_TYPE'
3393: ,'PARTY');
3394: END;

Line 6088: HZ_TRANS_PKG.SOUNDX(

6084: END IF;
6085: IF p_search_ctx THEN
6086: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6087: x_stage_rec.TX158 :=
6088: HZ_TRANS_PKG.SOUNDX(
6089: p_search_rec.PARTY_ALL_NAMES
6090: ,null,'PARTY_ALL_NAMES'
6091: ,'PARTY');
6092: ELSE

Line 6099: HZ_TRANS_PKG.WRNAMES_CLEANSE(

6095: END IF;
6096: IF p_search_ctx THEN
6097: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6098: x_stage_rec.TX40 :=
6099: HZ_TRANS_PKG.WRNAMES_CLEANSE(
6100: p_search_rec.PARTY_ALL_NAMES
6101: ,null,'PARTY_ALL_NAMES'
6102: ,'PARTY','SEARCH');
6103: ELSE

Line 6108: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

6104: x_stage_rec.TX40 := '';
6105: END IF;
6106: ELSE
6107: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6108: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
6109: x_stage_rec.TX40
6110: ,null,'PARTY_ALL_NAMES'
6111: ,'PARTY','SCORE');
6112: IF tmp IS NOT NULL THEN

Line 6120: HZ_TRANS_PKG.WRNAMES_EXACT(

6116: END IF;
6117: IF p_search_ctx THEN
6118: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6119: x_stage_rec.TX39 :=
6120: HZ_TRANS_PKG.WRNAMES_EXACT(
6121: p_search_rec.PARTY_ALL_NAMES
6122: ,null,'PARTY_ALL_NAMES'
6123: ,'PARTY','SEARCH');
6124: ELSE

Line 6129: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

6125: x_stage_rec.TX39 := '';
6126: END IF;
6127: ELSE
6128: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6129: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
6130: x_stage_rec.TX39
6131: ,null,'PARTY_ALL_NAMES'
6132: ,'PARTY','SCORE');
6133: IF tmp IS NOT NULL THEN

Line 6141: HZ_TRANS_PKG.RM_SPLCHAR(

6137: END IF;
6138: IF p_search_ctx THEN
6139: IF p_search_rec.PARTY_NUMBER IS NOT NULL THEN
6140: x_stage_rec.TX34 :=
6141: HZ_TRANS_PKG.RM_SPLCHAR(
6142: p_search_rec.PARTY_NUMBER
6143: ,null,'PARTY_NUMBER'
6144: ,'PARTY','SEARCH');
6145: ELSE

Line 6150: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

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

Line 6162: HZ_TRANS_PKG.EXACT(

6158: END IF;
6159: IF p_search_ctx THEN
6160: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
6161: x_stage_rec.TX36 :=
6162: HZ_TRANS_PKG.EXACT(
6163: p_search_rec.PARTY_TYPE
6164: ,null,'PARTY_TYPE'
6165: ,'PARTY');
6166: ELSE

Line 6173: HZ_TRANS_PKG.EXACT(

6169: END IF;
6170: IF p_search_ctx THEN
6171: IF p_search_rec.SIC_CODE IS NOT NULL THEN
6172: x_stage_rec.TX46 :=
6173: HZ_TRANS_PKG.EXACT(
6174: p_search_rec.SIC_CODE
6175: ,null,'SIC_CODE'
6176: ,'PARTY');
6177: ELSE

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

6182: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6183: l_party_name := p_search_rec.PARTY_ALL_NAMES;
6184: END IF;
6185: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
6186: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
6187: END IF;
6188: EXCEPTION
6189: WHEN OTHERS THEN
6190: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 6247: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6243: FOR I IN 1..p_search_list.COUNT LOOP
6244: IF p_search_ctx THEN
6245: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6246: x_stage_list(I).TX4 :=
6247: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6248: p_search_list(I).ADDRESS
6249: ,null,'ADDRESS'
6250: ,'PARTY_SITES','SEARCH');
6251: ELSE

Line 6256: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6252: x_stage_list(I).TX4 := '';
6253: END IF;
6254: ELSE
6255: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6256: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6257: x_stage_list(I).TX4
6258: ,null,'ADDRESS'
6259: ,'PARTY_SITES','SCORE');
6260: IF tmp IS NOT NULL THEN

Line 6270: HZ_TRANS_PKG.WRADDRESS_EXACT(

6266: FOR I IN 1..p_search_list.COUNT LOOP
6267: IF p_search_ctx THEN
6268: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6269: x_stage_list(I).TX3 :=
6270: HZ_TRANS_PKG.WRADDRESS_EXACT(
6271: p_search_list(I).ADDRESS
6272: ,null,'ADDRESS'
6273: ,'PARTY_SITES','SEARCH');
6274: ELSE

Line 6279: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

6275: x_stage_list(I).TX3 := '';
6276: END IF;
6277: ELSE
6278: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6279: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(
6280: x_stage_list(I).TX3
6281: ,null,'ADDRESS'
6282: ,'PARTY_SITES','SCORE');
6283: IF tmp IS NOT NULL THEN

Line 6293: HZ_TRANS_PKG.CLEANSE(

6289: FOR I IN 1..p_search_list.COUNT LOOP
6290: IF p_search_ctx THEN
6291: IF p_search_list(I).CITY IS NOT NULL THEN
6292: x_stage_list(I).TX10 :=
6293: HZ_TRANS_PKG.CLEANSE(
6294: p_search_list(I).CITY
6295: ,null,'CITY'
6296: ,'PARTY_SITES');
6297: ELSE

Line 6306: HZ_TRANS_PKG.EXACT(

6302: FOR I IN 1..p_search_list.COUNT LOOP
6303: IF p_search_ctx THEN
6304: IF p_search_list(I).CITY IS NOT NULL THEN
6305: x_stage_list(I).TX9 :=
6306: HZ_TRANS_PKG.EXACT(
6307: p_search_list(I).CITY
6308: ,null,'CITY'
6309: ,'PARTY_SITES');
6310: ELSE

Line 6319: HZ_TRANS_PKG.EXACT(

6315: FOR I IN 1..p_search_list.COUNT LOOP
6316: IF p_search_ctx THEN
6317: IF p_search_list(I).COUNTRY IS NOT NULL THEN
6318: x_stage_list(I).TX22 :=
6319: HZ_TRANS_PKG.EXACT(
6320: p_search_list(I).COUNTRY
6321: ,null,'COUNTRY'
6322: ,'PARTY_SITES');
6323: ELSE

Line 6332: HZ_TRANS_PKG.WRSTATE_EXACT(

6328: FOR I IN 1..p_search_list.COUNT LOOP
6329: IF p_search_ctx THEN
6330: IF p_search_list(I).STATE IS NOT NULL THEN
6331: x_stage_list(I).TX14 :=
6332: HZ_TRANS_PKG.WRSTATE_EXACT(
6333: p_search_list(I).STATE
6334: ,null,'STATE'
6335: ,'PARTY_SITES','SEARCH');
6336: ELSE

Line 6341: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(

6337: x_stage_list(I).TX14 := '';
6338: END IF;
6339: ELSE
6340: IF p_search_list(I).STATE IS NOT NULL THEN
6341: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(
6342: x_stage_list(I).TX14
6343: ,null,'STATE'
6344: ,'PARTY_SITES','SCORE');
6345: IF tmp IS NOT NULL THEN