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

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

Line 5749: HZ_TRANS_PKG.WRNAMES_CLEANSE(

5745: END IF;
5746: IF p_search_ctx THEN
5747: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
5748: x_stage_rec.TX40 :=
5749: HZ_TRANS_PKG.WRNAMES_CLEANSE(
5750: p_search_rec.PARTY_ALL_NAMES
5751: ,null,'PARTY_ALL_NAMES'
5752: ,'PARTY','SEARCH');
5753: ELSE

Line 5758: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

5754: x_stage_rec.TX40 := '';
5755: END IF;
5756: ELSE
5757: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
5758: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
5759: x_stage_rec.TX40
5760: ,null,'PARTY_ALL_NAMES'
5761: ,'PARTY','SCORE');
5762: IF tmp IS NOT NULL THEN

Line 5770: HZ_TRANS_PKG.WRNAMES_EXACT(

5766: END IF;
5767: IF p_search_ctx THEN
5768: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
5769: x_stage_rec.TX39 :=
5770: HZ_TRANS_PKG.WRNAMES_EXACT(
5771: p_search_rec.PARTY_ALL_NAMES
5772: ,null,'PARTY_ALL_NAMES'
5773: ,'PARTY','SEARCH');
5774: ELSE

Line 5779: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

5775: x_stage_rec.TX39 := '';
5776: END IF;
5777: ELSE
5778: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
5779: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
5780: x_stage_rec.TX39
5781: ,null,'PARTY_ALL_NAMES'
5782: ,'PARTY','SCORE');
5783: IF tmp IS NOT NULL THEN

Line 5791: HZ_TRANS_PKG.EXACT(

5787: END IF;
5788: IF p_search_ctx THEN
5789: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
5790: x_stage_rec.TX36 :=
5791: HZ_TRANS_PKG.EXACT(
5792: p_search_rec.PARTY_TYPE
5793: ,null,'PARTY_TYPE'
5794: ,'PARTY');
5795: ELSE

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

5800: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
5801: l_party_name := p_search_rec.PARTY_ALL_NAMES;
5802: END IF;
5803: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
5804: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
5805: END IF;
5806: EXCEPTION
5807: WHEN OTHERS THEN
5808: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 5897: HZ_TRANS_PKG.EXACT(

5893: FOR I IN 1..p_search_list.COUNT LOOP
5894: IF p_search_ctx THEN
5895: IF p_search_list(I).JOB_TITLE IS NOT NULL THEN
5896: x_stage_list(I).TX22 :=
5897: HZ_TRANS_PKG.EXACT(
5898: p_search_list(I).JOB_TITLE
5899: ,null,'JOB_TITLE'
5900: ,'CONTACTS');
5901: ELSE

Line 5982: HZ_TRANS_PKG.CLEANSED_EMAIL(

5978: FOR I IN 1..p_search_list.COUNT LOOP
5979: IF p_search_ctx THEN
5980: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
5981: x_stage_list(I).TX6 :=
5982: HZ_TRANS_PKG.CLEANSED_EMAIL(
5983: p_search_list(I).EMAIL_ADDRESS
5984: ,null,'EMAIL_ADDRESS'
5985: ,'CONTACT_POINTS','SEARCH');
5986: ELSE

Line 5991: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(

5987: x_stage_list(I).TX6 := '';
5988: END IF;
5989: ELSE
5990: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
5991: tmp := HZ_TRANS_PKG.CLEANSED_EMAIL(
5992: x_stage_list(I).TX6
5993: ,null,'EMAIL_ADDRESS'
5994: ,'CONTACT_POINTS','SCORE');
5995: IF tmp IS NOT NULL THEN

Line 6005: HZ_TRANS_PKG.EXACT_EMAIL(

6001: FOR I IN 1..p_search_list.COUNT LOOP
6002: IF p_search_ctx THEN
6003: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
6004: x_stage_list(I).TX5 :=
6005: HZ_TRANS_PKG.EXACT_EMAIL(
6006: p_search_list(I).EMAIL_ADDRESS
6007: ,null,'EMAIL_ADDRESS'
6008: ,'CONTACT_POINTS');
6009: ELSE

Line 6018: HZ_TRANS_PKG.RM_SPLCHAR_CTX(

6014: FOR I IN 1..p_search_list.COUNT LOOP
6015: IF p_search_ctx THEN
6016: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
6017: x_stage_list(I).TX1 :=
6018: HZ_TRANS_PKG.RM_SPLCHAR_CTX(
6019: p_search_list(I).FLEX_FORMAT_PHONE_NUMBER
6020: ,null,'FLEX_FORMAT_PHONE_NUMBER'
6021: ,'CONTACT_POINTS','SEARCH');
6022: ELSE

Line 6027: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(

6023: x_stage_list(I).TX1 := '';
6024: END IF;
6025: ELSE
6026: IF p_search_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL THEN
6027: tmp := HZ_TRANS_PKG.RM_SPLCHAR_CTX(
6028: x_stage_list(I).TX1
6029: ,null,'FLEX_FORMAT_PHONE_NUMBER'
6030: ,'CONTACT_POINTS','SCORE');
6031: IF tmp IS NOT NULL THEN