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

3250: /********************* Find Parties private procedures *******/
3251: PROCEDURE set_person_party_type IS
3252: BEGIN
3253: g_party_stage_rec.TX36:=
3254: HZ_TRANS_PKG.EXACT(
3255: 'PERSON'
3256: ,null,'PARTY_TYPE'
3257: ,'PARTY');
3258: END;

Line 5941: HZ_TRANS_PKG.RM_SPLCHAR(

5937: END IF;
5938: IF p_search_ctx THEN
5939: IF p_search_rec.ALL_ACCOUNT_NUMBERS IS NOT NULL THEN
5940: x_stage_rec.TX35 :=
5941: HZ_TRANS_PKG.RM_SPLCHAR(
5942: p_search_rec.ALL_ACCOUNT_NUMBERS
5943: ,null,'ALL_ACCOUNT_NUMBERS'
5944: ,'PARTY','SEARCH');
5945: ELSE

Line 5950: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

5946: x_stage_rec.TX35 := '';
5947: END IF;
5948: ELSE
5949: IF p_search_rec.ALL_ACCOUNT_NUMBERS IS NOT NULL THEN
5950: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
5951: x_stage_rec.TX35
5952: ,null,'ALL_ACCOUNT_NUMBERS'
5953: ,'PARTY','SCORE');
5954: IF tmp IS NOT NULL THEN

Line 5962: HZ_TRANS_PKG.EXACT(

5958: END IF;
5959: IF p_search_ctx THEN
5960: IF p_search_rec.DUNS_NUMBER_C IS NOT NULL THEN
5961: x_stage_rec.TX41 :=
5962: HZ_TRANS_PKG.EXACT(
5963: p_search_rec.DUNS_NUMBER_C
5964: ,null,'DUNS_NUMBER_C'
5965: ,'PARTY');
5966: ELSE

Line 5977: HZ_TRANS_PKG.RM_SPLCHAR(

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

Line 5986: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

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

Line 5998: HZ_TRANS_PKG.WRNAMES_CLEANSE(

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

Line 6007: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

6003: x_stage_rec.TX40 := '';
6004: END IF;
6005: ELSE
6006: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6007: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
6008: x_stage_rec.TX40
6009: ,null,'PARTY_ALL_NAMES'
6010: ,'PARTY','SCORE');
6011: IF tmp IS NOT NULL THEN

Line 6019: HZ_TRANS_PKG.WRNAMES_EXACT(

6015: END IF;
6016: IF p_search_ctx THEN
6017: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6018: x_stage_rec.TX39 :=
6019: HZ_TRANS_PKG.WRNAMES_EXACT(
6020: p_search_rec.PARTY_ALL_NAMES
6021: ,null,'PARTY_ALL_NAMES'
6022: ,'PARTY','SEARCH');
6023: ELSE

Line 6028: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

6024: x_stage_rec.TX39 := '';
6025: END IF;
6026: ELSE
6027: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6028: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
6029: x_stage_rec.TX39
6030: ,null,'PARTY_ALL_NAMES'
6031: ,'PARTY','SCORE');
6032: IF tmp IS NOT NULL THEN

Line 6040: HZ_TRANS_PKG.RM_SPLCHAR(

6036: END IF;
6037: IF p_search_ctx THEN
6038: IF p_search_rec.PARTY_NUMBER IS NOT NULL THEN
6039: x_stage_rec.TX34 :=
6040: HZ_TRANS_PKG.RM_SPLCHAR(
6041: p_search_rec.PARTY_NUMBER
6042: ,null,'PARTY_NUMBER'
6043: ,'PARTY','SEARCH');
6044: ELSE

Line 6049: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6045: x_stage_rec.TX34 := '';
6046: END IF;
6047: ELSE
6048: IF p_search_rec.PARTY_NUMBER IS NOT NULL THEN
6049: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6050: x_stage_rec.TX34
6051: ,null,'PARTY_NUMBER'
6052: ,'PARTY','SCORE');
6053: IF tmp IS NOT NULL THEN

Line 6061: HZ_TRANS_PKG.EXACT(

6057: END IF;
6058: IF p_search_ctx THEN
6059: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
6060: x_stage_rec.TX36 :=
6061: HZ_TRANS_PKG.EXACT(
6062: p_search_rec.PARTY_TYPE
6063: ,null,'PARTY_TYPE'
6064: ,'PARTY');
6065: ELSE

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

6070: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6071: l_party_name := p_search_rec.PARTY_ALL_NAMES;
6072: END IF;
6073: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
6074: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
6075: END IF;
6076: EXCEPTION
6077: WHEN OTHERS THEN
6078: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 6234: HZ_TRANS_PKG.CLEANSED_URL(

6230: FOR I IN 1..p_search_list.COUNT LOOP
6231: IF p_search_ctx THEN
6232: IF p_search_list(I).URL IS NOT NULL THEN
6233: x_stage_list(I).TX8 :=
6234: HZ_TRANS_PKG.CLEANSED_URL(
6235: p_search_list(I).URL
6236: ,null,'URL'
6237: ,'CONTACT_POINTS','SEARCH');
6238: ELSE

Line 6243: tmp := HZ_TRANS_PKG.CLEANSED_URL(

6239: x_stage_list(I).TX8 := '';
6240: END IF;
6241: ELSE
6242: IF p_search_list(I).URL IS NOT NULL THEN
6243: tmp := HZ_TRANS_PKG.CLEANSED_URL(
6244: x_stage_list(I).TX8
6245: ,null,'URL'
6246: ,'CONTACT_POINTS','SCORE');
6247: IF tmp IS NOT NULL THEN

Line 6257: HZ_TRANS_PKG.EXACT_URL(

6253: FOR I IN 1..p_search_list.COUNT LOOP
6254: IF p_search_ctx THEN
6255: IF p_search_list(I).URL IS NOT NULL THEN
6256: x_stage_list(I).TX7 :=
6257: HZ_TRANS_PKG.EXACT_URL(
6258: p_search_list(I).URL
6259: ,null,'URL'
6260: ,'CONTACT_POINTS');
6261: ELSE