eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.CSM_USER_EVENT_PKG dependencies on CSM_USER_ACC

Line 1002: CSM_USER_ACC

998: CURSOR c_user_acc(l_user_id NUMBER)
999: IS
1000: SELECT USER_ID
1001: FROM
1002: CSM_USER_ACC
1003: WHERE USER_ID=l_user_id;
1004:
1005: CURSOR c_group_users(l_owner_id NUMBER)
1006: IS

Line 1009: CSM_USER_ACC ACC

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:
1013: BEGIN

Line 1023: DELETE FROM CSM_USER_ACC WHERE USER_ID =l_user_id;

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
1023: DELETE FROM CSM_USER_ACC WHERE USER_ID =l_user_id;
1024: END IF;
1025:
1026: SELECT CSM_USER_ACC_S.NEXTVAL INTO l_access_id FROM DUAL;
1027:

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

1022: IF c_user_acc%FOUND THEN
1023: DELETE FROM CSM_USER_ACC WHERE USER_ID =l_user_id;
1024: END IF;
1025:
1026: SELECT CSM_USER_ACC_S.NEXTVAL INTO l_access_id FROM DUAL;
1027:
1028: 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)
1029: VALUES (l_access_id,l_user_id,l_owner_id,1,sysdate,1,sysdate,1,1);
1030: CLOSE c_user_acc;

Line 1028: 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)

1024: END IF;
1025:
1026: SELECT CSM_USER_ACC_S.NEXTVAL INTO l_access_id FROM DUAL;
1027:
1028: 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)
1029: VALUES (l_access_id,l_user_id,l_owner_id,1,sysdate,1,sysdate,1,1);
1030: CLOSE c_user_acc;
1031:
1032: l_markdirty := asg_download.mark_dirty(

Line 1059: UPDATE CSM_USER_ACC

1055: FETCH c_group_users BULK COLLECT INTO l_tab_user_id,l_tab_owner_id,l_tab_access_id LIMIT 10;
1056: EXIT WHEN l_tab_access_id.COUNT = 0;
1057: FOR i in 1..l_tab_access_id.COUNT
1058: LOOP
1059: UPDATE CSM_USER_ACC
1060: SET OWNER_ID = l_tab_owner_id(i),
1061: LAST_UPDATE_DATE = SYSDATE
1062: WHERE USER_ID = l_tab_user_id(i);
1063:

Line 1108: CSM_USER_ACC

1104: CURSOR c_user_acc(l_user_id NUMBER)
1105: IS
1106: SELECT ACCESS_ID,USER_ID,OWNER_ID
1107: FROM
1108: CSM_USER_ACC
1109: WHERE USER_ID=l_user_id;
1110:
1111:
1112: BEGIN

Line 1130: DELETE FROM CSM_USER_ACC WHERE USER_ID =l_user_id;

1126: , P_TIMESTAMP => sysdate
1127: );
1128: END IF;
1129: --delete for owner,member or individual user
1130: DELETE FROM CSM_USER_ACC WHERE USER_ID =l_user_id;
1131:
1132: CSM_UTIL_PKG.LOG('User is Deleted From the Access table for User_id :' || p_user_id,
1133: 'CSM_USER_EVENT_PKG.DELETE_ACC',FND_LOG.LEVEL_PROCEDURE);
1134:

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

1148: END DELETE_ACC;
1149:
1150: /*
1151: The following two apis are used for inserting/deleting
1152: non-group member records in CSM_USER_ACC for the (user,owner)
1153: */
1154:
1155: PROCEDURE INSERT_ACC (p_user_id IN NUMBER,p_owner_id IN NUMBER)
1156: IS

Line 1170: FROM CSM_USER_ACC

1166:
1167: CURSOR c_user_acc(b_user_id NUMBER,b_owner_id NUMBER)
1168: IS
1169: SELECT ACCESS_ID
1170: FROM CSM_USER_ACC
1171: WHERE USER_ID=b_user_id
1172: AND OWNER_ID = b_owner_id;
1173:
1174: BEGIN

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

1179: FETCH c_user_acc INTO l_access_id;
1180: IF c_user_acc%FOUND THEN
1181: CSM_UTIL_PKG.LOG('Record already there in the Access table: (User_id,owner_id) : (' || p_user_id||','||p_owner_id||')',
1182: 'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);
1183: UPDATE CSM_USER_ACC SET COUNTER=COUNTER+1 ,LAST_UPDATE_DATE=sysdate WHERE ACCESS_ID=l_access_id;
1184: CLOSE c_user_acc;
1185: ELSE
1186:
1187: CLOSE c_user_acc;

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

1185: ELSE
1186:
1187: CLOSE c_user_acc;
1188:
1189: SELECT CSM_USER_ACC_S.NEXTVAL INTO l_access_id FROM DUAL;
1190:
1191: 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)
1192: VALUES (l_access_id,p_user_id,p_owner_id,1,sysdate,1,sysdate,1,1);
1193:

Line 1191: 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)

1187: CLOSE c_user_acc;
1188:
1189: SELECT CSM_USER_ACC_S.NEXTVAL INTO l_access_id FROM DUAL;
1190:
1191: 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)
1192: VALUES (l_access_id,p_user_id,p_owner_id,1,sysdate,1,sysdate,1,1);
1193:
1194: CSM_UTIL_PKG.LOG('Record inserted into the Access table: (User_id,owner_id) : (' || p_user_id||','||p_owner_id||') and Marking dirty',
1195: 'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);

Line 1231: FROM CSM_USER_ACC

1227:
1228: CURSOR c_user_acc(b_user_id NUMBER,b_owner_id NUMBER)
1229: IS
1230: SELECT access_id,counter
1231: FROM CSM_USER_ACC
1232: WHERE USER_ID=b_user_id
1233: AND OWNER_ID = b_owner_id;
1234:
1235: BEGIN

Line 1252: DELETE FROM CSM_USER_ACC WHERE USER_ID =p_user_id

1248: , p_dml => 'D'
1249: , P_TIMESTAMP => sysdate
1250: );
1251:
1252: DELETE FROM CSM_USER_ACC WHERE USER_ID =p_user_id
1253: AND OWNER_ID=p_owner_id;
1254: ELSE
1255: UPDATE CSM_USER_ACC SET COUNTER=COUNTER-1 ,LAST_UPDATE_DATE=sysdate WHERE USER_ID =p_user_id
1256: AND OWNER_ID=p_owner_id;

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

1251:
1252: DELETE FROM CSM_USER_ACC WHERE USER_ID =p_user_id
1253: AND OWNER_ID=p_owner_id;
1254: ELSE
1255: UPDATE CSM_USER_ACC SET COUNTER=COUNTER-1 ,LAST_UPDATE_DATE=sysdate WHERE USER_ID =p_user_id
1256: AND OWNER_ID=p_owner_id;
1257: END IF;
1258: END IF;
1259: