APPS.HZ_MATCH_RULE_98 dependencies on HZ_TRANS_PKG

Line 633: HZ_TRANS_PKG.clear_globals;

629: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
630: 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);
631: END IF;
632: -- Transform search criteria
633: HZ_TRANS_PKG.clear_globals;
634: MAP_PARTY_REC(FALSE,p_party_search_rec, l_dummy, g_party_stage_rec);
635: MAP_PARTY_SITE_REC(FALSE,p_party_site_list, l_dummy, g_party_site_stage_list);
636: MAP_CONTACT_REC(FALSE,p_contact_list, l_dummy, g_contact_stage_list);
637: MAP_CONTACT_POINT_REC(FALSE,p_contact_point_list, l_dummy, g_contact_pt_stage_list);

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

686: g_contact_pt_stage_list.DELETE;
687: call_order.DELETE;
688: call_max_score.DELETE;
689: HZ_DQM_SEARCH_UTIL.new_search;
690: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
691: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
692:
693: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
694: 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 3070: HZ_TRANS_PKG.EXACT(

3066: /********************* Find Parties private procedures *******/
3067: PROCEDURE set_person_party_type IS
3068: BEGIN
3069: g_party_stage_rec.TX36:=
3070: HZ_TRANS_PKG.EXACT(
3071: 'PERSON'
3072: ,null,'PARTY_TYPE'
3073: ,'PARTY');
3074: END;

Line 5744: HZ_TRANS_PKG.WRNAMES_CLEANSE(

5740: END IF;
5741: IF p_search_ctx THEN
5742: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
5743: x_stage_rec.TX40 :=
5744: HZ_TRANS_PKG.WRNAMES_CLEANSE(
5745: p_search_rec.PARTY_ALL_NAMES
5746: ,null,'PARTY_ALL_NAMES'
5747: ,'PARTY','SEARCH');
5748: ELSE

Line 5753: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

5749: x_stage_rec.TX40 := '';
5750: END IF;
5751: ELSE
5752: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
5753: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
5754: x_stage_rec.TX40
5755: ,null,'PARTY_ALL_NAMES'
5756: ,'PARTY','SCORE');
5757: IF tmp IS NOT NULL THEN

Line 5765: HZ_TRANS_PKG.WRNAMES_EXACT(

5761: END IF;
5762: IF p_search_ctx THEN
5763: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
5764: x_stage_rec.TX39 :=
5765: HZ_TRANS_PKG.WRNAMES_EXACT(
5766: p_search_rec.PARTY_ALL_NAMES
5767: ,null,'PARTY_ALL_NAMES'
5768: ,'PARTY','SEARCH');
5769: ELSE

Line 5774: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

5770: x_stage_rec.TX39 := '';
5771: END IF;
5772: ELSE
5773: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
5774: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
5775: x_stage_rec.TX39
5776: ,null,'PARTY_ALL_NAMES'
5777: ,'PARTY','SCORE');
5778: IF tmp IS NOT NULL THEN

Line 5786: HZ_TRANS_PKG.EXACT(

5782: END IF;
5783: IF p_search_ctx THEN
5784: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
5785: x_stage_rec.TX36 :=
5786: HZ_TRANS_PKG.EXACT(
5787: p_search_rec.PARTY_TYPE
5788: ,null,'PARTY_TYPE'
5789: ,'PARTY');
5790: ELSE

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

5795: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
5796: l_party_name := p_search_rec.PARTY_ALL_NAMES;
5797: END IF;
5798: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
5799: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
5800: END IF;
5801: EXCEPTION
5802: WHEN OTHERS THEN
5803: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 5892: HZ_TRANS_PKG.EXACT(

5888: FOR I IN 1..p_search_list.COUNT LOOP
5889: IF p_search_ctx THEN
5890: IF p_search_list(I).JOB_TITLE IS NOT NULL THEN
5891: x_stage_list(I).TX22 :=
5892: HZ_TRANS_PKG.EXACT(
5893: p_search_list(I).JOB_TITLE
5894: ,null,'JOB_TITLE'
5895: ,'CONTACTS');
5896: ELSE

Line 5977: HZ_TRANS_PKG.CLEANSED_EMAIL(

5973: FOR I IN 1..p_search_list.COUNT LOOP
5974: IF p_search_ctx THEN
5975: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
5976: x_stage_list(I).TX6 :=
5977: HZ_TRANS_PKG.CLEANSED_EMAIL(
5978: p_search_list(I).EMAIL_ADDRESS
5979: ,null,'EMAIL_ADDRESS'
5980: ,'CONTACT_POINTS','SEARCH');
5981: ELSE

Line 5986: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(

5982: x_stage_list(I).TX6 := '';
5983: END IF;
5984: ELSE
5985: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
5986: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(
5987: x_stage_list(I).TX6
5988: ,null,'EMAIL_ADDRESS'
5989: ,'CONTACT_POINTS','SCORE');
5990: IF tmp IS NOT NULL THEN

Line 6000: HZ_TRANS_PKG.EXACT_EMAIL(

5996: FOR I IN 1..p_search_list.COUNT LOOP
5997: IF p_search_ctx THEN
5998: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
5999: x_stage_list(I).TX5 :=
6000: HZ_TRANS_PKG.EXACT_EMAIL(
6001: p_search_list(I).EMAIL_ADDRESS
6002: ,null,'EMAIL_ADDRESS'
6003: ,'CONTACT_POINTS');
6004: ELSE

Line 6013: HZ_TRANS_PKG.RM_SPLCHAR_CTX(

6009: FOR I IN 1..p_search_list.COUNT LOOP
6010: IF p_search_ctx THEN
6011: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
6012: x_stage_list(I).TX1 :=
6013: HZ_TRANS_PKG.RM_SPLCHAR_CTX(
6014: p_search_list(I).FLEX_FORMAT_PHONE_NUMBER
6015: ,null,'FLEX_FORMAT_PHONE_NUMBER'
6016: ,'CONTACT_POINTS','SEARCH');
6017: ELSE

Line 6022: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(

6018: x_stage_list(I).TX1 := '';
6019: END IF;
6020: ELSE
6021: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
6022: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(
6023: x_stage_list(I).TX1
6024: ,null,'FLEX_FORMAT_PHONE_NUMBER'
6025: ,'CONTACT_POINTS','SCORE');
6026: IF tmp IS NOT NULL THEN