APPS.XDP_ERRORS_PKG SQL Statements

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

Line: 35

		insert into XDP_ERROR_LOG (
			ERROR_ID,
			OBJECT_TYPE,
			OBJECT_KEY,
			ERROR_TIMESTAMP,
			MESSAGE_NAME,
			MESSAGE_PARAMETERS,
			ERROR_TYPE,
			CREATED_BY,
			CREATION_DATE,
			LAST_UPDATED_BY,
			LAST_UPDATE_DATE,
			LAST_UPDATE_LOGIN) values (
			XDP_ERRORS_S.NEXTVAL,
			p_object_type,
			p_object_key,
			SYSDATE,
			p_message_name,
			nvl(l_message_parameters, NULL),
			p_error_type,
			FND_GLOBAL.USER_ID,
			SYSDATE,
			FND_GLOBAL.USER_ID,
			SYSDATE,
			FND_GLOBAL.LOGIN_ID);

Line: 275

		select message, error_type, MAX(error_timestamp)
		into p_message, p_error_type, p_message_timestamp
		from XDP_ERROR_LOG_V
		where object_type = p_object_type and object_key = p_object_key;

Line: 289

PROCEDURE Update_Error_Count (
		p_object_type 		IN VARCHAR2,
		p_object_key 		IN VARCHAR2,
		p_error_count		IN NUMBER DEFAULT 0)
is
begin

	UPDATE xdp_error_count SET
		error_count = p_error_count,
		last_updated_by = FND_GLOBAL.USER_ID,
		last_update_date = sysdate,
		last_update_login = FND_GLOBAL.USER_ID
	WHERE
		object_type = p_object_type and object_key = p_object_key;

Line: 306

		INSERT INTO XDP_ERROR_COUNT (
			object_type,
			object_key,
			error_count,
			created_by,
			creation_date,
			last_updated_by,
			last_update_date,
			last_update_login
		) VALUES (
			p_object_type,
			p_object_key,
			p_error_count,
			FND_GLOBAL.USER_ID,
			sysdate,
			FND_GLOBAL.USER_ID,
			sysdate,
			FND_GLOBAL.LOGIN_ID);

Line: 326

END UPDATE_ERROR_COUNT;

Line: 337

		SELECT error_count into l_errorCount
		FROM xdp_error_count
		WHERE object_type = p_object_type and object_key = p_object_key;