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

Line 130: FROM hz_dqm_stage_log

126: func_ret_status BOOLEAN := FALSE;
127:
128: CURSOR c_sh_stage_log_count IS
129: SELECT 1
130: FROM hz_dqm_stage_log
131: WHERE operation = 'SHADOW_STAGING'
132: AND STEP = 'COMPLETE';
133:
134: BEGIN

Line 2127: CURSOR c_non_indexed IS select 1 from hz_dqm_stage_log where operation= 'ALTER_INDEX'

2123: FIRST BOOLEAN ;
2124: l_index_conc_program_req_id NUMBER ;
2125: l_request_id NUMBER ;
2126: --Start of bug 4915282
2127: CURSOR c_non_indexed IS select 1 from hz_dqm_stage_log where operation= 'ALTER_INDEX'
2128: and start_flag = 'Y' and end_flag ='Y';
2129: l_index_count number := 0;
2130:
2131:

Line 2747: SELECT COUNT(*) INTO index_cnt FROM HZ_DQM_STAGE_LOG WHERE OPERATION='ALTER_INDEX';

2743:
2744: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_index_owner);
2745:
2746: -- Propagating the changes done for Bug:4706376
2747: SELECT COUNT(*) INTO index_cnt FROM HZ_DQM_STAGE_LOG WHERE OPERATION='ALTER_INDEX';
2748:
2749: IF enabled = 'Y'
2750: THEN
2751: EXECUTE IMMEDIATE 'ALTER INDEX ' || l_index_owner ||

Line 2762: insert into hz_dqm_stage_log(OPERATION, NUMBER_OF_WORKERS,WORKER_NUMBER,STEP,START_FLAG,START_TIME,END_FLAG,

2758: '.hz_stage_cpt_t1 rebuild parameters(''replace metadata transactional'')';
2759:
2760: -- Propagating the changes done for Bug:4706376
2761: if(index_cnt=null OR index_cnt=0) then
2762: insert into hz_dqm_stage_log(OPERATION, NUMBER_OF_WORKERS,WORKER_NUMBER,STEP,START_FLAG,START_TIME,END_FLAG,
2763: END_TIME,LAST_UPDATE_DATE, CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_LOGIN )
2764: values ('ALTER_INDEX',1,1,'STAGED_TABLES','Y',sysdate,'Y',null,sysdate,sysdate,
2765: fnd_global.user_id,fnd_global.user_id,fnd_global.login_id);
2766: else

Line 2767: update hz_dqm_stage_log set start_flag='Y',end_flag='Y',start_time=sysdate,

2763: END_TIME,LAST_UPDATE_DATE, CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_LOGIN )
2764: values ('ALTER_INDEX',1,1,'STAGED_TABLES','Y',sysdate,'Y',null,sysdate,sysdate,
2765: fnd_global.user_id,fnd_global.user_id,fnd_global.login_id);
2766: else
2767: update hz_dqm_stage_log set start_flag='Y',end_flag='Y',start_time=sysdate,
2768: last_update_date=sysdate,last_update_login=fnd_global.login_id
2769: where operation='ALTER_INDEX';
2770: end if;
2771:

Line 2784: insert into hz_dqm_stage_log(OPERATION, NUMBER_OF_WORKERS,WORKER_NUMBER,STEP,START_FLAG,START_TIME,END_FLAG,

2780: '.hz_stage_cpt_t1 rebuild parameters(''replace metadata nontransactional'')';
2781:
2782: -- Propagating the changes done for Bug:4706376
2783: if(index_cnt=null OR index_cnt=0) then
2784: insert into hz_dqm_stage_log(OPERATION, NUMBER_OF_WORKERS,WORKER_NUMBER,STEP,START_FLAG,START_TIME,END_FLAG,
2785: END_TIME,LAST_UPDATE_DATE, CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_LOGIN)
2786: values ('ALTER_INDEX',1,1,'STAGED_TABLES','N',sysdate,'N',null,sysdate,sysdate,
2787: fnd_global.user_id,fnd_global.user_id,fnd_global.login_id);
2788: else

Line 2789: update hz_dqm_stage_log set start_flag='N',end_flag='N',start_time=sysdate,

2785: END_TIME,LAST_UPDATE_DATE, CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_LOGIN)
2786: values ('ALTER_INDEX',1,1,'STAGED_TABLES','N',sysdate,'N',null,sysdate,sysdate,
2787: fnd_global.user_id,fnd_global.user_id,fnd_global.login_id);
2788: else
2789: update hz_dqm_stage_log set start_flag='N',end_flag='N',start_time=sysdate,
2790: last_update_date=sysdate,last_update_login=fnd_global.login_id
2791: where operation='ALTER_INDEX';
2792: end if;
2793: