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_PARTIES

Line 146: insert /+ append / into hz_thin_st_parties

142:
143: IF p_entity = 'PARTIES'
144: THEN
145: log('Start Time for Parties ' || TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
146: insert /*+ append */ into hz_thin_st_parties
147: (party_id, status, partition_id, parent_rowid, concat_col)
148: select party_id, status, decode(TX36, 'ORGANIZATION ',0,'PERSON ',1,1),ROWID,null
149: from hz_shadow_st_parties;
150: log('End Time for Parties ' || TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));

Line 241: l_sql := ' select owner from sys.all_tables where table_name = ''HZ_THIN_ST_PARTIES'' and owner = :1';

237: log('---------------------------------------------------');
238: log('Calling truncate_thin_tables ');
239:
240: IF (fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_owner1)) THEN
241: l_sql := ' select owner from sys.all_tables where table_name = ''HZ_THIN_ST_PARTIES'' and owner = :1';
242: EXECUTE IMMEDIATE l_sql into l_owner USING l_owner1;
243: /* select owner into l_owner from sys.all_objects
244: where object_name = 'HZ_THIN_ST_PARTIES' and OBJECT_TYPE = 'TABLE' and
245: owner = l_owner1;*/

Line 244: where object_name = 'HZ_THIN_ST_PARTIES' and OBJECT_TYPE = 'TABLE' and

240: IF (fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_owner1)) THEN
241: l_sql := ' select owner from sys.all_tables where table_name = ''HZ_THIN_ST_PARTIES'' and owner = :1';
242: EXECUTE IMMEDIATE l_sql into l_owner USING l_owner1;
243: /* select owner into l_owner from sys.all_objects
244: where object_name = 'HZ_THIN_ST_PARTIES' and OBJECT_TYPE = 'TABLE' and
245: owner = l_owner1;*/
246: END IF;
247: log('Truncating HZ_THIN_ST_PARTIES .. ', FALSE);
248: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_owner||'.HZ_THIN_ST_PARTIES';

Line 247: log('Truncating HZ_THIN_ST_PARTIES .. ', FALSE);

243: /* select owner into l_owner from sys.all_objects
244: where object_name = 'HZ_THIN_ST_PARTIES' and OBJECT_TYPE = 'TABLE' and
245: owner = l_owner1;*/
246: END IF;
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);

Line 248: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_owner||'.HZ_THIN_ST_PARTIES';

244: where object_name = 'HZ_THIN_ST_PARTIES' and OBJECT_TYPE = 'TABLE' and
245: owner = l_owner1;*/
246: END IF;
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';

Line 324: l(' ,p.STATUS from hz_shadow_st_parties p,hz_thin_st_parties t '); -- Bug 5209633

320:
321: -- Begin Code changes for bug 5155761
322: if p_entity = 'PARTY' then
323: l(' data ');
324: l(' ,p.STATUS from hz_shadow_st_parties p,hz_thin_st_parties t '); -- Bug 5209633
325: end if;
326:
327: --Create party_id, person_party and contact_point_type section
328: if p_entity = 'PARTY_SITES' then

Line 652: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_parties_t1 FORCE';

648: log('---------------------------------------------------');
649: log('Calling drop_context_indexes');
650: log('Dropping Context Indexes on Thin tables');
651: BEGIN
652: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_parties_t1 FORCE';
653: log('Dropped hz_thin_st_parties_t1');
654: EXCEPTION
655: WHEN OTHERS THEN
656: log('Exception while dropping hz_thin_st_parties_t1. Error is ' || SQLERRM );

Line 653: log('Dropped hz_thin_st_parties_t1');

649: log('Calling drop_context_indexes');
650: log('Dropping Context Indexes on Thin tables');
651: BEGIN
652: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_parties_t1 FORCE';
653: log('Dropped hz_thin_st_parties_t1');
654: EXCEPTION
655: WHEN OTHERS THEN
656: log('Exception while dropping hz_thin_st_parties_t1. Error is ' || SQLERRM );
657: NULL;

Line 656: log('Exception while dropping hz_thin_st_parties_t1. Error is ' || SQLERRM );

652: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_parties_t1 FORCE';
653: log('Dropped hz_thin_st_parties_t1');
654: EXCEPTION
655: WHEN OTHERS THEN
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';

Line 1093: log('Truncating HZ_THIN_ST_PARTIES .. ', FALSE);

1089: l_end_flag:=NULL;
1090: END;
1091: IF nvl(l_end_flag,'N') = 'N' THEN
1092: if nvl(l_start_flag, 'N') = 'Y' then
1093: log('Truncating HZ_THIN_ST_PARTIES .. ', FALSE);
1094: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_index_owner||'.HZ_THIN_ST_PARTIES';
1095: log('Done');
1096: end if;
1097: UPDATE HZ_DQM_STAGE_LOG set START_FLAG = 'Y', END_TIME=SYSDATE

Line 1094: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_index_owner||'.HZ_THIN_ST_PARTIES';

1090: END;
1091: IF nvl(l_end_flag,'N') = 'N' THEN
1092: if nvl(l_start_flag, 'N') = 'Y' then
1093: log('Truncating HZ_THIN_ST_PARTIES .. ', FALSE);
1094: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_index_owner||'.HZ_THIN_ST_PARTIES';
1095: log('Done');
1096: end if;
1097: UPDATE HZ_DQM_STAGE_LOG set START_FLAG = 'Y', END_TIME=SYSDATE
1098: WHERE operation = 'SHADOW_POPULATE_THIN' AND step ='HZ_PARTIES';

Line 1212: SELECT 1 INTO T FROM HZ_THIN_ST_PARTIES

1208: if I = 1 then
1209: l_index := 'HZ_PARTIES';
1210: if create_index_flag = false and STAGE_NEW_TRANSFORMATIONS = false then
1211: BEGIN
1212: SELECT 1 INTO T FROM HZ_THIN_ST_PARTIES
1213: WHERE ROWNUM=1
1214: AND CONTAINS (concat_col, 'dummy_string')>0;
1215: EXCEPTION
1216: WHEN NO_DATA_FOUND THEN

Line 1220: log('hz_thin_st_parties_t1 is valid. No recreation necessary.');

1216: WHEN NO_DATA_FOUND THEN
1217: UPDATE HZ_DQM_STAGE_LOG
1218: SET START_FLAG ='Y', START_TIME=SYSDATE,END_FLAG = 'Y', END_TIME=SYSDATE
1219: WHERE OPERATION = 'SHADOW_CREATE_INDEXES' AND step = 'HZ_PARTIES';
1220: log('hz_thin_st_parties_t1 is valid. No recreation necessary.');
1221: WHEN OTHERS THEN
1222: BEGIN
1223: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_parties_t1 FORCE';
1224: log('Dropped hz_thin_st_parties_t1');

Line 1223: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_parties_t1 FORCE';

1219: WHERE OPERATION = 'SHADOW_CREATE_INDEXES' AND step = 'HZ_PARTIES';
1220: log('hz_thin_st_parties_t1 is valid. No recreation necessary.');
1221: WHEN OTHERS THEN
1222: BEGIN
1223: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_parties_t1 FORCE';
1224: log('Dropped hz_thin_st_parties_t1');
1225: EXCEPTION
1226: WHEN OTHERS THEN
1227: log('Exception while dropping hz_thin_st_parties_t1. Error is ' || SQLERRM );

Line 1224: log('Dropped hz_thin_st_parties_t1');

1220: log('hz_thin_st_parties_t1 is valid. No recreation necessary.');
1221: WHEN OTHERS THEN
1222: BEGIN
1223: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_parties_t1 FORCE';
1224: log('Dropped hz_thin_st_parties_t1');
1225: EXCEPTION
1226: WHEN OTHERS THEN
1227: log('Exception while dropping hz_thin_st_parties_t1. Error is ' || SQLERRM );
1228: NULL;

Line 1227: log('Exception while dropping hz_thin_st_parties_t1. Error is ' || SQLERRM );

1223: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_parties_t1 FORCE';
1224: log('Dropped hz_thin_st_parties_t1');
1225: EXCEPTION
1226: WHEN OTHERS THEN
1227: log('Exception while dropping hz_thin_st_parties_t1. Error is ' || SQLERRM );
1228: NULL;
1229: END;
1230: create_index_flag := true;
1231: END;

Line 1778: log('Attempting restart build of index '||l_index_owner || '.hz_thin_st_parties_t1');

