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_PARTY_STAGE_SHADOW dependencies on HZ_THIN_ST_CPTS

Line 174: insert /+ append / into hz_thin_st_cpts

170: log('End Time for Contacts ' || TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
171: ELSIF p_entity = 'CONTACT_POINTS'
172: THEN
173: log('Start Time for Contact Points ' || TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
174: insert /*+ append */ into hz_thin_st_cpts
175: (party_id, partition_id, contact_point_id, party_site_id,
176: person_party_id, parent_rowid, org_contact_id, qkey, concat_col,status_flag) -- Bug No: 4299785
177: select decode(party_id,person_party_id,NULL,party_id), decode(contact_point_type,'PHONE',0,'EMAIL',1,2),contact_point_id,party_site_id, person_party_id,ROWID,org_contact_id, qkey, null,status_flag -- Fix for bug 5155761
178: --select party_id, decode(contact_point_type,'PHONE',0,'EMAIL',1,2),contact_point_id,party_site_id,person_party_id,ROWID,org_contact_id, qkey, null,status_flag -- Bug No: 4299785

Line 259: log('Truncating HZ_THIN_ST_CPTS .. ', FALSE);

255: log('Truncating HZ_THIN_ST_CONTACTS .. ', FALSE);
256: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_owner||'.HZ_THIN_ST_CONTACTS';
257: log('Done');
258:
259: log('Truncating HZ_THIN_ST_CPTS .. ', FALSE);
260: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_owner||'.HZ_THIN_ST_CPTS';
261: log('Done');
262:
263: EXCEPTION

Line 260: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_owner||'.HZ_THIN_ST_CPTS';

256: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_owner||'.HZ_THIN_ST_CONTACTS';
257: log('Done');
258:
259: log('Truncating HZ_THIN_ST_CPTS .. ', FALSE);
260: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_owner||'.HZ_THIN_ST_CPTS';
261: log('Done');
262:
263: EXCEPTION
264: WHEN OTHERS THEN

Line 366: l(' from HZ_SHADOW_ST_CPTS p,hz_thin_st_cpts t '); -- Bug 5209633

362: l_trns1 := 'P.CONTACT_POINT_TYPE';
363: l('||');
364: l('''<'||l_trns||'>'''||'||'||l_trns1||'||''''');
365: l(' data ');
366: l(' from HZ_SHADOW_ST_CPTS p,hz_thin_st_cpts t '); -- Bug 5209633
367: end if;
368: l(' where t.ROWID = rid and p.ROWID=parent_rowid) LOOP ');
369: l(' data := R.data;');
370: l(' dbms_lob.writeappend(tlob, length(data),data);');

Line 676: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_cpts_t1 FORCE';

672: log('Exception while dropping hz_thin_st_contacts_t1. Error is ' || SQLERRM );
673: NULL;
674: END;
675: BEGIN
676: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_cpts_t1 FORCE';
677: log('Dropped hz_thin_st_cpts_t1');
678: EXCEPTION
679: WHEN OTHERS THEN
680: log('Exception while dropping hz_thin_st_cpts_t1. Error is ' || SQLERRM );

Line 677: log('Dropped hz_thin_st_cpts_t1');

673: NULL;
674: END;
675: BEGIN
676: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_cpts_t1 FORCE';
677: log('Dropped hz_thin_st_cpts_t1');
678: EXCEPTION
679: WHEN OTHERS THEN
680: log('Exception while dropping hz_thin_st_cpts_t1. Error is ' || SQLERRM );
681: NULL;

Line 680: log('Exception while dropping hz_thin_st_cpts_t1. Error is ' || SQLERRM );

676: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_cpts_t1 FORCE';
677: log('Dropped hz_thin_st_cpts_t1');
678: EXCEPTION
679: WHEN OTHERS THEN
680: log('Exception while dropping hz_thin_st_cpts_t1. Error is ' || SQLERRM );
681: NULL;
682: END;
683: log('Done with dropping context indexes on Thin tables');
684: END;

Line 1165: log('Truncating HZ_THIN_ST_CPTS .. ', FALSE);

1161: l_end_flag:=NULL;
1162: END;
1163: IF nvl(l_end_flag,'N') = 'N' THEN
1164: if nvl(l_start_flag, 'N') = 'Y' then
1165: log('Truncating HZ_THIN_ST_CPTS .. ', FALSE);
1166: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_index_owner||'.HZ_THIN_ST_CPTS';
1167: log('Done');
1168: end if;
1169: UPDATE HZ_DQM_STAGE_LOG set START_FLAG = 'Y', END_TIME=SYSDATE

Line 1166: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_index_owner||'.HZ_THIN_ST_CPTS';

1162: END;
1163: IF nvl(l_end_flag,'N') = 'N' THEN
1164: if nvl(l_start_flag, 'N') = 'Y' then
1165: log('Truncating HZ_THIN_ST_CPTS .. ', FALSE);
1166: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_index_owner||'.HZ_THIN_ST_CPTS';
1167: log('Done');
1168: end if;
1169: UPDATE HZ_DQM_STAGE_LOG set START_FLAG = 'Y', END_TIME=SYSDATE
1170: WHERE operation = 'SHADOW_POPULATE_THIN' AND step ='HZ_CONTACT_POINTS';

Line 1287: SELECT 1 INTO T FROM HZ_THIN_ST_CPTS

1283: elsif I = 4 and STAGE_NEW_TRANSFORMATIONS = false then
1284: l_index := 'HZ_CONTACT_POINTS';
1285: if create_index_flag = false then
1286: BEGIN
1287: SELECT 1 INTO T FROM HZ_THIN_ST_CPTS
1288: WHERE ROWNUM=1
1289: AND CONTAINS (concat_col, 'dummy_string')>0;
1290: EXCEPTION
1291: WHEN NO_DATA_FOUND THEN

Line 1295: log('hz_thin_st_cpts_t1 is valid. No recreation necessary.');

1291: WHEN NO_DATA_FOUND THEN
1292: UPDATE HZ_DQM_STAGE_LOG
1293: SET START_FLAG ='Y', START_TIME=SYSDATE,END_FLAG = 'Y', END_TIME=SYSDATE
1294: WHERE OPERATION = 'SHADOW_CREATE_INDEXES' AND step = 'HZ_CONTACT_POINTS';
1295: log('hz_thin_st_cpts_t1 is valid. No recreation necessary.');
1296: WHEN OTHERS THEN
1297: BEGIN
1298: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_cpts_t1 FORCE';
1299: log('Dropped hz_thin_st_cpts_t1');

Line 1298: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_cpts_t1 FORCE';

1294: WHERE OPERATION = 'SHADOW_CREATE_INDEXES' AND step = 'HZ_CONTACT_POINTS';
1295: log('hz_thin_st_cpts_t1 is valid. No recreation necessary.');
1296: WHEN OTHERS THEN
1297: BEGIN
1298: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_cpts_t1 FORCE';
1299: log('Dropped hz_thin_st_cpts_t1');
1300: EXCEPTION
1301: WHEN OTHERS THEN
1302: log('Exception while dropping hz_thin_st_cpts_t1. Error is ' || SQLERRM );

Line 1299: log('Dropped hz_thin_st_cpts_t1');

1295: log('hz_thin_st_cpts_t1 is valid. No recreation necessary.');
1296: WHEN OTHERS THEN
1297: BEGIN
1298: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_cpts_t1 FORCE';
1299: log('Dropped hz_thin_st_cpts_t1');
1300: EXCEPTION
1301: WHEN OTHERS THEN
1302: log('Exception while dropping hz_thin_st_cpts_t1. Error is ' || SQLERRM );
1303: NULL;

Line 1302: log('Exception while dropping hz_thin_st_cpts_t1. Error is ' || SQLERRM );

1298: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_cpts_t1 FORCE';
1299: log('Dropped hz_thin_st_cpts_t1');
1300: EXCEPTION
1301: WHEN OTHERS THEN
1302: log('Exception while dropping hz_thin_st_cpts_t1. Error is ' || SQLERRM );
1303: NULL;
1304: END;
1305: create_index_flag := true;
1306: END;

Line 2017: log('Attempting restart build of index '||l_index_owner || '.hz_thin_st_cpts_t1');

2013: END;
2014:
2015: IF nvl(l_start_flag,'N') = 'Y' THEN
2016: BEGIN
2017: log('Attempting restart build of index '||l_index_owner || '.hz_thin_st_cpts_t1');
2018: EXECUTE IMMEDIATE 'ALTER INDEX ' || l_index_owner ||
2019: '.hz_thin_st_cpts_t1 rebuild parameters(''resume memory ' || p_idx_mem /* || 'sync (every "sysdate+(1/24)")' */ || ''')';
2020:
2021: log('Index Successfully built');

Line 2019: '.hz_thin_st_cpts_t1 rebuild parameters(''resume memory ' || p_idx_mem /* || 'sync (every "sysdate+(1/24)")' */ || ''')';

2015: IF nvl(l_start_flag,'N') = 'Y' THEN
2016: BEGIN
2017: log('Attempting restart build of index '||l_index_owner || '.hz_thin_st_cpts_t1');
2018: EXECUTE IMMEDIATE 'ALTER INDEX ' || l_index_owner ||
2019: '.hz_thin_st_cpts_t1 rebuild parameters(''resume memory ' || p_idx_mem /* || 'sync (every "sysdate+(1/24)")' */ || ''')';
2020:
2021: log('Index Successfully built');
2022: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE
2023: WHERE operation = 'SHADOW_CREATE_INDEXES' AND step ='HZ_CONTACT_POINTS';

Line 2030: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_cpts_t1 FORCE';

2026: EXCEPTION
2027: WHEN OTHERS THEN
2028: log('Restart unsuccessful. Rebuilding index.');
2029: BEGIN
2030: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_cpts_t1 FORCE';
2031: log('Dropped hz_thin_st_cpts_t1');
2032: EXCEPTION
2033: WHEN OTHERS THEN
2034: NULL;

Line 2031: log('Dropped hz_thin_st_cpts_t1');

2027: WHEN OTHERS THEN
2028: log('Restart unsuccessful. Rebuilding index.');
2029: BEGIN
2030: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_cpts_t1 FORCE';
2031: log('Dropped hz_thin_st_cpts_t1');
2032: EXCEPTION
2033: WHEN OTHERS THEN
2034: NULL;
2035: END;

Line 2050: log(' Creating hz_thin_st_cpts_t1 on hz_thin_st_cpts . ');

2046:
2047: l_section_grp := g_schema_name || '.HZ_DQM_CPT_GRP';
2048:
2049:
2050: log(' Creating hz_thin_st_cpts_t1 on hz_thin_st_cpts . ');
2051: log(' Index Memory ' || p_idx_mem);
2052: log(' Starting at ' || to_char(SYSDATE, 'HH24:MI:SS'));
2053: -- commenting the sync part || ' sync (every "sysdate+(1/24)")'
2054: EXECUTE IMMEDIATE 'CREATE INDEX ' || l_index_owner || '.hz_thin_st_cpts_t1 ON ' ||

Line 2054: EXECUTE IMMEDIATE 'CREATE INDEX ' || l_index_owner || '.hz_thin_st_cpts_t1 ON ' ||

2050: log(' Creating hz_thin_st_cpts_t1 on hz_thin_st_cpts . ');
2051: log(' Index Memory ' || p_idx_mem);
2052: log(' Starting at ' || to_char(SYSDATE, 'HH24:MI:SS'));
2053: -- commenting the sync part || ' sync (every "sysdate+(1/24)")'
2054: EXECUTE IMMEDIATE 'CREATE INDEX ' || l_index_owner || '.hz_thin_st_cpts_t1 ON ' ||
2055: 'hz_thin_st_cpts(concat_col) indextype is ctxsys.context ' ||
2056: 'parameters (''storage '||g_schema_name || '.HZ_DQM_STORAGE datastore '||g_schema_name || '.hz_contact_point_uds ' ||
2057: 'SECTION GROUP '||l_section_grp||' STOPLIST CTXSYS.EMPTY_STOPLIST LEXER '||g_schema_name || '.dqm_lexer memory '
2058: || p_idx_mem /* || ' sync (every "sysdate+(5/1440)")' */ || ''')';

Line 2055: 'hz_thin_st_cpts(concat_col) indextype is ctxsys.context ' ||

2051: log(' Index Memory ' || p_idx_mem);
2052: log(' Starting at ' || to_char(SYSDATE, 'HH24:MI:SS'));
2053: -- commenting the sync part || ' sync (every "sysdate+(1/24)")'
2054: EXECUTE IMMEDIATE 'CREATE INDEX ' || l_index_owner || '.hz_thin_st_cpts_t1 ON ' ||
2055: 'hz_thin_st_cpts(concat_col) indextype is ctxsys.context ' ||
2056: 'parameters (''storage '||g_schema_name || '.HZ_DQM_STORAGE datastore '||g_schema_name || '.hz_contact_point_uds ' ||
2057: 'SECTION GROUP '||l_section_grp||' STOPLIST CTXSYS.EMPTY_STOPLIST LEXER '||g_schema_name || '.dqm_lexer memory '
2058: || p_idx_mem /* || ' sync (every "sysdate+(5/1440)")' */ || ''')';
2059: