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 1080: INSERT INTO HZ_DQM_STAGE_LOG (

1076: p_num_workers NUMBER DEFAULT 0) IS
1077:
1078: BEGIN
1079:
1080: INSERT INTO HZ_DQM_STAGE_LOG (
1081: OPERATION,
1082: NUMBER_OF_WORKERS,
1083: WORKER_NUMBER,
1084: STEP,

Line 1531: FROM HZ_DQM_STAGE_LOG

1527: ELSIF l_command = 'STAGE_NEW_TRANSFORMATIONS' THEN
1528: log (' In the STAGE_NEW_TRANSFORMATIONS flow');
1529: BEGIN
1530: SELECT number_of_workers INTO l_last_num_workers
1531: FROM HZ_DQM_STAGE_LOG
1532: WHERE operation = l_command
1533: AND STEP = 'INIT';
1534:
1535: IF l_last_num_workers<>l_num_workers AND l_continue = 'Y' THEN

Line 1568: DELETE from HZ_DQM_STAGE_LOG where operation = l_command;

1564: IF l_rebuild_cpt_idx THEN
1565: generate_datastore_prefs('CONTACT_POINTS');
1566: END IF;
1567:
1568: DELETE from HZ_DQM_STAGE_LOG where operation = l_command;
1569: create_log(
1570: p_operation=>l_command,
1571: p_step=>'INIT',
1572: p_num_workers=>l_num_workers);

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

1582: p_num_workers=>l_num_workers);
1583: END LOOP;
1584: END LOOP;
1585:
1586: DELETE from HZ_DQM_STAGE_LOG where operation = 'CREATE_INDEXES';
1587: IF l_rebuild_party_idx THEN
1588: create_log(
1589: p_operation=>'CREATE_INDEXES',
1590: p_step=>'HZ_PARTIES');

Line 1629: FROM HZ_DQM_STAGE_LOG

1625: END IF;
1626:
1627: ELSE
1628: SELECT step INTO l_step
1629: FROM HZ_DQM_STAGE_LOG
1630: WHERE OPERATION = 'CREATE_INDEXES'
1631: AND step like 'HZ_PARTIES%';
1632:
1633: IF l_step ='HZ_PARTIES' THEN

Line 1640: FROM HZ_DQM_STAGE_LOG

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

Line 1651: FROM HZ_DQM_STAGE_LOG

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

Line 1662: FROM HZ_DQM_STAGE_LOG

1658: l_rebuild_contact_idx:=FALSE;
1659: END IF;
1660:
1661: SELECT step INTO l_step
1662: FROM HZ_DQM_STAGE_LOG
1663: WHERE OPERATION = 'CREATE_INDEXES'
1664: AND step like 'HZ_CONTACT_POINTS%';
1665:
1666: IF l_step ='HZ_CONTACT_POINTS' THEN

Line 1790: FROM HZ_DQM_STAGE_LOG

1786: ELSIF l_command = 'STAGE_NEW_TRANSFORMATIONS_NO_INDEXING' THEN
1787: log (' In the STAGE_NEW_TRANSFORMATIONS_NO_INDEXING flow');
1788: BEGIN
1789: SELECT number_of_workers INTO l_last_num_workers
1790: FROM HZ_DQM_STAGE_LOG
1791: WHERE operation = substr(l_command,1,30)
1792: AND STEP = 'INIT';
1793:
1794:

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

1811: generate_datastore_prefs ;
1812:
1813:
1814:
1815: DELETE from HZ_DQM_STAGE_LOG where operation = substr(l_command,1,30) ;
1816: create_log(
1817: p_operation=>l_command,
1818: p_step=>'INIT',
1819: p_num_workers=>l_num_workers);

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

1855:
1856: ELSIF l_command = 'STAGE_ALL_DATA' THEN
1857:
1858: BEGIN
1859: SELECT count(*) into l_is_wildchar from HZ_DQM_STAGE_LOG where operation = 'STAGE_FOR_WILDCHAR_SEARCH' and rownum = 1 ;
1860: IF l_is_wildchar < 1 THEN
1861: INSERT INTO HZ_DQM_STAGE_LOG(operation, number_of_workers, worker_number, step,
1862: last_update_date, creation_date, created_by, last_updated_by)
1863: VALUES ('STAGE_FOR_WILDCHAR_SEARCH', '-1', '-1', 'Y', SYSDATE, SYSDATE, 0, 0);

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

1857:
1858: BEGIN
1859: SELECT count(*) into l_is_wildchar from HZ_DQM_STAGE_LOG where operation = 'STAGE_FOR_WILDCHAR_SEARCH' and rownum = 1 ;
1860: IF l_is_wildchar < 1 THEN
1861: INSERT INTO HZ_DQM_STAGE_LOG(operation, number_of_workers, worker_number, step,
1862: last_update_date, creation_date, created_by, last_updated_by)
1863: VALUES ('STAGE_FOR_WILDCHAR_SEARCH', '-1', '-1', 'Y', SYSDATE, SYSDATE, 0, 0);
1864: END IF;
1865:

Line 1867: FROM HZ_DQM_STAGE_LOG

1863: VALUES ('STAGE_FOR_WILDCHAR_SEARCH', '-1', '-1', 'Y', SYSDATE, SYSDATE, 0, 0);
1864: END IF;
1865:
1866: SELECT number_of_workers INTO l_last_num_workers
1867: FROM HZ_DQM_STAGE_LOG
1868: WHERE operation = l_command
1869: AND STEP = 'INIT';
1870:
1871: IF l_last_num_workers<>l_num_workers AND l_continue = 'Y' THEN

Line 1898: DELETE from HZ_DQM_STAGE_LOG where operation = l_command;

1894: IF l_command = 'STAGE_ALL_DATA' THEN
1895: generate_map_pkg;
1896: END IF;
1897:
1898: DELETE from HZ_DQM_STAGE_LOG where operation = l_command;
1899: create_log(
1900: p_operation=>l_command,
1901: p_step=>'INIT',
1902: p_num_workers=>l_num_workers);

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

