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 3270: l(' HZ_TRANS_PKG.clear_globals;');

3266: l(' BEGIN');
3267: ldbg_s('-----------------','calling the procedure init_score_context');
3268: ldbg_s('In init_score_context calling the Map procedures');
3269: l(' -- Transform search criteria');
3270: l(' HZ_TRANS_PKG.clear_globals;');
3271: l(' MAP_PARTY_REC(FALSE,p_party_search_rec, l_dummy, g_party_stage_rec);');
3272: l(' MAP_PARTY_SITE_REC(FALSE,p_party_site_list, l_dummy, g_party_site_stage_list);');
3273: l(' MAP_CONTACT_REC(FALSE,p_contact_list, l_dummy, g_contact_stage_list);');
3274: l(' MAP_CONTACT_POINT_REC(FALSE,p_contact_point_list, l_dummy, g_contact_pt_stage_list);');

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

3325: l(' g_contact_pt_stage_list.DELETE;');
3326: l(' call_order.DELETE;');
3327: l(' call_max_score.DELETE;');
3328: l(' HZ_DQM_SEARCH_UTIL.new_search;');
3329: l(' HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);');
3330: l(' HZ_DQM_SEARCH_UTIL.set_num_eval(0);');
3331: l('');
3332: ldbg_s('In init_search calling the Map procedures');
3333: l(' -- Transform search criteria');

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

3510: ELSE
3511: tmp := 'NULL';
3512: END IF;
3513: --- Modified for Bug 4016594
3514: IF PRIMATTRS.ATTRIBUTE_NAME = 'DUNS_NUMBER_C' AND upper(PRIMTRANS.PROCEDURE_NAME) = 'HZ_TRANS_PKG.EXACT' THEN
3515: l(' IF g_party_stage_rec.'||PRIMTRANS.STAGED_ATTRIBUTE_COLUMN||' IS NOT NULL THEN');
3516: l(' IF ltrim(g_party_stage_rec.'||PRIMTRANS.STAGED_ATTRIBUTE_COLUMN||',''0'') IS NOT NULL THEN');
3517: l(' FOR I in lengthb(ltrim(g_party_stage_rec.'||PRIMTRANS.STAGED_ATTRIBUTE_COLUMN||',''0''))..9 LOOP');
3518: l(' HZ_DQM_SEARCH_UTIL.add_transformation( -- ' || PRIMTRANS.TRANSFORMATION_NAME);

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

3601: HZ_TRANS_ATTRIBUTES_VL a
3602: WHERE f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
3603: AND a.entity_name = 'PARTY'
3604: AND a.attribute_name='PARTY_TYPE'
3605: AND f.PROCEDURE_NAME='HZ_TRANS_PKG.EXACT'
3606: AND nvl(f.active_flag,'Y')='Y'
3607: AND ROWNUM=1
3608: ) LOOP
3609:

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

5919: HZ_TRANS_ATTRIBUTES_VL a
5920: WHERE f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
5921: AND a.entity_name = 'PARTY'
5922: AND a.attribute_name='PARTY_TYPE'
5923: AND f.PROCEDURE_NAME='HZ_TRANS_PKG.EXACT'
5924: AND nvl(f.active_flag,'Y')='Y'
5925: AND ROWNUM=1
5926: ) LOOP
5927: l(' PROCEDURE set_person_party_type IS');

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

5926: ) LOOP
5927: l(' PROCEDURE set_person_party_type IS');
5928: l(' BEGIN');
5929: l(' g_party_stage_rec.'||TX.STAGED_ATTRIBUTE_COLUMN||':= ');
5930: l(' HZ_TRANS_PKG.EXACT(');
5931: l(' ''PERSON''');
5932: l(' ,null,''PARTY_TYPE''');
5933: l(' ,''PARTY'');');
5934: l(' END;');

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

8972: l(' ) IS');
8973: l(' l_dummy NUMBER;');
8974: l(' BEGIN');
8975: l(' -- Transform search criteria');
8976: l(' HZ_TRANS_PKG.clear_globals;');
8977: l(' MAP_PARTY_REC(FALSE,p_party_search_rec, l_dummy, g_party_stage_rec);');
8978: l(' MAP_PARTY_SITE_REC(FALSE,p_party_site_list, l_dummy, g_party_site_stage_list);');
8979: l(' MAP_CONTACT_REC(FALSE,p_contact_list, l_dummy, g_contact_stage_list);');
8980: l(' MAP_CONTACT_POINT_REC(FALSE,p_contact_point_list, l_dummy, g_contact_pt_stage_list);');

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

