APPS.CSM_AUTO_SYNC_PKG dependencies on FND_USER

Line 37: PROCEDURE INSERT_AUTO_SYNC_ACC (p_id NUMBER, p_user_id IN fnd_user.user_id%TYPE,p_auto_sync_num NUMBER)

33: WHERE tranid$$ = b_tranid
34: AND clid$$cs = b_user_name;
35:
36:
37: PROCEDURE INSERT_AUTO_SYNC_ACC (p_id NUMBER, p_user_id IN fnd_user.user_id%TYPE,p_auto_sync_num NUMBER)
38: IS
39: l_sysdate DATE;
40: l_count NUMBER;
41: BEGIN

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

56: RAISE;
57: END INSERT_AUTO_SYNC_ACC;-- end INSERT_AUTO_SYNC_ACC
58:
59: /******************************************************************************************************************/
60: PROCEDURE AUTO_SYNC_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_id(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_id(b_user_id fnd_user.user_id%TYPE) IS
69: SELECT id, auto_sync_num
70: FROM csm_auto_sync;
71:
72: BEGIN