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_CONTACTS

Line 164: insert /+ append / into hz_thin_st_contacts

160: log('End Time for Party Sites ' || TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
161: ELSIF p_entity = 'CONTACTS'
162: THEN
163: log('Start Time for Contacts ' || TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
164: insert /*+ append */ into hz_thin_st_contacts
165: (party_id, person_party_id, qkey, org_contact_id, parent_rowid, concat_col,status_flag) -- Fix for bug 5155761
166: select decode(party_id,person_party_id,NULL,party_id),person_party_id, qkey,org_contact_id,ROWID,null,status_flag -- Fix for bug 5155761
167: --(party_id, qkey, org_contact_id, parent_rowid, concat_col,status_flag)-- Bug No: 4299785
168: --select party_id, qkey,org_contact_id,ROWID,null,status_flag -- Bug No: 4299785

Line 255: log('Truncating HZ_THIN_ST_CONTACTS .. ', FALSE);

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';
257: log('Done');
258:
259: log('Truncating HZ_THIN_ST_CPTS .. ', FALSE);

Line 256: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_owner||'.HZ_THIN_ST_CONTACTS';

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';
257: log('Done');
258:
259: log('Truncating HZ_THIN_ST_CPTS .. ', FALSE);
260: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_owner||'.HZ_THIN_ST_CPTS';

Line 350: l(' from hz_shadow_st_contacts p,hz_thin_st_contacts t ');

346: l_trns1 := 'P.PERSON_PARTY_ID';
347: l('||');
348: l('''<'||l_trns||'>'''||'||'||l_trns1||'||''''');
349: l(' data ');
350: l(' from hz_shadow_st_contacts p,hz_thin_st_contacts t ');
351: end if;
352: if p_entity = 'CONTACT_POINTS' then
353: l_trns := 'PARTY_ID';
354: l_trns1 := 'P.PARTY_ID';

Line 668: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_contacts_t1 FORCE';

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';
669: log('Dropped hz_thin_st_contacts_t1');
670: EXCEPTION
671: WHEN OTHERS THEN
672: log('Exception while dropping hz_thin_st_contacts_t1. Error is ' || SQLERRM );

Line 669: log('Dropped hz_thin_st_contacts_t1');

665: NULL;
666: END;
667: BEGIN
668: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_contacts_t1 FORCE';
669: log('Dropped hz_thin_st_contacts_t1');
670: EXCEPTION
671: WHEN OTHERS THEN
672: log('Exception while dropping hz_thin_st_contacts_t1. Error is ' || SQLERRM );
673: NULL;

Line 672: log('Exception while dropping hz_thin_st_contacts_t1. Error is ' || SQLERRM );

668: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_contacts_t1 FORCE';
669: log('Dropped hz_thin_st_contacts_t1');
670: EXCEPTION
671: WHEN OTHERS THEN
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';

Line 1141: log('Truncating HZ_THIN_ST_CONTACTS .. ', FALSE);

1137: l_end_flag:=NULL;
1138: END;
1139: IF nvl(l_end_flag,'N') = 'N' THEN
1140: if nvl(l_start_flag, 'N') = 'Y' then
1141: log('Truncating HZ_THIN_ST_CONTACTS .. ', FALSE);
1142: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_index_owner||'.HZ_THIN_ST_CONTACTS';
1143: log('Done');
1144: end if;
1145: UPDATE HZ_DQM_STAGE_LOG set START_FLAG = 'Y', END_TIME=SYSDATE

Line 1142: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_index_owner||'.HZ_THIN_ST_CONTACTS';

1138: END;
1139: IF nvl(l_end_flag,'N') = 'N' THEN
1140: if nvl(l_start_flag, 'N') = 'Y' then
1141: log('Truncating HZ_THIN_ST_CONTACTS .. ', FALSE);
1142: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_index_owner||'.HZ_THIN_ST_CONTACTS';
1143: log('Done');
1144: end if;
1145: UPDATE HZ_DQM_STAGE_LOG set START_FLAG = 'Y', END_TIME=SYSDATE
1146: WHERE operation = 'SHADOW_POPULATE_THIN' AND step ='HZ_ORG_CONTACTS';

Line 1262: SELECT 1 INTO T FROM HZ_THIN_ST_CONTACTS

1258: elsif I = 3 then
1259: l_index := 'HZ_ORG_CONTACTS';
1260: if create_index_flag = false and STAGE_NEW_TRANSFORMATIONS = false then
1261: BEGIN
1262: SELECT 1 INTO T FROM HZ_THIN_ST_CONTACTS
1263: WHERE ROWNUM=1
1264: AND CONTAINS (concat_col, 'dummy_string')>0;
1265: EXCEPTION
1266: WHEN NO_DATA_FOUND THEN

Line 1270: log('hz_thin_st_contacts_t1 is valid. No recreation necessary.');

1266: WHEN NO_DATA_FOUND THEN
1267: UPDATE HZ_DQM_STAGE_LOG
1268: SET START_FLAG ='Y', START_TIME=SYSDATE,END_FLAG = 'Y', END_TIME=SYSDATE
1269: WHERE OPERATION = 'SHADOW_CREATE_INDEXES' AND step = 'HZ_ORG_CONTACTS';
1270: log('hz_thin_st_contacts_t1 is valid. No recreation necessary.');
1271: WHEN OTHERS THEN
1272: BEGIN
1273: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_contacts_t1 FORCE';
1274: log('Dropped hz_thin_st_contacts_t1');

Line 1273: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_contacts_t1 FORCE';

1269: WHERE OPERATION = 'SHADOW_CREATE_INDEXES' AND step = 'HZ_ORG_CONTACTS';
1270: log('hz_thin_st_contacts_t1 is valid. No recreation necessary.');
1271: WHEN OTHERS THEN
1272: BEGIN
1273: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_contacts_t1 FORCE';
1274: log('Dropped hz_thin_st_contacts_t1');
1275: EXCEPTION
1276: WHEN OTHERS THEN
1277: log('Exception while dropping hz_thin_st_contacts_t1. Error is ' || SQLERRM );

Line 1274: log('Dropped hz_thin_st_contacts_t1');

1270: log('hz_thin_st_contacts_t1 is valid. No recreation necessary.');
1271: WHEN OTHERS THEN
1272: BEGIN
1273: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_contacts_t1 FORCE';
1274: log('Dropped hz_thin_st_contacts_t1');
1275: EXCEPTION
1276: WHEN OTHERS THEN
1277: log('Exception while dropping hz_thin_st_contacts_t1. Error is ' || SQLERRM );
1278: NULL;

Line 1277: log('Exception while dropping hz_thin_st_contacts_t1. Error is ' || SQLERRM );

1273: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_contacts_t1 FORCE';
1274: log('Dropped hz_thin_st_contacts_t1');
1275: EXCEPTION
1276: WHEN OTHERS THEN
1277: log('Exception while dropping hz_thin_st_contacts_t1. Error is ' || SQLERRM );
1278: NULL;
1279: END;
1280: create_index_flag := true;
1281: END;

Line 1940: log('Attempting restart build of index '||l_index_owner || '.hz_thin_st_contacts_t1');

1936: END;
1937:
1938: IF nvl(l_start_flag,'N') = 'Y' THEN
1939: BEGIN
1940: log('Attempting restart build of index '||l_index_owner || '.hz_thin_st_contacts_t1');
1941: EXECUTE IMMEDIATE 'ALTER INDEX ' || l_index_owner ||
1942: '.hz_thin_st_contacts_t1 rebuild parameters(''resume memory ' || p_idx_mem || ''')';
1943: log('Index Successfully built');
1944:

Line 1942: '.hz_thin_st_contacts_t1 rebuild parameters(''resume memory ' || p_idx_mem || ''')';

1938: IF nvl(l_start_flag,'N') = 'Y' THEN
1939: BEGIN
1940: log('Attempting restart build of index '||l_index_owner || '.hz_thin_st_contacts_t1');
1941: EXECUTE IMMEDIATE 'ALTER INDEX ' || l_index_owner ||
1942: '.hz_thin_st_contacts_t1 rebuild parameters(''resume memory ' || p_idx_mem || ''')';
1943: log('Index Successfully built');
1944:
1945: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE
1946: WHERE operation = 'SHADOW_CREATE_INDEXES' AND step ='HZ_ORG_CONTACTS';

Line 1953: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_contacts_t1 FORCE';

1949: EXCEPTION
1950: WHEN OTHERS THEN
1951: log('Restart unsuccessful. Recreating Index');
1952: BEGIN
1953: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_contacts_t1 FORCE';
1954: log('Dropped hz_thin_st_contacts_t1 ');
1955: EXCEPTION
1956: WHEN OTHERS THEN
1957: NULL;

Line 1954: log('Dropped hz_thin_st_contacts_t1 ');

1950: WHEN OTHERS THEN
1951: log('Restart unsuccessful. Recreating Index');
1952: BEGIN
1953: EXECUTE IMMEDIATE 'DROP INDEX ' || l_index_owner || '.hz_thin_st_contacts_t1 FORCE';
1954: log('Dropped hz_thin_st_contacts_t1 ');
1955: EXCEPTION
1956: WHEN OTHERS THEN
1957: NULL;
1958: END;

Line 1973: log(' Creating hz_thin_st_contacts_t1 on hz_thin_st_contacts. ');

1969:
1970: l_section_grp := g_schema_name || '.HZ_DQM_CONTACT_GRP';
1971:
1972:
1973: log(' Creating hz_thin_st_contacts_t1 on hz_thin_st_contacts. ');
1974: log(' Index Memory ' || p_idx_mem);
1975: log(' Starting at ' || to_char(SYSDATE, 'HH24:MI:SS'));
1976:
1977: -- commenting the sync part || 'sync (every "sysdate+(1/24)")'

Line 1978: EXECUTE IMMEDIATE 'CREATE INDEX ' || l_index_owner || '.hz_thin_st_contacts_t1 ON ' ||

1974: log(' Index Memory ' || p_idx_mem);
1975: log(' Starting at ' || to_char(SYSDATE, 'HH24:MI:SS'));
1976:
1977: -- commenting the sync part || 'sync (every "sysdate+(1/24)")'
1978: EXECUTE IMMEDIATE 'CREATE INDEX ' || l_index_owner || '.hz_thin_st_contacts_t1 ON ' ||
1979: 'hz_thin_st_contacts(concat_col) indextype is ctxsys.context ' ||
1980: 'parameters (''storage '||g_schema_name || '.HZ_DQM_STORAGE datastore '||g_schema_name || '.hz_contact_uds ' ||
1981: 'SECTION GROUP '||l_section_grp||' STOPLIST CTXSYS.EMPTY_STOPLIST LEXER '||g_schema_name || '.dqm_lexer memory '
1982: || p_idx_mem /* || ' sync (every "sysdate+(5/1440)")' */ || ''')';

Line 1979: 'hz_thin_st_contacts(concat_col) indextype is ctxsys.context ' ||

1975: log(' Starting at ' || to_char(SYSDATE, 'HH24:MI:SS'));
1976:
1977: -- commenting the sync part || 'sync (every "sysdate+(1/24)")'
1978: EXECUTE IMMEDIATE 'CREATE INDEX ' || l_index_owner || '.hz_thin_st_contacts_t1 ON ' ||
1979: 'hz_thin_st_contacts(concat_col) indextype is ctxsys.context ' ||
1980: 'parameters (''storage '||g_schema_name || '.HZ_DQM_STORAGE datastore '||g_schema_name || '.hz_contact_uds ' ||
1981: 'SECTION GROUP '||l_section_grp||' STOPLIST CTXSYS.EMPTY_STOPLIST LEXER '||g_schema_name || '.dqm_lexer memory '
1982: || p_idx_mem /* || ' sync (every "sysdate+(5/1440)")' */ || ''')';
1983: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE