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 dependencies on HZ_DQM_STAGE_LOG

Line 1068: INSERT INTO HZ_DQM_STAGE_LOG (

1064: p_num_workers NUMBER DEFAULT 0) IS
1065:
1066: BEGIN
1067:
1068: INSERT INTO HZ_DQM_STAGE_LOG (
1069: OPERATION,
1070: NUMBER_OF_WORKERS,
1071: WORKER_NUMBER,
1072: STEP,

Line 1519: FROM HZ_DQM_STAGE_LOG

1515: ELSIF l_command = 'STAGE_NEW_TRANSFORMATIONS' THEN
1516: log (' In the STAGE_NEW_TRANSFORMATIONS flow');
1517: BEGIN
1518: SELECT number_of_workers INTO l_last_num_workers
1519: FROM HZ_DQM_STAGE_LOG
1520: WHERE operation = l_command
1521: AND STEP = 'INIT';
1522:
1523: IF l_last_num_workers<>l_num_workers AND l_continue = 'Y' THEN

Line 1556: DELETE from HZ_DQM_STAGE_LOG where operation = l_command;

1552: IF l_rebuild_cpt_idx THEN
1553: generate_datastore_prefs('CONTACT_POINTS');
1554: END IF;
1555:
1556: DELETE from HZ_DQM_STAGE_LOG where operation = l_command;
1557: create_log(
1558: p_operation=>l_command,
1559: p_step=>'INIT',
1560: p_num_workers=>l_num_workers);

Line 1574: DELETE from HZ_DQM_STAGE_LOG where operation = 'CREATE_INDEXES';

1570: p_num_workers=>l_num_workers);
1571: END LOOP;
1572: END LOOP;
1573:
1574: DELETE from HZ_DQM_STAGE_LOG where operation = 'CREATE_INDEXES';
1575: IF l_rebuild_party_idx THEN
1576: create_log(
1577: p_operation=>'CREATE_INDEXES',
1578: p_step=>'HZ_PARTIES');

Line 1617: FROM HZ_DQM_STAGE_LOG

1613: END IF;
1614:
1615: ELSE
1616: SELECT step INTO l_step
1617: FROM HZ_DQM_STAGE_LOG
1618: WHERE OPERATION = 'CREATE_INDEXES'
1619: AND step like 'HZ_PARTIES%';
1620:
1621: IF l_step ='HZ_PARTIES' THEN

Line 1628: FROM HZ_DQM_STAGE_LOG

1624: l_rebuild_party_idx:=FALSE;
1625: END IF;
1626:
1627: SELECT step INTO l_step
1628: FROM HZ_DQM_STAGE_LOG
1629: WHERE OPERATION = 'CREATE_INDEXES'
1630: AND step like 'HZ_PARTY_SITES%';
1631:
1632: IF l_step ='HZ_PARTY_SITES' THEN

Line 1639: FROM HZ_DQM_STAGE_LOG

1635: l_rebuild_psite_idx:=FALSE;
1636: END IF;
1637:
1638: SELECT step INTO l_step
1639: FROM HZ_DQM_STAGE_LOG
1640: WHERE OPERATION = 'CREATE_INDEXES'
1641: AND step like 'HZ_ORG_CONTACTS%';
1642:
1643: IF l_step ='HZ_ORG_CONTACTS' THEN

Line 1650: FROM HZ_DQM_STAGE_LOG

1646: l_rebuild_contact_idx:=FALSE;
1647: END IF;
1648:
1649: SELECT step INTO l_step
1650: FROM HZ_DQM_STAGE_LOG
1651: WHERE OPERATION = 'CREATE_INDEXES'
1652: AND step like 'HZ_CONTACT_POINTS%';
1653:
1654: IF l_step ='HZ_CONTACT_POINTS' THEN

Line 1778: FROM HZ_DQM_STAGE_LOG

1774: ELSIF l_command = 'STAGE_NEW_TRANSFORMATIONS_NO_INDEXING' THEN
1775: log (' In the STAGE_NEW_TRANSFORMATIONS_NO_INDEXING flow');
1776: BEGIN
1777: SELECT number_of_workers INTO l_last_num_workers
1778: FROM HZ_DQM_STAGE_LOG
1779: WHERE operation = substr(l_command,1,30)
1780: AND STEP = 'INIT';
1781:
1782:

Line 1803: DELETE from HZ_DQM_STAGE_LOG where operation = substr(l_command,1,30) ;

1799: generate_datastore_prefs ;
1800:
1801:
1802:
1803: DELETE from HZ_DQM_STAGE_LOG where operation = substr(l_command,1,30) ;
1804: create_log(
1805: p_operation=>l_command,
1806: p_step=>'INIT',
1807: p_num_workers=>l_num_workers);

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

1843:
1844: ELSIF l_command = 'STAGE_ALL_DATA' THEN
1845:
1846: BEGIN
1847: SELECT count(*) into l_is_wildchar from HZ_DQM_STAGE_LOG where operation = 'STAGE_FOR_WILDCHAR_SEARCH' and rownum = 1 ;
1848: IF l_is_wildchar < 1 THEN
1849: INSERT INTO HZ_DQM_STAGE_LOG(operation, number_of_workers, worker_number, step,
1850: last_update_date, creation_date, created_by, last_updated_by)
1851: VALUES ('STAGE_FOR_WILDCHAR_SEARCH', '-1', '-1', 'Y', SYSDATE, SYSDATE, 0, 0);

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

1845:
1846: BEGIN
1847: SELECT count(*) into l_is_wildchar from HZ_DQM_STAGE_LOG where operation = 'STAGE_FOR_WILDCHAR_SEARCH' and rownum = 1 ;
1848: IF l_is_wildchar < 1 THEN
1849: INSERT INTO HZ_DQM_STAGE_LOG(operation, number_of_workers, worker_number, step,
1850: last_update_date, creation_date, created_by, last_updated_by)
1851: VALUES ('STAGE_FOR_WILDCHAR_SEARCH', '-1', '-1', 'Y', SYSDATE, SYSDATE, 0, 0);
1852: END IF;
1853:

Line 1855: FROM HZ_DQM_STAGE_LOG

1851: VALUES ('STAGE_FOR_WILDCHAR_SEARCH', '-1', '-1', 'Y', SYSDATE, SYSDATE, 0, 0);
1852: END IF;
1853:
1854: SELECT number_of_workers INTO l_last_num_workers
1855: FROM HZ_DQM_STAGE_LOG
1856: WHERE operation = l_command
1857: AND STEP = 'INIT';
1858:
1859: IF l_last_num_workers<>l_num_workers AND l_continue = 'Y' THEN

Line 1882: DELETE from HZ_DQM_STAGE_LOG where operation = l_command;

1878: IF l_command = 'STAGE_ALL_DATA' THEN
1879: generate_map_pkg;
1880: END IF;
1881:
1882: DELETE from HZ_DQM_STAGE_LOG where operation = l_command;
1883: create_log(
1884: p_operation=>l_command,
1885: p_step=>'INIT',
1886: p_num_workers=>l_num_workers);

Line 1903: DELETE from HZ_DQM_STAGE_LOG where operation = 'CREATE_INDEXES';

1899: p_worker_number=> J,
1900: p_num_workers=>l_num_workers);
1901: END LOOP;
1902: END LOOP;
1903: DELETE from HZ_DQM_STAGE_LOG where operation = 'CREATE_INDEXES';
1904: create_log(
1905: p_operation=>'CREATE_INDEXES',
1906: p_step=>'HZ_PARTIES');
1907: create_log(

Line 2020: DELETE from HZ_DQM_STAGE_LOG where operation = 'CREATE_INDEXES';

2016: ELSIF l_command = 'CREATE_INDEXES' THEN
2017: IF l_continue = 'N' THEN
2018: drop_indexes;
2019: generate_datastore_prefs;
2020: DELETE from HZ_DQM_STAGE_LOG where operation = 'CREATE_INDEXES';
2021: create_log(
2022: p_operation=>'CREATE_INDEXES',
2023: p_step=>'HZ_PARTIES');
2024: create_log(

Line 2127: DELETE from HZ_DQM_STAGE_LOG where operation = 'CREATE_INDEXES';

2123: END IF;
2124: ELSIF l_command='CREATE_MISSING_INVALID_INDEXES' THEN
2125: IF l_continue = 'N' THEN
2126: generate_datastore_prefs;
2127: DELETE from HZ_DQM_STAGE_LOG where operation = 'CREATE_INDEXES';
2128: create_log(
2129: p_operation=>'CREATE_INDEXES',
2130: p_step=>'HZ_PARTIES');
2131: create_log(

Line 2152: UPDATE HZ_DQM_STAGE_LOG

2148: WHERE ROWNUM=1
2149: AND CONTAINS (concat_col, 'dummy_string')>0;
2150: EXCEPTION
2151: WHEN NO_DATA_FOUND THEN
2152: UPDATE HZ_DQM_STAGE_LOG
2153: SET START_FLAG ='Y', START_TIME=SYSDATE,END_FLAG = 'Y', END_TIME=SYSDATE
2154: WHERE OPERATION = 'CREATE_INDEXES' AND step = 'HZ_PARTIES';
2155: WHEN OTHERS THEN
2156: BEGIN

Line 2187: UPDATE HZ_DQM_STAGE_LOG

2183: WHERE ROWNUM=1
2184: AND CONTAINS (concat_col, 'dummy_string')>0;
2185: EXCEPTION
2186: WHEN NO_DATA_FOUND THEN
2187: UPDATE HZ_DQM_STAGE_LOG
2188: SET START_FLAG ='Y', START_TIME=SYSDATE,END_FLAG = 'Y', END_TIME=SYSDATE
2189: WHERE OPERATION = 'CREATE_INDEXES' AND step = 'HZ_PARTY_SITES';
2190: WHEN OTHERS THEN
2191:

Line 2227: UPDATE HZ_DQM_STAGE_LOG

2223: WHERE ROWNUM=1
2224: AND CONTAINS (concat_col, 'dummy_string')>0;
2225: EXCEPTION
2226: WHEN NO_DATA_FOUND THEN
2227: UPDATE HZ_DQM_STAGE_LOG
2228: SET START_FLAG ='Y', START_TIME=SYSDATE,END_FLAG = 'Y', END_TIME=SYSDATE
2229: WHERE OPERATION = 'CREATE_INDEXES' AND step = 'HZ_ORG_CONTACTS';
2230: WHEN OTHERS THEN
2231:

Line 2267: UPDATE HZ_DQM_STAGE_LOG

2263: WHERE ROWNUM=1
2264: AND CONTAINS (concat_col, 'dummy_string')>0;
2265: EXCEPTION
2266: WHEN NO_DATA_FOUND THEN
2267: UPDATE HZ_DQM_STAGE_LOG
2268: SET START_FLAG ='Y', START_TIME=SYSDATE,END_FLAG = 'Y', END_TIME=SYSDATE
2269: WHERE OPERATION = 'CREATE_INDEXES' AND step = 'HZ_CONTACT_POINTS';
2270: WHEN OTHERS THEN
2271:

Line 2482: FROM HZ_DQM_STAGE_LOG

2478: ) IS
2479:
2480: CURSOR l_log_cur(p_command VARCHAR2, l_worker_number NUMBER, l_step VARCHAR2) is
2481: ( SELECT start_flag, end_flag
2482: FROM HZ_DQM_STAGE_LOG
2483: WHERE OPERATION = p_command
2484: AND WORKER_NUMBER = l_worker_number AND step = l_step);
2485:
2486: l_party_id NUMBER;

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

2550: IF nvl(l_end_flag,'N') = 'N' THEN
2551: IF nvl(l_start_flag ,'N') = 'N' THEN
2552:
2553: l_log_step := 'STEP1';
2554: UPDATE HZ_DQM_STAGE_LOG set start_flag='Y', start_time = SYSDATE
2555: WHERE OPERATION = p_command
2556: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2557: COMMIT;
2558:

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

2569: END IF;
2570:
2571: CLOSE l_party_cur;
2572: l_log_step := 'STEP1';
2573: UPDATE HZ_DQM_STAGE_LOG set end_flag='Y', end_time = SYSDATE
2574: WHERE OPERATION = p_command
2575: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2576:
2577: COMMIT;

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

2588:
2589: IF nvl(l_end_flag,'N') = 'N' THEN
2590: IF nvl(l_start_flag,'N') = 'N' THEN
2591: l_log_step := 'STEP2';
2592: UPDATE HZ_DQM_STAGE_LOG set start_flag='Y', start_time = SYSDATE
2593: WHERE OPERATION = p_command
2594: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2595: COMMIT;
2596:

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

2607: END IF;
2608:
2609: CLOSE l_party_cur;
2610: l_log_step := 'STEP2';
2611: UPDATE HZ_DQM_STAGE_LOG set end_flag='Y', end_time = SYSDATE
2612: WHERE OPERATION = p_command
2613: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2614:
2615: COMMIT;

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

2626:
2627: IF nvl(l_end_flag,'N') = 'N' THEN
2628: IF nvl(l_start_flag,'N') = 'N' THEN
2629: l_log_step := 'STEP3';
2630: UPDATE HZ_DQM_STAGE_LOG set start_flag='Y', start_time = SYSDATE
2631: WHERE OPERATION = p_command
2632: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2633: COMMIT;
2634:

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

2646: END IF;
2647:
2648: CLOSE l_party_cur;
2649: l_log_step := 'STEP3';
2650: UPDATE HZ_DQM_STAGE_LOG set end_flag='Y', end_time = SYSDATE
2651: WHERE OPERATION = p_command
2652: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2653:
2654: COMMIT;

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

2670:
2671: IF nvl(l_end_flag,'N') = 'N' THEN
2672: IF nvl(l_start_flag,'N') = 'N' THEN
2673: l_log_step := 'STEP1';
2674: UPDATE HZ_DQM_STAGE_LOG set start_flag='Y', start_time = SYSDATE
2675: WHERE OPERATION = p_command
2676: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2677: COMMIT;
2678:

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

2686: CLOSE l_party_cur;
2687: END IF;
2688:
2689: l_log_step := 'STEP1';
2690: UPDATE HZ_DQM_STAGE_LOG set end_flag='Y', end_time = SYSDATE
2691: WHERE OPERATION = p_command
2692: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2693:
2694: COMMIT;

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

2705:
2706: IF nvl(l_end_flag,'N') = 'N' THEN
2707: IF nvl(l_start_flag,'N') = 'N' THEN
2708: l_log_step := 'STEP2';
2709: UPDATE HZ_DQM_STAGE_LOG set start_flag='Y', start_time = SYSDATE
2710: WHERE OPERATION = p_command
2711: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2712:
2713: END IF;

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

2720: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_parties(l_party_cur);
2721: CLOSE l_party_cur;
2722: END IF;
2723: l_log_step := 'STEP2';
2724: UPDATE HZ_DQM_STAGE_LOG set end_flag='Y', end_time = SYSDATE
2725: WHERE OPERATION = p_command
2726: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2727:
2728: COMMIT;

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

2740:
2741: IF nvl(l_end_flag,'N') = 'N' THEN
2742: IF nvl(l_start_flag,'N') = 'N' THEN
2743: l_log_step := 'STEP3';
2744: UPDATE HZ_DQM_STAGE_LOG set start_flag='Y', start_time = SYSDATE
2745: WHERE OPERATION = p_command
2746: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2747: END IF;
2748:

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

2755: CLOSE l_party_cur;
2756: END IF;
2757:
2758: l_log_step := 'STEP3';
2759: UPDATE HZ_DQM_STAGE_LOG set end_flag='Y', end_time = SYSDATE
2760: WHERE OPERATION = p_command
2761: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2762:
2763: COMMIT;

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

2775:
2776: IF nvl(l_end_flag,'N') = 'N' THEN
2777: IF nvl(l_start_flag,'N') = 'N' THEN
2778: l_log_step := 'STEP4';
2779: UPDATE HZ_DQM_STAGE_LOG set start_flag='Y', start_time = SYSDATE
2780: WHERE OPERATION = p_command
2781: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2782:
2783: END IF;

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

2788: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_contacts(l_contact_cur);
2789: CLOSE l_contact_cur;
2790: END IF;
2791: l_log_step := 'STEP4';
2792: UPDATE HZ_DQM_STAGE_LOG set end_flag='Y', end_time = SYSDATE
2793: WHERE OPERATION = p_command
2794: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2795:
2796: COMMIT;

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

2808:
2809: IF nvl(l_end_flag,'N') = 'N' THEN
2810: IF nvl(l_start_flag,'N') = 'N' THEN
2811: l_log_step := 'STEP5';
2812: UPDATE HZ_DQM_STAGE_LOG set start_flag='Y', start_time = SYSDATE
2813: WHERE OPERATION = p_command
2814: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2815:
2816: END IF;

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

2822: CLOSE l_party_site_cur;
2823: END IF;
2824:
2825: l_log_step := 'STEP5';
2826: UPDATE HZ_DQM_STAGE_LOG set end_flag='Y', end_time = SYSDATE
2827: WHERE OPERATION = p_command
2828: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2829:
2830: COMMIT;

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

2841:
2842: IF nvl(l_end_flag,'N') = 'N' THEN
2843: IF nvl(l_start_flag,'N') = 'N' THEN
2844: l_log_step := 'STEP6';
2845: UPDATE HZ_DQM_STAGE_LOG set start_flag='Y', start_time = SYSDATE
2846: WHERE OPERATION = p_command
2847: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2848:
2849: END IF;

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

2854: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_contact_pts(l_cpt_cur);
2855: CLOSE l_cpt_cur;
2856: END IF;
2857: l_log_step := 'STEP6';
2858: UPDATE HZ_DQM_STAGE_LOG set end_flag='Y', end_time = SYSDATE
2859: WHERE OPERATION = p_command
2860: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2861:
2862: COMMIT;

Line 3539: FROM HZ_DQM_STAGE_LOG

3535: IF CREATE_PARTY_TEXT_INDEX THEN
3536: create_btree_indexes ('PARTY');
3537: BEGIN
3538: SELECT start_flag, end_flag INTO l_start_flag, l_end_flag
3539: FROM HZ_DQM_STAGE_LOG
3540: WHERE OPERATION = 'CREATE_INDEXES'
3541: AND step = 'HZ_PARTIES';
3542: EXCEPTION
3543: WHEN no_data_found THEN

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

3559: EXECUTE IMMEDIATE 'ALTER INDEX ' || l_index_owner ||
3560: '.hz_stage_parties_t1 rebuild parameters(''resume memory ' || p_idx_mem || ''')';
3561: log('Index Successfully built');
3562:
3563: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE
3564: WHERE operation = 'CREATE_INDEXES' AND step ='HZ_PARTIES';
3565: COMMIT;
3566:
3567: EXCEPTION

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

3580: END;
3581: END IF;
3582:
3583: IF nvl(l_start_flag,'N') = 'N' THEN
3584: UPDATE HZ_DQM_STAGE_LOG set START_FLAG = 'Y', START_TIME=SYSDATE
3585: WHERE operation = 'CREATE_INDEXES' AND step ='HZ_PARTIES';
3586: COMMIT;
3587:
3588: l_section_grp := g_schema_name || '.HZ_DQM_PARTY_GRP';

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

3616: 'SECTION GROUP '||l_section_grp||' STOPLIST CTXSYS.EMPTY_STOPLIST LEXER '||g_schema_name || '.dqm_lexer memory ' || p_idx_mem || ''')';
3617: log('Done creating hz_stage_parties_t1');
3618: END IF;
3619:
3620: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE
3621: WHERE operation = 'CREATE_INDEXES' AND step ='HZ_PARTIES';
3622: COMMIT;
3623: END IF;
3624: log(' Completed at ' || to_char(SYSDATE, 'HH24:MI:SS'));

Line 3633: FROM HZ_DQM_STAGE_LOG

3629: IF CREATE_PS_TEXT_INDEX THEN
3630: create_btree_indexes ('PARTY_SITES');
3631: BEGIN
3632: SELECT start_flag, end_flag INTO l_start_flag, l_end_flag
3633: FROM HZ_DQM_STAGE_LOG
3634: WHERE OPERATION = 'CREATE_INDEXES'
3635: AND step = 'HZ_PARTY_SITES';
3636: EXCEPTION
3637: WHEN no_data_found THEN

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

3653: EXECUTE IMMEDIATE 'ALTER INDEX ' || l_index_owner ||
3654: '.hz_stage_party_sites_t1 rebuild parameters(''resume memory ' || p_idx_mem || ''')';
3655: log('Index Successfully built');
3656:
3657: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE
3658: WHERE operation = 'CREATE_INDEXES' AND step ='HZ_PARTY_SITES';
3659: COMMIT;
3660:
3661: EXCEPTION

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

3674: END;
3675: END IF;
3676:
3677: IF nvl(l_start_flag,'N') = 'N' THEN
3678: UPDATE HZ_DQM_STAGE_LOG set START_FLAG = 'Y', START_TIME=SYSDATE
3679: WHERE operation = 'CREATE_INDEXES' AND step ='HZ_PARTY_SITES';
3680: COMMIT;
3681:
3682: l_section_grp := g_schema_name || '.HZ_DQM_PS_GRP';

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

3709: 'SECTION GROUP '||l_section_grp||' STOPLIST CTXSYS.EMPTY_STOPLIST LEXER '||g_schema_name || '.dqm_lexer memory ' || p_idx_mem || ''')';
3710: log('Done creating hz_stage_party_sites_t1');
3711: END IF;
3712:
3713: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE
3714: WHERE operation = 'CREATE_INDEXES' AND step ='HZ_PARTY_SITES';
3715: COMMIT;
3716: END IF;
3717: log(' Completed at ' || to_char(SYSDATE, 'HH24:MI:SS'));

Line 3726: FROM HZ_DQM_STAGE_LOG

3722: IF CREATE_CONTACT_TEXT_INDEX THEN
3723: create_btree_indexes ('CONTACTS');
3724: BEGIN
3725: SELECT start_flag, end_flag INTO l_start_flag, l_end_flag
3726: FROM HZ_DQM_STAGE_LOG
3727: WHERE OPERATION = 'CREATE_INDEXES'
3728: AND step = 'HZ_ORG_CONTACTS';
3729: EXCEPTION
3730: WHEN no_data_found THEN

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

3746: EXECUTE IMMEDIATE 'ALTER INDEX ' || l_index_owner ||
3747: '.hz_stage_contact_t1 rebuild parameters(''resume memory ' || p_idx_mem || ''')';
3748: log('Index Successfully built');
3749:
3750: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE
3751: WHERE operation = 'CREATE_INDEXES' AND step ='HZ_ORG_CONTACTS';
3752: COMMIT;
3753:
3754: EXCEPTION

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

3767: END;
3768: END IF;
3769:
3770: IF nvl(l_start_flag,'N') = 'N' THEN
3771: UPDATE HZ_DQM_STAGE_LOG set START_FLAG = 'Y', START_TIME=SYSDATE
3772: WHERE operation = 'CREATE_INDEXES' AND step ='HZ_ORG_CONTACTS';
3773: COMMIT;
3774:
3775: l_section_grp := g_schema_name || '.HZ_DQM_CONTACT_GRP';

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

3805: log('Created hz_stage_contact_t1');
3806:
3807: END IF;
3808:
3809: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE
3810: WHERE operation = 'CREATE_INDEXES' AND step ='HZ_ORG_CONTACTS';
3811: COMMIT;
3812: END IF;
3813: log(' Completed at ' || to_char(SYSDATE, 'HH24:MI:SS'));

Line 3822: FROM HZ_DQM_STAGE_LOG

3818: IF CREATE_CPT_TEXT_INDEX THEN
3819: create_btree_indexes ('CONTACT_POINTS');
3820: BEGIN
3821: SELECT start_flag, end_flag INTO l_start_flag, l_end_flag
3822: FROM HZ_DQM_STAGE_LOG
3823: WHERE OPERATION = 'CREATE_INDEXES'
3824: AND step = 'HZ_CONTACT_POINTS';
3825: EXCEPTION
3826: WHEN no_data_found THEN

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

3842: EXECUTE IMMEDIATE 'ALTER INDEX ' || l_index_owner ||
3843: '.hz_stage_cpt_t1 rebuild parameters(''resume memory ' || p_idx_mem || ''')';
3844:
3845: log('Index Successfully built');
3846: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE
3847: WHERE operation = 'CREATE_INDEXES' AND step ='HZ_CONTACT_POINTS';
3848: COMMIT;
3849:
3850: EXCEPTION

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

3863: END;
3864: END IF;
3865:
3866: IF nvl(l_start_flag,'N') = 'N' THEN
3867: UPDATE HZ_DQM_STAGE_LOG set START_FLAG = 'Y', START_TIME=SYSDATE
3868: WHERE operation = 'CREATE_INDEXES' AND step ='HZ_CONTACT_POINTS';
3869: COMMIT;
3870:
3871: l_section_grp := g_schema_name || '.HZ_DQM_CPT_GRP';

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

3901:
3902: log('Done creating hz_stage_contact_t1');
3903: END IF;
3904:
3905: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE
3906: WHERE operation = 'CREATE_INDEXES' AND step ='HZ_CONTACT_POINTS';
3907: COMMIT;
3908: END IF;
3909: log(' Completed at ' || to_char(SYSDATE, 'HH24:MI:SS'));