9028: l(' g_contact_pt_stage_list.DELETE;');
9029: l(' call_order.DELETE;');
9030: l(' call_max_score.DELETE;');
9031: l(' HZ_DQM_SEARCH_UTIL.new_search;');
9032: l(' HZ_TRANS_PKG.set_party_type(p_party_search_rec.PARTY_TYPE);');
9033: l(' HZ_DQM_SEARCH_UTIL.set_num_eval(0);');
9034: l('');
9035: l(' -- Transform search criteria');
9036: l(' MAP_PARTY_REC(TRUE,p_party_search_rec, l_entered_max_score, g_party_stage_rec);');

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

9188: HZ_TRANS_ATTRIBUTES_VL a
9189: WHERE f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
9190: AND a.entity_name = 'PARTY'
9191: AND a.attribute_name='PARTY_TYPE'
9192: AND f.PROCEDURE_NAME='HZ_TRANS_PKG.EXACT'
9193: AND nvl(f.active_flag,'Y')='Y'
9194: AND ROWNUM=1
9195: ) LOOP
9196:

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

10562: HZ_TRANS_ATTRIBUTES_VL a
10563: WHERE f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
10564: AND a.entity_name = 'PARTY'
10565: AND a.attribute_name='PARTY_TYPE'
10566: AND f.PROCEDURE_NAME='HZ_TRANS_PKG.EXACT'
10567: AND nvl(f.active_flag,'Y')='Y'
10568: AND ROWNUM=1
10569: ) LOOP
10570: l(' PROCEDURE set_person_party_type IS');

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

10569: ) LOOP
10570: l(' PROCEDURE set_person_party_type IS');
10571: l(' BEGIN');
10572: l(' g_party_stage_rec.'||TX.STAGED_ATTRIBUTE_COLUMN||':= ');
10573: l(' HZ_TRANS_PKG.EXACT(');
10574: l(' ''PERSON''');
10575: l(' ,null,''PARTY_TYPE''');
10576: l(' ,''PARTY'');');
10577: l(' END;');

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

12908: HZ_TRANS_ATTRIBUTES_VL a
12909: WHERE f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
12910: AND a.entity_name = 'PARTY'
12911: AND a.attribute_name='PARTY_TYPE'
12912: AND f.PROCEDURE_NAME='HZ_TRANS_PKG.EXACT'
12913: AND nvl(f.active_flag,'Y')='Y'
12914: AND ROWNUM=1
12915: )
12916: LOOP

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

13592: HZ_TRANS_ATTRIBUTES_VL a
13593: WHERE f.ATTRIBUTE_ID = a.ATTRIBUTE_ID
13594: AND a.entity_name = 'PARTY'
13595: AND a.attribute_name='PARTY_TYPE'
13596: AND f.PROCEDURE_NAME='HZ_TRANS_PKG.EXACT'
13597: AND nvl(f.active_flag,'Y')='Y'
13598: AND ROWNUM=1
13599: )
13600: LOOP

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

13655: l(' END IF;');
13656: END IF;
13657:
13658: --- Modified for Bug 4016594
13659: IF FUNCS.ATTRIBUTE_NAME = 'DUNS_NUMBER_C' AND upper(FUNCS.PROCEDURE_NAME) = 'HZ_TRANS_PKG.EXACT' THEN
13660: l(' IF p_search_rec.'||FUNCS.ATTRIBUTE_NAME || ' IS NOT NULL THEN ');
13661: l(' x_stage_rec.'||FUNCS.STAGED_ATTRIBUTE_COLUMN || ' := ');
13662: l(' lpad(x_stage_rec.'||FUNCS.STAGED_ATTRIBUTE_COLUMN || ',9,''0'');');
13663: l(' END IF;');

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

13668: l(' IF l_party_name IS NULL AND p_search_rec.PARTY_ALL_NAMES IS NOT NULL THEN');
13669: l(' l_party_name := p_search_rec.PARTY_ALL_NAMES;');
13670: l(' END IF;');
13671: l(' IF l_party_name IS NOT NULL AND x_stage_rec.TX8 IS NULL THEN');
13672: l(' x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,''PARTY_NAME'',''PARTY'','''||g_context||''');');
13673: l(' END IF;');
13674:
13675: IF NONE THEN
13676: l(' NULL;');

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

16203: l_add_then := FALSE;
16204: l_close_if := TRUE;
16205: END IF;
16206: IF l_operation = 'LIKE' then
16207: l_value :=''''||HZ_TRANS_PKG.EXACT(l_value,NULL,l_attribute_name,l_entity_name)||'%''';
16208: ELSIF l_operation = 'IN' then
16209: l_tmp_value := l_value;
16210: l_value := NULL;
16211: LOOP

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

16210: l_value := NULL;
16211: LOOP
16212: l_index := instrb(l_tmp_value,',');
16213: IF l_index =0 then
16214: l_value := l_value ||','''||HZ_TRANS_PKG.EXACT(l_tmp_value,NULL,l_attribute_name,l_entity_name)||'''';
16215: l_value := '('||ltrim(l_value,',')||')';
16216: exit;
16217: END IF;
16218: l_value := l_value ||','''||HZ_TRANS_PKG.EXACT(substrb(l_tmp_value,1,l_index-1),NULL,l_attribute_name,l_entity_name)||'''';

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

16214: l_value := l_value ||','''||HZ_TRANS_PKG.EXACT(l_tmp_value,NULL,l_attribute_name,l_entity_name)||'''';
16215: l_value := '('||ltrim(l_value,',')||')';
16216: exit;
16217: END IF;
16218: l_value := l_value ||','''||HZ_TRANS_PKG.EXACT(substrb(l_tmp_value,1,l_index-1),NULL,l_attribute_name,l_entity_name)||'''';
16219: l_tmp_value := substrb(l_tmp_value,l_index+1);
16220: END LOOP;
16221:
16222: ELSE

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

16219: l_tmp_value := substrb(l_tmp_value,l_index+1);
16220: END LOOP;
16221:
16222: ELSE
16223: l_value :=''''||HZ_TRANS_PKG.EXACT(l_value,NULL,l_attribute_name,l_entity_name)||'''';
16224: END IF;
16225:
16226: IF l_entity_name = 'PARTY' THEN
16227: l_cond_string := 'HZ_TRANS_PKG.EXACT(p_party_search_rec.'||l_attribute_name||',NULL,'''||

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

16223: l_value :=''''||HZ_TRANS_PKG.EXACT(l_value,NULL,l_attribute_name,l_entity_name)||'''';
16224: END IF;
16225:
16226: IF l_entity_name = 'PARTY' THEN
16227: l_cond_string := 'HZ_TRANS_PKG.EXACT(p_party_search_rec.'||l_attribute_name||',NULL,'''||
16228: l_attribute_name||''',''PARTY'') '|| l_operation ||' '|| l_value;
16229: ELSIF l_entity_name = 'PARTY_SITES' THEN
16230: 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).'||
16231: l_attribute_name||',NULL,'''||l_attribute_name||''',''PARTY_SITES'') '|| l_operation ||' '|| l_value ||')';

Line 16230: 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).'||

16226: IF l_entity_name = 'PARTY' THEN
16227: l_cond_string := 'HZ_TRANS_PKG.EXACT(p_party_search_rec.'||l_attribute_name||',NULL,'''||
16228: l_attribute_name||''',''PARTY'') '|| l_operation ||' '|| l_value;
16229: ELSIF l_entity_name = 'PARTY_SITES' THEN
16230: 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).'||
16231: l_attribute_name||',NULL,'''||l_attribute_name||''',''PARTY_SITES'') '|| l_operation ||' '|| l_value ||')';
16232: ELSIF l_entity_name = 'CONTACTS' THEN
16233: l_cond_string := '(p_contact_list IS NOT NULL AND p_contact_list.COUNT >0) AND (HZ_TRANS_PKG.EXACT(p_contact_list(1).'||
16234: l_attribute_name||',NULL,'''||l_attribute_name||''',''CONTACTS'') '|| l_operation ||' '|| l_value ||')';

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

16229: ELSIF l_entity_name = 'PARTY_SITES' THEN
16230: 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).'||
16231: l_attribute_name||',NULL,'''||l_attribute_name||''',''PARTY_SITES'') '|| l_operation ||' '|| l_value ||')';
16232: ELSIF l_entity_name = 'CONTACTS' THEN
16233: l_cond_string := '(p_contact_list IS NOT NULL AND p_contact_list.COUNT >0) AND (HZ_TRANS_PKG.EXACT(p_contact_list(1).'||
16234: l_attribute_name||',NULL,'''||l_attribute_name||''',''CONTACTS'') '|| l_operation ||' '|| l_value ||')';
16235: ELSIF l_entity_name = 'CONTACT_POINTS' THEN
16236: 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).'||
16237: l_attribute_name||',NULL,'''||l_attribute_name||''',''CONTACT_POINTS'') '|| l_operation ||' '|| l_value ||')';

Line 16236: 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).'||

16232: ELSIF l_entity_name = 'CONTACTS' THEN
16233: l_cond_string := '(p_contact_list IS NOT NULL AND p_contact_list.COUNT >0) AND (HZ_TRANS_PKG.EXACT(p_contact_list(1).'||
16234: l_attribute_name||',NULL,'''||l_attribute_name||''',''CONTACTS'') '|| l_operation ||' '|| l_value ||')';
16235: ELSIF l_entity_name = 'CONTACT_POINTS' THEN
16236: 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).'||
16237: l_attribute_name||',NULL,'''||l_attribute_name||''',''CONTACT_POINTS'') '|| l_operation ||' '|| l_value ||')';
16238: END IF;
16239: IF l_add_then THEN
16240: l_cond_string := l_cond_string || ' THEN ';