APPS.XDP_MESSAGE dependencies on WF_NOTIFICATION

Line 21: -- SELECT wf.notification_id, msg.msg_id, msg.msg_code

17: -- Logic depends on that subject for notification ends with ' - '.
18:
19: /* Corrected the following SQL to fix bug 3957604. dputhiye. 27/10/04 */
20: -- CURSOR c_notification_to_respond_to IS
21: -- SELECT wf.notification_id, msg.msg_id, msg.msg_code
22: -- FROM wf_notifications wf
23: -- , xnp_msgs msg
24: -- WHERE wf.message_name like 'MSG_FAILURE_NOTIF'
25: -- AND wf.status = 'OPEN'

Line 22: -- FROM wf_notifications wf

18:
19: /* Corrected the following SQL to fix bug 3957604. dputhiye. 27/10/04 */
20: -- CURSOR c_notification_to_respond_to IS
21: -- SELECT wf.notification_id, msg.msg_id, msg.msg_code
22: -- FROM wf_notifications wf
23: -- , xnp_msgs msg
24: -- WHERE wf.message_name like 'MSG_FAILURE_NOTIF'
25: -- AND wf.status = 'OPEN'
26: -- AND msg.msg_code like '||p_msg_to_retry||'

Line 32: SELECT wf.notification_id, msg.msg_id, msg.msg_code

28: -- AND msg.msg_id =
29: -- SUBSTR(subject,INSTR(subject,' - ')+3,LENGTH(subject));
30:
31: CURSOR c_notification_to_respond_to IS
32: SELECT wf.notification_id, msg.msg_id, msg.msg_code
33: FROM wf_notifications wf
34: , xnp_msgs msg
35: WHERE wf.message_name like 'MSG_FAILURE_NOTIF'
36: AND wf.status = 'OPEN'

Line 33: FROM wf_notifications wf

29: -- SUBSTR(subject,INSTR(subject,' - ')+3,LENGTH(subject));
30:
31: CURSOR c_notification_to_respond_to IS
32: SELECT wf.notification_id, msg.msg_id, msg.msg_code
33: FROM wf_notifications wf
34: , xnp_msgs msg
35: WHERE wf.message_name like 'MSG_FAILURE_NOTIF'
36: AND wf.status = 'OPEN'
37: AND msg.msg_code like p_msg_to_retry

Line 49: wf_notification.SetAttrText(

45: FOR rec_notification_to_respond_to IN c_notification_to_respond_to
46: LOOP
47: BEGIN
48:
49: wf_notification.SetAttrText(
50: nid => rec_notification_to_respond_to.notification_id
51: , aname => 'RESULT'
52: , avalue => 'RETRY_MSG');
53:

Line 54: wf_notification.Respond(

50: nid => rec_notification_to_respond_to.notification_id
51: , aname => 'RESULT'
52: , avalue => 'RETRY_MSG');
53:
54: wf_notification.Respond(
55: nid => rec_notification_to_respond_to.notification_id
56: , respond_comment => 'Retried processing message in batch '||
57: 'together with messages with code '||p_msg_to_retry
58: , responder => fnd_global.user_id);