DBA Data[Home] [Help]

APPS.XDP_CRON_UTIL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 36

Procedure UpdateDBJob (
	p_jobID in number,
	p_request in number,
	p_ReqDate in date,
	p_Freq in number )
is
l_tmpdate varchar2(4000);
Line: 45

		FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_CRON_UTIL.UPDATEDBJOB',
				'BEGIN:p_request: '||p_request);
Line: 60

end UpdateDBJob;
Line: 103

		-- request is not there? Maybe, request got deleted and job is still
		-- getting executed. Donot do anything, return
		-- With the deletion of request, job for future will anyway be deleted

	IF( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN -- Fix: 4256771, dbhagat, 28 Apr 05
		FND_LOG.STRING (FND_LOG.LEVEL_ERROR,
				'XDP_CRON_UTIL.EXECUTE_ADAPTER_ADMIN',
				'After FetchAdapterAdminReqInfo, SQLCODE: '||SQLCODE);
Line: 211

		XDP_ADAPTER.Delete_Admin_Request (
				p_request, l_RetCode, l_ErrorMsg);