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 3465: HZ_TRANS_PKG.EXACT(

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

Line 6194: HZ_TRANS_PKG.WRNAMES_CLEANSE(

6190: END IF;
6191: IF p_search_ctx THEN
6192: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6193: x_stage_rec.TX40 :=
6194: HZ_TRANS_PKG.WRNAMES_CLEANSE(
6195: p_search_rec.PARTY_ALL_NAMES
6196: ,null,'PARTY_ALL_NAMES'
6197: ,'PARTY','SEARCH');
6198: ELSE

Line 6203: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

6199: x_stage_rec.TX40 := '';
6200: END IF;
6201: ELSE
6202: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6203: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
6204: x_stage_rec.TX40
6205: ,null,'PARTY_ALL_NAMES'
6206: ,'PARTY','SCORE');
6207: IF tmp IS NOT NULL THEN

Line 6215: HZ_TRANS_PKG.WRNAMES_EXACT(

6211: END IF;
6212: IF p_search_ctx THEN
6213: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6214: x_stage_rec.TX39 :=
6215: HZ_TRANS_PKG.WRNAMES_EXACT(
6216: p_search_rec.PARTY_ALL_NAMES
6217: ,null,'PARTY_ALL_NAMES'
6218: ,'PARTY','SEARCH');
6219: ELSE

Line 6224: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

6220: x_stage_rec.TX39 := '';
6221: END IF;
6222: ELSE
6223: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6224: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
6225: x_stage_rec.TX39
6226: ,null,'PARTY_ALL_NAMES'
6227: ,'PARTY','SCORE');
6228: IF tmp IS NOT NULL THEN

Line 6236: HZ_TRANS_PKG.RM_SPLCHAR(

6232: END IF;
6233: IF p_search_ctx THEN
6234: IF p_search_rec.PARTY_NUMBER IS NOT NULL THEN
6235: x_stage_rec.TX34 :=
6236: HZ_TRANS_PKG.RM_SPLCHAR(
6237: p_search_rec.PARTY_NUMBER
6238: ,null,'PARTY_NUMBER'
6239: ,'PARTY','SEARCH');
6240: ELSE

Line 6245: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6241: x_stage_rec.TX34 := '';
6242: END IF;
6243: ELSE
6244: IF p_search_rec.PARTY_NUMBER IS NOT NULL THEN
6245: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6246: x_stage_rec.TX34
6247: ,null,'PARTY_NUMBER'
6248: ,'PARTY','SCORE');
6249: IF tmp IS NOT NULL THEN

Line 6256: HZ_TRANS_PKG.EXACT(

6252: END IF;
6253: END IF;
6254: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
6255: x_stage_rec.TX36 :=
6256: HZ_TRANS_PKG.EXACT(
6257: p_search_rec.PARTY_TYPE
6258: ,null,'PARTY_TYPE'
6259: ,'PARTY');
6260: ELSE

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

6264: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6265: l_party_name := p_search_rec.PARTY_ALL_NAMES;
6266: END IF;
6267: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
6268: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
6269: END IF;
6270: EXCEPTION
6271: WHEN OTHERS THEN
6272: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 6338: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6334: FOR I IN 1..p_search_list.COUNT LOOP
6335: IF p_search_ctx THEN
6336: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6337: x_stage_list(I).TX4 :=
6338: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6339: p_search_list(I).ADDRESS
6340: ,null,'ADDRESS'
6341: ,'PARTY_SITES','SEARCH');
6342: ELSE

Line 6347: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6343: x_stage_list(I).TX4 := '';
6344: END IF;
6345: ELSE
6346: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6347: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6348: x_stage_list(I).TX4
6349: ,null,'ADDRESS'
6350: ,'PARTY_SITES','SCORE');
6351: IF tmp IS NOT NULL THEN

Line 6361: HZ_TRANS_PKG.WRADDRESS_EXACT(

6357: FOR I IN 1..p_search_list.COUNT LOOP
6358: IF p_search_ctx THEN
6359: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6360: x_stage_list(I).TX3 :=
6361: HZ_TRANS_PKG.WRADDRESS_EXACT(
6362: p_search_list(I).ADDRESS
6363: ,null,'ADDRESS'
6364: ,'PARTY_SITES','SEARCH');
6365: ELSE

Line 6370: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

6366: x_stage_list(I).TX3 := '';
6367: END IF;
6368: ELSE
6369: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6370: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(
6371: x_stage_list(I).TX3
6372: ,null,'ADDRESS'
6373: ,'PARTY_SITES','SCORE');
6374: IF tmp IS NOT NULL THEN

Line 6384: HZ_TRANS_PKG.CLEANSE(

6380: FOR I IN 1..p_search_list.COUNT LOOP
6381: IF p_search_ctx THEN
6382: IF p_search_list(I).CITY IS NOT NULL THEN
6383: x_stage_list(I).TX10 :=
6384: HZ_TRANS_PKG.CLEANSE(
6385: p_search_list(I).CITY
6386: ,null,'CITY'
6387: ,'PARTY_SITES');
6388: ELSE

Line 6397: HZ_TRANS_PKG.EXACT(

6393: FOR I IN 1..p_search_list.COUNT LOOP
6394: IF p_search_ctx THEN
6395: IF p_search_list(I).CITY IS NOT NULL THEN
6396: x_stage_list(I).TX9 :=
6397: HZ_TRANS_PKG.EXACT(
6398: p_search_list(I).CITY
6399: ,null,'CITY'
6400: ,'PARTY_SITES');
6401: ELSE

Line 6410: HZ_TRANS_PKG.EXACT(

6406: FOR I IN 1..p_search_list.COUNT LOOP
6407: IF p_search_ctx THEN
6408: IF p_search_list(I).COUNTRY IS NOT NULL THEN
6409: x_stage_list(I).TX22 :=
6410: HZ_TRANS_PKG.EXACT(
6411: p_search_list(I).COUNTRY
6412: ,null,'COUNTRY'
6413: ,'PARTY_SITES');
6414: ELSE

Line 6423: HZ_TRANS_PKG.CLEANSE(

6419: FOR I IN 1..p_search_list.COUNT LOOP
6420: IF p_search_ctx THEN
6421: IF p_search_list(I).COUNTY IS NOT NULL THEN
6422: x_stage_list(I).TX21 :=
6423: HZ_TRANS_PKG.CLEANSE(
6424: p_search_list(I).COUNTY
6425: ,null,'COUNTY'
6426: ,'PARTY_SITES');
6427: ELSE

Line 6436: HZ_TRANS_PKG.EXACT(

6432: FOR I IN 1..p_search_list.COUNT LOOP
6433: IF p_search_ctx THEN
6434: IF p_search_list(I).COUNTY IS NOT NULL THEN
6435: x_stage_list(I).TX20 :=
6436: HZ_TRANS_PKG.EXACT(
6437: p_search_list(I).COUNTY
6438: ,null,'COUNTY'
6439: ,'PARTY_SITES');
6440: ELSE

Line 6449: HZ_TRANS_PKG.RM_SPLCHAR(

6445: FOR I IN 1..p_search_list.COUNT LOOP
6446: IF p_search_ctx THEN
6447: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6448: x_stage_list(I).TX11 :=
6449: HZ_TRANS_PKG.RM_SPLCHAR(
6450: p_search_list(I).POSTAL_CODE
6451: ,null,'POSTAL_CODE'
6452: ,'PARTY_SITES','SEARCH');
6453: ELSE

Line 6458: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

6454: x_stage_list(I).TX11 := '';
6455: END IF;
6456: ELSE
6457: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6458: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
6459: x_stage_list(I).TX11
6460: ,null,'POSTAL_CODE'
6461: ,'PARTY_SITES','SCORE');
6462: IF tmp IS NOT NULL THEN

Line 6472: HZ_TRANS_PKG.CLEANSE(

6468: FOR I IN 1..p_search_list.COUNT LOOP
6469: IF p_search_ctx THEN
6470: IF p_search_list(I).PROVINCE IS NOT NULL THEN
6471: x_stage_list(I).TX13 :=
6472: HZ_TRANS_PKG.CLEANSE(
6473: p_search_list(I).PROVINCE
6474: ,null,'PROVINCE'
6475: ,'PARTY_SITES');
6476: ELSE

Line 6485: HZ_TRANS_PKG.EXACT(

6481: FOR I IN 1..p_search_list.COUNT LOOP
6482: IF p_search_ctx THEN
6483: IF p_search_list(I).PROVINCE IS NOT NULL THEN
6484: x_stage_list(I).TX12 :=
6485: HZ_TRANS_PKG.EXACT(
6486: p_search_list(I).PROVINCE
6487: ,null,'PROVINCE'
6488: ,'PARTY_SITES');
6489: ELSE

Line 6498: HZ_TRANS_PKG.WRSTATE_CLEANSE(

6494: FOR I IN 1..p_search_list.COUNT LOOP
6495: IF p_search_ctx THEN
6496: IF p_search_list(I).STATE IS NOT NULL THEN
6497: x_stage_list(I).TX15 :=
6498: HZ_TRANS_PKG.WRSTATE_CLEANSE(
6499: p_search_list(I).STATE
6500: ,null,'STATE'
6501: ,'PARTY_SITES','SEARCH');
6502: ELSE

Line 6507: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(

6503: x_stage_list(I).TX15 := '';
6504: END IF;
6505: ELSE
6506: IF p_search_list(I).STATE IS NOT NULL THEN
6507: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(
6508: x_stage_list(I).TX15
6509: ,null,'STATE'
6510: ,'PARTY_SITES','SCORE');
6511: IF tmp IS NOT NULL THEN

Line 6521: HZ_TRANS_PKG.WRSTATE_EXACT(

6517: FOR I IN 1..p_search_list.COUNT LOOP
6518: IF p_search_ctx THEN
6519: IF p_search_list(I).STATE IS NOT NULL THEN
6520: x_stage_list(I).TX14 :=
6521: HZ_TRANS_PKG.WRSTATE_EXACT(
6522: p_search_list(I).STATE
6523: ,null,'STATE'
6524: ,'PARTY_SITES','SEARCH');
6525: ELSE

Line 6530: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(

6526: x_stage_list(I).TX14 := '';
6527: END IF;
6528: ELSE
6529: IF p_search_list(I).STATE IS NOT NULL THEN
6530: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(
6531: x_stage_list(I).TX14
6532: ,null,'STATE'
6533: ,'PARTY_SITES','SCORE');
6534: IF tmp IS NOT NULL THEN