DBA Data[Home] [Help]

APPS.CSM_USER_EVENT_PKG dependencies on CSM_USER_ACC

Line 1059: CSM_USER_ACC

1055: CURSOR c_user_acc(l_user_id NUMBER)
1056: IS
1057: SELECT USER_ID
1058: FROM
1059: CSM_USER_ACC
1060: WHERE USER_ID=l_user_id;
1061:
1062: CURSOR c_group_users(l_owner_id NUMBER)
1063: IS

Line 1066: CSM_USER_ACC ACC

1062: CURSOR c_group_users(l_owner_id NUMBER)
1063: IS
1064: SELECT USR.USER_ID,USR.OWNER_ID,ACC.ACCESS_ID
1065: FROM ASG_USER USR,
1066: CSM_USER_ACC ACC
1067: WHERE USR.OWNER_ID=l_owner_id
1068: AND USR.USER_ID = ACC.USER_ID;
1069:
1070: BEGIN

Line 1080: DELETE FROM CSM_USER_ACC WHERE USER_ID =l_user_id;

1076:
1077: OPEN c_user_acc(p_user_id);
1078: FETCH c_user_acc INTO l_user_id;
1079: IF c_user_acc%FOUND THEN
1080: DELETE FROM CSM_USER_ACC WHERE USER_ID =l_user_id;
1081: END IF;
1082:
1083: SELECT CSM_USER_ACC_S.NEXTVAL INTO l_access_id FROM DUAL;
1084:

Line 1083: SELECT CSM_USER_ACC_S.NEXTVAL INTO l_access_id FROM DUAL;

1079: IF c_user_acc%FOUND THEN
1080: DELETE FROM CSM_USER_ACC WHERE USER_ID =l_user_id;
1081: END IF;
1082:
1083: SELECT CSM_USER_ACC_S.NEXTVAL INTO l_access_id FROM DUAL;
1084:
1085: INSERT INTO CSM_USER_ACC(ACCESS_ID,USER_ID,OWNER_ID,COUNTER,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN)
1086: VALUES (l_access_id,l_user_id,l_owner_id,1,sysdate,1,sysdate,1,1);
1087: CLOSE c_user_acc;

Line 1085: INSERT INTO CSM_USER_ACC(ACCESS_ID,USER_ID,OWNER_ID,COUNTER,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN)

1081: END IF;
1082:
1083: SELECT CSM_USER_ACC_S.NEXTVAL INTO l_access_id FROM DUAL;
1084:
1085: INSERT INTO CSM_USER_ACC(ACCESS_ID,USER_ID,OWNER_ID,COUNTER,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN)
1086: VALUES (l_access_id,l_user_id,l_owner_id,1,sysdate,1,sysdate,1,1);
1087: CLOSE c_user_acc;
1088:
1089: l_markdirty := asg_download.mark_dirty(

Line 1116: UPDATE CSM_USER_ACC

1112: FETCH c_group_users BULK COLLECT INTO l_tab_user_id,l_tab_owner_id,l_tab_access_id LIMIT 10;
1113: EXIT WHEN l_tab_access_id.COUNT = 0;
1114: FOR i in 1..l_tab_access_id.COUNT
1115: LOOP
1116: UPDATE CSM_USER_ACC
1117: SET OWNER_ID = l_tab_owner_id(i),
1118: LAST_UPDATE_DATE = SYSDATE
1119: WHERE USER_ID = l_tab_user_id(i);
1120:

Line 1165: CSM_USER_ACC

1161: CURSOR c_user_acc(l_user_id NUMBER)
1162: IS
1163: SELECT ACCESS_ID,USER_ID,OWNER_ID
1164: FROM
1165: CSM_USER_ACC
1166: WHERE USER_ID=l_user_id;
1167:
1168:
1169: BEGIN

Line 1187: DELETE FROM CSM_USER_ACC WHERE USER_ID =l_user_id;

1183: , P_TIMESTAMP => sysdate
1184: );
1185: END IF;
1186: --delete for owner,member or individual user
1187: DELETE FROM CSM_USER_ACC WHERE USER_ID =l_user_id;
1188:
1189: CSM_UTIL_PKG.LOG('User is Deleted From the Access table for User_id :' || p_user_id,
1190: 'CSM_USER_EVENT_PKG.DELETE_ACC',FND_LOG.LEVEL_PROCEDURE);
1191:

Line 1209: non-group member records in CSM_USER_ACC for the (user,owner)

1205: END DELETE_ACC;
1206:
1207: /*
1208: The following two apis are used for inserting/deleting
1209: non-group member records in CSM_USER_ACC for the (user,owner)
1210: */
1211:
1212: PROCEDURE INSERT_ACC (p_user_id IN NUMBER,p_owner_id IN NUMBER)
1213: IS

Line 1227: FROM CSM_USER_ACC

1223:
1224: CURSOR c_user_acc(b_user_id NUMBER,b_owner_id NUMBER)
1225: IS
1226: SELECT ACCESS_ID
1227: FROM CSM_USER_ACC
1228: WHERE USER_ID=b_user_id
1229: AND OWNER_ID = b_owner_id;
1230:
1231: BEGIN

Line 1240: UPDATE CSM_USER_ACC SET COUNTER=COUNTER+1 ,LAST_UPDATE_DATE=sysdate WHERE ACCESS_ID=l_access_id;

1236: FETCH c_user_acc INTO l_access_id;
1237: IF c_user_acc%FOUND THEN
1238: CSM_UTIL_PKG.LOG('Record already there in the Access table: (User_id,owner_id) : (' || p_user_id||','||p_owner_id||')',
1239: 'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);
1240: UPDATE CSM_USER_ACC SET COUNTER=COUNTER+1 ,LAST_UPDATE_DATE=sysdate WHERE ACCESS_ID=l_access_id;
1241: CLOSE c_user_acc;
1242: ELSE
1243:
1244: CLOSE c_user_acc;

Line 1246: SELECT CSM_USER_ACC_S.NEXTVAL INTO l_access_id FROM DUAL;

1242: ELSE
1243:
1244: CLOSE c_user_acc;
1245:
1246: SELECT CSM_USER_ACC_S.NEXTVAL INTO l_access_id FROM DUAL;
1247:
1248: INSERT INTO CSM_USER_ACC(ACCESS_ID,USER_ID,OWNER_ID,COUNTER,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN)
1249: VALUES (l_access_id,p_user_id,p_owner_id,1,sysdate,1,sysdate,1,1);
1250:

Line 1248: INSERT INTO CSM_USER_ACC(ACCESS_ID,USER_ID,OWNER_ID,COUNTER,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN)

1244: CLOSE c_user_acc;
1245:
1246: SELECT CSM_USER_ACC_S.NEXTVAL INTO l_access_id FROM DUAL;
1247:
1248: INSERT INTO CSM_USER_ACC(ACCESS_ID,USER_ID,OWNER_ID,COUNTER,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN)
1249: VALUES (l_access_id,p_user_id,p_owner_id,1,sysdate,1,sysdate,1,1);
1250:
1251: CSM_UTIL_PKG.LOG('Record inserted into the Access table: (User_id,owner_id) : (' || p_user_id||','||p_owner_id||') and Marking dirty',
1252: 'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);

Line 1288: FROM CSM_USER_ACC

1284:
1285: CURSOR c_user_acc(b_user_id NUMBER,b_owner_id NUMBER)
1286: IS
1287: SELECT access_id,counter
1288: FROM CSM_USER_ACC
1289: WHERE USER_ID=b_user_id
1290: AND OWNER_ID = b_owner_id;
1291:
1292: BEGIN

Line 1309: DELETE FROM CSM_USER_ACC WHERE USER_ID =p_user_id

1305: , p_dml => 'D'
1306: , P_TIMESTAMP => sysdate
1307: );
1308:
1309: DELETE FROM CSM_USER_ACC WHERE USER_ID =p_user_id
1310: AND OWNER_ID=p_owner_id;
1311: ELSE
1312: UPDATE CSM_USER_ACC SET COUNTER=COUNTER-1 ,LAST_UPDATE_DATE=sysdate WHERE USER_ID =p_user_id
1313: AND OWNER_ID=p_owner_id;

Line 1312: UPDATE CSM_USER_ACC SET COUNTER=COUNTER-1 ,LAST_UPDATE_DATE=sysdate WHERE USER_ID =p_user_id

1308:
1309: DELETE FROM CSM_USER_ACC WHERE USER_ID =p_user_id
1310: AND OWNER_ID=p_owner_id;
1311: ELSE
1312: UPDATE CSM_USER_ACC SET COUNTER=COUNTER-1 ,LAST_UPDATE_DATE=sysdate WHERE USER_ID =p_user_id
1313: AND OWNER_ID=p_owner_id;
1314: END IF;
1315: END IF;
1316: