DBA Data[Home] [Help]

APPS.XDP_INTERFACES dependencies on XNP_MSGS

Line 623: ** Mark massages for the order in xnp_msgs table to 'CANCELED'

619: error_description := lv_timer_err||lv_event_err;
620: END IF;
621:
622: /**
623: ** Mark massages for the order in xnp_msgs table to 'CANCELED'
624: **/
625:
626: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
627: IF (FND_LOG.TEST(FND_LOG.LEVEL_STATEMENT, 'xdp.plsql.XDP_INTERFACES.CANCEL_ORDER')) THEN

Line 4008: UPDATE xnp_msgs

4004: END IF;
4005: END IF;
4006: END IF;
4007:
4008: UPDATE xnp_msgs
4009: SET msg_status = 'CANCELED',
4010: last_update_date = SYSDATE
4011: WHERE order_id = p_order_id
4012: AND msg_status = 'READY';