DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_39 dependencies on HZ_TRANS_PKG

Line 647: HZ_TRANS_PKG.clear_globals;

643: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
644: 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);
645: END IF;
646: -- Transform search criteria
647: HZ_TRANS_PKG.clear_globals;
648: MAP_PARTY_REC(FALSE,p_party_search_rec, l_dummy, g_party_stage_rec);
649: MAP_PARTY_SITE_REC(FALSE,p_party_site_list, l_dummy, g_party_site_stage_list);
650: MAP_CONTACT_REC(FALSE,p_contact_list, l_dummy, g_contact_stage_list);
651: MAP_CONTACT_POINT_REC(FALSE,p_contact_point_list, l_dummy, g_contact_pt_stage_list);

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

700: g_contact_pt_stage_list.DELETE;
701: call_order.DELETE;
702: call_max_score.DELETE;
703: HZ_DQM_SEARCH_UTIL.new_search;
704: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
705: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
706:
707: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
708: 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 3038: HZ_TRANS_PKG.EXACT(

3034: /********************* Find Parties private procedures *******/
3035: PROCEDURE set_person_party_type IS
3036: BEGIN
3037: g_party_stage_rec.TX36:=
3038: HZ_TRANS_PKG.EXACT(
3039: 'PERSON'
3040: ,null,'PARTY_TYPE'
3041: ,'PARTY');
3042: END;

Line 5690: HZ_TRANS_PKG.EXACT(

5686: END IF;
5687: IF p_search_ctx THEN
5688: IF p_search_rec.DUNS_NUMBER_C IS NOT NULL THEN
5689: x_stage_rec.TX41 :=
5690: HZ_TRANS_PKG.EXACT(
5691: p_search_rec.DUNS_NUMBER_C
5692: ,null,'DUNS_NUMBER_C'
5693: ,'PARTY');
5694: ELSE

Line 5705: HZ_TRANS_PKG.WRNAMES_CLEANSE(

5701: END IF;
5702: IF p_search_ctx THEN
5703: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
5704: x_stage_rec.TX40 :=
5705: HZ_TRANS_PKG.WRNAMES_CLEANSE(
5706: p_search_rec.PARTY_ALL_NAMES
5707: ,null,'PARTY_ALL_NAMES'
5708: ,'PARTY','SEARCH');
5709: ELSE

Line 5714: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

5710: x_stage_rec.TX40 := '';
5711: END IF;
5712: ELSE
5713: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
5714: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
5715: x_stage_rec.TX40
5716: ,null,'PARTY_ALL_NAMES'
5717: ,'PARTY','SCORE');
5718: IF tmp IS NOT NULL THEN

Line 5726: HZ_TRANS_PKG.WRNAMES_EXACT(

5722: END IF;
5723: IF p_search_ctx THEN
5724: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
5725: x_stage_rec.TX39 :=
5726: HZ_TRANS_PKG.WRNAMES_EXACT(
5727: p_search_rec.PARTY_ALL_NAMES
5728: ,null,'PARTY_ALL_NAMES'
5729: ,'PARTY','SEARCH');
5730: ELSE

Line 5735: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

5731: x_stage_rec.TX39 := '';
5732: END IF;
5733: ELSE
5734: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
5735: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
5736: x_stage_rec.TX39
5737: ,null,'PARTY_ALL_NAMES'
5738: ,'PARTY','SCORE');
5739: IF tmp IS NOT NULL THEN

Line 5746: HZ_TRANS_PKG.EXACT(

5742: END IF;
5743: END IF;
5744: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
5745: x_stage_rec.TX36 :=
5746: HZ_TRANS_PKG.EXACT(
5747: p_search_rec.PARTY_TYPE
5748: ,null,'PARTY_TYPE'
5749: ,'PARTY');
5750: ELSE

Line 5756: HZ_TRANS_PKG.RM_SPLCHAR(

5752: END IF;
5753: IF p_search_ctx THEN
5754: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
5755: x_stage_rec.TX44 :=
5756: HZ_TRANS_PKG.RM_SPLCHAR(
5757: p_search_rec.TAX_REFERENCE
5758: ,null,'TAX_REFERENCE'
5759: ,'PARTY','SEARCH');
5760: ELSE

Line 5765: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

5761: x_stage_rec.TX44 := '';
5762: END IF;
5763: ELSE
5764: IF p_search_rec.TAX_REFERENCE IS NOT NULL THEN
5765: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
5766: x_stage_rec.TX44
5767: ,null,'TAX_REFERENCE'
5768: ,'PARTY','SCORE');
5769: IF tmp IS NOT NULL THEN

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

5775: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
5776: l_party_name := p_search_rec.PARTY_ALL_NAMES;
5777: END IF;
5778: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
5779: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
5780: END IF;
5781: EXCEPTION
5782: WHEN OTHERS THEN
5783: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 5831: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

5827: FOR I IN 1..p_search_list.COUNT LOOP
5828: IF p_search_ctx THEN
5829: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5830: x_stage_list(I).TX4 :=
5831: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
5832: p_search_list(I).ADDRESS
5833: ,null,'ADDRESS'
5834: ,'PARTY_SITES','SEARCH');
5835: ELSE

Line 5840: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

5836: x_stage_list(I).TX4 := '';
5837: END IF;
5838: ELSE
5839: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5840: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
5841: x_stage_list(I).TX4
5842: ,null,'ADDRESS'
5843: ,'PARTY_SITES','SCORE');
5844: IF tmp IS NOT NULL THEN

Line 5854: HZ_TRANS_PKG.WRADDRESS_EXACT(

5850: FOR I IN 1..p_search_list.COUNT LOOP
5851: IF p_search_ctx THEN
5852: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5853: x_stage_list(I).TX3 :=
5854: HZ_TRANS_PKG.WRADDRESS_EXACT(
5855: p_search_list(I).ADDRESS
5856: ,null,'ADDRESS'
5857: ,'PARTY_SITES','SEARCH');
5858: ELSE

Line 5863: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

5859: x_stage_list(I).TX3 := '';
5860: END IF;
5861: ELSE
5862: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5863: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(
5864: x_stage_list(I).TX3
5865: ,null,'ADDRESS'
5866: ,'PARTY_SITES','SCORE');
5867: IF tmp IS NOT NULL THEN

Line 5877: HZ_TRANS_PKG.RM_SPLCHAR(

5873: FOR I IN 1..p_search_list.COUNT LOOP
5874: IF p_search_ctx THEN
5875: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
5876: x_stage_list(I).TX11 :=
5877: HZ_TRANS_PKG.RM_SPLCHAR(
5878: p_search_list(I).POSTAL_CODE
5879: ,null,'POSTAL_CODE'
5880: ,'PARTY_SITES','SEARCH');
5881: ELSE

Line 5886: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

5882: x_stage_list(I).TX11 := '';
5883: END IF;
5884: ELSE
5885: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
5886: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
5887: x_stage_list(I).TX11
5888: ,null,'POSTAL_CODE'
5889: ,'PARTY_SITES','SCORE');
5890: IF tmp IS NOT NULL THEN