DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_41 dependencies on HZ_TRANS_PKG

Line 750: HZ_TRANS_PKG.clear_globals;

746: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
747: 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);
748: END IF;
749: -- Transform search criteria
750: HZ_TRANS_PKG.clear_globals;
751: MAP_PARTY_REC(FALSE,p_party_search_rec, l_dummy, g_party_stage_rec);
752: MAP_PARTY_SITE_REC(FALSE,p_party_site_list, l_dummy, g_party_site_stage_list);
753: MAP_CONTACT_REC(FALSE,p_contact_list, l_dummy, g_contact_stage_list);
754: MAP_CONTACT_POINT_REC(FALSE,p_contact_point_list, l_dummy, g_contact_pt_stage_list);

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

803: g_contact_pt_stage_list.DELETE;
804: call_order.DELETE;
805: call_max_score.DELETE;
806: HZ_DQM_SEARCH_UTIL.new_search;
807: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
808: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
809:
810: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
811: 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 3219: HZ_TRANS_PKG.EXACT(

3215: /********************* Find Parties private procedures *******/
3216: PROCEDURE set_person_party_type IS
3217: BEGIN
3218: g_party_stage_rec.TX36:=
3219: HZ_TRANS_PKG.EXACT(
3220: 'PERSON'
3221: ,null,'PARTY_TYPE'
3222: ,'PARTY');
3223: END;

Line 5966: HZ_TRANS_PKG.EXACT_PADDED(

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

Line 5977: HZ_TRANS_PKG.WRNAMES_EXACT(

5973: END IF;
5974: IF p_search_ctx THEN
5975: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5976: x_stage_rec.TX8 :=
5977: HZ_TRANS_PKG.WRNAMES_EXACT(
5978: p_search_rec.PARTY_NAME
5979: ,null,'PARTY_NAME'
5980: ,'PARTY','SEARCH');
5981: ELSE

Line 5986: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

5982: x_stage_rec.TX8 := '';
5983: END IF;
5984: ELSE
5985: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5986: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
5987: x_stage_rec.TX8
5988: ,null,'PARTY_NAME'
5989: ,'PARTY','SCORE');
5990: IF tmp IS NOT NULL THEN

Line 5998: HZ_TRANS_PKG.EXACT(

5994: END IF;
5995: IF p_search_ctx THEN
5996: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
5997: x_stage_rec.TX36 :=
5998: HZ_TRANS_PKG.EXACT(
5999: p_search_rec.PARTY_TYPE
6000: ,null,'PARTY_TYPE'
6001: ,'PARTY');
6002: ELSE

Line 6009: HZ_TRANS_PKG.RM_SPLCHAR(

6005: END IF;
6006: IF p_search_ctx THEN
6007: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
6008: x_stage_rec.TX44 :=
6009: HZ_TRANS_PKG.RM_SPLCHAR(
6010: p_search_rec.TAX_REFERENCE
6011: ,null,'TAX_REFERENCE'
6012: ,'PARTY','SEARCH');
6013: ELSE

Line 6018: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6014: x_stage_rec.TX44 := '';
6015: END IF;
6016: ELSE
6017: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
6018: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6019: x_stage_rec.TX44
6020: ,null,'TAX_REFERENCE'
6021: ,'PARTY','SCORE');
6022: IF tmp IS NOT NULL THEN

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

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','SEARCH');
6033: END IF;
6034: EXCEPTION
6035: WHEN OTHERS THEN
6036: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 6087: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6083: FOR I IN 1..p_search_list.COUNT LOOP
6084: IF p_search_ctx THEN
6085: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6086: x_stage_list(I).TX4 :=
6087: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6088: p_search_list(I).ADDRESS
6089: ,null,'ADDRESS'
6090: ,'PARTY_SITES','SEARCH');
6091: ELSE

Line 6096: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6092: x_stage_list(I).TX4 := '';
6093: END IF;
6094: ELSE
6095: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6096: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6097: x_stage_list(I).TX4
6098: ,null,'ADDRESS'
6099: ,'PARTY_SITES','SCORE');
6100: IF tmp IS NOT NULL THEN

Line 6110: HZ_TRANS_PKG.WRADDRESS_EXACT(

6106: FOR I IN 1..p_search_list.COUNT LOOP
6107: IF p_search_ctx THEN
6108: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6109: x_stage_list(I).TX3 :=
6110: HZ_TRANS_PKG.WRADDRESS_EXACT(
6111: p_search_list(I).ADDRESS
6112: ,null,'ADDRESS'
6113: ,'PARTY_SITES','SEARCH');
6114: ELSE

Line 6119: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

6115: x_stage_list(I).TX3 := '';
6116: END IF;
6117: ELSE
6118: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6119: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(
6120: x_stage_list(I).TX3
6121: ,null,'ADDRESS'
6122: ,'PARTY_SITES','SCORE');
6123: IF tmp IS NOT NULL THEN

Line 6133: HZ_TRANS_PKG.RM_SPLCHAR(

6129: FOR I IN 1..p_search_list.COUNT LOOP
6130: IF p_search_ctx THEN
6131: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6132: x_stage_list(I).TX11 :=
6133: HZ_TRANS_PKG.RM_SPLCHAR(
6134: p_search_list(I).POSTAL_CODE
6135: ,null,'POSTAL_CODE'
6136: ,'PARTY_SITES','SEARCH');
6137: ELSE

Line 6142: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

6138: x_stage_list(I).TX11 := '';
6139: END IF;
6140: ELSE
6141: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6142: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
6143: x_stage_list(I).TX11
6144: ,null,'POSTAL_CODE'
6145: ,'PARTY_SITES','SCORE');
6146: IF tmp IS NOT NULL THEN

Line 6270: HZ_TRANS_PKG.CLEANSED_EMAIL(

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

Line 6279: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(

6275: x_stage_list(I).TX6 := '';
6276: END IF;
6277: ELSE
6278: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
6279: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(
6280: x_stage_list(I).TX6
6281: ,null,'EMAIL_ADDRESS'
6282: ,'CONTACT_POINTS','SCORE');
6283: IF tmp IS NOT NULL THEN

Line 6293: HZ_TRANS_PKG.EXACT_EMAIL(

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

Line 6306: HZ_TRANS_PKG.RM_SPLCHAR_CTX(

6302: FOR I IN 1..p_search_list.COUNT LOOP
6303: IF p_search_ctx THEN
6304: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
6305: x_stage_list(I).TX1 :=
6306: HZ_TRANS_PKG.RM_SPLCHAR_CTX(
6307: p_search_list(I).FLEX_FORMAT_PHONE_NUMBER
6308: ,null,'FLEX_FORMAT_PHONE_NUMBER'
6309: ,'CONTACT_POINTS','SEARCH');
6310: ELSE

Line 6315: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(

6311: x_stage_list(I).TX1 := '';
6312: END IF;
6313: ELSE
6314: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
6315: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(
6316: x_stage_list(I).TX1
6317: ,null,'FLEX_FORMAT_PHONE_NUMBER'
6318: ,'CONTACT_POINTS','SCORE');
6319: IF tmp IS NOT NULL THEN