DBA Data[Home] [Help]

APPS.XDP_AQ_UTILITIES dependencies on XNP_MSGS

Line 3612: UPDATE xnp_msgs

3608:
3609: l_msg_header := p_msg_header ;
3610: l_correlation_id := l_msg_header.message_code ;
3611:
3612: UPDATE xnp_msgs
3613: SET msg_status = 'READY',
3614: last_update_date = SYSDATE
3615: WHERE msg_id = l_msg_header.message_id;
3616:

Line 3735: FROM xnp_msgs

3731: ELSE IF object_type = 'MESSAGE_OBJECT' THEN
3732:
3733: SELECT order_id
3734: INTO l_order_id
3735: FROM xnp_msgs
3736: WHERE msg_id = object_id;
3737:
3738: IF l_order_id IS NULL THEN
3739: RETURN true; --Message is independent, therefore process it