eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_MATCH_RULE_50 dependencies on HZ_TRANS_PKG

Line 984: HZ_TRANS_PKG.clear_globals;

980: ) IS
981: l_dummy NUMBER;
982: BEGIN
983: -- Transform search criteria
984: HZ_TRANS_PKG.clear_globals;
985: MAP_PARTY_REC(FALSE,p_party_search_rec, l_dummy, g_party_stage_rec);
986: MAP_PARTY_SITE_REC(FALSE,p_party_site_list, l_dummy, g_party_site_stage_list);
987: MAP_CONTACT_REC(FALSE,p_contact_list, l_dummy, g_contact_stage_list);
988: MAP_CONTACT_POINT_REC(FALSE,p_contact_point_list, l_dummy, g_contact_pt_stage_list);

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

1030: g_contact_pt_stage_list.DELETE;
1031: call_order.DELETE;
1032: call_max_score.DELETE;
1033: HZ_DQM_SEARCH_UTIL.new_search;
1034: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
1035: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1036:
1037: -- Transform search criteria
1038: MAP_PARTY_REC(TRUE,p_party_search_rec, l_entered_max_score, g_party_stage_rec);

Line 2314: HZ_TRANS_PKG.EXACT(

2310: /********************* Find Parties private procedures *******/
2311: PROCEDURE set_person_party_type IS
2312: BEGIN
2313: g_party_stage_rec.TX36:=
2314: HZ_TRANS_PKG.EXACT(
2315: 'PERSON'
2316: ,null,'PARTY_TYPE'
2317: ,'PARTY');
2318: END;

Line 4922: HZ_TRANS_PKG.EXACT(

4918: END IF;
4919: IF p_search_ctx THEN
4920: IF p_search_rec.DUNS_NUMBER_C IS NOT NULL THEN
4921: x_stage_rec.TX41 :=
4922: HZ_TRANS_PKG.EXACT(
4923: p_search_rec.DUNS_NUMBER_C
4924: ,null,'DUNS_NUMBER_C'
4925: ,'PARTY');
4926: ELSE

Line 4933: HZ_TRANS_PKG.RM_SPLCHAR(

4929: END IF;
4930: IF p_search_ctx THEN
4931: IF p_search_rec.JGZZ_FISCAL_CODE IS NOT NULL THEN
4932: x_stage_rec.TX45 :=
4933: HZ_TRANS_PKG.RM_SPLCHAR(
4934: p_search_rec.JGZZ_FISCAL_CODE
4935: ,null,'JGZZ_FISCAL_CODE'
4936: ,'PARTY','SEARCH');
4937: ELSE

Line 4942: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

4938: x_stage_rec.TX45 := '';
4939: END IF;
4940: ELSE
4941: IF p_search_rec.JGZZ_FISCAL_CODE IS NOT NULL THEN
4942: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
4943: x_stage_rec.TX45
4944: ,null,'JGZZ_FISCAL_CODE'
4945: ,'PARTY','SCORE');
4946: IF tmp IS NOT NULL THEN

Line 4954: HZ_TRANS_PKG.BASIC_WRNAMES(

4950: END IF;
4951: IF p_search_ctx THEN
4952: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
4953: x_stage_rec.TX59 :=
4954: HZ_TRANS_PKG.BASIC_WRNAMES(
4955: p_search_rec.PARTY_NAME
4956: ,null,'PARTY_NAME'
4957: ,'PARTY','SEARCH');
4958: ELSE

Line 4963: tmp :=HZ_TRANS_PKG.BASIC_WRNAMES(

4959: x_stage_rec.TX59 := '';
4960: END IF;
4961: ELSE
4962: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
4963: tmp :=HZ_TRANS_PKG.BASIC_WRNAMES(
4964: x_stage_rec.TX59
4965: ,null,'PARTY_NAME'
4966: ,'PARTY','SCORE');
4967: IF tmp IS NOT NULL THEN

Line 4975: HZ_TRANS_PKG.EXACT_PADDED(

4971: END IF;
4972: IF p_search_ctx THEN
4973: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
4974: x_stage_rec.TX2 :=
4975: HZ_TRANS_PKG.EXACT_PADDED(
4976: p_search_rec.PARTY_NAME
4977: ,null,'PARTY_NAME'
4978: ,'PARTY');
4979: ELSE

Line 4986: HZ_TRANS_PKG.EXACT(

4982: END IF;
4983: IF p_search_ctx THEN
4984: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
4985: x_stage_rec.TX36 :=
4986: HZ_TRANS_PKG.EXACT(
4987: p_search_rec.PARTY_TYPE
4988: ,null,'PARTY_TYPE'
4989: ,'PARTY');
4990: ELSE

Line 4997: HZ_TRANS_PKG.EXACT(

4993: END IF;
4994: IF p_search_ctx THEN
4995: IF p_search_rec.SIC_CODE IS NOT NULL THEN
4996: x_stage_rec.TX46 :=
4997: HZ_TRANS_PKG.EXACT(
4998: p_search_rec.SIC_CODE
4999: ,null,'SIC_CODE'
5000: ,'PARTY');
5001: ELSE

Line 5065: HZ_TRANS_PKG.BASIC_WRADDR(

5061: FOR I IN 1..p_search_list.COUNT LOOP
5062: IF p_search_ctx THEN
5063: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5064: x_stage_list(I).TX26 :=
5065: HZ_TRANS_PKG.BASIC_WRADDR(
5066: p_search_list(I).ADDRESS
5067: ,null,'ADDRESS'
5068: ,'PARTY_SITES','SEARCH');
5069: ELSE

Line 5074: tmp := HZ_TRANS_PKG.BASIC_WRADDR(

5070: x_stage_list(I).TX26 := '';
5071: END IF;
5072: ELSE
5073: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5074: tmp := HZ_TRANS_PKG.BASIC_WRADDR(
5075: x_stage_list(I).TX26
5076: ,null,'ADDRESS'
5077: ,'PARTY_SITES','SCORE');
5078: IF tmp IS NOT NULL THEN

Line 5088: HZ_TRANS_PKG.EXACT(

5084: FOR I IN 1..p_search_list.COUNT LOOP
5085: IF p_search_ctx THEN
5086: IF p_search_list(I).CITY IS NOT NULL THEN
5087: x_stage_list(I).TX9 :=
5088: HZ_TRANS_PKG.EXACT(
5089: p_search_list(I).CITY
5090: ,null,'CITY'
5091: ,'PARTY_SITES');
5092: ELSE

Line 5101: HZ_TRANS_PKG.EXACT(

5097: FOR I IN 1..p_search_list.COUNT LOOP
5098: IF p_search_ctx THEN
5099: IF p_search_list(I).COUNTRY IS NOT NULL THEN
5100: x_stage_list(I).TX22 :=
5101: HZ_TRANS_PKG.EXACT(
5102: p_search_list(I).COUNTRY
5103: ,null,'COUNTRY'
5104: ,'PARTY_SITES');
5105: ELSE

Line 5114: HZ_TRANS_PKG.RM_SPLCHAR(

5110: FOR I IN 1..p_search_list.COUNT LOOP
5111: IF p_search_ctx THEN
5112: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
5113: x_stage_list(I).TX11 :=
5114: HZ_TRANS_PKG.RM_SPLCHAR(
5115: p_search_list(I).POSTAL_CODE
5116: ,null,'POSTAL_CODE'
5117: ,'PARTY_SITES','SEARCH');
5118: ELSE

Line 5123: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

5119: x_stage_list(I).TX11 := '';
5120: END IF;
5121: ELSE
5122: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
5123: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
5124: x_stage_list(I).TX11
5125: ,null,'POSTAL_CODE'
5126: ,'PARTY_SITES','SCORE');
5127: IF tmp IS NOT NULL THEN

Line 5137: HZ_TRANS_PKG.WRSTATE_EXACT(

5133: FOR I IN 1..p_search_list.COUNT LOOP
5134: IF p_search_ctx THEN
5135: IF p_search_list(I).STATE IS NOT NULL THEN
5136: x_stage_list(I).TX14 :=
5137: HZ_TRANS_PKG.WRSTATE_EXACT(
5138: p_search_list(I).STATE
5139: ,null,'STATE'
5140: ,'PARTY_SITES','SEARCH');
5141: ELSE

Line 5146: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(

5142: x_stage_list(I).TX14 := '';
5143: END IF;
5144: ELSE
5145: IF p_search_list(I).STATE IS NOT NULL THEN
5146: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(
5147: x_stage_list(I).TX14
5148: ,null,'STATE'
5149: ,'PARTY_SITES','SCORE');
5150: IF tmp IS NOT NULL THEN

Line 5212: HZ_TRANS_PKG.BASIC_WRPERSON(

5208: FOR I IN 1..p_search_list.COUNT LOOP
5209: IF p_search_ctx THEN
5210: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
5211: x_stage_list(I).TX23 :=
5212: HZ_TRANS_PKG.BASIC_WRPERSON(
5213: p_search_list(I).CONTACT_NAME
5214: ,null,'CONTACT_NAME'
5215: ,'CONTACTS','SEARCH');
5216: ELSE

Line 5221: tmp := HZ_TRANS_PKG.BASIC_WRPERSON(

5217: x_stage_list(I).TX23 := '';
5218: END IF;
5219: ELSE
5220: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
5221: tmp := HZ_TRANS_PKG.BASIC_WRPERSON(
5222: x_stage_list(I).TX23
5223: ,null,'CONTACT_NAME'
5224: ,'CONTACTS','SCORE');
5225: IF tmp IS NOT NULL THEN

Line 5235: HZ_TRANS_PKG.EXACT_PADDED(

5231: FOR I IN 1..p_search_list.COUNT LOOP
5232: IF p_search_ctx THEN
5233: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
5234: x_stage_list(I).TX2 :=
5235: HZ_TRANS_PKG.EXACT_PADDED(
5236: p_search_list(I).CONTACT_NAME
5237: ,null,'CONTACT_NAME'
5238: ,'CONTACTS');
5239: ELSE

Line 5248: HZ_TRANS_PKG.EXACT(

5244: FOR I IN 1..p_search_list.COUNT LOOP
5245: IF p_search_ctx THEN
5246: IF p_search_list(I).JOB_TITLE IS NOT NULL THEN
5247: x_stage_list(I).TX22 :=
5248: HZ_TRANS_PKG.EXACT(
5249: p_search_list(I).JOB_TITLE
5250: ,null,'JOB_TITLE'
5251: ,'CONTACTS');
5252: ELSE

Line 5314: HZ_TRANS_PKG.REVERSE_PHONE_NUMBER(

5310: FOR I IN 1..p_search_list.COUNT LOOP
5311: IF p_search_ctx THEN
5312: IF p_search_list(I).RAW_PHONE_NUMBER IS NOT NULL THEN
5313: x_stage_list(I).TX158 :=
5314: HZ_TRANS_PKG.REVERSE_PHONE_NUMBER(
5315: p_search_list(I).RAW_PHONE_NUMBER
5316: ,null,'RAW_PHONE_NUMBER'
5317: ,'CONTACT_POINTS');
5318: ELSE

Line 5327: HZ_TRANS_PKG.RM_SPLCHAR(

5323: FOR I IN 1..p_search_list.COUNT LOOP
5324: IF p_search_ctx THEN
5325: IF p_search_list(I).RAW_PHONE_NUMBER IS NOT NULL THEN
5326: x_stage_list(I).TX10 :=
5327: HZ_TRANS_PKG.RM_SPLCHAR(
5328: p_search_list(I).RAW_PHONE_NUMBER
5329: ,null,'RAW_PHONE_NUMBER'
5330: ,'CONTACT_POINTS','SEARCH');
5331: ELSE

Line 5336: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

5332: x_stage_list(I).TX10 := '';
5333: END IF;
5334: ELSE
5335: IF p_search_list(I).RAW_PHONE_NUMBER IS NOT NULL THEN
5336: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
5337: x_stage_list(I).TX10
5338: ,null,'RAW_PHONE_NUMBER'
5339: ,'CONTACT_POINTS','SCORE');
5340: IF tmp IS NOT NULL THEN

Line 5350: HZ_TRANS_PKG.CLEANSED_URL(

5346: FOR I IN 1..p_search_list.COUNT LOOP
5347: IF p_search_ctx THEN
5348: IF p_search_list(I).URL IS NOT NULL THEN
5349: x_stage_list(I).TX8 :=
5350: HZ_TRANS_PKG.CLEANSED_URL(
5351: p_search_list(I).URL
5352: ,null,'URL'
5353: ,'CONTACT_POINTS','SEARCH');
5354: ELSE

Line 5359: tmp := HZ_TRANS_PKG.CLEANSED_URL(

5355: x_stage_list(I).TX8 := '';
5356: END IF;
5357: ELSE
5358: IF p_search_list(I).URL IS NOT NULL THEN
5359: tmp := HZ_TRANS_PKG.CLEANSED_URL(
5360: x_stage_list(I).TX8
5361: ,null,'URL'
5362: ,'CONTACT_POINTS','SCORE');
5363: IF tmp IS NOT NULL THEN

Line 5373: HZ_TRANS_PKG.EXACT_URL(

5369: FOR I IN 1..p_search_list.COUNT LOOP
5370: IF p_search_ctx THEN
5371: IF p_search_list(I).URL IS NOT NULL THEN
5372: x_stage_list(I).TX7 :=
5373: HZ_TRANS_PKG.EXACT_URL(
5374: p_search_list(I).URL
5375: ,null,'URL'
5376: ,'CONTACT_POINTS');
5377: ELSE