DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_58 dependencies on HZ_TRANS_PKG

Line 784: HZ_TRANS_PKG.clear_globals;

780: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
781: 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);
782: END IF;
783: -- Transform search criteria
784: HZ_TRANS_PKG.clear_globals;
785: MAP_PARTY_REC(FALSE,p_party_search_rec, l_dummy, g_party_stage_rec);
786: MAP_PARTY_SITE_REC(FALSE,p_party_site_list, l_dummy, g_party_site_stage_list);
787: MAP_CONTACT_REC(FALSE,p_contact_list, l_dummy, g_contact_stage_list);
788: MAP_CONTACT_POINT_REC(FALSE,p_contact_point_list, l_dummy, g_contact_pt_stage_list);

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

837: g_contact_pt_stage_list.DELETE;
838: call_order.DELETE;
839: call_max_score.DELETE;
840: HZ_DQM_SEARCH_UTIL.new_search;
841: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
842: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
843:
844: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
845: 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 3304: HZ_TRANS_PKG.EXACT(

3300: /********************* Find Parties private procedures *******/
3301: PROCEDURE set_person_party_type IS
3302: BEGIN
3303: g_party_stage_rec.TX36:=
3304: HZ_TRANS_PKG.EXACT(
3305: 'PERSON'
3306: ,null,'PARTY_TYPE'
3307: ,'PARTY');
3308: END;

Line 6046: HZ_TRANS_PKG.RM_SPLCHAR(

6042: END IF;
6043: IF p_search_ctx THEN
6044: IF p_search_rec.ALL_ACCOUNT_NUMBERS IS NOT NULL THEN
6045: x_stage_rec.TX35 :=
6046: HZ_TRANS_PKG.RM_SPLCHAR(
6047: p_search_rec.ALL_ACCOUNT_NUMBERS
6048: ,null,'ALL_ACCOUNT_NUMBERS'
6049: ,'PARTY','SEARCH');
6050: ELSE

Line 6055: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6051: x_stage_rec.TX35 := '';
6052: END IF;
6053: ELSE
6054: IF p_search_rec.ALL_ACCOUNT_NUMBERS IS NOT NULL THEN
6055: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6056: x_stage_rec.TX35
6057: ,null,'ALL_ACCOUNT_NUMBERS'
6058: ,'PARTY','SCORE');
6059: IF tmp IS NOT NULL THEN

Line 6067: HZ_TRANS_PKG.RM_SPLCHAR(

6063: END IF;
6064: IF p_search_ctx THEN
6065: IF p_search_rec.JGZZ_FISCAL_CODE IS NOT NULL THEN
6066: x_stage_rec.TX45 :=
6067: HZ_TRANS_PKG.RM_SPLCHAR(
6068: p_search_rec.JGZZ_FISCAL_CODE
6069: ,null,'JGZZ_FISCAL_CODE'
6070: ,'PARTY','SEARCH');
6071: ELSE

Line 6076: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6072: x_stage_rec.TX45 := '';
6073: END IF;
6074: ELSE
6075: IF p_search_rec.JGZZ_FISCAL_CODE IS NOT NULL THEN
6076: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6077: x_stage_rec.TX45
6078: ,null,'JGZZ_FISCAL_CODE'
6079: ,'PARTY','SCORE');
6080: IF tmp IS NOT NULL THEN

Line 6088: HZ_TRANS_PKG.WRNAMES_CLEANSE(

6084: END IF;
6085: IF p_search_ctx THEN
6086: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6087: x_stage_rec.TX40 :=
6088: HZ_TRANS_PKG.WRNAMES_CLEANSE(
6089: p_search_rec.PARTY_ALL_NAMES
6090: ,null,'PARTY_ALL_NAMES'
6091: ,'PARTY','SEARCH');
6092: ELSE

Line 6097: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

6093: x_stage_rec.TX40 := '';
6094: END IF;
6095: ELSE
6096: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6097: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
6098: x_stage_rec.TX40
6099: ,null,'PARTY_ALL_NAMES'
6100: ,'PARTY','SCORE');
6101: IF tmp IS NOT NULL THEN

Line 6109: HZ_TRANS_PKG.WRNAMES_EXACT(

6105: END IF;
6106: IF p_search_ctx THEN
6107: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6108: x_stage_rec.TX39 :=
6109: HZ_TRANS_PKG.WRNAMES_EXACT(
6110: p_search_rec.PARTY_ALL_NAMES
6111: ,null,'PARTY_ALL_NAMES'
6112: ,'PARTY','SEARCH');
6113: ELSE

Line 6118: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

6114: x_stage_rec.TX39 := '';
6115: END IF;
6116: ELSE
6117: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6118: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
6119: x_stage_rec.TX39
6120: ,null,'PARTY_ALL_NAMES'
6121: ,'PARTY','SCORE');
6122: IF tmp IS NOT NULL THEN

Line 6130: HZ_TRANS_PKG.RM_SPLCHAR(

6126: END IF;
6127: IF p_search_ctx THEN
6128: IF p_search_rec.PARTY_NUMBER IS NOT NULL THEN
6129: x_stage_rec.TX34 :=
6130: HZ_TRANS_PKG.RM_SPLCHAR(
6131: p_search_rec.PARTY_NUMBER
6132: ,null,'PARTY_NUMBER'
6133: ,'PARTY','SEARCH');
6134: ELSE

Line 6139: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6135: x_stage_rec.TX34 := '';
6136: END IF;
6137: ELSE
6138: IF p_search_rec.PARTY_NUMBER IS NOT NULL THEN
6139: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6140: x_stage_rec.TX34
6141: ,null,'PARTY_NUMBER'
6142: ,'PARTY','SCORE');
6143: IF tmp IS NOT NULL THEN

Line 6151: HZ_TRANS_PKG.EXACT(

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

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

6160: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6161: l_party_name := p_search_rec.PARTY_ALL_NAMES;
6162: END IF;
6163: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
6164: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
6165: END IF;
6166: EXCEPTION
6167: WHEN OTHERS THEN
6168: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 6257: HZ_TRANS_PKG.EXACT(

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

Line 6342: HZ_TRANS_PKG.CLEANSED_EMAIL(

6338: FOR I IN 1..p_search_list.COUNT LOOP
6339: IF p_search_ctx THEN
6340: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
6341: x_stage_list(I).TX6 :=
6342: HZ_TRANS_PKG.CLEANSED_EMAIL(
6343: p_search_list(I).EMAIL_ADDRESS
6344: ,null,'EMAIL_ADDRESS'
6345: ,'CONTACT_POINTS','SEARCH');
6346: ELSE

Line 6351: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(

6347: x_stage_list(I).TX6 := '';
6348: END IF;
6349: ELSE
6350: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
6351: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(
6352: x_stage_list(I).TX6
6353: ,null,'EMAIL_ADDRESS'
6354: ,'CONTACT_POINTS','SCORE');
6355: IF tmp IS NOT NULL THEN

Line 6365: HZ_TRANS_PKG.EXACT_EMAIL(

6361: FOR I IN 1..p_search_list.COUNT LOOP
6362: IF p_search_ctx THEN
6363: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
6364: x_stage_list(I).TX5 :=
6365: HZ_TRANS_PKG.EXACT_EMAIL(
6366: p_search_list(I).EMAIL_ADDRESS
6367: ,null,'EMAIL_ADDRESS'
6368: ,'CONTACT_POINTS');
6369: ELSE

Line 6378: HZ_TRANS_PKG.RM_SPLCHAR_CTX(

6374: FOR I IN 1..p_search_list.COUNT LOOP
6375: IF p_search_ctx THEN
6376: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
6377: x_stage_list(I).TX1 :=
6378: HZ_TRANS_PKG.RM_SPLCHAR_CTX(
6379: p_search_list(I).FLEX_FORMAT_PHONE_NUMBER
6380: ,null,'FLEX_FORMAT_PHONE_NUMBER'
6381: ,'CONTACT_POINTS','SEARCH');
6382: ELSE

Line 6387: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(

6383: x_stage_list(I).TX1 := '';
6384: END IF;
6385: ELSE
6386: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
6387: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(
6388: x_stage_list(I).TX1
6389: ,null,'FLEX_FORMAT_PHONE_NUMBER'
6390: ,'CONTACT_POINTS','SCORE');
6391: IF tmp IS NOT NULL THEN