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

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

Line 6092: HZ_TRANS_PKG.EXACT(

6088: END IF;
6089: IF p_search_ctx THEN
6090: IF p_search_rec.DUNS_NUMBER_C IS NOT NULL THEN
6091: x_stage_rec.TX41 :=
6092: HZ_TRANS_PKG.EXACT(
6093: p_search_rec.DUNS_NUMBER_C
6094: ,null,'DUNS_NUMBER_C'
6095: ,'PARTY');
6096: ELSE

Line 6107: HZ_TRANS_PKG.WRNAMES_CLEANSE(

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

Line 6116: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

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

Line 6128: HZ_TRANS_PKG.WRNAMES_EXACT(

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

Line 6137: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

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

Line 6148: HZ_TRANS_PKG.EXACT(

6144: END IF;
6145: END IF;
6146: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
6147: x_stage_rec.TX36 :=
6148: HZ_TRANS_PKG.EXACT(
6149: p_search_rec.PARTY_TYPE
6150: ,null,'PARTY_TYPE'
6151: ,'PARTY');
6152: ELSE

Line 6158: HZ_TRANS_PKG.RM_SPLCHAR(

6154: END IF;
6155: IF p_search_ctx THEN
6156: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
6157: x_stage_rec.TX44 :=
6158: HZ_TRANS_PKG.RM_SPLCHAR(
6159: p_search_rec.TAX_REFERENCE
6160: ,null,'TAX_REFERENCE'
6161: ,'PARTY','SEARCH');
6162: ELSE

Line 6167: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6163: x_stage_rec.TX44 := '';
6164: END IF;
6165: ELSE
6166: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
6167: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6168: x_stage_rec.TX44
6169: ,null,'TAX_REFERENCE'
6170: ,'PARTY','SCORE');
6171: IF tmp IS NOT NULL THEN

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

6177: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6178: l_party_name := p_search_rec.PARTY_ALL_NAMES;
6179: END IF;
6180: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
6181: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
6182: END IF;
6183: EXCEPTION
6184: WHEN OTHERS THEN
6185: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 6236: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6232: FOR I IN 1..p_search_list.COUNT LOOP
6233: IF p_search_ctx THEN
6234: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6235: x_stage_list(I).TX4 :=
6236: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6237: p_search_list(I).ADDRESS
6238: ,null,'ADDRESS'
6239: ,'PARTY_SITES','SEARCH');
6240: ELSE

Line 6245: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6241: x_stage_list(I).TX4 := '';
6242: END IF;
6243: ELSE
6244: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6245: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6246: x_stage_list(I).TX4
6247: ,null,'ADDRESS'
6248: ,'PARTY_SITES','SCORE');
6249: IF tmp IS NOT NULL THEN

Line 6259: HZ_TRANS_PKG.WRADDRESS_EXACT(

6255: FOR I IN 1..p_search_list.COUNT LOOP
6256: IF p_search_ctx THEN
6257: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6258: x_stage_list(I).TX3 :=
6259: HZ_TRANS_PKG.WRADDRESS_EXACT(
6260: p_search_list(I).ADDRESS
6261: ,null,'ADDRESS'
6262: ,'PARTY_SITES','SEARCH');
6263: ELSE

Line 6268: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

6264: x_stage_list(I).TX3 := '';
6265: END IF;
6266: ELSE
6267: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6268: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(
6269: x_stage_list(I).TX3
6270: ,null,'ADDRESS'
6271: ,'PARTY_SITES','SCORE');
6272: IF tmp IS NOT NULL THEN

Line 6282: HZ_TRANS_PKG.RM_SPLCHAR(

6278: FOR I IN 1..p_search_list.COUNT LOOP
6279: IF p_search_ctx THEN
6280: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6281: x_stage_list(I).TX11 :=
6282: HZ_TRANS_PKG.RM_SPLCHAR(
6283: p_search_list(I).POSTAL_CODE
6284: ,null,'POSTAL_CODE'
6285: ,'PARTY_SITES','SEARCH');
6286: ELSE

Line 6291: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

6287: x_stage_list(I).TX11 := '';
6288: END IF;
6289: ELSE
6290: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6291: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
6292: x_stage_list(I).TX11
6293: ,null,'POSTAL_CODE'
6294: ,'PARTY_SITES','SCORE');
6295: IF tmp IS NOT NULL THEN

Line 6349: HZ_TRANS_PKG.EXACT_PADDED(

6345: FOR I IN 1..p_search_list.COUNT LOOP
6346: IF p_search_ctx THEN
6347: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
6348: x_stage_list(I).TX2 :=
6349: HZ_TRANS_PKG.EXACT_PADDED(
6350: p_search_list(I).CONTACT_NAME
6351: ,null,'CONTACT_NAME'
6352: ,'CONTACTS');
6353: ELSE

Line 6362: HZ_TRANS_PKG.WRPERSON_EXACT(

6358: FOR I IN 1..p_search_list.COUNT LOOP
6359: IF p_search_ctx THEN
6360: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
6361: x_stage_list(I).TX5 :=
6362: HZ_TRANS_PKG.WRPERSON_EXACT(
6363: p_search_list(I).CONTACT_NAME
6364: ,null,'CONTACT_NAME'
6365: ,'CONTACTS','SEARCH');
6366: ELSE

Line 6371: tmp := HZ_TRANS_PKG.WRPERSON_EXACT(

6367: x_stage_list(I).TX5 := '';
6368: END IF;
6369: ELSE
6370: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
6371: tmp := HZ_TRANS_PKG.WRPERSON_EXACT(
6372: x_stage_list(I).TX5
6373: ,null,'CONTACT_NAME'
6374: ,'CONTACTS','SCORE');
6375: IF tmp IS NOT NULL THEN

Line 6454: HZ_TRANS_PKG.RM_SPLCHAR_CTX(

6450: FOR I IN 1..p_search_list.COUNT LOOP
6451: IF p_search_ctx THEN
6452: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
6453: x_stage_list(I).TX1 :=
6454: HZ_TRANS_PKG.RM_SPLCHAR_CTX(
6455: p_search_list(I).FLEX_FORMAT_PHONE_NUMBER
6456: ,null,'FLEX_FORMAT_PHONE_NUMBER'
6457: ,'CONTACT_POINTS','SEARCH');
6458: ELSE

Line 6463: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(

6459: x_stage_list(I).TX1 := '';
6460: END IF;
6461: ELSE
6462: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
6463: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(
6464: x_stage_list(I).TX1
6465: ,null,'FLEX_FORMAT_PHONE_NUMBER'
6466: ,'CONTACT_POINTS','SCORE');
6467: IF tmp IS NOT NULL THEN