1774: END;
1775:
1776: IF nvl(l_start_flag,'N') = 'Y' THEN
1777: BEGIN
1778: log('Attempting restart build of index '||l_index_owner || '.hz_thin_st_parties_t1');
1779: EXECUTE IMMEDIATE 'ALTER INDEX ' || l_index_owner ||
1780: '.hz_thin_st_parties_t1 rebuild parameters(''resume memory ' || p_idx_mem || ''')';
1781: log('Index Successfully built');
1782:

Line 1780: '.hz_thin_st_parties_t1 rebuild parameters(''resume memory ' || p_idx_mem || ''')';

1776: IF nvl(l_start_flag,'N') = 'Y' THEN
1777: BEGIN
1778: log('Attempting restart build of index '||l_index_owner || '.hz_thin_st_parties_t1');
1779: EXECUTE IMMEDIATE 'ALTER INDEX ' || l_index_owner ||
1780: '.hz_thin_st_parties_t1 rebuild parameters(''resume memory ' || p_idx_mem || ''')';
1781: log('Index Successfully built');
1782:
1783: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE
1784: WHERE operation = 'SHADOW_CREATE_INDEXES' AND step ='HZ_PARTIES';

Line 1791: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_parties_t1 FORCE';

1787: EXCEPTION
1788: WHEN OTHERS THEN
1789: log('Restart Unsuccesful .. Recreating');
1790: BEGIN
1791: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_parties_t1 FORCE';
1792: log('Dropped hz_thin_st_parties_t1');
1793: EXCEPTION
1794: WHEN OTHERS THEN
1795: NULL;

Line 1792: log('Dropped hz_thin_st_parties_t1');

1788: WHEN OTHERS THEN
1789: log('Restart Unsuccesful .. Recreating');
1790: BEGIN
1791: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_parties_t1 FORCE';
1792: log('Dropped hz_thin_st_parties_t1');
1793: EXCEPTION
1794: WHEN OTHERS THEN
1795: NULL;
1796: END;

Line 1812: log(' Creating hz_thin_st_parties_t1 on hz_thin_st_parties .');

1808: COMMIT;
1809:
1810: l_section_grp := g_schema_name || '.HZ_DQM_PARTY_GRP';
1811:
1812: log(' Creating hz_thin_st_parties_t1 on hz_thin_st_parties .');
1813: log(' Index Memory ' || p_idx_mem);
1814: log(' Starting at ' || to_char(SYSDATE, 'HH24:MI:SS') );
1815:
1816: -- commenting the sync part || ' sync (every "sysdate+(1/24)")'

Line 1817: EXECUTE IMMEDIATE 'CREATE INDEX ' || l_index_owner || '.hz_thin_st_parties_t1 ON ' ||

1813: log(' Index Memory ' || p_idx_mem);
1814: log(' Starting at ' || to_char(SYSDATE, 'HH24:MI:SS') );
1815:
1816: -- commenting the sync part || ' sync (every "sysdate+(1/24)")'
1817: EXECUTE IMMEDIATE 'CREATE INDEX ' || l_index_owner || '.hz_thin_st_parties_t1 ON ' ||
1818: 'hz_thin_st_parties(concat_col) indextype is ctxsys.context ' ||
1819: 'parameters (''storage '||g_schema_name || '.HZ_DQM_STORAGE datastore '||g_schema_name || '.hz_party_uds ' ||
1820: 'SECTION GROUP '||l_section_grp||' STOPLIST CTXSYS.EMPTY_STOPLIST LEXER '||g_schema_name || '.dqm_lexer memory ' ||
1821: p_idx_mem /* || ' sync (every "sysdate+(5/1440)")' */ || ''')';

Line 1818: 'hz_thin_st_parties(concat_col) indextype is ctxsys.context ' ||

1814: log(' Starting at ' || to_char(SYSDATE, 'HH24:MI:SS') );
1815:
1816: -- commenting the sync part || ' sync (every "sysdate+(1/24)")'
1817: EXECUTE IMMEDIATE 'CREATE INDEX ' || l_index_owner || '.hz_thin_st_parties_t1 ON ' ||
1818: 'hz_thin_st_parties(concat_col) indextype is ctxsys.context ' ||
1819: 'parameters (''storage '||g_schema_name || '.HZ_DQM_STORAGE datastore '||g_schema_name || '.hz_party_uds ' ||
1820: 'SECTION GROUP '||l_section_grp||' STOPLIST CTXSYS.EMPTY_STOPLIST LEXER '||g_schema_name || '.dqm_lexer memory ' ||
1821: p_idx_mem /* || ' sync (every "sysdate+(5/1440)")' */ || ''')';
1822: