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_PSITES

Line 154: insert /+ append / into hz_thin_st_psites

150: log('End Time for Parties ' || TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
151: ELSIF p_entity = 'PARTY_SITES'
152: THEN
153: log('Start Time for Party Sites ' || TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
154: insert /*+ append */ into hz_thin_st_psites
155: (party_id, party_site_id, person_party_id, qkey, org_contact_id,
156: parent_rowid, concat_col,status_flag) -- Bug No: 4299785
157: select decode(party_id,person_party_id,NULL,party_id), party_site_id,person_party_id, qkey,org_contact_id,ROWID,null,status_flag -- Fix for bug 5155761
158: --select party_id, party_site_id,person_party_id, qkey,org_contact_id,ROWID,null,status_flag -- Bug No: 4299785

Line 251: log('Truncating HZ_THIN_ST_PSITES .. ', FALSE);

247: log('Truncating HZ_THIN_ST_PARTIES .. ', FALSE);
248: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_owner||'.HZ_THIN_ST_PARTIES';
249: log('Done');
250:
251: log('Truncating HZ_THIN_ST_PSITES .. ', FALSE);
252: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_owner||'.HZ_THIN_ST_PSITES';
253: log('Done');
254:
255: log('Truncating HZ_THIN_ST_CONTACTS .. ', FALSE);

Line 252: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_owner||'.HZ_THIN_ST_PSITES';

248: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_owner||'.HZ_THIN_ST_PARTIES';
249: log('Done');
250:
251: log('Truncating HZ_THIN_ST_PSITES .. ', FALSE);
252: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_owner||'.HZ_THIN_ST_PSITES';
253: log('Done');
254:
255: log('Truncating HZ_THIN_ST_CONTACTS .. ', FALSE);
256: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_owner||'.HZ_THIN_ST_CONTACTS';

Line 338: l(' from hz_shadow_st_psites p,hz_thin_st_psites t ');

334: l_trns1 := 'P.PERSON_PARTY_ID';
335: l('||');
336: l('''<'||l_trns||'>'''||'||'||l_trns1||'||''''');
337: l(' data ');
338: l(' from hz_shadow_st_psites p,hz_thin_st_psites t ');
339: end if;
340: if p_entity = 'CONTACTS' then
341: l_trns := 'PARTY_ID';
342: l_trns1 := 'P.PARTY_ID';

Line 660: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_psites_t1 FORCE';

656: log('Exception while dropping hz_thin_st_parties_t1. Error is ' || SQLERRM );
657: NULL;
658: END;
659: BEGIN
660: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_psites_t1 FORCE';
661: log('Dropped hz_thin_st_psites_t1');
662: EXCEPTION
663: WHEN OTHERS THEN
664: log('Exception while dropping hz_thin_st_psites_t1. Error is ' || SQLERRM );

Line 661: log('Dropped hz_thin_st_psites_t1');

657: NULL;
658: END;
659: BEGIN
660: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_psites_t1 FORCE';
661: log('Dropped hz_thin_st_psites_t1');
662: EXCEPTION
663: WHEN OTHERS THEN
664: log('Exception while dropping hz_thin_st_psites_t1. Error is ' || SQLERRM );
665: NULL;

Line 664: log('Exception while dropping hz_thin_st_psites_t1. Error is ' || SQLERRM );

660: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_psites_t1 FORCE';
661: log('Dropped hz_thin_st_psites_t1');
662: EXCEPTION
663: WHEN OTHERS THEN
664: log('Exception while dropping hz_thin_st_psites_t1. Error is ' || SQLERRM );
665: NULL;
666: END;
667: BEGIN
668: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_contacts_t1 FORCE';

Line 1117: log('Truncating HZ_THIN_ST_PSITES .. ', FALSE);

1113: l_end_flag:=NULL;
1114: END;
1115: IF nvl(l_end_flag,'N') = 'N' THEN
1116: if nvl(l_start_flag, 'N') = 'Y' then
1117: log('Truncating HZ_THIN_ST_PSITES .. ', FALSE);
1118: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_index_owner||'.HZ_THIN_ST_PSITES';
1119: log('Done');
1120: end if;
1121: UPDATE HZ_DQM_STAGE_LOG set START_FLAG = 'Y', END_TIME=SYSDATE

Line 1118: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_index_owner||'.HZ_THIN_ST_PSITES';

1114: END;
1115: IF nvl(l_end_flag,'N') = 'N' THEN
1116: if nvl(l_start_flag, 'N') = 'Y' then
1117: log('Truncating HZ_THIN_ST_PSITES .. ', FALSE);
1118: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_index_owner||'.HZ_THIN_ST_PSITES';
1119: log('Done');
1120: end if;
1121: UPDATE HZ_DQM_STAGE_LOG set START_FLAG = 'Y', END_TIME=SYSDATE
1122: WHERE operation = 'SHADOW_POPULATE_THIN' AND step ='HZ_PARTY_SITES';

Line 1237: SELECT 1 INTO T FROM HZ_THIN_ST_PSITES

1233: elsif I = 2 then
1234: l_index := 'HZ_PARTY_SITES';
1235: if create_index_flag = false and STAGE_NEW_TRANSFORMATIONS = false then
1236: BEGIN
1237: SELECT 1 INTO T FROM HZ_THIN_ST_PSITES
1238: WHERE ROWNUM=1
1239: AND CONTAINS (concat_col, 'dummy_string')>0;
1240: EXCEPTION
1241: WHEN NO_DATA_FOUND THEN

Line 1245: log('hz_thin_st_psites_t1 is valid. No recreation necessary.');

1241: WHEN NO_DATA_FOUND THEN
1242: UPDATE HZ_DQM_STAGE_LOG
1243: SET START_FLAG ='Y', START_TIME=SYSDATE,END_FLAG = 'Y', END_TIME=SYSDATE
1244: WHERE OPERATION = 'SHADOW_CREATE_INDEXES' AND step = 'HZ_PARTY_SITES';
1245: log('hz_thin_st_psites_t1 is valid. No recreation necessary.');
1246: WHEN OTHERS THEN
1247: BEGIN
1248: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_psites_t1 FORCE';
1249: log('Dropped hz_thin_st_psites_t1');

Line 1248: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_psites_t1 FORCE';

1244: WHERE OPERATION = 'SHADOW_CREATE_INDEXES' AND step = 'HZ_PARTY_SITES';
1245: log('hz_thin_st_psites_t1 is valid. No recreation necessary.');
1246: WHEN OTHERS THEN
1247: BEGIN
1248: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_psites_t1 FORCE';
1249: log('Dropped hz_thin_st_psites_t1');
1250: EXCEPTION
1251: WHEN OTHERS THEN
1252: log('Exception while dropping hz_thin_st_psites_t1. Error is ' || SQLERRM );

Line 1249: log('Dropped hz_thin_st_psites_t1');

1245: log('hz_thin_st_psites_t1 is valid. No recreation necessary.');
1246: WHEN OTHERS THEN
1247: BEGIN
1248: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_psites_t1 FORCE';
1249: log('Dropped hz_thin_st_psites_t1');
1250: EXCEPTION
1251: WHEN OTHERS THEN
1252: log('Exception while dropping hz_thin_st_psites_t1. Error is ' || SQLERRM );
1253: NULL;

Line 1252: log('Exception while dropping hz_thin_st_psites_t1. Error is ' || SQLERRM );

1248: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_psites_t1 FORCE';
1249: log('Dropped hz_thin_st_psites_t1');
1250: EXCEPTION
1251: WHEN OTHERS THEN
1252: log('Exception while dropping hz_thin_st_psites_t1. Error is ' || SQLERRM );
1253: NULL;
1254: END;
1255: create_index_flag := true;
1256: END;

Line 1859: log('Attempting restart build of index '||l_index_owner || '.hz_thin_st_psites_t1');

1855: END;
1856:
1857: IF nvl(l_start_flag,'N') = 'Y' THEN
1858: BEGIN
1859: log('Attempting restart build of index '||l_index_owner || '.hz_thin_st_psites_t1');
1860: EXECUTE IMMEDIATE 'ALTER INDEX ' || l_index_owner ||
1861: '.hz_thin_st_psites_t1 rebuild parameters(''resume memory ' || p_idx_mem /*|| 'sync (every "sysdate+(1/24)")'*/ || ''')';
1862: log('Index Successfully built');
1863:

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

1857: IF nvl(l_start_flag,'N') = 'Y' THEN
1858: BEGIN
1859: log('Attempting restart build of index '||l_index_owner || '.hz_thin_st_psites_t1');
1860: EXECUTE IMMEDIATE 'ALTER INDEX ' || l_index_owner ||
1861: '.hz_thin_st_psites_t1 rebuild parameters(''resume memory ' || p_idx_mem /*|| 'sync (every "sysdate+(1/24)")'*/ || ''')';
1862: log('Index Successfully built');
1863:
1864: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE
1865: WHERE operation = 'SHADOW_CREATE_INDEXES' AND step ='HZ_PARTY_SITES';

Line 1872: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_psites_t1 FORCE';

1868: EXCEPTION
1869: WHEN OTHERS THEN
1870: log('Restart Unsuccesful .. Recreating');
1871: BEGIN
1872: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_psites_t1 FORCE';
1873: log('Dropped hz_thin_st_psites_t1');
1874: EXCEPTION
1875: WHEN OTHERS THEN
1876: NULL;

Line 1873: log('Dropped hz_thin_st_psites_t1');

1869: WHEN OTHERS THEN
1870: log('Restart Unsuccesful .. Recreating');
1871: BEGIN
1872: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_psites_t1 FORCE';
1873: log('Dropped hz_thin_st_psites_t1');
1874: EXCEPTION
1875: WHEN OTHERS THEN
1876: NULL;
1877: END;

Line 1894: log(' Creating hz_thin_st_psites_t1 on hz_thin_st_psites. ');

1890: COMMIT;
1891:
1892: l_section_grp := g_schema_name || '.HZ_DQM_PS_GRP';
1893:
1894: log(' Creating hz_thin_st_psites_t1 on hz_thin_st_psites. ');
1895: log(' Index Memory ' || p_idx_mem);
1896: log(' Starting at ' || to_char(SYSDATE, 'HH24:MI:SS'));
1897:
1898: -- commenting the sync part || ' sync (every "sysdate+(1/24)")'

Line 1899: EXECUTE IMMEDIATE 'CREATE INDEX ' || l_index_owner || '.hz_thin_st_psites_t1 ON ' ||

1895: log(' Index Memory ' || p_idx_mem);
1896: log(' Starting at ' || to_char(SYSDATE, 'HH24:MI:SS'));
1897:
1898: -- commenting the sync part || ' sync (every "sysdate+(1/24)")'
1899: EXECUTE IMMEDIATE 'CREATE INDEX ' || l_index_owner || '.hz_thin_st_psites_t1 ON ' ||
1900: 'hz_thin_st_psites(concat_col) indextype is ctxsys.context ' ||
1901: 'parameters (''storage '||g_schema_name || '.HZ_DQM_STORAGE datastore '||g_schema_name || '.hz_party_site_uds ' ||
1902: 'SECTION GROUP '||l_section_grp||' STOPLIST CTXSYS.EMPTY_STOPLIST LEXER '||g_schema_name || '.dqm_lexer memory ' ||
1903: p_idx_mem /* || ' sync (every "sysdate+(5/1440)")' */ || ''')';

Line 1900: 'hz_thin_st_psites(concat_col) indextype is ctxsys.context ' ||

1896: log(' Starting at ' || to_char(SYSDATE, 'HH24:MI:SS'));
1897:
1898: -- commenting the sync part || ' sync (every "sysdate+(1/24)")'
1899: EXECUTE IMMEDIATE 'CREATE INDEX ' || l_index_owner || '.hz_thin_st_psites_t1 ON ' ||
1900: 'hz_thin_st_psites(concat_col) indextype is ctxsys.context ' ||
1901: 'parameters (''storage '||g_schema_name || '.HZ_DQM_STORAGE datastore '||g_schema_name || '.hz_party_site_uds ' ||
1902: 'SECTION GROUP '||l_section_grp||' STOPLIST CTXSYS.EMPTY_STOPLIST LEXER '||g_schema_name || '.dqm_lexer memory ' ||
1903: p_idx_mem /* || ' sync (every "sysdate+(5/1440)")' */ || ''')';
1904: