APPS.AR_CMGT_UTIL dependencies on WF_NOTIFICATIONS

Line 971: l_notification_id wf_notifications.notification_id%type;

967: p_recipient_role IN VARCHAR2,
968: p_resultout OUT NOCOPY VARCHAR2,
969: p_error_msg OUT NOCOPY VARCHAR2) IS
970:
971: l_notification_id wf_notifications.notification_id%type;
972:
973: BEGIN
974: IF pg_debug = 'Y' THEN
975: debug ('CLOSE_WF_NOTIFICATION(+)' );

Line 985: from wf_notifications

981: p_error_msg := null;
982:
983: select notification_id
984: INTO l_notification_id
985: from wf_notifications
986: where message_name = p_message_name --'MSG_TO_CM_NO_CA'
987: and Recipient_role = p_recipient_role --'FND_RESP222:23918'
988: and status = 'OPEN'
989: and context like 'ARCMGTAP:'||p_credit_request_id||'%';