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

3295: /********************* Find Parties private procedures *******/
3296: PROCEDURE set_person_party_type IS
3297: BEGIN
3298: g_party_stage_rec.TX36:=
3299: HZ_TRANS_PKG.EXACT(
3300: 'PERSON'
3301: ,null,'PARTY_TYPE'
3302: ,'PARTY');
3303: END;

Line 6035: HZ_TRANS_PKG.RM_SPLCHAR(

6031: END IF;
6032: IF p_search_ctx THEN
6033: IF p_search_rec.ALL_ACCOUNT_NUMBERS IS NOT NULL THEN
6034: x_stage_rec.TX35 :=
6035: HZ_TRANS_PKG.RM_SPLCHAR(
6036: p_search_rec.ALL_ACCOUNT_NUMBERS
6037: ,null,'ALL_ACCOUNT_NUMBERS'
6038: ,'PARTY','SEARCH');
6039: ELSE

Line 6044: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6040: x_stage_rec.TX35 := '';
6041: END IF;
6042: ELSE
6043: IF p_search_rec.ALL_ACCOUNT_NUMBERS IS NOT NULL THEN
6044: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6045: x_stage_rec.TX35
6046: ,null,'ALL_ACCOUNT_NUMBERS'
6047: ,'PARTY','SCORE');
6048: IF tmp IS NOT NULL THEN

Line 6056: HZ_TRANS_PKG.RM_SPLCHAR(

6052: END IF;
6053: IF p_search_ctx THEN
6054: IF p_search_rec.JGZZ_FISCAL_CODE IS NOT NULL THEN
6055: x_stage_rec.TX45 :=
6056: HZ_TRANS_PKG.RM_SPLCHAR(
6057: p_search_rec.JGZZ_FISCAL_CODE
6058: ,null,'JGZZ_FISCAL_CODE'
6059: ,'PARTY','SEARCH');
6060: ELSE

Line 6065: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6061: x_stage_rec.TX45 := '';
6062: END IF;
6063: ELSE
6064: IF p_search_rec.JGZZ_FISCAL_CODE IS NOT NULL THEN
6065: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6066: x_stage_rec.TX45
6067: ,null,'JGZZ_FISCAL_CODE'
6068: ,'PARTY','SCORE');
6069: IF tmp IS NOT NULL THEN

Line 6077: HZ_TRANS_PKG.WRNAMES_CLEANSE(

6073: END IF;
6074: IF p_search_ctx THEN
6075: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6076: x_stage_rec.TX40 :=
6077: HZ_TRANS_PKG.WRNAMES_CLEANSE(
6078: p_search_rec.PARTY_ALL_NAMES
6079: ,null,'PARTY_ALL_NAMES'
6080: ,'PARTY','SEARCH');
6081: ELSE

Line 6086: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

6082: x_stage_rec.TX40 := '';
6083: END IF;
6084: ELSE
6085: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6086: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
6087: x_stage_rec.TX40
6088: ,null,'PARTY_ALL_NAMES'
6089: ,'PARTY','SCORE');
6090: IF tmp IS NOT NULL THEN

Line 6098: HZ_TRANS_PKG.WRNAMES_EXACT(

6094: END IF;
6095: IF p_search_ctx THEN
6096: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6097: x_stage_rec.TX39 :=
6098: HZ_TRANS_PKG.WRNAMES_EXACT(
6099: p_search_rec.PARTY_ALL_NAMES
6100: ,null,'PARTY_ALL_NAMES'
6101: ,'PARTY','SEARCH');
6102: ELSE

Line 6107: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

6103: x_stage_rec.TX39 := '';
6104: END IF;
6105: ELSE
6106: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6107: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
6108: x_stage_rec.TX39
6109: ,null,'PARTY_ALL_NAMES'
6110: ,'PARTY','SCORE');
6111: IF tmp IS NOT NULL THEN

