APPS.XNP_MESSAGE dependencies on XNP_EVENT_SUBSCRIBERS

Line 961: xnp_event_subscribers ESS

957: CURSOR get_subscribers (message_code IN VARCHAR2) IS
958: SELECT xnp_utils.get_adapter_using_fe(
959: FET.fulfillment_element_name) adapter_name
960: FROM xdp_fes FET,
961: xnp_event_subscribers ESS
962: WHERE FET.FE_ID = ESS.FE_ID
963: AND ESS.msg_code = message_code ;
964:
965: l_subscriber_count INTEGER ;

Line 1807: DELETE FROM xnp_event_subscribers

1803: DELETE FROM xnp_timer_publishers
1804: WHERE timer_message_code = p_msg_code
1805: OR source_message_code = p_msg_code;
1806:
1807: DELETE FROM xnp_event_subscribers
1808: WHERE msg_code = p_msg_code;
1809:
1810: BEGIN
1811: xnp_msg_types_pkg.delete_row(p_msg_code) ;