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

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

Line 6093: HZ_TRANS_PKG.SOUNDX(

6089: END IF;
6090: IF p_search_ctx THEN
6091: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6092: x_stage_rec.TX158 :=
6093: HZ_TRANS_PKG.SOUNDX(
6094: p_search_rec.PARTY_ALL_NAMES
6095: ,null,'PARTY_ALL_NAMES'
6096: ,'PARTY');
6097: ELSE

Line 6104: HZ_TRANS_PKG.WRNAMES_CLEANSE(

6100: END IF;
6101: IF p_search_ctx THEN
6102: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6103: x_stage_rec.TX40 :=
6104: HZ_TRANS_PKG.WRNAMES_CLEANSE(
6105: p_search_rec.PARTY_ALL_NAMES
6106: ,null,'PARTY_ALL_NAMES'
6107: ,'PARTY','SEARCH');
6108: ELSE

Line 6113: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

6109: x_stage_rec.TX40 := '';
6110: END IF;
6111: ELSE
6112: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6113: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
6114: x_stage_rec.TX40
6115: ,null,'PARTY_ALL_NAMES'
6116: ,'PARTY','SCORE');
6117: IF tmp IS NOT NULL THEN

Line 6125: HZ_TRANS_PKG.WRNAMES_EXACT(

6121: END IF;
6122: IF p_search_ctx THEN
6123: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6124: x_stage_rec.TX39 :=
6125: HZ_TRANS_PKG.WRNAMES_EXACT(
6126: p_search_rec.PARTY_ALL_NAMES
6127: ,null,'PARTY_ALL_NAMES'
6128: ,'PARTY','SEARCH');
6129: ELSE

Line 6134: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

6130: x_stage_rec.TX39 := '';
6131: END IF;
6132: ELSE
6133: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6134: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
6135: x_stage_rec.TX39
6136: ,null,'PARTY_ALL_NAMES'
6137: ,'PARTY','SCORE');
6138: IF tmp IS NOT NULL THEN

Line 6146: HZ_TRANS_PKG.RM_SPLCHAR(

6142: END IF;
6143: IF p_search_ctx THEN
6144: IF p_search_rec.PARTY_NUMBER IS NOT NULL THEN
6145: x_stage_rec.TX34 :=
6146: HZ_TRANS_PKG.RM_SPLCHAR(
6147: p_search_rec.PARTY_NUMBER
6148: ,null,'PARTY_NUMBER'
6149: ,'PARTY','SEARCH');
6150: ELSE

Line 6155: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6151: x_stage_rec.TX34 := '';
6152: END IF;
6153: ELSE
6154: IF p_search_rec.PARTY_NUMBER IS NOT NULL THEN
6155: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6156: x_stage_rec.TX34
6157: ,null,'PARTY_NUMBER'
6158: ,'PARTY','SCORE');
6159: IF tmp IS NOT NULL THEN

Line 6167: HZ_TRANS_PKG.EXACT(

6163: END IF;
6164: IF p_search_ctx THEN
6165: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
6166: x_stage_rec.TX36 :=
6167: HZ_TRANS_PKG.EXACT(
6168: p_search_rec.PARTY_TYPE
6169: ,null,'PARTY_TYPE'
6170: ,'PARTY');
6171: ELSE

Line 6178: HZ_TRANS_PKG.EXACT(

6174: END IF;
6175: IF p_search_ctx THEN
6176: IF p_search_rec.SIC_CODE IS NOT NULL THEN
6177: x_stage_rec.TX46 :=
6178: HZ_TRANS_PKG.EXACT(
6179: p_search_rec.SIC_CODE
6180: ,null,'SIC_CODE'
6181: ,'PARTY');
6182: ELSE

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

6187: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6188: l_party_name := p_search_rec.PARTY_ALL_NAMES;
6189: END IF;
6190: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
6191: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
6192: END IF;
6193: EXCEPTION
6194: WHEN OTHERS THEN
6195: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 6252: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6248: FOR I IN 1..p_search_list.COUNT LOOP
6249: IF p_search_ctx THEN
6250: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6251: x_stage_list(I).TX4 :=
6252: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6253: p_search_list(I).ADDRESS
6254: ,null,'ADDRESS'
6255: ,'PARTY_SITES','SEARCH');
6256: ELSE

Line 6261: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6257: x_stage_list(I).TX4 := '';
6258: END IF;
6259: ELSE
6260: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6261: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6262: x_stage_list(I).TX4
6263: ,null,'ADDRESS'
6264: ,'PARTY_SITES','SCORE');
6265: IF tmp IS NOT NULL THEN

Line 6275: HZ_TRANS_PKG.WRADDRESS_EXACT(

6271: FOR I IN 1..p_search_list.COUNT LOOP
6272: IF p_search_ctx THEN
6273: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6274: x_stage_list(I).TX3 :=
6275: HZ_TRANS_PKG.WRADDRESS_EXACT(
6276: p_search_list(I).ADDRESS
6277: ,null,'ADDRESS'
6278: ,'PARTY_SITES','SEARCH');
6279: ELSE

Line 6284: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

6280: x_stage_list(I).TX3 := '';
6281: END IF;
6282: ELSE
6283: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6284: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(
6285: x_stage_list(I).TX3
6286: ,null,'ADDRESS'
6287: ,'PARTY_SITES','SCORE');
6288: IF tmp IS NOT NULL THEN

Line 6298: HZ_TRANS_PKG.CLEANSE(

6294: FOR I IN 1..p_search_list.COUNT LOOP
6295: IF p_search_ctx THEN
6296: IF p_search_list(I).CITY IS NOT NULL THEN
6297: x_stage_list(I).TX10 :=
6298: HZ_TRANS_PKG.CLEANSE(
6299: p_search_list(I).CITY
6300: ,null,'CITY'
6301: ,'PARTY_SITES');
6302: ELSE

Line 6311: HZ_TRANS_PKG.EXACT(

6307: FOR I IN 1..p_search_list.COUNT LOOP
6308: IF p_search_ctx THEN
6309: IF p_search_list(I).CITY IS NOT NULL THEN
6310: x_stage_list(I).TX9 :=
6311: HZ_TRANS_PKG.EXACT(
6312: p_search_list(I).CITY
6313: ,null,'CITY'
6314: ,'PARTY_SITES');
6315: ELSE

Line 6324: HZ_TRANS_PKG.EXACT(

6320: FOR I IN 1..p_search_list.COUNT LOOP
6321: IF p_search_ctx THEN
6322: IF p_search_list(I).COUNTRY IS NOT NULL THEN
6323: x_stage_list(I).TX22 :=
6324: HZ_TRANS_PKG.EXACT(
6325: p_search_list(I).COUNTRY
6326: ,null,'COUNTRY'
6327: ,'PARTY_SITES');
6328: ELSE

Line 6337: HZ_TRANS_PKG.WRSTATE_EXACT(

6333: FOR I IN 1..p_search_list.COUNT LOOP
6334: IF p_search_ctx THEN
6335: IF p_search_list(I).STATE IS NOT NULL THEN
6336: x_stage_list(I).TX14 :=
6337: HZ_TRANS_PKG.WRSTATE_EXACT(
6338: p_search_list(I).STATE
6339: ,null,'STATE'
6340: ,'PARTY_SITES','SEARCH');
6341: ELSE

Line 6346: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(

6342: x_stage_list(I).TX14 := '';
6343: END IF;
6344: ELSE
6345: IF p_search_list(I).STATE IS NOT NULL THEN
6346: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(
6347: x_stage_list(I).TX14
6348: ,null,'STATE'
6349: ,'PARTY_SITES','SCORE');
6350: IF tmp IS NOT NULL THEN