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

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

Line 5961: HZ_TRANS_PKG.EXACT_PADDED(

5957: END IF;
5958: IF p_search_ctx THEN
5959: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5960: x_stage_rec.TX2 :=
5961: HZ_TRANS_PKG.EXACT_PADDED(
5962: p_search_rec.PARTY_NAME
5963: ,null,'PARTY_NAME'
5964: ,'PARTY');
5965: ELSE

Line 5972: HZ_TRANS_PKG.WRNAMES_EXACT(

5968: END IF;
5969: IF p_search_ctx THEN
5970: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5971: x_stage_rec.TX8 :=
5972: HZ_TRANS_PKG.WRNAMES_EXACT(
5973: p_search_rec.PARTY_NAME
5974: ,null,'PARTY_NAME'
5975: ,'PARTY','SEARCH');
5976: ELSE

Line 5981: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

5977: x_stage_rec.TX8 := '';
5978: END IF;
5979: ELSE
5980: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5981: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
5982: x_stage_rec.TX8
5983: ,null,'PARTY_NAME'
5984: ,'PARTY','SCORE');
5985: IF tmp IS NOT NULL THEN

Line 5993: HZ_TRANS_PKG.EXACT(

5989: END IF;
5990: IF p_search_ctx THEN
5991: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
5992: x_stage_rec.TX36 :=
5993: HZ_TRANS_PKG.EXACT(
5994: p_search_rec.PARTY_TYPE
5995: ,null,'PARTY_TYPE'
5996: ,'PARTY');
5997: ELSE

Line 6004: HZ_TRANS_PKG.RM_SPLCHAR(

6000: END IF;
6001: IF p_search_ctx THEN
6002: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
6003: x_stage_rec.TX44 :=
6004: HZ_TRANS_PKG.RM_SPLCHAR(
6005: p_search_rec.TAX_REFERENCE
6006: ,null,'TAX_REFERENCE'
6007: ,'PARTY','SEARCH');
6008: ELSE

Line 6013: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6009: x_stage_rec.TX44 := '';
6010: END IF;
6011: ELSE
6012: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
6013: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6014: x_stage_rec.TX44
6015: ,null,'TAX_REFERENCE'
6016: ,'PARTY','SCORE');
6017: IF tmp IS NOT NULL THEN

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

6023: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6024: l_party_name := p_search_rec.PARTY_ALL_NAMES;
6025: END IF;
6026: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
6027: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
6028: END IF;
6029: EXCEPTION
6030: WHEN OTHERS THEN
6031: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 6082: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6078: FOR I IN 1..p_search_list.COUNT LOOP
6079: IF p_search_ctx THEN
6080: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6081: x_stage_list(I).TX4 :=
6082: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6083: p_search_list(I).ADDRESS
6084: ,null,'ADDRESS'
6085: ,'PARTY_SITES','SEARCH');
6086: ELSE

Line 6091: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6087: x_stage_list(I).TX4 := '';
6088: END IF;
6089: ELSE
6090: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6091: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6092: x_stage_list(I).TX4
6093: ,null,'ADDRESS'
6094: ,'PARTY_SITES','SCORE');
6095: IF tmp IS NOT NULL THEN

Line 6105: HZ_TRANS_PKG.WRADDRESS_EXACT(

6101: FOR I IN 1..p_search_list.COUNT LOOP
6102: IF p_search_ctx THEN
6103: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6104: x_stage_list(I).TX3 :=
6105: HZ_TRANS_PKG.WRADDRESS_EXACT(
6106: p_search_list(I).ADDRESS
6107: ,null,'ADDRESS'
6108: ,'PARTY_SITES','SEARCH');
6109: ELSE

Line 6114: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

6110: x_stage_list(I).TX3 := '';
6111: END IF;
6112: ELSE
6113: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6114: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(
6115: x_stage_list(I).TX3
6116: ,null,'ADDRESS'
6117: ,'PARTY_SITES','SCORE');
6118: IF tmp IS NOT NULL THEN

Line 6128: HZ_TRANS_PKG.RM_SPLCHAR(

6124: FOR I IN 1..p_search_list.COUNT LOOP
6125: IF p_search_ctx THEN
6126: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6127: x_stage_list(I).TX11 :=
6128: HZ_TRANS_PKG.RM_SPLCHAR(
6129: p_search_list(I).POSTAL_CODE
6130: ,null,'POSTAL_CODE'
6131: ,'PARTY_SITES','SEARCH');
6132: ELSE

Line 6137: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

6133: x_stage_list(I).TX11 := '';
6134: END IF;
6135: ELSE
6136: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6137: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
6138: x_stage_list(I).TX11
6139: ,null,'POSTAL_CODE'
6140: ,'PARTY_SITES','SCORE');
6141: IF tmp IS NOT NULL THEN

Line 6265: HZ_TRANS_PKG.CLEANSED_EMAIL(

6261: FOR I IN 1..p_search_list.COUNT LOOP
6262: IF p_search_ctx THEN
6263: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
6264: x_stage_list(I).TX6 :=
6265: HZ_TRANS_PKG.CLEANSED_EMAIL(
6266: p_search_list(I).EMAIL_ADDRESS
6267: ,null,'EMAIL_ADDRESS'
6268: ,'CONTACT_POINTS','SEARCH');
6269: ELSE

Line 6274: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(

6270: x_stage_list(I).TX6 := '';
6271: END IF;
6272: ELSE
6273: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
6274: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(
6275: x_stage_list(I).TX6
6276: ,null,'EMAIL_ADDRESS'
6277: ,'CONTACT_POINTS','SCORE');
6278: IF tmp IS NOT NULL THEN

Line 6288: HZ_TRANS_PKG.EXACT_EMAIL(

6284: FOR I IN 1..p_search_list.COUNT LOOP
6285: IF p_search_ctx THEN
6286: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
6287: x_stage_list(I).TX5 :=
6288: HZ_TRANS_PKG.EXACT_EMAIL(
6289: p_search_list(I).EMAIL_ADDRESS
6290: ,null,'EMAIL_ADDRESS'
6291: ,'CONTACT_POINTS');
6292: ELSE

Line 6301: HZ_TRANS_PKG.RM_SPLCHAR_CTX(

6297: FOR I IN 1..p_search_list.COUNT LOOP
6298: IF p_search_ctx THEN
6299: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
6300: x_stage_list(I).TX1 :=
6301: HZ_TRANS_PKG.RM_SPLCHAR_CTX(
6302: p_search_list(I).FLEX_FORMAT_PHONE_NUMBER
6303: ,null,'FLEX_FORMAT_PHONE_NUMBER'
6304: ,'CONTACT_POINTS','SEARCH');
6305: ELSE

Line 6310: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(

6306: x_stage_list(I).TX1 := '';
6307: END IF;
6308: ELSE
6309: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
6310: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(
6311: x_stage_list(I).TX1
6312: ,null,'FLEX_FORMAT_PHONE_NUMBER'
6313: ,'CONTACT_POINTS','SCORE');
6314: IF tmp IS NOT NULL THEN