Line 6119: HZ_TRANS_PKG.RM_SPLCHAR(

6115: END IF;
6116: IF p_search_ctx THEN
6117: IF p_search_rec.PARTY_NUMBER IS NOT NULL THEN
6118: x_stage_rec.TX34 :=
6119: HZ_TRANS_PKG.RM_SPLCHAR(
6120: p_search_rec.PARTY_NUMBER
6121: ,null,'PARTY_NUMBER'
6122: ,'PARTY','SEARCH');
6123: ELSE

Line 6128: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6124: x_stage_rec.TX34 := '';
6125: END IF;
6126: ELSE
6127: IF p_search_rec.PARTY_NUMBER IS NOT NULL THEN
6128: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6129: x_stage_rec.TX34
6130: ,null,'PARTY_NUMBER'
6131: ,'PARTY','SCORE');
6132: IF tmp IS NOT NULL THEN

Line 6140: HZ_TRANS_PKG.EXACT(

6136: END IF;
6137: IF p_search_ctx THEN
6138: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
6139: x_stage_rec.TX36 :=
6140: HZ_TRANS_PKG.EXACT(
6141: p_search_rec.PARTY_TYPE
6142: ,null,'PARTY_TYPE'
6143: ,'PARTY');
6144: ELSE

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

6149: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6150: l_party_name := p_search_rec.PARTY_ALL_NAMES;
6151: END IF;
6152: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
6153: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
6154: END IF;
6155: EXCEPTION
6156: WHEN OTHERS THEN
6157: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 6246: HZ_TRANS_PKG.EXACT(

6242: FOR I IN 1..p_search_list.COUNT LOOP
6243: IF p_search_ctx THEN
6244: IF p_search_list(I).JOB_TITLE IS NOT NULL THEN
6245: x_stage_list(I).TX22 :=
6246: HZ_TRANS_PKG.EXACT(
6247: p_search_list(I).JOB_TITLE
6248: ,null,'JOB_TITLE'
6249: ,'CONTACTS');
6250: ELSE

Line 6331: HZ_TRANS_PKG.CLEANSED_EMAIL(

6327: FOR I IN 1..p_search_list.COUNT LOOP
6328: IF p_search_ctx THEN
6329: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
6330: x_stage_list(I).TX6 :=
6331: HZ_TRANS_PKG.CLEANSED_EMAIL(
6332: p_search_list(I).EMAIL_ADDRESS
6333: ,null,'EMAIL_ADDRESS'
6334: ,'CONTACT_POINTS','SEARCH');
6335: ELSE

Line 6340: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(

6336: x_stage_list(I).TX6 := '';
6337: END IF;
6338: ELSE
6339: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
6340: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(
6341: x_stage_list(I).TX6
6342: ,null,'EMAIL_ADDRESS'
6343: ,'CONTACT_POINTS','SCORE');
6344: IF tmp IS NOT NULL THEN

Line 6354: HZ_TRANS_PKG.EXACT_EMAIL(

6350: FOR I IN 1..p_search_list.COUNT LOOP
6351: IF p_search_ctx THEN
6352: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
6353: x_stage_list(I).TX5 :=
6354: HZ_TRANS_PKG.EXACT_EMAIL(
6355: p_search_list(I).EMAIL_ADDRESS
6356: ,null,'EMAIL_ADDRESS'
6357: ,'CONTACT_POINTS');
6358: ELSE

Line 6367: HZ_TRANS_PKG.RM_SPLCHAR_CTX(

6363: FOR I IN 1..p_search_list.COUNT LOOP
6364: IF p_search_ctx THEN
6365: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
6366: x_stage_list(I).TX1 :=
6367: HZ_TRANS_PKG.RM_SPLCHAR_CTX(
6368: p_search_list(I).FLEX_FORMAT_PHONE_NUMBER
6369: ,null,'FLEX_FORMAT_PHONE_NUMBER'
6370: ,'CONTACT_POINTS','SEARCH');
6371: ELSE

Line 6376: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(

6372: x_stage_list(I).TX1 := '';
6373: END IF;
6374: ELSE
6375: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
6376: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(
6377: x_stage_list(I).TX1
6378: ,null,'FLEX_FORMAT_PHONE_NUMBER'
6379: ,'CONTACT_POINTS','SCORE');
6380: IF tmp IS NOT NULL THEN