DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_61 dependencies on HZ_TRANS_PKG

Line 749: HZ_TRANS_PKG.clear_globals;

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

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

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

3255: /********************* Find Parties private procedures *******/
3256: PROCEDURE set_person_party_type IS
3257: BEGIN
3258: g_party_stage_rec.TX36:=
3259: HZ_TRANS_PKG.EXACT(
3260: 'PERSON'
3261: ,null,'PARTY_TYPE'
3262: ,'PARTY');
3263: END;

Line 5952: HZ_TRANS_PKG.RM_SPLCHAR(

5948: END IF;
5949: IF p_search_ctx THEN
5950: IF p_search_rec.ALL_ACCOUNT_NUMBERS IS NOT NULL THEN
5951: x_stage_rec.TX35 :=
5952: HZ_TRANS_PKG.RM_SPLCHAR(
5953: p_search_rec.ALL_ACCOUNT_NUMBERS
5954: ,null,'ALL_ACCOUNT_NUMBERS'
5955: ,'PARTY','SEARCH');
5956: ELSE

Line 5961: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

5957: x_stage_rec.TX35 := '';
5958: END IF;
5959: ELSE
5960: IF p_search_rec.ALL_ACCOUNT_NUMBERS IS NOT NULL THEN
5961: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
5962: x_stage_rec.TX35
5963: ,null,'ALL_ACCOUNT_NUMBERS'
5964: ,'PARTY','SCORE');
5965: IF tmp IS NOT NULL THEN

Line 5973: HZ_TRANS_PKG.EXACT(

5969: END IF;
5970: IF p_search_ctx THEN
5971: IF p_search_rec.DUNS_NUMBER_C IS NOT NULL THEN
5972: x_stage_rec.TX41 :=
5973: HZ_TRANS_PKG.EXACT(
5974: p_search_rec.DUNS_NUMBER_C
5975: ,null,'DUNS_NUMBER_C'
5976: ,'PARTY');
5977: ELSE

Line 5988: HZ_TRANS_PKG.RM_SPLCHAR(

5984: END IF;
5985: IF p_search_ctx THEN
5986: IF p_search_rec.JGZZ_FISCAL_CODE IS NOT NULL THEN
5987: x_stage_rec.TX45 :=
5988: HZ_TRANS_PKG.RM_SPLCHAR(
5989: p_search_rec.JGZZ_FISCAL_CODE
5990: ,null,'JGZZ_FISCAL_CODE'
5991: ,'PARTY','SEARCH');
5992: ELSE

Line 5997: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

5993: x_stage_rec.TX45 := '';
5994: END IF;
5995: ELSE
5996: IF p_search_rec.JGZZ_FISCAL_CODE IS NOT NULL THEN
5997: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
5998: x_stage_rec.TX45
5999: ,null,'JGZZ_FISCAL_CODE'
6000: ,'PARTY','SCORE');
6001: IF tmp IS NOT NULL THEN

Line 6009: HZ_TRANS_PKG.WRNAMES_CLEANSE(

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

Line 6018: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

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

Line 6030: HZ_TRANS_PKG.WRNAMES_EXACT(

6026: END IF;
6027: IF p_search_ctx THEN
6028: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6029: x_stage_rec.TX39 :=
6030: HZ_TRANS_PKG.WRNAMES_EXACT(
6031: p_search_rec.PARTY_ALL_NAMES
6032: ,null,'PARTY_ALL_NAMES'
6033: ,'PARTY','SEARCH');
6034: ELSE

Line 6039: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

6035: x_stage_rec.TX39 := '';
6036: END IF;
6037: ELSE
6038: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6039: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
6040: x_stage_rec.TX39
6041: ,null,'PARTY_ALL_NAMES'
6042: ,'PARTY','SCORE');
6043: IF tmp IS NOT NULL THEN

Line 6051: HZ_TRANS_PKG.RM_SPLCHAR(

6047: END IF;
6048: IF p_search_ctx THEN
6049: IF p_search_rec.PARTY_NUMBER IS NOT NULL THEN
6050: x_stage_rec.TX34 :=
6051: HZ_TRANS_PKG.RM_SPLCHAR(
6052: p_search_rec.PARTY_NUMBER
6053: ,null,'PARTY_NUMBER'
6054: ,'PARTY','SEARCH');
6055: ELSE

Line 6060: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6056: x_stage_rec.TX34 := '';
6057: END IF;
6058: ELSE
6059: IF p_search_rec.PARTY_NUMBER IS NOT NULL THEN
6060: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6061: x_stage_rec.TX34
6062: ,null,'PARTY_NUMBER'
6063: ,'PARTY','SCORE');
6064: IF tmp IS NOT NULL THEN

Line 6072: HZ_TRANS_PKG.EXACT(

6068: END IF;
6069: IF p_search_ctx THEN
6070: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
6071: x_stage_rec.TX36 :=
6072: HZ_TRANS_PKG.EXACT(
6073: p_search_rec.PARTY_TYPE
6074: ,null,'PARTY_TYPE'
6075: ,'PARTY');
6076: ELSE

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

6081: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6082: l_party_name := p_search_rec.PARTY_ALL_NAMES;
6083: END IF;
6084: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
6085: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
6086: END IF;
6087: EXCEPTION
6088: WHEN OTHERS THEN
6089: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 6245: HZ_TRANS_PKG.CLEANSED_URL(

6241: FOR I IN 1..p_search_list.COUNT LOOP
6242: IF p_search_ctx THEN
6243: IF p_search_list(I).URL IS NOT NULL THEN
6244: x_stage_list(I).TX8 :=
6245: HZ_TRANS_PKG.CLEANSED_URL(
6246: p_search_list(I).URL
6247: ,null,'URL'
6248: ,'CONTACT_POINTS','SEARCH');
6249: ELSE

Line 6254: tmp := HZ_TRANS_PKG.CLEANSED_URL(

6250: x_stage_list(I).TX8 := '';
6251: END IF;
6252: ELSE
6253: IF p_search_list(I).URL IS NOT NULL THEN
6254: tmp := HZ_TRANS_PKG.CLEANSED_URL(
6255: x_stage_list(I).TX8
6256: ,null,'URL'
6257: ,'CONTACT_POINTS','SCORE');
6258: IF tmp IS NOT NULL THEN

Line 6268: HZ_TRANS_PKG.EXACT_URL(

6264: FOR I IN 1..p_search_list.COUNT LOOP
6265: IF p_search_ctx THEN
6266: IF p_search_list(I).URL IS NOT NULL THEN
6267: x_stage_list(I).TX7 :=
6268: HZ_TRANS_PKG.EXACT_URL(
6269: p_search_list(I).URL
6270: ,null,'URL'
6271: ,'CONTACT_POINTS');
6272: ELSE