333:
334: COMMIT;
335: EXCEPTION WHEN OTHERS THEN
336: ROLLBACK;
337: RAISE FND_API.G_EXC_ERROR;
338: END POPULATE_ACCESS_RECORDS;
339:
340: PROCEDURE DELETE_ACCESS_RECORDS( P_USER_ID IN NUMBER )
341: IS
356: CLOSE c_user;
357: COMMIT;
358: EXCEPTION WHEN OTHERS THEN
359: ROLLBACK;
360: RAISE FND_API.G_EXC_ERROR;
361: END DELETE_ACCESS_RECORDS;
362:
363: PROCEDURE APPLY_CLIENT_CHANGES( P_USER_NAME IN VARCHAR2
364: , P_TRAN_ID IN NUMBER )