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_52 dependencies on HZ_TRANS_PKG

Line 1030: HZ_TRANS_PKG.clear_globals;

1026: ) IS
1027: l_dummy NUMBER;
1028: BEGIN
1029: -- Transform search criteria
1030: HZ_TRANS_PKG.clear_globals;
1031: MAP_PARTY_REC(FALSE,p_party_search_rec, l_dummy, g_party_stage_rec);
1032: MAP_PARTY_SITE_REC(FALSE,p_party_site_list, l_dummy, g_party_site_stage_list);
1033: MAP_CONTACT_REC(FALSE,p_contact_list, l_dummy, g_contact_stage_list);
1034: MAP_CONTACT_POINT_REC(FALSE,p_contact_point_list, l_dummy, g_contact_pt_stage_list);

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

1076: g_contact_pt_stage_list.DELETE;
1077: call_order.DELETE;
1078: call_max_score.DELETE;
1079: HZ_DQM_SEARCH_UTIL.new_search;
1080: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
1081: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1082:
1083: -- Transform search criteria
1084: MAP_PARTY_REC(TRUE,p_party_search_rec, l_entered_max_score, g_party_stage_rec);

Line 2382: HZ_TRANS_PKG.EXACT(

2378: /********************* Find Parties private procedures *******/
2379: PROCEDURE set_person_party_type IS
2380: BEGIN
2381: g_party_stage_rec.TX36:=
2382: HZ_TRANS_PKG.EXACT(
2383: 'PERSON'
2384: ,null,'PARTY_TYPE'
2385: ,'PARTY');
2386: END;

Line 5022: HZ_TRANS_PKG.EXACT(

5018: END IF;
5019: IF p_search_ctx THEN
5020: IF p_search_rec.DUNS_NUMBER_C IS NOT NULL THEN
5021: x_stage_rec.TX41 :=
5022: HZ_TRANS_PKG.EXACT(
5023: p_search_rec.DUNS_NUMBER_C
5024: ,null,'DUNS_NUMBER_C'
5025: ,'PARTY');
5026: ELSE

Line 5033: HZ_TRANS_PKG.RM_SPLCHAR(

5029: END IF;
5030: IF p_search_ctx THEN
5031: IF p_search_rec.JGZZ_FISCAL_CODE IS NOT NULL THEN
5032: x_stage_rec.TX45 :=
5033: HZ_TRANS_PKG.RM_SPLCHAR(
5034: p_search_rec.JGZZ_FISCAL_CODE
5035: ,null,'JGZZ_FISCAL_CODE'
5036: ,'PARTY','SEARCH');
5037: ELSE

Line 5042: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

5038: x_stage_rec.TX45 := '';
5039: END IF;
5040: ELSE
5041: IF p_search_rec.JGZZ_FISCAL_CODE IS NOT NULL THEN
5042: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
5043: x_stage_rec.TX45
5044: ,null,'JGZZ_FISCAL_CODE'
5045: ,'PARTY','SCORE');
5046: IF tmp IS NOT NULL THEN

Line 5054: HZ_TRANS_PKG.BASIC_WRNAMES(

5050: END IF;
5051: IF p_search_ctx THEN
5052: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5053: x_stage_rec.TX59 :=
5054: HZ_TRANS_PKG.BASIC_WRNAMES(
5055: p_search_rec.PARTY_NAME
5056: ,null,'PARTY_NAME'
5057: ,'PARTY','SEARCH');
5058: ELSE

Line 5063: tmp :=HZ_TRANS_PKG.BASIC_WRNAMES(

5059: x_stage_rec.TX59 := '';
5060: END IF;
5061: ELSE
5062: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5063: tmp :=HZ_TRANS_PKG.BASIC_WRNAMES(
5064: x_stage_rec.TX59
5065: ,null,'PARTY_NAME'
5066: ,'PARTY','SCORE');
5067: IF tmp IS NOT NULL THEN

Line 5075: HZ_TRANS_PKG.EXACT_PADDED(

5071: END IF;
5072: IF p_search_ctx THEN
5073: IF p_search_rec.PARTY_NAME IS NOT NULL THEN
5074: x_stage_rec.TX2 :=
5075: HZ_TRANS_PKG.EXACT_PADDED(
5076: p_search_rec.PARTY_NAME
5077: ,null,'PARTY_NAME'
5078: ,'PARTY');
5079: ELSE

Line 5086: HZ_TRANS_PKG.EXACT(

5082: END IF;
5083: IF p_search_ctx THEN
5084: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
5085: x_stage_rec.TX36 :=
5086: HZ_TRANS_PKG.EXACT(
5087: p_search_rec.PARTY_TYPE
5088: ,null,'PARTY_TYPE'
5089: ,'PARTY');
5090: ELSE

Line 5097: HZ_TRANS_PKG.EXACT(

5093: END IF;
5094: IF p_search_ctx THEN
5095: IF p_search_rec.SIC_CODE IS NOT NULL THEN
5096: x_stage_rec.TX46 :=
5097: HZ_TRANS_PKG.EXACT(
5098: p_search_rec.SIC_CODE
5099: ,null,'SIC_CODE'
5100: ,'PARTY');
5101: ELSE

Line 5165: HZ_TRANS_PKG.BASIC_WRADDR(

5161: FOR I IN 1..p_search_list.COUNT LOOP
5162: IF p_search_ctx THEN
5163: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5164: x_stage_list(I).TX26 :=
5165: HZ_TRANS_PKG.BASIC_WRADDR(
5166: p_search_list(I).ADDRESS
5167: ,null,'ADDRESS'
5168: ,'PARTY_SITES','SEARCH');
5169: ELSE

Line 5174: tmp := HZ_TRANS_PKG.BASIC_WRADDR(

5170: x_stage_list(I).TX26 := '';
5171: END IF;
5172: ELSE
5173: IF p_search_list(I).ADDRESS IS NOT NULL THEN
5174: tmp := HZ_TRANS_PKG.BASIC_WRADDR(
5175: x_stage_list(I).TX26
5176: ,null,'ADDRESS'
5177: ,'PARTY_SITES','SCORE');
5178: IF tmp IS NOT NULL THEN

Line 5188: HZ_TRANS_PKG.EXACT(

5184: FOR I IN 1..p_search_list.COUNT LOOP
5185: IF p_search_ctx THEN
5186: IF p_search_list(I).CITY IS NOT NULL THEN
5187: x_stage_list(I).TX9 :=
5188: HZ_TRANS_PKG.EXACT(
5189: p_search_list(I).CITY
5190: ,null,'CITY'
5191: ,'PARTY_SITES');
5192: ELSE

Line 5201: HZ_TRANS_PKG.EXACT(

5197: FOR I IN 1..p_search_list.COUNT LOOP
5198: IF p_search_ctx THEN
5199: IF p_search_list(I).COUNTRY IS NOT NULL THEN
5200: x_stage_list(I).TX22 :=
5201: HZ_TRANS_PKG.EXACT(
5202: p_search_list(I).COUNTRY
5203: ,null,'COUNTRY'
5204: ,'PARTY_SITES');
5205: ELSE

Line 5214: HZ_TRANS_PKG.RM_SPLCHAR(

5210: FOR I IN 1..p_search_list.COUNT LOOP
5211: IF p_search_ctx THEN
5212: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
5213: x_stage_list(I).TX11 :=
5214: HZ_TRANS_PKG.RM_SPLCHAR(
5215: p_search_list(I).POSTAL_CODE
5216: ,null,'POSTAL_CODE'
5217: ,'PARTY_SITES','SEARCH');
5218: ELSE

Line 5223: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

5219: x_stage_list(I).TX11 := '';
5220: END IF;
5221: ELSE
5222: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
5223: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
5224: x_stage_list(I).TX11
5225: ,null,'POSTAL_CODE'
5226: ,'PARTY_SITES','SCORE');
5227: IF tmp IS NOT NULL THEN

Line 5237: HZ_TRANS_PKG.WRSTATE_EXACT(

5233: FOR I IN 1..p_search_list.COUNT LOOP
5234: IF p_search_ctx THEN
5235: IF p_search_list(I).STATE IS NOT NULL THEN
5236: x_stage_list(I).TX14 :=
5237: HZ_TRANS_PKG.WRSTATE_EXACT(
5238: p_search_list(I).STATE
5239: ,null,'STATE'
5240: ,'PARTY_SITES','SEARCH');
5241: ELSE

Line 5246: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(

5242: x_stage_list(I).TX14 := '';
5243: END IF;
5244: ELSE
5245: IF p_search_list(I).STATE IS NOT NULL THEN
5246: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(
5247: x_stage_list(I).TX14
5248: ,null,'STATE'
5249: ,'PARTY_SITES','SCORE');
5250: IF tmp IS NOT NULL THEN

Line 5312: HZ_TRANS_PKG.BASIC_WRPERSON(

5308: FOR I IN 1..p_search_list.COUNT LOOP
5309: IF p_search_ctx THEN
5310: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
5311: x_stage_list(I).TX23 :=
5312: HZ_TRANS_PKG.BASIC_WRPERSON(
5313: p_search_list(I).CONTACT_NAME
5314: ,null,'CONTACT_NAME'
5315: ,'CONTACTS','SEARCH');
5316: ELSE

Line 5321: tmp := HZ_TRANS_PKG.BASIC_WRPERSON(

5317: x_stage_list(I).TX23 := '';
5318: END IF;
5319: ELSE
5320: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
5321: tmp := HZ_TRANS_PKG.BASIC_WRPERSON(
5322: x_stage_list(I).TX23
5323: ,null,'CONTACT_NAME'
5324: ,'CONTACTS','SCORE');
5325: IF tmp IS NOT NULL THEN

Line 5335: HZ_TRANS_PKG.EXACT_PADDED(

5331: FOR I IN 1..p_search_list.COUNT LOOP
5332: IF p_search_ctx THEN
5333: IF p_search_list(I).CONTACT_NAME IS NOT NULL THEN
5334: x_stage_list(I).TX2 :=
5335: HZ_TRANS_PKG.EXACT_PADDED(
5336: p_search_list(I).CONTACT_NAME
5337: ,null,'CONTACT_NAME'
5338: ,'CONTACTS');
5339: ELSE

Line 5348: HZ_TRANS_PKG.EXACT(

5344: FOR I IN 1..p_search_list.COUNT LOOP
5345: IF p_search_ctx THEN
5346: IF p_search_list(I).JOB_TITLE IS NOT NULL THEN
5347: x_stage_list(I).TX22 :=
5348: HZ_TRANS_PKG.EXACT(
5349: p_search_list(I).JOB_TITLE
5350: ,null,'JOB_TITLE'
5351: ,'CONTACTS');
5352: ELSE

Line 5417: HZ_TRANS_PKG.EXACT_EMAIL(

5413: FOR I IN 1..p_search_list.COUNT LOOP
5414: IF p_search_ctx THEN
5415: IF p_search_list(I).EMAIL_ADDRESS IS NOT NULL THEN
5416: x_stage_list(I).TX5 :=
5417: HZ_TRANS_PKG.EXACT_EMAIL(
5418: p_search_list(I).EMAIL_ADDRESS
5419: ,null,'EMAIL_ADDRESS'
5420: ,'CONTACT_POINTS');
5421: ELSE

Line 5430: HZ_TRANS_PKG.REVERSE_PHONE_NUMBER(

5426: FOR I IN 1..p_search_list.COUNT LOOP
5427: IF p_search_ctx THEN
5428: IF p_search_list(I).RAW_PHONE_NUMBER IS NOT NULL THEN
5429: x_stage_list(I).TX158 :=
5430: HZ_TRANS_PKG.REVERSE_PHONE_NUMBER(
5431: p_search_list(I).RAW_PHONE_NUMBER
5432: ,null,'RAW_PHONE_NUMBER'
5433: ,'CONTACT_POINTS');
5434: ELSE

Line 5443: HZ_TRANS_PKG.RM_SPLCHAR(

5439: FOR I IN 1..p_search_list.COUNT LOOP
5440: IF p_search_ctx THEN
5441: IF p_search_list(I).RAW_PHONE_NUMBER IS NOT NULL THEN
5442: x_stage_list(I).TX10 :=
5443: HZ_TRANS_PKG.RM_SPLCHAR(
5444: p_search_list(I).RAW_PHONE_NUMBER
5445: ,null,'RAW_PHONE_NUMBER'
5446: ,'CONTACT_POINTS','SEARCH');
5447: ELSE

Line 5452: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

5448: x_stage_list(I).TX10 := '';
5449: END IF;
5450: ELSE
5451: IF p_search_list(I).RAW_PHONE_NUMBER IS NOT NULL THEN
5452: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
5453: x_stage_list(I).TX10
5454: ,null,'RAW_PHONE_NUMBER'
5455: ,'CONTACT_POINTS','SCORE');
5456: IF tmp IS NOT NULL THEN

Line 5466: HZ_TRANS_PKG.EXACT_URL(

5462: FOR I IN 1..p_search_list.COUNT LOOP
5463: IF p_search_ctx THEN
5464: IF p_search_list(I).URL IS NOT NULL THEN
5465: x_stage_list(I).TX7 :=
5466: HZ_TRANS_PKG.EXACT_URL(
5467: p_search_list(I).URL
5468: ,null,'URL'
5469: ,'CONTACT_POINTS');
5470: ELSE