APPS.XNP_TIMER SQL Statements

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

Line: 109

    SELECT timer_id,timer_message_code,next_timer
    FROM  xnp_timer_registry
    WHERE
          reference_id=p_msg_header.reference_id
    AND
    (
          timer_message_code = p_message_code
       OR
          next_timer= p_message_code
    )
    AND   status = 'ACTIVE';

Line: 222

	INSERT INTO xnp_timer_registry (
		timer_id,
		reference_id,
		timer_message_code,
		status,
		start_time,
		end_time,
		next_timer,
		order_id,
		wi_instance_id,
		fa_instance_id,
		created_by,
		creation_date,
		last_updated_by,
		last_update_date
	)
	VALUES (
		p_msg_header.message_id,
		p_msg_header.reference_id,
		p_msg_header.message_code,
		'ACTIVE',
		l_start_time,
		l_end_time,
		p_dummy_for,
		p_msg_header.order_id,
		p_msg_header.wi_instance_id,
		p_msg_header.fa_instance_id,
		fnd_global.user_id,
		sysdate,
		fnd_global.user_id,
		sysdate
		);