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_DQM_STAGE_LOG

Line 722: INSERT INTO HZ_DQM_STAGE_LOG (

718: p_num_workers NUMBER DEFAULT 0) IS
719:
720: BEGIN
721:
722: INSERT INTO HZ_DQM_STAGE_LOG (
723: OPERATION,
724: NUMBER_OF_WORKERS,
725: WORKER_NUMBER,
726: STEP,

Line 892: DELETE FROM HZ_DQM_STAGE_LOG

888:
889: -- REPURI. Bug 4884742. To delete the record
890: -- at the beginning of the staging program.
891:
892: DELETE FROM HZ_DQM_STAGE_LOG
893: WHERE operation = 'SHADOW_STAGING'
894: AND step = 'COMPLETE';
895:
896: -- req_data will be null the first time, by default

Line 916: SELECT count(*) into l_is_wildchar from HZ_DQM_STAGE_LOG where operation = 'SHADOW_STAGE_FOR_WILDCHAR_SRCH' and rownum = 1 ;

912:
913:
914: IF l_command = 'STAGE_ALL_DATA' THEN
915: BEGIN
916: SELECT count(*) into l_is_wildchar from HZ_DQM_STAGE_LOG where operation = 'SHADOW_STAGE_FOR_WILDCHAR_SRCH' and rownum = 1 ;
917: IF l_is_wildchar < 1 THEN
918: INSERT INTO HZ_DQM_STAGE_LOG(operation, number_of_workers, worker_number, step,
919: last_update_date, creation_date, created_by, last_updated_by)
920: VALUES ('SHADOW_STAGE_FOR_WILDCHAR_SRCH', '-1', '-1', 'Y', SYSDATE, SYSDATE, 0, 0);

Line 918: INSERT INTO HZ_DQM_STAGE_LOG(operation, number_of_workers, worker_number, step,

914: IF l_command = 'STAGE_ALL_DATA' THEN
915: BEGIN
916: SELECT count(*) into l_is_wildchar from HZ_DQM_STAGE_LOG where operation = 'SHADOW_STAGE_FOR_WILDCHAR_SRCH' and rownum = 1 ;
917: IF l_is_wildchar < 1 THEN
918: INSERT INTO HZ_DQM_STAGE_LOG(operation, number_of_workers, worker_number, step,
919: last_update_date, creation_date, created_by, last_updated_by)
920: VALUES ('SHADOW_STAGE_FOR_WILDCHAR_SRCH', '-1', '-1', 'Y', SYSDATE, SYSDATE, 0, 0);
921: END IF;
922:

Line 924: FROM HZ_DQM_STAGE_LOG

920: VALUES ('SHADOW_STAGE_FOR_WILDCHAR_SRCH', '-1', '-1', 'Y', SYSDATE, SYSDATE, 0, 0);
921: END IF;
922:
923: SELECT number_of_workers INTO l_last_num_workers
924: FROM HZ_DQM_STAGE_LOG
925: WHERE operation = l_command
926: AND STEP = 'SHADOW_INIT';
927:
928: IF l_last_num_workers<>l_num_workers AND l_continue = 'Y' THEN

Line 950: DELETE from HZ_DQM_STAGE_LOG where operation = l_command and

946: truncate_staging_tables ;
947: truncate_thin_tables ;
948: -- Verify the validity of transformations and custom procedures,
949: verify_all_procs;
950: DELETE from HZ_DQM_STAGE_LOG where operation = l_command and
951: step like 'SHADOW%';
952:
953:
954:

Line 971: DELETE from HZ_DQM_STAGE_LOG where operation = 'SHADOW_POPULATE_THIN';

967: p_worker_number=> J,
968: p_num_workers=>l_num_workers);
969: END LOOP;
970: END LOOP;
971: DELETE from HZ_DQM_STAGE_LOG where operation = 'SHADOW_POPULATE_THIN';
972: create_log(
973: p_operation=>'SHADOW_POPULATE_THIN',
974: p_step=>'HZ_PARTIES');
975: create_log(

Line 985: DELETE from HZ_DQM_STAGE_LOG where operation = 'SHADOW_CREATE_INDEXES';

981: create_log(
982: p_operation=>'SHADOW_POPULATE_THIN',
983: p_step=>'HZ_CONTACT_POINTS');
984:
985: DELETE from HZ_DQM_STAGE_LOG where operation = 'SHADOW_CREATE_INDEXES';
986: create_log(
987: p_operation=>'SHADOW_CREATE_INDEXES',
988: p_step=>'HZ_PARTIES');
989: create_log(

Line 1083: FROM HZ_DQM_STAGE_LOG

1079: log('Data workers completed');
1080: if (STAGE_ALL_DATA) then
1081: BEGIN
1082: SELECT start_flag, end_flag INTO l_start_flag, l_end_flag
1083: FROM HZ_DQM_STAGE_LOG
1084: WHERE OPERATION = 'SHADOW_POPULATE_THIN'
1085: AND step = 'HZ_PARTIES';
1086: EXCEPTION
1087: WHEN no_data_found THEN

Line 1097: UPDATE HZ_DQM_STAGE_LOG set START_FLAG = 'Y', END_TIME=SYSDATE

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';
1099: COMMIT;
1100: insert_into_thin_tables('PARTIES');
1101: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE

Line 1101: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE

1097: UPDATE HZ_DQM_STAGE_LOG set START_FLAG = 'Y', END_TIME=SYSDATE
1098: WHERE operation = 'SHADOW_POPULATE_THIN' AND step ='HZ_PARTIES';
1099: COMMIT;
1100: insert_into_thin_tables('PARTIES');
1101: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE
1102: WHERE operation = 'SHADOW_POPULATE_THIN' AND step ='HZ_PARTIES';
1103: COMMIT;
1104: END IF;
1105: BEGIN

Line 1107: FROM HZ_DQM_STAGE_LOG

1103: COMMIT;
1104: END IF;
1105: BEGIN
1106: SELECT start_flag, end_flag INTO l_start_flag, l_end_flag
1107: FROM HZ_DQM_STAGE_LOG
1108: WHERE OPERATION = 'SHADOW_POPULATE_THIN'
1109: AND step = 'HZ_PARTY_SITES';
1110: EXCEPTION
1111: WHEN no_data_found THEN

Line 1121: UPDATE HZ_DQM_STAGE_LOG set START_FLAG = 'Y', END_TIME=SYSDATE

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';
1123: COMMIT;
1124: insert_into_thin_tables('PARTY_SITES');
1125: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE

Line 1125: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE

1121: UPDATE HZ_DQM_STAGE_LOG set START_FLAG = 'Y', END_TIME=SYSDATE
1122: WHERE operation = 'SHADOW_POPULATE_THIN' AND step ='HZ_PARTY_SITES';
1123: COMMIT;
1124: insert_into_thin_tables('PARTY_SITES');
1125: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE
1126: WHERE operation = 'SHADOW_POPULATE_THIN' AND step ='HZ_PARTY_SITES';
1127: COMMIT;
1128: END IF;
1129: BEGIN

Line 1131: FROM HZ_DQM_STAGE_LOG

1127: COMMIT;
1128: END IF;
1129: BEGIN
1130: SELECT start_flag, end_flag INTO l_start_flag, l_end_flag
1131: FROM HZ_DQM_STAGE_LOG
1132: WHERE OPERATION = 'SHADOW_POPULATE_THIN'
1133: AND step = 'HZ_ORG_CONTACTS';
1134: EXCEPTION
1135: WHEN no_data_found THEN

Line 1145: UPDATE HZ_DQM_STAGE_LOG set START_FLAG = 'Y', END_TIME=SYSDATE

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';
1147: COMMIT;
1148: insert_into_thin_tables('CONTACTS') ;
1149: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE

Line 1149: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE

1145: UPDATE HZ_DQM_STAGE_LOG set START_FLAG = 'Y', END_TIME=SYSDATE
1146: WHERE operation = 'SHADOW_POPULATE_THIN' AND step ='HZ_ORG_CONTACTS';
1147: COMMIT;
1148: insert_into_thin_tables('CONTACTS') ;
1149: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE
1150: WHERE operation = 'SHADOW_POPULATE_THIN' AND step ='HZ_ORG_CONTACTS';
1151: COMMIT;
1152: END IF;
1153: BEGIN

Line 1155: FROM HZ_DQM_STAGE_LOG

1151: COMMIT;
1152: END IF;
1153: BEGIN
1154: SELECT start_flag, end_flag INTO l_start_flag, l_end_flag
1155: FROM HZ_DQM_STAGE_LOG
1156: WHERE OPERATION = 'SHADOW_POPULATE_THIN'
1157: AND step = 'HZ_CONTACT_POINTS';
1158: EXCEPTION
1159: WHEN no_data_found THEN

Line 1169: UPDATE HZ_DQM_STAGE_LOG set START_FLAG = 'Y', END_TIME=SYSDATE

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';
1171: COMMIT;
1172: insert_into_thin_tables('CONTACT_POINTS') ;
1173: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE

Line 1173: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE

1169: UPDATE HZ_DQM_STAGE_LOG set START_FLAG = 'Y', END_TIME=SYSDATE
1170: WHERE operation = 'SHADOW_POPULATE_THIN' AND step ='HZ_CONTACT_POINTS';
1171: COMMIT;
1172: insert_into_thin_tables('CONTACT_POINTS') ;
1173: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE
1174: WHERE operation = 'SHADOW_POPULATE_THIN' AND step ='HZ_CONTACT_POINTS';
1175: COMMIT;
1176: END IF;
1177: log('inserted into thin tables');

Line 1217: UPDATE HZ_DQM_STAGE_LOG

1213: WHERE ROWNUM=1
1214: AND CONTAINS (concat_col, 'dummy_string')>0;
1215: EXCEPTION
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

Line 1242: UPDATE HZ_DQM_STAGE_LOG

1238: WHERE ROWNUM=1
1239: AND CONTAINS (concat_col, 'dummy_string')>0;
1240: EXCEPTION
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

Line 1267: UPDATE HZ_DQM_STAGE_LOG

1263: WHERE ROWNUM=1
1264: AND CONTAINS (concat_col, 'dummy_string')>0;
1265: EXCEPTION
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

Line 1292: UPDATE HZ_DQM_STAGE_LOG

1288: WHERE ROWNUM=1
1289: AND CONTAINS (concat_col, 'dummy_string')>0;
1290: EXCEPTION
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

Line 1375: -- REPURI. Bug 4884742. To insert a record into hz_dqm_stage_log table

1371: end if;
1372: */
1373: end if;
1374:
1375: -- REPURI. Bug 4884742. To insert a record into hz_dqm_stage_log table
1376: -- indicating that shadow staging conc prog has completed successfully.
1377:
1378: create_log ('SHADOW_STAGING','COMPLETE');
1379:

Line 1416: FROM HZ_DQM_STAGE_LOG

1412: ) IS
1413:
1414: CURSOR l_log_cur(p_command VARCHAR2, l_worker_number NUMBER, l_step VARCHAR2) is
1415: ( SELECT start_flag, end_flag
1416: FROM HZ_DQM_STAGE_LOG
1417: WHERE OPERATION = p_command
1418: AND WORKER_NUMBER = l_worker_number AND step = l_step);
1419:
1420: l_party_id NUMBER;

Line 1491: UPDATE HZ_DQM_STAGE_LOG set start_flag='Y', start_time = SYSDATE

1487: IF nvl(l_end_flag,'N') = 'N' THEN
1488: IF nvl(l_start_flag ,'N') = 'N' THEN
1489:
1490: l_log_step := 'SHADOW_STEP1';
1491: UPDATE HZ_DQM_STAGE_LOG set start_flag='Y', start_time = SYSDATE
1492: WHERE OPERATION = p_command
1493: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
1494: COMMIT;
1495: log(' Regular Flow -- Fresh Run of Staging');

Line 1510: UPDATE HZ_DQM_STAGE_LOG set end_flag='Y', end_time = SYSDATE

1506: END IF;
1507:
1508: CLOSE l_party_cur;
1509: l_log_step := 'SHADOW_STEP1';
1510: UPDATE HZ_DQM_STAGE_LOG set end_flag='Y', end_time = SYSDATE
1511: WHERE OPERATION = p_command
1512: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
1513:
1514: COMMIT;

Line 1533: UPDATE HZ_DQM_STAGE_LOG set start_flag='Y', start_time = SYSDATE

1529:
1530: IF nvl(l_end_flag,'N') = 'N' THEN
1531: IF nvl(l_start_flag,'N') = 'N' THEN
1532: l_log_step := 'SHADOW_STEP2';
1533: UPDATE HZ_DQM_STAGE_LOG set start_flag='Y', start_time = SYSDATE
1534: WHERE OPERATION = p_command
1535: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
1536: COMMIT;
1537: log(' Regular Flow -- Fresh Run of Staging');

Line 1552: UPDATE HZ_DQM_STAGE_LOG set end_flag='Y', end_time = SYSDATE

1548: END IF;
1549:
1550: CLOSE l_party_cur;
1551: l_log_step := 'SHADOW_STEP2';
1552: UPDATE HZ_DQM_STAGE_LOG set end_flag='Y', end_time = SYSDATE
1553: WHERE OPERATION = p_command
1554: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
1555:
1556: COMMIT;

Line 1575: UPDATE HZ_DQM_STAGE_LOG set start_flag='Y', start_time = SYSDATE

1571:
1572: IF nvl(l_end_flag,'N') = 'N' THEN
1573: IF nvl(l_start_flag,'N') = 'N' THEN
1574: l_log_step := 'SHADOW_STEP3';
1575: UPDATE HZ_DQM_STAGE_LOG set start_flag='Y', start_time = SYSDATE
1576: WHERE OPERATION = p_command
1577: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
1578: COMMIT;
1579: log(' Regular Flow -- Fresh Run of Staging');

Line 1594: UPDATE HZ_DQM_STAGE_LOG set end_flag='Y', end_time = SYSDATE

1590: END IF;
1591:
1592: CLOSE l_party_cur;
1593: l_log_step := 'SHADOW_STEP3';
1594: UPDATE HZ_DQM_STAGE_LOG set end_flag='Y', end_time = SYSDATE
1595: WHERE OPERATION = p_command
1596: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
1597:
1598: COMMIT;

Line 1758: FROM HZ_DQM_STAGE_LOG

1754: create_btree_indexes ('PARTY');
1755:
1756: BEGIN
1757: SELECT start_flag, end_flag INTO l_start_flag, l_end_flag
1758: FROM HZ_DQM_STAGE_LOG
1759: WHERE OPERATION = 'SHADOW_CREATE_INDEXES'
1760: AND step = 'HZ_PARTIES';
1761: EXCEPTION
1762: WHEN no_data_found THEN

Line 1783: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE

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';
1785: COMMIT;
1786:
1787: EXCEPTION

Line 1806: UPDATE HZ_DQM_STAGE_LOG set START_FLAG = 'Y', START_TIME=SYSDATE

1802:
1803: -- Regular Flow, We do not Continue from a previous Run of Staging
1804: IF nvl(l_start_flag,'N') = 'N' THEN
1805: log('regular creation of party indexes');
1806: UPDATE HZ_DQM_STAGE_LOG set START_FLAG = 'Y', START_TIME=SYSDATE
1807: WHERE operation = 'SHADOW_CREATE_INDEXES' AND step ='HZ_PARTIES';
1808: COMMIT;
1809:
1810: l_section_grp := g_schema_name || '.HZ_DQM_PARTY_GRP';

Line 1823: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE

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:
1823: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE
1824: WHERE operation = 'SHADOW_CREATE_INDEXES' AND step ='HZ_PARTIES';
1825: COMMIT;
1826: END IF;
1827:

Line 1839: FROM HZ_DQM_STAGE_LOG

1835: IF CREATE_PS_INDEXES THEN
1836: create_btree_indexes ('PARTY_SITES');
1837: BEGIN
1838: SELECT start_flag, end_flag INTO l_start_flag, l_end_flag
1839: FROM HZ_DQM_STAGE_LOG
1840: WHERE OPERATION = 'SHADOW_CREATE_INDEXES'
1841: AND step = 'HZ_PARTY_SITES';
1842: EXCEPTION
1843: WHEN no_data_found THEN

Line 1864: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE

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';
1866: COMMIT;
1867:
1868: EXCEPTION

Line 1888: UPDATE HZ_DQM_STAGE_LOG set START_FLAG = 'Y', START_TIME=SYSDATE

1884:
1885:
1886:
1887: IF nvl(l_start_flag,'N') = 'N' THEN
1888: UPDATE HZ_DQM_STAGE_LOG set START_FLAG = 'Y', START_TIME=SYSDATE
1889: WHERE operation = 'SHADOW_CREATE_INDEXES' AND step ='HZ_PARTY_SITES';
1890: COMMIT;
1891:
1892: l_section_grp := g_schema_name || '.HZ_DQM_PS_GRP';

Line 1905: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE

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:
1905: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE
1906: WHERE operation = 'SHADOW_CREATE_INDEXES' AND step ='HZ_PARTY_SITES';
1907: COMMIT;
1908: END IF;
1909: log(' Completed at ' || to_char(SYSDATE, 'HH24:MI:SS'));

Line 1920: FROM HZ_DQM_STAGE_LOG

1916: IF CREATE_CONTACT_INDEXES THEN
1917: create_btree_indexes ('CONTACTS');
1918: BEGIN
1919: SELECT start_flag, end_flag INTO l_start_flag, l_end_flag
1920: FROM HZ_DQM_STAGE_LOG
1921: WHERE OPERATION = 'SHADOW_CREATE_INDEXES'
1922: AND step = 'HZ_ORG_CONTACTS';
1923: EXCEPTION
1924: WHEN no_data_found THEN

Line 1945: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE

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';
1947: COMMIT;
1948:
1949: EXCEPTION

Line 1966: UPDATE HZ_DQM_STAGE_LOG set START_FLAG = 'Y', START_TIME=SYSDATE

1962: END;
1963: END IF;
1964:
1965: IF nvl(l_start_flag,'N') = 'N' THEN
1966: UPDATE HZ_DQM_STAGE_LOG set START_FLAG = 'Y', START_TIME=SYSDATE
1967: WHERE operation = 'SHADOW_CREATE_INDEXES' AND step ='HZ_ORG_CONTACTS';
1968: COMMIT;
1969:
1970: l_section_grp := g_schema_name || '.HZ_DQM_CONTACT_GRP';

Line 1983: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE

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
1984: WHERE operation = 'SHADOW_CREATE_INDEXES' AND step ='HZ_ORG_CONTACTS';
1985: COMMIT;
1986: END IF;
1987: log(' Completed at ' || to_char(SYSDATE, 'HH24:MI:SS'));

Line 1997: FROM HZ_DQM_STAGE_LOG

1993: IF CREATE_CPT_INDEXES THEN
1994: create_btree_indexes ('CONTACT_POINTS');
1995: BEGIN
1996: SELECT start_flag, end_flag INTO l_start_flag, l_end_flag
1997: FROM HZ_DQM_STAGE_LOG
1998: WHERE OPERATION = 'SHADOW_CREATE_INDEXES'
1999: AND step = 'HZ_CONTACT_POINTS';
2000: EXCEPTION
2001: WHEN no_data_found THEN

Line 2022: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE

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';
2024: COMMIT;
2025:
2026: EXCEPTION

Line 2043: UPDATE HZ_DQM_STAGE_LOG set START_FLAG = 'Y', START_TIME=SYSDATE

2039: END;
2040: END IF;
2041:
2042: IF nvl(l_start_flag,'N') = 'N' THEN
2043: UPDATE HZ_DQM_STAGE_LOG set START_FLAG = 'Y', START_TIME=SYSDATE
2044: WHERE operation = 'SHADOW_CREATE_INDEXES' AND step ='HZ_CONTACT_POINTS';
2045: COMMIT;
2046:
2047: l_section_grp := g_schema_name || '.HZ_DQM_CPT_GRP';

Line 2060: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE

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:
2060: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE
2061: WHERE operation = 'SHADOW_CREATE_INDEXES' AND step ='HZ_CONTACT_POINTS';
2062: COMMIT;
2063: END IF;
2064: log(' Completed at ' || to_char(SYSDATE, 'HH24:MI:SS'));