APPS.HZ_MATCH_RULE_40 dependencies on HZ_TRANS_PKG

Line 785: HZ_TRANS_PKG.clear_globals;

781: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
782: 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);
783: END IF;
784: -- Transform search criteria
785: HZ_TRANS_PKG.clear_globals;
786: MAP_PARTY_REC(FALSE,p_party_search_rec, l_dummy, g_party_stage_rec);
787: MAP_PARTY_SITE_REC(FALSE,p_party_site_list, l_dummy, g_party_site_stage_list);
788: MAP_CONTACT_REC(FALSE,p_contact_list, l_dummy, g_contact_stage_list);
789: MAP_CONTACT_POINT_REC(FALSE,p_contact_point_list, l_dummy, g_contact_pt_stage_list);

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

838: g_contact_pt_stage_list.DELETE;
839: call_order.DELETE;
840: call_max_score.DELETE;
841: HZ_DQM_SEARCH_UTIL.new_search;
842: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
843: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
844:
845: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
846: 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 3328: HZ_TRANS_PKG.EXACT(

3324: /********************* Find Parties private procedures *******/
3325: PROCEDURE set_person_party_type IS
3326: BEGIN
3327: g_party_stage_rec.TX36:=
3328: HZ_TRANS_PKG.EXACT(
3329: 'PERSON'
3330: ,null,'PARTY_TYPE'
3331: ,'PARTY');
3332: END;

Line 6097: HZ_TRANS_PKG.EXACT(

6093: END IF;
6094: IF p_search_ctx THEN
6095: IF p_search_rec.DUNS_NUMBER_C IS NOT NULL THEN
6096: x_stage_rec.TX41 :=
6097: HZ_TRANS_PKG.EXACT(
6098: p_search_rec.DUNS_NUMBER_C
6099: ,null,'DUNS_NUMBER_C'
6100: ,'PARTY');
6101: ELSE

Line 6112: HZ_TRANS_PKG.WRNAMES_CLEANSE(

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

Line 6121: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

6117: x_stage_rec.TX40 := '';
6118: END IF;
6119: ELSE
6120: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6121: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
6122: x_stage_rec.TX40
6123: ,null,'PARTY_ALL_NAMES'
6124: ,'PARTY','SCORE');
6125: IF tmp IS NOT NULL THEN

Line 6133: HZ_TRANS_PKG.WRNAMES_EXACT(

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

Line 6142: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

6138: x_stage_rec.TX39 := '';
6139: END IF;
6140: ELSE
6141: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6142: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
6143: x_stage_rec.TX39
6144: ,null,'PARTY_ALL_NAMES'
6145: ,'PARTY','SCORE');
6146: IF tmp IS NOT NULL THEN

Line 6153: HZ_TRANS_PKG.EXACT(

6149: END IF;
6150: END IF;
6151: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
6152: x_stage_rec.TX36 :=
6153: HZ_TRANS_PKG.EXACT(
6154: p_search_rec.PARTY_TYPE
6155: ,null,'PARTY_TYPE'
6156: ,'PARTY');
6157: ELSE

Line 6163: HZ_TRANS_PKG.RM_SPLCHAR(

6159: END IF;
6160: IF p_search_ctx THEN
6161: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
6162: x_stage_rec.TX44 :=
6163: HZ_TRANS_PKG.RM_SPLCHAR(
6164: p_search_rec.TAX_REFERENCE
6165: ,null,'TAX_REFERENCE'
6166: ,'PARTY','SEARCH');
6167: ELSE

Line 6172: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6168: x_stage_rec.TX44 := '';
6169: END IF;
6170: ELSE
6171: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
6172: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6173: x_stage_rec.TX44
6174: ,null,'TAX_REFERENCE'
6175: ,'PARTY','SCORE');
6176: IF tmp IS NOT NULL THEN

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 6241: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6237: FOR I IN 1..p_search_list.COUNT LOOP
6238: IF p_search_ctx THEN
6239: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6240: x_stage_list(I).TX4 :=
6241: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6242: p_search_list(I).ADDRESS
6243: ,null,'ADDRESS'
6244: ,'PARTY_SITES','SEARCH');
6245: ELSE

Line 6250: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6246: x_stage_list(I).TX4 := '';
6247: END IF;
6248: ELSE
6249: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6250: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6251: x_stage_list(I).TX4
6252: ,null,'ADDRESS'
6253: ,'PARTY_SITES','SCORE');
6254: IF tmp IS NOT NULL THEN

Line 6264: HZ_TRANS_PKG.WRADDRESS_EXACT(

6260: FOR I IN 1..p_search_list.COUNT LOOP
6261: IF p_search_ctx THEN
6262: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6263: x_stage_list(I).TX3 :=
6264: HZ_TRANS_PKG.WRADDRESS_EXACT(
6265: p_search_list(I).ADDRESS
6266: ,null,'ADDRESS'
6267: ,'PARTY_SITES','SEARCH');
6268: ELSE

Line 6273: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

6269: x_stage_list(I).TX3 := '';
6270: END IF;
6271: ELSE
6272: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6273: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(
6274: x_stage_list(I).TX3
6275: ,null,'ADDRESS'
6276: ,'PARTY_SITES','SCORE');
6277: IF tmp IS NOT NULL THEN

Line 6287: HZ_TRANS_PKG.RM_SPLCHAR(

6283: FOR I IN 1..p_search_list.COUNT LOOP
6284: IF p_search_ctx THEN
6285: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6286: x_stage_list(I).TX11 :=
6287: HZ_TRANS_PKG.RM_SPLCHAR(
6288: p_search_list(I).POSTAL_CODE
6289: ,null,'POSTAL_CODE'
6290: ,'PARTY_SITES','SEARCH');
6291: ELSE

Line 6296: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

6292: x_stage_list(I).TX11 := '';
6293: END IF;
6294: ELSE
6295: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6296: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
6297: x_stage_list(I).TX11
6298: ,null,'POSTAL_CODE'
6299: ,'PARTY_SITES','SCORE');
6300: IF tmp IS NOT NULL THEN

Line 6354: HZ_TRANS_PKG.EXACT_PADDED(

6350: FOR I IN 1..p_search_list.COUNT LOOP
6351: IF p_search_ctx THEN
6352: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
6353: x_stage_list(I).TX2 :=
6354: HZ_TRANS_PKG.EXACT_PADDED(
6355: p_search_list(I).CONTACT_NAME
6356: ,null,'CONTACT_NAME'
6357: ,'CONTACTS');
6358: ELSE

Line 6367: HZ_TRANS_PKG.WRPERSON_EXACT(

6363: FOR I IN 1..p_search_list.COUNT LOOP
6364: IF p_search_ctx THEN
6365: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
6366: x_stage_list(I).TX5 :=
6367: HZ_TRANS_PKG.WRPERSON_EXACT(
6368: p_search_list(I).CONTACT_NAME
6369: ,null,'CONTACT_NAME'
6370: ,'CONTACTS','SEARCH');
6371: ELSE

Line 6376: tmp := HZ_TRANS_PKG.WRPERSON_EXACT(

6372: x_stage_list(I).TX5 := '';
6373: END IF;
6374: ELSE
6375: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
6376: tmp := HZ_TRANS_PKG.WRPERSON_EXACT(
6377: x_stage_list(I).TX5
6378: ,null,'CONTACT_NAME'
6379: ,'CONTACTS','SCORE');
6380: IF tmp IS NOT NULL THEN

Line 6459: HZ_TRANS_PKG.RM_SPLCHAR_CTX(

6455: FOR I IN 1..p_search_list.COUNT LOOP
6456: IF p_search_ctx THEN
6457: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
6458: x_stage_list(I).TX1 :=
6459: HZ_TRANS_PKG.RM_SPLCHAR_CTX(
6460: p_search_list(I).FLEX_FORMAT_PHONE_NUMBER
6461: ,null,'FLEX_FORMAT_PHONE_NUMBER'
6462: ,'CONTACT_POINTS','SEARCH');
6463: ELSE

Line 6468: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(

6464: x_stage_list(I).TX1 := '';
6465: END IF;
6466: ELSE
6467: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
6468: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(
6469: x_stage_list(I).TX1
6470: ,null,'FLEX_FORMAT_PHONE_NUMBER'
6471: ,'CONTACT_POINTS','SCORE');
6472: IF tmp IS NOT NULL THEN