1915: p_worker_number=> J,
1916: p_num_workers=>l_num_workers);
1917: END LOOP;
1918: END LOOP;
1919: DELETE from HZ_DQM_STAGE_LOG where operation = 'CREATE_INDEXES';
1920: create_log(
1921: p_operation=>'CREATE_INDEXES',
1922: p_step=>'HZ_PARTIES');
1923: create_log(

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

2032: ELSIF l_command = 'CREATE_INDEXES' THEN
2033: IF l_continue = 'N' THEN
2034: drop_indexes;
2035: generate_datastore_prefs;
2036: DELETE from HZ_DQM_STAGE_LOG where operation = 'CREATE_INDEXES';
2037: create_log(
2038: p_operation=>'CREATE_INDEXES',
2039: p_step=>'HZ_PARTIES');
2040: create_log(

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

2139: END IF;
2140: ELSIF l_command='CREATE_MISSING_INVALID_INDEXES' THEN
2141: IF l_continue = 'N' THEN
2142: generate_datastore_prefs;
2143: DELETE from HZ_DQM_STAGE_LOG where operation = 'CREATE_INDEXES';
2144: create_log(
2145: p_operation=>'CREATE_INDEXES',
2146: p_step=>'HZ_PARTIES');
2147: create_log(

Line 2168: UPDATE HZ_DQM_STAGE_LOG

2164: WHERE ROWNUM=1
2165: AND CONTAINS (concat_col, 'dummy_string')>0;
2166: EXCEPTION
2167: WHEN NO_DATA_FOUND THEN
2168: UPDATE HZ_DQM_STAGE_LOG
2169: SET START_FLAG ='Y', START_TIME=SYSDATE,END_FLAG = 'Y', END_TIME=SYSDATE
2170: WHERE OPERATION = 'CREATE_INDEXES' AND step = 'HZ_PARTIES';
2171: WHEN OTHERS THEN
2172: BEGIN

Line 2203: UPDATE HZ_DQM_STAGE_LOG

2199: WHERE ROWNUM=1
2200: AND CONTAINS (concat_col, 'dummy_string')>0;
2201: EXCEPTION
2202: WHEN NO_DATA_FOUND THEN
2203: UPDATE HZ_DQM_STAGE_LOG
2204: SET START_FLAG ='Y', START_TIME=SYSDATE,END_FLAG = 'Y', END_TIME=SYSDATE
2205: WHERE OPERATION = 'CREATE_INDEXES' AND step = 'HZ_PARTY_SITES';
2206: WHEN OTHERS THEN
2207:

Line 2243: UPDATE HZ_DQM_STAGE_LOG

2239: WHERE ROWNUM=1
2240: AND CONTAINS (concat_col, 'dummy_string')>0;
2241: EXCEPTION
2242: WHEN NO_DATA_FOUND THEN
2243: UPDATE HZ_DQM_STAGE_LOG
2244: SET START_FLAG ='Y', START_TIME=SYSDATE,END_FLAG = 'Y', END_TIME=SYSDATE
2245: WHERE OPERATION = 'CREATE_INDEXES' AND step = 'HZ_ORG_CONTACTS';
2246: WHEN OTHERS THEN
2247:

Line 2283: UPDATE HZ_DQM_STAGE_LOG

2279: WHERE ROWNUM=1
2280: AND CONTAINS (concat_col, 'dummy_string')>0;
2281: EXCEPTION
2282: WHEN NO_DATA_FOUND THEN
2283: UPDATE HZ_DQM_STAGE_LOG
2284: SET START_FLAG ='Y', START_TIME=SYSDATE,END_FLAG = 'Y', END_TIME=SYSDATE
2285: WHERE OPERATION = 'CREATE_INDEXES' AND step = 'HZ_CONTACT_POINTS';
2286: WHEN OTHERS THEN
2287:

Line 2500: FROM HZ_DQM_STAGE_LOG

2496: ) IS
2497:
2498: CURSOR l_log_cur(p_command VARCHAR2, l_worker_number NUMBER, l_step VARCHAR2) is
2499: ( SELECT start_flag, end_flag
2500: FROM HZ_DQM_STAGE_LOG
2501: WHERE OPERATION = p_command
2502: AND WORKER_NUMBER = l_worker_number AND step = l_step);
2503:
2504: l_party_id NUMBER;

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

2629: IF nvl(l_end_flag,'N') = 'N' THEN
2630: IF nvl(l_start_flag ,'N') = 'N' THEN
2631:
2632: l_log_step := 'STEP1';
2633: UPDATE HZ_DQM_STAGE_LOG set start_flag='Y', start_time = SYSDATE
2634: WHERE OPERATION = p_command
2635: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2636: --COMMIT;
2637:

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

2641: 'ALL_PARTIES', 'ORGANIZATION',l_worker_number, l_num_workers, NULL,'N', l_start_rowid,l_end_rowid,l_party_cur);
2642: HZ_STAGE_MAP_TRANSFORM.insert_stage_parties('N',l_party_cur);
2643:
2644: l_log_step := 'STEP2';
2645: UPDATE HZ_DQM_STAGE_LOG set start_flag='Y', start_time = SYSDATE
2646: WHERE OPERATION = p_command
2647: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2648: COMMIT;
2649:

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

2652: 'ALL_PARTIES', 'PERSON',l_worker_number, l_num_workers, NULL,'N', l_start_rowid,l_end_rowid,l_party_cur);
2653: HZ_STAGE_MAP_TRANSFORM.insert_stage_parties('N',l_party_cur);
2654:
2655: l_log_step := 'STEP3';
2656: UPDATE HZ_DQM_STAGE_LOG set start_flag='Y', start_time = SYSDATE
2657: WHERE OPERATION = p_command
2658: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2659: COMMIT;
2660:

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

2712: raise;
2713: END;
2714: -- CLOSE l_party_cur;
2715: l_log_step := 'STEP1';
2716: UPDATE HZ_DQM_STAGE_LOG set end_flag='Y', end_time = SYSDATE
2717: WHERE OPERATION = p_command
2718: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2719:
2720: COMMIT;

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

2736: END IF;
2737:
2738: -- CLOSE l_party_cur;
2739: l_log_step := 'STEP2';
2740: UPDATE HZ_DQM_STAGE_LOG set end_flag='Y', end_time = SYSDATE
2741: WHERE OPERATION = p_command
2742: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2743:
2744: COMMIT;

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

2761: END IF;
2762:
2763: --CLOSE l_party_cur;
2764: l_log_step := 'STEP3';
2765: UPDATE HZ_DQM_STAGE_LOG set end_flag='Y', end_time = SYSDATE
2766: WHERE OPERATION = p_command
2767: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2768:
2769: COMMIT;

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

2785:
2786: IF nvl(l_end_flag,'N') = 'N' THEN
2787: IF nvl(l_start_flag,'N') = 'N' THEN
2788: l_log_step := 'STEP1';
2789: UPDATE HZ_DQM_STAGE_LOG set start_flag='Y', start_time = SYSDATE
2790: WHERE OPERATION = p_command
2791: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2792: COMMIT;
2793:

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

2801: CLOSE l_party_cur;
2802: END IF;
2803:
2804: l_log_step := 'STEP1';
2805: UPDATE HZ_DQM_STAGE_LOG set end_flag='Y', end_time = SYSDATE
2806: WHERE OPERATION = p_command
2807: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2808:
2809: COMMIT;

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

2820:
2821: IF nvl(l_end_flag,'N') = 'N' THEN
2822: IF nvl(l_start_flag,'N') = 'N' THEN
2823: l_log_step := 'STEP2';
2824: UPDATE HZ_DQM_STAGE_LOG set start_flag='Y', start_time = SYSDATE
2825: WHERE OPERATION = p_command
2826: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2827:
2828: END IF;

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

2835: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_parties(l_party_cur);
2836: CLOSE l_party_cur;
2837: END IF;
2838: l_log_step := 'STEP2';
2839: UPDATE HZ_DQM_STAGE_LOG set end_flag='Y', end_time = SYSDATE
2840: WHERE OPERATION = p_command
2841: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2842:
2843: COMMIT;

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

2855:
2856: IF nvl(l_end_flag,'N') = 'N' THEN
2857: IF nvl(l_start_flag,'N') = 'N' THEN
2858: l_log_step := 'STEP3';
2859: UPDATE HZ_DQM_STAGE_LOG set start_flag='Y', start_time = SYSDATE
2860: WHERE OPERATION = p_command
2861: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2862: END IF;
2863:

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

2870: CLOSE l_party_cur;
2871: END IF;
2872:
2873: l_log_step := 'STEP3';
2874: UPDATE HZ_DQM_STAGE_LOG set end_flag='Y', end_time = SYSDATE
2875: WHERE OPERATION = p_command
2876: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2877:
2878: COMMIT;

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

2890:
2891: IF nvl(l_end_flag,'N') = 'N' THEN
2892: IF nvl(l_start_flag,'N') = 'N' THEN
2893: l_log_step := 'STEP4';
2894: UPDATE HZ_DQM_STAGE_LOG set start_flag='Y', start_time = SYSDATE
2895: WHERE OPERATION = p_command
2896: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2897:
2898: END IF;

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

2903: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_contacts(l_contact_cur);
2904: CLOSE l_contact_cur;
2905: END IF;
2906: l_log_step := 'STEP4';
2907: UPDATE HZ_DQM_STAGE_LOG set end_flag='Y', end_time = SYSDATE
2908: WHERE OPERATION = p_command
2909: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2910:
2911: COMMIT;

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

2923:
2924: IF nvl(l_end_flag,'N') = 'N' THEN
2925: IF nvl(l_start_flag,'N') = 'N' THEN
2926: l_log_step := 'STEP5';
2927: UPDATE HZ_DQM_STAGE_LOG set start_flag='Y', start_time = SYSDATE
2928: WHERE OPERATION = p_command
2929: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2930:
2931: END IF;

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

2937: CLOSE l_party_site_cur;
2938: END IF;
2939:
2940: l_log_step := 'STEP5';
2941: UPDATE HZ_DQM_STAGE_LOG set end_flag='Y', end_time = SYSDATE
2942: WHERE OPERATION = p_command
2943: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2944:
2945: COMMIT;

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

2956:
2957: IF nvl(l_end_flag,'N') = 'N' THEN
2958: IF nvl(l_start_flag,'N') = 'N' THEN
2959: l_log_step := 'STEP6';
2960: UPDATE HZ_DQM_STAGE_LOG set start_flag='Y', start_time = SYSDATE
2961: WHERE OPERATION = p_command
2962: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2963:
2964: END IF;

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

2969: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_contact_pts(l_cpt_cur);
2970: CLOSE l_cpt_cur;
2971: END IF;
2972: l_log_step := 'STEP6';
2973: UPDATE HZ_DQM_STAGE_LOG set end_flag='Y', end_time = SYSDATE
2974: WHERE OPERATION = p_command
2975: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2976:
2977: COMMIT;

Line 3659: FROM HZ_DQM_STAGE_LOG

3655: IF CREATE_PARTY_TEXT_INDEX THEN
3656: create_btree_indexes ('PARTY');
3657: BEGIN
3658: SELECT start_flag, end_flag INTO l_start_flag, l_end_flag
3659: FROM HZ_DQM_STAGE_LOG
3660: WHERE OPERATION = 'CREATE_INDEXES'
3661: AND step = 'HZ_PARTIES';
3662: EXCEPTION
3663: WHEN no_data_found THEN

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

3679: EXECUTE IMMEDIATE 'ALTER INDEX ' || l_index_owner ||
3680: '.hz_stage_parties_t1 rebuild parameters(''resume memory ' || p_idx_mem || ''')';
3681: log('Index Successfully built');
3682:
3683: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE
3684: WHERE operation = 'CREATE_INDEXES' AND step ='HZ_PARTIES';
3685: COMMIT;
3686:
3687: EXCEPTION

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

3700: END;
3701: END IF;
3702:
3703: IF nvl(l_start_flag,'N') = 'N' THEN
3704: UPDATE HZ_DQM_STAGE_LOG set START_FLAG = 'Y', START_TIME=SYSDATE
3705: WHERE operation = 'CREATE_INDEXES' AND step ='HZ_PARTIES';
3706: COMMIT;
3707:
3708: l_section_grp := g_schema_name || '.HZ_DQM_PARTY_GRP';

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

3738: END;
3739: log('Done creating hz_stage_parties_t1');
3740: END IF;
3741:
3742: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE
3743: WHERE operation = 'CREATE_INDEXES' AND step ='HZ_PARTIES';
3744: COMMIT;
3745: END IF;
3746: log(' Completed at ' || to_char(SYSDATE, 'HH24:MI:SS'));

Line 3755: FROM HZ_DQM_STAGE_LOG

3751: IF CREATE_PS_TEXT_INDEX THEN
3752: create_btree_indexes ('PARTY_SITES');
3753: BEGIN
3754: SELECT start_flag, end_flag INTO l_start_flag, l_end_flag
3755: FROM HZ_DQM_STAGE_LOG
3756: WHERE OPERATION = 'CREATE_INDEXES'
3757: AND step = 'HZ_PARTY_SITES';
3758: EXCEPTION
3759: WHEN no_data_found THEN

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

3775: EXECUTE IMMEDIATE 'ALTER INDEX ' || l_index_owner ||
3776: '.hz_stage_party_sites_t1 rebuild parameters(''resume memory ' || p_idx_mem || ''')';
3777: log('Index Successfully built');
3778:
3779: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE
3780: WHERE operation = 'CREATE_INDEXES' AND step ='HZ_PARTY_SITES';
3781: COMMIT;
3782:
3783: EXCEPTION

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

3796: END;
3797: END IF;
3798:
3799: IF nvl(l_start_flag,'N') = 'N' THEN
3800: UPDATE HZ_DQM_STAGE_LOG set START_FLAG = 'Y', START_TIME=SYSDATE
3801: WHERE operation = 'CREATE_INDEXES' AND step ='HZ_PARTY_SITES';
3802: COMMIT;
3803:
3804: l_section_grp := g_schema_name || '.HZ_DQM_PS_GRP';

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

