APPS.XNP_EVENT dependencies on XNP_CALLBACK_EVENTS

Line 35: UPDATE xnp_callback_events

31: -- Cursors replaced by explicit updates
32:
33: IF (p_close_flag = 'Y') THEN
34:
35: UPDATE xnp_callback_events
36: SET status = 'CLOSED',
37: callback_timestamp = sysdate
38: WHERE callback_event_id = p_cb_event_id;
39:

Line 42: UPDATE xnp_callback_events

38: WHERE callback_event_id = p_cb_event_id;
39:
40: END IF ;
41:
42: UPDATE xnp_callback_events
43: SET status = 'EXPIRED',
44: callback_timestamp = sysdate
45: WHERE process_reference = p_process_reference
46: AND status = 'WAITING'

Line 67: UPDATE xnp_callback_events

63:
64: -- adabholk 03/01 - Performance fix
65: -- Cursors replaced by explicit updates
66:
67: UPDATE xnp_callback_events
68: SET status = 'EXPIRED',
69: callback_timestamp = sysdate
70: WHERE reference_id = p_reference_id
71: AND msg_code = p_msg_code;

Line 89: UPDATE xnp_callback_events

85: BEGIN
86: -- adabholk 03/01 - Performance fix
87: -- Cursors replaced by explicit updates
88:
89: UPDATE xnp_callback_events
90: SET status = 'EXPIRED',
91: callback_timestamp = sysdate
92: WHERE order_id = p_order_id;
93:

Line 112: UPDATE xnp_callback_events

108: ,x_error_message OUT NOCOPY VARCHAR2
109: )
110: IS
111: BEGIN
112: UPDATE xnp_callback_events
113: SET status = 'EXPIRED',
114: callback_timestamp = sysdate
115: WHERE wi_instance_id = p_workitem_instance_id
116: AND status = 'WAITING';

Line 149: INSERT INTO xnp_callback_events (

145: )
146: IS
147: BEGIN
148:
149: INSERT INTO xnp_callback_events (
150: callback_event_id,
151: reference_id,
152: msg_code,
153: status,

Line 167: XNP_CALLBACK_EVENTS_S.nextval,

163: creation_date,
164: last_updated_by,
165: last_update_date )
166: VALUES (
167: XNP_CALLBACK_EVENTS_S.nextval,
168: p_reference_id,
169: p_msg_code,
170: 'WAITING',
171: p_process_reference,

Line 231: FROM XNP_CALLBACK_EVENTS

227: close_reqd_flag,
228: order_id,
229: wi_instance_id,
230: fa_instance_id
231: FROM XNP_CALLBACK_EVENTS
232: WHERE reference_id in (l_reference_id, '-1')
233: AND msg_code = l_msg_code
234: AND status = 'WAITING' ;
235:

Line 536: FROM XNP_CALLBACK_EVENTS

532: close_reqd_flag,
533: order_id,
534: wi_instance_id,
535: fa_instance_id
536: FROM XNP_CALLBACK_EVENTS
537: WHERE reference_id in (l_reference_id, '-1')
538: -- WHERE ((reference_id = l_reference_id) OR (reference_id IS NULL))
539: AND msg_code = l_msg_code
540: AND status = 'WAITING' ;