33: AND clid$$cs = b_user_name;
34:
35: -----------------------------------------------------------------------------------------------------------
36: PROCEDURE INSERT_AUTO_SYNC_LOG_ACC (p_notification_id IN wf_notifications.notification_id%TYPE,
37: p_user_id IN fnd_user.user_id%TYPE)
38: IS
39: l_sysdate DATE;
40: l_count NUMBER;
41: BEGIN
62: l_error_msg VARCHAR2(4000);
63: l_return_status VARCHAR2(2000);
64:
65: -- get all notifications in which user is a recipient
66: /*CURSOR c_notf(b_user_id fnd_user.user_id%TYPE) IS
67: SELECT DISTINCT notification_id
68: FROM CSM_AUTO_SYNC_LOG_ACC ACC;
69: */
70: BEGIN