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

Line 966: HZ_TRANS_PKG.clear_globals;

962: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
963: 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);
964: END IF;
965: -- Transform search criteria
966: HZ_TRANS_PKG.clear_globals;
967: MAP_PARTY_REC(FALSE,p_party_search_rec, l_dummy, g_party_stage_rec);
968: MAP_PARTY_SITE_REC(FALSE,p_party_site_list, l_dummy, g_party_site_stage_list);
969: MAP_CONTACT_REC(FALSE,p_contact_list, l_dummy, g_contact_stage_list);
970: MAP_CONTACT_POINT_REC(FALSE,p_contact_point_list, l_dummy, g_contact_pt_stage_list);

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

1019: g_contact_pt_stage_list.DELETE;
1020: call_order.DELETE;
1021: call_max_score.DELETE;
1022: HZ_DQM_SEARCH_UTIL.new_search;
1023: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
1024: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
1025:
1026: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1027: 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 3533: HZ_TRANS_PKG.EXACT(

3529: /********************* Find Parties private procedures *******/
3530: PROCEDURE set_person_party_type IS
3531: BEGIN
3532: g_party_stage_rec.TX36:=
3533: HZ_TRANS_PKG.EXACT(
3534: 'PERSON'
3535: ,null,'PARTY_TYPE'
3536: ,'PARTY');
3537: END;

Line 6268: HZ_TRANS_PKG.WRNAMES_CLEANSE(

6264: END IF;
6265: IF p_search_ctx THEN
6266: IF p_search_rec.ALL_ACCOUNT_NAMES IS NOT NULL THEN
6267: x_stage_rec.TX33 :=
6268: HZ_TRANS_PKG.WRNAMES_CLEANSE(
6269: p_search_rec.ALL_ACCOUNT_NAMES
6270: ,null,'ALL_ACCOUNT_NAMES'
6271: ,'PARTY','SEARCH');
6272: ELSE

Line 6277: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

6273: x_stage_rec.TX33 := '';
6274: END IF;
6275: ELSE
6276: IF p_search_rec.ALL_ACCOUNT_NAMES IS NOT NULL THEN
6277: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
6278: x_stage_rec.TX33
6279: ,null,'ALL_ACCOUNT_NAMES'
6280: ,'PARTY','SCORE');
6281: IF tmp IS NOT NULL THEN

Line 6289: HZ_TRANS_PKG.WRNAMES_EXACT(

6285: END IF;
6286: IF p_search_ctx THEN
6287: IF p_search_rec.ALL_ACCOUNT_NAMES IS NOT NULL THEN
6288: x_stage_rec.TX32 :=
6289: HZ_TRANS_PKG.WRNAMES_EXACT(
6290: p_search_rec.ALL_ACCOUNT_NAMES
6291: ,null,'ALL_ACCOUNT_NAMES'
6292: ,'PARTY','SEARCH');
6293: ELSE

Line 6298: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

6294: x_stage_rec.TX32 := '';
6295: END IF;
6296: ELSE
6297: IF p_search_rec.ALL_ACCOUNT_NAMES IS NOT NULL THEN
6298: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
6299: x_stage_rec.TX32
6300: ,null,'ALL_ACCOUNT_NAMES'
6301: ,'PARTY','SCORE');
6302: IF tmp IS NOT NULL THEN

Line 6310: HZ_TRANS_PKG.RM_SPLCHAR(

6306: END IF;
6307: IF p_search_ctx THEN
6308: IF p_search_rec.ALL_ACCOUNT_NUMBERS IS NOT NULL THEN
6309: x_stage_rec.TX35 :=
6310: HZ_TRANS_PKG.RM_SPLCHAR(
6311: p_search_rec.ALL_ACCOUNT_NUMBERS
6312: ,null,'ALL_ACCOUNT_NUMBERS'
6313: ,'PARTY','SEARCH');
6314: ELSE

Line 6319: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6315: x_stage_rec.TX35 := '';
6316: END IF;
6317: ELSE
6318: IF p_search_rec.ALL_ACCOUNT_NUMBERS IS NOT NULL THEN
6319: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6320: x_stage_rec.TX35
6321: ,null,'ALL_ACCOUNT_NUMBERS'
6322: ,'PARTY','SCORE');
6323: IF tmp IS NOT NULL THEN

Line 6331: HZ_TRANS_PKG.EXACT(

6327: END IF;
6328: IF p_search_ctx THEN
6329: IF p_search_rec.DUNS_NUMBER_C IS NOT NULL THEN
6330: x_stage_rec.TX41 :=
6331: HZ_TRANS_PKG.EXACT(
6332: p_search_rec.DUNS_NUMBER_C
6333: ,null,'DUNS_NUMBER_C'
6334: ,'PARTY');
6335: ELSE

Line 6346: HZ_TRANS_PKG.WRNAMES_CLEANSE(

6342: END IF;
6343: IF p_search_ctx THEN
6344: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6345: x_stage_rec.TX40 :=
6346: HZ_TRANS_PKG.WRNAMES_CLEANSE(
6347: p_search_rec.PARTY_ALL_NAMES
6348: ,null,'PARTY_ALL_NAMES'
6349: ,'PARTY','SEARCH');
6350: ELSE

Line 6355: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

6351: x_stage_rec.TX40 := '';
6352: END IF;
6353: ELSE
6354: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6355: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
6356: x_stage_rec.TX40
6357: ,null,'PARTY_ALL_NAMES'
6358: ,'PARTY','SCORE');
6359: IF tmp IS NOT NULL THEN

Line 6367: HZ_TRANS_PKG.WRNAMES_EXACT(

6363: END IF;
6364: IF p_search_ctx THEN
6365: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6366: x_stage_rec.TX39 :=
6367: HZ_TRANS_PKG.WRNAMES_EXACT(
6368: p_search_rec.PARTY_ALL_NAMES
6369: ,null,'PARTY_ALL_NAMES'
6370: ,'PARTY','SEARCH');
6371: ELSE

Line 6376: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

6372: x_stage_rec.TX39 := '';
6373: END IF;
6374: ELSE
6375: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6376: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
6377: x_stage_rec.TX39
6378: ,null,'PARTY_ALL_NAMES'
6379: ,'PARTY','SCORE');
6380: IF tmp IS NOT NULL THEN

Line 6388: HZ_TRANS_PKG.RM_SPLCHAR(

6384: END IF;
6385: IF p_search_ctx THEN
6386: IF p_search_rec.PARTY_NUMBER IS NOT NULL THEN
6387: x_stage_rec.TX34 :=
6388: HZ_TRANS_PKG.RM_SPLCHAR(
6389: p_search_rec.PARTY_NUMBER
6390: ,null,'PARTY_NUMBER'
6391: ,'PARTY','SEARCH');
6392: ELSE

Line 6397: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6393: x_stage_rec.TX34 := '';
6394: END IF;
6395: ELSE
6396: IF p_search_rec.PARTY_NUMBER IS NOT NULL THEN
6397: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6398: x_stage_rec.TX34
6399: ,null,'PARTY_NUMBER'
6400: ,'PARTY','SCORE');
6401: IF tmp IS NOT NULL THEN

Line 6409: HZ_TRANS_PKG.EXACT(

6405: END IF;
6406: IF p_search_ctx THEN
6407: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
6408: x_stage_rec.TX36 :=
6409: HZ_TRANS_PKG.EXACT(
6410: p_search_rec.PARTY_TYPE
6411: ,null,'PARTY_TYPE'
6412: ,'PARTY');
6413: ELSE

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

6418: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6419: l_party_name := p_search_rec.PARTY_ALL_NAMES;
6420: END IF;
6421: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
6422: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
6423: END IF;
6424: EXCEPTION
6425: WHEN OTHERS THEN
6426: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 6486: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6482: FOR I IN 1..p_search_list.COUNT LOOP
6483: IF p_search_ctx THEN
6484: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6485: x_stage_list(I).TX4 :=
6486: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6487: p_search_list(I).ADDRESS
6488: ,null,'ADDRESS'
6489: ,'PARTY_SITES','SEARCH');
6490: ELSE

Line 6495: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6491: x_stage_list(I).TX4 := '';
6492: END IF;
6493: ELSE
6494: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6495: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6496: x_stage_list(I).TX4
6497: ,null,'ADDRESS'
6498: ,'PARTY_SITES','SCORE');
6499: IF tmp IS NOT NULL THEN

Line 6509: HZ_TRANS_PKG.WRADDRESS_EXACT(

6505: FOR I IN 1..p_search_list.COUNT LOOP
6506: IF p_search_ctx THEN
6507: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6508: x_stage_list(I).TX3 :=
6509: HZ_TRANS_PKG.WRADDRESS_EXACT(
6510: p_search_list(I).ADDRESS
6511: ,null,'ADDRESS'
6512: ,'PARTY_SITES','SEARCH');
6513: ELSE

Line 6518: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

6514: x_stage_list(I).TX3 := '';
6515: END IF;
6516: ELSE
6517: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6518: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(
6519: x_stage_list(I).TX3
6520: ,null,'ADDRESS'
6521: ,'PARTY_SITES','SCORE');
6522: IF tmp IS NOT NULL THEN

Line 6532: HZ_TRANS_PKG.CLEANSE(

6528: FOR I IN 1..p_search_list.COUNT LOOP
6529: IF p_search_ctx THEN
6530: IF p_search_list(I).CITY IS NOT NULL THEN
6531: x_stage_list(I).TX10 :=
6532: HZ_TRANS_PKG.CLEANSE(
6533: p_search_list(I).CITY
6534: ,null,'CITY'
6535: ,'PARTY_SITES');
6536: ELSE

Line 6545: HZ_TRANS_PKG.EXACT(

6541: FOR I IN 1..p_search_list.COUNT LOOP
6542: IF p_search_ctx THEN
6543: IF p_search_list(I).CITY IS NOT NULL THEN
6544: x_stage_list(I).TX9 :=
6545: HZ_TRANS_PKG.EXACT(
6546: p_search_list(I).CITY
6547: ,null,'CITY'
6548: ,'PARTY_SITES');
6549: ELSE

Line 6558: HZ_TRANS_PKG.EXACT(

6554: FOR I IN 1..p_search_list.COUNT LOOP
6555: IF p_search_ctx THEN
6556: IF p_search_list(I).COUNTRY IS NOT NULL THEN
6557: x_stage_list(I).TX22 :=
6558: HZ_TRANS_PKG.EXACT(
6559: p_search_list(I).COUNTRY
6560: ,null,'COUNTRY'
6561: ,'PARTY_SITES');
6562: ELSE

Line 6571: HZ_TRANS_PKG.RM_SPLCHAR(

6567: FOR I IN 1..p_search_list.COUNT LOOP
6568: IF p_search_ctx THEN
6569: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6570: x_stage_list(I).TX11 :=
6571: HZ_TRANS_PKG.RM_SPLCHAR(
6572: p_search_list(I).POSTAL_CODE
6573: ,null,'POSTAL_CODE'
6574: ,'PARTY_SITES','SEARCH');
6575: ELSE

Line 6580: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

6576: x_stage_list(I).TX11 := '';
6577: END IF;
6578: ELSE
6579: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6580: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
6581: x_stage_list(I).TX11
6582: ,null,'POSTAL_CODE'
6583: ,'PARTY_SITES','SCORE');
6584: IF tmp IS NOT NULL THEN

Line 6594: HZ_TRANS_PKG.WRSTATE_CLEANSE(

6590: FOR I IN 1..p_search_list.COUNT LOOP
6591: IF p_search_ctx THEN
6592: IF p_search_list(I).STATE IS NOT NULL THEN
6593: x_stage_list(I).TX15 :=
6594: HZ_TRANS_PKG.WRSTATE_CLEANSE(
6595: p_search_list(I).STATE
6596: ,null,'STATE'
6597: ,'PARTY_SITES','SEARCH');
6598: ELSE

Line 6603: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(

6599: x_stage_list(I).TX15 := '';
6600: END IF;
6601: ELSE
6602: IF p_search_list(I).STATE IS NOT NULL THEN
6603: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(
6604: x_stage_list(I).TX15
6605: ,null,'STATE'
6606: ,'PARTY_SITES','SCORE');
6607: IF tmp IS NOT NULL THEN

Line 6617: HZ_TRANS_PKG.WRSTATE_EXACT(

6613: FOR I IN 1..p_search_list.COUNT LOOP
6614: IF p_search_ctx THEN
6615: IF p_search_list(I).STATE IS NOT NULL THEN
6616: x_stage_list(I).TX14 :=
6617: HZ_TRANS_PKG.WRSTATE_EXACT(
6618: p_search_list(I).STATE
6619: ,null,'STATE'
6620: ,'PARTY_SITES','SEARCH');
6621: ELSE

Line 6626: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(

6622: x_stage_list(I).TX14 := '';
6623: END IF;
6624: ELSE
6625: IF p_search_list(I).STATE IS NOT NULL THEN
6626: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(
6627: x_stage_list(I).TX14
6628: ,null,'STATE'
6629: ,'PARTY_SITES','SCORE');
6630: IF tmp IS NOT NULL THEN