DBA Data[Home] [Help]

APPS.CSM_CLIENT_NFN_LOG_PKG dependencies on FND_USER

Line 38: p_user_id IN fnd_user.user_id%TYPE)

34: AND clid$$cs = b_user_name;
35:
36: -----------------------------------------------------------------------------------------------------------
37: PROCEDURE INSERT_CLIENT_NFN_LOG_ACC (p_notification_id IN wf_notifications.notification_id%TYPE,
38: p_user_id IN fnd_user.user_id%TYPE)
39: IS
40: l_sysdate DATE;
41: l_count NUMBER;
42: BEGIN

Line 60: PROCEDURE CLIENT_NFN_LOG_ACC_PROCESSOR(p_user_id IN fnd_user.user_id%TYPE)

56: RAISE;
57: END INSERT_CLIENT_NFN_LOG_ACC;-- end INSERT_CLIENT_NFN_LOG_ACC
58: -------------------------------------------------------------------------------------------------
59:
60: PROCEDURE CLIENT_NFN_LOG_ACC_PROCESSOR(p_user_id IN fnd_user.user_id%TYPE)
61: IS
62: l_sqlerrno VARCHAR2(20);
63: l_sqlerrmsg VARCHAR2(4000);
64: l_error_msg VARCHAR2(4000);

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

64: l_error_msg VARCHAR2(4000);
65: l_return_status VARCHAR2(2000);
66:
67: -- get all notifications in which user is a recipient
68: CURSOR c_notf(b_user_id fnd_user.user_id%TYPE) IS
69: SELECT DISTINCT notification_id
70: FROM CSM_CLIENT_NFN_LOG_ACC ACC;
71:
72: BEGIN