3833: END;
3834: log('Done creating hz_stage_party_sites_t1');
3835: END IF;
3836:
3837: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE
3838: WHERE operation = 'CREATE_INDEXES' AND step ='HZ_PARTY_SITES';
3839: COMMIT;
3840: END IF;
3841: log(' Completed at ' || to_char(SYSDATE, 'HH24:MI:SS'));

Line 3850: FROM HZ_DQM_STAGE_LOG

3846: IF CREATE_CONTACT_TEXT_INDEX THEN
3847: create_btree_indexes ('CONTACTS');
3848: BEGIN
3849: SELECT start_flag, end_flag INTO l_start_flag, l_end_flag
3850: FROM HZ_DQM_STAGE_LOG
3851: WHERE OPERATION = 'CREATE_INDEXES'
3852: AND step = 'HZ_ORG_CONTACTS';
3853: EXCEPTION
3854: WHEN no_data_found THEN

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

3870: EXECUTE IMMEDIATE 'ALTER INDEX ' || l_index_owner ||
3871: '.hz_stage_contact_t1 rebuild parameters(''resume memory ' || p_idx_mem || ''')';
3872: log('Index Successfully built');
3873:
3874: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE
3875: WHERE operation = 'CREATE_INDEXES' AND step ='HZ_ORG_CONTACTS';
3876: COMMIT;
3877:
3878: EXCEPTION

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

3891: END;
3892: END IF;
3893:
3894: IF nvl(l_start_flag,'N') = 'N' THEN
3895: UPDATE HZ_DQM_STAGE_LOG set START_FLAG = 'Y', START_TIME=SYSDATE
3896: WHERE operation = 'CREATE_INDEXES' AND step ='HZ_ORG_CONTACTS';
3897: COMMIT;
3898:
3899: l_section_grp := g_schema_name || '.HZ_DQM_CONTACT_GRP';

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

3931: log('Created hz_stage_contact_t1');
3932:
3933: END IF;
3934:
3935: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE
3936: WHERE operation = 'CREATE_INDEXES' AND step ='HZ_ORG_CONTACTS';
3937: COMMIT;
3938: END IF;
3939: log(' Completed at ' || to_char(SYSDATE, 'HH24:MI:SS'));

Line 3948: FROM HZ_DQM_STAGE_LOG

3944: IF CREATE_CPT_TEXT_INDEX THEN
3945: create_btree_indexes ('CONTACT_POINTS');
3946: BEGIN
3947: SELECT start_flag, end_flag INTO l_start_flag, l_end_flag
3948: FROM HZ_DQM_STAGE_LOG
3949: WHERE OPERATION = 'CREATE_INDEXES'
3950: AND step = 'HZ_CONTACT_POINTS';
3951: EXCEPTION
3952: WHEN no_data_found THEN

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

3968: EXECUTE IMMEDIATE 'ALTER INDEX ' || l_index_owner ||
3969: '.hz_stage_cpt_t1 rebuild parameters(''resume memory ' || p_idx_mem || ''')';
3970:
3971: log('Index Successfully built');
3972: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE
3973: WHERE operation = 'CREATE_INDEXES' AND step ='HZ_CONTACT_POINTS';
3974: COMMIT;
3975:
3976: EXCEPTION

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

3989: END;
3990: END IF;
3991:
3992: IF nvl(l_start_flag,'N') = 'N' THEN
3993: UPDATE HZ_DQM_STAGE_LOG set START_FLAG = 'Y', START_TIME=SYSDATE
3994: WHERE operation = 'CREATE_INDEXES' AND step ='HZ_CONTACT_POINTS';
3995: COMMIT;
3996:
3997: l_section_grp := g_schema_name || '.HZ_DQM_CPT_GRP';

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

4029:
4030: log('Done creating hz_stage_contact_t1');
4031: END IF;
4032:
4033: UPDATE HZ_DQM_STAGE_LOG set END_FLAG = 'Y', END_TIME=SYSDATE
4034: WHERE operation = 'CREATE_INDEXES' AND step ='HZ_CONTACT_POINTS';
4035: COMMIT;
4036: END IF;
4037: log(' Completed at ' || to_char(SYSDATE, 'HH24:MI:SS'));