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

Line 937: HZ_TRANS_PKG.clear_globals;

933: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
934: 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);
935: END IF;
936: -- Transform search criteria
937: HZ_TRANS_PKG.clear_globals;
938: MAP_PARTY_REC(FALSE,p_party_search_rec, l_dummy, g_party_stage_rec);
939: MAP_PARTY_SITE_REC(FALSE,p_party_site_list, l_dummy, g_party_site_stage_list);
940: MAP_CONTACT_REC(FALSE,p_contact_list, l_dummy, g_contact_stage_list);
941: MAP_CONTACT_POINT_REC(FALSE,p_contact_point_list, l_dummy, g_contact_pt_stage_list);

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

990: g_contact_pt_stage_list.DELETE;
991: call_order.DELETE;
992: call_max_score.DELETE;
993: HZ_DQM_SEARCH_UTIL.new_search;
994: HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);
995: HZ_DQM_SEARCH_UTIL.set_num_eval(0);
996:
997: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
998: 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 3462: HZ_TRANS_PKG.EXACT(

3458: /********************* Find Parties private procedures *******/
3459: PROCEDURE set_person_party_type IS
3460: BEGIN
3461: g_party_stage_rec.TX36:=
3462: HZ_TRANS_PKG.EXACT(
3463: 'PERSON'
3464: ,null,'PARTY_TYPE'
3465: ,'PARTY');
3466: END;

Line 6189: HZ_TRANS_PKG.WRNAMES_CLEANSE(

6185: END IF;
6186: IF p_search_ctx THEN
6187: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6188: x_stage_rec.TX40 :=
6189: HZ_TRANS_PKG.WRNAMES_CLEANSE(
6190: p_search_rec.PARTY_ALL_NAMES
6191: ,null,'PARTY_ALL_NAMES'
6192: ,'PARTY','SEARCH');
6193: ELSE

Line 6198: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

6194: x_stage_rec.TX40 := '';
6195: END IF;
6196: ELSE
6197: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6198: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
6199: x_stage_rec.TX40
6200: ,null,'PARTY_ALL_NAMES'
6201: ,'PARTY','SCORE');
6202: IF tmp IS NOT NULL THEN

Line 6210: HZ_TRANS_PKG.WRNAMES_EXACT(

6206: END IF;
6207: IF p_search_ctx THEN
6208: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6209: x_stage_rec.TX39 :=
6210: HZ_TRANS_PKG.WRNAMES_EXACT(
6211: p_search_rec.PARTY_ALL_NAMES
6212: ,null,'PARTY_ALL_NAMES'
6213: ,'PARTY','SEARCH');
6214: ELSE

Line 6219: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

6215: x_stage_rec.TX39 := '';
6216: END IF;
6217: ELSE
6218: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6219: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
6220: x_stage_rec.TX39
6221: ,null,'PARTY_ALL_NAMES'
6222: ,'PARTY','SCORE');
6223: IF tmp IS NOT NULL THEN

Line 6231: HZ_TRANS_PKG.RM_SPLCHAR(

6227: END IF;
6228: IF p_search_ctx THEN
6229: IF p_search_rec.PARTY_NUMBER IS NOT NULL THEN
6230: x_stage_rec.TX34 :=
6231: HZ_TRANS_PKG.RM_SPLCHAR(
6232: p_search_rec.PARTY_NUMBER
6233: ,null,'PARTY_NUMBER'
6234: ,'PARTY','SEARCH');
6235: ELSE

Line 6240: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6236: x_stage_rec.TX34 := '';
6237: END IF;
6238: ELSE
6239: IF p_search_rec.PARTY_NUMBER IS NOT NULL THEN
6240: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6241: x_stage_rec.TX34
6242: ,null,'PARTY_NUMBER'
6243: ,'PARTY','SCORE');
6244: IF tmp IS NOT NULL THEN

Line 6251: HZ_TRANS_PKG.EXACT(

6247: END IF;
6248: END IF;
6249: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
6250: x_stage_rec.TX36 :=
6251: HZ_TRANS_PKG.EXACT(
6252: p_search_rec.PARTY_TYPE
6253: ,null,'PARTY_TYPE'
6254: ,'PARTY');
6255: ELSE

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

6259: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6260: l_party_name := p_search_rec.PARTY_ALL_NAMES;
6261: END IF;
6262: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
6263: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
6264: END IF;
6265: EXCEPTION
6266: WHEN OTHERS THEN
6267: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 6333: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6329: FOR I IN 1..p_search_list.COUNT LOOP
6330: IF p_search_ctx THEN
6331: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6332: x_stage_list(I).TX4 :=
6333: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6334: p_search_list(I).ADDRESS
6335: ,null,'ADDRESS'
6336: ,'PARTY_SITES','SEARCH');
6337: ELSE

Line 6342: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6338: x_stage_list(I).TX4 := '';
6339: END IF;
6340: ELSE
6341: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6342: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6343: x_stage_list(I).TX4
6344: ,null,'ADDRESS'
6345: ,'PARTY_SITES','SCORE');
6346: IF tmp IS NOT NULL THEN

Line 6356: HZ_TRANS_PKG.WRADDRESS_EXACT(

6352: FOR I IN 1..p_search_list.COUNT LOOP
6353: IF p_search_ctx THEN
6354: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6355: x_stage_list(I).TX3 :=
6356: HZ_TRANS_PKG.WRADDRESS_EXACT(
6357: p_search_list(I).ADDRESS
6358: ,null,'ADDRESS'
6359: ,'PARTY_SITES','SEARCH');
6360: ELSE

Line 6365: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

6361: x_stage_list(I).TX3 := '';
6362: END IF;
6363: ELSE
6364: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6365: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(
6366: x_stage_list(I).TX3
6367: ,null,'ADDRESS'
6368: ,'PARTY_SITES','SCORE');
6369: IF tmp IS NOT NULL THEN

Line 6379: HZ_TRANS_PKG.CLEANSE(

6375: FOR I IN 1..p_search_list.COUNT LOOP
6376: IF p_search_ctx THEN
6377: IF p_search_list(I).CITY IS NOT NULL THEN
6378: x_stage_list(I).TX10 :=
6379: HZ_TRANS_PKG.CLEANSE(
6380: p_search_list(I).CITY
6381: ,null,'CITY'
6382: ,'PARTY_SITES');
6383: ELSE

Line 6392: HZ_TRANS_PKG.EXACT(

6388: FOR I IN 1..p_search_list.COUNT LOOP
6389: IF p_search_ctx THEN
6390: IF p_search_list(I).CITY IS NOT NULL THEN
6391: x_stage_list(I).TX9 :=
6392: HZ_TRANS_PKG.EXACT(
6393: p_search_list(I).CITY
6394: ,null,'CITY'
6395: ,'PARTY_SITES');
6396: ELSE

Line 6405: HZ_TRANS_PKG.EXACT(

6401: FOR I IN 1..p_search_list.COUNT LOOP
6402: IF p_search_ctx THEN
6403: IF p_search_list(I).COUNTRY IS NOT NULL THEN
6404: x_stage_list(I).TX22 :=
6405: HZ_TRANS_PKG.EXACT(
6406: p_search_list(I).COUNTRY
6407: ,null,'COUNTRY'
6408: ,'PARTY_SITES');
6409: ELSE

Line 6418: HZ_TRANS_PKG.CLEANSE(

6414: FOR I IN 1..p_search_list.COUNT LOOP
6415: IF p_search_ctx THEN
6416: IF p_search_list(I).COUNTY IS NOT NULL THEN
6417: x_stage_list(I).TX21 :=
6418: HZ_TRANS_PKG.CLEANSE(
6419: p_search_list(I).COUNTY
6420: ,null,'COUNTY'
6421: ,'PARTY_SITES');
6422: ELSE

Line 6431: HZ_TRANS_PKG.EXACT(

6427: FOR I IN 1..p_search_list.COUNT LOOP
6428: IF p_search_ctx THEN
6429: IF p_search_list(I).COUNTY IS NOT NULL THEN
6430: x_stage_list(I).TX20 :=
6431: HZ_TRANS_PKG.EXACT(
6432: p_search_list(I).COUNTY
6433: ,null,'COUNTY'
6434: ,'PARTY_SITES');
6435: ELSE

Line 6444: HZ_TRANS_PKG.RM_SPLCHAR(

6440: FOR I IN 1..p_search_list.COUNT LOOP
6441: IF p_search_ctx THEN
6442: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6443: x_stage_list(I).TX11 :=
6444: HZ_TRANS_PKG.RM_SPLCHAR(
6445: p_search_list(I).POSTAL_CODE
6446: ,null,'POSTAL_CODE'
6447: ,'PARTY_SITES','SEARCH');
6448: ELSE

Line 6453: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

6449: x_stage_list(I).TX11 := '';
6450: END IF;
6451: ELSE
6452: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6453: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
6454: x_stage_list(I).TX11
6455: ,null,'POSTAL_CODE'
6456: ,'PARTY_SITES','SCORE');
6457: IF tmp IS NOT NULL THEN

Line 6467: HZ_TRANS_PKG.CLEANSE(

6463: FOR I IN 1..p_search_list.COUNT LOOP
6464: IF p_search_ctx THEN
6465: IF p_search_list(I).PROVINCE IS NOT NULL THEN
6466: x_stage_list(I).TX13 :=
6467: HZ_TRANS_PKG.CLEANSE(
6468: p_search_list(I).PROVINCE
6469: ,null,'PROVINCE'
6470: ,'PARTY_SITES');
6471: ELSE

Line 6480: HZ_TRANS_PKG.EXACT(

6476: FOR I IN 1..p_search_list.COUNT LOOP
6477: IF p_search_ctx THEN
6478: IF p_search_list(I).PROVINCE IS NOT NULL THEN
6479: x_stage_list(I).TX12 :=
6480: HZ_TRANS_PKG.EXACT(
6481: p_search_list(I).PROVINCE
6482: ,null,'PROVINCE'
6483: ,'PARTY_SITES');
6484: ELSE

Line 6493: HZ_TRANS_PKG.WRSTATE_CLEANSE(

6489: FOR I IN 1..p_search_list.COUNT LOOP
6490: IF p_search_ctx THEN
6491: IF p_search_list(I).STATE IS NOT NULL THEN
6492: x_stage_list(I).TX15 :=
6493: HZ_TRANS_PKG.WRSTATE_CLEANSE(
6494: p_search_list(I).STATE
6495: ,null,'STATE'
6496: ,'PARTY_SITES','SEARCH');
6497: ELSE

Line 6502: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(

6498: x_stage_list(I).TX15 := '';
6499: END IF;
6500: ELSE
6501: IF p_search_list(I).STATE IS NOT NULL THEN
6502: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(
6503: x_stage_list(I).TX15
6504: ,null,'STATE'
6505: ,'PARTY_SITES','SCORE');
6506: IF tmp IS NOT NULL THEN

Line 6516: HZ_TRANS_PKG.WRSTATE_EXACT(

6512: FOR I IN 1..p_search_list.COUNT LOOP
6513: IF p_search_ctx THEN
6514: IF p_search_list(I).STATE IS NOT NULL THEN
6515: x_stage_list(I).TX14 :=
6516: HZ_TRANS_PKG.WRSTATE_EXACT(
6517: p_search_list(I).STATE
6518: ,null,'STATE'
6519: ,'PARTY_SITES','SEARCH');
6520: ELSE

Line 6525: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(

6521: x_stage_list(I).TX14 := '';
6522: END IF;
6523: ELSE
6524: IF p_search_list(I).STATE IS NOT NULL THEN
6525: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(
6526: x_stage_list(I).TX14
6527: ,null,'STATE'
6528: ,'PARTY_SITES','SCORE');
6529: IF tmp IS NOT NULL THEN