APPS.CSM_NOTIFICATION_EVENT_PKG dependencies on FND_USER

Line 47: p_user_id fnd_user.user_id%TYPE)

43: END check_if_notification_exists;
44:
45: --Bug 5337816
46: PROCEDURE INSERT_NOTIFICATIONS_ACC (p_notification_id wf_notifications.notification_id%TYPE,
47: p_user_id fnd_user.user_id%TYPE)
48: IS
49: l_sysdate DATE;
50: l_count NUMBER;
51: BEGIN

Line 76: CURSOR c_notf(b_user_id fnd_user.user_id%TYPE) IS

72: l_error_msg VARCHAR2(4000);
73: l_return_status VARCHAR2(2000);
74:
75: -- get all notifications in which user is a recipient
76: CURSOR c_notf(b_user_id fnd_user.user_id%TYPE) IS
77: SELECT DISTINCT wfn.notification_id
78: FROM wf_notifications wfn,
79: asg_user au
80: WHERE au.user_id=b_user_id

Line 90: CURSOR c_broadcast_notf(b_user_id fnd_user.user_id%TYPE) IS

86: WHERE ACC.NOTIFICATION_ID = WFN.NOTIFICATION_ID
87: AND ACC.USER_ID = AU.USER_ID);
88:
89: --12.1
90: CURSOR c_broadcast_notf(b_user_id fnd_user.user_id%TYPE) IS
91: SELECT DISTINCT wfn.notification_id
92: FROM WF_NOTIFICATIONS wfn,
93: ASG_USER au
94: WHERE au.user_id=b_user_id