APPS.CSM_AUTO_SYNC_NFN_PKG dependencies on FND_USER

Line 37: p_user_id IN fnd_user.user_id%TYPE)

33: AND clid$$cs = b_user_name;
34: -----------------------------------------------------------------------------------------------------------
35:
36: PROCEDURE INSERT_AUTO_SYNC_NFN_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

Line 58: PROCEDURE AUTO_SYNC_NFN_ACC_PROCESSOR(p_user_id IN fnd_user.user_id%TYPE)

54: RAISE;
55: END INSERT_AUTO_SYNC_NFN_ACC;-- end INSERT_AUTO_SYNC_NFN_ACC
56: -------------------------------------------------------------------------------------------------
57:
58: PROCEDURE AUTO_SYNC_NFN_ACC_PROCESSOR(p_user_id IN fnd_user.user_id%TYPE)
59: IS
60: l_sqlerrno VARCHAR2(20);
61: l_sqlerrmsg VARCHAR2(4000);
62: l_error_msg VARCHAR2(4000);

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

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_NFN
69: WHERE user_id=b_user_id;
70: