APPS.XNP_EVENT SQL Statements

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

Line: 35

		UPDATE	xnp_callback_events
		SET		status = 'CLOSED',
				callback_timestamp = sysdate
		WHERE	callback_event_id = p_cb_event_id;

Line: 42

	UPDATE	xnp_callback_events
	SET		status = 'EXPIRED',
			callback_timestamp = sysdate
	WHERE	process_reference = p_process_reference
	AND		status = 'WAITING'
	AND		close_reqd_flag = 'Y';

Line: 67

		UPDATE	xnp_callback_events
		SET		status = 'EXPIRED',
				callback_timestamp = sysdate
		WHERE	reference_id = p_reference_id
		AND		msg_code = p_msg_code;

Line: 89

		UPDATE	xnp_callback_events
		SET		status = 'EXPIRED',
				callback_timestamp = sysdate
		WHERE	order_id = p_order_id;

Line: 112

		UPDATE	xnp_callback_events
		SET		status = 'EXPIRED',
				callback_timestamp = sysdate
		WHERE	wi_instance_id = p_workitem_instance_id
		 AND    status = 'WAITING';

Line: 149

	INSERT INTO xnp_callback_events (
		callback_event_id,
		reference_id,
		msg_code,
		status,
		process_reference,
		registered_timestamp,
		callback_type,
		callback_proc_name,
		close_reqd_flag,
		order_id,
		wi_instance_id,
		fa_instance_id,
		created_by,
		creation_date,
		last_updated_by,
		last_update_date )
	VALUES (
		XNP_CALLBACK_EVENTS_S.nextval,
		p_reference_id,
		p_msg_code,
		'WAITING',
		p_process_reference,
		SYSDATE,
		p_callback_type,
		p_procedure_name,
		p_close_reqd_flag,
		p_order_id,
		p_wi_instance_id,
		p_fa_instance_id,
		fnd_global.user_id,
		SYSDATE,
		fnd_global.user_id,
		SYSDATE );

Line: 224

		SELECT callback_event_id,
			callback_proc_name,
			process_reference,
			close_reqd_flag,
			order_id,
			wi_instance_id,
			fa_instance_id
		FROM XNP_CALLBACK_EVENTS
		WHERE reference_id in (l_reference_id, '-1')
		AND msg_code = l_msg_code
		AND status = 'WAITING' ;

Line: 312

		xnp_message.update_status(
			p_msg_id=>l_msg_header.message_id,
			p_status=>'PROCESSED',
			p_order_id=>l_order_id,
			p_wi_instance_id=>l_wi_instance_id,
			p_fa_instance_id=>l_fa_instance_id) ;

Line: 333

			xnp_message.update_status(
				p_msg_id=>l_msg_header.message_id,
				p_status=>'FAILED',
				p_error_desc=>l_fnd_message,
				p_order_id=>l_order_id,
				p_wi_instance_id=>l_wi_instance_id,
				p_fa_instance_id=>l_fa_instance_id) ;

Line: 354

			xnp_message.update_status(
				p_msg_id=>l_msg_header.message_id,
				p_status=>'FAILED',
				p_error_desc=>l_fnd_message,
				p_order_id=>l_order_id,
				p_wi_instance_id=>l_wi_instance_id,
				p_fa_instance_id=>l_fa_instance_id) ;

Line: 374

			xnp_message.update_statuS(
				p_msg_id=>l_msg_header.message_id,
				p_status=>'FAILED',
				p_error_desc=>l_fnd_message,
				p_order_id=>l_order_id,
				p_wi_instance_id=>l_wi_instance_id,
				p_fa_instance_id=>l_fa_instance_id) ;

Line: 400

		xnp_message.update_status(
			p_msg_id=>l_msg_header.message_id,
			p_status=>'PROCESSED',
			p_order_id=>l_order_id,
			p_wi_instance_id=>l_wi_instance_id,
			p_fa_instance_id=>l_fa_instance_id) ;

Line: 425

			xnp_message.update_status(
				p_msg_id=>l_msg_header.message_id,
				p_status=>'FAILED',
				p_error_desc=>l_fnd_message,
				p_order_id=>l_order_id,
				p_wi_instance_id=>l_wi_instance_id,
				p_fa_instance_id=>l_fa_instance_id) ;

