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

3524: /********************* Find Parties private procedures *******/
3525: PROCEDURE set_person_party_type IS
3526: BEGIN
3527: g_party_stage_rec.TX36:=
3528: HZ_TRANS_PKG.EXACT(
3529: 'PERSON'
3530: ,null,'PARTY_TYPE'
3531: ,'PARTY');
3532: END;

Line 6257: HZ_TRANS_PKG.WRNAMES_CLEANSE(

6253: END IF;
6254: IF p_search_ctx THEN
6255: IF p_search_rec.ALL_ACCOUNT_NAMES IS NOT NULL THEN
6256: x_stage_rec.TX33 :=
6257: HZ_TRANS_PKG.WRNAMES_CLEANSE(
6258: p_search_rec.ALL_ACCOUNT_NAMES
6259: ,null,'ALL_ACCOUNT_NAMES'
6260: ,'PARTY','SEARCH');
6261: ELSE

Line 6266: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

6262: x_stage_rec.TX33 := '';
6263: END IF;
6264: ELSE
6265: IF p_search_rec.ALL_ACCOUNT_NAMES IS NOT NULL THEN
6266: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
6267: x_stage_rec.TX33
6268: ,null,'ALL_ACCOUNT_NAMES'
6269: ,'PARTY','SCORE');
6270: IF tmp IS NOT NULL THEN

Line 6278: HZ_TRANS_PKG.WRNAMES_EXACT(

6274: END IF;
6275: IF p_search_ctx THEN
6276: IF p_search_rec.ALL_ACCOUNT_NAMES IS NOT NULL THEN
6277: x_stage_rec.TX32 :=
6278: HZ_TRANS_PKG.WRNAMES_EXACT(
6279: p_search_rec.ALL_ACCOUNT_NAMES
6280: ,null,'ALL_ACCOUNT_NAMES'
6281: ,'PARTY','SEARCH');
6282: ELSE

Line 6287: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

6283: x_stage_rec.TX32 := '';
6284: END IF;
6285: ELSE
6286: IF p_search_rec.ALL_ACCOUNT_NAMES IS NOT NULL THEN
6287: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
6288: x_stage_rec.TX32
6289: ,null,'ALL_ACCOUNT_NAMES'
6290: ,'PARTY','SCORE');
6291: IF tmp IS NOT NULL THEN

Line 6299: HZ_TRANS_PKG.RM_SPLCHAR(

6295: END IF;
6296: IF p_search_ctx THEN
6297: IF p_search_rec.ALL_ACCOUNT_NUMBERS IS NOT NULL THEN
6298: x_stage_rec.TX35 :=
6299: HZ_TRANS_PKG.RM_SPLCHAR(
6300: p_search_rec.ALL_ACCOUNT_NUMBERS
6301: ,null,'ALL_ACCOUNT_NUMBERS'
6302: ,'PARTY','SEARCH');
6303: ELSE

Line 6308: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6304: x_stage_rec.TX35 := '';
6305: END IF;
6306: ELSE
6307: IF p_search_rec.ALL_ACCOUNT_NUMBERS IS NOT NULL THEN
6308: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6309: x_stage_rec.TX35
6310: ,null,'ALL_ACCOUNT_NUMBERS'
6311: ,'PARTY','SCORE');
6312: IF tmp IS NOT NULL THEN

Line 6320: HZ_TRANS_PKG.EXACT(

6316: END IF;
6317: IF p_search_ctx THEN
6318: IF p_search_rec.DUNS_NUMBER_C IS NOT NULL THEN
6319: x_stage_rec.TX41 :=
6320: HZ_TRANS_PKG.EXACT(
6321: p_search_rec.DUNS_NUMBER_C
6322: ,null,'DUNS_NUMBER_C'
6323: ,'PARTY');
6324: ELSE

Line 6335: HZ_TRANS_PKG.WRNAMES_CLEANSE(

6331: END IF;
6332: IF p_search_ctx THEN
6333: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6334: x_stage_rec.TX40 :=
6335: HZ_TRANS_PKG.WRNAMES_CLEANSE(
6336: p_search_rec.PARTY_ALL_NAMES
6337: ,null,'PARTY_ALL_NAMES'
6338: ,'PARTY','SEARCH');
6339: ELSE

Line 6344: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(

6340: x_stage_rec.TX40 := '';
6341: END IF;
6342: ELSE
6343: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6344: tmp :=HZ_TRANS_PKG.WRNAMES_CLEANSE(
6345: x_stage_rec.TX40
6346: ,null,'PARTY_ALL_NAMES'
6347: ,'PARTY','SCORE');
6348: IF tmp IS NOT NULL THEN

Line 6356: HZ_TRANS_PKG.WRNAMES_EXACT(

6352: END IF;
6353: IF p_search_ctx THEN
6354: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6355: x_stage_rec.TX39 :=
6356: HZ_TRANS_PKG.WRNAMES_EXACT(
6357: p_search_rec.PARTY_ALL_NAMES
6358: ,null,'PARTY_ALL_NAMES'
6359: ,'PARTY','SEARCH');
6360: ELSE

Line 6365: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(

6361: x_stage_rec.TX39 := '';
6362: END IF;
6363: ELSE
6364: IF p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6365: tmp :=HZ_TRANS_PKG.WRNAMES_EXACT(
6366: x_stage_rec.TX39
6367: ,null,'PARTY_ALL_NAMES'
6368: ,'PARTY','SCORE');
6369: IF tmp IS NOT NULL THEN

Line 6377: HZ_TRANS_PKG.RM_SPLCHAR(

6373: END IF;
6374: IF p_search_ctx THEN
6375: IF p_search_rec.PARTY_NUMBER IS NOT NULL THEN
6376: x_stage_rec.TX34 :=
6377: HZ_TRANS_PKG.RM_SPLCHAR(
6378: p_search_rec.PARTY_NUMBER
6379: ,null,'PARTY_NUMBER'
6380: ,'PARTY','SEARCH');
6381: ELSE

Line 6386: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(

6382: x_stage_rec.TX34 := '';
6383: END IF;
6384: ELSE
6385: IF p_search_rec.PARTY_NUMBER IS NOT NULL THEN
6386: tmp :=HZ_TRANS_PKG.RM_SPLCHAR(
6387: x_stage_rec.TX34
6388: ,null,'PARTY_NUMBER'
6389: ,'PARTY','SCORE');
6390: IF tmp IS NOT NULL THEN

Line 6398: HZ_TRANS_PKG.EXACT(

6394: END IF;
6395: IF p_search_ctx THEN
6396: IF p_search_rec.PARTY_TYPE IS NOT NULL THEN
6397: x_stage_rec.TX36 :=
6398: HZ_TRANS_PKG.EXACT(
6399: p_search_rec.PARTY_TYPE
6400: ,null,'PARTY_TYPE'
6401: ,'PARTY');
6402: ELSE

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

6407: IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN
6408: l_party_name := p_search_rec.PARTY_ALL_NAMES;
6409: END IF;
6410: IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN
6411: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
6412: END IF;
6413: EXCEPTION
6414: WHEN OTHERS THEN
6415: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

Line 6475: HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6471: FOR I IN 1..p_search_list.COUNT LOOP
6472: IF p_search_ctx THEN
6473: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6474: x_stage_list(I).TX4 :=
6475: HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6476: p_search_list(I).ADDRESS
6477: ,null,'ADDRESS'
6478: ,'PARTY_SITES','SEARCH');
6479: ELSE

Line 6484: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(

6480: x_stage_list(I).TX4 := '';
6481: END IF;
6482: ELSE
6483: IF p_search_list(I).ADDRESS IS NOT NULL THEN
6484: tmp := HZ_TRANS_PKG.WRADDRESS_CLEANSE(
6485: x_stage_list(I).TX4
6486: ,null,'ADDRESS'
6487: ,'PARTY_SITES','SCORE');
6488: IF tmp IS NOT NULL THEN

Line 6498: HZ_TRANS_PKG.WRADDRESS_EXACT(

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

Line 6507: tmp := HZ_TRANS_PKG.WRADDRESS_EXACT(

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

Line 6521: HZ_TRANS_PKG.CLEANSE(

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

Line 6534: HZ_TRANS_PKG.EXACT(

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

Line 6547: HZ_TRANS_PKG.EXACT(

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

Line 6560: HZ_TRANS_PKG.RM_SPLCHAR(

6556: FOR I IN 1..p_search_list.COUNT LOOP
6557: IF p_search_ctx THEN
6558: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6559: x_stage_list(I).TX11 :=
6560: HZ_TRANS_PKG.RM_SPLCHAR(
6561: p_search_list(I).POSTAL_CODE
6562: ,null,'POSTAL_CODE'
6563: ,'PARTY_SITES','SEARCH');
6564: ELSE

Line 6569: tmp := HZ_TRANS_PKG.RM_SPLCHAR(

6565: x_stage_list(I).TX11 := '';
6566: END IF;
6567: ELSE
6568: IF p_search_list(I).POSTAL_CODE IS NOT NULL THEN
6569: tmp := HZ_TRANS_PKG.RM_SPLCHAR(
6570: x_stage_list(I).TX11
6571: ,null,'POSTAL_CODE'
6572: ,'PARTY_SITES','SCORE');
6573: IF tmp IS NOT NULL THEN

Line 6583: HZ_TRANS_PKG.WRSTATE_CLEANSE(

6579: FOR I IN 1..p_search_list.COUNT LOOP
6580: IF p_search_ctx THEN
6581: IF p_search_list(I).STATE IS NOT NULL THEN
6582: x_stage_list(I).TX15 :=
6583: HZ_TRANS_PKG.WRSTATE_CLEANSE(
6584: p_search_list(I).STATE
6585: ,null,'STATE'
6586: ,'PARTY_SITES','SEARCH');
6587: ELSE

Line 6592: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(

6588: x_stage_list(I).TX15 := '';
6589: END IF;
6590: ELSE
6591: IF p_search_list(I).STATE IS NOT NULL THEN
6592: tmp := HZ_TRANS_PKG.WRSTATE_CLEANSE(
6593: x_stage_list(I).TX15
6594: ,null,'STATE'
6595: ,'PARTY_SITES','SCORE');
6596: IF tmp IS NOT NULL THEN

Line 6606: HZ_TRANS_PKG.WRSTATE_EXACT(

6602: FOR I IN 1..p_search_list.COUNT LOOP
6603: IF p_search_ctx THEN
6604: IF p_search_list(I).STATE IS NOT NULL THEN
6605: x_stage_list(I).TX14 :=
6606: HZ_TRANS_PKG.WRSTATE_EXACT(
6607: p_search_list(I).STATE
6608: ,null,'STATE'
6609: ,'PARTY_SITES','SEARCH');
6610: ELSE

Line 6615: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(

6611: x_stage_list(I).TX14 := '';
6612: END IF;
6613: ELSE
6614: IF p_search_list(I).STATE IS NOT NULL THEN
6615: tmp := HZ_TRANS_PKG.WRSTATE_EXACT(
6616: x_stage_list(I).TX14
6617: ,null,'STATE'
6618: ,'PARTY_SITES','SCORE');
6619: IF tmp IS NOT NULL THEN