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

Line 2858: IF TX.ATTRIBUTE_NAME = 'DUNS_NUMBER_C' AND upper(TX.PROCEDURE_NAME) = 'HZ_TRANS_PKG.EXACT' THEN

2854: AND a.attribute_id = sa.attribute_id
2855: AND a.entity_name= p_entity
2856: ORDER BY sa.attribute_id) LOOP
2857: --- Modified for Bug 4016594
2858: IF TX.ATTRIBUTE_NAME = 'DUNS_NUMBER_C' AND upper(TX.PROCEDURE_NAME) = 'HZ_TRANS_PKG.EXACT' THEN
2859: x_select_list := x_select_list || ', lpad(rtrim('||TX.STAGED_ATTRIBUTE_COLUMN||'),9,chr('||ascii('0')||'))';
2860: ELSE
2861: x_select_list := x_select_list || ', '||TX.STAGED_ATTRIBUTE_COLUMN;
2862: END IF;

Line 3263: l(' HZ_TRANS_PKG.clear_globals;');

3259: l(' BEGIN');
3260: ldbg_s('-----------------','calling the procedure init_score_context');
3261: ldbg_s('In init_score_context calling the Map procedures');
3262: l(' -- Transform search criteria');
3263: l(' HZ_TRANS_PKG.clear_globals;');
3264: l(' MAP_PARTY_REC(FALSE,p_party_search_rec, l_dummy, g_party_stage_rec);');
3265: l(' MAP_PARTY_SITE_REC(FALSE,p_party_site_list, l_dummy, g_party_site_stage_list);');
3266: l(' MAP_CONTACT_REC(FALSE,p_contact_list, l_dummy, g_contact_stage_list);');
3267: l(' MAP_CONTACT_POINT_REC(FALSE,p_contact_point_list, l_dummy, g_contact_pt_stage_list);');

Line 3322: l(' HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);');

3318: l(' g_contact_pt_stage_list.DELETE;');
3319: l(' call_order.DELETE;');
3320: l(' call_max_score.DELETE;');
3321: l(' HZ_DQM_SEARCH_UTIL.new_search;');
3322: l(' HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);');
3323: l(' HZ_DQM_SEARCH_UTIL.set_num_eval(0);');
3324: l('');
3325: ldbg_s('In init_search calling the Map procedures');
3326: l(' -- Transform search criteria');

Line 3507: IF PRIMATTRS.ATTRIBUTE_NAME = 'DUNS_NUMBER_C' AND upper(PRIMTRANS.PROCEDURE_NAME) = 'HZ_TRANS_PKG.EXACT' THEN

3503: ELSE
3504: tmp := 'NULL';
3505: END IF;
3506: --- Modified for Bug 4016594
3507: IF PRIMATTRS.ATTRIBUTE_NAME = 'DUNS_NUMBER_C' AND upper(PRIMTRANS.PROCEDURE_NAME) = 'HZ_TRANS_PKG.EXACT' THEN
3508: l(' IF g_party_stage_rec.'||PRIMTRANS.STAGED_ATTRIBUTE_COLUMN||' IS NOT NULL THEN');
3509: l(' IF ltrim(g_party_stage_rec.'||PRIMTRANS.STAGED_ATTRIBUTE_COLUMN||',''0'') IS NOT NULL THEN');
3510: l(' FOR I in lengthb(ltrim(g_party_stage_rec.'||PRIMTRANS.STAGED_ATTRIBUTE_COLUMN||',''0''))..9 LOOP');
3511: l(' HZ_DQM_SEARCH_UTIL.add_transformation( -- ' || PRIMTRANS.TRANSFORMATION_NAME);

Line 3598: AND f.PROCEDURE_NAME='HZ_TRANS_PKG.EXACT'

3594: HZ_TRANS_ATTRIBUTES_VL a
3595: WHERE f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
3596: AND a.entity_name = 'PARTY'
3597: AND a.attribute_name='PARTY_TYPE'
3598: AND f.PROCEDURE_NAME='HZ_TRANS_PKG.EXACT'
3599: AND nvl(f.active_flag,'Y')='Y'
3600: AND ROWNUM=1
3601: ) LOOP
3602:

Line 5900: AND f.PROCEDURE_NAME='HZ_TRANS_PKG.EXACT'

5896: HZ_TRANS_ATTRIBUTES_VL a
5897: WHERE f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
5898: AND a.entity_name = 'PARTY'
5899: AND a.attribute_name='PARTY_TYPE'
5900: AND f.PROCEDURE_NAME='HZ_TRANS_PKG.EXACT'
5901: AND nvl(f.active_flag,'Y')='Y'
5902: AND ROWNUM=1
5903: ) LOOP
5904: l(' PROCEDURE set_person_party_type IS');

Line 5907: l(' HZ_TRANS_PKG.EXACT(');

5903: ) LOOP
5904: l(' PROCEDURE set_person_party_type IS');
5905: l(' BEGIN');
5906: l(' g_party_stage_rec.'||TX.STAGED_ATTRIBUTE_COLUMN||':= ');
5907: l(' HZ_TRANS_PKG.EXACT(');
5908: l(' ''PERSON''');
5909: l(' ,null,''PARTY_TYPE''');
5910: l(' ,''PARTY'');');
5911: l(' END;');

Line 8930: l(' HZ_TRANS_PKG.clear_globals;');

8926: l(' ) IS');
8927: l(' l_dummy NUMBER;');
8928: l(' BEGIN');
8929: l(' -- Transform search criteria');
8930: l(' HZ_TRANS_PKG.clear_globals;');
8931: l(' MAP_PARTY_REC(FALSE,p_party_search_rec, l_dummy, g_party_stage_rec);');
8932: l(' MAP_PARTY_SITE_REC(FALSE,p_party_site_list, l_dummy, g_party_site_stage_list);');
8933: l(' MAP_CONTACT_REC(FALSE,p_contact_list, l_dummy, g_contact_stage_list);');
8934: l(' MAP_CONTACT_POINT_REC(FALSE,p_contact_point_list, l_dummy, g_contact_pt_stage_list);');

Line 8986: l(' HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);');

8982: l(' g_contact_pt_stage_list.DELETE;');
8983: l(' call_order.DELETE;');
8984: l(' call_max_score.DELETE;');
8985: l(' HZ_DQM_SEARCH_UTIL.new_search;');
8986: l(' HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);');
8987: l(' HZ_DQM_SEARCH_UTIL.set_num_eval(0);');
8988: l('');
8989: l(' -- Transform search criteria');
8990: l(' MAP_PARTY_REC(TRUE,p_party_search_rec, l_entered_max_score, g_party_stage_rec);');

Line 9146: AND f.PROCEDURE_NAME='HZ_TRANS_PKG.EXACT'

9142: HZ_TRANS_ATTRIBUTES_VL a
9143: WHERE f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
9144: AND a.entity_name = 'PARTY'
9145: AND a.attribute_name='PARTY_TYPE'
9146: AND f.PROCEDURE_NAME='HZ_TRANS_PKG.EXACT'
9147: AND nvl(f.active_flag,'Y')='Y'
9148: AND ROWNUM=1
9149: ) LOOP
9150:

Line 10510: AND f.PROCEDURE_NAME='HZ_TRANS_PKG.EXACT'

10506: HZ_TRANS_ATTRIBUTES_VL a
10507: WHERE f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
10508: AND a.entity_name = 'PARTY'
10509: AND a.attribute_name='PARTY_TYPE'
10510: AND f.PROCEDURE_NAME='HZ_TRANS_PKG.EXACT'
10511: AND nvl(f.active_flag,'Y')='Y'
10512: AND ROWNUM=1
10513: ) LOOP
10514: l(' PROCEDURE set_person_party_type IS');

Line 10517: l(' HZ_TRANS_PKG.EXACT(');

10513: ) LOOP
10514: l(' PROCEDURE set_person_party_type IS');
10515: l(' BEGIN');
10516: l(' g_party_stage_rec.'||TX.STAGED_ATTRIBUTE_COLUMN||':= ');
10517: l(' HZ_TRANS_PKG.EXACT(');
10518: l(' ''PERSON''');
10519: l(' ,null,''PARTY_TYPE''');
10520: l(' ,''PARTY'');');
10521: l(' END;');

Line 12856: AND f.PROCEDURE_NAME='HZ_TRANS_PKG.EXACT'

12852: HZ_TRANS_ATTRIBUTES_VL a
12853: WHERE f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
12854: AND a.entity_name = 'PARTY'
12855: AND a.attribute_name='PARTY_TYPE'
12856: AND f.PROCEDURE_NAME='HZ_TRANS_PKG.EXACT'
12857: AND nvl(f.active_flag,'Y')='Y'
12858: AND ROWNUM=1
12859: )
12860: LOOP

Line 13540: AND f.PROCEDURE_NAME='HZ_TRANS_PKG.EXACT'

13536: HZ_TRANS_ATTRIBUTES_VL a
13537: WHERE f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
13538: AND a.entity_name = 'PARTY'
13539: AND a.attribute_name='PARTY_TYPE'
13540: AND f.PROCEDURE_NAME='HZ_TRANS_PKG.EXACT'
13541: AND nvl(f.active_flag,'Y')='Y'
13542: AND ROWNUM=1
13543: )
13544: LOOP

Line 13603: IF FUNCS.ATTRIBUTE_NAME = 'DUNS_NUMBER_C' AND upper(FUNCS.PROCEDURE_NAME) = 'HZ_TRANS_PKG.EXACT' THEN

13599: l(' END IF;');
13600: END IF;
13601:
13602: --- Modified for Bug 4016594
13603: IF FUNCS.ATTRIBUTE_NAME = 'DUNS_NUMBER_C' AND upper(FUNCS.PROCEDURE_NAME) = 'HZ_TRANS_PKG.EXACT' THEN
13604: l(' IF p_search_rec.'||FUNCS.ATTRIBUTE_NAME || ' IS NOT NULL THEN ');
13605: l(' x_stage_rec.'||FUNCS.STAGED_ATTRIBUTE_COLUMN || ' := ');
13606: l(' lpad(x_stage_rec.'||FUNCS.STAGED_ATTRIBUTE_COLUMN || ',9,''0'');');
13607: l(' END IF;');

Line 13616: l(' x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,''PARTY_NAME'',''PARTY'','''||g_context||''');');

13612: l(' IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN');
13613: l(' l_party_name := p_search_rec.PARTY_ALL_NAMES;');
13614: l(' END IF;');
13615: l(' IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN');
13616: l(' x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,''PARTY_NAME'',''PARTY'','''||g_context||''');');
13617: l(' END IF;');
13618:
13619: IF NONE THEN
13620: l(' NULL;');

Line 16149: l_value :=''''||HZ_TRANS_PKG.EXACT(l_value,NULL,l_attribute_name,l_entity_name)||'%''';

16145: l_add_then := FALSE;
16146: l_close_if := TRUE;
16147: END IF;
16148: IF l_operation = 'LIKE' then
16149: l_value :=''''||HZ_TRANS_PKG.EXACT(l_value,NULL,l_attribute_name,l_entity_name)||'%''';
16150: ELSIF l_operation = 'IN' then
16151: l_tmp_value := l_value;
16152: l_value := NULL;
16153: LOOP

Line 16156: l_value := l_value ||','''||HZ_TRANS_PKG.EXACT(l_tmp_value,NULL,l_attribute_name,l_entity_name)||'''';

16152: l_value := NULL;
16153: LOOP
16154: l_index := instrb(l_tmp_value,',');
16155: IF l_index =0 then
16156: l_value := l_value ||','''||HZ_TRANS_PKG.EXACT(l_tmp_value,NULL,l_attribute_name,l_entity_name)||'''';
16157: l_value := '('||ltrim(l_value,',')||')';
16158: exit;
16159: END IF;
16160: l_value := l_value ||','''||HZ_TRANS_PKG.EXACT(substrb(l_tmp_value,1,l_index-1),NULL,l_attribute_name,l_entity_name)||'''';

Line 16160: l_value := l_value ||','''||HZ_TRANS_PKG.EXACT(substrb(l_tmp_value,1,l_index-1),NULL,l_attribute_name,l_entity_name)||'''';

16156: l_value := l_value ||','''||HZ_TRANS_PKG.EXACT(l_tmp_value,NULL,l_attribute_name,l_entity_name)||'''';
16157: l_value := '('||ltrim(l_value,',')||')';
16158: exit;
16159: END IF;
16160: l_value := l_value ||','''||HZ_TRANS_PKG.EXACT(substrb(l_tmp_value,1,l_index-1),NULL,l_attribute_name,l_entity_name)||'''';
16161: l_tmp_value := substrb(l_tmp_value,l_index+1);
16162: END LOOP;
16163:
16164: ELSE

Line 16165: l_value :=''''||HZ_TRANS_PKG.EXACT(l_value,NULL,l_attribute_name,l_entity_name)||'''';

16161: l_tmp_value := substrb(l_tmp_value,l_index+1);
16162: END LOOP;
16163:
16164: ELSE
16165: l_value :=''''||HZ_TRANS_PKG.EXACT(l_value,NULL,l_attribute_name,l_entity_name)||'''';
16166: END IF;
16167:
16168: IF l_entity_name = 'PARTY' THEN
16169: l_cond_string := 'HZ_TRANS_PKG.EXACT(p_party_search_rec.'||l_attribute_name||',NULL,'''||

Line 16169: l_cond_string := 'HZ_TRANS_PKG.EXACT(p_party_search_rec.'||l_attribute_name||',NULL,'''||

16165: l_value :=''''||HZ_TRANS_PKG.EXACT(l_value,NULL,l_attribute_name,l_entity_name)||'''';
16166: END IF;
16167:
16168: IF l_entity_name = 'PARTY' THEN
16169: l_cond_string := 'HZ_TRANS_PKG.EXACT(p_party_search_rec.'||l_attribute_name||',NULL,'''||
16170: l_attribute_name||''',''PARTY'') '|| l_operation ||' '|| l_value;
16171: ELSIF l_entity_name = 'PARTY_SITES' THEN
16172: l_cond_string := '(p_party_site_list IS NOT NULL AND p_party_site_list.COUNT >0) AND (HZ_TRANS_PKG.EXACT(p_party_site_list(1).'||
16173: l_attribute_name||',NULL,'''||l_attribute_name||''',''PARTY_SITES'') '|| l_operation ||' '|| l_value ||')';

Line 16172: l_cond_string := '(p_party_site_list IS NOT NULL AND p_party_site_list.COUNT >0) AND (HZ_TRANS_PKG.EXACT(p_party_site_list(1).'||

16168: IF l_entity_name = 'PARTY' THEN
16169: l_cond_string := 'HZ_TRANS_PKG.EXACT(p_party_search_rec.'||l_attribute_name||',NULL,'''||
16170: l_attribute_name||''',''PARTY'') '|| l_operation ||' '|| l_value;
16171: ELSIF l_entity_name = 'PARTY_SITES' THEN
16172: l_cond_string := '(p_party_site_list IS NOT NULL AND p_party_site_list.COUNT >0) AND (HZ_TRANS_PKG.EXACT(p_party_site_list(1).'||
16173: l_attribute_name||',NULL,'''||l_attribute_name||''',''PARTY_SITES'') '|| l_operation ||' '|| l_value ||')';
16174: ELSIF l_entity_name = 'CONTACTS' THEN
16175: l_cond_string := '(p_contact_list IS NOT NULL AND p_contact_list.COUNT >0) AND (HZ_TRANS_PKG.EXACT(p_contact_list(1).'||
16176: l_attribute_name||',NULL,'''||l_attribute_name||''',''CONTACTS'') '|| l_operation ||' '|| l_value ||')';

Line 16175: l_cond_string := '(p_contact_list IS NOT NULL AND p_contact_list.COUNT >0) AND (HZ_TRANS_PKG.EXACT(p_contact_list(1).'||

16171: ELSIF l_entity_name = 'PARTY_SITES' THEN
16172: l_cond_string := '(p_party_site_list IS NOT NULL AND p_party_site_list.COUNT >0) AND (HZ_TRANS_PKG.EXACT(p_party_site_list(1).'||
16173: l_attribute_name||',NULL,'''||l_attribute_name||''',''PARTY_SITES'') '|| l_operation ||' '|| l_value ||')';
16174: ELSIF l_entity_name = 'CONTACTS' THEN
16175: l_cond_string := '(p_contact_list IS NOT NULL AND p_contact_list.COUNT >0) AND (HZ_TRANS_PKG.EXACT(p_contact_list(1).'||
16176: l_attribute_name||',NULL,'''||l_attribute_name||''',''CONTACTS'') '|| l_operation ||' '|| l_value ||')';
16177: ELSIF l_entity_name = 'CONTACT_POINTS' THEN
16178: l_cond_string := '(p_contact_point_list IS NOT NULL AND p_contact_point_list.COUNT >0) AND (HZ_TRANS_PKG.EXACT(p_contact_point_list(1).'||
16179: l_attribute_name||',NULL,'''||l_attribute_name||''',''CONTACT_POINTS'') '|| l_operation ||' '|| l_value ||')';

Line 16178: l_cond_string := '(p_contact_point_list IS NOT NULL AND p_contact_point_list.COUNT >0) AND (HZ_TRANS_PKG.EXACT(p_contact_point_list(1).'||

16174: ELSIF l_entity_name = 'CONTACTS' THEN
16175: l_cond_string := '(p_contact_list IS NOT NULL AND p_contact_list.COUNT >0) AND (HZ_TRANS_PKG.EXACT(p_contact_list(1).'||
16176: l_attribute_name||',NULL,'''||l_attribute_name||''',''CONTACTS'') '|| l_operation ||' '|| l_value ||')';
16177: ELSIF l_entity_name = 'CONTACT_POINTS' THEN
16178: l_cond_string := '(p_contact_point_list IS NOT NULL AND p_contact_point_list.COUNT >0) AND (HZ_TRANS_PKG.EXACT(p_contact_point_list(1).'||
16179: l_attribute_name||',NULL,'''||l_attribute_name||''',''CONTACT_POINTS'') '|| l_operation ||' '|| l_value ||')';
16180: END IF;
16181: IF l_add_then THEN
16182: l_cond_string := l_cond_string || ' THEN ';