Line: 445

			xnp_message.update_status(
				p_msg_id=>l_msg_header.message_id,
				p_status=>'FAILED',
				p_error_desc=>l_fnd_message,
				p_order_id=>l_order_id,
				p_wi_instance_id=>l_wi_instance_id,
				p_fa_instance_id=>l_fa_instance_id) ;

Line: 466

			xnp_message.update_status(
				p_msg_id=>l_msg_header.message_id,
				p_status=>'FAILED',
				p_error_desc=>l_fnd_message,
				p_order_id=>l_order_id,
				p_wi_instance_id=>l_wi_instance_id,
				p_fa_instance_id=>l_fa_instance_id) ;

Line: 529

		SELECT callback_event_id,
			callback_proc_name,
			process_reference,
			close_reqd_flag,
			order_id,
			wi_instance_id,
			fa_instance_id
		FROM XNP_CALLBACK_EVENTS
		WHERE reference_id in (l_reference_id, '-1')
--		WHERE ((reference_id = l_reference_id) OR (reference_id IS NULL))
		AND msg_code = l_msg_code
		AND status = 'WAITING' ;

Line: 619

		xnp_message.update_status(
			p_msg_id=>l_msg_header.message_id,
			p_status=>'PROCESSED',
			p_order_id=>l_order_id,
			p_wi_instance_id=>l_wi_instance_id,
			p_fa_instance_id=>l_fa_instance_id) ;

Line: 640

			xnp_message.update_status(
				p_msg_id=>l_msg_header.message_id,
				p_status=>'FAILED',
				p_error_desc=>l_fnd_message,
				p_order_id=>l_order_id,
				p_wi_instance_id=>l_wi_instance_id,
				p_fa_instance_id=>l_fa_instance_id) ;

Line: 661

			xnp_message.update_status(
				p_msg_id=>l_msg_header.message_id,
				p_status=>'FAILED',
				p_error_desc=>l_fnd_message,
				p_order_id=>l_order_id,
				p_wi_instance_id=>l_wi_instance_id,
				p_fa_instance_id=>l_fa_instance_id) ;

Line: 679

			xnp_message.update_statuS(
				p_msg_id=>l_msg_header.message_id,
				p_status=>'FAILED',
				p_error_desc=>l_fnd_message,
				p_order_id=>l_order_id,
				p_wi_instance_id=>l_wi_instance_id,
				p_fa_instance_id=>l_fa_instance_id) ;

Line: 705

		xnp_message.update_status(
			p_msg_id=>l_msg_header.message_id,
			p_status=>'PROCESSED',
			p_order_id=>l_order_id,
			p_wi_instance_id=>l_wi_instance_id,
			p_fa_instance_id=>l_fa_instance_id) ;

Line: 730

			xnp_message.update_status(
				p_msg_id=>l_msg_header.message_id,
				p_status=>'FAILED',
				p_error_desc=>l_fnd_message,
				p_order_id=>l_order_id,
				p_wi_instance_id=>l_wi_instance_id,
				p_fa_instance_id=>l_fa_instance_id) ;

Line: 750

			xnp_message.update_status(
				p_msg_id=>l_msg_header.message_id,
				p_status=>'FAILED',
				p_error_desc=>l_fnd_message,
				p_order_id=>l_order_id,
				p_wi_instance_id=>l_wi_instance_id,
				p_fa_instance_id=>l_fa_instance_id) ;

Line: 770

			xnp_message.update_status(
				p_msg_id=>l_msg_header.message_id,
				p_status=>'FAILED',
				p_error_desc=>l_fnd_message,
				p_order_id=>l_order_id,
				p_wi_instance_id=>l_wi_instance_id,
				p_fa_instance_id=>l_fa_instance_id) ;

Line: 842

		SELECT ack_msg_code FROM XNP_MSG_ACKS
		WHERE source_msg_code = p_message_type;

Line: 962

		xnp_message.update_status(p_message_id,
			'FAILED',
			l_fnd_message) ;

Line: 966

		xnp_message.update_status(p_msg_id=>l_msg_header.message_id,
			p_status=>'FAILED',
			p_error_desc=>l_fnd_message) ;

Line: 993

  SELECT fa_instance_id
    FROM xnp_msgs
   WHERE msg_id = p_message_id;

Line: 1088

			xnp_message.update_status(
				p_msg_id=>l_msg_header.message_id,
				p_status=>'FAILED',
				p_error_desc=>l_fnd_message);