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 2008: CURSOR c_non_indexed IS select 1 from hz_dqm_stage_log where operation= 'ALTER_INDEX'

2004: FIRST BOOLEAN ;
2005: l_index_conc_program_req_id NUMBER ;
2006: l_request_id NUMBER ;
2007: --Start of bug 4915282
2008: CURSOR c_non_indexed IS select 1 from hz_dqm_stage_log where operation= 'ALTER_INDEX'
2009: and start_flag = 'Y' and end_flag ='Y';
2010: l_index_count number := 0;
2011: --End of bug 4915282
2012: BEGIN

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

2564:
2565: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_index_owner);
2566:
2567: -- Propagating the changes done for Bug:4706376
2568: SELECT COUNT(*) INTO index_cnt FROM HZ_DQM_STAGE_LOG WHERE OPERATION='ALTER_INDEX';
2569:
2570: IF enabled = 'Y'
2571: THEN
2572: EXECUTE IMMEDIATE 'ALTER INDEX ' || l_index_owner ||

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

2579: '.hz_stage_cpt_t1 rebuild parameters(''replace metadata transactional'')';
2580:
2581: -- Propagating the changes done for Bug:4706376
2582: if(index_cnt=null OR index_cnt=0) then
2583: insert into hz_dqm_stage_log(OPERATION, NUMBER_OF_WORKERS,WORKER_NUMBER,STEP,START_FLAG,START_TIME,END_FLAG,
2584: END_TIME,LAST_UPDATE_DATE, CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_LOGIN )
2585: values ('ALTER_INDEX',1,1,'STAGED_TABLES','Y',sysdate,'Y',null,sysdate,sysdate,
2586: fnd_global.user_id,fnd_global.user_id,fnd_global.login_id);
2587: else

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

2584: END_TIME,LAST_UPDATE_DATE, CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_LOGIN )
2585: values ('ALTER_INDEX',1,1,'STAGED_TABLES','Y',sysdate,'Y',null,sysdate,sysdate,
2586: fnd_global.user_id,fnd_global.user_id,fnd_global.login_id);
2587: else
2588: update hz_dqm_stage_log set start_flag='Y',end_flag='Y',start_time=sysdate,
2589: last_update_date=sysdate,last_update_login=fnd_global.login_id
2590: where operation='ALTER_INDEX';
2591: end if;
2592:

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

2601: '.hz_stage_cpt_t1 rebuild parameters(''replace metadata nontransactional'')';
2602:
2603: -- Propagating the changes done for Bug:4706376
2604: if(index_cnt=null OR index_cnt=0) then
2605: insert into hz_dqm_stage_log(OPERATION, NUMBER_OF_WORKERS,WORKER_NUMBER,STEP,START_FLAG,START_TIME,END_FLAG,
2606: END_TIME,LAST_UPDATE_DATE, CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_LOGIN)
2607: values ('ALTER_INDEX',1,1,'STAGED_TABLES','N',sysdate,'N',null,sysdate,sysdate,
2608: fnd_global.user_id,fnd_global.user_id,fnd_global.login_id);
2609: else

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

2606: END_TIME,LAST_UPDATE_DATE, CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_LOGIN)
2607: values ('ALTER_INDEX',1,1,'STAGED_TABLES','N',sysdate,'N',null,sysdate,sysdate,
2608: fnd_global.user_id,fnd_global.user_id,fnd_global.login_id);
2609: else
2610: update hz_dqm_stage_log set start_flag='N',end_flag='N',start_time=sysdate,
2611: last_update_date=sysdate,last_update_login=fnd_global.login_id
2612: where operation='ALTER_INDEX';
2613: end if;
2614: