APPS.CSM_USER_EVENT_PKG dependencies on ASG_USER

Line 25: FROM asg_user_pub_resps aupr,

21:
22: CURSOR l_responsibilities_csr (p_resp_id NUMBER, l_user_id IN NUMBER)
23: IS
24: SELECT 1 --R12-Multiple Responsibility
25: FROM asg_user_pub_resps aupr,
26: asg_user asu
27: WHERE aupr.user_name = asu.user_name
28: AND aupr.responsibility_id = p_resp_id
29: AND asu.user_id = l_user_id

Line 26: asg_user asu

22: CURSOR l_responsibilities_csr (p_resp_id NUMBER, l_user_id IN NUMBER)
23: IS
24: SELECT 1 --R12-Multiple Responsibility
25: FROM asg_user_pub_resps aupr,
26: asg_user asu
27: WHERE aupr.user_name = asu.user_name
28: AND aupr.responsibility_id = p_resp_id
29: AND asu.user_id = l_user_id
30: AND aupr.pub_name = 'SERVICEP';

Line 96: FROM asg_user au,

92:
93: CURSOR l_user_csr (p_user_id NUMBER)
94: IS
95: SELECT au.user_id
96: FROM asg_user au,
97: asg_user_pub_resps asg_resp
98: WHERE au.user_id <> p_user_id
99: AND au.enabled = 'Y'
100: AND asg_resp.pub_name = 'SERVICEP'

Line 97: asg_user_pub_resps asg_resp

93: CURSOR l_user_csr (p_user_id NUMBER)
94: IS
95: SELECT au.user_id
96: FROM asg_user au,
97: asg_user_pub_resps asg_resp
98: WHERE au.user_id <> p_user_id
99: AND au.enabled = 'Y'
100: AND asg_resp.pub_name = 'SERVICEP'
101: AND asg_resp.user_name = au.user_name;

Line 286: FROM ASG_USER

282:
283: CURSOR c_get_group(b_user_id NUMBER)
284: IS
285: SELECT GROUP_ID,USER_ID
286: FROM ASG_USER
287: WHERE USER_ID=b_user_id
288: AND USER_ID=OWNER_ID;
289:
290: l_group_id NUMBER;

Line 681: FROM asg_user

677:
678: CURSOR l_get_resource_id_csr(p_user_id IN NUMBER)
679: IS
680: SELECT resource_id
681: FROM asg_user
682: WHERE user_id = p_user_id;
683:
684: BEGIN
685: CSM_UTIL_PKG.LOG('Entering USER_RESP_INS_INITIALIZER for user_id:' || p_user_id,

Line 991: CURSOR c_asg_user(l_user_id NUMBER)

987: l_tab_owner_id asg_download.user_list;
988: l_tab_access_id asg_download.access_list;
989: g_pub_item varchar2(30) := 'CSF_M_USER';
990:
991: CURSOR c_asg_user(l_user_id NUMBER)
992: IS
993: SELECT USER_ID,OWNER_ID,GROUP_ID
994: FROM
995: ASG_USER

Line 995: ASG_USER

991: CURSOR c_asg_user(l_user_id NUMBER)
992: IS
993: SELECT USER_ID,OWNER_ID,GROUP_ID
994: FROM
995: ASG_USER
996: WHERE USER_ID=l_user_id;
997:
998: CURSOR c_user_acc(l_user_id NUMBER)
999: IS

Line 1008: FROM ASG_USER USR,

1004:
1005: CURSOR c_group_users(l_owner_id NUMBER)
1006: IS
1007: SELECT USR.USER_ID,USR.OWNER_ID,ACC.ACCESS_ID
1008: FROM ASG_USER USR,
1009: CSM_USER_ACC ACC
1010: WHERE USR.OWNER_ID=l_owner_id
1011: AND USR.USER_ID = ACC.USER_ID;
1012:

Line 1016: OPEN c_asg_user(p_user_id);

1012:
1013: BEGIN
1014: CSM_UTIL_PKG.LOG('Entering INSERT_ACC for User_id ' || p_user_id,
1015: 'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);
1016: OPEN c_asg_user(p_user_id);
1017: FETCH c_asg_user INTO l_user_id,l_owner_id,l_group_id;
1018: CLOSE c_asg_user;
1019:
1020: OPEN c_user_acc(p_user_id);

Line 1017: FETCH c_asg_user INTO l_user_id,l_owner_id,l_group_id;

1013: BEGIN
1014: CSM_UTIL_PKG.LOG('Entering INSERT_ACC for User_id ' || p_user_id,
1015: 'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);
1016: OPEN c_asg_user(p_user_id);
1017: FETCH c_asg_user INTO l_user_id,l_owner_id,l_group_id;
1018: CLOSE c_asg_user;
1019:
1020: OPEN c_user_acc(p_user_id);
1021: FETCH c_user_acc INTO l_user_id;

Line 1018: CLOSE c_asg_user;

1014: CSM_UTIL_PKG.LOG('Entering INSERT_ACC for User_id ' || p_user_id,
1015: 'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);
1016: OPEN c_asg_user(p_user_id);
1017: FETCH c_asg_user INTO l_user_id,l_owner_id,l_group_id;
1018: CLOSE c_asg_user;
1019:
1020: OPEN c_user_acc(p_user_id);
1021: FETCH c_user_acc INTO l_user_id;
1022: IF c_user_acc%FOUND THEN