DBA Data[Home] [Help]

APPS.HZ_DQM_SYNC dependencies on FND_GLOBAL

Line 2269: l_request_id := FND_GLOBAL.conc_request_id ;

2265: log('Total number of Data Workers deployed = ' || l_num_of_workers );
2266: log ('Data Workers only create/update data');
2267:
2268: --get request_id of this program
2269: l_request_id := FND_GLOBAL.conc_request_id ;
2270:
2271: -- Deploy Data Workers
2272:
2273: FIRST := TRUE ;

Line 2765: fnd_global.user_id,fnd_global.user_id,fnd_global.login_id);

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
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';

Line 2768: last_update_date=sysdate,last_update_login=fnd_global.login_id

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:
2772: ELSE

Line 2787: fnd_global.user_id,fnd_global.user_id,fnd_global.login_id);

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
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';

Line 2790: last_update_date=sysdate,last_update_login=fnd_global.login_id

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:
2794: END IF ;

Line 2962: Where Parent_Request_Id = FND_GLOBAL.conc_request_id

2958:
2959: -- get request ids that did not complete
2960: Select request_id BULK COLLECT into l_sub_requests
2961: from Fnd_Concurrent_Requests R
2962: Where Parent_Request_Id = FND_GLOBAL.conc_request_id
2963: and (phase_code<>'C' or status_code<>'C');
2964:
2965: -- log these request_ids and set the return code of the parent concurrent program
2966: -- to 2 ie., ERROR